Ralph Paparo
Senior Director
Irvington ,NY
Summary
Progressive and results-driven professional passionate about developing and implementing
business-impacting data applications and frameworks. Bringing a unique combination of functional
business process understanding from years of working within business units and supplemented by years
of project work and working within IT. Strategic problem solver with demonstrated ability to deliver
projects and solutions on time and within budget. , by improving business efficiencies and driving process
improvement through the use of data, technology, automation, and simplification.
Overview
24
24
years of professional experience
1
1
Certification
Work History
Sr Director Financial Systems
HomeServe USA
01.2019 - 09.2023
- Developed Data Governance Program, and built standards and procedures which included defining roles at the application level, access control, data quality, and metadata protocols for the organization
- Established formal data governance committees and teams. Identify data owners, stewards, and subject area specialists. Managed and developed roadmap for all finance applications.
- Ensured that financial applications had minimal downtime and never during month-end close periods
- Expanded the use of Oracle EBS to provide increased business functionality
- Prioritized building confidence in the data warehouse and reporting processes across the organization
- Built consistency and reliability of underlying platforms, prioritized data issues, and brought transparency to both issues and solutions
- Started Tableau and Alteryx User community to share insights
- Developed the first project management performance for the Finance Group
- Used Smartsheet to manage projects, deliverables, and delivery dates for the team
- Successfully worked with IT to migrate to a new cloud platform for Data Warehouse and Reporting
- Leading advocate for moving to entire all finance related applications to cloud-based infrastructure
- Successfully advocated and completed the migration of the planning platform from Hyperion to EPM with no disruption to end-users
- Key contributor to strategic direction and support of new business segment for HomeServe which added 20 new businesses in 3 years.
- Added support staff, built reports and data infrastructure to support new business reporting
- Automated all financial reporting for all new businesses within 1 year, reducing the level of effort for reports by over 75%
- Leveraged Jira and Confluence as main applications to help support the operational and development teams
- Enhanced the use of Confluence for documentation, and instituted formal design reviews and documentation as part of team's core work.
Sr Director DW and BI
Mediacom Communications Corp
02.2013 - 11.2018
- Developed DW and BI roadmaps, staffing plans, and supporting budgets to ensure alignment with IT and business needs to support the business strategy and objectives
- Developed multi-year road map balancing cost, quality, business risk, and service
- Built confidence in the data warehouse across the organization, by ensuring integrity, consistency and reliability of underlying platforms, applications and data
- Instituted processes and systems to maintain and ensure ongoing accuracy and reliability
- Data accuracy from source systems: 99.999%
- Ensured project performance, delivery dates and cost/budgetary expectations are met
- Maintained portfolio of projects, communicated status, and established project management best practices for data warehouse
- Maximized the value of existing technology investments, such as Oracle and identified future technologies required to support the information needs of the organization
- Direct technology and process contributions to Mediacom which included introduction of first Exadata server (database appliance technology), first enterprise wide automation and scheduling tool (Active Batch), first non
- SSIS integration tool with Informatica, introduction to Tableau in reporting and increase use of visualizations and complex data analysis
- Created department and team SLA’s and began reporting on teams overall operational performance metrics.
Director DW and Customer
Heineken USA/ Americas
12.2008 - 06.2012
- Created an enterprise information platform that provided data across divisions by deploying objects that spanned multiple subject areas
- Delivered Data Warehouse redesigned and BI platform that included a rebuild and instituting brand new Cognos v8
- Introduced the first Data Governance Council to manage critical enterprise data management issues
- Lead
- Data Governance Council in designing efforts in exception handling, data cleansing, and data standardization
- Produced and implemented data architecture vision, design, and functionality for the enterprise
- Drove a progressive approach to adding additional data sources and processes to the data warehouse
- Improved Data Warehouse and Business Intelligence departments after years of inconsistent performance
- Expanded vendor and third-party relationships
- Built strong relationships and SLA with all major third-party data providers, such as AC Nielson and Vermont Information Systems
- Delivered development of Heineken USA first spatial database which improved the accuracy of reporting across territories and identified distributors selling outside of contracted areas
- Achieved immediate improvement for Customer Service Group while instituting continuous improvement program in the US and across the Region
- Increased end-user satisfaction from 85% to 99% for the Group
- Drove reduction of total costs while decreasing hold times, call resolution times, and repeat calls
- Collaborated with HQ and operating companies across the globe to deliver projects in the Americas Region to meet overall IT standards for equipment, security, and costs
Application Mgr - Supply Chain
Heineken USA/ Americas
12.2006 - 12.2008
- Drove improvement in SAP order to cash processing and supply chain planning.
- Revamped SAP Business Warehouse (BW) while making improvements in reporting functionality and performance.
- Designed, developed and managed several Planning and SAP deployments across multiple platforms
- Delivered a successful deployment of SAP Portal re-design and re-launch without any downtime
- Portal redesign resulted in order-related errors dropping to zero and a reduction of 5 FTE’s in regional offices
- Designed and delivered the company’s first Order Management report – Called Order Lifecycle report allowing business users to track orders from creation to invoice for the first time in one report.
Process Lead
Sony Electronics
12.1999 - 10.2006
- Orginal member for the first Green Field Migration to SAP for Sony
- Completed the highest number of deliverables on the pilot SAP project, including designing and configuration of assigned processes for order to cash
- Created two industry-leading solutions for the financial services group in the credit management area, which drove cost savings of 15% -20% due to time savings by analysts
- SME and expert in SAP credit management process
- Business process lead and major contributor for BW / reporting rollout to over 5,000 users during phase two of
- SAP rollout.
Education
MBA - Finance
Fordham University
Tarrytown, NYBS - Finance
Manhattan College
Riverdale, NYSkills
Leadership and Management
Strategic Planning
Project Management
Enterprise Reporting & Business Analytics
Supply Chain Management
Financial Reporting and Reconciliation
Software Development Lifecycle
Agile / Lean Methodologies
PCI, SOX Compliance
Vendor Management Data Strategy
Invoice Processing and Automation
Data Engineering and Integration
Certification
Project Management Certification (PMP) Training - 2019
Tools
Tableau. OBIEE, Cognos, Business Objects, Alteryx, Power BI, Tableau, Exadata, Oracle 12c & 19c, AWS, OracleCloud Infrastructure, Smartsheet, MS Project, Mindjet, Jira, Confluence, Remedy, SAP, Hyperion/EPM, Oracle EBS, Quickbooks; Sage, Informatica; Powershell; SQL scripting; Tableau Prep, Active Batch; Tidal, All MS applications and Vizio.
Other
Informatica Conference Presentation: The Everything Strategy: 5 Essentials of Effective Data Warehouse Automation
Adjunct Professor in Finance, Mercy College Dobbs Ferry, NY 2000-2005
Timeline
Sr Director Financial Systems
HomeServe USA
01.2019 - 09.2023
Sr Director DW and BI
Mediacom Communications Corp
02.2013 - 11.2018
Director DW and Customer
Heineken USA/ Americas
12.2008 - 06.2012
Application Mgr - Supply Chain
Heineken USA/ Americas
12.2006 - 12.2008
Process Lead
Sony Electronics
12.1999 - 10.2006
MBA - Finance
Fordham University
BS - Finance
Manhattan College
Similar Profiles
Margaret PotterMargaret Potter
Retention Specialist at HomeServe USARetention Specialist at HomeServe USA
Nicholas ClarkeNicholas Clarke
Facility and Fleet Manager at HomeServe USAFacility and Fleet Manager at HomeServe USA
Rudolfo GamboaRudolfo Gamboa
Insurance Account Representative at HomeServe USAInsurance Account Representative at HomeServe USA
SHERMONICA MCCURTYSHERMONICA MCCURTY
Escalated Complaints Specialist at HomeServe USAEscalated Complaints Specialist at HomeServe USA
Renée SwiftRenée Swift
School Counselor & Mental Health Counselor at EF Academy International Boarding SchoolSchool Counselor & Mental Health Counselor at EF Academy International Boarding School