SQL or Data analyst

Douglas Alan Williams

City, State: Centennial, CO Email address: **************@*****.***

Telephone Number: 720-***-**** LinkedIn Profile: https://www.linkedin.com/in/douglas-w-178b04199/

Professional Summary

Seasoned Senior Coordinator with ten plus years of experience in researching, gathering and analyzing data from one or

more data sources using SQL, Toad, Microsoft Excel, and Microsoft Access. In addition experience with PERL Scripting and

HTML for distribution of the results of the research.

Hard Skills Soft Skills

SQL querying Collaboration

Microsoft Office Teamwork

Microsoft SharePoint Critical Thinking

Gmail Organization

PERL Scripting Active Listening

HTML Active Learning

PHP

JavaScript

Json

QlikView

Tableau

Work History

Robert Half, Various locations in the Denver Metro Area depending on the assignment.

May 2020 – Present

Contractor

Collected, Inventoried, and Prepared computer equipment for shipment.

Verified and if possible repaired computer issues for customers.

Other duties as needed in the assignment.

CenturyLink, Thornton & Littleton, Colorado

April 2006 – December 2019

Business Intelligence Analyst

Employed Tableau to pull raw data, charts and graphs for reporting

Pulled raw data from specified reports converted them to pivot charts to show trends in ticket and calls answered.

Pulled and used graphs from the specified report to show trends for multiple months and year to month.

Pulled individual technician data for managers and director of the teams.

For reports that needed data not shown in the report that was specified by management. I would pull data from alternate reports and formatted it as need to show trends.

Created weekly, month to date, year to date reports showing tickets worked, human error trends, network element

counts per one hundred tickets. Using Microsoft Excel and Tableau raw data

Added conditional formatting for monthly vice president report in place of manual formatting in Microsoft Excel

Coordinator 2

Created SQL queries both simple and complex for one time ad hoc and ongoing reporting

Created SQL queries for combining data from two or more databases into one databases

Created SQL queries for pulling data to be used on JSON data representational grids

Created PERL scripts to create emails with data grids and spreadsheets to be sent out on a multiple time of the Day, Daily, Weekly and Monthly schedules

Processed data to show trends, using pivot tables, pivot charts and graphs

Created web forms per requirements of the requester using HTML, PHP, JavaScript.

Created templates to take different data set formats into one combined data set

Renovated International Carrier Information pages and performed a partial rebuild of team information pages

Education

Computer Networking and Information Technologies Associate degree Cambridge College, Aurora, Colorado

Electronic design and troubleshooting Associate degree in Applied Science Electronics Technical Institute, Denver, Colorado

PERL Scripting Certificate course Books 24/7 Online

JavaScript Certificate course Books 24/7 Online

HTML 5 Certificate course Books 24/7 Online

Oracle Database 11g Certificate course Books 24/7 Online

Programming Foundations: Algorithms Certificate course Lynda.com

Learning Transact-SQL Certificate course Lynda.com

SQL Essential Training Certificate course Lynda.com

Introduction to Web Design and Development Certificate course Lynda.com

How to Create a Perfect Elevator Pitch Certificate course Lynda.com

Recovering from a Layoff Certificate course Lynda.com

Contact this candidate