Nikhil Janwe
Data Analyst
Pune
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for data.
Overview
8
8
years of professional experience
9
9
years of post-secondary education
3
3
Certifications
Work History
Data Analyst
Earthly Joy Global Pvt. Ltd.
Pune
4 2022 - Current
- Spearheaded implementation of automated data cleaning process, resulting in 30% reduction in data preparation time
- Collected, cleaned, and organized large datasets from various sources
- Developed and deployed predictive models using Python, leading to 15% improvement in demand forecasting accuracy
- Performed data analysis using statistical methods and machine learning techniques to identify trends and patterns in consumer behavior and sales data
- Utilized Tableau to create interactive dashboards that provided real-time insights into sales performance, contributing to 20% increase in sales efficiency
- Interfaced with clients and internal teams to understand business requirements and provide data-driven solutions to optimize processes and drive business growth
- Led team in optimizing supply chain using data-driven insights, resulting in 25% reduction in excess inventory
- Documented data analysis procedures and findings to ensure knowledge transfer and support continuous improvement initiatives.
- Analyzed data to identify root causes of problems and recommend corrective actions
- Tested data prediction algorithms based on historical data
- Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements
- Enhanced business efficiency by identifying trends and patterns in complex datasets
- Collaborated with stakeholders to identify business needs and data sources
- Analyzed transactions to build logical business intelligence model for real-time reporting needs
- Worked with business intelligence software and various reports to glean insights into trends and prospects
Data Analyst Intern
Skill Edge
Pune
07.2021 - 03.2022
- Shadowed interdepartmental personnel to better understand methods for handling daily tasks and job duties.
- Identified trends and patterns in complex datasets through exploratory data analysis, leading to actionable insights.
- Assisted with creating data cubes and models to improve data analysis.
- Developed and implemented data governance policies and procedures.
- Learnt and developed predictive models with 85% accuracy within 95% CI intervals.
- Developed KPI dashboards to monitor key financial metrics and thereby assisting in business development strategies.
- Inventory management, material management, warehouse management and optimized resource utilization in manufacturing and production cycle.
- Designed and developed data pipelines to acquire, clean and process data
- Analyzed data to identify root causes of problems and recommend corrective actions
- Used modeling and analytics to understand how business decisions impacted bottom line
BTG OPERATIONS
OEG India Limited - SWPGL
Warora
12.2020 - 06.2021
- Analyzed daily power generation data to identify trends and anomalies, enabling proactive maintenance and optimizing operational efficiency.
- Reduced time by 15% in production schedule planning in real time by past energy consumption trend.
- Conducted in-depth analysis of equipment performance data to minimize energy losses and enhance overall plant productivity
- Utilized advanced statistical methods to assess efficiency of electrical systems, leading to targeted improvements and cost savings
- Monitored and interpreted real-time data from electrical meters and sensors, enabling rapid response to deviations and ensuring uninterrupted power supply
- Developed predictive models to forecast electrical load demand, contributing to better resource allocation and enhanced grid stability
- Collaborated with cross-functional teams to analyze historical maintenance records, identifying patterns to implement preventive maintenance schedules, reducing downtime and improving equipment reliability.
- Analyzed demand and supply process flows and identified and recommended improvements and standardizations
Engineer Trainee
Avneesh Logistics Pvt Ltd
12.2015 - 11.2016
- Leveraged electrical engineering expertise to analyze supply chain data, optimizing raw material procurement processes for increased efficiency and cost-effectiveness.
- Utilized advanced statistical methods and data visualization techniques to identify trends and patterns in raw material demand, enabling proactive decision-making and inventory management strategies.
- Utilized historical consumption data, to pan out trends in raw material requirements to minimize stockouts and maximize production output.
- Collaborated with cross-functional teams to integrate data-driven insights into strategic planning initiatives, driving continuous improvement in supply chain performance and supplier relationship management.
Education
Master of Technology -
Government College of Engineering
Karad 08.2017 - 09.2019
Bachelor of Engineering -
Marathwada Institute of Technology
Auranagbad 07.2011 - 08.2015
High School Diploma -
IRA International School
Butibor, Nagpur 05.2009 - 05.2011
SSC -
DAV Public School
Wani, India 05.2008 - 05.2009
Skills
Python Programming
undefinedCertification
Foundations of Business Intelligence, 2024, Coursera Google, https://www.coursera.org/account/accomplishments/certificate/MD5KG73MZCYP
Projects
Business Revenue and Sales Performance Dashboard, 2023, Tableau and Power Bi, Total Revenue, Sales Growth Rate, Average Order Value (AOV), Customer Acquisition Cost (CAC), Customer Lifetime Value (CLV), Sales by Product Category, Sales by Geographical Region, Conversion Rate, Sales Pipeline Velocity, Churn Rate, Revenue Overview, Sales KPIs, Customer Analysis, Product Performance, Sales Pipeline, Geospatial Visualization, Trend Analysis, Time Period, Product Categories, Geographical Regions, Customer Segments Customer segmentation and purchase prediction for Marketing and Sales strategy, 2022, Python - Numpy, Scikitlearn, Pandas, Matplotlib; Tableau, Excel, Customer Segmentation, Purchase Prediction Model, Segmentation Visualizations, Predictive Analytics Dashboard, Product Affinity Analysis, Engagement Metrics Product Association and Bundling for Enhanced Customer Experience, 2021, Python - Mlxtend, Pandas, numpy, Scikitlearn; Excel; Tableau, Association Rule Mining, Market Basket Analysis, Product Bundle Creation, Sales Impact Analysis, Customer Experience Enhancement
Timeline
Data Analyst Intern
Skill Edge
07.2021 - 03.2022
BTG OPERATIONS
OEG India Limited - SWPGL
12.2020 - 06.2021
Master of Technology -
Government College of Engineering
08.2017 - 09.2019
Engineer Trainee
Avneesh Logistics Pvt Ltd
12.2015 - 11.2016
Bachelor of Engineering -
Marathwada Institute of Technology
07.2011 - 08.2015
High School Diploma -
IRA International School
05.2009 - 05.2011
SSC -
DAV Public School
05.2008 - 05.2009
Data Analyst
Earthly Joy Global Pvt. Ltd.
4 2022 - Current
Foundations of Business Intelligence, 2024, Coursera Google, https://www.coursera.org/account/accomplishments/certificate/MD5KG73MZCYP
Python Basic Certificate, 2024, HackerRank, https://www.hackerrank.com/certificates/5641ef4bace1
Python Bootcamp, 2021, Udemy, https://www.udemy.com/certificate/UC-a77916fd-a47a-4108-823f-d00b18602e68/
Similar Profiles
Karandeepsingh BaliKarandeepsingh Bali
Product support engineer at Komatsu Mining Corp. Group (Joy Global India Pvt Ltd)Product support engineer at Komatsu Mining Corp. Group (Joy Global India Pvt Ltd)
Asia BatemanAsia Bateman
General Laborer - Fabrication at Komatsu - Joy GlobalGeneral Laborer - Fabrication at Komatsu - Joy Global
Mehar YahyaMehar Yahya
HR Consultant - Talent Acquisition at Joy of Giving Global Foundation (Jan Suraaj)HR Consultant - Talent Acquisition at Joy of Giving Global Foundation (Jan Suraaj)