Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Kwame Darko

Dallas,Texas

Summary

Experienced data professional with experience in data analysis skills. Seeking Data Analysis or SQL BI Developer role, where new technology in data processing is applied, and career development is encouraged.

Overview

8
8
years of professional experience

Work History

Data Analyst

DataCheff LLC
Dallas, TX
08.2021 - Current
  • Generated 50+ data reports and dashboards delivering valuable insight to stakeholders and executives using SSRS and Power BI
  • Created over 1000 database objects including tables, joins, views, and triggers, to structure, optimize, and secure data for my business entity
  • Configured SSIS package pipeline for data movement from the Source to the Staging environment
  • Designed and maintained complex stored procedures, optimizing system performance by 30%
  • Deployed and automated several ETL processes, migrating data from several sources to database destinations with zero data loss
  • Collaborated with stakeholders, executives, and several departments to deliberate on business requirements and deliver on tasks

SQL Developer

BCTwenty Solutions
Dallas, TX
03.2019 - 07.2021
  • Worked in the SQL business intelligence department, using data to create insights and drive stakeholders' informed business decisions increasing revenue
  • Created and debugged database entities applying constraints and data models for maintaining referential integrity in the data warehouse and enhancing database structure
  • Generated staging databases, performing ETL (extract, transform, and load) on several data sources into staging databases and operational data stores (ODS)
  • Employed, maintained, and troubleshot several database techniques like CTEs, functions, and subqueries, to dynamize SQL queries improving client users' performance by 15%
  • Developed and automated several incremental and full loads into the Data warehouse
  • Provisioned Data models establishing Facts and Dimension relationships on Star schemas, Snowflake, etc
  • Increasing database efficiency
  • Streamlined query performance by implementing advanced optimization techniques and best practices, reducing processing time to 60%
  • Possessed expert knowledge of Database management tools while enhancing and keeping up to date on new and emerging technologies

Supply Chain Analyst

Valeo
Remote
07.2017 - 07.2020
  • Identified product, service, and process-related cost-saving measures utilizing the organization's databases, benchmarking studies, and technology assessments
  • Coordinated the supply chain process through various projects
  • Generated data and reports for customers and project team members
  • Performed recommended backup procedures for electronic files to ensure projects or programs were properly maintained
  • Co-ordinated customer orders checked inventory availability, and processed orders
  • Conducted full inventory count and management every week to ensure inventory integrity
  • Processed inbound and out paperwork through SAP and provided customers with detailed documents on shipped products

Education

Bachelor of Science - Logistics & Supply Chain Management

Ball State University
01.2019

Solution BI Analytics Bootcamp - Data Analysis

01.2020

Skills

  • ETL
  • Data Analysis
  • Data Visualization
  • Data Migration
  • Data Modeling
  • Database Management
  • Database Optimization
  • Power BI
  • Tableau
  • Visual Studio
  • SQL Server
  • SSMS
  • SSIS
  • SSRS
  • T-SQL
  • Excel
  • Google Sheets
  • XML
  • CSV
  • Repository
  • Microsoft Suite
  • Google Suite
  • Communication
  • Collaboration
  • Leadership
  • Problem Solving
  • Research

References

Available upon request.

Timeline

Data Analyst

DataCheff LLC
08.2021 - Current

SQL Developer

BCTwenty Solutions
03.2019 - 07.2021

Supply Chain Analyst

Valeo
07.2017 - 07.2020

Bachelor of Science - Logistics & Supply Chain Management

Ball State University

Solution BI Analytics Bootcamp - Data Analysis

Kwame Darko