MICHAEL W. CONTOIS
Summary: Seasoned professional able to apply business analyst concepts to generate business work flows, data flows, data attributes and data management solutions to integrate with technology so as to meet both internal and external customer reporting needs and requirements.
Windows OS; Microsoft Office 2013; OpenText/HP/Cardiff Teleform v.9.1; MS SQL Server 2014; T-SQL; SSRS; Crystal Reports XI; Visio 2010; MS Publisher; Adobe Acrobat XI; Adobe Photoshop CS2, Microsoft FrontPage 2003, Dreamweaver.
Experience using RackForms software for PHP web page development and deployment using SQL Server 2014.
Business and Data Analyst functions.
The GEO Group Inc. Boca Raton, FL. April 2017 – September 2017
Data Systems Manager
Acquired Community Education Centers, prior employer. Continued duties during transition of company assets.
SQL server database development and implementation. SQL; Stored Procedures, Views, Triggers
Business Objects Crystal Reports and MS SQL Server Reporting Services.
Community Education Centers 290 Donald Lynch Blvd. Suite 301, Marlboro, MA April 2007 – April 2017
Data Systems Manager
Developed database driven solutions to meet data tracking and quality assurance measures.
Developed an Incident Reporting System
Gathered user functional requirements to develop business work flows and data flows for a web based database management solution that provided managerial oversight and control of incidents occurring in facility locations.
CiviGenics, Inc. 100 Locke Drive, Marlboro, MA July 2000 – April 2007
Data Systems Manager
Developed database driven solutions to meet data tracking, quality assurance, and research outcome measures.
Developed a paper data collection system using OCR scan forms (Teleforms) that collected data based on work and business flows, later used as the foundation meeting business analyst requirements to build a web-based XML and .NET web application by our web developer for a State government customer.
Treatment Outcome Measures Data Collection and Reporting
Developed a system where psychosocial surveys and client demographics are gathered using OCR scan forms and processed to a SQL Server database.
Developed stored procedures to score and export outcomes to a Business Objects Crystal Reports report for use as part of clinical treatment planning and efficacy outcome research.
Wrote system documentation and user training manuals.
Supported data collection and analyses for data analysts at remote sites performing similar requirements.
Publication: Assessing Offender Needs and Performance for Planning and Monitoring Criminal Justice Drug Treatment. Criminal Justice and Behavior (9)2007; vol. 34: pp. 1179 – 1187.
Snelling Personnel Services, Worcester MA 01604 March 2000 – July 2000
Data System Coordinator: Temporary to Hire at CiviGenics, Inc.
Moved pre-existing Access 1999 database to a SQL Server 8 platform.
Managed data system operations and reporting for 68 remote sites.
Authored data collection protocols for in-house and remote operations.
Trained end users.
Supervised data entry personnel.
Wrote T-SQL queries to meet quality assurance requirements.
Utilized automated report writing tools to develop and report data quality issues and outcome reports.
Department of Forestry and Wildlife, University of Massachusetts, Amherst, MA 01002 July 1998 - November 1998
Biological Field Technician
Department of Psychology, University of Massachusetts, Amherst, MA 01002 February 1996 - November 1998
Publication: Ciliary neurotrophic factor receptor alpha in spinal motoneurons is regulated by gonadal hormones.
J. Neurosci., 18(2): 8720-8729.
Missouri Ozark Forest Ecosystem Project, University of Missouri-Columbia, MO, in association with the Missouri Department of Conservation, May 1997-August 1997
Field Biological Technician – Ornithologist
Metropolitan College, Computer Science Department, Commonwealth Ave., Boston, MA 02215
Master Degree Program in Computer Information Systems (MSCIS) – Completed March 2012.
Degree Specialization in Business Intelligence and Database Management - Overall GPA 3.71
Pennsylvania State University
College of Earth and Mineral Sciences, Department of Geography, University Park, PA 16802
Certification Program in Geographic Information Systems- June 2000; GPA 4.0
GIS software programs: Intergraph's GeoMedia and Smart Sketch; ThinkSpace Inc.'s MFWorks
University of Massachusetts
College of Food and Natural Resources, Department of Forestry and Wildlife, Amherst, MA 01002
B.S., Wildlife and Fisheries Conservation- May 1998. GPA 3.63. Dean’s List five semesters.
Project Wild Certified by the Massachusetts Division of Fisheries and Wildlife.
Red Card Certified for Wildland Fire Control by the Department of the Interior; May 1997.
ACTIVITIES, AWARDS AND INTERESTS
Member of The Golden Key Honor Society at the University of Massachusetts and Xi Sigma Phi, the Honor Society for natural resource professionals.
Formerly involved with the Student Chapter of The Wildlife Society at the University of Massachusetts.
Recipient of the 1998 Outstanding Senior in Wildlife Conservation Award, presented by the Department of Forestry and Wildlife at the University of Massachusetts-Amherst, April 1998, representing departmental involvement and scholastic achievement.
Previously managed and developed two web sites, one for a local Indian Tribe, the other personal.
References are available upon request.