R (Programming Language)
Pranvi Ahuja
Data Analyst
Australia,VIC
Summary
Detail-focused graduate with a Master of Analytics from RMIT University, Melbourne. Well-versed in various statistical methods such as descriptive and influential statistics. Independent and versatile individual skilful in identifying data issues and monitoring existing metrics with over 2.5 years of experience at Ernst & Young, Global Delivery Services and KPMG India.
Overview
5
5
years of professional experience
5
5
years of post-secondary education
2
2
Languages
Work History
Customer Service Analyst
Mgallery Hotel, Accor Group Of Hotels
Melbourne, VIC
05.2022 - Current
- Used statistical methods to analyze customer satisfaction data collected by review forms filled by guests and generate useful business reports and models.
- Develop analytical insights which may be used by internal stakeholders to improve the safety and stay of our customers.
- Going through day-to-day statistical percentages of occupancy of hotels on Opera software and performing analysis on same as previous years and working on customer strategy to increase revenue by 20% next year.
- Maintained customer satisfaction with forward-thinking strategies focused on addressing customer needs and resolving concerns.
Student Intern - Data Analyst
Meals With Impact
Melbourne, VIC
08.2022 - 11.2022
- Gathered relevant and up-to-date Australian Bureau of Statistics data by performing intensive research and assisted with the management and processing of source data.
- Develop Power BI reports providing internal stakeholders with the ability to self-serve for data requests, and quickly identify trends in data.
- Presented data in easy, informative and interactive dashboards using Power BI which increased the chances MWI team getting a government grant of more than 10000$.
- Followed up with the MWI team regularly and provided recommendations to improve analysis and get better numbers.
- Communicated effectively with faculty and staff and accepted critiques and suggestions for areas of improvement.
Senior Assurance Associate
Ernst & Young, Global Delivery Services India LLP
Gurgaon , India
09.2020 - 12.2020
- Analyzing and data visualization on numbers provided in Procure to Pay and Cash processes for 3 clients in USA.
- Using Data wrangling techniques in order to clean data provided by US clients before proceeding further.
- Analyzing company financials with previous years on EY Helix using various internal and MS Excel formulas.
- Performed detailed comparisons of reports and physical documents.
Experienced Assurance Associate
Ernst & Young, Global Delivery Services India LLP
Gurgaon, India
11.2019 - 09.2020
- Assisted onshore team in Control Testing and Substantive Tasks such as Cash and Bank Reconciliation, Fixed Assets Testing and Equity Reconciliations
- Performed Legal Review and Consolidation Packages and configured analytic reports to assess workflow processes.
- Validated Financial Statements of various companies along with preparation of over 10 necessary audit work-papers.
- Reconciled transaction processing to promote data accuracy.
Risk Analyst
KPMG India
Gurgaon, India
06.2018 - 09.2019
- Performed Analysis and Internal Audit of various processes in some of Indian Retail Clients and visualized findings on Power BI.
- Through multiple techniques, found loopholes in current system and suggested future improvements by performing and detailed research and analyses.
- Prepared over 100 flowcharts using Standard Operating Procedures and metadata provided in Microsoft Visio.
- Developed short-term goals and long-term strategic plans to improve risk control and mitigation by Internal Financial Controls (IFC) and Sarbanes-Oxley (SOX) testing.
- Gained training and knowledge for analyses on SAS programming, analytics and influential communication.
Education
Master of Analytics - GPA: 3.5
RMIT University
Melbourne 03.2021 - 12.2022
Bachelor of Commerce - Accounting And Business Management
University of Delhi
India 07.2015 - 07.2018
Skills
Data Wrangling
undefinedWork Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Student Intern - Data Analyst
Meals With Impact
08.2022 - 11.2022
Customer Service Analyst
Mgallery Hotel, Accor Group Of Hotels
05.2022 - Current
Master of Analytics - GPA: 3.5
RMIT University
03.2021 - 12.2022
Senior Assurance Associate
Ernst & Young, Global Delivery Services India LLP
09.2020 - 12.2020
Experienced Assurance Associate
Ernst & Young, Global Delivery Services India LLP
11.2019 - 09.2020
Risk Analyst
KPMG India
06.2018 - 09.2019
Bachelor of Commerce - Accounting And Business Management
University of Delhi
07.2015 - 07.2018
Software
Python
SAS
SQL
Microsoft Power BI
Tableau
Microsoft Excel
Microsoft Visio
Similar Profiles
Venkatesh RavanlaVenkatesh Ravanla
Cluster Finance Supervisor at The Canvas Hotel - MGallery By AccorCluster Finance Supervisor at The Canvas Hotel - MGallery By Accor
TALITUA LEOTALITUA LEO
Receptionist at HOTEL IBIS WELLINGTON, Accor Group Of HotelsReceptionist at HOTEL IBIS WELLINGTON, Accor Group Of Hotels
Kunal KapoorKunal Kapoor
Commis Chef at Ibis Hotel, Accor HotelsCommis Chef at Ibis Hotel, Accor Hotels