Andrew Albertelli
Old Bethpage
Summary
Business professional with a strong foundation in data analysis, regulatory compliance, and business operations. Demonstrates a team-oriented mindset, honed through four years of college football, and brings resilience and discipline to the professional field. Known for problem-solving and the ability to deliver insights that support business goals, seeking an opportunity to leverage analytical and financial expertise in a dynamic, growth-focused role.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Business Analyst Summer Intern - Substation Operations Central Planning
Con Edison
06.2023 - 08.2023
- Collaborated with central planning for corrective maintenance across Con Edison's NYC service territory, covering all five boroughs
- Analyzed and cross-referenced data to identify and resolve inconsistencies in work order records, enhancing data accuracy
- Actively participated in weekly safety meetings with the substation operations management team
Insurance Compliance Consultant
HB Consulting
01.2021 - Current
- Demonstrated a deep understanding of ISO standards, statutory reporting, and regulatory compliance, ensuring adherence to industry and government guidelines in data management and reporting.
- Ensured data integrity and operational accuracy across insurance policy and claims databases, resolving data discrepancies to meet regulatory standards.
Event Equipment Technician
Party Harty Entertainment
01.2020 - Current
- Coordinate the delivery of equipment to and from event venues in a prompt and efficient manner
- Designed light, sound, and stage equipment, ensuring timeliness and safety through effective team collaboration
Education
Bachelor of Business Administration (BBA) - Finance
Pace University Lubin School of Business
Pleasantville, NY05.2024
Skills
- Python
- Microsoft Office Suite (Word, Excel, PowerPoint)
- US Insurance Compliance
- Business Analysis
- Data Quality and Discrepancy Analysis
- Effective Communication and Collaboration
- Property & Casualty (P&C) Insurance Expertise
- Insurance Policy and Claims System Proficiency
Certification
JPMorgan Chase & Co. Quantitative Research Virtual Experience Program, Forage, 06/24
- Completed a simulation focused on quantitative research methods.
- Analyzed a book of loans to estimate a customer's probability of default.
Accenture Data Analytics and visualization job simulation, Forage, 06/24
- Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture
- Cleaned, modeled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions.
The Hong Kong University of Science and Technology Python and Statistics for Financial Analysis, Coursera, 05/24
- Import, pre-process, save and visualize financial data into pandas Dataframe.
- Build a trading model using multiple linear regression model.
Leadership Experience
Plainview Old Bethpage JFK Football Team, Plainview, NY, Captain, 2018, 2019, Served as captain and was awarded the honor of MVP of Plainview-Old Bethpage Varsity Football., Committed to developing younger players through training and mentorship.
Athletics
Pace University Football Team, Pleasantville, NY, Defensive Back, 08/20, 12/23
- Committed approximately 40 hours per week to train, watch film and gameplan.
- Developed a strong work ethic, dedication and team building skills to achieve personal and team goals.
- Contributed to the development of younger players by mentoring athletes at football showcases.
Activitiesvolunteerwork
Celiac Disease Center at Columbia University, New York, NY, Junior Board Member, 01/11, Present
- Founder of annual Bowling Bash which raised over $100,000 for Columbia University
- Founder Celiac Awareness Day with the NY Mets.
Relevant Coursework
- Data Analysis and Finance
- Financial Management
- Options, Futures, & Swaps
- Valuation of the Firm
- International Finance
- Corporate Finance
- Financial Accounting
- Principles of Investment
Timeline
Business Analyst Summer Intern - Substation Operations Central Planning
Con Edison
06.2023 - 08.2023
Insurance Compliance Consultant
HB Consulting
01.2021 - Current
Event Equipment Technician
Party Harty Entertainment
01.2020 - Current
Bachelor of Business Administration (BBA) - Finance
Pace University Lubin School of Business
Similar Profiles
Krystle BrownKrystle Brown
Gas Mechanic at Con Edison of New YorkGas Mechanic at Con Edison of New York
Arnold StovellArnold Stovell
Portfolio Manager at Con Edison of New YorkPortfolio Manager at Con Edison of New York
David JuarbeDavid Juarbe
Sr. Specialist at Con EdisonSr. Specialist at Con Edison
SHAWN BROWNSHAWN BROWN
Parking Flagger at Con Edison SolutionsParking Flagger at Con Edison Solutions
LIANNA MAZZOCCHILIANNA MAZZOCCHI
Medical Scribe at Scribe AmericaMedical Scribe at Scribe America