SUMMARY:

Functional / technical experience in Confidential ERP R11i/R12 implementation, production support and customization, including gap analysis, requirements gathering, process analysis, solution design, integration, testing, knowledge transfer, and documentation using AIM/ADM Methodologies. Successfully performed data migration from legacy systems to Confidential applications, designed and delivered custom concurrent programs and workflows and involved in preparing user manuals for the end users. Versatile team player with excellent communication and interpersonal skills who works well with remote users and is an effective mediator between Programmers, End users and Clients. Inquisitive problem solver who enjoys challenge.

AREAS OF EXPERTISE:

• Over 10 years of experience in Confidential E - Business Suite as an ERP consultant.
• Strong Functional and Technical Knowledge in Order Management, Service Contracts, Install Base, Inventory, Purchasing, CRM Foundation, Core HRMS and Confidential Receivables
• Implementation/Testing/Support experience in core modules like Order Management, Service Contracts, Install Base, Confidential Inventory, Purchasing, CRM Foundation, Confidential Receivables, Accounts Payable, Core HRMS, Project Foundation, Service Request, Confidential cMRO and Pricing.
• Through knowledge of Order To Cash, Order to Service Contracts and Install base, P2P, Confidential Project Foundation, Physical Inventory Process, Core HRMS.
• Fair Understanding of System Administrator, Confidential Alert and Confidential Workflow.
• Responsible for documentations, setups, bugs, enhancement requests, collecting debug/trace files working with Confidential support using TAR and escalation to Confidential duty manager.
• Involved in Project Management Activities like meeting stake holder requirements, Prioritizing system problems, enhancement requests, scope management and status reporting to management.
• Experience in Production support and related Business process improvements.
• Experience in building custom interfaces between Confidential Applications and external systems.
• Proficient in designing and collecting requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration and AOL.
• Applications Version worked on 11.5.9, 11.5.10 and R12.

TECHNICAL SKILLS:

Software: Confidential 9i/10g/11g

Languages/Tools: PL/SQL, Confidential XML Publisher, SQL Loader, Confidential Developer - Forms 6i, Reports 6i, Workflow, Confidential Application Express, C, C++, Core Java, HTML, TOAD, Confidential Discoverer User, Discoverer Administrator and Discoverer Plus.

Project Management: MS Excel, MS Word, MS Visio, MS PowerPoint.

Other Applications/OS: WINDOWS 95/98/2000/XP, UNIX, LINUX, SOLARIS.

PROFESSIONAL EXPERIENCE:

Confidential, Milford, Connecticut

Onsite Project Lead

• Production Support, MD70, Test Plans, CEMLI (Customization, Extension, Modification, Localization, and Integration) of above modules.
• Involved in Integration between different legacy systems like SAP, Siebel, Sales Force, Confidential Lease Management, ATLAS, OLS and Zuora Billing System.
• Monitoring of Integration between systems like Confidential Interface to SAP for Shipping, SAP to Confidential for receiving Drop ship POs, Lease Order Integration to Confidential Lease Management, Service Request Integration to Siebel from Confidential Order Management, Return Orders Integration from SAP to Confidential, AR Transactions Interface Monitoring, Receiving Interface Monitoring and Install Base Error Monitoring.
• Involved in complete cycle of Physical Inventory Process by creating Documentation of the Physical Inventory process and testing a full cycle of Physical Inventory Process in Test System.
• Involved in clearing all the Open transactions related to Inventory Organization for the Process of Inactivating the Inventory Organization.
• Production Support for Month End Process Including Period Closure activities for Inventory, Purchasing, Receivables, Payables and General Ledger.
• Closely involved in the business discussion on requirements, Functional designs and Technical Designs for the new developments and Change requests.
• Handled offshore team of 15 members.
• Customization of Confidential reports, development of new PL/SQL reports.
• Trouble shooting and bug fixing of Custom Workflow, Custom reports, Custom Forms and Custom APIs.
• Involved in the bug fixes and enhancement in the customization of Confidential standard process for Order to Service contract creation.
• Involved in the UI design for Customer Screen and created the technical design and the PL/SQL components related to the development.
• Very Good understanding of all the Integrations related to Confidential ERP to the Legacy systems.
• Data Analysis, Multiple Data migration from legacy to Confidential Apps using interfaces Development and debugging of PLSQL API/interfaces for OKS, AR, OM, IB and Inventory modules.
• Setups for DFFs (Descriptive Flex Fields), Implemented Custom Profiles, Custom Lookups and Custom Concurrent programs.

Confidential

