Having ~ 10 years’ expertise in month-end, quarter-end, and year-end closing processes. Proven track record in ensuring accurate reporting through proactive problem-solving and specialized knowledge of Portfolio Management System (PMS) subsystems. Skilled in reconciliation, feed file management, and team leadership. Adept at leveraging technology tools like SAP Business Objects and S4 Hana for data analysis and reporting. Excellent communicator, focused on client satisfaction and team collaboration.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Management Trainee (4A)
GENPACT
Gurgaon
01.2014 - Current
Technical Expertise-
Data analysis, data reconciliation and data visualization using Power BI and PPT dashboard
Automating tasks using Excel Macros
Migrated dashboards from excel to Power BI
Wrote power BI DAX formulas
Data collection, data cleaning and transformation
Finance and banking Domain Expertise-
Ensuring Successful Month end, Quarter and year end closing and reporting through pro-active approach and expertise
Ensuring feed files to flow correctly at the time of GL close through PMS subsystem interface
SME for PMS Specialized CDR’s reconciliations i.e
Unapplied Cash, Inter Company, Mechanical Suspense and Conversion Clearing
Ensuring correct accounting and error solving in PMS by having the feeds moved to the correct account
Have been instrumental performer starting from transitioning till simplification
Preparation of GL reconciliations & Bank Reconciliation with the help of using Business objects software (SAP) and S4 Hana tool
Helping Finance & Accounting team and Cash team in identifying and closing the open items
Ensuring all the reconciliations and open items are closed within the recs cycle of 25 days
Worked on database tool to pull the desired data for further analysis from the data ware tool business objects (Business objects 4.1 & 4.3)
Worked on database tool S4 Hana for further analysis from the data ware tool Business objects
Preparing and discussing the monthly process Dashboard with the client
Prepare & upload MJE’S in Subsystem and GL
Preparation of templates for various reconciliations to report out to clients
Prepare mass allocation for all the manual journal entry
Preparing and managing workflow forms in Support Central community
Maintaining and updating Hardcode Logic for feed posting to GL to get the feeds posted to correct place in GL
Preparing monthly securitization reconciliation and make wires sent to Trust are correct
Preparing Anomaly reporting on weekly basis to identify any suspicious activity in the system which has helped in identifying multiple projects
Annual SOP review and approval with Client
Worked with client to prepare and setup the reconciliation process for Securitization
Involved in the GE Capital LCD (Last Calendar Day) project in which GE moved from Fiscal calendar to Last Calendar Day for closing
Worked on UAT testing during conversion GE Capital to BMO to ensure all the application should work properly on Day 1 live production environment, since this is the first and critical step during conversion and it was appreciated by client, my supervisor and stakeholders
Worked with client and IT team on migration from IBM to AWS with high accuracy
Supported Booking team in extensions during very high volume during covid period.
Team Leading Expertise-
Ensuring team to complete their 1 on 1 on monthly basis
Making sure team is 100% cross-trained and no impact on deliverables
Ensuring Monthly Incentives are given to team members as per the rating after doing 1-on-1
Preparation of resource capacity utilization tracker
Process Associate
Capgemini Business Services (India) Limited
Bangalore
10.2010 - 05.2012
I have work experience in Capgemini Business Services (India) Limited in R2R process
I worked on Fixed Asset Reconciliation on SAP tool
Job responsibilities: Maintaining Fixed Assets register beginning of every month
Created of WBS according the Capex proposal, Disposal/retirement of fixed assets, creation of new assets, link of assets with WBS in SAP
Closing of Fixed Assets i.e
Month end process
Prepared fixed Assets AUC Accounts ageing analysis, AUC transfer, Capitalization, depreciation of assets, periodical posting and Offset Journal; Ensuring that all the asset transactions are posted as per SCOA
Reconcile the balance of fixed asset register and General Ledger by ensuring balance matching
Handling end to end General Ledger Process of Accounting
Preparing & Reporting Bank Reconciliation Statements (BRS) on weekly and Monthly Basis
Analysis on aging transaction in BRS
Clearing cash book entries with corresponding Bank entries of different Companies
Investigating and booking Journal entries with consulting internal and onshore team
Updating aging transaction list in BRS and highlighting to onshore for further action
Preparing Bank and Treasury related Journal Vouchers, uploading and posting those in SAP
Uploading Bank statement on Daily basis
Manual Updating Bank statement in the system
Processing Provision and Accrual Journals
Uploading BRS in UNIREX on Bank account wise every month.
Education
PGDBA - Finance
Symbiosis
Pune
05-2013
Bachelor of Commerce - Accounting And Finance
Maharani Lakshmi Ammani Women's College
Bangalore
06-2010
Skills
Domain Knowledge: (Record to Report) R2R, GL Reconciliations
Team Leading skills: Team building, Strategic planning, Decision making, Conflict resolution, motivation, Time management, Performance management, Change management
Database: S4 HANA, MySQL
Language: VBA
Data Visualization tools: Power BI
SAP tools: SAP Identity Provider (IDP), S4 Hana, Business Object
Certification
Microsoft Power Business Intelligence (BI) data analyst associate
Certified QPA from Genpact (Quick Program Automation)
Certificate Course in E- Commerce (Passed with 77%)
Tally 7.2 & 9.0 with VAT (Passed with ‘A’ Grade)
Accomplishments
Appreciated by client, external stakeholders & got rewarded for the preparation of automated mass allocation for various manual journal entries which saves huge time & reduction of cost to the company
Received multiple awards and appreciation from client and leadership team for thinking out of the box and bringing multiple simplifications in the process