SUMMARY

• Solid experience with data analytics and data visualizations in Cosmos and Azure Data Lake Analytics.
• Experience in Database Programming using RDBMS databases like SQL Server 2012/2014/2016.
• Experience in designing and developing software applications using Visual C#.Net and ASP.NET.
• Experience in providing effective solutions using Confidential Business Intelligence Tools like SSIS, SSRS and SSAS, also solid background producing analysis and metrics, covering both financial and operational functions in fast changing environments.
• Good hands on experience in SCOPE (Scripting Language)/Cosmos and PowerBI.
• Good hands on experience in Azure Services (Azure Data Lake / Azure SQL DB).
• Quick learner, Self - driven enthusiast, exceptional problem-solving and trouble-shooting Capabilities.

TECHNICAL SKILLS

Distributed System: Autopilot, Cosmos, Azure Data Lake Analytics

Language & Tools: C#, GIT, SQL, PowerShell, Scope, USQL, Azure SQL Database, Power BI

PROFESSIONAL EXPERIENCE

Software Engineer

Confidential

Responsibilities:

• Build a dashboard for QA environment and for production environment using PowerBI.
• Write PowerShell scripts to submit U-SQL distributed query performance test jobs to Azure Data lake cluster.
• Write U-SQL scripts to collect job failure statistics and put it into daily cron to monitor the healthiness of the cluster.
• Own Azure Data Lake Analytics Performance Testing pipeline.
• Ship Azure Data Lake Analytics, provide performance report to Ship Room every Prod Push from Private Preview, Public Preview to now.
• Create Performance Testing Framework to automate performance testing, including data preparation, test execution and result visualization.
• Maintain and configure performance testing cluster according to specified requirements via APGold.
• Create Telemetry dashboard.
• Leverage Azure SQL Database to process data and PowerBI to visualize reports.
• Mine cosmos event logs to measure the health of ADLA and drive related component team to fix issues.
• Maintain existing E2E testing framework and debug big data job failures.

Software Engineer

Confidential

Responsibilities:

• Design a visual delivery solution which “tells the story” of Datacenter builds and Datacenter performance for MS ‘Go Local’ projects.
• Entirely dedicated to design and develop Power BI Reports and Dashboards.
• Gather data from different sources and transform the data, enhance the data for analysis, and produce reports and dashboards.
• Involved in data analytics, understand and leverage data driven architecture and solutions.
• Mock up Power BI reports for Datacenter build.
• Design and develop a collection of base-level revenue reports for Datacenters performance.
• Create the necessary SQL objects and models to integrate disparate data sources.
• Actively worked with stakeholders to define requirements, feature requests and feedback.

Technical Environment: Power BI Desktop, Power BI Online, Power Pivot, SQL Server Tabular Model, AZURE Data Lake, SQL Server 2016, SQL Server Data Tools 2015, SSIS 2016, and SSRS 2016.

Software Engineer

Confidential

Responsibilities:

• The Billing team is in a unique position with a charter of three lines of business: Display Advertising, Paid Search (monetizing the Bing search results) and Payout for their publishers.
• Actively involved in creating SSIS package which helps to migrate data from a disparate source into SQL Server.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Managed and troubleshoot common ETL issues such as database connectivity, mapping failures, resource limitations, and validated data quality.
• Developed SCOPE (COSMOS) scripts to pull onboard customers billing data from Commerce Platform and outputted the data to various streams.
• Created and modified Stored Procedures, Functions, and Indexes based on the business changes and for new features.
• Designed Dashboard, Drill-down Reports, Drill down Charts, Summary Reports, Navigational Reports, and Linking Reports using both SSRS and Power View as visualization tools.
• Report deployment, tuning, subscriptions, schedules, security and end user delivery.
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly, and Monthly processes.
• Sync in daily for SCRUM meetings on features, bugs, progress and share updates.

Technical Environment: SQL Server 2012/2014, SQL Server Data Tools, SSIS, SSAS, SSRS, COSMOS, SCOPE Studio, SQL Azure, C#, Power Pivot, Visual Studio 2012/13, TFS, Code Flow 2010, PowerShell.

Software Engineer

Confidential

Responsibilities:

• The SharePoint Data Center Team which belongs to the large SharePoint enterprise team specifically focuses on the integration and migration of clients from various versions of SharePoint both on premise and in the cloud.
• Populate SharePoint portal site list using Integration Service (SSIS) packages.
• Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
• Write T-SQL scripts, stored procedures, views, based on business requirements.
• Create, Maintain & Schedule various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SSRS.
• Create new and modify multiple database objects like Store procedure, Views, Functions, and Triggers to meet the requirements.

Technical Environment: SQL Server 2012, SQL Server Data Tools, SSIS, SSAS, SSRS 2012, C#, Visual Studio 2012/13, SharePoint 2013, PowerShell, TFS, Windows server 2008R/2012, Code Flow 2010.

Software Engineer

Confidential

Responsibilities:

• The MS hardware software team is developing LifeCam software and Device App.
• UI Automation, Mock testing and Involved in bug triage and follow up the bug to be fixed.
• Automated test Case Development for functional testing.
• Converting the old Test Cases from MCF framework (semi-automation job) to TAEF (full automation job)
• Automated and Integration testing on the product and Investigate on failed test cases.

Technical Environment: C#, Visual Studio 2010, VSTS, Coded UI, Mita, WTT, Code Flow 2010, Source Depot, MS Product Studio, and Bug Tracker

Software Engineer

Confidential

Responsibilities:

• Involved in a team of three on migrating and upgrading the organization existing static website to dynamic website.
• Involved to redesign, refactoring existing source code and implemented the user interface.
• Maintained, updated, and enhanced the organization site.
• Involved in designing the backend Database from scratch.

Technical Environment: C#, ASP.Net, SQL Server 2008, Visual Studio 2008, Visio, HTML, Java Script, CSS, IIS.