Guntram Uschtrin

Objective: Support trading desk in start of a new business initiative; Tech: Visio, Excel, Bloomberg, R; Stakeholders: Various internal stakeholders and relationship manager

Objective: Replace existing Java-based, near-real-time order-flow analysis tool with a Kibana/ElasticSearch Solution - Tech: Extraction of trading data with parameterized SQL statements, data enrichment via R, near-real-time visualization with Kibana; Objective: Support bank-wide AppDynamics implementation - Tech: Analysis of AppDynamics implementation via AppDynamics API and R; Objective: Evaluate big-data options to replace ELK stack - Tech: Claudera Hadoop, Jupyter Notebooks, R, Elastic-Stack

Objective: Reconciliate and replace Excel- and PDF-reports used in cost controlling with an automated ElasticSearch/Kibana solution - Tech: Automatization of data extraction and data enrichment with R, Elastic-Stack; Objective: Reconciliate EOD trade data repositories - Tech: F#, Elastic-Stack; Objective: Provide an overview over software landscape on trading floor - Tech: JavaScript, D3, Bootstrap, R

Objective: Ownership of an ElasticSearch-cluster and Development of multiple Kibana-dashboards - Tech: ElasticStack (ElasticSearch, Kibana, X-Pack); Objective: Document processes and version control of code - Tech: Confluence, JIRA, GIT, Subversion

Objective: Development of VBA scripts and Excel templates to improve processes - Tech: Excel, VBA; Objective: Product owner of two iPad-applications that support the advisory process and rollout of applications to a couple hundred pilot-users - Methodology: Scrum - Tech: HP Quality Center for Defect tracking

see above

Creation and controlling of a budget of CHF 400.000; External audit; Coordination of the discharge of the Executive Board through the General Assembly

Overall Grade: 5.2 (magna cum laude) - Master-Thesis: "Unconventional Monetary Policy Measures of the ECB and Turnover of European Public Debt" (Dataset with 5.4M trades, time-series and visualization - Multiple regression analysis, ARIMA-modeling - R, RStudio, Latex - Grade: 6.0)

Overall Grade: 4.78 - Bachelor-Thesis: "Characteristics of IPOs from an Ex-Post-Perspective" (Extraction and analysis of stock data for 1.644 U.S. IPOs - Excel, VBA, Word - Grade: 5.0)

Grade: 1.9 (German Grading-system), Honors Courses: Mathematics und Social Sciences, US High School Diploma