SUMMARY:

• Techno - Functional Consultant having 7.4 years of Oracle Applications IT experience.
• Experienced of implementing 5 SDLC cycles including phases - Requirements Gathering, Development, Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Production (Go-Live) and post-production support.
• Good Interpersonal and Communication skills.
• Strong technical expertise in Oracle SQL, PL/SQL, Oracle Reports, Oracle Forms, BI Publisher, Oracle Workflow, Unix and Fusion Apps Reports.
• Oracle Demantra Techno-functional specialist in the DM and RT-SOP Solution Implementation process.
• Development expert in building complex custom RICE objects, Oracle Reports, Workflow and BI Publisher reports. One such example, Critical Customizations and transactional data migrations (Purchase Order, Global Purchase Agreements and PO attachments).
• Good Knowledge on Customer process tools like Version Control System, HPOV tool, Change Management Process and migration of objects using Kintana.
• Good Functional knowledge in Oracle Functional areas i.e., Purchasing, OM, Inventory, AR, AP, GL Modules. Besides, O2C and P2P cycles.
• Expertise in documentation of Technical Design, Unit Test Cases, User documents and Code Promotion process.

TECHNICAL SKILLS:

Oracle EBusiness Suite: 11i, Oracle Applications R12 and Fusion Apps

Oracle ERP Modules: Oracle Demantra (DM & RT-SOP), Purchasing, OM, Inventory, AR, AP, GL Modules and O2C, P2P cycles.

Oracle EBusiness Components/Development Tools: Oracle Demantra, Oracle Reports, Oracle Forms, Oracle XML Publisher, Oracle Workflow

Databases: Oracle 11g, 10g and 9i

Custom/General Tools: Toad, Putty, Ticketing tool - HPOV Tool, Configuration Management tools - PVCS, Change Management tool - Kintana and Textpad

OS Platforms: Sun Solaris, HP-UX, Windows NT/XP

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Technical Lead for the team of 5 members from Offshore and Onsite as well.
• Development and enhancement of different Inbound and Outbound Interfaces to roll-out Demantra to different divisions and implementing Standard Demantra CTO Process with 7.3.1.2.
• Enhancing the existing interfaces to meet the requirements of upgrade as well roll-out.
• Identifying and implementing changes in existing Interfaces and new components required for the new CTO process.
• Performed changes in the major component i.e., Sales History data extraction to meet all the requirements of client specific new CTO structure.
• Developing new Demantra Series, Integration Interfaces, Workflows and worksheets.
• Outbound Interfaces related to OM, INV and WIP modules.
• Assigning tasks, coordinating and working with the team to accomplish them in the stipulated time.
• Reviewing and finalizing the technical design and unit test case documents prepared by the team.
• Provided complete knowledge transition to the offshore development team.
• Provided complete support during CRP1, CRP2, SIT, SIT2, FAT and Production as well user

Confidential

Responsibilities:

• Technical Lead for the team of 4 members from Offshore.
• Responsible for all the BI Publisher reports track of project. Developing and testing the Financial Module related BI Publisher reports in Fusion apps. Besides, resolving issues reported during UAT phase.

Confidential

Responsibilities:

• Performed few Demantra Set-up changes/enhancements and modified the standard hooks procedure to include the required hierarchy changes as per the business requirements.
• Maintenance of Items, Locations and Sales Data extraction from EBS.
• Loading the data in Demantra and resolving all the issues encountered during this process.
• Validated and resolved the data issues reported by business users as well conducted user .
• Worked on new development, enhancement and performance tuning of BI Publisher reports.

Confidential

Responsibilities:

• Migration of major Customizations with new enhancements (RICE components that were part of Supply Chain Modules).
• Auto PO Process
• Custom Forms
• Vendor Performance Interface
• Preparing and finalizing the technical design and unit test case documents.
• Development of data migrations for Global Purchase Agreement, Purchase Orders and PO Attachments.
• Developed Data extraction code to extract the data from source system.
• Developed loader program which does complete validations and loads the data in the target system.
• Resolving issues on priority during data migration process in each phase of the project including Post production.

Confidential

Responsibilities:

• Design, Development, Post Production support and SIT, UAT support on go-live critical oracle reports.

Confidential

Responsibilities:

• Developing and unit testing of Outbound/Inbound Interfaces at EBS/Demantra end respectively.
• Understanding the custom working of Demantra tool, Workflows and GUI (Worksheets).
• Performing Data extraction on EBS and loading on Demantra end.
• Validating Data and resolving any of the data issues reported during test phases and post go-live support.

Confidential

Responsibilities:

• Worked on different RICE Objects. Mainly focused on,
• Data Conversions related to Manufacturing Modules.
• Customization and testing oracle reports related to Purchasing and Order Management modules.
• Worked on development of Oracle Workflow.
• Support SIT, UAT and Post Production.

Confidential

Responsibilities:

• Development, Testing and final delivery of the newly developed/enhanced reports.
• Production Support issues related to AP and AR Oracle Reports.