SUMMARY

• 10+ years of extensive Oracle, MSSQL database developer experience
• Experience in Database Design, Development, conversion in client/server OLTP environment
• Expert in Extraction, Transforming and Loading (ETL) data flows using PL/SQL, DataStage 7.0
• Extensive experience in writing complex SQL and PL/SQL programs Stored procedures, User defined Functions, Packages, Triggers for back end development
• Experience in Performance Tuning usingExplain plan,SQL Traceand various types ofHints, Partitioning of Tables and Indexes.
• Expertise in Oracle advanced features like Ref Cursors, Bulk Collections, Native Dynamic SQL, DBMS SQL, Analytic functions and PL/SQL Collections.
• In - depth knowledge of Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Stored Procedures, Collections, Ref Cursors, Constraints, Triggers, B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Export/Import Utilities.
• Worked in many Software Development Life Cycle (SDLC), performing process-planning, documentation, functional and system design, implementation, unit, integration, regression testing, and system maintenance.
• Exposure to Customized Iterative Development Life Cycle as part of product development
• Experienced in data modeling, designing, and data analysis with Conceptual, Logical and Physical Modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Involved in Data Profiling and Data Mining
• Experience in creating Autosys JIL scripts
• Expertise in requirement analysis and design
• Worked as single point of contact for onsite - offshore coordination and SME
• Strong analytical, technical, project management, communication and presentation skills.
• Experience working on multiple projects simultaneously
• Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Excellent team worker, self-motivated, quick learner and always eager to learn new technologies.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux and Windows 2003/XP/7

Databases and Tools: Oracle 9i/10g/11g, SQL Server 2005, TOAD, PLSQL Developer

ETL Tools: DataStage 7.0, SSIS

BI Tools: SSRS

Languages: SQL, PL/SQL, T-SQL, Perl, UNIX Shell Scripting, C, Java

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Scheduling Tools: Autosys

Database Modeling Tools: ERWIN

Version Control: SVN, CSV

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Database Developer

Responsibilities:

• Project requirement analysis and technical design document preparation
• Development of PL/SQL Functions, Procedures and Packages using advanced concepts like Collections, Advanced Queuing, DBMS SQL
• Development of Autosys jil scripts and identifying run window to schedule batch jobs
• Involved in different stages of data conversion projects (Data mapping, Coding, Data reconciliation, Testing)
• Production support activities for batch processing involving PL/SQL, Autosys jobs, Perl Unix shell scripts, NDM
• Involved in data extraction project using PL/SQL, Perl and Autosys
• Onsite-Offshore team coordination
• PL/SQL performance tuning and SQL query tuning

Environment: Oracle 11G, Java, Perl, PowerBuilder, Autosys

Confidential, Rockville, MD

Data Analyst

Responsibilities:

• Interacted with the SMEs at the bank site to identify the data sources for extraction
• Involved in Data Analysis (Data profiling and Data minimg) and preparation of data extraction scope
• Involved in analyzing the source databases and developing complex SQL queries to extract data in desired format
• Involved in creating perl scripts to extract data in the desired format
• Involved in identifying and working with open source tools required to extract data
• Single point of contact for Onsite - Offshore coordination and task allocation
• Involved in mentoring new team members
• Used recursive CTEs, CTE, temp tables for data Extraction and data Transformation
• Created complex UDF and stored procedures to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Created PL/SQL packages to Extract, Transform and Load data from source systems to Staging Area
• Used PL/SQL Records and Collections for effective data manipulation.

Environment: MSSQL, Oracle 11G, Java, Perl, Excel, Access, Open Source tools

Confidential, Minneapolis, MN

Database Developer

Responsibilities:

• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc,
• Created PL/SQL packages to Extract, Transform and Load data from source systems to target systems
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the stored procedures and SQL objects and also Modified already existing stored procedures, views, indexes depending on the requirement.
• Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.
• Tuned PL/SQL programs for better performance
• Used BULK COLLECT for multiple row processing
• Provided documentation about database structures and Updated functional specification and technical design documents

Environment: Oracle 10g, PL/SQL, SSIS, SSRS, SQL Server 2008, Windows, Linux

Confidential

Database Developer

Responsibilities:

• Involved in project review meetings along with Java developers and understanding their requirements
• Involved in Creation of Views, Stored procedures, PL/SQL, T-SQL Functions, Packages.
• Requirements gathering from Clients and implement the back end changes in existing product and in designing the database
• Involved in SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Installed, configured and maintained the multiple databases in development, testing and Integration environments
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O
• Used PL/SQL Records and collections for Data correction
• Providing development team with DML scripts based on their requirement
• Streamlining Test Data and customer specific data
• Provided documentation about database structures and Updated functional specification and technical design documents

Environment: Java, Oracle 9i/10g, SQL Server 2005, Windows, Linux

Confidential

Database Developer

Responsibilities:

• Requirements gathering from Clients and implement the back end changes in existing product and in designing the database
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements
• Created Platform independent schema structure so that the product data can be implemented in any database
• Developing PL/SQL, T-SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules
• Tuned and optimized queries by altering database design, analyzing different options and indexing strategies

Environment: Java, Oracle 9i/10g, SQL Server 2005, Windows, Linux

Confidential

ETL Developer

Responsibilities:

• Used Data Stage Designer to develop Jobs for extracting and transforming data and creating sequential files
• Constructed shared containers
• Used hashed file stage as a lookup stage
• Designed and developed job sequences for server jobs
• Involved in job reviews
• Involved in unit testing

Environment: Data stage 7.0, Oracle 9i, Windows, UNIX.