Mark Hansel Email & Phone Number

Oak Park, Mi, Us

Farmington Hills, Mi, Us

SYSTEMS ANALYSIS: Analyzed the CASS(Customer Account Service System) batch processing, documenting it and recommending improvements. Identified unused Endevor elements to be cleaned up from Stage and Production libraries. This included JCL, PROCs, COBOL Programs, DB2, CICS, MQ Series, Subroutines, copybooks and parameters. DESIGN, BUILD, TEST AND IMPLEMENT: Decommissioned CASS Mexico Batch Processing. Made modifications and decommission plans for CASS US and Canada Automobile processing. Developed DB2 purge process for accounts aged greater than 10 years. Developed reconciliation report for periodic Data Refresh. Supported migration to new data center. Cleaned up unused Endevor elements from the Stage libraries. Used COBOL, DB2, JCL, Endevor and CA7, STAGE ENVIRONMENT: Supported early morning batch processing by being on call. Migrated code changes into the stage environment. Validated that changes work as expected. Analyzed and troubleshot anomalies in stage test results. Used Endevor, COBOL, JCL, Xpediter and CA7.DOCUMENTATION: Published VISIO flowchart of the complex nightly batch processing. Documented test case results for SIT, UAT and Pre-Prod testing. Gathered details of the existing account request transaction processing. Documented the monthly archival process. Documented new designs and impact lists for project work. Used Microsoft Office Word, XCEL and VISIO. ENVIRONMENT: COBOL, CICS, DB2, VSAM, JCL, PROC, FTP, SQL, Stored Procedures, MQ Series, Endevor, Xpediter, Agile, Systems Analysis, Documentation,. Microsoft Office Word, XCEL, PPT and VISIO.

Brentwood, Tennessee, Us

DATA ANALYSIS: Compiled data lineage from source to target mapping documents. Analyzed existing data models, identified gaps, and updated data models as needed in ERWIN. Loaded data lineage into ERWIN for advantage project. Loaded lineage for ALFA COTS package: Web Services, User Interface, Conversion Tables, Reporting Bookmarks and Data Store. DATA MAPPING: Participated in data mapping working sessions for incoming Credit Applications. Credit Applications Interface switched from Legacy COBOL to COTS package. REQUIREMENTS GATHERING: Derived business rules from legacy COBOL system documentation for the Advantage project. The project replaces the COBOL legacy system with a COTS package. Performed gap analysis between current and future state requirements. TRAINING: Published training materials and led training sessions for IBM InfoSphere and Metatdata Workbench.ENVIRONMENT: ERWIN, IBM InfoSphere, Metadata Workbech, PACBASE, COBOL, JCL, FTP, SQL, Oracle, Agile, JAVA, Requirements Gathering, Systems Analysis, Data Analysis. Microsoft Office Word, XCEL, PPT and VISIO.

Karachi, Sindh, Pk

SYSTEMS ENGINEERING: Designed sequenced order extract from DB2 Order Bank. Defined twenty jobs to support parallel processing by multiple customers. Defined twenty corresponding jobs to receive and process the extract updates to the Order Control systems to keep it in sync with the Order Bank. This insures the latest information is transmitted to the assembly plants. Published technical specifications, and mentored off shore developers through coding and unit testing. Supported all phases of testing, implantation to production, and during two month warranty period. REQUIREMENTS GATHERING: Analyzed and Gathered Requirements for the Generate Based On Vehicle Order program. This program calls a stored procedure from another TSO facility to retrieve Vehicle Order Recode information. Subroutine calls are made to apply any needed updates to the rest of the order in the Single Order Bank. Produced specifications and mentored offshore developer through unit testing of the COBOL DB2 program. INTEGRATION TESTING: Collaborated with Business Analysts and Developer to bring Status Progression specifications and program code up to date after a two year hiatus. Performed Gap analysis between the business requirements, specs and code. Updated specifications and reviewed with the Business Analysts and Developer. Mentored Developer to modify existing driver program and the subroutine to accommodate the testing requirements. Integration Testing was completed two weeks ahead of schedule.TECHNICAL ANALYST: Collaborated with the Ford DB2 DBA and Changeman specialist to troubleshoot the bind of the Generate Based On Vehicle Order program between facilities. This was the first such cross facility call from for the Order Bank. Implemented successfully in production. ESTIMATING: Performed high-level estimating for various development efforts.

Zurich, Ch

SYSTEMS ENGINEERING: Developed Customer Billing Correction Process to automate the generation of billing correction files and transmit (FTP) them to Ford Motor Co. Designed and wrote Customer Entry CICS online screens for entry of corrections. Also designed changes to the COBOL VSAM batch process to transmit (FTP) selected correction batches to Ford Motor Co. Collaborated with customers to complete testing. PROGRAMMING: Ensured the timely completion of monthly $2MIL Ford billings. Analyzed discrepancies discovered during the monthly reconciliation process. Correcting billing entries and/or enhancing COBOL VSAM program logic while meeting time constraints. DEVELOPER: Revamped the Ford Dealer Statement making it more readable to the dealers. Added more meaningful headings, part information and details. Ensured appropriate regression testing was performed.ESTIMATING: Performed high-level estimating for all outstanding Ford Billing requests for the Parts Account system.

