PROFESSIONAL SUMMARY:

• 13+ years of experience in designing and extending Azure & Confidential BI Database and Data Warehousing applications.
• Currently I am architecting a data warehousing solution using Azure Sql Database, Azure Data Factory, Azure PowerShell, Power BI Desktop and Azure Active Directory at Accenture, Redmond/Seattle for Confidential Client.
• Have been working for Confidential client from Accenture for the past 8+ years.
• Very strong in Database design and Data Warehousing design using the Multi - Dimensional Facts and Dimensions
• Evaluated with Proof of concepts if Azure Data Warehouse & Azure Data Lake, Azure Service Fabric PAAS services can be used for the current Azure Data warehousing project.
• Did POCs on Azure Data Lake using U-SQL to on-board large datasets.
• Currently working in a devops and agile methodology for the past 30+ months
• Used Clustered column store indices in Azure PAAS Sql Databases and avoided the use of Sql server Analysis Services. SSAS internally uses Column store indices.
• Have the set up the Continuous Integration-Continuous Deployment-Continuous Testing (CI-CD-CT) for Azure Sql Database and Azure Data Factory projects for Confidential Client.
• Moved data between Azure and On-Premises machines using Azure Gateways (installed and configured both Azure Data Factory Gateway and on-premises Data Gateway)
• Very strong in TSql, Sql server Integration Services (ETL), Sql server 2012 Analysis Services (Tabular), Sql Server Reporting Services, Query Tuning. Worked on Replication and Service Broker.
• Architected a huge data warehousing solution from using SSAS, SSIS, Sql server 2012 and Power BI. This project eventually had 600+ million records at the end of Nov, 2015
• 80% of the reports developed are Self-service Power BI reports. Implemented Power Pivot, Tabular Model/Power View reports. The Power View reports are hosted on SharePoint 2013.
• Built Full and Incremental ETLs/ELTs using SSIS Packages on top of 600+ million records
• Right sized the CPU/Memory/IO/Page-file for the Database servers
• Used compressions and Partition techniques to perfection on Sql server tables so that the scans on the 400+ million records tables happen in < 10 seconds.
• Good knowledge of MDX, DAX and PolyBase languages. Implemented the Row level security for the self-service Reporting using DAX in SSAS(Tabular).
• Implemented month level Partitions on Sql Server Analysis Services Tabular Model and processed the changed Partitions from SSIS Packages on a daily basis.

TECHNOLOGY SKILLS:

Languages: C#, VB.NET, SQL, PLSQL

Databases: SQL Server 2012/2016, SSIS SSRS, Sql server 2012 Tabular Models

Web Technologies: ASP.Net, ASP.Net Ajax, Java Script

Frameworks: .NET Framework 2.0/3.5

Power BI: Power Pivot, Power Views, Power BI Desktop

Azure: Azure Sql Database, Azure Data FactoryAzure PowerShell, Service Fabric.

PROFESSIONAL EXPERIENCE:

Confidential

Architect

Responsibilities:

• Performed the Initial evaluation and Proof of concepts to use Azure Data Lake, Azure Data Warehouse OR Azure Sql Database, Azure Active Directory, Azure Data Factory and Power BI Desktop. We finally decided to use Azure Sql Database, Azure Data Factory, Azure Active Directory and Power BI Desktop.
• Implemented clustered column store indices to perfection so that the data is fetched into reports in sub-seconds from tables containing millions of records
• Designed and implemented data pulls using Azure Data Factory(ADF). Data was pulled from Azure Blob/On-Premises up-streams and Data was pushed into Azure Blob down-streams. Have used custom .Net activities in ADF. Implemented Alerts for Azure Data Factory failures.
• Built the Multi-dimensional models using Facts and dimensions in the Azure Sql Database using stored procedures, views and external tables. Implemented Non-clustered column store indices on transactional tables
• Used Azure PowerShell and Visual Source Online for implementing Continuous Integration-Continuous Deployment-Continuous Testing (CI-CD-CT). Used Azure PowerShell to up-size/down-size the Azure Sql Databases and to procure new Azure Sql databases on the fly.
• Used the Azure Service Fabric Stateless services for our windows services.
• Have set-up the Azure Active Directory Integrated Authentication with Sql Server Management studio. Waiting for the Power BI Desktop to support Azure Active Directory Authentication
• Developed self-service reports using Power BI Desktop & an in-house excel tool in Confidential .
• Following a devops and agile methodology for the past 15 months.
• The team was spread across Redmond and Hyderabad.

