Course: DATA 401 - Data Literacy

Course: DATA 401 - Data Literacy

By John Eymard Estepa

Data 401 - Data Literacy

Description

This course aims to equip students with essential data manipulation and modelling techniques. It explores various data formats and styles, enabling students to understand data extraction, transformation and loading the datasets. Students will learn to refine and query data from the databases using query language. Through the lens of data analysis, students will craft informative narratives to aid organizational decision-making.

Course Learning Outcomes

1. Consider data and their characteristics.

Objectives:

1.1 identify common types.

1.2 Review data management and data manipulation tools.

1.3 Evaluate data sets by reviewing, managing and manipulating data.

1.4 Use SQL to query data.

1.5 Use the import/export data tool to connect the data source and move it to a destination.

2. Recommend a data manipulation tool.

Objectives:

2.1 Describe common data types.

2.2 List the advantages and disadvantages of different data types.

2.3 Build tables with data types.

2.4 Manipulate data types for sorting, aggregation, and representation.

2.5 Survey tools that use and manage data types.

3. Visualize data types from open data sources for presentation to an audience.

Objectives:

3.1 Survey open data sources and the available formats.

3.2 Evaluate tools used to open data.

3.3 Review case studies of open data use.

3.4 Choose open data for analysis.

4. Select data modelling tools for the exploration and presentation of data.

Objectives:

4.1 Review standard data modelling tools used in the industry.

4.2 Exampime data attributes and domains.

4.3 Use a data modelling tool to explore a relational database.

4.4 Diagram data modeling notations.

Reference: https://www.sait.ca/programs-and-courses

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