Consultant Resume Profile
| ORACLE E-BUSINESS SUITE TECHNO FUNCTIONAL CONSULTANT FINANCE |
| Experience Summary |
- Around eight and a half year of experience in the Implementation, Upgrade, Enhancement and Support of Oracle Financials ERP.
- Experience in all phases of the system development and implementation life cycle.
- Proficient in understanding business processes/requirements and translating them into functional and technical specifications.
- Excellent exposure to Oracle Financial Accounting Hub FAH and Sub-ledger Accounting SLA design for Banking Services industry.
- Strong experience of custom development including Interfaces, Conversions, Workflows, BI Reports, Extensions and Integration with 3rd party systems.
- Team Player, Self-Driven, Quick Learner and Excellent Analytical Communication skills.
- Oracle Certified Professional in R12 General Ledger and Account Payables.
- Oracle Certified Associate Consultant in 9i SQL, PL/SQL.
| Skills Summary |
- ERP Systems: Oracle Financials E-Business Suite 11i and R12. Modules - FAH , SLA, GL, PO, AP, AR, Projects
- Programming Tools: SQL, PL/SQL, Oracle Workflow, Oracle Reports, BI Publisher
- Data base: Oracle 9i, 10G
- Administration/Tools: TOAD, PL/SQL Developer, SQL Plus, HP-QC
- Operating Systems: Windows, UNIX
| Professional Experience |
Confidential
Project Description:
The project envisages implementing Oracle R12 FAH and GL module to act as a consolidated hub for client's all accounting data and regulatory reporting requirements. The objective is to integrate client's all external Source systems with Oracle R12 FAH and GL module in phases as wells as integrate Oracle 11i GL, which is their current Oracle EBS environment, with R12 GL.
Role: FAH Design Lead. Responsibilities include:
- Liaising with the Legacy Systems, understanding the business/accounting process and conceptualizing/mapping the same in Oracle domain.
- Work on Business Requirement definitions and Event Model for accounting scenarios such as FAS91, Unfunded Commitments, Non-Accrual accounting, and statutory accounting.
- Serve as a liaison across the Line of Business, Wells Fargo Corporate Controllers, and the Deloitte offshore development team.
- Support development and testing.
Confidential
Project Description:
Invesco Finance and Corporate Services FCS had embarked on a financial transformation initiative to meet the future SOX compliance rules and better integrate with other 3rd party systems. The company worked on Oracle 11i platform consisting of multiple environments, COA structures and a non-integrated consolidation process. As such, FCS transformation was to re-implement its ERP system with Oracle R12 enabling a single global platform with single COA structure and new multi-org set-up.
Role: Conversions Track / GL Functional Lead. Responsibilities included:
- Business requirement analysis and solution design and architecture.
- Design of R12 OU, Ledger and GL Accounting Setups.
- Effort estimation analysis and coordination with Technical team on design and delivery of RICEW objects.
- Coordination on Conversion cycles including SIT and UAT and Defects resolution.
- Design and development of Chart of Accounts COA Mapping Utility for mapping 11i COA structure to R12 COA structure.
Confidential
Project Description: Re-implementation of Oracle R12.1.3
Role: Oracle Projects Billing Consultant. Responsible for:
- Liaising with client's business team, requirement gathering and solution design.
- Functional design preparation and walk-through, and Technical design reviews.
- Design of custom Year End Auto-close process for Oracle Projects/Contracts having zero unbilled revenue.
- Design of a custom solution for showing the current obligation, commitment and expense accounts balance for each project and tasks/subtasks combination.
- Customization of Oracle Projects Client Extensions to meet the client's business processes.
- Customization of Oracle Account Generators Budget, Invoice, Purchase Order Requisitions .
Project TMSE - GAIA Program
- Company: Deloitte Consulting India Pvt. Ltd
- Client: Toshiba Medical Systems Europe
- Location: Zoetermeer, Netherlands
- Project Type: Upgrade R12.1.3
- Duration: Mar, 2012 - Dec, 2012
- Client Description:
- With headquarter in Zoetermeer, The Netherlands Toshiba Medical Systems Europe TMSE B.V. is part of the Toshiba Medical Systems Corporation. TMSE markets, sells, distributes and services diagnostic imaging systems, and coordinates clinical diagnostic imaging research for all modalities in Europe.
- Project Description:
- The main objective of TMSE - GAIA Program was to make TMSE IFRS compliant across all the 11 European entities which were in scope of phase-1 of the GAIA project. The project aimed to utilize the designs and platform of the existing 11i system of the Oracle EBS Package and re-implement the system, using as much standard R12 functionality as possible without losing business functionality and efficiency.
Role: EBS Techno-functional Consultant. Responsibilities included:
- Analyze existing stack of technical components in 11i environment and their re-usability in R12.
- Perform fit-gap and impact analysis for R12 upgrade.
- Deploy the existing / modified solution in R12.
- Prepare technical design documents such as MD70, UTP, MD120 and traceability matrix.
Confidential
Project Description:
The project aimed at implementing Oracle R12 Financial Accounting Hub FAH module to integrate various non-Oracle subledger applications Source Systems with Oracle R12 GL. The objective was to house all the accounting information in Oracle R12 General Ledger for better regulatory reporting and compliance.
Role: R12 EBS Financials Techno-functional Consultant. Responsibilities included:
- Liaising with the Legacy Systems, understanding the business/accounting process and conceptualizing/mapping the same in Oracle domain.
- Setting up the Process and Design Documents. Involved in creation of BR100, MD50, MD60 and MD70 documents.
- Design and development of custom POA Inbound Process to process the external subledgers accounting data in form of Pass-through/Event to Oracle GL using FAH and SLA Create Accounting Process.
