Hello, It's Me
Carlo de Guzman
And I'm a
Data Analyst at Bangko Sentral ng Pilipinas
(via LSERV Corporation)
| Skilled in Excel, SQL & Power BI
| Data Cleaning,
Preparation, Analysis & Visualization
View Resume
Data Analyst at Bangko Sentral ng Pilipinas
(via LSERV Corporation)
| Skilled in Excel, SQL & Power BI
| Data Cleaning,
Preparation, Analysis & Visualization
👋 Greetings! I’m Carlo de Guzman, a
dedicated and detail-oriented Data Analyst skilled in Microsoft Excel,
PostgreSQL, and Power BI, specializing in data cleaning, preparation,
analysis, and visualization.
📈 To continuously enhance my expertise, I’ve attended data analytics bootcamps
and earned certifications and data projects, building a well-rounded skill set
to deliver insightful, strategic business solutions.
✨ I’m passionate about transforming data into meaningful insights
and collaborating with teams to drive impactful results! Let’s
connect—I’m always excited to explore new opportunities and
challenges in the world of data!
Microsoft Excel allows data analysts to efficiently clean, organize, manipulate,
analyze, and visualize large sets of data using a variety of functions and tools.
I can proceed to Data cleaning until Data Visualization in Excel or we can
use PostgreSQL and Power BI for better data preparation and visualization.
PostgreSQL allows data analysts to leverage its powerful query engine and
analytics features to clean, manipulate, analyze, and extract insights from large and complex datasets.
I mainly used PostgreSQL for data preparation and data process.
Power BI enables data analysts to quickly and easily transform from various sources into visually compelling and
interactive insights, allowing for better-informed business decisions. I can also clean and organize the data with
Power BI.
The Bank Loan Portfolio shows strong performance with 86.2% Good Loans, but challenges remain with 13.8% Bad Loans concentrated in high-risk segments. To sustain growth, the bank must address borrower risk profiles while capitalizing on growing demand for Debt Consolidation loans.
DSA F&B CO. saw a 59.55% increase in yearly revenue and a 12.14% quarterly growth, with Supervisors Mr. Emmanuel and Mr. Noel driving over 70% of sales. To sustain growth, the company should expand food products, address seasonal fluctuations, and use predictive analytics for better inventory and marketing decisions.
Bike Categories drive 93% of total sales, with Mountain 200 generating $7.17M, while the United States accounts for 32.17% of total profit. Retirees lead revenue at 55.73%, and Low-Income customers dominate unique customer count with 11.0K.
With Hawaii and Massachusetts showing a strong correlation between income and health spending, consider prioritizing these states for initial market expansion. Tailor your campaigns addressing unique consumer preferences in each region for optimal impact.
Completed a 40-hour online training course, enhancing skills in data cleaning, preparation, analysis, and advanced data visualization using Power BI.
View Certificate
Recognized as one of the Outstanding Achievers based on the final project, ranking 2nd out of 50+ students in my cohort.
View Certificate
This 16-hour course refreshed and enhanced my skills in Excel to manipulate, analyze, and visualize data in a variety of ways. I enhanced my skills in working with different data types, creating formulas and functions, and building charts and pivot tables.
View Certificate
I'm thrilled to share that I had the incredible opportunity to participate in the 2nd Philippine Conference on Data Analytics
with the theme, "Data Analytics for Good Governance: Driving Solutions for a Better Future" that was held on 28 September 2023
at the FEU Tech Innovation Center in Manila City.
This event brought together a remarkable group of professionals and data analytics enthusiasts, all passionate about harnessing
the power of data for positive change.
During the conference, I had the privilege of witnessing some outstanding data-driven projects
that showcased the transformative impact of analytics in various sectors. The enthusiasm for gaining insights from data was palpable,
and I had the pleasure of making new friends and valuable connections who share my passion for data-driven
decision-making.
I'm thrilled to share that I've successfully completed the Refocus Digital Academy for Data Analytics Course!
Throughout this journey, I've tackled assignments and solo and group projects using a variety of powerful
data analytics tools, including Excel, PostgreSQL, Power BI, and Python. This course has equipped me with
the skills and knowledge needed to thrive in the data analytics field. I'm eager to apply what
I've learned to the tech world, where I plan to drive business growth through data-driven strategies.
I'd also like to invite you to check out my Final Project in Refocus on LinkedIn(or the 4th project on Feautred Projects),
titled "Strategic Expansion Analysis: Identifying High-Potential States for Smartwatch Market Expansion."
It's a culmination of my hard work and showcases the practical insights I've gained.
Join me on this exciting data journey as we uncover opportunities that will shape our
strategic decisions in the ever-evolving smartwatch market! Let's make data-driven decisions together!
I’m happy to share that I’ve obtained a new certification: Data Analytics and Visualization Virtual Experience from Forage! where I have completed practical tasks in Project Understanding, Data Cleaning and Modeling, Data Visualization & Storytelling, and Presenting to the Client. It's a great opportunity for me to learn more about how Accenture companies analyze and visualize data!
View Certificate
I’m happy to share that I’ve obtained a new certification: Data Analytics 101 from Bayan Academy! This 30-day program covered Foundational Skills as a Data Analyst using Excel and Power BI. I'm grateful for this opportunity to improve my data analytics skills and gain valuable insights. Excited to use my new knowledge in future projects!
View Certificate
I passed a proctored exam on Python complete with identity verification at a Certiport Authorized Testing Center. As a holder of the Information Technology Specialist - Python certification from Certiport, I have demonstrated my ability to recognize, write, and debug Python code that can logically solve problems. This certification is globally recognized by industries as the professional standard for basic Python competency, and it showcases my knowledge and skills in the Python programming language. Having passed the exam, I have showcased my ability to use Python to solve problems and my dedication to continually improving my skills. This certification can help open doors to new career opportunities.
View Badge
One of my biggest accomplishments was completing a Google Course named "Google Data Analytics" through Coursera. This certification program included data understanding, data analyzation, and data visualization. It required a lot of concentration and effort, and we had the chance to accomplish a capstone project. This certification has given me the courage to take on new challenges in my profession and this qualification will also help me stand out in a crowded employment market. I am grateful for having the opportunity to have finished this program, and I believe it has equipped me with the skills and knowledge to begin my future career as a data analyst.
View Certificate
I have completed the core track of the Data Analytics program of Refocus. This was the first Course that peaked my interest in becoming a Data Analyst as I will graduate 2-3 years from now as a Business Analyst Student. The core track comprises of Microsoft Excel and PostgreSQL. I have completed 50 hours of video lectures, assessments, and self-study. With 14 assignments passed a lot of skills acquired. During the core track, I have also finished the Group Project: Elevating Yellavate which gave me the opportunity to be the SQL Lead in the team.
View Certificate
I passed a proctored exam on Databases complete with identity verification at a Certiport Authorized Testing Center at Far Eastern University – Institute of Technology. This certification is globally recognized by industries as the professional standard for basic Databases competency, and it showcases my knowledge and skills in the SQL programming language. Additionally, this certification is evidence of my commitment to keeping pace with rapidly changing technology, which positions me for increased skills, efficiency, and earning potential in my future career roles.
View Badge