Overview
Work History
Education
Skills
Relevant Training
Timeline
Generic

Charles Galea

Riverview,MI

Overview

28
28
years of professional experience

Work History

Systems Analyst

Universal System Technologies
12.2010 - 10.2012
  • Assumed responsibility for several MS Access databases used by many departments at DFD headquarters
  • Improved ability to process good mileage reimbursement data while data in error was also corrected and resubmitted for payment
  • Previously hand calculations were used to combine two months of data
  • This method resulted in employees having to wait one month for their reimbursement checks to be processed
  • The new process eliminated delays in reimbursement checks by 50%
  • Completed 6 month project to bring seniority MS Access database up to date after being lapse for two years
  • This required gaining a thorough understanding of the database schema and entering the data directly into the database
  • The user community was very happy this project was completed in a high quality manner.

Systems Analyst

FORD MOTOR COMPANY
11.2001 - 07.2008
  • Project Manager for integration of daily vehicle inspection system into plant daily processes
  • Directed user meetings to aid in configuration of software to plant specific needs
  • Trained all plant employees (hourly, salary) in system use
  • Became self-taught in web-based technologies (ASP, HTML, SQL, JavaScript, SQL Server and Oracle) used to produce plant summary report that gave management a global picture of plant compliance with corporate requirements
  • Project Manager & MS Access VBA Expert for launch of general trades tracking system/Maximo
  • Trained hourly and salary employees on system use/value
  • Not long after system was launched it became apparent that there was a gap between user needs and system abilities
  • Bridged gap by designing and developing MS Access VBA reporting system to enable reporting by area, department and start/end dates
  • Initiated and ran plant Maximo user forum which shared knowledge of Maximo plant wide
  • Routinely created queries in MS Access to provide data needed by various departments
  • Project Manager & MS Access VBA Expert for Gage Control System (GCS)
  • GCS provided the ability to schedule the following tests in a repeated fashion: Repeatability and Reproducibility (R&R), Visual Inspections (Surveillance), and Go/No Go (Verification)
  • Replaced error filled reports containing counts of when tests were due versus done by month and department with new high quality version based on MS Access VBA
  • Improved relationship between user community and IT dept by 300%
  • Project Manager & MS Access VBA Expert that modified existing MS Access VBA utility to include First Time Thru (FTT) graphs/reports
  • This project was completed under which intense pressure from a plant statistical analyst who wanted quick completion and high quality
  • Reports were used weekly in Ford Production System hourly meetings to study manufacturing problem areas within the plant
  • Organized, launched, debugged and supported integration of Synchronous Material Replenishment Trigger (SMART) System used as the backbone of daily just-in-time processes
  • Managed interdepartmental cooperation of Central Maintenance, MP&L and Plant IT to ensure a smooth adaptation and high level of quality within deadlines and staying on course
  • Operated in a highly independent and goal orientated fashion to deliver high confidence level at time of launch
  • System used both wireless and database technologies
  • Project Manager for upgrade of Common Security Component/password system used by all plant floor applications
  • Proactively took initiative to update all 200 user database records to reflect new security structure
  • Trained users in change from application only password, to utilizing Windows NT password for application login
  • Executed and coordinated use of Compare Sync Tool to remove obsolete and outdated CSI user list
  • At completion of launch, zero defects were found and a quality product was well received
  • DEFTP was selected as first plant to start and complete launch
  • Project Manager for wireless rack shipment validation system with hand held computers and bar code scanners
  • Procured and coordinated installation of 108.11b wireless access points
  • Scheduled and tested installation of database and software on web server
  • Primary point of contact for user help and issues.

Product Design Engineer

FORD MOTOR COMPANY
02.1998 - 10.2001
  • Completed maintenance project to split Ford and Visteon software release process
  • This required coordination and input from users in Spain, Brazil, England, and United States
  • The project was completed on time without defects in quality in VAX VMS environment
  • Maintained and enhanced Powertrain Control Module (PCM) Calibration Editor, File Comparator and Document system
  • Utilized C and PL/1 in VAX VMS environment.

Product Design Engineer

FORD MOTOR COMPANY
09.1996 - 02.1998
  • Designed and developed system to convert Ford proprietary variable file to generic MS Access database utilizing Visual C++, Visual Studio and SQL
  • This tool was to be used by engineers as method to convert calibration file to generic format required by new real-time calibration editing software
  • Designed and developed Calibration File Translator to update PCM software and calibration with incremental changes utilizing Visual Basic.

