Microsoft Visual Basic

JAMES O’BANNON

*** ******** **** **** ************, GA 347-***-**** **************@*****.***

PROFESSIONAL EXPERIENCE

Contractor – RWD Consulting, LLC – (Computer Programmer II)

CDC – (Centers for Disease Control - Atlanta, Georgia)

Division of Congenital and Developmental Disorders (DCDD)

September 2017 - Present

Task 1:

Prepare system documentation to include:

Relational Schema (Database diagram)

Entity-Relational Schema (Database dependency diagram)

Written documentation, in an MS Word format, on 368 tables and 698 stored procedures describing; (exact table structure, what stored procedure are doing to data, and how and what order these stored procedures are called to perform a specific application function by the web pages.

Documentation of 255 web pages, including their function and the stored procedures and other functions that they call and their purpose.

Task 2:

Provide an electronic copy of all system documentation outlined in Task # 1 into the provided shared drive on the CDC Network; as well as a 3-hole punched hard copy of the same.

Task 3:

Participate in a regular review sessions with developers and NCBDDD IT Lead to review documentation for accuracy and knowledge transfer.

Electronically submit monthly report to RWD Corporate Operations by 1st of each month

Microsoft Visual Studio 2017

Microsoft SQL Server 2012 – (T-SQL)

Microsoft C#.NET

Microsoft ASP.NET

JavaScript

PROFESSIONAL EXPERIENCE (Continued)

Software Developer/Engineer

NYC Health & Hospitals Corporation

Quality Management – Regulatory Affairs

November 1998 – February 2017 - (18 years)

Agile development practices with a focus on writing thorough and testable code and support, understanding business requirements for various projects, and design and develop application modules based on those requirements. Collaborated in the development of in-house projects for clinical and financial solutions, managing project life cycle activities in developing desktop and/or web applications. Strong oral and communication skills, establishing methods for collecting and analyzing large amounts of data, also providing data analytics from Data Warehouse using 3rd party tools and resources and building analytic data assets using Microsoft Excel, SQL Server and Microsoft Access.

Microsoft Visual Studio 2013 .NET

.NET MVC Architectures/Framework

.NET Framework Programming (3.5 – 4.0)

Data structures and data modeling

Oracle 10g (PL/SQL)

Microsoft SQL Server 2012 R2 (T-SQL)

Microsoft Access (SQL)

Microsoft C# .NET

Microsoft Visual Basic .NET

Microsoft ASP.NET

Microsoft Excel (VBA Macros – Formulas)

JavaScript - SOAP – XML – JSON

JavaScript API For Microsoft Office

VBA – Visual Basic For Applications – (Microsoft Excel Macros & Formulas)

VBA - Visual Basic For Applications – (Microsoft Access)

VBA – Visual Basic For Applications – (Microsoft Word)

ADO.Net – ODBC – DAO – ADO

Develop GUI interfaces using Microsoft Excel

PROFESSIONAL EXPERIENCE (Continued)

IT Consultant – Contractor – (Part Time)

SUNY Downstate University Hospital of Brooklyn

Quality Management - Clinical Abstract Department

February 2003 – October 2004 - (1 year and 8 months)

Project Summary

Performance Indicators Clinical Abstract – (PICA)

Tracking and trending 725 indicators selected by a Quality Assurance committee. Indicators access performance of clinicians in specific areas of patient care and documentation of the medical chart. The PICA System allows Quality Management to collect thousands of samples on a monthly basis.

Collaborated in the development of in-house project for a clinical chart review system, managing project activities in development of desktop application. Strong oral and communication skills, utilizing Agile Development Practices with a focus on writing thorough and testable code and support, understanding business requirements for required project, and design and develop application modules based on those requirements.

Microsoft Visual Studio .NET 2002

Microsoft SQL Server 2000(T-SQL)

Microsoft Access (SQL)

Microsoft C++ .NET

Microsoft Visual Basic .NET

.NET Framework Programming (2.0)

VBA – Visual Basic For Applications (Microsoft Access)

VBA – Visual Basic For Applications (Microsoft Excel Macros & Formulas)

ADO.NET – ADO – DAO

Data structures and data modeling

Front end development

Create VBA programs and stored procedures to implement business requirements

Develop GUI interfaces using Microsoft Excel

PROFESSIONAL EXPERIENCE (Continued)

Per Diem – Temporary

CTI Personnel Agency

January 1993 – November 1998

Working long and short-term assignments, experience in designing, developing, testing and implementing a variety of IT applications in a number of different development, operational, and industry environments. Proven ability to perform as a technical leader, training and directing, developing IT applications for client organizations. Resolute problem solver with strong communication, interpersonal and leadership skills.

Created reports, cubes, scheduled processes, toolset to the users in order to create meaningful and accurate reports, graphs, and spreadsheets to support the business.

Borland C programming and UNIX

Microsoft C++

dBase II, III, IV

Visual Basic

VBA

Sybase (SQL)

JCL (Job Control Language)

COBOL

IBM/COGNOS

Assembly Language

Pascal

SQL Server 6.5 (T-SQL)

Visual Prolog

Paradox DB

Lotus 123 Macros

MS Excel Macros

SKILL SETS

Microsoft Visual C# .NET

.NET Framework 2.0

Microsoft Visual Basic .NET

.NET Framework 3.5

ASP.NET 4.0

.NET Framework 4.0

Microsoft SQL Server 7.0 (T-SQL)

Microsoft Windows 2000

Microsoft SQL Server 2000(T-SQL)

Microsoft Windows XP

Microsoft SQL Server 2008 R2 (T-SQL)

Microsoft Windows 7

Oracle PL/SQL (9i - 10g)

Microsoft Visual Studio 2002 .NET

Microsoft Access (SQL)

Microsoft Visual Studio 2005 .NET

(VBA) Visual Basic For Applications

Microsoft Visual Studio 2008 .NET

dBase II, III, IV

Microsoft Visual Studio 2010 .NET

COBOL

UNIX Operating Systems (versions 5 & 7)

COBOL/COGNOS

Novell Intranet Ware Networks

Assembly Language

Windows NT Operating System

PASCAL

Microsoft Office Suite ( 95, 2000)

JCL (Job Control Language)

Corel Office Suite

Sybase (SQL)

UNIX MultiMate and Multiplan

Microsoft SQL Server 6.5 (T-SQL)

LOTUS 1-2-3

Microsoft Visual Prolog

Paradox

Microsoft Visual C++

Wang Word Processing

Microsoft Visual Basic 6.0

Microsoft Visual Studio 6.0

Microsoft Access (SQL)

Typing 90 words per minute

EDUCATION / PROFESSIONAL DEVELOPMENT

Current Studies and Goals

Estimated completion date December 2017

Microsoft MCAD/MCSD Certifications

C# .NET and Visual Basic .NET

T.C.S. - New York, New York

May 2006 – November 2006

Oracle 9i & 10g Database Admin

Certification Prep Studies

Baruch College - New York, New York

April 2000 – September 2000

Continuing Education Studies

SQL Server 2000 Software Development

Baruch College - New York, New York

January 1986 – April 1990

40 Credits Computer Science

Chanute Air Force Base – Rantoul, Illinois

Blytheville, Air Force Base – Blytheville, Arkansas

September 1981 – September 1983

CDC Program

Applied Sciences and Computer Science

Contact this candidate