M. David Jaynes
*******@*****.***
Objectives
Fulfill the role as Power BI Developer and Administrator
Perform ETL operations to gather necessary client data.
Work extensively with both ‘M’ and DAX code when creating visualizations.
Perform role as Power BI Administrator setting up Gateway connections to On-Prem data cubes.
Create Rich Power BI reports and Apps which present back-end data quickly and accurately.
Maintain the Power BI environment by maintains Gateways and Workspaces.
Fulfill the role of MS-SQL Administrator
Create complex stored procedures, function, triggers and query to support Business Intelligence needs.
Maintain the Database housekeeping needs such as backups and scheduled jobs.
Maintain the security of the Database environment.
Ensure data speed and reliability using proper indexing on tables
Fulfill the role and .NET developer
Create applications in C#, ASP.NET, PowerShell among others.
Use Microsoft Visual Studio as application development platform.
Fulfill the role of Azure Administrator
Administer Microsoft Entra.
Develop App Registration to be used to apply necessary rights to applications.
Maintain Azure SQL databases and Tables.
Create and Maintain Azure Storage Pools.
Create and Maintain Azure runbooks.
Work Experience
Power BI Administrator/SQL Administrator/Software Developer
Eversana Mason, OH
June 2019 - Present
Power BI Administrator
Perform everyday ETL operations with a variety of data sources.
Develop solid Data Modeling environments where information can be easily retrieved and displayed.
Work closely with Power Query ‘M’ code, transforming data into useable forms.
Create rich Power BI reports using techniques such as data drilldown and bookmarking.
Work closely with data owners, discussing their needs for business reports.
SQL Administrator
Work extensively with Azure SQL databases.
Work daily with MS-SQL Server 19 operations.
Use SQL SMS on a daily basis.
Perform complex Stored Procedures and Functions to support various applications
Familiar with the 3NF Normalization Data Modeling Design.
Perform routine database backup and recovery job activities.
Perform troubleshooting activities when investigating query latencies.
Write comprehensive Views, functions and queries to meet needs of projects.
Obtained the PL-300 Data Analyst certification for Power BI.
Obtained the AZ-900 certification for Azure Cloud support.
Work with Agile team to develop applications and business reports.
Provide bi-weekly Sprint updates.
Maintain the DevOps Azure repository to ensure proper versioning of data.
Work extensively with Microsoft Azure performing such tasks as:
Account Creation and maintenance
Application Development via API Registrations and Enterprise Application.
PowerShell and Python workbook development.
Create software application in ASP.NET, C Sharp, PowerShell, Python using Microsoft Visual Studio
Assist in Linux based operations such as filesystem expansions, user account administration and many other tasks.
EMC Storage Admin/Linux Administrator/Ansible Automation developer
Compucom Cincinnati, OH
May 2010 – May 2019
Maintained a multi-Datacenter EMC storage environment
Provided Daily Linux administration for over 200 RedHat Linux platforms
Developed several automation applications using Ansible Tower and Ansible Engine.
EMC Storage Admin/Linux Administrator
Logic Technology Cincinnati, OH
May 2005 – May 2009
Maintained a multi-Datacenter EMC storage environment
Provided Daily Linux administration approximately 340 RedHat Linux platforms
References
Name
Relation
Jerry Locke
*****.*****@********.***
Worked at Eversana with Jerry
Larry Wheat
*****.*****@********.***
Worked at Eversana with Lerry
Ted Schuette
***.********@********.***
Worked at Eversana with Ted
Education:
Associates Degree in Computer Science
ECPI University, Virginia Beach VA
Graduated: 1996 GPA. 3.6