Product Design Engineer

FORD MOTOR COMPANY
09.1995 - 08.1996
  • UNIX System Administrator
  • Answered user questions concerning UNIX operating system
  • Upgraded DEC ULTRIX operating system to current version
  • Procured purchase of DEC Alpha Computer for department needs.

Electronic Computer Programmer

FORD MOTOR COMPANY
05.1990 - 08.1995
  • Project Leader for VAX VMS based system during both development and maintenance phases of project
  • Used inter-language communication between FORTRAN and PL/1 languages to modify portions of Tester II system that interact with the calibration editing system in VAX VMS environment
  • Completed variety of maintenance projects in C, FORTRAN and PL/1.

Programmer/Analyst

Compuware Corporation
10.1985 - 05.1990
  • Gathered user requirements, created functional specifications, completed design and development of a new plotting package which compared results of real-time tests to that of simulation tests using DEC GKS with VMS FORTRAN
  • Graphs were capable of having 6 Y-axis and printing on a variety of printers, including laser and color plotters
  • This system improved user efficiency by 50%
  • CASE tools were used extensively to create a high quality project that matched user needs and requirements to a feature rich application
  • Developed software tools for VAX/VMS environment used in the verification of Electronic Engine Control (EEC) Software for EEC-IV processor for Ford Motor Company
  • Utilized Structured Analysis and Design Methodologies during software development process
  • Aided in the design and development of FORTRAN based simulation of real-time test environment of Electronic Engine Control Software
  • Project replaced previous software that required the use of a proprietary language and debugging ability
  • Project resulted in using FORTRAN as standard language and VMS debugger
  • Engineer’s efficiency increased 75% upon conversion to this tool
  • Supported department bug tracking system based on DEC RDB
  • Routinely added departments and new software applications using SQL.

Software Engineer

GTE Valeron Corporation
05.1985 - 10.1985
  • Assisted in the development and maintenance of tooling analysis system implemented in FORTRAN for DEC PRO 350 and VAX VMS system, used to assist tooling engineers in gaining optimum use and performance of machining operations

CO-OP Programmer

ANR Pipeline Company
05.1984 - 08.1984
  • Performed system updates of corporate payroll system in COBOL on IBM 3033
  • Recorded employee work hours, deductions and generated bi-weekly paychecks
  • Updates on the system were granted as requested by corporate payroll department
  • Rewrote report portions of pension fund monitoring system using PL/1 on IBM 3033, which was developed to aid the personnel department in the analysis of investments of corporate pension fund.

Education

M.S. in Information Systems & Technology -

University of Michigan
Dearborn, MI
01.2004

B.A. in Computer Science -

Wayne State University
Detroit, MI
01.1985

Skills

  • Visual Basic
  • Visual C
  • C
  • PLI
  • FORTRAN
  • MS Access VBA
  • ASP
  • HTML
  • SQL
  • Oracle
  • SQL Server
  • PHP
  • MAXIMO
  • Visual Studio 2008
  • JavaScript
  • WIN95
  • WIN98
  • WIN2000
  • WINXP
  • DEC VAX/OpenVMS
  • ULTRIX
  • IBM PC
  • DEC ALPHA
  • CMS/MMS
  • DEC GKS
  • DCL
  • RS1
  • DOS

Relevant Training

  • Henry Ford Community College, Web/Internet Technologies, Web database development with PHP
  • Henry Ford Community College, Introduction to Visual Basic.net, Advanced Visual Basic.net database programming

Timeline

Systems Analyst

Universal System Technologies
12.2010 - 10.2012

Systems Analyst

FORD MOTOR COMPANY
11.2001 - 07.2008

Product Design Engineer

FORD MOTOR COMPANY
02.1998 - 10.2001

Product Design Engineer

FORD MOTOR COMPANY
09.1996 - 02.1998

Product Design Engineer

FORD MOTOR COMPANY
09.1995 - 08.1996

Electronic Computer Programmer

FORD MOTOR COMPANY
05.1990 - 08.1995

Programmer/Analyst

Compuware Corporation
10.1985 - 05.1990

Software Engineer

GTE Valeron Corporation
05.1985 - 10.1985

CO-OP Programmer

ANR Pipeline Company
05.1984 - 08.1984

M.S. in Information Systems & Technology -

University of Michigan

B.A. in Computer Science -

Wayne State University

Similar Profiles

CREATE PROFILE
Charles Galea