Over 10 years of business side IT project management in the development of 7 enterprise wide global applications at Ford Web, Client Server and Mainframe . IT teams ranged in size from 28 to 120.
Project delivery lead on 7 different Data Warehouse applications.
Experience with full Systems Life-Cycle in many different design methodologies FUSION, Ford System Life Cycle, Unified Solution Delivery Methodology USDM, RUP, Agile and Waterfall .
Application platforms involve Web, Client Server, Mainframe and BI - Data Warehousing.
8 years of people management experience for a staff of 7 10 agency personnel.
Over 10 years experience with Security sub-system development experience for Role, Profile and Data level controls. Areas included enterprise controls, extra-net firewall solutions, access authentication authorization, and development of controls for proprietary Identity personal data.
7 years of experience developing and executing UAT test cases.
4 years of experience with technical writing, end-user training and user guide documentation.
Over 10 years of mainframe FOCUS programming BI special projects reporting .
Over 15 years Web and Client Business Intelligence tools experience 7 WebFOCUS, 8 - Business Objects, and 4 - Cognos Impromptu and SQL development experience.
2 years of Data Mining development experience with three different applications utilizing automated algorithms for intelligent analysis of business data and dashboard front ends of pattern results and key performance metrics.
1 year of business systems management experience in Human Resources.
Acquired Knowledge / Skills
Full life-cycle Project Management experience
IT Project Business Analyst experience
Programming experience on mainframe, client server and web BI special reporting tools.
Data Warehousing Data Mining development experience
IT application development knowledge Mainframe, Oracle Server and Web
Corporate database knowledge HR data, parts, dealers, vehicle BOM, warranty claims and product concern data
Cross-functional team experience.
Human Resources business IT processes
Automotive Education
People management experience
Automotive product development knowledge
Vehicle diagnostic development experience.
Diagnostic Tool development knowledge
Vehicle Powertrain calibration development experience
Product quality concern identification resolution process experience
Part procurement process knowledge
Recall process knowledge
Problem solving and analytical skills
Professional Experience
Confidential
Business Systems Analyst
Achievements:
Successfully analyzed Warranty Claims Data Warehouse architecture, database structures and transactional processing to identify major issues inherent in all current report programs.
Implemented changes in report program logic to allow staff in Warranty, CRC, Product Investigation, Litigation, Field Staff and Finance personnel to be able to accurately reflect and reconcile all Warranty performance and cost throughout the organization. Identified financial discrepancies in annual reconciliation valued at over 500,000.
Successfully analyzed supporting data and business systems to identify root causes for source system issues and provided recommendations for resolution.
Successfully managed and performed required programming for over two hundred business reports through the use of the WebFOCUS Special Reporting Tool.
Responsibilities:
Monitor, fix and upgrade all Special Reports required by business through the use of a WebFOCUS reporting environment. Instance architecture consisted of a production job scheduler Report Caster with over 100 reports run at various time intervals with output distributed through email, a canned reporting environment of 50 plus reports web delivered for end user ease of access and report run Managed Reporting Environment and adhoc delivery of required business data for day-to-day decision making.
Process requests of business data for the purpose of identify incorrectly coded Warranty Claims by company retailers which result in corporate cost saves.
Understand and investigate various business processes throughout the North American headquarters office and find opportunities to improve and automate for both efficiency and productivity.
Investigate and analyze corporate source system issues. Find business data anomalies, identify root causes and define recommendations for resolution.
Participate in the development of all new source system applications, by drawing on over 30 years of experience, to provide guidance and technical support to ensure that system designs meet business needs.
Confidential
Human Resources HR Business Systems
Achievements:
Participated in the successful source system upgrade to PeopleSoft v8.9.
Successfully managed all source system data improvements through ELT and Data Warehouse enhancements.
Acquired knowledge of all HR source systems and Business Intelligence applications to handle Level 2 Help Desk support for Chrysler employees non-employees globally.
Responsibilities:
Direct all workflow for the design, content and data integrity of the HR Data Warehouse. Workflow included business customer interface for new sources of HR data as-well-as defining requirements, maintaining the system Change Control process, setting IT work priorities, chairing project status meetings with IT and providing project status to upper management.
Monitor all processes and manage changes for HR data extracts sent external to the organization. Extracts included data feeds for Chrysler Management and Executive compensation to supplier Towers Perrin, a data feed of corporate employee Service Anniversary recognition data to supplier Tharpe Robbins, a feed to the corporate web portal for Chrysler Financial staff access, and a feed to the Daimler Corporation for global HR data record integrity between the global entities.
Manage and maintain the Security of the HR Data Warehouse. Tasks included leading efforts on design and strategy of the security system, approving and implementing security access for global HR representatives, managing Sarbanes Oxley security compliance efforts such as annual Security renewal for all users and a quarterly review of all security implemented for access integrity and non-use.
Acquire and utilize enterprise knowledge on all corporate HR production systems to provide Level 2 support for two Help Desks Corporate and HR . Expertise required for the Person Data Management system for Identity Management of corporate personnel employee non-employee , My Profile for employee self-service of maintaining personal data, the PeopleSoft system for corporate management of all HR employee data employment processes. Regular tasks included diagnosing HR data integrity issues and approving the correction for HR data to all downstream corporate systems.
Technologies:
PeopleSoft
Cognos Impromptu and SQL
Lightweight Directory Access Protocol LDAP
Java Script
DB2 Connect
Cobol
Confidential
Business Analyst
Responsibilities:
Develop Business Systems Requirements Specifications document to capture all the business and IT requirements related to the Parts Distribution and Part Claims Handling for VW North America on a joint venture vehicle program with Chrysler.
Workflow involved coordination between a client side Project Manager, IT side Project Manager, a project side Technical Architect and various business management and end user business team members to document all requirements.
Technologies:
Utilized a VW of Germany adapted Waterfall systems design methodology.
Microsoft Word, Excel and Visio
Confidential
Business Technical Project Lead Global Campaign system GCAMP
Achievements:
Utilized programming skills to increase data integrity in the 20 years of historical data in GCAMP.
Participation in testing of all sub-systems for function and integration on 3 separate launch phases of the GCAMP application. The application enables Ford North America, Ford of Europe, Ford Asia Pacific, Jaguar and Land Rover staff to identify affected vehicle populations, launch and status Field Service Actions anywhere in the globe.
Led IT /Business through the definition, development, testing, and successful launch of 4 core GCAMP application sub-systems.
Participation in the successful development and launch of the global Vehicle Data Mart.
Responsibilities:
Initiated, developed and executed computer programs to automatically assign new Responsible Dealers for terminated dealers or customer relocation conditions. The programs merge dealership Market Area Point data and Dealer Master data to perform proximity that would optimize dealer assignments within closest geography to the customer.
Led IT and Business teams though the design, development and launch of the Special Reporting data warehouses on Teradata for Vehicle Targeting and for Field Service Action execution and repair completion performance metrics..
Led IT and Business teams through the development and launch of the Records Management sub-system to enable the organization to have effective document controls.
Led IT and Business teams though the development and launch of the application Security sub-system to deliver the proper authentication, validation and authorization for system access.
Led IT and Business teams through the conversion and changes of the Vehicle Targeting sub-system. This sub-system is utilized by global Field Service Action FSA Coordinators to target affected vehicle populations involved in a given quality issue.
Participated in the launch of the Business Objects client server special reporting tool to maximize end-user utilization of FSA data for Business Intelligence. Developed training materials and helped with the training sessions.
Technologies:
SUN Applications Servers Web in iPlanet App Services in Websphere
Web application screens and business logic in java script using J2EE
Application Services Layer Security DB SQL Server Reporting Svc in Oracle Reports
Affected FSA Data Mart for interface communications in SQL Server
IBM 355 Running OS/390 I/O handled running Cobol stored procedures to DB2 databases
Middleware communications handled through DB2Connect
Data Warehouse on Teradata with BI analytical service in Business Objects 9 and SQL
Over 30 global interfaces to other Web, Mainframe and Vendor applications databases.
Microsoft Office Suite, Visio and Project
Confidential
Responsibilities:
Set-up / coordinate vehicle concern Technical Review meetings with Engineering and FCSD Recall program management staff.
Derive vehicle attributes for data selection from involved vehicle descriptions in 14D document on potential Field Service Actions Recall or Customer Satisfaction programs .
Use vehicle selection criteria in queries against the Vehicle Data Mart to target involved vehicles in the Campaign Targeting System CTS .
Load affected vehicle population records into the Corporate North American Campaign System CNACS for someone else to process the Field Service Action FSA launch steps.
Maintain potential FSA process status and affected vehicle volumes in the Field Service Action Online database for weekly Concern Status Review meetings.
Confidential
Achievements:
Managing the successful development, launch and roll-out of the GCQIS web application.
Managing the successful development, launch and roll-out of the WebFOCUS business intelligence application.
Participation in the development of the Early Concern Warning System ECWS
Participation with vendor Triada Corp. and Ford Scientific Research Labs in data mining development of quality indicator data R D projects .
Potential patent on data mining technique.
Responsibilities:
Led offshore development project for Global CQIS Web application with FCSD, the Quality Office and Satyam Computers located in India .
Participated in various data mining research efforts conducted by Ford Scientific Research Laboratories. The tasks involved work with software tools such as Triada Ngram technology, Themescape by Cartia, Inc. and Text-O-Scope by Instinct Software now ClearForest .
Developed data optimization techniques to support the full analytical capabilities of several data mining software suites. Techniques were documented in a patent submission.
Participate with Quality Office team and vendor team Triada to develop a corporate data mining application to house all corporate quality indicator data.
Led IT team of 5 in the development of WebFOCUS BI analytical application running against a Data Warehouse on a Teradata platform. Existing mainframe FOCUS application was migrated to WebFOCUS.
Technologies:
Data Mining
Applications using Triada Ngram technology, Themescape by Cartia, Inc. and TextO-Scope by Instinct Software now ClearForest .
GCQIS Web Application
Unix Applications Servers
Web application screens and business logic in java script
IBM 355 Running OS/390 I/O handled running Cobol stored procedures to DB2 databases
Middleware communications handled through DB2Connect
WebFOCUS BI Tools on Teradata Data Warehouse and SQL
Confidential
IT Project Leader
Achievements:
Successfully led the development and launch of multiple sub-systems for mainframe CQIS application.
Roll-out of the CQIS application to 4200 users at global Ford locations.
Management of 7 10 people for 8 years on day-to-day work priorities.
Development of a 3 5 year Global Business / IT Plans for on-going system development.
Managing the successful development of the mainframe FOCUS BI system.
Participation in the successful development and launch of the web based Global Concern Reporting application GCR .
Responsibilities:
Initiated and led the agency staff through the development and implementation of a mainframe FOCUS based Menu Reporting System. This system housed more than 163 unique special reports for problem solving, data input metrics and administrative metric reports. The output from this system interfaced to all Microsoft Office software to extend the analytical capabilities of the CQIS data.
Led IT activity and the FCSD Plant Vehicle Team PVT representatives in the development and implementation of a sub-system called the Concern Tracking System. This sub-system was used to track and status of both Quicker Service Fix and normal vehicle concerns through to resolution. The system allows all plant PVT teams to monitor all vehicle concerns though the entire concern resolution process.
Led the National Hotline activity NHL and FCSD Service Improvement Operations activities in the development and implementation of a sub-system in CQIS called Technical Assistance Referral TAR . This sub-system provided a communication interface between the Hotline and 19 FCSD Regional Offices on tough to fix vehicle concerns. The communications resulted in on-site support from regional Field Service Engineers FSEs to dealership personnel with technical support to resolve customer vehicle concerns.
Initiated and led the Administration team in a marketing and awareness strategy for the use of CQIS, which yielded 4200 users in 311 global Ford organizations in 33 countries for business process consistency.
Performed in a Business Systems planning capacity to develop and implement a global business plan for rolling out CQIS and reporting processes to Global FCSD Regions/Markets for global enterprise product quality early concern identification, quality tracking and resolution management.
Participate in the team effort to develop and implement the Global Concern Reporting web application GCR . Provided solutions that enabled the application to accept vehicle concern reports on any Ford Motor vehicle globally and move the report data into the quality indicator repository for early concern identification and tracking.
Participate in the Systems development of the Vehicle Data Mart. The database enabled the merger of both manufacturing BOM and sales data for all of Ford North America and Ford of Europe produced vehicles.
Technologies:
IBM 355 Running OS/ 390 I/O handled Cobol programs to DB2 databases
Interfaces managed through 3270 Terminal Emulation
Data Warehouse on Teradata with BI analytical service in Mainframe FOCUS and SQL
Confidential
IT Project Coordinator Common Quality Indicator System CQIS
Achievements:
Successfully led the development of mainframe Common Quality Indicator System CQIS , phase 1.
Prompt Office Automation Support to over 70 PCs in Service Engineering Office.
Responsibilities:
Participation in Rapid meetings to identify main functions and content for the application.
Led user groups and IT through the detail specification development, design and implementation of sub-systems. The scope for this phase of the design included:
General and Fleet Hotline report entry sub-systems.
Problem solvers Tool Kit to handle the review of product quality indicator reports with report summary count analysis.
Electronic foldering of quality indicator data for concern business case development in preparation for problem resolution process steps.
Electronic report forwarding interface for Service Engineers to communicate critical Safety Emissions concerns to the Recall activity.
Electronic Technical Library sub-system to hold all known published product concern communications to the field TSB, Hotline Internal, FSA programs .
Provided the Service Engineering Office, staff of 70 plus, with PC office automation support. Tasks involved staging PCs with Ford approved standard software loads, new updates/patches, and help desk like PC trouble-shooting 2 years of OA experience . Interfaced with divisional / corporate office automation activities and end-users.
Technologies:
IBM 355 Running OS/ 390 I/O handled Cobol programs to DB2 databases
Interfaces managed through 3270 Terminal Emulation
Data Warehouse on Teradata with BI analytical service in Mainframe FOCUS
Technologies Summary
iPlanet
Websphere
Java J2EE
DB2Connect middleware communications
Cobol
Oracle 9i
Oracle Reports
SQL Server
NET.DATA
ETL
Cognos Impromptu
Business Objects web full client
WebFOCUS
Mainframe FOCUS
IMS / TSO mainframe environments
JCL
Sun and Unix Servers w/ web hosting and applications services layers
IBM 355 Mainframe w/ O/S 390 and DB2 database management
Privacy Policy
