Jonathan Kroeker Email & Phone Number

Biel, Berne, Switzerland

Zurich, Switzerland

I was responsible for the daily operation of the company's core banking DWH. The DWH was fed from the T24 platform via XML files loaded by batch processes. I performed analysis and resolution for batch problems, business queries and incident tickets, and ensured that the database and our hundreds of custom reports were available for our community of over.

Zurich, Switzerland

I performed architecture, design and development work for our Regulatory Reporting datamart. Solutions were implemented with SQL and PL/SQL on Oracle 19c. I worked closely with the business analysts and downstream consumers to make sure our solutions fit the requirements and to investigate and resolve data issues in our production environment.

Zurich, Switzerland

I was a developer on the Regulatory Reporting team. My responsibilities included ETL processing of data extracted from Avaloq to prepare reports and file extracts for downstream consumption. All processing was done using SQL and PL/SQL on an Oracle database. I also liaised directly with internal customers such as the Liquidity Reporting team to coordinate.

Zurich, Switzerland

My role included the architecture, design and development of technical solutions for the Treasury Datawarehouse using Oracle, PL/SQL and Informatica running on Unix. I was also involved in the interviewing and hiring process for new developers for our team. We used Scrum and SAFe (the Scaled Agile Framework) to organize and coordinate work within and.

Winnipeg, Manitoba, Canada

I was responsible for the analysis, design and development of various tools for our business users. This included the implementation of web-based reporting and dashboards using the Cognos 8 BI software, programming Excel spreadsheets to give business users a simple interface to retrieve/update records kept in an Oracle database, as well as a logistics.

Zurich, Switzerland

I was the ETL Lead in a team of contractors implementing and customizing BI reporting using OBIEE on top of PeopleSoft’s HRMS software.

Zurich, Switzerland

My role was to design and implement the IT interfaces to a new network element as well as to make the necessary changes to the upstream systems so Sunrise could take advantage of the full functionality offered by the new equipment. The solution was implemented using a combination of Oracle9i, PL/SQL, Java, JSP and HTML.

Winnipeg, Manitoba, Canada

I was a member of a small team of developers that designed, implemented and tested bespoke software solutions. When given responsibility for the company datamart, I simplified the tables and relationships, rewrote the ETL using PL/SQL and migrated the datamart onto current versions of Oracle and Unix. As usage and demand increased multiple enhancements.

Zurich, Switzerland

At this telecom company I was a member of the Mediation Team responsible for customer provisioning and call record collection. My duties included the installation, testing and support of Comptel’s MDS/AMD and MDS/SAS products. Additionally, I was responsible for the design, implementation and testing of custom tools and applications for our environment..

Chicago, Illinois, United States

This GSM provider used Comptel’s MDS to handle all Mediation functions. I provided analysis and coordination of system enhancements and Level 3 support for service provisioning and call record collection. Two major projects I handled from the Mediation side were the development of a customer service tool to do network element queries and a BSCS to AMDOCS.

Winnipeg, Manitoba, Canada

As a consultant representing Online I worked at various client sites in the role of analyst/developer. My responsibilities included the analysis, design, implementation and testing of systems designed to meet the needs of our clients. I primarily worked on databases and back-end server jobs, using a combination of SQL, PL/SQL, C++, Pro*C and Korn Shell.