Summary

• 14 years of experience in Information Technology, involved in Analysis, Design and Development of Oracle Applications R12,11i, Oracle based ERPs and Client-Server Technology Applications on Windows and UNIX environments.
• Excellent Techno-functional knowledge in Order to Cash and Procure to pay cycle.
• Working experience in the implementation, designing customizations and extensions in Oracle Manufacturing, Supply Chain and Financials Modules.
• Experience in Implementation and Production Support of Oracle Application 11i and other ERPs. Handled different Kinds of Projects in Oracle Applications11i and Oracle based ERPs for the Clients like Cisco System (San Jose, USA), AT&T (Atlanta, GA), Doosan(Atlanta, GA),Agilent Technologies International (Palo Alto, CA USA), Deloitte -Diebold (North Canton, OH, USA), Emerson Motor Company, (St. Louis, MO USA) and Escorts Agri Machinery Group (Faridabad, India).
• Experienced in O2C and P2P processes with more focus on O2C process. Implementation experience in OM, AR, INV, Oracle Purchasing,Oracle Receivable, AP, GL, BOM etc.
• Implementation experience in Data Conversions, Interfaces, Extensions, Customization and new development in Oracle Application including Order Management, O2C, Oracle General Ledger, Oracle Payables, Oracle Receivables, Purchasing, Fixed Assets, Inventory, Bill of Materials ,Warehouse Management and Work in Process.
• In depth knowledge about Oracle apps data flow and data model for O2C, P2P areas including OM, PO, INV, AR,CDH, GL, BOM, WIP Modules
• Expertise in AOL, System Administration. Working knowledge of Workflow,SOA Suite, Alerts and Trading Community Architecture (TCA), including Oracle Order Management. Used both Oracle AIM (Application Implementation Methodology) and other custom methodologies for Implementation and Upgradations.
• Extensive experience in Performance Tunning,Oracle backend objects like Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Extensive experience in documentation, created technical design documents from functional design documents.
• Expertise in developing database applications using Oracle with Developer 2000 (Forms 10.x, Reports 6i). Started working as a software engineer/developer in Oracle based ERP’s like Avalon; then began working as Oracle Applications 11i techno functional consultant. Technical Consultant for Account Payables, Account Receivables, PO, GL and Order Management,AR modules.
• Expertise in Project Mangement, Coordinations,Vendor selection and Customer interactions
• Functional expertise - Requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training documents, training end users, and production support.
• Technical (technical lead, developer, etc.) activities: interfacing with users, identifying functional and technical gaps, estimating work, designing custom solutions, and programming, leading developers, scheduling, producing documentation, and providing production support.
• Experienced in Developing Functional Specification, Technical Specification and Design Document. Having strong debugging skills.
• Having strong Business and Analytical skills and domain knowledge of Automotive, Manufacturing, Telcom and insurance.
• Knowledge of BPEL MANAGER, OAF ,OBIEE,SOA,JAVA,ADF,JDEVELOPER

Education:
Masters of Technology in Computer Science and Engineering from Kurukshetra University, India 1998

Techo Functional Skills:

Oracle Applications R12,11i, AVALON. Oracle Workflow, EDI,AOL, Alerts, and SYSADMIN GL,AR,PO,P2P,AP,PA,FA, Shell Script, SQL, PL/SQL, Oracle 7.x/8.x,9i,10G TOAD, CVS, PVCS, Clear case, Taviz, SQL*Loader, Export, Import, Workflow builder, Appworx, Autosys,Kintana, OAF ,BI Publisher, JDevloper,ADF,SQR
Knowledge of BPEL MANAGER, SOA,JAVA

Professional Experience:

Confidential– Atlanta ,GA May 2012-till date
Sr. Oracle Apps Consulatant

Project Description This project involved Enhancements.

Responsibilities:

• Worked with Business Systems Analysts/Designers to identify and research new functionality required to meet business users needs .
• Deployment of these components in Production environment.
• Suggest alternatives and work-around to problems being faced by the clients.
• Write functional/Technical sepecification ,KT and testing Documents
• Write test cases
• User group meetings to address support and training issues/concerns.
• User Training and Demo

Environment: oracle financials AP ,AR,GL,PL/SQL,AOL,WORKFLOW,Forms6i,Reports6i,Alerts,XML,Toad,
MD70,MD120, etc.

Confidential -- seattle,wa June 2011-Feb 2011
Sr. Oracle Apps Consulatant

Project Description This project involved Enhancement and production support in Oracle Application 11i .

Responsibilities:

