Personal details

Amardeep W. - Remote data analyst

Amardeep W.

Senior Software Engineer
Based in: 🇺🇸 United States
Timezone: Pacific Time (US & Canada) (UTC-7)
Available to work these hours in your timezone: 1 AM - 5 AM
Time displayed in your browser timezone: Africa/Abidjan (+00:00)

About

· IT professional having 9.8+ years of full-time hands-on experience in Business Intelligence Technologies with major focus on BI Development using MicroStrategy.

· Worked on development and migration projects in Retail, Banking, Logistics and Telecom domains with an excellent track record of delivering complex functional projects.

· Expertise in MicroStrategy development, creating and integrating Schema objects and Application objects.

· Involved in business requirement gathering and providing technical specifications on the same.

· Proficient in Microsoft Azure Technology and created CI/CD pipelines using ADF, data bricks and ADLS

· Master in BI development using Power BI and DAX and created many user reports using it.

· Worked as full stack developer for a given project handling both back-end data and front-end reporting.

· Proficient in delivering results among ambiguities and working cohesively with all stakeholders.

· Working as acting lead in onshore location (USA) for managing a team based out of offshore location.

· Executed successful development and migration project at customer onsite location in Canada.

Work Experience

Senior Software Engineer
Nisum Technologies Inc | Jul 2024 - Present
SQL
ADF
MicroStrategy
Power BI
Snowflake
CI/CD
  • Involved in ETL and Reporting solution discussions.
  • Gathered all the new required fields information and created the mapping document
  • Performed the Unit Testing, Handled QA concerns and reviews the report with business as part of UAT.
  • Deployed the ETL and Reporting changes to production env.
  • Monitored the job and report in production for warranty support.
  • Attaining Scrum calls on daily basis to resolve team’s technical issues, planning deployment, sprint planning, peer review.
Principal Software Engineer
Nisum Consulting Pvt. Ltd | Jan 2020 - Jun 2024
SQL
Oracle
Reporting
Teradata
Data Visualization
Tableau
Power Query
ADF
MicroStrategy
DAX
Power BI
Snowflake
Databricks
  • Data Engineering, Data Management & Analysis
  • Ability to Manage Multiple Projects Simultaneously and Work Under Pressure
  • Gathering and Understanding Key Business Requirements
  • BI Development

Projects

Business to Business Reporting
2024
SQL
ADF
MicroStrategy
Snowflake
CI/CD
Role – Full Stack Developer (BI) Desc – Project to enhance existing MicroStrategy report to add new attributes from the salesforce interface. Key Accomplishments – • Involved in ETL and Reporting solution discussions. • Gathered all the new required fields information and created the mapping document • Updated the Azure ETL pipeline code to bring the new columns from salesforce to our snowflake database • Altered the MicroStrategy cube to incorporate this new information along with the existing data. • Modified the MicroStrategy report and added the new fields in the report in asked order. • Performed the Unit Testing, Handled QA concerns and reviews the report with business as part of UAT. • Deployed the ETL and Reporting changes to production env. • Monitored the job and report in production for warranty support.
Teradata Migration
2023
SQL
Teradata
MicroStrategy
Snowflake
Role – Lead MicroStrategy Developer Desc - Migration project from Teradata to Snowflake database for MicroStrategy reporting. Key Accomplishments - • Involved in documentation of technical specifications of the project. • Worked with Admin to establish connectivity to Snowflake database • Involved with Business to priorities the reports and worked • Created different schema objects and public objects based on report requirements. • Involved in creating MSTR objects like Metrics (Conditional, Transformational, Dimensional and Compound), Advance Filters, Prompts. • Created a system Manager flow to check the completion of table data load and then trigger the MSTR cube refresh. • Attaining Scrum calls on daily basis to resolve team’s technical issues, planning deployment, sprint planning, peer review.

Education

GH Raisoni Institute of Management and Research
Master's degree・Business Analytics
Oct 2021 - Jun 2023
Yeshwantrao Chavan College of Engineering
Bachelor's degree・Electronics and Telecommunications
Oct 2012 - Jun 2015
By using Arc, you agree to our Cookie Policy.
By using Arc, you agree to our Cookie Policy.