PROFESSIONAL SUMMARY:

• Over 10 years of experience in Designing, Developing, Customizing, Data conversion, Implementing and Upgrading Oracle Applications R12, 11i using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms 10g/9i/6i, Reports 10g/9i/6i, and Discoverer 10g, Unix, Linux and Shell Scripting.
• Extensive experience in Oracle SCM, Financial, AOL (Application Object Library) and HCM modules with in depth knowledge of their integration. Detailed knowledge on O2C and P2P transactional flows with experience in related setups.
• Complete knowledge on Order to Cash and Procure to pay life cycles
• Proficient in Technical aspects of Financials (O2C and P2P), SCM and HCM (HR, OTL and OAB), OPM, PROJECT ACCOUNTING modules and their preliminary setups.
• Experience in System Administration activities and Strong knowledge of AOL.
• Expert in custom Form Development and Form Personalization.
• Experience working with Oracle Application Express (APEX).
• Proficient in designing and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Extensive experience in designing and developing new reports and customizing standard Reports and Forms using Oracle Reports 11g/10g/6i, Discoverer 10g, XML Publisher and Forms 10g/6i.
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers, SQL * Loader scripts and shell scripting.
• Experience in supporting the production system and handling day - to-day issues.
• Experienced various stages of Software Development Life Cycle Process (SDLC) and its deliverables.
• Analyze Troubleshoot Root cause, Fix the Transaction level issues for month end and quarter end support.
• Experience in writing numerous MD70, MD120 and CV40 and Test Script documents in Financials and HCM modules.
• Excellent knowledge of Multi-Org and Multi-Currency implementation solutions.
• Experience with Oracle Support in resolving multiple R12 issues in its first release.
• Worked on developing OAF pages, Customizations, Personalizations and Extensions of View Objects and Controller Objects.
• Worked in world’s first R12 implementation with global footprint (UTStarcom). Had exposure to all R12 implementation issues, tips and tricks.
• Profound experience in unit testing, Integrating and User acceptance testing activities.
• Proficient in integrating outbound interfaces with Banks and Payroll systems using SFTP.
• Experience in writing technical reference guides, user manuals and other technical related documentation according to Application Implementation Methodology (AIM).
• Strong interpersonal, analytical, and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation. Result oriented, organized with good Presentation skills.
• Excellent learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS:

ERP: Oracle EBS R12/11i

Tools: JDeveloper, Forms 10g/6i, Reports 11g/10g/6i, XML & EDI Gateway, HFM, FDM, OBIEE, TOAD, Oracle Discoverer10g, SQL *Loader, PL/SQL Developer, SQL Developer, SQL navigator, XML Publisher, Quality Center, Load Runner, Accurev and SharePoint and PVCS.

RDBMS: Oracle 11g/10g/9i, SQL Server.

Languages: PL/SQL, C, C++, HTML, Perl, VB.NET XML, DHTML, Core JAVA and Shell Scripting.

Version Control: PVCS, Accurev

EMail: MS Office Outlook and IBM Lotus Notes.

Oracle Applications: Accounts Payable (AP), Accounts Receivables (AR), General Ledger (GL), Project Accounting, Cash Management (CM), Fixed Assets (FA), Human capital Management (HCM), Purchasing (PO), Order Management (OM), Inventory (INV), Bills of Material (BOM), and AOL.

Document Methodologies: MD050, MD070, MD120 and CV60.OS: UNIX, Sun Solaris, Windows XP/Vista/Windows7 and Linux.

EXPERIENCE SUMMARY:

