Data Analytics Leader and Practitioner with 14+ years of experience building data solutions and leading analytics initiatives to drive business decisions and strategy.
Highly Experienced in Data Architecture, data modeling, Business Intelligence and Analytics.
Extensive data Engineering experience building Data Warehouse, Data Mart and Analytical applications.
Proven expertise in developing data pipelines from structured to unstructured sources, with strong skills in data architecture, modeling, and advanced analytics.
Experienced in Data Architecture & Data Engineering activities to design and build analytical applications leveraging distributed and cloud-native technologies.
Strong Hands-on experience with complex Transformation based data pipelines designed & developed using SQL, Python Structured data API / Library and Apache Spark.
Experience in BI Analytics and building Analytics pipelines – Tableau, Business Objects, Pentaho and Google Data Studio.
In-depth understanding of distributed computing and spark Architecture including Spark Core, SparkSQL, Dataframes etc.
Demonstrated ability to collaborate with cross-functional teams to develop innovative analytics solutions that achieve business goals.
Experienced in advanced analytics like Segmentation, Cohort analysis, tabPy integration and Hyper API
Successful track record in identifying and implementing process improvements and automation in data collection, analysis, and reporting.
Championed data-driven culture, transforming organizations from descriptive to prescriptive analytics approaches.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Lead Data Engineer
Alumni Services
04.2023 - Current
Led data domain/portfolio services and own end-to-end data projects—from understanding business needs to designing, implementing, and delivering scalable, automated data solutions that drive impact
Consulted and provided strategic solutions for driving organizational value, working directly under the CTO to align data initiatives with business objectives
Project: Data Platform for Leading Shipping Company
Lead the design and development of data Platform for Leading Shipping Company
Designed and developed scalable data platform infrastructure using Azure Synapse Analytics, PySpark, Azure Data Factory, and Terraform, reducing data processing costs by 35%
Developed and maintained a robust data pipeline architecture, resulting in a 20% increase in data processing efficiency and supporting timely insights for decision-making
Identified and defined key data leadership metrics, establishing governance frameworks that improved data quality by 40%
Led targeted initiatives and delivered workshops to enhance data literacy and governance for over 50 business stakeholders, resulting in increased adoption of data-driven decision-making
Project: Data Migration Platform for Leading shipping client
Created cloud data migration/integration platform on Azure using ADF, Databricks, and Power Apps to successfully migrate data from 20+ finance systems to enterprise ERP within strict 6-month timeline
Defined and implemented comprehensive Data Quality Framework with automated validation rules, reducing data errors by 75% and ensuring regulatory compliance
Developed Power BI dashboards for quality monitoring and migration progress tracking, providing stakeholders with real-time visibility into project status and data integrity metrics
Senior Data Engineer
HSBC
10.2022 - 03.2023
Define canonical data models for Global Banking and functions
Collaborate with data project teams and engineering teams to design data models
Design data models for Regulatory reports for Global Banking and functions
Perform EDA, reverse engineering of physical data models from databases and ETL/ELT scripts
Standardize domain data models with Industry standard models (BIAN, FIBO)
Senior Data Engineer
Equinix
05.2020 - 10.2022
Design and develop ETL/ELT engineering patterns using Python on Spark and SQL
Developed mapping and framework using Python, SQL, Informatica, and Exasol
Refactored and engineer data pipelines from on-premises to Google cloud
Developed SPARK data pipelines for ingestion from Dataproc (GCP Managed Hadoop) to BigQuery for Analytics and Data Science applications
Developed event-based pipelines to data streaming using Kafka and Pub/sub to Dataproc (Hadoop)
Troubleshooting maintenance, and optimization or enhancement of existing processes
Collaborate with stakeholders including the BSA, Report developers, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
Automated manual process, optimizing data pipelines and processes for greater scalability
Migrated/Re-created existing dashboards/reports in OBI, SFDC and SiSense to Tableau
Solution Engineer
Hitachi Vantara
05.2019 - 04.2020
Engineered solutions and consulting/advisory for Pentaho suite of products, to build Big Data applications and Analytics
Assisted and worked closely with Pre-Sales teams to understand customer requirements and engineer solutions
Built Proof-of-value for customer Business case to Demonstrate Pentaho platform capabilities and benefits
Designed Proof-of-value for train crowd analytics from Wi-Fi sniffer data (pcap) pipeline in PDI (Pentaho Data Integration)
Implemented self-service data catalog platform, for organizations for easy adoption of Big Data
Lead a team to create the Insurance recommendation demo powered by Pentaho platform and demonstrated this at Singapore FinTech event 2019
Onboard and Migrate dashboards/reports from other reporting tools (Tableau and Power BI) to Pentaho
Data Architect
Tata Consultancy Services (TCS)
02.2017 - 04.2019
Company Overview: Client: Singapore Airlines
Create and maintain a Datawarehouse and Business Intelligence applications roadmap for the customer
Solution architecture and data models based on business requirements
Architect and oversee the migration or upgrade of data/product from existing system to new versions/products
Review and engage in data modeling for new Data Mart/Datawarehouse implementations and database design
Evaluating products/solutions for various Business reporting/analytical needs and demonstrating PoC (Proof of Concepts)
Led proof-of-concepts and pilot projects for BO to Tableau, Data warehouse migration from DB2 to Redshift
Architected and implemented GDPR and PDPA compliance policies for Datawarehouse and BI applications
Create tableau dashboards from redshift database and Datawarehouse (on-premises)
Client: Singapore Airlines
Senior Data Engineer & Business Analyst
Tata Consultancy Services (TCS)
01.2011 - 01.2017
Company Overview: Client: Singapore Airlines
Participate in client meetings to understand business needs, outlining problems, opportunities, and solutions for a business
Engage with Customer for Requirements engineering and improvement opportunities
Manage customer relationships and expectations by translating and simplifying business requirements
Translating business requirements into conceptual, logical and physical data models
Maintain and comply with SOP (Standard Operating Procedure) for all BI applications
Led and Upgraded SAP Business Objects from XI to SAP BI 4.2
Developed proof-of-concepts for SAP BW cubes and SAP Business Objects integration
Public Relations Head at Students' Alumni Cell, Office of Alumni Affairs & Branding IIT kharagpurPublic Relations Head at Students' Alumni Cell, Office of Alumni Affairs & Branding IIT kharagpur