Email Address; adyepo@r.postjobfree.com

Phone; 615-***-****

Location: Chattanooga TN.

Over 3 years’ experience in I.T. Business and technology oriented professional.

Earned a degree in Computer Information Technology with a side concentration in Microsoft SSIS Developer, SQL DBA Administration and Analysis, MySQL, SQL Database Development.

Able to work both independently and efficiently with team members.

Currently, Working on Master’s in Data Science.

Ms. Visual Studio (2012,2017,2019)-MSBI

MS SQL Server

Python/Bash/R

Microsoft Excel

Management Studio (SSMS)

Kleopatra (encryption, decryption)

MDM in an ERP system

WinSCP (Logging in to Sftp Accounts)

BitVise (for sftp Accounts).

Database Engine Tuning Advisor

SQL Server Profiler

Activity Monitor MySQL

Azure Portal

Chilkat Encryption

Data Migration Assistant (Very Useful in Azure)

Azure Data Studio (ADS).

.NET Framework

SQL Server Configuration Manager

Services.msc

Some Personal Attributes

Effective Communication, and Writing.

Hardworking and Great attention to detail.

Able to work effectively with internal/external team members.

Great Analytical Mindset.

Adhering to deadlines for tasks.

Great brainstorming skills.

B.SC. (Bachelor’s) Computer Information Technology Minor: Health Science December 2017

Middle Tennessee State University, Murfreesboro, TN.

Master’s Program for Data Science at UTC: Graduation: May 2024

Certifications:

1 SQL Developer Certificate.

1 Statement of Accomplishment by DataCamp—Intermediate SQL Server.

Google Data Analytics – Foundations: Data, Data Everywhere

MODIS-US Express December 2020—June 2021

Business SQL Analyst, Master Data (Contract)

Interacting with the business to determine business requirements/needs and translating them into system requirements by following the SDLC.

