Andrew Johnson
PNC Bank
Shaker Heights,OH
10
years of professional experience
Quantitative professional with experience in financial modeling, statistical analysis, and data-driven decision-making. Strong focus on team collaboration and achieving results, flexible with changing needs. Skilled in programming languages, machine learning, and risk management. Dependable and results-oriented, with keen a keen analytical mindset and problem-solving abilities.
Work History
Business Intelligence Analyst
8 Months- Translated business requirements into reporting specifications and analytics solutions.
- Developed BI dashboards supporting sales, operations, and risk reporting.
- Analyzed data sources to identify trends, anomalies, and process gaps.
- Partnered with stakeholders to deliver accurate, actionable performance insights.
- Streamlined ETL workflows to improve data availability for analysis.
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Conducted regular data quality audits to maintain high standards of accuracy and reliability in reporting.
QUANTITATIVE ANALYST
2 Years 1 Month- Guided model validation processes, minimizing operational risks from inaccurate predictions or calculations.
- Evaluated potential investment opportunities using sophisticated quantitative methodologies, leading to increased returns on investments.
- Developed risk management strategies for portfolio optimization, lowering exposure to market volatility.
- Generated insightful reports for stakeholders by analyzing large sets of financial data using tools like SQL and Tableau.
- Conducted thorough research on market trends, contributing to accurate forecasting and strategic investment decisions.
- Provided guidance on model validation processes, reducing operational risks associated with inaccurate predictions or calculations.
- Used analytics to assist with drawing actionable insights into financial data.
- Analyzed large datasets using SQL, Python, and statistical techniques
FINANCIAL ANALYST
8 Years 1 Month- Streamlined financial reporting to enhance decision-making through clear, concise analysis and presentation.
- Improved financial forecast accuracy by implementing new, dynamic modeling tool.
- Developed financial models to assess potential investments and identify potential risks.
- Facilitated month-end close processes by reconciling accounts and promptly addressing discrepancies.
- Collaborated with cross-functional teams to optimize budgets, improving resource allocation.
- Streamlined financial reporting processes, improving speed by 33%
- Streamlined financial reporting for better decision-making with clear, concise analysis and presentation.
- Improved financial forecast accuracy by implementing new, dynamic modeling tools.
- Reduced financial risks by developing and implementing robust risk management policies.
Education
Bachelor of Science - Mathematics
Skills
Business intelligence analysis
Financial analysis
Big data analytics
Multitasking
Financial modeling
Predictive analytics
Financial forecasting
Python
Report preparation
Critical thinking
Attention to detail
Process optimization
Timeline
Business Intelligence Analyst
Key Bank
03.2026 - CurrentRead More
QUANTITATIVE ANALYST
PNC Bank
10.2024 - CurrentRead More
FINANCIAL ANALYST
Procter & Gamble Co
09.2016 - 10.2024Read More
Jackson State University
Bachelor of Science from Mathematics
Read More