Jun 2025 – Dec 2025 · 6 mos · Vancouver, British Columbia, Canada · Hybrid

• Led BI Team in Designing and maintaining scalable ETL architectures & data models using Azure Data Factories.
• Managed large and complex datasets to meet diverse business requirements.
• Created databases, tables, stored procedures, and functions to support ETL workflows.
• Built an ADF pipeline template to dynamically extract data from Oracle systems (5G, 5C, JDE, OTM) using ADF
• Watermark for incremental loads and Change Data Capture.
• Developed a similar dynamic ETL framework for migrating data from on-prem SQL to Azure SQL.
• Optimized existing ADF pipelines and implemented transformations using Mapping Data Flows and
• parameterized datasets.
• Developed ETL pipelines and data flows to deliver insights into key business metrics.
• Created semantic models and data flows used as sources for Power BI dashboards.
• Collaborated with Executive, Product, Data, and Design teams to support data load and reporting needs.

Apr 2025 – Jun 2025 · 2 mos · Vancouver, British Columbia, Canada · Hybrid

• Worked with business stakeholders to gather business requirements for ETL development & PowerBI reports.
• Implemented ETL using Azure Data factory to transform & load data from CRM Metaverse to Azure SQL.
• Assisted in creating & maintaining data storage solutions, including Azure SQL Database, Azure Data Lake, Azure Blob Storage
• Redesign and rebuild existing SSRS, Excel, and Power BI reports using Microsoft Fabric and Power BI.
• Design & implemented ETL data pipelines for data ingestion, processing, and transformation on Azure cloud.
• Develop new reports and dashboards to meet business requirements, ensuring they are optimized for performance, usability, and scalability.
• Support the team in operational tasks, including monitoring & troubleshooting pipelines & PowerBI reports.
• Assist in maintaining and updating Power BI workspaces, roles, and access permissions.
• Collaborate with the data team to implement and enforce data governance policies.
• Perform data quality checks, build data quality dashboards and ensure data integrity across systems.
• Document data processes, report logic, and data lineage.
• Implement data validation and cleansing procedures to ensure the quality and integrity of the data.
• Monitor and resolve data pipeline problems to ensure consistency and availability of the data.

Apr 2024 – Apr 2025 · 1 yr · Vancouver, British Columbia, Canada · Hybrid

• Worked with Analytics Solutions Team responsible for design, development & support of BI Applications.
• Worked with cross-functional teams & business stakeholders to identify business objectives and scopes.
• Collaborate with stakeholders to gather requirements, documents and analyse it for development purpose.
• Convert business requirements into technical, functional and non-functional specifications.
• Implemented data collection process by implementing ETL to create PowerBI tabular semantic models.
• Worked on data warehouse migration from on-prem multi-dimensional (SSAS) model to PowerBI models.
• Worked on migration of SSRS paginated and non-paginated report to PowerBI using report builder.
• Worked on Optimizing complex SQL queries, functions & stored Procedure to enhance the performance.
• Provide technical support & monitoring to the application already running in production.
• Partnered with other technical teams to design and implement solutions.
• Worked on Azure ETL components- Azure Data Factory, Azure Data Lake, Pipelines, Notebooks to get the details from API’s and load it into SQL databases and tables for Vehicle Health Monitoring project.
• Created and implemented CI/CD process & pipelines to deploy the models and reports across environments.
• Planned and strategies PI planning, Collobrated with stakeholders to create business requirement document.
• Strong exposure on Agile scrum ceremonies, like sprint planning, backlog grooming, retrospectives.
• Worked on production support issues using ITSM incident management and adhering to SLA processes.

Sep 2023 – Apr 2024 · 7 mos · Vancouver, British Columbia, Canada · Hybrid

