SUMMARY

• Over 7 years of experience in Design, Development and Implementation of Oracle Applications.
• Worked extensively as Oracle Apps Techno - Functional Consultant in modules Oracle General Ledger (GL), Oracle Account Payables (AP), Oracle Account Receivables(AR),Revenue, Oracle Fixed Assets(FA), Order Management(OM), Cash Management (CM), Inventory(INV), Purchasing(PO), Payroll(HRMS), Application Object Library(AOL), Oracle Projects, Workflow, forms, Oracle Framework and System Administration.
• Experience in ERP Oracle Application E-Business suite (10.7 SC/11.0.3, 12.0.6/11.5.10 ),Oracle Applications 11i, Oracle 8i/9i, Oracle 8.x.
• Proficient in developing Procedures,Functions, Packages, Triggers, Materialized Views, Synonyms, Sequences and other database objects using SQL and PL/SQL.
• Strong analytical and technical skills with good programming experience in SQL, PL/SQL and UNIX shell scripting.
• Excellent skills in Application Development using Oracle Developer 6i/2000(Forms 4.5/6i/10g and Reports 2.5/6i/10g), TOAD, SQL Loader utilities.
• Developed various reports using Discoverer4i/10g in different Oracle Financials modules.
• Experienced in developing and customizing new/existing Forms and Reports according to client specification to suit improvised business processes forms personalization and customizations.
• Worked on Upgrading of R11i to R12.
• Customization of oracle forms & reports of purchasing module.
• Service requests, item instance details, inventory and contracts etc in install base systems.
• Manage warranties, book of contracts, extended warranties and usage etc in service contract system(SC).
• Provided Technical Design for all the main OA pages developed for Total Compensation Statement.
• Customized I Expense and I Procurement pages for adding custom validation and changes in display.
• Strong experience in designing, developing and troubleshooting developing Reports, Interfaces (Inbound & Outbound), Conversions, Extensions & Workflow (RICEWF) in Oracle Applications.
• Running different type of Interface programs like Auto-Invoice, Auto-Lock Box etc in Financials.
• Modified packages, procedures, functions and triggers for designing user interface.
• Comprehensive knowledge of System Development Life Cycle (SDLC). And good understanding Business Flows like inP2P and O2C. Good knowledge about Multi-Org and Multi-Currency setups. Working Knowledge on I procurement self-service module.
• Proficient in Legacy conversions, Application Customizations and Interface development. Expertise in SYSADMIN and in Oracle Applications activities managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, providing support to users for any technical issues.
• Experienced in creating Functional and Technical documents (MD 50, MD60 and MD 70).
• SOB’s, Ledgers (R12) and Legal Entity setups for an Organization based on Client requirements. Resolving production issues reported by End Users.
• Proficiency in Documenting Business Processes and GAP Analysis including inidentifying gaps and documenting the gaps Confidential a detailed level.
• Comprehensive knowledge of AIM (Application Implementation Methodology).
• Have very strong analytical and communication skills. Structural and methodical in approaching a problem.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i 11.5.10, 11 X, Tech & Functional modules Sys Admin, AOL (Application Object Library), OAFWorkflow,Oracle Projects, Payroll (HRMS) and AIM

Documents: GL, AP, PO, INV, AR, FA, CM, TCA and OM.

Oracle Tools: Forms 4.5/6i/10g, Reports 2.5/6i/10g, Discoverer 4i/10g.

Programming Languages: SQL, PLSQL, C, C++, JAVA, HTML,XML

Databases: Oracle 8i/9i/10g/11g

Operating systems: Windows NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Oracle Applications Functional Consultant

Responsibilities:

• Worked on the complete Auto lockbox setup process in Account receivables.
• Worked with creating executables, concurrent programs, request set, Request Group, Value setin Account Receivables (AR).
• Worked on creating the control file and Unix shell script program.
• Involved in analysis, design, coding, testing and implementation of the entire project.
• Studied the existing system, prepared the Functional (MD50), Technical (MD70), Migration matrix, Test results, Business requirement (BR100) design documents.
• Worked on lockbox process steps like how to import the data, validation and post quick cash in AR.
• Created the Unix shell script program in such a way that schedule the process and send the notifications from the concurrent program.
• Worked on Supplier remit advice file (SRAF) configuration settings, File transmission information and file specifications.
• Performed problem analysis, debugging and coding as part of production support and new development.
• Involved in documenting user requirements, technical specification and reporting manuals.

Environment: Oracle Applications R11i (GL, AR),PLSQL, SQL loader, SQL*Plus, BI Publisher, AOL, TOAD and Workflow Builder.

