Data Analyst Engineer

HYOUNG CHOI

**** ********** *****, ****, ** ***** 248-***-**** **@****.***

I am a dynamic, high energy Sr. Data Engineer, Data Architect, Data Analyst and Software Engineer looking for a new opportunity. I enjoy fast paced environments, and I am calm in high intensity situations. I have deep data technology expertise. I have solid automotive knowledge and background, I have significant content management experience, but I am comfortable in any industry, and I am always willing to learn new business practices and processes. My philosophy is simple, I want to make a difference every day and I want to have a little fun doing it. I would like to work in or help create a state-of-the-art data environment where I can help empower people that make decisions with data every day. From a technology perspective I have extensive experience in database technologies like Oracle, SQL Server, Postgres, MySQL and Informix. I have experience with Cloud technologies like AZURE and AWS. I have experience with programming languages like PERL, XML, Java, Python, and C. In the last 27 years, I have developed more than 1 million lines of code over more than 180 projects. I have designed more than 30 front-ends and back-ends for websites. I am a versatile and confident technologist that has solid technology experience, but I also love to learn new technologies and I learn new technologies quickly. Sincerely,

Hyoung Choi

HYOUNG CHOI

6115 Smithfield Drive, Troy, MI 48085 248-***-**** **@****.*** Data Architect / Data Analyst / Data Engineer / Content Manager / Enterprise Business Analyst / Software Engineering

Cloud Based Data Management / Azure Cloud Platform / Agile / Content Management / Business Analytics / Enterprise Architecture / Databases / Data Visualization https://www.linkedin.com/jobs/view/394*******/

I am a senior Data Architect, Data Analyst, Content Manager, Software engineer and Developer with significant experience building enterprise data environments both on premises and in the cloud. I have moved and modernized on-premises data environments to the cloud, and I have created modern cloud data architectures to replace premises legacy architectures. Once Architectures were in place, I built data, data analytics, data visualization dashboards. I have helped multiple companies change their culture to become data driven. I have been doing all these activities for more than 27 years. I understand the possibilities of data and the challenges that await companies that embark on the journey to use data to become data driven organizations. I have created unique enterprise level data systems and applications that provide competitive advantages. I have built modern data environments that increased revenues, and improved customer experience. I have introduced technological efficiencies and improved operational efficiencies and delivered products at or below budget. My experience includes:

● A Data Visionary

● An Enterprise Data Architect & Cloud Data Architect

● A Lead Data Engineer / Programmer and Data Pipeline developer

● Moving on premises siloed data architectures to Integrated Data Lakes in the Cloud

● Builder of Cloud based Data environments in AZURE and AWS

● Builder of Data Visualization applications / dashboards in Azure and AWS

● Creator of competitive advantages using data technology

● Builder of Data Organizations from Scratch

WORK EXPERIENCE:

Tweddle Group, Clinton Twp., MI Sep. 2016 – Sep. 2024 Sr. Manager of CMS/Analyst/Software Engineering

Manage CCMS (Component Contents management System) for Authoring platform to support internal and external customers. Develop transformation process for contents and troubleshoot system issues and work as necessary. Working with CM-Operation team to develop TG’s internal Tridion Docs/LCA DITA contents system. Analyzed multiple source XML for transforming DITA Maps and Topics to structured Data. Support for web-site tool for automation and authoring team and tracking process for workflow.

Key projects:

• Over 8 years of experience in the Sr. contents analysis, design, development, management and implementation of business application software and contents data transformation.

• Quickly adapted to new technology and have utilized several tools including C#, X-code, Visual Basic, SQL-Server, MS-Access, Java, C++, ASP, VB script, Java Script.

• Sharp analytical and problem-solving skills.

• Demonstrated record of flexibility and versatility in various client environments and project roles.

• Lead Developer on Stellantis Owner Manual publication and Video metadata delivery management system to Azure.

• Lead Developer on Nissan Service Manual publication delivery process to Nissan ASIST system for their technicians.

• Participated in DITA XML contents implementation team for Nissan Service Manual

• Nissan Owner Manual authoring team support and process automation for authors

• Stellantis Service Manual delivery automation, authoring and delivering support with automation process (DITA + J2008)

• Stellantis Owner Manual delivery process, develop automation for delivery to Azure contents repository

• Stellantis TSB (Technical Service Bulletin) authoring system design and development and delivery automation into Stellantis TechConnect system (End user website)

