Pawan Shivani

Customer: KPMG Deal Advisory (Internal Technology Enablement)

• Migrated a complete data engineering and analytics solution from Synapse, Databricks, and Power BI Services to Microsoft Fabric.
• Built data pipelines using Databricks and Synapse to ingest data from diverse internal/external sources, supporting Deal Advisory teams in M&A and business strategy.
• Implemented Generative AI use cases using Azure OpenAI, including company name matching via vector search and auto-generation of narrative-driven presentations.
• Developed lightweight Python apps leveraging prompt engineering to solve targeted business problems.
• Extracted insights from unstructured documents using GPT models and LlamaIndex for content harvesting projects.
• Delivered BI solutions using Databricks, Synapse Analytics, and Power BI to enhance client deliverables.

Customer: Oil & Gas Company of USA | Jan 2023 – June 2023

• Leading carbon emissions tracking module using PySpark, Azure Databricks, and Azure Data Lake.
• Built end-to-end pipelines to process and load data into Azure SQL and Delta Tables.

Customer: Mining Company of USA | Jan 2022 – Jan 2023

• Architected medallion architecture using Azure Databricks, ADF, and Azure SQL.
• Implemented a metadata-driven framework for dynamic integration of new sources.
• Managed CI/CD pipelines via Azure DevOps for automated deployment.

Customer: Global FMCG Client | Jan 2020 – Jan 2022

• Led migration of on-premise data systems to Azure Cloud, designing a modern data warehouse.
• Used Azure Data Factory, Azure Synapse, Databricks, and Blob Storage for ingestion and transformation.
• Directed architecture and delivery of highly available, scalable cloud-based solutions.

Customer: Public Sector Client of USA | Aug 2016 – Jan 2020

• Spearheaded data conversion and reporting architecture using SSIS, SQL Server, and Pentaho.
• Built enterprise data warehouse and OLAP cubes using Pentaho Data Integration and Mondrian.
• Automated workflows using SQL Server Agent for seamless data operations.

Customer: Global Technology Firm | Dec 2015 – Jul 2016

• Led development of ETL workflows and reporting using SSIS and SQL Server.

Customer: Health Insurance Company of USA

• Developed and optimized ETL pipelines and reporting solutions using Microsoft SQL Server, SSIS, and Power BI.
• Collaborated with business stakeholders to design and deliver enterprise data warehouse components.
• Improved performance and scalability of legacy data systems to meet evolving business needs.