SUMMARY:

• Over 5 years of IT experience in Analysis, Design and Implementation as a Techno Functional Consultant in Oracle database and E - Business Suite. Highly motivated, enthusiastic professional with high level of commitment to succeed.
• Worked on more than 3 end to end large scale Oracle EBS implementation projects.
• Received appreciations from management on various occasions for dedication and commitment towards work in various projects.
• Have Extensive experience in different phases of the software development life cycle such as requirements gathering, analysis, design, development, administration, testing, implementation and Documentation.
• Ability to work independently, key team player and effectively promote teamwork.
• Have experience in Implementation, Development, Customization, Testing and, Production Support of Oracle Applications, mainly in CRM, SCM and Financials Domains.
• Good working knowledge in Data Model of Order Management (OM), TCA Architecture, Service Contracts (OKC/OKS), Install Base (IB), Account Receivables and Fixed Assets (FA) Modules.
• Have thorough hands on Experience Senior Developer in SQL, PL/SQL, Oracle Forms, Reports, Oracle Workflow, BI/XML Publisher to generate reports in PDF, HTML, and Excel Formats.
• Possesses sound knowledge of System Administration part of Oracle applications, Concurrent Program Registration, Responsibilities, Menus, and Functions etc.
• Expertise in developing RICE components using SQL, PL/SQL, as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Experience using Oracle Streams, Advanced Queuing (AQ), Java Store Procedures, DBMS Jobs, Generating/Parsing XML data, building and invoking Web Services from database.
• Worked on Database Performance Tuning for custom programs in EBS
• Ability to learn new modules and Technologies quickly and efficiently.
• Excellent communication skills and team player, very good working knowledge in Technical Documentation
• Excellent problem solving and Analytical skills with an ability to identify problems and implement connective solutions.

TECHNICAL SKILLS:

Operating System: Windows XP, UNIX

Languages: SQL

PL/SQL: Unix Shell Scripting

Core Java: Oracle ERP Modules

CRM Modules: Oracle Service contracts

Oracle Install Base: Field Service

Oracle Receivables: Account Payables

Fixed Assets: General Ledger

TCA: Order Management

Front end Tools: Oracle Reports Builder(XML Publisher)

Oracle Form Builder(6i,10g): Oracle Work Flow Builder

PL/SQL Developer: JDeveloper 12.2.1.2.0 for ADF(Just 6months experience)

Tools: & Technology: MKS Integrity and ALM

PROFESSIONAL EXPERIENCE:

Confidential, Webster, NY

Oracle Apps Technical Consultant

Operating System: Windows XP

Languages: SQL, PL/SQL, UNIX

Modules: Service Contracts, Install Base, Accounts Receivables, General Ledger and TCA

Version: Oracle Applications R12.1.3

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Responsibilities:

• Understanding business process and gathering requirements from clients
• Analyzing the existing business flow and proposing new business flow
• Preparation of customer requirements, development requirement documents and Functional Test Case Design Documentation and presenting them to business and IT users for getting approvals.
• Implementing the functional and technical setups in order to develop the desired functionality
• Understanding and implementing any new functionality which comes in addition to the existing functionality
• Providing estimations, code version control and code development
• Responsible for database tuning and optimization of the SQL queries and PL/SQL objects
• Optimizing the database performance of Trading Applications using Object Types, Collections, Records, etc.
• Knowledge sharing and onsite - offshore coordination.

Confidential

Oracle Apps Technical Consultant

Operating System: Windows XP

Languages: SQL, PL/SQL,UNIX

Version: Oracle Applications R12.1.3

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Modules: Service Contracts, Install Base, Field Service, Accounts Receivables, Account Payables, General Ledger and Fixed Assets

Responsibilities:

• Carried out the following activities:
• Involved in the Preparation of AS-IS documents for CRM modules.
• Prepared Customer Requirements and Development Requirement documents.
• Involved in Design, Coding and Unit Testing.
• Manually executed the test cases on the build for functional validation.
• Analysing the data reports and defect logging & tracking till closure.
• Sharing the Test Results with Client.

Confidential

Oracle Apps Technical Consultant

Hardware:

Operating System: Windows XP

Languages: SQL,PL/SQL,UNIX

Version: Oracle Applications R12.1.3

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Modules: Service Contracts, Install Base, Accounts Receivables, Field Service, TCA and Order management

Responsibilities:

• Involved in discussions with Customers for gathering the requirements.
• Prepared customer requirements, development requirement documents and Functional Test Case Design Documentation and presented to business and IT users for getting approvals.
• Developed PL/SQL objects such as Packages, Functions, Procedures, triggers, tables etc.
• Used UTL FILE package to generate various feeds for the external and internal systems.
• Analyzed the complex Backend Procedures/Packages/Queries and implemented the changes to improve the processing time by using Hints and Materialized Views.
• Implemented the functional and technical setups in order to develop the desired functionality
• Implemented new functionality which comes in addition to the existing functionality
• Provided Post Production support and resolved issues arisen during that duration.
• Involved in Knowledge sharing and onsite - offshore coordination.

Confidential

Oracle Apps Technical Consultant

Operating System: Windows XP

Languages: SQL,PL/SQL,UNIX, Core JAVA

Special Software: Oracle Applications R12.1.3 Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Tools: Forms 10g, PL/SQL Developer, Oracle 11g and Oracle E-Business Suite.

Modules: General Ledger, Fixed Assets, Account Receivables

Responsibilities:

• Understand the functional requirements and prepare detail technical design Documents
• Implemented the necessary changes to enable the Oracle ERP General Ledger and Fixed Assets module
• Consolidated the multiple General Ledger and Fixed Assets applications that are currently supporting US and Canada .
• Prepared High level Design, Detail level design and test cases
• Involved in Development and testing of outbound interfaces and conversions.
• Post-production support.
• Involved in Knowledge Sharing Sessions with Support Teams.