Confidential, Denver, CO

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in analysis, design, coding, testing and implementation of the project.
• Used various Triggers and Procedures to validate data Confidential each level.
• Created some custom tables using TOAD, developed control files to load the data into the Oracle system using SQL*Loader.
• Developed Forms and Customized Forms to meet the Client requirement mainly in Financial Modules (GL, AP, AR and FA) using Oracle Forms.
• Worked with creating executables, concurrent programs, request set in General Ledger (GL) module, Account Receivables (AR).
• Worked on the complete Order to Cash cycle modules including Order Management, Inventory and Shipping.
• Set up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Worked on order import interface for sales order conversion.
• Customized Application by creating Menus, Request Groups and Setting up Forms, Form Functions and attaching to menus. Reports by registering in Concurrent Executables and Concurrent Programs.
• Developed oracle forms, PL/SQL stored procedures, SQL scripts and functions to provide customers.
• Involved in design, development & implementation of Oracle Application modules AR, AP& PO.
• Studied the existing system, prepared the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Created control files for SQL *Loader as part of conversion process to extract legacy data from existing applications and load them into Pa transaction interface all table and then ran the Transaction import process to load data into project base tables.
• Registration of customized Reports through creation of concurrent executables, concurrent programs, assigning to Request Group.
• Developed interface program to close old Purchase Orders in the ERP system.
• Used the System Administrator responsibility to create User, Responsibilities and Request Groups.
• Developed PL/SQL Packages and Database Triggers.
• Implemented the business logic by Oracle Stored Procedures/Functions in the backend.

Environment: Oracle Applications R11i (PO, AP, GL, AR),OM,INV,Oracle 10g, Forms, Reports, PLSQL,SQL loader, SQL*Plus, BI Publisher, XML, TOAD andWorkflow Builder.

Confidential, Carlsbad, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in design, development & implementation of Oracle Application modules AR, OM, INV& PO.
• Customized the Sales Order Line and HeaderWorkflow to meet the business requirement.
• Developed SQL * Loader programs to load data from flat file to stage tables. Written PL/SQL procedures to validate and load the data into the Oracle Interface tables or directly into the Oracle base tables for the respective modules.
• Worked on order import interface for sales order conversion.
• Worked on Sales Order API for editing sales order data.
• Worked on Upgrading of R11i to R12.
• Performed problem analysis, debugging and coding as part of production support and new development.
• The Pharmacist Verification stage of workflow has an additional option to Verify the Patient, Drug/Mixture, Doctor and Rx individually
• Customized sales order form based on the business requirement.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Providing troubleshooting assistance to all issues and concern related to oracle forms.
• Modified packages, procedures, functions and triggers for designing user interface.
• Developed the Custom Scheduling Program for Order Lines Scheduling using I proc.
• Configured UOM and PO Catalogs in eCommerce Gateway in order to map with Supplier UOM.
• Assign pricing products, types of discounts and creating a price list etc in oracle advance pricing.
• Written interface programs for AR customers, AR invoices.
• Involved in the complete Order to Cash and Procure to pay cycle.
• Studied the existing system, prepared the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables. Used AOL and System Administrator modules for registering the developed and customized reports.
• Proficient in Developing, Customizing and Implementation of Oracle SCM, MFG and Oracle Financial Modules and integration between the modules and accounting Entries.
• Wrote common Packages and Procedures, Registering them as Concurrent Programs in Oracle Applications which helped the team members.
• Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report,Purchase Requisition Status Report) according to the functional specifications using Reports 10g, BI publisher.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields. Registered concurrent programs, request groups for reports and concurrent requests.

Environment: Oracle E-Business Suite R12 (OM, INV, WSH, AR and PO), Oracle 10g, Oracle Developer 10g (Forms 9i/10g, Reports 9i/10g), BI Publisher, Workflow Builder 2.6, TOAD, SQL*Loader, SQL*Plus, PL/SQL, OAF.

