SUMMARY

• Over 8+ years of experience as an Oracle applications (E - Business Suite) Techno-Functional Consultant with expertise in General Ledger (GL), Accounts Payables(AP), Account Receivables (AR), Order Management (OM), Payroll, Supply Chain Management (SCM), Inventory (INV), Purchasing (PO), Human Resource (HR).
• Hands on experience in 11i & R12 implementation and rollout financial modules like GL, AP, and AR.
• Cross-industry business process expertise in Manufacturing, Supply Chain Management, Financials, and Distribution with a focus on business process improvements, development of functional / technical solutions.
• Designing, developing, customizing and supporting the Inbound and Outbound Interfaces in Oracle Applications which includes AP, PO, AR, OM, SCM, INV, EAM, GL, HRMS modules.
• Extensive Experience on Order to Cash (O2C) and Procure to Pay (P2P).
• Complete Life cycle experience of ERP implementations, and custom application development projects.
• Worked on Oracle Channel Revenue Management.
• Good Experience in RICEFW Components like Reports, Interfaces, Conversions, Extensions, Forms and Workflow as per client requirements.
• Extensive experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers.
• Proficient in using SQL Plus, TOAD, Reports 6i/10g and Forms 6i/10g for both development and customizations as per client specifications.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Experienced in Performance Tuning and Explain plan, SQL loader, FNDLOAD, UTL File, Indexes, Import and Export Utilities and UNIX Shell Scripting
• Extensively worked on Data Conversion, Migrations and Interface Programs (Outbound/Inbound).
• Hands on experience in design and development in Extraction, Transformation & Loading (ETL) of data from multiple sources (oracle, flat file and ftp) using oracle PL/SQL, SQL loader
• Strong Knowledge on Functional testing phases like CRP, SIT and UAT
• Experience in Application Object Library (AOL) for registration of Forms, Reports, Concurrent Programs and oracle API’s and Menus.
• Expertise in developing Functional Specification (MD-50), Technical Specification (MD-70), Migration (MD-120), Testing (TE-20), BR-100, CV-60 documents using AIM methodology.
• Very good understanding of Trading Community Architecture (TCA).
• Working knowledge of OAF
• A self-motivated Team Leader/Memberwith excellent inter-personal, presentation and technical documentation skills with concern for maintaining quality at all levels.

TECHNICAL SKILLS

Oracle Applications Software: Oracle 11.0.3, 11i (11.5.3/11.5.8/11.5.9/11.5.10 ), R12 (12.1.3)

Application Modules: Oracle Process Manufacturing (OPM), General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Oracle Purchasing (PO), iProcurement, Supply Chain Management (SCM), Oracle Fusion HR, Cash Management Receivables(AR) Order Management (OM), Inventory (INV), Payroll, Work in Progress (WIP), Revenue Management, iExpense, Q2C, Oracle Alerts, XML Gateway and e-Commerce Gateway.

Oracle Development Tools: Oracle Forms (6i/10g), Oracle Reports (6i/10g), Oracle Workflow Builder, XML/BI Publisher, JDeveloper, Visio, Putty, SQL, PL/SQL, UNIX.

Languages: SQL, PL/SQL, C++, XML, HTML, SHELL scripting

Hardware and Development Systems: MS-Windows (XP, Vista, 7, 8), Windows Server 2003, Windows Server 2008 R2, Windows Server 2012, LINUX

Databases: ORACLE 8i/9i/10g/11g (11.2.0.3 and 11.2.0.4) and MS Access.

Database Tools: Toad, SQL*PLUS, SQL*LOADER, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential - Marlborough, MA

Oracle EBS Production Support Lead

Responsibilities:

