James Gray Walker

Walker Informatics GmbH
Im Suderfelde 22
D – 21385 Amelinghausen
Germany
jim.walker@walkerinformatics.de
www.walkerinformatics.de
Mobile: +49 / 176 / 45 50 14 01

Objective

Contract work – under the ægis of my Einmann-GmbH – performing consulting, analysis, design, implementation, installation, maintenance and support on software projects and systems dealing with business data and communications (preferably Banking/DBMS/EC).

Education

M B A Imperial College of Science, Technology and Medicine (University of London), Management School, 1992 – 1993. Master of Business Administration and Diploma of the Imperial College, 1994.
B Sc (Hons) University of Pennsylvania, Moore School of Electrical Engineering, 1979 – 1983. Bachelor of Science in Engineering, Computer Science and Engineering, Magna Cum Laude, 1984.

Experience

1994 – Present Walker Informatics GmbH, Amelinghausen, Consultant / Contractor (and Geschäftsführer).
JIRA-Developer, Python, Groovy, REST-API •   In 2019 I worked for a large exchange organization and market infrastructure provider in Eschborn as developer in a small project team that was responsible for the JIRA-based security issues system. My work centered around importing data from other systems into JIRA, making adjustments to the user interface, tweaking workflows, as well as designing and implementing the necessary program elements in the background to support the visible changes. Components used: Jira, with ScriptRunner; Groovy, with Java; JavaScript and Ajax; Python 3 and PythonJira; Cement-Framework in Python; JIRA-REST-API-Clients in Python; REST-Endpoints in Groovy / ScriptRunner; JetBrains PyCharm; JetBrains IntelliJ IDEA for Groovy and Java.
Regulatory Reporting, EMIR, MiFIR, Perl, Sybase, XML, Linux •   From 2017 to mid-2019 I worked for a large cooperative bank in Frankfurt as developer and analyst in a project team responsible for the EMIR and MiFIR reporting for the bank and its partners. The EMIR system was taken through a major release and multiple smaller upgrades. The MiFIR system was brought into existence and was steadly improved thereafter. My emphasis fell to EMIR, in particular analysing the reported errors, determining why they arose and repairing them in the programs and the data held at the registry. The problem complexity was high, due to data interrelationships and quality issues, as well as legacy errors and shortcomings in the available documentation. Nevertheless, we achieved an accepted message rate of better than 99%. Components used: Perl 5, Sybase, XML, Tortoise for Mercurial, Linux, ServiceNow, Jenkins.
Regulatory Reporting, Liabilities / Issuances Data, Word, Excel, Access, Sybase, Oracle •   In 2015 and 2016 I worked as an analyst and documents author in a project team writing specifications for liabilities dataflows within a large (G-SIB) bank in Frankfurt to support the FSB, Bail-In and Basel III reporting requirements. My responsibility was the bank's issuances dataset, although I also assisted with the handling of wholesale funding data. The relevant data elements and structures had to be identified and obtained from the Treasury to the Finance databases, which required expansion of the data models in the intermediate and target systems. The primary results of my work were Business Requirements Dokuments (BRD) and Functional Specifications Dokuments (FSD) for the various steps in multiple ETL-pipelines. The nature of the work was a mixture of technical and business analysis and much communication, including explaining, describing, convincing, negotiating and compromise, in a culturally diverse and geographically distributed environment. Components used: MS Word/Excel/Access/Visio/Powerpoint, Oracle SQL Developer, Toad for Oracle and Sybase, Jira, Collabnet, Python 2, CSV.
Testing, Perl, XML, Linux, Excel, CSV •   In 2015 I performed a short project for a major bank in Frankfurt to convert the control programs in a regression-testing toolkit, and their control data, from an Excel- and CSV-representation of the data to an XML-representation of the same data, in preparation for a wider deployment of the tool to support a planned major upgrade. Components used: Perl 5, Excel, CSV, XML, Linux.
System Monitoring, Front Arena, Python/ACM/AEL, ITRS Geneos •   In 2013 and 2014 I did project work for a large bank in Frankfurt involving 1) supporting the integration into Front Arena of a recently acquired certificate business and 2) establishing an infrastructure, based on ITRS Geneos, to monitor the availabilty and performance of a calculation and quoting pipeline for those and previously-existing certificates. In task 1, I concentrated on performance analysis and optimization of the reporting and interface programs, as well as developing ad-hoc tools to support the daily doings of the middle office. My task 2 involved the implementation of samplers for ITRS Geneos and binding them into Geneos, including rules and other configuation entities. To this end I designed and implemented a flexible framework and class-hierarchy, based on Python, that works equally on Windows and Linux/Unix. The samplers draw their data from many different sources, including Front Arena, Reuters RFA, Bloomberg BLPAPI, KDB/Q-databases and FIX- or XML-logfiles, correlate and summarize the data and send the monitoring outputs to Geneos. "Samplers" for administrative tasks were also implemented within the framework. I assembled several releases, which were passed to production and, of course, documented everything. Also, I assisted in the assembly of dashboards and in the administration of the Geneos infrastructure (gateways, web-servers, net-probes). Finally, I was often in contact with the software provider, ITRS. Components used: Front Arena 2012.1, Python/ACM/AEL, ITRS Geneos, Excel, Windows, Linux.
Algo Collateral Management, Perl •   In 2013 I worked for a large bank in Munich on a project introducing the Algo Collateral Management System for the bank's office in Italy, where they had been using Murex's MLC. Because Algo was already being used in the German office, it was mostly just a matter of cloning the existing system and adapting it to the Italians' specific needs, although making the existing single code base usable by two distinct installations was tricky at times. My role was mostly technical, although there were some business aspects to reconciliations I implemented and in additional system enhancements for the German customer. Components used: Algo Sentry CM, Perl, MS Access, Windows and Oracle.
Front Arena, Python/ACM/AEL •   In 2012 I worked for a large bank in Stuttgart performing system modifications, mostly small to medium change requests, to an established Front Arena installation. Most had to do with business reports, including generating simulation values, and reconciliation interfaces. My work also involved automating and performing regression testing of hundreds of existing reports in support of a large system upgrade. I also wrote a tool for the automatic registry configuration of all of the various Front Arena components running on Windows, including AMASes, price feeds, exchange interfaces and XMBA interfaces. Finally I provided technical support for minor upgrades of a few interfaces. Components used: Front Arena, Python/ACM/AEL, SVN, Jira, Solaris, Sybase, SQL Server.
Bloomberg BPipe & DataLicense, Front Arena •   From the second half of 2010 through 2011, I worked for a large, resurrected bank in Munich. I supported, enhanced, monitored and documented interfaces to two Bloomberg market-data applications, BPipe and DataLicense. The main foci were improving the performance of the BPipe interface programme and stabilising the real-time price-delivery mechanism between BPipe and Front Arena. I was also in the support team for two Front Arena installations, one Windows-based and one Unix/Solaris-based. Typical tasks involved handling special data or reporting requests, including programming customised solutions, as well as tracking down problems and performing routine maintenance. Components used: Python, Java, Powershell, Windows Server, Front Arena, Solaris, Sybase, SQL Server.
Front Arena, Migration, SwapsWire •   Until April 2010, worked on two projects for a major bank in Munich. The primary project was the migration of a legacy Front Arena system to Murex, although my work involved only the Front Arena side. My task was the development of a suite of data-extraction programmes which make the full set of data related to live trades in Front Arena available to the Murex team on an ongoing basis as well as on the cutover weekend. Additionally I performed analysis and documentation work for existing interfaces and queries in Front Arena, with an eye towards providing specifications from which the Murex team can work. The secondary project was the design and implementation of a query/interface in Front Arena for the backloading of legacy IRS and OIS swaps from Front Arena to SwapsWire, in accordance with the SwapsWire Backload Cookbook. Components used: Front Arena, Solaris, AEL/Python, AMBA, SwapsWire Backload and Client programmes.
Front Arena, AEL/Python, wxPython •   In 2009, worked as a programmer/analyst on a Front Arena system for a state development bank in Dusseldorf. My work was concentrated on re-working and enhancing two processes, the mark-to-market programme and the market conformance process. The first involved optimisations and bank-specific customisations to the standard MtM-product of the system. The second involved a back-end programme which captured and evaluated trades with respect to market conditions in real-time, and a front-end GUI programme integrated into Prime which the risk managers use to identify, check and sign off on any trades which are not immediately accepted by the configurable tolerance rules. This work involved reverse-engineering of the existing processes, analysis, interfacing with the risk managers, implementation, testing and documentation. Components used: Front Arena, FA Prime, Solaris, Sybase, AEL/Python, wxPython, ATS, AMBA.
Front Arena, System Management •   In the second half of 2007 and all of 2008, worked as the sole technical and functional system manager and maintainer for the entire Front Arena installation (which I helped introduce in 2002 and 2003) for a major bank in Munich. My work included testing and performing numerous upgrades as dictated by the exchanges, maintaining system stability and compactness despite continually increasing data volumes, setting up and caring for the various users, diagnosing and repairing any problems and keeping the interfaces and data clean as conditions changed. The wide range of my activities required that I know all parts of the Front Arena system inside out and front to back, and navigate within the bank's system landscape and change management procedures. Components used: Front Arena, FA Prime, Solaris, Sybase, Windows Server/Cluster, MS SQL Server, AEL/Python, AMAS, ATS, XMBA, AMBA, ASG-IMPACT ITIL Tool.
Front Arena, Project Management •   In winter 2006-2007, worked as the project manager for the introduction and initial integration of a new Front Arena 2.2 platform for a new equity derivatives trading group at a large German bank in Zurich. Coordinated all aspects of the FA subproject, from the hard- and software installation and configuration, and interfaces to other systems, to accommodating the demands of the traders, middle office, compliance, business and the vendor. Met the ambitious 'Go-Live' target date of eight weeks after my arrival in the project. Normalised the data flows and operational procedures, including hands-on training of the middle office, and stabilised the system, in order to make it operable in the long term. Components used: Front Arena, FA Prime, Solaris, Sybase, Windows Server/Cluster, AEL/Python, AMAS, ATS, AMBA, ADFL.
Front Arena, Win32Com •   In early 2006, performed design, implementation and documentation of a control program to serve as a scaffold on which new and existing elements of the P&L process for Front Arena are to be integrated and automated, for a major bank in Frankfurt. Interesting here was the diversity of the elements to be bound together, including a generalised GUI using Python's Tkinter, data extraction from Front Arena using Atlas Extract/ASQL and ACM/Portfolio Sheets, an intermediate Database using Access, reporting using Excel, VBA callouts using Python's Win32Com and mailing of results using Lotus Notes Mail. Components used: Front Arena, AEL/ACM/Python, Tkinter, Win32Com, ASQL, ADFL, cygwin, cvs, Access, Excel, Lotus Notes Mail.
Front Arena, Python •   In 2005, performed general implementation, maintenance and troubleshooting in support of an installation of the Front Arena financial information system for a major public bank in Munich. A strong focus was data maintenance, aggregation, archiving and deletion. Other work involved the interfaces between Front Arena and a wide range of other systems. Components used: Front Arena, Sybase, OOP, AEL/Python, SQL, sh, cvs, SUN Solaris, Excel.
Front Arena, Tkinter •   In 2004, performed design, implementation and documentation of two data import/export interfaces to the Front Arena financial information system for a major bank in Frankfurt. These involved a price/volatility interface for the mark-to-market process and a trade interface for reverse convertibles. Interesting here was the integration of Python's Tkinter with AEL, enabling custom GUIs to be developed and then served from within Front Arena Prime. Also, I created object classes and a wrapper for the easy development of further AEL hooks. Components used: Front Arena, Sybase, OOP, AEL/Python, Tkinter, SQL, sh, cvs, ClearCase, SUN Solaris, Excel.
Front Arena, Perl •   In 2002 and 2003, performed analysis, implementation, integration and documentation work to support the introduction of the Front Arena financial information system for a major bank in Munich. My main tasks had to do with interfaces to/from other bank-internal systems, batch processes and data integrity. This work involved perl, python, tk/tcl, various shells, cvs, SQL and the Sybase DB in a Solaris (Unix) environment. Additional tasks include performance and throughput testing and improvement, and the introduction of a project-wide source-code (cvs) control system.
Solaris, Informix •   In 2003, for a cable infrastructure company in Munich, configured the RAID file systems on a Sun development machine, introduced the cvs source code control system, imported the sources for several existing applications into cvs and implemented a subsystem to perform asynchronous distributed updates to standing data tables, including automatic foreign key adjustment. This work involved perl, triggers, stored procedures, SQL and the Informix DB in a Solaris (Unix) environment as well as Cygwin and XFree86 on W2K PCs.
CRM, MS Access •   From 2000 to 2003, for Cirrus Logic, a DSP-chip maker, specified a web-based database application to support the sales and forecasting functions in Europe, after interviewing staff members about their requirements. Also maintained and upgraded Cirrus' old Access/NT-based sales application, which was replicated and distributed over three European sites. This involved plenty of Access and VBA design and programming.
Kondor+, C •   In 2001, performed upgrade work on an interface for foreign exchange and money-market instrument data between the front-office Reuters Kondor+ trading system and the back-office internal treasury system of a major bank in Munich. This work involved C, various scripting languages, cvs, SQL and the Sybase DB in a Solaris (Unix) environment.
EDI, MS Access •   In 1999, for Epcos, designed and developed an Access-based application for stock control of a consignment depot, integrating incoming EDI data from the customer. Also, developed basis documents to specify the conversion of several EDIFACT versions to the Siemens-internal subset; based on these, wrote the additional customer-specific specifications for 64 customer-to-Siemens mappings. Using Awk, generated test data files for several outgoing links and checked the results of their translations.
EDI, BS-2000 •   In 1997 to 1999, for Siemens Business Services, EDI Service, External Suppliers, performed connection of new partners to Siemens-internal BS-2000 system and EDI-support of existing partners. Narrowed the Siemens EDIFACT-subset for use with external partners. Developed BS-2000 and Windows tools, based on my company's product, to streamline recurring processes. Developed an Access DB, with Awk front-end, to track the 100 partners and 600 individual connections between the various Siemens-customers and external suppliers.
EDI, Awk •   In 1996, for Bass Brewers, developed a testing tool, based on my company's product, to generate outgoing EDI messages.
Visual C++, DLL •   From 1994 to 1996, for own company, developed a specialised Windows EDI product for small customers of large distributors. This involved Windows driver and DLL programming using Visual C++. Unhappily, I failed to sell the product to targeted distributors, and nearly exhausted my company's initial capital. It was a worthwhile attempt, nevertheless.
1992 – 1993 Student, Imperial College, London (see Education above).
1992 Independent Information Technology Consultant, Munich and Frankfurt.
Sybase, Informix •   Worked on project for Siemens-Nixdorf and Dresdner Bank to emulate a subset of the Sybase DBMS programming interface on top of the Informix DBMS interface.
1990 – 1992 Infosoft Datenverarbeitung GmbH, Munich, Computer Systems Analyst / Database Technology Specialist.
Unix/C, Sybase •   Participated in design and implementation of specialised application interface layer over the Sybase DBMS C-language interface layer. Developed tools to automate Sybase database creation and loading and other administrative functions. Installed and administered Sybase DBMS on networked Unix PCs. Wrote paper evaluating Unix DBMS packages. Developed data-conversion programs and other tools.
1985 – 1989 Federal Judicial Center of the United States Courts, Washington, D.C., Research Computer Scientist.
Unix, DBMS •   Designed, developed, implemented, tested, and installed Unix-based application for electronic filing and review of court case documents. Worked as part of team developing and implementing court and case management database application for federal courts using the Unify DBMS and Unix. Worked with all parts of the application, including database design, data conversion, performance optimisation, application security, system software, transaction data-entry, reporting, new-site startup and releases. Delivered technical presentations for several subsystems.
1984 – 1985 Planning Research Corporation, Patent & Trademark Office Project, Fairfax, Virginia, Programmer / Analyst.
Cobol •   Participated in analysis and design of project's Data Capture Subsystem. Participated in evaluation of vendor workstation hardware and integrated software packages.
1979 – 1983 Student, University of Pennsylvania, Philadelphia (see Education above).

Other

Resident of Germany since 1989. German citizen since 2009. Speak German fluently. Awarded Zertifikat Deutsch als Fremdsprache, Goethe Institut, Munich, 1989. Several German courses at the Munich Volkshochschule followed.

Date of Birth: 3 October 1961; Citizenship: German; Marital Status: Single. gulp.de-Id: 7708; Postal-Area: 213xx Amelinghausen.

Products with which I have extensive experience

Products to which I have had exposure in the past

Last Update: 2023–06–05