Data Analyst

SUMMARY

Highly motivated, responsible, and reliable professional analyst with very strong technical skills. Ability to reconcile data obtained from various locations and in a variety of formats to meet customer reporting/data requirements. Seeking a challenging position that can not only utilize existing skill sets, but provide opportunities to allow for growth of new skill sets to help move the company forward.

WORK EXPERIENCE

Sales Performance Reporting Analyst

June 2011-December 2016

AT&T – MCO Sales & Service Centers, Business Customer Service

Developed and maintain databases for PURL data/reporting, ShortURL click data/reporting, and Social Media data/reporting from various data sources

Developed and maintained reports created from databases, including reports for targeted customers to aide in the reduction of calls to call centers and increase digital adoption. Would sometimes use pivot tables and other formulas within Excel for smaller reporting requests

Handled AdHoc data and report requests

Assisted with Social Media performance reporting from Salesforce and Radian6

Collaborated with peers on look and feel of presenting metrics to the social media team and leadership

Collaborated with vendors for data extracts and regular feeds of data for various reporting

Developed Visual Basic and VBA macros to mechanize repetitive office tasks, database loads, and reporting

Assisted Social Media team with cases during high volume periods

Manager Quality/M&P/Process

May 2010-June 2011

AT&T – Wholesale Customer Care

Collaborated with peers to perform data analysis for process improvement

Collaborated with peers on look and feel of presenting metrics and that they met the requirements of the end user

Handled AdHoc data and report requests

Monitored daily database loads and resolved issues for both Access and SQL Server databases, including those databases that house data for the Fingertip reporting website, and other databases like those used for Sub-Process reporting

Developed existing and new databases including building tables, queries, forms, DTS and SSIS packages in both Access and SQL Server as needed to meet the needs of the team as well as customer reporting requirements. Would sometimes use pivot tables and other formulas within Excel for smaller reporting requests

Developed Visual Basic and VBA macros to mechanize repetitive office tasks, database loads, and reports

Wrote SQL queries to obtain data from various corporate databases including EDW, NIW, OQS, DB2 and IMEPAS

Created dynamic web reports using HTML, ColdFusion, and ASP for Fingertip website, as well as static webpages for the Access Operations website

Server administration including configuring IIS and security access privileges

Maintained ACTS Database on UNIX server and served as Tier2 Support

Navigated WFA mainframe systems to extract data for various reports

Network Center Technician

October 2000-May 2010

AT&T – Wholesale Customer Care

Monitored daily database loads and resolve loading issues, as well as any other issues that may arise, for Access databases the team uses for reporting

Developed existing and new databases including building tables, queries, forms and DTS packages in both Access and SQL Server as needed to meet the needs of the team as well as customer reporting requirements. Would sometimes use pivot tables and other formulas within Excel for smaller reporting requests

Developed Visual Basic and VBA macros to mechanize repetitive office tasks, database loads, and reports

Wrote SQL queries to obtain data from various corporate databases including EDW, NIW, OQS, DB2 and IMEPAS

Created dynamic web reports using HTML, ColdFusion, and ASP for Fingertip website, as well as static webpages for the Access Operations website

Single handedly took over maintaining the ACTS Database on UNIX server and served as Tier2 Support. Later developed an Access database to interface with the database on the UNIX server allowing for easier maintenance of records as well as creating a back-up of those records

Navigated WFA mainframe systems to extract data for various reports

Developed and maintained socket listener program in PERL (learned enough of PERL inside of 2 weeks to accomplish this task) to run as a system process on a Windows Server for handling of flat files coming to the server via VPS (Virtual Printer Service) from a mainframe system.

Inventory Controller

July 1997-April 2000

Smiser Industries, Inc.

Maintained all inventory

Assisted in Research and Development to enhance products as well as develop new

Drafting of machine fabrication drawings, wiring diagrams, and schematics

Assisted in production of products, which would include soldering components onto printed circuit boards as well as wiring panels and other sub-assemblies

Troubleshooting systems to component level and repair them

Lead Sound Engineer (Volunteer)

January 2010 - Present

Northside Christian Church

When scheduled, responsible for setup of sound console including mapping inputs, outputs, setting EQ and dynamics, etc… As well as mixing FOH for rehearsals as well as Sunday services.

Train new volunteers on the sound console and responsibilities four Sound Tech positions.

Assist in troubleshooting and repairs of A/V issues. Occasionally this will also include troubleshooting equipment to component level and repairing it.

Assist with A/V projects which includes relocating equipment as well as installing new equipment. This would also include collaborating with the worship pastor on designs, any cable runs that need to be done as well as assisting in configuration of equipment.

On occasion will take on projects that include some research like building signal lights for the drummer to signal the FOH sound person that they need to talk to them, or even designing and producing other simple equipment like a DI box. I also assist in researching products for potential projects, how to configure equipment, wiring, etc

EDUCATION

DeVry University

Online

Bachelors – Engineering Technology – Computers

105 Credit Hours Completed

ITT Technical Institute

1999

Houston, Texas

Associate Degree – Electronics Engineering

Waller High School

1997

Waller, Texas

Diploma

SKILLS

Comprehensive understanding of computers and networking, Extensive experience with MS Office Products (including Excel, Word, Access, PowerPoint), Webpage development and maintenance, HTML, ColdFusion, VBScript, JavaScript, ASP, Visual Basic, VBA, SQL, JAVA, C++, Business Objects, SQL Server, UNIX & Windows Server, Salesforce, CAD, Six Sigma Green Belt, electrical, plumbing, General Carpentry, Welding

Contact this candidate