Learn Data Skills
Beta
Jeremiah Haremza

Jeremiah Haremza

Business Analytics Lead Associate

KeyBank | Clarence, NY

Technologies

My Portfolio Highlights

My New Course

Intermediate SQL Queries

My New Course

Understanding Data Science

My New Course

Understanding Data Visualization

My New Course

Intermediate SQL Queries

STEM advocate focusing on data science and machine learning.

My Work

Take a look at my latest work.

course

Understanding Data Science

course

Introduction to SQL

course

Intermediate SQL

course

Understanding Data Science

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Understanding Data Science
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

KeyBank | May 2021 - Jun 2023

Business Analytics Lead Associate

Responsible for optimizing outreach methods (Phone, Email, SMS, Letters) for past due accounts: - Design and deployment of digital (SMS & Email) strategies in Katabat - Increased email out reach by 50% driving associated return to an all-time high of ~$7MM - Built enhanced data feed for legal team to handle charged off accounts - Optimization of web based workflows for loss mitigation
Show More

Citi | Dec 2019 - May 2021

Strategy Senior Analyst - Assitant Vice President

Focused on process enhancements to the firm-wide Material Risk Inventory (MRI) and its relation to CCAR and capital planning. • Natural Language Processing (NLP) of risk statements in the MRI via Python. • Power BI visualizations of analytics related to MRI. • Resolving linkage between risk statements from MRI and CCAR stress scenario quantifications.

M&T Bank | Jun 2016 - Apr 2018

Data Analyst

Responsible for IT Resource Management Optimization Analytics monthly and weekly reports as well as ad-hoc requests. Function as SME for data availability and analytics capability of multiple systems related to RMO. Support of data driven processes via automation, streamlining, and process improvement. • Tableau Dashboard development, implementation, and adoption • Helped to drive adoption of CA-PPM adoption and compliancy • Developed VBA process automation to reduce production time of reports • Excel and Outlook Automation to streamline process for data entry compliance • VBS automation and Excel direct dB connection for TRON team reports • Data Quality checks • Data Profiling • Data blending across multiple sources (CA-PPM, TRON, Taleo, etc.)

Citi | Jul 2013 - Jun 2016

Market Risk Analyst

Responsible for analysis of and data quality related to Value At Risk (VaR), Stress VaR, and Incremental Risk Capital (IRC). Create reconciliations for various factor sensitivities which are used as input for VaR calculations. reconciliations are created in MS Excel and data for reconciliations is retrieved an compiled via MS Access or SQL. In addition, Excel Add-Ins of scAddins, dpAddinsNT, and arkAddins are used both for sourcing front office data and for various data quality checks. Create ad-hoc reports or data extractions for Risk managers as requested. Creation of these ad-hoc reports is done via the same tools, databases, and methodologies as mentioned above. Interact with other members of the Risk Reporting team as well as Senior Management, Market Risk Managers, Traders, Front Office Business Managers, Technology, Financial Control and other groups within the firm regarding daily risk exposures that are above limit and/or show data quality concerns. Currently responsible for covering the following Business Units: - Risk Treasury (US, Europe, Japan, and Canada) - North American Rates - European Rates, - CVA Desk - Central Funding Desk Previously responsible for covering the following Business Units: - Municipal Bonds - Global Finance.

Louisiana State University | May 2010 - Aug 2012

Research Assistant

Compiled and analyzed extensive data to show stability of Side Muon Range Detector. Conducted software research and wrote / tested code; wrote software to access temperature database and performed bit decoding tasks. Structured and presented weekly PowerPoint research status reports to local research group and to international Data Quality Group via Web Conference software. Trained research group members on bit encoding access; delivered orientations to new software users. Successfully demonstrated 99.997% stability of Side Muon Range Detector. Wrote and tested data quality computational code to analyze data quality in semi-live time as well as developing novel process for compiling data quality information. Automated and wrote documentation for data quality processes / tasks. Conducted particle reconstruction studies. Presented research findings at South Eastern Section of the American Physical Society.

Louisiana State University | Aug 2009 - May 2012

Teaching Assistant

Developed and taught undergraduate physics and astronomy courses to classes of ~30 students. Delivered lectures, coordinated and led lab activities, and monitored students' use of volt meters, photo gates, telescopes, and other equipment; created curricular materials, syllabi, class schedules, and spreadsheets for student use. Tracked student progress, graded exams, and submitted final grades to Registrar. Redesigned syllabi for 2 Astronomy courses.

The Princeton Review | Feb 2007 - Jul 2009

Instructor

Taught test preparation courses for SATs, GREs, MCAT Chemistry, and GMATs. Coordinated lessons and shipping of materials with home office in Amherst, New York, proctored practice tests.

University of Rochester | Aug 2007 - Dec 2007

Teaching Assistant

As undergraduate teaching assistant, taught laboratory section of astronomy course. Met weekly with professor to verify lesson plans; demonstrated use of telescopes and CCD equipment to students. Provided basic lab orientations, evaluated lab work, and reported grades.

My Education

Take a look at my formal education

Master of Science, PhysicsLouisiana State University | 2012
Bachelor of Science, PhysicsUniversity of Rochester | 2009
Bachelor of Arts, PhilosophyUniversity of Rochester | 2009

About Me

Jeremiah Haremza

Jeremiah hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free