SUMMARY

• 8+ years of IT industry experience in database design, development & maintenance for various applications using SQL server, MS Excel, MS Access, C#, and related domains.
• 6+ years of experience in Microsoft SQL Server 2005/2008/2012 and providing Business Intelligence solutions using SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) in Finance, HealthCare and Retail domains.
• Efficiently halped in teh Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Hands on experience on teh whole ETL (Extract Transformation & Load) process.
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, My SQL, flat file, Text Format Data).
• Experience wif T SQL (DDL and DML) in constructing tables, user defined functions, views, complex stored procedures, relational database models, data dictionaries, data integrity and appropriate triggers to facilitate efficient data manipulation and consistent data storage.
• Experience in report writing using SQL Server Reporting Services(SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in creating dashboard reports using SQL Server Reporting Services(SSRS), Report Model and ad - hoc reporting using Report Builder.
• Experience in developing SSRS reports using J Query.
• Experience in writing expressions in SSRS and expert in fine tuning teh reports.
• Good understanding of Data Modeling including ER, Star and Snow Flake data models.
• Extensive knowledge in database maintenance, SQL query optimization& performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, Database consistency check using DBCC utilities and Database Engine Tuning Advisor
• Highly motivated, committed and a natural team player wif capability to work independently, wif proven ability to adopt and react quickly in a high pressure, fast-paced environment. Ability to communicate technical ideas clearly and concisely

TECHNICAL SKILLS

RDBMS/Database: MS SQL Server 2005/2008/2008 R2/2012, Oracle 11i/10g, MS Access

Data warehouse tools: OLAP, OTLP, SSIS, SSRS, and SSAS.

Analysis Tools: SAS, Google Analytics, Data Mining.

Data Tools: SQL Server Management Studio, SQL Enterprise Manager, SQL . Profiler DTS Import/Export, Report Builder, Query Analyzer SQL Client Configuration utility, Replication ServerSQL Server Business Intelligence Development Studio (BIDS).

Operating System: Windows XP/Vista/7/8, Server 2003/2008, Mac, Unix.

Languages: C#, T-SQL, MDX, VB.NET, HTML, CSS.

Others: SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Westchester, PA

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

Responsibilities:

• Worked on teh complete life cycle of teh project from design to implementation and support which involved creating Enterprise Data Warehouse and reports on teh EDW.
• Analyzed business requirements and built logical and physical data models dat describe teh data and relationships between teh data.
• Based on business requirement, developed Complex Stored procedures, Views, User Defined Functions, Triggers, CTE's, Table variables, Temp tables, Merge, Cross Apply to implement teh business rules and transformations.
• Designed high level ETL architecture for extracting data from heterogeneous source systems, transform and load into teh Staging Database.
• Extensively worked on data integration which includes developing ETL mappings, various SSIS transformations, Scripts and multiple SSIS tasks.
• Worked on importing and cleansing of data from various sources like DB2, Oracle, flat files, Excel to and from SQL Server wif high volume data.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, Bulk Insert task, Execute package task, Send mail task, For Loop &For-Each Loop containers.
• Worked on SSIS transformations like Conditional Split, Lookup, Fuzzy grouping, Merge, Union All, Data conversion, Multicast, Pivot& Un-Pivot.
• Created Dynamic SSIS Package templates dat captures teh error information and also takes teh variable and configuration values dynamically from XML File. Wrote custom C# code in SSIS Script task as well.
• Deploy SSIS Package and used Package configuration to export various package properties to make package environment independent and dynamic.
• Designed Cubes in OLAP and created teh Fact and Dimension tables in star schema, developed names sets using MDX in SSAS.
• Involved in Database Installation, Configuration, and Maintenance, Monitoring, Backup and Disaster Recovery procedure.
• Responsible for fast data retrieval by extensive use of multiple joins leveraging indexes and partitions.
• Created different type of reports including Cross-tab, Conditional, drill-down, Matrix, Tabular and Sub reports using SSRS.
• Created Charts and graphs in SSRS per business requirement for analyzing data.
• Implemented multiple grouping into several reports using visibility and toggle options in SSRS.
• Fixed many data related production bugs and made required changes to existing production reports.
• Analyzed Execution plans of teh store procedures and performed Query optimization, performance tuning and index creation.
• Used SQL Server Profiler to monitor teh performance, debugged teh Transact-SQL statements and stored procedures in existing application, to identify slow running query.
• Involved in Unit Test cases preparation and performed Unit testing.

Environment: MS SQL Server 2008/2012, MS Access, Excel, Visio, T-SQL, Windows Server, SSRS, SSIS, SSAS, Visual Studio, C#, .Net, XML

Confidential, Louisville, Kentucky

Sr. MSBI Developer (SSIS/SSRS/BI)

Responsibilities:

• Involved in gathering requirements from Business Users, Analysts by scheduling meeting Confidential regular basis.
• Worked extensively on data extraction, cleansing and data integration, and loading from various data sources using SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements wif error handling.
• Extracted large volumes of data from different data sources and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed SSIS packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Worked wif Technical Architects and Database analysts for teh Design of Summary tables required for efficient Report Design.
• Developed complexSSRS reports using multiple Data providers, Global Variables and Expressions.
• Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized and deployed based on teh customer requirement and same has been configured in teh Production Environment..
• Scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Create and delivered OLAP solution by developing Corporate and Executive Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Designer functionality.
• Debugging reports and deploying reports on server.
• Used Cascaded Parameters to generate a report from two different data sets.
• Scheduled Jobs to call teh packages and Stored Procedures.
• Tested, Cleaned and Standardized Data meeting teh business standards using Fuzzy /exact lookups usingSSIS tasks.
• Designed and developed OLAP cubes for Multi-dimensional data reporting based on teh business requirements using SSAS.

Environment: SQL Server 2012/2008R2, T-SQL, SSIS, SSRS 2008R2, Agile, Visual Studio, BIDS, ER/Studio MS Access, SQL Server Management Studio, SQL profiler, and Windows Server 2008.

Confidential

SSIS & SSRS Developer

Responsibilities:

• Migrated data from different sources and built enterprise data warehouse by staging teh data.
• Extracted large volumes of data from various data sources and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Designed and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Worked in creating complex Stored Procedures, triggers, cursors, joins and statements for applications.
• Involved in designing teh physical databases model on SQL Server 2008R2/2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Created SSIS Templates for developing SSIS Packages in such a way dat they can be dynamically deployed into Development, Testing and Production Environments.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Designed and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 Reports Services (SSRS).
• Worked on all activities related to teh development, implementation, administration and support of ETL processes using SSIS and DTS.
• Helped in leading team in creating SSIS templates for developing SSIS Packages.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

Environment: Windows 2003/2008 Server, MS SQL Server 2008R2, BIDS, ASP .NET, XML, SSIS, SSRS, Service Broker, C#, MS VSS

Confidential

BI Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Strong performance, diagnostic, and query tuning skills.
• Involved in creating ER Diagram, Data Architecture design, Data modeling.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008.
• Extracted teh data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into teh target Data warehouse using SSIS (SQL Server 2008).
• Designing SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, and Access to MS SQL Server.
• Handled slowly changing dimensions to maintain teh history of teh data.
• Optimized indexes, SQL queries and stored procedures to improve teh quality of teh software.
• Design, review, and create primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed Ad hoc reports for teh clients as per their requirements using SSRS.
• Variance reports using Reporting Services (SSRS).
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Responsible for taking data objects across different databases: Development -Test - Production.
• Created trace in SQL Profiler and used Data-base engine tuning advisor for Performance tuning on stored procedures and script.

Environment: MS SQL Server 2005, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, VSS

Confidential

Jr.SQL Developer

Responsibilities:

• Worked wif teh IT team to improve teh quality of IT service and completed multiple projects wifin assigned time frame.
• Developed tables and relationship among tables by applying Normalization, Referential Integrity, Constraints and Cardinality in RDBMS.
• Involved in Data Mapping by developing teh relationship among Entities.
• Created Stored Procedure, Functions, Tables and Views for teh optimization of Database and to reduce teh traffic of database.
• Modified teh database object and structures as suggested by developers in both production and development environment.
• Worked in front end designing using .NET for developing websites and console applications using C#.

Environment: SQL server 2005, T-SQL, Erwin, MS Excel, MS Access, C#, ASP.NET