Ronnie Macalalad
Cabuyao
Summary
Experienced data analyst with 5+ years of experience leveraging statistical models to extract valuable insights from extensive datasets. Transforms insights into interactive visualizations for informed decision-making by diverse teams. Proficient in SQL, Python, Power BI, and Excel.
Overview
6
6
years of professional experience
Work History
Data Analyst - Freelancing (UpWork)
Upwork
12.2022 - Current
- Developed customized financial dashboards using Google Sheets, integrated automated pivot tables for comprehensive data analysis
- Restructured data collection processes, implementing standardization to enhance data visualization
- Created performance dashboards to track employee KPIs and facilitate monthly pay tracking
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Designed and implemented a workload monitoring system.
Data Analyst
Westcoast Tree Service Inc.
05.2024 - 08.2024
- Produced monthly reports using advanced Excel spreadsheet functions.
- Implemented code solutions to answer analytic questions and test and assess new methods.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Developed required policies and procedures that reflected actual goals, tasks, and workflows, while meeting all regulatory compliance requirements.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Used statistical methods to analyze data and generate useful business reports.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Developed data mining algorithms to identify and classify patterns in data.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Created dashboards to monitor and track key performance indicators.
- Assisted with creating data cubes and OLAP models to improve data analysis.
Executive Assistant Career Finder - Freelance
Pinili Outsourcing (Local)
09.2023 - 03.2024
- Guided individuals in assessing their skills and goals to support their professional growth
- Analyzed industries and positions to identify strong job opportunities
- Created effective resumes and cover letters
- Helped individuals succeed in interviews through company research and question anticipation
- Coordinated schedules, tracked deadlines, and managed multiple projects efficiently
- Communicated clearly and effectively in both written and verbal formats
- Additional skills: Discretion, healthcare knowledge, tech proficiency
- Achievements: Streamlined the job search process, enhanced application success, identified untapped career paths, boosted interview confidence.
- Organized and coordinated conferences and monthly meetings.
- Managed executive calendars, scheduling meetings and appointments and coordinating travel arrangements to optimize time.
- Used advanced software to prepare documents, reports, and presentations.
- Handled confidential and sensitive information with discretion and tact.
Data Quality Analyst - Excel / Report Specialist
Trad's Pest Control of Jacksonville - Remote
10.2023 - 01.2024
- Conducted daily audits of database transactions to minimize errors and ensure data accuracy
- Monitored and maintained database integrity, ensuring accurate customer and transaction data
- Developed key performance indicators (KPIs) and metrics to evaluate employee performance based on customer feedback
- Analyzed performance data to identify trends and areas for improvement, reporting findings to Operations Manager and CEO
- Led initiatives to streamline data management and reporting processes, enhancing operational efficiency and decision-making
- Achievements: Enhanced data accuracy, implemented performance evaluation system, enabled targeted employee training and optimization of sales strategies through comprehensive data analysis.
VA Data Administrator - Freelance
Gu-Wi Gutters & Windows (UpWork)
05.2023 - 08.2023
- Managed and maintained databases, ensuring data accuracy, security, and integrity
- Developed and implemented data policies, standards, and procedures
- Monitored and optimized database performance, identifying and resolving issues
- Performed regular backups and data recovery operations
- Created and managed user accounts and permissions
- Collaborated with IT teams to ensure data infrastructure meets organizational needs
- Conducted data analysis and generated reports to support decision-making processes
- Identified data quality issues and implemented data cleansing and validation measures
- Ensured compliance with data protection regulations
- Stayed updated with industry trends and advancements in data management.
Data Analyst - Freelancing (UpWork)
UpWork
12.2021 - 01.2022
- Created a KPI for a client's request
- Evaluated current strategies, procedures, and services for event planning
- Created monthly/weekly/daily reports
- Created a dashboard to visualize campaign performance
- Created a data mining (Google Form) to standardize data information
- I added a script to eliminate duplicate entries
- I created a pivot table to check and have an overview of performance.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Created dashboards to monitor and track key performance indicators.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of the best placement of needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Used statistical methods to analyze data and generate useful business reports.
- Implemented code solutions to answer analytic questions and test and assess new methods.
Account Associate - Payreto Service Inc.
04.2018 - 07.2020
- Prepared payment notifications for customers
- Followed up on receipts to validate transfers
- Validated and audited purchases
- Ensured purchases were credited accordingly within the ideal time frame
- Achievements: Developed a Google Sheet Base Influence, developed a working tool to align with SLA of clients, minimized errors and increased productivity
- Company achievements: Developed R&R Tracker, developed Leave Tracker, developed an Employee Database.
Fraud Analyst - Payreto Service Inc.
04.2018 - 09.2018
- Performed due diligence on new clients
- Reviewed all documents presented using tools to verify customer identity
- Reviewed documents through search engines
- Used Lexis Nexis to ensure clients had no criminal records and were not related to Politically Exposed Persons (PEP).
Education
Associate in Computer Technology -
Pamantasan ng Cabuyao
01.2016
Skills
- Google Sheets Advanced
- Google Looker
- GA4
- Google App script
- Microsoft Excel Advanced
- Power BI (Data Visualization)
- Python
- R
- Google Forms Expertise
- Microsoft Excel Advance
- Google Sheets Advance
- Process Improvement
- Data Warehousing
- Tableau
- SQL
- Google Analytics
- Data Analysis
Timeline
Data Analyst
Westcoast Tree Service Inc.
05.2024 - 08.2024
Data Quality Analyst - Excel / Report Specialist
Trad's Pest Control of Jacksonville - Remote
10.2023 - 01.2024
Executive Assistant Career Finder - Freelance
Pinili Outsourcing (Local)
09.2023 - 03.2024
VA Data Administrator - Freelance
Gu-Wi Gutters & Windows (UpWork)
05.2023 - 08.2023
Data Analyst - Freelancing (UpWork)
Upwork
12.2022 - Current
Data Analyst - Freelancing (UpWork)
UpWork
12.2021 - 01.2022
Account Associate - Payreto Service Inc.
04.2018 - 07.2020
Fraud Analyst - Payreto Service Inc.
04.2018 - 09.2018
Associate in Computer Technology -
Pamantasan ng Cabuyao
Similar Profiles
ADEWOLE BENJAMIN OYEDIRANADEWOLE BENJAMIN OYEDIRAN
Data Analyst - Freelance at UpworkData Analyst - Freelance at Upwork
Mollee Bloom MarcusMollee Bloom Marcus
LEAD TAXONOMIST ALGORITHM AND RESEARCH at UpworkLEAD TAXONOMIST ALGORITHM AND RESEARCH at Upwork
Peter BrownPeter Brown
Freelance Copywriter at UpworkFreelance Copywriter at Upwork