SUMMARY:

• About 7 years of IT experience in developing cost effective solutions as a Sr. Oracle apps Technical Consultant using Oracle Applications and related technologies including Implementations, upgradations and Customizations.
• Successfully completed full life cycle implementations using Oracle Applications R12.2.4/ R12.1.3 / R 12.1 / 11.1.3 / 11. i.
• Extensive experience in Oracle Applications e - Business Suite Modules - Oracle Supply Chain Management(Order Management, Inventory, Oracle Process Manufacturing, Purchasing), Oracle Financials (Accounts Payable, Accounts Receivable, General Ledger), Trading Community Architecture (TCA), Application Object Library (AOL),Customer Relationship Module (CRM).
• Experience in defining processes relative to Order to Cash (O2C), Procure to Pay (P2P) business cycles.
• Expertise in extending and customizing Oracle EBS using SQL, PL/SQL, Shell Script, Oracle Forms & Report, SQL*Plus, SQL*Loader, Workflow builder.
• Expertise in implementingRICE(Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Extensively used oracle APIs and Open Interfaces.
• Developed interfaces between legacy systems and Oracle Applications.
• Good experience in using Kintana and STAT tool for migration of database objects.
• Proficient in SQL and PL/SQL tuning techniques.
• Proficient in mapping business requirements, use cases, scenarios, business analysis, and workflow analysis. Act as liaison between business units, technology and IT support teams.
• Good experience on WEBADI and OAF form Personalization’s.
• Has knowledge on Oracle Applications Framework (OAF).
• Basic knowledge on Oracle ADF.
• Extensive experience in customization of Oracle Application modules, which involves Forms Personalization.
• Good working knowledge in designing technical documents using AIM Methodologies (MD050, MD070, CV40,CV70, BR100 and TE010).
• Post production support forESS legacy application.
• Capability to adapt and learn new tools and applications.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i

ERP: Order Management (OM), Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Inventory (INV), Purchasing (PO), Oracle Process Manufacturing (OPM),Fixed Assets (FA),Cash Management (CM), Application Object Library (AOL), SLA, TCA, Oracle Process Manufacturing (OPM), iProcurement, Customer Relationship Module (CRM).

Tools: SQL*Plus, SQL*Loader, Toad, Winscp, Putty, SQL Developer, Oracle10g Reports & Forms, Microsoft SQL Server, Workflow Builder, JDeveloper.

Operating Systems: Windows 2000/98/XP, Unix

Languages: SQL, PL/SQL, JAVA, HTML, XML, C, C++, UNIX, C#.

PROFESSIONAL EXPERIENCE:

Confidential - Austin, TX

Sr. Oracle Technical Consultant

Responsibilities:

• Involved in study of existing system, preparing Technical (MD070) design documents as per business requirements using AIM Methodology.
• Produced Installation Instructions documents (MD120).
• Gathered functional user inputs and produced TE020 document.
• Involved in multiple CRP’s and UAT’s to meet business users requirements.
• Currently working on both SCM and Finance Modules.
• Gathered Business requirements, designed and developed custom Forms and Reports.
• Working on both P2P (Procure to Pay) and OTC (Order to Cash) Business cycles.
• Setup DFF’s on standard and custom forms to store additional information. Ex: Transaction Expense Activity, Revenue Activity, Budget Fiscal Year, Warrant reporting attributes.
• Created NI workflows for employees which will send the notification to managers to approve the requests submitted by respective employees (ex. Time card approval, leave management etc.).
• Responsible for all deliverables including Data extract programs, Reports and Concurrent Programs.
• Created EITO CUSTOMER PROC and EITO ITEM PROC stored procedures which retrieves the Customer and Item data from Oracle Standard tables.
• Worked on Input VAT Report for calculating the tax depends on tax codes with respect to total distribution amount.
• Created Trigger on AR PAYMENTS INTERFACE ALL to generate receipt number automatically.
• Developed a report to show all the payables cleared invoices sorted by invoice groups.
• Worked on Vendor interface program to import supplier, supplier sites and site contacts into oracle applications.
• DevelopedNIC Order Import Interfacefor business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into theOrder Import (OE) headersandline interface tables and tan toOEbase tables.
• Resolved issues in Discoverer Reportsduring the Period wise, monthly and yearly closing.
• Developed workbooks usingDiscovererto develop custom reports for business analysis.
• DevelopedUNIX Shell Scripts.Customized and developed Oracle Forms and Oracle Reports using OracleForms 9i/10gandReports 9i/10g.
• Setup AR as per client requirement.
• Designed and Developed anOutbound Interfaceto send the Orderdetails for a givencustomer.
• As per the company requirements, created and implementedXML/BI Publisherreports for different products likePO, AP, FAandGL.
• Created RTF, Excel and XML Templates using XML Publisher/BI Publisher.
• Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility.
• Has created an Oracle Alert to send an email regarding the inactive/terminated employees to the responsible persons who are in the custom lookups.
• CreatedUNIXshell scripts to automate programs on daily basis.
• Participated in developing an open interface to convert service contracts data from legacy system to Oracle 11i.
• Proficient in generating Forms usingOracle Formsmeeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Level 2 and 3 Production support for Oracle EBS.

Confidential - Chicago, IL

Sr. Oracle Technical Consultant

Responsibilities:

• ProvidedTechnical design documents(MD70) based on business requirement.
• Working as a technical resource at client site to develop, implement and enhancement various customization of SCM and financial modules.
• Worked in preparation ofAIMdocuments for Functional and Technical specifications ofConversions, Interfaces, ReportsandFormscustomizations.
• Worked in Creating Value sets, DFF's, Lookups, Customer Design using TCA.
• Involved in implementing Inventory, BOM, WIP, and Purchasing, Order Management and Receivables modules in Multi-Org set up including designing, testing and maintaining interfaces from legacy system.
• Worked on Uploading journal’s using Desktop Integrator (Web ADI) in General Ledger.
• Responsible for all deliverables including Data extract programs, Reports and Concurrent Programs.
• Performed activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.
• Worked in analyzing the legacy data and creation of tables as per specifications.
• Worked on Payables invoice interface to import vendor invoices into oracle applications from external applications.
• Experience in data mapping external source files with oracle columns in Oracle Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL) and Fixed Assets (FA) modules.
• Implemented PO Mass Update Interfaceto upload the data in front end.
• Developed a Control File to load Customer Information from flat file into interim tables using SQL*Loader tan validated data and written customized program to insert data into the interface table using Customer Interface Program.
• Modified standard reports and integrated with Oracle Applications 11i using Application Object Library.
• Making all the Forms read only for the general user and full access for all the super users by creating new form functions using parameter Read only = ‘yes’.
• Developed custom GEHC New Expense Report to which will process the employee report expenses are either outstanding or has been paid in the last 30 days.
• ThePOApproval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders usingworkflow builder.
• Designed and developed custom OAF pages.
• Worked onConversionsof employees from Legacy System to OracleHR.
• DevelopedSQL*Loadercontrol programs and PL/SQL validation procedures to load legacyGL Code CombinationsintoOracle General Ledger GL.
• Worked onperformance tuninglike Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Prepared most of the AIM Functional and Technical documents for requirements, design, and implementation steps with data conversions, test plans and functional user guides for all the phases of the project.

