Oracle Financial Consultant -general Ledger Lead Resume
2.00/5 (Submit Your Rating)
Tampa -, FloridA
SUMMARY
- 8 years of professional experience as an Oracle applications functional consultant.
- Understanding of 11i and R12 financials GL, AP, PA, CM and FA.
- Working and process knowledge of General ledger (GL), Accounts Payable (AP), Purchasing (PO), Accounts Receivable (AR), Fixed Assets(FA) and Cash Management(CM) in multi - currency environment.
- Knowledge of end to end process like Procure to Pay (P2P) and Order to Cash (O2C).
- Understanding of concepts of flex-fields, Chart of accounts (COA), Multiple reporting currencies (MRC), Global consolidation system (GCS)
- Understanding of the multi org set up.
- Ability to understand and use new technologies quickly with flexibility to adapt to changing priorities.
- Excellent documentation and presentation skills with experience in using Application Implementation Methodology (AIM) tool.
- Experience in performing Oracle administrative support and security functions like maintaining users, responsibilities, cross validation rules, security rules, profile options, menu etc.
- Ability to define custom reports across the various financial modules.
- Adaptable to new technologies and changes. Proactive in thought and action.
- Full life cycle implementation experience in Oracle Release 12
- Experienced in functional requirements analysis, Production support, Training business users, Testing and documentation
- Well experienced in Oracle application implementation methodology (AIM)
- Excellent documents preparations including module design document MD050 and also user manual documents for all Modules .
- Experienced in conducting dashboard reviews, escalation management and process streamlining.
- Good knowledge of Financial statements like balance sheet statement
- Experience in system administration tasks like creating users, menus, forms and profile options
- Conducted link system and integration testing and involved with user acceptance testing
- Flexible to adapt to new environment with a strong desire to keep pace with the latest technologies.
- Ability to work multiple tasks in a fast-paced environment independently
- Outstanding team player with great interpersonal and communication skills.
- Knowledge of Sub Ledger Accounting (SLA)
- Full cycle implementation of GL Module.
- Configured AP and created the Procure to pay process.
- Project Management for various countries in Citi Group Project
- Team Lead for a team of 11 members
- Understanding As-Is Business Process, Designing To-Be Business Processes. Gathering business requirements, performing gap analysis and setup modules
- Ability to do analysis on reports and create custom reports for senior leadership.
- Understanding of PSQL/ SQL and uses the same to query back end tables
- Knowledge of back end oracle Tables.
- Work with business users to identify system issues and suggest improvements or alternatives.
- Ability to evaluate and analysis Gaps and recommend workaround to meet business requirements.
- Ability to do analysis on current process and recommend improvements to reduce costs and increase efficiency.
- Reconciliation of financial statements.
- Ability to manage multiple projects simultaneously from idea to Production/Go-Live for Major Projects.
- Extensive knowledge of project delivery with Agile/Scrum delivery methodology and task tracking through Jira Tool.
- Ability to work remotely while taking ownership of task timeline and milestone completion with no supervision.
- Started requirement gathering for Cloud update project
- Knowledge of source to pay cycle.
TECHNICAL SKILLS
- SQL/PSQL/LINUX/UNIX/MS VISIO/ ADVANCED EXCEL/DATA LOADER
PROFESSIONAL EXPERIENCE
Oracle Financial Consultant -General Ledger Lead
Confidential, Tampa - Florida
Responsibilities:
- Requirement gathering, analysis and preparation of MD050 documents for various countries including Singapore, Philippines, Malaysia, Venezuela, Costa Rica, Nigeria, Peru, Chile, Vietnam, Bangladesh, Turkey, Bahrain, Qatar, Ukraine, Germany, United Arab Emirates and Tunisia.
- Set up ledgers for various countries as above
- Set up of Procure to pay system to various countries to automate the procurement process.
- Testing of Procure to pay flow
- Testing of General Ledger set ups to ensure timely and accurate ledgers
- Analysis of data from the legacy system to prepare interfaces maps.
- Mappings of data to derive legacy values
- Set up of interfaces from the legacy system to oracle
- Testing of interfaces to legacy systems
- Solving interfaces issues and errors.
- Preparation of training materials and conducting training to end users
- Postproduction support
- Mentoring and training of team members
- Preparing Project Plans and updating Status on daily basis
- Running status meetings and tracking Project milestones.
- Escalating critical issues to functional Mangers for resolution.
- Coordinating meetings with offshore teams
- Trained team members on the new testing AML tool and I am an AML administrator.
- Resolving of Complicated queries on timely manner and closure of service now ticks on time.
- Created the accounting engine to enable system handle complex financial accounting.
- Analysis of reports for senior leadership use.
- Analysis of potential risks to the projects and report to senior leadership.
- Creating Custom reports for management use.
- Analysis of data and suggestion of improvements to processes.
- Identifying and evaluating project bottlenecks and providing solutions based on data provided.
- Ensured all the countries implementation meet the Citi operating standards and no deviation.
- Analyzing and creating module design documentation for technical team coding.
- Used SLA to resolve specific requirements for rounding lines.
- Reviewed some interfaces with few cost centers and amalgamated into a single interface which reduced work and hours spend reconciling.
- Used Agile /scrum Methodology to deliver my project on timeline and tracked tasks through sprints and Jira tool.
- Customized various functions to meet a country’s gap with multiple branches with different currencies.
- Analyzed complex data reports utilizing Excel to identify key performance indicators to provide valuable evaluation and simplified results to senior management and various lines of business
- Leading collaborative design sessions with Process Owners/Stakeholders and SME’s.
- Managed projects scope to ensure delivery was compliant to scope commitment and budget.
- Created test scripts and coordinated user acceptance testing through the ALM tool
- Prioritized projects to be worked- monitored project budget/spending.
- Managed projects scope to ensure delivery was compliant to scope commitment and budget.
- Retrospective Planning, Product Backlog Grooming and Defect Review
- Multiple Cross Functional Collaborations.
- Process and system integrations.
- Leading collaborative design sessions with Process Owners/Stakeholders and SME’s.
- Liaison between Business, Process Owners and Development Team.
- Creating Design documents for technical team coding and review of the code through understanding of PL/SQL.
- Successfully running project meetings in the absence of project manager or Scrum Master.
- Leading collaborative design sessions with Process owners /stakeholders and SME’s
- Liaison between business, Process owners and Technical Development team.
Oracle Financial Consultant Accounts Payable
Confidential, Tampa - Florida
Responsibilities:
- Full cycle implementation of AP module to 2 different countries as the AP primary resource.
- In conjunction with project lead and in country teams, participated in contract negotiation with 3rd party vendor
- Created Design documents MD050 for inbound interface from a Government portal.
- To meet regulatory requirements, developed, tested and deployed a solution ingesting over 1000 XMLs and PDF files (Citi’s largest volume per daily) for Citi’s Source to Pay digitization program for LATAM and EMEA region (7 countries)
- Part of the project team which redesigned, implemented and tested Mexico Corporate card program from the current Banamex program consisting of 7 programs to 1 unified program where cards are issued from one legal vehicle for over 1000 employees
- Designed custom programs and reports for new applications in Citi’s Procure to Pay system LATAM region
- Managing testing cycle to include Test case/script development, training external testers and leading UAT
- Detailed documentation of User Stories, BRDs, Test Cases and designing process flow diagrams to map As-Is and To-Be processes for the new ERP system and XML interface
- Prepared and implemented a change management plan for transitioning into the new P2P system for Mexico and Belgium.
- Prepared user manuals, training guides, and conducted end user training for the new ERP deployments
- Working with offshore development team and Oracle though SRs in reviewing and implementing new patches
- Full cycle implementation on the Purchase Order Module.
- Testing and user training for Purchase order
- Created an MD050 for Amazon integration with PO module.
- Part of team testing the new integration of PO module with Amazon.
Oracle Financial Consultant Fixed Assets
Confidential, Tampa - Florida
Responsibilities:
- Full cycle implementation of FA module to different countries.
- Requirement gathering and review of local FA process.
- Reviewed category mappings for inconsistences
- Created MD050 documents for FA reports
- Created mass addition template and loaded Assets into Oracle.
- Created test scripts and coordinated user acceptance testing.
Oracle Financial Consultant
Confidential - Houston, TX
Responsibilities:
- Prepared business process flow documents for the key processes in General Ledger (GL) Accounts Payable (AP), Accounts and FA.
- Prepared RD10 (for existing financial structure).
- Prepared BR 100 (for application set up) for GL, AP and FA
- Configured and setup cash forecast and cash positioning and trained users of these functionalities.
- Prepared TE40 and TE50 and coordinated testing for GL.
- Prepared training documents for Oracle Processes of GL and AP
- Provided operational and functional training to end users
- Resolving functional queries during implementation.
- Analysis of requirements for FA module and evaluating Gaps.
- Review of FA Gaps and recommended workaround to meet the user requirement.
- Full cycle implementation of Fixed Assets.
- Provided support after implementation of Oracle.
- Full cycle implementation for AR Module.
System Analyst
Confidential
Responsibilities:
- Helped in Preparing BR 100 (application setup document) for General ledger and did a full cycle implementation.
- Gave presentation on how security and cross validation rules work upon implementation to the bank.
- Involved in setting up the COA (segments and values), SOB.
- Enabling and updating flex field contexts in AP and GL
- Performed User Accepted Testing of General ledger module and Accounts Payable.
- Trained the end users and prepared training manuals.
- Created new responsibilities and defining the profile options.
- Involved in implementation of Oracle 11i specifically GL,
- Resolved functional queries after implementation
- Educated the key users on the features of Oracle Financials