JOHN PARRA
Brooklyn,NY
Summary
Data-focused professional with experience leveraging data visualization and analytical tools to identify trends, support forecasting, and generate actionable insights. Skilled at translating complex datasets into meaningful information that highlights performance strengths and opportunities for improvement. Recognized by peers as proactive, detail-oriented, and collaborative, with a strong commitment to continuous learning and applying new skills to support organizational goals and data-driven decision-making.
Overview
6
6
years of professional experience
Work History
Sr. Analyst
Con Edison
New York, NY
03.2024 - Current
- Developed and maintained interactive dashboards using Microsoft Power BI to track KPIs and infrastructure trends, enabling stakeholders to prioritize pipe replacement based on safety risk, asset condition, and operational factors.
- Performed geospatial and asset inventory analysis using ArcGIS, ArcFM, and ProceMX to support infrastructure planning and respond to ad hoc stakeholder data requests related to pipeline systems.
- Analyzed utility asset data across multiple geospatial platforms to provide actionable insights that supported maintenance planning, risk mitigation, and capital improvement decision-making.
- Gathered, validated, and reported benchmarking datasets for regulatory submissions to the New York State Public Service Commission, supporting Con Edison performance tracking against mandated safety, reliability, and infrastructure compliance targets.
- Analyzed data trends to support operational efficiency initiatives.
- Developed comprehensive reports on energy consumption patterns for strategic decision-making.
- Collaborated with cross-functional teams to optimize project workflows and enhance process accuracy.
- Mentored junior analysts, guiding data analysis techniques and best practices.
- Conducted risk assessments to identify potential operational challenges and propose mitigation strategies.
Business Analyst
Exelon Pepco Holdings Inc
12.2021 - 03.2024
- - Handled the reporting of KPIs for the department, providing crucial insights into performance metrics.
- - Leveraged Google Analytics and PowerBI to provide data by forecasting/analyzing historical information.
- - Continuously enhanced and managed our Google Sheets by incorporating new PPVs, ensuring meticulous tracking of diverse transactions associated with our KPI monitoring.
- - Managed and responded to ad hoc requests, ensuring timely and accurate delivery of information.
- - Played a key role in the transition from GA360 to GA4 for KPI tracking.
- - Utilized data visualization tools to create insightful reports for senior management showcasing and reviewing KPIs, customer feedback, and engagement metrics across our digital channels.
- - Monitored daily heatmaps with Google to ensure that all core transactions our company tracks are operating as they should.
IT/Project Manager
Privatel Incorporated
10.2020 - 12.2021
- - Project Manager for various Fordham University contracts.
- - Prepared and installed Access points across various Universities.
- - AV installs and maintenance (Modulators, receivers, nodes, TVs).
- - Managed phone service for Fordham University (Troubleshoot, Activate phones, process phone upgrades)
Education
Bachelor's Degree - Information Systems
Rutgers University
12-2020
Associate's Degree - Computer Science
Hudson County Community College
12-2016
Skills
- Google Analytics 4
- Google Analytics 360
- PowerBI
- Google Tag Manager
- Intrado
- Tableau
- PowerPoint
- Performance monitoring
- Report preparation
- Advanced Excel
- Stakeholder communication
- Cost-benefit analysis
- Risk analysis
LANGUAGES
English | Native
Native or Bilingual
Spanish | Native
Native or Bilingual
Timeline
Sr. Analyst
Con Edison
03.2024 - Current
Business Analyst
Exelon Pepco Holdings Inc
12.2021 - 03.2024
IT/Project Manager
Privatel Incorporated
10.2020 - 12.2021
Associate's Degree - Computer Science
Hudson County Community College
Bachelor's Degree - Information Systems
Rutgers University