SUMMARY

• 8 Years of extensive IT experience as a Microsoft SQL Server Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs.
• Strong knowledge of Transact - SQL (DDL, DML).
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
• Experienced in using Try Catch block in SQL Server 2005/2008.Query Optimization and Tuning.
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experienced in creating Databases, Tables, Stored Procedure, Views, User defined functions, Cursors and Indexes using T-SQL.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Created many complexSSISpackages with complicated transformationslikeLookup, Derived Column, ConditionSplit, Multicast, Sort, Union All, Cache Transform, and ConditionalSplitetc.
• Great Expertise in Creating and managing event handlers, Package Configurations, Logging, Check points, Package Securities, User Defined Variables and Incremental Loads for SSIS Packages.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascaded Reports, and Sub Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Good experience in Designing Partitions and Aggregations in SSAS.
• Knowledge in creating groups, hierarchies and measures, KPIs.
• Experienced in deploying created reports in various sources like Web browser, XML and PDF.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012, MS SQL Server 2008, MS SQL Server 2005

ETL Tools: SSIS 2012, SSIS 2008, SSIS 2005

Reporting Tools: SSRS 2005, SSRS 2008, Crystal Reports

Programming Languages: C, C++, T-SQL, PL/SQL, UNIX, VB.NET

Operating Systems: Windows 7/Vista/2003/XP

IDE: Visual Studio 2008/2005/2003

Object Oriented Tools: MS Visio

Utilities/Applications: MS-Word (00/07/XP), MS-Excel (00/07/XP), MS-PowerPoint (00/07/XP)

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, Michigan

SSIS/SSRS/SQL Developer

Responsibilities:

• Involve in complete Software Development Lifecycle (SDLC).
• Analyze user requirements, functional and technical specifications, preparing test plans and write test cases.
• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
• Created Cross-Tabs, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. Deployed RDLs to Report Server (Share Point).
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Involve in Unit testing, Integration testing and System testing.

Environment: Microsoft SQL Server-2008/2012, Visual Studio-2008/2010, T-SQL, Team Foundation Server, SQL Server Analysis/Integration and Reporting Services, Share Point 2010/2013.

Confidential

MSBI Developer

Responsibilities:

• Created Database Objects Schemas, Tables, Triggers and Constraints.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Developed Complex Packages to load data into Stageand Data Ware House systems.
• Developed SSIS packages usingLookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columnswith Multiple Data Flow tasks.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created XMLPackage Configurations,Error Handling usingEvent Handlersfor On Error, On Warning, and On-Task Failed Event Types.
• Extracted Data from Database tables to different file formats (Pipe, CSV, Tab, Tilde, Fixed Width)
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily, weekly, Semi Monthly, Monthly and Annual Loads.
• Created Maintenance Plans and setup log files to monitor jobs.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Performed documentation of standards, best practices, and ETL procedures.

Environment: Microsoft SQL Server 2012/2008/2005 , MS Access, SSAS,SSIS, SSRS, HTML, Visual Studio 2005/2008/2010 , IIS, Sybase 12.0,Query Analyzer,, ERWIN, Windows server 2008R2, DTS, TSQL, .Net, SQL Profiler, DTS, Team Foundation Server, CITRIX, CISCO Any Connect, Visual Source Safe

Confidential, Dallas, Texas

SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Design and implementation of stored procedures and triggers for automating tasks.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created Functions, Stored Procedures, Database Triggers.
• Created checks and constraints to maintain data integrity.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of the application.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

Confidential, Houston, TX

SQL/MSBI Developer

Responsibilities:

• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
• Performing Replication (snapshot and transactional).
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: SQL Server 2000/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access.

Confidential

Associate Analyst

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Involved in the entire System study, analysis and Design.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Installation, configuration of MS SQL Server 2000 for development and testing purpose
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases, using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server.

Environment: MS SQL Server 2000, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.