Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sandeep Jagtap

Business Planning & MI Analyst
PUNE

Summary

Driven by a results-focused approach, I leveraged advanced Excel and VBA skills at TCS India PVT Limited to automate & maintain reporting . My dedication to continuous improvement and adept problem-solving abilities have consistently enhanced operational efficiency and quality across roles. My speciality 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.

Overview

9
9
years of professional experience
6
6
years of post-secondary education
1
1
Certification

Work History

MI Analyst

TCS
04.2022 - Current

· Analysed operational improvements against KPIs to measure progress.

· Educated users on automation systems and features to reduce work time and achieve quality results.

· Power BI transition of current Excel reports

· New Automation Requests, Maintenance of current tools, Database(Access)maintenance

· BAU and Adhoc activities

Business Planning & MI Analyst

Capita India PVT Limited
12.2018 - 04.2022
  • Achieved benefit of 0.5 fte in reporting by developing effective report automation
  • Used VBA and MS Access to generate required reports
  • Handling reporting and adhoc activity for O2 service area & Preparing Summarized view for SM
  • Automated multiple reporting tasks through creation of reporting tools with VBA and Power Query
  • Developed and documented standard operating procedures
  • Developed new template & database while transition to new reporting tool

Sales Ops Executive

ZDSB
04.2018 - 07.2018
  • Improved operations through consistent hard work and dedication.
  • Campaign checking and launching & delivery to client
  • Campaign tracking and follow-up
  • SFDC updation of opportunity & Incident tracker updation
  • Client communication and error handling

Executive

DHL Express
11.2015 - 03.2018
  • Tracked orders and notified customers of status or potential delays.
  • Monitored and reported on transportation costs and properly filed shipping documents.
  • Reported customer feedback to management.
  • Liaised between warehouse personnel and customer to facilitate account and operational needs.
  • Completed timely data entry of new orders, labeled containers and placed in accurate storage locations.

Education

Post Graduate -

TASMAC
Pune
06.2011 - 05.2013

Bachelors of Commerce -

Bharti Vidyapeeth
Pune
06.2007 - 04.2011

Skills

    Report automation

    VBA, Python

    Power BI, Power Query

    Ms Access, SQL

Certification

Six Sigma Yellow Belt

Timeline

MI Analyst

TCS
04.2022 - Current

Six Sigma Yellow Belt

03-2020

Business Planning & MI Analyst

Capita India PVT Limited
12.2018 - 04.2022

Sales Ops Executive

ZDSB
04.2018 - 07.2018

Executive

DHL Express
11.2015 - 03.2018

Post Graduate -

TASMAC
06.2011 - 05.2013

Bachelors of Commerce -

Bharti Vidyapeeth
06.2007 - 04.2011
Sandeep JagtapBusiness Planning & MI Analyst