SUMMARY:

• Chetan has over 9 years of experience in the implementation of ERP systems and customizations.
• Core areas of skill are: Gathering requirements, analyzing, defining the problem areas, working out the logical solution, proposing the solution based on the technology available. Suitable planning and supervising of the design, development, testing, implementation and maintenance of the Enterprise Solutions.
• Has extensive technical experience in OAF, XML Publisher, SQL, PL/SQL, Oracle Reports, Oracle Forms, Conversions, SQL Loader, Workflow, UNIX shell scripting HRMS - self-service, AR, AP, OM, PO, iProcurement, O2C, P2P.
• Has in-depth understanding of the business process of Oracle Financial/Purchasing/hrms core modules.
• Experiences in configuration management and code migration tools (WinCvs & Kintana).
• Documentation experience, keeping in line with the AIM Methodology.
• Performed Team Lead roles and Onsite offshore co-ordination.
• Proficient in CMMi quality processes.

TECHNICAL SKILLS:

Environment: Oracle Applications Release 12 Business Suite, Ver 12.0.X Oracle Applications 11iBusiness Suite, Ver11.5.10.2, Oracle 11g,10g,9i, UNIX (IBM AIX, HP& Solaris), Linux, Win NT/7/XP/2000/95

Tools: & Utilities:OAF, Oracle JDeveloper 10g,Oracle Forms 10g/6i, Oracle Reports 10g/6i, OracleBI Publisher, Oracle Workflow Builder, Forms Personalization, CUSTOM.pllSQL/PLSQL, SQL* Loader,Toad, Oracle SQL Developer, WinCvs and Kintana

Application Modules: Oracle HRMS, Oracle Purchasing,Accounts Payables, Accounts ReceivablesOrder to Cash, Procure to Pay, Order Management, Oracle General Ledger.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Consultant

Responsibilities:

• Requirement Gathering from client, conducting client meetings.
• Development in Forms, PL/SQL (concurrent programs).
• Development of OAF custom pages/personalization.
• Development of XML publisher / Oracle RDF Reports
• Responsible for all extensions, workflow deliverables.
• Review of functional documents for technical feasibility.
• Preparing technical designs and development of code, issue resolution.
• Onsite offshore co-ordination.
• Preparing and maintaining checklist for code review using development standards
• Preparing MD70, TE020, Unit Test Scripts, Integration Test script documents for customized objects.
• Managing Version Control for the objects using WinCvs and migration using Kintana.

Environment: Oracle Apps R12 - HRMS, AR,PO,AP modules, Jdeveloper, OAF, Custom.pll, XML Publisher, SQL, PL/SQL, Toad, SQL Developer, Oracle 10g database, WinCvs, Kintana, Windows XP, UNIX, MS-Office (Word, Excel, Outlook).

Confidential, HARRISBURG, PA

Senior Designer and Developer

Responsibilities:

• Developed Vendor Collaboration Portal, Order Portal, Store Portal which integrates business between the supplier, stores and the client between Oracle eBs and RMS.
• Developed a Vendor Portal and Order Portal in OAF for the client. This included creating of custom pages, VO, AM, Controllers, validations in OAF. This was a complex object, which was the key for integration of client legacy system and Oracle Applications R12 suite. The OAF Portal allows the client to create, update cancel orders though oaf and the subsequent orders/updates get reflected in eBs. The Portal also allows printing the Order directly to a store printer.
• Development of AR invoices conversion, PO conversion, oracle Reports.
• Co-ordination with offshore team and functional team on OAF objects design and development
• Providing Estimates for CEMLI objects and change Requests.
• Client Communication, status meetings, MoM, for Issue updates and discussions in PO,OM module
• Understanding MD050, Preparing technical documents (MD070), Coding,Unit Test Scripts (TE020).
• Preparing installation documents (MD120), for migration to other instances

Environment: Oracle Apps R12 - HRMS, AR,PO modules, RMS, Jdeveloper, OAF, Oracle Reports, Custom.pll, XML Publisher, SQL, PL/SQL, Toad, SQL Developer, Oracle 10g database, WinCvs 2.1, Windows XP, UNIX, MS-Office (Word, Excel, Outlook), Adobe Acrobat 7.0

Confidential

Senior Designer and Architect

Responsibilities:

• Developed a utility package to generate PDF report or RTF report from any OAF page and display it on OAF page, without using concurrent program, which was used in this project and can be used in any project requirement by just calling the custom utility package.
• With the standard Invoice Report developed of AR Invoice Report as per the client requirement. This report involves development of concurrent program and also printing the Invoice Report on an OAF page from standard ‘Transactions’ screen menu. This report was developed in multiple languages. The report has the data from Project Accounting, Service Contracts, Field Services, Order management Invoices.
• Developed HR Interface (outbound).
• Extension of standard VO objects
• Defaulting of customer dff values onto Quotes dff while creating quotes. This included customization in standard OAF Quote creation screen page. Customization also involved creating a custom page to display item details.
• Developed SCM Sales Commission Report and Quotes Report. These reports were developed in multiple languages.
• OAF Development-Developed oaf pages, search page, view objects, AM, Controllers, OAF personalization. Preparing migration documents (MD120) for deploying OAF customizations onto different instances.
• Developed global error package for error handling.
• Developed Proforma Invoice.
• Developed XML publisher reports.
• Developed Forecast to Supplier Interface
• Developed SCM Packing Slip Report in xmlp in multiple languages.
• Developed a common package which was used in lots of other SCM reports for fetching sold-to, bill-to, ship-to customer names and addresses, customer VAT, attachments
• Senior Technical Designer and Developer
• Providing Estimates for CEMLI objects and change Requests
• Prepared technical documents (MD070) and handing it over to the developer. Preparing installation documents (MD120)
• Client Communication, status meetings, MoM.
• Configuration Manager.

