Martin Z.

IT Process Consultant, Requirements Engineer and Solution Architect

Avatar placeholder
Aachen, Germany

Experience

Jan 2023 - Present
3 years
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance

  • Data migration of transaction data in the area of commission settlement from various proprietary IBM mainframe systems to the target application SAP ICM.
  • Planning, implementation, and quality assurance of a batch process for data migration on various mainframe platforms from testing to production.
Jan 2022 - Present
4 years
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance

  • Development of a complex Excel automation solution to calculate reverse level appointments for field sales based on annual production figures and many other parameters.
  • Multi-year analysis of the appointments, simulation procedures.
Jan 2022 - Dec 2022
1 year
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance

  • Development of a mass business transaction for reorganizing the organizational structure.
  • Automated SAP export - complex, VBA-powered Excel front end for data processing and validation - automated SAP import.
Jan 2021 - Dec 2022
2 years
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance

  • Backend design and development - IBM mainframe, COBOL, DB2, SQL for data provisioning of a web application for insurance field sales.
Jan 2021 - Dec 2021
1 year
Berlin, Germany
Lorem ipsum dolor sit amet

Pharma

  • Design and development of an Excel tool in VBA for pharmaceutical sales / securing drug trade to reconcile CRM customer and order data.
  • Automated invoice delivery via MS Outlook.
Jan 2020 - Dec 2021
2 years
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance company

  • Developed complex Excel front-ends in VBA for data maintenance and cleanup in the organizational structure and sales organization before a migration.
  • Designed the solution with the business users, implemented it and tested it.
Jan 2018 - Dec 2020
3 years
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance company

  • Developed a test automation workflow with Excel VBA, UFT and HP ALM to test SAP applications, mainly the OM, BP and ICM modules.
Jan 2013 - Dec 2014
2 years
Düsseldorf, Germany
Lorem ipsum dolor sit amet

Insurance company

  • Data warehouse to qualify and quantify incoming mail, business processes and outgoing mail as a basis for management decision-making.
  • Designed and developed the necessary ETL processes to standardize heterogeneous transaction data in the system of record for the contract, claims/benefits and application areas of the composite, life and health lines.
  • Automated testing with Excel VBA to evaluate test runs and compare regression tests.
  • Developed a process for providing test data from business requirements to the presentation of the results.
  • Conducted data migration and operational cutover of the field staff management system to a new sales structure.
  • Developed a process in Microsoft Office (Excel, Access, Outlook) to capture migration data for about 60,000 field employees and prepare it for data migration to an IBM mainframe.
Jan 2012 - Dec 2012
1 year
Cologne, Germany
Lorem ipsum dolor sit amet

Insurance company

  • Migrated the health insurance system using an ETL tool for the technical implementation of the migration process.
  • Designed, developed and implemented business migration rules.
Jan 2008 - Dec 2018
11 years
Düsseldorf, Germany

IT Process Consultant, Requirements Engineer and Solution Architect

Insurance company

  • Major project for an insurance group to implement SAP OM and SAP BP in place of its own proprietary mainframe application for managing the sales and organizational structure.
  • Managed and organized the necessary interface transformations.
  • Designed and implemented test procedures, and designed and implemented test automation for SAP OM and SAP BP.
Jan 2007 - Dec 2008
2 years
Saarbrücken, Germany
Lorem ipsum dolor sit amet

Insurance Company

  • Migration of health insurance policies as part of a portfolio merger.
  • Design, development and implementation of specialized migration rule sets, planning and development of the necessary data center processes.
Jan 2007 - Dec 2007
1 year
Hamburg, Germany
Lorem ipsum dolor sit amet

Insurance Company

  • Upgrade of Content Manager (optical archive) from version 7 to 8.3.
  • Migration of document references to the new format.
  • Motor insurance competency center, design and processing of business requests for IT, release change planning.
Jan 2006 - Dec 2006
1 year
Aachen, Germany
Lorem ipsum dolor sit amet

Insurance Company

  • Support of two large projects to restructure the sales organization in the composite/motor insurance subproject.
  • Development of a business and technical migration concept for migrating the motor insurance portfolio to a new sales structure.
  • Business design in the area of transaction management.
  • Development of Office tools to support test coordination in large projects.
Jan 2005 - Dec 2005
1 year
Aachen, Germany

Domain Designer and Release Coordinator

Insurance Company

  • Motor insurance competency center, design and processing of business requests for IT, release change planning.
  • Product modeling for motor insurance using a holistic approach for target platforms: host, field sales quoting software, and web-based broker software with the product modeling tool IP.Suite.
