SUMMARY

• Over 8+ years of experience as an Oracle applications (E - Business Suite) Techno-Functional developer with expertise in General Ledger (GL), Accounts Payables(AP), Account Receivables (AR), Order Management (OM), Inventory (INV), Purchasing (PO).
• Hands on experience in 11i & R12 implementation and roll-out of 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, INV, GL, HRMS modules.
• Extensive Experience on Order to Cash (O2C), Procure to Pay (P2P) Quote to Cash(QTC).
• Complete Life cycle experience of ERP implementations, and custom application development projects.
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
• 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
• 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: General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR),Cash Management, Oracle Purchasing (PO), Order Management (OM), Inventory (INV),Work in Progress (WIP), Bill Of Materials (BOM).

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

Languages: SQL, PL/SQL, C++, XML

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 and MS Access.

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

PROFESSIONAL EXPERIENCE

Confidential - SanJose, CA

Senior Consultant (Oracle Apps Techno-Functional/Upgrade Consultant)

Responsibilities:

• Worked on the new development, customization and support projects. Key initiative included upgrade of 11.5.9 to r.12.06, 11.53 to 11.5.9
• Worked on Advance Collection in developing the new delinquencies, scoring components, Engines & strategies, and metrics.
• Created various Oracle alerts based on the requirements. Upgraded Alerts to Workflow Notification mailer as a part of Upgrade process to r12
• Integrated Oracle EBS with SDP with SOA through BPEL. Loaded data to custom and staging tables through EDI as XML payloads.
• 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.
• Sub ledger accounting related customizations - post upgrade scenario included addition of two segments in GL Key accounting flexfields .
• Worked on flexfield 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 on customized e-payables system (developed by Tiff works) that is integrated with Oracle EBS.
• 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.
• 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.
• Worked on Oracle interface process to interface data from Oracle to data tree systems, CLASS and e-Payables.
• 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.
• Worked on ad-hoc queries based on customer requirement.
• Worked on OAF page personalizations.
• Extensively worked on Customization of standard functionality and form personalization.
• Identified and strategieswhich pieces of functionality would be satisfied by which technology,obtained approval from the customer that the requirements were satisfied and communicated areas of responsibility to the development teams.
• Modelled the business entities that were required to solve the business problem. From this structure, the business domain portion of the solution was developed.
• Prepared Architecture Decisions, Architecture Overview and Architecture Design Documents
• 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, PO, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBM67, PL/SQL,OracleWeblogic Application Server 11.1.1.5

Confidential - Charlotte, NC

Senior Consultant (Oracle EBS Functional/Upgrade Consultant)

Responsibilities:

• Coordinated with Onsite and Offshore Teams to gather functional requirements and complete development.
• 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.53 to 11510 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
• Designed and Developed end-to-end Bank Statement Interface in Cash Management Module.
• Developed a custom OA Framework (OAF) jsp page to print shipping labels using JDeveloper 9i.
• Customized Oracle Receivables r12.1.3 standard JSP based web pages in Customer Standard, Collections workbench and Advance collections.
• Created MD70 documents, shell and fnd load 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.510 to r12.
• 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.
• Worked with internal team of OM SDP SOA Informatica in creating the work flow and getting the invoices printed in BI publisher.
• Scheduled and bursted 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.
• Resolved several issues by coordinating with Oracle Support Team through Service Requests of all levels of severity including data fixes on production system during go live.
• Always met deadlines within the stipulated time frames and met team’s expectations.

Environment: Oracle Applications 11i (11.5.10.2), GL, AR, AP, Oracle 10g,OAF, 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 - Hightstown, NJ

Oracle Apps 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.
• Upgrade Oracle Applications from oracle 11.5.10to R12.
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a POinterface 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 DiscovererDesktop.
• 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: 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 Applications 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.
• Discuss business solutions with Confidential business analysts in resolving existing problems and improving the application stability.
• Coordinate with business clients, support the application and implement the process as per specifications provided.
• 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:

• Confidential is the largest, national multilineinsurance companyfocusing on educators’ financial needs with more than $6 billion in assets. Confidential offers retirement annuities, automobile, homeowner, group and life insurance to educators and their families.
• 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

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

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
• Involved in design, development and testing of new Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications Modules like AR, GL, AP, and INV. All the interfaces were registered and run through the concurrent manager.

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