SUMMARY:

• Seven years of experience as a Techno - Functional consultant in Oracle applications (E-Business Suite) implementation, enhancements, customizations, migration, interfaces and conversions.
• Expertise in the technical and functional aspects of Oracle applications R 12/11.5.10/11.5.9/11.0.3 financial, supplychain 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), Order Management (OM), Cash Management (CM), Fixed Assets (FA) & HRMS.
• Well experienced in Reports, Interfaces, Conversions, Extensions and Workflow (RICEW), implementation and support in the various Oracle apps modules.
• Involved in implementing versions/upgrades of the 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 and under Windows/UNIX/LINUX environments.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suites of applications.
• Extensive experience in writing Oracle backend objects like, Database Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• Expertise in development of the barcode labels and also developed barcodes in the BI publisher reports as per the clients requirements. Familiar with third party label design tools like Loftware for designing labels.
• Created the install scripts to migrate objects between instances.
• Expertise on data uploading tools like More4Apps and WEB ADI to upload data into the application.
• Created the concurrent programs to execute requests viz. reports, Stored Procedures and shell scripts.
• 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 the business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proficiency in understanding the client’s needs and generatedthe modified existing data in Oracle applications according to the requirements and specifications.
• Strong analytical, inter-personnel, problem-solving withproven ability to work under pressure.

TECHNICAL SKILLS:

