SUMMARY

• Overall 11 years of IT experience of which 9+ years of experience in designing, developing, testing, implementing, configuring, and customizing Oracle E - business applications, integrating with other operations in various operating environments.
• Expertise in RICE (Reports, Interfaces, Conversions and Extensions)
• Extensive experience in using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms, Reports, Discoverer, XML Publisher, SQL*Loader and Workflows.
• Have good working exposure on modules like Financial Accounting Hub (FAH), General Ledger (GL), Account Payables (AP), Account Receivables (AR), Order Management/Order Entry (OM), Oracle Alerts, Fixed Assets (FA), Oracle Purchasing (PO) and Application Object Library (AOL).
• Worked extensively on Data Conversions in Various Modules.
• Extensively worked on AIM documents like MD050, MD070, MD120 and CV40.
• Experience in ITG Kintana Migration Tool.
• Technically proficient in TCA, Order-to-Cash and Procure-to-Pay.
• Extensive experience in identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored SR/TAR’s for several P1 issues.
• Expertise in Customizing Oracle reports and developing custom reports by using Report 2.5/6i/9i, Discoverer 4i and XML/ BI Publisher.
• Experienced in Customizing Oracle Forms with Forms personalization, Custom.pll on Forms 6i/4.5.
• Proficient in customizing Workflow in Oracle Apps.
• Well versed with Performance tuning concepts such as Optimizer Hints, Explain Plan, SQL Trace and TK Prof.
• Adept in PL/SQL Procedures, Functions, Packages and UNIX shell scripts.
• Excellent communication skills with ability and willingness to work towards the business and technical requirements of clients and users.
• Excellent team player with strong analytical, presentation and problem solving skills.
• My project handling skills include Team Leading Skills, Communication Skills, Positive and Proactive Attitude, Adaptable to Change, Teamwork Skills, and Strategic Thinking & Analytics.

TECHNICAL SKILLS

Package Applications (ERP): Oracle EBS R12, Release11i

Oracle ERP Financials: Financial accounting Hub (FAH), General Ledger (GL), Account Receivables (AR), Payables (AP), Fixed Assets (FA) and Trading Community Architecture (TCA)

Oracle ERP Manufacturing: Order Entry/ Order Management (OM), Oracle Purchasing (PO)

Others: HRMS, System Administration, AOL, Oracle Alerts, Oracle Workflows

Software Languages: SQL*Plus, PL/SQL

RDBMS (Database): Oracle 8i/9i/10g/11g.

Development Tools: Oracle XML/BI Publisher, Oracle Discoverer 4.0, Workflow Builder, D2K (Forms/ Reports6i/ 9i/ 10g). ADI’s, Data loader.

Database Tools: SQL*Plus, SQL*Loader, TOAD, SQL*Navigator

Operating Systems: Sun Solaris 2.8, Unix, Windows XP/NT, Linux

Configuration Management tools: SVN (sub Version) & CVS

Migration Tools: Kintana Workbench.

Document Methodologies: AIM Methodology

Other Minor Skills: OBIEE, BPEL, SOA, Advanced Pricing.

PROFESSIONAL EXPERIENCE

Confidential, Keene, NH

Sr. Techno-Functional Consultant

Environment: Oracle Applications Release12.2.3 (GL, AP, AR, FA, AOL), Oracle BI Publisher, PLSQL.

Responsibilities:

• Responsible for developing and customizing inbound and Outbound interfaces involving vendors interface, GL Interfaces.
• Responsible for developing BI Publisher reports using Excel Templates.
• Responsible for designing Reconciliation reports between the source and the destination systems.
• Responsible for developing MD70’s and Md 120’s for the objects owned.
• Handled Daily status calls with the client to effectively track the day to day issues and their resolution.

Confidential, SantaClara, CA

Sr. Techno-Functional Consultant

Environment: Oracle Applications Release12.1.3 (GL, AP, AR, OM, FA, AOL), Oracle BI Publisher, PLSQL.

Responsibilities:

