SUMMARY

• IT professional with 9.5 years of experience as a Microsoft Business Intelligence & Data Warehousing consultant.
• Having hands on experience on cloud services - Azure Data Factory V2, Power BI, Azure Analysis Services, Azure SQL DB.
• Programming skills (PowerShell, C#, MDX, DAX, SQL).
• Designing, development and implementation of Business Intelligence solutions using Microsoft BI suite of tools - SSIS, SSAS and SSRS
• Power BI -Complex Data Modelling and creating Interactive data Visualizations for the Business users.
• Power BI - Have experience pulling data from both on premise data sources (SQL Server DB, Oracle DB, Excel files, .csv files, SharePoint Lists etc.) and Cloud data sources like Salesforce, Azure SQL SB, Azure Analysis Services, SharePoint Online lists etc.
• Power BI Administration, Management and automation (Gateway management, Dataset Refresh, Power BI Admin tasks like Managing Workspaces, Reports and Datasets) using Power BI REST API and PowerShell.
• Experience in configuring security, organizational content packs, data Gateways, refresh schedules for Power BI service.
• Have worked on Real Time Dashboards with Power BI Real Time streaming datasets and PowerShell.
• Have worked on creating Pipelines, Linked Services, Integration Run time, Triggers, Data Flows, in AzureDataFactory V2.
• Experience in creating CI/CD pipelines in AzureDataFactory.
• Experience in designing, developing and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Extensive data warehouse and OLAP/Cube, Tabular Model/Cube design experience using Kimball Method Best Practices.
• Experience in Dimensional Modelling, ER Modelling, Star Schema / Snowflake Schema
• Strong desire in learning new technologies and methodologies
• Worked closely with Project manager, development, testing and production team to align project deliverables, dates and report issues/concerns.
• Well versed with overall ITIL processes like change, incident and problem management along with its relevant processes.
• Involved in root cause analysis, problem solving, issue tracking and support in production.
• Creating shell scripting to automate monitoring activity.
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude.
• A very good team player, self-motivated, dedicated in any work environment.
• Mentored and trained existing and new team members.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2008R 2/2012/2016/2017 , Windows 7 and 10

Programming Languages: PowerShell, C#, MDX, DAX, SQL

RDBMS: Microsoft SQL Server 2008/2008R2/2012,2016,2017

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

MSBI Datawarehouse Consultant

Responsibilities:

• Requirement gathering, Data Warehouse Design, Semantic Layer (Multidimensional model and Tabular model) Design based on the Business Requirements.
• Converted existing multidimensional cubes to tabular model, recreated all existing measures using DAX and release to azure cloud analysis service
• Developing compelling and interactive analysis reports and dashboards for analytics using Power BI desktop.
• Installed and Configured Enterprise Gateway for Power BI to keep the Dashboards and reports up to date.
• Import data from SQL Server DB, Oracle DB, Azure SQL DB, SharePoint Online Lists, SharePoint on-premise Lists to Power BI and develop data models on top it and create data Visualizations in Power BI.
• Setup/Configure Pipelines, Integration Runtime, Linked Services, Data Flows in Azure Data Factory.
• Create and Orchestrate ADF pipelines to pull data from on premise Relational Databases and store it to Azure SQL DB and Azure Blob storage.
• CI/CD pipelines in Azure data Factory to deploy the objects to different environments.
• Use of ARM templates to deploy the Azure data factory to different environments.
• Configured ADF V2 to GIT repository to use CI/CD release pipeline for deployment automation.
• Have worked recently to move the source code from Team Foundation Version Control (TFVC) to Azure DevOps GIT.
• Automated Azure Resources using Azure Resource Management CLI and PowerShell.
• Ex: Restarting the Azure Analysis Services using Azure REST API and Azure Management PowerShell commandlets.
• Automated and Administered Power BI Dashboard, Reports and Datasets using Power BI REST API and Power BI PowerShell command lets.
• Automated Power BI datasets refresh with Microsoft flow/Power BI REST API.
• Created an SSIS solution for the Power BI Administration, pulling the details of all the Workspaces, datasets, Reports, Dashboards published on the Power BI service.
• Created a Live Dashboard for the Business using the Power BI Realtime streaming datasets - Streaming, Hybrid and Push datasets.

Confidential

MSBI Technical Lead

Responsibilities:

• Developed SSIS packages for the entire Business Model. Approx. 50 SSIS packages developed in 3 phases.
• Configured SSIS packages through Project and Package parameters and created Environment Variables in the Integration Services Catalog to enable the packages to read values dynamically from the Environment, a feature available only with SSIS 2012. Earlier the packages used SSIS configuration tables if it was to be dynamically configured.
• This had a loophole as the tables could be read and the sensitive data passwords were at risk.
• So, environment variables replaced SQL server configuration tables.
• Developed Master Package with Sequence containers with all the SSIS packages inside them with precedence constraints.
• The main idea to have the Master Package was to enable the execution of the SSIS packages in parallel to save time and enhance performance.
• Deployed the SSIS 2012 packages to the Integration Services Catalog and created a SQL job to trigger the Master package that in turn triggered rest of the SSIS packages.
• Migrated the entire SSIS solution through the Project Deployment Model available only with SSIS 2012 using the. isapc file.
• Developed SSAS MOLAP Cube on top of the Datawarehouse for Reporting purposes.
• The Excel Pivot table reports were used for Cube Reporting purpose which were then deployed to the SharePoint for Business Users.

Confidential

MSBI Developer

Responsibilities:

• SQL server programming, writing stored procedure in TSQL to generate SSRS Reports as per the Business requirement.
• Generated dynamic SSRS reports by writing expressions, queries and Stored Procedures, automated report delivery to users, Deployed Reports to report server.
• All kinds of SSRS Reports were developed Table, Matrix, Parameterized, Cascaded Parameterized reports, Sub Reports, Lists, Document Map, Charts, Sparklines, Gauge etc.
• The client had reporting done in excel and my responsibility was to convert all the excel reports to SSRS Reports.
• The advantage being the reports to be dynamic and readily available to the users from the Report Server.

Confidential

MSBI Applications Support & Developer

Responsibilities:

• Deploying SQL server database instances and configuring databases through SQL Server Management Studio (SSMS) with database maintenance plans.
• Created and Modified SSIS Packages to extract data from various data sources such as SQL server, Excel spreadsheet, and flat files into SQL Server 2008R2\2008 for further Data Analysis and Reporting using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Lookup, Merge, Union etc.
• Created and Deployed SSRS reports for Transactional Databases.
• Included almost all forms of reports i.e.
• Tabular Matrix Charts Parameterized and all forms of other dynamic reports.
• SQL server 2008R2/2008 implementing SQL server cluster configuration, Fail over cluster management, Database maintenance plans and other Database related maintenance activities.
• Analysing the performance and monitoring the overall server health along with the performance of the applications hosted on them.
• These tasks heavily rely on PAL and Perfmon.