• Worked as EBS lead production support
• Worked in a SOX compliance environment
• Supported EDI transactions (810, 812, 940, 944, 945, 947 and 846) interfaced with EBS
• Supported EBS database upgrade from 11.2.0.3 to 11.2.0.4
• Worked on multiple deployments of projects into production based on business requirement.
• Oracle Channel revenue management - Validation and settlement through Oracle AP/AR
• Support Lockbox integrations.
• Supported custom integration in Oracle EBS with Concur on Travel and expense reports.
• Hands on experience on ServiceNow change management system which consists of tickets and project status.
• Actively worked with off shore EBS team and all the other application teams who have integrations with EBS. This includes infrastructure teams as well (Network, Security, UNIX teams etc.,)
• Supported business and IT on company audits with KPMG.
• Support customized interfaces in Oracle EBS involving O2C and P2P cycles.
• Supported Payroll interfaces which are Outbound/Inbound from Oracle to ADP. Extracts are etime, person and projects.
• Worked on integrations between Oracle HR and Workday. Employee sync and Employee changes.
• Improved application performance ( Oracle Purge automation with custom business requirement, Concurrent manager optimization)
• Troubleshoot/Fixed issues with Concur travel and expense reports both in USA and CANADA.
• Supported multiple production activities like environment clones, patch analysis, licensing, certificate updates etc.,
• Maintained sunovions more than 50 custom interfaces in EBS application, which has the following modules mentioned in environment section.

Environment: Oracle EBS Application 12.1.3, Database - 11.2.0.3, OS - RedHat E5 Linux x86 64 Bit, GL, Payroll, iProcurement, AP, AR, INV, HR, SCM, Order Management, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBM67, Putty, Service Desk, Service Now, Workday, Sterling Integrator (EDI Transactions).

Confidential

Senior Consultant (Oracle Apps Techno-Functional/Production Support)

Responsibilities:

• Actively worked on client issues in accordance to Ticketing system (Remedy).
• Provided extrinsic production support to the client.
• Resolved Functional Issues in the system.
• Prepared Project Plan for iExpenses and AP (p2p Project)
• Developed concurrent programs according to the business logic.
• Worked on new development, customization and production support for Oracle EBS R12
• Developed Custom Interfaces for Oracle Payroll to ADP.
• Worked on issues involving SCM (O2C) cycle.
• Worked on EAM- Enterprise Asset Management.

Environment: Oracle Applications r12.06, 11.5.10 RUP2, 11.5.10 RUP6, GL, EAM, iProcurement, iExpense, AP, AR, INV, SCM, PO, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBM67, Putty, Remedy, OracleWeblogic Application Server 11.1.1.5

Confidential - Houston, TX

Oracle Consultant

Responsibilities:

• Worked on the new development, customization and support projects. Key initiative included upgrade of 11.5.9 to r.12.06 .5.9
• Created various Oracle alerts based on the requirements. Upgraded Alerts to Workflow Notification mailer as a part of Upgrade process to r12
• Migrate Rules and Time values for Oracle Service Contracts from 11.5.9 to r12
• Worked on report conversions from 11.5.x to r12 by migrating Report 6i file to XML publisher.
• Used Oracle cash management for cash forecasting and to project cash flows from GL, AR, AP and Purchasing
• Sub ledger accounting related customizations - post upgrade scenario included addition of two segments in GL Key accounting flexfields - Worked on flexified customization and in corporation of the change in Oracle Reports
• Perform Customizations around TCA and Customer Master. This included integrating Customer zip codes with vertex sales tax location codes, and updating customer master with DUNS number.
• Worked implementing Order to Cash cycle in SCM module.
• Design and Develop Oracle Application Framework OAF development for self-service modules of R12 such as Internet Expenses, iReceivables, iProcurement
• Design and Develop Integration between Oracle Apps R12 and other systems such as SF.com, ultipro, Next Generation Provision Tool.
• Manage effective communicate with others at all levels of the Company both verbally and in writing. Demonstrates a courteous, tactful and professional approach with employees and others.
• Worked on Oracle Channel revenue management to manage Accounts Receivable Deduction Settlement and Price Protection
• Extensive development of Discoverer reports, BI Reports. Few examples: Aging report- tabular, Hierarchy Detail, Aging Hierarchy Summary, Aging File Closed Date, Aging File Open Date, and Payables Aging.
• Development of numerous BI Publisher reports using Oracle Reports, and BI Publisher combined. Few examples are Check printing reports, Property Tax Report, Un-invoiced Receipt Report, Unapproved Invoice Report, Bank Reconciliation Report, Recurring Invoice Report, Statement Report, Multiple Invoice Print report and Recurring Invoices Alert.
• Development of Supplier conversion interface.
• Worked on conversion projects like Receipts, invoices, customer, supplier.
• Prepared GAP analysis and Functional Design documents for iExpenses and Accounts Payables.
• Provided total Oracle EBS post production support to users.
• Form Customizations of Oracle Payable's Invoice workbench, Oracle Receivables customer standard form and transactions workbench. Developed a new form from scratch for GL hierarchy mapping.
• Extensive hands on SQL tuning. Worked on numerous SQL based programs to tune them to boost performance of the process.
• Development of Unix Shell Scripts, SQL Loader scripts to support various outbound and inbound conversion processes in and out of Oracle EBS.
• Worked on FA Conversion, Mass addition process from FA to Payables.

