SUMMARY

• Over 8 years of experience as an Oracle application (E - Business Suite) Techno-Functional Consultant with expertise in General Ledger (GL), Accounts Payables(AP), Account Receivables (AR), Project Accounting, 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).
• 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.
• Experienced in Performance Tuning and Explain plan, SQL loader, FNDLOAD, UTL File, Indexes, Import and Export Utilities and UNIX Shell Scripting.
• 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
• 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.
• Experienced in preparing Business Requirement Documents (BRD), Functional Setup Documents (BR100), Functional Specification Documents (MD050) and Test Plan Documents (TE020 and TE040).
• Committed to maintaining the highest quality in all the phases of software development life cycle.
• Proven experience in Design, Development and execution of Test plans, Test cases, Test Procedures and Test Scenarios.
• Exposed to Onshore-Offshore IT working model.
• Extensive work experience on Functionality Testing, UI Testing, Regression Testing, Performance Testing, Stress Testing, Integration Testing, System Testing, User Acceptance Testing, Database Testing and Load Testing.
• Performed functional/Integration testing for multiple third-party applications integrated with Oracle ERP.
• Proven experience in writing moderate to complex SQL queries and reviewing PL/SQL and Unix shell scripts.
• Used Quality Center for requirements tracking, defect tracking, results and status reporting.
• Excellent analytical, written and verbal communication skills.
• Worked as a SPOC providing daily and weekly status via status calls, and status reports to Client and internal PMO team.

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: General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Oracle Purchasing (PO), Supply Chain Management (SCM), Order Management (OM), Inventory (INV), Project accounting, Work in Progress (WIP), Revenue Management, Cash Management, iProcurement, iExpense, Payroll, Oracle HR, 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

Sr Oracle EBS Consultant

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 cross funtional teams who has 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.
• Developed Custom Reports such asService Contractsby Status Report,Service ContractsDetail Report and Service ContractForecast Management Report using Discoverer.
• 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, updates etc.,
• Maintained sunovions more TEMPthan 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, Service Contracts 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 PL/SQL Procedures to convert data in custom tables to service contracts usingService Contract APIs.
• 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, Service Contracts, 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.
• Mapped the UNSPSC codes to NIGP codes using Oracle E-Commerce Gateway.
• Prepared Technical specification MD.070 document for issues in Production support for PLSQL extension Service Contracts
• Worked on all modules of Project Accounting, namely Project Billing, Costing, Resource Management, Account Receivables Budgeting, Quota to Order and Oracle Time and Labor.
• Involved in setting up the Expense rules for the Account Generator.
• Provided operational support for the day to day issues.
• Involved in designing Custom Reports for the Purchasing Modules.
• Involved in troubleshooting problems pertaining to purchase orders, requisitions, reports and workflows.
• Actively involved in meetings with Procurement team and vendors for setting up Punchouts.
• Handled production support responsibilities in recognizing and troubleshooting concurrent managers and concurrent requests.
• Worked with Oracle Support on many operational issues.
• Prepared documents for the end users on purchasing activities.

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

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 dat 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 dat 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 dat 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 dat 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 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.
• 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.