German Popken - Microsoft BI Specialist

Colle Diana, Italy

Experience

Jul 2022 - Present

3 years 1 month

Germany

Microsoft BI Specialist

HELABA

HELABA started developing its credit risk management in the early 2000s as a client-server application with a SQL Server back end and an MS Access front end. Over 15 years it grew into a software giant with more than a million lines of code. German joined the BI team to maintain the existing system and build a new, modern front end. After modeling the application and adding a debug code trail, he could quickly analyze and resolve open issues and extend back-end functionality and the various front ends (MS Access, Excel, Word, each half a million lines of code in complex object-oriented design patterns).
He quickly became known as an all-round troubleshooter for MS Office and VBA issues. In the meantime, he co-developed the new C#.NET front end for the credit risk management application, including peripheral tooling in VB.NET. He built many other databases and full applications, for example an HR reporting database based on SAP data. He wrote Python and R scripts for detailed statistical analysis of operational risk data.
He currently develops new requirements for the credit risk and operational risk application systems.
Department: HELABA / BI Team, Developer.
Tools: SQL Server 2008 R2 to 2019, SQL, VBA, .NET Framework, C#, VB, WPF, XAML, MVVM, Infragistics, Entity Framework, Jenkins, Visual Studio, SSIS, SSRS, SSAS, Python, R, Tortoise SVN, HP ALM, CA Harvest Software Change Manager, CMM, Redgate SQL Toolbelt, ITSM, Bitbucket.
Skills: Credit/operational risk management, business information analysis, DWH design/build, ETL, object-oriented design/development, debugging, data quality, database performance tuning, IT system management.

May 2022 - Sep 2024

2 years 5 months

Germany

Microsoft BI Specialist

DB Netz AG

Team NeMo designs, builds, and manages the Netzmonitor data warehouse for Deutsche Bahn. This DWH stores rail network data for planning, usage, and monitoring.
The DWH has separate warehouses for staging, core, and marts by year and topic. The warehouses are optimized for big data and connected to about 30 source systems.
For the new "Capacity Management" program, the team was reorganized, and extra hands were needed to reach its goals, so German joined.
He implemented several agile stories, such as adding geographic imagery to rail objects (networks, divisions, regions, track sections, operation points) and building a data mart with many new source system interfaces. Most recently, he refactored and optimized the GDF-Z interface in pair programming.
Department: Capacity Management Program / NeMo Team, Developer.
Tools: SQL Server 2016/2019, SQL, C#, Visual Studio 2019, SSIS, Git, GitLab, ReadyAPI, Groovy, Python.
Skills: Rail infrastructure, complex ETL for large datasets, testing.

Mar 2018 - Dec 2021

3 years 10 months

Germany

Microsoft BI Specialist

HELABA

HELABA started developing its credit risk management in the early 2000s as a client-server application with a SQL Server back end and an MS Access front end. Over 15 years it grew into a software giant with more than a million lines of code. German joined the BI team to maintain the existing system and build a new, modern front end. After modeling the application and adding a debug code trail, he could quickly analyze and resolve open issues and extend back-end functionality and the various front ends (MS Access, Excel, Word, each half a million lines of code in complex object-oriented design patterns).
He quickly became known as an all-round troubleshooter for MS Office and VBA issues. In the meantime, he co-developed the new C#.NET front end for the credit risk management application, including peripheral tooling in VB.NET. He built many other databases and full applications, for example an HR reporting database based on SAP data. He wrote Python and R scripts for detailed statistical analysis of operational risk data.
Department: HELABA / BI Team, Developer.
Tools: SQL Server 2008 R2 to 2019, SQL, VBA, .NET Framework, C#, VB, WPF, XAML, MVVM, Infragistics, Entity Framework, Jenkins, Visual Studio, SSIS, SSRS, SSAS, Python, R, Tortoise SVN, HP ALM, CA Harvest Software Change Manager, CMM, Redgate SQL Toolbelt, ITSM, Bitbucket.
Skills: Credit/operational risk management, business information analysis, DWH design/build, ETL, object-oriented design/development, debugging, data quality, database performance tuning, IT system management.

