SUMMARY

• Over all 5+ years of experience in Database Design, Development and Implementation of MS SQL SERVER 2005/2008/2008 R2/2012 with Business Intelligence tools MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS).
• Experienced in Installing, Upgrading, Managing, Configuring, Migrating and Troubleshooting of MS SQL Server and Database.
• Supported an internal team of Developers, Designers and Test Engineers.
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experienced with Large - scale relational databases.
• Knowledge of normalization/de-normalization of database tables, developing (DDL) and (DML) and building referential integrity for the (RDMS).
• Performed database development and maintenance tasks.
• Designs and develops databases structures, scripts, transformation (ETL) scripts and common components.
• Good understanding of ACID properties and Locks.
• Understanding of data warehousing concepts such as Cubes, Fact Table, Dimensions Table, OLTP, OLAP.
• Experienced in writing Queries, T-SQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.
• Experienced in sub queries, joins involving multiple tables.
• Experienced in Clustered and Non Clustered indexes on Tables.
• Experience in creating Parameterized Reports, Drill through and Drill Down reports, Tabular reports, Linked Reports, Sub-Reports using MS SQL Server Reporting Services.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Working experience in using version control tools likeVisual Source Safe (VSS) and Team Foundation System (TFS).
• Experience in designing and developing SSIS packages for loading data from Oracle, text files, Excel, Flat files to SQL Server database.
• Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
• Experience in creating packages for migration of the data from one source to different destination using SSIS and Handling error with Event handler using SSIS.
• Experience in the design, development and implementation of RDBMS using SQL.
• Quick Learner, Analytical, Problem Solving, and Time Management Skills.
• Excellent communication skills, both verbal and written.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows7, Windows Server 2008t

Databases: SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, MS Access, ORACLE, MS Visio

Database Tools: Business Intelligence Development Studio, Data Transformation Service (DTS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS )

ETL Tools: SQL Server Integration Service (SSIS)

Languages: SQL, T-SQL, PL/SQL,C#,VB.NET, .NET

Reporting Tools: SQL Server Reporting Service (SSRS)

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL Developer

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Individually designed MS SQL Server 2008/2008R2 database, coded stored procedures (T-SQL).
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Worked with various XML data and worked on creating ETL packages with loading all package in loop and loading them in SQL server
• Created package with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into Confidential tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
• Created temporary tables and table variables while creating complex queries in SQL Server 2008/2008R2.
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Designing, developing, implementing, and maintaining reporting frameworks.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Built SSRS reports from various heterogeneous sources like SQL Server.
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Used Team Foundation Server (TFS) for the purpose of version Control and source code maintenance needs.
• Creating Ad-hoc reports using Report Builder.
• Adept at rebuilding indexes on various tables.
• Optimized the SQLs and Informatica mappings which handled millions of records
• Adept at debugging stored procedures using SQL Server Profiler.
• Restored QA server from development periodically to test the queries on the QA server.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, TFS, SSAS, Windows Server 2008, Informatica 9.1, Erwin 7x.

Confidential, Fort Worth, TEXAS

SQL DEVELOPER/BI DEVELOPER

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008R2
• Designed ETL packages with the different sources as Flat Files, Excel, Text files, CSV Files, MS Access, Oracle and XML files and migrating the data into SQL Server using SQL Server Integration Services (SSIS)
• Extensively worked on T-SQL code to create datasets
• Involved in developing Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Worked with PL/SQL in oracle database which was read only, specially writing a Select queries and load that data into SQL Server 2008 R2 tables using SSIS.
• Created SQL Server SSIS packages (ETL) to upload data to the database objects.
• Scheduled jobs to run the SSIS packages on daily basis and monthly basis using SQL Server Agent.
• Implemented Checkpoints, to rerun the failed package from the point of failure.
• Implemented Event Handlers in SSIS packages
• Designed and developedSSIS Packages (dtsx files)to import and export data fromMS Excel, ORACLE 10g and Flat files
• Working on Work Items in Team Foundation Server (TFS).
• SSIS packages to update tables with daily data/monthly data and automated it through scheduled jobs for the beginning of every day and month.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, CSV Files and Oracle
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS, using various features like data conversion. Created derived columns from the present columns for the given requirements.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Environment: SQL Server 2008 R2, Windows Server 2007, Windows 2008 Server, SQL Server BIDS, Oracle, MS Access 2003, MS Access 2010, TFS, SQL Profiler, SSIS, SSRS, SSAS.

Confidential, Plano, TX

SQL SERVER DEVELOPER

Responsibilities:

• Developed different objects like functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Strored Procedures for the DataSet to build the reports for the client requirements.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Performance tuning, and optimization of procedures and queries.
• Used DBCC commands for Database maintenance (Rebuilding Indexes).
• Installation and configuration of SQL Server 2008 R2
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2008 and Flat files.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Experienced in participating meetings with business users to gather the requirements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2008/2008R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),T-SQL, Microsoft Office 2010, OLAP, Oracle, ASP.Net, VB.net, MS Visio.

Confidential, SCHAUMBURG, IL

SQL DEVELOPER

Responsibilities:

• Participated in designing and normalizing the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.
• Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.
• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Experience in deploying and scheduling the reports based on quarter, month, and year reports.
• Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).
• Developed, monitored and deployed SSIS packages.
• Worked on Excels to upload the data from excels to database.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).
• Implemented Event Handlers in SSIS packages
• Implemented Checkpoints to rerun the failed package from the point of failure.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Oracle, MS Excel, Windows XP.