SUMMARY:

• Having around 6+ 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),Powerbuilder,Power Pivot,Power view,Power BI,Talent ecosystem.
• Core Competence in Data Warehousing and Business Intelligence Platform.
• Experience inBI DevelopmentandDeploymentofDTS,SSISpackages 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 and also used Couch Performance tuning .
• 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.
• DesigningandDeployment of Reportsfor the End-User requests usingWeb 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),MongoDB

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

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

Reporting Tools: SSRS 2005, 2008r2,2014/2016,Tableau,ORACLE SQL,Azure.

ETL&ERP Tools: SSIS/2008r2/2010,2014/2016,MS Dynamics CRM,Power BI,Splunk,ODI11g

OLAP Tools: SSAS 2008r2, 2012/2014/2016 , Postgre SQL,Data analysis,ALTERYX.

Others: BIDS, Visual Studio, .NET, DB2, UNIX, Linux,SQL Server DBA,Azure,Powerbuilder.

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park KS

BI Developer

Responsibilities:

• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems by Power BI.
• 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.
• Design, develop, test, and deploy custom SharePoint web parts, custom features, Workflows.
• Ability to create custom SharePoint site definitions (publishing, team sites, collaboration), Lists, Libraries, Content Types.Experience in configuring all service applications (2013) and configuring Security.SSIS:
• 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 PerformedDatabase Refreshtasks from production toDevelopmentandStagingServers.
• Lookup and Working in Blocking and Un-Blocking Transformations.
• Design, develop, test, and deploy custom SharePoint web parts, custom features, Workflows.
• Ability to create custom SharePoint site definitions (publishing, team sites, collaboration), Lists, Libraries, Content Types.Experience in configuring all service applications (2013) and configuring Security and used talent eco system.
• Configured performance tuning settings using indexes, SQL profiler of couch performance.
• 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, PivotTables,Tabular Model and Slowly Changing Dimensions and used MS Dynamics CRM,Splunk AppD for data visualization.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes by using Power Pivot tables.Powerbuilder,Power Pivot,Power view,Power BI.
• 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 by using Couchbase performance tuning.
• 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 using DB2/Talend.
• 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

Application Support Analyst

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 also by using Talend .
• 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(MDX)
• 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 withLiteSpeed 5.0and 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 and used Splunk for dashboard, populated Sales force for migration from ERP Systems in to MS Dynamics through Open query.
• Experience in designing reports using SQL Server Reporting Services (SSRS).
• According to the situation created Subscriptions, snapshot and Linked Reports.

Confidential

SQL BI Developer

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 By using Supply Chain Management.
• 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 likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• 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.

Confidential

BI Consultant

Responsibilities:

• Cube deployed and Processed from OLAP system in SSAS and used Splunk AppD.
• 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 and used Salesforce for migration to ERP Systems.

Confidential

MS BI Developer

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 and used Sales force for migration to ERP Systems.

Confidential

BI Developer

Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modeling tool. Worked on Facets Datamodeling.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.SSIS:
• 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.