SUMMARY:

• 7 Years of experience as Techno - Functional Consultant in Oracle Applications (E-Business Suite) implementation, enhancements, customizations, migration, interfaces and conversions.
• Expertise in Technical and Functional aspects of Oracle applications R 12/11.5.10/11.5.9/11.0.3 Financial, Supply Chain, Order to cash and Manufacturing Modules which include Trading Community Architecture (TCA), Pricing (QP), EDI, SOA, AOL, General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Cash Management (CM), Fixed Assets (FA) & HRMS.
• Well experienced in Reports, Interfaces, Conversions, Extensions and Workflow (RICEW), Implementation and Support in various Oracle Apps modules.
• Involved in implementing versions/upgrades of Oracle Applications 11i and Oracle Applications R12 for Oracle Business.
• Extensive experience in Oracle Fusion middleware primarily in SOA Integration such as Web services.
• Expertise in using Oracle Discoverer 10g, PL/SQL, SQL, Forms 10g, Reports 10g, BI/XML Publisher, APIs, Oracle 11g/10g/9i/8i under Windows/UNIX/LINUX environments.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Import and Export utility, SQL* Loader.
• Extensive experience in writing Oracle backend objects like: Database Triggers, Stored Procedures, functions and Packages using PL/SQL.
• Creation of Install scripts to migrate objects between Instances.
• Creation of concurrent programs to execute requests viz.; reports, stored procedure, shell script.
• Strong knowledge of order to cash (O2C) and procure to pay (P2P) business flows.
• Expertise in using third party software’s like TOAD, PUTTY and WINSCP3.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proficiency in understanding clients needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS:

ERP: Oracle applications 11i/R12 (Financials, AP, AR, GL, OM, PO, INV, BOM, WIP, Service Contracts, CM, Advanced Collections, HRMS, FA and Shipping).

Languages: SQL, PL/SQL, C, XML.

Databases: Oracle 8i/9i/10g, MS Access, SQL Server 2000, MYSQL.

Web Tools: HTML, Java Script, JSP, MS Front page.

Tools: Oracle Reports 6i/9i/10g, Oracle Forms 6i/9i/10g, Oracle Developer 2000, Oracle Discoverer 4i/9i/10g, Oracle Workflow, TOAD, SQL Navigator, Microsoft Project and Visio.

Operating Systems: UNIX & Linux, Windows98/XP and Windows NT.

EXPERIENCE:

Oracle Applications Technical Consultant

Confidential, Chicago, IL

Responsibilities:

• Involved in converting legacy system data into the respective PO, INV, OM, AR and AP modules of Oracle Applications.
• Prepared the conversion strategy and managed Conversions. Involved in identifying the data sources, mapping the data, design and develop the feeder system using SQL*Loader and PL/SQL and implementing the conversion.
• Worked on INV Stock locators, AP Suppliers, INV Item transaction defaults, INV Primary Pick, PO ASL, MRP Sourcing rules conversions.
• Involved in developing custom inbound Interface to load vehicle data into Oracle engineering.
• Responsible for Installation, Upgrade, Development, and Implementation of Oracle Applications R12.
• Involved in full life cycle Implementation of order to cash.
• Extensively worked on Order management and shipping for different extensions.
• Involved in developing pl/sql web services in Service Oriented Architecture (SOA) using protocols such as SOAP and REST.
• Developed custom pl/sql Web Services to support users to create Sales Orders, Customers and Stock Check etc from 3rd party tools.
• Worked on OEOH and OEOL workflows, added few rules to place Order oh hold.
• Created few backend objects (util pkgs) for EDI that supports all the validations for creating Sales orders and Purchase orders.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Created Install Scripts for the developed objects to migrate between the Instances.
• Developed Custom extension to create Sales orders from csv/flat file.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for conversion, interfaces, reports and extensions.
• Wrote UNIX Shell scripts for copying and moving files to and from the server.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating indexes.
• Involved in customization of Standard Oracle Reports in Purchasing and Order Management as per client requirement, using Oracle Reports.
• Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 6i, XML publisher.
• Converted various oracle Seeded report templates into BI publisher to display the layout in a user-friendlier format.
• Customized various forms using oracle from personalization as per the client requirements.

