Mark Hansel

Mark Hansel Email and Phone Number

Senior Enterprise Analyst and Developer @ KYYBA Inc
Oak Park, MI, US
Mark Hansel's Location
Oak Park, Michigan, United States, United States
Mark Hansel's Contact Details

Mark Hansel personal email

n/a

Mark Hansel phone numbers

About Mark Hansel

Mark_Hansel@sbcglobal.net -- All invitations to connect are welcome, no IDK. Senior Enterprise Developer and Analyst with over 25 years of experience in Mainframe Development of which 14 years was as a Mainframe Systems Analyst in the healthcare and automobile industries.Specialties: Languages: COBOL/COBOLII, SQL, DL/1, IMS DC, MFS, CICS, PL/SQL, JAVA, Pacbase.Database: DB2, IMS DB, Oracle, UDB, Access, IDMS. Ancillary Skills: MS Project, EPM, MS Office, VISIO, JCL, SPUFI, QMF, TOAD, FTP, VSAM,KORN Shell, Unix Shell Scripts, Endevor, Panvalet, Changeman, TSO/ISPF.Operating Systems: OS/MVS, WAS3.5/5.0, Unix, Windows 9.X,XP, GCOS. Hardware: IBM30XX, SUN E10000, Intel-Based PC, Honeywell Bull.

Mark Hansel's Current Company Details
KYYBA Inc

Kyyba Inc

View
Senior Enterprise Analyst and Developer
Oak Park, MI, US
Website:
kyyba.com
Employees:
394
Mark Hansel Work Experience Details
  • Kyyba Inc
    Kyyba Inc
    Oak Park, Mi, Us
    View
  • Kyyba Inc
    Senior Programmer Analyst
    Kyyba Inc Jan 2019 - Apr 2020
    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.
    View
  • Vaco
    Data/Systems Analyst
    Vaco Aug 2015 - Jun 2018
    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.
    View
  • Millennium Software (Pvt) Limited
    Systems Design Analyst
    Millennium Software (Pvt) Limited Jul 2011 - Dec 2015
    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.
    View
  • Adecco Staffing
    Programmer Analyst
    Adecco Staffing Feb 2010 - Jul 2011
    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.
    View
  • Dpm Consulting, Inc
    Mainframe Systems Analyst & Mainframe Developer
    Dpm Consulting, Inc 2007 - 2009
    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.
  • Unilog Logicacmg
    Mainframe Systems Analyst & Mainframe Developer
    Unilog Logicacmg 2004 - 2007
    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.
    View
  • Unilog Logicacmg
    Mainframe Systems Analyst & Mainframe Developer
    Unilog Logicacmg 2000 - 2004
    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.
    View
  • Health Alliance Plan
    Senior Programmer Analyst
    Health Alliance Plan 1996 - 2000
    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.
    View
  • Computer & Engineering Services
    Programmer Analyst
    Computer & Engineering Services 1994 - 1995
    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.
  • Strategic Staffing Solutions
    Programmer Analyst
    Strategic Staffing Solutions 1993 - 1994
    Detroit, Mi, Us
    DEVELOPER: Developed COBOL IMS DB2 programs for the Integrated Retail Information System (IRIS).
    View
  • Computer & Engineering Services
    Programmer Analyst
    Computer & Engineering Services 1992 - 1993
    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.
  • Consultants In Business & Engineering Resources
    Programmer Analyst
    Consultants In Business & Engineering Resources 1990 - 1992
    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.

Mark Hansel Skills

Db2

Mark Hansel Education Details

  • Wayne State University
    Wayne State University
    Mechanical Engineering

Frequently Asked Questions about Mark Hansel

What company does Mark Hansel work for?

Mark Hansel works for Kyyba Inc

What is Mark Hansel's role at the current company?

Mark Hansel's current role is Senior Enterprise Analyst and Developer.

What is Mark Hansel's email address?

Mark Hansel's email address is mh****@****ell.net

What is Mark Hansel's direct phone number?

Mark Hansel's direct phone number is +124854*****

What schools did Mark Hansel attend?

Mark Hansel attended Wayne State University.

What are some of Mark Hansel's interests?

Mark Hansel has interest in Christianity, Kids, Collecting Antiques, Exercise, Electronics, Outdoors, Nascar, The Arts, Home Improvement, Reading.

What skills is Mark Hansel known for?

Mark Hansel has skills like Db2.

Who are Mark Hansel's colleagues?

Mark Hansel's colleagues are Vivek Anand, Shashikala Raja, Jingxin Yu, Deepa E, Tamilmani S, Erica M, Srikanth R K.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.