PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in analyzing, designing and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MSSQL Server Integration Services(SSIS), Analysis Services(SSAS)and Reporting Services (SSRS).
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services(SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS).
• Worked extensively on Extraction, Transformation, loading (ETL) data from Oracle, SQL Server, DB2, Teradata, Access, Excel, Flat Files and XML using DTS and SSIS Services.
• Configured SSIS packages using package logging, Breakpoints, Checkpoints and Event handler to fix the errors.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Expertise in Creating, Configuring and Fine - tuning ETL workflows designed using SSIS of MSSQL Server.
• Extensive Knowledge in creating SSIS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Technical skills include MS SQL Server 2012, T-SQL, MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft Excel, SDLC, RDBMS, Data Ware
• house & Data Modeling concepts.
• Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User defined Functions, views, indexes, query writing and SQL joins.
• Knowledge in Creating Star Schema and Snow Flake Schemas.
• Experience in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for monitoring & tuning server performance, Performance Tuning and Query Optimization.
• Good knowledge on how to design and deploy rich Graphic Visualizations Parameters using tableau.
• Knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines. 
• Experience at transforming and validating data using SQL Server Integration Service (SSIS)Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Knowledge in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects. Deft at using MDX (Multi-Dimensional Expressions) queries to retrieve data from multi-dimensional SSAS Cubes.
• Experience in designing complex reports including sub reports, parametric, drilldown, drill through, cascading and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Expert in Experienced in sorting the data, defining subtotals for the reports.
• Proficient in using global variables, expressions and functions for the reports.
• Expert in handling sub reports in SSRS 2005.
• Experience in Reporting Services (SSRS) 2008/2012.
• Goal-oriented and highly motivated team player with excellent analytical, troubleshooting, problem solving and presentations skills; ability to work independently or collaboratively to accomplish critical business objectives .

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Languages: C, T-SQL, .Net, Visual Basic.

Operating Systems: Windows Server 2003, Windows 2000 advanced Server, Windows NT/95/XP.

Databases: MS SQL Server 2012/2008/2005/2000 , MS Access 97/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Scripting: HTML, DHTML, XML.

Reporting Tools: SSRS, SSAS, Crystal Reports, Tableau.

Data Modeling: Visio 2007 and Erwin 4.1

Application Packages: MS Outlook

WORK EXPERIENCE:

Confidential, Seattle WA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Performing query plans and making sure each query is using appropriate useful Indexes.
• Understanding the report design Requirements and Constraints.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Deployed the created SSIS packages in Development and Testing environments.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Developing and maintaining ETL jobs for the Data Warehouse using SQL Server Agent.
• Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed Custom/Conditional formatting reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Created Adhoc reports and data exploration using Power View.

Environment: MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, Microsoft Visual Source Safe, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Office 2007.

Confidential, Cupertino, California

SQL BI Developer

Responsibilities:

• Worked on enterprise solutions development with rapid SDLC Agile Methodologies, SCRUM.
• Created packages using SSIS for data extraction from Flat files, OLEDB to SQL server using ETL tool.
• Designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Moved the static data from various text files to SQL Server 2012 DB using Import Export Wizard.
• Developed SSIS packages not only for initial data loads but also for incremental/delta loads.
• Created log tables to capture the SSIS events and used it to perform debugging of the packages.
• Generated the data validation report in SQL server reporting services (SSRS).
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Ad-hoc reports, Cascading reports, Drill down reports.
• Created user groups in Report Manager for limited access to the users in SSRS.
• Involved in unit testing of SSIS packages, query verifications in SSRS.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Maintaining the documents and packages in Team Foundation Server as a version control.

Environment: MS SQL Server 2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Team Foundation Server, MS Excel, MS Visio.

Confidential, Plano Texas

SQL BI (SSRS/SSIS/SSAS) Developer

Responsibilities:

• Tuned the Database to increase the performance for the faster retrieval of the data.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Used SQL Profiler to view Indexes performance to eliminate table scan.
• Used T-SQL to produce desired results for users.
• Developed multiple join statements to retrieve data from several tables.
• Developed T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Experience monitoring the Change Data Capture Process.
• Involved in all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Created SSIS process design architecting the flow of data from MS Access to MS SQL Server 2005.
• Created ETL (.DTSX files) packages using SSIS to Validate, Extract, Transform and Load data to Data warehouse databases, Data mart databases.
• Designed ETL SSIS packages to process data to target databases.
• Coordination with off shore teams in testing.
• Extracting data from Oracle Source.
• Extensively worked on SSRS 2008.
• Expertise in creating cascading parameters, expressions, filters, charts, tabular reports, matrix reports in SSRS 2008.
• Extensive worked on Tablix control reports in reporting services
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure on levels of reports.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2, SQL Server Integration Services 2008 R2, SQL Server Analysis Services 2008 R2, MS Visio 2007, Windows 7/ Vista and T-SQL.

Confidential, Denver, CO

SQL/BI Developer

Responsibilities:

• Created SSIS packages to transfer data across heterogeneous data sources.
• Upgraded database tables from 2000 to SQL 2005 and SQL 2008 to 2012 SQL environment.
• Created complex Stored Procedures for data retrieval.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS).
• Developed standard reports, sub reports and charts using crystal reports.
• Extensively worked on converting of crystal reports to SSRS reports.
• Optimized performance of various SQL scripts, stored procedures and triggers by using CTEs and System stored procedures.
• Created triggers, views, tables, and generated TSQL script for application.
• Analyzed execution plan and optimized queries by creating indexes.
• Created linked servers to fetch data from Oracle.
• Created user defined functions in SSRS using VB script.
• Experience in Power View and Power Pivot.
• Deployed SSRS reports on Microsoft office SharePoint (Moss).
• Wrote complex T-SQL queries and Stored Procedures for the reports
• Created standard report Subscriptions and Data Driven Report Subscriptions.
• Tested the data with complex queries, joins and sub queries.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: SQL Server Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, T-SQL, ODBC, Excel, Access, Windows 2000/ XP.

SQL Developer/DBA

Confidential

Responsibilities:

• Designed and created SQL Database, tables, indexes, and views based on user requirements.
• Created User Defined Functions, cursors, and Triggers.
• Created & used stored procedures for database transactions in SQL Server.
• Created tables, views, clustered & non-clustered index, user defined data types and functions.
• Developed stored procedures and views for managing efficient data retrieval.
• Wrote various Stored procedures for application development
• Developed backup & restore scripts for SQL Server as needed.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used multiple join statements to retrieve data from multiple tables.
• Worked in the team for gathering and analyzing the needs of end user requirements.
• Worked in enhancing the bug/issue tracking system used by the entire team, to produce flexible reporting with respect to the life cycle of an issue.

Environment: MS SQL Server Enterprise Edition, MS Access, MS Excel, DTS, SQL Profiler, PL/SQL.