Environment: Oracle Applications R12 (PO, OM, INV, AR, AP, GL), Oracle 11g, Reports 9i, forms 9i, BI Publisher, OAF, SOA, SQL LDR, Advanced Collections, TOAD, Stored Procedures, Windows 2000, UNIX, AOL.

Oracle Applications Techno Functional Consultant

Confidential, New York.

Responsibilities:

• Used SQL * Loader and UTL FILE packages for data interfaces.
• Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables
• Imported data from Legacy system (Mainframe) to Account Receivables tables using SQL*Loader and validated them using PL/SQL Procedures.
• Migrated GL and AP custom interfaces and reports, during Oracle financials upgrade project from 11i to R12.
• Worked on BOM BILL OF MTLS INTERFACE in BOM module to load the data into the base table.
• Identified the pain points and discussed with the client for the probable solutions.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Resolved issues relating to Service Contracts and Advance pricing, which was not calculating the price properly in case of step pricing for usage lines in service contracts.
• Prepared the conversion strategy and managed Conversions. Involved in identifying the data sources, mapping the data, design and develop the feeder system using SQL*Loader and PL/SQL and implementing the conversion.
• Converted sales Order information from legacy system to oracle Applications using custom program and API to effect the OM tables.
• Worked on various Business Areas in Discoverer Admin and extensively worked on the Desktop and Plus environment.
• Developed reports in AP, GL and AR modules using Reports9i.
• Created Request Groups and Value sets for reports.
• Developed the Request sets that are scheduled to submit concurrent programs in a desired sequence as per the functional document.
• Developed documentation for workflow of process to teach end users in AP, AR and GL modules using UPK.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Created PDF/EXCEL output’s for reports based on requirements
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level
• Experience in customization of XML Publisher reports.
• Created output format in XML, new templates for XML Publisher to display the reports in client requirement format.

Environment: Oracle Apps 11i/R12, AOL, ORACLE 9i/10g, PL/SQL, Advanced Collections, Oracle Workflow, Forms 6i/10g, Reports 6i/10g, Toad 2.5, Discoverer, XML/BI Publisher, UNIX.

Oracle Applications Technical Consultant

Confidential, St. Louis, MO

Responsibilities:

• Gather, analyze and document the requirements.
• Provide techno-functional leadership in the configuration, customization, implementation and maintenance of EBS in business environment in AR, AP, CM, FA and GL modules.
• Worked on the BOM Conversion from Legacy system into the Oracle application tables using the BOM Open Interface.
• Involved in the data conversion of historical legacy data from 11i to R12; performed validations prior to transferring data into OM Open Interface tables and subsequently used Order Import program to populate base tables. Tools used for loading are SQL *Loader and PL/SQL.
• Successfully designed and implemented the Purchase Orders Open Interface. Activities involved creation of control file, porting Interface tables and then used Import Standard Purchase orders concurrent program to port the data into the Oracle base tables.
• Worked on outbound processes to send Vendor, GL Accounts, payments, Purchase orders, Receipts information from third party system ASPEN for PO matching and invoice approvals.
• Worked on automated process of select/build/format/confirm and creation of payment batches, sending positive pay files to the bank for Checks and ACH/Wire Payments.
• Developed payables open interface program for creating invoices for Duty, Freight and Commission charges.
• Designed and developed interfaces and custom PL/SQL objects.
• Provide production support and trouble-shooting expertise for Oracle 11i Applications.
• Develop/Customize oracle reports using reports 6i/10g, XML Publisher.
• Develop/Customize oracle forms using 6i/10g.

Environment: Oracle database 10g/11g, Oracle Applications 11i & R12, Toad, HPUX, Red hat Linux, SQL, PL/SQL, Xml Publisher, Discoverer and Oracle Reports/forms 6i/10g

Oracle Applications Technical Consultant

