Project Manager Management
Resume:
David Heathcote
Northville, MI 48167
********@*****.***
PROFESSIONAL SUMMARY
** ***** ** ********** ** the Information Technology Industry as an
Architect, Project Leader, Business Analyst, and Systems Programmer in the
retail, automotive and real estate industries. Prior positions have
included the following job functions:
Data Analysis Project Management
Business Analysis Shell Scripts Programming
Business Process Reengineering Structured Programming
Change Management System Design/Analysis
Data Dictionary Development System Development
Data Modeling System Implementation
Data Flow Diagrams Design System Integration
Database Design/Analysis System Maintenance
DB2 Database Development System Requirements
Defect Reporting System Testing
Design Specifications UNIX Systems
Functional Modeling Technical Writing
Informix Database Development Test Case Design
Oracle Database Development Test Case Execution
Presentations to management Infrastructure BOM
PROFESSIONAL EXPERIENCE
Fujitsu Consulting August 2008 - November 2009
Project Manager in Infrastructure Architecture assigned to Ford Motor
Company.
. Technical Reviews of Infrastructure blueprints with Subject Matter
Experts for implementation.
. Developed Bills of Material hardware and middleware for Web Servers,
Application Servers and Database Servers.
. Review Server designs for 145 applications for Project Swift which is
a "Clone and Go" project to transfer the data systems from Ford Motor
Company to Tata Motors in India for LandRover and Jaguar.
. Responsible to interview and select Technical Talent for Project
Swift.
. Localizing Ford code with Jaguar Land Rover equivalents. Rexx, Perl
and Java.
. Providing Change Management.
Ajilon Consulting October 2005 - July 2008
Data Architect for Financials at the Speed of Thought (F@ST) June 2006 -
July 2008
assigned to Ford Motor Company
. Mastered global enterprise financial database configuration process
for the Ford F@ST project.
. Worked with Oracle external tables.
. Developed data models for geographical rollout of F@ST.
. Material cost management, TPDB, ODS and data warehouse.
. Design database tables for Oracle and Teradata in transaction
processing, operational data store and data warehousing sytems.
. Designed and modeled database tables for various marketing and sales
systems and for the F@ST Financial System.
. Recognized for efforts in F@ST Geo rollout.
Environment: Windows XP Professional UNIX, MS Outlook, SQL, C, Oracle
Designer
Data Architect Marketing Sales and Service Systems October 2005 - May 2006
. Pilot for database design and implementation process.
. Created data model in Designer for Global OASIS Online Automotive
Service Information System.
. Organized data model changes for British Brands Systems Suite.
. Maintained 500-plus data models for Teradata, DB2, Oracle and MS SQL
Server.
Environment: Oracle Designer, DFD, eROOM, eTracker, MS Word, MS Excel, MS
Outlook, Oracle, DB2, NCR/Teradata, SQL Server
Heathcote Rental Properties / Internet Real Estate, Inc. June 2004 - Oct
2005
Property Manager / Realtor:
. Responsible for the client management, single family residences
maintenance management and renovation project management for
residential properties.
. Experience with asset procurement, asset management, vendor
management, Accounts Receivables, General Ledger, improvement project
management including historic homes renovations.
. Responsible for income tax preparation, financing, and mortgaging
residential properties. Proficient in Quicken TurboTax and Quicken
Rental Properties.
. Created and conducted marketing strategies and conducted open houses,
Chamber of Commerce shows and seen advertising on TV for Pulte Homes.
Compuware Corporation Headquarters November 1994 - June 2004
In-house Consultant November 2003 - June 2004
. Developed project proposals for new projects for Compuware
. Computer based and Instructor led training.
Project Leader / Data Architect November 2001 - November 2003
assigned to Ford Motor Company
. Led a team of 11 developers who created detailed mainframe program
specifications and COBOL code for the development of 55 mainframe DB2
stored procedures and 22 mainframe batch programs.
. Developed new recall process decomposition.
. Implemented team collaboration software eROOM and MS FrontPage.
. Wrote functional specifications.
. Enforced System Development Life Cycle (SDLC) and Technical Inspection
Processes for all program specification and development.
. Led ETL Extract Transform and Load team; DB2 to Teradata.
. Maintained DB2 database changes and program issues in eTracker.
. Data modeling and relational analysis using Oracle Designer.
. Used ERwin Case Tool for data modeling.
. Created system test and tracked system defects in Mercury
TestDirector.
. Supported multiple projects concurrently.
. During Firestone Tire Replacement Program demonstrated the ability to
work as a team member with all levels of management.
. Excellent verbal, listening and written communication skills.
. Team Leader over 11 programmers.
. Subject Matter Expert for Ford Recall Systems.
. Database change representative.
. Customer Liaison.
Environment: MS Project, Oracle Designer, ERWin, ABC Flowchart, DFD, eROOM,
eTracker, SPUFI, MS Word, MS Excel, MS Outlook, Mercury Test
Director, WebSphere, Business Objects, J2EE, Java, NCR/Teradata,
ETL, BTEQ/MLOAD/FASTLOAD, COBOL, JCL, TSO, MS FrontPage
Business Analyst October 1998 - November 2001
assigned to Ford Motor Company
. Conducted a Warranty Recall RAPID (Rapid Approach to problem
identification) requirements gathering.
. Wrote program specifications for Web and mainframe development.
. Launched and maintained a Web/mainframe campaign targeting system.
. Implemented Teradata Business Objects ad hoc reporting system.
. Supported the Firestone Tire Replacement Program.
. Worked with budget requirements for system improvements.
. Created 552 ACR Application Control Document, which spells out a
Systems Security, Disaster Recovery, Backup/Recovery, Business
Resumption Plans, and Upstream and Downstream systems.
. Data modeling and relational analysis using Oracle Designer.
. Used ERwin Case Tool for data modeling.
. Designed targeting database in both DB2 and Teradata to support
complex business rules.
. Facilitated design sessions with business customers and IT to define
data requirements.
. Held weekly meetings with European and U.S. customers to give project
status and review requirements issues.
. Worked with DB2 database administrators for development and
maintenance.
. Customer liaison to Europe and North America.
. Subject Matter Expert for Ford Recall Systems.
. Database change analyst.
. Team leader over eight programmers.
Environment: BTEQ, SPUFI, MS Project, ERWin, Oracle Designer, MS FrontPage,
ABC Flowcharter, MS Word, Profs, MS Outlook, Business Objects,
Net.Data, Function Points
Technical Analyst November 1994 - October 1998
assigned to Ford Motor Company
. Wrote server software for three-tier Global Client/Server System,
which runs 2,000 reports a month.
. Designed and coded Database Claim Summary Report which runs against
all claims and vehicle data Ford has had for the past seven model
years.
. Created the Ford Dealer report, which allows over 100 filters as well
as various group and order by conditions.
. Designed and wrote fault tolerant code which creates SQL at runtime.
. Designed and coded mileage band report and part by condition code
report.
. Coded and implemented system for reporting to the California
government.
. Programmer Analyst Unix C Server programming.
. Specification writing
. Environment: PRO*C, SQL*Plus, vi, C, PageMaker, Profs, Data
Warehousing, Function Points
Kmart International Headquarters May 1987 - October 1994
Systems Programmer
. Created fault tolerant tape software, which runs on over 4,000 UNIX
computers every night.
. Enhanced and maintained print software, which runs hundreds of times
on over 4,000 UNIX systems.
. Coded a pseudo terminal drive for automation of software with a user
interface.
. Wrote multiplexed software to allow a program to wait for
communication from several processes.
. Created 'C' to Informix 4GL interface.
. Taught technical classes for print, tape and utility middleware.
. Managed staff of three contract programmers
. Wrote BTRIEVE data utility programs.
. Modified and maintained receiving Kmart store application, which runs
at 1,500 sites.
. Ported receiving Application from IBM loop communications to LAN
communications.
. Created a DOS screen interface in C through use of machine level
routines.
. Used Fagan methodology for code and specification reviews.
. System Programmer in Unix and DOS C.
. Wrote specifications.
Environment: BTRIEVE, Informix 4GL, MS C, Profs
EDUCATION
Bachelor of Science Degree in Computer Science
Tri-State University, Angola, Indiana, USA
Contact this candidate