Project Manager / Analyst
Resume:
Patrick L. Wilcox
Southgate, MI 48195
*.**********@*****.***
RELEVANT WORK EXPERIENCE
Ford Motor Company - Project Management
. Created the Internal ACR (internal process used by Ford Motor Co.), to
open a firewall port and apply security based on supplier static IP to
Ford's internal servers
. Gatekeeper to allow supplier access to financials database
. Established and problem solved network and supplier connectivity issues
. Developed a financial database that moves supplier's mainframe to an
online financial environment. This database replaced Fords mainframe
system with an advanced internet based payables and receivables system
. Created policy and procedures for network connection
. Created 3 Dimensional data analysis system in Microsoft Excel for
Warranty Analysis and maintained server side security for the DataCube
Warranty system
. Utilized Microsoft Access and wrote Visual Basic code and SQL to create
analysis queries and cost reduction analysis
. Responsible for Sarbanes Oxley compliance and audits
. Compose and enforce policies and procedures
. Utilized SAP in daily operations
. Collection, Litigation for delinquent accounts
. Create process for supplier network access
. Manage customer support to Ford and Suppliers
. Project Manager for AWS Supplier Billing System, Sarbanes Oxley Launch,
Supplier Warranty Data Cube Launch
. Maintained and provided detailed analysis and customer support for IT
databases such as AWS, SWIS, Firestone Litigation
Liaison supplier warranty information systems
Use WERS system for part and EOC research
Supply CQIS data to Ford suppliers (warranty sharing)
Performed account payable and receivable for manufacturing suppliers
Six Sigma Certified Greenbelt
Martial Arts Fitness Center
Install and maintain all IT security and functions
Manage all financial and legal aspects of business
Supervised a team of instructor and assistant instructors in operations,
procedures and teaching techniques
Develop and lead community outreach programs
Choreograph and supervised promotional demonstrations
Instruct Monroe County Sheriff and US Military in self-defense tactics
Coordinate regional and national federation events
Great Lakes Bank
Residential Lending Officer
Federal and Local lending regulation
Customer financial qualifications
Cross sell bank products and services
Determine debt to credit ratios and housing to income ratios
Deal with FHA and GNMA loans
Create FHA Mortgage calculator on Excel
Oakbrook Financial
Advertising and cross selling products and services
Manage six locations
Supervised directly over 20 employees
Perform annual reviews for employees
Train new employees
Implemented training course for new recruits
Create new policies and procedures
Litigations
Branch / Spot Audits
Public / Customer Relations
Property Management
Consumer Lending, approvals
Travel nation-wide to open new locations
Summit Academy School - Toledo OH
. Teach special need students, including Autistic, Asperger's, ADD, and
ADHD disorder
. Develop weekly lesson plans based on educational needs
. CPI certified
. Safety team leader
. Incident Commander, based on Homeland Security Initiative
WORK HISTORY
. Summit Academy School, Physical Education Teacher, February 2011 -
Present
. Martial Arts Fitness Center, Business Owner / Lead Instructor, June 2006
- Present
. Ford Motor Company / Kelly Service - ASG, March 1999 - January 2006,
Project Manager / Financial and Quality Analyst
. Great Lakes Bank, Residential Lending Officer, 1998 - 1999
. Oakbrook Financial, Regional Manager, 1996-1998
EDUCATION
Cleary University
. Bachelor of Business Administration
Graduated Cum Laude Honor
SOFTWARE SKILS
Microsoft Word, Excel, PowerPoint, Publisher, Access, Outlook, Front Page,
Visual Basic, SQL, CQIS, PROFS, PeopleSoft, Infopac, SharePoint, MICS,
WERS, AWS, GQA/OLAP SAP, and HTML.
COMMUNITY SERVICE
. Conduct after school program for Airport, and Jefferson School District
. Volunteer services for Monroe County Sheriff Aviation Department
Contact this candidate