SQL, Crystal Reports, Tableau, MS Excel, VLookups, Pivot Tables

Data Analyst

Terry Van Williams

*** ****** ***** *****, #*****; Irving, TX 75038

(214) 229 – 4125

********.*****.***.***.**@*****.***

PROFILE OF QUALIFICATIONS

A bright, talented and self-motivated data analyst who has excellent organizational skills, is highly efficient and has a good eye for detail. A reliable individual with over 9 years of experience in the Social Work environment and with over 10 years’ experience as an IT professional. Has extensive experience in the researching, monitoring and enforcing policies and procedures. Able to play a key role in analyzing problems and coming up with creative solutions as well as producing methodologies for effective data management. A quick learner who can absorb innovative ideas and can communicate clearly and effectively.

HIGHLIGHTS

Proficient in developing reports of test results that are easy to utilize

Excellent organization and corporate presentation skills

Able to meet any project deadline

Dedicated to utilizing a database to bring prosperity to an organization

Proficient critical thinking and situation analysis skills

TECHNICAL SUMMARY

MS EXCEL Pivot Tables VLOOKUP

COBOL II JCL VSAM

DB2 IMS TSO/ISPF

MS Access SQL Queries Tableau

PROFESSIONAL EXPERIENCE

Quality/Integrity

Analyzed daily quality reviews for SNAP, TANF, and WIOA government

programs to determine that all Board and ResCare policies and procedures were followed.

Submitted and analyzed metric control reports that monitored center performance

against contractual obligations.

Analyzed the hard copy documentation, application data entry, trend tracking and

adherence to process/procedures.

Recommended how performance could be improved and worked with center managers

to ensure the recommendations are acted upon.

Researched files to determine that client met all eligibility requirements.

Tier III (QA) approver of ITA’s and other program activities(Subsidized)

Reviewed to ensure that internal quality checks and external monitoring’s have an

error rate less than 10%.

Reporting/Performance Data

Executed, analyzed and formatted state programs (SNAP, TANF and WIA) reports for staff and management

for the Irving Office.

Created line graph that indicated the contact-hire relationship for Dallas County Workforce Solution Centers.

Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.

Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.

Designed, recorded, and executed macros to automate data entry inputs.

Formatted spreadsheets and workbooks for print, document reproduction, and presentations.

.

Terry V. Williams ********.*****.***.***.**@*****.*** (214) 229 - 4125

Workshop / Instructor / Test Administrator

Administered TABE test to WIA and TANF recipients to determine academic level.

Instructed the Pre-Employment class by providing information to participants in one-on-one

or group format areas of Career Readiness, Job Re-search, Networking, Life Skills and

other skills required to secure and retain employment.

Initiated, instructed and created two ‘Computer Basic’ courses during the fall of 2009 and the

1st quarter of 2010.

Created and instructed Summer Youth curriculum in 2009.

Assessed WIA clients using ‘Prove It’ software to determine customer service skills.

Mainframe Development / Implementation / Communication

On a team of three that did a rewrite of the A/R system for Y2K compliance.

Enhanced tax program to populate GEOCODE field when empty via CBM IMS database.

Actively involved in phases of application development from design through implementation.

Used Endeavor to process unit and system testing for all projects.

Handled requirement projects via testing and using structured methodologies.

Used Changeman to implement programs (developed and enhancements), JCL and PROCS.

Communicated with Client/Server that downloaded data for mainframe processing.

Worked closely with users to define and support needs.

EMPLOYMENT HISTORY

Quality Assurance Analyst - Workforce Solutions Greater Dallas - Dallas, Texas 2013 – 2016 Performance Analyst - Workforce Solutions Greater Dallas - Dallas, Texas 2007 – 2013

HelpDesk Analyst - People Logic Staffing (Accenture) - Dallas, Texas 2006 – 2007

EDUCATION

Southern University – New Orleans, LA

B.S., Mathematics

A.A., Computer Science

Contact this candidate