Environment: Oracle Applications r12.06, 11.5.10 RUP2, 11.5.10 RUP6, GL AP, AR, INV, Payroll, iExpense, PO, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBM67, PL/SQL,OracleWeblogic Application Server 11.1.1.5

Confidential - Wilmington, DE

Consultant (Oracle EBS Functional/Upgrade Consultant)

Responsibilities:

• Worked as Discoverer Lead coordinating with Onsite and Offshore Teams to gather functional requirements and complete development.
• Expert-level skills on technical and functional areas of Oracle Sales (Oracle Sales Online, Oracle Quoting) and Oracle Service Modules (CRM Foundation), Trading Community Architecture.
• Supported Bank statement reconciliation interface in Oracle cash management.
• Country specific implementations for iExpenses and Accounts payables
• Also worked as overall Oracle Applications Technical consultant, involving in development and coordination with off-shore team.
• Worked closely with Management team to get Functional Requirements and transformed them into Technical Documentation using AIM methodology.
• Designed and developed AP Distribution Set Upload Program and a report to validate the Distribution sets.
• Designed and developed AP Withholding Tax report as part of India localization project.
• Analyzed Business Requirements (MD50s), worked with users to assist with the functional design, developed/customized reports forupgradefrom 11.5.3 to 11.5.10 andr12.1.3
• Modules AR,MFG modules (ONT, BOM. CST, INV) using Oracle Development Suite/Reports 6i. 9i and BI Publisher. Created custom values sets, menus, and responsibilities as a part of r12 Upgrade from 11.5.10
• Customized Oracle Receivables r12.1.3 standard JSP based web pages in Customer Standard, Collections workbench and Advance collections.
• Created MD70 documents, shell and fndload scripts, built new workflows to replenish or supplement the upgraded functionality in r12.
• Developed OM Sales Order Conversion from websites into Oracle Order Management as part of r12 Upgrade project
• Customized Customers Standard webpage in r12 using Forms personalization to hide, rename and reposition some columns for different operating units.
• Upgraded AR Customer, Invoice and Receipt Conversion programs for multiple entities with different validations as per requirements from 11. .
• Conversion of 32 11i reports (Report 6i) to BI Publisher reports in r12.
• Customized Oracle’s Order Entry workbench to bypass online credit card authorization functionality.
• Customized Oracle Forecasting workbench to include MRP consumed sales order in roll forward Forecasts.
• Developed new forms for various business needs as extensions to Oracle EBS.
• Maintained refreshes of materialized views created for Discoverer Workbooks on daily basis.
• Always been the primary contact for all Discoverer related issues for both Technical and Management Teams.
• Involved in integrating BI Publisher with Discoverer to burst and email reports to Users according to security rules.
• Scheduled BI Publisher reports to distribute monthly reports to users.
• Developed various Operational reports in Discoverer including AR Aging Report with GL segment hierarchies with summary and detail worksheets.
• Customized standard ATO Order Header and standard ATO Order line workflows using Oracle workflow builder 2.6.8+.
• Also worked on updating interfaces like Out of Pocket Expense, Fee Transfer and Oracle XML Publisher Reports.
• Extensively utilized the Application Object Library to register SQL*Loader programs, shell scripts, PL/SQL procedures and RDF Reports. In addition, also used the System Administrator responsibility to create users, responsibilities, custom profiles, request groups, request sets and Value sets.
• Developed Custom Oracle HR interfaces