• Worked with Business Systems Analysts/Designers to identify and research new functionality required to meet business users needs .
• Deployment of these components in Production environment.
• Suggest alternatives and work-around to problems being faced by the clients.
• Worked with large databases with high transaction volume in a fast-paced, production environment.
• Query and report performance tuning.
• Responsible for Analysis, Design, Development,Testing and System Integration Testing for the
• Work Oracle production issues and see thru to resolution.
• Worked with Oracle Tar process to resolve ongoing release issue vs patch implementation.
• Provided run-time business solution for HRMS,AP,GL,FA,PA, AR,OM
• Write interfaces and documents for integration between Oracle and CLOUD ERP(PLEX)
• Test plan preparation, Review of test plans, unit & integration testing.
• Everyday Production Support: Troubleshooting of problems related to delivered Oracle E-Business solutions and interaction with business users. Provided techno-functional solution as needed.

Environment: Oracle Financials/SupplyChain//Manufacturing modules,PLex(Cloud ERP),D2K ,PL/SQL,SQL,AOL,SYSADMIN,WORKFLOW,Shellscript,Unix,WEBADI,XML, Oracle FMW ,Hybrid cloud

Confidential ,San Diego,CA Oct 2009 - Mar 2011
Sr. Oracle Apps Consulatant

Project Description This project involved Enhancement and production support in Oracle Application 11i .

Responsibilities:

• Worked with Business Systems Analysts/Designers to identify and research new functionality required to meet business users needs .
• Deployment of these components in Production environment.
• Suggest alternatives and work-around to problems being faced by the clients.
• Worked with large databases with high transaction volume in a fast-paced, production environment.
• Query and report performance tuning.
• Worked on data model for HRMS,Payroll,O2C, P2P areas including OM, PO, AR,AP,GL Modules
• Responsible for Analysis, Design, Testing and System Integration Testing for the project - Responsible for preparing technical and Unit testing documents.
• Work Oracle production issues and see thru to resolution.
• Worked with Oracle Tar process to resolve ongoing release issue vs patch implementation.
• Test plan preparation, Review of test plans, unit & integration testing.
• Followed Qualcomm Coding and Quality standards for documentation Development.
• Everyday Production Support: Troubleshooting of problems related to delivered Oracle E-Business solutions and interaction with business users. Provided techno-functional solution as needed.

Environment:Oracle Applications R12,11.5.10 , Oracle FMW ,Oracle Supply Chain/Financials modules

Confidential, San Jose, CA Aug 2008 - Oct 2009
Consultant/Project Manger

Project Description This project involved Enhancement and production support in Oracle Application 11i,R12 .

Responsibilities:

• Work with Business Systems Analysts to identify and research new functionality required to meet business users needs .
• Involved in all the stages of the Project enhancements, gather requirements, Prepared Technical Design Documents,
• Prepared Technical/functional specification Documents.
• Deployment of components in Production environment.
• Responsible for providing tier 2 supports and incident management for the production application, interacting directly with the end-users, client application administrators, and functional and technical resources.
• Suggest alternatives and work-around to problems being faced by the clients.
• Worked with large databases with high transaction volume in a fast-paced, production environment.
• Query and report performance tuning.
• Work Oracle production issues and see thru to resolution.
• Responsible for managing help desk ticket reports and monitoring progress and resolution with Oracle Support to log and resolve SRs
• User group meetings to address support and training issues/concerns.
• Test plan preparation, Review of test plans, unit & integration testing.
• Work with the client and off-shore team for Custom upgrade,functional enhancements & application and application interface development and deliver.
• Team Managment

Environment: Oracle Applications R12 upgrade,11.5.10 Oracle Supply Chain (OM,GL, Receivables & Purchasing) ,Upgrade,Form 6i,Forms10g,Report 6i,PL/SQL,SQL,Kintana,PVCS,SOX,AOL, SYSADMIN, WORKFLOW ,Shell Script,Unix,LiveLink,Cisco Related Tools

Confidential, Saint Louis ,MO Feb 2008 - Aug 2008
Consultant/Project Manger

This project involved the migration from JDE system and implementation of Oracle Application 11i Financials, SCM, HRMS and CRM modules.

Responsibilities:

• Work with Business Systems Analysts to identify and research new functionality required to meet business users needs.
• Prepared Technical/functional specification Documents.
• Development of complex Queries, APIs, procedures, functions, packages, Triggers and reports using pl/sql.
• Development of forms,reports,interfaces and other extensions of OM,AR,AP and GL
• Data Mapping and validations
• Worked on data model for O2C, P2P areas including OM, PO, INV, AR,CDH, GL, BOM, WIP Modules
• Data conversion and migration from JDE to Oracle Application 11i.
• Responsible for end to end testing.
• Team Managment
• Test plan preparation, Review of test plans, unit & integration testing.
• Work with the client and off-shore team for functional enhancements & application and application interface development and deliver.
• User group meetings to address support and training issues/concerns.
• Followed Emerson Coding and Quality standards for Development.
• Involved in Code reviews of objects developed by other team members and ensure the Quality standards.

