SUMMARY:

• Over 10+ years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Expert in Developing, Customizing, Maintaining and Supporting Oracle Applications E-Business Suite ERP versions R12/11i using Oracle Application Framework (OAF), PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI(XML) Publisher, Workflow, Web ADI, Application Development framework (ADF) and PLSQL.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Accounts Payables (AP), Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Purchasing (PO) and I-Procurement
• Hands on experience in End-to-End Oracle E-Business Suite (R12) Implementation project experience, Intensive 11i to R12 Upgrade project experience.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
• Proficient in Designing, writing Stored Procedures, Packages and Functions using PL/SQL.
• Involvement of four successful end-to-ends R12 Implementation.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Extensive hands on experience on using various tools like Service Now, HPALM & Deployment and Tortoise SVN.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. EBS System Analyst

Environment: E- Business Suite R12.1.3, Oracle Database 11g

Responsibilities:

• OAF customizations done on various ISupplier Pages like SupplierMyReqsPG, SupplierPrRequestPG.
• OAF Org & Site level personalization done for multiple IProcurement pages and Buyers Works center like PosChangePOPG.XML, PosAgreementsPG.xml & PosViewPOPG.XML etc.
• Controller (CO) and View Object (VO) extensions done for IProcurement, ISupplier and Buyer Work center.
• Implemented AME for PO Approval Workflow (POAPPRV) and Requisition Approval Workflow (REQAPPRV).
• PO Approval Workflow for sending notification customized as per Business requirements
• Worked on Interfaces like FA Asset Additions and FA Asset Transfer Interface.
• Added new functionality in “JOB entry” forms and “Billing Entry” custom Oracle forms.
• Created and executed development plans and revises as appropriate to meet changing needs and requirements.

Confidential, Jacksonville, Florida

Oracle Fusion/ADF Consultant

Environment: Fusion, Weblogic Server, Middleware Technologies, Oracle Database 11g

Responsibilities:

• Mapping the Client requirements with standard functionality in finance area (AP) and finding the gaps and delivering the solutions in terms of Customizations, workarounds & reengineering.
• Created the business components required in building the ADF pages. Created Entity Objects (EO), View Objects (VO) and Application Modules (AM).
• Developed Agreement UI page fragments, task flows, backing beans, managed beans etc. using Application Development Framework (ADF) to meet business requirements.
• Created new screens using Oracle ADF JSF features, several JAVA classes in BC4J layer of Application Development Framework to implement the complex business requirements for Fusion Leases project.
• Used most of the UI Components in building the complex ADF web pages.
• Implemented Partial Page Rendering in ADF Pages.
• Resolved defects and support issues related to Project.
• Created debugs and runs SQL scripts to conduct data analysis, accuracy validation and data maintenance.
• Developed requirements like; Create Web Service Clients in ADF, Multi-level Task Flow Call Activates and Root Application Modules for transactions been done in one go
• Easily recognized the system deficiencies and implements effective solutions.
• Created and executed development plans and revises as appropriate to meet changing needs and requirements.

Confidential

Sr. Finance R12 Techno Functional Consultant

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Gathering Technical requirements, design, test, training, deployment support, and production support for various finance modules including AP & GL .
• Providing technical expertise to the Knowledge Sharing & Collaboration Team as part of the delivery of Single View & EBS Finance module like AP, I-Proc, I-Supplier, PO, Payments , , GL, AGIS, INV& FA for Equinix Workplace using the Oracle EBS R12.1.3 Product Suite.
• Designed and developed AP Supplier, AP Supplier Sites & Contacts interface.
• Developed and delivered WebADI’s related with AP & FA Module.
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
• Design and Development of multiple Custom OAF Pages using JDeveloper. VO, EO, OAF Page Personalization on I-procurement (Requisitions) pages.
• Extensive knowledge on Oracle AR and CE (Cash Management) modules.
• Involved in design & development & configuration of AME module (Roles/Grants/Approval) for PO Requisition Approval, PO Approval.
• Writes expert technical documentation MD070 to be used as training and reference materials for System Analysts as well as other IT staff.
• Involved in implementation of Inventory INV & FA module GO live.
• Exposure on third party applications like Vertex, SingleView & Aventx .
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface (Import Items) program.
• Conversion & Interfaces in Procurement Module.
• Providing management with recommendations and guidance on enhancements to existing functionality and implementation of new functionality
• Create Oracle Alerts to monitor business events based on users' requirements.
• Extensive knowledge of Oracle EBS suite platform (Conversion, Open Interfaces, APIs, Flexfields, Custom Library, Forms Personalization, OAF Personalization, Alerts, Oracle Workflow, Oracle AME, OA Framework)

Confidential

