PROFESSIONAL SUMMARY:

• Nine years of experience with multiple projects in Oracle Implementation, Upgradation and Post Production support in both 11i and R12 versions.
• Worked extensively on General Ledger (GL) including AGIS and SLA, Accounts Payable (AP) including Payments (IBY), Accounts Receivables (AR), E - B.Tax, Cash Management (CE), Fixed Assets (FA), iProcurement, Purchasing (PO), Order to Cash (O2C Cycle), Procure to Pay (P2P Cycle) and Acquire to Retire (A2R Cycle).
• Good understanding of SOP and USGAAP accounting.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical or functional issues.
• Experience in developing, modifyind and customizing FSG reports using FSG generator.
• Experience in Multi - Org Application architecture, AME Approvals Management, Oracle Tutor, Oracle User Productivity Kit (UPK), Built-in Workflow and Web ADI.
• Experience in documentation using Oracle Tutor, Oracle UPKs and AIMs BP040, BP070, BP080, RD010, RD020,, RD050, BR010, BR030, BR100, BR110, TE040, MD050, and MD070 etc
• Experience in workflow approval process and integration experience in modules like GL, AP, Purchasing, Inventory, Order Management and iExpenses.
• Experience in execution SQL queries on PL/SQL server tables to view successful transactions of data and for validating data.
• Experience in Data Conversions/Migration and design of function specific document of data (Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and open receipts) from Legacy to Oracle.
• Experience in supporting/enhancing the Oracle E-Business Suite, Release 11i for Oracle Financials.
• Experience in gap analysis, future business process study, as per the requirements of project, and preparing scripts for Functional Documents (MD50) and experience in extensive testing of component and integration before Go Live.
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through financial closing; revenue and expense cash/accrual concepts; adjustments and financial statements.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual. Sound understanding of the business processes as well as a strong working rapport with business users
• Demonstrated good leadership skills with inspirational attitude with result oriented approach.

TECHNICAL SKILLS:

Oracle Applications: 11i &R12, GL, AP AR, FA, iProc, PO, CE, E-B Tax.

Languages and Tools: PL/SQL, SQL, HTML, Web ADI, Data Loader.

Knowledge on other Modules: iExpenses, iSupplier, INV,WIP, BOM.

Applications: MS office, MS Visio, Oracle Tutor, UPK.

Miscellaneous: CAD, CAM, PRO-E, ANSYS, CATIA.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta - GA

Oracle Financials Functional Consultant

Responsibilities:

• Analysed gaps and provided solution as per new business requirements and existing solution print.
• Worked extensively on COA design initial solution print.
• Configured application and updated BR100 for GL, AP, AR, SLA, E.B Tax, FA, CE and Projects
• Implemented iProcurement as per new solution design including punchouts and configured AME for requisition approvals.
• Provided functional design and prepared MD070 for customization of Revenue recognition for progress and non-progress billing, as per SOP 81-1 and SAB 104 standards.
• Provided functional design and prepared MD070 for customization of credit memo approval process in Project billing.
• Provided functional design and prepared MD070 for customized integration of Order Management with Project Billing for delay time and shipping information to recognize revenue.
• Provided functional design for customized report of Project Billing draft invoices with tax details.
• Provided functional design to limit who can update PA billing events based on key members functionality.

Confidential, Omaha - NE

Oracle Financials Functional Consultant

Responsibilities:

• Worked extensively in Upgradation of Oracle applications (GL, AP, AR, PO, iProc, FA, CE) from 11.5.10 to 12.2.3.
• Performed interview sessions with end users for ASIS process analysis and documented ASIS processes BP040.
• Provided solution design for existing and changed business processes according to SOP and USGAAP standards with documentation of BP080.
• Configured modules as per business processes and user requirements.
• Worked exclusively in configuring funds disbursement setup like, formats, templates and payment process profiles.
• Assisted technical team in configuring third party printer software by providing xml data extract as per changed output format of format payment instructions program.
• Worked on E.B-Tax in modifying migrated tax codes as per new business requirements.
• Worked on OAF personalization for personalizing iProcurement checkout and supplier creation pages.
• Worked in collaboration with technical team to resolve issues with iProcurement punchout stores.
• Modified Sql queries in AME rules as per the new AME package.
• Configured Buyers Work Centre, for Auto create Orders, receipts etc.
• Worked on work flow administration in collaboration with technical team to modify inbound and outbound setups as per business requirement.
• Worked with technical team in modifying customized package to load data into expense report tables for expense reports.
• Implemented SLA and modified report templates as per user requirements.
• Worked on report manager and FSG generator to fill gap generated by the removal of client ADI.
• Conducted user training sessions and trained users for new functionalities.
• Configured pilots and conducted CRP sessions (CRP1,2&3).
• Prepared test scripts TE40 and conducted UAT sessions.
• Prepared configuration documents BR100 for all modules with respect to R12 setup.
• Prepared training materials and user guides for end users.
• Working with technical team in modifying middleware for Order entry systems and Customer APIs.
• Providing support after GO Live.

