Responsible for Energy system company corporate BI solution.Initialized NAES first BI and built BI from ground up on corporate controller pack successfully in 3 months with presentation to company finance meeting.Designed and developed NAES BI Solution at On-Prem platform in 2018 and migrated to Azure Cloud data platform in 2020 with Microsoft BI stack. MS Power BI, Azure mi-SQL, Azure Analysis Services, Azure Data Factory pipeline, ETL/ELT, SSIS, Stage, Data warehouse, DataMart, and OLAP cube with row level and column level security. Business domain included corporate finance data, power plant finance data, power plant marketing data, sales marketing data, HR data and Dynamic CRM data.Research Azure Synapse Analytics, IoT Pi data for Power Plant large data integration

Microsoft Universal Store Sales Core Team BI development and maintenance by utilizing technology on Big Data, COSMOS, SCOPE, C#, SQL, OLAP Cube. Dev Team Technical PM. Finance Operation MS Sales and GBI Weekly and Monthly Reconcile Reporting PM. Lead a team of 5 developers and technical screen 4 additional resources to form a strong vendor team at Microsoft Redmond.

As a Microsoft Management Services Consultant at Consumer and Device Sales (CDS) Scorecard Systems and BI, I have fun to work with large technology group and business domain leader/subject expert to deliver Microsoft Retail Business Intelligence Solution for Microsoft product(Xbox, Surface, Office, Windows, and Accessories, etc.) as We-Team.List of my accomplishments1. Designed and implemented row level OLAP cube security model to compliant with Microsoft all MS Sales users and Mercury users credential. Launched OEM BI cube (Tabular) and BREMA BI cube (Tabular) w MS Sales OEM row level dynamic security mask on organization related dimension attributes value in 8/2017. This is possible the first creature within Microsoft on OLAP security.Launched One cube (Multi-dimensional) w Profit Loss(PnL) and MS Sales composite row level security on different geography view. Innovated the 3 keys binding bridge out of box solution to resolve security dynamical driven on different measure groups associated with user, permission type, and dimension. It was an innovation back to 12/2014 which solid the BI data platform application compliant with Microsoft security policy and continued to grow the team to leverage 20+ source on boarding with stability on HBI (high business impact) data.2. Completed 250+ BI data platform design and development Sprint tasks to deliver BI solution end to end from source system data scrub, to stage, to warehouse, to data mart, and to OLAP cubes. 3. Initial monthly business update and quarterly business update close cube automation process.4. Provided data platform team members guidance and solution on urgent production issues and critical trouble-shooting. Led offshore developers for BI development and meeting.5. Main developer for BI data platform FY16 and FY17 fiscal year rollover.6. Design an enterprise data integration hub for Channel Marketing process to leverage commercial data. 7. BI Portfolio Architecture roadmap input and discussion.

1. Worked with C-level, VP, directors, and finance team for BI release, requirement gathering, POC, meeting, user acceptance test, and change management process. Excellent result driven and customers focus skill. 2. Designed, developed, and maintained retail industry enterprise system corporate BI solution. Main technology was MS based. Delivered 8 releases to production successfully. Integrated with PC-POS Fujitsu system transaction level data with 30 digits scanned barcode parsing. Transaction flow was 2TB per year.3. Delivered corporate BI solution end to end. (340+ stores DB, Merge/Trans Replication, OLTP DB, Log shipping, ETL, SSIS, meta data, data mart, OLAP cube and reporting). 4. Designed and developed store, district, region, corporate level security model on OLAP cube. 5. Designed and developed business intelligence solution for merchandise and Halloween holiday sales. (Ordering system, allocation, shipment tracking to retail scanned sales). Drill through to detail on item, store, and hourly sales levels in near real-time.6. Maintained OBIEE HR analytics daily ETL process by informatica and DAC. 7. Built operational data store for call center. This served the corporate EDW backbone for BI reporting.8. Managed 10 + BI servers and configured them for BI reporting. 9. Technology evaluation for corporate BI solution.10. Worked with Microsoft sales team on Power Map POC project (weather, social media, and stores location)11. Industry certification: CBIP, CDMP, and CDP

(Consultant) - Finance (BMO, SMS&P, EPG, Dynamics) Business Intelligence Packs Development, ETL, Data Warehouse, SQL Server, SSIS, SSAS, OLAP, MDX.

ELT, DW, S2T Mapping, extraction engine stored procs coding, legacy system migration and techincal documentation.

(Consultant) Data Warehouse, Data Mart, MSSales Extract, ETL, OLAP, MDX, Finance BI

ETL and Finance BI

(Consultant) ETL, Data Warehouse, BI, Finance Reporting

(Consultant) Database Development, ETL Process, Finance web application(C#, .NET)

ETL, BI, Reporting, CRM, Telecom industry