2016 ? 2023: Various Projects
Role: ICT Application Developer (JEE, Legacy), Java Developer
Customer: Informatik Service Center ISC-EJPD
Tasks:
PTTS Dashboard / Feed Project:
- Create a Dashboard Monitoring with Angular.
- The Dashboard including Calendar for user to add the appointments.
- The Dashboard including different Graphical Statistics.
- Loading docx/pdf files from Angular front-end to Spring Boot server and use POI framework to read the docx/pdf files to delete/insert/update Postgres database table data.
- Automation loading updated JIRA tickets from back-end Webservice and use this updated data update the Angular front-end Dashboard/Feed presentation.
Related Projects:
- ZEMIS: Java Application
- DK-Changes: Correct ZEMIS Product database data.
- eGov-eAsyl: Angular / Restful /Spring Boot Application.
- eGov-eRetour: Angular / Restful /Spring Boot Application.
- eGov-eMap: Angular / Restful /Spring Boot Application.
- ZEMIS: The central migration system ZEMIS of the SEM (State Secretariat for Migration). ZEMIS is the personal register for foreign nationals, who live in Switzerland or are staying in Switzerland.
- eAsyl: The asylum procedure.
- eRetour: The asylum return.
- eMap: Managed expulsion and entry ban. in addition, the exchange of information with other Schengen countries.
ZEMIS Application:
- Supported the DK Change team by using PL/SQL to write the codes (Update/Insert/Delete) to correct the data in the production ZEMIS database.
- Writing new feature/functionality (e.g: Daktylo) for ZEMIS Online by automatically sending messages sequentially to clients.
- Responsible for more than 60 ZEMIS Batches.
- Using the Spring Batch framework to create new functionality for ZEMIS Batches.
- Helping Batches bug fixing. Including Selenium Automation tests bug fixing.
- Fixing bugs and managing ZEMIS Integration tests.
- Analyze errors in the Integration-tests and provide feedback to the ZEMIS development team.
- Use ZEMIS as a data center to create test-cases for Regression-Tests and FeatureTests.
eGov Application s (eRetour, eAsyl and eMap)
- Implemented test scenarios using Cypress Automation Testing framework - The tests were end-to-end tests - for testing the GUI front-end developed in Angular.
- Implemented test scenarios using JUnit and REST-Assured for REST API Automation Testing framework to test Spring Boot service back-end.
- Assists the testing team in implementation Regression-Tests and Feature-Tests, analysing bugs and providing feedback to the development team.
- Carrying out clarifications with the Test-Manager and Testers.
- Creating new JIRA tickets for the development team.
- Normally we use ALM as a quality control tool to verify the tests.
Used Products:
Angular, Restful, Spring Boot, Java Application
2008 ? 2016: Various Projects
Tasks:
- Related Projects:
- Meldeverfahren: Java, GWT, J2EE, Webservice, WebLogic Application
- jMessageHandler: Struts, J2EE, Hibernate, Webservices, WebLogic Application.
- IPAS: Java, GWT, J2EE, Webservice, WebLogic Application.
- Infostar: Window Application with Java Swing, WebLogic, MyEclipse.
- M2: Struts / J2EE, WebLogic Application
- Meldeverfahren: Foreign employees from EU/EFTA countries can work in Switzerland for up to 90 working days per calendar year without a permit, but with mandatory registration.
- jMessageHandler: Self-developed communication platform of the ISC-EJPD between the AFIS and EURODAC databases and the authorities issuing the order (Police, GWK, BFM).
- IPAS: The computerized Person Recognition System, File Recognition System and Administration System of the Federal Office of Police.
- Infostar: The electronic Civil Status register.
- M2: Monitornig social assistance stop.
- Meldeverfahren Application : Control Characters (x00-x1F).
- Because the Webservice schema XML files contain the control characters (x00-x1F) ? a typical killer ?. As long as these schema XML files are being loaded for the Online Application, there may be problems with the Online Application.
- Helping analyze the problem and write code by iterating over each field in the schema XML file to remove the control characters (x00-x1F) and rebuilding the XML. It works successfully by loading schema XML to the Online Application.
- jMessageHandler Application: This project includes many interfaces and the main function is to receive the requests from various Webservices and send back the response data (fingerprints, DNA, etc.) by reading the EURODAC database.
- Create a new Webservice (Mides Webservice).
- Use SoapUI to write the test-cases to test the various Webservices.
- Write Unit-Tests to cover the tests from 10% to 80%.
- IPAS Application : Convert Coolgen Application to Java Application by using Java, GWT, J2EE, Webservice, myBatis, JasperReports.
- Write more than 20 new Batches by using Java, MyBatis, Spring Framework, Webservice and Mockito Unit-Test to replace the old Coolgen Batches.
- Supported the team by using Magic Draw to create UML Activity Diagrams and UML Sequence Diagrams for each Batch.
- Write documentation for each batch.
- Prepare test-cases for ALM quality control testing to test each Batch.
- Create new Mock-Webservices (AFIS and IPAS) for Batches to test Webservices data.
- Generate PDF files and Batch reports during the execution of each batch, so that clients can view the result of Batches from Online or download the result of Batches in PDF files.
- Helping GWT Oline Application to correct the design of the PDF files generated by JasperReports according to the requirement of clients.
- Helping bug fixing for GWT Oline Application.
- Add new functionality for GWT Online Application.
- Infostar Application : Convert Coolgen (Window Application ) to Java Application .
- There is a converter called SoFa to convert the Coolgen codes to Java codes, but Online Application and Batches run very slowly. I'm rewriting about 1000 SQL queries to improve performance. This means that Online Application and Batches are running very quickly after fixing the SQL queries.
- Correct the design and texts of more than 100 Online electronic documents/certificates: marriage certificate, birth certificate, civil rights certificate, etc.
- Assisting customers in creating 2 new complicated Online electronic documents/certificates: Proof of civil rights and proof of name (Bürgerrechtsnachweis und Namensnachweis). ? Through JAVA.
- M2 Application : Convert old Coolgen Application to new Java Application .
- Using Java codes and Struts framework to replace an old Application written with Coolgen codes. The clients are very satisfied because they don't believe that we can create a successful Web-Application using the Java and Struts framework. Because the Struts Framework is quite new for ISC-EJPD at that time. And the clients invited our development team to an aperitif. At that time, I am still an external employee. (Year 2008).
- The technical project lead who works on the server side as he is an EJB expert.
- I work on the Struts site because I am a Struts expert.
Used Products:
Struts, GWT (Google Web Toolkit), Java Swing, J2EE, Webservice Application
08/2006 ? 09/2007: Internation Programm System
Role: IPS Expert/Progarmmer
Customer: Zürich Financial Service (ZFS)
Tasks:
- Responsible for IPS (International Program System) Team
- 3th Level Support for the Application
- Consulting and helping ZFS IT to create the Business Specification
- IPS (International Program System) is a complex Java Swing GUI/Window Insurance Application, is a hug System and was generated by many Java Software Developers.
- This GUI/Window Application is made by Client/Server, RMI, Eclipse, Java, Java Swing, XML/XSD/XSL/XSLT, TopLink, Actuate9(eSpreadSheet/Import/Export), Ant-Build, DB2 (DB2 tables are more than you can imagine), AIX Unix Server, CVS, VSS, UML Enterprise Architect (EA).
12/2005 ? 07/2006: Pandora Project: J2EE Web-Application
Role: Senior Application Architect (Designer/ Programmer Analyst)
Customer: Zürich Financial Service (ZFS)
Tasks:
- Responsible for Pandora Plattform Application
- 3th Level Support for the Application
- Pandora Plattform has more than 20 Online-Forms (one Form is one specific project):
- Contact Form
- AdressAenderung Form
- Baugarantie Form
- BaugarantieMitteilung Form
- BroschuerenBest Form
- Eclaims Form
- Kontak Form
- Mfschaden Form
- Netorder Form
- OffertAnfrage Form
- Vita Form
- etc.
- This Web-Application is made by Eclipse, Java, JavaMail, J2EE, EJB, Struts, JUnit, Digester, XML/Schema, Ant-Build, Tomcat, JBoss, CORBA, EJB, DB2, CVS, VSS
2001 ? 2005: Electronic Document Delivery System Project
Role: Analyst/Programmer & Software Developer (Software Engineer /Internet Designer)
Customer: Thomson Corporation Switzerland AG Dialog/DataStar, Bern
Tasks:
Electronic Document Delivery System Project: Working on a complex multifunctional DataStar EDDS (Electronic Document Delivery System) (7/24 service)
- Selecting the data in compressed format from the DB2 tables (including customer ordered alert documents from DataStar CICS search engine) and creating the ASCII decompressed alert documents to insert into IBM DB2 tables.
- Modifying and copying data from IBM DB2 to Sun Solaris Oracle tables.
- By using Borland JBuilder6/GUI-Applications program created an EDDS monitor for the AVOR.
- EDDS-JavaBean integrated into EDDS-Monitor, which converts the alert documents into ASCII/HTML/PDF format (HTML and PDF format can also include image links and eLinks) and sends them to scientist?/customers' email addresses using JavaMail. Such an email can contain thousands of documents (in INLINE or ATTACHMENT) with more than 50MB. In the event of an error or warning, AVOR is informed immediately by email/SMS. This project was built using DSL (DataStar Language), C, ASM, DB2 Table, DB2 Batch Load Utilities, PLATINUM, Oracle Table, LDAP, Borland JBuilder6, JAVA, AWT/Swing, JavaMail, Unix/Sun Solaris Server and Email Server be completed. The result is that on the year 2001 by using the old Delivery System, the statistics shows that the total documents sent to the customers/scientist per month is about 32,000 documents. After the EDDS launches to the market, it increases rapidly to more than 20%. On February 2005 the total documents sent to the customers/scientist is more than 700,000 per month, and can imagine that it can reach 1 million documents per month.
1998 - 2001: Various Projects
Role: Analyst / Programmer / Software Developer
Customer: Dialog, A Thomson Company, Bern
Tasks:
1999 - 2000: Journal Name Finder project
- Select the Journal Names and ISSNs from the more than 400 DataStar databases which may contain the Journal Names/ISSNs to create a complete new DataStar Journal Name Finder online database (JOUR).
- By using this online database the customers do not need to search the journal name or ISSN from more than 400 DataStar databases, and can immediately know which DataStar databases may contain the journal names and issns. It saves a lot time for the customers for searching.
- Journal Name Finder consists of about 50 processes. It is an automatical system and merging the new data to the old data every day automatically.
1999 - 1999: Y2K Conversion System
- Generate a magic Y2K Conversion System to convert more than 400 DataStar databases.
- Before year 2000 all databases are converted on time.
- I also solved the Y2K problem for all the Delivery Systems and helping the TradStat Department (Trading Statistic Database Product) to solve the Y2K problem.
1997 - 1998: DataStar Delivery System
Tasks:
- Using C, ASM and APPC-LU6.2 (communication interface programming) to create a new Delivery System to replace the old one which was written by COBOL, and adding Lotus Notes format for customers.
- The function of this system is to select the data from the Datastar online DB2 distribution tables and generate different types of alerts documents (DataStar databases information) to delivery to the customers in the formats of Paper Printer, DataMail, FAX, X400, Internet and Lotus Notes
1994 - 1997: DataStar Data Center Project
Role: Analyst / Programmer / Software Developer
Customer: Knight-Ridder Information AG, Bern
Tasks:
- Use C to regenerate a large DataStar Data Center (7 terabyte (TB) data center - bycompressing data before storing it in the VSAM Data Center) to replace the old DataStar Data Center generated by Cobol.
- Creation of all VSAM utilities and jobs/JCLs for DataStar Data Center:
- Batch Loading
- Batch Merging
- Batch Deleting
- Online Merging
- Online Replacing
- Online Reorganizing und Online Automatic Updating
1994 - 1994: Tradstat Import/Export Reports Project
Tasks:
I used WATCOM-VX-REXX/GUI-Applications-Programs APPC-LU6.2, OS2 and DB2 tables to realize this project.
- Report Generator: Creation of Text formats and Excel Import/Export Report Formats for PC users.
- Floppy Disk Extractor: Loads the Tradstat reports from the HOST onto PC floppy disks through an APPC-LU6.2 Interface.
- Worldwide administration: Uploads Tradstat information from HOST to the user platform through an APPC-LU6.2 interface.
1989 - 1994: Custom Projects
Role: Third Party Analyst / Programmer / Software Developer
Customer: Radio Switzerland AG, Bern
Tasks:
durch den Einsatz von Sprachen WATCOM-VX-C, OS2, VIDEOTEXT-ASM, ASM, COBOL, REXX, APPC-LU6.2, C und DB2 Tabellen.
- (1994-1994) Online Banking - Switzerland Invoice Paymaker/Online Banking
- (1993-1993) SBB Railroad Ticketing System.
- (1992-1992) ELVIA Insurance.
- (1991-1991) Switzerland Sports Results.
- (1990-1991) Switzerland Car Catalogue System.
- (1989-1989) Switzerland Snow Report.
1979 - 1989: Mail Distribution
Customer: Northern Virginia, USA
Tasks:
- Mail Distribution at the Post Office Headquarters, VA, USA
- Manager at Maylai Import in the Chinese furniture industry
- Cashier at the Gas Station
1978 - 1979: Mehrere Projekte
Customer: Kowloon, Hongkong
Tasks:
- Watch Assembler at Longin in the Watchmaking Industry
- Workers in the Paper Industry