Tools: Azure Sql Database (V12 Servers), Azure Data Factory, Azure Blobs, Azure PowerShell, Visual Studio 2015, Git for source control, Visual studio test projects, Visual studio online

Confidential

Team Lead

Responsibilities:

• I architected a huge data warehousing solution with the self-service BI capabilities using SSAS, SSIS, Sql server 2012 and Power BI.
• Designed the multi-dimensional data model.
• Architected the ETLs using SSIS Packages. The Full loads are developed on top of 400+ million records and delta pulls on top of 1-2 million records
• The Data Warehouse was 2 TB in size and a single table in the DW has 600+ million records in Nov, 2015.
• Built a 10 GB MOLAP cube and a 4 GB SSAS Tabular Model on top of the Data warehouse
• Published the Data Mart to the Downstream and reporting systems.
• Implemented self-service using (Tabular Model-Power Views) & (Tabular Model-excel). Implemented row level security in all the Tabular models.
• Used Power-Pivots for reports where row level security is not needed.
• Self-service capabilities are implemented on top of Facts that contained 600+ million records.
• Implemented month level Partitions on Sql Server Analysis Services Tabular Model and processed the Partitions from SSIS Packages on a daily basis.
• Implemented Partitions & Compressions on the Sql Server tables that growing beyond 200+ million records and brought down the scanning times to < 10 seconds
• Right sized the Sql Server machines with 8 core processor, 64 GB RAM & 16 GB page file. Also right sized the Sql Server Analysis server machines with 8 core processor, 32 GB RAM & 16 GB page file. Ensured page file is not part of the C drive. Ensured sufficient free space on the C drive.
• Implemented SSRS Reports & Excel reports where the business logic is complex and the request cannot be accommodated into self-service reports.
• Installed SharePoint 2013 with Power BI components when the Infrastructure team lacked knowledge to install SharePoint 2013.
• The team was spread across Dublin and Hyderabad.

Tools: Sql Server 2008 R2, SSRS, SSIS, Sql server 2012 Tabular Models, Power Views, Power Pivots, Excel 2013/2010

Confidential

Team Lead

Responsibilities:

• I lead the development of the BI system for the Dynamics CRM project. A total of 35 Complex SSRS Reports and 25 Out of the Box CRM Charts (bar graphs and 3D Pie charts) are implemented. Dashboards contained the CRM Charts
• Prepared a POC of a Dashboard involving both the out of the box CRM charts and the SSRS charts. The client chose to go with CRM charts. All the other dashboards are easily implemented as result of this POC.
• Written complex TSQL procedures for SSRS Reports. Developed analytical reports using matrix control.
• Coordinate with the onshore team and raise the queries or gaps that we find in the business documents.
• Review all the reports, stored procedures and test scripts built by the team members.
• Optimize the slow running Queries by analyzing the sql plans
• Went to UK for 2 months to help the business users during the UAT with any queries. Gave a knowledge transfer session to the Management Information Analysts in UK on how to use Dynamics CRM Advanced Find Queries.
• Written Sql Scripts that inserted 7+ million records into all the transaction tables in 70 minutes for Performance testing. Batched records to insert into the database.
• Received appreciation from the Client and Onshore multiple times.

Tools: Sql Server 2008 R2, SSRS, BIDS, VS 2010, C#, Dynamics CRM Charts and Dashboards

Confidential

Team Lead

Responsibilities:

• I was responsible for SCEDA and IM applications so that they communicate with APO, OPS DW and GPS systems in Gregorian calendar aligned weeks.
• Making changes to the SPs, functions to send the date data in broken weeks rather than 7 day week buckets when the week is shared by both the months.
• Adding the indices to high volume tables to improve performance
• Gregorian calendar changes to Demand & Revenue cubes in GPS. The TimeDim table should be aligned to the new Gregorian calendar and need to process all the fact data again.
• SSIS Packages to import data from OPS DW, GPS, SCEDA to Inventory Modeling.
• Changing the TimeDim relationship in ForecastDW SSAS cube and redeploying the cube.
• Integration testing as this is system involves many independently working systems.
• Preparing the builds that deploy and rollback all the above changes to SIT, UAT and Production databases

Tools: Sql Server 2000/2005, SSIS, SSAS, Management Studio, BIDS