Data Analyst Database Administrator

Nicholas Adamu-Amanfu

Full Stack Developer /Database Administrator /Data Analyst

Contact Information:

Phone: +233-***-***-***

Email: *******@*****.***

LinkedIn: https://www.linkedin.com/in/nicholas-a-b3913626/

GitHub: https://github.com/niksync1/

Professional Summary:

Proficient IT professional with over 7 years of experience in network installations, domain maintenance, and software development. Highly skilled in advanced SQL, including query optimization, database replication, and complex stored procedures. Expertise in full stack web development using the MERN stack and a certified data analyst proficient in SQL, R, Python, and various data visualization tools. Microsoft and Cisco certified, with a strong foundation in both backend and frontend technologies. Fluent in English and conversant in French, with a proven track record of implementing server-centered forecourt retail solutions across multiple sites.

Education:

Coursera - Google Data Analytics Professional Certificate

June 2023 - August 2023

Focus: R, SQL (advanced queries, data management), Tableau, Python. Hands-on experience in data cleaning, data visualization, and project management.

DataCamp - Data Analytics with Python Track

December 2021 - May 2022

Focus: Data cleaning with Python, exploratory data analysis, advanced SQL for data manipulation, supervised and unsupervised machine learning.

Coursera - Server-side Development with NodeJS Express & MongoDB

December 2021 - May 2022

Focus: Full stack web development on the MERN stack, integrated applications with ReactJS and React Native.

Certifications:

Cisco Certified Network Associate (CCNA)

Microsoft Certified Solutions Expert (MCSE)

ITIL Foundation Certification

DEV277x: Object Oriented Programming in Java

MTA: Networking Fundamentals

Work Experience:

Simnet Ghana Ltd - Web Developer & Database Administrator

December 2023 - June 2024

Developed and maintained backend and frontend software for a lottery ticketing system using ReactJS, NodeJS, and ASP.Net. Utilized advanced SQL skills for data replication across multiple SQL databases, optimized complex queries, and created stored procedures to improve system performance.

Phoenix Innovations Ltd - Software Development and Data Analysis

June 2016 - Present

Analyzed large datasets and generated critical reports from 50 MySQL databases at retail sites using advanced SQL techniques. Implemented SQL-based data warehousing solutions and developed TSQL scripts for automated data processing. Provided remote support on Microsoft Windows and Office suite, enhancing user productivity. Delivered management reports for strategic decision-making.

Universal Engineering Ltd - IT Manager

March 2012 - March 2015

Led a project team to achieve a 300% increase in subscriber sites within 2 years. Provided onsite desktop and LAN support, ensuring seamless IT operations.

Shell Ghana Ltd - Client Support Specialist

March 2009 - March 2012

Delivered second-level front desk support, specializing in RIM Blackberry services and website administration. Trained new staff in ITIL principles, improving service management efficiency.

Skills:

Programming Languages: JavaScript, Python, SQL (Advanced Queries, Stored Procedures, Database Optimization)

Web Development: ReactJS, NodeJS, ASP.Net, MERN stack

Data Analysis: R, Python, Numpy, Microsoft Excel, PowerBI, Tableau

Database Management: Advanced SQL, MySQL, SQL Server, MongoDB, Data Warehousing

Certifications: Cisco Certified (CCNA), Microsoft Certified (MCSE)

Tools: Microsoft Office Suite, TSQL Scripts, Query Optimization Tools

Languages:

English: Professional level fluency

French: Intermediate level fluency

Hobbies and Interests:

Cycling

Reading

Contact this candidate