Ryan Lynch
Summary
Analytical and detail-oriented professional with extensive experience in data analysis, financial modeling, and reporting across diverse industries. Expert in advanced Microsoft Excel, including VBA, Power Query, and dashboard creation, with a proven track record of transforming complex datasets into actionable insights that drive strategic decision-making. Skilled in predictive modeling, process optimization, and business intelligence, with a strong ability to communicate findings to stakeholders at all levels. Adept at delivering data-driven solutions that improve efficiency, uncover growth opportunities, and support long-term business goals.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Business Analyst
PL Consulting
07.2022 - 01.2025
- Partnered with clients and cross-functional teams to understand business needs and define clear project scopes and requirements.
- Transformed complex datasets into actionable insights using statistical analysis and predictive modeling to uncover trends, inefficiencies, and growth opportunities.
- Designed and automated Excel-based reports, dashboards, and KPI trackers to support strategic decision-making and improve operational visibility.
- Delivered data-driven consulting across diverse industries, streamlining processes through Excel automation and boosting client efficiency and performance.
Data Analyst & Engineer
CenturyLink (now Lumen)
07.2016 - 07.2022
- Analyzed large datasets using SQL and Excel to uncover trends, optimize performance, and support key business decisions.
- Built and maintained advanced financial and operational models using Excel (Power Query, VBA) and SQL for data manipulation.
- Developed automated reports and interactive dashboards to monitor KPIs related to network performance, customer behavior, and market trends.
- Delivered executive-level insights through forecasting, predictive analytics, and clear data visualizations to guide strategy and resource planning.
Investment Analyst
EverWest RE Partners (now Sagard)
07.2014 - 07.2016
- Performed detailed financial analysis of commercial real estate assets using advanced Excel models, including cash flow forecasting, sensitivity analysis, and valuation methodologies.
- Developed and delivered comprehensive investment reports to managing partners and external investors, supporting high-stakes acquisition and portfolio strategy decisions.
- Evaluated potential acquisitions and dispositions by analyzing property performance, market dynamics, and risk exposure.
Education
Bachelor of Science - Business Administration And Management
Colorado State University
Fort Collins, CO05-2014
Skills
- Microsoft Excel (Advanced functions, VBA, Power Query, Pivot Tables)
- Data Analytics & Statistical Analysis
- Predictive Modeling & Forecasting
- Financial Modeling & Underwriting
- SQL (Data Extraction & Transformation)
- Business Intelligence & Dashboard Creation
- Data Visualization (Charts, Graphs, KPI Reporting)
- Process Optimization & Automation
Certification
Data Analyst Career Certification (365DataScience)
Microsoft Office Specialist (MOS) Certification for Excel (Microsoft)
Timeline
Business Analyst
PL Consulting
07.2022 - 01.2025
Data Analyst & Engineer
CenturyLink (now Lumen)
07.2016 - 07.2022
Investment Analyst
EverWest RE Partners (now Sagard)
07.2014 - 07.2016
Bachelor of Science - Business Administration And Management
Colorado State University
Similar Profiles
CHANSCHERANI CHANSCHERANI null
Assistant Operations (Procurement/Project) Manager at TIVO TECHNOLOGIES PL /VERSATECH SYSTEMS PLAssistant Operations (Procurement/Project) Manager at TIVO TECHNOLOGIES PL /VERSATECH SYSTEMS PL
Angela SohAngela Soh
Marketing & Admin Assistant Manager at MB Solutions Singapore PL/ BASF South East Asia PLMarketing & Admin Assistant Manager at MB Solutions Singapore PL/ BASF South East Asia PL
Keyana IveyKeyana Ivey
Front of House Staff Member at Star Group Property Services PLFront of House Staff Member at Star Group Property Services PL