Data Analyst Power Apps

Jess Holmes

Pfafftown, NC

336-***-****

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

January 2014 - March 2022

Data Analyst – SQL Programming

Extensive experience ensuring business solutions are delivered in compliance with client requirements and quality standards. Proficient at testing source code, Data Modeling, Data Visualizations and Dashboard development. SQL Programming, Query Optimization, Database Administration.

Code Writing Database Administration Program Testing Data Analytics Power Apps

EXPERIENCE

PGT Solutions March 2022-Present

Work on government contract with the Veterans Health Administration as a SQL DBA and Power Apps Developer. Developed canvas applications in Power Apps that supported administrative functions within the VA by creating workflows for process modelers to track their work within their teams. Also developed applications to track change requests and developed a Data Dictionary app to keep up with changes to the database for business units to record what changes were made and provide detailed information on the purpose of all the tables in the SQL Database. Assisted with Power BI reports and integration between Power Apps and Power BI.

Digital Risk, Orlando Florida September 2021 – December 2021

Provided Data Analysis and data cleaning for Mortgage loan applications. Duties included

Data Cleaning

Data Analysis

Documenting Process flows

Lowe's Home Improvement, Mooresville NC March 2015 - December 2020

Software Engineer, SQL Server Admin

Provided maintenance on .NET application used to track all financial transactions that are processed in the stores, and for Trade Payable and Capital Expense invoices.

Maintained backend SQL Server DB by writing Stored Procedures, DB optimization, Manage DB backups.

Wrote C# scripts to apply bug fixes and enhancements to the Financial Application.

Create PowerBI dashboards to track Financial Statistics

SQL Stored Procedure Development

Asurion, Sterling VA January 2014 – March 2015

Data Analyst

Duties included data mining, data cleaning, creating excel financial reports to provide to Management ‘* SQL, Excel, MS Access, VBA

Hewlett Packard, Winston Salem NC November 2001 - January 2014

.NET Application Developer SQL Administrator Project Manager IT Support Manager

Developed front web applications to track Hardware, Support tickets, and Inventory management.

Maintained backend SQL Server DB by writing Stored Procedures, DB optimization,

Managed DB backups.

Wrote C# scripts to apply bug fixes and enhancements

American Airlines, Winston Salem NC August 1986 - November 2001

.NET Application Developer SQL Administrator Project Manager IT Support Manager

Developed front web applications to track Hardware, Support tickets, and Inventory management.

Maintained backend SQL Server DB by writing Stored Procedures

Managed DB backups.

SQL Programmer

ETL Data Warehousing

EDUCATION/Certifications

Associates Degree IT, Florida Technical College Orlando FL

Google Data Analyst Certification

TECHNICAL SKILLS

Programming Languages:

C# .NET, ASP.NET, Visual Basic, VBA, JavaScript, JSON, SQL, TSQL, MS OFFICE automation, HTML, Python, R

Database Experience:

MS SQL Server

IBM DB2

Oracle

ETL Database Warehousing

Software Applications:

Excel, Word, PowerPoint, MS Access’

Visual Studio IDE

Visual Studio Code

R Studio

PowerBI,

Tableau

Jupyter Notebooks

JIRA

Contact this candidate