Data Analyst

DAVID C. GREEN

Fort Myers, Florida

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

SUMMARY

Demonstrated strong analytical skills with ability to manage and lead projects.

Problem solving and team player with proven leadership qualities.

Extremely proficient at VFP, SQL Server, Web Development and System Integration.

Early implementation of Agile Software Development Methodology.

Security Clearance: SECRET, effective 10/13/2011

Owner of Green Management Services, Inc. software consulting business since 1994. SKILLS

Visual FoxPro (21 years)

SQL Server (15 years)

Windows 2003/2008/2012 Server

Visual Basic (16 years)

VB .NET (5 years)

HTML

Cascading Style Sheets (CSS)

Winsock

WinInet

MS Office Web Components

Internet Information Server (IIS)

XML

Simple Mail Transfer Protocol (SMTP)

Crystal Reports

JavaScript

VBScript

Active Server Pages (ASP)

EDUCATION

M.A. Computer Science

1991 BALL STATE UNIVERSITY, Muncie, Indiana

Expert Systems, Artificial Intelligence, Compilers, Numerical Analysis, Case Tools Masters Project: Computer Adaptive Testing a program to interactively administer tests. EMPLOYMENT HISTORY

Consultant 4/1997 to present, part-time support REEDY CREEK IMPROVEMENT DISTRICT, Lake Buena Vista, Florida

Developed and supported several web based FoxPro applications using SQL queries contributing to award winning facility management team at Disney World Resorts. Consultant 5/2014 to 4/2016 THE OHIO STATE UNIVERSITY, Columbus, Ohio Supported and maintained several critical Visual FoxPro programs involved with human resources and payroll until they could be converted. Planned the conversion. Migrated data from FoxPro to MS SQL Server.

DBA 2/2014 to 5/2014 COMMUNITY HEALTH SYSTEMS, Naples Florida Contract by Zycron, Franklin, Tennessee

Temporary position: supported SQL Server transition of over one hundred servers from one data center to another. I emerged as the leader of a 6 person team tasked with evaluating and migrating virtual and physical servers to another data center 500 miles away while supporting and tuning the existing SQL Server operations. Responded to help tickets and monitored transaction logs. Consultant 5/2012 to 12/2013 THE OHIO STATE UNIVERSITY, Columbus, Ohio Supported a Visual FoxPro program to import BAI files, assign PeopleSoft chart fields and export general ledger entries. I reverse engineered an existing application to create rules for the IntelliMatch application to match bank transactions from a BAI file to PeopleSoft chart fields. I created VB.NET web application to send automated requests via email to add items to the university supply catalog. I created a design document for a VB.NET program to replace the existing mail services program. I created a requirements document to convert a Visual FoxPro investment tracking application to a VB.NET application. Consultant 1/2006 to 5/2012 PEREGRINE ENERGY GROUP, Boston, Massachusetts Contract by Green Management Services, Inc., Fort Myers, Florida I developed an Energy Information System to collect, store and report energy/fuel consumption and cost data for Boston Housing Authority, City of Cambridge and other state and federal buildings throughout the Commonwealth of Massachusetts. Tasks: Managed leased Windows Server 2003; Collected, parsed and calculated energy/fuel data; Created web reporting tools using SQL queries. Consultant 3/2005 to 12/2005 ORANGE COUNTY PUBLIC SCHOOLS, Orlando, Florida Developed the Facility Scheduling Program (FSP) using Visual FoxPro with SQL queries to provide an easy- to-use method for OCPS staff to request after-school operation of heating, ventilating and air conditioning systems (HVAC) in any OCPS facility. Supported the system as needed. Analyst 12/1999 to 3/2005 and 3/2005 to 1/2014 (part-time) THE M.A.R.C., Fort Myers, Florida Contract by Green Management Services, Inc., Fort Myers, Florida Network/Database administrator, programmer and web site manager. Tasks: Windows Server 2003 to 2008 migration; Maintained MS SQL Server database of medical information; Maintained and enhanced Visual Basic application; Automation, importing, exporting and reporting using SQL queries; Managed company web site and email.

PUBLICATIONS

Co-Author, Utility Data Web Page Design – An Introduction, Strategic Planning for Energy and the Environment, Vol. 23 No. 2, 2003

Associate Editor, Information Technology for Energy Managers, Fairmont Press 2004 Co-Author, Utility Data Web Page Design – Learning Technologies, Strategic Planning for Energy and the Environment, Vol. 23 No. 4, 2004

Author, Utility Data Web Page Design – Presenting the Data, Strategic Planning for Energy and the Environment, Vol. 24 No. 2, 2004

Associate Editor, Web Based Energy Information and Control Systems, Fairmont Press 2005 Co-Author, Utility Data Web Page Design – Mining the Data, Strategic Planning for Energy and the Environment, Vol. 25 No. 2, 2005

Author, Developing an Energy Information System: Rapid Requirements Analysis, Strategic Planning for Energy and the Environment, Vol. 25 No. 4, 2006

Co-Author, Using the Web for Data Acquisition & Analysis, Performance Contracting Expanding Horizons, Second Edition, Fairmont Press 2006

Associate Editor, Web Based Enterprise Energy & Building Automation Systems, Fairmont Press 2007 Co-Author, Encyclopedia of Energy Engineering and Technology, CRC Press 2007 Associate Editor, Handbook of Energy Information Systems and Control Systems, Fairmont Press 2011 Author, Home Energy Information: Measuring and Managing Energy Consumption in Residential Buildings, Springer Briefs in Energy, 2014

Contact this candidate