SUMMARY

• 10+ years of professional experience as Oracle Apps Techno Functional Consultant in Oracle E - Business Suite Applications with expertise in Oracle Financials Modules and Supply Chain Management Modules GL, AP, AR, FA, CM, PA, Iproc, Isupplier, PO, OM, INV),
• Experienced on various phase 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.
• Hands-on involvement in business requirement, Confidential analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training.
• Developed functional and technical specifications, test plans and test scenarios using AIM methodology.
• Good Experience in implementing Order-to-Cash and Procure-to-Pay Business Process flows.
• Strong technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE) components.
• Strong knowledge and experience in AOL (Application Object Library), System Administration, Workflow Administrator and Application Developer modules.
• Expertise in General Ledger (GL), Account Payable (AP), Account Receivable (AR), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Oracle Process Manufacture(OPM), Inventory (INV), TCA, HRMS, Shipping (WSH), Sub Ledger Accounting (SLA), iProc, iExp, iSupplier and AOL objects.
• Strong working knowledge of business flows like Procure-to-Pay, Order-to-Cash and Quote-to-Order along with the dependencies and relationships between Oracle Applications modules Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Very Good Knowledge and understanding of Application Object Library (AOL) and Trading Community Architecture (TCA).
• Hands-on experience in Data Conversion, Data Migration and Developing Interfaces, Extensions in various Oracle ERP modules.
• Strong design and development experience on Open Interfaces (inbound and outbound interfaces) and APIs in Oracle Supply Chain, Manufacturing and financial Modules.
• Transferred and retrieved data to and from FTP Servers to Oracle Database.
• Performed System Integration Testing (SIT) as and when required.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Extensive experience in developing and customizing reports using Reports 10g/9i/6i and generated various XML/BI Publisher reports, which included working on report development objects like data templates and RTF’s.
• Experience in creating RTF templates using XML Publisher.
• Extensive experience in developing and customizing of Oracle Workflow and AME.
• Strong Knowledge in personalization and Customization of Oracle Forms and Oracle Applications Framework (OAF).
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
• Knowledge in BPEL and IPM
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, Shell scripting, Performance Tuning.
• Involved in preparation of various documents like MD120, MD070, BR100, MD50 and TE20 (Installation & Technical Design) documents using AIM Methodologies.
• Experienced in migrating code from instance to instance using version control software like PVCS and Kintana and Change management tools like SDLC.
• Have strong interpersonal skills along with proficient written and verbal skills. A quick learner with ability to adapt to any environment and finish each task with finesse.

TECHNICAL SKILLS

ERP: Oracle applications 11i/R12 (GL, AP, AR, FA, CM, PA, Iproc, IExp, Isupplier, PO, OM, INV)

Databases: Oracle RDBMS, Oracle 8i /9i/10g

Languages: SQL, PL/SQL, C, C++, Java.

Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Toad, SQL Navigator, SQL*Plus, SQL*Load, JDeveloper, Oracle Application Framework (OAF), Oracle Workflow, BI Publisher, Winscp, SVN.

Operating Systems: UNIX, Linux (Red hat enterprise) and WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TX

Oracle Apps Technical Lead

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Involved with Business teams and worked closely with the Oracle Order Management sales Admins, Purchasing Admins.
• Performed Confidential analysis to ensure that the requirements are captured properly.
• Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing.
• Worked on creating various functional design and requirement gathering documents like (MD50).
• Worked on business cases for the current as-is process and the to-be process.
• Worked on risks and merits of the new process to be implemented.
• Created Oracle service requests and fixed the bugs in Oracle Work in Progress application with the help of Oracle support. Tested the fix in TEST instance prior to apply in other instances.
• Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application.
• Worked on creating setup document BR Shipment Setup documents.
• Created all the setups required for the shipment project including Pick Slip Grouping rules, release sequence rules, release rules form, document sets, creating sub inventories, value sets.
• Designed and developed Account Payables Check Report using BI/RTF template
• Worked on cross functional teams for resolving various oracle functional issues and gathering appropriate requirements.
• Worked closely with the business users to understand the intricacies of the business and document accordingly.
• Developed Auto Lock box program to import receipts from the legacy systems.
• Designed and developed Account Payables EFT using BI/RTF template.
• Designed and developed BI/RTF Report to bring Fixed Asset details and retirements into a single report.
• Developed Conversion program to import Receivables Transaction data using Auto Invoice Program.
• Developed Custom program for the Receipt- Create, Apply and Write off and On Account.
• Customized Statement and Invoice Print reports to suit as per the client business needs.
• Designed and Developed an Item Conversion to Import legacy inventory item data.
• Created a XML/BI publisher report for Open Requisitions.
• Customized existing Oracle Reports in Inventory Module (INV) using Reports 6i.
• Implemented Spend vision solutions to the client which loads the employee spending through spend vision to Oracle.
• Complete functional/business scenarios on various types of order types and pricelists etc.
• Worked on Pricelist issues to add custom functions to create percentages on service items.
• Involved in creating sales orders with different ship methods, ship dates, pricelists and order types, creating pick releasing and ship confirmation processes.
• Designed and developed Dunning letters using collections.
• Customized the Purchase order Workflow to implement approval hierarchy.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
• Developed Conversion program to import Sales Order data using OM Import program.
• Developed program for Cash management reconciliation
• Developed extensions for Supplier & Customer OAF pages on R12, and also involved in OAF screens personalization.
• Worked on WIP Discrete Job Value Report.
• Worked on Jobs and Schedule Interface
• Developed the Business Solution Design Documents and Technical Design Documents for Workflow, iProcruement and iSupplier Portal Customizations Extensions.
• Designed the Test Scripts and Test Scenarios for iProcurement and iSupplier Portal.
• Customized iProcurement and iSupplier Portal (Creating Buyer Name LOV, Chart Of Account LOVs and Screen Changes and etc.).
• Developed Iprocurement and iSupplier Portal Extensions like Demand Pull, Consignment Reports and etc..
• Worked on OA Framework using JDeveloper 10.1.3. Developed extensions for iProcurement using OAF.
• Developed Conversion program to load Item Categories from legacy system.
• Provided technical support on Oracle Payables, Oracle Receivables, Purchasing, Procure to pay and Oracle Inventory modules.
• Extensive use of pl/sql programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.
• Participated in performance tuning using Explain Plan and Tkprof.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Worked on UNIX shell scripting programs (Host executable type concurrent programs) and SQL LOADER jobs to load data from flat files into staging tables in Oracle.
• Developed Technical Specification documents (MD70) and Unit Test Scripts Documents (TE20).