Confidential, Newport Beach, CA

Responsibilities:

• Developed new extensions and customize existing objects as per business requirements in Oracle EBS R12 system.
• Responsible for handling tickets created by users in everyday business process.
• Developed Item Quantity Outbound interface to Extract Item Quantity details to the Legacy system.
• Developed Requisitions Interface to upload the requisitions data from Legacy system into Oracle apps base tables.
• Developed outbound interface to extract the Back Order details from Oracle to legacy using the UTL FILE Utility.
• Designed and developed applications for new divisions in Oracle EBS R12 that replicates existing legacy systems.
• Extensively worked on the TCA Architecture to create the customers and update their personnel information.
• Provided technical and functional support to users and help them in understanding Oracle R12 application.
• Developed reports are per user requirements and migrate all data from legacy application to Oracle EBS R12 through interfaces.
• Performed testing, resolving defects and coordinate with Oracle support.
• Worked on complex problems where analysis of situations or data requires an in-depth evaluation of various factors.
• Responsible for Application performance and bug fixes.
• Developed Custom reports, Customized existing reports (Bill of Lading, Customer AR Aging Report, Inventory Planning Report, Price evaluation report, Shipping Order, Sales Order Report) according to the functional specifications using Reports 10g, XML publisher.
• Worked on Shipping Tag and Receiving Tag Printing.
• Developed Custom Forms to submit the reports from tools menu and defaulting to the printer.
• Worked as part of the production support team in resolving daily Production issues.
• Extensively participated in developing functional and technical documents (MD70)and (MD50).

Environment: Oracle Applications 12.0.6 (OM, INV, AR, QP, PO, AOL, TCA, Advanced Collections) Oracle 10g, Reports 10g, Forms 10g, TOAD, Windows XP, UNIX.

Oracle Applications Technical Consultant

Confidential, St. Louis

Responsibilities:

• Worked on Project Approval Workflow (PAPROWF) and Project Change Order Workflow (PAWFCISC) to customize it from end to end.
• Re-designed Lawson to Oracle HR Interface as per the user requirements.
• Customized the Project PO Requisition Account Generator Workflow extensively to in corporate new requirement to involve Projects in requisitions.
• Createed a new GL COA Mapping Interface and CM to GL Interface for MCF.
• Involved in Creating a BES interface which to upgrade the existing MCBS system.
• Used JDeveloper to perform OA Framework Extensions to Controllers and View Objects.
• Customized Custom.pll to in corporate zoom functionality for AP Fishes for Belgium Localizations.
• Created Bank Statement Loader- Corporate program which is run on a daily basis to upload the electronic bank statements from JPMC into Oracle Cash Management.
• Involved in modifying many custom views, to improve the performance while utilizing the features of 10g during upgrade.
• Implemented many code fixes, enhanced workflows, in modules such as GL, AR, AP, Projects, CM, as per user requirements for enhancements.
• Involved in many fixes for the Folders in Discoverer, along with improving the performance of the views behind by tuning.
• Developed many reports using Oracle Report Builder along with XML Publisher and also CSV reports using PLSQL.
• Created many Data fix scripts, to be implemented in Production as per MasterCard standard rules.

Environment: Oracle Apps 11i, GL, AP, AR, PO, CM, Projects, Project Costing, Resource Management, Project Billing, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, JDeveloper, TOAD.

Oracle Developer

Confidential

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Worked closely with database developers to ensure adherence of the database guidelines, standards and procedures and generated system plans
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Wrote SQL Scripts to create, alter, and drop database objects, like tables, views, and sequences
• Created stored procedures, triggers, and functions to retrieve data from the database using PL/SQL
• Developed SQL Applications for extracting the data from the Oracle tables
• Created user defined Exceptions while Handling Exceptions
• Involved in complete documentation using MS Office
• Involved in testing and fixing bugs on test and on-line data
• Troubleshooting production problems and worked effectively with other team members to identify and address problems.

Environment: Oracle 9i, PL/SQL, Reports 6i, Toad, Unix