ERP: Oracle applications 11i/R12 (AP, AR, GL, OM, PO, INV, BOM, WIP, ServiceContracts, 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, OracleDiscoverer 4i/9i/10g, Oracle Workflow, TOAD, SQL Navigator, Microsoft Project and VisioOperating SystemsUNIX & Linux, Windows98/XP and Windows NT

EXPERIENCE:

Oracle Applications Techno-Functional Consultant

Confidential, Teaneck, NJ

Responsibilities:

• Worked on solution designs and development of financial applications to integrate Wide Orbit applications with Oracle EBS.
• Worked on integration of AR with (Wide Orbit) to import invoices in to EBS.
• Designed the development and testing of creating and applyingcash receipts and created reversals as part of a Wide Orbit implementation.
• Worked on a conversion of suppliers and customer (TCA) data into EBS from Wide Orbit.
• Setup the GL accounting hierarchy using KFF by creating value sets for each segment and defined the hierarchy based on the client’s requirements.
• Worked on design, development and testing of custom BI publisher reports in GL for accounting hierarchy and balance fact reports based on the client requirements.
• Designed and developedthe BI publisher reports in AR for aging and DSO reports.
• Worked on design and development of outbound interface to send AP and AR invoices to the trading partners.
• Created custom views, PLSQL scripts for various extensions in AP, AR and GL to interface data for reporting.
• Worked on integration of financial and supply chain modules of EBS to integrate with SAPBO for reporting purposes.
• Experienced and worked on data mapping of AR, AP and GL base tables to get the reporting data into SAPBO through Informatica.
• Worked on identifying the gaps between EBS and then SAP reporting to ensure that a smooth transition took place in implementation.

Environment: Oracle Applications R12 (PO, AR, AP, GL, PA and TCA), Oracle 11g, Reports 9i, forms 9i, BI Publisher, OAF, SOA, SQL LDR, TOAD, Stored Procedures/Functions, Windows 2000, UNIX, AOL, SAP BO and Crystal reports.

Oracle Applications Technical Consultant

Confidential, Westlake, OH

Responsibilities:

• Worked on gathering requirements, design, development and testing of conversions, interfaces, extensions, BI publisher reports and forms personalization’s.
• Worked on design/development and testing of the custom bank loader interface to load bank statements in cash management.
• Developed auto lockbox interface. SQL*loader to import receipt data into interface tables after defining lockbox and transmission format and running lockbox interface form transferred data into Oracle receivables.
• Worked on the system administrator activities like managing concurrent managers, application user setup, defined responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs and profile options as per the requirements.
• Converted seeded RDF reports in to XML BI publisher reports and created new RTF templates based on client-required format.
• Worked on design and development of Loftware labels to print item nameplate details in the warehouse.
• Involved in development and testing of custom extensions and BI publisher reports in OM and shipping.
• Developed GL interface for importing journals from thelegacy systems into GL interface table.
• Worked on the development and deployment of outbound interface to trade sphere to send AR invoices to the customers.
• Worked on purchase orders and pick slip reports to develop a custom BI publisher template and printed the header data of this report in a barcode format.
• Created various custom programs to load demand and forecast history into Demantra and ASCP.
• Worked on complex shipping reports like pick slip, pack slip, BOL and export invoices etc.
• Developed custom views in OM and TCA for discoverer reporting purposes.
• Involved on go live activities, worked on production issues and gave 24/7 production support which also included the end users on performed validations and reports.

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

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 developed the feeder system using SQL*loader and PL/SQL and implemented the conversion.
• Worked on INV stock locators, AP suppliers, INV item transaction defaults, INV primary pick, PO ASL and MRP sourcing rules conversions.
• Involved in developing custom inbound interface to load vehicle data into Oracle engineering.
• Responsible for installation, upgrades, development and implementation of the Oracle applications R12.
• Involved in the full life cycle implementation of orders to cash.
• Extensively worked on order management and shipping for different extensions.
• Involved in developing PL/SQLWeb services in Service Oriented Architecture (SOA) using protocols such as SOAP and REST.
• Developed custom PL/SQL Web services to support the users to create sales orders, customers and stock checks etc., from third party tools.
• Worked on OEOH and OEOL workflows, added few rules to place orders on hold.
• Created few backend objects (util pkgs) for EDI that supports all the validations for creating sales orders and purchase orders.
• Worked on creating custom labels in WSH (shipping) using Loftware tools to print on label printers in the warehouse.
• Developed interfaces to load the GL data from legacy systems into the GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent programs.
• Developed PL/SQL scripts to load order data from the external systems to OM interface tables and OE base tables.
• Created install scripts for the developed objects to migrate between the instances.
• Developed custom extensions to create sales orders from the csv/flat file.
• Involved in design of AIM (ApplicationImplementation 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, explainplan, trace and created Indexes.
• Involved in customization of standard Oracle reports in purchasing and order management as per the client requirements, using Oracle reports.
• Developed various custom reports, customized the existing reports (PO, purchaseorder and releaseddetail reports and purchase requisition status reports) according to the functional specifications using reports 6i, XML publisher.
• Converted various Oracle seeded report templates into the 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, Grafton, WI

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/SQLprocedures.
• Migrated GL and AP custom interfaces and reports, during Oracle financials and upgraded the projects from 11i to R12.
• 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 the 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 developed the feeder system using SQL*Loader and PL/SQL and implemented the conversion.
• Converted sales order information from the legacy system to the Oracle applications using custom programs and API to affect the OM tables.
• Worked on various business areas in discoverer admin and extensively worked on the desktop and 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 the Workflow process to teach end users in AP, AR and GL modules using UPK.
• Created report output format in XML/BI, new templates for XML/BI publisher to display the reports in the 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.

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

Oracle Applications Technical Consultant

Confidential, St. Louis, MO

Responsibilities:

• Gathered, analyzed and documented the requirements.
• Provided 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 the legacy systems 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 the OM open interface tables and subsequently used the order import program to populate base tables. Tools were used for loading theSQL *Loader and PL/SQL.
• Successfully designed and implemented the purchase orders open interface. The activities involved were the creation of control files, porting interface tables and then used the 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 and thereceipts information from third party systems ASPEN for PO matching and invoice approvals.
• Worked on the 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 programs for creating invoices for duty, freight and commission charges.
• Designed and developed interfaces and custom PL/SQL objects.
• Provided production support and trouble-shooting expertise for the Oracle 11i applications.
• Developed/customized theOracle reports using reports 6i/10g, and XML publisher.
• Developed/customizedOracle 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 customized existing objects as per the business requirements in Oracle EBS R12 system.
• Responsible for handling tickets created by users in the everyday business process.
• Developed item quantity outbound interface to extract items fromquantity details to the Legacy system.
• Developed requisitions interface to upload the requisitions data from the 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 the existing legacy systems.
• Extensively worked on the TCAarchitecture to create the customers and updated their personnel information.
• Provided technical and functional support to users and help them in understanding Oracle R12 applications.
• Developed reports are per the user requirements and migrated all of the data from legacy applications to Oracle EBS R12 through interfaces.
• Performed testing, resolving defects and coordinated with Oracle support.
• Worked on complex problems where analysis of situations or data required 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 planningreport, price evaluation report, shipping orders, sales order reports) 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 the tools menu and defaulting to the printer.
• Worked as part of the production support team in resolving the daily production issues.
• Extensively participated in developing functional and technical documents (MD70)and (MD50).

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

Oracle Developer

Confidential

Responsibilities:

• Developed new extensions and customized the existing objects as per the 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 items from the quantity details to the Legacy system.
• Developed requisitions interface to upload the requisitions data from the 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 the existing legacy systems.
• Extensively worked on the TCAArchitecture to create the customers and update their personnel information.
• Provided technical and functional support to users and helped them in understanding Oracle R12 application.
• Developed reports are per the user requirements and migrated all of the data from legacy application to Oracle EBS R12 through interfaces.
• Performed testing, resolving defects and coordinated with Oracle support.
• Worked on complex problems where analysis of situations or data required 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 reports, inventory planning reports, price evaluation reports, shipping orders and sales order reports) 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 the tools menu and defaulted 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.