Environment: Oracle Applications R12, GL, AP, AR, INV, PO, OM, FA, Iproc, Isupplier, Oracle 9i, Reports 10g, Forms 10g, XML Publisher, PL/SQL, SQL*Loader, TOAD, OAF,UNIX, Oracle R.I.C.E, BI Publisher Reports

Confidential, Lexington, SC

Oracle Apps Techno Functional Consultant

Responsibilities:

• Collaborated with business users to analyze and understand business problems and needs. Lead process configuration design activities.
• Involved in CRP meetings to discuss the issues and concerns regarding various requirements gathering and designing reports and forms.
• Worked on cross functional teams for resolving various oracle functional issues and gathering appropriate requirements.
• Created current business process documents BRD for the enhancement projects of Oracle Services system.
• Facilitated businessrequirements gathering and documentation and translated business user requirements into system requirements using Functional specifications documents.
• Ensured current procedures are in compliance with established processes, standards and tools.
• Verifies and ensures test plan, scripts support testing objectives are executed properly.
• Participates in defect management strategy and coordinate with project team to ensure timely resolution of defects.
• Presented Kick off meetings for start of project.
• Developed Conversion program to import Item Categories and Inventory Load.
• Analyzed business requirements, designed, implemented business solution design and development
• Developed Conversion program to import open invoices and adjustments.
• Customized the Statement program to suite as per the client requirements
• Customized the Aging buckets program to suite as per the client requirements.
• Converted standard reports into BI Publisher Reports.
• Developed Conversion program to import Party, Party Site, Location, Contact Points (Through API).
• Developed Conversion program to load Item On hand Quantities
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into purchasing interface tables
• Worked on different objects in Oracle Payables and Receivables as a part of production support.
• Customized forms for Advanced Pricing.
• Report to show all the Booked & Pending sales orders
• Designed and developed Interface programs to load Vendors in Payables using Supplier Open Interface
• Outbound interface of Cancelled Sales Orders.
• Imported Bills and Routings through BOM Interfaces.
• Worked on Quoting API’s for update Quoting tables and order creation
• Used Pricing API’s to get pricing calculations for quotes and to create new pricelists.
• Sales orders & RMA outbound Interface
• Involved in PL/SQL code review and modification for the development of new requirements.
• Coordinated with Functional team in understanding the Documentation, requirements gathering, and providing production support.
• Extensively worked in developing Functional Design Documents (MD50), Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in Design and Code reviews.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Supported the CRPs, SIT and go-live activities
• Responsible for custom program maintenance during the production support
• Tuned the application report queries, other SQL queries to improve the performance

Environment: Oracle Applications EBS - R12, Oracle 10g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher, BOM.

Confidential, San Francisco, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Understanding technical upgrade process. Compiled and executed number of forms, interfaces, custom reports, customizations/extensions etc
• Involved in technical upgrade like Concurrent custom reports had to be re-compiled and executed using Oracle reports and forms.
• Collaborated with business users to analyze and understand business problems and needs.
• Facilitated businessrequirements gathering and documentation and translated business user requirements into system requirements using Functional specifications documents.
• Collaborated and assisted IT teams in providing configuration solutions forbusinessrequirements.
• Developed various Oracle reports / Discoverer reports in AP, AR, and PO.
• Modified the existing old performance test cases to fit for new upgrade functionality
• Performed a technical upgrade which includes Reports, forms, interfaces and various customizations during upgrade process.
• Verifies and ensures test plan, scripts support testing objectives are executed properly.
• Participates in defect management strategy and coordinate with project team to ensure timely resolution of defects.
• Developed Packing slip report and Commercial Invoice Report using XML publisher (BI Publisher, RTF Templates).
• Working on TCA API’s for complex AR Customer conversion.
• Developed XML and BI publisher reports.
• Tuning SQL queries for better performance.
• Involved in Form personalization.
• Tuned the reports to improve performance during upgrade process.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes in upgrade.
• Developed stored procedures, functions and packages, Views for implementing major functionality of the system.
• Well trained in SOX and CAPS.
• Updating MD70 documents after upgrade based on MD50 documents.

