Mansha Khandelwal
Technical Lead · Database Engineering & Data Analytics · 13 Years Experience
Hire this person
Send a job offer directly to this candidate
About
Database Engineer and Technical Lead with 13 years of experience designing, optimizing, and migrating mission-critical database systems across telecom, banking, and trading domains. Deep expertise in Oracle PL/SQL and PostgreSQL with handson experience building production ETL pipelines using Apache Airflow and Apache NiFi. Experienced with Azure cloud data platforms including Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), and Azure Databricks.
Proven track record of leading large-scale Oracle-to-PostgreSQL cloud migrations and delivering executive BI dashboards via Power BI and SAP BusinessObjects.
Experience
Technical Lead – PostgreSQL & Data Engineering - Netcracker Technology
(2022-05)
Telecom Rating & Billing R&D product — database development, ETL pipelines & cloud migration.
- Leading Oracle-to-PostgreSQL migration — rewriting PL/SQL functions and complex queries to PostgreSQL-native equivalents, ensuring cloud-readiness and performance parity.
- Designed and built end-to-end ETL pipelines using Apache NiFi and Python for automated, fault-tolerant data ingestion and transformation between on-premises systems and Azure cloud environments.
- Developing Azure-based data pipelines with Azure Data Factory (ADF) and Azure Data Lake Storage (ADLS Gen2) to support cloud-first data architecture.
- Building Python-based data transformation scripts using pandas and PySpark for data cleansing, aggregation, and business logic implementation.
- Performed systematic performance tuning using EXPLAIN ANALYZE, index optimization, and connection pooling - reducing query latency in cloud-hosted PostgreSQL environments.
- Built Apache Superset dashboards for operational monitoring; mentored developers and established team coding standards and review workflows.
- Contributed to R&D initiatives on scalable database architecture for high-throughput telecom billing and rating systems.
Senior Consultant – Data Engineering & Oracle - Capgemini
(2019-06 - 2022-05)
Finance & Compliance platform migration for a leading banking client.
- Contributed to Oracle Exadata → One Finance Platform migration: schema redesign, SQL refactoring, data validation, and large-dataset performance tuning.
- Designed and built production-grade ETL pipelines using Apache Airflow — orchestrated daily financial data loads from 5+ core banking systems (Finacle 11, IMEX, FPRO, PSGL, MUREX), ensuring SLA-compliant and error-free processing.
- Developed complex data integration workflows using Python: built ingestion queries, transformation logic, and data mapping rules to unify heterogeneous banking data sources into a single platform.
- Built Oracle PL/SQL-based ETL pipelines for financial sub-ledger generation - replaced manual legacy processes with automated, scheduled, auditable workflows using Python and Airflow orchestration.
- Developed PL/SQL functions, stored procedures, and REST APIs to expose financial data to reporting layers and downstream consumers.
- Applied advanced optimization techniques — explain plan analysis, indexing, partitioning, schema redesign — improving query performance on high-volume financial datasets.
IT Analyst – BI & Database Development - Tata Consultancy Services (TCS)
(2013-10 - 2019-06)
Database developer and BI specialist across multiple banking client engagements.
- Designed SAP BusinessObjects Web Intelligence reports and dashboards for finance and operations stakeholders at major banking clients.
- Built and maintained SAP BO Universes(UDT/IDT) — contexts, joins, hierarchies, LOVs, and role-based object-level security.
- Created Oracle and SQL Server stored procedures, triggers, and views; managed BO platform administration including scheduling, access controls, and performance troubleshooting.
- Optimized SQL queries and universe objects to improve report performance; delivered ad-hoc and scheduled BI reports for senior finance stakeholders.
- Documented report logic, universe design standards, and BI best practicesfor team knowledge transfer.
Freelance Power BI Developer - FleetResponse (US Client)
- Built P&L, Job Leads, and JMR Power BI dashboards across US fleet management subsidiaries with DAX measures, data models, and automated refresh.
- Developed Power Query transformations to consolidate multi-source sales and financial data into unified reporting models.
- Executed SAP BO content migration across Dev → Test → Prod environments.
Education
B.E. - Information Technology - Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV) (2013)

