SUMMARY

• 7+ years of experience in Oracle Apps (ERP Package). Expertise in R12 Oracle Application Implementation, Upgrade and Support.
• Extensively worked on Oracle Apps including reports creation, code customization, Mods and Interfaces.
• Worked on SQL, PL/SQL, Forms, Workflow, Oracle Reports, XML Reports and Form Personalization.
• Experience with Data Dictionary, Database Normalization Theory and Design Techniques.
• Expertise in Client Server application development using Oracle 11g/10g/, PL/SQL, SQL*PLUS, TOAD and SQL *LOADER.
• Thorough knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and SQL - Server database.
• Writing complex database objects like Stored Procedures, Functions and Packages and triggers using SQL and PL/SQL.
• Designed and Developed complex custom programs and reports using PL/SQL.
• Experience in Records and PL/SQL Tables.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Involved in creating Procedures, packages using REF Cursors, BULK collects.
• Experience in SQL Performance tuning using Cost-Based Optimization (CBO).
• Good Knowledge in Performance Tuning using Explain Plan and HINTS.
• Functional knowledge in Inventory, Order Management, Purchasing.
• Understanding the Business Process of Oracle Applications covering Order to Cash and Procure to Pay.
• Involved in gathering the user requirements and preparing Technical Design Documents.
• Good working knowledge in all the stages of Software Development Life Cycle.
• Created Shell Scripts for migrating components from one instance to another.
• Experience in using tools like TOAD, WINSCP, Putty and Tortoise SVN.
• Excellent Analytic and Problem Solving skills.
• Self-motivated, self-starter, insightful, result driven, highly focused and fast learner

TECHNICAL SKILLS

Operating System: Windows 95/98/2000/NT/XP, Unix

Programming Language: SQL, PL/SQL, Shell Scripting

Database: Oracle 11g

Tools: BI/XML Publisher, Oracle Workflow Builder, Basics of Discoverer, Quality Centre, WinSCP, SQL Developer, SQL plus, TOAD, Putty and Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential

Sr.Oracle Developer

• Understand the existing solution in R12.1.1 and ensuring existing solution working in upgraded version 12.1.3
• Understanding new features in R.12.1.3 and perform setup per business requirement.
• Preparation of SIT and UAT Test cases.
• Test in Development, SIT and UAT instances to ensure upgraded application is working as expected.
• Test and Migrate issues fixed in SIT and UAT test cycle.
• Support Business and Onsite team to execute UAT and fix any issues raise during UAT.
• Provide hyper care support post go-live to fix, test and migrate any issues raised by application users.

Environment: Oracle Apps R12

Confidential

Sr. Oracle Developer

Contribution

• Understand the existing solution in 11i and ensuring existing solution working in upgraded version 12.1.3
• Retrofitted custom PL/SQL programs, SQL programs, Reports in AP, GL and AR modules.
• Created Technical specification and unit test case documents.
• Performed Code review for retrofitted components.
• Unit testing of retrofitted components and migration to test instances.
• Provided technical support for CRP sessions and SIT test phase and resolving tickets raised.
• Guided team under stringent deadlines and delivered the components on schedule.

Environment: Oracle Apps R12

Confidential

Sr. Oracle Developer

Contribution

• Review functional specification documents for enhancement requests.
• Identify Process Improvement areas and Design, develop, test and deploy Process improvements.
• Ensure Production migration code and documentation adhere to development standards.
• Review Technical Specification document and initiate change control process.
• Provide solution and Support for any Severity 1 issues/ Bugs raised.
• Support Business and Onsite team to execute UAT and fix any issues raises during UAT for rollouts.
• Manage Development team and ensure on-time delivery.
• Coordinate Onsite and Offshore team to track issues and ensure team follows SLA to close the issues.
• Handle customer escalations and take appropriate action.
• Create and monitor daily job runs in Cisco Tidal enterprise scheduler to transfer files to third party applications and Bank using PGP encryption.
• Ensure all integrations including Middleware and third-party applications are up and running.
• Review and upload technical documents in Agile for compliance approval.
• Work with external application support to resolve any issue related data transfer or process issue.
• Control access to SVN code repository.
• Schedule and monitor cron jobs to send alerts to support team.

Environment: Oracle Apps R12

Confidential

Associate Technical Consultant L3

Contribution

• Involved in requirement gathering and designing phase.
• Involved in the development of operational reports, MOD’s, Interfaces.
• Worked in the areas of Oracle Purchasing, Order Management, Inventory and Account Payables.
• Functional Knowledge on Order to Cash (O2C) cycle and Procure to Pay (P2P).
• Involved in Form customization
• Developed the XML reports which involve these modules.
• Involved in defect fixing and performance tuning.
• Supported all phases of project deployment like SIT, ST and UAT, Supporting for higher phases.
• Successfully completed complete life cycle of project deployment.

Environment: Oracle Apps R12

Confidential

Associate Technical Consultant L2

Contribution

• Involved in designing of technical design document as per functional requirements.
• Involved in the development of Operational reports, Interfaces and MOD’s.
• Extensively worked in PL/SQL, SQL *Plus, Explain Plan, Query Performance tuning, created DDL scripts, Created database objects.
• Worked in the areas of Oracle Purchasing, Order Management, Inventory and Oracle Process Manufacturing.
• Developed the complex XML reports which involve these modules.
• Involved in writing the Test cases and performing the Unit testing for all the possible scenarios.
• Involved in defect fixing and performance tuning of the custom reports and MOD’s.
• Successfully completed complete life cycle of project deployment, starting from design phase to ‘Go-live’.

Environment: Oracle Apps R12

Confidential

Application Developer (ORMS) L1

Contribution

• Involved in understanding and analysis of functional and technical requirements from Design documents
• Worked with business to refine and clarify requirements to ensure quality deliverables on time
• Provided Design solution through design documents on Oracle Retail Merchandising System enhancement/modification
• Involved in the core development activity of customization in Oracle Retail Merchandising System (ORMS) application
• Development of operational reports using BI Publisher

Environment: ORMS 13.2