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),Powerbuilder,Power Pivot,Power view,Power BI,Talent ecosystem.
• 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.
• Expertise in Performance Point Server 2007, Microsoft Business Intelligence Tools (SSIS, SSAS (Tabular Model), SSRS, Power View, Power Pivot, Power Maps, Power Query, ProClarity, SQLServer 2005/2008/2012 , Microsoft Office SharePoint Server, Excel reporting and Power Pivots.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory.
• 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.
• 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),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, Boston, MA

BI Developer

ETL Tool: SSIS 2008r2,2016,SSRS 2008,2012, C#,MS Dynamics CRM,NoSQL,ALTERYX.

OLAP Tool: SSAS 2005,2008r2,2014/2016 SQL Server 2014/2016,Supply Chain,MDX.

Reporting Tool: SSRS 2008,2010,2014,Power BI, Power Query,Oracle,Azure,Powerbuilder.

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.
• 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.
• 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

PROFESSIONAL EXPERIENCE:

Confidential, SanJose, CA

Application Support Analyst

ETL Tool: SSIS 2008 r2,2014 C#,.Net.Datastage,Informatica, MongoDB,Power BI, SSAS,2008 r2,2014 OLAP,MS Dynamics CRM,SCM,Powerbuilder,ALTERYX

Reporting Tool: SSRS 2008r2,2010,2014, Power BI,Oracle SQL,Azure,Python,Power Map.

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 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 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, New York, NY

SQL BI Developer

ETL Tool: SSIS,2008r2,DB2,MS Dynamics CRM, Supply Chain Management.

Reporting Tool: SSRS, 2008r2,2012,C#,.Net,ORACLE BI,Azure, Python, Pyspark. Alteryx

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 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, Columbia, Tennessee

BI Developer

Analysis Tool: SSAS 2008R2,2014, Excel, SQL DBA,SSIS,MS Dynamics CRM,Azure.

ETL Tool: SSIS, 2008r2,DB2,MS Dynamics CRM, Supply Chain Management.

Reporting Tool: SSRS, 2008r2,2012,C#,.Net,ORACLE BI,Azure,Python,Pyspark.Alteryx

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.
• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2012/2016.

Confidential

MS BI Developer

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

ETL Tool: SSIS, 2008r2,DB2,MS Dynamics CRM, Supply Chain Management, SSRS, 2008r2,2012,C#,.Net,ORACLE BI,Azure,Python,Pyspark.Alteryx

Reporting Tool: SSRS, 2008r2,2012,C#,.Net,ORACLE BI,Azure,Python,Pyspark.Alteryx

Responsibilities:

• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS).
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014/2016 .
• Transformed data from various data sources using OLE DB connection by Creating SSIS Packages and used Sales force for migration to ERP Systems.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Confidential

BI Developer

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

ETL Tool: SSIS, 2008r2,DB2,MS Dynamics CRM, Supply Chain Management.

Reporting Tool: SSRS, 2008r2,2012,C#,.Net,ORACLE BI,Azure,Python,Pyspark.Alteryx

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.
• 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.