• Data transform automation (XML to DITA), DITA to HTML for customer requirement.

• Pub-Data manager for Stellantis web-site data feed through API

• Stellantis QR-Code redirect manager website (design and development)

• EV LOPs (Labor Operation Time-Study data authoring website) design and development for Time Study authoring for EV vendor

Tweddle Group, Clinton Twp., MI Oct. 2013 – Sep. 2016 Innovation Team Leader/Analyst/Information Architecture Manage CCMS Authoring System for Tridion Docs and LCA to support internal and external customers. Troubleshoot system issues and work with authoring team. Worked with the Contents Management team to develop an internal Trisoft/Tridion Docs DITA system. I analyzed multiple sources of XML information to transform into DITA and DB Design. Support for the Authoring system and contents in DITA XML related projects. Key projects:

• over 4 years of experience in Contents Management analysis, design, development, CMS management and implementation of business application software and contents data transformation.

• lead Developer on Stellantis TSB (Service Bulletin) publication authoring tool and delivery process automation to TechConnect repository system

• lead Developer on Stellantis Service-Manual publication delivery process automation to TechConnect repository system

• As a Senior Programmer/Analyst with over 12, involved in the design and development of major data conversion for a major automotive manufacturer Chrysler, Ford, Nissan, Mazda, Toyota.

• Supported and Maintained Chrysler’s SM/OM authoring system using J2008 and Tridion Docs DITA CMS and XPP process for publication.

• 16 years of content data modeling experience on various CMS DB including Informix, MS- SQL Server, and Access

• Design website on Ford Owner publication Change Management System.

• Nissan D-Notes (Desing Change notes) management system website.

• Senior Programmer/Analyst and Database design on Chrysler VIP2(mobile) backend Data process/application flow management system.

• Participated in Tweddle Group DITA XML implementation team

• RChMS (Review Change Management System), RMS (Review Management system) web- site design and development

• Nissan D-Notes (Design Notes) web-site design and development

• Contents rollover process automation for CMS

• Contents transform XML to DITA XML for CCMS import Tweddle Group, Clinton Twp., MI Mar. 2001 – Oct. 2013 Contents Application Developer/Information Architect Manage Nissan Authoring tools to support internal and external customers. Troubleshoot system issues and work with Nissan in Japan and IT to correct issues as necessary. Develop and support TG’s internal Trisoft/Tridion Docs DITA system. Lead develops and supports customers multiple source SGML to transform into DITA XML.

Key projects:

• Participated in TG DITA implementation team

• Chrysler J2008 to DITA content data conversion and content modeling for Trisoft/Tridion Docs DITA CMS and J2008 legacy data management system to support legacy data editing and publishing process automation.

• Chrysler PBD2 to J2008 SM data conversion (SGML to XML) and content modeling.

• Chrysler OM XSLT supports and improves TechConnect (Vehicle Service bulletin).

• Expertise includes project management and development in diverse platforms including both client/server and Database modeling.

• ARTISS – Digital asset management (DAM) and workflow and Art-file manage web-tool for multiple automotive customer/vendor

• ChMS (Change Management System) for Ford for Owner manual authoring team

• Visual Search for hot-spot web application

Tweddle Group, Clinton Twp., MI Jan. 1997 – Mar. 2001 Contents Composition programmer/Application development XPP Composition tools to Publication compose to support internal and external customers. Troubleshoot system issues and work with web-application. Trained in CCMS automation support programming, SGML, J2008, S1000D for customers. Worked with CM to develop internal Contena tool and Trisoft/Tridion Docs DITA system. Analyzed multiple sources of information to transform XML import into CCMS

Key projects:

• Participated in SGML to XML implementation team for J2008

• SGML DTD modification and support for customer Chrysler J2008

• Web-site development using ASP for Backup tape inventory list tracking (TAIL)

• TCL/C-Shell scripting for file-system automation for publication process improvement

• PERL program for many CMS/XPP process automation RECENT PROJECT HIGHLIGHTS

Project: Stellantis Owner Manual XML data automation – May. 2022 to Nov. 2023 Using Azure data storage management, API application development for mopar.com XML publication data ETL/ELT from MS-SQL to Azure MySQL DB for publication back-end support

