Feb 2018 – Jul 2022 · 4 yrs 5 mos · Pune, Maharashtra, India · Hybrid

• Enterprise Data Warehouse & ODI Framework: Directed end-to-end development of a new Enterprise Data Warehouse for Vodafone New Zealand, including re-designing data models and building an ODI 12c-based framework to ingest hundreds of source files. Ensured a robust ETL process and improved data availability for analytics and reporting across the organization.
• Customer Data Hub (Real-Time Analytics): Architected a Customer Data Hub as part of the Solstice program using K2View Fabric (ETL) and Cassandra on AWS, ingesting large, complex nested JSON data from Kafka streams in real-time to provide a unified 360° view of customers. Implemented data models and integration logic that enabled “single source of truth” customer analytics across multiple systems.
• Data Modeling, Stakeholder Collaboration & Optimization: Collaborated closely with business stakeholders and cross-functional teams to gather requirements and translate them into effective data models and integration designs. Oversaw data quality and performance improvements by tuning data pipelines and queries, ensuring the delivered solutions met enterprise standards and improved decision-making capabilities.

Apr 2013 – Feb 2018 · 4 yrs 10 mos · Pune · Hybrid

• High-Volume Data Integration Projects: Led multiple large-scale data warehousing projects for telecom clients (e.g. British Telecom, Vodafone Ghana), designing frameworks to ingest massive data volumes (millions of Call Detail Records within hours) using Oracle Data Integrator on Oracle Exadata. Ensured data pipeline reliability and scalability to handle 55+ TB databases and high-throughput requirements.
• End-to-End BI Solution Delivery: Managed a team of engineers and provided technical leadership in delivering end-to-end BI solutions – from data modeling and ETL development to enterprise reporting with OBIEE. Created and owned data architecture and design documentation, aligning technical implementations with business requirements and ensuring high-quality, on-time deliverables.
• Performance Tuning & Architecture Optimization: Optimized complex SQL queries, PL/SQL procedures, and data storage (partitioning, indexing, Exadata compression techniques) to improve query performance and system efficiency. Guided capacity planning and resolved critical issues by proactive monitoring (RAG status management), thereby enhancing the platform’s performance and stability.

Apr 2011 – Mar 2013 · 1 yr 11 mos · Pune, Maharashtra, India · Hybrid

• ETL Development for Analytics Products: Led data integration and database development for enterprise IT performance and analytics products – IBM Tivoli Netcool Performance Manager (telecom network analytics) and BMC BladeLogic Decision Support for Server Automation. Installed and configured these solutions and built ETL workflows (using Oracle SQL Loader and Oracle Data Integrator) to aggregate and load large volumes of data from multiple sources into centralized data warehouses.
• Database Optimization & Feature Enhancement: Improved database performance by tuning SQL and PL/SQL (utilizing tools like Oracle TKPROF) and implementing Oracle partitioning and collection methodologies for large datasets. Designed and developed new product features and database objects (tables, indexes, partitions, stored procedures, triggers) based on business requirements, enhancing reporting capabilities and overall system efficiency.

Jan 2007 – Apr 2011 · 4 yrs 3 mos · Pune, Maharashtra, India · Hybrid

• Product Customization & Full SDLC Development: Developed and customized banking payment and liquidity management products (Transact CashIn, Transact CashWeb) for global clients such as Kasikorn Bank, Barclays, HSBC, and BNP Paribas. Implemented new features, performed impact analysis for custom changes, and resolved defects across all phases of the SDLC, ensuring successful product deployments and client satisfaction.
• Data Integration & Reporting Solutions: Built and maintained data interface modules and reporting tools to enable seamless data exchange between systems. This included developing file upload/download processes, writing PL/SQL validation routines to ensure data quality before integration into core systems, and creating Oracle Reports (6i/10g) for scheduled reporting.