HITESH HARISH JALGAONKAR
Finance Reporting Analyst \ Data Analyst
Thane
Summary
Dedicated and detail-oriented Microsoft Certified Power BI Data Analyst with a strong background in Excel Analytics & Reporting and Power BI.
Seeking to leverage analytical skills and data visualization expertise to contribute to data-driven decision-making and improve business process.
Currently working as Finance Reporting Analyst \ Data Analyst with 2 years' experience in different Finance Reports & 10 years' experience in Advance Excel, Reporting, Business Communications, Stake Holder Management.
Business Intelligence skills including Power BI Desktop & Service, Power Query, Excel & PBI Dashboards, DAX & Automations. Database skills including Data Visualizations and Data Storage.
Working knowledge of Power Automate and Excel VBA.Motive is to work in a globally competitive environment on challenging assignments \ projects that shall yield the twin benefits of the job satisfaction and a steady-paced growth.
Always an hunger to learn new things, make new opportunities & helping people in their work, save time and efforts.
Supported critical Business situation like Business Continuity Plan (BCP), IT Transition, Operational Issue, Impact assessment and documentation. Engaging Stakeholder and sending professional business communication during critical business situation.
Overview
10
10
years of professional experience
8
8
years of post-secondary education
7
7
Certifications
Work History
Finance Reporting Analyst (Client End)
Capgemini Technology Service Limited (CG)
11.2021 - Current
- Currently working for Nordics countries as Finance Reporting Analyst where roles involve Remuneration Cost Analysis & Calculation, HFM Headcount Reporting, Flat files preparations, ARC Projection, Salary Bench Marking and ARC Budgeting
- ARC Cost calculation upload in the backend system for updating necessary database which is useful to determine Actual Cost & Future Projections for multiple teams.
- Developed 03 PBI dashboards for client related finance.
- 04 Major Automations in Excel which saved around 2 FTE hours in a month.
- HFM Headcount Analysis for Nordics group of countries.
- Working on ADHOC Finance reports and analysis
- Working with SAP team for database correctness checks in SAP Database
- SAP Success Factor testing.
Data Analyst (Operations End)
Capgemini Technology Service Limited (CG)
11.2021 - Current
- Building Excel & Power BI Interactive dashboards for internal reporting and client
- Using Power Query & DAX for ETL & complex calculations
- Using Power BI to connect to multiple data sources like Sharepoint, Onedrive, Local Storage & SQL
- Building Automations for team colleagues and saving time on critical reports
- Helping teammates on query, challenges and guide them whenever needed
- 2 Major Automation in Excel which saved around 0.2 FTE a day.
- Analytical Thinking ability for Database and find out trends or patterns wherever needed
- Automated recurring reporting processes, reducing manual workload and increasing efficiency
- Working knowledge of Power Automate & Excel VBA.
Data Analyst (Pharma Process Client End)
TATA CONSULTANCY SERVICE (TCS)
09.2020 - 10.2021
- Development of risk tool methodology and analysis
- Preparing Risk Matrix, Compliance Risk & Business Importance assessment to derive final risk level country wise and Continent wise
- Working on managing data and getting valuable analysis from it
- Preparing Excel automation on reducing steps involved in complex project through time saving Macros in VBA
- Working on Microsoft team and SharePoint online for data storage
- Preparing multiple data analysis graphs and chart in Power BI
- Preparing comparison year & month wise to see trend analysis
- Working on power query for complex data and sending it to pivot tables
- Preparing Risk Tool presentation and analysis and presenting to Client in Weekly Meeting.
Workflow Analyst \ Incident Management Associate
TATA CONSULTANCY SERVICE (TCS)
06.2014 - 08.2020
- Produces call volume forecasts on a daily, weekly, monthly, and annual basis for multi-site operation.
- Compares results to forecast and identify opportunities for improvement
- Provide daily/intra-day performance reports to leadership
- Communicating internally on MS Teams (previously with skype) for any roster changes and leave updating, and timely managing transportation, attendance, shrinkage data and reports
- Preparing effective reports using pivot tables, pivot charts and excel formula
- Preparing Excel Automation for advisor's database and process related data analysis for Incident Management and sending it to client for further drill down and maintaining Problem Management Database.
Education
Postgraduation Diploma in Finance Management (PGDFM) -
Welingkar institute of Management studies
01.2012 - 04.2014
Bachelor of Commerce (B.com) - Computer & Finance
Annasaheb Vartak College
01.2006 - 04.2011
SSC - undefined
Adarsh Education Society (Kapol) High School
01.2006 - undefined
Skills
Power BI Serviceundefined
Certification
Excel and Macros VBA certification (Aptech Institute)
Accomplishments
- Recognized by client as Telstra TCS Best Incident Management.
- Got BPS Star Performer for July 2018 for excellent quality work, putting extra effort on incident resolving.
- Got BPS Special Initiative Award for September 2018 for preparing two macros based excel sheet for updating Outage tracker and transport tracker automation to save time improve efficiency.
Area Of Expertise
- Advance Excel 365 and PowerPoint
- Advance Power Query
- Power BI Desktop & Power BI Service
- MS Teams and SharePoint
- Tool used: - BMC ITAM Remedy, Genesys WFM, Configuration Manager
- VDI (Virtual Desktop Infrastructure) and RDP (Remote Desktop Platform) working knowledge
- IT transition and BCP support
- Business Incident Management
- Business Communication
- Business Email Writing
Total Experience
12
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Advanced (C1)
Hindi
Upper intermediate (B2)
Interests
Travelling
Bike Ride
Singing
Work Preference
Work Type
Full TimeWork Location
On-SiteHybridImportant To Me
Work-life balanceFlexible work hoursTeam Building / Company RetreatsCareer advancementCompany CultureHealthcare benefitsTimeline
Finance Reporting Analyst (Client End)
Capgemini Technology Service Limited (CG)
11.2021 - Current
Data Analyst (Operations End)
Capgemini Technology Service Limited (CG)
11.2021 - Current
Data Analyst (Pharma Process Client End)
TATA CONSULTANCY SERVICE (TCS)
09.2020 - 10.2021
Workflow Analyst \ Incident Management Associate
TATA CONSULTANCY SERVICE (TCS)
06.2014 - 08.2020
Postgraduation Diploma in Finance Management (PGDFM) -
Welingkar institute of Management studies
01.2012 - 04.2014
Bachelor of Commerce (B.com) - Computer & Finance
Annasaheb Vartak College
01.2006 - 04.2011
SSC - undefined
Adarsh Education Society (Kapol) High School
01.2006 - undefined
Similar Profiles
RENU MANISH JAINRENU MANISH JAIN
HR Recruiter at CAPGEMINI TECHNOLOGY SERVICE LIMITEDHR Recruiter at CAPGEMINI TECHNOLOGY SERVICE LIMITED
Dhanwant PatilDhanwant Patil
Software Developer at Capgemini Technology Service India LimitedSoftware Developer at Capgemini Technology Service India Limited
EKTA JAISWALEKTA JAISWAL
Analyst at Capgemini Technology Service India LimitedAnalyst at Capgemini Technology Service India Limited
Janvi Jagannath ParabJanvi Jagannath Parab
Deputy Manager – Finance and Accounts at MAHINDRA SUMMIT AGRISCIENCE LTD.Deputy Manager – Finance and Accounts at MAHINDRA SUMMIT AGRISCIENCE LTD.
Parikshit ParabParikshit Parab
Techno Functional Senior Talent Acquisition at Kale Logistics SolutionsTechno Functional Senior Talent Acquisition at Kale Logistics Solutions