Confidential - Houston, TX

Oracle Technical Consultant

Responsibilities:

• Worked on SCM and Financial Modules.
• Worked extensively onAuto Lock Boxto bring data from external sources into ReceivablesARbase tables.
• Implementation and re-engineering of Order to Cash (O2C) and Procure to Pay (P2P) business processes.
• Implemented Confidential Automated Payment Process Interface which automates the payment process.
• Developed Conversion program to importVendor/SupplierInformation intoPurchasing POby loading data into staging tables from legacy system, validating data using PL/SQL API and tan loading the data into Vendor information Base tables.
• CreatedCustom responsibilities: GL, AR,OM, INVand moved all orders booked and status not closed to the new responsibilities for further process.
• Worked on Confidential LIST PRICE(STC)Form Personalization.
• Provided technical support onOracle Payables, Oracle Receivables, Purchasing, Procure to pay and Oracle Inventorymodules.
• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• DevelopedUNIX Shell scriptsto FTP the Flat file from External Server to Oracle UNIX Server location.
• DevelopedInterfacefor theStandard ItemsinINVENTORYgenerating the SQL Loader scripts and PL/SQL procedures for validating and loading data into oracle tables
• Developed interfaces to import payable invoices andiExpensesrelated invoices.
• Developed several new forms usingTEMPLATE.fmb& customized standard forms throughCustom.pll.
• Developed forms usingZOOM Functionalitydat pops up appropriate form based on the item context. Modifiedcustom.pllto activate zoom.
• Invoices are imported from the Excel sheets to the Oracle Database usingSQL *Loader.

