SUMMARY:

• More than 7 years of Techno - functional experience in Oracle Applications eBS involved in two Green Field Implementation Projects, one Oracle 11i Implementation project, six enhancement projects, two 11i Upgrade Project and three Production Support Projects during the tenure.
• Currently working as Lead Techno-Functional Consultant at Confidential in Collierville, TN, USA for an R12 Production Support and Enhancement project and leading a team of three onsite and seven offshore team members.
• Worked on PO, INV, iProcurement, OPM, AR, AP, GL, FA, Cash Management, OM, Core HR, SSHR, OTL, iRecruitment modules.
• Strong Technical knowledge in SQL, PL/SQL.
• Worked on Oracle reports 10g, Oracle API’s (Extensively on OPM modules API’s), complete data migration, conversions, interfaces, XML publisher reports, Discoverer Reports.
• Quality Oriented and believe in driving quality consciousness across the team.
• Participated in ITIL initiative for one of the projects.
• Worked as a Technical Lead in one of the Implementation Projects with a technical team size of 5 team members.
• Worked as an individual contributor for one of the clients in Singapore for an enhancement project.
• Has got Honors’ degree in Bachelor of Technology (B.Tech.) (ECE).

TECHNICAL SKILLS:

ERP/Packages: Oracle Applications 12.1.3, 12.1.1, 12.0.4, 12.0.6 and 11.5.10.2, 11.5.5

Modules: PO, INV, OM, iProcurement, OPM, AR, AP, FA, GL, HRMS, OTL, iRecruitment, Oracle Advanced Collections etc.

Language/Programming/Internet Script Language: SQL,PL/SQLHTML

Database: Oracle 9i, 10g, 11i

Tools: SQL*Plus, Data Loader, Toad, Remedy, SQL Developer, Edit Plus Editor, Putty, Discoverer, Kintana, ClearCase, Notepad ++, Subversion SVN, Quality Center Design Methodology (SSAD, OOAD, RUP etc.) Application Implementation Methodology(AIM)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Lead Consultant

Responsibilities:

• Production Support day to day activities like generating status reports, script execution for known potential issues, co-ordination activities with offshore team and client SME’s.
• Responsible for designing solution for business processes which are not yet mapped/developed in Oracle.
• Customization/personalization- This involves gathering requirement for the new components and development of new codes to fulfil these requirements.
• Data Migration Activities for entities still in legacy system - Currently 63 entities are in Oracle and 21 are still in legacy.
• Support business applications through Quality Center tool.
• Technical Changes like XML reports, Concurrent programs.
• Customization of the existing system to improve various existing custom & standard processes.
• End to End testing of new customizations done.
• Involved in ST/SIT, UAT cycle for testing & bug fixing.

Environment: Oracle Applications 12.1.3Operating System(s)Windows7

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Upgrade impact analysis of objects with their customizations (identification in changing data structure related to all objects like tables, indexes, views, packages, API’s etc.)
• Documentation (e.g., AS-IS document, TO-BE document, Technical Upgrade Impact analysis document etc.).
• Pre-upgrade audit (validation of data, process mapping with data, count of data).
• According to impact in current database, made change in custom objects.
• Unit testing of all the components.
• Post upgrade audit (validation of data, process mapping with data, count of data).
• Involved in user for the upgraded system.
• Involved in SIT and UAT.
• Post Production Support after R12 Upgrade Go Live.

Environment: Oracle Applications 11.5.10.2, 12.1.3

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Supporting Oracle Financial modules AP, AR & GL.
• Working on various enhancement requests like reports, customizations, personalization’s etc.
• Responsible for end to end development, testing & delivery of the enhancements.

Environment: Oracle Applications 11.5.10.2

Confidential

Oracle Apps Functional Consultant

Responsibilities:

• As-Is Analysis of client’s existing legacy PRMS system.
• Requirements Gathering, Study of the current Business Process, Suggestions for future Processes and GAP Analysis using AIM documents BR030, BR100 etc.
• Mapping Business requirements with Oracle functionality.
• Configuration and set ups for Purchasing, Inventory & Order Management modules.
• RICE component identification & design document preparation.

Environment: Oracle Applications 11.5.10.2

Confidential

Oracle Apps Techno-functional Consultant

Responsibilities:

