Francis Osei Boafo
Chicago,IL
Summary
Detail-oriented Data Engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Data Engineer
Myfootpath
11.2022 - Current
- Leveraged Excel, Power Query, and Power BI to conduct data analysis and used Python and external databases to develop custom data tools and infrastructure
- Employed command-line interfaces and integration tools like Zapier to run reports and coordinate system-wide processes using Excel and Python
- Spearheaded process improvements that contributed to a 20% annual increase in student enrollment and a corresponding 10% annual profit increase.
- Collaborated on technology tool setup and integration, including no-code tools, with a focus on data structuring and process flow development
- Designed and developed a local database using SQLite for efficient data migration into the cloud.
- Established and maintained data analytics protocols, standards, and documentation to ensure consistent and reliable results
- Optimized workflow efficiency and accuracy by creating Python scripts to automate tasks and build pipelines
- Seamlessly integrated external systems and applications using various APIs for improved data analysis and interpretation
- Streamlined transitions between data warehouses through the development of ETL code installations
- Built a comprehensive library of models and knowledge-base assets using Python to drive business intelligence and support data-driven decision-making
Education
Bachelor of Science - Cloud Computing
Western Governors University
Salt Lake City, UT06.2024
Associate of Applied Science - Computer Science
Joliet Junior College
Joliet, IL05.2022
Skills
- Proficient in Microsoft office (Word, Excel and PowerPoint)
- Coding Languages: Python, SQL, Java, JavaScript, C#, C, React, Nodejs, yaml, json,SQLite
- Operating System: Linux, Windows
- Cloud: Amazon Web Services, Azure, Google Cloud Platform
- DevOps tools: GitLab, AWS, GitHub, Docker
Certification
- AWS Certified Cloud Practitioner, Amazon Web Services
- Microsoft Azure Fundamentals- In progress
- CompTia a+
- CompTia Network +
- CompTia Security +
- CompTIA Secure Infrastructure Specialist
Projects
Successfully Migrated Local SQLite Database to Google Cloud Platform, Improving Accessibility and Scalability
Description: Migrated a local SQLite database to Google Cloud Platform to improve data accessibility and scalability. After designing the schema and populating the database, I used Python and APIs to interact with it. I overcame challenges during the migration by optimizing query performance and addressing data inconsistencies. The project resulted in cost efficiency, reduced burden on local infrastructure, and improved data management. USED: SQLite, Python, APIs, Google Cloud Platform.
- Designed and developed a local SQLite database to store project data, and populated it with data from various sources while performing necessary data cleaning and transformations.
- Leveraged Python and APIs to interact with the database and prepare it for migration to the cloud.
- Identified Google Cloud Platform (GCP) as the ideal cloud service provider, and configured the environment for seamless data migration
- Overcame challenges during the migration process, including optimizing query performance and addressing data inconsistencies to ensure data integrity.
- Streamlined data accessibility and scalability by migrating to GCP, resulting in significant cost savings and reduced strain on local infrastructure.
- Successfully implemented a reliable and efficient data management solution that helped achieve project objectives and contributed to the overall success of the business.
Timeline
Data Engineer
Myfootpath
11.2022 - Current
Bachelor of Science - Cloud Computing
Western Governors University
Associate of Applied Science - Computer Science
Joliet Junior College
Similar Profiles
Anthony NunezAnthony Nunez
After School Matter - Soccer at Eric Solorio Academy High SchoolAfter School Matter - Soccer at Eric Solorio Academy High School
Alexander ReyesAlexander Reyes
Volunteer at After School Programs Inc.Volunteer at After School Programs Inc.
Krystal BrandyKrystal Brandy
Sanitation Clerk at City Of ChicagoSanitation Clerk at City Of Chicago