Shayne Fraser

**** ********* ** ** • Smyrna, GA *0082 • 678-***-**** • ad23ii@r.postjobfree.com

linkedin.com/in/shaynef

TECHNICAL

EXPERTISE

● Tools — Power BI, SSMS, Oracle SQL Developer, Power BI, Tableau

● Databases — SQL, Oracle, Postgres

● Languages — C#, Javascript, XML, SQL, DAX, DirectQuery EXPERIENCE

SQL Developer, Mar 2020–Jan 2024

SP Richards

● SQL/TSQL- Develop ETL processes and procedures.

● Oversee daily processing. Analyze and update errors occurring processing.

● Develop reporting solutions for end users.

Data Analyst and Animal Wearables Specialist, Tableau Server Developer and Manager, February 2018–September 2019

AGL Technology, Peachtree Corners, Ga.

● Tableau, Excel, SQL, MS SQL Report Builder - I created reports to support business goals and monitor the battery health and quality of data of IOT sensors deployed in the field and in canine clinical studies.

● During clinical studies which could last from 5 weeks to 3 months, I would be in frequent contact with clinical technicians and administrators to supervise the setup of data collection systems and troubleshoot potential problems that may impact the operation of the study.

● T-SQL, Tableau, Blat - Develop custom applications and combine them with existing products to assemble and automate distribution of daily reports for both internal and external clients.

● SQL - Create custom queries to monitor the functioning of server processes to ensure data continuity.

● MS Access - Created front-end solutions for managing and inputting data. Data Manager, Tableau Server Developer and Manager, April 2011–March 2017 Park ‘N Fly, Atlanta, Ga.

● SQL - I produce most one-off reports for immediate needs of the company. Many of which try to fill in gaps not covered in original data captures.

● T-SQL, Tableau, Blat - Develop custom applications and combine them with existing products to assemble and automate distribution of daily reports for both internal and external clients.

● Visual Studio, BIDS - Create ETL processes to migrate data from legacy systems to newer system data storage, while transitioning to the newer systems.

● Tableau, Excel, SQL - Created a weekly and more comprehensive monthly report covering facility volume, revenue, accounting adjustments for both on-site and online transactions. I streamlined this process from a one-week production time, at the start of my employment, to an approximately four-hour window, while increasing the level of detail and consistency.

● MS Access - Created front-end solutions for managing and inputting data. Web Developer, November 2005–December 2009

Intrust Bank, N.A., Wichita, Kan.

● Created simpler procedures and automation to make data management easier for employees. This included creating applications that watched for, processed, and re-distributed periodic files necessary for daily operations.

● Made access to information easier for external customers by enhancing the external Web site. These functions ranged anywhere from creating an automated process that pulled and Shayne Fraser

3602 Westbrook Dr SE • Smyrna, GA 30082 • 678-***-**** • ad23ii@r.postjobfree.com linkedin.com/in/shaynef

published hourly XML weather updates for the website, to streamlining forms to reduce input error and speed delivery.

● Updated and maintained internal and external Web sites. Much of the internal website involved sharing data between departments and relied on submitting data to, and pulling queries from Access databases.

● Designed, implemented and supported Web or network-based data management systems while maintaining data security.

● All development was performed using MS Visual Studio and ran on IIS. The external website was converted to C#.net from VB.net during this period. The internal and ‘side’ websites were still in VB.net when I left.

● I was in process with project managers and department managers to rebuild the intranet site using SharePoint at the time I left INTRUST. I had progressed to the point of establishing department sub-sites with collaborative permissions based on Active Directory group memberships, integrating the corporate Active Directory in a twice-daily update to the SharePoint employee directory lookup, and developed modules to enable to marketing to update, modify the display of, and publish the ‘news’ landing page.

● I utilized CSS, master pages, XML, SOAP, HTML, and DHMTL by way of ASP.net, VB.net, C# and JavaScript.

All projects were performed in the same environment. Environment:

ASP.NET 3.5, C# 3.5, Visual Studio 2008, SQL Server 2008, ASP.Net MVC 1, ASP.NET Ajax, XMLSpy, MS SPD.

Data Security Specialist, May 2001–November 2005

Intrust Bank, N.A., Wichita, Kan.

● Provided for the integrity, security and availability of the company data. I used a combination of system controls and audits to ensure the minimum necessary access, thereby minimizing risk and maximizing data continuity. The audits relied on an Access database that I created that imported tables provided by HR, queried Active Directory for current network status, normalized the data, and ran a series of 23 queries, comparing them to the Data Security records, all through VBA macros and scripts.

● Scanned and secured networks and machines using MSBA and ISS to reduce exposure to internal and external vulnerabilities.

● I set up and maintained user accounts and security access. During my term in this position, we had a dual network on Novell and MS and eventually finished the migration of files and permissions to MS.

EDUCATION Friends University,

Wichita, Kan.

MIS Training Institute,

Chicago, Ill.

2010, continued Fundamentals of

Information Security

New Horizons and Executrain,

Wichita, Kan.

Programming with MS Visual Basic .NET, MS Windows 2000 Network and Operating System Essentials, Programming an MS SQL Server 2000 Database

Contact this candidate