Environment:OracleApplications11.5.9(OM,AR,GL,AP,AOL,SYSADMIN),Workflow,Form6i,Report6i,PL/SQL,SQL,Kintana,PVCS,JDE

Confidential,Atlanta,GA
Oracle Supply Chain Analyst Nov 2007 - Jan 2008

Production Support for SCM Oracle Applications 11.5.10.2

Responsibilities:

• Responsible for all aspects of Production support.
• Work with business users as a second tier resource for functional and technical issues
• Suggest alternatives and work-around to problems being faced by the clients.
• Respond to client support requests by diagnosing and resolving problems within guidelines, and escalates more complex problems to Business Systems Analysts.
• Work Oracle production issues and see thru to resolution. Interface with Business Systems Analysts and business users on a regular basis to review and clarify the issues. Manage priorities to deliver to the SLA
• Responsible for managing help desk ticket reports and monitoring progress and resolution with Oracle Support to log and resolve SRs
• User group meetings to address support and training issues/concerns.

Environment: Oracle Applications 11.5.10(OM,Oracle Purchasing,,INV,OPUS,CATS)

Confidential, Hartford, CT Jul 06 - Oct 2007
Onsite Oracle Project Coordinator

This project includes the Production support and enhancements in existing Application.

Responsibilities:

• Responsible for GAP Analysis and requirement gathering.
• Team Management and onsite offshore coordination
• Preparation of Design documents, Specifications and Technical mapping
• Development and customization of existing forms and reports, procedures and package.
• Worked for various enhancements and developed design documents and forms and other related database objects.
• Monitor of various jobs and batch processes and resolving the issues and providing beeper support.
• Involved in data migration. Created intermediate tables required to transfer data from flat files. SQL* Loader was used to populate into temporary tables.
• Worked on the resolution to the Performance issues and did tuning of various programs
• Worked on PVCS to Check-in and Checkout the code and Control the version details.
• Responsible for bug fixes, change requests and Enhancements by using form6i, Report6i and PL/SQL.
• Code reviews of objects developed by other team members and ensure the Quality standards.

Environment: Oracle Applications, Sun Solaris,Oracle 9.i,Forms 10 and Reports 6i & TOAD,SQR, SQL*Loader, Autosys,shell script,pl/sql,XML.

Confidential,USA Mar 2005 - Jun 2006
Oracle Apps Techno Funtional Consultant

Responsibilities:

• User Requirements analysis.
• Team Management and onsite offshore coordination
• Trained offshore team with client Environment and Tools
• Responsible for development of custom forms, reports, procedures and other components.
• Worked on some fixes and Custom Programs in Oracle Financials.
• Development of Inbound and outbound process from Oracle Applications to other systems and vice versa
• Job Scheduling.
• Account Receivables - Converted Invoices from Legacy System into Oracle Receivables using Auto Invoice.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface programs to support the interface requirements.
• Used Auto lockbox to load Cash receipts from Legacy System into Oracle Receivables.
• Defined at multiple levels default entry types and reasons used to categorize debit and credit billing activity to be sent to Receivables system from Billing.
• Managed customer tax-exempt certificate information, accessing customer notes, and defined our own payment terms in Billing.
• Created Customers, Parties, Party Sites, Party Accounts in TCA.
• Developed Complex Forms with Folder Options in AR.
• Developed BI Publisher reports for: (AR: Aged Trial Balance and Recurring Invoice Register reports)
• Account Payable - Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• General Ledger (GL) - Prepared Sales Journal reports to show all invoices and invoice details entered: (Trial Balance, General Ledger postings).
• Run Journal Import in General Ledger (GL) to load the data into Oracle application tables.
• Developed and customized Rice components.
• Created a process for order import using customize API for validating data and update the base tables.
• Customized and ran Shipped Delivery Lines Report, Backorder Detail Report, and Backorder Summary Report for Oracle Shipping (WSH).
• Developed a Data Template XML file and defined a RTF template using the generated Data XML according to the Business requirements. Involved in creating parameters in data template file according to the requirement.
• Worked on the resolution to the Performance issues.
• Registration of Concurrent programs Reports, Forms. Creation of Request sets, Value sets etc.
• Interacted with the Users and Business Process Managers to gather requirements to resolve the issues and fix the problems.

Environment: Oracle Applications E-Business 11i (AP, GL), Sun Solaris, Oracle 8i, SQL, PL/SQL, Workflow, Appworx, TOAD,SQR.

Confidential, Palo Alto, CA Dec 2003 –Mar 2005
Oracle Apps Techno Funtional Consultant

