Senior Manager, Enterprise Data Analytics

MARY BROCATO MBA MS

Coatesville, PA, USA ***** Phone: 484-***-**** Email: ****@********.***

Director of Data Analytics IT Team Manager Data Architect

Data Engineering Data Management Data-Driven Decisions

Professional Summary

Technical Team Leadership: Proven background of 25+ years in IT, data engineering, and technical resource management acquiring experience across enterprise strategy, data product management, and operations. Led cross-functional projects for senior leadership utilizing my diverse background in people management, change management, and customer/employee facing technology. Employed Stakeholder Collaboration and Cross-Functional Team Leadership, to lead, plan and execute strategic enterprise programs / projects across geographic locations, functional teams, and departments. Demonstrated capabilities in hiring, onboarding, training, management, mentoring and developing technical performers and managers. Strong communications skills to interface / collaborate with business executives, vendors, cross functional teams, and enterprise users.

Business Intelligence: Proven background of 20 years in data warehousing, big data processing, and analytical data product development. Gathered and analyzed business requirements translating them into conceptual, logical, and physical data models and technical requirements for software developers and testers. Led the development of multiple data loads, transformations, and extracts for enterprise data systems including but not limited to the Travel Data Warehouse (TDW) at Sabre Holdings, the National Data Warehouse (NDW) at Comcast, and several domain-specific data marts. Released data products for business partners and external customers including a Customer Value Calculator, Subscriber Reporting, Customer Profitability Analytics, and Equipment Inventory Optimization. Demonstrated capabilities in Data Modeling, Data Acquisition, Data Analysis, SQL, Data Visualization, Data Privacy and Compliance, Data Quality and Accessibility, Data Pipeline Orchestration, and Enterprise Data Architecture and Governance.

DevSecOps Management: Led multiple startup Technology Development Lifecycles for large scale and high availability platforms (Inception, roadmap, solution architecture, development, deployment) as well as supporting product enhancements. Exceptional expertise in building “greenfield products” for Enterprise Solutions which were highly scalable, distributed, and secure. Expert at leading structured development methodologies including Lean, Agile, Scrum, Continuous improvement, and SDLC. Directed projects and operations implementing cloud computing (AWS), data mesh, data lake architecture, big data analytics, modern data warehouse applications and secure development lifecycle (SDL). Recognized multiple times for project successes by executives and awards for successful innovative products.

COMPETENCIES

Team Leadership

Business Intelligence

DevSecOps Management

Cross functional teams

Data Modeling

New Product Development

Outsourcing / Vendor management

Data Collection / Acquisition

Platform Migrations

Employee Performance Reviews

Data Analysis / SQL

Strategic Planning / Roadmaps

Executive / Stakeholder Collaboration

Data Visualization and Analytics

Master Data Management

Staff Development / Training

Data Privacy and Compliance

Cloud-based systems, AWS

Annual forecast / Budgeting

Data Governance / Catalog

Infrastructure Design

PROFESSIONAL SUMMARY

Comcast Corporation, Philadelphia, PA Sr. Manager, Software Dev & Engineering (5 years) 04/2010 - present

Principal Solution Architect (8 Years)

Sabre Holdings, Inc., Southlake, TX Sr. Data Warehouse / Lead Software Developer 03/1993-03/2010

EDUCATION

Maryland University of Integrative Health, Laurel, MD M.S. Nutrition and Integrative Health 2022

Colorado Christian University, Lakewood, CO Master of Business Administration (MBA) 2016

Virginia Polytechnic Institute and State University, VA Bachelor of Science-Electrical Engineering (BSEE) 1986

TECHNICAL TEAM LEADERSHIP

Cross-functional Teams at Comcast and Sabre: Proven background of 20+ years in the retail travel, hospitality, and telecommunications industries acquiring experience with enterprise strategy, data product management, and operations. Led cross-functional projects for senior leadership utilizing my diverse background in people management, change management, and customer/employee facing technology. Results: Led and employed collaboration and Cross-Functional Team Leadership (as large as 10-member scrum teams) of 15 Enterprise projects across diverse geographic locations, time zones, confidentiality levels, departments, and workstreams.

Outsourcing / Vendor Management at Comcast: Identified project resource needs and negotiated beneficial contracts with consulting service vendors. Authored Statements of Work (SOWs) based on Comcast standards, obtained legal approval, and revised SOWs as needed according to timeline and budget adjustments. Supervised and reported on vendor performance and negotiated personnel assignment changes, as necessary. Result: Successfully oversaw and directed flexible staffing resources to meet business and project demands.

Technical Team Hiring at Comcast: Hired technical talent. Conducted resume screens, panel interviews, and new-hire onboarding for contractors, full-time employees, and matrixed employees in various geographic locations. Built and managed teams of up to thirty professionals. Results: Hired and developed strong engineering talent to perform data product development with the capacity to knowledge-share and work together to cover 24 by 7 DevOps responsibilities.