Confidential, South Park, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Working on the entire SDLC of the project starting from Requirements Gathering, Analysis, Design, Development, Testing and Production support.
• Have been working with the clients to understand their requirements and resolve any issues they face with the current application.
• Developed PL/SQL Packages, Procedures and Functions for validation of the invoices and payment information from the legacy system to import into Oracle Application.
• Designed and Developed PL/SQL Packages to import AR Invoices andAR Receipts legacy information into Oracle.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * Loader
• Created database objects like packages, procedures, and functions according to the client requirement.
• Developed the Custom Scheduling Program for Order Lines Scheduling using I proc.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexestables for faster retrieval of the data to enhance database performance
• Modified, maintained and developed the sql codes to develop new enhancement in oracle forms.
• Involving in the complete Order to Cash and Procure to pay cycle.
• Reports and using various templates to publish the reports as per user requirements.
• Worked on Check Printing, AP cleared checks, Invoice Aging Reports for Payables to accomplish customization according to business requirements.
• Involved in AP Invoices Conversion, Customer Conversion, VendorConversion, AR Invoice Conversion and GL Year end and Monthly balances Conversion.
• Developed Interface programs to load order information from legacy system-to-system tables. Interim Tables created to hold the data from the flat file. This was done to load data in CSV file obtained from the External system. To achieve this, few concurrent programs were developed to Load data from a flat file into interim tables.
• Developed interface program for conversion of sales orders using the Order Import Open Interface program.
• Developed oracle forms, PL/SQL stored procedures, SQL scripts and functions to provide customers.
• Tested and Fixed bugs in existing Forms &Reports.
• Developed interface program to close old Purchase Orders in the ERP system.
• Defined payment terms, locations, and Invoice approvals and setting up account information in Oracle Financials AP.
• Customized Requisition Approval andPO Approval workflow for Procurement.
• Developing accounting reports using Discoverer.

Environment: Oracle Applications R12/11i (PO, AP, OM, GL, AR),Iproc, PLSQL,SQL loader BI Publisher, XML,EDI, Discoverer, TOAD,JDeveloper 11.1.1.3, forms, Workflow Builder and OAF.

Confidential, Alpharetta, GA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked on customizations ofcustom reports, XML reports, packages, functions, and triggers, workflows in the areas of OM, INV, PO, and AR.
• Worked on the complete Order to Cash cycle modules including Order Management, Inventory, Shipping and Receivables.
• Developed custom API’s to change the move order lines after pick release.
• Developed packages to create locations, customers, customer sites using TCA API.
• Developed PL/SQL procedures for conversion of items using the Open items import program and data validation of the Journal Entries and then ran the Standard Journal Import Program to integrate with Oracle Applications
• Responsible for design and development of screens/reports using Oracle Forms/Reports.
• Worked on developing various profile options to in corporate security in Oracle Reports, XML Reports etc.
• Wrote functions to cater to various business requirements like getting Line of Business Information, Set of Books, Legal Entity, and Code combination Segments information by passing the code combination id. The developed functions were used in all the programs being modified.
• Provided Technical Design for all the main OA pages developed for Total Compensation Statement and a flexible OA design which is configured using OA personalization.
• Assisted In designing of tables, data base, forms, reports, connected forms with oracle application.
• Generated the extract report for the Price List changes using Reports 6i.
• Designed a program to submit all the month end jobs as per schedule.
• Involved in preparing technical and functional documentation (MD50/MD70) for Packages, Procedures, Reports, and Workflows, etc.
• Was responsible for defining system security parameters including: responsibilities, request sets, and system access.
• Troubleshoot workflow issues related to error activities in notifications and SQL errors.
• Registration of customized Reports through creation of concurrent executables, concurrent programs, assigning to Request Group.
• Set up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.

Environment: Oracle Applications 11.5.9 (PO, INV, OM, AR, GL), ORACLE 9i, PL/SQL, forms, Reports 6i, Discoverer 4i, TOAD, Windows XPand OAF.

Confidential, Charlotte, NC

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked with creating executables, concurrent programs, request set in General Ledger (GL) module, Order Management.
• Dealt with registering / defining of custom applications, tables, forms, reports, concurrent requests standard report submissionetc and also with profile options, defining of application users and responsibilities.
• Worked on importing Legacy Journals into General Ledger using SQL*Loader, GL Interface and Journal Import.
• Worked on customization of Order Import Interface in Oracle Order Management.
• Worked on Form Personalization in Order Management.
• Worked in development of new reports in Order Management and Process Manufacturing modules like Sales Log Report, Finished Goods Stock Status Report.
• Involved in Project cost conversions open interface.
• Created control files for SQL *Loader as part of conversion process to extract legacy data from existing applications and load them into Pa transaction interface all table and then ran the Transaction import process to load data into project base tables.
• Worked on AP Invoices Conversion to convert the paid invoices data.
• Developed new reports using Report 6i and also customized standard reports.
• Modified GL reports designed, developed and tested custom reports for Account payables (AP) as per user’s requirements.
• Customized Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the report of Fixed Asset and Project Accounting.
• Worked on Order to Cash Process (O2C) and procure to pay (P2P).
• Experience as Oracle APPS System Administrator in creating new users, Responsibilities, Menus and User Security system. Created Concurrent Programs and Concurrent executables along with Value Sets, Flex Fields.
• Customized Application by creating Menus, Request Groups and Setting up Forms, Form Functions and attaching to menus. Reports by registering in Concurrent Executables and Concurrent Programs.
• Customized the Blanket Purchase Order, Standard Purchase Order using Reports 6i.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.

