SUMMARY:

• Over 10 years of experience as Oracle Applications 11i/R12 Technical professional
• Excellent in Technical Analysis, Configuration and testing of new Development, Customization of existing systems involving Technical expertise on various modules like Account Receivables(AR), Account Payables(AP), Purchasing(PO), Order Management(OM), Subledger Accounting(SLA), General Ledger(GL), Fixed Assets(FA), Inventory (INV)
• Expert in developing technical components using SQL, PL/SQL, SQL *Loader, Oracle Reports, BI / XML Publisher, Performance Tuning, Discoverer and Unix Shell Scripting
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles
• Expert in creating Oracle Reports 6i/9i/10g, Inbound/Outbound Interfaces UTL FILE, SQL *Loader, Conversions, Extensions for Oracle Applications - RICE Components
• Creating several Oracle PL/SQL Packages, Procedures & Functions for the past several years
• Used FNDLOAD for moving AOL Components
• Converting the client requirements into deliverables and Focused on end user/Customer Requirements
• Used Oracle Alerts for Creating Alerts and run at business specified interval
• Involved in preparing MD050, MD070, MD120 and MD200 documents
• Assisted users in UAT and Post-Production Support

SKILL:

ERP: Oracle Applications (EBS) 11.0.3 / 11i / R12.1.3 / R12.2.4

Oracle Apps Modules: Account Receivables(AR), Account Payables(AP), Purchasing(PO), Shipping Execution (WSH), Order Management(OM), Subledger Accounting(SLA), General Ledger(GL), Fixed Assets(FA), Inventory (INV)

Oracle Technologies: SQL, PL/SQL, SQL *Loader, Tuning, Discoverer, Reports, Winscp, Putty, Toad

Business Intelligence: Oracle BI/XML Publisher

Languages: SQL, PL/SQL, UNIX Shell Scripting

Databases: Oracle 7/8i/9i/10g/11g

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Oracle Applications Senior Technical Consultant

Responsibilities:

• Sr. Oracle Applications consultant responsible for Design and Implementation to rewrite OPTIO based CFD reports using Oracle BI Publisher
• Technical Retrofit of all Invalid objects during R12 Upgrade
• Remediated several Concurrent Programs and Reports for Oracle Apps R12
• Identified database objects used by Oracle Reports and remediated
• Remediated several Queries/Reports to use the new table structures
• Remediated several packages to use the new table data structure
• Successfully implemented Invoice Print report to support Selective Duplex Printing where in the printed paper was automatically folded, based on OMR mark, put in an envelope and sealed, ready to be posted to customer
• Created Invoice Print program for Receivables invoices and automated delivery of pdf output to the customers through BI Publisher email bursting
• Customized the U.S. Sales Tax Report per client specific requirements and closely worked with the client team during month ends to make any additional changes required
• Customized the most complex Aging 7 Buckets report in Oracle Receivables to help in identifying the past due invoices, across all operating units, grouped by customer account. All the amounts will be converted to USD before display on the report
• The Invoice Print implementation also included displaying the output in different languages using BI Publisher Translations i.e. XLIFF
• Customized CFD further to display respective company Logo and address during Acquisitions phase of the project
• Establish two way interfaces to support COR360 and Payables module and provided the feed for suppliers, supplier sites, and Payables invoices.
• Developing custom interfaces between Oracle Payables and Kofax applications for Payables Invoices for certain legal entities using PL/SQL code.
• Developed strategy to convert existing legacy data for external systems for Payables and Receivables to R12 EBS for new entities. Supervised and assisted in the performance of data mapping exercises and saved time by utilizing a combination of Data Loader and PL/SQL Scripts to perform the migration
• Resolved performance tuning related issues on reports and queries
• Developed PL/SQL Packages to perform Extract, Transform and Load (ETL) processes for Data Conversion routines required to extract data from legacy staging tables for loading into appropriate Application Open Interfaces tables used for migration of legacy system data to Oracle Applications - using appropriate Application Program Interfaces (API)
• Closely worked with Client testing team during UAT and obtained approval for the project go-live
• Worked on developing custom code for custom sources to be used in SLA for generating custom accounting entries as defined in MD50
• Improved performance of BI/XML Publisher reports be reducing the length of XML Tag field names

Confidential, Chicago, IL

