Professional Summary

• Around 9 of rich technical experience in Oracle Applications in Analysis, Design, Development, Testing and Support of Business Applications with rich onsite experience.
• Extensive experience in designing, development, testing and implementation of Stored Procedures, Packages, Functions in PL/SQL, Shell Script
• Extensive technical experience in Data Conversion Interfaces, Customization Development of Reports, Forms, Oracle Workflow, OA Framework
• Basic Functional knowledge in General Ledger, Oracle Payables, Oracle Order Management OM , Oracle Process Manufacturing OPM , Procurement, Purchasing.
• Extensive technical expertise in Oracle HRMS with core HR, ADP Payroll and Self Service as main modules
• Part of the End to End implementation life cycle. The implementation cycle Initial Kick-Off, Requirement Gathering, Effort Estimation, Client Approvals, Solution design Technical Design Document, Configuration and Release Planning, Testing Cycle Testing Document, Implementation Instruction for UAT and finally ensuring project is successfully implemented within the timelines
• Excellent problem solving skills with an ability to identify problems and implement connective solutions.
• Experience in providing Level 2 support to resolve high priority production and support tickets
• Excellent Communication, Analytical, Interpersonal, Presentation skills

Skills

ERP : Oracle Applications 11.5.9, 11.5.10.2, R12.1.3, R12.2.4

Finance Module : AP, PO, Iprocurement and GL

Distribution Module :OM, OPM

People Module : Oracle Core HRMS, Oracle ADPPayroll, Self Service

Oracle Applications Products : Form 6i/9i, Report 6i/9i, Oracle Workflow, OAF

Oracle Framework : JDeveloper 9i/10g

Programming Languages : C, C , HTML, XML and Java.

Operating Systems : Windows 9x/2000/XP, UNIX.

Databases : Oracle 9i/10g

Tools Utilities : SQL Loader, Data Loader, PL/SQL Developer, Toad

Trainings Attended

Oracle 9i SQL and PL/SQL , Forms 6i, Reports 6i at Software Technologies Group International Ltd.

Oracle Application Framework conducted at HCL Technologies.

XML Basics conducted at HCL Technologies.

Professional Experience

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Ensuring proper interaction with clients, arranging client meetings and guiding the technical team with the proper inputs for prompt delivery of deliverables in time.
• Developed the Solution Design Document, based on gap analysis and feasibility study.
• Management of own time and delivery of tasks according to deadlines and identifying options for potential solutions and assessing them for both technical and business suitability.
• Conducting end to end process functional testing of the retrofitted components.
• Contributed to Functional Designs by providing solution design feasibility and recommendations

Oracle OAF

• Involved in various OAF customizations like VO Extension, Controllerextensions, AM extensions and designing new custom OAF pages for various modules like HCM, Finance,SLM and OM.
• Involved in designing a whole new custom module for Advanced Pricing for Order Management module which helped in setting up the prices for all the commodities from the client side.
• Involved in resolving various support tickets both in business logic and the front end framework of the custom screens developed for online shopping of Texas Smartbuy. The complexity involves in understanding 11i upgrade to R12.Needed constant interaction with the client team understanding various upgrade features and new customizations that were needed.

Oracle Workflow

• Involved in designing a custom workflow for EAM module which routes approval to a set of approvers based on certain scenarios and this involves understanding the seeded workflow and various business scenarios attached to it.

Oracle Reports

• Involved in developing a MPA report for accounts payable division user needs in Excel XML in a prescribed format to know the outstanding accruals pending transactions accounting.

Oracle Interfaces

• Involved in designing various conversion interfaces used for loading of legacy data into R12 instances for modules like HCM, SCM, OM.
• Involved in designing a concurrent program which updates the leave balance of an employee when there is a change of holiday calendar

Confidential

Responsibilities:

• Responsible for continuous client interaction for analyzing technical solutions for the various customizations involved in current system.
• Implementing new system and providing production support and correction of errors / bugs in production
• Documentation of changes in programs and publishing of documentation as required to a central point
• Leading a technical team for understanding the various technicalities and functionalities of the various customizations done in the system.

Oracle OAF

• Involved in resolving various support tickets both in business logic and the front end framework of the custom screens developed for online shopping of client marketing site. The complexity involves in understanding 11i upgrade to R12.Needed constant interaction with the client team understanding various upgrade features and new customizations that were needed.
• Involved in the enhancement of adding Related Contracts column in custom contracts advanced page search results. This column would display Yes with hyperlink if the contract has any related contracts else it would display No without hyperlink . If user clicks on Yes, new form would open and display the related contracts number and relationship code. The related contract number would be having hyperlink to redirect to contract details page.
• Involved in creating a new OAF pages for validation of QMSR status in the Iprocurement module i.e. When the User creates a requisition and when he checks out, depending on the category of the item he selects, a questionnaire page would appear which on answering would validate the qms functionality of the requisition.
• Involved in creating custom module called GEOHR responsible for creating mapping rules for particular business units. It involves creation of screens responsible for creating, updating and display of the mapping rules along with the respective operating units.
• Involved in many customizations and personalization with the various flows of Iprocurement pages with OAF in various businesses of GE.
• Involved in resolving few technical issues regarding a custom screen developed by GE called Document Viewer which is used for searching any document regarding the purchasing modules.

Confidential

Oracle Applications 11i, Oracle Database 10g, Oracle Application Framework

Responsibilities:

• Analyze the Functional Specification received from client.

• Involved in the Customization and Development of Self Service Pages Used for validation of timesheet entered by employees.

Oracle OAF

• Involved in the customization of a custom page used for validating the timesheet entries made by the employers working in the organization. This page basically validates all the entries made by the employees in the timesheet and informs them of all the possible time entries for a particular project. The extensions include extending the View Object, Changing the Controller code, AM code and overall business logic of the screen.
• Using this custom application one can Mobilize, Demobilize time entries for a particular project for the employees working under the project. It also has the provision for over time entries and approval of the same.