SUMMARY

• Over 9 years of experience in IT, designing and developing oracle based applications.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Extensive experience in writing SQL queries, PL/SQL procedures, functions, packages, triggers, exception handlers, cursors, collections, PL/SQL tables in 11g, 10g, 9i, 8i and 7i.
• Expert in Performance Tuning, SQL Tuning, Data optimization, query optimization, UNIX Shell Scripting in UNIX environment and Unix Cron Shell scripting and job scheduling.
• Proficient in Data modeling using Erwin and logical and physical database design.
• Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.
• Well verse with Explain Plan, SQL*Trace and TKPROF for high efficiency.
• Strong skills in using ETL, Datastage tools like Informatica Power Center 6.0/5.1 and Power Mart 5.1/5.0/4.7 (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Oracle Warehouse Builder (OWB), OBIA/OBIEE.
• Proven ability to plan co - ordinate and implement Full Life Cycle Software Development and Maintenance projects.
• Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical, technical, problem sloving and interpersonal skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, SQL SERVER 5.0, DB2 7, MS Access 2005

ETL Tools: Informatica (Power Center 7.x/6.2/5.1, Power Mart 7.x/6.2/5.1), Power ConnectMS Visio, Datastage

Reporting tools: Siebel 8.0/7.8, Cognos

Operating Systems: UNIX (Sun Solaris, HP Unix, LINUX), Windows 95/98/2000, WIN XP

Data Modeler: Erwin 4.1.4, 4.0

Version Control: Star Team 2009/2008, PVCS Tracker 6.8

Bug Tracking tools: Test Director 8.0, Bugzilla, Mercury Quality Center 8.2, Axosoft OnTime Defect Tracker 2009/2008

Languages: SQL, PL/SQL, UNIX shell scripts, HTML, DHTML, C, C++, XML

Utility Tools: Toad 10.1/ 9.7, SQL * Plus 10.1, SQL-Navigator 6.2

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD (Business Requirement Document) that provides detailed information about the requirements.
• Created/Modified Informatica ETL, Datastage mappings in various stages folders like Staging area and production area for development and production environment that transfers data from SQL Server, Oracle Source systems to Oracle Target system.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Provide resolutions to time-sensitive ad-hoc requests for information from management.
• Optimization of SQL queries, and performance tuning by using Explain plan and Analysis.
• Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality.
• Responsible for Unit level testing, Module level testing and Application testing.
• Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures.
• Wrote Informatica ETL, Datastage design documents, establish ETL, Datastage coding standards and perform Informatica mapping reviews, Oracle Warehouse Builder (OWB), OBIA/OBIEE.
• Provided production support and resolved production issues in a timely and efficient manner.
• Ensure smooth execution of Incident Management, Problem Management, Change Management, Release Management and Availability Management.
• Involved in the ASM/AD activities on the PACTS requirements.
• Maintaining and updating the process documents related to the project, procedural documentations
• Involved in Development, testing, and release management for the PACTS releases.
• Monitoring and management of the applications in the Solaris box. This is to ensure the 24*7 online - as part of maintaining the availability management.

Environment: Oracle 11g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 10.1, UNIX, Solaris, Linux, Red hat Linux, Shell Scripting, Windows, Informatica (Power Center 7.x/6.2/5.1.

Confidential, Knoxville, TN

Oracle PL/SQL Developer

Responsibilities:

• Worked with business analysts to understand the business requirements and created technical requirements document.
• Responsible for development activities at the back-end side as well as actively participated in analysis and designing part.
• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Identifying performance bottlenecks, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Developed code using advance features of 10g such as Regexp *, analytical functions, used UTIL package and functionality to send emails to team members and department about the progress of conversion every hour.
• Provide resolutions to time-sensitive ad-hoc requests for information from management.
• Optimization of SQL queries, and performance tuning by using Explain plan and Analysis.
• Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality.
• Responsible for Unit level testing, Module level testing and Application testing.
• Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures.
• Designed the ETL, Datastage processes using Informatica to load data from Sybase, Oracle, Flat Files, XML Files and Excel files to target Oracle Data Warehouse, Oracle Warehouse Builder (OWB), OBIA/OBIEE.
• Provided production support and resolved production issues in a timely and efficient manner.

Environment: Oracle 10g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 10.1, Informatica (Power Center 7.x/6.2/5.1.

Confidential, San Diego, CA

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD (Business Requirement Document) that provides detailed information about the requirements.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Developed Unix shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Involved in the development of Informatica mappings, sessions and workflows.
• Configured and managed Informatica Repositories using Informatica administrator console, Oracle Warehouse Builder (OWB), OBIA/OBIEE.
• Conducted meeting with System Analyst to explain the application functionality.
• Involved in 24 x 7 production support for any adhoc or hot fix requirements.

Environment: Oracle 9i, SQL, PL/SQL, Erwin 4.0, SQL*Plus, SQL*Loader, UNIX, Windows XP.

Confidential, Omaha, NE

Oracle PL/SQL Developer

Responsibilities:

• Involved in logical data modeling, including developing and maintaining data model diagrams (E-R Diagrams), implementing physical designs, and facilitating data model requirements gathering
• Worked in PL-SQL code tuning System Analysis, Design, Coding, Testing, Development and Documentation
• Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases.
• Involved in the creation of new users and controlling and administering the access privileges to Informatica Power Analyzer.
• Created and maintained all database objects such as Tables, views, indexes, sequences, constraints, procedures, functions.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Data warehouse, Oracle Warehouse Builder (OWB), OBIA/OBIEE, Datastage
• Designed and Developed Triggers and Packages using PL/SQL
• Created indexes on tables and Optimizing Stored procedure queries
• Wrote Scripts for batch processing and data loading using SQL*Loader
• UNIX Shell Scripts for cron jobs and batch programs to generate reports.
• Used ERwin as the data-modeling tool to re-engineer the existing database, to define relationships, implement business rules as constraints

Environment: Informatica 6.2, Oracle 9i/8i, PL/SQL, SQL*Loader, Erwin and Windows 2000

Confidential, Los Angeles, CA

Database Developer

Responsibilities:

• Involved in user requirement and requirement specification from users for outbound calling and Campaign Management modules
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse, Oracle Warehouse Builder (OWB), OBIA/OBIEE.
• Documenting business requirements, functional specifications and test requirements.
• Participated in logical and physical database design and developed the logical dimensional model(s) using Erwin 4.0.
• Optimized and tuned SQL and PL/SQL script using EXPLAIN PLAN and TKPROF.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL, Datastage processes.
• Wrote loader scripts using SQL Loader to load large tables.
• Developer to develop mappings and design workflows.
• Involved in development and unit testing of Informatica Power Center mappings and Workflows.
• Implemented Performance Tuning logic on Mappings, Sessions and Data loading using SQL*loader, to provide maximum efficiency and performance.

Environment: Oracle 9i, Toad, SQL*Loader, UNIX Shell Scripts, Windows XP, Erwin 4.0.