Sql Server Visual Basic

Allan Witham

Home phone: 214-***-****

Cell phone: 469-***-****

**** * **** **. *** 303

Dallas, TX 75219

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

Database Developer/Data Analyst

Professional Summary:

. SQL Server versions 2005, 2008, 2010 querying, T-SQL, views, jobs

. Created custom tools to automate current processes using T-SQL, SSRS,

SSIS

. Created SSRS performance reports and mass mailing subscriptions

. Created C# application to track Medicare claims and gaps in care

. Created and maintained Access Database to store, organize and retrieve

confidential documents and provide audit trail

. Created and maintained Access Database for Inventory tracking and

control

. Acted as point of contact and acting supervisor for Records Department

. Consulted and collaborated on software and hardware conversion issues,

to improve process and workflow

. Provided internal hardware and software troubleshooting and technical

support

. Created training manuals and technical documentation

. Performed Data mining and reconciliation of databases, using T-SQL,

Excel, Access, and other tools

Technical Summary:

Databases: Visual Basic (multiple versions), C#, Access, VBA, SQL

Server 2005, 2008, 2010

Software: Visual Studio, SSRS, SSIS, SSMS, MS Office (multiple

versions), Visual Basic (3, 6, .Net), MySQL

Other: Network configuration and troubleshooting, general technical

support for hardware and software issues

Experience:

January 2013 to present:

. Short term contracts, including JC Penny, SQL Server and MySQL

development (queries and stored procedures) and data analysis -

performance and marketing trend databases

February 2011 to January 2013:

Developer/Data Analyst

Censeohealth

. SSRS reporting, generating performance, financial and trending reports

and contact letters from SQL Server backend (2005,2008,2010)

. Data Mining and Analysis of SQL Server databases for multiple projects

using SQL queries and stored procedures - health care claim analysis,

performance statistics, financial reporting

. Support of production Access databases, and reconciling with SQL

databases

. VB development and support (.Net, VB6) for user front end databases

. SSIS packages - file import and export, SQL querying, external file

manipulation

. C# development and support (.Net) for user front end databases and

data manipulation tools

. Automating and troubleshooting current processes

. Hardware and software support

April 2009 to December 2010:

CTI Data Analyst

Citigroup

. analyzing, troubleshooting and reconciling data from Excel and

proprietary databases, using SQL(2008) queries and stored procedures,

SSRS, data mining, and cross-application development tools

. Visual Basic(VB6), VBA development and support - file and ETL

utilities

. Created documentation to analyze, audit and improve operations

. Automating and troubleshooting workflow and performance

March 2006 to April 2009

Consultant

. Private consultant and contract worker for hardware and software

issues while in school (ATI) - Independent and short term assignments

- Visual Basic, MySQL, SQL Server (queries and stored procedures),

SSRS

October 2005 to March 2006

Telvista TechSupport Agent

. Provided phone technical support for Verizon DSL customers

. TCP/IP and router configuration and troubleshooting, OS

optimization

September 2002 to September 2005

Texas Dept. of Family & Protective Services Administrative

Technician

. Created and maintained file inventory database for Records

department(Visual Basic and VBA development and coding, SQL)

. Acted as consultant and tech support for design, upgrade and

maintenance of database.

. Data Entry (MS Access, MS Excel, proprietary database)

. HR Clerical Support/Administrative Support

. Acting supervisor when supervisor unavailable

Temp Work 9/98-9/02

. Database Development (MS Access/SQL/VBA/Visual Basic)

. Data Entry

. Accounting/Clerical/Administrative support

. AP/AR

Education:

North Shore Community College - 1988 Associate of the Arts

Northeastern University - 1989 Cobol Programming Classes

ATI Career Training Institute - Completion May 2008

Technical Diploma - A+ training, Hardware and Software

troubleshooting, Microsoft Training, Network configuration

Contact this candidate