Mangesh Sangodkar

Experience

• 

  EClerx

  Nov 2013 - Jul 2016

  Reporting Analyst

  * Wrote VB script to fetch the data from websites and present the same to customers in summarized format using excel reports on daily, weekly, and monthly basis.* Presented the business insights of retail and hotel domain using financial dashboards.* Conducted the comparative analysis of customers key measures like price, star rating, in-stock value etc. with its competitor’s data using Tableau.* Used SQL queries to audit monthly reports and managed the manual testing over the business data Show less

• 

  ATOS SYNTEL PRIVATE LTD

  Jul 2016 - Aug 2019

  Associate Consultant

  - Worked in the Service Management domain to support in driving the performance of different departments like incident, change, problem & configuration management- Designed and deployed BI solutions, improving decision-making processes, and leading to an increase in operational efficiency by 15%- Formulated multiple financial reports to provide deep dive analysis to leadership using Power BI and Tableau- Liaised with business stake holders, gathering requirements, and managing the SLAs of the reports- Build the objectives of ~4000 employees at all levels and then presenting their performance against these objectives to directors and managers during the end of year- Conducted the detailed analysis regarding resource management and time utilization on projects, which was provided to management for understanding the overall effectiveness of the workforce on different accounts- Managed single platform to highlight over 70 KPI’s on monthly basis including the revenue, cost, FTE, timesheet entry, training status, automations, leave statistics, Awards, and recognitions etc. across multiple sectors- Worked with Transition Team to transfer business of around 150 FTEs from United Kingdom to India in 2019 Show less

• 

  Maersk Global Service Centre India Private Limited

  Aug 2019 - Sept 2024

  Senior Business Analyst (PowerBI Developer)

  - As a part of Global Business Performance Management team, working closely with Execution, Product Owners and SMEs to define performance metrics and goals aligned with organizational objectives- Designed and implemented a series of dashboards and data visualizations using Power BI and other BI tools that effectively communicated key trends and insights to executive leadership, leading to data-driven decision making and improved business performance- Optimized DAX formulas and query performance to enhance report responsiveness and improve user experience- Led and managed multiple projects from design to production, enhancing and optimizing existing processes to increase data accuracy and customer satisfaction by 20%- Showed power of data in one of the projects through which, the unbilled invoices were reduced significantly by $12M, from $21 M to $9 M helping minimize revenue leakage in 2022- Supported implementation team though dashboards and other automated tools to migrate a business of approx. 600 FTEs from front office to Service Centre in 2023- Led a team of 6 data analysts/engineers in the design and execution of a data warehousing project, resulting in a 50% reduction in data processing time and a 20% improvement in data accuracy Show less

• 

  Accenture in India

  Sept 2024 - now

  Analytics and modelling Specialist

  As an Analytics and Modelling Specialist within the Sales Excellence Team, I leverage data-driven insights and advanced predictive models to optimize sales performance and strategy. My role involves analyzing historical sales data, developing accurate forecasts, and using machine learning techniques to predict sales outcomes and identify opportunities for improvement.