SUMMARY: 

• Certified Oracle Professional with 11+ years of experience as a Senior Oracle Financials Functional Consultant with experience in versions R12 and 11i
• As a functional lead - worked with business users and technical teams in successfully translating business requirements into functional specifications and deliverables.
• Strong in GL, AR, AP, FA, EBTax, CE (Cash Management), and Sub Ledger Accounting (SLA) within R12.
• Knowledge on Oracle fusion on all the financial modules.
• Key Business Analysis skills on requirements gathering, process flow mapping, functional specifications, design and coding, testing and impact analysis.
• Experience working with multiple stake holders distributed world-wide for Requirement gathering and functional designs.
• Proficient in Procure to Pay (P2P) and Order to Cash (O2C) tracks.
• Worked on multiple Implementations, Upgrade and Testing and Support projects, including full life cycle implementations in Oracle R12 (R12.1.3) and 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2).
• Experience in Global Consolidation Process, Multi-Currency, Revaluation and Translation. Well versed with the integration and architecture of Multi-Org (MOAC), Financial Statement Generator (FSG), Sub-ledger accounting (SLA) and extensive use of Web ADI.
• Experience on Data Conversion and Migrations life cycle. Worked in Onsite and Offshore model projects including coordinating and leading offshore team.
• Expertise in the entire Oracle implementation cycle i.e. Baseline & Requirements analysis, solution design, system configuration & set-ups, data migration, pilot testing, trouble shooting, implementation, roll out, user training and post implementation support.
• Experience in complete software product development life cycle (SDLC): System Analysis, Design, Development, Testing and Deployment.
• Good understanding of the AIM implementation methodology: BP040, BP080, BR100, MD50 documents.
• Experience on E-prentise for Chart of Account Conversion Projects.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.

TECHNICAL SKILLS:

Oracle Applications: Oracle 11i & R12 - GL (SLA), AP, AR, FA, CE, EB-Tax

Documentation: AIM Methodology (Scope, Business Process, Business Requirement, Conversions, Mapping).

Database: Oracle 9i/10g/11g, MS SQL SERVER.

Operating Systems: Windows (95, 98, XP, NT, Vista, 7), Linux.

Other Tools: MS Office 2003/2007/2010, MS Visio 2007, Use of SQL Developer, Web ADI, Data loader, E-Prentise and XML publisher

PROFESSIONAL EXPERIENCE: 

Confidential, Scranton, Pennsylvania

 Solution Architect

Responsibilities:

• Upgrading from 11i to R12 applications.
• Captured business process using AIM methodologies. Preparing and maintaining the wish list by priority
• Hands on involvement in preparation of test scripts (TE40) for all business areas in GL, AP, P2P and O2C Cycle.
• Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Set up Revenue Recognition Invoices to recognize the revenue in advance and arrears
• Chart of Account Conversion by using tool ePrentise
• Designing the mapping sheets as per the enterprise standards as per the new COA structure
• Preparing the pre and post ePrentise activities
• Configuring the broken configurations.
• Coordinating with technical team on development of custom objects.
• Working on testing defects, process flows that comes up as part of system integration testing.
• Working on onsite and offshore model
• Defining the new COA structure and creating the one-many and many to one mapping in ePrentise.
• Provided Solution on Misclassified accounts and solved exceptions that were raised as part of conversion.
• Guided users and business in SIT CRP and UAT in testing Phase

Environment: Oracle Applications E-Business, Oracle R12.1.3, Oracle Financials, GL, AP, AR, Procure to Pay (P2P), Order to Cash (OTC), Cash Management (CE).

Confidential, Cincinnati, OH

Solution Architect

Responsibilities:

• Chart of Account Conversion by using tool e-prentise
• Designing the mapping sheets as per the enterprise standards as per the new COA structure
• Preparing the pre and post eprentise activities
• Configuring the broken configurations.
• Coordinating with technical team on development of custom objects.
• Working on testing defects, process flows that comes up as part of system integration testing.
• Working on onsite and offshore model
• Using HPQC for SIT and assigning the necessary defects raised by business to the appropriate team and guiding them in solving by providing the appropriate solutions.
• Defining the new COA structure and creating the one-many and many to one mapping in eprentise.
• Provided Solution on Misclassified accounts and solved exceptions that were raised as part of conversion.