Environment: Oracle Apps R12 - iProcurement, OM, GL modules, Jdeveloper, OAF, SQL Loader, Oracle Reports, Custom.pll, XML Publisher, SQL, PL/SQL, Toad, SQL Developer, Oracle Forms, Oracle 10g database, WinCvs 2.1, Windows XP, UNIX, MS-Office (Word, Excel, Outlook), Adobe Acrobat 7.0

Confidential, San Francisco, CA

Senior Designer and Developer

Responsibilities:

• Worked and resolved Several Service Request in forms, interfaces.
• Customized business logic in iProcurement.
• Customization of standard form using custom.pll
• Personalization of standard Final Appraisal OAF Page, to create a custom signature region, VO, Controller which had signatures and dates of associate, first level supervisor, second level supervisor in the appraisal hierarchy.
• Creating controller, creating custom page, to display data on standard notification onto custom page.
• Customized standard workflow HRSSA, to customize notification.
• HRSSA workflow - created AME rules, worked on appraisal hierarchy
• Developed Sales order printout Report including details for ato, pto items
• Calculated Arrival date depending on promise date in standard sales order form. This was done using form personalization.
• Conducting status report meetings with Client
• Provided Estimates for development objects and change requests in HR module
• Customized and personalized OAF pages, workflow
• Preparing MD070 and MD120 and TE020

Environment: Oracle Apps R12 - HRMS, OM,AR,AP, iProcurement modules, Jdeveloper, OAF, WinCvs 2.1, Windows XP, UNIX, MS-Office (Word, Excel, Outlook), Adobe Acrobat 7.0, Custom.pll, XML Publisher, SQL, PL/SQL, Toad, SQL Developer, Oracle 10g database, Oracle Reports, XML Publisher

Confidential

Senior Designer and Developer, Team Lead

Responsibilities:

• Development of Inbound DOC Interface:
• Developed Interface to allow integration between VBA STI applications, Oracle Purchasing and inserting data into GL
• Also worked and resolved several Service Requests (SR), Change Requests related to Interface Developed Outbound TRAX Interface
• Developed Interface in PO module and worked on a Change Request for the interface
• Developed a Form as a part of the Interface to Enter and validate Tail Code Data values.
• Worked and resolved Several Service Request (SR) related to TRAX Interface.
• Developed Trigger on Organization ID of Assignments screen in HRMS responsibility to change the cost code information under purchasing tab.
• Customized of HRMS Leave Absence Form.
• Sales Order Cycle
• Senior Designer & Developer, Team Lead
• Conducting Status report meetings with Client.
• Provided Estimates for CEMLI objects and Change Requests
• Developed and customized Interface and Forms.
• Preparing MD070, MD120, TE020

Environment: SQL Loader Oracle Reports, Custom.pll, XML Publisher, SQL, PL/SQL, Toad, SQL Developer, Oracle Apps-PO, HRMS, OM modules, Oracle Forms, Oracle 8i/9i database, WinCvs, Windows UNIX, MS-Office (Word, Excel, Outlook)

Confidential

Senior Architect, Developer

Responsibilities:

• Developed Custom Interface code, Oracle Report for outputting processed and error records, developed UNIX script to send email of the report output to client.
• Customized WIP Reconciliation Report in PA module.
• Worked on GL Interface. Submitting Journals Manually, Import Journals
• Conducting Status report meetings with Client.
• Customization of Oracle Reports, Interfaces
• Patch Impact Analysis.

Environment: SQL Loader, Oracle Reports, GL modules, Custom.pll, XML Publisher, SQL, PL/SQL Toad, SQL Developer, Oracle Forms, Oracle 9i database, WinCvs, Windows XP, UNIX, MS-Office (Word, Excel, Outlook), Interface, conversion.

Confidential, Concord, MA

Sr. Software Engineer

Responsibilities:

• Development of Supplier Conversion
• Validated, prepared procedures, installations scripts and concurrent program.

Environment: Oracle Apps - AR, OM modules, SQL Loader, Oracle Reports, SQL, PL/SQL, Toad, SQL Developer, Oracle 9i database, WinCvs, Windows, UNIX, MS-Office (Word, Excel, Outlook)

Confidential, CA

Software Developer

Responsibilities:

• Validated, prepared procedures, installation scripts and concurrent program.
• As a technical consultant involved in preparing stand-alone procedures for various validations and data mapping
• Customized Warranty Inheritance program and creation of materialized views & indexes for performance optimization.
• Interacting with client functional team
• Developed sample form including, LOV, Calendar, Flexfield

Environment: Oracle Forms, Oracle 8i database, WinCvs, Windows, UNIX, MS-Office (Word, Excel, Outlook), Adobe Acrobat, putty,WinScp. Oracle Apps - AR, PO, OM modules, SQL Loader, Oracle Reports, Custom.pll, SQL PL/SQL, Toad

Confidential, WI

Software Developer

Responsibilities:

• Performed requirement analysis and implementation of requirement analysis and development of Wage Progression Step Increase Report.
• Involved in developing Reports, PL/SQL Packages, and Custom Extension
• Programs in AR and HRMS modules
• Preparing and maintaining checklist for code review using development standards document as well as customization of standards document.
• Preparing MD070, MD120 documents for customization objects.
• Managing Version Control for the objects created
• Interacting with Onsite functional team and client

Environment: Oracle Apps - AR, HRMS, iProcurement modules, SQL Loader, Oracle Reports, Custom.pll, SQL PL/SQL, Toad, SQL Developer, Oracle Forms, Oracle 8i database, WinCvs, Windows, UNIX, MS-Office (Word, Excel, Outlook), Adobe Acrobat, putty,WinScp.