Sep 2016 - Feb 2018

1 year 6 months

Business Information Analyst

AEGON

Aegon launched an improvement project in early 2016. German joined in September. After mapping the current situation and training the team in agile methods, he led a separate analysis phase to identify all business and data requirements. About 4,000 data fields and 10,000 lines of SQL code were documented and analyzed (technical and business). Meanwhile he designed a relational data model, which due to data quality issues was soon replaced by a Data Vault model. The SQL Server 2008 R2 instance was replaced by a new Azure SQL DB (OTAP) with a four-layer DWH solution (Landing Zone, Control Tables, Data Vault, Data Marts) and an SSRS/Power BI front end. He built an Azure Functions front end usable on iPads. German designed and built the DWH structure, all SQL statements, stored procedures, SSIS packages, and SSRS reports. He wrote Python and R scripts for detailed statistical analysis of source data.
He also served as Scrum Master, mentored an intern (PDF scraping with PowerShell), and led a four-member technical team.
Department: Aegon Finance / Master Service.
Tools: SQL Server 2008 R2, Azure SQL DB, Azure SQL DWH, Power BI, Azure Functions, SQL Server 2016, PowerShell, VSTS, Visual Studio, SSIS, SSRS, Python, R.
Skills: Mortgages, business information analysis, DWH design/build, ETL, Agile SCRUM.

Dec 2014 - Jun 2016

1 year 7 months

SQL Server Database Administrator

ING

The Master Control Room is ING's command center, ensuring all systems and controlling global data processing.
German is responsible for timely resolution of infrastructure incidents, problems, and interactions in SQL Server, Windows Server, and Sybase ASE. He also developed reports (HPSC-DWH source) to provide insight into the SOS team's performance and built a time-tracking application in Excel/Access/VBA.
Department: Master Control Room, Senior Operational Support Officer.
Tools: SQL Server 2000–2012, Windows Server 2000–2012 (Core), PowerShell, TSM, HPSC, Excel, Access, VBA, Sybase ASE, RHEL7, VMware vSphere, Oracle 11, IIS, Citrix XenApp, XenDesktop, SCOM, SCCM.

Mar 2014 - Jul 2014

5 months

Business Information Analyst/BPM

APG

The BI department had just been formed and reorganized; management and maintenance processes were unclear.
German analyzed and mapped the business processes. He involved staff and managers through intensive workshops. The processes were divided into technical, functional, and operational management.
Department: BI Department.
Tools: BI, ETL, data quality, Cognos, workshops, ITIL, ASL.

Feb 2014 - Jul 2014

6 months

QA Manager / Scrum Master

APG

The BUI program was part of the “Controlled Change” portfolio and had yet to start. The BI department had no project experience. The program scope included a new architecture with new hardware, a new DWH, new ETL layer, new reporting tools, new reports, new KPIs, and new agile methodology.
German wrote the program plan in detail, then led requirements management. As QA manager he identified progress issues and helped find solutions through workshops or his technical expertise.
He drafted the biweekly program report and aligned it with project managers and the program manager.
As Scrum Master, German taught BI staff agile principles, the Scrum method, and Scrum tools like daily stand-ups and Scrum boards.
His work resulted in a well-running BI program with clear scope control and a good working atmosphere.
Department: BI Program.
Tools: PRINCE2, Scrum, brown paper sessions, workshops.

Dec 2013 - Jul 2014

8 months

QA Manager / Technical Specialist (EPM)

APG