Environment: Oracle Applications E-Business, Oracle R12.1.3, Oracle Financials, GL AP AR, SLA

Confidential, Seattle, WA

Lead Oracle Financials Functional Consultant

Responsibilities:

• Participated in designing, configuring and testing of AWS project Roll outs.
• Participated in GEO expansion of Amazon Roll outs.
• Driven the SIT and UATs with users and got Sign offs from them
• Configuration of all financial modules (AP, AR, GL, FA, I expenses) provided functional support
• Resolving the Issues or Errors as per the Severity level and as per the Service   Level Agreement with the Client.
• Participated in understanding the requirements and business processes from the requirement gathering team and business users
• Provided training to key user community and supervised that knowledge being transitioned to the end user community
• Responsible for obtaining signoff on business processes and custom components from users after regress testing

Environment: Oracle Applications E-Business, Oracle R12.1.3, Oracle Financials, GL AP AR, I expenses

 Confidential, Minneapolis, MN

Lead Oracle Financials Functional Consultant

Responsibilities:

• Defined, Configured and implemented Chart of Accounts, Value Sets, Ledger, Security Rules, Cross Validation Rules, Calendar, Journal Source, Journal Category.
• Hands on involvement in preparation of test scripts (TE40) for all business areas in GL, AP and P2P. Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Set up General Ledger, consolidation ledgers, AGIS for intercompany transactions, FSG reports (Income statement, Cash flow statement, and Balance sheet statement.
• Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets. Prepared BR.100 Application setup and MD.50 Application Extensions Functional.
• Design documents according to AIM. Involved in configuration of CRP2, SIT, and UAT Test Instance & GOLD.
• Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment.
• Lead the offshore setups team for configuring General Ledger and Advanced Global Intercompany Systems.
• Defined supplier sites, suppliers, and banks for payable use. Defined Tax Code, Rates using E-Business Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Co-ordinate with India Offshore team on customizations development and functional testing. Involved in designing and configuring Advanced Global Intercompany Systems for Seagate companies and General Ledger. Help offshore setup teams by resolving the issues faced during configuration / development etc. Gather information from onsite and provide it to offshore for any clarifications.
• Participated in multiple business meetings for Fit-Gap Analysis and Solution. Assisted Seagate Functional lead to conduct CRP2.
• Defined Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes. Defined Payment Attributes-Payment Formats, Bank Account, Payable Documents.
• Defined supplier sites, suppliers, and banks for payable use. Defined Tax Code, Rates using E-Business Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.

Environment: Oracle Applications E-Business, Oracle R12.1.3, Oracle Financials, GL, AP, P2P, AGIS

Confidential, Houston, TX,

Solution Architect - Oracle Financials

Responsibilities:

• Captured business process using AIM methodologies. Preparing and maintaining the Requirement Traceability Matrix (RTM).
• Fixed all the financial issues during CRP, SIT, UAT and support phase. Conducted Delta Training for the users highlighting the difference between R12 and 11i.
• Fixed all the financial issues during the support phase. Setting up the MOAC functionality. Designed and implemented Payment setups including Payment process profiles, Requests Formats, XML Publisher Templates and Bank accounts to facilitate the Check and EFT Payment process with WELLS FARGO and bank of America.
• Setup of Special calendars and Recurring Invoices. Supporting the users on daily business issues and Bugs.
• Managed Technical Assistance Requests (TAR's) on-line Oracle Metalink. Analysis of processes and Solution Design for addressing gaps identified.
• Setting up the secure 32 format in payables by using check payment method. Resolve user’s issues in using WEBADI.
• Configured Regime-Rate tax setup for US Sales taxes. Design and Implement GL Journal Entry Approval. Resolve Many to Many Intercompany posting issues by setting up default Intercompany clearing accounts.
• Resolve user’s issues in using WEBADI. Master data mapping and conversion from Legacy to Oracle. Preparation of Basic Requirement Documents (BR 100’s) and Preparation of Test Scripts for User Acceptance Testing (TE 40’s), MD 50 for the Project.
• Worked on customization of SLA. Defined setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes.
• Defined Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets.
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources.
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets.
• Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes. Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos.

Environment: Oracle Applications E-Business, Oracle R12.1.3, Oracle Financials, GL AP AR, SLA