
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 OfficeDomains
Data Engineering/Analytics, Cloud Solutions Architect , Database Development/ManagementAbout 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

Bachelor of Science in Computer Engineering
Work Experience

Student Consultant,
Data Analysis

Student Consultant,
Data Analysis
Graduate Teaching Assistant,
Projects

Allegheny County, Hello Baby PRM

Esteé Laude, Web3 Analytics

Ghana NCA, National Sim Reregistration

Meta, Facebook Loan Service Integration

Ericsson, EMA to EDA migration

AirtelTigo, Mobile Number Portability

Huawei, Convergent Billing System

AirtelTigo, API Integration Projects

AirtelTigo, Epin Mobile Financial Services

AirtelTigo, SIM Card procurement

AirtelTigo, First ESIM deployment in Ghana

Block Center, Workforce SupplyChain Analytics

Yum Brands, ESG Social Media Sentiment analysis
Leadership

VP, Heinz Finance Society, 2022-2023

Class President, Computer Eng., 2016

CMU Student Ambassador Program
“The heights by great men reached and kept were not attained by sudden flight, but they while their companions slept, were toiling upward in the night."
- Henry Wadsworth Longfellow
Certifications

ChatGPT Prompt Engineering for Developers
Issued April 2023
Gallery