The “Controlled Change” portfolio aimed to reorganize APG. It included workforce programs, new financial processes, and a redesigned BI architecture. Another component was an ongoing EPM implementation. German ran quality assurance for this portfolio and helped shape portfolio management. He also participated in the EPM implementation, offering technical advice on emerging questions and helping design timelines in EPM and SAP CATS as well as reports in SAP BI and SAP FICO. He developed a portfolio KPI dashboard, a portfolio registry tool, and an APG-wide portfolio management annual cycle.
Department: “Controlled Change” Portfolio.
Tools: Excel/VBA, VB.NET, SAP CATS, SAP BI, SAP FICO, PL/SQL, interviews, brown paper sessions.

Dec 2011 - Dec 2014

2 years 1 month

Project Manager / Implementation Specialist / Technical Specialist (EPM) / Business Information Analyst-BPM / BI Developer

ABNAMRO

After German completed the situation analysis, he wrote a project proposal with two options: 1) develop an MS Access application; 2) implement EPM. ABN AMRO chose the second. German led project kickoff, secured approvals from the IT architecture committee, IT security, procurement, and internal audit. He authored the project charter, PID, and detailed plans, and led a team of three. Later he focused on technical solutions and took on the lead architect role. He organized EPM hosting and vendor management with Microsoft, Perrit, freelancers, and CGI. German managed requirements on behalf of the model management chain’s four departments. He configured MS Project, Project Server, SharePoint, SQL Server, SSRS, and SharePoint Server. He handled stakeholder management with departments, internal audit, the Dutch central bank, and other parties. German was the solution visionary, handled design details, and aligned use cases with users. He proposed integrated datasets, solved data quality issues, and organized data ownership. He ran DTS tool management and trained functional managers. Organizationally, he designed new chain processes around the new tool in ARIS and implemented them. He built 100+ management reports and a custom data warehouse with a SQL Server sync mechanism.
He also developed custom MS Project functions for usability and trained users and admins. The initial improvement areas from internal audit and the Dutch central bank were solved with the Microsoft EPM solution across the entire model management chain. All 160 concurrent modeling projects were implemented, including static and dynamic data for all financial models. German made extensive EPM customizations with SharePoint sites, MS Project functions, and 100+ custom reports, and organized functional and technical management. Many EPM issues were resolved with the hosting partner and Microsoft MVPs in Portugal. Finally, German produced 30 training videos for end users and admins.
Department: COO/Functions/Model Management – EPM Implementation.
Tools: MS EPM, Project Server, SharePoint Server, SQL Server, SSMS, SSRS, PL/SQL, Excel/VBA/ODBC, MS Project/VBA, SharePoint 2010, process analysis, workshops, interviews, PRINCE2, Scrum, ARIS.

Aug 2011 - Jun 2012

11 months

QA Manager / Business Information Analyst-BPM / Technical Specialist (EPM) / Application Developer (MS Access/VBA)

ABNAMRO

Internal audit and the Dutch central bank reported on the model management chain results. The status of management actions was unclear. A manager who had worked with German before asked him to analyze the situation. German reviewed audit findings, current status, and drafted concrete management actions, aligning them with leadership. He reported to ABN AMRO’s board and the Dutch central bank. He was then asked to run QA management for the four model management departments. He developed KPIs and a “Chain QA Tool” in MS Access/VBA. He reported KPIs biweekly, then monthly. After one department head left, German analyzed the Access tooling and wrote a project proposal for a final QA solution (MS Enterprise Project Management). His proposal was accepted, and he began implementing EPM.
Department: Risk Model Governance.
Tools: Business Objects, Access, Excel, VBA, workshops, interviews, EPM.

Jan 2010 - Jun 2011

6 months

QA Manager / Configuration Manager

ABNAMRO

The data migration project for TIGA: MISTRAL (by CGI) was colocated with the TIGA program and had control issues around requirements and outcomes. German was asked for help.
He implemented issue, change, QA, and configuration management. He developed an MS Access application for this and another Access app for time tracking. German ensured MISTRAL requirements and results were controlled and hours per deliverable could be tracked.
Department: TIGA/MISTRAL.
Tools: HP Quality Center, MS Access/VBA, workshops, interviews.