Technical Consultant

Responsibilities:

• Involved in converting all Supplier master data from the legacy system into Oracle ERP using PL/SQL
• Involved in converting all legacy data into Oracle using PL/SQL.
• This included converting open and closed AR invoices using the Auto Invoice Process
• Developing Reports 6i/9i and deploy in Oracle EBS
• Designed and Developed Custom Business Intelligence Reports like (AR) Invoice Print and Packing Slip to help in Packing and Shipping (WSH) process
• Developed interface to automate loading daily exchange rates in General Ledger module using PL/SQL
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries
• Developed interface to load the Sales Orders from Legacy system to Oracle EBS
• Troubleshooting with the PL/SQL interface issues which are imported through a flat file as well as through a custom program for Payables Invoices, Receivables invoices, Purchase Orders
• Improved the performance of the time-consuming PL/SQL procedure by using built-in regular expression functions REGEXP SUBSTR
• Collecting requirements (MD 50); prepared Technical Design Documentations (MD 70)
• Unit testing and peer reviews and Assisted clients in UAT (User Acceptance Test)
• Developed Item Conversion and Item Category Conversion to load data in oracle Inventory tables using PL/SQL

Confidential, San Francisco, CA

Technical Consultant

Responsibilities:

• Working on the Technical code correction tasks
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3
• Analysis of all Invalid RICE components for R12 Upgrade
• Retrofit of Invalid objects and Customization of PL/SQL Interfaces
• Customized reports to make changes related to R12 for MOAC changes and tables changes
• Developed enhancements required for business process in Order-to-Cash and Procure-to-Pay cycles
• Resolve performance tuning related issues on reports and queries
• Redeveloped various custom RICE components for R12 upgrade
• Involved in developing custom XML/BI Publisher reports like AR Aging, Collections by Collector, and Purchase Order Summary
• Worked on the technical design and implementation of custom Collections Module to track collections correspondence and send reminder letters
• Involved in AP Check Printing customization in R12 through BI Publisher
• Worked on different interfaces like importing AR invoices from one of third party systems which validates and submits a standard interface program using PL/SQL
• Developed custom AR INTERFACE program which validates and modifies data in the interface tables. This program is also designed to update Sales order based data in AR interface tables.
• Developed an outbound Interface to export AR Invoice data to third party systems, also inbound Interfaces to import AR Invoices to Oracle using PL/SQL
• Developed PL/SQL Interfaces from Shipping (WSH) tables to Ship Console and UPS Connect to create Shipping label
• To meet various reporting requirements, customized various Oracle reports like Invoice report, Account analysis report

Confidential, Hunt Valley, MA

Technical Consultant

Responsibilities:

• Analysis of all Invalid RICE components for R12 Upgrade
• Working on the Technical code correction tasks created by PANAYA
• Retrofit of Invalid objects
• Testing and Retrofit of Form Personalization
• Developed various Oracle Applications components using PL/SQL, SQL*Plus and Oracle Reports
• Reviewed design documents (MD 50), technical documents (MD 70) and Installation documents (MD 120) for all the customizations
• Created and used stored procedures, packages, cursors and functions to do the validations on the legacy data, created indexes to enhance the performance of the application.
• Analyzed and Retrofit AR and OM Interface and conversions using PL/SQL code
• Created Staging tables to load the records and uploaded the flat files using SQL*Loader
• Configured Concurrent Executable, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus, And Custom Responsibilities
• Customized the Journal Entries Report, which is used to review the details that make up General ledger journal entries, to in corporate additional information relating to the transactions stored in DFF
• Registered the PL/SQL scripts using Concurrent Programs and attached the programs to Request Sets
• Involved in the User Acceptance testing and Post Production support
• Created and customized Reports in AP, AR, and Collections using Reports 10g
• Created UNIX shell scripts to automate the process of loading the external data
• Used FND LOAD utility to migrate responsibility, request sets, concurrent programs, value sets, Context-Sensitive DFF, Profile Options, Form Personalization etc.

Confidential, Chicago, IL

Technical Consultant

Responsibilities:

