정석원

스킬: Microsoft Excel, 데이터 분석, Power BI

● Developing Mobile Application('claim taLK') for Employee Health Benefit Program - Deriving key requirements from Interviewing employees and researching competitors' applications - Sourcing proper app developers based on the key requirements - Checking the milestones and timeline to achieve the requirements - Adjusting internal voices not to expand the initial scope. ● Establishing Security and Compliance Monitoring Functions(with using Microsoft WIP, DLP) - Setting up the guidelines for security and compliance - Communicating with consultants for adequate security configuration on endpoint devices - Educating and supporting all the employees for the adaptation ● Introducing Contract Management System(with Microsoft Dynamics 365 Sales and Power BI) - Analyzing existing documents to derive key indicators and templates for the contract management - Interviewing employees to get the work processes and deficiencies - Communicating with developers to design processes and data tables - Educating and supporting all the employees for the adaptation

● PLM(Project Lifecycle Management) Process Innovation - Designing the PPM system process, metrics, dashboards at CPG firm (5 months) ● Introducing Data Analysis & Machine Learning - A pilot project at CPG firm (2 months) as Acting PM ● Profitability and Strategic Diagnosis - KPI redesign project at a private club (2 months, PM) - Diagnosis for internal M&A at construction firm (2 months) - Market analysis for market penetration strategy at AMHS manufacturing firm (2 months, PM) ● Master data management - Master data re-design project at the broadcasting firm (3 months) ● Introducing RPA - A pilot project at a CPG firm (2 months) - A Pilot and succeeding projects at a cosmetic company(4 months) - A pilot project at a publishing company(2 months, acting PM)

1. Data Analytics & Visualization Specialist (2013.09 ~ 2017.12) ● Designing dashboards for different purpose on OBIEE – Drawing dashboards for beginners to check daily KPIs (about 20 pages) – Drawing dashboards for executives to monitor and report daily (about 20 pages) – Drawing early warning dashboards to distinguish fraud ticketing, agents (about 4 pages) ● Managing revenue database and designing new database – Checking conformity of sales data between before and after migration (over 300 mil. data) – Modifying logical structure according to the migrated sales data – Designing new database fit on different evaluation process for branches – Extracting and processing sales data with SQL to access the appliance(IBM Netezza) – Integrating and simplifying the process to upload data manually ● Lecturing how to use OBIEE – Publishing and distributing user manuals and FAQs to HQs and all the branches – Developing online and offline lectures for users – Instructing offline lectures for users (4+ times per year, both of Korean & English) 2. Route Analyst (2013.01 ~ 2013.09) ● Analyzing trend of flight sales to control controlling frequency and aircraft type for handling capacity ● Researching media related to destinations: Tourism trends, Activities of Competitors and Agents 3. Reservation and Ticketing Coordinator (2011.01 ~ 2013.01) ● Consulting fare regulations and pricing to travel agents ● Supervising newly hired coordinators according to the transferring service center to Kuala Lumpur

학점: 4.01 / 4.30 ● Information Technology Strategy & Management, Business Analytics, e-Business Strategy, etc. Global fan analysis of BTS as a graduation project(on going, 570 thousand data) ● Studying data analysis, visualization with R in KDSG(KAIST Data Scientist Group)

학점: 3.64 / 4.30 Coursework includes: Strategic Management, Management Information Systems, Consumer Behavior Analysis, Relationship Marketing