SUMMARY

• 7+ years of Professional experience in Information technology having good experience in development, project deliverables, client relationship and service delivery excellence in Oracle E - Business Suite (EBS).
• Over 7+ years of professional experience in IT, Software Analysis, Design, Development and Testing in Oracle EBS and Over 4+ years of experience on Oracle Apps R12.
• Good functional knowledge of Service Contracts (SC), Install Base (IB), Order Management (OM), Inventory (INV), Account Receivables (AR), Account Payables (AP), General Ledger (GL), Work in Process (WIP), Purchasing (PO), Bills of Material (BOM), Project Accounting(PA), Human Resource Management System (HRMS), Quoting, Trading Community Architecture (TCA), Application Object Library (AOL) and System Administration.
• Hands on experience in development and extension RICEW components using SQL and PL/SQL, Customization of forms using Custom.pll, Oracle Reports, Oracle Forms, Workflow Builder, XML Publisher, OA Framework, Oracle Alert, Oracle Discoverer, Form Personalization and Shell Scripting .
• Good functional knowledge in "Procure to Pay” and “Order to Cash" business flows.
• Good at Sysadmin and AOL activities including creation of DFFs, users, responsibilities, menus, concurrent programs, request sets, request groups, value sets.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities and also for Interface development.
• Worked on Performance tuning using Explain Plan, TKPROF and SQL Tuning.
• Knowledge of underlying table structure of oracle applications modules for development of enhanced functionalities.
• Wide-range of experience performing requirement gathering, fit/gap analysis, functional specification design, functional testing, system testing, unit and integration testing, UAT, data conversion, documentation, user training, production and post-production support.
• Created business documentation using AIM Methodology like BR100, RD50, MD50, MD70, MD80, MD120, CV70, CV90, TE70, TE110, TE120, TE130 and PT120.
• A fast learner and a good team player with excellent technical, analytical, interpersonal, troubleshooting and communication skills.

TECHNICAL SKILLS

ERP Applications: Oracle EBS 11i/R12: Financials -- AP, AR, GL, TCA Distributions - OM,QOT Supply Chain -- INV, PO, BOM CRM -- OKS, IB HRMS

Operating Systems: Windows 95/98/NT/2000, Unix

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

Reporting Tools: Reports 6i/10g, XML Publisher, Oracle Discoverer

GUI Tools: Oracle Forms 6i/10g, Workflow Builder, Jdeveloper

Tools: SQL * Loader, TOAD, SQL Developer

Databases: ORACLE 9i, ORACLE 10g,11g

Configuration Tools: Visual Source Safe, PVCS, Serena Version Manager

ERP: Oracle Applications 11i, R12

Documentation: MS Word, MS Excel

Documentation Methodology: AIM Methodology (BR100, RD50, MD50, MD70, MD80, MD120, CV70, CV90, TE70, TE110, TE120, TE130 and PT120)

PROFESSIONAL EXPERIENCE

Confidential, IL

ERP Techno Functional Consultant

Environment: Oracle E-Business Suite 12.1.3, Oracle Report 10g, Oracle Workflow Builder, Oracle Application Framework, Oracle Forms 10g, Jdeveloper, TCA,TOAD, SQL, PL/SQL

Responsibilities:

• Design, development of various RICEW components in Oracle Applications R12 and Workflow customization.
• Bank Setups, Supplier setups and Payment Template setups in R12.
• Modifying the interfaces to make it R12 compatible. Components designed and tested include: (i) Customer conversion into TCA; (ii) Invoice conversion into AR;
• Used JDeveloper to make all extensions/changes to OAF components (EO’s/VO’s).
• Involved in creating new OAF Personalization.
• Involved in the complete auto lockbox setup process by setting up bank and bank accounts, importing a lockbox file, setting up the transmission format & fields, splitting the bank file to feed Auto lockbox.
• Designed and tested business case scenarios, unit testing and integration testing for various customized objects for Oracle Financials, Order to Cash and Procure to Pay Modules
• Experience working with Oracle Support in raising Service Requests and following them closely
• Provided Post Production support

Confidential, IL

ERP Techno Functional Consultant

Environment: Oracle E-Business Suite 12.0.6, Oracle Report 10g, workflow builder, Oracle Forms 10g, Oracle Discoverer, OAF,TCA, TOAD, SQL, PL/SQL

Responsibilities:

