Experience

CUBIC Inc.
• Indonesia
• Business Consulting and Services
• 1 - 100 Employee
• Project Analyst

  • Oct 2021 - Present


Cabin John Consulting Corp

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Analyst

  • Jan 2021 - Sep 2021

  - Met with ticket vendors to understand the business operational processes and be familiar with the ticket definitions by determining the ticket request, escalations, justification, and evaluation processes, and building the model framework - Built advanced SQL in Google BigQuery to aggregate and transform views, connected with Google Colab to extract and tokenize key metrics data, and built the target storage formats to align ticket data from preset ticket processing logic - Applied Bert to vectorize the metrics and justify the similarity of ticket descriptions, the results helped to build the distribution and definitions of natural words to study the categorical trends, and enhanced the classification models in SVM to assign ticket descriptions to pre-determined categories and departments for best solution purposes - Trained Logistic Regression models to determine valuable features and return the probability of escalations with details - Designed Tableau to track ticket KPIs of operation and analyze the opportunity to enhance the effectiveness of recommendation systems by monitoring the ticket solution effectiveness in different segmentations and customer groups Show less



Tricolor Auto Group

• United States
• Financial Services
• 100 - 200 Employee

• Business Intelligence Analyst

  • May 2020 - Nov 2020

  - Met with business functional lead to collect business requirements, translated, and document user stories into technical requirements, and senior developers to create the sprint deployment plans based on team workloads and working rates - Designed Data Mapping Diagram to track data relationship within Azure Data Lake Gen2 to explain and incorporate data from external resources, map the SOR Attributes, create data dictionary to explain domain data from each API resources - Created Data Profiling in Databricks SQL to generate the data descriptions within each domain and develop the source to target architecture to explicate the data modeling, cleansing, and transforming techniques in data ingestions pipeline - Regulated data integration and automation pipeline with Data Engineer team in Azure environment to extract data from data lake on mapping requirements, and incorporated back-end database in CosmosDB to ensure high throughput updates - Developed PowerBI dashboards to monitor the efficiency and ingestion log of daily integration pipeline and track the expected and actual attributes in different ingestion domains to accelerate the Quality Check processes Show less



Urban Space Planning and Architectural Design

• Urban Planner – Associate Manager

  • Sep 2010 - Nov 2018

  - Collected, managed, mapped, and analyzed data using GIS and Excel for existing conditions analysis. - Designed and developed data-driven, multi-criteria decision analysis models that allow diagnostic and predictive assessment and, analysis of new or existing projects, undertaken by public departments at different levels. - Developed performance metric modules for background resource assessments and formulated scripts that automated data manipulation, geo-spatial analysis, and metrics calculation procedures. - Led research and identified issues in the domains of future transportation, sustainability, water infrastructure, and social justice; developed policy alternatives consistent with client needs and community goals. - Prepared interactive mapping and infographic analysis products for use in community meetings, planning documents, and reports. Show less