SUMMARY:

• To pursue a career in Oracle ERP area on Techno Functional roles that enhance my knowledge and to be part of an organization which provides an opportunity to work in a stimulating environment, providing scope for personal growth and achieving organizational goals.
• I have 10+ years of experience in Oracle E - Business Suite Financials and Procure to pay areas.
• Experience in Oracle R12 and 11i end-to-end full life cycle Implementation, Upgrade and Productions support projects.
• Strong working knowledge in Oracle modules General Ledger(GL), Advanced Global Intercompany Systems(AGIS), Payables(AP), Receivables(AR), Cash Management(CE), Fixed Assets(FA), iProcurement, Purchasing and Oracle Incentive Compensation.
• Experience with Oracle application development tools i.e. BI/XML Publisher, Oracle Workflow, D2K Reports, Forms, and Oracle Application Framework (OAF).
• Expertise with SQL and PL/SQL.
• Expertise with Data conversion and interfaces from Oracle and non-Oracle systems.
• Well versed with Oracle process flows, R2R, P2P.
• Expertise in Functional Analysis, Requirement Gathering, Process Mapping, preparing Functional and Technical specifications, Application Configuration, Testing, Data migration and User Training.
• Rich experience in working with multi location technical resources and offshore team to complete deliverables.
• Experience of Data Conversion and migration using Oracle Open Interface tables and standard APIs.
• Good Knowledge and experience in Oracle AIM Methodology of implementation and Documentation.
• Highly Quality oriented, self-driven and motivated for timely target achievement.
• Effective oral and written communication, presentation skills, strong analytical problem solving capabilities, planning and organizational skills.
• Experience communicating with various levels of stakeholders.

TECHNICAL SKILLS:

Functional Expertise: Oracle Application modules General Ledger(GL), AGIS, Accounts Payable(AP), Accounts Receivables(AR), Fixed Assets(FA), Cash Management(CE), Purchasing(PO), iProcurement, Confidential, Sub Ledger Accounting(SLA), Advanced Pricing, E-Business Tax, Oracle Incentive Compensation.

