PROFESSIONAL SUMMARY:

• Over 8 years of professional experience in Analysis, Design, Development, Testing and Implementation of Applications using Oracle Applications, SOA and Oracle Development tools.
• Expert in customization, implementation, maintenance and support of Enterprise Business Applications using Oracle R 12/11.5.10/11.5.8/11.0.6 e - Business Suite.
• Expertise on Enterprise Application Integration EAI, Service Oriented Architecture usingOracle SOA Suite (11g and 10g) and Oracle Fusion Middleware.
• Expertise on Web service Orchestration using Oracle BPEL Process Manager and OracleEnterprise Service Bus (ESB).
• Conversant in implementing Oracle Finance, Supply Chain, Manufacturing and Human Resources modules like Oracle (GL, AR, AP, FA, PO, OM, INV, BOM, AOL, HRMS(Core HR, Payroll, CWB and Advanced Benefits)).
• Sound knowledge in the Finance, OTC and P2P cycles of Oracle Apps e-Business Suite.
• Worked with Interfaces in all Human Resources, Finance and Supply Chain Modules and also used standard Oracle API’s for Interfaces and conversion procedures for data transfer between modules OM, INV, PO, GL, AR, AP and HR.
• Expertise in Oracle Application EBS Customization, Enhancements, Reports, Interfaces, Conversion, Extension, Workflow (RICEW) components using D2K - Forms10g, Reports10g,Workflow Builder.
• Proficient in writing stored Procedures/Packages, Functions, Cursors, Database triggers using PL/SQL.
• Strong experience and knowledge of XML Technologies XML, DTD, XSLT, XSD and XPath.
• Hands on experience in supporting and implementation of Business Integration for variouscustomers.
• Expert in developing programs using SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Experienced in analyzing index, quality assurance, Performance Tuning of Oracle SQL and PL/SQL applications using- TKPROF Explain Plan.
• Worked extensively in developing Functional Design Documents (MD50), Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Expert in SYSADMIN and in Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, providing support to apps users for any technical or functional issues.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite 12i/ 11.5.10/11.0.3 ( HR, GL, AP, AR, PO,FA, INV, BOM, OM, Work flow, System Administration)

Fusion Middleware: Oracle SOA Suite (10g and 11g), Oracle EBS (Database, File, FTP,AQ, Oracle Applications and JMS) Adapters, Oracle BPEL, Oracle Application Server 10g, Oracle Web Service Manager

Tools: Toad, WinSCP, Putty, Clear Case, MS Visio, SQL * Loader,PL/SQL Developer

Languages: C, C++, Core java, SQL, PL/SQL, Shell Programming

Operating Systems: Windows 2000/NT/98, Linux, UNIX (Solaris, HP-UX).

Developer Tools: Forms 10g/6i/4.5, Reports 10g/6i/4.5/2.5, XML Publisher,Discoverer 10g/4i/3i, Workflow Builder 2.6, JDeveloperWeb Service/XML

Technologies: XML, XSLT, XPATH, XSD, WSDL, HTML, Java-Script

Databases: Oracle 10g/9i, Access 2000

PROFESSIONAL EXPERIENCE:

Confidential (Pittsburgh, PA)

Techno-Functional Consultant

Environment: Oracle EBS R12 HRMS (Core HR, Payroll, CWB, Advanced Benefits) Oracle Fusion Middleware 11.1.1.7.0, JDeveloper, SQL*Plus, TOAD, D2K-Reports 10g, PL/SQL, SQL*Loader, UNIX

Responsibilities:

• Designed and developed Inbound/Outbound interface programs between the Confidential and the third party vendors - BIMS, XEROX and KENEXA etc.
• Developed the Custom Inbound and Outbound interfaces for BIMS Legacy system:
• New Hire Information from KENEXA to Oracle; Integration from Person DB for Email
• Developed the custom interface for Payroll:
• Outbound from Oracle to Fidelity Demographic and Payroll Information
• Outbound from Oracle to Fidelity Long Term Incentive Plan Indicative and Payroll Balance
• File going to TALX for unemployment
• Oracle to Canada Post - Salary Pay Advices
• Developed and customized the Extensions in Oracle HR and Payroll modules:
• Purchase Order Tab Extension - Update Assignment Default Expense Account ; Custom
• Savings Plan ER (Employer Match - Pre tax) ; Savings Plan AT ER( Employer Match - After Tax) ; Savings Plan Spill Over ; Saving Fund Retirement Account (SFP) for Payroll
• Developed the Custom reports using XML Publisher in Core HR, Payroll modules:
• Statistics of Labor Turnover; Missing Logs of US Employees; HR Approval Transactions;
• Employees Inactive 21 Months and Longer (Non-represented); Employee Vacation Eligibility Report; Employee Vacation Accrual Report ; Active Part Time Employees
• Involved in the Vertex install for every month to update the Tax Rates, Formulas and other Jurisdiction Information.
• Have experience on Custom reports in Compensation Work Bench with Plan and Employee Administration.
• Have experience on Forms Personalization and OAF Page Personalization.
• Have experience in creating the Personalization files (XML and LDT) for OAF Forms including Oracle Forms.
• Worked on the Enhancements and Change Requests for the existing objects in HR, Payroll and CWB modules.
• Worked on the Enhancements for Self Service HR Workflow Approvals and Workflow
• Registered the PL/SQL scripts using Concurrent Programs and attached the programs to existing Request Sets. Used the tool Kintana to move the above developed procedures to the other environments.
• Involved in Analysis of Requirements document. Created Technical Design, Test Plan and Unit Test documents and specifications using Application Implementation Methodology (AIM) Standards.
• Responsible for Unit, Integration and User Acceptance testing and supporting the Post Production support.

