Experience

ShareThis

• Technology, Information and Internet
• 1 - 100 Employee

• Sr. Data Analytics Engineer

  • Jun 2021 - Sep 2023

  Palo Alto, California, United States Developed end-to-end BI solutions using Databricks, BigQuery, Airflow, PowerBI, Domo, Python, Spark, SQL, PySpark, and more. Created data products, including custom datasets, curated DaaS feeds, and data governance solutions. Collaborated on customer-facing projects and worked alongside product management. Key technologies: SQL, Python, PySpark, Spark, BigQuery, Docker, Databricks, Data Quality, Big Data tools, GitHub, Airflow, etc.



CSBio

• United States
• Biotechnology Research
• 1 - 100 Employee

• Analytics Engineer

  • Jun 2019 - Jun 2021

  San Francisco Bay Area • A key contributor to the company’s success by improving core functions with the help of data-driven solutions. • Extracting and preparing large data from SQL Server using pandas, NumPy, and scikit-learn to understand the patterns and identify KPIs and Matrices. • Perform duties of Power BI lead for developing and maintaining a suite of dashboards & visualizations to provide improved insightfulness across various stakeholders. • Developed AS-IS and TO-BE business… Show more • A key contributor to the company’s success by improving core functions with the help of data-driven solutions. • Extracting and preparing large data from SQL Server using pandas, NumPy, and scikit-learn to understand the patterns and identify KPIs and Matrices. • Perform duties of Power BI lead for developing and maintaining a suite of dashboards & visualizations to provide improved insightfulness across various stakeholders. • Developed AS-IS and TO-BE business scenarios for underperforming departments and used historical data to identify non-performing indicators and collaborate with managers to improve performance. Key Achievements: • Built dashboard for EH&S manager to monitor and control the site’s HVAC system in real-time. This solution saved daily site inspection rounds which are ~1.50 man-hours and HVAC maintenance cost is slashed by 40%. Tools used - Power BI, Microsoft Flow, and Envision (BMS). • Built & delivered a prediction model for freezers to lower down the number of deviations. With 87% of accuracy, the solution drastically improves business efficiency and saves ~45 man-hours for each freezer related deviation. Tools used - Azure ML, SQL, and Python. • Saved ~$120K annually by building a program for analyzing EM data in-house and updating the EM sensors configurations to maintain the air quality as per applicable ISO standards. Tools used – MS-Excel and MS-Word. Show less



California State University, Los Angeles

• United States
• Higher Education
• 700 & Above Employee

• Graduate Student Assistant

  • Aug 2017 - May 2019

  Greater Los Angeles Area • Replacement of a collection of MS-Excel pivot charts with Tableau dashboard. This improved the query processing speed from Oracle PeopleSoft and HRIS manager is enabled to greatly leverage the value generated from HCM datasets. • Continues delivery of bi-weekly departmental performance reports with snippets from dashboards. • Performing statistical ANOVA analysis between payroll datasets for various departments every quarter to understand the variation throughout the academic… Show more • Replacement of a collection of MS-Excel pivot charts with Tableau dashboard. This improved the query processing speed from Oracle PeopleSoft and HRIS manager is enabled to greatly leverage the value generated from HCM datasets. • Continues delivery of bi-weekly departmental performance reports with snippets from dashboards. • Performing statistical ANOVA analysis between payroll datasets for various departments every quarter to understand the variation throughout the academic calendar year. Show less



Boehringer Ingelheim

• Germany
• Pharmaceutical Manufacturing
• 700 & Above Employee

• Data Science Intern (Enabling Functions & Platforms)

  • Jun 2018 - Aug 2018

  Fremont, CA • Achieved 78% improvement by automating the logistics operations utilizing data stream from SAP BO and MS-Excel using VBA scripts to help the logistics department succeed. • Drastically reduced IT equipment downtime from ~4 hours to ~1.5 hours by implementing & configuring JIRA Service Desk and Confluence knowledge base for internal IT ticketing system and integrating Tableau for the IT service desk team to empower the IT/IS department. • Solved a data management problem… Show more • Achieved 78% improvement by automating the logistics operations utilizing data stream from SAP BO and MS-Excel using VBA scripts to help the logistics department succeed. • Drastically reduced IT equipment downtime from ~4 hours to ~1.5 hours by implementing & configuring JIRA Service Desk and Confluence knowledge base for internal IT ticketing system and integrating Tableau for the IT service desk team to empower the IT/IS department. • Solved a data management problem by building an RDBMS in MS-Access and defining schemas to successfully migrate multiple non-relational spreadsheets to help the human resource department. • Collaborated with the offshore team, Tata Consultancy Services, for the development/upgrade of modules in IBM Maximo. Show less



Bajaj Auto Ltd

• India
• Manufacturing
• 700 & Above Employee

• Market Researcher

  • Jun 2013 - Jun 2017

  New Delhi Area, India • Completed a research project to understand the buying pattern of KTM Duke motorcycle customers. • The data was collected using SurveyMonkey questionnaires, company historical datasets, and in-person interviews to perform the analysis. • Multivariate testing and media mix modeling was done using statistical tools like MS-Excel and IBM SPSS. • This research enabled the marketing department to revise marketing strategies for targeted niche groups of performance motorcycles and an… Show more • Completed a research project to understand the buying pattern of KTM Duke motorcycle customers. • The data was collected using SurveyMonkey questionnaires, company historical datasets, and in-person interviews to perform the analysis. • Multivariate testing and media mix modeling was done using statistical tools like MS-Excel and IBM SPSS. • This research enabled the marketing department to revise marketing strategies for targeted niche groups of performance motorcycles and an overall gain of 28% sales improvement in Q1-Q2 2014. Show less



KTM Bajaj Auto Ltd.

• 1 - 100 Employee

• Motorsport Athlete

  • Feb 2009 - Jan 2017

  New Delhi Area, India • Won multiple cross-country rallies and track national championships and supported R&D division.