Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Shannon Lin

Kent,WA

Summary

  • Tech lead in the Business Intelligence, Prototype tooling, Advanced Analytics and Production Service / Data Engineering. Cloud Operations & Innovation (CO+I), Microsoft, Corp. Creating and supporting automation of OKR(Objectives and Key Results) generation for SLT to track global datacenter supply / demand fulfillment.
  • Building from scratch, a scalable program delivering high-impact solutions built in Power BI with an Azure engine including Azure Data Factory, Kusto, SQL, Key Vault. Overseeing the implementation of private endpoints utilizing AzureVPN. Leading E2E solution build from conceptual phase to physical implementation and continuous support for seamless user experience.
  • Utilize Azure and everything it has to offer by building prototype solutions that can be quickly tested and featured, responding to an industry that requires agility and quality. Key workstreams include planning around capacity demand, supply and constraints, land acquisition and other day-to-day business operations.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Program Manager

Microsoft
12.2021 - Current
  • Created multiple Power BI reports with focus on dynamic and interactive content.
  • utilized advanced features such as Drill down, Drill through and page tooltips to provide detailed insights into data.
  • Created datasets and dataflows for seamless collaboration with team members.
  • Designed highly scalable data models using star schema, role-playing dimensions, and factless fact tables for efficient data organization and analysis.
  • Built Azure Data Factory pipelines to conduct ETL process which source data from diverse data sources, including Azure SQL Database, Excel, flat files, API, JSON files, and Kusto database.
  • Created multiple Power Apps (Canvas Apps) read and write data from diverse sources, including Azure SQL Database, SharePoint, OneDrive, and Dataverse virtual tables.
  • Wrote complex queries using joins, subqueries, and other advanced techniques to apply business logic.
  • Create numerous stored procedures, user-defined functions, and triggers to help automate business process.
  • Used varies temporary objects like Common Table Expressions (CTE), table variables, and temporary tables to enhance query efficiency and modularity.
  • End to end program management adeptly overseeing Microsoft's global datacenter development life cycle. Skilled in supply chain, planning strategy, and finance domains, ensuring seamless execution and optimization throughout the process.


Senior Analytical Consultant

Brillio
02.2020 - 12.2021
  • Created and optimized Power BI reports to help stake holds making business decision.
  • Using SSMS (SQL Server Management Studio) to create database object, like tables and views, stored procedures and table value functions to simplify business process or to support data loading.
  • Designed complicated SSIS packages to help load on-prem files into azure SQL database.
  • Created VBA procedures to make Heavy formularized excel files to be ETL tool friendly
  • Created ADF (Azure Data Factory) Pipelines to make existing ETL process to the cloud
  • Helped migrate old data base to a new subscription within Azure.
  • Created multiple linked services on ADF to connet to varias datasources, like Aure Blob Storage, Cosmos DB, Kusto Database, Azure database or API
  • Created data quality reports for planners to use as KPI management method. Help management to have insight on the quality control
  • Wrote complex T-SQL queries to make sure the data in Power BI reports are as dynamic as possible.
  • Optimized Power queried and fine toning data model in Power Bi reports for better performance.
  • Created User Interface with Power APP to help simplify business process.
  • Created multiple Flows (Power Automate Flows) to apply complicated business logic when processing the data from canvas app
  • Dedicated with data quality control to ensure data integrity.

Database Engineer

Aptive Environmental
07.2018 - 11.2019
  • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
  • Addressed ad hoc analytics requests and facilitated data acquisitions to support internal projects, special projects and investigations.
  • Prepared documentation and analytic reports effectively and efficiently delivering summarized results, analysis and conclusions to stakeholders.
  • Created Stored Procedures and other database object to help analysis works
  • Created SSRS and Power BI reports to visualize the data for decision makers
  • Developed, implemented, supported and maintained data analytics protocols, standards and documentation.
  • Created seasonal sales reports for stake holders to understand sales team performance.

Data Specialist

L&R International Trading
10.2015 - 04.2018
  • Helped business owner with day to day warehouse operation.
  • Helped business with order management and supply chain
  • Participated in our own ERP system development
  • Created daily/ weekly/ monthly sales reports to help business owner understand sales performance and have vision in trending goods and market reactions for the products on sale.
  • Participated in the prototype design for our user end mobile app

Education

Bachelor of Science - Public Affairs And Public Policy Analysis

Capitial Medical University
Beijing, China
07.2013

Skills

  • Analytical skills
  • T-SQL (Transact SQL)
  • SSDT (SSIS,SSAS,SSRS)
  • Power BI
  • Power Apps
  • Power Automate
  • API/Json
  • VBA
  • DAX / MDX
  • Data Modeling
  • ADF (Azure Data Factory)

Certification

Microsoft Certified: Power BI Data Analyst Associate

Earned on: Aug 11, 2023

Certification number 9538BD-275CAS


Microsoft Certified: Azure Data Fundamentals

Earned on: Aug 19, 2023

Certification number 5R4F20-7CD245



Timeline

Senior Program Manager

Microsoft
12.2021 - Current

Senior Analytical Consultant

Brillio
02.2020 - 12.2021

Database Engineer

Aptive Environmental
07.2018 - 11.2019

Data Specialist

L&R International Trading
10.2015 - 04.2018

Bachelor of Science - Public Affairs And Public Policy Analysis

Capitial Medical University

Similar Profiles

  • Catalina Dinu

    Catalina DinuCatalina Dinu

    Senior Technical Support Engineering Manager at MicrosoftSenior Technical Support Engineering Manager at Microsoft

  • TONY HAUGEN

    TONY HAUGENTONY HAUGEN

    Partner Customer Account Manager / Customer Success Account Manager at MicrosoftPartner Customer Account Manager / Customer Success Account Manager at Microsoft

  • Denis Mazurov

    Denis MazurovDenis Mazurov

    Senior Software Engineer at MicrosoftSenior Software Engineer at Microsoft

  • Shubham Singh

    Shubham SinghShubham Singh

    Software Developer II (Level 62) at MicrosoftSoftware Developer II (Level 62) at Microsoft

  • NSOFINI BIME

    NSOFINI BIMENSOFINI BIME

    SQL Server Database Administrator at Trader Joe’s CorpSQL Server Database Administrator at Trader Joe’s Corp

CREATE PROFILE
Shannon Lin