Martin Zschirnt
IT services
Experience
Jan 2023 - Jun 2023
6 monthsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Migration of movement data in commission accounting starting from various proprietary IBM mainframe systems to the target SAP ICM application.
- Planning, implementation, and quality assurance of a batch process for data migration on different mainframe platforms from test to production.
Jan 2022 - Jun 2023
1 year 6 monthsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Development of a complex Excel automation solution to calculate salesforce reappointment levels based on annual production figures and many other parameters.
- Multi-year analysis of appointments and simulation procedures.
Jan 2022 - Dec 2022
1 yearDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Development of a mass business transaction for restructuring an organizational hierarchy.
- Automated SAP export, complex VBA-based Excel frontend for data editing and validation, and automated SAP import.
Jan 2021 - Dec 2022
2 yearsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Backend design and development using IBM mainframe, COBOL, DB2, SQL to supply data for a web application in the insurance field.
Jan 2021 - Dec 2021
1 yearBerlin, Germany
Lorem ipsum dolor sit amet
Pharma
- Design and development of an Excel tool in VBA for the pharmaceutical sales/trade security area to reconcile CRM customer and order data.
- Automated invoice sending via MS Outlook.
Jan 2020 - Dec 2021
2 yearsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Development of complex Excel frontends in VBA for data maintenance and cleanup in organizational and sales structures before a migration.
- Conceptual design with business users, implementation, and testing.
Jan 2018 - Dec 2020
3 yearsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Development of a test automation workflow using Excel VBA, UFT, and HP ALM to test SAP applications, mainly modules OM, BP, and ICM.
Jan 2013 - Dec 2014
2 yearsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Test automation with Excel VBA for test series evaluation and regression test comparison.
- Development of a procedure for test data provisioning from business description to result presentation.
- Data migration and operational switch of the field staff management system to a new sales structure.
- Development of a Microsoft Office solution (Excel, Access, Outlook) to capture migration data for about 60,000 field staff and provide it for data migration on an IBM mainframe.
Jan 2012 - Dec 2012
1 yearCologne, Germany
Lorem ipsum dolor sit amet
Insurance
- Migration of health insurance using an ETL tool for technical implementation of the migration process.
- Design, development, and implementation of business migration rules.
Jan 2008 - Dec 2018
11 yearsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Insurance
- Large project for an insurance group to implement SAP OM and SAP BP replacing the proprietary mainframe application for managing sales and organizational structure.
- Support and organization of required interface transformations.
- Design and implementation of test procedures and automation for SAP OM and SAP BP.
- Role as IT process consultant, requirements engineer, and solution architect.
- Data warehouse for qualifying and quantifying incoming mail, business processes, and outgoing mail as a decision basis for management.
- Design and development of ETL processes to neutralize heterogeneous transaction data in the system of record for contract, claims/service, and application areas in property-casualty, life, and health lines.
Jan 2007 - Dec 2008
2 yearsSaarbrücken, Germany
Lorem ipsum dolor sit amet
Insurance
- Migration of health insurance in a portfolio merger.
- Design, development, and implementation of business migration rules, planning and development of data center processes.
Jan 2007 - Dec 2007
1 yearHamburg, Germany
Lorem ipsum dolor sit amet
Insurance
- Upgrade of Content Manager (optical archive) from version 7 to 8.3.
- Migration of document references to the new format.
Jan 2007 - Dec 2007
1 yearAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Competence center for motor insurance: design and execution of business requests for IT, release change planning.
Jan 2006 - Dec 2006
1 yearAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Support of two large projects for restructuring the sales organization.
- In the property-casualty/motor subproject.
- Development of business and technical migration concepts for portfolio relocation of motor insurance according to a new sales structure.
- Business concept in transaction management.
- Development of Office tools to support test coordination in large projects.
Jan 2005 - Dec 2005
1 yearAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Competence center for motor insurance: design and execution 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 IP.Suite modeling tool.
- Role as business designer and release coordinator.
Jan 2004 - Dec 2004
1 yearHamburg, Germany
Lorem ipsum dolor sit amet
Insurance
- Transaction modeling for motor insurance in connection with integration into a corporate-wide transaction system.
- Assessment and migration of all related transaction data into a corporate-wide transaction system.
- Development of a technical concept for archiving historical and canceled policy states of the motor insurance portfolio.
- Design and implementation of the initial population of the corporate data warehouse with motor insurance portfolio data.
Jan 2003 - Dec 2003
1 yearHamburg, 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, assessment, and migration of all related transaction data into a corporate-wide transaction system.
- Migration of transaction and schedule data of a multi-client corporate partner system into a new, unified environment.
- Development of a parameterizable and reusable migration procedure for future projects.
Jan 2002 - Dec 2002
1 yearAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Development of a solution for automated monitoring of batch productions on an IBM mainframe.
- Development of a solution for automated fax transmission control.
- Import and reconciliation of all relevant data in MS Excel using VBA.
- Operations of a document creation system.
- Validation and control of daily production on an IBM mainframe.
- Development of tools for automated verification of daily processes.
- Support and maintenance of systems for transaction and schedule management.
- Migration of the technical insurance lines, commercial individual and group accident insurance, and transport insurance into a new contract management system reusing the 1998–2001 migration process.
- Development of dialog modules and functional blocks of the contract management system.
Jan 2001 - Dec 2001
1 yearAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Business analysis of existing insurance products in commercial electronics and construction insurance.
- Implementation of product definition rules for parameterizing a new contract management system.
Jan 1998 - Dec 2001
4 yearsAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Implementation of a corporate contract data management system to store contracts for private and commercial property, accident, and liability insurance.
- Development of a cross-line migration process from business rule design to technical implementation.
- Programming of a rule compiler to generate COBOL migration code.
- Development of dialog modules and functional blocks of the contract management system.
Jan 1995 - Dec 1998
4 yearsAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Implementation of a partner data management system of a corporate entity in another corporate IT landscape.
- Business concept for integration into the existing application landscape and specification of interfaces to existing systems.
- Development of a migration procedure for legacy system data.
- Stepwise integration of partner data management into all policy-holding systems.
- Development of a dialog middleware and a transformation layer to manage communication between various user systems and the partner application.
- Data modeling, capacity planning, and implementation of data storage.
- Final application tuning mainly by performance analysis and optimization of data retrieval.
Jan 1994 - Dec 1995
2 yearsCologne, Germany
Lorem ipsum dolor sit amet
Bank
- Development of a procedure to copy database objects and their contents into any target environments via batch with dynamic SQL.
Jan 1991 - Dec 1994
4 yearsCologne, Germany
Lorem ipsum dolor sit amet
Insurance
- Implementation of the commission procedure from 1989–1990 for another client.
- Enhancement of the procedure, adaptation of client-specific employee management and compensation.
- Integration of field sales compensation with portfolio-maintenance commission.
- Integration of a report for balance sheet presentation of outstanding commission volume.
Jan 1990 - Dec 1991
2 yearsMunich, Germany
Lorem ipsum dolor sit amet
Insurance
- Design to determine, report, and accrue outstanding commission amounts.
- Data modeling, capacity planning, implementation, and administration of data storage.
- Programming of all dialog and batch components.
Jan 1989 - Dec 1990
2 yearsMunich, Germany
Lorem ipsum dolor sit amet
Insurance
- Business redesign of a multi-client, cross-line procedure for commission accounting, commission calculation, and employee management with dialog-driven 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 yearsAachen, Germany
Lorem ipsum dolor sit amet
Insurance
- Maintenance and enhancement of a system for commission accounting, commission calculation, and employee management.
- Programming of dialog and billing components, management of batch production.
Languages
German
NativeEnglish
AdvancedFrench
Elementary Education
Lorem ipsum dolor sit amet
High school diploma · General university entrance qualification
Lorem ipsum dolor sit amet
Intermediate diploma · Business Administration
Lorem ipsum dolor sit amet
IT specialist · Computer Science
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
