Power Bi Data Conversion

Timothy Voorheis

915-***-**** *******.********@*****.***

TECHNICAL COMPETENCIES:

Object Oriented Microsoft Suite Windows UNIX Linux SQL SSIS SSRS DBA Metrix 4 Metrix 5 Data Conversion Excel Maestro MDM Power BI MySQL

PROFESSIONAL EXPERIENCE:

Apptega, Atlanta, GA

Lead DBA 2/2022 – Current

Manage and approve database updates, and architecture the database when required to make the current system run at most efficient level.

Increase database speed and integrity through PK/FK relationships.

Migrate data from one framework to another.

Create stored procedures and functions to accommodate for MySQL 5.7

Update from MySql 5.7 to 8 to use windowing functions.

Monitor and manage replication, triggers, and events.

Coordinate with the different product teams and clients to ensure changes are up to best practice standards and that all the client needs are met.

Improving – Atlanta

SQL / SSIS Senior Developer 5/2019 – 1/2022

Developer

Create/alter virtual data model

Create/alter Power BI report with automation for further growth

Create custom Measures using DAX

Create/alter Tabular models

Create/alter excel data model with Summary Matrix sheet

Provide Training on how to use the new Dashboard and Data model

Ensure validity of current data inside the new data model

Create/alter SSIS Data import/migrations

Create and teach class on Advanced SQL techniques and functions

Create/alter SSRS reports

Work with backend billing systems to present the data to the client in a readable form

Postman to get/post APIs from Azure Dev Ops

Quality Assurance

Create and execute SQL stored procedures to test data for reporting

Test Tabular model for analytical data warehouse

Test front end Power BI reports on top of warehouse

Check enhancements and tuning queries to optimize performance

Validate implementations in Power BI reports and Dashboards

Supporting build automation and deployments

Create and test Power Shell script focusing on tabular build scripts

Troubleshoot and recommend resolutions found in existing tabular models and dashboards

Ernst and Young via Hexaware Technologies via Virtue Group

SQL / SSIS Developer 10/2018 – 5/2019

Create, develop update, delete, insert/merge, and select SQL scripts

Create, develop, and deploy SISS packages

Monitor and manipulate MDM conversion operations

Execute and update Conversion process

Update and maintain conversion documentation

UPS via Revolution Technologies, Sandy Springs, GA

Developer 07/2018 - 9/2018

Create Access database for human resource reporting

Write SQL packages to convert data to the new access database

Help with SSRS packages when needed with other departments

Design and modify reports in agile reporting environment

Interface Access database with end-user dashboards to provide real-time reporting

Ingenico Group, Alpharetta, GA.

Developer 06/2016 – 04/2018

Build and manage 400+ reports for operations and financial departments written in T-SQL via SSRS practices.

Develop SSIS packages to assist in data analytics, manipulation and database integration.

Created and maintained SQL Database for logistics and operations departments to manage inventory and billing metrics.

Assist in advanced DBA responsibilities such as replication, indexing, and data integrity.

Contact and coordinate with the business for requirements and changes needed to new and existing reports

Advanced Excel work including pivot tables, VLOOKUP, and data conversion using SSIS packages, macros, and templates for data migration in Excel

Contractor 11/2015 - 06/2016

Create and manage user accounts for Metrix System

Assist developers in SAP data entry

Test new internal Application Development

Assist System Analyst with SQL development and testing

Assist in creation of new web-based applications

CLIENT: DeVry University, Alpharetta, GA. 8/2014 – 11/2015

IT Tutor

Provide tutoring for computer sciences undergraduates in programming languages, C#, Java, SQL, ASP.Net, and PHP

Tutor general undergraduates in all IT related products, such as Microsoft Office, and RSA.

EDUCATION AND PREVIOUS CAREER EXPERIENCE:

Bachelor of Science Computer Information Systems - DeVry University, Alpharetta, GA Dec 2015.

Military:

US Army, Fort Bliss, TX 03/2008 – 01/2013

US Marine Corps, Camp Lejeune, NC 12/2001 – 12/2006

Contact this candidate