PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Design, Modeling, Development, Implementation and Support of SQL Server 2000/ 2005/2008/2008 R2/2012.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence (SSIS and SSRS).
• Expertise in data models, data flows and data dictionaries.
• Good knowledge of Normalization and De - Normalization techniques.
• Experience in SQL Server scripting- Stored Procedures, Triggers, User-defined Functions (UDF’s), Views, indexes and constraints.
• Experience in tuning Stored Procedures, T-SQL Queries and SSIS Packages.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Microsoft Visual C# in script component of SSIS.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Very good experience in working with several types of reports including drill-down, drill through, sub reports, tablix, matrix, charts, graphs, Power view, Excel PowerPivot and front end UI application dashboard portals.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Expertise in creating various Parameterized, Linked, Drill-through, Drill-down and Ad-hoc reports.
• Excellent knowledge in Dimensional Modeling using Kimball methodology, Star/Snowflake Schemas and ODS.
• Good experience with Database Tuning Advisor, Performance Monitor and SQL Profiler for tracing and auditing.
• Experience in SQL administration activities like installation, configuration, maintenance, backup and restore of SQL Server databases.
• Extensively used Team Foundation Server (TFS), Visual Source Safe and Tortoise Subversion.

TECHNICAL SKILLS:

RDBMS: SQL Server 2005/2008/2008 R2/2012, Oracle, Teradata, MS Access, Sybase

Database Tools: SQL Server Management Studio, MS Access, MS Excel, Query Editor

Programming Languages: T-SQL, PL SQL, C#, VB.NET, HTML and Shell Scripting

Reporting Tools: Crystal Reports XI/X, SQL Server Reporting Services

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services

BI Tool: Business Objects, SSIS and SSRS

Data Modeling: ER-Win, MS- Visio 2003/2007

Operating Systems: Windows 2000/2003/XP/Vista/2007

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL/SSIS/SSRS Developer

Responsibilities:

• Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
• Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Maintained all the SQL documents including installation and data conversion Procedure documents.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 20012.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Deployed the SSIS Packages to the MSDB as well as File System based on the requirements.
• Designed ETL Packages with Microsoft SSIS 2012 to pull data from various sources like DB2, SQL Server, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages to run sequentially using SQL Server Agent job and windows Scheduler.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• ETL process was documented for future s.
• Created complex SSIS packages using various transformations.

Environment: MS SQL Server 2008R2/2012, BIDS (SSIS, SSRS), T-SQL, C#, Share Point Portal Server, Windows Server 2008, Erwin, Oracle, Visual Studio.NET 2010.

Confidential, Louisville, KY

SQL/SSIS/SSRS Developer

Responsibilities:

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation and maintenance.
• Managing physical database design & creation, devising strategies for backups, recovery & fine-tuning.
• Tuning SQL statements and rendering support for MS SQL tool-sets and utilities.
• Responsible for monthly releases and production support.
• Extensively working with off shore team and coordinating the workflow based on everyday Project Status.
• Modifying database programs to increase processing performance, referred to as Performance tuning.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created robustSSISpackages with row counts, verifications, notifications, security and production servers, ftp, compress txt files, indexing and table constraints.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLEDB Source (Oracle), Excel Spreadsheet to SQL Server 2008R2.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Defined and developed Report Structure withdata definition, report layout and report definition language.
• Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience inSharePoint & Performance Point Servers.

Environment: MS SQL Server 2008R2, SQL/SSIS/SSRS, C#, T-SQL, Agile, Visual Studio.NET 2008, Oracle, .XML, SharePoint 2010, MS Office.

Confidential, Dallas, TX

SQL/SSIS/SSRS Developer

Responsibilities:

• Extensively involved in designing the SSIS packages to export flat file source to SQL Server database.
• Created necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using (SSRS).
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Enhancing the SSIS Packages and deploying from development server to production server.
• Worked with T-SQL to create Tables, Views, triggers and stored Procedures.

Environment: SQL Server 2008, Query Analyzer, SQL/SSIS /SSRS, Visual Studio.NET, ProClarity Server, XML, BizTalk, MS Excel, Oracle.

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered functional requirements and designed the technical specifications
• Designed logical/physical data models and defined primary key, foreign key using Erwin tool.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Experienced in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Developed stored procedures, functions, views and triggers.
• Experienced in development of extracting, transforming and loading (ETL), maintenance and support of enterprise data warehouse system and corresponding marts
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Experienced with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experienced in generating reports using linked reports, sub reports and filters in SQL server reporting services (SSRS).
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Designed Star Schema and Snow flaked schemas in the process of data modeling.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: UNIX, Shell Scripting SQL/SSIS /SSRS, VB.NET, Enterprise Manager, SQL Profiler, DTS, T-SQL, Oracle, BCP, Replication

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Designed, implemented and administrated SQL Server 2000 databases.
• Created and Modified Stored Procedures, Triggers, Views according to the business.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Created indexes, constraints and rules on database objects.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experienced in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.NET, Windows 2000, MS Access, MS Excel.