Carly Schwartzberg

VistaOne (SoCalGas)

• Led data cleaning, testing, and organization efforts to ensure accuracy and integrity in report development.
• Mapped legacy Dart system data to AWS, ensuring seamless data migration and compatibility.
• Developed and optimized reports using AWS data in Power BI, enhancing visual design and usability for end-users.
• Conducted thorough testing of reports prior to production release, identifying issues and ensuring high-quality output.
• Worked to optimize reports for efficiency and performance, reducing processing times and improving user experience.

VistaCIS (SoCalGas)

• Collaborated daily with business and functional teams to understand reporting needs and ensure alignment with business objectives.
• Led functional design sessions, developing 30+ report designs and obtaining approval from business stakeholders.
• Coordinated meetings to gather and refine business requirements, ensuring reports accurately addressed user needs.
• Analyzed and developed a report combining TAP Survey data (Web, MyAccount, CSR, IVR, Branch) in AWS Quicksite to identify trends and improve system functionality.
• Leveraged free-text survey responses to generate actionable insights aimed at improving overall customer service and system performance.

Data Analysis and Development

• Utilized advanced techniques for cleaning complex data, ensuring accuracy and integrity before creating Power BI dashboards
• Built a high visibility dashboard tailored for managers and directors, integrating diverse data sources to deliver actionable insights
• Employed IT best practices in data visualization to design interactive Power BI dashboards with dynamic filters and drill-down options for easy exploration
• Explored customer survey data from various transactions to pinpoint trends enhancing overall customer experience metrics
• Collaborated closely with stakeholders to analyze and streamline data, resolving collection issues and improving reliability
• Applied statistical methods and data modeling approaches to extract valuable information from extensive datasets, guiding strategic decision-making
• Optimized data structure and relationships within Power BI dashboards for alignment with IT metrics, scalability, and performance
• Actively pursued professional development in Power BI and Python to enhance data analysis capabilities

Project Management

• Led the development of a Power BI feature from inception to deployment, ensuring alignment with project timelines and stakeholder requirements
• Implemented Agile methodologies for data dashboard projects, facilitating iterative development cycles and improving team efficiency
• Effectively onboarded team members and fostered collaborative efforts to ensure clear communication and drive successful project outcomes
• Identified and resolved data quality issues through effective project planning and execution, resulting in improved data accuracy and reliability
• Actively contributed to process improvement initiatives, driving efficiency and effectiveness in project management practices