Summary

• Oracle certified PL/SQL developer with around6years of IT experience with proficiency in software development.
• Actively involved in project execution process, coding standards best practices.
• Proficient in understanding business processes / requirements and translating them in to technical requirements.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i/ Oracle Apps, SQL, PL/SQL.
• Experience in analysis and design and data modelling of relational database using ER Diagrams.
• Hands on experience in executingSQL Queries and Creating PL/SQLPackages, Procedures, Functions, Triggers, Ref Cursors, materialized views.
• Experience in working with analytical functions, collections and extensive knowledge of Dynamic SQL and queries, Bulk loading and processing.
• Experience of databaseperformance tuning using SQL Trace, explain Plan, TKPROFand DBMS PROFILER.
• Experience in Version Control management using PVCS and dealt with multiple version code development environment.
• Extensively worked on trouble-shooting, Problem solving, Analytical Design related tasks.
• Involved in Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing UAT , Code Review, coordinating user training and user testing, Project demonstration, Implementation, Maintenance.
• Good knowledge of Data Modeling, Data Warehousing concepts, OLAP Concepts, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Experience in ETL tasks related to data transformation and migration such as creating and loading of meta data , applying transformation process/rules,monitoring various sessions usingInformatica data warehousing tool

Software Skills

• Operating Systems:- Windows Vista/XP/2000/98//7.0, UNIX
• Databases:- Oracle 11g/11i/10g/9i/, SQL Server 2000, DB2
• Front-End:- Oracle Apps
• Reporting:- Crystal reports 9/10
• Languages:- SQL, PL/SQL, UNIX Shell script
• Database Tools:- TOAD,PL/SQL Developer,SQL Plus,
• ETL/Data warehousing tools:- Informatica Power Center

Professional Experience

Confidential

Role: -Sr. Oracle PL/SQL Developer /Module Lead

Responsibilities Include:

• Extensively involved in the complete software development life cycle process.
• Actively involved in Oracle 10g to 11g migration tasks.
• Worked on multiple version code development environment, used PVCS for version control management.
• Generated SQL and PL/SQL scripts to install create database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Writing of Procedures/Functions/Packages/Triggers/Other Database Objects for the data processing using SQL and PL/SQL.
• Worked on Bulk processing, collections and Dynamic queries for Query optimization.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, VARRAYS, Records, Types, Materialized views, Dynamic SQL etc.
• Actively involved in performance tuning using Explain Plan, TKPROF and dbms profiler.
• Used indexes and hints for query optimization.
• Involved in UAT, Code Reviews and Production deployment process.

Environment:Oracle 11g,10g, Oracle Apps 11i, PL/SQL developer, SQL Plus, TOAD, PVCS Version Manager, Windows XP, Unix SSH, HP Quality Center, Kintana Package Deployment

Confidential

Role: -Sr.Oracle PL/SQL Developer

Responsibilities Include:

• Detailed functionaland technical Analysis of Legacy system, business requirements and various workflows.
• Identified existing production issues and various flaws in the existing system and process flow.
• Preparation of High /Low Level technical Design and functional specification documents.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, VARRAYS,Records, Types, Materialized views, Dynamic SQL etc.
• Developed various Reports using Oracle PL/SQL advanced features for analyzing data.
• Developed Packages, Stored procedures, triggers to translate Input source to the final output statement file using SQL queries and PL-SQL.
• Performed Data Mining Data Aggregation using complex business rules.
• Prepared test cases for testing procedures, also involved in unit testing and Integration testing of the Modules.
• Involved in debugging, error handlingand providing fixes to the issues identified in testing phaseto facilitate smooth and proper functioning of the system.
• Implemented Bulk processing, dynamic queries and complex functionality using collections to improve performance.
• Query Optimization, using optimizers and Database performance tuning of slow performing Queriesusing SQL Explain Plan and TKPROF.