Environment: Oracle Applications R12 (INV, OM, AR), Oracle PL/SQL, Forms 10g, Reports 10g, Toad, Oracle 9i, Api, RTF Templates, XML

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in developing and Review of AIM (MD050, MD 070) documents for (AP, OM, PO and AR) module implementation/development.
• Worked closely with the business teams to understand the intricacies of the business and document accordingly.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Involved in Importing the Orders data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program
• Involved in Item Conversion to import items, and its attributes from legacy system into oracle applications.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Involved in complete Procure to Pay (P2P) and Order to Cash (O2C) life cycle.
• Customized the Accounts payable Check report using BI Publisher/RTF e-text template.
• Worked on Inventory (INV) in defining a New Item in inventory and there increasing the On-Hand Quantity.
• Customized the Accounts payables EFT report to send file to bank using BI publisher/RTF report.
• Customized the Printed Purchase order report in Purchasing (PO) to meet the client’s requirements.
• Customized Reports in OE and Inventory Modules.
• Involved in customization of several standard reports to serve important business processes very specific to the client.
• Developed several customer facing reports using Oracle Report Builder.
• Customized the Inventory (INV) Item Report using Reports (6i).
• Developed a PL/SQL conversion programto import BOM items
• Developed BOM explosion program
• Developed outbound interfaces for cancelled purchase orders.
• Worked on cash management reconciliation programs
• Worked on Form Personalization in Oracle Receivables (AR).
• Customized Purchase Order (PO) Form using Custom.pll.

Environment: Oracle Applications EBS - R12, Oracle 10g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher, BOM.

Confidential, Dallas, TX

Oracle Apps Technical Consultant

Responsibilities:

• Interface program for receipt create, apply, write off and on-account
• Customer/party site conversion
• Item, Item Categories and Inventory Load.
• Manage support tickets Queue based on severity/priority/ team-member availability.
• Conducting peer code reviews. Tracking defects and interacting with project managers and business analysts to provide feedback/status.
• Suggesting process improvements to increase productivity, efficiency
• Evaluate and articulate requirements and identify impact, risk, and benefit of alternative solutions.
• Develop new inbound/outbound interfaces between Oracle apps and the third party system.
• PL/SQL programming, UNIX scripting.
• Design and customization of statements.
• Design and customization of Aging buckets.
• Modify inbound/outbound interfaces in Oracle apps and other legacy systems.
• Modification of existing workflow processes as per business needs.
• Extensively worked on OM API’s to import the orders from the legacy system and to process the order.
• Developed an interface to load data from third party systems to create PO Requisitions periodically.
• Business Merger: STARS and Accounting Business were different in their own way.
• STARS is an indirect way of business where we have the agent as intermediary between the Confidential and Customer.
• But, in the Case Accounting we relate with the customer directly while doing the Business.
• We merged both the stars and accounting projects business to have a good view of the business.

Environment: Oracle Applications 11.5.10.2(GL, AP, AR, FA, CM, PO, OM, INV, PA) Oracle 9i, Oracle 10G, PL/SQL, Forms and Reports 4i, Oracle Discoverer 10g, SQL*loader and HP UNIX

Confidential

Responsibilities:

• Being a technical consultant involved in all the custom components of the modules OM, INV, PO, and Pricing.
• Developed inbound interfaces on PO receipt creation, sales order import and sales person conversion.
• Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions and Workflows as per client requirements.
• Experience in BI/XML Publisher Reporting Tool
• Worked with SQL * Loader, UTL File for outbound and inbound interfaces
• Developed custom forms for common error handling framework mechanism for the capturing the errors in all the components including inbound and outbound interfaces.
• Worked on form personalization on receivables transaction form.
• Coding the requirements as per the standards
• Experience in customizing standard Oracle forms with the use of CUSTOM.PLL and Form Personalization

Environment: Oracle 10g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher, BI, RICE, UTL, CUSTOM.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Used various SQL tools to monitor database activity, bottlenecks and run query statistics
• Expert in RDBMS conceptual/logical and Physical database design and Modeling
• Created Integrity constraints and Database Triggers for data validation
• Created and modified SQL statements for ETL
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Extracted data from various sources for loading to destinations
• Used SQL Loader to read data from flat files and load into staging tables
• Sub-Queries and joins are extensively used in stored procedures
• Extensively used UNIX shell scripting for automating batch programs
• Wrote complex queries to retrieve information from large databases
• Experience in development activities including analysis, design, coding, data migration and testing for production and development environments
• Experience in database design modeling and design experience
• Writing ad-hoc queries
• Strong Trouble-shooting, Problem solving, Analytical & Design skills
• Trouble-shooting, Problem solving, Analytical & Design skills