• Responsible for analyzing the requirements, preparing the technical specification from the functional requirements document, designing the program, programming, unit testing and production migration
• Involved in developing PL/SQL conversion programs, interfaces, building custom reports and writing UNIX shell scripts based on the functional specifications provided
• Worked on Party Conversion through Bulk Import Program and few entities with standard APIs using PL/SQL code
• Worked on one time data fix for correcting few erroneous records created through an interface
• Reviewed design documents (MD 50), created technical documents (MD 70), unit test script documents (TE 20) and Installation documents (MD 120) for all the customizations
• Developed RICEW components in modules like AP, AR, and PO
• Developed objects keeping performance in view
• Identified the performance related issues and suggested to run Gather statistics on all the tables
• Involved in Performance Tuning of SQL Queries, PL/SQL Code
• Designed and developed custom shipping (WSH) reports like Packing slip, Pick Slip, and other reports like Bill of lading, Invoice Print and Aging Report using XML/BI Publisher
• Provided post go-live support and involved in user sessions.
• Documented all the work done for future and created various manuals for functional testers and users

Confidential, Cambridge, MA

Technical Consultant

Responsibilities:

• The project is an implementation of Oracle Apps R12. Involved in developing PL/SQL conversion programs, interfaces, building custom reports and writing UNIX shell scripts based on the functional specifications provided
• Worked on the technical team responsible for the code development
• Analyzing the requirements from customer for technical feasibility and prioritize them
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, programming, unit testing and production migration
• Working on Batch Error Correction program, which required complex PL/SQL logic, developed as an API which will be called from Informatica providing opportunity to work across functions
• Pre-Analysis and Post-Analysis during Go-Live
• Prepared Technical documents (MD 200) and Installation documents (MD 120) for all the customizations
• Created new concurrent request sets and scheduled the Order Import interface program to run periodically using PL/SQL code
• Involved in Performance Tuning of SQL Queries, PL/SQL Code
• Developed custom reports using Report 10g and customized seeded reports
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables for performing validation before loading into Oracle Interface tables
• Provided post go-live support and involved in user sessions

Confidential, Chicago, IL

Functional Configuration

Responsibilities:

• Working on the functional team responsible for configurations
• Responsible for completing the configurations based on the requirement published by Onsite functional team
• Working on Data Loader to load huge amount of data into complex Self Service applications pages of Oracle AGIS
• Mentored the team of 2 campus recruits in functional configurations
• Worked on tools like XML/BI Publisher to generate the reports.
• Developed, implemented and unit tested AR Invoice interface. This involved importing data from the legacy system into staging tables using SQL Loader, validating the data using a PL / SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AR tables
• Written PL/SQL Stored Procedures, Functions, and Packages to implement business rules into the application
• Involved in Performance Tuning of Packages. Identified code parts that spend a lot of time processing INSERT, UPDATE, or DELETE statements, or looping through query results and used FORALL statement for issuing DML, and the BULK COLLECT INTO clauses for queries to improve the performance
• Created new concurrent request sets and scheduled the Order Import interface program to run periodically using PL/SQL code
• Used standard Order import to load the open orders from the interface tables to the standard OM tables using PL/SQL
• Designed and developed an PL/SQL Inbound Interface between web based Order management systems and Order Management for Sales Orders import
• Developed a Custom program in OM that accomplishes Pick Release and Ship Confirm Process in Oracle

Confidential, Atlanta, GA

Technical Consultant

Responsibilities:

• Working on the technical team responsible for the technical aspects
• Leaded the team of 2 members of reports development team
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, programming, unit testing and production migration
• Working on Discoverer 10g & Oracle BI Publisher (earlier known as XML Publisher reports) reports such as Dunning reports, Collections Summary and some more customer facing documents
• Working on Interface/Conversion of Invoices and Receipts for Italy Implementation using PL/SQL code
• Working on Notes conversion & Notes Interface with PL/SQL coding
• Configured Concurrent Executable, Concurrent Programs, Custom Lookups, Request Sets, Request Groups, Functions, Menus, Sub-Menus and Custom Responsibilities
• Developed Audit extraction SQLs involving AR, AP, GL and PO modules
• Developed Custom API to invoke the API to load the external data into the corresponding tables at the end of every month
• Developed outbound interfaces to export data to Mainframes, Hyperion, and other custom applications using PL/SQL
• Analyzed the execution plans and performance of the SQL statements using EXPLAIN PLAN, SQL Trace facility with TKPROF utility, Oracle Trace facility
• Involved in Handling CR’s (Change Requests)
• Involved in creating the UAT scripts
• Responsible for fixing various UAT bugs
• Created user defined functions and used library functions for easier maintenance of script