Confidential, Tampa - FL

Oracle Financials Functional Consultant

Responsibilities:

• Worked exclusively on Oracle E Business Suite (GL, AP, AR, PO, iProc, FA, CE, iExpense, E.B-TAX) implementation of R12.1.3.
• Worked on business requirement gathering with documentation of BR100 and BR150.
• Detail business process analysis and research to enhance the business process with documentation of BP40 and BP80.
• Worked in co-ordination with off shore team for identification of gaps.
• Designed the chart of accounts to meet the client’s business requirements
• Configured the MOAC, Ledger Setup, and Legal Entities
• Handled Cash/Revenue Management as per SOP81-1 and SAB 104 standards for reconciliations purpose.
• Configured AGIS for Inter-company Transactions
• Involved in customization of Journal batch summary report, Trial balance report in GL.
• Configured iProcurement along with setting up of items and catalogues.
• Configured Buyers Work Centre in Purchasing for creation of orders, receipts etc.
• Responsible in creating, supplier groups, Pay groups, and Payment terms as per payable options in Accounts Payables (AP).
• Performed funds disbursement setups including formats, templates and payment process profiles for use of Payment Manager.
• Worked on Cash Management for setting up of banks, and interbank transfers between LEs
• Worked on iExpense in setting expense templates and audit workflows.
• Worked on E.B Tax in setting up regime to rate flow for Non-recoverable and recoverable taxes.
• Handled Fixed Assets and leased assets with Fixed Assets Module and OLM (Oracle Lease Management) including Period-End Processes for further legalization processes.
• Conducted CRPs, Training Sessions to super users, and UAT sessions.
• Prepared test scripts, training material and end user guides.
• Provided post production support for bug fixing and enhancement of reports.

Confidential, Harrisburg- PA

Oracle Financials Functional Consultant

Responsibilities:

• Implemented R12 Financial Modules (GL, AP, AR, FA & CE), Acquire to Retire (A2R), Procure to Pay (P2P), E-Business Tax (EBT), iExpenses, Property Manager and integration of Account Receivable module with legacy billing system.
• AS-IS business process study of the client organization by means of observation, interviews, end to end walkthrough tests, obtaining samples business cases and documentations etc.
• Identified tasks and interrelationships to evaluate functional and cross-functional requirements.
• Identified gaps and addressed them actively in collaboration with the project team through documentation (BR010), Oracle Tutor and MS Office.
• Provided Support the ERP initiatives in design, development and implementation of plans to translate enterprise information system objectives into functional business systems.
• Prepared solution design/To-Be document as per client requirement and best practices embedded in the application using Oracle Tutor tool and AIMs Methodology.
• Conducted User Acceptance training (UAT) sessions, prepared UAT scripts (TE040) and obtained user acceptance after providing feasible solutions to issues raised within UAT sessions.
• Configured of Oracle application setup of respective modules and prepared BR-100 setup document.
• Conducted training sessions for users and prepared guides on User Productivity Kit.
• Reviewed the existing reports and collected requirements to develop additional custom reports.
• Executed SQL queries on PL/SQL server tables to view successful transactions of data and for validating data.
• Responsible for Data gathering on given templates and upload activity on systems.
• Providing post implementation support to users.
• Documents all business processes, needs, flows and diagrams.

Confidential, Charlotte - NC

Oracle Applications Techno Functional Consultant

Responsibilities:

• Responsible for requirements gathering, analysis, planning, selection, blueprinting, designing, developing, rolling out, and end-user training of BI solutions to the user community.
• Defined new organization structure and COA
• Use of SQL * Loader utility to load data from legacy system to interface.
• Defined various currencies for multi currency operations and currency translation, conversion, revaluation TEMPhas been done to meet the requirement. Cross validation rules has been setup for various GL codes. Configured Sub-ledger accounting process to GL.
• Performed functional setups like creating lookups, Profile options, DFF’s and value sets based on the technical requirement.
• Worked extensively on Payables and Payments to incorporate changes from 11i like bank accounts, tax and check printing.
• Reviewed the current reconciliation process in Cash Management and designed business process and system TEMPhas been configured and tested to meet the Business requirements.
• Customized the Invoice Aging and Customer Balance Report in AR.
• Worked in collaboration with technical team, to configure AR for Order entry systems and customer APIs.
• Prepared test scripts (TE40) for all business areas.
• Conducted Conformance Room Pilot (CRP)/Conducting User Acceptance Training (UAT) sessions and obtain user acceptance after providing feasible solution to issues raised within UAT sessions.
• Designed FSG reports (Income statement, Balance sheet statement its notes and other reports).
• 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.
• Defined Tax Code, Rates, Groups and Withholding Tax.
• Responsible for creating Request sets and Concurrent Programs and scheduling various tasks as per requirements.

