Jomarie Villanueva
Reporting Analyst
San Pablo City
Summary
As a results-driven reporting analyst, I excel at converting raw data into actionable insights that propel strategic decision-making. My expertise lies in crafting dynamic reports and dashboards, utilizing advanced analytics tools to illuminate the path forward. With a talent for deciphering complex data sets, I effectively communicate key findings to enhance organizational efficiency and drive success. My analytical prowess ensures that data not only informs but also transforms the way we do business.
Overview
6
6
years of professional experience
5
5
Certifications
Work History
Reporting Analyst
Willis Towers Watson
Taguig, Metro Manila, Philippines (Remote)
02.2024 - Current
- Engineered dynamic Power BI dashboards, integrating diverse data sources including SQL databases, Dataverse, and Benefits Engine, ensuring real-time data accessibility.
- Spearheaded the maintenance and enhancement of PowerBI dashboards, incorporating new metrics, visuals, and resolving discrepancies to bolster reporting efficiency.
- Crafted compelling monthly presentations for stakeholders, delivering insightful reporting and driving data-driven decision-making.
- Optimized dashboard performance and report accuracy through advanced formula and query enhancements, coupled with rigorous validation processes.
- Pioneered automation solutions for daily reporting tasks, significantly reducing manual effort and elevating productivity using VBA macros, Power automate, and office scripts.
- Leveraged Power Query to streamline dashboards, achieving optimal performance and user experience.
- Developed custom PowerApps applications to track and improve employee productivity, contributing to operational excellence.
- Provided high-level insights through data analysis, significantly impacting strategic business decisions.
- Delivered ad hoc request to other teams such as creating and optimizing their team report by using macros.
Reports Analyst
Enshored, Inc.
Pasig, Metro Manila, Philippines (Remote)
10.2022 - 02.2024
- Pioneered new client onboarding, expanding business opportunities and fostering growth
- Developed Looker Studio-based reporting and dynamic dashboards, driving strategic insights and incorporating data visualization to monitor agents' KPI
- Additionally, created impactful dashboards on Google Sheets, Excel, AWS QuickSight, and Salesforce, enhancing data-driven decision-making across multiple platforms
- Gathered, arranged, and inspected data using MS Excel and Google Sheets to provide information to the client
- Managed and created dashboards with multiple data
- Utilized SQL to query large datasets, optimizing performance through strategic indexing and collaborative fine-tuning for improved efficiency in a relational database environment
- Utilized RingCentral to generate and compare data across various platforms, enabling a holistic analysis of performance metrics for informed decision-making
- Developed AppSheet activity trackers for streamlined data processes and data generation
- Ensured precision via meticulous audits across client data collections
- Automated regular updates through macros and scripts, saving time while ensuring consistency
- Delivered valuable high-level insights, informing strategic decisions.
Internal Auditor
CARD Bank, Inc
San Pablo City, Laguna
03.2018 - 10.2022
- Conducted audits at 30+ branches nationwide, overseeing 4 unit offices per branch
- Collaborated on formulating working paper for new risk-based audit approach
- Interviewed 50+ clients/branch, auditing loans and savings, ensuring accuracy
- Provided reporting and monthly feedback to auditees and senior management
- Strategically planned audits to meet or exceed designated schedules
- Managed teams of up to 3 auditors, handling tasks independently
- Reviewed application controls, mitigating risks and ensuring compliance
- Assessed information controls, including security and disaster recovery
- Evaluated systems for potential risks, contributing to proactive measures.
Education
Bachelor of Science - Business Administration
Laguna State Polytechnic University
San Pablo City, Province Of Laguna, Philippines 04.2001 -
Skills
Certification
Lean Six Sigma Whitebelt
Timeline
GWS End User Training
09-2024
Data Story telling and data visualization mastery
07-2024
Data to Insights
06-2024
GROW Model Coaching
04-2024
Reporting Analyst
Willis Towers Watson
02.2024 - Current
Lean Six Sigma Whitebelt
05-2023
Reports Analyst
Enshored, Inc.
10.2022 - 02.2024
Internal Auditor
CARD Bank, Inc
03.2018 - 10.2022
Bachelor of Science - Business Administration
Laguna State Polytechnic University
04.2001 -