Confidential, Richmond, VA

Technical Consultant

Responsibilities:

• Working on the technical team responsible for the technical aspects
• Involved in gathering requirements for AR Implementation
• Analyzing the requirements from customer for technical feasibility and prioritize them
• Involved in developing new Invoice Interface & Invoice conversion using PL/SQL
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, programming, unit testing and production migration
• Working on Oracle BI Publisher (earlier known as XML Publisher reports) reports such as Print Invoice Report, Aging Report, Transaction Summary Report with output in EXCEL and PDF formats
• My role included developing conversions, reports and other enhancements for Oracle AR module
• Worked on AP Invoices Conversion to convert the paid invoices data with PL/SQL code
• Designed and developed Staging tables, Conversion routines and Custom PL/SQL API’s for Customer Import, Order Import, AR Invoices and Item Import
• Improved performance of procedures by replacing loop constructs with FORALL statements to issue a series of DML statements
• Designed and developed an PL/SQL Interface from third party billing system to Oracle EBS, Where I developed an UNIX shell script, which calls SQL Loader program to load data into custom staging tables and checks for uniqueness of the files in UNIX directory to avoid duplicate data and to archive the same

Confidential, Atlanta, GA

Technical Consultant

Responsibilities:

• Working on the technical team responsible for the technical aspects
• Involved in gathering requirements for AR Implementation
• Analyzing the requirements from customer for technical feasibility and prioritize them
• Involved in developing new Invoice Interface & Customer conversion using PL/SQL
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, unit testing and production migration
• Working on Oracle BI Publisher (earlier known as XML Publisher reports) reports such as Aging Report & complex requirement of Print Invoice Report
• Involved in developing new Advanced Collections Notes Inbound Interface, Notes Outbound Interface & Onetime Customer Update using PL/SQL

Confidential, Atlanta, GA

Technical Consultant

Responsibilities:

• Working with Confidential client to maintain and support their RICE (Reports, Interfaces, Customizations and Extensions) Components as per their business requirements. Involved in technical and functional process flow capturing for modules like FA, AP and AR & XML Reports
• Working on the technical team responsible for the technical aspects
• Handling Day to Day support activities like providing technical Solutions for the problem SR’s
• Responsible for delivering Enhancements which include preparing the technical specification from the functional requirements Document, designing the program, programming, unit testing and production migration
• Responsible in Client management and Team Activities
• Working on the technical team responsible for the technical aspects like preparing procedures, functions, packages as per requirement
• Involved in Performance Tuning of PL/SQL code by using oracle provided highly optimized string functions such as REPLACE, TRANSLATE, SUBSTR, INSTR, RPAD, and LTRIM. These built-in functions are more efficient than regular PL/SQL.
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, programming, unit testing and production migration.
• Took the lead to handle critical components for the UK Process and have been the first point of contact for any issue
• Always owns up the complete responsibility for any object/ task assigned
• Was responsible for developing and on-time delivery for the critical components like the 1099 Income tax reports of Confidential
• Have successfully Improved/handled the Confidential UK employee expenses daily load coming from GELCO into Oracle AP after debugging all the errors in the expense data files
• Also, have identified Improvement areas and took the complete responsibility to automate the entire GELCO AP Interface process for Confidential UK
• Have shown the boundary less behavior by helping other internal teams in testing and coding
• Have actively participated in team gathering
• Involved in developing new Interfaces for AP Income Tax Reporting (1099), GELCO (AP Invoice Interface), AR Invoice Interface, Notes Interface both Inbound and outbound
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, programming, unit testing and production migration
• Involved in developing the most complex Oracle XML Publisher reports such as Print Invoice Reports
• Received wonderful VOC’s from Key Stake Holders, for solving tickets in very short time
• Have won appreciations from Customer and also from the internal teams for helping them to identify the root areas for them to start the development activities
• Have shown excellent written communication skills while working on many Sev1 and high impact tickets for which have won appreciations from the Technical leads
• Successfully completed automation of entire GELCO AP Interface process and this is also certified as a Lean project