Environment: Oracle Applications 11i (11.5.10.2), GL, AR, HR, iExpense, AP, Oracle 10g, PL/SQL, Discoverer 10g, Reports 6i, XML Publisher, XML, PL/SQL, Oracle Weblogic Application Server 11.1.1.5, Oracle Enterprise Manager (Grid Control), Oracle BI Pub, JDeveloper 11.1.1.5, Oracle R12g Database, Oracle BI Publisher Enterprise Edition, Toad 8.0.0.47, Linux x86, Windows XP.

Confidential - Kansas City, MO

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Developed SQL scripts to create temporary tables and SQL*Loader control files to load the item legacy data into the temporary tables.
• Configured iExpenses module
• Upgrade Oracle Applications from oracle 11. .
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).
• Customized MODULES AP, AR & GL, FA in Multi - Org environment.
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Developed reports to handle multi-currency exchange gain and losses.
• Worked with AP Team to reconcile AP with General Ledger by running Accounts Payable Trail Balance report, Posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Imported Open Payables Invoices from legacy system into Oracle AP using AP-Invoices-Interface and AP-Invoice-Lines-Interface tables.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL-Budget-Interface table using SQL*Loader.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Modified custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Modified Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Performance tuning of the discoverer reports.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. It displays the discount amount calculated for that order basing on the payment terms of the order.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement modules as client requirements.
• Development/modification of custom reports in purchasing and payables.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Preparation of technical and Solution Design document for the offshore developer.

Environment: GL, AR, HR, iExpense, AP, Oracle Applications R12/11.5.10, Reports 6i/10g, SQL, PL/SQL of Oracle 9i/10g, PL/SQL on UNIX, Windows 2000/NT environment, Forms 6i/10g, Discoverer10g, XML/BI Publisher, Toad, SQL*Loader.

Confidential - Dallas, TX

Oracle EBS Technical consultant

Responsibilities:

• Involved in various activities like development of xml publisher reports, Form Personalization, Data Conversions and Interfaces.
• Involved in designing database packages and optimizing them for best throughput.
• Provide the enhancements to the pre-existing objects in the current ERP system by coordinating with the functional team.
• Providing fixes to the Oracle apps support related issues that may come up during the production phase. This also includes the application users in understanding the application and setting up the environment up and running.
• Provide production support by monitoring day to day processes, timely fix of the production problems encountered, data fixes and execution of the monthly, quarterly, yearly end batch processes and troubleshoot the issues for business users and business analyst.
• Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, development testing and deployment of application enhancements, project planning.
• Answer the technical queries, driving the product initiatives and metric collection and analysis
• Review work products and deploying the application in the test environment and initiate the process of user acceptance testing. It includes fixing of bugs and fixing technical errors that may come up during the phase.

Environment: Oracle Applications 11i (AP, AR, OM, GL, FA and PO), AOL, Sys Admin, UNIX, Forms 6i, Reports 6i, XML Publisher reports, Toad, winscp.

Confidential - Springfield, IL

Oracle Applications Technical Consultant

Responsibilities:

