SUMMARY

• 8+ Years of IT Experience including design, analysis, configuration, administration of Database and Business Intelligence solutions wif Microsoft SQL Server 2008/2012 in Development, Test and Production Environments in various business domains like Consulting, Financial, Pharmaceutical, Healthcare and Retail.
• Excellent in MS SQL Server 2005/2008/2012 BI stack like SSMS, SSIS, SSAS and SSRS.
• Extensive knowledge in logical and physical data modeling, normalization
• Good knowledge of System Development Life Cycle (SDLC).
• Experience in gathering customer needs, business requirements and resolving design issues
• Participated in teh testing process and works to improve teh quality and efficiency of BI projects SQL Servicer Integration Services (SSIS)/ ETL
• Extensive experience using Integration services (SSIS) and DTS for Extraction, Transformation and Loading data from various heterogeneous sources like Excel, Flatfiles, MS Access,Oracle, Teradata and DB2
• Created, configured and deployed SSIS packages by applying various transformations and using various control flow tasks
• Experience in designing custom components using C#
• Expert in Migrating DTS Packages to SSIS 2005/2008/2012.
• Configured SSIS packages in BIDS wif config file to execute packages across teh different environment from development to test to production server
• Implementation experience in running and scheduling SSIS packages, Fuzzy Look - up for cleaning bad data, validating data using SSIS wizard. SQL Server Analysis Services (SSAS)/OLAP
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server)
• Extensive experience wif SQL Server in Data Warehousing, OLTP/OLAP (MOLAP, ROLAP, HOLAP)environment
• Experience in MDX development/conversions
• Experience in developing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
• Experience in working wif very large volume of relational databases and Cubes.
• Proficient in developing Cubes and creating DSV’s,hierarchies, attribute relatioships,custom dimesions, partitions, aggregations and KPI’s wif SSAS.
• Expert in creating calculated measures and dimension members using multi dimensional expressions (MDX)
• Proficient in writing complex MDX queries for data analysis and reporting using SSAS & SSRS
• Migrated and recreated existing Dimensions and Cubes using Star schema, Snow flake schema to achieve teh efficiency of SQL Server Analysis Services (SSAS). SQL Server Reporting Services ( SSRS )
• 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, Drillthrough, Sub, Linked, Snapshot, Cached, and Ad hoc Reports
• Expert in defining Query for generating drill down reports in SSRS 2008/2012.
• Experience in writing expressions in SSRS and Expert in fine tuning teh reports.
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to teh Document Library of SharePoint Database Design and Administration
• Excellent in T-SQL programming like creating Stored Procedure, Triggers, Views, User defined functions and Indexes.
• Experience in installation, upgrade, configuration and clustering of Microsoft SQL Server databases
• Experirnce in SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Created, altered, maintained system roles and permissions to users on various database objects.
• Experience in optimizing teh database performance by analyzing Execution Plan, creating various clustered, non-clustered indexes and indexed views
• Performed daily tasks including backup, restore by using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Experience in source control tools like Visual Source Safe, Team Foundation Server.

TECHNICAL SKILLS

RDBMS: SQL Server 2008R2/2012, MS Access, Teradata, Oracle 10gDatabase Tools Enterprise Manager, Query Analyzer, SQL Profiler, Replication, BCP, DBCC

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, SharePoint Dashboards, Power BI, Qlikview

Applications: MS Word, MS Excel, MS PowerPoint, Sharepoint

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

Scripts: VB Script, XML, UNIX, Javascript

Data Modelling Tools: Erwin Tool, Microsoft Visio, Kimball’s methodology

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

SSRS/SSAS Developer

Responsibilities:

• 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, Excel (Pivot) dat could be used to send information to diverse group of users, clients, and managers.
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from multiple tables.
• Developed reports wif flexibility using Report Parameters Drop-Down Parameters Multi-Valued Parameters in order to meet teh changing business needs (SSRS) and deployed to SharePoint site.
• Created a high level design document which contains teh specification details for teh whole project.
• Extensively used SSIS transformations in order to perform data cleansing and data mapping before loading teh data in to data marts.
• Created SSIS Configurations to migrate packages from Development to Test and to Production
• Utilized T-SQL extensively in order to replace SSIS transformations in order to improve teh performance of packages.
• Used Microsoft TFS in order to share teh code wif other programmers and as a source control
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies, actions, partitions, aggregations based on teh OLAP reporting needs.
• Involved in Analyzing, designing, building &, testing of OLAP cubes wif SSAS and in adding calculations using MDX.
• Wrote teh MDX queries for OLAP Reporting.

Environment: SQL Server 2008/2012, Sharepoint 2010/2013, MDX, SSRS,SSIS,SSAS

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 wif 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 dat 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 wifout any closed loops, Synthetic tables and ambiguous relationships
• Developed SQL Scripts, database objects, procedures, functions and packages to support teh Qlikview reports and dashboards
• Scheduled and monitered teh SQL Server Agent jobs to run teh SSIS packages and stored procedures

Environment: SQL Server 2008, Windows Server 2003, Qlikview Developer 10.0, Sharepoint, SSISSSRS

Confidential, Austin, TX

SQL BI Developer

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 wif 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 configred 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 wif 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

SQL BI Developer

Responsibilities:

• Worked wif business users to define and analyze problems, create logical data model, implement physical data model, and considers teh implications of business solutions using MS BI stack to teh current and future environment.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using teh execution package
• Conducted data migration processes in teh SQL Server environment using SQL Server Integration Services
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle using SSIS
• Conducted and automated teh ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into teh Multi-dimensional data warehouse
• Designed and Developed matrix, tabular and parametric Reports in teh SQL Server Reporting Services 2008
• Generated database monitering and data validation reports in SQL Server Reporting Service (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, ASP.NET, ADO.NET, C#.net, UNIX, 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
• Defined requirements and comprehended teh complex business rules required for writing teh code.
• Involved in analysis, design, development, and enhancement of teh data warehousing application.
• Transformed data from various data sources using OLE DB connection; also scheduled automated tasks.
• Created reports dat call Sub reports in SSRS. Created Custom reports, datasets for reports using TSQL.
• Generated multiple reports (SSRS) in drill mode using tables, cross tabs and charts.
• 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 Datawarehourse Cubes in SSAS 2005 and migrated them to SSAS 2008
• Created SSIS packages and used Analysis Services (SSAS) processing task to update teh cube wif current data, build teh Dimensions, cubes wif 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).
• Designed and Imported KPI’s into PPS score cards.
• Created score cards wif executive summary dashboards using Performance Point Server 2007 Dashboard Designer and deployed them to Sharepoint server
• Created interactive reports, canned reports wif SSRS using report parameters, query parameters, filters and expressions.
• Performed Sorting, formatting, and Grouping to custom reports in (SSRS).

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

Confidential, Bloomfield, CT

SQL Server Developer

Responsibilities:

• Took part in teh meetings wif Sr. Business Analyst and managers and understood various process plans, business process, and functionality for developing applications using MS BI stack
• Exporting teh Database from Local Server to teh Remote Server and Importing teh Current running database from remote server to teh Local DB Server using DTS.
• 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.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Created new cubes and modified existing cubes using SSAS to make data available for teh decision makers.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Identified teh measures, dimensions and defined cubes to enable decision makers to drill through teh detail data.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSAS, SSRS, SQL Enterprise Manager, Windows XP, Oracle, TFS, MS Access, MS Excel, Windows 2003, HTML, VB.