Confidential, San Diego, CA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked on developing custom fine tuned PLSQL procedure/API for Customer Integration. This involves gathering requirements from the business users, creating the mapping document and developing the code, unit testing and deploying to PROD.
• Worked in a fast paced environment and provided quick results in an agile environment.
• Developed customer benefits integration (this information is maintained in customer relationships) from Oracle to Salesforce and also from Salesforce to Oracle. Requirement gathering, mapping, developing and unit testing.
• Experience using complex sql or PLSQL functions like TABLE CAST and to use them efficiently using Bulk Collection methodology (Converting rows of data into a temporary table).
• Developed API calls for Cancel Order and Create Order from Salesforce to Oracle.
• Developed to and fro Integrations from Salesforce to Oracle for Assets and Install Base.
• Proficient in using Bulk collect, Analytical Functions and performance optimization techniques.
• Tuned several views that they already had in their Production environment. The new views are running 48% better than what they had.
• Developed Order Management integration from Salesforce to Oracle.
• Developed several Oracle Reports, gathering requirements from Business users.
• Professional in developing Oracle Reports with RTF templates and Data Definitions using XML Administrator Responsibility. Developed various invoices for each country.
• Created Price List and Modifiers and qualifiers.
• Worked on Form customizations and Personalizations.
• Experience in creating territories, resources in Oracle applications.
• Developed package for assigning the postal codes for the territories.
• Developed a procedure and created a concurrent program to update the territories for the customer sites based on Business specific logic for each country.
• Developed all the above-mentioned components or objects for the countries like Switzerland, Canada, Ireland, and UK.

