Data Analyst

EBA TIYO

Phone: (404-***-**-**

Address: Atlanta, GA

OBJECTIVE

Data Engineer with 5 years of experience in Data Analyst involved in various projects related to Data Modeling, Data Analysis, Design and Development for Data warehousing environments. Moreover, has substantial experience in SQL server Database Administration/DBA/.

PROFESSIONAL SUMMARY

Results driven Data Analysis with 3+ years of experience involving in various projects related to Data Modeling, Data Analysis, Design and Development for Data warehousing environments.

Over 3 years of diverse experience in Information Technology field, includes Development, and Implementation of various applications in big data and Mainframe environments, Adapt and met challenges of tight release dates.

Practical understanding of the Data Modeling (Dimensional and Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Successful history of manipulating, transforming, and extracting value from large data sets with experience of writing SQL queries for data manipulation, definition and control.

Extensive experience of data analysis using MS SQL Server and Tableau.

Strong Experience using SQL server integration SSIS and its tools to analyze various data.

Experience using SQL database Administration including setting up new Servers, installing database instances, role assignments, backup and restoration of databases.

Experience using SSIS and SQL Server Reporting Service (SSRS), data transfer services (DTS) and performing ETL using SQL Server Integration Services (SSIS).

Experience using Tableau to create multiple charts for creating interactive dashboards for clear data visualization on Tableau Server.

Ability to support and work with cross-functional teams in a dynamic environment.

Excellent communication (both written and verbal) combined with a strong collaborative drive.

Technical mindset and desire to learn new tools and approaches.

TECHNICAL SKILLS

Database Management

SQL, NoSQL, MySQL Server, SQL Server, Oracle, and Oracle/SQL developer

Data Integration

ETL.

ETL/Reporting Tools

SSIS, SSRS, SSAS

Cloud Platform

Azure

Language & Statistical Tools

Tableau, T-SQL

Big Data Management

Data Mining, Data Entry, Data Cleaning, Data Quality and Validation

Statistical Analysis

Descriptive Statistics, Time Series, Mixed Model, Clustering, Student t-test, Experimental Design

Database Visualization

Tableau,SSRS

WORK EXPERIENCE

Data analysis

US TaxiCab Inc. (Fulton, Georgia) - January 2022 – July 2023

US TAXICAB is a transportation industry focused on bridging the gap between information technology and industry needs.

RESPONSIBILITIES:

Responsible for data engineering functions including, but not limited to: data extract, transformation, loading, integration in support of enterprise data infrastructures – data warehouse, operational data stores and master data management.

Develop, refine and scale data management and analytics procedures, systems, workflows, and best practices.

Implements concepts of programming such as data structures, error handing, data manipulation and I/O processing.

Implements database concepts and practices including definition and query language.

Supporting the development group by providing API's and performing middle-tier application development

Responsible for data services and data movement infrastructures.

Develop framework, metrics and reporting to ensure progress can be measured, evaluated and continually improved.

Works closely with project manager to develop work plan for Data Warehouse projects and keep the manager aware of any issues.

Providing accurate estimates for project development and implementation. Work with management to meet those estimates.

Providing analytical network support to improve quality and standard work results.

Perform in-depth analysis of research information for the purpose of identifying opportunities, developing proposals and recommendations for use by management.

Support the development of performance dashboards that encompass key metrics to be reviewed with senior leadership and sales management.

Analyzes requirements and architecture specifications to create detailed design.

Prepares project plans and uses flowcharts and data flow diagramming to create program design concepts.

Creates detailed system design documentation.

Tools and Technologies: MS SQL, MySQL, NO SQL, ETL, SSIS, SSRS.

DATA ANALYST

Digi Safari (Alpharetta, Georgia) May 2020 – November 2021

Digi-Safari is a state-of-the-art learning center focused on bridging the gap between college education and industry needs.

RESPONSIBILITIES:

Created Tables, Views, Indexes, Constraint, Temporary Tables and User defined data types and functions using T-SQL.

Created tabular and matrix reports by using SSRS and use stored procedures and functions to create SSRS reports.

Created SSIS packages to export and import data from CSV files, Text files, Excel spreadsheet and other databases.

Developed and deployed reports using SSRS and configuring the SQL Server Reporting Server.

Create SSIS package to Import/Export Wizard to perform ETL operations and various containers to do the loop generating.

Developed logically and Physical Data Models by using ER and Normalize or De-Normalize according to business requirement.

Developed T-SQL script to use in Joints, Queries and sub-queries to retrieve data from multiple tables.

Developed and supported packages using variables, master child packages and Execute Package Task in SSIS, executing with bath files and moving along with SQL servers.

Monitors and troubleshoots the performance issues and optimized TSQL queries, stored procedures, functions.

Create, maintain and organize database by using Microsoft excel and Access.

Used tools in Collecting payments from the members and preparing financial reports and performed daily, weekly, and monthly bases reports.

Tools and Technologies: MS SQL Server, Integration Services tools, SSIS, SQL Server Reporting Services.

DATA ANALYST

Coin Technology (Doraville, Georgia) July 2016 – Feb. 2020

Coin Technology, financial department Led class project to research and present financial forecasts for local and global markets focused on the role of information technology in financial industries.

RESPONSIBILITIES:

Design and maintain well-structured relational database schemas.

Monitor the state of the database used by the Data Science team to ensure data correctness and availability

Gathering and collating new data sources for use by the Data Science team.

Manage the movement of data between environments to support model development.

Create and maintain data pipelines to feed into our data lake.

Respond to operational data pipeline failures with ownership and accuracy.

Identify, design, implement, and own internal process improvements; Automating manual processes, optimizing data delivery and ingestion.

Assemble large, complex data sets that meet business requirements.

Work with data experts to strive for greater functionality in our data platform.

Evaluate logs across a wide range of complex systems.

Generate accurate and effective documentation.

Tools and Technologies: MS SQL, NoSQL, ETL, SSIS, Excel, MySQL.

PERSONAL PROJECTS AND EXPERIENCE

Created database project for rental car Management: Database Design and Implementation

Designed and modeled a simple database structure for keeping track of information about a car rental company

Identified the relationships by designing the EER schema and mapping it into a relational database schema

SQL Server Database related projects Developed, Executed, and maintained the database using SQL

EDUCATION

Highest Degree

Associate degree in Database Administration

Bachelor of Science in Computer Science

Master’s degree in Art of curriculum development and instruction

Professional Related Courses

Diploma in Database Specialist, 2017, Georgia Piedmont Technical College, Georgia

Associate Degree in Applied Science Database Specialist, 2018, Georgia Piedmont Technical College, Georgia

Bachelor of Science in Information Technology/IT/

Contact this candidate