Tech lead in charge of data architecture, ETL, CDP creation and optimization for marketing campaigns and data distribution to vendors.

Responsible for Design, translate business requirements, develop, document, test, monitor, troubleshoot and administrate our BI environment using Redpoint Data Management ETL tool.Participate in maintenance and upgrades for our platforms and tool sets. Communicate and accurately document all architectural decisions, plans, goals, functional requirements, and open items and issues to key stakeholders, including management, development teams, and business areas. Participates in short- and long-term planning sessions with customers to improve business processes and work closely with data warehouse manager & VP IT to assure all systems are in line with IT long-term strategy

Responsible for the architecture and design of data movement and cleansing processes for data-centric applications for Action Center clients. Responsible for the design, development, coding, testing, debugging and documentation of applications to satisfy the requirements of one or more user areas. Includes hands-on new development as well as support, maintenance or enhancement of existing applications. Work closely with client management to identify and specify complex business requirements and processes.Duties and Responsibilities -Program and support ETL (Redpoint Data Management and Alteryx) workflows for integrating data from disparate data sources and loading in club data warehouses. This includes probabilistic matching, profiling, data cleansing, geo coding and applying unique keys. -Visualize, architect, design and deliver the data movement framework to improve consistency, quality and reduce the redundancy in code for repeatable tasks. -Creation of the Policies, standards and guidelines for Data Movement -Drive quality of data movement solutions delivered by ETL practice -Create automated processes that encapsulate workflows which can be used by other team members. -Participate in Architecture Reviews -Resolve database performance issues, database capacity issues, data replication, and other distributed data issues for Data Lever server. -Create dashboards and reports using Tableau -Create SQL databases for housing integrated data sets for club data warehouses

Pentaho is the commercial open source alternative for business intelligence (BI). Pentaho Open BI Suite provides comprehensive reporting, OLAP analysis, dashboards, data integration, data mining and a BI platform that have made it the world's leading and most widely deployed open source BI suite. As a support engineer I was able to participate on almost every aspect of the company. I became a subject matter expert for the ETL (Kettle) and the OLAP Analysis (Mondrian) tools. As part of my responsibilities, I was in charge of supporting these two specific products and also provide consulting and training to potential clients

• Subject matter expert of the AimCall OLAP application and the Allstate call center metrics and data warehouse. • Responsibilities related to the AimCall Application: Installation and configuration of the application Establish connection to data sources like Avaya CMS tables and Aspect EWFM, Oracle,Mainframe and SQL databases. Data manipulation and transformation through the use of Microsoft SQL Server DTS packages  Creation of OLAP cubes, measures and calculated members in the Microsoft Analysis Servicesapplication Implementation of business rules and performance metrics through the use of MDX query language