Mangeshkumar Ninawe
Pune
Summary
Goal-driven analyst polished in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Several years of experience in industry.
Overview
7
7
years of professional experience
Work History
Analyst II
Toro Technology Center India
Pune
03.2023 - Current
- Worked on various projects such as Incoming Orders, Sales & Revenue, Open Orders, Manufacturing (Downtime & OEE Analysis), DEI Analytics (HR).
- Collaborate with Business Analytics Managers to develop and deploy enterprise analytics operating processes.
- Collaborate with cross functional teams to deliver defined analytics objectives; including project scoping, data source identification, scenario modeling, dashboard design and development, testing and go live.
- Provide business recommendations and insights based on analytic outcomes.
- Conduct gap analysis, feasibility analysis and report to leadership team in presentable format.
- Simplify and automate data reporting dashboards; build solutions to have maximum scale and self-serviceability by users.
- Understand business rules and contribute to the data transformation process and data cleansing, data mining.
- Use sources of data from disparate systems, identify relationships between data to enable analysis and provide insights and recommendations, also to be good at data modeling.
- Communicate effectively to business users, stakeholders and leaders on how business logic is applied to raw data, constraints with data and solving certain data problems, and how operational activities create data.
- Partner with IT to ensure data extraction, transformation, loading, and presenting it in a sophisticated manner using business analytics tools and techniques.
- Recognize and adopt best practices in reporting and analysis: data integrity, dashboard design, analysis, and documentation.
- Monitor and report data integrity caused by business systems or processes and determine solutions to resolve any issues identified.
- Carry out data validation to highlight the data issue and come up with solutions to improve the data-driven decision making.
- Drive ad-hoc research related to strategic projects.
- All other tasks and projects as assigned.
- Expertise in Descriptive Analytics, BI Reporting, Visual Analytics, KPI Development, Root Cause Analysis, building statistical models to solve business problems.
- Expertise in Advance Excel including use of VBA for automating in Excel Reports and creating dynamic dashboards using VBA.
- Proficient professional with sound business logic and ability to structure approaches to answer complex business and supply chain questions.
- Proficiency in writing complex Dax Queries in PowerBi and hands on experience in SQL.
- Proficient with Business Intelligence and Analytics tools such as Power BI, Excel, MS Access.
- Experience with ERP systems, SAP.
- Ability to prioritize projects, manage multiple competing priorities and drive projects to completion under tight deadlines.
- Excellent written and oral English language and communication skills.
- Ability to break down complex ideas and issues and communicate in simple terms to different levels of the organization.
- Capacity to work independently as well as within a team-oriented, collaborative environment.
- Extensively worked with Power Users to deploy Dashboards, Dataset & Reports objects in production.
- Test the objects assign gateways, raise request to create gateways sometime create it on our own.
- Deploy new as wells as existing reports in production by testing it in stage first then validate & then promote the same in production.
SENIOR EXECUTIVE
Interarch Building Products Pvt. Ltd.
Pune
07.2021 - 03.2023
- Extensive hands-on database Management
- Experience of handling customer and Partner interaction and to deal with their requirements
- Understand business requirements in BI context and design data models to Transform raw data into meaningful insights
- Published reports and dashboards using Power BI
- Used Power BI Gateways to keep the dashboards and reports up to date
- Create dashboards and interactive visual reports using Power BI & Excel
- Handling various projects trackers regarding Operations, Supply chain management, and IME
- Identify key performance indicators (KPIs) with clear objectives and consistently monitor those Analyzing data and present data through reports that aid decision making
- Create relationships between data and develop tabular and other multidimensional data models, Chart creation
- Perform DAX queries and functions in Power BI
- Prepare Reports on Excel Using different reporting tools and formulas like V-Lookup
- Reports Generation from Pivot Table and Pivot Chart
- Good hands on with Excel tools like V-Look up H-look up Pivot charts
- Thorough, diligent and executing the tasks with a high level of accuracy
- To support for Making PowerPoint presentation (PPTs) required for Business meeting
- Power BI, DAX, SQL Server, Data Warehousing concepts.
SALES REPORT ENGINEER - COORDINATION
Avians Innovations Pvt. Ltd.
Pune
06.2020 - 07.2021
- Extensive hands on database Management of O&M projects
- Experience of handling customer and Partner interaction and to deal with their requirements
- Analyze and present data to help the company make important decisions
- Creating and Maintaining Power BI reports based on productivity data generated across Entire Circle
- Created DAX Queries to generated computed columns in Power BI
- Analyze the Daily progress data and creating summarized reports on Excel & Power BI
- Creating various Charts and visualizations for Showing performance of different Areas
- Handling various projects trackers regarding Operations, Supply chain management, and IME
- Finding correlations in data to discover meaningful insights
- Prepare Reports on Excel Using different reporting tools and formulas like V- Lookup
- Reports Generation from Pivot Table and Pivot Chart
- Good hands on with Excel tools like V-Look up H-look up Pivot charts
- Thorough, diligent and executing the tasks with a high level of accuracy
- To support for Making PowerPoint presentation (PPTs) required for Business meeting
- Practical Experience and Expertise in Handling Various data and Reporting.
PROJECTS & SUPPORTS
Diffusion Engineers Ltd.
Nagpur
05.2019 - 03.2020
- Extensive hands on database Management of O&M projects
- Experience of handling customer and Partner interaction and to deal with their requirements
- Analyze and present data to help the company make important decisions
- Creating and Maintaining Power BI reports based on productivity data generated across Entire Circle
- Created DAX Queries to generated computed columns in Power BI
- Analyze the Daily progress data and creating summarized reports on Excel & Power BI
- Creating various Charts and visualizations for Showing performance of different Areas
- Handling various projects trackers regarding Operations, Supply chain management, and IME
- Finding correlations in data to discover meaningful insights
- Prepare Reports on Excel Using different reporting tools and formulas like V- Lookup
- Reports Generation from Pivot Table and Pivot Chart
- Good hands on with Excel tools like V-Look up H-look up Pivot charts
- Thorough, diligent and executing the tasks with a high level of accuracy
- To support for Making PowerPoint presentation (PPTs) required for Business meeting
- Practical Experience and Expertise in Handling Various data and Reporting.
SALES ENGINEER
Mr Breeze Cooling Pvt. Ltd.
Nagpur
11.2017 - 04.2019
- Connected professionally with the dealers, vendors, contractors and consultants who were already involved in to the same business to get brief idea of the market
- Expanded customer base by identifying needs and delivering client-centered solutions
- Managed all project's activities by helping to sales executives, project assistants and technicians
- Managed individually Sales, Marketing and Procurement
- Set timelines and helped teams to complete the target within given time period
- Negotiated prices with vendors and suppliers
- Buildup new strong business relationships with visitors with the help of exhibitions
- Worked with support teams to resolve product and service issues.
Education
BACHELOR OF ENGINEERING IN ELECTRONICS -
RCOEM - Nagpur
Skills
- Microsoft Office
- Power BI Desktop
- Power BI Services
- Data Visualizations & Modeling
- Data Warehousing & Data Analytics
- DAX
- Team Work
- Problem Solving
- SQL
- Data Analytics
- Business Requirements
- Business Insights
- Incoming Orders, Sales & Revenue Insights, Downtime & OEE Analysis
- Snowflake
Timeline
Analyst II
Toro Technology Center India
03.2023 - Current
SENIOR EXECUTIVE
Interarch Building Products Pvt. Ltd.
07.2021 - 03.2023
SALES REPORT ENGINEER - COORDINATION
Avians Innovations Pvt. Ltd.
06.2020 - 07.2021
PROJECTS & SUPPORTS
Diffusion Engineers Ltd.
05.2019 - 03.2020
SALES ENGINEER
Mr Breeze Cooling Pvt. Ltd.
11.2017 - 04.2019
BACHELOR OF ENGINEERING IN ELECTRONICS -
RCOEM - Nagpur
Similar Profiles
Subrata GhoshSubrata Ghosh
Senior Quality Engineer at GGS Engineering Services India Pvt. Ltd (Onsite at John Deere Technology Center India)Senior Quality Engineer at GGS Engineering Services India Pvt. Ltd (Onsite at John Deere Technology Center India)
Deepakraj PandaDeepakraj Panda
Senior Design Engineer at RNTBCI (Renault Nissan Technology & Business Center India)Senior Design Engineer at RNTBCI (Renault Nissan Technology & Business Center India)
Aravinth RamakrishnanAravinth Ramakrishnan
Assistant Manager - HR (PMD COE) at Renault Nissan Technology Business Center IndiaAssistant Manager - HR (PMD COE) at Renault Nissan Technology Business Center India
Vikash AgrawalVikash Agrawal
IT Analyst at Tata Consultancy ServicesIT Analyst at Tata Consultancy Services
Shital ArgadeShital Argade
Senior System Engineer / Technology Analyst at Infosys Pvt. Ltd.Senior System Engineer / Technology Analyst at Infosys Pvt. Ltd.