Data Analyst Database Specialist

AKUETE TOUDEKA

STONE MOUNTAIN, GEORGIA, *****. 770-***-****

*****************@*****.***

Summary:

I am an Oracle PL/SQL support, Business Intelligence Analyst, and data analyst using Financial, Economic, and Public Health data when analyzing and interpreting Statistical data and developing Business Intelligence solutions.

Areas of Proficiencies:

SQL Development, SQL Server Report Service

Database development (SQL, including Azure SQL) SQL Server Analysis Service

Business Intelligence (Power BI)

PL/SQL(Oracle)

Professional Experience

High levels of Communication & Management skills with Excellent Role playing capabilities

Designed and built database solutions (tables / stored procedures / View/ queries /Functions) using Oracle tools like SQL Developer and Microsoft SQL Server

Utilized joins and subqueries to simplify queries involving multiple tables while optimizing procedures and triggers to be used in production

Knowledge of loading data into base tables from external system using SQL Loader utility and SQL Developer Tool

Proficient in performance tuning and optimization of SQL queries

Experienced in DAX queries

Extract, transform data dashboards and reports related and Power BI to ensure measurement of metrics on a regular basis

Created and Shared Report and dashboard, assigned row level security, auto refresh with Power BI.

Designed and develop report using SQL server Report Service

Extensively used the following environments: MS SQL Server 2014/2016/2017/2019, Visual Studio 2017

TECHNICAL SKILL

Other Tools Microsoft Office 2019

Personal BI Tools PowerPivot, Power BI

Database Microsoft SQL Server 2014/2016/2017/2019, Oracle11g/12c/18c/19c/21c

Network Topologies WINS, FTP, SMTP

Source Code Editor Note++

Cloud Solution: AZURE DB

Professional Certifications

Professional Experience

KATMAI - Atlanta, GA July2019 – Date

Business Intelligence Support Engineer

Designs, develops and implements data warehouses

Maintained a complex set of tables, queries, and procedures to ensure integrity of data interfaces for the planning of systems

Creates and design report using SSRS reports based on business requirements

Support various SLA reports

Support production process on database.

Monitor and fix automated ETL process.

Environment: MS SQL SERVER 2016/2017/2019, Power BI, ORACLE DB

Educations

Georgia Piedmont Technical College, Clarkston, GA August 19, 2019 - May 14, 2022

Associate of Science in Computer Database Specialist Spec-Degree 3.3 GPA

Contact this candidate