The Insightful Analyst

Posts

Showing posts from February, 2025

By John Eymard Estepa

Course: DATA 201 - Digital Visualizations

By John Eymard Estepa

DATA 201 | Data Wrangling | Digital Visualizations Assignment 4: Digital Visualization | Examining Rental Properties in Calgary Displaying rental prices in descending order. Visualization of how many rentals there are in each neighbourhood. The average going prices for rentals in each neighbourhood. 1. What are some distinctive observations between the attributes of neighbourhood and price? Which neighbourhood, on average, houses the most expensive rentals? Are there common attributes among the most expensive neighbourhoods? Looking at the raw data in Excel, one can infer that the neighbourhood “WEST HILLHURST '' had the highest sum of the prices in the neighbourhoods with a whopping $485. (I created a table, aggregated the sum of prices, and sorted it from largest to smallest.) I wanted to test whether the MEAN prices reflect the same story in my analysis. First, I looked at the rental count in each neighbourhood by using the Calculated Field with the function Count on T...

LinkedIn Learning

By John Eymard Estepa

"Data Analytics for Business Professionals" - This course is only 1 hour and 16 minutes long and covers data visualization, data-driven decision-making, and business applications of analytics. "Learning Data Analytics: 1 Foundation" - While slightly longer at 3 hours and 29 minutes, this course provides a comprehensive introduction to data analytics, covering topics like SQL, data cleaning, and working with tools like Excel and PowerBI. "Data Analytics: Dashboards vs. Data Stories" - This is a very short 17-minute course that introduces you to two common data science and analytics tools: dashboards and data stories. "Data Analytics: Graph Analytics" - Another quick 19-minute course focusing on graph analytics9. "Introduction to Career Skills in Data Analytics" - This 2-hour 21-minute course provides an overview of data analytics concepts and prepares you for the Microsoft GSI Data Analytics certification exam.

Dear Hiring Manager,

I am excited to present my portfolio, showcasing the skills and experiences I have gained through my academic and professional journey. As an individual committed to continuous growth and excellence, I am eager to contribute to a dynamic organization by leveraging my knowledge in data analytics, business intelligence, and technical solutions.

Throughout my career, I have developed a strong foundation in organizing, analyzing, and visualizing complex datasets. My technical expertise, combined with my hands-on experience working in data management and customer service, has allowed me to thrive in fast-paced and ever-changing environments. I am passionate about using data-driven insights to streamline processes and improve efficiency, ensuring that businesses achieve their strategic goals while maximizing stakeholder value.

Having gained valuable experience through internships and projects, I am confident in my ability to work independently and as part of a team, tackling challenges and delivering results under pressure. I possess excellent problem-solving skills, a strong work ethic, and the flexibility to adapt to new opportunities.

I am eager to bring my technical proficiency, creative mindset, and dedication to contributing to your company’s growth and success. Thank you for taking the time to explore my portfolio, and I would be thrilled to discuss how my skills and experiences align with your organization's needs.

Please feel free to contact me for any additional information or to schedule an interview.

With Appreciation,
John Eymard Estepa

John Eymard Estepa

BComm Business Analytics and Economics Undergrad | Data Analyst Student | Aspiring Analyst

31 Martindale Mews N.E.
Calgary, AB T3J 2V5
403-809-2898
johneymard.estepa@gmail.com
https://www.linkedin.com/in/johneymardestepa/

Objective:

Pursuing a full-time position to strengthen foundational skills in data analytics and build
connections that will propel long-term personal and professional development and success.
Personal Statement:
A learner by heart, seeking employment opportunities and knowledge that will develop personal and
professional skills, education, and interests. A personal desire to improve pre-existing perspectives about an
organization to facilitate betterment. There’s fulfillment in an immersed pursuit of a meaningful career. You
will not find a worker more ambitious, hardworking, or grateful for being given a chance.

Technical Skills:

● Well-versed in using Microsoft applications such as Word, Excel, Outlook, PowerPoint, OneDrive, and
Sharepoint
● Skilled in creative, writing, diagramming, and visualization platforms such as Blogger, Power BI,
LucidChart and Canva
● Working knowledge of data analysis and management software such as SQL Management Studio,
Tableau, RStudio, and Rapid Miner
● Possesses a Class 5 Alberta GDL License

Candidate Summary:

● Offering diverse technical skills in data gathering and organizing software honed through 3+ years of
business analytics study
● Introspective blogger, skilled in communicating and analyzing real-life information. Independently
developed a blog website and content
● A discerning problem solver who thrives in fast-paced work settings, refined through over three years
of experience in the goods and services industry

Data Analysis Experience:

● Various business reporting involving rigorous data collection and data cleaning from multiple
departments, business units, operational staff, consultants, and open-source data platforms and
databases
● Application of critical thinking and technical coding ability to solve analytical case studies and
statistical problems.
● Identifying relationships between measures, fields, and variables in datasets to conduct and
synthesize descriptive and explanatory analysis

Education:

Accelerated Data Analytics Post-Diploma Certificate September 2024 - June 2025
● School for Advanced Digital Technology, Southern Institute of Technology, AB
Bachelor of Commerce September 2019 - June 2024
Haskayne School of Business, University of Calgary, AB
● Concentration in Business Analytics with a Minor in Economics
● Completed various data analytics and data wrangling courses, OPMA 415, OPMA 419, BTMA 431,
MGST 395

Achievements:

Jason Lang & Louise McKinney Scholarships ($1000)
● Achieved a minimum GPA of 3.20 on all courses completed over the previous fall and winter terms
Gong Cha Shift Lead Promotion (01/2021)
● Exhibited leadership qualities and established coherence in team coordination
Gong Cha Year 2020 Scholarship Award ($500)
● Displayed academic and professional merit while in post-secondary
Gong Cha Employee of the Month (03/2020)
● Recognized for outstanding employee performance and adept technical drink-making ability
Calgary Bridge Youth Foundation 2019 Mentorship Acknowledgment Certification
● Participated as a mentor for the entirety of secondary education
Youth Achievement Awards - The Calgary Bridge Foundation (Boards of Directors Award, 2019) ($1000)
● Selected as a winner of a personal essay competition about life as an immigrant in Alberta. Published
in the CBFY 2019 edition of “In Their Own Words”
Alexander Rutherford Scholarship ($2,500)
● Maintained a high academic record throughout secondary education
2018 Volunteer Recognition Honour Roll - Youth Central
● Achieved through outstanding and consistent volunteer performance

Work Experience:

Sales Advisor January 2024 - Present
Lindt and Sprungli
● Actively engaging with colleagues to enhance operational efficiency in inventory management and
sales floor maintenance.
● Upholding high-quality customer service while providing ample guidance on Lindt product offerings
● Creating an effective work environment and dynamic for a team of 4-5 people
● Ensuring proper management of inventory through vigilant monitoring, receiving, and maintenance
Security Systems Administrator Student Intern May 2023 - August 2023

City of Calgary

● Partnered with a cohort of city employees and site approvers from varying business units for capital
projects aimed to standardize and consolidate corporate security operations
● Oversaw access card administration and mitigated various city-wide site access requests
● Tasked with cleaning and establishing naming conventions for The City of Calgary’s access control
system
● Synthesizing record tables that display, discern, organize, and segregate corporate security assets
● Attained extensive knowledge of access levels and buildings relating to city operations.
Other Experience:

Volunteer July 2017 - Present

● 5+ years of volunteer work, logging 223.50 hours in various social enterprises and events in Calgary
● Established connections and relationships with a vast array of industry experts
● Honed transferable technical and soft life skills through working with different backgrounds and
perspectives

References Available Upon Request