• Involved in the complete auto lockbox setup process by setting up bank and bank accounts, importing a lockbox file, setting up the transmission format & fields, splitting the bank file to feed Auto lockbox.
• Involved in the process of creating new Rate360 easy-to-navigate rate comparison tool which involves changed in Sales Force, Order Management, Quoting, Service Contracts by creation of Pl/sql Packages, Table, View & Sequence, Forms and Reports changes.
• Created new XML templates for Dunning letter.
• Used JDeveloper to make all extensions/changes to OAF components. Involved in creating new OAF Personalization.
• Components designed and tested include: (i) Customer conversion into TCA; (ii) Invoice Conversion into AR; (iii) interfaces to and from IB;
• Created new AP checks Templates and the necessary payment format, payment document and payment profiles.
• Created new NACHA XML Templates and related payment setups.
• Developed reports in Discoverer and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Service Delivery Workflow customization and PO Approval Workflow as per new requirement.
• Developed various custom reports and forms as per the business requirements in HRMS, FIN and SCM modules.
• Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
• Functional / Technical analysis of existing business process flow
• Interacted with customers for the requirements gathering and the new changes
• Involved in troubleshooting issues on Auto Invoice Import Program
• Designed and tested business case scenarios, unit testing and integration testing for various customized objects for Oracle Financials, Order to Cash and Procure to Pay Modules
• Experience working with Oracle Support in raising Service Requests and following them closely
• Provided Post Production support

Confidential, PA

ERP Techno Functional Consultant

Environment: Oracle E-Business Suite 12.1.1, Oracle E-Business Suite 11.5.8, Oracle Reports 6i, Oracle Report 10g,OA Framework, workflow builder 2.6,Oracle Forms 6i, TOAD, SQL, PL/SQL

Responsibilities:

• Functional / Technical analysis of existing business process flow
• Interacted with customers for the requirements gathering and the new changes
• Done the changes for the custom codes from 11.5.8 instance to 12.1.1 instance
• Functional and Technical support in the Oracle EBS ( SC, IB, AR)
• Developing custom scripts for data fixes
• Involved in troubleshooting issues on Auto Invoice Import Program
• Developed Auto Lockbox interface program for Oracle Accounts Receivables
• Preparation of technical design document MD070, installation document MD120, technical and functional specifications and customization documentation and technical process/data flow chart for development work
• Maintaining the custom scripts in PVCS and storing the understanding and Test case documents by creating various folders in Portal for reference by future testers and users
• Working with Mercury, for registering the packages and the SQL scripts in the various instances to move into Production server
• Designed and tested business case scenarios, unit testing and integration testing for various customized objects for Oracle Financials, Order to Cash and Procure to Pay Modules
• Involved in creating new OAF Personalization.
• Performed Standard Functionality testing in Service Contracts, Install Base, Account Receivables
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications
• Identified performance bottlenecks in code developed by others, fixed them
• Experience working with Oracle Support in raising Service Requests and following them closely
• Provided Post Production support

Confidential, Boston

ERP Techno-Functional Consultant

Environment: Oracle E-Business Suite 11.5.10.2, Reports 6i,forms 6i, Oracle Report 10g, Workflow Builder 2.6, TOAD

Responsibilities:

• Discussion with clients on any new business requirements or changes
• Developed new Oracle Alerts based on the requirement
• Developed new XML Reports, converted the existing Oracle Reports to XML publisher reports
• Developed more than 50 new oracle reports that should replace the legacy reports that are used in monthly and day to day activities of AS&E business which are utilized primarily in the Finance, Manufacturing, Services and Contracts departments
• Developed new Discoverer Reports based on the customer requirement
• Worked on AR Auto lockbox programs
• Customized OM standard header and line workflows
• Preparation of functional specifications of the Oracle E-Business Suite reports based on the requirements from ASE
• Involved in creation of Database staging Tables, views, triggers
• Prepared MD50, MD70, MD80 for the various development activities
• Worked on Mercury Quality Center/Test Director for defect tracking and resolution recording
• Defined Payment terms according to business requirements
• Worked on various Oracle & XML reports in Inventory, BOM, Order Management and Purchasing
• Participated in customizing Order workflow in Order Management in accordance with user’s specifications
• Design, Develop & publish the unit testing results for each of the reports
• Deployment of the reports in the User Acceptance Testing (“UAT”) environment
• Was involved in Standard Functionality testing for few instances
• Responsible for extrapolating the performance data from Oracle e-Business suite module and other Monitoring tools and identify Bottlenecks in the system & propose steps to resolve them
• Involved in developing Test Plans and Test cases for the various custom reports and codes
• Involved in performing Performance Testing and fine-tuning of the various custom codes
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases

Confidential

ERP Techno Functional Consultant

Environment: Oracle E-Business Suite 12.0.4, Oracle Reports 6i, Oracle Report 10g, workflow builder 2.6,Oracle Forms 6i, SQL * Loader, TOAD

Responsibilities:

• Responsible for managing the RICE development team at offshore
• Analyzed business requirements and performed fit-gap analysis to map user requirements to R12 functionality / transactions utilizing Oracle’s AIM Methodology
• Involved in gathering client requirements
• Provide estimates for all technical components
• Developed interface and conversion programs using PLSQL and Oracle Standard APIs
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities
• Developed new Oracle 6i and Oracle 10g Reports based on the client’s requirements
• Developed new XML based Reports
• Extensively used Workflow Builder to create Processes, Messages and Notifications
• Written various CV70, CV90 documents for the data conversion
• Preparation of data Conversion Strategy from legacy to oracle database as per the client standards
• Responsible for R12 data conversion of AR and AP invoices data
• Involved in Unit Testing and System Testing
• Interacted with business team, prepared To Be Scenarios and documentation
• Documented setups, processes, and logged issues
• Performed debugging of the applications and helped team members in troubleshooting and debugging
• Created technical and functional specifications and customization documentation

