Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Work Availability
Quote
Timeline
Generic
Francis Addae

Francis Addae

Newark,NJ

Summary

Meticulous Analytics Engineer eager to provide holistic data acquisition and management services. Leverages novel techniques and technologies to squeeze maximum value from owned and acquired assets. Dedicated to exceeding business goals through careful exploitation of all available resources.

Overview

5
5
years of professional experience
2
2
Certification

Work History

Data Analytics Engineer

DispatchHealth
Denver, CO
11.2022 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Adaptable and proficient in learning new concepts quickly and efficiently.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Contributed to internal activities for overall process improvements, efficiencies and innovation.

Data Intelligence Analyst

Phenom People
Ambler, PA
06.2021 - 09.2022
  • Developed tables, views and materialized views using SQL and dbt.
  • Designed integration tools to combine data from multiple, varied data sources such as Mongo, Snowflake and big data installations.
  • Designed and developed schema data models.
  • Performed large-scale data conversions, transferring NoSQL data into standardized tabular formats for integration into Postgres & Snowflake.
  • Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.

Data Quality Analyst

BRC
Manhattan, NY
01.2021 - 06.2021
  • Developed process improvements to enhance overall data quality.
  • Performed quality control inspections at customer sites to determine alignment with safety regulations.
  • Analyzed issues and recommended corrective actions to improve final results.
  • Analyzed, queried and manipulated data to defined business procedures.
  • Determined root cause of data quality errors and recommended long-term solutions.

Solar Data Analyst

Momentum Solar
South Plainfield, NJ
07.2020 - 01.2021
  • Designing and predicting production data based on environmental and state regulations.
  • Compiled and modeled client's roof structure and buildings data using 3D Software.
  • Prepared data examples, runs and views for client meetings.

Teaching Assistant/Student Grader

Leonhard Center, Penn State
University Park, PA
08.2018 - 05.2020
  • Assisted students with Technical Power-point presentations.
  • Prepared, duplicated and collated teaching materials to help students better understand learning concepts.
  • Conducted special assessments and tutoring sessions to support individual student needs.
  • Assisted teachers with classroom management and document coordination to maintain positive learning environment

Education

Bachelor of Science - Data Science

The Pennsylvania State University
University Park, PA
05.2020

Skills

  • ETL, ELT
  • SQL (Postgres, Snowflake, Redshift), DBT, Python, Git
  • Engineering Standards, CI/CD
  • NoSQL Databases
  • AWS Platform Integrations
  • Data Warehousing
  • Data Quality, Collection, Management, Modeling
  • Reporting Tools: Excel, Tableau, Looker

Accomplishments

  • Predicted housing prices using both linear and logistic regression. To obtain an accurate performance, results were placed on kaggle which earned a Top 4% score. XGBoost Classifier was the core component in predicting the house prices using different markers.
  • Retrieved information from the web. The crawled url's which were parsed for indexing. ElasticSearch was used as the base for creating a custom search engine which provided information. This project provided insight on gathering data in its raw form which was further wrangled for better processing.
  • Cleaning raw data to fit relational databases using SQL and file systems like CSV,XML. Transforming relational data into non-relational data types. Manipulation of data using databases like MongoDB, RedisDB and Cassandra. CAP theorem was gravely emphasized.
  • Designed a codebook and website which details how cold and hotspots affects the organic agricultural markets across county levels in the US.Detailed emphasis on the effects of sensitive data on a project design. Used ArcGIS software to further analyze and produce reasonable data for both customer and public for viewing.

Certification

  • Professional Data Analyst, DataCamp Inc. - April,2022 - April, 2024
  • Associate Data Engineer , DataCamp Inc. - July,2023 - July, 2025

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

The best way out is always through.
Robert Frost

Timeline

Data Analytics Engineer

DispatchHealth
11.2022 - Current

Data Intelligence Analyst

Phenom People
06.2021 - 09.2022

Data Quality Analyst

BRC
01.2021 - 06.2021

Solar Data Analyst

Momentum Solar
07.2020 - 01.2021

Teaching Assistant/Student Grader

Leonhard Center, Penn State
08.2018 - 05.2020

Bachelor of Science - Data Science

The Pennsylvania State University
Francis Addae