Data Warehouse Engineer

• Aug 2022 - Present

Data Engineer

• Sep 2019 - Aug 2022

1. 아모레퍼시픽 Service Operation(SO) 프로젝트 - Oracle, AWS, MySQL에 적재된 영업계 데이터에 대해 기반의 분석계 ODS 영역 ETL 설계 및 개발 : Netezza, Hadoop의 경우, Informatica tool 활용 : AWS의 경우, Spark, Airflow 활용 - 각 경로 별 Netezza, Hadoop 기반의 Data Mart 설계 및 개발 : Netezza의 경우, Informatica tool 또는 procedure 실행 : Hadoop의 경우, hive 쿼리로 작성하여 shell script 실행 - CRM 캠페인을 위한 고객 타겟팅 및 캠페인 결과 집계 - 고객정보 삭제에 따른 고객번호 암호화(SHA-512) 및 ETL 수정 - 각 경로 별 실적 데이터 추출 및 데이터 확인 지원 : Microstrategy OLAP tool 사용 또는 쿼리로 직접 추출 - ETL 모니터링 및 장애 발생 시 대응 2. RHOS Openshift POC 프로젝트 - Java SpringBoot, MongoDB 기반으로 이니스프리몰 리뷰 시스템 구축 - MicroService 방법론을 도입하여 성능 최적화 Show less

Field Application Engineer

• Jun 2017 - Sep 2019

• Provide post-sales technical expertise during installation, implementation and maintenance of software modeling tool(IBM Rational Rhapsody) • Provide tool training with UML modeling skill • Perform tool demo for automotive and avionics field applications • Provide technical assistance in automotive consulting regarding ASPICE, ISO26262 and AUTOSAR specification • Preside over both sales and technical meeting between Hancom MDS and IBM global team • Prepare and deliver technical presentations explaining products or services to prospective customers • Handle Duzon ERP with sales order Show less

Intern

• Mar 2017 - May 2017

• Planned sports ICT items such as player management system based on IoT and tactics suggesting system based on Big Data analysis and AI for Korean National Soccer Association • Wrote sports ICT items technical proposal for projects under Ministry of Culture, Sports and Tourism • Prepared presentation materials for press conference of MOU between POSTECH and Korean National Soccer Association • Wrote business item proposal using drone technology for project under Korea Creative Content Agency Show less

Intern

• Jan 2017 - Feb 2017

• Created, managed and edited webpages using SDL, a cross-platform multimedia library 01.2017-02.2017 • Reported error regarding webpage management to global headquarter • Uploaded product information in online database system • Tested application to be launched and reported error and suggested ideas to global headquarter • Supported conference by managing invitees’ information using Excel and Enfax, address handling online database system • Matched correct URLs for keyword in Naver search engine Show less

Intern

• Jan 2016 - Feb 2016

• Researched IoT Smart Farm market trends and network protocols for IoT sensor communication such as Lora and MQTT • Planned Smart Farm system based on IoT and created prototype of mobile application • Designed database system • Researched IoT Smart Farm market trends and network protocols for IoT sensor communication such as Lora and MQTT • Planned Smart Farm system based on IoT and created prototype of mobile application • Designed database system