PROFILE SUMMARY:-

• Proficient in writing PL/SQL Packages, Stored Procedures, Triggers and Cursors. Developed various applications, using Oracle built-in packages.
• Over 7 years of experience in Information Technology Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL,SQL Developer, SQL PLUS.
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
• 3 years working in agile development environment.
• Extensively used Oracle Analytical functions like ROW NUMBER, FIRST VALUE.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, Code Review, coordinating user training and user testing, Project demonstration, Implementation, Maintenance.
• Experience working with Production and Development environment.
• Design and Development of PL/SQL scripts and stored procedures using mapping documents to transform and load data into Oracle database
• Developed Forms Reports using Oracle Forms Reports 10g/11g.
• Optimized Queries using Explain Plan, Oracle Hints Performance tuning
• Experience in Database query tuning, Performance tuning Explain Plan and TKPROF utility of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems
• Developed scripting jobs using Unix shell scripts for scheduling, transforming and loading data into Oracle database.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL.
• Have experience on backend systems running Oracle Databases and working with large database.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Strong skills in data mapping for the Slowly Changing Dimensions SCD1, SCD2 Flagging, Time Stamping and Version , and SCD3.
• Experience in developing Strategies for Extraction Transformation Loading ETL mechanism using INFORMATICA tool.
• Implemented ETL mechanism using PL/SQL procedures, functions, triggers and ad-hoc scripts.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Experience in extracting Data from COBOL files,XML files and other Flat files and integration and loading data into the OLAP system.

Technical Skills

Databases: Oracle 10g / 11g, MS Access, Oracle Forms and Reports

DW Tools: Informatica Power Center 8.6

Languages: SQL, PL/SQL, Java

Applications: Microsoft Office Word, Excel, PowerPoint.

Operating Systems: UNIX, Windows XP / 7

Web Technologies: HTML, CSS, DHTML, XML, SOA/BPEL

Scripting Languages: UNIX Shell Scripting, JavaScript

Database Tools: TOAD, SQL Plus,SQL Loader

Data warehouse Schema: Star Schema, Snowflake Schema

Version Control: SVN, Mercurial Tortoisehg

Incident Change Management: BMC Remedy, JIRA, SPIRA

Professional Experience

Confidential

Role: Oracle BPEL Developer

Responsibilities:-

• Involved in System Analysis, Design, Coding, Development and Implementation
• Change coordinator for implementing all changes deployed to Production environment.
• Worked closely with Business Analyst to create the Migration mapping document from Oracle to Salesforce systems.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader DDL scripts
• Designed Forms for generating Delivery Complaints request for Subscriptions using Oracle Forms10g.
• Extracted data from source systems using Data Extraction tools and loaded the data using SQL Loader
• Written SQL queries Sub queries and Join conditions , PL/SQL programming for different modules with the help of both Onsite and Offshore team.
• Developed stored procedures, views, DDL triggers, cursors and user defined functions
• Expert in analyzing/troubleshooting and providing technical support for Oracle applications and their interfaces
• Promoting code from QA/UAT environments to Production using Change Management tools like BMC Remedy and JIRA
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Developed Dynamic Queries using Execute Immediate.
• Copying of data from production to system test and development by using DB LINKS
• Involved in unit testing and system testing while the code is moved to production
• Helped BI team to create the views which can be used for their reporting purpose.
• Created Mappings and Workflows using Informatica
• Worked on transformations like Lookup, Filter, Expression, Aggregator, Router, Source Qualifier, Sorter, Sequence Generator, Rank, Lookup, Normalizer etc.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load them into the OLAP system.

Environment: - UNIX, J2EE platform, Oracle 11g/10g/9i, PL/SQL Stored Procedures, Packages, Triggers, REF Cursors , Informatica 8.6

Confidential

Role: Oracle Developer

Responsibilities:-

• Created Clean up Scripts for correcting data and eliminating synchronization errors occurred due to Migration.
• Change coordinator for implementing all changes deployed to Production environment.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader
• Designed Forms for generating Delivery Complaints request for Subscriptions using Oracle Forms10g.
• Written SQL queries Sub queries and Join conditions , PL/SQL programming for different modules with the help of both Onsite and Offshore team.
• Developed stored procedures, views, DDL triggers, cursors and user defined functions
• Expert in analyzing/troubleshooting and providing technical support for Oracle applications and their interfaces
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Copying of data from production to system test and development by using DB LINKS
• Involved in unit testing and system testing while the code is moved to production
• Promoting code from QA/UAT environments to Production using Change Management tools like BMC Remedy and JIRA

Environment:- Unix , J2EE platform, Oracle 11g/10g/9i ,PL/SQL Stored Procedures, Packages, Triggers, REF Cursors, Collection Objects

Confidential

Role: Oracle Developer

Responsibilities:-

