EXPERIENCE SUMMARY:

• Over 8 years of Professional experience on Oracle Applications as a Techno - Functional consultant, focused on Implementation, Upgrade and Support of Oracle Financials, Oracle Manufacturing, and Oracle Supply Chain modules.
• Extensive in-depth experience on Oracle 11i implementation, upgrade and conversion also experience in R12.
• Experience in all phases of the Software development life cycle (SDLC) in an ERP environment.
• Good working Experience in Oracle Financials like (GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management), PO-Oracle Purchasing, Supply Chain Management (SCM) Modules like OM (Order Management/Advanced Pricing), Project Accounting, Manufacturing (INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials), Install Base, Service Contracts, iExpenses, iProcurement, iSupplier and AOL (Application Object Library).
• Strong implementation knowledge of O2C(Order to Cash), P2P(Procure to Pay) and Drop Ship end to end Cycles.
• Expertise in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports .
• Experience in developming of RICE components in SCM modules Oracle Inventory, Purchasing, Order Management, Bill of Material.
• Developed custom reports as per client requirement in OPM Forecasting module.
• Delivered numerous customizations on 11i applications foundation of global Order to Cash and Procure to Pay and Drop Ship cycles.
• Strong SQL and PL/SQL programming skills and Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Stored Procedures, Packages, Functions, Triggers, views, collections(nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Customized Oracle Reports & Forms, Workflow, OAF.
• Knowledge and understanding of Oracle Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Experience in Manufacturing modules like Work in progress(WIP) and Bills Of Management(BOM)
• Functional responsibilities include: requirements gathering, application design, setups, testing, preparing guides and user .
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Experienced in Database Design, Data Modelling, Migration, and Systems Architecture, Planning, Testing and Trouble Shooting.
• Experience in designing COGS Workflows.
• Actively involved in Implementation, re-Implementation, Customization and Upgrade of Oracle Applications. This includes Version upgrades, Data conversions, Data Migration, Interfaces Development, Module Implementation (Financial & Manufacturing), Customization and Development
• Good working experience in XML/BI Publisher and Discoverer Reports.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
• Worked extensively in Data Warehousing environments to handle bulk loading of data.
• Development of inbound and outbound interfaces to external legacy systems for new implementations.
• Setup of Customized menus, Custom developed programs and also Created Alerts.
• Experienced in ERP Applications & Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Worked in designing various Technical and Functional DocumentslikeBR100, MD070and MD120 and Conversion MappingCV060usingAIMMethodology.
• Experience in design and development of inbound and outbound interfaces integrating Oracle Apps with Legacy System using SQL*Loader.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions.
• Excellent technical background for the accurate evaluation of customization efforts. Strong business, analytical and technical problem solving skills.
• Solid management skills, capable of leading and motivating individuals
• Self-motivated with the ability to effectively manage time and multiple projects.

TECHNICAL SKILLS:

Programming: PL/SQL, SQL, C, C++, Java Script, HTML, PHP, Unix shell scripting, Java.

Development Tools: Financial modules such as GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management), PO-Oracle Purchasing, OM (Order Management/Advanced Pricing), OPM, Manufacturing (INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials), Install Base, Service Contracts, iExpenses, iProcurement and AOL (Application Object Library.

Reporting Tools: Oracle BI Publisher, Discoverer 2000, 9i,10g, Data loader, MS VSS, SSH Client

Oracle Apps: Oracle Reports 10g, Oracle Forms 10g, Web ServicesOracle Developer Suite 9i/6i/10g, TOAD, SQL Developer.

Platforms: Windows 98/2000/XP, Windows NT 4.0/2000 Server/Workstation, UNIX SVR4.

Databases: Oracle versions 8i, 9i, 10g, 11g, MS Access.

Oracle Apps: PL/SQL, XML Publisher, Oracle Discoverer

Processes: Order-2-Cash (O2C), Procure-2-Pay (P2P).

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Techno-Functional

Responsibilities:

• Designed forms for Demand, Supply and In transit quantities from scratch.
• Developed PL/SQL Package and procedures for demand detail, supply detail and in transit detail quantities.
• Developed XML Reports PO Output for communication, Pick slip, Pack slip Commercial Invoice and Batch Pick slip reports using Standard reports.
• Developed Receiving interfaces PO, Internal Orders and RMA Receiving's.
• Developed PL/SQL procedures, functions and packages for validating invoice data before importing it into Account Receivables interface tables
• Imported Bills and Routings through BOM Interfaces.
• Designed and developed reports - PI Pick Slip and PI Pack Slip Report using XML Publisher.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle
• Customized sales order form using Form personalization.
• Worked on discoverer desktop for creating various workbooks based on custom folders.
• Created MD70 documents, shell and fnd load scripts, built new workflows to replenish or supplement the upgraded functionality in R12.
• 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.
• Gathered requirements, wrote functional (MD050) and technical (MD070) specifications, provided recommendations for user concerns and implement process and system modification.

Environment: Oracle Applications R12(R12.1.3), Oracle 10g, iProcurement, iSupplier,PL/SQL, Discoverer 10g, Reports, XML Publisher, PL/SQL, Oracle Weblogic Application Server 11.1.1.5, Oracle Enterprise Manager (Grid Control), Oracle BI Pub, JDeveloper 11.1.1.5, Oracle BI Publisher Enterprise Edition, Toad, Linux x86, Windows XP.

Confidential, Woonsocket, RI

Oracle EBS Techno-Functional/Upgrade Consultant

Responsibilities:

• Customized Modules AP, AR, GL, FA,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.
• Developed OM Sales Order Conversion from websites into Oracle Order Management as part of r12 Upgrade project.
• Imported Bills and Routings through BOM Interfaces.
• 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.
• Performed the Data Migration using SQL * Loader Scripts for importing legacy systems data intoProject Accountinginterface tables.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.
• 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.
• Analyzed Business Requirements (MD50s), worked with users to assist with the functional design, developed/customized reports forupgradefrom 11. .1.3
• Extensively utilized the Application Object Library to register SQL*Loader programs, shell scripts, PL/SQL procedures and RDF Reports.
• Worked on development of Custom Order import using API and debugged the issues with the orders which got stuck.
• Developed new forms for various business needs as extensions to Oracle EBS.
• Conversion of 11i reports to BI Publisher reports in R12.
• Also worked on updating interfaces like Out of Pocket Expense, Fee Transfer and Oracle XML Publisher Reports.
• Worked on Data loader to load the GL Code combinations into the Oracle applications.
• Worked extensively on XML Publisher reports.
• Customized Oracle Receivables R12.1.3 standard JSP based web pages in Customer Standard, Collections workbench and Advance collections.
• Developed various Operational reports in Discoverer including AR Aging Report with GL segment hierarchies with summary and detail worksheets.
• Prepared Functional Mappings for data conversion from 11i to R12 for all Distribution and Financials modules
• Created MD70 documents, shell and fnd load scripts, built new workflows to replenish or supplement the upgraded functionality in R12.
• 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.
• 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.

Environment: Oracle Applications R12(R12.1.3), 11i (11.5.10.2), Oracle 10g, iProcurement, iSupplier,PL/SQL, Discoverer 10g, Reports, 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 BI Publisher Enterprise Edition, Toad, Linux x86, Windows XP.

Confidential, Charlotte, NC

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Process and Performance plans to Bring out enhancements in the current system.
• Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Develop AP/AR/GL/PO reports using discoverer which include the following
• PO requisition reportsAR sales profit report with cost of goodsGL Summary Report.
• Worked with form personalization for customizing Oracle forms.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM .
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator (FSG).
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Developing PL/SQL code to obtain the required functionality.
• Troubleshooting of the Order Management (OM) and Inventory (INV) modules within Oracle Applications.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.

Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, Discoverer, UNIX, Shell scripts.

Confidential, Harleysville, PA

Oracle Apps Techno-Functional Specialist

Responsibilities:

• Worked on the Conversions for AP Supplier Invoices, Customer Invoice/Credit Notes for Migration of the Data from legacy system to the new system Customized Accounting Flex Fields, Cross Validation Rules and Security Rules.
• Created an Audit report which gives the audit details of Migration of data.
• Wrote UNIX Scripts to extract custom objects from each product top.
• Designed interface programs to facilitate transfer of large volumes of legacy data from flat file to Oracle Apps modules like AP, AR, GL and FA.
• Customized Oracle Reports & Forms, Workflow.
• Delivered numerous customizations on 11i applications foundation of global Order to Cash(O2C) and Procure to Pay(P2P) and Drop Ship cycles.
• Developed forms and reports.
• Worked on importing the period end rates for all set of books.
• Designed and developed Project Accounting Conversion 11.0.3 to 11.5.10
• Worked on GL Interface, uploaded the data and then imported the GL data for a specific period and currency code.
• Automated the remittance notification to the vendor based on the payment details.
• Worked on the Invoice detail report which gives the vendor and their invoice details.
• Worked on the IBAN Validation process
• Wrote procedures to extract all the SQL statements from the Database Objects like Forms, Reports and SQL Scripts.
• Developed salespersons report - Discoverer.
• Created reports using Foundation tables and views and custom views
• Improved efficiency of the team by effectively deploying resources based on the priorities
• Devised Performance improvement plans for underperforming individuals.
• Worked on supporting Receiving Transactions Interface errors in Purchasing, fixing the stuck records, investigating the issues in receiving and following up with the Receiving users at DC.
• Working on the upgrade process from 11.5.10 RUP2 to 11.5.10 RUP6. Upgrading the Custom objects, DFFs etc and testing each module.
• Designed and developed reports - PI Commercial Invoice report, PI Pick Slip and PI Pack Slip Report using XML Publisher.
• Developed Custom Pl/sql packages and procedures. Used advanced PL/SQL concepts like Objects, Bulk collect etc.
• Designed Shipping labels in Pick Slip and Pack Slip Report using XML Publishers.

Environment: Oracle Applications 11.5.10 RUP2, 11.5.10 RUP6, GL, AP, AR, INV, iSuppler, PO, Order to Cash (O2C), Procure to Pay (P2P), PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBMS 9i/10g, Unix.

Confidential -Schaumburg, IL

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked on SQL*Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
• Involved in the development of RICE components in SCM modules Oracle Inventory, Purchasing, Order Management, Bill of Material.
• Developed custom reports as per client requirement in OPM Forecasting module.
• Complete analysis, design, development and testing of new Discovererreports and customization of the existing reports for Project Accounting, General Ledger, Accounts Payable and Accounts Receivables.
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Experience in designing Workflows.
• Migrated an Item Conversion to import legacy inventory item data into Oracle base tables.
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Used SQL*Loader and UTL FILE packages for data conversion and interfaces.
• Customized the reports for Financial Module (GL, AP, and AR) using Report Builder.
• Extract program for Open orders information (Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized) and corresponding stock amounts program, which shows the costing information for those open orders in the SCM modules Purchasing (PO) and Order Management (OM).
• Key user for the landed Costing custom Module and Integration with Oracle Purchase, Inventory, Order Management and Account payable.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer responsibilities.
• Worked on performance tuning of existing reports and PL/SQL programs.
• Developed customized reports using XML Publisher & Discoverer.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Worked on discoverer desktop for creating various workbooks based on custom folders.
• Customized Oracle standard reports like AP and AR Aging Reports, Open PO report and changed the output format to XML and created new templates for XML Publisher to display in pdf or excel format.
• Converted custom forms using Forms 6i in Installed base for global update of instance.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.
• Customized sales order form using Form personalization.
• Gathered requirements, wrote functional (MD050) and technical (MD070) specifications, provided recommendations for user concerns and implement process and system modification.

Environment: Oracle Apps 11.5.8/10.2, GL, AP, AR, PO, OM, OPM Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Shell Scripting, TOAD, PVCS, UNIX.

Confidential

Software Associate

Responsibilities:

• Worked on Outbound interface to extract sales Orders data from 11i OM to a different system called IDE.
• All elements like Product key, Customer data, Ship-to, Bill to, End User, RMAs, transaction changes like end customer changes are extracted.Preparation of Functional and Technical Documents.
• Analyzed and designed the custom database schema.
• Worked on gathering the requirement from the user, preparing the Scope and Requirement Document, Functional Document, Technical Design Document, Oracle Setup Document and Production Change Control Document.
• Worked on implementing Oracle Inventory to Cash business flow as part of Procure to Pay (P2P) and Order to Cash(O2C).
• 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.
• Involved in the analysis, design and testing of customizations.
• Developed Warehouse Rules and Production Batches interfaces in OPM.
• Mapped client’s business requirements to Oracle Applications features.
• Worked on the creation of Function design document from Business requirements and also created Use cases with examples.
• Attended meetings with Business Team for understanding requirements and also for FD and use cases reviews.
• Involved in the creation of Technical design MD-70.
• Used Process Order API to insert/ update Orders and order lines.
• Designed and developed Pl/SQL packages. Used Pl/SQL Objects and tables.
• Worked on Interfaces development for ICE(Sales Compensation) implementation.
• Worked on integration of Customer Accounts and Parties for the above data.
• Worked with Business team to understand the requirements for various business scenarios and helped them with testing as per their requirements.
• Analyze system for upgrade, considering customizations, technical restrictions & system stability
• Analyzed the existing application and collected the requirements from the user. Prepared functional and technical documentations for the required objects.
• Studied MD-50 for all requirements and responsible for creation of MD-70
• Created the forms and reports required to build these custom applications.

Environment: Oracle Applications 11i, AR, AP, PO, OM, INV, O2C, P2P,Oracle9i, TOAD, PL/SQL, SQL*LOADER, Reports 6i, Forms 6i, Discoverer.

Confidential

Software Associate

Responsibilities:

• Responsible Co-ordination with Client.
• Analyzing the Design and functionality.
• Developed Packages, Function, Procedure and Database Triggers.
• Involved in Creating the Oracle table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc.
• Defining new users, menus and responsibilities
• Registered various applications, reports, PL/SQL packages, Request Sets, Forms, Menus and Tables.
• Customization of reports and forms using Developer 2000
• Use of Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on UNIX.
• Prepared the documentation of Forms and Reports
• Developed a PL/SQL package to validate data invoices into tables.
• Designed and Developed packages for Import Interface to import statement information into the system.
• Used SQL * Loader to load invoices.
• Performing system analysis, address gaps to improve performance, use trouble shooting skills, identify root causes, and resolve problems related to system functionality
• Preparing weekly status reports
• Updating the status to On-site on weekly basis.
• Prepared Quality Related documents
• Creating SQL, Object Views, PL/SQL database objects.
• Participated in developing interfaces
• Implementation at the Client's site and imparting user .

Environment: - Oracle 8i/9i, PL/SQL, Oracle Loader, TOAD, Stored Procedures, Shell Scripts