• Customization/personalization- This involved gathering requirement for the new component ( Confidential Oracle Application Implementation Methodology) and development of new codes to fulfil these requirements.
• Testing of the customized component ( Confidential Testing Methodology).This is done by running the business case scenario in Production clone instances so that there are no issues faced by the business users in the production instance.
• Techno Functional consultant for modules like AP, AR, GL implementation and development teams. Reviewing BR100 and setting up the instance.
• Data Migration Activities - Cleaning data from legacy systems using Data Clean tool and then uploading the cleaned data using Data Loader tool.
• Support business applications through Remedy Tool.
• Technical Changes like XML reports, Concurrent programs.
• Customization of the existing system to improve various processes.
• End to End testing of new customization done.
• Involved in ST/SIT, UAT cycle for testing & bug fixing.

Environment: Oracle Applications 11.5.10.2Operating System(s)Windows7

Confidential

Oracle Apps Senior Techno-functional Consultant

Responsibilities:

• Handling Technical as well as functional issues related to mainly AOL, Core HR, Self Service HR, OTL, iRecruitment, PO, AP, GL etc.
• Primary as well as secondary level support to all employees of the organization for various day-to-day activities.
• Employee Wage Report development for Payroll and HR modules.
• Customization of the existing system to improve various processes.
• End to End testing of new customization done and fixes provided by Oracle support for product bugs.
• Involved in ST/SIT, UAT cycle for testing & bug fixing.

Environment: Oracle Applications 12.1.1Operating System(s)Windows-XP

Confidential

Oracle Apps Lead Consultant - Onsite, Singapore

Responsibilities:

• Handling Technical as well as functional aspect of the project.
• Impact analysis of the enhancement required for automating the process.
• Customization of the existing system to automate the process.
• Unit testing of new customization done.
• Involved in ST/SIT, UAT cycle for testing & bug fixing.

Environment: Oracle Applications 11.5.10.2

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Upgrade impact analysis of objects with their customizations (identification in changing data structure related to all objects like tables indexes, views, packages, API’s etc.).
• Deployment and testing of 58 custom Manufacturing and Finance reports
• Deployment and testing of 34 Manufacturing and Finance Forms Personalization.
• Unit testing of all the components.
• Prepared material for Users for Report Generation, Alerts and Personalization.
• Involved in ST/SIT, UAT cycle for testing & bug fixing.
• Worked on Bill Presentment Architecture (BPA).

Environment: Oracle Applications 12.1.1Operating System(s)Windows-XP, UNIX

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Upgrade impact analysis of objects with their customizations (identification in changing data structure related to all objects like tables indexes, views, packages, API’s etc.)
• Documentation (e.g., AS-IS document, TO-BE document, Technical Upgrade Impact analysis document etc.).
• SR generation and their monitoring.
• Pre-upgrade audit (validation of data, process mapping with data, count of data).
• According to impact in current database, made change in custom objects.
• Unit testing of all the components.
• Post upgrade audit (validation of data, process mapping with data, count of data).
• Involved in user for the upgraded system.
• Involved in SIT and UAT.

Environment: Oracle Applications 11.5.10.2

Confidential

Technical Lead

Responsibilities:

• Worked extensively in Oracle Process Manufacturing (OPM) API’s to develop custom module (SFDC-Shop Floor Data Collection System).
• Involved in technical and functional design and development of OSP (Outside Processing System) solution for Process Manufacturing.
• Worked extensively in AP, AR, Inventory modules for data migration & conversion.
• Understanding the requirement of the client and developed codes for master data conversions like Item, Supplier, Customer and Employee and for OPM conversions like formulas, routings, recipe, operation, resource, validity rules, and test cases.
• Developed codes for creating credit memo, debit memo, AR invoice and AP invoice for Freight Management System (FMS) for Process Manufacturing.
• Worked on customization of custom pll.
• Preparation and review of design documents to describe the analysis done and the changes required for the integration.
• Imported data for India Localization.

Environment: Oracle Applications 12.0.6

Confidential

Technical Consultant - Offshore

Responsibilities:

• Working as a Technical Consultant for resolving customer issues related to Oracle Order management.
• Resolving the orders stuck in Oracle Apps and different interfaces, specifically eCDM interface.
• Solely responsible for all the housekeeping activities e.g., analysis of base and custom tables, creating purge scripts for them, interaction with client for housekeeping issues.
• Involved in preparing business reports for Client.
• Working on improvement of the existing system.
• Leading the team of fresher and giving knowledge transfer sessions for the existing system.
• Handling complex issues and assigning the repeated issues to the fresher.
• Involved in giving enhancements and permanent fixes for the frequently occurring problems to improve the performance of the system.
• Functional understanding of all the interfaces involved in the system.
• Detail analysis and study of all the related business and technical documents.