Project Manager Data Visualization
Resume:
Christian Pina
****************@*****.***
Montville, NJ 07045
* Will furnish references upon request *
Business Intelligence Analyst Data Visualization Specialist Project Manager P r o f e s s i o n a l S ummary:
Twenty-Five years professional experience at AT&T in various Accounting, Finance, Risk Management, and Underwriting support roles. Senior consultant to Associate Vice President and above using data driven insights into general ledger positions, cash summary and actuarial reporting, property underwriting, policy registry management, data modeling, and overall business operations. I have saved AT&T tens of millions in expenses by enhancing existing processes, developing bespoke dashboard tools, and identifying waste via root cause analysis. These accomplishments are a testament to my collaboration with internal/external partners to establish clear KPI targets, measure performance, and incentivize the adoption of clearly developed roadmaps. A r e a s o f Expertise:
Business Analysis Statistical Analysis Performance Analysis Power BI
Regulatory Compliance Project Management Communication MS Access
Financial Controls Underwriting Data Modeling MS Excel
Accounting Database Manager Data Visualization Business Objects C a r e e r H i g h l i g h t s :
Business Analysis: 25 years of providing objective data-driven strategic consultation to senior leadership of AT&T. Data Visualization: Passionate about the power of data when transformed into clear, concise, and seemingly obvious goals. Regulatory Compliance: 15+ years working closely with government and legal entities to protect privilege and security. P r o f e s s i o n a l E x p e r i e n c e :
Senior Business Analyst: Risk Management, AT&T, Bedminster, NJ May 2016 – March 2025 Hired by senior leadership to manage data/reporting operations and develop a suite of solutions for leadership and claim management teams. Solutions included the automation and management of processes to increase efficiency and accuracy, the analysis and interpretation of data to establish KPIs and capitalize on areas of opportunity through the application of bespoke reporting solutions that served to highlight those areas and provide targets to measure and achieve.
• Business Analysis: Created hierarchy-based reporting model by marrying claim data to HR data. This provided new insight and accountability at the Business Unit level, leading to radical change in operations management and a reduction in claims.
• Data Analysis: Developed data anomaly detection algorithms to replace 3 full time equivalents. This shifted work focuses on moving away from anomaly hunting to root cause analysis and cost reduction measures in excess of $20M a year.
• Regulatory Compliance: Managed financial data, the production of quarterly actuarial reports, and developed/managed the expense tracking infrastructure for all AT&T major landmark legal cases (those anticipated to exceed $50M).
• Project Management: Managed the transition from our external Claims Management System (CMS) of 26+ million claim records into an internal solution saving $600K annually and providing greater capability and access.
• Data Visualization: Developed comprehensive Power BI Dashboards for Senior Leadership to highlight areas of success establish KPIs to target. These data-based tools serve as the driving force in senior leadership operations.
• Underwriting: Managed all data related to AT&T property and assets which totaled $120 Billion as of December 2024.
• Data Modeling: Developed reporting models for Significant Insurable Events (i.e. storms, wildfires, solar flares, etc.) to estimate future exposure and inform our negotiations/purchases of related insurance coverage policies.
• Financial Controls: Implemented “Horserace” style reporting to incentivize organizational accountability. This revolutionized the management approach to losses and resulted in tens of millions in savings annually.
• Database Management: Developed multiple templated processes and associated databases to drive efficiency and accuracy in the management of AT&T’s massive datasets (i.e. Policy Registry, Risk Management Claims, Property Data, etc.)
• Client Relations: Maintain wonderful working relationships with internal customers as well as external peers at companies like Sedgwick, AON, Marsh, Riskonnect, etc.
Christian Pina
****************@*****.***
4 Rockledge Rd.
Montville, NJ 07045
* Will furnish references upon request *
Lead Financial Analyst, AT&T, Bedminster, NJ September 2014 – May 2016 Hired by the sales finance team for the development of reporting solutions to establish target quotas and monitor sales personnel and product performance relative to projected expectations.
• Error Identification/Correction: Uncovered subtle errors in previous quota management system resulting in over payment, this correction resolved over $1M in allocation errors across all regions.
• Financial Controls: Redeveloped quota modeling tool from scratch to ensure accurate and timing generation of quotas and associated payments/bonuses.
• Database Manager: Created Sales Tracking database to automate previous excel processes. By extracting the sales data via Business Objects and managing the dataset directly I was able to create Access algorithms and macros to generate a timely sales funnel that supported accurate and consistent models.
• Sales Team Management: Responsible for managing the Northeast regional sales market. Through the implementation of the above mentioned “Quota Modeling Tool” and “Sales Tracking Database”, my teams consistently hit target quota, but most importantly did not need to waste time/resources on fixing errors and correcting sales personnel compensation.
• Team Player: All teams benefited from these improvements, resulting in overall organizational improvement. Associate Director of Reporting: AT&T Wireless, Paramus, NJ June 2012 – September 2014 Promoted to managing the suite of call center reports and relationships I had developed as a manager in the department. In addition to ensuring the growth and success of the organization, I was charged with developing the reporting team’s capabilities and helping employees achieve their individual professional goals.
• Team Management: I coached all 12 team members through Six Sigma training, all achieving Green Belt status.
• Project Management: Developed service Rep. “Scorecard” reports to track and coach representative performance. These scorecards not only measured representatives on standard quality metrics but introduced new parameters previously unavailable. The new metrics decreased the average speed of answer, average handle time, and most importantly repeat calls. These measures lead to improved efficiency, reduced headcount, and helped to drive down incoming volume resulting in significant cost saving. This became the new standard of Rep. management for all call centers.
• Data Analysis: Uncovered Customer Care fraud in excess of $500K by investigating suspicious credits that routinely appeared on accounts within a representative’s home zip code.
• Program Management: Developed an overtime monitoring report to evaluate the volume and effectiveness of overtime, resulting in $75K+ cost savings per month.
• Resource Management: By redeveloping previously existing reports into more efficient processes my team was able to take on new major projects with the same headcount… More with less.
• Process Improvement: Redesigned “Save Team” reporting processes to capture metrics previous not considered and developed metrics to better measure overall performance resulting in a consistent 10% increase in monthly save rate.
• Enhanced Efficiency: Developed a new Intraday reporting process using IEX servers and SQL to replace a manual entry process resulting in an 80% improvement in efficiency. Senior Performance Reporting Manager: AT&T Wireless, Paramus, NJ March 2010 – June 2012 Promoted to managing a reporting team tasked with the development of data management systems and reports to monitor the performance of AT&T Wireless Call Centers.
• Program Management: Capitalized on the robust data storage and data analysis capabilities of Access to automate all Excel- based calculation processes. This shift not only increased production times but eliminated all errors resulting from data entry.
• Incentivized Progress: The creation of “Horserace” style reports resulted in significant improvement across all Call Centers. We saw a dramatic decrease in all negative measures: AHT, Dropped Calls, and Repeat Calls.
• Cross Function Collaboration: Volunteered my/team’s technical capabilities to improve partner organization accounting processes. The “Accounting Tool” enhancement generated the efficiency of two full time equivalents.
• Team Development: Significantly increased the data/reporting capabilities of all team members and inspired several to pursue Data Management and Reporting as a career.
E d u c a t i o n a n d Accomplishments:
• Saint Peter’s University (3.6 GPA) • Timlin Award for highest achievement in Philosophy
• Six Sigma: Green Belt • Ironman Lake Placid Finisher
Contact this candidate