Sep 2010 - Jan 2011

5 months

Technical Specialist (MS Project), Application Developer (MS Project/Excel/SharePoint), Requirements Manager

ABN AMRO

The goal was to plan dry runs and final run for the ABN AMRO TIGA migration. This was a large MS Project plan with ~50 parties and 5,000 tasks. The team faced technical and content issues with the plan. A weekly cycle delivered new plans, merged, scheduled, and got feedback. Based on German’s successful TIR approach, he was asked to do the same for TIGA. German did an information analysis and proposed a design using central MS Project and Excel. He built a scheduling app interfacing MS Project, Excel, and SharePoint. He also built a QA control app for automatic checks of weekly inputs. He managed requirements and weekly releases for these apps. He trained users and handed documented apps over to IT (Infosys, India).
The MS Project import/export and QA control apps went live successfully, enabling a smooth TIGA planning cycle.
Department: TIGA.
Tools: VBA, MS Project, SharePoint, Excel, workshops, interviews, Agile/Scrum.

Jun 2010 - Jul 2010

2 months

Application Developer / BIA-BPM

British American Tobacco

The existing bonus system (Excel application) for tobacco outlets no longer matched new bonus structures. The complex system was undocumented and messy after many changes. German analyzed the existing app, documenting bonus processes, information needs, and flows. He rewrote the bonus app in Agile/Scrum with key users.
He also documented the system and trained users.
Department: Outlet Bonus System Rebuild.
Tools: VBA, Excel, VB.NET, BIA/BPM, workshops, interviews, Agile/Scrum.

Jan 2009 - Jun 2010

6 months

QA Manager

Fortis

There was little insight into the bank-wide scope (Retail, Private, Business Banking, Legal, IT, Facilities) of the Fortis rebranding at the board level. German was asked to bring more transparency to program planning.
German took on QA and requirements management. He built an MS Project interface with PowerPoint, Visio, and VBA to visualize planning. He led weekly progress meetings with program managers. One of his creative hobbies came in handy: he shot a rebranding promo film. German’s efforts helped control scope, quality, and governance of the rebranding program.
Department: Rebranding Program.
Tools: Workshops, interviews, Final Cut Pro, Photoshop, VB.NET, MS Project/VBA, PowerPoint/VBA, Visio/VBA.

Jan 2009 - Apr 2010

4 months

Technical Specialist (MS Project/Excel/VBA)

Fortis

The integration plan for Fortis and ABN AMRO had planning issues (technical and content). Fortis and ABN AMRO’s legal advisors lacked trust in the joint legal merger plan. German analyzed and fixed technical MS Project issues. He documented Fortis’s results and joined the joint legal merger planning, working closely with lawyers from both banks. He built a user-friendly MS Project-Excel interface for basic plans. German solved MS Project tech issues and ensured Fortis’s results were clear and controlled.
Department: Legal Merger Program.
Tools: Interviews, workshops, VB.NET, MS Project/VBA, Excel/VBA.

Sep 2009 - Dec 2009

4 months

Technical Specialist (MS Project/Excel)

ABNAMRO

For the TIR migration, a schedule with multiple test runs and a final run was created. The central MS Project plan had ~50 parties and 5,000 tasks. The team faced tech and content issues. A weekly cycle delivered new plans, merged, scheduled, and got feedback. The project manager asked German to solve their problems. After an information analysis, he proposed a central MS Project and decentralized Excel system. He built a VB.NET interface app between MS Project and Excel and a QA control app for automatic checks. He managed requirements and weekly releases. He trained users and handed over to IT in India.
The MS Project import/export and QA control apps went live successfully, and the TIR planning cycle succeeded.
Department: TIR Migration.
Tools: MS Project/VBA, VB.NET, Excel/VBA, workshops, interviews, Agile/Scrum.

Feb 2009 - Aug 2009

7 months

Various Internal Roles

CGI