Confidential

Oracle Technical Consultant

Responsibilities:

• Designed, documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Created Staging tables, and custom PL/SQL API’s to convert
• Employees, Employee Addresses, Employee Assignments, Jobs, Salary, Assignment set, Element Set, Element Link, Element, Earnings, Deductions, Benefit Contributions, Absence Types, etc.from legacy system to HR.
• Worked on SCM and Financial Modules.
• Developedseveral stored procedures, functions and packages extensively involving with the collections and records such as PL/SQL records, PL/SQL tables, VARRAYs, TABLE index by binary integer, sorting the PL/SQL Tables and reading them by using multiset operator, cursors, parameterized cursors, global temp tables, DBMS SQL Package, UTL FILE package for OM, and INV modules.
• Handled the data errors with appropriate exception handling and printing the corresponding sqlerrm and SQL code.
• Customized Pick and Pack slips to list back ordered items and print discount information in Oracle Order Management (OM) module.
• Development of a custom package to fire Auto Invoice Master Program based on the AR grouping attributes.
• DevelopedPL/SQLPackages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using thePayables Open Interface Import programand populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed a customreport which is required by the Government authorities of shipping country when shipping material to other foreign country.
• Developed a tough solution for one of the critical month end reports required for business to generate the month ending GL revenue balances.
• Developed a SA SALES ORDER Report to show all the booked and pending sales orders.
• Extensively leveraged XML Bursting Process to e-mail reports to multiple Business users across different operating units globally.
• Uploaded assets information into Fixed Assets (FA) module.
• Writing Packages and Procedures, registering them as Concurrent Programs in Apps.
• Scripts in PL/SQL to read file from remote server and import the lines into custom tables for Point of sale data and present the data to the users using custom forms.
• Creation of Request Sets.
• Implemented number of techniques to eliminate redundancies in the Database.
• Documentation of Technical Design documentwhich includes all the components developed as part of the requirement - packages, procedures, table creation scripts etc.
• Preparation of Unit Test Cases, Defect logs and Issue Log.
• Providing Knowledge Transfer(KT) to the production support team on the requirements handled by me.

Confidential

Technical Associate

Responsibilities:

• Prepared MD-070’s Technical documents for the various MD-50’s as per business requirement.
• Worked on SCM and Financial Modules.
• Evaluation of organization structure, reporting needs, business needs.
• Involved in the customization of reports as per the clients requirement.
• Designed and developedstaging tables, Custom PL/SQL API’s and use Oracle Public API’s to load
• Creation of value-sets, registering the reports and running the reports using the System Administrator Responsibility.
• Giving Buy and Sell option reports to customers.
• Responsible for status update reports to higher management on weekly as well as monthly basis.
• Edited existing reports to add additional functionality (Parameters, sorting, calculations and conditions).
• Generate Trade reports, Trial Balances and alerting clients about markets volatilities.
• Interacting with the functional consultants on the new enhancements to finalize the design and flow of the component and accordingly preparing the technical design and source code.
• Analyzing the effect of new enhancements to other designs deviating the end to end cycle.
• Presenting New Enhancement Changes and getting them moved to Production.
• Developed Technical documents for the modifications performed as per the requirement.
• Defined Executables, Concurrent Programs, Request Groups, Users, and Responsibilities.
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities.
• Designed and developed two custom data entry forms to maintain data in custom tables and Modified existing reports.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliationof reports.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.