Open to opportunities

Ankita Pandey

@ankita_dubey

Message

Senior Data Analytics and BI professional specializing in ETL, Database management, data warehousing, and dashboarding.

India

Message

What I'm looking for

I seek a technical leadership role in data engineering or BI where I can lead ETL/data warehouse initiatives, enable self-service analytics, mentor teams, and work in an agile, impact-driven environment.

I am a Senior Data Analytics & BI professional with 11+ years delivering enterprise-scale data warehousing, ETL, reporting, and analytics solutions across BFSI and large enterprises. I have led migrations, production support, and performance tuning while serving as a Module Lead and SME.

My technical expertise includes designing and developing SSIS ETL packages, SSRS reports, Power BI and Tableau dashboards, and working with Oracle and MS SQL Server; I have supported Python-based ML workflows and enhancements on Elastic DB and Kibana. I have driven end-to-end data warehouse lifecycles, CI/CD for ETL/reporting, and served as the SPOC for reporting migrations to enable self-service analytics.

I mentor and coach teams, and I bring a strong track record of zero-critical-downtime migrations, measurable business impact through rapid SSIS delivery, and multiple internal awards for innovation and delivery excellence.

Experience

Work history, roles, and key accomplishments

Senior Software Engineer

BNP Paribas ISPL

Feb 2016 - Mar 2022 (6 years 1 month)

Led design, development and support of enterprise BI solutions including 150+ SSIS ETL packages and 50+ SSRS reports; drove migrations, performance tuning and production support with zero critical downtime and enabled Power BI self-service analytics.

SSIS Power BI SQL Oracle Kibana Python Data Warehousing

MSBI Developer

Accenture

Mar 2015 - Nov 2015 (8 months)

Developed and enhanced SSRS reports and SSIS ETL for global HR analytics, created Tableau dashboards and designed SSAS Tabular/BISM models to support analytical reporting.

SSIS Tableau SSAS SQL Data Modeling ETL Reporting Performance Tuning

ETL Developer

Accenture

Sep 2013 - Jan 2015 (1 year 4 months)

Built and optimized SSIS ETL packages and MS SQL stored procedures for large-scale telecom data, performed end-to-end ETL testing and improved performance for AT&T client reporting.

SSIS T SQL MS SQL Server ETL Performance Optimization Data Warehousing

Developer

Accenture

Nov 2011 - Sep 2013 (1 year 10 months)

Served as SME for ACH reconciliation and delivered technical enhancements across SSRS, C#, Oracle SQL and MS SQL Server while supporting enterprise tools and production releases for Duke Energy.

C++Oracle MS SQL Server ACH Production Support