• Business requirement analysis, identifying functional and technical gaps, estimating work, Conduct CRP, System integration Testing, Functional Testing, AIM Documentation BR100, MD50, MD70, Test Plans and Training Manuals.
• Data Analysis, Multiple Data conversion from Confidential 11i to Confidential R12 using interfaces Development and Conversions for HRMS and CRM Modules.
• Architecting system interfaces, designing custom solutions, programming and leading the development team of 10 - 12 members.
• Involved in the technical review of the components developed by the team members.
• Designed and developed the Complex HRMS Employee Conversion Which Involved the creation of Applicants, Employees, Applicant to Employee conversion, Contacts, Addresses, Phones, Employee Primary and Secondary Assignments, Termination and Re-hiring of Employees, Contracts, Costs and Relationships using Confidential APIs which will be ran to convert the Legacy data to Confidential Applications.
• Involved in the design and development of customizing the Standard PO matching process using Confidential Forms.
• Setups for DFFs (Descriptive Flex Fields), Custom Form, Custom Concurrent programs and Concurrent Request Sets. Conducted performance tuning, worked with Confidential Support/Duty Managers using TAR to resolve/escalate customer issues.

Confidential

• Business requirement analysis, gap fitment, Conduct CRP, Involved in UAT and Technical Documentation MD070.
• Data Analysis, Multiple Data migration from legacy to Confidential Apps using interfaces Development and Conversion.
• Designed and developed the Customer Conversion for creating Customers, Customer Profiles, Customer accounts, Locations, Party Sites, Customer Account Sites and Customer contacts using Standard APIs which will convert the legacy data into Confidential Applications.
• Designed and developed the Receivables Transactions Conversion using Confidential Interface table approach which will convert the legacy data into Confidential Applications.
• Developed the Applied and Unapplied receipts conversion using Confidential APIs for Creating Applied/ Unapplied Receipts using Confidential APIs which will be ran to convert the legacy data into Confidential data.
• Involved in the design and development of Purchase Order Conversion using Confidential Interface table approach which will convert the legacy data into Confidential Applications.
• Designed and developed the Extensions on Confidential Projects Module which involved PA Labor Extension which processes the time entry data from different legacy systems and moves into another staging table with reconciled data.
• Designed and developed the Extension on Confidential Projects Module which involved PA Labor Calculation uses the Processed & reconciled data from the staging table and calculates the rates based and populates into a staging table. Project transactions are created for these records in Confidential using interface table approach.
• Played the role of technical lead by tracking, analyzing and assigning the defects to the technical team.
• Involved in the technical review of the components developed by the team members.
• Conducted performance tuning, worked with Confidential Support/Duty managers using TAR to resolve/escalate customer issues.

Confidential

• Involved in Gap Analysis, Functional Design and Technical Design Documents (MD050, MD070) using AIM (Applications Implementation Methodology).
• Designed and developed Employee - Assignment Conversion using Confidential API which will convert the legacy data into Confidential Applications.
• Designed and developed a very complex conversion for creating the Projects, Employee Roles, Organization Roles, Project Classifications, Tasks, UDAs, Deliverables, Baselining of project workplans and linking of projects which will be ran to convert the legacy data into Confidential Applications. This involved in creation of 25 concurrent programs for running this conversion.
• Involved in the technical review of the components developed by the team members.
• Involved in the design and development of XMLP Reports in Confidential Project Accounting module.

