Senior Manager Data Warehouse
Resume:
David F. Figueroa
Greater Boston Area
**************@*****.***
https://www.linkedin.com/in/david-fernando-figueroa/
• Technology driven MBA professional, passionate for leveraging Data Analytics to produce consumer communication outreaches and actionable business insights.
• Computer Science / Informatics Engineer with very strong academic and technical background on Database Marketing, Data Science and Cloud Computing.
• Senior Manager of Enterprise Analytics Campaign Targeting team, leading business efforts to design, execute and analyze member communication data to measure outreach results and obtain consumer behavior insights.
• Information technology senior professional with over twenty years of experience implementing Data Warehouse and CRM solutions for multiple companies across different industries in the United States as well as in Latin America (Peru, Chile, and Brazil).
• Successfully integrated several CRM solutions with Business Intelligence processes that positively impacted business performance by leveraging the Enterprise Data Warehouse. WORK EXPERIENCE
Senior Manager, Architecture / Analytics & Behavior Change, CVS Health Woonsocket, RI, USA / May 2010 to present
• Leading transition and adoption from on-prem Data Lake and Data Warehouse to Google Cloud Platform capabilities and processes.
• Leading design, modeling, implementation, adoption, and support for the Campaign Data Mart (CDM) for the PBM and Specialty business units.
• Setting strategy, team leading and managing operations within the Member Engagement Analytics team to leverage the team’s technical skills and engage them into the Campaign Targeting business process within a highly collaborative environment across multiple business partners like Product Owners, Marketing Managers, Project Managers, Vendor Managers, Data Engineers, Data Scientists, and IT.
• Extensive utilization of SAS and Teradata to perform campaign targeting execution and analytical work.
• Implementation of solutions using Teradata and SAS in order to execute consumer outreaches for adherence to medication and Member Value programs.
• Lead analytics team for design, execution and analysis of consumer outreaches targeted to improve consumer adherence to medication and overall member experience.
• Analysis and reporting of consumer outreaches using test over control methodology in order to calculate lift and determine EBIT contribution.
• Functional design of a Campaign Management solution for automating consumer outreaches. Senior Consultant / Americas Customer Management COE, Teradata Corporation Columbus, OH, USA / October 2007 to April 2010
• Expanded Teradata sales in Latin America by implementing CRM solutions in customers including a large retail/consumer credit company and a major telecommunications company in Chile, as well as at one of the largest financial institutions in Brazil.
• Responsible for delivering the CRM project at a bank in Brazil which drove the expansion of its Teradata system and services. This was in response to the bank’s immediate goal to retain its customer base and react to changes in the financial scenario that affected their leadership in the industry.
• Lead the team responsible for operational improvements to the CRM implementations at the parent company of one of the largest supermarket and groceries chains as well as at a major retail chain for shoes, with the goal to increase the effectiveness of the existing marketing campaigns.
• Lead the CRM proof-of-concept in conjunction with a Service-Oriented-Architecture (SOA) at one of the largest financial institutions in the US.
• Responsible for the migration to the TRM solution from the previous TCRM implementation at customers such as a major US airline, a parent company of a casino chain and a major US online retail store in order to improve the performance of the application, reduce the operational costs associated with the hardware, and integrate with the communication channels.
Consultant / CRM Group - Teradata Division, NCR Corporation Columbus, OH, USA / March 2001 to October 2007
• Managed operations at a CRM site implemented at one of the major online travel retailers in order to comply with the business requirements for daily marketing campaigns. Some additional changes were performed in order to incorporate new customers and marketing specifications after the merge with another European company within the same industry.
• Delivered implementation, expansion and operational support to a CRM implementation at a large US insurance company in order to implement marketing campaigns for customer loyalty, retention and win-back.
• Delivered the CRM solution at one of the largest casino and entertainment chains in the US and the integration with the provider for the email and web delivery channel.
• Delivered a proof-of-concept at a military supplier company for the Supply Chain Intelligence solution in order to reduce operational costs by optimizing the logistic processes.
• Responsible for the implementation of the CRM solution at a mid-size US airline and the integration with the email channel in order to support customer retention and customer loyalty marketing campaigns.
• Provided consultant services to scope CRM data readiness at a major parcel and mail company in the US. Consultant / eCommerce Division, NCR Corporation
Columbus, OH, USA / January 2000 to March 2001
• Responsible for the design and implementation of the e-Bill Payment solution (for customers) and the e-Bill Presentment solution (for providers) at a mid-size bank in the US. This solution was designed for expansion of services to their regular and business users.
• Delivered the implementation of the Internet Banking application at a mid-size bank in the US and at one of the early internet-only banks as part of supporting the initiative to grow the web communication channel. Consultant / Financial & Retail Solutions Division, NCR Corporation Lima, Peru / January 1996 to January 2000
• Managed the implementation of the internet banking application for business users as part of the expansion into the web communication channel at one of the largest financial institutions in Peru.
• Designed and implemented a set of custom modifications to the Microsoft Exchange email platform in order to comply with business and infrastructure requirements at one of the largest financial institutions in Peru. This project was implemented in conjunction with the Microsoft Exchange team in Redmond, Washington.
• Responsible for the deployment of the Trimax application for the NCR Point-of-Sale stations at a department store in Peru.
EDUCATION
Isenberg School of Management / University of Massachusetts Amherst Amherst, Massachusetts / Class of 2015
• Master in Business Administration (MBA)
School of Science and Engineering / Pontificia Universidad Católica del Perú (PUCP) Lima, Peru / Class of 1996
• Computer Science / Informatics Engineer (11 academic semesters) CERTIFICATIONS
• Google Cloud Professional Data Engineer (Certified in July 2024)
• Google Cloud Digital Leader (Certified in April 2024)
• SAS Enterprise Business Intelligence (Trained in 2011)
• SAS Foundation (Trained in 2010)
• Teradata Certified Professional (Certified in 2007)
• Teradata Certified SQL Specialist (Certified in 2007)
• Teradata CRM level III (Certified in 2002)
• Microsoft Certified Solutions Developer (Certified in 1997) TOOLS & METHODOLOGIES
• Agile Methodology
• Google Cloud Platform (GCP) framework
• Tableau for visualization and reporting
• SAS and Microsoft Excel for data analytics
• SQL for implementation of complex queries and data processes
• R Studio for Machine Learning (Statistical Learning)
• Python for data ingestion and Artificial Intelligence processes
• Microsoft Office Professional suite
• Microsoft VBA for data-driven Excel spreadsheets
• Microsoft Visual Studio and Java framework for software development data integration
• Teradata CIM (Campaign Interaction Manager) as CRM tool
• Teradata Utilities
• CA Erwin Data Modeler
• UML for software modeling
• Service Oriented Architecture (SOA) data exchange based on XML
Contact this candidate