Environment: Oracle 11g, 10g, Oracle Apps 11i, PL/SQL developer, SQL Plus, TOAD, PVCS Version Manager, Windows XP, HP Quality Center, , Kintana Package Deployment

Confidential

Role: -Oracle PL/SQL Developer /Module Lead

Responsibilities Include:

• Generated scripts to install create database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Worked on creating Procedures/Functions/Packages/Triggers/Other Database Objects using SQL and PL/SQL.
• Co-ordination with cross-functional teams to understand the impact of the requirements on up-stream and downstream systems, leveraging onsite-offshore model to maximize productivity and optimize project cost.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, VARRAYS, Records, Types, Materialized views, Dynamic SQL etc.
• Design and developed various Reports using Oracle PL/SQL and SQL.
• Performed Tuning using Explain Plan, Tkprof, Hints and Indexes.
• Extensively Used TOAD, PL/SQL developer tools for faster application development.
• Created responsibilities, menus, functions and concurrent jobs using Oracle apps.
• Documentedfunctional and technical designs, test cases, and user guides.
• Prepared various test cases, involved in debugging, error handling, unit testing and Integration testing of different modules of the system.
• Worked on Oracle 11i, created various concurrent jobs, scheduled and monitored as per requirement of the project.
• Actively involved in code deployment process to production using Kintana Package Deployment.
• Provided on-call production support to solve immediate crises and work towards stability, self-sufficiency through knowledge transfer
• Worked with clients to meet and exceed all agreed to Service Level Agreements SLA for the organization
• Actively involved in debugging the code, error handling and providing fixes to the issues identified in testing phase to facilitate smooth and proper functioning of the system.
• Debugged and fixed production fallouts due to code glitches on a daily basis.
• Deployed crucial patches directly into production environments.

Environment: Oracle 10g, Oracle Apps 11i, PL/SQL developer, SQL Plus, TOAD, PVCS Version Manager, Windows XP, HP Quality Center, Kintana Package Deployment

Confidential

Role: -Oracle PL/SQL Developer

Responsibilities Include:

• Worked on Project Management and Demand Management PPM modules.
• Creating and maintaining workflows request types to digitize the existing SDLC processes
• Client interaction to understand the business requirements and providing functional and logical solutions for the same.
• Modification and Enhancement of existing Packages and stored Procedures based on the User Change/Enhancement Request using SQL Queries and PL/SQL.
• Writing PL/SQL Packages, Functions, stored procedures, complex queries and logic to accommodate the requirements and to generate various reports.
• Design and document reporting/dashboard requirements.
• Configure the project/proposal creation process within application. Help in design of the various Workflows and associated request types in Kintana/PPM that will be used in order to implement the project management process.
• Deployment of various changes, enhancements and developments to production and stage environment.
• Providing support to user defects/enhancements and delivered solutions within the given SLA.
• Carrying out root cause analysis of the bugs and troubleshooting problems faced by user of the application.

Environment: Oracle 10g,SQL plus, TOAD,HP PPM,HP Quality Center, Windows XP, XML,HTML, Kintana Package Deployment.

Confidential

Role: -Informatica PL/SQL Developer

Responsibilities Include:

• Understanding the functionality of existing application to facilitate incorporation
• Offuture enhancements.
• Involved in creating various technical design specification documents and unit test cases.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Designed and developed mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Involved in creation and loading of Metadata.
• Used Repository manager to create user groups and users, and managed users by setting up their privileges.
• Created events and tasks in the work flows using workflow manager.
• Created sessions and work flows for loading the data from source to target database and monitored the status of workflows using Workflow Monitor.
• Applied rules using transformations like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
• Created Mapplet and used them in different Mappings.
• Unit test the data mappings and workflows and fix issues effectively within given delivery time.

Environment: Informatica Power Center 7 Repository Manager, Designer, Workflow Manager, Workflow Monitor ,Flat Files, DB2, UNIX, PUTTY,Windows XP.