Michael Affare

Data Analyst, Solutions Architect - Cloud, Data Engineer

Skills

  • Languages: Python, Java, SQL (T-SQL, PL-SQL)
  • Cloud: AWS (S3, EC2, RDS, DynamoDB, IAM, Route53, Glue, Athena) , Google Cloud (Big Query, Cloud Run, SQL, Looker)
  • Analytics: Tableau, NumPy, Pandas, Restful API, Spark, Hadoop, Excel, TensorFlow, Scikit-learn, Keras, Cypher Query Language
  • General Skills: Linux, ETL, AI Prompt Engineering, Process automation, Digital Transformation, Technical Documentation

Tools

  • Databases: Microsoft SQL Server, Oracle 21g , MySQL, NoSQL (MongoDB, Redis, Cassandra, Neo4j )
  • Visualization: Tableau, Python Libraries
  • Automation: SQL (Procedures, jobs, triggers), Selenium, PowerAutomate, Linux Crontab, Microsoft Task Scheduler,
  • Mobile app development: Flutter, PowerApps, Android Native (Java)

Software

Postman, Wireshark, Jira, PyCharm, Jupyter, Android Studio, VS Code, Canva, Microsoft Office

Domains

Data Engineering/Analytics, Cloud Solutions Architect , Database Development/Management
About me

Hello! I'm Michael Affare, a Computer Engineer with a Master's degree in Information Systems Management from Carnegie Mellon University. I am currently leading a Data Analytics team at Great Lakes Behavioral Research Institute and consulting as a Cloud Solutions Architect for the CMU research team at the Block Center for Technology & Society.

I take pride in having managed large scale distributed technical projects on 3 continents.

  • In Africa (Ghana) I led technical projects in the telecommunications space during the merger of Airtel and Tigo. I led projects with vendors like Ericsson, Huawei, Meta and managed integrations with banks (Barclays) and mobile financial services. I also led the AirtelTigo team on the National Communication Authority committee during the Ghana National Sim Reregistration Exercise that resulted in the reduction of mobile fraud by 60%.
  • In Australia I worked with Freshtrack Systems using database development and data analytics to support stakeholders in the fresh food supply chain industry (from the farm to the shelves).
  • In the United States I am consulting for the Allegheny County Department of Human Services using data analytics to drive data-driven policy decisions whiles contributing to research on WorkForce Mobility and labour analytics at CMU.

My passion is to support businesses with digital transformation solutions that are automatable and leverage data analytics solutions to help improve productivity. I am a continuous learner and passionate about technical projects that improve optimization and data-driven decision-making.

Education

Master of Information Systems Management

2021 - 2023

Bachelor of Science in Computer Engineering

2012 - 2016

Work Experience

Data Analytics Manager

Jun. 2023 - Present

Cloud Engineer, Research Consultant

Jan. 2023 - Present

BI, Application Support Analyst

Apr. 2021 - Aug. 2023

Consumer Solutions Architect,
Business Solutions Architect

May. 2017 - Aug. 2022

Student Consultant,
Data Analysis

January 2023 - May 2023

Student Consultant,
Data Analysis

March 2021 - April 2023

Graduate Teaching Assistant,

Student Consultant, 3D Modeling
Intern, Data Science


May. 2022 - July. 2022

Projects

Allegheny County, Hello Baby PRM

June 2023 - Present

Esteé Laude, Web3 Analytics

Jan. 2023 - May. 2023

Ghana NCA, National Sim Reregistration

Nov. 2020 - Dec. 2021

Meta, Facebook Loan Service Integration

February 2023

Ericsson, EMA to EDA migration

January 2023

AirtelTigo, Mobile Number Portability

September 2022

Huawei, Convergent Billing System

July 2022

AirtelTigo, API Integration Projects

March 2022

AirtelTigo, Epin Mobile Financial Services

March 2022

AirtelTigo, SIM Card procurement

February 2022

AirtelTigo, First ESIM deployment in Ghana

January 2022

Block Center, Workforce SupplyChain Analytics

January 2022

Yum Brands, ESG Social Media Sentiment analysis

October 2021

Apps

Workforce Insight Tool (ongoing)

December 2022

SubAnagram (ongoing)

November 2022

Web3 Analytics Engine (Cryo)

May 2022

Raptoreum - Private Smartnode Operator (live)

November 2021
Leadership

VP, Heinz Finance Society, 2022-2023

Pittsburgh, USA

Class President, Computer Eng., 2016

Kumasi, Ghana / KNUST

CMU Student Ambassador Program

Pittsburgh, USA

Code

Github

Certifications

AWS Solutions Architect Associate

Issued October 2023

AWS Cloud Practitioner

Issued October 2023

Neo4j Certified Professional

Issued April 2023

ITIL Foundation, IT Service Management

Issued September 2019

Python 3 Programming Specialization

Issued August 2020

Databases & SQL for Data Science

Issued December 2020

ChatGPT Prompt Engineering for Developers

Issued April 2023

Critial Thinking in Global Challenges,
University of Edinburgh

Issued April 2013

IT Automation with Python Professional Certificate

Issued August 2020