Environment: Confidential Application R12 ( Confidential Project Foundation, Confidential Project Accounting, Core HRMS, SQL, PL/SQL, Reports6i, XML Publisher, TOAD, Putty, FTP.

Confidential

Apps Developer

• Analyzing and fixing the bugs related to Service Contracts, Order management and Install base process and the custom components. Working with Confidential support to solve issues.
• Involved the CR development and worked on the defects raised by the business users.
• Production Support: Supporting the system for the month end activities.
• Testing: Involved in the full functional setups and testing for TPCO.
• Methodology: AIM (Applications Implementation Methodology)

Environment: Confidential Application R12 (Service Contracts, IB, Confidential Order Management), SQL, PL/SQL, SQL Loader, Forms6i, Reports6i, TOAD, Putty, FTP.

Confidential

Apps Developer

• Worked on Technical Design Documents (MD070) using AIM methodology for Conversions, XML Publisher and Discoverer Reports.
• Developed RICE Components.
• Designed and developed the XMLP reports for Payables check printing for different bank formats, Bar Label reports (4 * 6, 1 * 1.5, 2* 4 size label reports) in different paper sizes.
• Designed and developed a very complex XMLP report (Discrete Job Routing - Operations) is used to instruct operator on the flow of work order and the material and resource requirements along with specific instructions for each operation.
• Designed and developed a XMLP report (Order Acknowledgement) which allows generating Sales Order Acknowledgments for various order types. The report can be generated for a single order number or for a range of order numbers.
• Created and managed business areas & developed workbooks for Discoverer reports.
• Development includes the discoverer reports like VSOE Compliance (This report is to determine if a contract value is VSOE (Vendor Specific Objective Evidence) compliant for each maintenance plan.), Rate For Maintenance Bookings Report (used for revenue analysis on a daily, monthly, quarterly, year to date, and yearly)
• Designed and developed the Service contracts conversion.

Environment: Confidential R12 (Service Contracts, Accounts Payable and Work in Process), SQL, PL/SQL, SQL Loader, XML Publisher, Reports6i, TOAD, Discoverer User and Discoverer Administrator.

Confidential

Apps Developer

• Involved in the User requirement, design, development and unit testing for XMLP reports on AP module which includes AP check printing on pre-printed stationary as per Indiana Public Employee Retirement Fund Standards and Indiana Teachers Retirement Fund.
• Reports: Prepared the technical specifications and developed new reports to suit the business needs based on user requirements using Confidential Reports 6i and XML Publisher. Performed the testing for that report.
• Methodology: AIM (Applications Implementation Methodology).

Environment: Confidential R12 (Accounts Payable), SQL, PL/SQL, XML Publisher, Reports 6i.

Confidential, Santa Clara, CA

Confidential Apps Developer

• Production Support, MD70, Test Plans, CEMLI (Customization, Extension, Modification, Localization, and Integration) of above modules.
• Created and Managed Various Discoverer reports for Project Accounting some of them include fiscal forecast report, Sun badge expenses reports, Reports to track revenue and cost budget for Fixed manual projects.
• Created and Managed Various Discoverer reports for Confidential Order management and Quoting Module some of them include report that captures all client solutions /Professional services sales order lines, Quote header and Quote line level reports, Quoting product category reports, Order header and line level detail reports.
• Created and Managed Business areas in Discoverer Administrator and developed reports in Confidential Discoverer Plus.
• Worked on the XLF templates for XML Publisher reports for different language formats.
• Designed and developed Extensions, PL/SQL reports and XML Publisher reports on Financial and Order Management modules.
• Designed and developed extension for defaulting Freight Terns and FOB onto to the Quote from the Pricing Agreement entered on the Quoting and Sales Order screen which involved the customizing of the seeded library CUSTOM.pll. This also involved a PL/SQL API for Header and Line entity to derive these values based on selected pricing agreement in sales orders.
• Designed and developed extension for Multibyte search functionality for customer using LOV changes at runtime. This was achieved by CUSTOM.pll coupled with a Custom form is used to extend the existing functionality for providing the local language search capability in E Business center and Universal Search screen in Tele Sales responsibility.
• Designed and developed an Interface for creating the Service Requests from Service Contracts which also involved Install base module.
• Involved in the Performance testing and worked on improving the performance of the Custom PL/SQL reports in Confidential Service Contracts and Install base modules.
• Involved in design and development for some of the PL/SQL and XML Publisher reports in Confidential Order Management and Quoting modules.
• Production Support for Confidential Discoverer Reports, XML Publisher reports and Extensions which involves bug fixes and Change Requests.
• Closely involved in the business discussion on requirements, Functional designs and Technical Designs for the new developments and Change requests.

Environment: Confidential 11i (Order Management, Quoting, Project Accounting, Service Contracts, and Install Base and Telesales module.)Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, FORMS 6i, Reports 6i, XML Publisher, Discoverer User, Discoverer Administrator, Discoverer Plus, SQL and PL/SQL.

Confidential

Apps Developer

• Design, development and testing of various Inbound and Outbound Interfaces in Inventory and cMRO modules some of them include Items masters outbound interface, cMRO Workorders outbound interface, Operation completion to cMRO Inbound interface from legacy systems using Confidential API and cMRO Composition list Outbound interface.
• Methodology: AIM (Applications Implementation Methodology).

Environment: Confidential 11i ( Confidential cMRO and Inventory module.)Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, SQL and PL/SQL.

Confidential

Apps Developer

• Design, development and testing of various HRMS conversions which includes Employee, Assignment, Address and Phones conversion using Confidential APIs which will be ran to convert the Legacy data to Confidential Applications.
• Methodology: AIM (Applications Implementation Methodology).

Environment: Confidential 11i ( Confidential HRMS.)Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, SQL, PL/SQL and UNIX Scripting.

Confidential

Apps Developer

• Design, development and testing of various HRMS conversions which includes Employees, Assignments, Contacts and Address Conversion using Confidential APIs which will be ran to convert the Legacy data to Confidential Applications.
• Methodology: AIM (Applications Implementation Methodology).

Environment: Confidential 11i ( Confidential HRMS.)Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, SQL, PL/SQL and UNIX Scripting.

Confidential

Apps Developer

• Design and Customizing of standard Confidential 6i reports in Purchasing and Order management modules.
• Methodology: AIM (Applications Implementation Methodology).

Environment: Confidential 11i ( Confidential Order Management and Confidential Purchasing.)Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, SQL, PL/SQL and Reports 6i.

Confidential

Apps Developer

• Design and customizing of standard Confidential 6i reports in Confidential Receivables modules.
• Involved in the Performance testing using CEMLI Performance tool and worked on improving the performance of the Custom PL/SQL programs.
• Methodology: AIM (Applications Implementation Methodology).

Environment: Confidential 11i ( Confidential Accounts Receivables and Accounts Payables.)Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, SQL, PL/SQL and Reports 6i.