Developed portfolio management for Achmea.
Advised Rabobank on portfolio management.
Trainer in Clarity and Open Workbench.
Contributed to Lean Six Sigma training and offerings, and to the Lean Six Sigma management game.
Bid management for Astellas/PrimaVera.

Sep 2008 - Jan 2009

5 months

QA Manager, PMO Lead, Application Developer (MS Project/Excel)

ING

A new ING Business Bank program for mid-market SMEs was just starting. The acting program manager was unhappy with project leads and the PMO. German’s main task was to reorganize and lead the PMO.
Over time he took on QA management, requirements, and dependencies. He built a “thermometer” app showing program progress using MS Project, Excel, and VB.NET. His work improved scope control and progress tracking with the thermometer app and clear governance.
Department: ING TANGO Business Banking.
Tools: PRINCE2, VB.NET, MS Project/VBA, Excel/VBA.

Aug 2006 - Sep 2008

2 years 2 months

Head of Quality Assurance

ING

There were progress and quality issues in the Call2rING call center program. It included a dozen projects, including RINGO, the new call center application. German’s tasks were QA, requirements, and dependency management. He was a sounding board for the call center manager and program manager and advised ING TANGO senior QA management. German implemented a weekly QA control cycle and fixed 100+ QA issues. He also made significant QA contributions to the TANGO program.
Department: ING/TANGO/Call2®ING.
Tools: Workshops, interviews, Clarity, VB.NET, Access/VBA.

Jul 2006 - Aug 2007

1 year 2 months

Technical Specialist (EPM), Implementation Specialist (EPM), Project Manager

Friesland Bank

Friesland Bank used hosted EPM from LogicaCMG for 18 months and wanted an in-house EPM installation. German wrote the project mandate and PID. He was project manager and technical specialist for installing EPM on the bank’s infrastructure and migrating project data. He and his team successfully installed EPM and migrated the existing data.
Department: In-house EPM Implementation.
Tools: Project Server, SharePoint Server, IIS, SQL Server, SSMS, SSRS, PL/SQL, workshops, interviews, PRINCE2, Agile/Scrum.

Feb 2006 - Aug 2007

1 year 7 months

Technical Specialist (EPM), Functional Manager (EPM), SQL Developer, QA Manager

Friesland Bank

After the first hosted EPM implementation by LogicaCMG, Friesland Bank faced many technical and organizational problems. The LogicaCMG sales manager asked German to complete Microsoft EPM training and fix issues. German served as functional manager of the hosted EPM solution at Friesland Bank’s HQ in Leeuwarden. He was 1st and 2nd line helpdesk for EPM problems, working with Microsoft EPM specialists in Portugal. He organized and delivered a three-day MS Project and EPM training for 25 project managers. He developed billing reports based on the EPM database, custom queries, and a planning standard. He built a function-point application on the EPM database. He also developed and implemented a portfolio management process, professionalized resource management, and created a project quality system. In the end, German helped the IT portfolio gain control and fixed 100+ technical issues.
Department: Hosted EPM Functional Management.
Tools: EPM, Project Server, SharePoint Server, IIS, SQL Server, SSMS, SSRS, PL/SQL, Excel/VBA/ODBC, MS Project/VBA, MS Access/VBA, VB.NET, SharePoint, BIA/BPM, interviews, workshops, PRINCE2, Agile/Scrum.

Apr 2005 - Feb 2006

11 months

Program Manager

ALD/Société Générale

Developing a new lease contract management application involved teams in Belgium, the Netherlands, India (reporting project), and hardware delivery in Paris managed by a Ukrainian PM. Société Générale was the financial stakeholder. The program requested a third PMO staff. German first led the PMO and did a situation/problem analysis in one week, then was asked to propose a solution as program manager. After another week, he was asked to implement it. As program manager, he oversaw all project management, resource planning, risk management, budget, and status checks. He temporarily managed the outsourced reporting project. His key contribution was delivering a first version successfully through structured reorganization of the central program, subprojects, and deliverables.
Department: Vulcan NL Pilot.
Tools: Interviews, workshops, Agile/Scrum, PRINCE2, Managing Successful Programs (MSP).