QUALITY ASSURANCE: Managed User Acceptance Testing of the Premium Rate Increase letter process meeting the production deadline. As a result, Testing was completed 25% earlier than the minimum time previously achieved by any group for any process. SYSTEMS ENGINEERING: Developed System and Technical Design Documents for the Cancellation letter. After the Cancellation process was completely unit and systems tested, we converted only part of membership history. Analyzed the Cancellation letter process to determine the lowest cost solution to meet new requirement. Collaborated with others on process development to insure the new solution would address all test scenarios correctly.PROGRAMMING: Wrote letter process COBOL DB2 programs and processes. Modified letter process COBOL DB2 programs to address defects found during Systems Integration and User Acceptance Testing. Extracted sample test data from test and production DB2 tables using SQL and SPUFI.DEVELOPER: Developed System and Technical Design Documents for Michigan Operating System letters. Managed and reviewed development, testing, and implementation of Michigan Operating System letters using SDLC. GAP ANALYSIS: Analyzed and documented the mainframe system letter functionality for the Michigan Operating System project. Performed gap analysis between existing letters and Metavance systems capabilities, including Correspondence Generator. Collaborated with system users to document business requirements for automated letters.

Montreal, Qc, Ca

DEVELOPER: Analyzed and updated EDI process to eliminate the need for unsupported software. Reduced costs while ensuring $200 million per week in payments to Ford suppliers went out accurately and on time. SYSTEMS ENGINEERING: Developed Corporate Centralized Accounts Payable System vs. Everest System Payables report. This met the business need to reconcile payables entries in the Everest system with the Corporate Centralized Accounts Payable System. It reported any discrepancies up to a specific dollar threshold. This made reconciliation between the two systems possible, as it was too time consuming to perform manually. DATA ANALYSIS: Analyzed production data in DB2 tables for testing using SQL and SPUFI. Maintained batch COBOL IMS DB2 programs and processes for the Corporate Centralized Accounts Payable System.ESTIMATING: Performed high-level requirements analysis and estimating for adding Volvo and Health Care payables to the Corporate Centralized Accounts Payable System.

Montreal, Qc, Ca

PROJECT MANAGER: Managed the ePayables project, which was a new web interface for Ford suppliers to access mainframe payables data. Coordinated development and testing efforts in the US and Great Britain. Project completed on time and within budget.SYSTEMS ENGINEERING: Performed analysis and programming to implement the ICS system for additional countries. Analyzed Corporate Centralized Accounts Payable System functionality to resolve support problems and identify business requirements. Identified solutions to problems, managed and developed COBOL IMS DB2 modifications.

Detroit, Mi, Us

SYSTEMS ENGINEERING: Led a team of 3 analysts to develop specifications for the daily membership update process. Led a team of 5 programmers to write and test the components of the daily membership update process. Provided technical support throughout system testing. Set up test data in Oracle tables using TOAD. Development was on time and within budget. SOLUTION ANALYSIS: Analyzed membership activity data from the existing system to facilitate project decision making. Evaluated feasibility of proposed solutions for the daily membership update process. Reviewed and edited business requirements for the daily membership PL/SQL Oracle update process to the Diamond Claims System. PROJECT MANAGER: Managed the Group Management Team's coding and unit testing for the Y2K project. Coordinated development for the company wide Y2K project. Developed the conversion process for Diamond Release 17.0 database fields. Projects were on time and within budget. QUALITY ASSURANCE: Tested Subscriber Billing during Full Integration Testing of Positive Billing and A/R systems. Maintained EDI programs for the Chrysler Group business. Documented the Positive Billing process for the implementation. BUSINESS ANALYSIS: Managed requirements capturing and development of Optical/Pharmacy Provider Access application. QUALITY ASSURANCE: Performed technical acceptance testing during the evaluation of new releases of Diamond software. Maintained Diamond batch PL/SQL Oracle programs and jobs. Investigated and resolved problems reported by customers. Collaborated with the system users to analyze concerns, and develop action plans. Rotated for on-call support of batch processing.

SYSTEMS ENGINEERING: Developed Customer Assistance System programs utilizing COBOL II, DB2, and IMS/DC. Analyzed Customer Assistance System batch reports. Developed COBOL II, DB2 batch report programs, and jobs. DEVELOPER: Developed COBOL II, DB2 batch programs and JCL job for FTP to LAN directories.

Detroit, Mi, Us

DEVELOPER: Developed COBOL IMS DB2 programs for the Integrated Retail Information System (IRIS).

DEVELOPER: Developed batch and online COBOL DB2 CICS programs for the Defect Detection Reporting and Correction (DDRC) System. PROGRAMMER: Maintained online and batch COBOL DB2 IMS DC and CICS programs and jobs for the DDRC, Vehicle Problem Tracking, and Management Reporting Systems.

SYSTEMS ENGINEERING: Designed Service Training and Reporting System online screens. Wrote specifications for online programs. Coded and tested COBOL DB2 IMS DB/DC online programs from specifications. Developed Customer Information System and Project Management System COBOL DB2 IMS DB/DC online and batch COBOL programs.