Startup providing a no-code SaaS platform that enables users to build interactive forms effortlessly• Engineered 20+ charts in Superset, streamlining data with MySQL to track revenue, acquisition, conversion, and retention status and metrics, reducing manual effort and mitigating errors• Spearheaded funnel analysis with MySQL and Google Spreadsheet, identifying key segments impacting the overall purchase user fluctuations. Engineered automated sheets for seamless segment analysis across 4851 segments• Utilized Big Query to analyze blog visitor journey, crafting 12+ queries to streamline metric generation and visualize conversion dynamics, enhancing efficiency compared to previous manual processes• Implemented Big Query ML to construct a logistic regression model predicting post-purchase churn with 70% accuracy and to conduct PCA analysis grouping subscription purchase users• Generated revenue predictions for various segments including MRR, New MRR, and NDR with MySQL, and crafted prediction charts in Superset, offering insights into the company's revenue performance across diverse categories• Leveraged Google Analytics, Google Tag Manager, and Amplitude to pinpoint high-traffic product-generated contents, guiding targeted marketing recruitment strategies

Infrastructure Accounting Team• Enhanced financial reporting efficiency by crafting an automation bot using UiPath RPA tool, adept at downloading, merging, and analyzing cash account reports from Oracle Fusion, with a specialized analysis tab featuring pre-built formulas for automatic identification of unmapped USGAPP accounts, yielding time savings of 2-6 hours per task and reducing manual intervention• Improved technical accounting reporting processes by leveraging UiPath RPA tool to develop an automation bot proficient in downloading dashboards from 9+ Tableaus server sites and seamlessly merging them via Adobe Acrobat, resulting in a significant time-saving of 4-6 hours per task and elevation of employee experience by eliminating every manual process • Enhanced a 3K+ line data pipeline for a quarterly close analytics Tableau dashboard, integrating 2K+ lines of SQL and Python to develop a specialized view discerning manual transaction creators (FTE, BPO, or Others), culminating in a robust 5K+ line solution• Designed an ETL workflow using Alteryx to automatically extract, prepare, and reconcile data from diverse Excel sheets to generate consolidate sources, powering 5+ Tableau dashboards including income statement and cash flow statement slides for CFO deck presentations• Produced monthly Tableau report dashboards through execution of 300+ lines of Presto SQL on substantial datasets comprising 6+ tables with 140M+ rows each, extracting only relevant tasks and related information to derive operational metrics and provide actionable insights for enhancing internal tool efficiency in task creation• Conducted comprehensive analysis and visualization, including the creation of a Sankey Chart, to clarify the derivation of LCNRV (Lower Cost and Net Realizable Value) for the company’s products, facilitating a holistic understanding while investigating any outstanding calculation components

Accounting Risk & Analytics Team• Created a comprehensive project usage dashboard by performing complex Presto SQL queries (100+ lines) on multiple data tables (4+ tables with 400K+ rows each), enabling accurate tracking and insightful analysis• Ensured risk evaluation and mitigation across projects by creating and maintaining 12+ interactive Tableau Risk Monitoring dashboards weekly, aligning with CAO objectives• Conducted Secondary Data Quality Assurance with Alteryx to ensure accuracy and completeness,identifying & rectifying gaps/issues in dashboards• Migrated data sources from shared excel sheets to Tableau Server based extracts with Alteryx,improving overall team data quality and minimizing manual interventions to data• Established a library of reusable Tableau dashboard templates and components that enabled the team to quickly build visualizations from any source data and improved delivery time by 50%.

• Analyzed 600+ financial annual reports of Germany Companies to help investigate causational relations within the ERP of German Companies

• Processed 570,000+ rows of the dataset with auction transaction data to generate subsets suitable for classification modeling with R studio• Generated logistic regression model, random forest model, and SVM model with R studio while utilizing the K-Fold validation method to predict the possibility of user churn with accuracy of 80%

• Generated and processed dataset with 2.72M + rows of Duke baseball team starting pitcher MySQL database, using 70+ lines of SQL queries that make use of CTEs and Window functions• Created novel multi-layer radial bar charts with the generated dataset in Tableau, showing and comparing key pitch performance indicators of Duke baseball team starting pitchers according to a pitch’s tilt in a single interactive dashboard

In 2021, I was brought as the Associate Manager & Project Manager to McKinely & Rice, a global tech outsourcing company that specializes in outsourcing tech solutions to brands & businesses• Drove systemization, professionalization, and scaling of IT Consulting, Engineering, and Financial Departments by conducting 100+ meetings with C-suites, Tech and Project Leads• Managed all ongoing IT development projects under cooperation with McKinley & Rice IT talents and client companies; projects with Citylabs(Blockchain company), DIOCIAN(Global Artist Collaboration Platform), Kinfolk(Leading lifestyle authority), and application developing startups• Supervised and educated 4 new Korean project managers, especially regarding project management, usage of Slack/Jira/Confluence, and international communication with India office developers

In 2019, I joined Atommerce as a business strategy analyst Intern. This is a start-up developing Mind Café, an anonymous psychological counseling platform application.• Worked closely with the App Development department to generate strategic recommendations regarding mobile app functions that highly align with target consumer preferences• Conducted multi-market research and well-designed competitor research and analyzed data to identify opportunities for the platform and app to improve reputation management• Planned and promoted Mind Café Healing Talk Concert, an event held by Atommerce with famous psychiatrists and psychologists

In 2018, I won the bid and operated Yeonhui-Dong Coffee Shop as an operations analyst & manager; a student-ran café operated under coordination with Yonsei Univ. Consumer’s Cooperative.• Collected and analyzed historical data of prior tenant cafés and current operation data; introduced four new menus, capturing 39% of total revenue, with 20+ other menus comprising the balance• Oversaw operations, generating $8K in three months and surpassing expectations given constraints

In 2017, I joined WeFlash as the project director intern at its early stage; a start-up that developed Great Checkbee, a remote store management service application for store owners.• Provided technical strategies and mobile app structure using screen flow chart, information structure, and mockup tools for the App Development department to deliver app’s beta version• Established pipeline of 21 contracts and 43 prospective customers by interviewing 101 store owners

In 2016 Summer, I was asked to work as the International Relations Assistants intern for CISMING, the marketing agent of CISM (International Military Sports Council), for the second time by CISMING CEO• Acquired and analyzed data of sponsors for past international sports events to support future CISM’s military games• Submitted a thorough analysis report on African countries to identify countries that CISM and CISMING can establish cooperative relationships with in the future

In 2016 Spring, I was asked to work as the International Relations Assistants intern for CISMING, the marketing agent of CISM (International Military Sports Council) by CISMING CEO• Completed the draft of ‘2019 7th Wuhan Military Sports Summer Games Contract’ in English and Korean version; the draft was accepted by CISM headquarter in Brussels, Belgium, and was further reinforced by lawyers for completion