Samuel Sarpong
512 Swadley Rd #52, Johnson City,TN
Summary
Driven information science graduate with hands-on experience developing end-to-end data pipelines, ETL processes, and database architecture through coursework and internships. Eager to apply analytical thinking, problem-solving skills, and passion for big data technologies. Ability to prioritize multiple assignments, meet and comply with several parallel deadlines. Demonstrated abilities to collaborate and take leadership across multi-disciplinary teams to attain the desired objective.
Overview
5
5
years of professional experience
4
4
Certification
Work History
Data Engineer Intern
Tombras Group
Knoxville, TN
01.2023 - 04.2023
- Identified data quality issues and anomalies using Spark; performed analysis to provide insights and improve data integrity by 95%.
- Built shell scripts and Airflow DAGs to handle errors, notifications, and workflow orchestration; orchestrated over 100 daily data loads with near zero downtime.
- Developed data pipelines to migrate MySQL databases to Google Cloud Platform; migrated over 5TB of data with 99.9% accuracy.
- Re-engineered ETL process by converting Pig scripts to PySpark; improved processing time by 75% for large datasets.
- Customized Airflow operators and hooks to integrate with Spark, AWS S3, and Snowflake for workflow tasks.
- Optimized task performance using Airflow pools, priorities, and queuing to maximize throughput.
Graduate Research Assistant
East Tennessee State University
Johnson City, TN
01.2022 - Current
- Records data and maintains source documentation following good documentation practices.
- Performs statistical, qualitative, and quantitative analysis.
- Completes administrative and research duties per professor request.
- Coordinated materials for research on the impact of technology on children with autism.
- Educates 28+ students weekly on Computer Systems and provides additional help for them, resulting in a 100% student satisfaction rate.
Fulfillment Coordinator
Amazon GmbH
Hamburg, Germany
05.2021 - 12.2021
- Examined incoming and outgoing shipments to check accuracy and identify damages and quality standards.
- Communicated with other departments to facilitate fulfillment activities and address issues.
- Trained new team members on proper and safe use of tools and equipment.
- Handled day-to-day shipping and receiving overseeing more than 100 packages per day.
- Updated database systems daily to bolster efficiency and performed quality control and inspected orders daily resulting in increased customer loyalty and customer satisfaction by 5% in the Hamburg-Winsen area
Back Office Support Officer
MTN Group
Kumasi, Ghana
06.2016 - 11.2020
- Innovated the utilization of dashboards for monitoring Key Performance Indicators (KPIs) to facilitate reporting and management of field activities which helped to gain over 80% marketshare in the Northern sector.
- Conducted investigations on mobile banking service fraud issues to ensure compliance with the Bank of Ghana's standards, reviewing over 150 cases of potential fraud per quarter.
- Evaluated new software applications and programs to ensure proper functionality at the desired level of performance and usability.
- Collaborated with the marketing team to identify and resolve customer issues quickly and professionally.
- Led a team of 16 employees on daily sales and data analysis operations, collected data from the team, and reported to the service implementation manager weekly.
- Managed and trained 800+ mobile banking agents and assigned them to territory managers resulting in an increase of agent performance by 25%.
- Reviewed agents’ documents before setup resulting in a 95% error-free data management process.
Education
Master of Science - Information Systems, Data Analytics Concentration
East Tennessee State University
Johnson City, TN12.2023
Master of Science - Computer Science
Technische Universität Clausthal
Clausthal-Zellerfeld, Germany12.2021
Bachelor of Science - Information Technology
Ghana Technology University College
Kumasi, Ghana05.2018
Skills
- Apache Spark : Spark Core, Dataframes, Spark SQL, Spark Streaming
- Programming Languages : SQL, C, Python, Java, PHP, Scala
- Automation Tools : Shell Scripting, BASH, Cronicle, Airflow
- Data Visualization & BI Tools : IBM Cognos , Tableau, Power BI, Looker
- Management Tools : Jira, Microsoft Project, Trello
- Cloud Computing : AWS, Azure
- Data Infrastructure: Kafka, Zookeeper, MongoDB, Casandra
Certification
- Big Data Specialization | IBM | March 2016
- Python for Data Science | IBM | February 2021
- HTML Certification | Code Academy | June 2022
- Data Analyst Nanodegree Program | Udacity | November 2022
- Advanced SQL Certification | HackerRank | January 2023
- IBM Data Warehouse Engineer Professional Certificate | Coursera | October 2023
- IBM Data Engineering Professional Certificate | Coursera | October 2023
Accomplishments
Sales Data Analysis
- Imported weekly sales data from SQL database into Python (Pandas and Numpy) for analysis.
- Identified trends and patterns in product sales over time using visualizations and statistical analysis.
- Developed interactive Tableau dashboard with filters to view sales by product, region, channel.
- Created models to predict future sales numbers based on historical data.
- Identified opportunities for growth by analyzing customer segments and product categories.
Customer Churn Prediction
- Developed logistic regression and random forest models in Python to identify customers likely to churn.
- Achieved 85% accuracy in predicting churn using features like purchase history, demographics and engagement.
- Recommended retention strategies targeting high risk customers.
Timeline
Data Engineer Intern
Tombras Group
01.2023 - 04.2023
Graduate Research Assistant
East Tennessee State University
01.2022 - Current
Fulfillment Coordinator
Amazon GmbH
05.2021 - 12.2021
Back Office Support Officer
MTN Group
06.2016 - 11.2020
Master of Science - Information Systems, Data Analytics Concentration
East Tennessee State University
Master of Science - Computer Science
Technische Universität Clausthal
Bachelor of Science - Information Technology
Ghana Technology University College
Similar Profiles
Tadezja MaxwellTadezja Maxwell
Social Media Community Manager at Tombras Group AdvertisingSocial Media Community Manager at Tombras Group Advertising
JACOB GRIMSLEYJACOB GRIMSLEY
Accounting Manager at The Tombras GroupAccounting Manager at The Tombras Group
Benjamin ClepperBenjamin Clepper
Paid Social Strategist at Charles Tombras AdvertisingPaid Social Strategist at Charles Tombras Advertising
Adeline EnsleyAdeline Ensley
Worship Resident at First Christian ChurchWorship Resident at First Christian Church
Sara O'Daniel, DMDSara O'Daniel, DMD
General Dentist Family Practice at Erwin Dental AssociatesGeneral Dentist Family Practice at Erwin Dental Associates