Environment: Oracle Applications R12.2.3 (OM, AP, AR, GL, Reports 10g, SQL*Plus, SQL Developer, Forms 10g, Jdeveloper, Oracle Workflow Builder.

Confidential, Richmond, VA

Oracle EBS Technical Consultant

Responsibilities:

• Worked on developing several custom PL/SQL stored procedures as per the requirement.
• Optimized the entire database (incudes custom programs, SQL queries, Reports, Forms) to make the queries or concurrent programs run faster.
• Worked on Sales Order Import.
• Worked with a functional lead in migrating all the CEMLI objects from 11i to R12.2.3 including modules like SCM, Finance, Project Accounting.
• Developed a custom Order Entry form.
• Developed an invoice interface to AR.
• Interface developed for billing system feed to Oracle Receivables in Oracle Financials.
• Worked on enhancing the Interfaces in OM, AP, AR.
• Customized MDM Interface to do the delta load instead of fresh load each time.
• Aided in developing Customer interface. Quite good experience creating SR with Oracle.
• Worked on migrating custom OAF pages in HRMS and Finance modules.
• Customized a PTO Carryover Fast Formula.
• Worked on OAF extension in iProcurement requisition page to print ad-hoc PO Print report and re-send to Vendor.
• Enhanced a custom interface in Project Accounting module.
• Worked on migration of P2P modules. Migrated all the reports, concurrent programs from 11i to R12.2.3.
• Developed a new custom OAF page and worked on Customization, Personalization and Extension of several OAF pages as per the requirements in R12 (For the custom OAF pages).
• Customized an iExpense OAF page - Create Expense Report.
• Gathered the requirements from the business users to develop a new Custom Concurrent Program that will attach the resumes of short-listed (Qualified) candidates in a vacancy and make a single attachment (including the PDF’s) and use the workflow to send an email to the recruiter with the html attachment.

Environment: Oracle Applications 11i and R12.2.3 (OM, AP, AR, GL, INV, OPM, BOM, Pricing, HRMS, OAB), iProcurement, Project Accounting, Reports 10g, SQL*Plus, SQL Developer, Forms 10g, XML Gateway, XML Publisher, Jdeveloper, Oracle Workflow Builder.

Confidential, Boston, MA

Oracle Technical Consultant

Responsibilities:

• Primarily worked on O2C and P2P modules.
• Created flex fields in various forms in AP, AR, OPM modules as per the requirements.
• Developed 3 complex reports from Custom financial tables (Group Above, Matrix and Group Left reports). The report execution time being less than 1min (Max limit is 2mins).
• Worked on developing Customer Interface.
• Good experience in interacting with Business Users to gather the requirements.
• Developed reports in GL, OM and AR Modules.
• Created external tables and worked on developing SQL queries using external object types.
• Worked on loading data into Oracle standard tables using Stating tables with the help of SQL*Loader.
• Wrote several Packages and created several views to support the Business requirement (Either for a project or for a report).
• Worked on iProcurement (View cart Button) to fix errors due to data corruption.
• Worked with development team for developing custom expense application, which transfers 3rd party employee expense reports that are exported as flat file and in approved status to Project Accounting Interface tables.
• Wrote several PL/SQL stored procedures to enhance the functionality of various applications.
• Worked as a member of the team for RMBS project and provided complex queries (best performance queries) for the RMBS interface. The interface shows the deals, collateral and tranche information.
• Performance Tuning is crucial in developing reports as the tables have very bulk load of data.
• Worked on migration of 250 reports from 6i to 11g.
• Worked on Conversion of Item Cost from legacy to Oracle Costing tables
• Worked on more than 25 report enhancements. Developed over 15 new reports gathering the requirements from the Business Users.
• Experience in writing more than 2500 lines of SQL statement with the runtime of the query being less than 30seconds.
• Wrote several MD70 and MD50 documents for the reports/packages developed.
• Proficient in using Analytical Functions to get better performance.
• Provided best performance queries which gives historic and forecast analytics at deal level, collat level and tranche level.
• Worked on Form enhancement to add attributes showing analytical data.
• Developed shell script to FTP the reports to user specific locations/directories.
• Developed a Perl job to create the report in an Excel Format and distribute it to various users.

Environment: Oracle Application R12, Reports 6i, Reports 11g, Forms10g, PLSQL Developer, Accurev.

Confidential, Billerica, MA

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Worked on issues pertaining to various Modules (OM, AR, INV, OPM, BOM, Advanced Pricing) in a Technical Support Role.
• Customized various reports and forms as part of issues.
• Customized OPTIO documents like Invoices, Order Acknowledgement and Shipment Notifications.
• Developed CUSTOMER MASTER, CUSTOMER ADDRESS, CUSTOMER PARTNER, CUSTOMER SALES, CUSTOMER LONG TEXT, and SALES BOM Conversions for CCT Countries (Belgium and Netherlands).
• Customized iProcurement Requisition and Receiving pages.
• Personalized iProcurement Prefences age, Requisition Summary display page and Requisition checkout page.
• Developed a custom package to do the purge process for old records in OTM.
• Worked on Rail Car Tracking. Provided the mapping for middleware team for transmission of the locations stored in OTM.
• Created an Automatic Agent in OTM.
• Developed POP (Price Offer Program) conversion for CCT Countries.
• Customized Cross Selling (To maintain the transfer cost of items over several Legal Entitites) and Trackwise Interfaces.
• Worked on Value Chain (Advanced Supply Chain Planning) program to maintain the database centric holistic planning.
• Created a custom program and registered under Project Accounting responsibility, which automatically submits Interface Expense reports to payables and Payables Invoice Import programs for final invoice generation and processing.
• Experience working with E-credit system.
• Developed MDM Interface (Master Data Management) to maintain the item SYNC between Oracle and SAP based on the requirement. The MDM System gets the data from Oracle, Tempo, Tempo+, etc (from other SAP systems).
• Worked on enhancements for MDM Interface which includes gathering the requirements (Mapping document), developing the code, writing test scripts, writin g technical document (MD70).
• Developed Price Optimizer interface. This interface is used to maintain the CUSTOMER SPECIFIC PRICING in SAP for the Oracle items. Worked on the Price Lists and Modifiers.
• Worked on Customer specific logic in BRUECKE project. The project to integrate Order Management of both Confidential as a single website. (As Merck SAP based acquired Millipore).
• Wrote MD70 for Price Optimizer Interface, MDM Interface, Customer Conversions and BOM Conversions.
• Gathered requirements from the business users and customized a OBIEE report.
• Created Sales Order interface to import the orders coming from legacy DB.
• Worked on Item conversion program to load the items into Oracle from Legacy system
• Worked on RIBS report related to Inventory and BOM.
• Worked on Service Contracts interface to load contracts into Oracle from legacy system.
• Developed XML Publisher report on Service contracts like Service Request report.
• Auto creates the orders based on a Quote.
• Improved the performance of several objects like Alerts, Value Chain program, MDM program, etc. upon the business request.
• Hands on experience with XML Gateway, XML Publisher, and Business Object reports, etc.
• Worked with Offshore development team to get some of the enhancements done. (Gave necessary KT).

Environment: Oracle Applications 11.5.10.2 (OM, AR, INV, OPM, BOM, ADVANCED PRICING, AP, GL, iProcurement and OPM) Reports 10g, OBIEE Analytics, SQL*Plus, TOAD, Forms 10g, XML Gateway, XML Publisher, and RDMS 10.2.0.5.0 g.

Confidential, Houston, TX

Oracle Financial Technical Consultant

Responsibilities:

• Designed, documented and developed Data Conversions for Master data (Suppliers, Customers and Employee data).
• On time delivery of conversions was provided with required SOX Reporting using Error Messaging Framework.
• Developed interfaces for AP Invoices, AR Invoices, GL Journal and also Intercompany Invoices between ALLEGRO and Oracle Modules using Fusion Middleware Architecture.
• Configured payments (banks, bank accounts, payment formats, payment process profiles and payment process templates) module for processing Check, ACH and WIRE payments from 2 corporate bank accounts.
• Designed and developed outbound Payment Interfaces to Confidential for processing ACH and WIRE payments.
• Developed a XML Check Template as per Chase bank preprinted check format, for in house Check Printing.
• Developed Journal Entry interface by writing a custom package to validate the data from the flat file and populate the same into GL interface table.
• Developed a PL/SQL program, which reconciles the Reply Bank data file (Lockbox) and call Receipt API to reverse the receipts for which credit card status is declined.
• Forms Personalization Utility has been used to call a PL/SQL procedure and update the AR Descriptive flex fields.
• Customized Account Payables (AP) Reconciliation Reports like AP Trail Balance Report, Posted Invoice Register, Unaccounted Transactions report, Invoice on hold report and Supplier listing report, Purchase Order Detail report in PO.
• Customized Account Receivables (AR) Reconciliation Reports like Active customer listing report, Unmatched Receipts report and Invoice aging report.
• Registered customized Oracle reports, XML Publisher reports and XML RTF templates using System Administrator, Application Developer and XML administrator responsibilities.
• Developed HR benefit extract program that send all benefits information of enrolled employees and their dependents to Confidential.
• Designed and developed US Payroll interface (Employee data and Hours data) for ADP Payx System and Cayman Islands Payroll Interface for ADP PCPW system.
• Created Custom Responsibilities and Custom Menus as per SOD matrix and migrated to Production.
• Wrote Technical Specifications (MD070), Conversion Mapping (CV060) documents for all RICE development.

Environment: Oracle Applications Suite R12 (AP, AR, IBY, GL, OM, INV, FA, INV, PO, OPM, XLA, and AOL) Reports 10g, OBIEE Analytics, SQL*Plus, TOAD, LINUX, Forms 10g, EDI Gateway, Fusion Middleware, SOA, BPEL, SOA, FSG, HFM, XML Publisher, and RDMS 11g.

Confidential, New York, NY

Oracle Technical Consultant

Responsibilities:

• Designed and documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Creating Staging tables and custom PL/SQL API’s to
• Create Enrollments, Rates
• Populate the elements and amount for employees
• Employees personal details, address, assignments, special information, salary, elements, and direct deposit methods etc.,
• Developed Auto Apply Credit to Invoice (AR) and implemented a unique solution to resolve manual application of invoices to credit memos using AR RECEIPT API PUB.
• Implemented Order Returns with and without credits, which involved setting up transaction type, loading order using SQL Loader, creating receipts to close the order.
• Involved in the development of TCA Customer Conversion program which includes data validation and API calls.
• Performed configuration of Procurement and iProcurement by setting up Purchasing options, Accounting Options, Jobs, and Approval Groups.
• Developed OTL inbound interface which transfers hours into OTL for hourly factory workers.
• Created new inventory organization, which allows Internal Transfers to handle returns from fulfillment (FF) centers. Internal Requisition receipts from FF’s where handled using RCV interface tables.
• EDI (e-commerce Gateway) experienced with documents like 850(PO Outbound), 810 (Invoicing), 856(Orders) and 852(Sales). Proficient with creating Trading Partners, setting up EDI on Customer, suppliers and troubleshooting various issues.
• Designed, developed and documented outbound interface from HRMS to ADP for Payroll Process.
• Designed and Developed 401K Inbound Interface with the ADP.
• Created a Custom PL/SQL program to handle employee transfers and 401K changes after transfer of employees.
• Designed, documented and developed Outbound Interface between Oracle HRMS/Payroll and ADP.
• Customized iRecruitment External Webpage JSP forms for changing Company Logo, adding additional fields to show extra information using OA Framework.
• Developed several Discoverer reports in HRMS, Payables, Receivables, Purchasing and Fixed Assets.
• Implemented Auto Create Purchase Order (PO) to reduce manual entry using PL/SQL, shell script and SQL Loader.
• Designed, documented and developed Interface between ADI Time Management system and Oracle Time and Labor for employee time tracking.
• Worked on shell scripts to move files from shared directory to server, load data into the tables using SQL*loader and sending reports to users.
• Modified print purchase order report to print EDI order.
• Designed XML Template reports to generate output in PDF format.
• Used company specific templates and developed reports using XML Publisher 5.0.
• Customized Positive pay report to generate a file and upload to Citi Bank.
• Developed Inv Movement Report Using Reports 6i, Accrual Reconciliation Report and Error Reports in Manufacturing and Financial modules.
• Used Kintana for Code migration.

Environment: Oracle Applications R12 (GL, AR, AP, FA, CN, OM, PO INV, PA, HR, OTL and OTM), Oracle 10g, Forms 10g, Reports 10g, Discoverer 9i/10g, XML/BI Publisher, TOAD, EDI Gateway, RDMS 11g, Forms Data Loader and UNIX.

Confidential

Oracle Technical Consultant

Responsibilities:

• Involved in the study of existing system, preparing the Functional (MD50), Technical (MD70) design documents and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Designed and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AP Invoices, and Open AR Invoices from legacy system into Oracle Applications.
• Designed and developed an Interface between web based Order Management systems to Oracle Order Management for creation of sales order which involved development of a UNIX shell script, which calls SQL Loader program to load data into custom staging tables and check for uniqueness of the files in UNIX directory to avoid duplicate data.
• Did setups in various modules like Payables, Receivables, Order management and General Ledger like Order & Line Types, defined custom profiles, Invoicing rules, and Conversion rates.
• Form personalizations have been done for around 15 forms (standard custom forms) for all business user requirements, to accommodate specific client requirements for China and International Operating unit Business Users.
• Using XML publisher, Sales order Acknowledgement Report have been developed and also customized AR to GL Reconciliation Report.
• Implemented System Administrative activities like creating new Menus, new Responsibilities, new Functions, and User Authentication security system profile.
• Involved in the design of more than 10 reports using Reports 6i, Discoverer and XML Publisher in Order Management, General Ledger, Payables, Receivables, and Progressive Billing Applications (Custom module).
• Developed Custom Discoverer reports like Monthly customer sales report, Monthly region sales report.
• Developed a report, which showed requisition details, purchase order details, receiving details, invoicing details and payment details in Oracle Procure to Pay Cycle.
• Developed various custom reports and customized standard Oracle reports like Account Status Report and Bank Account Listing as per the business requirements.
• Customized AR account status Report, and AP Trial Balance report using Report 6i tool.
• Created flex fields as required in the forms of various modules like AP, AR and GL.

Environment: Oracle Applications Suite 11i (OM INV, BOM, WIP, PO, AR, AP, GL, XLA, and AOL), Reports 10g, Report 6i tool, Forms 10g, XML Publisher, OA Framework, FSG, SQL*Plus, TOAD, Oracle BI Discoverer 10g, Mercury Quality Center, ITG Kintana 6.0, PVCS (Version Control Software), UNIX, and Test Director.

Confidential

Apps Technical Consultant

Responsibilities:

• Designed and developed Custom AP Payment Check format program which creates payment file in custom format, designed by business users and send it to check printing group.
• Designed and developed GL Outbound Interfaces, which extracts data from Oracle General Ledger and sends them to a reporting team with the help of a tool called Hyperion (which is the major reporting tool for Sherwin Williams to report critical financial data).
• Involved in the study of existing system, prepared the Functional (MD50), Technical (MD70) design document and Conversion Mapping (CV40) documents to extract the data from the legacy system into Oracle Applications open interface tables.
• Developed AP payments Outbound Interface to Asian Banks. Payment types include ACH, USD wires, and EFTs.
• Designed and developed Order Import Interface for daily and weekly feeds of orders.
• Using XML publisher, customized AR to GL Recompilation Report Template and On account Credit memo Gain and Loss Report Template.
• Used Auto Invoice Interface to import Standard Invoices into Oracle receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
• Designed documented and developed an Interface between ADP payroll and General Ledger to load journals into GL on monthly basis.
• Involved in customization of Monthly Journal Entry Detail Report and Monthly Journal Entry Transaction Currency Report. The business users have extensively used these reports for month end closing.
• Designed and developed Custom General Ledger Translation program, which can be used to translate all the foreign sets of books to US dollar sets of books. This translation program is really useful for the smooth closing of their books without hitting any major issues during month end close.
• Customized Corporate Budget Inbound Interface program for Sherwin Williams STORES division, which imports updated Budget data for all Sherwin William nationwide stores into Oracle standard budget tables after doing required business validations.
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface (PO).
• Designed Corporate Budget Conversion program, which does all business validations on the developed Budget Import program. Did all necessary setups like all Budget names and Budget Organizations and Fiscal years for defined budgets and budget organizations.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, XLA, FA, CN and AOL), Reports 6i, Forms 6i, PVCS (Version Control Software), UNIX, ITG Kintana 6.0, Test Director Mercury Quality Center, Hyperion, XML Publisher, OA Framework, BMC scheduler, FSG, SQL*Plus, TOAD and Oracle BI Discoverer 9i.

