SUMMARY

• 7+ years of experience in IT, as Software Engineer in Data Warehousing with SQL and PL/SQL development activities
• Hands on experience using query tools like TOAD, SQLDeveloper and PLSQLdeveloper
• Working experience in AGILE methodology for software development.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Experience in Tuning SQL Statements and PL/SQL Procedures for enhancing the load performance of applications in various schemas across databases.
• Expertise in using SQL utility tools: TOAD, SQL*PLUS, SQL Developer and SQL navigator.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries.
• Having experience in ETL processes and Interfaces, mapped the columns and load the data from source systems by using ODI (Oracle data integrator),SQL* Loader.
• Good experience of end to end ETL design and Development, Transformation and Loading in a complex, high-volume environment.
• Good experience in Oracle Database Integrator and Control-M Scheduling tool.
• Strong problem solving & technical skills and significant experience in 24/7 Production Environment Support.
• Excellent analytical, interpersonal and communication skills to assimilate new technologies and tools.
• Excellent ability to work in groups as well as independently.

TECHNICAL SKILLS

ETL Tools: Oracle Database Integrator (ODI), Ab Initio & SQL Server Integration Services (SSIS)

Database: Teradata V12, Oracle 11g, Microsoft SQL Server, MySQL

Reporting tools: Cognos BI, Microstrategy

Language: C, SQL, PL/SQL

Operating Systems: Windows XP, Windows 2007, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior PL/SQL developer

Responsibilities:

• Designed/developed/Modifiedtables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexesto improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tablesto handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocksby analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such asViews, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
• Performed Unit test, System integration test to make sure the deliverables are match with business requirement

Environment: Oracle 11g, PL/SQL, TOAD, UNIX

Confidential, Rochester, MN

Oracle developer

Responsibilities:

• Creating PL/SQL Stored Procedures, Functions and Triggers
• Coding according to the mapping sheet and debugging the code.
• Oracle Application Performance Tuning and SQL Query Tuning.
• Data Migration Using SQL Loader
• Client interaction.
• Reviewing the test scripts and involved in preparing technical specification documents.
• Unit Testing

Environment: Windows/XP, UNIX, PL/SQL, TOAD, UNIX and Oracle9i

Confidential, Ann Arbor, MI

PL/SQL developer

Responsibilities:

• Extensively involved in writing procedures, functions, triggers and packages
• Involved in Analyzing and Performance Tuning of the SQL queries using optimizer hints for joins, parallelism and Explain plan.
• Involved in Unit Testing the codes.
• Involved in debugging and fixing the codes that had performance issues.
• Worked with the Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Used SQL*LOADER to store data in the Oracle database from different types of flat files.
• Provided support in SIT/UAT phases of the project.
• Coordinated with various project stake holders for delivery.

Environment: Oracle10g, SQL, PL/SQL, TOAD, SQL*LOADER, UNIX, Oracle Reports 10g, Linux.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developing highly complex applications using Oracle 11g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Utilized SQL*Loader to load flat files into database tables.
• Used PL/SQL developing to load data from the source table to the target table based on the business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Responsible for performance tuning activities in oracle.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Used Materialized Views in order to improve the performance.
• Proposed and coded enhancements on Oracle PL/SQL

Environment: Oracle Database 11g, TOAD, PL/SQL, Oracle Application Express 4.2, UNIX (Solaris), PUTTY.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created many Generic Stored Procedures, Functions, Database Triggers, Packages, Tables, Indexes, Views, Synonyms, Sequences using SQL and PL/SQL.
• Extensively used PL/SQL programming in back end and front end Functions, Procedures, and Packages to implement business logics/rules.
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Analyzed the system requirements and performed logical and physical design of the database.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
• Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
• Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Analysis, Development, Testing and Implementation using Oracle 11g/10g.

Environment: Oracle 11g, Oracle performance tuning, SQL* loader,SQL, TOAD, PL/SQL.