Vp, It Development
San Juan Capistrano, California, United States
As a member of the IT ELT team reporting to the CIO, I am responsible for the development and support of the company’s customer data platform. Manage both internal employees and onshore/offshore contractors. Work closely with senior executives (Sales Operations, Marketing Operations, Finance and Accounting team) to support their short-term needs as well as long-term strategies. Lead Emerald from an on-premises, point-to-point integration architecture to a cloud-based pub-and-sub integration architecture with the Customer Data Integration (CDI) project using AWS technology (EventBridge, SNS, SQS, Appflow, S3), Fivetran, pySpark. Deliver Salesforce’s Sales Cloud integration to Delta Lake using Amazon Appflow, Amazon EventBridge, and Salesforce Platform Event. Migrate existing on-premises EDW to DataBricks Delta Lake’s medallion architecture that with focus on scalability, data security and governance, data quality and trust.Lead the technology track for a cross-functional team made up of leaders in Sales, Marketing, Finance and IT to re-launch the company’s Master Data Management project in the cloud. As Data architect, I lead the team of Tableau Developer, Data Analyst, and Data Engineers to deliver a set of Tableau Dashboards levering sales and budget data from our EDW (Customer Data Hub). These dashboards eliminate 8 hours/week of a Finance Analyst to generate the executive dashboard and over 40 business unit specific Excel reports. The data refresh interval went from weekly to daily that allow brand leaders to access timely and actionable data at their fingertip. Lead the IT team to successfully support the company’s initiative to migrate the main B2C Marketing Automation systems (Salesforce Marketing Cloud) and other marketing automation systems (Eloqua, Marketo, Active Campaign) to HubSpot’s Marketing Hub