Background

Highly analytical and business-oriented data analyst with in-depth knowledge of database types, research methodologies, data mining, manipulation and visualization with agile principles across windows platform. I have experience in object-oriented programming, SQL integration, reporting; using data tools and creating dashboards with Power BI. I am detailed oriented, quickly learn and master new technologies to help business organization make better decisions with success working in both teams and self-directed settings.

Experience

Data Analyst (Intern, Contract) Jan. 2018 – Present

Digisoft Consult Inc. – Cumming, GA

Roles:

Developed a model and schema conversion for US Immigration & Custom Enforcement as a Project to map parents to their children and the assigned facilities using SQL Server Management Studio 2014

Creating stored procedures, views and triggers with T-SQL code

Used SQL server data tools to Extract Transform & Load data

Using Data Tools for SSIS, creating packages and jobs

Trace and troubleshoot issues throughout the architecture

Utilizing Power BI for dashboard reporting and analysis, visualization

Implementing SQL server as SAAS and IAAS within Microsoft Azure platform

Design, test, implement, maintain and control the organization’s physical and relational databases

IT Support (Freelance) Jun. 2016 – Present

Role:

Monitoring, installation and maintaining computer systems and networks

IT Consulting and implementation

IT Coordinator (Volunteer) Jan. 2013 – Feb. 2017

Kids Teaching Kidz (A nonprofit Organization) - Pomfret, CT.

Successfully coordinated and raised funds for KidsTeachingKidz via crowdfunding

Set up and coordinated social media pages (Facebook, Twitter, YouTube, Instagram, LinkedIn) via Hootsuite social enterprise content management system for KTK publicity.

Currently developing a full stack system with a search engine and integrated web service for Kids Teaching Kids Non-Profit Organization.

Technologies Used: Html5, CSS3, JQuery, PHP, MySQL

Teaching and Research Assistant Jan. 2013 – Jan. 2015

Accra Institute of Technology, Accra, Ghana

Roles:

Accra Institute of Technology Project coordination team member: Assisted my supervisor to identify and tailor specifications with final year IT undergraduate students. “Plan, Review documentation and Testing the final product using agile methodology & CI/CD Dev-Ops tools” as a requirement to obtain their Bachelor degree.

Management of LMS courses: Updating course properties, create training contents and enrolling students with unique ID’s generated by the LMS.

Identified the specifics and assisted in the deployment/integration of an open source OS Ticketing System into Accra Institute of Technology Moodle Learning Management System.

Teaching Assistant for (IT 204) web development class, using WordPress, Joomla, HTML, CSS, PHP, MySQL & (NT204) - IT Ethics

Used Moodle Learning Management system to support and track student academic progress, create reports, assign courses and e-learning resources.

Designed a user interface a logical model for Accra Institute of Technology library management system

Facilitated gathering of materials and data for various research projects and reports; write summaries of project findings as requested.

Intern: May 2012 – Dec. 2012

Accra Institute of Technology - Accra, Ghana

Roles:

Security installations, troubleshoot, configure and verify functionality of workstations, printers and mobile devices

Set up computer devices and internet connectivity to LAN for new employees

Troubleshoot networks.

Perform routine maintenance for all workstations

Database Developer/Administrator Jan. 2006 – Jul. 2009

CITECH LLC, Port Harcourt, NG.

ROLE:

Database development & Manipulation – CREATE, READ, UPDATE & DELETE

Technology used: MySQL on Xampp (Integrated with WordPress CMS)

Control access permissions and privileges

Develop, manage and test back-up and recovery plans

Install and test new versions of the database management system (DBMS)

Education

New England Institute of Technology (East Greenwich, RI) Mar. 2017 –Aug. 2019

MSc IT – in lieu (Part time-online)

Kwame Nkrumah University of Science and Technology (Ghana) Jan. 2010 – June. 2014

Bachelor of Science - Information Technology

Johns Hopkins University Aug. 2016 – Sept. 2016

(Coursera Massive Open Online Course) – Front End Development: HTML5, CSS3, JavaScript and Bootstrap

Projects:

Developed a front-end web application system for a restaurant.

https://tedsparxx.github.io/tedamachree.io/

Integrated a database centric architecture for a word press project

Integrated a component based Ticketing system for Accra Institute of Technology Moodle LMS

Center for Development of Advanced Computing (Bootcamp) (Accra, Ghana) Feb. 2015 – Aug. 2015

Courses Taken:

.Net Framework (C#, ASP.Net, SQL Server)

PHP/MYSQL

Core Java & Enterprise

Windows OS & Basic Linux (Ubuntu)

SKILLS

HTML5, CSS, Php/MySQL, T-SQL, Pivot table,

WordPress, Power BI, Tableau, SSIS, SSAS, Microsoft Azure SSRS, Github

Agile methodologies, Software architecture design patterns (Observer & Strategy patterns)

INTEREST

Volunteering

New Technologies & Life Long learning

References will be available upon request

Contact this candidate