정성현 Email & Phone Number

Seoul, Kr

- Designing and Implementing Data Warehouse using Dimensional Modeling (Dimension/Fact)- Developing and Managing Data Transformation Logic (using Dataform)- Creating Custom Assertions for Data Quality Checks- Managing the Data Dictionary by creating and maintaining Table Descriptions- Establishing Data Governance (using Dataplex)- Developing Alerts for Excessive BigQuery Usage (using Log Router > Pub/Sub > Cloud Functions > Slack)- Developing BigQuery Usage Monitoring Dashboard (using Metabase)- Designing and Operating Key Enterprise Metrics and Dashboards- Designing and Conducting A/B Testing and Statistical Hypothesis Testing- Performing Time Series Data Analysis: Supporting marketing cost optimization by forecasting the number of job applications and membership revenue (using Prophet) and automating learning/predictions (using Airflow)- Designing Event Logs and Managing Event Taxonomy- Developing Data Ingestion Pipelines: Loading raw data from Branch.io (mobile linking platform) into BigQuery (using Airflow)

- Designed user behavior event logs and created an event taxonomy.- Managed end-to-end operations for Google Tag Manager (GTM), from the initial GTM container setup to establishing and managing rules.- Played a key role in the project from pre-launch, structuring and standardizing page/feature-specific event taxonomy, considering multilingual support (81 countries, 10 languages) and service scalability.- Established a culture of data quality assurance, with a particular focus on QA for user behavior event logs.- Created dashboards to assess the status post-global service launch (e.g., member registration funnel, DAU, retention).- Developed dashboards to evaluate the usability and goal achievement of features such as neighbor addition (follow) and direct trading of agricultural products.- Conducted SQL training for the marketing team, covering practical usage from basic to advanced levels.

대한민국 서울

- Designed and implemented data marts using ODS tables (logical design, physical design, query implementation, and Airflow development).- Developed key data analysis hypotheses: improving lawyer list click equality with a 'simple filter' (client-side), increasing lawyer responses by showing paid consultation conversion rates (lawyer-side), and identifying key factors affecting paid consultations using classification algorithms and Shapley Value (team-initiated).- Designed user behavior event logs and managed data collection, event taxonomy creation, and management.- Planned, developed, and operated dashboards to monitor service status, respond to metric changes, and evaluate project performance.- Conducted training on GTM usage for user behavior event log collection and utilization

- Provided sales insights and business (sales) support by analyzing user card payment data.- Supplied information about target user groups to advertisers (brands) interested in running ads within Toss (Development of Target Segments).- Proposed ads to advertisers who had not previously run ads within Toss.