Employee Engagement at Comcast: Possess 10+ years management experience directing teams at all levels using knowledge of how to guide, empower, and motivate managers and engineers to take charge and own tasks and responsibilities. Conducted group meetings to recognize and celebrate achievements and share knowledge and insights across scrum teams. Also conducted one-on-one meetings to coach individual employees. Result: Achieved greater employee empowerment, and increased collaboration across teams.

Annual Department Budgeting / Financial Planning at Comcast: Collaborated with business directors and product managers to plan and implement strategies and budgets based on complex issues and information from multiple sources. This led to thoughtful decisions, recommendations, and action plans. Result: Infrastructure, development tools, and data products delivered on time as planned and within budget. Managed people and system resources for multiple multimillion-dollar projects.

Project Status and Cost Reviews at Comcast: Participated in quarterly planning for multiple software development teams to meet product management goals and cost objectives. Communicated project status updates to senior executives and business stakeholders throughout multiple project life cycles. Result: Collaboration led to strategy decisions, scope and budget adjustments and forward-looking action plans.

Employee Performance Reviews at Comcast: Employees must be incentivized to do their best work in order to achieve their goals and the larger goals of the organization. Conducted career coaching, technical mentoring, and quarterly employee performance reviews with a final annual review. Annual merit increases were determined to reward individual accomplishments. Results: Personal development plans were created with employee buy-in as part of annual goals, and non-performing employees were either terminated or helped to find new positions within the organization.

Staff Development / Training at Comcast: As technology advances, full-time employees must continuously update their skills, and new employees need orientation to organization-specific systems, processes, and tools. As part of an Employee Resource Group (ERG) leadership team, developed a new employee on-boarding guide to consolidate access to information about training resources for modern technologies and available systems, processes, and tools used by the data organization. Result: Time allocated and employee engagement for individualized training and development increased by approximately 12% enabling existing employees to contribute to projects involving modern technologies.

BUSINESS INTELLIGENCE

Data Modeling at Comcast and Sabre: Business intelligence and data science applications required data modeling. At Sabre, created the Logical and Physical data models for the Traveler Data Warehouse. At Comcast, assisted with gathering and analyzing business requirements, translating them into conceptual, logical, and physical data models and technical requirements for software developers and testers. Assisted with the data models for the National Data Warehouse, the Equipment Data Warehouse, and several analytical data marts such as Customer Profitability, Promotional Offers, and Workforce data. Result: Created Relational Database Models including star schemas and snowflake schemas to meet business needs and enable Data-driven Decision making.

Data Collection / Acquisition at Comcast and Sabre: Designed, developed, and supported multiple data loads, transformations, and extracts for the enterprise data systems including but not limited to 4 Enterprise Databases: the Travel Data Warehouse (TDW) hosted on Teradata, the National Data Warehouse (NDW) hosted on Teradata, Promotional Data Mart hosted on Kubernetes and MinIO, and the Equipment Data Mart hosted on Hadoop and migrated to AWS. Result: Data gathered from a variety of disparate source systems made available for OLAP processing, Data Analysis, Visualization, and AI/ML projects.

Data Analysis and SQL at Comcast and Sabre: At Sabre, expanded data products and information merchandising to hosted travel providers through the development and implementation of a warehouse-based customer value calculator and an agency ad filter system with forecasting reports. Tools included: SQL, Oracle Data Integrator, and Teradata macros. At Comcast, developed data products such as Customer Profitability and Promotional Data Mart from raw billing-source data. Tools included: SQL, Teradata BTEQ, and Informatica. Result: Marketed and generated revenue from data products such as the Customer Value Calculator and the Agency Ad Filter System. Internal reports also enabled data-driven decision making, revenue and improved customer and service agent experience.

Data Visualization and Analytics at Comcast: The goal was to organize and present data in visual reports to Executive decision makers on a daily, weekly, monthly, quarterly, and annual basis. Led and contributed to the development of Enterprise Business Intelligence (BI) data products and transformed data sets for data science use. Result: Improved company performance in multiple functional business data domains: Customer Data, Service Usage Data, Marketing / Promotions Data, Offer Campaign Management, Workforce Data and Equipment Supply Chain Data Domains.

Data Privacy and Compliance at Comcast and Sabre: Data organizations must comply with data privacy laws and regulations such as HIPAA, Sarbanes Oxley (SOX), CCPA, and GDPR. Directed data management, data privacy, and information security including regular validation of system access, data encryption in transit and at-rest, and data curation for analysts. Assisted in SOX compliance audits. Directed teams to service CCPA requests for data and data deletions. Results: Reduced risk to the company that could have otherwise resulted from data security threats and breaches of consumer data privacy.

Data Integrity / Accessibility at Comcast: Verified design best practices, coding standards, ETL templates, data governance, data lineage, metadata catalogs, documentation, and adherence to architectural guidelines and frameworks. Used SQL to validate data quality, integrity, and privacy. Provided oversight and requirements for microservice API prototype utilizing MuleSoft. Result: Improved the reliability and availability of data marts and data mesh for data analytics and data science.