Confidential

Oracle Consultant

Responsibilities:

• I was involved in the implementation of design, development and testing phases, which accompanied by high degree of user interaction.
• Wrote technical documents for standard invoice interface to load all PO and non-PO Invoice information for internal customers and suppliers, payment outbound interface to Bank of New York (payment types: foreign wires, foreign drafts, USD wires, ACH and checks).
• Involved in import of invoices, receipts, credit memos, and debit memos into Oracle Receivables.
• Developed transactions and their related customer extract interface from AR module to generate out file to AR collect which facilitates collection of invoices created in Oracle receivable module.
• Prepared Technical Specification documents (MD70).
• Wrote conversion code for Customer, Open Invoices and Item in which many business validations have been taken care before loading all the data into Oracle interface tables.
• Developed project costing inbound interface, which loads the entire project cost transactions from internal systems to Oracle 11i applications after performing all the required validations.
• Interacted with IBM India development team on daily basis and on time delivery of all the components was provided in spite of aggressive onsite schedule.
• Developed Receivable Open Interface and ran it to import data into RA interface tables and used the standard API “Auto Invoice” to import the customer invoices.
• Created reports from the scratch as per users requirements in AP, AR and OM.
• Developed Discoverer reports for Oracle project accounting and Payables.
• Developed Project Billing and Financial Review Summary Report and Project Costing Customer Estimates Report. Technical
• Developed project billing details outbound interface and FTP’d the extracted file to outside back office system. Wrote shell script for FTP and the technical document.
• Tools such as ITG Kintana (Ver: 6.0.0) and PVCS (version control software) have been used to migrate numerous RICEW objects.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, OE, PO, and AOL), TOAD, Oracle Discoverer 4i, Unix and Shell scripting ITG Kintana 6.0, PVCS (Version Control Software), Test Director, Reports 6i, XML Publisher, SQL*Plus, SQL*Loader, OA Framework.