POWER BI
Shantanu Prakash Joshi
SCM Control & Planning Analyst
Bengalore
Summary
A proficient Business SCM Analyst with 8+ years of quality experience in business analysis, supply chain procurement and related tool Work with POWER BI tool as main analysis tool and basic knowledge of SAP, SQL, Power Automate. Developed & implemented dashboards like Supplier Qualification, P2P, Commodity report, Payment Terms, Automated validation tool Experienced in developing the reporting capabilities using various data sources like SSAS cube, Salesforce, SAP Ariba, SharePoint etc. Engaged with the business cross functional teams to develop analysis solutions in the areas of supply chain management Basic knowledge of manufacturing process and awareness of Agile process Adept in requirement gathering, designing and implementing the solution to cater to the business requirement Instrumental in strategic sourcing and procurement, actively involved in RFx management and coordination Proficient in preparing commercial offers for direct and indirect commodities, technical clarification to customers Core Competencies: Procurement Analysis, Manufacturing knowledge, Awareness of Agile process, MS Office, POWER BI, Cross- functional Coordination, Leadership Skill, Team management, Strategic Sourcing, Vendor Development & Management, Contracting and Negotiation, Strong Interpersonal Skills
Overview
11
11
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
Controlling & Planning SCM Analyst
Hitachi Energy Technology Services Private Limited
Bengaluru
05.2022 - Current
- Working on PG SCM and TTL global performance reporting - timely and accurate reporting of performance
- Validate and improving reporting quality - continue to enhance data accuracy, integrity, and report outcomes
- Support development of KPIs, key metrics, and critical analytics
- Managing annual planning process for target setting and other KPIs
- Global lead and Subject Matter Expert on certain aspects of performance management process and reporting
- Part of core team leading roll out and adoption of new global performance management system (New SCMIS)
- Key account manager for performance management process globally
- Managing global data base and reporting system
- Improved monthly performance turn around time by automation of report from 5 days to 3 days
SCM Business Analyst
ABB Global Industrial & Service
Bengaluru
06.2017 - 04.2022
- Strong business acumen with proven ability to identify business drivers and make sound recommendations
- Work with POWER BI tool as subject matter expert (SME) and basic knowledge of Tableau and Qlik View
- Collaborated with global team for solution development and implementation and present it to internal stakeholder
- Track global KPIs for internal & external stakeholders and provide it to global management on weekly, monthly basis
- Proven ability in leveraging data analysis tools and techniques and extracting insights from data and drive resultant business action
- Automation of dashboards for internal customers resulting in to saving around 51K USD annually
- Reviewing performance of SCM and identifying areas that can be improved like qualification of suppliers improved from 85% to 93%
- Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts like Commodity reports, SharePoint Management and Development
- Knowledge of Power BI reporting architecture focused primarily on POWER BI Desktop, POWER BI Web, POWER BI gateway, POWER BI Services
- Working as SAP Ariba administrator for business area, managing and conducting trainings across globe, continuously working with Project manager of SAP Ariba and monitoring process of implementation of SAP Ariba tool Globally
Strategic Sourcing and Procurement Coordinator
ABB Global Industrial & Service
Bengulure
06.2016 - 05.2017
- Generate quotation, sales order and invoice for external and internal suppliers from Dubai, India and Europe
- Coordinate with SCM team and engineering team for technical clarification, supplier payments, on time delivery for both internal and external suppliers
- Monitor demand-flow for all suppliers, which include days of supply, consigned warehouse arrangements, and safety stock to support project
- Determine supplier performance index scores involving Spend, CR, Payment Terms, integrity, conduct monthly reviews for top suppliers and set goals for grade-achievement results with management
- Familiar with E-tools for Supplier Management, RFQ Management (e-sourcing and SAP)
- Continuously working with customers for continuous improvement in quality of suppliers
- Have basic information quality improvement tools 8D, 5S and 6Sixgma
Tactical
ABB Global Industrial & Service
Bengaluru
04.2015 - 05.2016
- Performed Tactical activities (Quotation process) from UAE to India OPC which provide savings about 10%
- Lead highly motivated team of SCM professionals who have multidisciplinary tactical skills for SCM analytical activities across Business units in Business
- Consistently received >95% score in biannual customer satisfaction survey since last 3 years
Quality Engineer – Management Trainee
Model Infra Corporation
Pune
10.2014 - 03.2015
- Taking responsibilities of inspecting job correctly from child parts till final assembly
- Responsible for coordination with customers related to new product development and developing prototype of product
- Generate fixtures for new develop products and set up production line, generate Standard Operating Procedure (SOP)
- Can handle independently product development/supplier development
- Have basic information about PPAP, 5S and quality tools
Quality Engineer
Neat Wind Industry
Ahmednagar
06.2012 - 06.2013
- Electrical and Mechanical
- Handle customer complaints
- To maintain in-line Quality of product as per Customer standard (Q.C.)
- To plan production and execute production as per plan
- To assure customer regarding quality of product (Q.A.)
- Generate fixtures for new develop products and set up production line, generate Standard Operating Procedure (SOP)
- Can handle independently product development/supplier development
- Have basic information about PPAP, 5S and quality tools
Education
MBA - Marketing
Pune University
Ahmednagar 06.2013 - 06.2015
B.E - electrical
Pune University
Ahmednagar 06.2008 - 06.2012
Skills
Data analysis
Software
SAP
SAP Ariba (SSS module)
SQL (Basic End user Knowledge)
Accomplishments
- Achieved 100% by completing Monthly reporting task with accuracy and efficiency.
- Collaborated with team of 10 people of third party supplier in the development of NEW SCMIS Project.
- Achieved 90% result through effectively helping with building Savings entry tool.
- Consistently received >95% score in biannual customer satisfaction survey since last 3 years
Timeline
Controlling & Planning SCM Analyst
Hitachi Energy Technology Services Private Limited
05.2022 - Current
SCM Business Analyst
ABB Global Industrial & Service
06.2017 - 04.2022
Strategic Sourcing and Procurement Coordinator
ABB Global Industrial & Service
06.2016 - 05.2017
Tactical
ABB Global Industrial & Service
04.2015 - 05.2016
Quality Engineer – Management Trainee
Model Infra Corporation
10.2014 - 03.2015
MBA - Marketing
Pune University
06.2013 - 06.2015
Quality Engineer
Neat Wind Industry
06.2012 - 06.2013
B.E - electrical
Pune University
06.2008 - 06.2012
Similar Profiles
Rajeev SonaimuthuRajeev Sonaimuthu
Project Engineer at Hitachi Energy Technology Services Private Limited,Project Engineer at Hitachi Energy Technology Services Private Limited,
Mithun NMithun N
Finance Executive at HITACHI ENERGY TECHNOLOGY SERVICES PRIVATE LIMITEDFinance Executive at HITACHI ENERGY TECHNOLOGY SERVICES PRIVATE LIMITED
BHAGAVAN CHODAVARAPUBHAGAVAN CHODAVARAPU
Tender/Quotation Specialist at Hitachi Energy Technology Services Pvt LtdTender/Quotation Specialist at Hitachi Energy Technology Services Pvt Ltd