Joel Macabaya
Bundaberg
Summary
Prodigious Business Intelligence Specialist accomplished at processing large-scale stores of disorganized data into harmonious and accessible Business Intelligence tools. Deft at providing easily understood dashboards and tools. Noted creator of media accessible to anyone from senior executives to customer service personnel.
Overview
20
20
years of professional experience
Work History
Disability Support Worker
Endeavour Foundation
09.2023 - Current
- Provided assistance in daily living activities by dressing, grooming, bathing, and toileting patients.
- Drove clients safely to social activities and appointments.
- Developed strong interpersonal relationships with clients, earning their trust and respect through consistent empathy and understanding.
- Supported clients in maintaining a clean living space by assisting with household tasks such as laundry, meal preparation, and general tidying.
- Enhanced quality of life for clients with physical and intellectual disabilities through compassionate care and assistance.
- Maintained safety with tidy, clean, and hazard-free home environments.
- Delivered exceptional personal care services, including bathing, dressing, grooming, and feeding assistance.
- Transported patients via wheelchair to and from rehabilitation and daily activities.
- Improved client independence by developing personalized support plans tailored to individual needs and goals.
Community Care Worker
Bundaberg Regional Council
10.2022 - 01.2024
- Contributed to the improvement of community health by conducting regular home visits and assessments.
- Enhanced client well-being by providing personalized care and support in their homes.
- Streamlined communication between healthcare providers, clients, and families to ensure optimal care coordination.
- Assisted clients with prescribed exercises to improve mobility.
- Facilitated access to community resources and services by connecting clients with appropriate agencies or organizations.
- Supported family caregivers through respite services allowing them time away from caregiving responsibilities while ensuring continued quality care for their loved ones.
- Assisted clients with mobility such as getting out of bed, dressing and transferring to commode or wheelchair.
- Observed, monitored and recorded clients' physical and emotional well-being to report changes to senior staff.
- Ensured a safe environment for clients by addressing potential hazards and maintaining clean living spaces.
- Maintained accurate records of client progress by documenting observations, interventions, outcomes, and any pertinent information on a timely basis.
Disability Support Worker
CLS
03.2021 - 09.2023
- Provided assistance in daily living activities by dressing, grooming, bathing, and toileting patients.
- Drove clients safely to social activities and appointments.
- Developed strong interpersonal relationships with clients, earning their trust and respect through consistent empathy and understanding.
- Supported clients in maintaining a clean living space by assisting with household tasks such as laundry, meal preparation, and general tidying.
- Enhanced quality of life for clients with physical and intellectual disabilities through compassionate care and assistance.
- Maintained safety with tidy, clean, and hazard-free home environments.
- Kept detailed daily logs with care actions, patient behaviors, and incidents.
- Delivered exceptional personal care services, including bathing, dressing, grooming, and feeding assistance.
IT Support Specialist
BR RAD
06.2020 - 12.2020
- Created help desk tickets, troubleshot and resolved desktop issues.
- Answered questions and provided information to customers about new software or hardware.
- Optimized network performance with regular maintenance checks, software updates, and hardware upgrades.
- Used ticketing systems to manage and process support actions and requests.
- Resolved escalated issues by serving as subject matter expert on wide-ranging issues.
- Provided Tier 1 IT support to non-technical internal users through desk side support services.
IT Field Technician
Arvens Technology
04.2020 - 06.2020
- Established a strong professional reputation with clients through consistent delivery of high-quality service and technical expertise.
- Increased productivity by training end-users on proper use of hardware, software, and network resources.
- Enhanced system performance by troubleshooting and resolving hardware, software, and network issues.
- Assisted in the development of IT policies and procedures to ensure compliance with industry best practices and regulatory requirements.
IT Field Technician
Apcd
10.2019 - 01.2020
- Assisted in the development of IT policies and procedures to ensure compliance with industry best practices and regulatory requirements.
- Ensured data security by installing antivirus software, firewalls, and other protective measures to protect client information.
- Boosted user satisfaction by providing timely remote support for software installation, configuration, and troubleshooting.
- Managed inventory of hardware components, keeping track of equipment status and ensuring timely replacement when necessary.
- Supported successful project completion by assisting in the setup, configuration, testing, deployment, and decommissioning of hardware systems as needed.
Business Intelligence Specialist
Ministry Of Labor
08.2014 - 06.2019
- Designed customized data collection models for specific visualization tasks.
- Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
- Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Evaluated BI tool options, selected best-fit solutions based on cost-benefit analyses, ensuring optimal return on investment.
- Facilitated seamless integration of disparate data sources into cohesive analytical frameworks for comprehensive reporting purposes.
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Handled massive quantities of business intelligence data, personally managing as much as 300 terabytes.
- Enhanced data quality by conducting thorough analyses, identifying discrepancies, and providing recommendations for improvement.
- Implemented robust data warehousing solutions that provided a single source of truth for critical business information.
- Trained end-users on BI tools usage to maximize adoption rates and improve overall company data literacy levels.
- Streamlined reporting processes for increased efficiency and accuracy with the development of custom dashboards.
- Optimized BI reporting capabilities for secure server environment.
- Supported strategic decision-making processes by delivering timely and accurate insights from complex datasets.
- Mentored junior analysts in advanced statistical techniques to enhance their skillsets in developing meaningful business insights.
- Optimized database performance through regular maintenance, query optimization, and index tuning.
- Created data analysis tools to allow teams to query acquired information for unique details.
- Developed predictive models that supported proactive decision-making in areas such as customer retention and revenue growth.
- Championed a data-driven culture within the organization by promoting the use of analytics tools and methodologies across departments.
- Contributed to the successful launch of new products by providing comprehensive market research analysis and insights.
- Increased understanding of customer behavior patterns by analyzing sales, marketing, and demographic data sets.
- Maintained proficiency with latest database technologies.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Collected data from wide-ranging sources.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Provided ad-hoc reports for executive leadership team to support informed decision-making during critical situations or periods of change management.
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Conducted regular audits of BI infrastructure to ensure data accuracy, system stability, and adherence to industry standards.
- Created data models to support decision-making processes.
- Designed and developed data pipelines to acquire, clean and process data.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Collaborated with stakeholders to identify business needs and data sources.
- Created dashboards to monitor and track key performance indicators.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Optimized data access and storage to improve performance of analytics systems.
- Developed data mining algorithms to identify and classify patterns in data.
- Implemented business intelligence solutions to increase operational efficiency.
- Deployed predictive analytics models to forecast future trends.
- Generated ad-hoc reports to evaluate specific business requirements.
- Developed and implemented data governance policies and procedures.
- Generated standard and custom reports to provide insights into business performance.
- Developed and maintained data warehouses and data marts to support business operations.
- Provided technical support for troubleshooting analytics and reporting issues.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Utilized data visualization techniques to present and explain complex data sets.
- Identified patterns and trends in large data sets and provided actionable insights.
- Demonstrated strong organizational and time management skills while managing multiple projects.
Business Intelligence Developer
CYS Group
06.2012 - 04.2014
- Improved data gathering, analysis, and visualization procedures with strategic optimizations.
- Improved overall efficiency by automating manual reporting tasks through the development of dynamic BI tools.
- Collaborated with cross-functional teams to gather requirements and create tailored BI reports for stakeholders.
- Ensured data quality and integrity by implementing rigorous validation methods within the business intelligence framework.
- Provided training to end-users on best practices for utilizing BI tools, increasing adoption across departments.
- Optimized data processing for faster insights by designing efficient ETL processes and data models.
- Supported senior management with timely ad-hoc analyses, enabling agile responses to market changes.
- Generated reports, updated spreadsheets, and presented results.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Monitored and optimized SQL server performance.
IT Specialist
Cole Asia Business Center Incorporated
03.2011 - 05.2012
- Configured hardware, devices, and software to set up work stations for employees.
- Managed hardware and software inventory, ensuring timely updates and replacements as needed.
- Maintained servers and systems to keep networks fully operational during peak periods.
- Provided exceptional customer service by promptly addressing problems reported by endusers.
- Suggested software and hardware modifications to reduce lag time and improve overall speed.
- Enhanced system efficiency by implementing and maintaining IT infrastructure upgrades.
- Led migration projects to modernize legacy systems without disrupting daily operations or compromising security standards.
- Maintained a comprehensive knowledge of current industry trends, developments, tools, or techniques relevant to the role of an IT specialist.
- Optimized network performance through regular monitoring and maintenance.
- Performed server backups and changed and replaced backup tapes daily.
- Implemented effective backup systems to ensure data integrity and availability in case of disaster recovery scenarios.
- Explained technical information in clear terms to promote better understanding for non-technical users.
- Trained employees on new technologies, increasing competency levels across the organization.
- Patched software and installed new versions to eliminate security problems and protect data.
- Monitored systems in operation and quickly troubleshot errors.
- Streamlined technical support process for enhanced user satisfaction and faster issue resolution.
- Monitored systems in operation and input commands to troubleshoot areas.
- Evaluated emerging technologies for feasibility, cost-effectiveness, and potential value-add to the company''s IT ecosystem.
- Secured sensitive data by establishing robust cybersecurity measures and protocols.
Business Intelligence Analyst
Almana Group Of Companies
10.2007 - 01.2011
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Designed customized data collection models for specific visualization tasks.
- Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.
- Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Facilitated seamless integration of disparate data sources into cohesive analytical frameworks for comprehensive reporting purposes.
- Evaluated BI tool options, selected best-fit solutions based on cost-benefit analyses, ensuring optimal return on investment.
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Enhanced data quality by conducting thorough analyses, identifying discrepancies, and providing recommendations for improvement.
- Trained end-users on BI tools usage to maximize adoption rates and improve overall company data literacy levels.
- Streamlined reporting processes for increased efficiency and accuracy with the development of custom dashboards.
- Implemented robust data warehousing solutions that provided a single source of truth for critical business information.
- Optimized database performance through regular maintenance, query optimization, and index tuning.
- Created data analysis tools to allow teams to query acquired information for unique details.
- Optimized BI reporting capabilities for secure server environment.
- Supported strategic decision-making processes by delivering timely and accurate insights from complex datasets.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
Freelance Programmer
Self Employed
06.2005 - 05.2007
- Improved software performance by optimizing C++ code and implementing efficient algorithms.
- Resolved critical bugs swiftly, minimizing downtime for users and maintaining a positive product reputation among clients.
- Developed user-friendly applications for clients, focusing on functionality and ease of use.
- Enhanced user experience by designing intuitive graphical user interfaces using C++ libraries.
- Reduced development time for complex projects through effective project management strategies and strong collaboration skills.
- Streamlined development processes through the implementation of best practices in coding standards and documentation.
- Enhanced software scalability with modular design principles that allowed for easy expansion of features as needed over time.
- Provided ongoing support and maintenance for client software, ensuring continued satisfaction and optimal performance.
- Ensured seamless integration with existing systems through diligent testing and troubleshooting, providing a smooth transition for endusers.
- Successfully integrated third-party libraries into software solutions to add functionality without compromising performance or security.
Jr. Software Engineer/Datawarehouse Developer
Accenture
03.2004 - 08.2005
- Built data cubes, data marts and queries, maintaining every aspect of storage and translation.
- Debugged systems and fixed program malfunctions quickly.
- Increased efficiency of ETL workflows by automating repetitive tasks using scripting languages like Python or PowerShell.
- Streamlined data retrieval for business users by designing and developing user-friendly reporting tools.
- Employed vast knowledge of relational database concepts and PL/SQL coding to produce highly efficient data systems.
- Developed applications and designed processes for transformation and data management from company-wide databases.
- Supported enterprise-wide analytics efforts by providing accurate and timely datasets extracted from various sources for analysis purposes.
- Scheduled and tested system-wide upgrades to keep databases evolving with company needs.
- Implemented effective backup strategies which safeguarded critical business information against potential loss or damage.
- Reduced query response time with proficient database indexing strategies and partitioning techniques.
- Created data models and mapped content storage pathways to facilitate easy access and support troubleshooting access issues.
- Ensured data accuracy and integrity by conducting thorough audits of source systems, validating transformation logic, and monitoring ongoing data quality.
- Revamped outdated ETL processes for faster execution times without compromising data quality or integrity.
- Provided comprehensive documentation on all developed solutions, facilitating smooth knowledge transfer between team members.
- Assisted with the migration of legacy systems to modern platforms, ensuring minimal disruption to business operations during the transition process.
- Analyzed code defects and failures and presented code refactors and design fixes.
- Delivered completed products within project deadline.
Education
Certificate IV - Business (Big Data)
Swinburne University of Technology
Surry Hills, NSW, AUCertificate III of Individual Support (Disability) - Disability Studies
Impact Community Services
Bundaberg, QLD03.2021
Certified Implementation Specialist - Business Intelligence Implementation Specialist
Oracle University
Redwood City, CA.USA10.2015
Bachelor of Science - Computer Science
STI Philippines
Manila, Philippines11.2003
Skills
- Business Analysis
- SQL Expertise
- ETL development
- Data monitoring
- Data Transformation
- Data Mapping
- Data Migration
- Advanced analytics
- Machine Learning
- Data Modeling
- Big Data Analytics
- Predictive modeling
- Report Development
- Data Cleansing
- BI Tools Mastery
- Programming Languages: Java, C#, Net, Visual Basic, Python
- Project Management
- Agile
- Project Documentation
- API design knowledge
- Database Management Software
- Stakeholder Management
- Software Architecture
- Security Planning
- Virtualization
- Algorithm implementation
- Databases: Oracle, MongoDB
- Software Development Tools: JIRA, Confluence
- Programming
Accomplishments
- Spearheaded to rebuild the Business Intelligence Infrastructure at multiple data centre post Shamoon cyber attack .
- Joint Commission International Standard Accreditation of the organization through BI reports as part of organizations quality improvement system.
- Implemented Business Intelligence Infrastructure end to end solution for the clients.
- Operational cost savings of 7% on first year.
- Increases productivity of 10.7% on first year.
- Increases Net profit of 19% on first year.
- Completed the System Integration Project with 100% data accuracy.
Timeline
Disability Support Worker
Endeavour Foundation
09.2023 - Current
Community Care Worker
Bundaberg Regional Council
10.2022 - 01.2024
Disability Support Worker
CLS
03.2021 - 09.2023
IT Support Specialist
BR RAD
06.2020 - 12.2020
IT Field Technician
Arvens Technology
04.2020 - 06.2020
IT Field Technician
Apcd
10.2019 - 01.2020
Business Intelligence Specialist
Ministry Of Labor
08.2014 - 06.2019
Business Intelligence Developer
CYS Group
06.2012 - 04.2014
IT Specialist
Cole Asia Business Center Incorporated
03.2011 - 05.2012
Business Intelligence Analyst
Almana Group Of Companies
10.2007 - 01.2011
Freelance Programmer
Self Employed
06.2005 - 05.2007
Jr. Software Engineer/Datawarehouse Developer
Accenture
03.2004 - 08.2005
Certificate IV - Business (Big Data)
Swinburne University of Technology
Certificate III of Individual Support (Disability) - Disability Studies
Impact Community Services
Certified Implementation Specialist - Business Intelligence Implementation Specialist
Oracle University
Bachelor of Science - Computer Science
STI Philippines
Similar Profiles
MATU TUTERUMATU TUTERU
Billing Officer at Endeavour FoundationBilling Officer at Endeavour Foundation
Gaby LingardGaby Lingard
Project Specialist - Construction at Endeavour FoundationProject Specialist - Construction at Endeavour Foundation
Elizabeth WhiteElizabeth White
Mental Health Support Worker at Endeavour FoundationMental Health Support Worker at Endeavour Foundation
Patricia BeardPatricia Beard
Support Worker at Endeavour FoundationSupport Worker at Endeavour Foundation
Ashtynne GallweyAshtynne Gallwey
Bartender at RiverfeastBartender at Riverfeast