User profile picture

John Newman

John Newman

Software Engineer at Atlas Copco US (Auburn Hills, Michigan)

Systems/Process Engineering

Summary

I have the skill sets of: 1) SQL Database Programmer and database administration 2) Information Security Officer 3) Many years of experience in the health care and 1 1/2 in manufacturing 4) Effective, personable communication

Experience

Software Engineer
Atlas Copco US
November 2014 - May 2016 (1 years 6 months) Auburn Hills, Michigan
Database Development, Optimization, System Engineering
Skills: Installation of complex database software, Optimization, database maintenance scripting
Reporting and Applications Support Specialist
Training and Treatment Innovations, June 2012
June 2012 - October 2014 (2 years 4 months) Oxford, MI
SSRS reporting, database server application support, SSIS warehouse table staging and loading
Skills: SQL Programming, SQL Server 2008 Reporting Services, SSIS transformations, Database Application Support, Network Server Application installations, Please see below for additional skills.
Information Security Officer and IT Director
Community Network Services
September 2004 - April 2012 (7 years 7 months) Farmington Hills, Michigan
• Analyzed data flow for the company internally and with customers. • Administering of SQL Server 2008 databases. • Extracted data from OLAP db to move into BI warehouse structure. • Obtained security analysis including WAN, LAN and wireless • Supervised upgrade of network to high-bandwidth MPLS
Skills: Team Work - Expert, Verbal Communication on the job - Expert, Technical Writing - Expert, IT Systems Analysis - Expert, Effective IT Director, SQL Database Programming - Expert, IT Security Officer
Senior Programmer
Macomb Oakland Regional Center
June 2000 - September 2004 (4 years 3 months) Clinton Township, MI
• Programmed in Visual Basic and complex Structured Query Language with SQL Server databases; utilized stored procedures and triggers to automate reporting and cascading update of tables and forms. • Some database administration.
Skills: SQL Database Programming - Expert, Health Care Data Services - Billing and Reporting - Expert, Data Collection Methodology - Expert, Handling all programming cases, normalization of databases, building user interfaces to read and wri, Verbal Communication on the job - Expert, Team Work - Expert

Education

University of Michigan
Bachelor's Degree
Psychology, German
1974 - 1978
Lawrence Technological University
Bachelor's Degree
Database Programming
1993 - 2005
Wayne State University
Master's Degree
1978 - 1979

Certifications

Master's Social Worker Clinical and Macro License
StateOfMichiganDeptofLicensingandRegulatoryAffairs
June 1982
Board of Social Work, Renewed 4/30/2015. Valid to 4/30/2018.

Professional Memberships/Awards

  • Professional Association for SQL Server, Detroit branch:SPID

Interests

  • Progressing from intermediate to advanced spanish, Chinese Wushu, and amateur astronomy
  • web development, and Business Intelligence application development.

Skills

  • Effective IT Director (7 years )
  • Effective, personable communication
  • Excellent written and oral technical communication skills
  • Team Work - Expert (15 years )
  • Verbal Communication on the job - Expert
  • Technical Writing - Expert
  • IT Systems Analysis - Expert
  • SQL Database Programming - Expert
  • Health Care Data Services - Billing and Reporting - Expert
  • Data Collection Methodology - Expert
  • Covering all mathematical possibilities that must be considered during computer programming to handl
  • Working effectively with clients; active listening and person-centered support
  • Handling all programming cases, normalization of databases, building user interfaces to read and wri (4 years )
  • C++ Object-oriented design and programming (4 years )
  • VB, Oracle (3 years )
  • SQL Programming, SQL Server 2008 Reporting Services
  • Speak Spanish (8 years )
  • Skilled in work with individuals suffering from co-occurring conditions of Substance Use and MI
  • Skilled in work with elderly; consequences of loss, physical disability, impact on marriages
  • Anger Management Groups
  • Quality service and crisis intervention for the chronically mentally ill.
  • Supervision of care for clients suffering from servere mental illness.
  • Work with families of those suffering from mental illness
  • Coordination of care with interdisciplinary team and other community service providers.
  • Database Application Support
  • Database Application Support, Network Server Application installations
  • additional skills
  • Please see below for additional skills.
  • Many years of experience in the health care, as provider and data reporter.
  • Installation of complex database software, Optimization, database enhancement
  • SQL Programming, SQL Server 2008 Reporting Services, SSIS transformations
  • Installation of complex database software, Optimization, database maintenance scripting
  • IT Security Officer