BI Developer Resume

SUMMARY

Creative software engineer with over 13 years of experience developing/Testing BI (Big data) solutions.
Able to pick up new skills quickly and always interested in new technology.
Passionate about data and data processing for the extraction of meaningful insights to drive right business decisions.
Building /testing ETLs to support multiple teams/products at Microsoft such as XBI and Marketing (Campaign Execution).
Design and migrate Microsoft Studios Data warehouse to Microsoft SQL Azure Data warehouse.
Design and Develop Microsoft Studios Data warehouse for Xbox and Windows titles.
Develop pipelines in Azure data factories to extract data from Microsoft Big data Platform (Cosmos) and SQL Server.
Build ETL’s to extract data from Microsoft Big Data platform (Cosmos), Flat files and SQL Sources.
Delivered quality in MIP BI platform by performing testing at various stages of product development which include data quality, ETL, Cube, System and Integration testing.
Developed test automation for ETL/Data quality testing.
Owned Test Strategy, Test Plan, Test Cases.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 8 /Windows 10

PROGRAMMING LANGUAGES: Scope, T - SQL, C#.NET, VB.

DATABASES: SQL Server 2008/2012/2015/2016 , Azure SQL Data Warehouse

TOOLS: SSAS, SSIS, COSMOS, Azure Data Factory Service.

Source Control: Visual Studio 2013 /2015.

PROFESSIONAL EXPERIENCE

BI Developer

Confidential

Responsibilities:

Create detail design documentation for implementation and oversee the successful and timely deployment of solutions.
Create structured/Unstructured streams from Cosmos for daily consumption into Data warehouse using Scope and C#.
Design and implement Azure Data Factory (ADF) pipelines for data loading into Azure Blobs and SQL Azure Data Warehouse (ADW) from Cosmos and OnPrem SQL Server.
Design and Implement data base entities and procedures in SQL Server and SQL Azure Data warehouse.
Design and implement ETL processes to consume the unstructured streams into SQL Data warehouse.
Schedule Jobs using XFlow and monitor the streams.
Develop Data Quality Monitoring /alerting between Cosmos and Azure SQL data warehouse.

BI SDET

Confidential

Responsibilities:

Feature Quality Lead for several critical releases for MIP.
Delivery of Test Plan, Test Case Design and feature estimations.
Test Automation for the features owned and some of the testing areas.
BVT test case design and automation.
Other key activities in testing include
Data Quality validation from source to data mart through various stages using t-SQL scripts.
Test data simulation at sources for various user scenarios and data flow validation till mart.
Cube testing including grain verification, cube calculations, user hierarchies, attribute, property and security testing.
Deployment of Development builds in different Test environment serving different purposes and investigation of ETL failures.
Test environment maintenance.

Software Engineer

Confidential

Responsibilities:

Worked as a software engineer with multiple clients through TCS Pune In India and global development center at Bellevue.
GDC evangelizes in upcoming Microsoft technologies and works closely with Microsoft in some of the upcoming technologies as early as beta versions of the product.
GDC also provides client services to US clients.