Onando Collins
Pittsburgh,PA
Summary
Data analytics professional with five years of experience, combining expertise in economics, data science, and business intelligence. Proven ability to work with different programming languages, create data visualizations, and drive data-driven decision-making.
Overview
5
5
years of professional experience
Work History
Senior Data Analyst
BNY Mellon
08.2023 - Current
- Performed data analysis supporting investment performance, asset allocation, and client profitability.
- Built financial models to analyze portfolio returns, capital gains, volatility, and risk-adjusted performance.
- Developed automated forecasting models to project portfolio growth, cash flows, and market trends.
- Generated monthly and quarterly KPI reports focusing on returns, diversification, and exposure analysis.
- Designed Power BI dashboards visualizing portfolio performance, asset mix, trends, and forecasted outcomes.
- Executed complex SQL queries across document repositories to extract, validate, and reconcile investment and transaction data.
- Used advanced Excel functions to reconcile transactions, holdings, and valuation discrepancies.
- Ensured data quality, accuracy, and regulatory compliance through data cleansing, validation, and documentation processes.
Business Analyst
Keystone Wastewater Services, Inc.
06.2021 - 05.2023
- Utilized Python, SQL, and Tableau to efficiently process, analyze, and visualize large datasets from internal databases.
- Performed market research and cost-benefit analyses.
- Created interactive dashboards visualizing sales trends and transaction volumes, enabling senior management to make data-driven decisions.
Risk Analyst
Inspire Closing Services
09.2020 - 06.2021
- Portfolio Risk Monitoring and Reporting: Using MS Excel and Power BI to create interactive dashboards to track and analyze the performance of mortgage portfolios, identifying trends and potential risks.
- Credit Risk Assessment: using SQL to extract and analyze portfolio data from databases.
Education
Bachelor of Arts - Economics
Robert Morris University
Moon, PA05.2020
Master of Science - Data Analytics
Robert Morris University
03-2025
Skills
- Database Modeling, ETL, and data pipelines
- Data Visualization: Tableau, Power BI, and MS Excel (Advanced)
- Programming languages: Python, R, SQL querying, and Java
- Regression analysis, forecasting
- Financial analysis
- Market research and cost-benefit analysis
- Big Data Tools: Apache Spark, Hadoop, AWS, TensorFlow
- Business intelligence and data analysis
Accomplishments
- Developed a Python-based stock tracking program in to analyze trends, give stock details and generate visual reports.
- Digitized employer's paper database, cutting data retrieval time by 40% and boosting accuracy.
- Built Power BI dashboards to track key sales KPIs on a yearly basis, providing real-time insights.
Timeline
Senior Data Analyst
BNY Mellon
08.2023 - Current
Business Analyst
Keystone Wastewater Services, Inc.
06.2021 - 05.2023
Risk Analyst
Inspire Closing Services
09.2020 - 06.2021
Bachelor of Arts - Economics
Robert Morris University
Master of Science - Data Analytics
Robert Morris University