PROFESSIONAL SUMMARY:

• Over 6 years of IT experience in the Analysis, Design, Development, Administrating Client/server application using Microsoft SQL Server and BI suite Experience in design and development of Enterprise Data warehouse and Data Mart .
• Expert level skills in Data Mapping, Table Normalization, Optimization and Performance Tuning.
• Expert in writing T - SQL queries with DDL and DML commands, complex stored procedures, indexes, triggers and views.
• Worked under Agile environment.
• Experience in writing complex T-SQL queries using Joins, Functions.
• Expert in handling Source Control tools like Visual Source Safe (VSS), Subversion, Team Forge and Team Foundation Server (TFS).
• Optimized the performance of queries with modifications in T-SQL queries, and eliminated redundant and inconsistent data.
• Worked extensively on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC).
• Worked extensively on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Experience in Extracting, Transforming and Loading the data using SSIS in visual studio 2013/2012/2010/2008 and used to load the data from various sources (Excel, Flat file, DBs) to MS SQL server.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from various sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Look up, merge join and union all.
• Experience in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Strong Experience in creating Drill down, Drill through, parameterized, Cascade parameterized, Sub reports, Charts and Snapshots using SSRS based on Relational and Multidimensional databases.
• Deploy reports, secure access, and schedule execution of reports and deliver them to the Web using reporting manager, Share Point, email recipients, file shares, and more, on a scheduled basis.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, partition and aggregation using SQL Server Analysis Services.
• Experience in building dimensional cubes with SSAS and querying the data with MDX script.
• Excellent hands on experience in scheduling SQL Server Agent Jobs for database Backups, Restoration and Disaster Recovery Procedures and implementing Backup strategies.
• Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
• Played an important role in improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Highly committed, motivated and a natural team player with strong analytical ability.

TECHNICAL SKILLS:

RDBMS/ Database: SQL Server 2005/2008/2008 R2/2012, MS-Access XP/2007, Sybase, ORACLE 10g/9i, PL/SQL

Reporting tools: SQL Server (SSIS, SSAS, SSRS), Crystal Reporting 10.0, Tableau 9.0

Data Modeling: Microsoft Vision 2000, Erwin 7.3

Languages: T-SQL, PL/SQL, C#.NET, ASP.NET, XML, VB.NET, Visual Basic 6.0

GUI: Visual Studio.Net, Visual Studio 6.0

SQL Tools: IDERA Performance Monitor, SSMS, SQL Profiler, DTS, Database Tuning Advisor DTA, IDERA SQL Backup.

Scripting Languages: Shell scripting, Perl Scripting

Operating Systems: MS-DOS, Windows XP/NT/Vista/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS, TX

Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement.
• Implemented Agile development methodology, this lead to collaborating with different teams in informing weekly progress on the project.
• Customizing and generating multiple TFS reports to serve company needs.
• Data migration (import & export) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator SSIS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSIS.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated various reports like Matrix reports, Tabular reports, and Chart reports, link Reports, Drill down reports. Prepared AD HOC reports through report builders.
• Generated reports using Expressions and Functions using SSRS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.

Environment: Windows 8, MS SQL Server 2012, PL-SQL/T-SQL, Business Intelligence Development Studio (BIDS), SSIS,SSRS, SSAS, Oracle 10g/9i, MYSQL, MS Excel, VB Script, XML, Net (Asp .Net,VB.Net, C# .Net), Team Foundation Server (TFS), Visual Studio 2010.

Confidential, Minnetonka, MN

Sr. MS SQL(SSIS/SSRS)

Role & Responsibilities:

• Primarily responsibilities include Data extraction and Reports development for Client applications.
• Dynamically supported business users for given requirements and developed the Packages and Reports accordingly.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Deployed and configured the reports in the Report Server.
• Generated Dashboards with Quick filters, Parameters and calculated sets to handle views more efficiently using Tableau.
• Created parameters (multivalve, hidden, default etc...) and cascading parameters for the required fields using the report designer in order to see the dropdowns in the end report.
• Involved in database design process and data modeling process for the application using Erwin.
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE’s, Triggers etc. according to the Requirements.
• Involved in Knowledge Transfer to the peers, Documenting of all the Business logic insuring maintenance is easy for the Peers and Responsible for conducting code reviews in my team.

Environment: Windows 7, MS SQL Server 2008R2/2012, PL-SQL/T-SQL, Business Intelligence Development Studio (BIDS), SSIS,SSRS, Tableau 8.0, Oracle 10g/9i, MYSQL, MS Excel, VB Script, XML, Net (Asp .Net,VB.net C# .NET), Erwin 7.3, Team Foundation Server (TFS).

Confidential, MO

SQL/BI Developer

Responsibilities:

• Supported development staff about database related issues.
• Transferred data between Development, Testing and Production databases.
• Created SSIS Packages to import different forms of health care claims data files from external contractors and export to SQL server tables.
• Analyzed the Data quality, Data validating, Data mapping on claims specific data.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database with SQL server Export Utility.
• Developed OLAP cubes using SSAS and defined measure groups for the functional analysis.
• Generated MDX queries to create calculated measures that meet business requirement.
• Created and deployed reports and report models for internal and external customers and support their specific requirements using SSRS.
• Deployed the SSRS reports in Microsoft office share point server.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Used Normalization techniques to create and modify data model.
• Designed DDL/DML queries and other database objects including triggers, stored procedures, indexes and view to manage database.
• Created views and stored procedures for front-end application.

Environment: MS SQL Server 2008R2, MS Visual Studio 2008, Windows 7, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, Sharepoint, T-SQL.

Confidential

SQL Developer

Role & Responsiblities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Installation and configuration of MS SQL Server 2005 .
• Created Drill down reports, Ad-hoc Reports and Drill through reports using SSRS .
• Optimized SQL statements for customer summary reports.
• Created Tables, indexes and constraints.
• Created T-SQL stored procedures, functions, tables, views and SQL joins and other statements for various applications, maintained referential integrity and implemented business logic.
• Client side implementation and testing.
• Created backups for databases.
• Partly involved in Performance Tuning.
• Monitored user accounts, user permissions and backup.
• Migrated from MS SQL Server 2005 to 2008
• Involved in analysis and Design Documentation, User Requirements and maintained good documentation.

Environment: MS SQL Server 2008/2005, SSRS, T-SQL, Crystal Reports, MS Access, MS Excel, HTML, XML, MS PowerPoint.