Ramadhita Umitaibatin

Managed the development of a customized, automated HR report to meet end-user requirements, utilizing cloud-based data from the datalake.
Conducted data modeling for high-quality data retrieval and visualization, ensuring scalability and accommodating manual metric calculations.
Led the establishment of a centralized data warehouse (DWH), overseeing the merging of redundant workflows across data lake, DWH, and datamart systems via DAG airflow, optimizing infrastructure and reducing redundancy (up to 50% running-hours saved).
Developed a streamlined system to facilitate client understanding and definition of business needs, along with a seamless feedback mechanism. Effectively deployed across diverse product lines, expanding beyond the initial HR focus.
Developed modules to provide training to 150+ team members on visualization tools, enhancing team proficiency.
Technologies: Mixpanel Tracker, SQL, Python, Amazon S3, Airflow, Git, Tableau, Quicksight, Metabase, Jupyter Notebook

Managed the development of a customized, automated HR report to meet end-user requirements, utilizing cloud-based data from the datalake.
Conducted data modeling for high-quality data retrieval and visualization, ensuring scalability and accommodating manual metric calculations.
Led the establishment of a centralized data warehouse (DWH), overseeing the merging of redundant workflows across data lake, DWH, and datamart systems via DAG airflow, optimizing infrastructure and reducing redundancy (up to 50% running-hours saved).
Developed a streamlined system to facilitate client understanding and definition of business needs, along with a seamless feedback mechanism.
Effectively deployed across diverse product lines, expanding beyond the initial HR focus.
Developed modules to provide training to 150+ team members on visualization tools, enhancing team proficiency.

Performed ad hoc and comprehensive analysis encompassing descriptive, diagnostic, and predictive methods to understand and anticipate consumer behavior.
Utilized findings to strategize and optimize buyer acquisition initiatives.
Developed automated monitoring dashboards for offline events, campaigns, and advertisements, conducting detailed anomaly analysis to drive proactive decision-making and optimize strategies.
Involved in several key projects individually and as part of a team to provide actionable insights for strategic decision-making.
TIV prediction of a strategic partnership program.
RFM and deep dive analysis of hyperlocal product acquisition.
Understanding ads effectiveness based on geolocation.
Reactivating churn buyer to dormant buyer.
Dormant buyer behavior analysis in hyperlocal cities.
Part of the data innovation community to create collaborative analysis across multiple business units.

Shadowed data analyst and engineer, specializing in Out-of-Home (OOH) media, to thoroughly plan and report media campaign performance.
Supported clients in assessing the effectiveness of their advertising campaigns by ensuring accurate and comprehensive measurement of KPIs specific to Out-of-Home (OOH) advertising.