Christian Lohmann Hebelstr. 19a 79618 Rheinfelden, Germany phone: +49 (7623) 748432 mobilphone: +49 (178) L-O-H-M-A-N-N eMail: cl@christian-lohmann.de homepage: www.christian-lohmann.de

Capabilities and Knowledge

• process know how in pharmaceutic industry and aerospace
• conceptual working, consulting, coaching and teaching
• customer focus
• basic knowledge in accounting and controlling
• deep knowledge in logistic area (production, warehouse, laboratory)
• project planning and controlling
• knowledge of change management and CSV
• wide knowledge of SAP R/3 (functional and technical)
• database design and implementation (Oracle, MS-SQL, MS-Access)
• program design and implementation (Object-oriented, ABAP, C/C++, JAVA, Visual Basic, SQL)
• knowledge of network infrastructure (WAN/LAN)
• knowledge of basic internet techniques

Targets

• contact to the customer
• membership in international SAP projects
• project work with a team
• leading a team / project
• design and implementation
• some traveling
  

since 08/2002 Novartis AG, Basel

• Senior Business Analyst Operations, member of the logistic team inside the CORE-management. Maintenance of change requests.
• Creating a rough cut prototype for warehouse management and the integration into the production. Location: Sasayama, Japan.
• Supporting during implementation phase
  • Creation of concepts during blue-print-phase
  • Execution the customizing for LE-WM
  • Documentation (Object descriptions, config-log)
  • Creation of functional specification for Add-ons, user-exits and SAP Scripts
  • Creation of concept and func.spec for an existing MES (via PI-PCS, tRFC)
  • Crosscheck of design specifications; support during debugging and fixing
  • Crosscheck of test specifications
  • Performing tests
  • Implementation of some programs (incl. specification and test specs)
  • Support for other modules MM, PP and external systems (QDIS, MES)
  • Raising change requests in case of required changes in CORE-system
  • Checking the conformity of the system against rules defined by CORE
• 01/05/2004: GoLive; After-GoLive-Support; training for future support team member
• Supporting the planning phase of a MES-implementation project (SAMURAI) in Japan
• Supporting a CORE-upgrade-project for the PEP-System in Japan
• 07/2004 - 12/2004: supporting ChemOps and PharmOps site in Basel, Swiss
  • several enhancements for production planning, manufacturing executions and batch management e.g. shipping under quarantaine, MRP planning run enhancements, MRP overview
• since 01/2005: Account Manager & SPOC for ChemOps inside SISNet Europe
  • acting as "Single Point Of Contact" to the customer
  • coordinating the workload inside SISNet for the customer cross team
  • budget control
• since 01/2005: Teamleader for WM-Team
  • leading the WM team which is responsible for providing second & third level support on European clients like Spain, France, Germany, Swiss
  • providing 3rd-level-support for local SISNet's
  • setup/maintain a best practice sharing platform
  • participate on several simplification projects to optimize SISNet internal procedures
  • coordinating external team member for warehouse support
  • tracking time recording and performing invoice verification for external team member
• Project leader for an warehouse insourcing project (from a 3rd-party distributor into the warehouse in Stein, Swiss)
  • preparing timeline
  • planing project organisation
  • budget controlling
  • prepare and conduct steering comitee & acceptance team meetings
  • project tracking
  • project went live one month before planned date (in-time & in-quality)
• since 11/2005: Teammember for QM-Team (Project LI@N)
  • analysis user requirment for calibration of lab-equipment and environmental monitoring
  • supporting business experts in creation of business scenarios
  • collecting user requirements
  • setup a rough-cut-prototype

since 06/2001 Fairchild Dornier GmbH

• business application manager, team leader in a running SAP project implementing SAP R/3 4.6C2 A&D for customer support, covering world-wide planning, warehouse, sales and procurement of spare parts for the aircraft of Fairchild Dornier. The MRO process includes sub contracting for external and internal repair procedures. Active components are SD, MM, PP, LE, QM and IM.
• based on industrial solution SAP R/3 4.6C2 Aerospace & Defense
• coordinating both plant Oberpfaffenhofen and San Antonio, TX, US
• big goal: common processes and one system setting
• project coordination
• analyzing and implementing of the planning module (consumption based planning)
• analyzing and implementing of a first simple cross company business
• analyzing and implementing of a release strategy for purchase requisitions
• analyzing and implementing of several user exits for goods movement and material planning
• implementing a report to analyze actual repair coast per aircraft
• implementing a report to analyze materials movement
• activating batch mngt. for all material master in a productive plant inside R/3
• end user support and project work for four month in San Antonio, TX