Jan 2004 - Dec 2004
1 year
Hamburg, Germany
Lorem ipsum dolor sit amet

Insurance Company

  • Business transaction modeling for motor insurance in connection with integration into a corporate-wide transaction system.
  • Evaluation and migration of all related transaction data into a corporate-wide transaction system.
  • Development of a technical concept for archiving historical and canceled contract states of the motor insurance portfolio.
  • Design and implementation of the initial loading of the corporate data warehouse with data from the motor insurance portfolio.
Jan 2003 - Dec 2003
1 year
Hamburg, Germany
Lorem ipsum dolor sit amet

Insurance

  • Migration of a system for managing optical archive data from scanning processes into a new environment.
  • Business analysis, evaluation and migration of all related transaction data into a company-wide transaction system.
  • Migration of transaction and scheduling data of a group-wide partner system with multiple tenants into a new, also unified environment.
  • Development of a parameterizable and reusable migration process for further use in future projects.
Jan 2002 - Dec 2002
1 year
Aachen, Germany
Lorem ipsum dolor sit amet

Insurance

  • Developed a solution for automated monitoring of batch productions on an IBM mainframe.
  • Developed a solution for automated monitoring of fax dispatch.
  • Imported and reconciled all relevant data in MS Excel using VBA.
  • Operated a system for document production.
  • Secured and monitored daily production on an IBM mainframe.
  • Developed tools for automated checking of daily processes.
  • Supported and maintained systems for transaction and schedule management.
  • Migrated the technical lines of insurance, commercial individual and group accident insurance, and transport insurance into a new policy administration system, reusing the migration process from 1998–2001.
  • Developed dialog modules and functional components of the policy administration system.
Jan 2001 - Dec 2001
1 year
Aachen, Germany
Lorem ipsum dolor sit amet

Insurance

  • Functional analysis of existing commercial electronics and construction insurance products.
  • Converted them into product definition rules to parameterize a new policy administration system.
Jan 1998 - Dec 2001
4 years
Aachen, Germany
Lorem ipsum dolor sit amet

Insurance

  • Implemented a group-wide policy data management system to store contracts for private and commercial property, accident and liability insurance.
  • Developed an inter-line migration process from the business rule description method to the IT implementation.
  • Programmed a rule compiler to generate COBOL migration code.
  • Developed dialog modules and functional components of the policy administration system.
Jan 1995 - Dec 1998
4 years
Aachen, Germany
Lorem ipsum dolor sit amet

Insurance

  • Implemented partner data management of a group company in another corporate IT landscape.
  • Developed the functional design for integration into the existing application landscape and specified interfaces to the existing systems.
  • Developed a migration process for the legacy system data.
  • Gradually integrated the partner data management into all core systems.
  • Developed a dialog middleware layer and a transformation layer to manage communication between different user systems and the partner application.
  • Performed data modeling, capacity planning and implemented data storage.
  • Final application tuning mainly by analyzing and improving the data retrieval performance.
Jan 1994 - Dec 1995
2 years
Cologne, Germany
Lorem ipsum dolor sit amet

Bank

  • Development of a procedure for copying database objects and their contents to any target environments via batch processing with dynamic SQL.
Jan 1991 - Dec 1994
4 years
Cologne, Germany
Lorem ipsum dolor sit amet

Insurance

  • Implementation of the commission procedure from 1989 to 1990 at another client.
  • Further development of the procedure, adapting client-specific employee management and compensation.
  • Integration of field force compensation with maintenance commission.
  • Integration of a report for the financial reporting of the commission volume at risk.
Jan 1990 - Dec 1991
2 years
Munich, Germany
Lorem ipsum dolor sit amet

Insurance

  • Design for determining, reporting and accounting of commission amounts at risk.
  • Data modeling, capacity planning, implementation and administration of data storage.
  • Programming of all dialog and batch components.
Jan 1989 - Dec 1990
2 years
Munich, Germany
Lorem ipsum dolor sit amet

Insurance

  • Functional redesign of a multi-tenant, cross-department procedure for commission accounting, commission calculation and employee management with dialog-based process control.
  • Data modeling, capacity planning, implementation and administration of data storage.
  • Programming of dialog, batch and billing components.
  • Management of batch production.
Jan 1987 - Dec 1989
3 years
Aachen, Germany
Lorem ipsum dolor sit amet

Insurance

  • Maintenance and further development of a system for commission accounting, commission calculation and employee management.
  • Programming of dialog and billing components, management of batch production.

