Brian LaFrance

**** ********* ***

Addison, TX **001

Phone 806-***-****

adl1yp@r.postjobfree.com

OBJECTIVE:

To obtain a professional position with an organization that allows for career advancement and development based on prior education and experience.

SKILLS PROFILE:

Self-motivated and organized team player

Strong people and customer service skills

Excellent verbal and written communication skills

EDUCATION:

Rawls College of Business, Texas Tech University, Lubbock, TX

Bachelor of Business Administration Management Information Systems

Graduation Date: December 2011

Dean’s List: Fall 2009, Spring 2011, Fall 2011

GPA: 3.30

Technical Skills

Languages: PL/SQL, VB.NET, VB6, PERL, IONIC, Shell Script, XML, DB2, PowerShell

Operating Systems: Windows Server 2003, Windows Server 2012, Oracle Toad, Linux, Talend, Microsoft Visual Studio, Unix, SQL Server 2014, SQL Server 2016, SQL Server 2017, SSIS, SSRS, Service Now, JIRA, Excel, Adhoc

EXPERIENCE:

Zenner

Software Support Specialist (November 2021 – Present)

Manage SQL Server databases

Customer software installations of new meters

Test and update firmware updates

Manage customer accounts of all data

Troubleshoot software for Handheld meter reading units

City of Dallas

Database Analyst (June 2020 – October 2020)

Manage SQL Server databases

Install SQL Server Management Studio on new servers

Create and alter Maintenance plans to provide new permissions

Shrink Database log files

Remove orphaned users

Run scripts for updates to tables on databases

Grant Permissions to users to access databases

Freeway Insurance

Database Administrator (August 2019 – March 2020)

Manage SQL Server databases

Install SQL Server Management Studio on new servers

Create and alter Maintenance plans to provide new permissions

Design PowerShell scripts to create backups to databases

Apply Cumulative Updates to servers

Run scripts for updates to tables on databases

Run manual backups to servers

Build indexes to on tables to run more efficient

Atmos Energy

Applications Developer (March 2016 – May 2019)

Manage data for multiple databases in Oracle Toad, SQL Server, and Unix

Create and execute queries using PL/SQL

Manage multiple applications used within the business

3rd tier support on applications

Implement upgrades to existing applications

Design, develop, and implement UNIX procedures

Update Datasets to geocoding software

Design, develop and implement new mobile applications

Design, develop, and implement new applications

Document procedures and data flows

Load databases using SSIS packages and Unix shell scripts

Create and automate Perl procedures

Frontend design and development of applications

Design, create, and deploy JAVA code using IDE(Eclipse)

Creating and completing tickets on Service Now and JIRA

CGI

ETL Developer/Lead of Balancing (August 2013 – March 2016)

Manage data for multiple databases in Oracle

Create and execute queries using PL/SQL

Correct any errors due to corrupt data on multiple databases

Work with Sales Audit team to correct any missing tender at stores

Resolve any errors on ETL jobs caused by corrupt data

Design, implement, and administrate new database tables on Oracle Toad

Assist in creating stored procedures to resolve errors on databases using PL/SQL

Assist QA team with any errors on store databases when implementing updates to stores

Troubleshoot new errors when client implements upgrades to Point of Sale System involving corrupt data

Research multiple tables to resolve any conflicts between tables that cause inbound process to fail.

Prepare daily Excel reports using PL/SQL in Oracle for Sales Audit and Inventory teams

Train new team members on database structure and flow of inbound process

24 x 7 Production Database on Call Support

A&G Healthcare

Computer Programmer (April 2012 – August 2013)

Assist in the creation and demonstration of VB.net applications for potential clients

Create and execute SSIS packages to load data to various databases including SQL and Microsoft Access

Create SQL statements to manage databases

Design and create medical and dental forms using Visual Studio

Program, design, and map existing insurance matching applications

Troubleshoot existing insurance matching applications for clients when errors occur

REFERENCES: Available upon request

Contact this candidate