SUMMARY

• Overall 8 years of IT Experience in Business Intelligence solutions and data warehouse complete life cycle with Microsoft SQL Server 2005/2008/2012 BI stack using SSIS, SSRS, and SSAS in Development, Test and Production Environments in various business domains like Consulting, Financial, Pharmaceutical, Healthcare and Retail.
• Excellent in developing solutions using MS SQL Server 2005/2008/2012 BI stack like SSMS, SSIS, SSAS and SSRS.
• Experience in designing dashboards with various data visualizations tools like MS Power BI, Tableau and Qlikview
• Extensive noledge in logical and physical data modeling and normalization
• Experience in data analysis, gathering customer needs, business requirements and resolving design issues
• Sound understanding of data warehouse principals, Data Warehouse design and best practices
• Ability to implement repeatable data cleansing and data standardization steps and procedures within ETL routines
• Extensive experience using Integration services (SSIS) and DTS for Extraction, Transformation and Loading data from various heterogeneous sources like Excel, Flat files, MS Access, Oracle, Teradata and DB2
• Created, configured and deployed SSIS packages by applying various transformations and using various control flow tasks
• Expert in creating OLAP solutions using SSAS Tabular and Multi - Dimensional models.
• Extensive experience with SQL Server in Data Warehousing, OLTP/OLAP (MOLAP, ROLAP, HOLAP) environment
• Experience in developing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling and Snow Flake Modeling.
• Proficient in developing Cubes and creating DSV’s, hierarchies, attribute relationships, custom dimensions, partitions, aggregations and KPI’s with SSAS.
• Experience in Power BI Designer with Power Pivot for Excel, Power View for data visualization and used DAX for use in calculated columns for reports and analysis purpose
• Proficient in writing complex MDX, DAX queries for data analysis and reporting using SSAS & SSRS and creating calculated measures and dimension members
• Experienced in report generation using Microsoft SQL Server Reporting Services (SSRS) as per teh client Requirement and for teh periodic analysis from relational databases and OLAP cubes
• Experience in SSRS 2008/2012 design and deployment of Parameterized, Drilldown, Drill-through, Sub, Linked, Snapshot, Cached, and Ad hoc Reports
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to teh Document Library of SharePoint
• Excellent in T-SQL programming like creating Stored Procedure, Triggers, Views, User defined functions and Indexes.
• Experience in SQL Server Configuration, Performance Tuning, Query Optimization.
• Experience in source control tools like Team Foundation Server.

TECHNICAL SKILLS:

RDBMS: SQL Server 2008R2/2012, MS Access, Teradata, Oracle

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Replication

ETL Tools: SSIS, Informatica

OLAP/Reporting Tools: SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS), Crystal Reports, Business Objects, Performance Point Server, PowerPivot, SSAS Tabular, Power BI, Qlikview, Tableau

Applications: MS Word, MS Excel, MS PowerPoint, SharePoint

Languages: T-SQL, MDX, DAX, PL/SQL, HTML, C#.NET

Scripts: VB Script, XML, UNIX, JavaScript

Data Modelling Tools: Erwin Tool, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, VA

SQL Server BI Developer

Responsibilities:

• Develop technical design documents and mapping specifications to build ETL Mappings to load data into target tables.
• Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files and loaded teh data into target tables by performing different kinds of transformations using SSIS.
• Used Microsoft TFS in order to share teh code with other programmers and as a source control Document, design, develop, optimize and maintain reliable, repeatable and scalable ETL packages and solutions by implementing ETL standards, conventions and best practices in SSIS
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
• Extensively used SSIS transformations in order to perform data cleansing and data mapping before loading teh data in to data marts.
• Provided technical expertise with data analysis, collection and documentation of metadata components and information delivery
• Utilized T-SQL extensively in order to replace SSIS transformations in order to improve teh performance of packages.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies, actions, partitions, aggregations based on teh OLAP reporting needs.
• Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema in SSAS
• Created calculated members, named sets for custom measures using MDX for OLAP Reporting as per end user requirements.
• Deployment and processing SSAS Cube, monitor Full and Incremental loads and support any issues
• Created SSAS Tabular semantic model with multiple partitions, KPI’s, hierarchies and calculated measures using DAX as per business requirements
• Createdtabularandmatrix reportsinSSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in thecreation and deploymentof teh reports usingSSRSand configuring teh SQL Server Reporting Server in SharePoint integrated mode.
• Generated reports usingSSRS, Power Pivot, and Power BI that could be used to send information to diverse group of users, clients, and managers.
• Used Power BI to create Power Pivot data model and Power View reports and dashboards and calculated Custom fields using DAX
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from multiple tables.
• Developed reports with flexibility using Report Parameters Drop-Down Parameters Multi-Valued Parameters in order to meet teh changing business needs (SSRS) and deployed to SharePoint site.

Environment: SQL Server 2008/2012, SharePoint 2010/2013, ASP.NET, MDX, DAX, Power BI, Power Pivot SSRS, SSIS, SSAS, Power BI

