Devon Ziegenfuss Email & Phone Number

Allentown, Pa, Us

Remote

Greater New York City Area

Acquired by Keyrus in 2014, BIPB and Vision.bi merged in early 2016 to become Keyrus US.• Lead Developer on Middle Office Trading BI project from July to Present at major NYC area investment bank o Create and maintain BI dashboards and daily reports using Qlik and NPrinting. Most dashboards track key risk indicators of middle office teams such as cancel/amends, late trades, trace violations, and total manual activities across various asset classes. o Analyzed customer requirements and designed BI models to meet those needs in fast paced environmento Built a dashboard to monitor building access throughout the entire bank. From this, built reports to help reconcile differences between security and HR data.o Installation of data quality software platform Quilliup for quality gates checks between systemso Rolled up most important KPIs and KRIs to Metric Insights, a senior management reporting tool. Documented definitions and calculations.• Thorough training of back-end and front-end development that includes, but is not limited to, the following topics:o Normalized vs De-normalized databaseso Best data warehousing practices, such as star vs snowflake schemas and ODS/STG environmentso Working with various table types including fact, dimension, and slowly changing dimension tableso Developing ETL layerso Production releaseso Develop Enterprise BI dashboards for bikes manufacturer and trading desk manager.

Greater New York City Area

• Lead Developer on Middle Office Trading BI project from July to Present at major NYC area investment bank o Create and maintain BI dashboards and daily reports using Qlik and NPrinting. Most dashboards track key risk indicators of middle office teams such as cancel/amends, late trades, trace violations, and total manual activities across various asset classes. o Analyzed customer requirements and designed BI models to meet those needs in fast paced environmento Built a dashboard to monitor building access throughout the entire bank. From this, built reports to help reconcile differences between security and HR data.o Installation of data quality software platform Quilliup for quality gates checks between systemso Rolled up most important KPIs and KRIs to Metric Insights, a senior management reporting tool. Documented definitions and calculations.• Thorough training of back-end and front-end development that includes, but is not limited to, the following topics:o Normalized vs De-normalized databaseso Best data warehousing practices, such as star vs snowflake schemas and ODS/STG environmentso Working with various table types including fact, dimension, and slowly changing dimension tableso Developing ETL layerso Production releaseso Develop Enterprise BI dashboards for bikes manufacturer and trading desk manager.

Villanova, Pennsylvania

• Responsible for assisting professors in day-to-day tasks, such as grading, running problem sessions, or proctoring. Also provided assistance to students on special projects.• Tutor undergraduate students in the school’s Math Learning Resource Center.

Master Of Arts (Ma), Mathematics, Graduate Student

Activities and Societies: Graduate AssistantGraduated in May 2015 (4.0 GPA).

Bachelor Of Arts (B.A.), Mathematics, 3.87 Gpa

Activities and Societies: Member of the baseball team for 4 years. Worked as a tutor for the school's tutoring center, as well as a TA.•.