Data Analyst Risk Management

Christian Bier

ad5ctg@r.postjobfree.com 203-***-****

Windsor Locks https://www.linkedin.com/in/christian-bier/

Core Competencies

Risk Management, Financial Expertise, Analytical Skills, Leadership and Management, Communication, Regulatory Compliance, Industry Knowledge, Financial Coding Proficiency, Integrity and Ethics

Work Experience

Belcan, South Windsor, CT July 2022- Current

Financial and Accounting Data Analyst

As a Financial and Accounting Data Analyst at Belcan, I specialize in leveraging Microsoft VBA to enhance data extraction from SAP. By creating an Excel macro, I efficiently organize expansive datasets by project and cost categories. This innovation has reduced a once time-intensive task from hours to just 10 minutes, resulting in substantial cost savings for our clients. Through process optimization, I've driven significant advancements in team productivity and project timelines, benefiting industry giants like Boeing, Rolls-Royce, Airbus, Pratt and Whitney, and Collins Aerospace.

●Utilize MS VBA, SQL, Python, and SAP to retrieve and organize extensive datasets efficiently.

●Conduct financial planning, including budgeting, forecasting, and variance analysis.

●Analyze extracted data to identify trends, patterns, and anomalies, ensuring accuracy and reliability.

●Cultivate collaborative relationships with customers, providing data utilization guidance to meet their needs.

●Implement data governance practices to ensure data quality, consistency, and security.

●Perform accounting tasks including general ledger management, journal entries, and month-end reconciliation.

Education

University of Connecticut, Hartford, CT September 2022 - August 2023

Masters in Financial Risk Management

●Track and provide updates on both potential financial risks and opportunities.

●Conducted Risk monitoring and internal/external risk reporting, ensuring compliance with industry standards.

●Utilized advanced financial modeling techniques, including Monte Carlo simulations and Black-Scholes formulas, to develop forward-looking financial statements and risk appetite monitoring.

●Produced risk analytics such as credit VaR and credit risk/return to aid in risk appetite setting and monitoring.

●Conducted valuation and risk modeling of General Accounts across various asset classes, leveraging expertise in coding stress tests and risk assessment.

●Major projects: FRM Capstone Project, Bloomberg global trading challenge

●Developed and tested the company's Risk Appetite, establishing Risk tolerances and Limits.

University of Connecticut, Storrs, CT August 2018 - May 2022

Bachelor of Liberal Arts & Sciences Economics major

Internship Experience

Internship Experience

Stamford Counseling Center, Stamford, Connecticut February 2020 -April 2020

Multi Functional Accounting Intern

●Entered and assisted payroll for all employees

●Worked with accounting team to complete the bank reconciliation of 2019-2020

●Used Quickbooks and Excel on a daily basis

Skills

Coding: Python (NumPy, Pandas, Matplotlib, SciPy),

SQL and R

Microsoft: VBA, Excel (Pivot Tables, Data Validation, Filters, Macros/VBA, Solver, VLOOKUP's), Word, PowerPoint, Azure and Access

Contact this candidate