TODD E SANCHEZ
San Antonio, TX **259
acr0yv@r.postjobfree.com
Career Objective
Seeking a position that would effectively utilize prior experience, education, and technical abilities in data and reporting analysis while offering the potential for continuing professional growth and advancement.
Summary of Qualifications
Visual Basic(Excel)
Excel
Business Objects
SAS/SQL
Microsoft Access
Lift Over Control Methodology
Perl
Oracle
Teradata
Residential Management Systems (RMS)
Crystal Reports XI (formal training)
Natural Programming Language
C Programming Language
Microsoft Word
Powerpoint
Adometry
Work History
May 18, 2015 to Sep 18, 2015
Contracted with USAA through The Millennium Group – San Antonio, Texas
Decision Science Analyst Mid
Provided data/reporting analysis and support for various levels of marketing personnel. Reports done in various tools including Business Objects, SAS/SQL, Excel, and Powerpoint. Written analysis provided for less technical personnel including recommendations for targeted audiences and effectiveness of marketing campaign analysis using lift over control methodology. Attended meetings in various capacities to gather information and to provide necessary feedback on marketing campaign performance as well as providing recommendations for future marketing campaigns.
Jun 1, 2014 to May 15, 2015
Contracted with the Department of Veterans Affairs through Intratek – San Antonio, Texas
CMDB Analyst
Extensive government background check to obtain a High Public Trust clearance. Created reports in Excel based on help desk data analysis which included pivot tables, vlookup, and other formulas. Considered subject matter expert on Excel including automating of Excel reports using Visual Basic.
Jun 26, 2006 to Jan 31, 2014
Contracted with AT&T through Group O Marketing Solutions – San Antonio, Texas
Marketing Support/Services
Automated sales reports using Visual Basic, Excel, Perl, and SQL to show concise and relevant statistics as well as written sales analysis with recommendations for future marketing strategies. Reports in Excel used pivot tables, vlookup, formulas, charts, and macros extensively. Provided plain English written analysis for non-technical marketing personnel to explain Excel marketing reports which included areas to focus on for marketing as well as areas to avoid. Maintained databases for AT&T sales campaign data using various company database tools as well as Business Objects 6.5 and XI. Performed pre-sales campaign analysis to give marketing clients approximate counts of customers to target for campaigns using Business Objects.
Feb 28, 2003 to Jun 16, 2006
University of Central Florida Dept. of Housing - Orlando, Florida
Computer Programmer Analyst
Database Administrator which included maintaining a database for residents living on campus. Creating reports as needed and within a program called Residential Management Services(RMS) using Crystal Reports and Microsoft Access. Training new and old users of RMS. Testing upgrades of RMS. Reporting and helping fix bugs in RMS. Modifying and repairing databases using Access.
Oct 10, 2000 - Feb 26, 2003
Florida Department of Financial Services - Tallahassee, Florida
Computer Programmer/Analyst I
Maintained computer programs written in Natural for the State of Florida accounting systems. This involved writing new programs, editing old programs, and checking code written by other programmers on a mainframe system. JCL(Job Control Language) was used to run the programs on a nightly basis. These jobs were edited and created as needed. In addition to these responsibilities technical support was given to non-programmers in regards to their programs.
Education
May 1999
University of Central Florida - Orlando, Florida
Education Level: Bachelors Degree
Major: Computer Science