SUMMARY:

• Having over all 12 + Years of IT experience in design, development, customization, testing and support of business applications using Oracle Client - Server architecture on a number of platforms. Having 6 + years of Experience in Oracle E-business suit full life cycle implementation customization and production support on ORACLE Applications R12/11i/11.x in OM-Order Management, PO-Purchasing, INV-Inventory, AP-Account Payables, AR-Account Receivables, System Administration,AOL,Workflow
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within SCM and Finance, Oracle Retail modules in Oracle Applications.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using SQL, PL/SQL, SQL*Loader.UTL FILE
• Experience in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
• Strong knowledge in SQL, PL/SQL Development and support.
• Strong knowledge of Application Implementation Methodology ( AIM ), Agile, Application Object Library ( AOL ) implementation standards, Trading Community Architecture ( TCA ) and Software Development Life Cycle (SDLC).
• Very good experience in Forms Development and Forms Personalization
• Very good development Experience in ETL Tools: Informatica power center.
• Having very good experience in Requirement Gathering, Client interaction and project Management
• Experience in Database up gradation and batch processing.
• Experience in Project Billing, Estimation ,Planning and incident management
• Very good experience in Team Management and project Coordination.
• Very good Experience in Incident Management.

TECHNICAL SKILLS:

Oracle Application ERP: Oracle Application R12

Database: Oracle10g,SQLSERVER,DB2

Oracle Tools& Languages: SQL,PL/SQL, Oracle Forms,Rports,Pro*C unix Shell Scripting

Domain Knowledge: Oracle Retail, Supply chain management,Finance,Banking, intellectual property

Operating systems: Sun Solaris, HP-UX, UNIX, Windows 95/98/NT/2000/XP

ETL & Tools: Informatica power center

Change & Incident Management: HP-ALM Service Now and SM7

Utility Tools: SQL*Loader,Toad,SQL Developer

RECENT WORK HISTORY:

Confidential

Associate Project Manager

Responsibilities:

• Managing and coordinating the project team to complete the task before SLA time frame.
• Worked on Pl/sql, Packages,Fumction and procedures Development support
• Prepared Complex SQL Queries for Customers Data
• Organizing the team meeting and customer Interaction
• Worked on Quick analysis on the PROD issues and providing the requisite script
• Worked on Task assignment and monitoring the system.
• Gathering process knowledge to give quick workaround on PROD issues
• Prepared Complex SQL Queries for Customers Data
• Worked on Confidential Customized Order process and handled errors

Confidential

Technical Consultant

Responsibilities:

• Developed outbound interface to transfer the data from base tables to external System
• Worked on Forms personalization as per the business requirements and workflow customization
• Worked on Requirement Gathering and converting business document into technical document
• Preparation of Test Cases and Test Plans and System Testing.
• Developed Data Conversions and Interface Programs . Used SQL * Loader to Load Data into Oracle Database .
• Worked on writing complex SQL.PL/SQL Package, Procedure Code.
• Worked on XML Publisher reports using RDF and Data Template
• Worked on Code coalition and code review.

Confidential

Sr.Consultant

Responsibilities:

• Worked for the sustaining engineering (US) team as individual contributor
• Worked as Part of development & performance team on enhancing/debugging/tuning the RMS module for various versions including 12, 13 & 14.
• Once in while liaise with the customers directly along with the internal solution Once in while liaise with the customers directly along with the internal solution architects to understand the customer issues which are otherwise not reproducible, propose the solution, review and release build as localization fix
• Reproduce and simulate the technical issues that is failing/not working at the Customer production environment identify the root cause, develop the solution, perform the complete functional & validation unit test and release fix as a new build/patch to deploy in customer environment.

Confidential

Responsibilities:

• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Worked on Forms Development and support
• Marinating the Confidential oracle application All over Gulf Region

Confidential

Responsibilities:

• Development of new objects, Interface related to business requirement
• Design and Development of the legacy customizations to Oracle Applications
• Closely interacting with onsite coordinator in deriving the delivery dates of the components
• Development of Interfaces, Workflows, Forms and Reports as part of new Enhancements to the production implementation.

Confidential

Responsibilities:

• Development of new objects, Interface related to business requirement
• Worked on Form Forms personalization and Upgadation Designed, developed and implemented
• Worked on preparing test case and test script
• Liaising and Resolving customer production DB issues
• Worked on monthly closer activities

Confidential

Responsibilities:

• Redesigned the complete module with materialized view feature from the existing Poorly performing module which was using Oracle streams concept
• PLSQL code optimization on all the batch programs.
• Develop test scripts for all the modules developed including unit test & peer Review
• Liaising and Resolving customer production DB issues