• Stellantis Owner Manual delivery automation. I developed and published xml data pipelines to send data to Azure content repository and update MySQL DB data for the mopar.com website data. Using C# and PERL program and Linux technologies.

• Pub-Data management system - application to support back-end Stellantis Owner guide website. I developed data pipelines to feed data through APIs to support mopar.com. The solution used AZURE MySQL database with MySQL workbench and C# programs to implement Data Governance and a metadata catalog on the Azure Cloud Platform.

• I create a content data governance organization and facilitate data governance meetings. I worked with Oracle, MS SQL and Postgres source relational databases XML data. I used cloud storage to store documents in the cloud.

• I worked with business data workers to help them use and be successful with the enterprise data repositories.

Project: Stellantis QR-Code data import and migration MS-SQL DB for redirect automation

– May. 2022 to Nov. 2024

I modeled MS-SQL database schemas and developed ELT/ETL data pipelines to import CSV source data files. I used T-SQL for redirecting URL based on QR-Key. I performed API application development and QR-Code development.

• Stellantis QR-Code redirect manager website (design and development) MS-SQL database manager and C# program for website.

• I developed an Azure MySQL database and Power BI Application to help analyze data. Project: Stellantis/FCA/ Daimler Chrysler TSB XML and meta-data automation – May. 2017 to Nov. 2023

AWS data storage management, Data ETL/ELT pipelines, application development for Transit DB2 database

XML publication data for ETL/ELT data pipelines from MS-SQL full publication data back-end authoring support

• Stellantis TSB (Service Bulletin) authoring system design and Full stack development and delivery automation into Stellantis TechConnect system (End user website) using MS-SQL design and development for metadata about the vehicle, and contents XML in MS-SQL and developed pipelines to merge data. I used C# web-site PERL program and Linux environment.

• I helped migrate on-premises SQL Server databases to MS-SQL databases using Azure Data Factory.

Project: Stellantis/FCA/Daimler Chrysler Service Manual xml data automation – May. 2006 to 2023.Nov.

AWS data storage management, ELT/ETL data pipeline development for transferring and transforming DB2 databases.

• Stellantis Service Manual delivery automation, publish and export AWS MS-SQL XML data to deliver the desired format for the customer database to the Stellantis DB2 database. Using PERL programs and Linux environment. I helped migrate on-premises SQL Server databases to Azure SQL databases using Azure Data Factory

• I developed enterprise AWS cloud data architecture. I moved the siloed-on premises data from on premises to the AWS cloud S3 and EC2 and Python ELT pipelines. I developed Cloud based Data Lake. I developed both batch and real-time data pipelines using python. I built data visualizations applications and dashboards using Power BI. I worked with business unit senior management to develop key performance indicators that drive the company and are supported by business analytics applications.

• MS-SQL upgrade for Tridion Docs CCMS (3.5 TB size) using DBUT and data migration. Project: Tweddle Group Data transform automation and report output – May. 2010 to Sep. 2024

MS-SQL DB in house DB server,

AWS data storage for CCMS management, Data ETL/ELT pipelines development for data migration for rollover.

Manage CCMS (Component Contents management System) for Authoring flatform to support internal and external customers. Develop back-end database support for contents and troubleshoot system issues and work as necessary. Working with CM-Operation team to develop TG’s internal Tridion Docs/LCA DITA contents system DB. Analyzed multiple source XML imports into DB for structured Data. Support for website back-end data storage and tracking process for workflow.

• Participated in TG DITA XML contents implementation team for Nissan Service Manual Via API, import XML into MS-SQL database

