Data Analysis Expertise
Specializing in transforming complex data into engaging visual narratives with expertise in data visualization.
Automation
As a VBA programmer in MS Excel, I automate repetitive tasks and enhance spreadsheet functionality through custom scripting. By writing and implementing Visual Basic for Applications (VBA) code, I create efficient solutions that streamline data processing, improve accuracy, and save time. My work includes developing macros, creating user-defined functions, and building interactive forms, all designed to optimize Excel’s capabilities and meet specific user needs. Other than Excel VBA and google sheets scripting, I also am capable of automating workflow processes in other platforms like DEAR systems used in inventory management and Zapier integrated in MS Teams.
Analysis and Reporting
As a Data and Reports Analyst, I specialize in collecting, processing, and analyzing data to produce comprehensive reports. I transform complex datasets into clear, actionable insights, helping organizations make data-driven decisions. My role includes data cleaning, statistical analysis, and creating visualizations that highlight key trends and patterns. Through my work, I enable businesses to optimize their operations and strategies by providing them with accurate and meaningful data interpretations.
Some of the projects I created in summary:
Web Scraper - Collects a specific data from an internet webpage identified by HTML element
Accounting Calendar Planner - Organizes Accounts Payable and Receivable in a calendar that creates projected net amount and sends out alarms and emails based on account due dates.
Automated invoicing - Streamlined repetitive processes involved in billing. Extracts data from multiple raw tables to invoice format.
Automated workflow in DEAR System - Streamlined repetitive processes involved in invoicing. Created a structured workflow in system integrated automation.
Listed above are just some of my projects that involves automation. Other projects I worked with are task and organization specific. For enquiries about my other projects, do not hesitate to reach out.
Most of the projects I have completed using VBA focus on automating repetitive tasks and enhancing accuracy by minimizing human error. Due to their specialized nature tailored to specific clients, these projects are not available here in my online portfolio.
Applications I have experience in:
Analytical Platforms I have used:
Certificates
Welcome to the certifications section of my portfolio. Here, you will find a collection of the credentials I have earned, reflecting my commitment to continuous learning and professional development. These certifications span various disciplines and demonstrate my expertise, dedication, and ability to stay current with industry standards and advancements. Each certificate is a testament to the skills and knowledge I have acquired, ensuring that I am equipped to deliver exceptional performance in my field. Explore the details of each certification to understand the breadth and depth of my professional capabilities.
Navigate Google Analytics interface and reports, and set up dashboards and shortcuts. The course also demonstrates how to analyze basic Audience, Acquisition, and Behavior reports, and set up goals and campaign tracking.
In this learning path, you learn how to use sponsored ads effectively. This path will introduce you to common terms, features, and functionality that you can use to help drive advertising effectiveness.
This is a list of courses I took from Learning Console.