SUMMARY

• Around 8 years of experience as SQL Developer with specialized skills in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).
• Experience in designing, installation, configuration, monitoring, troubleshooting and migration SQL Server 2005/2008/2008 R2/2012.
• Acquainted in all the phases of SDLC involving systems analysis, design, development and implementation.
• Well - versed in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Performance Tuning, Query Optimization and Validation issues.
• Proficient in writing complex SQL queries involving multiple tables inner and outer joins, temporary tables, table variables.
• ExcellentT-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Common Table Expressions, and Triggers.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Involved in Huge data migrations, transfers using utilities like SQL Server Integration Services (SSIS).
• Experienced in using Business Intelligence Development Studio (BIDS), Graphical User Interface (GUI) to design SSIS (SQL Server Integration Services) packages for Data Management applications.
• Expert in Data Extracting, Transforming and Loading (ETL) using SSIS tool.
• Experience in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Scheduling the SSIS packages using SQL Agent Jobs.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Knowledge in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2008 R2/2012.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily reports.
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in Various versions of Tableau
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, scatter plots, pie charts and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes.
• Experience in creating, quick filters, data source filters, global filters, context filters.
• Created email subscriptions for data driven reports by using Report Manager.
• Effective team player thrives with in group environments.
• Ability to work in fast-paced environment with excellent analytical, inter-personal, problem solving and communication skills.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Macintosh

RDBMS: MS SQL Server 2012/2008/2008 R2/2005, MS Access 2010/2007/2003 , Oracle 11/10g/9i/8.0, IBM DB2.

Languages: T-SQL, PL-SQL, MDX, C, C++, VB.NET, C#.NET, ASP.NET, ADO.NET, UML, HTML

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligence Development Studio (BIDS), Crystal Reports9.0, MS Office 10/07/03, Visual Source Team Foundation.

Designing Tools: MS Visual Studio and MS Visio.

Web Services: XML, CSS, HTML

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Tableau

PROFESSIONAL EXPERIENCE

Confidential, SAN ANTONIO, TX

SQL Server BI Developer

Responsibilities:

• Experience in writing Complex SQL queries, triggers, views, constraints, joins, DDL, DML and user defined functions to implement the business logic.
• Created complex Stored Procedures using various joins and common table expressions (CTE) and created Indexes to for efficient query performance.
• Experienced in creating instance/database level change data capture to track changes to tables.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Used various control flow tasks like FTP, Bulk insert task, Execute SQL task etc. and different data flow tasks.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File, XML etc. and vice versa.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL.
• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Created user defined functions using joins and cursors as required for SSIS packages.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Resolved complex issues and Error Handling in SSIS.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created and scheduled SQL agent jobs to run SSIS packages and stored Procedures as required.
• Experience in working creating Multidimensional cubes using SSAS.
• Used Multidimensional Expressions to query the data from the Cubes.
• Generated Report Models using Model Designer, to enable the business users to build ad-hoc reports using Report Builder.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports using SSRS 2012.
• Extensive experience on building Analytic Dashboards using Tableau.
• Deep experience with the design and development of Tableau visualization solutions by developingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Created action filters, calculated fields for preparing dashboards and worksheets in Tableau.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Generate Ad-Hoc reports as per the client requirements using Report Builder.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.

Environment: MS SQL Server Management Studio(SSMS) 2008/2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Tableau Desktop9.0/9.2, MDX, C#.net, VB.net

Confidential, CHICAGO, IL

SQL Server BI Developer

Responsibilities:

• Creating application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and UDF (User Defined Functions) according to the requirements of the project.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Monitored and tuned SQL scripts for performance.
• Used Inner joins, Outer joins and other Complex joins for data retrieval from complex tables.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Enhanced the Query performance using Cluster and Non Clustered indexes.
• Improved the performance by reducing the usage of the cursors.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Extracted data from heterogeneous sources and transferred to OLAP using SSIS.
• Migrated data from legacy system SQL Server database using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Created packages using different data sources (SQL Server, Flat Files, Excel files, etc.), loaded the data into staging tables and wrote complex Stored Procedures to load data into Target tables
• Used MDX to work with and retrieve multidimensional data in SQL Server Analysis Services(SSAS)
• Experience in using different kinds of gauges and indicators in creating reports using SSRS designer.
• Developed various complex reports using charts, parameterized reports, linked reports and sub reports using SSRS.
• Created drilldown, tabular and parameterized reports.
• Developed custom reports and deployed them to Report Manager using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008, Windows XP, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, MS Access, VB.NET, C#.NET, SQL Profiler.

Confidential, CHICAGO, IL

SQL BI Developer

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Adept at debugging stored procedures using SQL Server Profiler.
• Worked with various XML data and worked on creating ETL packages with loading all package in loop and loading them in SQL server.
• Created SSIS packages to retrieve data from various data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target 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.
• 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.
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services (SSIS), T-SQL, SQL Server Reporting Services (SSRS), Dashboards, Windows Server 2003/2008, C#, ASP.Net, Visual Basic 6.

Confidential

SQL Server Developer

Responsibilities:

• Created new views, wrote stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when an SSIS process failure or success.
• Data migration (import & export - BCP) from Text to SQL Server.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.

Environment: MS SQL Server 2005/08, T-SQL, MS Office, and Windows sever 2003; Win forms, Microsoft Visual Studio, MS Office 2003