Wonbae Kim

• Lead the project and analysis/design/develop & operation Samsung BI systems.

• ETL(SSIS) and SQL Cube (Tabular & SSAS: SQL Server Analysis Services) development for Samsung product's sales analysis, Sell-In/Sell-Through/Sales/Inventory/WOS(Week of Supply)/Revenue/Stock-out (by Channel/Carrier/Store and SKU Level) and more analysis

• DW(Data Warehouse) and DM(Data Mart) construction and operation management

• Create and manage a full analysis diagram and dataflow for the collection of various data sources across multiple systems.

• Data accuracy improve (Tracking the missing data, Monitoring the unmapped SKU and Comparing with the original data sources)

• Customized dashboard production and continuous upgrade to improve the efficiency of analysis work for executives and end users.

• Performance Improvement of Analysis System (Translate Multi-Dimension Analysis model to In-Memory Tabular model)

• Development the DAX (Data Analysis Expressions) calculation measures for various analysis/statistics & forecast values.

• Develop Power BI with Datasets, Data models, and Dashboards through a Data gateway.

• Developed Data Mart and Power BI Dashboard by calling Amazon Realtime Sales data API using Python.

• Developing analysis models for analyzing KPI indicators (MBO: Management by Objectives, etc.) of various users and providing Excel Pivot analysis guides and analysis reports.

• Build and Development by Azure Synapse Analysis

• Improvement of work efficiency and document collaboration function development and guide using Samsung SDS America’s intranet system (SharePoint) à I am a SharePoint Expert as well.

Proposals for finding business for external services and preparation of business proposals.

• Development the Enterprise collaboration system through SharePoint or Microsoft BI analysis system (ETL, Dashboard)

• Lead the project, make application design and development the system

Samsung ISAQ project, NJ & Korea

(Jun 2015 ~ Sep 2015)

- Samsung ISAQ(Integrated Service Agreement & Qualification) Project

- Lead the project and application design

- Develop a custom web page and implement business workflow using Infopath in SharePoint.

- Technology: SharePoint, C#, MS-SQL

SharePoint Online & Cloud PoC project, Korea

(Apr 2015 ~ May 2015)

- The technical review and development verification requested by Microsoft Korea. (Integration system for SharePoint Online with MS Azure Cloud)

- Technology: SharePoint, C#, MS Azure Cloud

Samsung RMSS project, NJ/USA

(Nov 2014 ~ Apr 2015)

- RMSS(Retail Mapping Support System) for SEA as SharePoint developer and Data engineer

- Lead/Development the UI part of the dashboard and development the ETL(SSIS)

- Technology: MS-SQL, SSIS, BI Report, JQuery, Dev Extreme, SharePoint, C#

Samsung SRM project, NJ/USA

(Feb 2014 ~ Apr 2014)

- SRM(Samsung Retail Mapping) System for SEA as SharePoint developer and Data engineer

- Lead the back-end area and design application

- Design BI report and analyze business needs

- Technology: MS-SQL, SSIS, BI Report, SharePoint, Dev Express, Open street map

S-Oil Information Collaboration project, Korea

(Dec 2013 ~ Jan 2014)

- S-Oil Information Collaboration System as MS BI Report Developer

- Lead the project and design data modeling

- Technology: MS-SQL, SSIS, BI Report, SharePoint

Samsung C&T Corporation Global Strategy System project, Korea

(Nov 2013 ~Dec 2013)

- Samsung C&T Corporation Global Strategy System as SharePoint and JQuery developer

- Design application and data modeling

- Technology: SharePoint, JQuery, MS-SQL

KT PKB System project, Korea

(Jul 2013 ~ Sep 2013)

-PKB (Project Knowledge Bank) for KT as developer

- Lead the project and design application process and data model

- Technology: SharePoint, ASP.Net, JQuery, MS-SQL

LG Chemical GBIS project, Korea

(Mar 2013 ~ Jun 2013)

- GBIS(Global Battery Information System) for LG Chemical as developer

- Technology: SharePoint, ASP.Net, JQuery, MS-SQL

• Development the Enterprise collaboration system through SharePoint or Microsoft BI analysis system (ETL, Dashboard)

Samsung SEA CPFR project, NJ/USA

(Sep 2012 ~ Oct 2012)

- CPFR(Collaborative Planning Forecasting and Replenishment) for SEA as PL

- Design the dashboard and data modeling

- Technology: SharePoint, MS-SQL, BI Report, Silverlight, C#, ASP.Net

LG Smart TV Dashboard project, Korea

(Mar 2012 ~Aug 2012)

- Smart TV Dashboard System for LG Electronic as developer

- Lead the UI part and design application and data model

- Technology: SharePoint, MS-SQL, BI Report, Silverlight, C#, ASP.Net

Samsung Life EDW(Enterprise Data Warehouse) project, Korea

(Mar 2012 ~ Aug 2012)

- EDW(Enterprise Data Warehouse) System for Samsung Life as developer

- Lead the BI report area and design BI report

- Technology: SharePoint, MS-SQL, BI Report, C#, ASP.Net

LG QIS(Quality Information System) project, Korea

(Mar 2011 ~ Jun 2011)

- QIS (Quality Information System) for LG Electronic as developer

- Lead the UI part and design application and BI report

- Technology: SharePoint, MS-SQL, BI Report, Silverlight, C#, ASP.Net

Dongbu BI(Business Intelligence) project, Korea

(Jun 2010 ~ Aug 2010)

- BI(Business Intelligence) System for Dongbu as developer

- Design BI report and data model

- Technology: SharePoint, MS-SQL, BI Report, C#, ASP.Net

Korea Smart Card QIS project, Korea

(Nov 2009 ~ May 2010)

- QIS(Quality Information System) for Korea Smart Card as developer

- Technology: SharePoint, MS-SQL, BI Report, Silverlight, ASP.Net