Oct 2004 - Mar 2005

6 months

PMO Lead, QA Manager

ING

The goal was a new mortgage administration application. The program suffered from progress, technical, and organizational issues and had no PMO. German was asked to set up a PMO and grow it to four people, leading the daily work. As QA manager he also implemented a reporting cycle and was a sparring partner for the program manager.
Department: Teilend.
Tools: Business Objects, Agile/Scrum, PRINCE2, MS Project, RUP, UML.

Jun 2003 - Sep 2004

1 year 4 months

IT Project Manager

AGIS

The goal was to enable data exchange between healthcare providers by law, but no national standards existed. German represented AGIS in the national cooperation organization VECOZO and helped create a national data exchange standard. He also contributed to the national patient record initiative. German managed the Exonet SOAP service development and AGIS requirements, ensuring SOAP data exchange services were delivered.
Department: Exonet/VECOZO IT Project Management.
Tools: Agile/Scrum, workshops, interviews, MS Access/VBA, Java.

Jan 2003 - Sep 2004

1 year 9 months

IT Project Manager

AGIS

Project Poseidon BAU: The new claim-handling application (Poseidon) was handed over to IT with lots of after-work; a project approach was needed. German managed the IT project and implemented change and release management with a release street.
Project AGIS Website: A new portal with more customer features was requested. German served as IT project manager, choosing between IBM WebSphere or BEA WebLogic, configuring server and portal, doing requirements analysis and management, and setting up SOAP services for the DB2/Cobol backend. He ensured successful Bea WebLogic server implementation and service-based functionality.
Tools: PRINCE2, Agile/Scrum, DB2, Cobol, Tuxedo, UniFace, Clarity/Niku Workbench, workshops, interviews.

Sep 2001 - Dec 2003

1 year 4 months

IT Project Manager

AGIS

AGIS’s IT department had been reorganized but still lacked a single PM tool. German was responsible for tool selection and requirements management. He contributed to Clarity setup in Oracle and trained Clarity users.
Department: Clarity Implementation.
Tools: Clarity/Niku Workbench, Oracle, PL/SQL.

Mar 2001 - Jun 2001

4 months

IT Project Manager

AGIS

AGIS’s IT department had just reorganized and lacked a unified PM method. German wrote a project management handbook and trained project managers and staff. He also QA-controlled all AGIS IT projects based on the new handbook principles.
Department: Project Management Professionalization.
Tools: PRINCE2, Agile/Scrum, workshops, interviews.

Nov 2000 - Mar 2001

5 months

Project Manager

ENECO

There were major changes to the existing ENECO GIS developed by CMG, done internaly by CMG on a fixed-price/time contract. The project struggled with progress delays.
German took over project management of a ten-member team. Under his leadership the project was delivered on time and under cost pressure, and after-work was defined.
Project: ENECO GIS (for CMG).
Tools: UML, RUP, SmallWorld, Magik, Unix, VB6, workshops, PRINCE2.

Jan 1999 - Nov 2000

11 months

Application Developer / Technical Specialist (MicroStation)

KPN

KPN’s fixed network operator needed a management system for technical areas, to integrate with BOBOCAD. After a situation, information, and process analysis, he implemented MicroStation, configured the system, and developed extra functionality. He migrated existing drawings and data, documented the system, and trained users and admins, delivering a working TORCAD system.
Project: TORCAD (for CMG).
Tools: BIA/BPM, Intergraph MicroStation/macros, VB6, BOBOCAD.

Dec 1997 - Jan 2000

2 years 2 months

Application Developer (Access, VB, SQL Server, Oracle, C++) / Tester / Functional Manager

KPN

