Data Scientist With 11+ Yrs Of Experience In Analytics
Pune
Summary
To succeed in an environment of growth and excellence and earn a job which provides me job satisfaction and self-development and helps me to achieve personal as well as organizational goals.
Overview
13
13
years of professional experience
4
4
Certifications
Work History
Lead Data Analyst – Product Delivery, Data Analytics & Intelligence
Johnson Control’s
2024.01 - Current
Built and delivered data product solutions tailored to stakeholder requirements, enabling data-driven decision-making.
Analyzed and resolved data issues across functional teams, ensuring accuracy and reliability in production tables for reporting.
Collaborated with cross-functional technical teams on data ingestion and transformation, updating SQL scripts to fix issues and deploy solutions in production.
Automated manual Excel reports by developing SQL scripts in Snowflake, improving efficiency and reducing manual effort.
Monitored Snowflake data platform and managed user role access requests to maintain security and compliance.
Performed data validation and quality checks in development environments, providing feedback and approvals for production deployment.
Mentored team members, assigned tasks, tracked progress, and resolved roadblocks to ensure timely delivery of project deliverables.
Business Analyst III – Pricing data analytics & Business Excellence
Johnson Control’s
2022.06 - 2024.12
Developed predictive models on pricing win/loss deal data to forecast winning probability, identify key deal attributes, and determine optimal pricing strategies to maximize margin and revenue.
Conducted correlation analysis to evaluate the impact of margin and deal status across segments, providing insights for strategies to improve win rates.
Designed and developed dynamic Power BI dashboards to visualize pricing data and support data-driven decision-making for pricing actions.
Extracted and prepared data from multiple sources for analysis, ensuring accuracy and consistency.
Managed ongoing data processes, including weekly/monthly extraction, dashboard maintenance, and implementing enhancements based on business requirements.
Analyst – HR Data Visualization, Automation & Analytics
Eaton Technologies Pvt Ltd
2019.04 - 2022.05
Executed strategic workforce planning projects, including current state analysis and time series regression to forecast headcount.
Collaborated with HR leaders to gather requirements, perform data analysis, and deliver actionable insights for business decisions.
Developed dynamic Power BI dashboards to analyze and visualize workforce data, enabling more data-driven decision-making.
Applied text analytics on employee survey data to transform open-ended responses into quantifiable, actionable insights.
Enhanced automation and analytics capabilities by leveraging Alteryx for process improvement and efficiency gains.
Associate Analyst – HR Data Reporting, Visualization & Analytics
Eaton Technologies Pvt Ltd
2016.05 - 2019.03
Managed HR data, identified data quality issues, and collaborated with cross-functional teams to implement solutions.
Developed SQL and OBIEE queries to extract employee attribute data for advanced analysis.
Created interactive dashboards and reports using Power BI, OBIEE, and MS Excel to support HR decision-making.
Programmed in R for data exploration, manipulation, and statistical analysis.
Built predictive models using Logistic Regression for HR analytics (employee attrition, recruitment), enabling early detection of at-risk employees and potential non-joining candidates.
Performed end-to-end data preparation including extraction, cleaning, variable creation, feature selection, exploratory analysis, and predictive modeling in R.
Forecasted workforce turnover using time series techniques to support workforce planning.
Conducted text analysis on exit interview data to identify key drivers of employee attrition.
Executed diagnostic projects, performed hypothesis testing, and delivered actionable insights to HR leadership for strategic decision-making.
Facilitated Excel training sessions for HR teams and led knowledge-sharing workshops on statistical methods.
Assistant Manager - Warranty Data Reporting & Statistical Analysis
TATA Motor’s Ltd
2013.01 - 2016.04
Managed complex datasets, identified data quality issues, and implemented effective solutions to ensure accuracy.
Developed R scripts for statistical analysis, summary tables, and warranty data listings.
Predicted component life cycles using warranty and test data with Minitab and R.
Forecasted failures and associated costs for upcoming models based on field data from base models.
Built statistical models to estimate AMC (Annual Maintenance Contract), warranty, and extended warranty costs for existing and new models.
Analyzed monthly sales patterns using advanced time series techniques to identify trends and support business decisions.
<ul><li>Roles and Responsibilities</li><li>Hiring and team building</li><li>Managing team’s career progression and performance reviews</li><li>Managing Performance improvement plan and firing</li><li>Mentoring</li><li>Product roadmap planning and execution</li><li>Accountability of the entire delivery execution including the risk mitigation planning.</li><li>Stakeholder management</li><li>Adhering to Apple Privacy and Security Guidelines for platform</li><li>Design and implementation of new architectures and solutions to manage all online services for AdXchange in Apple Ads.</li><li>Design and implementation of new architectures and solutions deliver Budget experimentation in Apple Ads</li><li>Design and implementation of new architectures and solutions to manage data for Ad Platform.</li><li>Creating and maintaining all the data and analytics and revenue pipelines for Ad Platforms</li><li>Driving the solution for data ingestions and data processing across Ad platform</li><li>Defining the Strategy for data governance and data access</li><li>Collaboration with business to deliver relevant data and insight for our strategy and decisions.</li><li>Managing storage, processing, copy/synchronization etc. appropriate to scale</li><li>Enabling machine learning and algorithm groups by proving them right frameworks and data</li><li>Advancing team’s design methodology and quality programming practices and evangelize those techniques across Ad platform.</li><li>Deliveries</li><li>Setup 8+ member team to design and deliver Budget Allocation and Budget experimentation.</li><li>Leading Ad Delivery services team, responsible for delivering various capabilities like query understanding, targeting, fraud etc.</li><li>Delivered and Lead Design for observability for budget, and data platform in Ad platform.</li><li>Setup 11+ members high performing team to handle various business needs such as analytics and micro services for Display Advertising as well as Data Platform</li><li>Instrumental in driving Data Platform throughout the SDLC from inception, design, development, testing and deployment.</li><li>Instilled a strong team culture of high-quality delivery by constructive feedback, cross collaboration, focus and motivation.</li><li>Delivered Realtime and Batch Platform with various integrations</li><li>Delivered new DIP design for Data Platform</li><li>Delivered design of all the components of Data processing platform</li><li>Transitioned Display data work to India seamlessly and delivered many critical business impacting features and organizational security initiatives.</li><li>Closely worked with various stakeholders to understand the requirements which resulted into efficient remote work culture.</li><li>Seamless Display execution and set up best practices for 24X7 production on-call.</li><li>Tools and Technologies</li><li>AWS, S3, Kafka, Spark, Hadoop, EMR, Hive, Scoop, Flume, Cassandra, Airflow, Oozie, Gobblin, Schema Store, Icloud, Grafana, Kubernetes, Vertica, Alation, snowflake, druid, Iceberg, Java, Scala, IntelliJ, Oracle, MySql, Git, RIO, Spinnaker, Elastic cache, Grpc, Agile.</li></ul> at Apple - Adplatform<ul><li>Roles and Responsibilities</li><li>Hiring and team building</li><li>Managing team’s career progression and performance reviews</li><li>Managing Performance improvement plan and firing</li><li>Mentoring</li><li>Product roadmap planning and execution</li><li>Accountability of the entire delivery execution including the risk mitigation planning.</li><li>Stakeholder management</li><li>Adhering to Apple Privacy and Security Guidelines for platform</li><li>Design and implementation of new architectures and solutions to manage all online services for AdXchange in Apple Ads.</li><li>Design and implementation of new architectures and solutions deliver Budget experimentation in Apple Ads</li><li>Design and implementation of new architectures and solutions to manage data for Ad Platform.</li><li>Creating and maintaining all the data and analytics and revenue pipelines for Ad Platforms</li><li>Driving the solution for data ingestions and data processing across Ad platform</li><li>Defining the Strategy for data governance and data access</li><li>Collaboration with business to deliver relevant data and insight for our strategy and decisions.</li><li>Managing storage, processing, copy/synchronization etc. appropriate to scale</li><li>Enabling machine learning and algorithm groups by proving them right frameworks and data</li><li>Advancing team’s design methodology and quality programming practices and evangelize those techniques across Ad platform.</li><li>Deliveries</li><li>Setup 8+ member team to design and deliver Budget Allocation and Budget experimentation.</li><li>Leading Ad Delivery services team, responsible for delivering various capabilities like query understanding, targeting, fraud etc.</li><li>Delivered and Lead Design for observability for budget, and data platform in Ad platform.</li><li>Setup 11+ members high performing team to handle various business needs such as analytics and micro services for Display Advertising as well as Data Platform</li><li>Instrumental in driving Data Platform throughout the SDLC from inception, design, development, testing and deployment.</li><li>Instilled a strong team culture of high-quality delivery by constructive feedback, cross collaboration, focus and motivation.</li><li>Delivered Realtime and Batch Platform with various integrations</li><li>Delivered new DIP design for Data Platform</li><li>Delivered design of all the components of Data processing platform</li><li>Transitioned Display data work to India seamlessly and delivered many critical business impacting features and organizational security initiatives.</li><li>Closely worked with various stakeholders to understand the requirements which resulted into efficient remote work culture.</li><li>Seamless Display execution and set up best practices for 24X7 production on-call.</li><li>Tools and Technologies</li><li>AWS, S3, Kafka, Spark, Hadoop, EMR, Hive, Scoop, Flume, Cassandra, Airflow, Oozie, Gobblin, Schema Store, Icloud, Grafana, Kubernetes, Vertica, Alation, snowflake, druid, Iceberg, Java, Scala, IntelliJ, Oracle, MySql, Git, RIO, Spinnaker, Elastic cache, Grpc, Agile.</li></ul> at Apple - Adplatform
Lead Business Systems Analyst, Data Analytics at Health Net Federal Services (Centene)Lead Business Systems Analyst, Data Analytics at Health Net Federal Services (Centene)