• Responsible for handling production support and the issue resolutions.
• Responsible in creating the functional & technical design documents and for implementation of the customizations.
• Responsible for Developing Bar code Reports using BI Publisher.
• Responsible for customization and developing new reports around Financial Modules using BI Publisher.
• Handled Daily status calls with the client to effectively track the day to day issues and their resolution.

Confidential, Newark, CA

Conversions Lead

Environment: Oracle Applications Release 11i, Release12.2.3 (GL, AP, AR, FAH, Core HRMS, AOL), Oracle Forms/Reports 10g, Oracle BI Publisher, PLSQL.

Responsibilities:

• Led a team of 14 members with onsite-offshore delivery model and responsible for the overall technical delivery including Financial, SCM and Core HRMS modules.
• Handled Daily status calls with the client and the offshore team members effectively tracking the day to day issues and their resolution.
• Created Forms Personalization on the Sales Order Form
• Responsible for preparing the cutover plans, conversion execution sequences, dry run instance planning and their execution.
• Responsible for designing Reconciliation reports between the source and the destination systems.
• Responsible for designing and developing conversions like Employees, Employee assignments, GL Interface, Users and responsibility assignments.

Confidential, Dallas, TX

Techo-Functional Consultant

Environment: Oracle Applications Release 11i, Release12.1.2 (GL, AP, AR, OM, FAH, iReceivables), Oracle Workflows, Oracle BI Publisher, Oracle Forms/ Reports 9i, PLSQL.

Responsibilities:

• Led a team of 8 members and responsible for the overall technical delivery including Financial, SCM and Core HRMS modules.
• Handled Daily status calls with the client and the offshore team members and responsible for the maintenance of Issue tracker System.
• Customized several standard and custom reports in AP, PO, OM and GL using AIM Methodology which included Customer Facing Documents (CFD) like Invoice, Pick-Slip, Pack-Slip Reports.
• Responsible for handling End user trainings on the technical components and the new tools.
• Responsible for developing custom PL/SQL wrappers for fixing the data issues.
• Responsible for Migration of custom reports from Release 11i to Release 12.
• Designed and implemented vendor mapping to custom applications using interfaces, Created Custom forms to help the users to correct /allow to do manual transactions on the top of Vendors interfaces.
• Modifying PL/SQL Packages, Procedures, and Functions for data population and updating data as per the user requirements.
• Responsible for providing the mapping information required for the EDI integration of GENTRAN systems.
• Developed and customized complex XML Publisher reports by communicating and interpreting end-user business requirements.
• Customized and developed various reports in AR, AP, GL, PO and OM modules using Reports 9i and Oracle BI Publisher.
• Responsible for customizing the existing custom workflow processes as per the business requirement.
• Responsible for designing and development of Journal Imports making use of financial accounting Hub.
• Responsible for designing and delivering Vendors Conversions.
• Responsible for designing and delivering Vendor Sites Conversion.
• Responsible for designing and delivering Vendor Contacts.
• Responsible for handling Conversions and Interfaces like Assigning Signing Limits to the Vendor and Synchronizing Employees.
• Responsible for developing Inbound and Outbound Custom Interfaces where the communication between the ERP systems are handled by SOA services.

Confidential, Lincolnshire, IL

Sr. Technical Consultant

Environment: Oracle Applications Release12.1.2 (GL, AP, AR, OM, PO), Oracle XML Publisher, Oracle Discoverer, Oracle Forms/ Reports 10g, Oracle workflows

Responsibilities:

