SUMMARY

• Over 5 years of experience in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, Oracle Data Integration and Unix Shell Scripting.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies.
• Worked extensively with Dimensional Modeling (Data Marts, Facts and Dimensions), Data Migration, loading high volume of data, Data Cleansing, ETL Processes.
• Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling.
• Experience in Performance tuning and debugging for Extraction Transformation and Loading (ETL) Processes like Ab - Initio and Informatica.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Materialized Views, Views, Cursors, Collections (Nested tables and Varrays), Records, Object types and Database Triggers.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications; refine conceptual systems design requirements into the technical design.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.
• Energetic, highly motivated individual, with excellent Analytical and Communication skills (Oral and Written), an effective team player and team builder.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS-SQL Server 7/2000, MS Access

Scripting: SQL, PL/SQL, UNIX Shell Scripting

Languages: C, C++

Reporting Tool: Business Objects, Crystal Reports

ETL Tool: Ab-Initio, Informatica

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus, iSQL * Plus

Operating Systems: HPUX, Solaris 7.0/8.0,MVS, Windows 2000/NT/XP, Window 95/98UNIX, LINUX 9.2/9.3

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point

Other Tools: SQL*Loader, MS-Visio, MS Project Professional 2003, PVCSVSS

PROFESSIONAL EXPERIENCE

Confidential, Reston VA

Sr Oracle PL/SQL Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Designed and developed the Packages, procedures, functions efficiently in loading, validating and cleansing the data. Also worked on creating users and roles as needed for the applications.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
• Used my strong experience to program in PL/SQL batch environment utilizing large database tables and high transaction throughput requirements.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Gained experience in Database migration, replication and conversion. Also had hands on experience in using ODI to load oracle tables from DB2 database.
• Worked on Windows Batch scripting and scheduling jobs and monitoring logs.
• Developed applications to automatically send the process logs and alerts the business users and data source group.
• Worked on Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Created Developer’s Documentation and User’s Manual.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.

Environment: Oracle 10g/11g,PL/SQL, SQL Loader, SQL*Plus, Windows NT 4.0/2000/XP and UNIX.

Confidential, Silver spring, MD

Sr. Oracle PL/SQL Developer

Responsibilities:

• Extensively Involved in Performance tuning and Optimization of the SQL queries.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes and also performed code debugging using TOAD
• Set up batch and production jobs through Autopsies.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages
• Created UNIX Shell Scripts for Informatica feeds and to execute Oracle procedures.
• Designed processes to extract, transform, and load data to the Data Mart.
• Worked with Business Users to gather requirements for developing new Reports or Changes in the existing Reports.
• Designed and developed Reports according to user specification. Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL used in Reports and Files to improve performance drastically.
• Used various transformations like aggregator, Update strategy, Lookup, Expression, Stored procedure Filter, Source Qualifier, Sequence generator, Router, Update strategy etc.

Environment: Oracle 9i, Oracle Reports 6i, SQL, PL/SQL, TOAD, Unix, ETL, Informatica Power Center 6/5.x, PVCS Version Manager, Exceed, Test Director.

Confidential

Oracle Developer

Responsibilities:

• Worked closely with architects, designers and developers to translate data requirements into the physical schema definitions for Oracle.
• Creating SQL and PL/ SQL scripts, calling C external routines from within PL/ SQL for transfer of data between the databases.
• Tuning Database and SQL scripts for Optimal Performance, Redesign and build the schemas to meet Optimal Performance measures.
• Developed Stored Procedures, Functions, Packages and Triggers using SQL, PL/ SQL and maintained the scripts for various data feeds.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Created UNIX Shell Scripts for automating the execution process.
• Involved in preparing documentation and user support documents.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i, SQL*PLUS, SQL, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000.