CMG built a new sales management system for KPN. German joined, then took on programming, database design, functional design, test case design, and automated test execution. He also led test management. He later assembled deployment packages and rolled out the application nationwide. Finally, he served as functional manager and helpdesk, and mentored new developers.
Project: Le#97 and Le#98 (for CMG).
Tools: MS Access, VB6, SQL Server, PL/SQL, Testframe, DSDM, Visual SourceSafe, Oracle, Oracle Forms, C++, ITIL, ASL.

Sep 1997 - Dec 1998

4 months

Application Developer (SmallWorld)

CMG

After earning his bachelor’s degree as a SmallWorld programmer, he joined the ongoing NUON GIS project for gas network management. He programmed and tested several modules.
Project: NUON GIS.
Tools: VB, SmallWorld, Magik, Unix, Emacs.

Jul 1994 - Jul 1997

3 years 1 month

R&D Project Manager

Intomart

Mobile GIS project to measure out-of-home advertising reach (Jul 1994–Jul 1997): Intomart used analog movement logs from a rolling sample of 15,000 Dutch. This was costly, manual, and had quality issues. German did a situation and problem analysis, wrote a feasibility study, and after planning, built a mobile GIS/GPS system. He programmed GPS units and loggers and developed and optimized a routing algorithm. After organizing national rollout, he focused on statistical analysis of resulting displacement data. German delivered a working GIS/GPS system and a new, accurate method for continuous ad reach measurement.
Tools: MapInfo, dBase, VB, Delphi, Clipper, SPSS, GPS technology, MATLAB.
Lloyd’s ISO 9001 certification project (Oct 1996–Jul 1997): For ISO 9001 certification, German analyzed and documented quantitative and qualitative market research processes and conducted internal audits, leading to successful certification.
Tools: Business process analysis, ISO 9001, workshops, interviews.
European funding project (Aug 1995–Dec 1995): Rules for EU research funding were unclear. German did secondary research, visited Brussels for clarification, then wrote a guide on European grants.
Tools: Mind mapping, Excel, Word.

Jan 1993 - Jul 1994

7 months

Project Manager/Application Developer

Environmental Police

The environmental knowledge system needed a geo component due to location-based law. German created an action plan, designed and developed a GIS, tested and debugged it, and organized deployment and user training, resulting in a live GIS for the environmental police.
Project: Environmental Police GIS (freelancer).
Tools: ArcView, ArcEditor, VB, Clipper, ArcInfo.

Aug 1993 - Jan 1994

6 months

Project Manager/Application Developer

Freelancer

Complex environmental legislation was hard to follow in the field. German made an action plan, analyzed the laws, created a decision tree, wrote functional and technical specs, developed, tested, and debugged an application, delivering a working knowledge system for slurry discharge regulations.
Project: Environmental Legislation Knowledge System.
Tools: dBase, Clipper, VB, SDM.

Jul 1993 - Aug 1993

2 months

Information Analyst

Limburg Network Administrators

The existing SUF standard format for pipeline data was insufficient. KPN, Lima GAS, WML, and Enexis collaborated. German analyzed base information, derived and synchronized requirements, resulting in a joint SUF 2.1 requirement catalog.
Project: SUF 2.1 Development (freelancer).
Tools: Intergraph MicroStation, Intergraph 220 Workstation.

Summary

German has now worked for 30 years in IT projects and has successfully completed a wide range of assignments. He is known for his flexibility, having worked as a project or QA manager, but also as a technical specialist who welcomes new challenges. He has an eye for technology as well as business processes. In recent years, German successfully developed new features for a data warehouse for Deutsche Bahn, such as implementing geodata with routing algorithms, and redeveloped a series of client-server applications for Deutsche Bank HELABA (credit and operational risk), as well as numerous smaller application development projects.

German Popken is an all-round IT professional with over 30 years of ICT experience. In the last 25 years he has worked as a DBA, designer, and developer for back-end and front-end applications. He specializes in MS SQL Server, the .NET Framework (C# and VB), and MS Office integration with VBA, using OOP, test-driven development, and modern design patterns.