Confidential, San Jose - CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Played role in upgradation of R12 Financial Modules (GL, AP, AR, FA, INV,BOM,WIP & CE), Acquire to Retire (A to R),
• Supply Chain Management (P to P), Consolidation ledgers, AGIS for intercompany transactions, Multi-Org application architecture.
• Responsible for complete As-Is study and its documentation.
• Prepared functional specifications documents such as BP080, MD50, MD70, BR100 for Financials and Supply Chain Management modules.
• Responsible for Data gathering on given templates and upload activity on systems
• Performed setup activities and prepared deliverable document i.e. BR100 document and taken sign-off.
• Guided developers for developing and modifying customized reports as per request of client
• Defined and performed Revaluation, Translation and Multi-Reporting Currency activities.
• Created Users, Responsibilities, Security profiles and Menus.
• Developed complete setups with Data upload on Production instance for Go-Live.
• Data gathering and upload using data load and Web ADI.
• Supported production environment and users on daily basis.
• Managed Technical Assistance Requests (TAR's) on-line Oracle Support.
• Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Documented custom processes using AIM Methodologies.
• During post production involved in the Manufacturing (INV, PO, BOM, WIP), OM, AP and AR modules application support, bug fixing and enhancements to the applications, enhancements include enhancing the existing functionality of forms, reports, custom forms.
• Worked on Order to Cash (OTC) and Drop Ship Cycles including Quote to Cash (QTC) logistics.
• Developed Purchase Order report, Packing slip report using XML Publisher (BI Publisher).
• Provided Training and conducted practice and additional business requirement sessions.
• Prepared UAT scripts and conducted UAT for with user acceptance sign-off.
• Conducted CRP, UAT and SIT tests to ensure the end product meets the client's requirements.

Confidential, Fairburn - Atlanta

Oracle Applications Functional Consultant

Responsibilities:

• Responsible to implement R12 Financial Modules (GL, AP, AR, FA & CE), Acquire to Retire (A to R), Supply Chain Management (P to P) & (O to C), iExpenses, Multi-Org application architecture.
• Studied of current business processes, future business flows and identification of gaps workarounds in order to provide an integrated information system solution to meet the business requirements of client.
• Conducted User Acceptance Training (UAT) sessions and obtained user acceptance after providing feasible solution to issues raised within UAT sessions and prepared UAT scripts.
• Developed and maintained all relevant documentation using Oracle Tutor & AIM Methodology - technical and functional specifications such as BP080, MD50, MD70, BR100, including project plans and status reports.
• Configured Setup of test and production instances financials and Supply Chain modules.
• Responsible for sing-off of all documents in time.
• Responsible for design and setup of Key and Descriptive flex fields for business groups. Setup work structures (Orgs, locations, Jobs, grades, positions, peoples group, cost allocation), org hierarchies.
• Worked with the technical team on conversion strategy and planning.
• Data gathering and upload using data load and Web ADI.
• Provided Training and conducted practice and additional business requirement sessions.
• Supported production environment and users on daily basis.
• Managed Technical Assistance Requests (TAR's) on-line Oracle Support.
• Provided Post go-live support.
• Designed Financial Reports using Financial Statement Generator (FSG) tool.

Confidential, Green bay - WI

Oracle Financials Functional Consultant

Responsibilities:

• Perform internal analysis and implementation of R12 EBS.
• Developed Business process flows for AR and AP and identify the gaps.
• Presented the identified gaps and work with business owners/users in the design sessions.
• Mapped the future state process requirements in GL, AP and AR.
• Develop project documentation including BR100 and Project Functional Design Documentation (MD50).
• Configured GL, AP, AR, FA & CE.
• Worked extensively in Revenue Recognition functionality considering accounting and audit requirements.
• Worked with the technical team for developing customer interface, transaction conversion from legacy systems and Auto Lockbox interface.
• Define system options, Accounting Option, Lookups, Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types.
• Assisted in developing and testing of invoices from third party systems.
• Conducted in CRP1, CRP2 and tested the customization.
• Conducted in the test sessions for GL, AP and AR modules. Performed unit, End to End tests and assisted in UAT sessions.
• Performed, developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.

Confidential

Oracle Programmer

Responsibilities:

• Responsible for creating database tables, indexes in Oracle 11i.
• Responsible for developing and customizing custom reports (6i) as per the client requirements.
• Developed SQL*Loader scripts for loading data.
• Wrote Explicit Cursors and Handling Exceptions.
• Created Views and Other Database Objects.
• Interacted with the Business users and identified the requirements.
• Designed and developed PL/SQL procedures and Functions.
• Trained end users for TEMPeffective usage of the software package.
• Responsible for table designing.
• Involved in database creation.
• Done preparation of program specifications.
• Wrote Database triggers for integrity checks.
• Wrote complex SQL scripts for reports.