PRABHAT SWAIN

Senior Consultant /Senior Data Engineer

PwC India•  July 2021 - Present

Engineered Low Code application for SAP HANA with Open-Source models to provide DDL/DML operations & Automated Business Rules Engine using Python & GIT. Developed & Migrated the Data Ingestion for pricing applications from MySQL-Snaplogic-HANA based pipeline to MySQL-Azure Databricks-HANA based pipeline using Python. Developed & Migrated the Data Ingestion for JIRA from Oracle-Snaplogic-SQL Server based pipeline to Oracle-Azure Databricks based pipeline using Python. Engineered Enterprise E2E Testing Application for SAP HANA migration to check the data quality using Python & GIT. Engineered Automated Code Review Platform for SAP HANA migration to reduce all the migration Code checking efforts which handled over 2000 database objects (SPs & Models) utilizing Python, GIT & NLP. Developed Retail Analytics Platform (RAP) which provides and performs initial AL/ML insights on the various aspects of the business including but not limited to Inventory management, Customer Retention, Feedback Analysis, Cost Optimization Using Python, AI/ML models. Developed Ingestion pipelines for different product areas in Digital Media Assets which reduced time, efforts & costs using Snaplogic, SAP HANA, & MSBI (SQL Server & SSIS). Implemented & Developed Enterprise level E2E testing Automation pipeline using Power BI & MSBI (SQL Server & SSIS).

Senior Software Engineer

Mindtree Ltd.•  July 2016 - July 2021

Developed various CRM, Finance, Sales & Global BI based Summarized reports for the senior leadership using Power BI & SQL Server. Developed Multi-Region Automated Data Ingestion platform which reduced time, efforts & costs using Python & MSBI (SQL Server & SSIS). Proposed & Performed Various Software Migrations Such On-prem (2008) to Azure Cloud (2016) which reduced costs & efforts in deliverables. Developed & Revamped Automated Report Delivery across Regions using Power BI & MSBI (SSIS & SSRS). Different New Source Integrations & Ingestion pipelines such as DutyFree, Italy in Global BI for FMCG using MSBI (SQL Server, SSIS, SSAS, SSRS & Excel).