Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Awards
Personal Information
Timeline
Generic
Dharmendra Sisodia

Dharmendra Sisodia

Faridabad

Summary

Oracle Financial Functional Consultant with expertise in Oracle Cloud GL and a proven track record at Mercer India. Demonstrated ability in cross-functional collaboration and strategic problem-solving, leading to process improvements. Recognized for enhancing customer satisfaction and increasing team efficiency by 20% through innovative solutions. Strong work ethic and adaptability, with a focus on mastering new skills independently.

Overview

14
14
years of professional experience

Work History

Lead (Team Handling/function support)

Mercer India
Gurgaon
02.2022 - Current
  • Resolved interface issues related to sub-ledger and legacy systems.
  • Contributed innovative ideas and solutions to enhance team performance and outcomes.
  • Completed day-to-day duties accurately and efficiently.
  • Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
  • Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
  • Executed troubleshooting, support, and maintenance tasks for general ledger (GL).
  • Analyzed technical flow of GL in Oracle Apps R12.
  • Developed SQL queries to extract data based on user requirements, such as five-year balances and transaction details.
  • Managed daily GL and Discoverer issues reported through tickets.
  • Defined chart of accounts, segment values, cross-validation rules, and security rules.
  • Created and processed recurring journals, reversals, and modifications according to specifications.
  • Supported migration from Oracle 11i to Oracle Cloud by updating MC50 and BR100 documents.
  • Prioritized and organized tasks to efficiently accomplish service goals.
  • Identified needs of customers promptly and efficiently.
  • Provided excellent service and attention to customers when face-to-face or through phone conversations.
  • Assisted with customer requests and answered questions to improve satisfaction.
  • Collaborated closely with team members to achieve project objectives and meet deadlines.
  • Worked with cross-functional teams to achieve goals.
  • Approached customers and engaged in conversation through use of effective interpersonal and people skills.
  • Maintained updated knowledge through continuing education and advanced training.
  • Provided support and guidance to colleagues to maintain a collaborative work environment.
  • Exceeded customer satisfaction by finding creative solutions to problems.
  • Recognized by management for providing exceptional customer service.
  • Utilized advanced technical skills and expertise to troubleshoot complex problems and implement solutions.
  • Conducted comprehensive research and data analysis to support strategic planning and informed decision-making.

Oracle Fin. Functional Cons in oracle cloud GL (Team Developer)

Bank of America
Gurgaon
01.2017 - 02.2022
  • Having complete understanding in GL oracle fusion cloud.
  • Having complete understanding of user creation in fusion and assigning roles to respective users.
  • Troubleshooting, Support and maintenance of GL.
  • Technical flow of GL in Oracle Apps 11i.
  • Creation of adhoc reports in Discoverer.
  • Creation of SQL queries and pulling data as per user requirement, like 5years balances, transactions detail etc.
  • Creation Recurring, modification and help to user as per requirement.
  • Handling the day to day issues in GL & Discoverer which come to us via tickets.
  • Understanding of GL.
  • Complete understanding of R11 Set Of book structure.
  • Support in ADI template issues.
  • Delete data from interfaces table.
  • Defining Charts of accounts, Segments values for each accounting segment, Cross validation rules and security rules.
  • Create and generate Recurring journals, reversals and modification.
  • Help to user for recognizing error (stuck un-posted journals.)
  • Delete the un-posted batch in case it is not required.
  • Running revaluation program in month-end as per schedule.
  • Dashboard.
  • Understanding of Oracle Discoverer, running reports in discoverer like modification of reports as required by business users.
  • Resolve issues of business user in reports.
  • Handling the day to day issues in GL& Discoverer, GICM module which come to us via tickets and emails.
  • Responsible for creation or modification of existing MC50 and BR100 for migrating from oracle 11i to oracle cloud, like journal upload as per requirement.

Oracle Fin. Functional Cons

CPA Global
02.2016 - 06.2016
  • Executed troubleshooting and maintenance for General Ledger (GL) within Oracle Apps R12.
  • Developed ad hoc reports using Discoverer to meet business requirements.
  • Created recurring dashboards for workflow reports, ensuring timely updates.
  • Addressed daily issues in GL and Discoverer reported through ticketing system.
  • Managed GL structure, including ledger sets and data access sets.
  • Defined charts of accounts, segment values, and established cross-validation rules.
  • Generated recurring journals, including reversals and modifications as needed.
  • Resolved user issues in reports while modifying existing MD50 and BR100 documentation.

Oracle Fin. Functional Consultant (Process Developer)

Genpact India
Gurgaon
04.2012 - 01.2016
  • Create and generate Recurring journals, reversals and modification.
  • Support in ADI template issues.
  • Delete data from interfaces table.
  • Delete the un-posted batch in case it is not required.
  • Revaluation program (GSS program) and taxes (Tax Memo, Foreign tax, Domestic tax (US Tax program)).
  • I define the various Receivable activities for Receipt Write off, Unearned or Earned Discount in AR.
  • Troubleshooting various data issues by running reports like Transaction register, Aging Report, Adjustment Journal Report, Applied/Unapplied Receipt register.
  • Understanding of Oracle Discoverer.
  • Running Reports in Oracle Discoverer.
  • Handling the Day to Day issues in AR, GL & Discoverer which come to us via Tickets.
  • Defining Charts of accounts, Segments values for each accounting segment, Cross validation rules and security rules.

Sr. Associate

Keane India LTD.
Gurgaon
10.2011 - 03.2012
  • Maintain all PCC Code and help to book the hotel for outside client.
  • Worked on GDS (Global Distribution System): Worldspan, Apollo, Galileo etc.

Education

B.Com -

Shri Ji Baba Degree College
Mathura
07-2009

Intermediate -

Jawahar Inter College
Mathura
06-2006

High School - Math

Sarvodaya Inter College
Mathura
06-2004

Skills

  • ERP systems
  • Oracle Cloud GL
  • General ledger maintenance
  • Customer relationship management
  • Process improvement initiatives
  • Cross-functional collaboration
  • Project coordination
  • Problem solving
  • Effective communication
  • Team leadership
  • Oracle applications R11 and R12
  • Oracle Cloud Fusion
  • General ledger management
  • Oracle Discoverer 10g
  • Toad for data management
  • GL, AR, and AGIS expertise
  • Windows operating systems (2007, 2010)

Hobbies and Interests

  • Playing Football
  • Kabbaddi

Awards

  • Platinum Award Winner in Genpact
  • Gold Award Winner in Bank of America
  • Silver Award Winner in Keane India
  • Bronze Award Winner in Genpact

Personal Information

  • Date of Birth: 01/01/90
  • Nationality: Indian
  • Marital Status: Married

Timeline

Lead (Team Handling/function support)

Mercer India
02.2022 - Current

Oracle Fin. Functional Cons in oracle cloud GL (Team Developer)

Bank of America
01.2017 - 02.2022

Oracle Fin. Functional Cons

CPA Global
02.2016 - 06.2016

Oracle Fin. Functional Consultant (Process Developer)

Genpact India
04.2012 - 01.2016

Sr. Associate

Keane India LTD.
10.2011 - 03.2012

B.Com -

Shri Ji Baba Degree College

Intermediate -

Jawahar Inter College

High School - Math

Sarvodaya Inter College
Dharmendra Sisodia