o(Requirement Analysis and Gathering DataàData—Exploration to verify integrityàDesign the project/workàImplementation/CodingàTestingà Visualizing ways of presenting data àMaintaining and studying for future trends (Prediction).

Interacting with team lead, and team members to determine technical requirements.

Review and documentation of all project procedures to ensure business continuity.

Validation of Project results by double checking sample records against internal (XPM Classic), and external systems (Skybitz website).

Identifying, coordinating, and implementing process improvement initiatives.

Using SQL String functions like Trim, LTrim, RTrim, Replace, Upper, Lower Charindex, Substring etc. to clean data, filtering, Code debugging, Coalesce, isnull functions.

Making use of DDLs, DMLs, Primary/Foreign keys, Parameterized Stored Procedures, Subquery, Joins (Advanced Joins like Restricted Left and Right), Cross Apply, Views, Derived tables, CTEs, Window functions (Row_number, lead, lag etc.

Using database diagrams in SQL to normalize data from a flat file source.

Documentation of business procedures, as well as daily tasks.

Having scrum meetings to check on the progress of assigned tasks.

Running Manual Reports in SQL (Mostly DML). Ensuring the absence of duplicates in data sets using CTE’s or Group by/Having clauses.

Running SQL Reports for Driver Students that are hired from the past week.

Using Cross Apply Function in conjunction with a table valued function to ensure business continuity.

Using ad-hoc queries to create and use temp tables to join multiple data sets in SQL.

oOrdersàReceiving CustomersàBillTos.

Using left and right restricted joins to show values in one data set over the other.

Efficiently utilizing SQL aggregate functions like MIN (lowest value), MAX (highest value), Count (present count of attribute values),

Using isnumeric SQL functions to retrieve numbers only within a column.

Using CAST and CONVERT functions in SQL to manipulate date, and decimal data.

Using spatial indexes to join and map out parking polygons.

Used Excel to perform the following:

oCreate pivot tables (to summarize, and tell insightful stories),

operform sum functions, percentages, minimum, maximum.

oreplace functions, concatenation functions, trim functions.

otechniques for placing single ticks around numbers/characters,

ofunction to apply commas at the end of long list of numbers.

oCreating vlookups, making excel sheets resilient by using match functions to evaluate the similarities between two columns in different sheets. (Absolute and relative references).

oUsing various design formats to enhance the outlook of the data.

oDashboard Creation, Format Columns, Dynamic Chart creation (Bar, Line), Making use of Slicers.

oProtecting Worksheets Sent out to Vice Presidents, and Other Receivers so that they do not accidentally alter the values presented.

oSplitting data from a list into category and sub-category Using “Text to Columns” Option

oChecking for and eliminating duplicates.

oTop 10 summary of data, Using Pareto’s rule.

Using Tableau to create line, bar, scatterplots, geographic charts.

NB: Projects done for U.S Xpress, with SQL, Excel, Tableau would be discussed upon request.

Sedgwick September 2018—May 2019

SQL Developer/ Data Analyst/SSIS Developer (Contract)

Gather and formalize requirements from Joint Requirement Definition Meetings.

Took part in some daily scrum meetings to check status of current projects.

Following the SDLC; RG/Analysis, Design/Development, Testing, Implementation, Evolution.

Used the Agile Methodology in attending to some projects (Developer, Other developers, Account Manager, Users).

Used Data Modeling

Used Data dictionary to apply the proper data types, and constraints on created tables.

Used CAST and CONVERT to go from one data type to another. Used different date formats.

Build fact and dimension tables for the data warehouse.

Develop documentations for reporting processes and data custodians.

Data warehouse architecting.

Utilize SSIS for ETL processes to merge disparate data sources.

Specific ETL Tasks include, but not limited to:

oCreating Fixed Width Text Files, Excel Files, Pipe, Tab, Comma, Multiple Comma Delimited Files with DateTime On each package execution from SQL Server Table to a specific drive location.

oLoading tab, pipe, comma, multiple commas, fixed width, ragged right delimited files to SQL Server Table in SSIS package. Loading files to Different SQL Server Tables According to the File Names.

oLoading file formats such as Excel, Flat File to SQL Server Tables. Converting blank values from Flat File Source to Nulls in SQL Server Table.

oLoading data from SQL Server to pre-formatted or template excel file in SSIS package. Also duplicating Excel Data file from one location to another using Variables.

oLoading files as per specific extension (for instance, text files only among different file extensions) in a given drive location to SQL Server table for future analysis.

oEfficiently reading and loading AlphaNumeric data columns as String from Excel file to SQL Server Table.

oLoading Multiple Excel Sheets in a Single Excel File to a SQL Server Table. Also, loading different excel sheets from multiple excel files to different SQL Server tables using/in SSIS.

oRedirecting rows from Flat File, Excel Source for Data Conversion, and Truncation error for further analysis.

oCreating different cardinality, and relationships on tables (PK, FK), Conjunction tables.

oUsed 1st (eliminate redundancies); Each cell contains single value, 2nd (1st, Partial dependency, PK, FK) and 3rd Normal forms (1st, 2nd, Transitive dependency, PK, FK) to normalize table data. Used Chen’s notation to show strong and weak relationships between tables(entities)

oUsing derived tables to limit the complexities of SQL queries. Helping to control the number of columns we want to present from an inner query based on a certain condition.

oUsed Table variable results to compare records in permanent tables. Inserting contents of table variable into permanent tables, and sending to clients for current, and future analysis.

oUsed Joins such as left, right, full join to retrieve records from tables. Also created views, and new tables from the results of the Join.

oCreating and Scheduling SQL Jobs from Existing Stored Procedures, and DTSx/SSIS packages and then sending files with DateTime to client’s sftp servers.

oGenerating, and using raw file source, and destination in SSIS package.

oExcellent knowledge on using “triggers” in OLE DB/SQL Server Destination.

oCreating sftp Accounts Via BitVise WinSSHD and WinSCP—Sftp Accounts used for receiving files and dropping files for clients to pick up.

oUsing Kleopatra Software to PGP encrypt files with client’s Public key and place on their sftp servers.

oCreating tables, views, stored procedures, functions, indexes, databases, schemas, etc. Performing DDL (Data Definition Language and DML (Data Manipulation Language) commands in SQL. Used Common Table Expression to delete duplicate records.

oModifying Existing Stored Procedures to create Exit Files and send to clients.

oAnalyzing long query run times, some of which could be open transactions not committed.

oResolving locking and blocking on queries

oAnalyzing drive space and removing old, unneeded, bulky folders to enhance performance of computer system.

oAnalyzing the reasons for SQL Agent Job failures by viewing its history, and also by configuring job to send email error notifications.

oAble to test whether Chilkat Encryption Software is working by running a specific script in SQL. Chilkat is software for zipping files, and this is normally placed in a job step.

Decrypting PGP files with a specific command.

oMigration of Microsoft SQL Server 2008 R2 (SP3) To SQL Server 2014(SP3)—I checked job schedules on old servers versus new servers and made sure that they match.

Making sure enabled jobs on old servers and new servers are same.

Making sure EST and CST times match from old servers.

KWAKU BOATENG

TECHNOLOGY USED

EDUCATION

EXPERIENCE

Contact this candidate