SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System and ETL architectures.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Ref Cursor, Triggers, Views, Materialized Views, Temporary Tables and PL/SQL Web - services.
• Extensively used QUEST Tools (Toad Navigator) and SQL*Plus.
• Extensive experience in identifying performance issues, debugging and Performance Tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF and Oracle code coverage utilities.
• Experience in Dimensional Modeling, writing ETL Stored Procedures and Informatica.
• Strong experience in Data warehouse concepts.
• Expertise working on Data Modeling and Design of Database.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in designing & developing application using JavaScript, HTML, XML and CSS.
• Expertise in Client-Server application development using Oracle 10g/11g, SQL, PL/SQL and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, Query Re-write and Transportable tablespaces.
• Written complex SQL queries using Joins, Sub Queries and Correlated Sub Queries.
• Experience in Oracle supplied packages, Dynamic SQL and PL/SQL Tables.
• Loaded Data into Oracle Table using SQL Loader and External Tables.
• Experience in dealing with different data sources ranging from Flat files and CSV.
• Ability to work on agile projects.
• Experience in on-call 24*7 support in production environment even during off-hours.
• Excellent trouble shooting, debugging and error trapping skills.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows2000, Windows NT, Windows 95 & MS-Dos, UNIX(Sun Solaris)

Software / Applications: MS XP, MS 2000, MS Word, MS Excel, MS Access, PowerPoint

Programming Languages: SQL, PL/SQL, Unix shell scripts, JavaScript, HTML, XML, CSS, C and C++.

Database: Microsoft Server 2005, Oracle 10g &11g.

Data warehouse Tools: ETL Scripting, Informatica Powercenter (7.1.3/8.6.1).

Tools used: SQL*Plus, DB Artisan 8.7.6, PLSQL developer, SQL Developer, SQL*Loader, Oracle11g Enterprise Manager, Toad, Oracle Developer Suite, Microsoft SQL Management Studio, Perforce, Oracle Data Integrator 11g version 11.1.1

Tuning Tools: TKPROF, EXPLAIN PLAN and HINTS

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, Arizona

Oracle PL/SQL Developer

Responsibilities:

• Configured and designed Entity Relationship Diagram (ERD) with Data Design team to illustrate the logical structure of the database.
• Developed Procedure, Package, and Functions to update and maintain the database.
• Wrote PL/SQL Procedure & Triggers to validate database records.
• Developed Stored Procedures and Complex Packages using PL/SQL for maintaining Patient Information.
• Created Stored Procedures for Batch Processing and also involved in moving large data using Bulk Insert for all methods.
• Developed Complex SQL Queries using various Joins and developed Dynamic SQL (Sub Queries and Correlated sub queries, Join Conditions).
• Development using Forms 10g.
• Perform ETL Testing by validating data.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and TKPROF.
• Extensively using Hints to direct the optimizer to choose an optimum Query Execution Plan.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in development and Production environment in PL/SQL and SQL*Plus.
• Optimized the Query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.
• Created Documentation of development code and the test cases involved.
• Designed database tables using various normalization techniques and database rules.
• Followed all processes and procedures for application deployment for new as well as existing
• Design, develop and conduct unit test plans for ensuring application code is functioning correctly.
• Debugging and fixing production data.
• Review meeting with the manager, architect and team to discuss day-to-day task and backlogs.

Environment: Oracle 11g, Toad, SQL*Plus, SQL Developer, SQL*PLUS, SQL*LOADER, Forms 10g, SVN, GitHub, UNIX Shell scripts

Confidential

Senior PL/SQL Developer

Responsibilities:

• Developed database Tables, Triggers, Cursors, Procedures, Functions and Packages to meet business requirements.
• Extensively used Ref cursors, PL/SQL Collections and Dynamic SQL.
• Assisted with performance tuning of SQL queries and fixed the slow running queries in production with utilities like Explain plan and Trace.
• 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 gathering and analyzing requirements for the component assigned to me.
• Work with data architect to make sure the table creation and related objects are developed as per the requirement.
• Worked on SQL*Loader to Load data from Flat files obtained from various facilities every day.
• Created Package to migrate data across various environments.
• Created and used HTML for data management and transmission.
• Created views to pull data from Staging area and load into Data Warehouse tables.
• Created DBMS SCHEDULER enables scheduling and automated execution of PL/SQL blocks, stored procedures, and external procedures and executables.
• Analyzing data in target DB.
• Involved more in performance tuning.

Environment: Oracle 11g, SQL Developer 4.0, PLSQL Developer, HTML, SQL*Plus, Windows 7.

Confidential

Senior PL/SQL Developer

Responsibilities:

• Developed database Tables, Triggers, Cursors, Procedures, Functions and Packages to meet business requirements.
• Created database Packages, Procedures, Functions, Triggers, Views, Materialized Views using Oracle PL/SQL in 11g.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Analyzing performance of database objects and suggesting DBA for Indexes, Schema gathering, Partitioning, Explain Plan and HINTS.
• Used SQL*Loader and export/import mechanism for data migration for Bulk upload.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Implemented PL/SQL to perform application security and Batch Job Scheduling.
• Implemented DBMS XMLGEN package to converts the results of a SQL Query to a canonical XML format.
• The package takes an arbitrary SQL query as input and converts it into XML format, and returns the results as a CLOB.
• Generated Dynamic web-reports using HTML and XML.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQL TUNE.

Environment: Oracle 11g, SQL Developer, SQL*Plus, Web Services, HTML, XML, JavaScript, Windows 7.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in the entire life cycle of the project starting from requirements gathering to the end of system integration.
• Designed and developed various PL/SQL scripts to meet the business requirements.
• Designed physical and logical data models for star and snowflake schemas.
• Wrote sequences for automatic generations of unique keys to support Primary and Foreign key constraints in data conversions.
• Developed and modified Triggers, Packages, Procedures and Functions for data conversion and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using Cursors and Exception handling.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Identified the Entities, attributes and designed a relational database system.
• Interacted with DBA to discuss database design and modeling, index creations and SQL tuning issues.
• Used SQL*Loader to load the database from flat files.
• Converted Data stored in flat files into Oracle tables.
• Developed stored procedures using Oracle to automate the data loading process.
• Involved in unit, regression, performance and integration testing of Database jobs.
• Involved in post-production process handling tickets for any production issues.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walkthroughs among various teams and documenting the process.

Environment: Oracle 11g, SQL Developer, PLSQL Developer 7.1, SQL* Plus, Windows 7.