SUMMARY:

• Over 8 years of extensive experience as Techno - Functional Consultant, in implementation and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Involved in Implementation, Enhancement, Testing and Support projects of Oracle Applications R12, 11i including the requirements gathering, analysis, process mapping, solution design, customization, data migration and testing.
• Strong Programming experience on Reports, Interfaces, Conversions, Extensions and Workflows ( RICEW ) and Unix Shell Scripting.
• Highly skilled in developing Reports using Reports 6i/10g, BI and XML Publisher Reports.
• Expertise in developing forms using Forms 6i/10g.
• Experience in designing Data Conversion programs both inbound and outbound to integrate Oracle Applications modules to import data from various sources using PL/SQL, SQL*Loader.
• Strong Knowledge and rich experience in Application object Library (AOL) and System Administration with LOV, Creating concurrent programs and Responsibilities.
• Strong Exposure in writing Simple and Complex SQL, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Experience in UNIX shell scripting, Performance Tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF.
• Excel in preparation of Functional Design (MD.050), Technical Design (MD.070) and Installation (MD.120) documentation using AIM standards.
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical & Functional issues.
• Worked with Oracle for standard bugs using Oracle service requests (SRs).
• Experienced in working with Oracle Team for standard bugs using Oracle SRS and has good knowledge on Patch Analysis using patch wizard in oracle apps and remediated the components in oracle apps for the patches provided by Oracle.
• Good knowledge on Oracle Application Framework (OAF) and Oracle Application Development Framework (ADF).
• Ability to communicate well at the user and technical levels to breakdown complex problems into manageable parts and develop alternative solutions.
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Self-starter with potential, initiative and a positive attitude.
• Keen and enthusiastic with constant desire to learn and a commitment to excel.

PROFESSIONAL EXPERIENCE:

ERP: Oracle Applications E-Business suite (EBS) 11i, R12 Order Management (OM), Inventory (Inv), Purchasing (PO), AOL, Account Payables, Account Receivables, General Ledger)

Oracle ERP: Versions 11.5.9/11.5.10 / R12.1.3

RDBMS: Oracle 10g/9i

Programming Languages: SQL, PL/SQL, Java, UNIX Shell Script, XML,C, C++,PERL, HTML.

Development Tools: SQL*Plus, SQL-Loader, PLSQL Developer/TOAD/SQL Developer, XML/BI Publisher, Oracle Reports 6i/10g, Oracle Forms 6i/10g, Oracle Workflow Builder, JDeveloper, PVCS, RCSMENU, Kintana and HP Quality Center.

Methodologies: Application Implementation Methodology (AIM)

Operating Systems: Windows 7/XP/NT/2000, Unix, Linux, Solaris

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Techno Functional Consultant

Key Areas: UNIX shell scripting , AOL,Pro*C, OM, Purchasing, Inventory, WMS, BOM, WIP, Oracle Reports, Oracle Forms, XML Publisher, Interfaces, SQL, PL/SQL

Responsibilities:

• Analyzing the existing shell scripts and the applications.
• Remediating the existing UNIX shell script and make it compatible to work in LINUX environment
• Remediating the scripts used for third party integration.
• Working with Oracle team, to resolve the standard issues faced due to incompatibilities.
• Working with DBA team to resolve the server related issues.
• Analyzing and converting the older technologies to LINUX Shell scripts or PLSQL.
• Daily follow up meeting with offshore and resolving the issues faced during remediation and unit testing
• Tracking of the remediation and status report.
• Working with BSA and users for requirement gathering for the newly raised Change request .
• Development of Components as per user requirements and perform unit testing.
• Updating of SDD and TDD after the code changes .
• Support during application release and in burn in after post production .
• Scheduling and providing the KT(knowledge transfer sessions) to Production support teams.

Confidential

Oracle Applications Techno Functional Consultant

Key Areas: OM, Purchasing, Inventory, WMS, BOM, WIP, Oracle Reports, Oracle Forms, XML Publisher, Interfaces, SQL, PL/SQL

Responsibilities:

• Patch Analysis and finding the Extended/Customized components affected by the Oracle patch.
• Remediating the standard customized components in the oracle apps.
• Working directly with the end users to understand and resolving the issues during remediation.
• Developing PL/SQL packages, functions and procedures as per business requirements.
• Worked on personalization related to Purchase order affected by oracle patch.
• Coordinating with Offshore counter parts to resolve the issues.
• Resolving the issues raised by the regression team during regression testing
• Burn-in support for post-production of patches.

Confidential

Oracle Applications Techno Functional Consultant

Key Areas: OM, Purchasing, Inventory, WMS, BOM, WIP, Oracle Reports, Oracle Forms, XML Publisher, Interfaces, SQL, PL/SQL

Responsibilities:

• Working directly with the end users to understand and resolve production issues.
• Developing new reports and interfaces as per business requirements.
• Developing PL/SQL packages, functions and procedures as per business requirements.
• Creating technical documents like System Design documents(SDD) and Technical design documents(TDD) and test plan.
• Tracked and published monthly production problems and resolution metrics.
• Defining and Registering Concurrent Programs, Request Sets in AOL.
• Scheduling the weekly status calls with Business users to discuss service ticket issues.
• Responsible for migration of code from Development to Testing environments with requisite approvals.
• Working on form personalization as per business requirement.
• Performance tuning for the long running queries /jobs.
• Fixing day to day production issues.
• Suggesting users with the workaround steps for the process related issues.
• Handled service requests with Oracle support on the Oracle product issues and Oracle patch testing.
• Working on the root cause for the critical issues faced in production instance.
• Creating workaround jobs to resolve the most commonly repetitive issues to save time and increase the productivity
• Conduct System Integration tests (SIT) for all customizations and enhancements.

Confidential

Oracle Application Developer

Key Areas: OM, Purchasing, Inventory, WMS, BOM, WIP, Advanced Pricing, Oracle Reports, Oracle Forms, XML Publisher, Interfaces, SQL, PL/SQL

Responsibilities:

• Analyzing the User Requirement Specifications
• Creating technical documents like System Design documents, Technical design documents and unit test case documents.
• Developed Custom forms as per business requirement .
• Developed customer specific reports using 6i report builder involving the WIP modules.
• Developed Custom Programs and UNIX scripts to load Data into custom Interfaces staging tables.
• Involved in enhancement of reports based on business requirements and registered them in Oracle applications.
• Coordinating with the onsite counterpart for daily status update

Confidential .

Oracle Applications Regression Tester

Key Areas: OM, Purchasing, Inventory, Inventory, WMS, BOM, WIP

Environment: Oracle Apps 11i - OM, PO, INV, HP Quality Center 11, Unit Testing

Responsibilities:

• Analyzing the User Requirement Specifications
• Coordinating with Functional owners and Onsite team
• Testing the Major customizations of Confidential Healthcare
• Revising the existing Test Scripts and creating new Test Scripts.
• Testing the Major customizations of Confidential Healthcare.
• Executing Test cases manually and reporting bugs in Quality Center tool.
• Mapping the Test Scripts in the Quality Center and defect Tracking.
• Doing required Functional setups during dry run.
• Attending daily and weekly status meetings with onsite team
• Reviewing the test scripts as per Test Case Standards
• Preparing Unit Test Plan and Installation Documents