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