SUMMARY

• 11+ years of total experience in IT industry and in production support of various business applications using Oracle SQL and PL/SQL,Informatica,SSAS, SSRS.
• Worked extensively on various RDBMS like Oracle 11g/10g/9i/8i.
• Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, Ref), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.
• Proficient in Oracle tools and utilities such as PL/SQL Developer, SQL Developer, SQL Navigator.
• Extensive experience in performance monitoring and tuning in Oracle.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Proficient in transforming data from various sources (flat files, mainframe,Oracle) to Data warehouse usingSQL*LOADER and External table.
• Experience in Sql server analysis services and reporting services 2008.
• Experience in Informatica.
• Handled new cube and reports requests from business units.
• Having knowledge in Tableau and Qlikview tools.
• Experience in production support, fixing production bugs and handled enhancements requested from business users.
• Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Experience in creating Batch jobs, daily jobs, one time jobs
• Excellent team player, self-motivated, will create excellent work environment around.
• Good communication, Analytical and presentation skills. Ability to provide timely solutions and work within specific time frames.
• Willingness to learn new technologies/tools.

TECHNICAL SKILLS

Reporting Tools: SSAS 2008, SSRS 2008, Tableau, Qlikview

Database: Oracle 8i, 9i, 10g, 11g.

DB Utilities: SQL*Loader, Export/Import, DBMS SQL, UTL FILE, DBMS Package.

ETL tools: Informatica 8.0

Languages: SQL, PL/SQL

Operating Systems: UNIX, Windows NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, TX

Module Lead

Responsibilities:

• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.
• Created stored procedures, Functions to facilitate the functionality for various complex modules.
• Optimized and fine-tuned the SQL queries by using Explain plan.
• Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.
• Designed and Developed and maintained the complex oracle scheduler chains for the load process.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Designed, developed and maintained Sql server analysis services cube to meet business needs.
• Developed and maintained Sql server reporting services reports based on business requests.
• Supporting the production environments 24/7, fixing the defects and high priority bugs.
• Responsible for performing code reviews and code fixing after identifying the Defects.

Environment: Oracle 11g R2, SQL Navigator, UNIX, Windows 7. SQL Loader, EXPLAIN PLAN, SSAS 2008,SSRS 2008

Confidential

Oracle PL/SQL Developer/Analyst

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.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Created Data Structures including Tables and Views, and applied referential integrity.
• Participated in designing of data conversion/interface with the use of SQL*Loader.
• Created Triggers, Stored Procedures, Packages and SQL Scripts.
• Worked in the Production Support team and fixed high priority bugs.
• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
• Performed unit testing and integration testing for various development applications in ORACLE 10g.

Environment: Oracle 10g, PL/SQL, SQL Developer, Windows XP, Clear Case

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Developed various Complex Queries, Views for Generating Reports.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
• Optimizing database objects and streamlining applications.
• Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.

Environment: Oracle Database 9i, Informatica, UNIX, Pro*C, SQL, PL/SQL, SQL Developer, Clear Quest, Clear case

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
• Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQLDeveloper.
• Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer
• Developed and deployed the Reports using Oracle Reports.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.

Environment: Oracle 9i/10g, SQL Developer, Oracle Reports & Forms 6i/9i, PL/SQL, EXPLAIN PLAN