• Process and Performance plans to Bring out enhancements in the current system.
• Worked on preparing specification documents for the custom reports. Developed the custom reports like Purchase Order Receipt Report, Order Lines Summary Report.
• Customized the WIP Valuation XML Report which fetches only those WIP entries whose transactional records where posted to GL within the date range specified in the parameters.
• Worked on debugging OM Workflow. Worked with Orders whose workflow got stuck and researched them to release.
• Worked with form personalization for customizing Oracle forms.
• Worked on GL interface, AR Customer Interface, Purchase Order Interface.
• Developed GL Inbound Interface to import the Journals data from Legacy to Oracle applications GL base tables
• Created Concurrent Programs, Menus and Functions required for registering the Forms, Reports and PL/SQL.
• Maintained the custom database for the company that has custom tables and stores information regarding the company’s sales, product, title mapping, platform mapping, and monthly data for each instance.
• Defined set of book with Currency and calendar in GL
• Defined operating units and profile options in GL.
• Wrote Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Manage effective communication with others at all levels of the Company both verbally and in writing. Demonstrates a courteous, tactful and professional approach with employees and others.
• Registered the reports as concurrent programs and tested them in Apps environment for different test cases. Prepared the installation guide MD-120 document to setup these concurrent programs.
• Analyzed their present application and collected the requirements from the user. Prepared functional and technical documentations for the required objects.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Worked on Auto Invoice Interface, to import data with all validations. The logic was written based on the invoice type like Credit Memo, Debit Memo, Invoice etc and the Line Type like line, Tax, Freight etc.
• Manage to accurately establish the length and difficulty of tasks and projects, set reasonable objectives and goals, anticipate and adjust for problems/roadblocks and measure results against goals
• Customized Master BOM Report, Production BOM Report, Transaction Source Summary Report, Sub-Inventory Quantities Report & Inventory Item Master Audit.
• Activating descriptive flex fields to capture additional information for the client not available in standard Oracle forms, set up Suppliers and Banks for AP use.

Environment: Oracle Applications 11i (11.5.10.2), GL, AR, AP, PL/SQL, Reports 6i, SQL*plus, SQL*Loader, Windows NT/2000, HP-Unix, BOM, WIP, Inventory.

Confidential

Jr. Oracle Technical Consultant

Responsibilities:

• This project involves in the support and enhancement of various objects in Oracle Applications.
• Involved in the Back to back orders setups
• Involved in attending training sessions on OM, PO, BOM and INV in 11i.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Involved in adding new descriptive flex field in Order Management to capture additional data
• Customization to display credit holds description at the time of Order Entry and develops a CUSTOM form to display all the information about credit check at one place.
• OM Customization - Forms Personalization for Related Item Price and Quantity
• Work flow customization to auto creates PO for Low Value requisitions.
• Developed conversion to load AR Invoices from MAB to oracle.
• Developed customized reports using XML Publisher & Discoverer Reports.
• Prepared Requirements Specifications, Technical Design Document and Test plans for the requirements based on Client interaction.
• Used SQL*Loader and UTL FILE packages for data conversion and interfaces.
• Onsite Co-ordination in Analysis, Design, Coding and Testing.
• Customized Sales Order XML Report using Xml Publisher.
• Tuned SQL statements using HINTS and appropriate indexing and Re-organizations of tables to improve the performance.
• Developed AP Invoice by Source, Checks reports using Discoverer.

Environment: Oracle APPS 11i (AR, OM, QP, PO, AP, Alerts), Developer 2000, PL/SQL, XML Publisher, Discoverer 6i, SQL*Loader, Workflow, TOAD and UNIX.

Confidential

Jr. Oracle Technical Consultant

Responsibilities:

• Experience with Oracle Financials, especially General Ledger and Accounts Payable.
• Developed new program in PL/SQL and Modified old programs for Payables Open Interface to import invoices from two different sources. Created new custom tables, Procedures, Value sets, Sequences etc., for this process. Utilized FND REQUEST API to submit concurrent programs from PL/SQL programs.
• Used Toad to Extract and test the data in the database.
• Developed SQL queries and PL/SQL stored procedures to get the customer orders.
• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Programming in PL/SQL, Oracle Forms, Oracle Reports and related Oracle dev. tools

Environment: Oracle Applications 11i (GL, AR, AP, PO, OM), Forms 6iand Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.