Open To Work
Bhushan Anil Metkar
Pune
Summary
Accomplished Senior Analyst with expertise in SAS programming and Python-based ETL development at Johnson & Johnson Pvt Ltd. Excelled in data transformation and visualization, enhancing stakeholder reporting. Proven ability to collaborate with cross-functional teams, driving process improvements and strategic insights. Successfully automated S3 data integration, boosting efficiency by 30%.
Overview
12
12
years of professional experience
Work History
Senior Analyst
Johnson & Johnson Pvt Ltd
06.2017 - Current
- Built and maintained ETL pipelines in Python using pandas to ingest, clean, and transform raw data stored on Amazon S3, enabling downstream analytics and reporting.
- Automated data ingestion from S3 into analysis workflows using boto3 and s3fs, streamlining processes and enhancing reproducibility.
- Implemented efficient pandas data transformations to process large S3-based datasets.
- Transformed large datasets from SAS to Python using Spyder, facilitating data analysis.
- Designed and maintained SAS-based ETL pipelines using DATA and PROC step, to ingest, cleanse, and transform large enterprise datasets for downstream analytics.
- Generated automated reports from pandas DataFrames, exporting results to Excel/Parquet/CSV on S3 for stakeholder review and ML training.
- Built models utilizing Cox regression to analyze significant variables for driver insights.
- Performed exploratory data analysis to solve business challenges and improve retention with new strategies.
- Developed interactive dashboards in Power BI, enabling stakeholders to make informed decisions.
Data Analyst
UPS Logistics Pvt. Ltd
12.2016 - 05.2017
- Data mining through large data set in excel and databases to be used for analysis.
- Formulated mathematical calculation for simplifying data.
- Developed and distributed reports monitoring metrics and performance standards for operations managers and teammates.
- Engaged with stakeholders and senior management to identify areas for operational improvement.
- Collaborated with industrial engineering team to implement and manage systematic operations of new business, contributing to revenue growth.
- Followed up with internal and external customers and kept customer informed about the request status.
Data Analyst
Divitrex technology solution pvt ltd
10.2015 - 11.2016
- Performed exploratory data analysis to solve business challenges and improve the data accuracy with new strategies.
- Executed SQL scripts to acquire new data, compiling findings in excel for subsequent analysis.
- Generated multiple reports daily using business intelligence tools to meet diverse customer needs.
- Conducted daily data quality checks in excel based on client-defined standards using python to ensure data integrity.
- Involved in ad hoc requests to create visualizations in Excel and validate data.
Senior Process Executive (Accounts payable process)
Infosys BPO
12.2013 - 09.2015
- Reconciled all bank and client money according to service level agreements.
- Reconciled misapplied payments through cash applications according to customer remittance.
- Researched dispute rejection reasons and submitted supporting documents for accounts payable operations.
- Processed daily quality checks and timelines by consulting local and US management.
- Served as senior analyst for application team, providing insights and support.
- Participated in ideation process to develop new process improvements for continuous client and internal commitment.
Education
Master of Science - Statistics
Modern College Shivajinagar
PuneSkills
- Data transformation
- Advanced Excel
- S3 data integration
- ETL development
- Basic AWS services
- SAS programming
- Data visualization
- Python programming
- Boto3
- S3fs
- Documentation and reporting
Timeline
Senior Analyst
Johnson & Johnson Pvt Ltd
06.2017 - Current
Data Analyst
UPS Logistics Pvt. Ltd
12.2016 - 05.2017
Data Analyst
Divitrex technology solution pvt ltd
10.2015 - 11.2016
Senior Process Executive (Accounts payable process)
Infosys BPO
12.2013 - 09.2015
Master of Science - Statistics
Modern College Shivajinagar