Big Data Architect Resume

SUMMARY

12+ years of work experience in Data Engineering, Data Visualization and Data Warehousing using cutting edge Microsoft technologies.
2+ years data engineering experience using Big Data technologies such as Cosmos, Kusto (Azure Data Explorer), Azure Data Factory(v2) technologies.
2+ years data visualization experiences using SSRS and Power BI.
4+ years of experience in Data Warehousing and ETL using MSBI Stack (SSIS, SSRS, SSAS).
3+ years of experience in Web Application Development using ASP.NET and C#.
Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
Experience in Azure system configuration, database migrations, backup and recovery, Load balancing, performance monitoring and tuning and disaster recovery configuration and execution.
Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
Experience in preparing ETL design documentations, user test case documentation and standard operating procedures (SOP) documentation.
Experience of working on onsite - offshore model.
Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

ETL: SSIS, ADF v2

Analytics: SSAS(Tabular), Azure Analysis Services

Database: MS SQL Server 2008-2016, Oracle 10g, Azure SQL

Reporting: Power BI, SSRS, Excel, Crystal Report

Language: T-SQL, C# .Net, PowerShell, ASP.NET

Big Data: Cosmos, Kusto

Web: HTML, CSS

Source Control: VSTF, VSS

CI/CD: Azure DevOps

Data Modelling: MS Visio

PROFESSIONAL EXPERIENCE

Confidential

Big Data Architect

Technologies used: Cosmos, Azure Analysis Service, Azure SQL, Power BI, Azure Functions

Responsibilities:

Implement ETL process to move data from Cosmos to SQL Azure Database using SQLizer, Xflow, SQL Azure Database and Azure Analysis Services.
Automated Cube refresh using the Azure Functions
Conduct data exploration using Scope or iScope for problem understanding.

Confidential

Big Data Architect

Technologies used: Kusto, Power BI, SSAS

Responsibilities:

Getting data from Kusto to calculate the QoS(Availability, Reliability, Performance)
Moving the DB backups to Azure Blob with retention using PowerShell Script.
Worked on the AzSDK to reduce the security and vulnerability on the Subscription.
Created Power BI Disk Space reports for all the MSXI Servers.
Configured the Load Balancing for the Daily Recommender API in Azure.

Confidential

Big Data Architect

Technologies used: ADF, Cosmos, ADW, SQL Server, SSAS, PowerShell, Power BI

Responsibilities:

Created the Scope script to pull the data from various sources and scheduled it using PowerShell with meta data approach.
Created the ADF pipeline to push the data from staging to Azure SQL Datawarehouse and Tabular Cube.

Confidential

Big Data Architect

Technologies used: SSIS, SSRS, Excel, SQL Server

Responsibilities:

Creating the SSIS Package to pull the data from various source using the Meta Data Driven framework.
Creating the SSRS/Excel Report and publishing it to Production Environment.