04/1998 to 05/2001, Haupt Pharma Wolfratshausen GmbH (a pharmaceutic company)

• Initial project setup for EURO conversion project; preselection external support resources
• preparing in the methods of validating of computer systems in pharmaceutic business
• successfully attend a certification course TAPP40 production planning (November/December 2000)
• initial project setup for release change to 4.6C
• planning and handling release change from 3.1H to 3.1I
• support for the end-user in production, planning and quality mngt.
• maintain the SAP system (incl. monitoring, system performance, data backup, database maintainance); optimizing the system
• connecting other sites via CISCO-Router; integrating the router in the network
• Go-Live at 12/13/1999
• Since 9/1/1999 head of IT department; responsible for all IT systems; leading the department with seven employees; budget planning for FY 2000. Supporting the Y2K-Team implementing test methods
• Assistant project leader for the implementation of the logistic modules (MM, SD, PP-PI, WM); this includes the preparation for the decision to use SAP in the future, preselecting the external consultant company, time- and budget controlling and the most important thing: conceptual work for integration
• Team leader for PP-PI: this includes the interviews, writing the concepts, doing the customizing and implementing ABAP/4-programs;
  in the first step we are using the plan recipes, plan orders, process orders, process coordination with control recipes and a planing mechanism.
  SAP-Scipt-formular
• Implementing an user-exit for a special pharmaceutic calculation (activity balance)
• Team leader QM: creating a really small QM-customizing to connect R/3 to an external LIMS-System (SQL*LIMS , PerkinElmer). This includes the creation of small inspection plans
• Team leader software-developing
  • userexit for an special calculation inside the process order to handle the lot-specific potency of raw materials
  • userexit for an special batch determination function (depending on data be stored in the classification)
  • planing and implementing an interface to our external  weighting system (written in C++ running under Windows NT). This interface is using the PI-PCS specification from SAP
• Implementation of a smal transaction for "Rückmeldung" using the same way a the interface to the external weighting system
• Coordination and doing of some modifications in the R/3 system
• Writing the batch-input for the converting and importing of the old database
• Administrator for the developing system (RS/6000 under AIX 4.3; Oracle 7.3.3, SAP 3.1H and 4.0B); both UNIX and SAP; this includes the installation of SAP 3.1H and 4.0B, enable the printer-queues, doing the backup (using the standard tool sapdba), managing the transports between the systems (via tp), doing some performance-watching
• Administrator for the integration machine (alpha server 800 under DEC UNIX; Oracle 7.3.3, SAP 3.1H); both UNIX and SAP
• Administrator for a small intranet-server which is running as a project information system (LINUX, SAMBA, apache, qmail)
• Supervising my colleagues in the different teams for there work and review the results
• Planing and doing the migration of the bill-of-material and recipes from the former system and implementing the special batch-inputs
• developing an interface (in C++ running under AIX 4.3 on RS/6000) to connect R/3 to a weight-measure-system (via interface PI-PCS)
• Migration of resources via CATT (in case of small amount of data)
• R/3 Courses:
  • BC325 - Workbench Organizer
  • BC410 - Transaction with ABAP
  • * BC411 - advanced ABAP
  • BC??? - Classification
  • DELTA-PI    Delta for PP-PI 3.x to 4.x
  • LO310 - detailed functions in PI
  • LO315 - process coordination
• Since 04/1999 I was also the (temporary) head of the iS-deparment.

04/1997 to 03/1998, Condat GmbH (consulting company)