Project: LOPs (Labor Operation Time-Study data automation and report output – Tweddle - MI, May. 2010 to Sep. 2024

MS-SQL DB in house DB server, MS-SQL query and C# web-form for data support.

• EV (Electric Vehicle) LOPs (Labor Operation Time-Study data management website) design and development for Time Study authoring for EV vendor MS-SQL database manager and C# program for website.

Project: Nissan Service Manual XML data automation – MI, May. 2022 – Sep. 2024.

• For transforming XML data TPS support

• MS-SQL to MS-SQL XML data ETL.

Project: Nissan Owner Manual XML data automation – MI, May. 2022 – Sep. 2024. For transform data TPS support

• Nissan Owner Manual authoring team support and process automation for authors

• Manage CCMS (Component Contents management System) for Authoring flatform to support

PERL program and project summary

• Developed over 1,000,000 lines of code for 180 projects in the last 27 years. Windows and website application (Full stack development) summary

• More than 30 web-site and windows applications developed (Design application, DB, front-end and back-end for website)

Linux, Windows, Data Base server support and administrator capabilities

• More than 20 years Linux support and shell scripting and windows server and PC applications developed

TECHNICAL HIGHLIGHTS

● 13 years of AWS with cloud-based Data XML development. Cloud Functions, Cloud AI, RedShift, Python, ETL/ELT and much more. Several examples with several customer companies of moving siloed legacy data to the cloud in modern Data Lake architecture.

● 27 years of Data Lake and Data Warehousing experience

● 27 years of relational database experience (Oracle, Informix, DB2, MYSQL, SQL Server, SYBASE)

● 27 years writing complex queries and reports with (SQL, Business Objects, SQL reporting Services)

● 27 years of data management and modeling experience

● 16 years of ETL data processing using home grown tools and tools like SSIS, AWS Cloud data fusion and Azure Data Factory

● 27 years application development (SQL, PERL, C#, ASP, ASPX, Visual Basic, VBS, C- Shell, Python, COBOL, Fortran, Omni-Mark)

● 27 years of Business Intelligence and data visualization dashboard development

● 8 years developing cloud-based data environments including AWS and Azure data environments.

● 8 years of Data Governance and data cataloging experience

● 8 years Cloud Data environments including AWS, Azure

● 30 customer and app DB migration process for MS-SQL 2012(v11) to 2019(v15)

● I have a small amount of experience with GCP

● I have modeled more than 100 databases in my career from 1gb to 350TB

● Experience implementing Agile and other extreme Programming development methodologies

● I managed over 50 SQL Server databases for automotive customers.

● I developed the AWS Cloud based Data Strategy I-phone app data support.

● Participated in TG DITA implementation team

● RChMS (Review Change Management System), RMS (Review Management system)

● web-site design and development - Full stack

● Nissan DNotes(Design Notes) data tracking and report web-site design and development

● Contents rollover process automation for CMS

● Contents transform XML to DITA XML for CCMS import CONSULTING HISTORY

I have provided data consulting and application services for the following customers: GM, FORD, Chrysler, Daimler Chrysler, FCA, Stellantis, Nissan, Subaru, Toyota Europe, Mullen, Harbinger

INDUSTRY EXPERIENCE

More than 27 years of data management, Business Intelligence and Data Science experience across multiple industries including manufacturing, logistics, distribution, and automotive.

• More than 27 years of data software development

• 27 years manufacturing industry experience

• 27 years of automotive industry experience

• 12 years building Cloud based data / data science environments. TECHNICAL ENVIRONMENT AND LANGUAGES:

Applications / Software: Hardware: Languages:

• Visual Studio

• MS Project

• MS Office

RDBMS:

• MS-SQL server

• Informix

• MS-Access

• MySQL

• Oracle

• Windows PC

• Unix system

• Linux system

• Raspberry Pi

Operating Systems:

• DOS

• VM

• UNIX

• AIX

• Windows

• C#

• PERL

• Visual Basic .Net

• JavaScript, VBScript

• ASP, ASP.Net, MVC

• SQL, T-SQL

• Unix Shell script

• XML, SGML, HTML

• XSLT

• X-code

• Node.js

• Python

• VB.Net

ADDITIONAL TRAINING/CERTIFICATION:

• C#

• ASPX

• .NET

• JavaScript

• PERL

• VB.Net

• Visual Basic

• Omni Mark for XML/HTML/SGML transformation program

• Excel and VB programing

• C++

• JAVA

• Agile

• Taxonomy

• DITA v1.2

• Python

EDUCATION SUMMARY:

• University of Detroit Mercy (Detroit, MI)

Master’s degree in computer information systems (Aug. 1994 - Aug. 1996)

• Sung Kyun Kwan University (Seoul, Korea)

Bachelor’s degree in Agricultural Mechanical Engineering (Jan. 1982 - Jan. 1989) PUBLICATION SUMMARY:

• PC-Guide for beginners (1992, Korean)

• Norton Utility for Beginner (1992, Korean)

• dBase III+ basic for beginners (1992, Korean)

• Hangeul Word Processor start for beginner (1993, Korean) MILITARY SERVICE:

• Korean Air Force

Sergeant, Specialization: Code Analysis (1984-1986)

Contact this candidate