Skills

  • Programming Languages: Cobol, Visual Age Cobol, Pl/1, Delta, Swt-vda, Visual Basic (Vb), Visual Basic For Applications (Vba), Rexx, Rpf, Basic Java, Basic Sas
  • Databases: Db2, Ims/db, Vsam, Sql-base, Access
  • Operating Systems: Mvs, Os/390, Z/os, Windows
  • Data Communication: Cics, Ims/dc, Mq Series, Ecsa, Kafka
  • Product Know-how: Microfocus Cobol Workbench, Mainframe Express, Visual Age, Swt-vda, Wsad, Rdz, Smarttest, Smartedit, Insight, Xpeditor, Ibm Debug Tool, Sclm, Fileaid, Proedit, Qmf, Spufi, Candle Db2 Workbench, Bmc Db2 Catalog Manager, Bmc Db2 Tools, Toad For Db2, Tabex, Beta91, Beta92, Control-d, Tivoli Workload Scheduler, Xinfo, Strobe, Orion, Dcf/script, Vps, Fax Plus Open, Msc, Filenet, Front Office, Content Manager, Sql Navigator, Iafc, Ip.suite, Informatica Powercenter, Enterprise Guide, Sap Om, Sap Bp, Jira, Tsf, Kafka, Rubberduck, Uft, Hp Alm, Microsoft Office Products, Visio
  • Methods: Agile Software Development, Object-oriented Analysis, Object-oriented Design, Method Manager, Uml, Structured Analysis/design/programming, Repository, Entity Relationship
  • Industries: Insurance
  • Focus Areas: Commission Calculation, Commission Settlement, Employee Administration, Partner Data Management, Policy Management For Property/commercial/industrial/motor/health Insurance, Document Management, Business Transaction Management, Test Procedures, Test Automation, Migration, Application Tuning, Product Modeling, Data Warehousing, Tool Development In Ms Office (Mainly Excel)

Languages

German
Native
English
Advanced
French
Elementary

Education

Lorem ipsum dolor sit amet

Diploma (intermediate) · Business Administration

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Onik M.
Onik M.

SAP SuccessFactors & S4HANA Consultant

View Profile
Werner H.
Werner H.

Consultant

View Profile
Lucas M.
Lucas M.

Recruiting, Employer Branding and New Work Consulting

View Profile
Antje M.
Antje M.

Director HR

View Profile
Henning M.
Henning M.

Interim HR Legal Consulting

View Profile
Peter J.
Peter J.

Compensation & Benefits with a focus on occupational pension schemes

View Profile
Hans j. F.
Hans j. F.

Project Lead & Subject Matter Expert

View Profile
Niko W.
Niko W.

Strategic HR & Reward Partner

View Profile
Thorsten K.
Thorsten K.

Freelance Logistics Consultant, Partner

View Profile
Oliver S.
Oliver S.

Interim

View Profile
Marie R.
Marie R.

HR & Compensation Consultant, Fractional VP People

View Profile
Michael W.
Michael W.

Production Manager & Site Manager

View Profile
Claudia M.
Claudia M.

Interim HR Director DACH

View Profile
Andy D.
Andy D.

Founder & Managing Partner

View Profile
Marcel D.
Marcel D.

Software Developer / IT Tester

View Profile
Bertrand L.
Bertrand L.

Business System Analyst - Freelancer

View Profile
Jürgen T.
Jürgen T.

HR Interim Manager

View Profile
Anke F.
Anke F.

Head of People Culture & Places (Interims Project)

View Profile
Britta K.
Britta K.

Sales Development 'Growth Thinker'

View Profile
Katrin C.
Katrin C.

Head of Financial Accounting & Human Resources

View Profile
Inka H.
Inka H.

Interim Manager

View Profile
Bensan S.
Bensan S.

Product Owner, Project Manager, People Partner, HR Business Partner

View Profile
Christina G.
Christina G.

Interim HR Business Partner

View Profile
Janine S.
Janine S.

Owner & HR Interim Manager

View Profile
Tobias T.
Tobias T.

Sales Director / Managing Partner

View Profile
Marina K.
Marina K.

Interim IT Recruiting Project Manager

View Profile
Jürgen W.
Jürgen W.

Business Consultant FI Migration S/4Hana

View Profile
Josef T.
Josef T.

Consultant and Interim Manager in Human Resources

View Profile
Norbert K.
Norbert K.

Interim Senior Manager HR

View Profile
Asta B.
Asta B.

Founder, Facilitator & Consultant

View Profile