• Developing several RFC-enabled function modules, which were called by an external system.The first function module was for reading a customer-specific table and to transfer the containing data to the subsystem. The second event was a function module which retrieve filtered customer address information from R/3 and transmitted the result to an external sales-information-system. For the same project I wrote a function module to read the sales data and transferred them also to the subsystem. My tasks were both in SAP to implement the ABAP and on the other side the corresponding communication DLL (written with C/C++ for MS-Windows).
• Developing an external system which sends Standard-IDoc to R/3 containing the weight of packages. The packages were identified through a bar-code which contains the order number. The subsystem collects the data (order number and weight) and send they to R/3 (via transactional RFC). Utilizing the user-exit to put the weight in the correct order using call transaction
• Customizing for this IDoc project, like definitions for partners, ports, logical systems etc. to establish the communication
• End-User training for the customer to use this system.
• Writing the documentation for these projects with MS-Word containing the conceptual basics and the way of implementation. Additional comments were placed in the sources of the programs.
• OSS: Analyze of problems; researching in OSS for existing solutions and / or reporting a problem to SAP
• For a project I used the data modeler to create a data model. I generated the resulting data elements and tables in the data dictionary using the Workbench (SE80) as root for all my work.
• Creating dynpros for this tables using the screen painter and assigned to a transaction codes
• Creating batch-input-program using the batch input sessions to fill the created tables
• Connecting an external human resource application (Taylorix) to the cost centers of R/3 using a standard batch input program to transfer costs between the cost centers
• R/3 Courses:
  • BC400 - Basic of ABAP/4 Programming (5-day-course)
  • PA??? - BAPI (3-day-course, in English language)
  • special in-house training for IDoc (one day)
• Developing client server application (Oracle 7.x / Centura TeamDeveloper)

02/1996 to 04/1997, Heinz Haupt GmbH & Co. KG (pharmaceutic company)

• Continue the developing of an existing software
• Maintaining leas-contracts and credit-overviews
• Evaluating the different data for the management, building a reporting system
• Member of the new founded SAP-Team (four persons all together); my tasks in this project were:
  • Specifying the As-Is and the To-Be for the company
  • Conceptual work and customizing for AM
  • Extracting and converting the old data and put them via FTP to the unix-server for the standard batch input program
  • Supporting the project leader in customizing FI
  • Supporting the project leader in customizing CO (cost center, internal orders)
  • The customizing was done by using both the IMG and the specific transaction codes
• R/3 Course: for this project I was trained by a  specific three-day-course for FI/AM and CO containing the basics for the customizing at  Plaut GmbH, near Munich, Germany; after that by reading the documentation or asking our project leader (he had more experiences). The project was not supported by an external company (only to buy the software and setup the system).
• In-House-training for my colleagues (done as training on the job)
• After my first (self-trained) ABAP-experiences my wrote an interface via a report between FI and the existing software system to exchange data from (pre-collected) incoming invoices (i.e. material prices; using the order numbers as reference) to the existing external system. Each day a file was written and transferred via FTP to the outside.

04/1992 to 03/1996, Fachhochschule fuer Wirtschaft, student

• Study of economy with specialization in business taxes and computer science.
• In my diploma I wrote about an object-orientated design and implementation of a rulebased expertsystem. For the design I used the method of Coad/Yourdon and I implemented the system with MS Visual C++ running under MS Windows NT as an OLE-control. The knowledge base covers parts of our value-added tax (VAT, e.g. Umsatzsteuer). The rules were stored in a small database and loaded into the system on demand.
• At the same time I worked as a freelancer. I supported my previous employer in a project for a company in the pharmaceutic industry. The result was a client-server application for the production planing, material management and sales. The application based on MS SQL Server (as back end with triggers and stored procedures) and MS Access (as front-end). My tasks in the project were analysis, data modeling and implementation.

• Developing systems to control something (automation)
• Developing network products
• Programming languages: C, Assembler M68000, Z80
• Customer support for this products

Education

04/1992 to 03/1996 Study at the Fachhochschule fuer Wirtschaft Berlin;  completed as "Diplom-Kaufmann (FH)"

02/1987 to 03/1989 vocational at Lette-Verein Berlin (technical education);  completed as "Technischer Assistent Elektonik/ Datentechnik"

09/1983 to 12/1986 Gymnasium;  completed with "Abitur" (qualifying for university entrance)

09/1979 to 08/1983 Realschule; completed with "Mittlere Reife"

09/1974 to 08/1979 Grundschule

Languages: German (as my native language)
English (many years in school)

Self trained in UNIX: setting up a linux-based server for by private network as print server, file server, www-server; connecting my private ethernet-network via ISDN to the internet

Self trained knowledge of JAVA