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 R12/11.5.10/11.5.8/11.0.6 e-Business Suite.
• Expertise on Enterprise Application Integration EAI, Service Oriented Architecture using Oracle SOA Suite and Oracle Fusion Middleware.
• Expertise on Web service Orchestration using Oracle BPEL Process Manager and Oracle Enterprise 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,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 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 various customers.
• 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, JDeveloper
• Technologies: XML, XSLT, XPATH, XSD, WSDL, HTML, Java-Script
• Databases : Oracle 10g/9i, Access 2000
• Certifications : Sun Certified Java Programming (SCJP), Oracle Certified Associate (OCA)

Professional Experience:
Confidential, (Pittsburgh, PA) Jan 2012 - till date
Techno-Functional Consultant

Confidential,is an integrated steel producer with major production operations in the United States, Canada and Central Europe. The company manufactures a wide range of value-added steel sheet and tubular products.

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

Responsibilities:

• Designed and developed Inbound/Outbound interface programs between the US Steel and the third party vendors – BIMS, XEROX and KENEXA etc.
• Worked and involved in Custom Inbound and Outbound interfaces for BIMS:
• New Hire Information from KENEXA to Oracle; Integration from Person DB for Email

Address; Pending HR Approval Transactions; Outbound Oracle to EASI; Outbound Oracle
to CA Short

• Worked on the Extensions to customize the process in Oracle HR and Payroll modules:
• Purchase Order Tab Extension – Update Assignment Default Expense Account ; Custom

HR Security Profile; RRSP Employer Liability Calculation; CWB Custom Attributes of STIP
Plan

• Worked on the Fast Formulas using with new changes in Oracle Advanced Benefits / CWB module:
• CWB Fast Formula Grouping (Eligible salary for STIP & Hierarchy); CWB STIP Bonus

Calculation; USS Merit STIP Eligibility; CWB Custom Attributes for Short Term Incentive Plan

• 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; Active Part Time Employees

• 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

Notifications for different Transaction Status (Hire, Terminate, Promote, Transfer,
Change of Address and Advance) of the Employee using Approvals Management Engine.

• 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) Oct 2010 - Dec 2011
Techno-Functional Consultant

Confidential,is one among the Business Units of Motorola. The project is to identify the Federal Transactions from the Transactions posted to GL Entries from four source systems US AR2, US COGS, GCC and NA11i and post them separately to FSS GL system.
Global Order Management solution was rolled-out globally as part of this project, the End to End business process demanded various export and product related compliances needs to be followed along with Finance validations during the Order to Cash cycle.

Environment: Oracle EBS R12 Financials (GL, FA, AP, AR, OM, INV, PO), 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 motorola 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 Reports 10g.
• 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) Jan 2009 – Sep 2010
Technical-Consultant

The Order Fulfillment process for OFD (Order Fulfillment Delivery) is a shipping solution based on
Oracle Order Management and Warehouse Management System functionality.
In the current business process, Sales Orders are consolidated back to legacy system and imported into Oracle as Configure to Order models (ATO Models or PTO Models). Then the orders will be fulfilled from manufacturing to shipping in Oracle.

Environment: Oracle EBS R11.5.10.2 (OM, INV, PO, WMS), PL/SQL Developer, 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.
• 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

• Used standard Oracle OE_ORDER_PUB API to create a new sales order and update/cancel an existing sales order in Oracle Apps System and OE_HOLDS_PUB API to apply/release holds.
• Developed the Custom reports using Report Builder as per the client requirements in OM module: Xerox Consolidated Pick Slip; Xerox Packing Slip; Daily Inventory Report; Orders Not Reserved Report; Xerox On-Hand Balance Totals Report
• Form Personalization Tasks
• Pick Release Form: Not allow selection/insert/update of the organization field.
• Copy flags when copying sales orders: Allows to pick and choose which sales order

elements are copied along with the order.

• 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.

• Oracle Warehouse Management (WMS) has been used extensively to automate the picking, packing and shipping process.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all conversion and reports.

Confidential, (Phoenix, AZ) May 2007 – Dec 2008
Technical Consultant

Confidential,is premier supplier of performance power solutions worldwide. At ON, developed various Inbound and Outbound interfaces from Legacy System to Oracle.

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 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

Into Legacy Flat file; Custom outbound Interface to send the Invoices file to third party system in AP Module.

• Developed various inbound process.
• Custom Item create Interface program to populate the Items, revisions, categories,

Cross-references information; Purchase order Interface to upload the standard Purchase
Order transactions into the Oracle apps Base tables; Requisitions Open Interface to upload
the Requisitions transactions into the Oracle apps Base tables.

• 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) Jan 2006 – Apr 2007
Technical Consultant
Confidential,is a reputed organization which offers diverse product range to honor milestones and memorable moments in life.At this client, developed the various conversions and interfaces between Legacy system and the Oracle.

Environment: Oracle EBS 11.5.8 (OM, INV, PO, AR, AP, FA), 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).
• Created interface vendor validation program. And also Created Initial vendor load program and Procurement New Vendor Load program.
• Developed the Sales Order Conversion to load orders from legacy system into OM.
• Designed and Developed Oracle Inventory transaction interface program to import and validate data from the legacy system into Oracle Inventory.
• Developed new reports like Major Accounts Sales Report, Product Detail Report, Delivery Note and other reports as per requirements using Report Builder.
• Customized many Reports like Mailing Label for Shipping, Order Detail & Summary Reports, Invoice register reports and others for Order Management and Account Payables.
• Documentation of all the processes using AIM documentation methodologies.

Confidential,India Jun 2004 – Dec 2005
Pl/SQL Developer

Confidential,Order Provisioning. R1OSS (Release 1 of Operational Support Systems) is the database that is the heart of the entire application. Whenever a customer registers for BT product like BB or BBT from User Interface like BT.com, WLS Pages or SMART the data will be passed to R1OSS and request instance will be created on R1OSS and the data will be stored in CSS database. CSS data will be used for billing.

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.

EDUCATION

Bachelor in Information Technology.