Confidential

ERP Techno Functional Consultant

Environment: Oracle E-Business Suite 11.5.10.2, Oracle Reports 6i, Oracle Report 10g, workflow builder 2.6,Oracle Forms 6i, TOAD

Responsibilities:

• Developed new custom forms based on the requirements and deployed the same in the Oracle EBS
• Customizing standard forms using custom.pll
• Created new custom responsibilities
• Done the Forms personalization applicable only to the specific responsibilities
• Administered the business process and created new workflow for the sales order approval hierarchy
• Developed new Oracle 6i and Oracle 10g Reports based on the customer requirements
• Developed new XML based Reports
• Preparation of the MTP documents for the Production move. Involved in developing the Technical Design, Test Plans and schedules for Integration and User Acceptance Testing
• Discussion with clients on any new business requirements or changes
• Performed all the testing of the Procure to Pay (P2P) and Order to Cash (O2C) modules
• Defined pricelists and used modifiers for different pricing scenarios
• Performed system administration functions such as creation of users, responsibilities, menu, concurrent programs, request sets, request groups, DFF and value sets
• Approval groups and assigned approval status for designated staff members
• Setup various Employees and Buyers
• Written standard test scripts for Oracle Financials and Manufacturing Modules
• Responsible for extrapolating the performance data from Oracle e-Business suite module and other Monitoring tools and identify Bottlenecks in the system & propose steps to resolve them
• Conducted business workshops/trainings to explain the new functionality done in the sales order, Inventory modules, workflows and review end-user and super-user feedback for improvements
• Completed user training and application setup/ training documentations. Also involved in training the users
• Conducting UAT and helping the user for going through all the test cases
• Worked on Mercury Quality Center/Test Director for defect tracking and resolution recording

Confidential, PA

ERP Techno-Functional Consultant

Environment: Oracle E-Business Suite 11.5.8, Reports 6i,workflow builder 2.6, OA Framework, Forms 6i, TOAD, SQL Navigator

Responsibilities:

• Discussion with clients on business changes
• Preparing functional specification for customizations
• Prepared interface programs for contract module
• Developing and Customizing Oracle Reports and Forms
• Functional and Technical support in the Oracle application (OKS,IB, AR, AP and GL)
• Developing custom scripts for data fixes
• Dealt with issues at different stages in the Order to cash cycle
• Worked on the customization in the Install Base. Also, developed the custom program to en-queue and de-queue the messages
• Developed interface program to import details from the legacy system to Oracle Service Contracts. Developed validation programs to validate the data before loading into interface tables
• Responsible for creating Responsibilities, Programs, Menus, Functions, Executable and Request Groups
• Responsible for creating new users and assigning the responsibilities to the users
• Imported data from legacy system to temporary tables using SQL*Loader
• Substituted/extended the seeded regions, COs & VOs using Jdeveloper.
• Preparation of MD120 documents for development work and Conversion Process according to AIM Methodology
• Maintaining the custom scripts in PVCS and storing the understanding and Test case documents by creating various folders in Portal for reference by future testers and users
• Participated in the Unit and Integration Testing along with the end-users
• Working with Mercury, for registering the packages and the SQL scripts in the various instances to move into Production server
• TAR was created and supported with the Oracle
• Provided Post Production support

Confidential

ERP Technical Consultant

Environment: Oracle E-Business Suite 11.5.8, Reports 6i,workflow builder 2.6,forms 6i, TOAD, SQL Navigator

Responsibilities:

• Customized Oracle Reports for the module AP, AR, PA, PO and INV
• Performed system administration functions such as creation of users, responsibilities, menu, concurrent programs, request sets, request groups and value sets
• Involved in Data Migration of Customers, Open AR Invoices
• Worked in Workflow Builder to create Processes, Messages and Notifications
• Used AOL to register reports and PL/SQL Packages
• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10)
• Set up Functions, Menus, Functions, Value Sets, Look Ups, and Flex fields
• Solving ticket’s involving problem solving, analyzing and understand the Business Flow, Functional and Technical aspects of these modules and developing the Custom Script for the fixes
• Created and Registered Concurrent Executable, Concurrent Programs and Request Sets of Reports, SQL* Loader and PL/SQL Packages in the front-end using AOL
• Involved in creating test plans & test cases
• Creating and Supporting TAR with Oracle
• Created and Registered Concurrent Executable, Concurrent Programs and Request Sets of Reports, SQL* Loader and PL/SQL Packages in the front-end using AOL
• Participated in the Unit and Integration Testing along with the end-users
• Provided Post Production support