Martin Zschirnt - IT Process Consultant, Requirements Engineer and Solution Architect

Q: Where is Martin based?

Martin is based in Aachen, Germany .

Q: What languages does Martin speak?

Martin speaks the following languages: German (Native), English (Advanced), French (Elementary) .

Q: How many years of experience does Martin have?

Martin has at least 39 years of experience. During this time, Martin has worked in at least 2 different roles and for 5 different companies . The average length of individual experience is 2 years and 7 months . Note that Martin may not have shared all experience and actually has more experience.

Q: What companies has Martin worked for in recent years?

In recent years, Martin has worked for Insurance , Pharma , and Insurance company .

Q: Which industries is Martin most experienced in?

Martin is most experienced in industries like Insurance , Banking and Finance , and Pharmaceutical .

Q: Which business areas is Martin most experienced in?

Martin is most experienced in business areas like Information Technology (IT) , Quality Assurance (QA) , and Accounting . Martin also has some experience in Finance , Business Intelligence , and Product Development .

Q: Which industries has Martin worked in recently?

Martin has recently worked in industries like Insurance and Pharmaceutical .

Q: Which business areas has Martin worked in recently?

Martin has recently worked in business areas like Information Technology (IT) , Finance , and Business Intelligence .

Q: What is Martin's education?

Martin attended education in Business Administration .

Recommended expert

Aachen, Germany

Experience

Jan 2023 - Present

3 years 2 months

Düsseldorf, Germany

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 2 months

Düsseldorf, Germany

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Insurance (39 years), Banking and Finance (2 years), and Pharmaceutical (1 year).

Insurance

Banking and Finance

Pharmaceutical

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (37 years), Quality Assurance (16 years), Accounting (11 years), Finance (9 years), Business Intelligence (8 years), and Product Development (4 years).

Information Technology

Quality Assurance

Accounting

Finance

Business Intelligence

Product Development

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

Diploma (intermediate) · Business Administration

Profile

Created

September 2023

Last Update

September 2024

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Martin based?

Martin is based in Aachen, Germany.

What languages does Martin speak?

Martin speaks the following languages: German (Native), English (Advanced), French (Elementary).

How many years of experience does Martin have?

Martin has at least 39 years of experience. During this time, Martin has worked in at least 2 different roles and for 5 different companies. The average length of individual experience is 2 years and 7 months. Note that Martin may not have shared all experience and actually has more experience.

What roles would Martin be best suited for?

Based on recent experience, Martin would be well-suited for roles such as: IT Process Consultant, Requirements Engineer and Solution Architect, Domain Designer and Release Coordinator.

What companies has Martin worked for in recent years?

In recent years, Martin has worked for Insurance, Pharma, and Insurance company.

Which industries is Martin most experienced in?

Martin is most experienced in industries like Insurance, Banking and Finance, and Pharmaceutical.

Which business areas is Martin most experienced in?

Martin is most experienced in business areas like Information Technology (IT), Quality Assurance (QA), and Accounting. Martin also has some experience in Finance, Business Intelligence, and Product Development.

Which industries has Martin worked in recently?

Martin has recently worked in industries like Insurance and Pharmaceutical.

Which business areas has Martin worked in recently?

Martin has recently worked in business areas like Information Technology (IT), Finance, and Business Intelligence.

What is Martin's education?

Martin attended education in Business Administration.

What is the availability of Martin?

Martin is immediately available for suitable projects.

What is the rate of Martin?

Martin's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.