Sr. Finance Oracle Apps. Consultant / Technical Lead

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Biz. Requirement Gathering, Technical Solution feasibility analysis for Finance modules.
• Assessment, design, development and delivery of multiple KIV from the Development pipeline.
• Retrofitted & migrated AP custom interfaces and reports from 11i to R12.
• Developed multiple custom BI (XML) Publisher reports for various finance modules like AP Account Analysis Report etc.
• Imported Legacy Journals data into GL using Journal import interface
• Assessing the Solution feasibility of complex custom solutions adopted in E-Biz R12.1.3 for the client with documentation involved like MD050, MD070, Unit Testing and Migration documents for ACMP.
• Oracle AD-Patch creation and applying using Patch Release Management Tool ACMP
• Design and Developed the multiple AP/OM objects like customer facing reports involving BI(XML) publisher Reports e.g. ‘Vendor Trial Balance Report’, ‘Vendor Transaction Details’, ‘True-Up Report’ etc. considering MOAC Security feature of R12.1.3 into consideration.
• Oracle WEBADI: Developed and delivered multiple Oracle WEBADI objects .
• Developed several forms using TEMPLATE.fmb & Customized standard forms through CUSTOM.pll.
• OAF: OAF Customization and Personalization done for OAF objects for the Oracle i-supplier Page. E.g VO Extension, ‘AR Cash Forecasting’ Page customization using JDeveloper 10g tool.
• Workflow/AME: AP Invoice Approval/ PO Approval Workflow using workflow builder.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages, Procedures and Reports developed.
• Flow Cycles: Extensively involved in Oracle AGIS (Advanced Global Intercompany System), Order Management IC Flows and P2P flows. The other flow involves Drop Shipment flows and O2C flows.
• Involved in post-production support.

Confidential

Sr. Oracle Apps. Consultant / Tech Lead

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Design, development and Timely Delivery of Conversion, Interfaces and data extraction for various modules like AP, AR, INV, FA & HRMS modules.
• Retrofitting of multiple objects like Interfaces, Forms, Reports, workflow, OAF Personalization and AOL objects from various modules of existing 11i to R12.
• Design and developed the multiple custom FIN/OM reports like ‘Average Sales Price for the Month’ using Reports Developer 10g and BI (XML) Publisher.
• Design and development of Oracle WEBADI objects for the FA Upload. Well versed through oracle TCA (Trading Community Architecture).
• Customized the DNCN (Fully Custom) Form using Forms Developer 10g.
• Patch Release Management using Oracle ACMP Tool.
• Multiple OAF Customization and Personalization done for OAF objects for the Cash Forecasting Page.
• Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger)
• Extensively involved in Oracle AGIS (Advanced Global Intercompany System)
• Well versed in the Order Management IC Flows.
• Design and development of PL/SQL code for Employee, Employee Address, and Routing Conversion according to the Oracle e-Business Suite R12.1.3 strategy.

Confidential

Oracle Apps. Finance Consultant

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Design and Customized the Discrete Job Routing Sheet Report using Reports Developer 10g.
• Design and developed the Sales Journal Detail Report using BI Publisher and Reports Developer 10g considering MOAC Security feature of R12.1 into consideration.
• Worked on oracle customer online Service Contracts/Install Base module. Well versed through Oracle TCA (Trading Community Architecture).

Confidential

Oracle Apps. Consultant

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Design and development of PL/SQL code for SUPPLIER Conversion, Enterprise Asset Management(EAM) Interface, Fixed Asset(FA) Interface, Positive Pay outbound Pay check interface according to the Oracle e-Business Suite R12.0.6 strategy.
• Testing of the code and delivering the same within the time limit.
• Preparation of Technical document for several activities like CV 60, MD 70, MD120 etc.
• Worked closely on the performance tuning of the SQL queries for Conversion and Reports through ‘CEMLI Performance Checker Program’ on ON-Demand Instance.
• Design and developed the Invoice format Report using BI Publisher and Reports Developer 10g.
• Customized the AP Invoice Form using CUSTOM.pll. Forms developer 10g is used to customize the Form.

Confidential

Oracle Apps. Technical Consultant

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Design and development of PL/SQL code for SUPPLIER Conversion, Employee Salary, Advance Benefits and Fixed Assets conversions according to the Oracle e-Business Suite R12.0.6 strategy.
• Testing of the code and delivering the same within the time limit.
• Preparation of Technical document for several activities like CV 60, MD 70, MD120, TE020, CV070 etc.
• Worked closely on the performance tuning of the SQL queries for oracle Reports and Conversion.
• Designed and Developed the Resource Transaction Report using BI Publisher and Reports 10g Developer.

Confidential

Oracle Apps. Technical Consultant

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Item Conversions: This conversion involved populating the data into oracle staging tables from the client’s legacy system. Then perform the validations according to oracle standards and then populate the Oracle STD Item Interface tables with the legacy data by a custom PL/SQL program. Run the Item Import from oracle application, which will populate the Oracle Base tables from the Interfacing Tables. Records, which failed validations needs to be corrected before running the program.
• Order Import: This involved the bringing Legacy Order Management data into Oracles Order Management module. A custom Host Unix program populated the staging tables. The PL/SQL program populated the oracle order interface tables. Then run the Order import from oracle apps, which bring the data into oracle OM module.
• Forms6i customizations
• Item entry form: This form involved the customizations of the Oracle STD Item entry form. Customized the form according to the client’s specifications. Customization of the form did by Oracle form 6i developer Tool.
• Involved in development of Technical Document (MD060), Coding and Testing for this Project.

Confidential

Support Engineer for Oracle Applications 11i

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Building of custom Data fix using PL/SQL for accounting related data corruption.
• Researching on the customer issues and then suggesting any patches if available.
• Providing Action plans to the customers.
• Coordinating with the Development team if any new Bugs found related with 11i
• Solving SRs according with the severity level.
• Coordination with Customers consultant team.

Confidential

Oracle Apps Technical Consultant

Environment: SQL, PL/SQL, TOAD, Windows XP, Shell Script.

Responsibilities:

• Building the complete PL/SQL code for VENDOR and BOM Routings conversions according to the Oracle e-Business Suite R12.0.4 strategy.
• Testing of the code and delivering the same within the time limit.
• Preparation of Technical document for several activities like CV 60, MD 70, MD120 etc.