Professional Summary:

Over * years experience in database programming in healthcare industry utilizing MS Access, Excel, SQL, Crystal Report, and VBA.

Extensive experience in relational data modeling and dimensional data modeling.

Improving performance of Queries, Procedures, Functions, and Procedures.

Provided ETL support for Pharmacy Data Transactions, which entailed collecting data, converting data, re-formatting data, and then transmitting data on monthly bases.

Provided VBA code trouble shooting and database trouble shooting skills in support of developing new Database Applications and supporting the maintenance of existing Database Applications.

Developed several data reports for management and support personnel, both graphical and tabular, for data tracking, data trends, and analysis.

Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.

Technical Skills:

RDMS

MS Access, Oracle 9i, SQL Server 2000, Excel

Business Skills

Definition Requirements, Business Process Analysis, Project Management

Programming

SQL, VBA, Excel, Crystal Reports XI, Cognos

Operating Systems

Windows 2000/XP/98

Tools

Text editor, MS Project, MS Office 2003

Professional Experience:

EDS, Sandston, Va (March 2015-Dec 2019)

Off lot Driver: Drove Avis rental cars to local markets in Richmond.

Hertz Local Edition, Midlothian, VA (Aug – Jan 2013)(Part Time)

Transporter: Drive rental cars to various locations in Richmond area.

Groome Tansportation, Richmond, VA (Feb 2012-June 2012)

Shuttle Driver: Drove the Richmond to Dulles airport shuttle van.

Kelly Services., Richmond, VA (Feb 2009-Feb 2009) (Contract Labor)

Lab Tech: Supported the sampling and testing in a paper lamination production line. Also did some support work on a production database at the plant.

Teksystems, Inc., Richmond, VA (Oct 2008) (Contract Labor)

Data Tech: Supported the gathering of information for Asset Management of PCs and other peripheral hardware for the State of Virginia.

Care 1st Health Plan of Arizona, Phoenix, Arizona (Apr 2005-Nov 2006)

IT Programmer: Provide Database programming support for health data reporting and analysis using MS Access, Crystal Reports, and Excel spread sheets.

Responsibilities:

Worked with ETL to create source to target mappings.

Worked with DBA to create the physical model and tables.

Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

Worked on rationalizing the requirements across multiple product lines.

Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.

Environment: Window XP client server, SQL server, Oracle, MS Access, Crystal Reports

GoDaddys, Scottsdale, Arizona, (Nov 2004-Feb 2005) (Contract Labor)

Technical and Sales Support Rep: Provided first level technical support, in a call center environment, for Domain Name registration and Web hosting services.

Responsibilities:

Taking customer calls in a Call Center and setting new accounts.

Resolving customer concerns on old accounts.

Assisting customer in setting up email accounts, domain names, and website building software.

Environment: Window XP client server, Web and Domain Names

Voices for Working Families, Phoenix, Arizona, (Sept 2004-Nov2004) (Contract Labor)

IT Support Specialist: Performed IT support duties in an office environment in support of voter registration drive efforts being done in the Hispanic community.

Responsibilities:

Created Access databases and Excel Spreadsheets for inputting voter registration data.

Created daily reports in MS Access and Excel for voter registration data.

Provided technical support for office equipment, including installation.

Environment: Window 2000, MS Access, Excel, Word

PacifiCare Health Systems, Phoenix, Arizona, (Mar 1999-Dec 2003)

Health Data Analyst: Maintained and Developed data structures for reporting and analysis, using MS Access, SQL, and Excel.

Responsibilities:

Built relational databases in MS Access.

Created Excel Spread sheets and Graphs.

Developed and launched numerous database applications in MS Access and Excel, from tracking and reporting daily utilization and creating customer mailings, to the importation of raw data further processing.

Worked with DBA to create the physical model and tables.

Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

Worked on rationalizing the requirements across multiple product lines.

Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.

Environment: Windows 2000, MS Access, Oracle, Excel, Word, Cognos

Crager Industries, Phoenix, Arizona (Jan 1999-Feb 1999) (Contract Labor)

System/Support Analyst: Performed IT support functions in the Office.

Responsibilities:

Supported all PC, hardware, and software, from printer troubleshooting to software installation and network administration.

Environment: Windows 98 client/server, MS Access

Lutheran Healthcare Network, Mesa, Arizona, (Aug 1998-Dec 1998) (Contract Labor) Programmer Analyst: Maintained Membership Eligibility database using MS Access and VBA.

Responsibilities:

Developed a Dental Payment tracking and reporting database using MS Access.

Troubleshot and cleaned up Membership database.

Environment: Windows 98 client/server, MS Access 97

Education:

BS Mechanical Engineering, University of Massachusetts, Amherst,

Massachusetts, Class of 1982.

Continuing Education:

MCSD Training, Ikon Office Solutions, Phoenix, Arizona, 1997.

Ross Black

3813 Chamberlayne Ave.

Richmond, VA 23227

Home Phone: 804-***-****

Contact this candidate