Responsibilities:

• Development of Technical Specifications (MD70) from functional Specifications.
• Analysis, Development and Testing of Custom forms like SPGCM WIP COMPLETION & Intransit Shipment User interface Form(Forms for manual transactions and to fix errors for different contarct manufacturers), SPGCM Control form (CM Control Parameter Setup form), SPGCM Dropship form (Dropship Information Transaction Form
• Design, Development, Testing and Deployment of Aging Intransit Report, Component Shortage Report (To show shortage of components potential for the shipment & WIP. It explodes BOM for Assembly items and populates data in Temp table and uses DBLink for accessing Planning instance.
• Design, Development, Testing of CM WIP Completion / Intransit Workflow Notification, CM Receipt Notification.
• Developed custom Reports in INV, BOM and WIP modules using Reports 6i.
• Involved in creations of Database Triggers & Sequences used for inserting sequence-generated value in table column
• Registration of Concurrent programs, Reports, Forms. Creation of Request sets, Value sets using customized views.
• Involved in Code reviews of objects developed by other team members and ensure the Quality standards

Environment:Oracle Applications E-Business 11i (11.5.8) (WIP, OM,BOM) Sun Solaris, FORM6i,Oracle 9i, Reports 6i, SQL*Loader, SQL, PL/SQL, Unix Shell, TOAD, Clear Case, Kintana.

Confidential, North Canton, OH May 2003 – Dec 2003
Oracle Apps Techno Funtional Consultant

Responsibilities:

• Customized Shipping Reports namely Pickslip, Packing List and Proforma Invoice in OM, and Open Purchase Orders,RFQ report in Oracle Purchase modules.
• Developed custom Reports in INV, BOM and WIP modules using Reports 6i.
• Customized Order Entry form to populate Intermediate ship-to locations using the CUSTOM.pll.
• Worked on the Item Conversion in the INV Module.
• Developed a Custom Report from the Scheduled data in the Custom tables in WIP Module.
• Developed a Custom form for the Line flow Schedule data in WIP Module.
• Worked on the Customer Conversion from legacy Systems using the Oracle HZ Schema APIs in the AR Module.
• Developed Custom Journal Import Program in GL Module.
• Developed Auto Invoice Interfaces in the AR.
• Used HZ Schema in TCA.
• Worked on the Translations of Reports to different languages using Oracle Translation Manager (OTM).
• Preparation of Unit Test Cases and Installation (MD120) Documents.
• Used CVS, and TortoiseCVS for Configuration Management.

Environment:Oracle Applications E-Business 11i (11.5.6)(GL, AR, TCA, Oracle Purchasing,Oracle Receivable,AP, OM, INV), HP UNIX, Oracle 9i, Forms 6i, Reports 6i, TOAD, SQL Loader,SQL, PL/SQL, Oracle Translation Builder, Oracle Workflow Builder, CVS.

Confidential Jan 1998 – May 2003
Oracle Apps Techno Funtional Consultant

Confidential-Accenture-Escort \'Pragati\' Project

Responsibilities:

• As a Techno/Functional Team Member, was Responsible for GAP Analysis and requirement gathering.
• Did one to one data mapping from legacy system to Oracle Application.
• Involved in data conversion between legacy systems (Avalon) and Oracle Apps.Created intermediate tables required to transfer data from flat files. SQL* Loader was used to populate into temporary tables.
• Created PL/SQL Procedure validated and loaded the data into the Open Interface. Wrote Interface program that transfers transaction data from the original system into interface tables, wrote the script files to create intermediate tables, and control files.
• Created and implemented UI for Journal Import from different systems.
• Built interfaces between Custom Application and HRMS,PAYROLL,GL,AP,AR,OM, INV modules of Oracle to process transactions.
• Customized Oracle Purchasing reports like PO release commitment, Supplier schedule printing report,AR report like Aging report,AP reports like (Subledger,Liablity report etc).
• Developed and registered Alerts for different inbound and outbound procedure.
• Involved in Performance tuning of various queries and stored procedures.
• Developed SQL*Plus Reports.
• Prepared Unit Test Cases.
• Used AIM Methodologies to prepare the business requirement documents.
• Migration and Testing of the Deliverables in different instances.
• Worked on PVCS to Check-in and Checkout the code and Control the version details.
• Code reviews of objects developed by other team members and ensure the Quality standards.

Environment:Oracle Applications E-Business 11i (11.5.5) (HRMS,PAYROLL,GL,AR,FA,Oracle Purchasing,Oracle Receivable,AP,INV,WIP), HP UNIX, Oracle 9i,Form6i, Reports 6i, SQL, PL/SQL, TOAD, PVCS.