Environment: Oracle Applications 11.5.10 (Modules: GL, AP, AR, PO, OM, INV, BOM, MRP, CST), Oracle 9i, SQL* Loader, SQL* Plus, PL/SQL, Toad, UNIX, Shell scripts.

Confidential, Englewood, CO

Oracle Applications Technical Consultant

Responsibilities:

• Performed various open interfaces in GL, PO and AR financial modules.
• Worked on Auto Invoicing to import Invoices from legacy systems into Oracle Receivables (AR).
• Developed a package that validates invoice information and load the invoices into AR by
• Running an Auto invoice daily Report.
• Created some custom tables using TOAD, developed control files to load the data into the Oracle system using SQL*Loader.
• Developed Forms and Customized Forms to meet the Client requirement mainly in Financial Modules (GL, AP, AR and FA) using Form 6i.
• Developed Reports 6i and Customized the Invoices posted to suspense account and Credit on Hold Reports in AR.
• Customized Reports to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Reports in AR, GL modules.
• Worked on Discoverer Admin, Discoverer Plus and Discoverer Desktop.
• Developed using Discoverer 10g. Created Business areas, Complex Folders, Item classes based on user requirements in AP, AR, FA and OM.
• Interacted with users to resolve any issues during the production, development and enhancement phases. And Involved in various activities like preparation of Technical Documents, discussions with the client regarding the proposed solution.
• Defined DFF’s on Banks and Aging Periods in AP to facilitate the additional information.
• Extensively used the AOL to create value sets, register Concurrent Programs, Forms and Reports, certain SQL scripts, SQL*Loader Programs, PL/SQL Procedures.
• Used the System Administrator responsibility to create User, Responsibilities and Request Groups.
• Developed PL/SQL Packages and Database Triggers.

Environment: Oracle Apps 11.5.10 (GL, AP, PO, AR, FA, CM and OM), Oracle 10g, Forms 6i, Reports6i, Discoverer 10g, SQL*Loader, SQL, Pl/SQL, TOAD, Windows 2000, HP-UNIX.

Confidential

Senior Oracle Apps Technical Consultant

Responsibilities:

• Involved in creating Tables, Developing screens and generating reports in Registration, Enrolment, Assessments, Inspections and Return Modules.
• Developed Packages and Customized Functions and Triggers based upon the tax requirements.
• Assisted in installing Application Server, Report Server and Database Server.
• Designed, Developed and Customized Forms by using Oracle Form 6i and Report 6i.
• Prepared test plans for System and User acceptance test.
• Involved in documenting user requirements, technical specification and reporting manuals.
• Hands on experience in migrating from legacy system to Oracle database using SQL Loader.

Environment: Hp-Unix, Oracle 9i, Forms 6i and Reports 6i, Oracle Apps 11i (Financials).

Confidential

Oracle Technical Consultant

Responsibilities:

• Developed monthly and yearly salary comparison reports using Oracle Reports 6i.
• Developed expense reports, both department and company wise using Oracle Reports 6i.
• Responsible for stored program development using PL/SQL packages, procedures, functions and triggers.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Provided training to end users on FORMS and REPORTS.

Environment: Windows NT, Oracle 8.0, Reports 6i, Forms 6i, Pl/SQL, SQL*PLUS.

Confidential

Software Programmer - Oracle Developer.

Responsibilities:

• Involved in analysis, design, coding, testing and implementation of the project.
• Creation of the database objects like tables, views, constraints, procedures, packages using Oracle tools like SQL*Plus and PL/SQL.
• Implemented the business logic by Oracle Stored Procedures/Functions in the backend.
• Responsible for requirements analysis, creating E-R diagrams, table design, database creation, preparation of program specifications, GUI design.
• Created Materialized Views to have the snap shot of a table.
• Used various Triggers and Procedures to validate data Confidential each level.
• Developed forms using Forms 4.5 and reports were using Reports 2.5 as per requirement definition.
• Redesign the database to tune its performance to handle the user traffic and load during peak times.
• Involved in upgrading from Oracle 7.x to Oracle 8i. Involved in technical and user documentation.

Environment: Oracle 7.x/8i, SQL, PL/SQL, Forms 4.5, Reports 2.5, Windows 98.