Tim Mercier
Naperville,IL
Summary
Self-motivated data management professional with over 15 years’ experience, excelling in problem-solving and technical knowledge. Proficient at navigating deadlines and able to manage competing priorities in fast-paced environments. Drives high-impact data solutions and decision-making through strategic AI and technology integration.
Overview
16
16
years of professional experience
2
2
Certifications
Work History
Managing Consultant
Vision Data Solutions
01.2022 - Current
- Collaborated with vendors to negotiate contracts on behalf of the client for PIM/MDM and data migration projects
- Spearheaded a sustainability-focused migration project from an existing PIM to the PimCore platform, achieving a 40% improvement in data accuracy and reducing data management tasks by 25%, enhancing long-term system viability
- Leveraged analytic skills, data science and advanced AI capabilities of ChatGPT APIs to significantly enhance data enrichment procedures, resulting in a 75% increase in product data completeness and the development of a product quality scoring system
- Managed, coached, and fostered professional development within a diverse team of 8 professionals to successfully execute a Product Information Management project, effectively utilizing a $350K budget
- Developed a data enhancement strategy, combining proprietary data with web-scraped content to enrich product attributes and specifications, leading to a 25% enhancement in search relevance
- Orchestrated the implementation of new cloud design and ETL processes reducing processing time by 40%
- Revamped the legacy reporting to a dimension-oriented data mart, cutting report turnaround time by 50% and boosting operational efficiency.
Director, Data Engineering and Reporting
Amsive
01.2019 - 01.2022
- Led the overhauling of the Customer Data Platform (CDP), enabling faster matching, merging, and cleansing of customer data, slashing processing times by 900%
- Administered a $1.5 million budget, encompassing infrastructure, software, and personnel
- Led 4 teams of 12 people (ETL, Reporting, Project Management, and Business Analysis) to provide data services, solutions development, data lifecycle management, and reporting for 45+ marketing clients
- Worked with sales for client projects and created reusable product offerings, enhancing client satisfaction and operational efficiency
- Modernized ETL and databases from private cloud to services in Azure cloud primarily utilizing Azure Data Factory, Pipelines, and Azure databases
- Management of technology infrastructure, including server maintenance, patching, and development tools, improving system reliability and efficiency
- Steered the technology /SDLC processes while nurturing client relationships and managing expectations.
Technology Manager, Senior Enterprise Architect
True Value Company
01.2015 - 01.2019
- Developed and executed technology roadmaps detailing retirement and proliferation plans for 20+ applications, resulting in the decommissioning of legacy systems and saving the company $500k in maintenance annually
- Calculated costs and timelines for 5 strategic initiatives, enabling senior leadership to make data-driven decisions that resulted in a 20% increase in ROI and a 15% reduction in project timelines
- Launched Product Information Management (PIM) strategy reducing time to market for new products by more than 500%, reducing quality of the data enrichment processing by more than 50%, and improving workflow
- Revitalized the Architecture Review Board by emphasizing early decision-making over design reviews, resulting in a 15% improvement in project timelines and a 25% increase in project success.
Senior Manager, Enterprise Data Warehouse
Adtalem
01.2011 - 01.2015
- Managed 3 development teams of 14 people (ETL/data flows and Cognos development and support)
- Built data warehousing development framework to improve support & enhance collaboration between teams
- Streamlined the reporting and analytics functions by centralizing teams, enhancing productivity and collaboration
- Led the transformation of the MDM strategy, transitioning from a custom-built repository to an enterprise MDM hub and spoke, resulting in a 30% increase in data accuracy
- Set data standards, defined, documented, and maintained enterprise data architecture, data dictionary, metadata management, data catalog, use cases and sox compliance
- Championed goal setting within cross-functional teams, fostering a culture of accountability and continuous improvement
- Adopted a coaching stance, providing regular feedback, setting developmental goals, and facilitating a learning environment that supported career growth and improved team performance metrics
- Led a development planning initiative that identified and nurtured high-potential talent, preparing them for leadership roles as part of our succession planning strategy, thereby ensuring continuity and the retention of critical skills within the organization.
Manager, Enterprise Data Architect
Grant Thornton
01.2008 - 01.2011
- Developed technology roadmaps detailing retirement and project plan for proliferation of legacy applications, resulting in significant cost savings, and increased operational efficiency
- Produced 30+ architectural designs based on technology roadmaps, proof of concepts and prototypes, and industry trends for handoff to development teams
- Streamlined reporting and analytics functions by centralizing teams, enhancing productivity, and fostering collaboration
- Led and provided mentorship to a team of data architects and developers in designing and implementing a comprehensive data management framework for all database management systems to improve all data transformations and SQL queries
- Spearheaded the transformation of the Master Data Management (MDM) strategy, transitioning from a custom-built repository to an enterprise MDM hub and spoke model, resulting in a 30% increase in data accuracy and improving data governance
- Established and maintained data standards, enterprise architecture and project documentation to ensure consistency and compliance
- Built strategic partnerships with executive leadership, effectively communicating, and leveraging resources to foster acceptance of proposed technology roadmaps, aligning with corporate strategic goals.
Education
Bachelor of Science - Computer Information Systems
DeVry University
Skills
Data Warehousing
Data Strategy
Business Intelligence
Solution Design
Program Management
Project Execution
Machine Learning (ML)
Artificial Intelligence (AI)
Data Analytics
IT Leadership
Data Analysis
Cloud Technologies – Azure, Google Cloud (GCP), AWS
Data Visualization - Business Objects, Cognos, Tableau, Power Bi, SSRS
RDBMS / NoSQL – MS SQL Server, MySQL, Oracle, DB2, Azure SQL, Snowflake, Azure Synapse
ETL/ELT Tools - Azure Data Factory (ADF), SSIS, Informatica, Data Integrator, DataPrep, Talend
Data Privacy & Security (PII/HIPAA)
Data Modeling (OLTP/OLAP)
Application Development - NET, C#, Java, Python, APIs
Version Control Systems - Azure DevOps, Git, TFS
Database Design/Model Tools – Erwin, ER Studio, Lucid Chart
Analytics Platforms – Databricks, Azure Synapse Analytics
Data Storage Azure Blob Storage, Google Buckets
Powerpoint, Visio, Microsoft Office, MS Project, Sharepoint
Unit Testing – NUnit, JUnit, MSTest
Websites
Certification
Microsoft Azure Fundamentals
Accomplishments
- Directed various data projects with budgets ranging from $350K to $1M, improving product data quality and completeness.
- Managed teams of 3-15 direct and indirect reports across multiple projects.
- Managed multiple large-scale data warehousing and integration projects.
- Utilized AI to boost data quality, improving product data completeness and establishing a product quality scoring system.
- Implemented a data enrichment/quality strategy, merging proprietary and web-scraped data for product catalogs.
- Played a pivotal role in several cloud migrations, facilitating the seamless transition of data and systems across multiple cloud platforms.
Timeline
Managing Consultant
Vision Data Solutions
01.2022 - Current
Director, Data Engineering and Reporting
Amsive
01.2019 - 01.2022
Technology Manager, Senior Enterprise Architect
True Value Company
01.2015 - 01.2019
Senior Manager, Enterprise Data Warehouse
Adtalem
01.2011 - 01.2015
Manager, Enterprise Data Architect
Grant Thornton
01.2008 - 01.2011
Bachelor of Science - Computer Information Systems
DeVry University