• Involved in System Analysis, Design, Coding, Development and Implementation
• Front-end Subscription Request form was developed using a java based tool namely Ciboodle.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader
• Designed Forms for generating Delivery Complaints request for Subscriptions using Oracle Forms10g.
• Written SQL queries Sub queries and Join conditions , PL/SQL programming for different modules with the help of both Onsite and Offshore team.
• Developed stored procedures, views, DDL triggers, cursors and user defined functions
• Expert in analyzing/troubleshooting and providing technical support for Oracle applications and their interfaces
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Developed Dynamic Queries using Execute Immediate.
• Copying of data from production to system test and development by using DB LINKS
• Involved in unit testing and system testing while the code is moved to production
• Helped BI team to create the views which can be used for their reporting purpose.
• Created Mappings and Workflows using Informatica
• Extensively used Star Schema for the ETL process.
• Worked on transformations like Lookup, Filter, Expression, Aggregator, Router, Source Qualifier, Sorter, Sequence Generator, Rank, Lookup, Normalizer etc.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load them into the OLAP system.

Environment:- Unix , J2EE platform, Oracle 11g/10g/9i ,PL/SQL Stored Procedures, Packages, Triggers, REF Cursors , Oracle Forms and Reports 10g,Informatica 8.6

Confidential

Role: Oracle Developer

Roles Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Designed forms for raising a voucher request using Oracle Forms10g.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Worked on transformations like Lookup, Filter, Expression, Aggregator, Router, Source Qualifier, Sorter, Sequence Generator, Rank, Lookup, Normalizer etc
• Created Mappings and Workflows using Informatica and used STAR SCHEMA
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Generated reports of SOA based Subscription using OLAP techniques.

Environment:- Unix, J2EE platform, Oracle 10g/9i, PL/SQL Stored Procedures, Packages, Triggers, REF Cursors , Oracle Forms and Reports 10g,Informatica 8.6

Confidential

Role: Oracle Developer

Responsibilities:-

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation Designing and developing data models.
• Developed various backend application programs such as Views, Functions, Triggers, Cursors, Procedures and Packages using SQL and PL/SQL
• Responsible for creating functions to be used for calculations. Written database triggers for monitoring the data migration
• Developed algorithm and PL/SQL code for efficient retrieval and manipulation of complex data sets using PL/SQL packages
• Written PL/SQL procedures and functions while migrating the data from the source legacy systems to the Oracle.
• Extracted and transformed source data from different database like Oracle, SQL Server and flat file into oracle.
• Developed packages for ETL purpose in data warehouse environment, to extract data from the production systems
• Created and modified database objects like tables, views, and constraints
• Implemented business logic using stored procedures to increase performance
• Tuning the SQL statements by creating indexes
• Created stored procedure and function in PL/SQL to increase the performance of Forms on web server

Environment:- Oracle 10g/9i, SQL PLUS, PL/SQL developer, MS SQL server 2005, TOAD, FTP, Unix, Oracle Enterprise Manager OEM , Unix Shell Scripts, Windows XP/2000

Confidential

Role: Oracle Developer

Responsibilities:-

• Participation in weekly design reviews and walkthroughs with project manager and development team
• Using Swing Concepts in Java Front End Forms were designed.
• Worked on database design with the team
• Writing PL/SQL code using the technical and functional specifications
• Generated SQL and PL/SQL scripts to install create database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
• Developed complex queries to retrieve the data
• Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers
• Documented business rules, functional and technical designs, test cases, and user guides.
• Involved in the debugging and error handling
• Monitored the database growth on daily basis. Established backup and recovery strategies
• Performed Tuning by creating Indexes. Used TOAD, PL/SQL developer tools for faster application development
• Measured the performance of the shell scripts by getting the expected results
• Prepared test cases for testing procedures. Involved in unit testing and Integration testing of the Modules
• Involved in Production support and Maintenance.

Environment:- Oracle 10G/9i, SQL, PL/SQL, Developer/2000 Forms 6i, Reports 6i, Graphics 6i , Designer, Discoverer, SQL Plus Reports, SQL Loader, Windows XP, Toad

Confidential

Role: Oracle Developer

Responsibilities:-

• Involved in System Analysis, Design, Coding, Development and Implementation.
• Creation of database objects like Tables, Views, Materialized views, Procedures and Packages using Oracle tools like PL/SQL, SQL Plus
• Written SQL queries Sub queries and Join conditions , PL/SQL programming
• Created Records, Tables, Objects, Collections Nested Tables and Varrays , and Error Handling
• Written stored procedures, functions and packages for application development.
• Developed SQL, PL/SQL programs to keep the Master and lookup tables up to date on a daily basis.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers, cursors and user defined functions.
• Automating data loading, extraction, report generation using PL/SQL coding.

Environment: - Windows XP, Oracle 8i, Developer 2000, and PL/SQL, SQL developer