End-to-end Automation and Orchestration at Comcast: Data collection and transformation pipelines must be orchestrated for periodic data delivery according to business service level agreements (SLAs). Advised the operations team regarding process interdependencies and prioritization in order to optimize automation and orchestration. Tools included: crontab, UC4, Informatica, and in-house custom-built pipeline orchestration. Result: Daily performance metrics improved by 30% allowing for intra-day reporting multiple times per day.

Data Governance at Comcast: The goal was to make data discoverable and accessible. Step 1: Reviewed and improved the results of AWS glue process to automatically discover and publish metadata to a basic data catalog. Step 2: Organized data sets into data products according to a standardized data taxonomy. Step 3: Transformed the organization of development scrum teams from working on disparate data types to working within the data domains defined by product management. Result: Improved data governance, reduced data redundancy, and improved development team efficiency.

DevOps MANAGEMENT

New IT Platform Development at Sabre and Comcast: Led multiple startup Technology Development Lifecycles for large scale and high availability platforms (Inception, roadmap, solution architecture, development, deployment). Exceptional expertise in building “greenfield products” for Enterprise Solutions which were highly scalable, distributed, and secure. Expert at leading structured development methodologies including Lean, Agile, Scrum, Continuous improvement, and SDLC. Results: Recognized multiple times for innovative project successes by executives and through company awards.

Platform Migrations at Comcast: To reduce processing costs and increase scalability, Comcast migrated big data processing to cloud-based architectures. Provided leadership for multiple data engineering teams to migrate applications from Hadoop to AWS and Kubernetes platforms. Cataloged data, migrated code, and configured to ensure performance and service level agreements (SLAs) met. Result: Hadoop was retired, and key applications were migrated to cloud-based platforms.

Cloud-based Systems / AWS at Comcast: Directed projects implementing modern data warehouse applications (data mesh, data lake architecture, and big data analytics). Tools included: K8s pods, Docker, MinIO storage, Databricks, and AWS services: Amazon EC2, S3, Lambda, Glacier, VPC, Kinesis, Athena, IAM and AWS Management Console. Result: Reduced total cost of ownership, maintained data accessibility and security, and improved scalability.

Strategic Planning / Roadmaps at Comcast: Led presentations to facilitate collaboration on development efforts to gain executive and team buy-in. Created and socialized design plans and timeline roadmaps to project teams and business partners consisting of executives, data architects, and user acceptance test (UAT) teams. Result: Increased support and greater awareness of high-level project plans and data product roadmaps.

Master Data Management at Comcast: Defined data governance processes and roles for Data Stewards, Data Approvers, and Developers to manage the "golden copy" of static or slowly changing reference data to map external source data to standardized enterprise business labels used for reporting and data visualization. Tools used included Kalido from Magnitude Software (acquired by Insight software), SQL Server, SSIS and ETL extracts. Results: Improved standardization for data categories including but not limited to Subscriber Products, Dwelling Types, Sales Channels, and Equipment Models.

Infrastructure Design at Comcast: Shared services and infrastructure needed changes to increase efficiency for code development, security, and maintenance. Collaborated with solution architects and shared service teams to prototype, implement, and adopt infrastructure solutions including but not limited to process scheduling, orchestration, logging, and change data capture (CDC) templates. Result: Repeatability and reliability of computer processing increased.

Daily Reliability Oversight at Comcast: DevSecOps teams were responsible for 24x7 Level 3 data application monitoring and incident remediation. Responsible for team oversight, secure development lifecycle (SDL), incident management, executive and stakeholder communication, and remediation action plans. Result: Reduced mean time to detect (MTTD) and mean time to resolve (MTTR) while improving stakeholder communication.

CERTIFICATIONS & CLEARANCES

Certified Nutrition Specialist (CNS) candidate

Teradata Certified SQL Specialist V2R5

SAFe 4 Product Owner/Product Manager

TS/SCI Clearance held in the past.

SAFe 4 Professional SAFe - Scaled Agile Framework

Teradata Certified Professional V2R5

TECHNOLOGY EXPERTISE / EXPOSURE

Data Analysis / Data Privacy:

Statistical Analysis, CCPA and GDPR

SQL, Teradata SQL Assistant, DBeaver

Cloud Computing platforms:

AWS, Kubernetes

AWS Redshift, Athena, Snowflake

Data Modeling Software:

Erwin, SAP Power Designer

Data Governance and ETL Tools:

Collibra, Alation Data Catalog, Kalido

Oracle Data Integrator, SSIS, DataStage ETL, Informatica

Data Visualization / Orchestration:

Tableau, Power BI

UC4, Airflow Astronomer, crontab

Communications / Content Management:

MS Word, Excel, PowerPoint, Visio

SharePoint, Confluence

Project Management Tools:

Agile Methodology, MS Project

Rally, Atlassian JIRA, Smartsheet

Workforce Analytics:

Workday, Kronos, Salesforce

Contact this candidate