Technical Expertise: Oracle SQL, PL-SQL, Oracle Reports, Oracle Forms, Oracle Workflow, XML/BI Publisher, UNIX Shell Scripting, AME (Approvals Management Engine), Interfaces, SQL Loader, Conversion, MOAC (Multi Org Access Control) and TCA (Trading Community Architecture and Oracle Application Framework (OAF).

Versions: 11.0.3/ 11i (11.5.10)/R12 (12.1.3)

Business Process: Procure-to-Pay, Record-to-Report and Order-to-Cash cycles

Strong working knowledge: of Oracle Applications Architecture and underlying tables, AOL and System Admin Functions.

PROJECTS EXECUTED:

Confidential, New York

Environment: Oracle EBS R12.1.3

Development: Oracle Reports, Forms, BI/XML Publisher, SQL, PLSQL, UNIX Shell Scripting

Responsibilities:

• Conversion of GL Balances, GL Detail Journals, GL Budgets, Suppliers, Internal Banks and External Banks.
• Preparing CV060 documents for conversions.
• Development of conversion programs for GL Balances, GL Detail Journals and Budgets.
• Analysis of Custom objects required to be moved from 11i to R12.
• Developing Check printing formats and EFT custom payment programs.
• Customizing standard CE Reconciliation programs as per business requirements.
• Customizing Cash Management SLA to create journals in foreign currency.
• Understanding complex business processes, retrofit and migrate the objects to R12.
• Managing a team of technical consultants.
• Design migration strategy and scripts for migrating custom objects to various instances.
• Responsible for overall delivery of the technical objects and conversions.
• Status reporting to various stakeholders.

Confidential, Oklahoma City

Environment: Oracle EBS R12.1.3

Development: Oracle Applications R12 (GL), Oracle Reports, BI/XML Publisher, SQL, PLSQL, OAF, HP Quality Center (Defects, Test Cases), SVN (Code Repository).

Responsibilities:

• Participated in multiple business meetings for Fit-Gap Analysis for Oracle E-business suite R12 implementation.
• Document BR100 documents and perform application setup of General Ledger and AGIS, Accounts Payable and Accounts Receivables module.
• Creation of Test Scenarios, Test Scripts in Oracle EBS R12 Financial Modules and perform the automation testing in HP Quality Centre.
• Document GL balance conversion strategy and create program to extract, transform and load the data.
• Develop custom program to transform 11i code combinations to R12 format using the defined rules.
• Document Functional and Technical design documents for custom programs.
• Design GL interface program for loading external files, GL Daily Rates using SQL*Loader, PL/SQL and UNIX shell scripts.
• Design and develop custom BI/XML Publisher Reports, UNIX shell scripts, Triggers, PL/SQL packages and procedures.
• Develop OAF search pages with download feature integrating XML publisher reports.
• Retrofit custom journal approval OAF pages to R12.
• Perform VO extensions on standard pages.
• Perform POC (proof of concept) for Translation, Auto Reversal, Definition Access Sets, Accounting and Reporting sequencing and Mass Allocation across ledgers,
• Provide assistance to business in setting up FSG’s.
• Setup WebADI templates.
• Provide application support during month end and quarter end issues.

Confidential, Boston

Environment: Oracle EBS 11.5.10

Development: Oracle Reports, BI/XML Publisher, SQL, PLSQL, OAF,

Responsibilities:

• Application Maintenance and support for General Ledger, Accounts Payable, Fixed Assets, Cash Management and Confidential .
• Interact with Business user’s in requirement gathering of enhancements and defects, mapping business requirements with existing functionality and gap analysis.
• Configuration and setup for FA modules and design strategy for Assets conversion.
• Setup AME for Confidential .
• Configuring iProcurement Punch-out for suppliers.
• Estimating development efforts and make adjustments to development plan to meet changing needs and requirements.
• Conduct the technical document and code reviews; ensure that the quality and coding standards are met before delivery.
• Coordinate with infrastructure teams, application vendors, and DBA teams for any issue with infrastructure.
• Solution Design for new enhancements and support issues.

Confidential

Environment: Oracle EBS R12.1.3

Development: Oracle Reports, BI/XML Publisher, SQL, PLSQL, Autosys (Job Scheduling).

Responsibilities:

• Configuration and Setup of Accounts Payable and Cash management modules.
• Requirements gathering for Payment Formats and Positive Pay Reports.
• Performed Setups of Internal Bank Accounts, Payment Documents and Payment Process Profiles.
• Setup Cash Management setups for Bank Statement Loader.
• Setup E-BTax and test AP module for tax calculation on Invoices.
• Prepared Functional and Technical design for 12 Payment Formats (Check, EFT, Wire) and Positive Pay reports.
• Developed XML Publisher Check Formats.
• Conversion of Suppliers and AP invoices.
• Used Payments hook IBY FD EXTRACT EXT PUB to add logic for extracting and formatting the columns required by Banks as part of EDI 820 formats.
• Developed e-Text XML templates for EFT programs and Positive Pay reports.
• Coordinated with Business Users, Check Printing teams and Banks for successfully testing the Payment Formats and Positive pay reports.
• Customize SLA (Sub Ledger Accounting) for AP invoices event by create new ADR’s using mapping sets.
• Planned and executed Cut-Over activities for Production Go-Live as an Onsite coordinator.

Confidential, San Jose

Environment: Oracle EBS R12.1.3

Development: SQL, PLSQL

Responsibilities:

• Implementation of Oracle Projects (Costing and Billing).
• Prepare Understanding documents after conducting meetings with Business users of current 11i Application and its boundary applications.
• Develop queries to extract data required for conversion.
• Prepare design strategy to migrate custom objects from 11. .1.3 incorporating MOAC and R12 specific technical changes.
• Performing POC’s as part of the Data Migration strategy using the Oracle projects and tasks API’s.

Confidential

Environment: Oracle EBS R12.1.3

Development: Oracle Reports, Oracle Workflow, Oracle Alerts, PL/SQL, UNIX Shell Scripting, BI/XML Publisher reports, OAF.

Project Lead

Responsibilities:

• Keep P2P modules in alignment with Oracle Release rollouts/patches
• Gather, Understand and document product issues from various project teams.
• Create SRs, work with oracle and obtain the product fixes/patches
• Conduct patch analysis to determine impacts to custom code
• Work with Infra and all partner for deploying the patches
• End to end testing and deployment of Procure to Pay modules.
• Development of testing documentation, execution of testing and providing support to end-users through each testing cycle.
• Implement the customizations (OAF VO extensions, personalization’s, that get impacted by applying patches).
• Follow the tools and processes of Cisco.
• Accountable for the quality of the deliverables and adhere to the SLAs.

Confidential

Environment: Oracle EBS R12.1.3

Development: Oracle Reports, Oracle Workflow, Oracle Alerts, PL/SQL, UNIX Shell Scripting, BI/XML Publisher reports, OAF.

Project Lead

Responsibilities:

• Prepare SQL queries for extracting the data counts of Master and Transaction data as part of pre and post upgrade activities.
• Conduct meetings with Business users to identify the customizations that needs to be migrated in R12.1.3
• Identify impact of existing processes due to R12 upgrade.
• Retrofitting RICE components and train Technical Consultants.
• Preparing test case and impact analysis documents
• Implement RICE components as per new features in R12 i.e. MOAC, TCA Architecture etc.
• Performing Smoke Testing for Financial Modules GL, AP, AR, FA, CE.
• Develop EFT Payment format program as per Payments module in R12.
• Preparing user training documents.