Matthew Sousa Email & Phone Number

Mayfield Village, OH, US

• Enable data access to all business units and stakeholders throughout Progressive Life Insurance access to aid decision making & have live insights to operations.
• Own the data pipeline, SQL logic, and 3rd party reporting
• Develop, maintain, and update all Power BI workspaces, reports, and dashboards to ensure easy access & comprehension of our information from customer interactions to financial performance.

Cleveland, Ohio, US

Philadelphia, Pennsylvania, US

• Investigated opportunities of sourcing at global level such as merging regional spend, examining market research, and meeting with suppliers, which located $1M in potential savings
• Managed the transfer and creation of 1,000 outline agreements between the legacy and new SAP systems enabling North American suppliers to be integrated into the global platform
• Presented current supply concerns to upper management and key stakeholders on a regular basis to help develop best strategies in ensuring proper inventory levels

Philadelphia, Pennsylvania, US

• Maintain a Power BI dashboard to aggregates and tracks trends in the Invoice to Pay process from multiple SAP systems to allow the team to proactively identify gaps and opportunities weekly basis
• Automate weekly reports using Power BI to track Working Capital actuals to projections, identifying over $30M in unfavorable variances among existing vendors for the team to close a spending gap
• Manage the Citi Supplier Finance Program by onboarding 12+ suppliers and extending payment terms, which increases FMC’s cash-on-hand

Philadelphia, Pennsylvania, US

• Manage a freshman floor of 28 students by assisting with academic and personal needs
• Organize weekly programs to promote learning, inclusion, citizenship, and civic engagement
• Serve as a liaison for students and help with conflict resolution

Philadelphia, PA, US

• Streamlined an executive report regarding link-analyses of 1,300 orders using Power Query, allowing fraudulent orders to be cancelled before products left warehouses
• Developed a VBA based template to enable agents to analyze a store’s compliance with the KBA policy at the local level to allow quicker remediation times
• Built stories in Tableau to show live insights about fraudulent orders that bypassed front end systems so any gaps could be identified and mitigated
• Implemented basic SQL scripts for anomaly detection to seek irregularities in Comcast’s processes, enabling all discrepancies to be corrected before perpetrators could exploit the systems
• Created monthly tracking of perpetrators, schemes, and detailing where a $2M loss occurred at both the national and regional level for all of 2019

Philadelphia, PA

• Forecasted inflow for 11 KPI groups based on historical data and seasonality trends to assist workforce planning and compliance with government regulations
• Converted an Access Database process to Excel and OBIEE platform, which decreased backlog of Gas Inactive meters by 98% over the span of two months
• Facilitated meetings with and provided weekly reports for FMS back office to prioritize work to maximize work efficiency while staying within the monthly budget