SUMMARY

• Over 7+ Years of software development life cycle experience in Software Design, Development and Implementation of SQL and PL/SQL.
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Extensive experience in writing SQL Queries, Stored procedures, Functions, Packages, Database triggers.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN and hints.
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing SQL code, modifying database query.
• Extensively worked in Client - Server application development using SQL, PL/SQL, T-SQL, SQL Server 2008/2010/2012 , SSIS 2010/2012, SSRS 2010/2012.
• Experience in the Analysis, Design, Development, Testing and Implementation of business application systems.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Extensive experience in data migration techniques using SQL* Loader, Import/Export, bulk and batch processing.
• Experienced in SDLC data analysis, data modeling, development, testing and documentation of projects.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Improve the performance of the slow SQL queries by implementing proper Index.
• Experience in Installing Software’s and Configuring Databases.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Possess good communication skills and quick learning ability.
• Experience in Production Support and troubleshooting data quality and integrity issues.
• Experience in creating Batch jobs, daily jobs, and one time jobs.
• Experience in writing technical design documents and organizing code reviews.

TECHNICAL SKILLS

Database Tools: SQL Server 2008/10/12, SQL * Loader, TOAD, Oracle SQL Developer, SQL Tool, SQL*Plus, SSIS, SSRS, SSAS.

Data Modeling Tools: Erwin, Microsoft Visio

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming Languages: Unix Shell Scripting, XML, C, C++,Java, HTML, XML, COBOL, CICS, JCL

Environment: Windows, Unix, MS DOS, ZOS

PROFESSIONAL EXPERIENCE

Confidential, Burnsville, MN

Database Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Used SSIS to unite data from existing system and performed transformations on MS SQL.
• Extract Transform Load (ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS).
• Generated drill down and drill through reports using SSRS.
• Created cubes using SSAS.
• Developed SSIS packages with Error Handling.
• Experience in using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Bulk inserted data from huge files to different destination tables in SQL server using SQL Server Integration Services (SSIS).
• Wrote many TSQL Stored procedures to perform specific tasks as per the requirements.
• Performed debugging on various Stored Procedures to handle errors.
• Developed different kind of reports such as charts, matrix, graphs, etc.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created enterprise conceptual data model to capture business concepts and their relationships for Claims.
• Converted logical data model to physical data model, using domains and standard abbreviations, created indexes, generated DDL.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Environment: MS SQL Server 2008/2012, T-SQL, SSAS, ERWIN, SSIS, SSRS, SQL*Plus, MS-Office, Confidential Compare, Oracle SQL Developer, Toad, SVN.

Confidential, Frederick, MD

Database Developer

Responsibilities:

• Created database objects like tables, views, indexes, stored procedures, Packages using SQL.
• Involve in database development by creating SQL Functions, Procedures, Packages, Performance tuning.
• Exposure to SQL Loader and ETL concepts in a data warehousing environment with large volume databases.
• Loaded data from Source to destination using different format file like Text file, OLDB file, Excel file in SSIS.
• Used different toolbox like Fuzzylookup, Merge, Union, and Union All and so on in SSIS.
• Created Reports and modified existing report in SSRS.
• Created Matrix and Table Report in SSRS.
• Closely Worked with Business, Testing and DBA team.
• Worked on UAT and Production Issues.
• Exposure to data modeling concepts in a RDBMS environment.
• Built physical data structures like tables, views, constraints & Indexes.
• Document design specifications and architecture using Microsoft Office.
• Develop code, SQL loader scripts to load data in the custom tables.
• Designed and developed skills using SQL Server, SSIS, SSRS, and SSAS.
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.

Environment: SQL Server 2012, SQL *Plus, MS-Office, T-SQL, Confidential Compare, SVN, SSIS 2012, SSRS 2012, Toad, Visual Studio, Windows, Unix.

Confidential, Chicago, IL

Database Developer

Responsibilities:

• Involved in database development by creating SQL Query, SQL Functions, Procedures, Triggers, Packages, Performance Tuning, Records and Collections.
• Worked Closely with QA and DBA Team. Based on Requirement to Modify the code.
• Involved in application enhancements according to user requirements.
• Designed Oracle workflows for automation of business processes.
• Worked on ETL tools using SSIS, SSRS, and SSAS.
• Corrected the data using Fuzzy lookup and Fuzzy Grouping in SSIS.
• Merge two or more file using union and union all.
• Created report either tabular or matrix format in SSRS.
• Built physical data structures like tables, views, constraints & Indexes.
• Documented design specifications and architecture using Microsoft Office.
• Developed TOAD, SQL loader scripts to load data in the custom tables.
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.

Environment: SQL Server 2012, SQL Loader, Visual Studio, Toad, Confidential Compare Tool, QC 11(ALM), SSIS 2012, SSRS 2012, MS-Office, MS Visio, Erwin, UNIX/Linux and Windows.

Confidential, Grand Rapids, MI

Database Developer

Responsibilities:

• Installed and configured DB and its components successfully by working closely with DBA in DEV and PROD.
• Installed and configured Oracle Portal for development, testing and production instance.
• Created virtual library for source code and converted different types of source code format as per the requirement.
• Involved in database development by creating SQL Functions, Procedures, Records and Collections.
• Worked on Claims, Facets and Plans.
• Involved in application enhancements according to user requirements.
• Designed Oracle workflows for automation of business processes.
• Implemented Designer2000 exclusively for SDLC process and Dataflow Diagrams.
• Built physical data structures like tables, views, constraints & Indexes.
• Documented design specifications and architecture using Microsoft outlook, Microsoft Excel.
• Developed TOAD, SQL loader scripts to load data in the custom tables.
• Sorted the data using Sort toolbox in SSIS.
• Transferred the data using FTP toolbox in SSIS.
• Configured oracle reports and crystal reports with internet information services (ISS).
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.
• Documented design specifications and architecture using Microsoft outlook, Microsoft Excel.

Environment: SQL Server 2008/10, SQL Loader, SVN Tool, MS-Office, Crystal Reports XI, SSIS 2010, SSRS 2010, Data Modeling, UNIX/Linux and Windows.

Confidential, MA

Database Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to develop interfaces.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Worked with SQL loader and control files to load the data in different schema tables.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Created database objects like tables, views, Stored procedures, Packages using Oracle Utilities like PL/SQL, SQL* Plus, Toad.
• Designed and developed complex forms and crystal reports as per the client’s requirement in Oracle 10g/11g.
• Implemented RDBMS concepts in Data modeling.
• Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP.
• Used Exception Handling extensively to display the error messages in the application.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: SQL Server 2008, SSIS, SSRS, .Net, C#, SQL *Plus, MS-Office, Crystal Reports XI, Toad, Windows.

Confidential

Database Developer

Responsibilities:

• Designing Tables, Views, Cursors, Triggers according the requirements given in the design document.
• Writing code for stored procedures, functions according to the requirements.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Executing the scripts and inserting data into the tables.
• Used SQL*Loader to load the database from flat files.
• Adding constraints, updating and altering tables according to the changes in the design documents.
• Documentation of Tables and Views.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.

Environment: Windows, Oracle SQL Developer, C#, .Net, SQL Server, Toad, SQL *Plus.