Leading end-to-end migration of purchasing analytics from SAP to Databricks and Power BI as domain owner, partnering with stakeholders to gather requirements, mapping data using SQL across legacy and new source systems, designing the semantic model, and building dashboards that consolidate fragmented reporting
Managed data validation and reporting enhancements for Power BI project management dashboards, improving accuracy of labor cost, timeline, and purchase order tracking
Replaced manual SOX compliance data validation with automated Python scripts that reconcile legacy SAP data against Databricks, improving audit readiness and reducing hours of manual reconciliation per audit cycle
Developing a data quality monitoring dashboard with automated validation rules to proactively flag accuracy and completeness issues across reporting projects, reducing reliance on ad-hoc spot checks
Senior Data Analyst
Ginkgo Bioworks
03.2023 - 08.2024
Analyzed data to solve problems that span finance, business strategy and operations to support data-driven decision-making
Delivered end to end analysis for Weekly Business Reviews that focus on the program and platform execution to achieve company wide revenue OKRs
Developed complex SQL queries and views in Snowflake to retrieve data from multiple sources to track and improve turnaround times for company’s services across multiple business units
Collaborated closely with business partners to define and track performance metrics, develop ad hoc data analysis, reports and interactive Tableau dashboards
Data Analyst
EMR Management Services LLC
02.2020 - 03.2023
Developed forecast models using machine learning algorithms in Python to predict buy/sell trends of various metals considering market trend, operational and global factors
Analyzed metal demands to improve inventory performance by increasing sales and reducing transport cost using Python.
Developed value based customer segmentation/clustering to identify and increase focus on profitable customers
Applied predictive analysis for company-wide trends and provided data visualization using Tableau for higher management
Data Analyst
National Healthcare Solution Inc.
10.2019 - 02.2020
Designed and implemented data transformation to schema using SQL queries, DB structures and stored procedures
Performed data analysis and validation for reporting, identifying outliers and exceptions within data extractions
Developed and designed enterprise data warehouse (EDW) and implemented ETL processes using Python for benefits administration system’s data to support eligibility data, premium billing data, claims data and provider data
Programmer Analyst
Baylor College of Medicine
06.2016 - 10.2018
Designed database framework using MS SQL Server by providing database tables, procedures, triggers and functions
Developed dashboards and reports on patient data for research and data safety monitoring board using Tableau and SSRS
Developed the workflow and dataflow of SSIS (ETL) processes to import clinical data to SQL Server (SSIS)
Education
MS - IT Management
Campbellsville University
Campbellsville, KY, USA
01-2020
Data Science & Visualization Cert. -
UC San Diego
San Diego, CA, USA
01-2019
MS - Computer Science
University of Houston-Clear Lake
Houston, TX, USA
01-2016
BE - Information Technology
University of Madhya Pradesh
Madhya Pradesh, India
01-2014
Skills
Python and libraries (NumPy, Pandas, Matplotlib, FB Prophet)
Graduate Student Data Analyst at Landscape Evolution Observatory, Biosphere 2Graduate Student Data Analyst at Landscape Evolution Observatory, Biosphere 2