SUMMARY:

• Working as a Lead Technical consultant at client location for last 5 Years.
• Having 11+ years of Experience in ERP including Developing, Customizing, Testing and Implementation of Oracle SCM and Finance modules.
• Proficient Experience in Procure to Pay, General Ledger, Order Management, Receivables, Inventory, HRMS, PA, AOL and System Administration .
• Expertise in SQL* Plus, PL/SQL, Advanced PL/SQL, D2K, XML Publisher and XDO Report.
• Good knowledge in Workflow and OAF .
• Experienced in data Conversions and Migrations using Interface tables and APIs from Feeder and Legacy systems to Oracle Application 11i and R12.
• Good knowledge in EDI - XML message designers - 850,860 and 810
• Involved in development of RICE components using SQL, PL/SQL, XML Publisher and OAF as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
• Extensive knowledge on GE and Confidential processes.
• Expertise in System Administration and AOL.
• Good experience in using Application Implementation Methodology (AIM ).
• Involved in all phases of Software Development Life Cycle.
• Excellent interpersonal, communication skills and understanding of Business applications. Willing to take up challenging assignments and interested to work in different kinds of modules and emerging technologies.
• Completed PMP certification training, planning to attempt to clear PMP in next 2 months.

TECHNICAL SKILLS:

ERP: 11I E-BUSINESS SUITE Releases 11.5.9 and R12.0.2

Modules: Procure to Pay (P2P), Inventory( INV),Order Management( OM), General Ledger (GL), Core HRMS, AR and PA

Languages: SQL, PL SQL, Shell Scripting

GUI Tools: Developer 2000(6i) and OAF

Reporting Tools: Reports 6i,10g XML Publisher, XML message designer.

Other Tools: SQL * Plus, SQL*Loader, Data Loader, Toad and Workflow

Database: Oracle 8i, 9i, 10g and 11g

Methods: Oracle AIM for Documentation and Test Scripts preparation

Versioning tools: CVS, Git and perforce.

Code migration: PVCS and Kintana

PROFESSIONAL EXPERIENCE:

Confidential, Schenectady NY

Oracle Apps Lead Technical consultant

Responsibilities:

• Worked as lead technical consultant to coordinate customer and functional team requirement and gap analysis.
• Developed Integration for material distribution interface from Oracle to mainframe system
• Developed outbound export programs to SMF team for sync supplier data
• Worked on interface for Receipt, PO and Item improvements between Oracle and COPICS system.
• Customized Item Activation dash board OAF from to add additional fields and search parameters.
• Developed OAF page for Item attribute dashboard.
• Worked on SQL performance tuning.
• Worked on application maintenance activities
• Involved in closing activities for month/quarter/year
• Closely worked with PMO team on metrics and instance strategies to take it next level and continues improvement
• Worked with oracle and DBA team on patch analysis.
• Worked on workflow activates.
• Worked on production outage activities.
• Worked on enhancement in Project accounting and AR programs.

Confidential - Bravo, Atlanta GA

Oracle Apps Technical Consultant

Responsibilities:

• Responsible as a primary Technical Lead/owner for designing and developing CEMLIs in Order Management (OM), Account Receivables (AR), Project Accounting (PA), Inventory(INV), Purchasing (PO), Account Payables, Oracle Payments (IBY), SLA and General Ledger (GL) Modules.
• Developed Purchase Order, Purchasing Receipts and Orders Inbound and Outbound Interfaces
• Developed Invoice and customer Outbound interface
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Involved in the Documentation of Business Requirement Document, Solution Design and Test Scripts.
• Developed OAF page for Item attribute dashboard.
• Working closely with Business, Third Party Teams, and Functional Teams for Developing Interfaces (Inbound and Outbound)
• Responsible for mapping the Business specific requirements on the integration.
• Testing for the Integration and Synchronization of data on both the systems SSP5, EDI and other off the shelf tools and Oracle.
• Developed xml and XDO reports in PO, PA, AR, Inv, and OM.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Assisted users in Month-end Closing procedures.
• Closely working with Oracle team, DBA and users to analyze patches and apply fixes in prod with extensive testing.
• Worked with GECARS, CMF OLS, BAAN and Web methods team to fix data issue between interactions and custom schema password change activities

Confidential

Oracle Apps Techn ical Consultant

Responsibilities:

• Preparation of technical documentation.
• Creation of Value Sets in various modules of application.
• Preparation of KINTANA Packages.
• Participating in ARB Meetings.
• Participating in release/go live activities.
• Done enhancements to PL/SQL Packages.
• Extensively worked on advanced PL/SQL components.
• Customized Purchase order report.
• Developed GL Reconciliation Report (SQL Report).
• Developed Inventory In transit shipment report.
• Customized Requisition report.
• Worked for different projects (under Confidential Account) as part of Global delivery model to develop and enhance the internal and external tools.
• Worked on Form personalization in SRM Module
• Developed new form to send email.
• Involved in testing Activities.
• Developed out bound interface to upload data for SFDC.
• Developed AP Interface to upload Invoice data from custom tables to AP Base Tables.

Confidential

Oracle Apps Developer

Responsibilities:

• Preparation of technical documentation.
• Registration of concurrent programs.
• Creation of Value Sets in various modules of application.
• Preparation of MoM for client and team meetings.
• Provided Period end / Quarter End/ Year end closing activities
• ERT (EMERGENCY RESPONSE TEAM) member for ODS.
• Developed FA Reconciliation Report (SQL Report)
• Developed Requisition Status Report.
• Developed On-Time Delivery Performance Report
• Developed Vendor Efficiency report (D2K Report)
• Developed alert for AP module to send emails for self-Invoice.
• Developed query find form for an existing from.
• Developed HRMS interface using APIs to upload/update employee’s information from flat file to HRMS base tables.
• Developed inbound interfaces for Purchase.
• Developed an outbound interface to send PO information of all external suppliers’ information to SMF tool.
• Developed reports for Purchase Orders to send to Suppliers.
• Developed couple of Form personalization’s on Requisition form in purchasing module.
• Developed queries and provided data as per user requirements.
• Developed many reports like Pick Slip, packing Slip, Mailing Label for Shipping and Orders by Item, Order Detail & Summary Reports for Order Management (OM) and created new reports as per client requests.
• Development of concurrent program to extract data from the Oracle database to .csv files to be loaded into the SFDC legacy data base by using UTL FILE.

Confidential

Oracle Apps Developer

Responsibilities:

• Involved in customizing and developing the reports
• Creation of Value Sets in various modules of application
• Created tables, indexes, sequences, constraints and snapshots.
• Developing Stored Procedures and Triggers using PL/SQL.