• Involved in preparing Functional design (MD50), Technical design (MD70) documents and Conversion Mapping Document (CV40) during designing phase.
• Interacted with end users to gather requirements and draft specifications during development Phase.
• Coding, Testing of the technical components to meet the functional requirements
• Responsible for developing XML Publisher reports based on the modules like Purchasing, General Ledger and Payables.
• Responsible for developing Oracle Discoverer reports based on the modules like Purchasing, General Ledger.
• Involved in requirements gathering and testing (Unit, Mock, Pre Production).
• Interacted with business users to resolve any issues during the development, mock testing, and Pre Production testing and production phase.
• Responsible for monitoring the SR’s.
• Responsible for providing resolutions for the issues encountered during the migration and post go-live.
• Responsible for direct interaction with the clients and prepared all the documents as per the Client Standards.
• Responsible for developing custom PL/SQL wrappers which included AP Invoices conversion.
• Responsible for importing AR transactions using Auto INvoice.
• Responsible for importing Journals for the data extracted from the legacy systems to Oracle.
• Responsible for developing the custom workflows in which the workflow process included sending approval notifications based on the custom defined hierarchy and invoking the custom database objects for creation of the Journals.
• Responsible for customizing the AP Invoice Approval workflow to send all the approval notifications to the helpdesk irrespective of the approval hierarchy.

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.10(GL, AP, PO, AOL) Oracle XML Publisher Reports, Oracle Forms/ Reports 6i, Oracle Discoverer.

Responsibilities:

• Responsible for providing post production Support and Issue Resolution.
• Responsible for developing XML Publisher reports as per the Clients Requirement.
• Responsible for direct interaction with the clients and prepared all the documents as per the Client Standards.
• Responsible for developing Discoverer reports as per the Clients Requirement.
• Responsible for Customization of packages to handle the data coming from the PeopleSoft and to send the notifications to the appropriate end users.
• Responsible for direct interaction with the clients.
• Responsible for designing and delivering Open PO conversion.
• Responsible for developing Journals import interface program.
• Responsible for designing and delivering AOL User Creation conversion.
• Responsible for designing and delivering Assigning Responsibilities Conversion.
• Responsible for designing and delivering Assigning Secured form attributes to the user Conversion.
• Customized the Standard form to create descriptive flex fields so as to enable the end users to populate extra information for the Purchase Orders Form.

Confidential, Californi

Technical Consultant

Environment: Oracle Applications 11i (AP, AR, GL, FA, Alerts), Oracle forms/ reports 6i, Oracle Discoverer.

Responsibilities:

• Designing and development of FA Custom reports.
• Responsible for developing Discoverer reports as per the Clients Requirement.
• Responsible for developing the Custom Packages to accept the incoming XML data from the Legacy System into the Oracle using BPEL Services as the communicating Interface as per the client’s requirement.
• Responsible for Creation of TAR files, Custom Views and Lookups.
• Responsible for Providing Onsite Support for the Project.
• Creation of concurrent programs for Reports and Stored Procedures.
• Creation of value sets for reports.
• Responsible for preparing all the Technical documents like MD70, MD120 as per the client defined standards and using AIM Methodology.
• Responsible for direct interaction with the clients.
• Responsible for designing and delivering AP Invoices Conversion.
• Responsible for loading the Budget Journals entries using Journal Import.
• Responsible for developing interfaces that was used to create new CCID in oracle for the data that is being interfaced from the legacy system.

Confidential

Technical Consultant

Environment: Oracle Applications 11i (GL, AR, AP, PO, OM), Oracle 11.0.3, Oracle Forms/ Reports 6i.

Responsibilities:

• Worked as an offshore development team member.
• Involved in Migrating the Objects using Mercury ITG Dashboard Migrating tool.
• Responsibilities include preparation of technical specifications from the functional specifications received from the functional team or user, technical design, development of program and unit testing and Interaction with the Client to resolve the Issues.
• Involved in Documentation of Archiving and Purging for different modules.
• Developed Oracle Alerts for the newly added Customers.
• Creation of concurrent programs for Reports and Stored Procedures.
• Creation of value sets for reports.
• Involved in Customizing and testing of Packages.
• Involved in Concurrent Program Registration and Manual creation of Lookups.
• Also responsible for system integrity testing and user acceptance testing before final migration of the programs to the PROD instance
• Prepared all the documents as per the Client defined methods for all assigned project tasks and met the timeliness of the project in all phases.
• Customized LOGI Uninvoiced Receipts Report as per the Clients Requirement.
• Customized LOGI JPDC Customer Statement to show the output in the Excel Format.
• Customized Reports to display all the static text items hard coded in the Reports in their respective languages based on the region they are running the Report.