- Leveraging Azure Databricks and Azure HDInsights to build scalable data harmonization layer on data lake

- Migrated Data Warehouse(AWS Redshift) and legacy data pipelines(AWS Glue) to Databricks Intelligence Platform- Migrated 100+ legacy business process from SAS to Pyspark(Azure Databricks & Azure HDInsights) which resulted in reduction on the license cost and improved operational efficiency- Designed scalable, reusable and metadata driven data quality framework using pyspark- Collaborated with Data Science team to build open-source analytics platform (Posit Workbench/Connect) serving over 300 users for machine learning and forecasting capabilities- Collaborated with Data Science team to deploy and manage real-time forecasting application and forecasting data pipelines

- Designed and developed data transformation and data integration pipeline to predict the online customers who are at high risk of churning. Collaborated with the data science team for exploratory data analysis, model building, testing and deployment using R and Teradata.- Designed and developed Global Data Warehouse(GDW) that harmonized and aligned the core business data to utilize a single, globally shared Enterprise Reporting solution.- Integrated various Master Data Management(Customer Master, Product Master, User Master) and ERP(Siebel CRM, Peoplesoft, Oracle E-Business Suite, and customer applications) data to GDW using 100+ batch process(ETL) using DataStage, Informatica, and Teradata.- Enabled management reporting, customer analytics, sales analytics, and finance analytics (Account Receivable) dashboards for key insights using Oracle Business Intelligence

- Designed system architecture and deployment topology for new analytics environment using Oracle Business Intelligence, Oracle BI Publisher and Hyperion Interactive Reporting.- Installed and configured a cluster of Oracle BI/Hyperion Interactive Reporting servers to deliver high performance and automatic failover capabilities.- Performed fit and gap analysis and developed data transformation and integration pipeline to integrate customer, sales and marketing data of an acquired entity to an existing sales data warehouse and enabled dashboards for key insights.

- Designed and developed data transformation and integration pipeline to enable marketing data in Customer Master(MDM) and Siebel CRM application- Upgraded 1000 ETL batch jobs and 3 real-time jobs from DataStage 8.0 to 8.5 environment, which improved batch performance by 30% and resulted in high availability of ETL environment across multiple data transformation programs.

- Designed and developed data transformation pipeline to extract customer and sales data from 10+ legacy applications and integrate with Customer Master(MDM) to provide a single version of the truth across various ERP applications, which resulted in 35% redundancy reduction.- Designed and developed reusable data profiling pipeline to assess and monitor the quality of data resides in 10+ legacy applications. This exercise helped the customer to improve data quality by 15% across the enterprise.

Completed Infosys foundation training program and specialized training in Oracle Developer Suite (Forms and Reports), data integration (ETL), data warehousing and business intelligence.