SUMMARY:

• Over 5 years 9 months 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

CAREER PROFILE:

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.

Version: Oracle Applications R12.1.3

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.