• Worked in Investment & Business Analysis Team responsible for Manages BI Applications life cycle.
• Ensure data integrity, accuracy, and consistency across systems.
• Coordinate and conducts User Acceptance Testing.
• Collaborated with stakeholders on requirements gathering, Planning, executions & monitoring.
• Proposed, Design & implemented solutions on Azure DevOps Cloud platform.
• Reviewed and negotiates priorities with Product Management
• Performed demonstrations of sprint reviews.
• Proposed, Design & implement complex ETL’s & DML, DDL operations using SQL Agent & Airflow.
• Proposed, Design & implement data warehouse and data modeling to create efficient databases using SQL.
• Designed PowerBI reports to aid clients in analyzing business processes and facilitating key decision-making.
• followed ITIL process to handle support activities like change requests approvals, eCR.
• Followed ITIL Guidelines in terms of Incident SLA, prioritizations, criticatility & escalations.
• Followed SDLC methods for project completion and Agile/Scrum for project progress phases.

Jan 2021 – Sep 2023 · 2 yrs 8 mos · Gurugram, Haryana, India

• Lead & worked with Business Intelligence team, on manages project solutions as per requirements.
• Worked with American clients like Encore Capital Group, Bank of America, Transamerica Bermuda (TLB).
• Presented data visualizations that effectively communicate key insights and trends to stakeholders.
• Worked closely with stakeholders to understand business needs and define key performance indicators (KPIs).
• Lead data-focused workshops, meetings, and presentations to drive alignment across teams.
• Implemented end to end solutions using Data Warehousing, Data Modeling to create efficient solutions.
• Designed SSIS packages to perform ETL/ELT operations & deployed it via Azure DevOps.
• Extract, analyze, and interpret complex datasets to identify trends and deliver actionable insights.
• Designed & enhanced SSAS cubes to implement real time data visualization & dashboards using Power BI.
• Implemented OLTP & OLAP databases to segregate transactional and analytical data components.
• Documented database designs, configurations, and procedures for future reference.
• Strong exposure of handing escalations with stakeholders, business POC and vendors on resolutions.
• Managed day-to-day operations, ensuring team adhered to Development model and SLA commitments.

Sep 2019 – Dec 2020 · 1 yr 3 mos · Gurugram, Haryana, India

Nov 2018 – Sep 2019 · 10 mos · Gurgaon, Haryana, India · On-site

• Lead & managed Team responsible for development & Support of BI & Database Solutions.
• Interacted with business stakeholders on requirements, planning, execution and support plan.
• Monitored database performance and tuned queries for optimal efficiency using Apex SQL, DPA.
• Followed ITIL Process on support activities like incidents, service request, change requests, eCR etc.
• Implemented ETL (Extract, Transform & Load)/ELT (Extract, Load & Transforms) using SSIS & SQL Server.
• Designed and deployed reports using SSRS over report servers.
• Worked on SSAS cube enhancements, flush & rebuild, incremental data load, table design & load.
• Performed root cause analysis on escalations & critical issues.
• Generated queue health reports and discussed with the management to track issue trend/resolution regularly.
• Performed code debugging using Visual Studio data tool, SQL Server, Tabular editor to find the root cause.
• Interfaced with internal Teams, support groups & vendors, stakeholders to drive the project till completion.

Dec 2017 – Oct 2018 · 10 mos

• Worked as a shift lead to manage BI team in a Shift.
• Designed & implemented SSIS & SQL development Solutions as per Jira tasks assigned by business analyst.
• Mentored & supported team on production & development activities.
• Designed & implemented solutions using Azure Data Factory, Data Lake, Data Warehouse, Azure SQL.
• Worked on ServiceNow incidents & problem tickets to fix production bugs within SLA's.
• Designed and implemented multiple PowerBI dashboards as per business requirements.
• Worked on Visual Studio Data Tool for package debugging to identify root cause for SSIS-ETL job failures & fixes.
• Hosted bridge client calls to discuss the implementation, trends & templates to increase the process productivity.
• Supported applications on Go-live and provided BI support.
• Created the knowledge transfer & Standard Operating Procedures (SOP) documents for the team.

May 2015 – Nov 2017 · 2 yrs 6 mos

Feb 2013 – May 2015 · 2 yrs 3 mos