Effectv

• Lead a team of analysts managing systems, data, and reporting for platforms like xG Linear.
• Deployed and maintained a supply domain portal, incorporating documentation and data dictionaries to enhance data accessibility and governance.
• Partnered with Oasis development teams to document and deploy updated datasets into production, optimizing system performance and user accessibility.
• Collaborated with the Yield team to transition reporting and analysis workflows to the updated xG Linear system, improving operational efficiency.
• Applied Effectv's Data Governance Framework to ensure data accuracy, compliance, and alignment with privacy standards.
• Partnered with product teams to plan and manage current and future offerings, aligning strategies with business priorities.

Senior Manager, Enterprise Data Analytics

Comcast

• Directed data stewardship and measurement initiatives for national marketing campaigns, enhancing data accuracy and efficiency.
• Supported AI/ML pilots, automating data quality measurement processes to reduce manual efforts and error rates.
• Consolidated redundant data assets in collaboration with senior executives, driving improved data consistency and operational efficiency.
• Taught SQL 101 courses to hundreds of internal employees as part of Comcast’s learning acceleration program (Data Practitioner), fostering technical skill development.

Senior Manager, Data Management

• Introduced agile methodologies, improving response times and communication.
• Developed dashboards to deliver actionable insights, including a New Build Summary for construction planning and post-pandemic travel expense tracking.
• Led backend developers to optimize ETL processes, ensuring efficient data integration.

Manager of Business Intelligence

andculture

• Developed SQL Server data warehouses, leveraging technologies like C# and Entity Framework for marketing analysis and revenue growth.
• Designed end-to-end marketing solutions using SAP Business Objects and Salesforce Marketing Cloud.
• Optimized query performance and improved data retention in SQL Server 2019 environments.

Data Engineer/Technical Lead

CM Regent Insurance Company

• Led a team of developers to enhance enterprise applications and implement efficient data migration strategies.
• Introduced Kanban boards to improve task management and team productivity.
• Designed T-SQL scripts for data migration and mandatory statistical reporting, ensuring compliance with regulatory requirements.

Senior Software Developer

Millers Mutual Group

• Designed and implemented a new data warehouse solution in SQL Server, enabling efficient business intelligence reporting.
• Collaborated with business units to define requirements and train stakeholders on leveraging data for decision-making.
• Transitioned to a lead architect role during a system replacement project to resolve regulatory compliance issues.

Senior Business Intelligence Developer

Glatfelter Insurance Group

• Directed external web and social media strategies, managing 21 social media pages and overseeing SEO optimization for all divisions.
• Led a project to redesign and launch responsive websites, achieving increased web traffic and improved user experience.
• Enhanced the CRM system, integrating online leads and improving sales efficiencies, resulting in increased revenue.
• Provided analytics reporting for web traffic, social media engagement, and mash-ups of online and internal data sources.

Director - Digital Marketing and Analytics

• Managed a 10-person team of DBAs, BI Developers, and Analysts, ensuring alignment with enterprise-wide data management strategies.
• Transitioned the company from static monthly reporting to agile, user-driven analytics using OLAP cubes and in-memory models, enabling faster decision-making.
• Led upgrades to the data warehouse environment (SQL Server 2008 R2), introducing PowerPivot and spatial mapping tools to enhance analytics capabilities.
• Oversaw data governance frameworks, ensuring data consistency and quality across the organization.

Director - Enterprise Data Management

Leader of the data warehouse team.

Successfully upgraded the data warehouse environment to SQL Server 2008 R2 to provide new functionality such as Power Pivot and spatial mapping reporting.

Introduced SharePoint to the organization as a new platform for BI and web portal needs.

Data Warehouse Manager

Helped design, architect and implement a new data warehouse, rewritten and moved from a DB2 platform to SQL Server.

Programmer/Analyst II

Kenra Professional

Manage, design and maintain databases in MS SQL 2000 environment
	Manage database security, backup and recovery
	Coding of DTS packages, Stored Procedures and Triggers where needed
	Perform database and query tuning to improve efficiency
	Maintain both internal and external websites written in asp and php
	Maintain Made2Manage Enterprise Resource Planning (ERP) system

Database Administrator/Developer

International Vending Management

Manage and design databases in MS SQL 2000 environment
	Coding of DTS packages, Stored Procedures and Triggers where needed
	Managed database security, backup and recovery
	Performed database tuning to improve efficiency
	Supervise staff and delegate I.T. functions to other members of the department
	Designed new data warehouse and application to be used for data storage and reporting

Database Administrator/I.T. Supervisor

Circle K

Managed and designed databases in MS SQL 2000 environment
Managed database security, backup and recovery
Managed Microsoft Exchange Server
Performed query tuning to improve efficiency
Created and maintained web forms using asp.NET
Participated in annual budgeting process
Designed, managed and implemented data warehouse and Cognos BI (PowerPlay, ReportNet) solution for Midwest division from ground up.
Promoted from Systems Administrator in 2004. Some accomplishments in that position include:
Administration of the PDI/RMS accounting package
Managed Microsoft Exchange Server
Managed user accounts and access in Windows (AD) and UNIX
Tier 3 Help Desk support
Suggest and deploy new systems of automation to aid in the use of PDI
Successfully implemented Remote Payroll system, resulting in annual savings in excess of $500,000.

Prima Marketing

Maintained PDI accounting system at all store locations as well as at the corporate office.
Provided technical help desk support to Store Managers, District Managers and Corporate Personnel.
Maintained network integrity and security.
Managed Microsoft Exchange Server.
Developed and deployed a consistent software platform for 90 locations.

Systems Analyst

Senior Manager with extensive experience in data engineering, data governance, and analytics leadership. Proven track record in designing and implementing data management frameworks, leading cross-functional teams, and driving business strategies through data-driven decision-making. Skilled in leveraging cloud and on-premises platforms, including SQL Server, Databricks, AWS, and Teradata, to optimize data quality and enable business success. Background includes significant experience in marketing analytics, enhancing advertising strategies and customer engagement.

Taplio

David Zapcic's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}David Zapcic's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

David Zapcic's Linkedin Analytics