Confidential, Herndon, VA

SQL Server/ SSIS Developer

Responsibilities:

• Converted teh DTS Packages into SSIS using Migration Wizards
• Migrated data from Excel, SQL Server 2000 to SQL Server 2005 via SSIS.
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from multiple tables
• Developed SSIS packages with which data resources such as Excel, SQL server for teh daily load in order to create and maintain a centralized data warehouse
• Designed and configured SSIS packages to migrate teh Customer Information, Contracts Information and other important data from teh Excel, Oracle, legacy System using various transformations.
• Created Jobs to extract data from different sources using SSIS packages that would aggregate teh data and load them in globally temporary table, having teh same architecture as teh table for which teh import is done
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures for troubleshooting
• Used SSIS packages to roll our data to Live Tables and to Reservation Processing Database
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships
• Developed SQL Scripts, database objects, procedures, functions and packages to support teh Qlikview reports and dashboards
• Designed and deployed interactive reports with Drill Downs, Parameters and Linked reports in Tableau and Qlikview
• Scheduled and monitored teh SQL Server Agent jobs to run teh SSIS packages and stored procedures

Environment: SQL Server 2008, Qlikview Developer 10.0, SharePoint, Tableau, SSIS, SSRS

Confidential, Austin, TX

BI Analyst

Responsibilities:

• Involved in logical and physical data modeling, database design, star schema, data analysis.
• Designed, developed and deployed Business Intelligence solutions using MS BI stack (SSIS, SSRS and SSAS)
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Migrated old data from legacy system into SQL Server 2008 using SSIS Packages
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions
• Wrote lot of Stored Procedures and developed lot of SSIS Packages in DW environment. Responsible for ETL jobs scheduled to run and daily DW load
• Created and configured various SSIS packages for optimal performance by studying teh parallelism, buffer sizing and design approaches.
• Migrated data from Oracle to Teradata data warehouse using Integration services (SSIS) and Informatica to generate teh reports using SSRS for different SSAS Cubes
• SSAS Cubes are built on top of teh Oracle and Teradata data warehouses.
• Make modifications and add new MDX to query teh cube
• Created partitions and aggregated cube for better performance.
• Processed cube to perform incremental updates.
• Built MDX queries for Analysis Services (SSAS) & Reporting Services (SSRS).
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to teh Document Library of SharePoint
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Created complex SSAS cubes with multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on teh OLAP reporting needs
• Built cube partitions using MOLAP, HOLAP,ROLAP methods for faster query performance and processing speed
• Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports

Environment: MS SQL Server 2008R2, Erwin, SSIS, SSRS, SSAS, Oracle 10g, SharePoint 2007, T-SQL, PL/SQL, MDX, Toad, Teradata, Informatica

Confidential, Des Moines, IA

SSAS/SSIS/SSRS Developer

Responsibilities:

• Designed OLAP cubes with star schema and multiple partitions using SSAS
• Meet with customer business and technical leaders to identify and scope teh business opportunities, document business requirements, identify TEMPeffective reporting techniques
• Developing OLAP cubes using SSAS 2008 and calculated teh metrics that were revealed in teh functional analysis
• Troubleshoot and performance tuning of SSAS Cubes
• Designed and Developed matrix, tabular and parametric Reports in teh SQL Server Reporting Services 2008
• Generated database monitering and data validation reports in SSRS.
• Wrote MDX using various aggregate functions
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing cubes using MDX.

Environment: MS SQL Server 2005/2008, Windows Server 2003 Enterprise manager, Query Analyzer, SSIS, SSRS, SSAS, DTS, PPS, Performance Monitor, Query Optimizer, T-SQL

Confidential, PA

SSAS/SSRS Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Involved in analysis, design, development, and enhancement of teh data warehousing application.
• Created reports that call Sub reports in SSRS. Created Custom reports, datasets for reports using TSQL.
• Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports
• Created partitions and aggregations for large measure groups in SSAS.
• Wrote complex MDX queries for calculated members and measure groups.
• Created SSIS packages and used Analysis Services (SSAS) processing task to update teh cube with current data, build teh Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Played a major role in teh production support of SSAS cubes and SSIS jobs.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild teh Dimensions and Cubes in Analysis Services (SSAS).
• Created KPI’s and PPS score cards.
• Created score cards with executive summary dashboards using Performance Point Server 2007 Dashboard Designer and deployed them to SharePoint server
• Created interactive reports, canned reports with SSRS using report parameters, query parameters, filters and expressions.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS, PPS, TSQL, C#.Net, ASP.Net UNIX Oracle 10g'

Confidential, Bloomfield, CT

SQL Server Developer

Responsibilities:

• Took part in teh meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality for developing applications using MS BI stack
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Designed slowly changing dimension transformations (SCD) and customized teh existing mappings.
• Developed Store Procedures and User defined functions (UDF) to access data from Data Mart.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSAS, SSRS, Oracle, TFS, MS Access, MS Excel,