Aditya Narendra
Senior Data Analyst
Bangalore,Karnataka
Summary
Data Analyst with over 10 years of experience in PMO & Planning, spanning IT Consulting and Product-based organizations. Proven track record in establishing PMO and Planning practices. Expertise in data analysis, reporting, and visualization, skilled in Python, SQL, Power BI, and ML. Excited to leverage data skills and PMO/Planning expertise to drive improvements and deliver value.
Overview
12
12
years of professional experience
4
4
years of post-secondary education
1
1
Language
Work History
Senior Data Analyst
Shell India Markets Pvt Ltd
10.2023 - Current
- Participated in the design and implementation of 'Planify,' a tool that uses Service Now cost plans and YTD actuals from Finance MI to derive Line of Sight (year-end project spend). This initiative marks a significant advancement in financial planning, replacing traditional MS Excel-based methods with an efficient tool.
- Conducted thorough analysis of current dashboards, reviewing data sources, architecture, and update frequencies.
- Led requirements gathering, supervised data quality checks, developed Power BI prototype screens for dashboards, and acted as the primary liaison for data projects in IGU-PT IT S&P.
- Successfully implemented Power BI dashboards to monitor 2024 IGU-PT IT objectives and efficiencies, supporting the achievement of 2024 financial targets.
Planning Analyst
Shell India Markets Pvt Ltd
08.2021 - 09.2023
- Quickly adapted to Planning Analyst role in a dynamic team environment, establishing processes and aiding IT Managers in understanding key processes.
- Led S&P initiatives, collaborating with finance for cost recovery project, analyzing sponsor costs for insights.
- Analyzed sponsor costs for relevance to Portfolio Companies (PC) in Renewables Energy sector, optimizing cost allocation.
- Facilitated monthly PMO-S&P-Finance meetings, ensuring alignment.
- Managed quarterly submissions and Operating Plan exercises independently, obtaining CIO sign-off.
- Demonstrated strong data analysis, collaboration, and leadership in S&P, achieving 99% financial alignment in 2022.
- Prepared material for IT CIO and IT board meetings, contributing to strategic decisions.
- Excelled in role transition documentation, providing comprehensive insights.
PMO Analyst
Shell India Markets Pvt Ltd
08.2017 - 07.2021
- Conducted training and hands-on sessions for project and product managers, improving ServiceNow project data quality. Developed reports and dashboards in ServiceNow for better project and financial visibility, reducing 16 hours of work per month across 50+ projects.
- Reduced FY20 accruals by 42% compared to FY19, allowing the PMO team to focus on current-year activities rather than past-year invoicing.
- Played a pivotal role in achieving $7.5 MN target (no deviation in plan vs actuals) in FY 2018 & 2019 through proactive communication and collaboration with PMs and C&P IT LT, reporting actuals, estimates, variance, and mitigation steps monthly.
- Ensured cost recovery from various Lines of Business (LoBs) like Downstream IT, Upstream IT, Shell Australia, collaborating with Finance, Project Managers, and IT Managers from different LoBs.
- Trained new PMOs, in addition to regular PMO responsibilities.
- Prepared presentations for monthly C&P IT Business Portfolio Steerco meetings which helped me gain insights into IT and Business Leadership expectations from the PMO thus contributing effectively to business outcomes.
PMO Analyst
Pearson India Education Services Pvt Ltd
03.2016 - 07.2017
- Collaborated with the PMO Director to establish the PMO practice, developing processes, templates, and training materials for Project Managers and Vendors.
- Implemented Plan View PPM tool successfully, training Project Managers and APAC region PMOs on its use.
- Partnered with cross-functional teams (Finance, Procurement and Legal) to streamline contract creation, PO setup, and invoice payment processes, eliminating bottlenecks.
- Drafted and presented project-on-a-page and business case documents which are key inputs for project approval by the investment review board. Worked with Architecture, Information Security, and Tech Ops teams for project approval.
PMO Analyst
Tech Mahindra
11.2012 - 02.2016
- Managed client relationships across electromechanical and aviation domains, handling purchase orders (POs) and outstanding invoices.
- Created documentation such as risk logs, issue logs, and project plans, and participated in internal quality audits.
- Acquired proficiency in MS Excel VBA, preparing estimates for VBA tool development projects for an aviation client. Successfully delivered projects on time and within budget, earning praise from leadership.
Education
Bachelor of Engineering - Mechanical Engineering
Gogte Institute of Technology
Belagavi, Karnataka, India 09.2008 - 06.2012
Skills
Microsoft Excel
Project & Program Management
Service Now ITBM
Financial Reporting and Analysis
Python
SQL
Proactive and Ability to Lead
Machine Learning
PowerBI
Microsoft Excel
Timeline
Senior Data Analyst
Shell India Markets Pvt Ltd
10.2023 - Current
Planning Analyst
Shell India Markets Pvt Ltd
08.2021 - 09.2023
PMO Analyst
Shell India Markets Pvt Ltd
08.2017 - 07.2021
PMO Analyst
Pearson India Education Services Pvt Ltd
03.2016 - 07.2017
PMO Analyst
Tech Mahindra
11.2012 - 02.2016
Bachelor of Engineering - Mechanical Engineering
Gogte Institute of Technology
09.2008 - 06.2012