GERALEN Z.

Oversaw product inventory, order tracking, and sales data for a customized graduation items shop, analyzing sales trends to enhance product offerings and fulfill accuracy.

Converted raw reproductive health data into organized marketing data sets by creating standardized monitoring and evaluation tools, which enhanced the accuracy of dashboards for weekly, monthly, and quarterly reporting. Developed and updated Power BI dashboards and Looker Studio reports to present program performance insights for internal stakeholders, transitioning from manual summaries to automated reporting templates. Cleaned and transformed large health datasets through Power Query and Visual Studio Code, minimizing data inconsistencies while reducing manual pre-processing time. Established reporting workflows and managed data sets for HIV awareness and teenage pregnancy campaigns, enabling reliable tracking of key program indicators across various funding cycles. Worked closely with internal teams to ensure that reporting requirements were effectively translated into precise dashboards. Created three Google Analytics Looker Studio dashboards to monitor website traffic, engagement, and user behavior metrics, providing key marketing insights for program decisions. Developed a Power BI dashboard for local HIV program monitoring to improve transparency of service delivery KPIs and lessen time spent on manual reporting by staff. Created a Client Satisfaction Survey dashboard in Power BI and Looker Studio for trend analysis of feedback data over time.

Established and managed organized candidate tracking pipelines, screening, categorizing, and reporting on applicant data to refine recruitment reporting for internal teams.

Monitored and communicated marketing performance data related to mall events and tenant openings, ensuring prompt and precise reporting of campaign outcomes to project heads. Organized and maintained marketing data, including schedules, budgets, and communications among various stakeholders, which enhanced reporting consistency and mitigated delays. Handled social media account management and tracked engagement metrics, producing bi-weekly performance reports that influenced content strategies and improved campaign return on investment. Executed promotional campaigns and documented results, delivering structured post-campaign reports that aided in future marketing strategies.

Oversaw social media accounts with a total following exceeding 100,000, analyzing engagement metrics and preparing regular performance reports to inform content strategies. Created and disseminated customer surveys, translating the feedback into evaluation reports that management utilized to gauge campaign effectiveness.

Maintained precise inventory records and processed transactions using the POS system, ensuring accuracy in daily operational reporting.