SUMMARY:

• Having around 8+ years of Total IT experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments in MSBI tools (SQL Server 2008 R2,2012, SSIS and SSRS,SSAS)
• Core Competence in Data Warehousing and Business Intelligence Platform.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS - Access, Excel, Oracle and Share Point 2010.
• Experience in solving issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Rich Knowledge in Object Oriented Analysis and 3 - Tier Architecture.
• Designed and Implemented layers like Dashboard and Scorecard type of Reports.
• Have worked in multiple projects as BI Developer in Designing ETL Packages and reports in development and implementation stages of the project according to client requirements.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms.
• In-depth Knowledge in SDLC life cycle for Design, Development and Staging Phases of projects with support of Data-flow, Process Models, E-R Diagrams.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS. Involved in Normalization and RDBMS.
• Supported team in resolving SQL Reporting services and ETL related issues by DB2 Server.
• Involved in performance tuning at different levels (Package, Source, Destination and Transformation).

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2008, MYSQL, MS Access, Oracle(Migration)

APP/WEB SERVERS:: IIS 5.0/6.0,TOAD,AS400

Languages:: TSQL, C#, ASP.Net 3.5, Visual Basic, LINQ.

Reporting Tools:: SSRS 2005, 2008r2,2014, QlikView.

ETL&ERP Tools: SSIS 2005/2008r2/2010,2014, COGNOS,PowerBI.

OLAP Tools: SSAS 2005, 2008r2, 2012/2014.

Others:: BIDS, Visual Studio, .NET, DB2, Crystal Reports, SQL Server DBA.

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park, KS

Metric BI Developer

ETL Tool: SSIS 2008r2,SSRS 2008,2012, C#,CRM.

OLAP Tool : SSAS 2005,2008r2,2014 SQL Server 2014.

Reporting Tool: SSRS 2008,2010,2014,Power BI.

Responsibilities:

• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi dimensional expression (MDX), Perspectives and Roles.
• Worked on Dimension Modeling, E-R Modeling and Schemas.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Creating SSIS Packages by using different data Performed Database Refresh tasks from production to Development and Staging Servers.
• Lookup and Working in Blocking and Un-Blocking Transformations.
• Configured performance tuning settings using indexes, SQL profiler
• Involved to planning and designing SSAS 2014 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Working with Performance Point Services, Pivot Tables,Tabular Model and Slowly Changing Dimensions.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes by using DB2 Server.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012/2014.
• Implemented KPI’s, actions, created calculated members for doing intermediate operations on Cubes in SSAS.
• Simple and Complex reports to generate reports in different formats.
• Based on the requirements develop reports on weekly, monthly and daily basis.
• Designed all most all kinds of simple and complex reports like Drill through, drill down, Matrix, Parameterized reports, and Sub reports in SSRS.
• Coded Business logic in C#
• Designed Web Pages using ASP.Net.
• Designed and Documented GUI by using C#
• Developed test plans and participating Code testing to ensure workability
• Created custom web parts using ASP.Net in windows workflow foundation

Confidential, Chicago, IL

Application Support Analyst

ETL Tool: SSIS 2008 r2,2014 C#,.Net

Reporting Tool: SSRS 2008r2,2010,2014 Crystal Report

Responsibilities:

• Performed analysis of Business requirements and interpreted transformation rules for all target data objects. Developed ETL specification based on business requirements.
• Designed and developed the Data Flows and control flows and performed data cleansing and quality using Fuzzy lookups.
• Worked with Different data transformations like Slowly Changing Dimensions, Data conversion, Union All, Sort, merge joins, look up etc.
• Analyzed the change requests (CRs) and Business Requirement Document (BRDs).
• Done the Unit testing on newly created SSIS Packages.
• Created/ Updated the ETL Technical Documentations on Clients Repository Portals.
• Involved in creating and modifying the ETL jobs and monitoring the ETL Schedule.
• Involved in performance tuning of SQL statements, Query optimization and Explain Plan utilities. Performed SQL queries extensively to test the Data Warehouse.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Handled Scheduled backups and restore operations with LiteSpeed 5.0 and monitored the Tasks, Maintenance plans.
• Created different kinds of Reports like Drill down Reports, Matrix, drill through reports, Linked Reports using SQL Server 2008 Reporting Services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in designing reports using SQL Server Reporting Services (SSRS).
• According to the situation created Subscriptions, snapshot and Linked Reports.

Confidential

SQL BI Developer

ETL Tool: SSIS 2005,2008r2,DB2

Reporting Tool: SSRS 2005,2008r2,2012/2014,C#,.Net

Responsibilities:

• Implemented Optimization of Stored Procedures by using DB2 Server.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and long running queries by checking appropriate changes to Transaction Isolation levels.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2008R2 and 2012 OLAP databases.
• Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2008
• Extracted data from various sources like SQL Server 2008/2014, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup sort, Data Conversion and Script Task to load data into Data Warehouse.
• Created Simple and complex ad hoc reports.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Worked with chart Report, Matrix and Chart reports.

Confidential

BI Consultant

Analysis Tool: SSAS 2008R2,2014 Excel, SQL DBA,SSIS

Responsibilities:

• Cube deployed and Processed from OLAP system in SSAS
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error log. Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.

Confidential

MS BI Developer

Analysis Tool: SSAS 2008R2,2012, 2014 Excel, SQL DBA,SSIS

Responsibilities:

• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS).
• Transformed data from various data sources using OLE DB connection by Creating SSIS Packages

Confidential

BI Developer

Analysis Tool : SSAS 2008R2,2012, 2014 Excel, SQL DBA,SSIS

Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modeling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Generated Reports weekly and monthly to an online management interface using SSRS Post production support Critical issue resolving in given timeframe. Monitor jobs and reporting, performed code reviews, unit testing.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options