KOMAL GUPTA
New Delhi
Summary
Dynamic Financial Analyst with a proven track record at Omnicom Media Group, excelling in data analysis and financial reporting. Expert in Oracle and Microsoft Excel, I drive impactful budget forecasting and variance analysis, fostering team collaboration to enhance operational efficiency. Passionate about transforming complex data into actionable insights for strategic decision-making.
Overview
6
6
years of professional experience
Work History
Financial Analyst
Omnicom Media Group
Gurugram
06.2024 - Current
- Prepare the company’s total AR dashboard, wherein total outstanding invoices are being analyzed based on what is past due, which payments have been received, the total number of invoices being booked, and with a proper commentary for the deviations compared week by week; all of this is pulled through Oracle.
- Work closely with various clients on various issues, or any research to do in projects.
- Prepare the company’s Open Account Payable report, wherein the total outstanding invoices expense is being analyzed based on what is past due, which payments have been received, the total number of invoices being booked, and with a proper commentary for the deviations compared week by week.
- Extracting and maintaining various queries that are used by clients to perform critical deliverables.
- Investigate and research open items, and follow up or escalate with different teams to get a resolution for the same.
- Prepare the cash forecasting report, wherein I perform budget vs. actual analysis, with brief commentary.
- Prepare the company’s Unbilled Dashboard, wherein we track the invoices not yet billed or approved by assigned approvers, to take follow-up and get the process done as soon as possible.
- Standardizing the portfolio, along with reducing manual efforts by automating the portfolio.
- Manually tracking the payments received, which are pulled from Oracle and loaded into R1 daily, and then comparing those with what was expected.
- Responsible for maintaining different types of receivables trackers for various clients, and then summarizing them in a more visual way to have a better presentation.
- Perform SOX commentary each quarter.
- Doing budgeting and forecasting annually for all the customers, and performing variance analysis.
Senior Financial Analyst
R1RCM
Gurugram
05.2021 - 06.2024
- First, we start with the actual receivables data report analysis, which is being fetched by HFM Oracle, and compare each market's data from the previous year or quarter.
- Then, after the actuals are finalized and all the markets are reviewed and closed, we move to reforecasting.
- Then we do variance analysis from year to year, quarter to quarter, along with a brief commentary on the ups and downs in the market’s receivables.
- We track another report of wins and losses, wherein the markets that we have won or lost are tracked for the brands that Omnicom provides services to.
- There are different regions for the markets, and we also connect with them for deep-dive analysis on high fluctuations.
- Preparing SOPs each quarter.
Genpact Limited
07.2019 - 05.2021
- Company Overview: Services. Genpact serves clients in various industries including banking and financial services, insurance, capital markets, healthcare, life sciences, consumer goods, and retail.
- To ensure successful completion of period end close activities followed with adhering to the agreed close schedule and that accounting policies are complying.
- Prepared two reporting’s FIS signature report in which post the general entries for all the transactions done by clients through signatures and other reporting was FIS PIN in which only transactions done by using pin through ATM cards were recorded. After report finalisation the entries are loaded in people soft software.
- Work closely with various Clients to understand business transactions and ensuring that they are processed and accounted for in appropriate category of account.
- Extracting and maintaining various queries which are used by clients to perform critical deliverables.
- To perform account reconciliations to clear the open items from people soft we pull the loaded data in excel to perform the reconciliation.
- Ensuring appropriate accounting treatment, completeness and accuracy related to general accounting along with preparing inputs for journal processing.
- Develop and implement internal controls and procedures.
- Standardizing the portfolio along with reducing of manual efforts by automating the portfolio.
- Manually loading the sub-ledger feed on the reconciliation tool (Recon+) using the bulk load template from Version One.
- Responsible for accurate processing of manual journals for various activities along with other variance close outs in Global One (people soft).
- Preparing SOP’s each quarter.
- Services. Genpact serves clients in various industries including banking and financial services, insurance, capital markets, healthcare, life sciences, consumer goods, and retail.
Education
PGDM in Finance -
IMT Ghaziabad
Ghaziabad01.2023
B. Com (Honours) -
Zakir Husain Delhi college (E), University of Delhi
New Delhi01.2019
Class XII - CBSE
Red Roses Public School
New Delhi01.2016
Class X - CBSE
Red Roses Public School
New Delhi01.2014
Skills
- Microsoft Excel
- Oracle
- HFM
- Essbase
- PeopleSoft
- PowerPoint
- Power BI
- Data analysis
- Financial reporting
- Dashboard creation
- Variance analysis
- Budget forecasting
- Team collaboration
Affiliations
- Project in Omnicom: build the dashboard report from scratch using raw data, leveraging pivot tables, and charts that represent the total outstanding accounts receivable for all the regions we deal with, doing analysis with a brief commentary on the variances from week to week
- Project in R1RCM: Faced with inefficiencies caused by multiple, scattered Excel sheets, I implemented a streamlined process improvement by consolidating numerous files into a single master spreadsheet, I leveraged data validation and advanced filtering techniques to organize data by year and month This eliminated manual sorting, reduced errors, and significantly improved productivities team could now retrieve reports instantly, making data analysis effortless and efficient.
Timeline
Financial Analyst
Omnicom Media Group
06.2024 - Current
Senior Financial Analyst
R1RCM
05.2021 - 06.2024
Genpact Limited
07.2019 - 05.2021
PGDM in Finance -
IMT Ghaziabad
B. Com (Honours) -
Zakir Husain Delhi college (E), University of Delhi
Class XII - CBSE
Red Roses Public School
Class X - CBSE
Red Roses Public School
Similar Profiles
Harleen KaurHarleen Kaur
Regional Client Lead at Ptarmigan Media (Part of Omnicom Media Group)Regional Client Lead at Ptarmigan Media (Part of Omnicom Media Group)
Sahil VermaSahil Verma
Associate Director at PHD Media - Omnicom Media GroupAssociate Director at PHD Media - Omnicom Media Group
Olivia BeringerOlivia Beringer
Senior Research Director at PHD Media, Omnicom Media GroupSenior Research Director at PHD Media, Omnicom Media Group
Deepayan MaitraDeepayan Maitra
Lead Designer Trainer, Lead Designer Digital, Subject Matter Expert at Annalect - Omnicom Media GroupLead Designer Trainer, Lead Designer Digital, Subject Matter Expert at Annalect - Omnicom Media Group
Rohit PajhalRohit Pajhal
Director Network Operations at Indian Air ForceDirector Network Operations at Indian Air Force