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

<p>Managed the development of a customized, automated HR report to meet end-user requirements, utilizing cloud-based data from the datalake.<br>
Conducted data modeling for high-quality data retrieval and visualization, ensuring scalability and accommodating manual metric calculations.<br>
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).<br>
Developed a streamlined system to facilitate client understanding and definition of business needs, along with a seamless feedback mechanism.<br>
Effectively deployed across diverse product lines, expanding beyond the initial HR focus.<br>
Developed modules to provide training to 150+ team members on visualization tools, enhancing team proficiency.</p>

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

<p>Shadowed data analyst and engineer, specializing in Out-of-Home (OOH) media, to thoroughly plan and report media campaign performance.<br>
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.</p>