***** ****** **. ****: 951-***-****

Temecula, CA 92592 Cell: 951-***-****

Email: abiwza@r.postjobfree.com

[pic]

Professional EXPERIENCE

REVShare, Temecula, California 2007 - 2009

Television's Largest Cost per Action Advertising Network. REVShare

distributes advertisers' Cost-per-Action (CPA) commercials across its

Network of 1700 television properties including cable systems, syndicators,

and national affiliates reaching over 110 million households.

Data Analyst

Primary data liaison for a division of REVShare using a FoxPro based

program and database with the parent company using a MySQL database and

with outside clients with data in various formats.

. Produced custom reports from a MySQL database to support other

departments in the company.

. Wrote and maintained programs in FoxPro to transfer data between

FoxPro database and MySQL database.

. Wrote and maintained programs in FoxPro to pull data from a MySQL

database and a FoxPro database to produce text files for import into

another FoxPro Database.

. Analyzed data for billing reconciliation, fraud, and to detect

patterns to help client properly staff their operators.

. Gathered user requirements for a new in house program including a data

dictionary of their current data.

Visual Records, Temecula, California 2004 - 2007

Visual Records specializes in developing innovative and high-quality

software products and systems for all industries by partnering with

entrepreneurs and visionaries.

Data Systems Programmer

Responsible for creating databases in MS SQL 2000 and 2005, programming,

and client support.

. Created MS SQL 2005 databases which entailed writing stored

procedures, views, user defined functions, including user defined

table functions.

. Created reports, invoices and disbursements using SQL Server 2005

Reporting Services and Crystal Reports.

. Converted data using MS SQL Server 2000 DTS.

. Programmed an Optical Character Recognition, OCR, module in C#

. Wrote code for a Release of Information (ROI) program for the medical

field that was a .Net Windows program with MS SQL 2000 database that

generated code to create triggers that would create an audit trail.

This was written so tables could be added or changed in the database

and by selecting an option in the program the triggers would be

automatically updated.

. Sole person responsible for the customizing, programming business

rules, and support of a FoxPro Third Party Administration Insurance

program, developed all of the reports requested by the user.

. Supported other programmers in writing their SQL queries,

optimizing database access,

QA tested several programs, recommended program enhancements, and

provided information for the user manuals.

. Taught new users, in a classroom setting, and supported end users.

HealthLine Systems Inc., San Diego, California 1996 - 2004

HealthLine Systems is the leader in credentialing software, contact center

software and quality management . HealthLine delivers state-of-the art

healthcare software solutions to hospitals and healthcare organizations.

Computer Programmer 1999 - 2004

Responsible for MS SQL Server 7 and 2000 database structures used as the

basis for all new development and writing code for program upgrades.

. Used xCase to create referential integrity functions and procedures.

. Converted user data from FoxPro databases to MS SQL databases.

. Coded and improved functionality of several areas of a program being

converted from FoxPro with FoxPro database to a three-tier environment

using MS Visual FoxPro with a MS SQL Server database.

. Programmed procedures in a program being converted from Visual Objects

to being internet base using Visual Studios .Net and C#.

Product Manager 1998 - 1999

Responsible for the companies credentialing software and quality assurance

program. Liaison between client support and the computer department.

. Gathered program requirements from clients and presented specs to the

computer department.

. Ran quality assurance tests on programs and gave feed back to the

programmers.

. Updated clients database with annual changes of the diagnosis and

procedure codes

. Supported client support representatives.

Client Support Representative 1996 - 1998

Trained clients on the use of HealthLine's software and worked with clients

calling the support line.

. Traveled to hospitals and managed care facilities in the US and Canada

to install HealthLine software and instruct end users in the use of

medical staff management software and quality assurance software. The

software ran in MS DOS, Windows 95, and Windows NT environment.

. Converted new client data from Excel spreadsheets, Access database

tables, and FoxPro tables into a HealthLine product FoxPro databases

tables using FoxPro.

Performed customer phone support. Diagnosed user problems and program

issues. Created custom reports for end users.

EDUCATION / TRAINING

Bachelor of Arts, Mathematics

Western State College of Colorado

Various programming language courses

University of Colorado

Operations Research Models and Techniques

Army Management Engineering Training Activity

Harris Vos Internals, Automatic Data Processing Systems and Design Database

Harris Computer Systems

Interactive Computer Graphics

University of Massachusetts at Amherst Videotape Instruction Program

Contact this candidate