Confidential (Schaumburg, IL)

Techno-Functional Consultant

Environment: Oracle EBS R12 Supply Chain & Financials (GL, FA, AP, AR, OM, INV, PO), Oracle Fusion Middleware 11.1.1.4.0, JDeveloper, PL/SQL Developer, SQL*Plus, TOAD, Reports 10g, PL/SQL, SQL*Loader, UNIX

Responsibilities:

• Developed the custom programs for the conversions in Inventory (INV): OM Item Substitution Conversion & OM Item Conditioning Conversion
• Implemented Order Management Workflow extension for RMA Finance approvals for various financial validations which Confidential requires during Order to Cash process.
• RMA email notifications to AR collector taking place within the order processing flow used globally for all 3 regions - EMEA, Americas, APac.
• RMA Approval workflow notification for Sales Order will be triggered at the launch of Sales Order “Book” event. Seeded OM Workflows are copied and customized to achieve this requirement.
• RMA amount was set up in a value set on Operating Unit Level. An Email Notification to the AR Collector is sent immediately after the RMA order is approved by finance in R12 Order Management. In the collector setup the collector email address was configured in consistent format.
• Developed custom interfaces for each system i.e., AR, COGS. For these systems, developed a process which loads general entries to the custom table and then created flat files using UTL FILE, DBMS utility which displays federal GL entries grouped by code combinations.
• Developed the UNIX shell scripting programs to upload flat files to FSS GL System. Created Staging tables and inserted the GL entries for OBIEE reporting purpose.
• Developed RMA Receipt Report using XML Publisher.
• Worked on documentation using Created Design, Test Plan and Unit Test documentation Application Implementation Methodology (AIM) Standards.
• Responsible for Unit, Integration and User Acceptance testing and supported the Post Production support.

Confidential (Webster, NY)

Technical-Consultant

Environment: Oracle EBS R12 (HRMS, Payroll, OM, INV, PO), PL/SQL Developer, Oracle Fusion Middleware 10g, JDeveloper, SQL*Plus, TOAD, PL/SQL, SQL*Loader

Responsibilities:

• Designed and developed interface programs to extract orders from custom web application objects, populate to staging table, validate the data in staging table and send to interface tables.
• Developed wrappers for various interfaces for applications related to HR and Payroll.
• Defining Key & Descriptive flex fields for custom Special Information Types (SIT).
• Worked on the Self Service HR Workflow Approvals for different Transaction Statusf the Employee using Approvals Management Engine (AME).
• Developed and modified the various Fast Formulas for Imputed Income and Savings Plan (401k).
• Importing Orders from Legacy EMP to Oracle includes the following interface programs
• Xerox Order Import ;Xerox Change Order Import; Xerox EMP Interface Control ;Xerox Order defaults and substitution
• Developed the Xerox Consolidated Pick Slip and Packing Slip reports using XML Publisher.
• Developed the Daily Inventory, Orders Not Reserved reports using XML Publisher.
• Workflow Customization
• Seeded OM Workflows are copied and customized to create Ship only Workflow.
• Workflow notification for Sales Order will be triggered at the launch of Sales Order “Book” event and an email notification is sent to the concerned.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all interfaces and reports.

Confidential (Phoenix, AZ)

Technical Consultant

Environment: Oracle Apps 11i, UNIX, Oracle 9i, Reports 6i, TOAD, SQL*Loader, PL/SQL, SQL*Plus, AR, AP, PO, INV, HR

Responsibilities:

• Developed Custom Program for Vendor Conversion (Include Vendor, Sites, Contacts) in AP Module.
• Developed Custom Program for Employees Conversion and Customers Conversion in AR from Legacy System.
• Developed various Inbound and outbound processes to send flat file from Oracle Applications to external system using UTL file package, FTP.
• Material On-hand Quantity Interface to transfer the Material Transactions information
• Developing Reports, Customization of Reports:
• Reconciliation Report for Item interface; Reconciliation Report for Invoice Interface
• Testing the resolved objects and supported in writing quality documents. Created indexes to enhance the performance of the applications.

Confidential (Indianapolis, IN)

Technical Consultant

Environment: Oracle EBS 11.5.8 (HRMS, Payroll, Compensation Work Bench), Workflow Builder, Reports 10g, PL/SQL Developer, SQL*Plus, TOAD, PL/SQL, SQL*Loader

Responsibilities:

• Involved in business requirements definition, mapping, fit/gap analysis, solution design, documentation, configuration, unit and system testing, User Acceptance Test (UAT).
• Involved throughout the life cycle from implementation to production support of Oracle HRMS application. Involved in various Technical designs and Data Mapping.
• Involved in Self service Personalization and Work flow customizations.
• Developed Student Update interface from Colleague system that runs every pay period before the student payroll run that updates the demographic information in Oracle.
• Worked on creating and maintaining database objects for developing interfaces.
• Developed various custom reports using Reports 6i.
• Supported production environment both technically and functionally.
• Documentation of all the processes using AIM documentation methodologies.

Confidential

Pl/SQL Developer

Environment: Developer 2000, SQL, PL/SQL, Oracle 9i, UNIX, Windows 2000

Responsibilities:

• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers, Stored Procedure, and Packages in the server side.
• Participated actively in the technical and functional discussions. Designed ER diagrams and normalization of database.
• Migrated the data from external files into Database tables using SQL *Loader. Interacted with the user group on a regular basis to discuss requirements and updates.
• Extensively involved in performance and tuning of all SQL and PL/SQL code. Used Built-in Packages provided by oracle for debugging.
• Developed UNIX shell scripts to schedule the cron jobs. Used Developer 2000 to generate reports of statements for users.