SAMUEL AKUAMOAH

+1-614******* • ad2nrk@r.postjobfree.com • Columbus, Ohio linkedin.com/in/akuamoah samuel-8b6482b5

Summary

An accomplished Data and Logistics professional with a track record of over five years in Analytics, Scripting, Data Science, and Business Intelligence. Demonstrates a strong passion for leveraging data to inform strategic business decisions. Enthusiastic about exploring new technologies, with a continuous learning mindset. Embraces feedback as a valuable opportunity for personal and professional growth. Qualification

Skills: A/B Testing and Statistical Analysis, Exploratory data analysis, Data cleaning, data visualization,data mining

Tools: SQL (PostgreSQL/MySQL), Excel, Google Sheets, Tableau, SPSS, Genstat, Python (pandas, NumPy, matplotlib)

Languages: English (Full professional proficiency) PROFESSIONAL EXPERIENCE

Logistics Analyst, Central Transport (Columbus-Ohio) 07/22 - 04/23

● Conduct in-depth analysis and interpretation of data pertaining to transportation, inventory, and supply chain operations.

● Produce regular reports that offer valuable insights into key performance indicators (KPIs) and trends in performance with the use of Tableau Desktop.

● Utilize data analysis to pinpoint areas for improvement and identify opportunities for enhanced efficiency across the supply chain.

● Evaluate current transportation routes, warehouse layouts, and inventory management strategies, providing strategic recommendations for improvement. Logistics Analyst, SLS logistics (Columbus-Ohio) 02/21-03/22

● Evaluate and analyze supply chain processes to identify areas for improvement and optimization.

● Monitor and assess the performance of suppliers, carriers, and other logistics partners.

● Collect, organize, and analyze data related to logistics operations.

● Use statistical methods and software tools to derive actionable insights from data.

● Analyzing multiple data sources in Advance excel, google sheet Data Analyst, Forestry Commission (GHANA) 09/17 - 03/19

● Formulate strategic business recommendations by analyzing collected data to enhance overall business efficiency.

● Gather and analyze client data, providing valuable recommendations for process improvement.

● Conduct ad-hoc data extraction through SQL Server 2008, Excel, SAS, Tableau reports, or PDFs.

● Collaborate with business leads on special assignments, ensuring optimal production efficiency.

● Perform data analysis and reporting using Tableau and SAS.

● Utilize data visualization tools to create accessible and user-friendly interfaces, enabling end-users to swiftly identify key themes within their data.

● Design and generate reports as needed by clients, employing Excel files, SQL Server, and Oracle databases.

● Develop Tableau scorecards and dashboards, incorporating stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, and Gantt charts to highlight key information for decision-making.

Junior Data Analyst, CSIR (GHANA) 09/16 - 08/17

● Developed intricate SQL queries, incorporating Joins, Sub-queries, and utilizing concepts such as explain, Stats, Cast, and volatile tables on SQL server for efficient data retrieval from diverse tables.

● Conducted comprehensive data validation through the creation of complex SQL queries and actively participated in back-end testing, addressing data quality issues.

● Identified and addressed duplicate data or errors, facilitating effective inter-departmental communication and generating monthly reports.

● Proficient in data mapping and transformation between source and target data models.

● Analyzed reporting needs and crafted diverse dashboards to meet requirements.

● Delivering top-tier service and enhancing client experiences through the transformation of data into actionable insights, fostering business value. This includes the identification of anomalous transactions and the assignment of priority scores to high-risk accounts for comprehensive evaluation of potential fraud and abuse.

● Conducting training sessions for both external and internal teams on the utilization of newly implemented dashboards.

Junior Research officer, (PPRSD) GHANA 05/14 08/15

● Assisted in Laboratory Operations and compiled Pest Risk Analysis (PRA) List within Integrated Crop Pest Management (ICP) Unit, Pathology Unit, and Biological Control Unit.

● Provided Training and Development for Farmers on Plant Protection Issues, including monitoring and conducting inspections of plant product consignments at entry and exit points.

● Utilized Tableau for creating various views and implemented SQL queries, statistical techniques, and tools like SAS, SPSS, and Genstat for data analysis and reporting. EDUCATION

Data Analytics Training Program

Masterschool

April 2023 - Present

● Engaged in Masterschool's technology training initiative, crafted by industry experts to skillfully mentor adept students through hands-on problem-solving.

● Successfully tackled diverse business challenges using a range of analytical techniques

● Acquired proficiency in SQL, covering window functions, multiple joins, views, and Common Table Expressions (CTEs), as well as in Python, encompassing functions, pivots, and Group By objects. Additionally, honed skills in Excel, mastering XLOOKUP/VLOOKUP, Pivot tables, and visualization techniques.

PROJECTS

E-commerce Customer Behavior Analysis (A and B Testing) Performed a comprehensive analysis of e-commerce transactional data, delving into customer behavior insights. Utilized SQL and Tableau to formulate recommendations on segmentation, lifetime value, and conversion rates, contributing valuable insights to enhance marketing strategies and customer retention initiatives. This project serves as a testament to the adept application of data analytics in addressing real-world business challenges.

Bachelor of Science in Agriculture

College of Agriculture and Natural Resources,KNUST(Kumasi-Ghana) October 2012 - 2016

● Cultivated a strong foundation in digital design, enhancing communication skills, later leadership in innovation and technology software.

PROJECTS

PERSISTENCE OF FALSE YAM LEAF (Icacina senegalensis) EXTRACT ON COWPEA GRAINS FOR THE CONTROL OF THE SEED BEETLE (Callosobruchus maculatus). The study focuses on plant-derived alternatives to synthetic insecticides for controlling the cowpea bruchid Callosobruchus maculatus in stored cowpea grains in sub-Saharan Africa. Aqueous false yam leaf extracts, combined with 8ml of the extract and 0.08ml of chlorpyrifos and betallic, show the highest effectiveness, resulting in 15-100% mortality and effective inhibition of oviposition and adult emergence. Statistical tools such as SPSS and Genstat are employed to enhance the project's goal of improving farmers' livelihoods by increasing the shelf life of stored cowpea grains while safeguarding human health.

Contact this candidate