Krunal Kharat

Led a team of four to enhance exchange rate functionality, transitioning from static to dynamic rates. Ingested data from Business Central, performed data profiling to assess quality and structure, and designed an optimized data model for efficient storage and querying. Designed and implemented an incremental data load process for the Business Central source. Managed the final reconciliation of the reporting layer.

Led a workstream to build revenue and cost cube for a major property security client. Performed data integrity and data profiling of invoice level information. Built a data platform for a major UK traffic management client, fetching financial data via API from NetSuite. Implemented ETL pipelines and designed financial report architecture for board-level dashboards. Optimized pipeline and store procedures, reducing runtime from 2 hours to 30 minutes. Developed automated data pipelines and dashboards using PySpark and Power BI, reducing sign-off time by 70%.

Worked as Data Engineer for a major US biopharmaceutical client. Designed and developed backend tables in the aggregate layer for dashboards (cohort, adverse events). Developed ETL pipelines using PySpark and AWS services (S3, EMR, Redshift) to automate end-to-end data processing. Created ETL source-to-target mapping documents.