Engineer Software

GAVIN GUNAWARDENA

Westminster, Colorado 702-***-**** *********@*****.*** www.linkedin.com/pub/gavingunawardena Results oriented and highly adaptable database and software support professional. Many years of experience deploying casino management software, designing ETL solutions, administrating databases and development. CERTIFICATIONS : Please see Linkedin for Acclaim verification

Microsoft Certified Solutions Expert: Data Management and Analytics – April 2020

Microsoft Certified Solutions Associate: SQL Server 2016 Database Administration – January 2020

Microsoft Certified: Azure Fundamentals – July 2020

Axelos ITIL v4 Foundation Level Certification – June 2020 EDUCATION:

Bachelors of Science in Information Systems

Major GPA: 3.67

University of Nevada Reno

12/10/13

TECHNICAL SKILLS:

LANGUAGES: SQL, C#, .NET, Powershell, VBA, Visual Basic, Javascript, HTML, CSS SOFTWARE DEVELOPMENT: Relational Database Design, Data Warehouse Design, Database scripting/querying, Object Oriented Programming, Git

APPLICATION SOFTWARE: SQL Server 2000/2008/2012/2016, Microsoft Office (Word, Outlook, Excel, Visio, Teams, Powerpoint, etc.), Git, Team Foundation Server, Visual Studio, SSIS, Crystal Reports, SSRS, Power BI, Tableau, Clarity, Azure, VMWare, Mobileframe, Oasis 360, Windows Server, BMC Remedy DATABASES: SQL Server CE/2000/2008/2012/2016, Access SQL SERVER: High Availability, Data Recovery, Performance Tuning, Corruption Repair, BCP, Troubleshooting KEY SKILLS:

Systems Analysis and Design

Telecommunications(OSI

Model)

Agile SDLC

Relational Database

Design/Development

Relational Database

Administration

Process Automation

Attention to Detail

Strong Organizational Skills

Staff and Customer Training

Written and Verbal

Communication

Technical Writing/Presentations

Project Scoping/Planning

Customer Service

Analytical Problem Solving

WORK EXPERIENCE:

Database Engineer III

Aristocrat Technologies Inc. - Casino Software and slot machine company On Site and remote technical lead for database and software upgrades, installs, and migrations for over 20 casinos, including the grand opening of over 10 casinos

Documented processes and conducted lectures to train coworkers and customers on new and updated software and installation processes

Updated and wrote scripts and stored procedures in order to solve process, reporting, audit, and ETL issues

Utilized MS SQL Server 2012/2014, Window Server 2012, PowerShell 5, VMware, IIS, Rest API, Postman, MS Network Load Balancer, MS Team Foundation Server, MS Teams

10/1/18 to 2/25/19

Solved and assisted with casino accounting and database issues having to do with performance tuning, data recovery, corruption repair, high availability preparation and report updating/access

Coordinated with project teams and casino executives in order to complete objectives

Resigned in order to pursue personal and career goals Database Engineer II

Aristocrat Technologies Inc. - Casino Software and slot machine company On Site and remote technical co-lead for database and software upgrades, installs, and migrations for over 40 casinos, including the grand opening of over 20 casinos

Documented processes and conducted lectures to train coworkers and customers on new and updated software and installation processes

Updated and wrote scripts and stored procedures in order to solve process, reporting, audit, and ETL issues

Utilized MS SQL Server 2012/2014, Window Server 2012, PowerShell 5, VMware, IIS, Rest API, Postman, MS Network Load Balancer, MS Team Foundation Server, MS Teams

Solved and assisted with casino accounting and database issues having to do with performance tuning, data recovery, corruption repair, high availability preparation and report updating/access

Coordinated with project teams and casino executives in order to complete objectives 3/23/15 to 10/1/18

Procurement Intern

Allegiant Air - Airline and Travel Agency

Worked in a small development team on designing, developing, and deploying a cross- platform package-tracking software as well as enhancing their accounting software

Utilized the Mobileframe development framework, .Net 2.0, T-SQL, and Batch

Coordinated with Mobileframe engineers in order to resolve problems with projects

Created enhancements and fixed bugs in MS Access applications utilizing VBA and SQL

Wrote a flight lookup application utilizing Mobileframe, .Net 2.0 and T-SQL with an automated ETL process for choosing which packages go on which flight 6/3/14 to 11/14/14

Information Technology Intern

MGM Resorts International – Casino and Resort Corporation Assisted the PMO and learned about the responsibilities of roles of different IT sub- departments

Conducted an audit of over 40 projects being worked on by project managers

Configured and documented their recently implemented project portfolio management software, Clarity

Learned about the responsibilities of project managers, business analysts, database admins, business technology partners, and the vice president of the IT department 6/3/13 to 8/9/13

Contact this candidate