Summary
Overview
Work History
Education
Skills
Timeline
Generic

Theodore Provencher

Scarborough,ME

Summary

IT professional with extensive experience in Healthcare data integration and ETL processes. Adept at collaborating with cross-functional teams, driving strategic data initiatives, and ensuring compliance with healthcare regulations (HIPAA, HITECH). Known for designing and optimizing workflows to enhance data quality and integrity. Reliable team player with focus on achieving results and adapting to changing project needs, showcasing skills in Informatica, SQL, and Oracle. Expertise in RDBMS, Enterprise Data Warehousing, Data Lakehouse and other data platforms, with a focus on high-performance data integration to support enterprise-wide reporting, AI-driven analytics, and digital health innovation.

Overview

29
29
years of professional experience

Work History

Data Architect - Google Cloud Data Platform

Hartford Healthcare
06.2023 - 07.2025
  • Designed and implemented scalable ETL templates in Google BigQuery, ensuring best practices and efficient data processing.
  • Developed data pipelines using CI/CD for continuous integration and delivery.
  • Created tables, data views for consumption, supporting enterprise-wide reporting and analytics.
  • Managed ETL job scheduling and pipeline creation.

Team Lead - Enterprise Data Intelligence

Hartford Healthcare
08.2017 - 05.2023
  • Led the maintenance of a cloud-based Hadoop Data Warehouse using Diyotta products, including ETL process development and scheduling.
  • Promoted a positive work environment by fostering teamwork, open communication, and employee recognition initiatives.
  • Optimized customer experience by delivering superior services and effectively troubleshooting issues.
  • Served as a role model for the team by demonstrating commitment to excellence, professionalism, and adherence to company values at all times.
  • Coached team members in techniques necessary to complete job tasks.
  • Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.
  • Collaborated with other department leads to streamline workflows, improve interdepartmental coordination, and achieve business goals collectively. Captured data needs for Bone and Joint Institute, Cancer Institute and HHC Quality Analytics Teams.
  • Led in the conversion of on premise Data Warehouse and its data pipelines to a Modern Analytics Cloud Platform.
  • Served as a vendor liaison to Clearsense, Diyotta (now ThoughtSpot), and Deloitte.
  • Managed data modeling and DDL development.
  • Utilized Informatica Enterprise Data Catalog, Data Quality, Axon.
  • Captured Data Lineage
  • Performed Data Profiling.
  • Employed Informatica address validation, match & merge processing in Power Center Workflows.

Database Archive Lead - Interoperability

Hartford Healthcare
03.2016 - 07.2017
  • Led application identification, data analysis, and data archiving solutions for applications being decommissioned as part of the enterprise conversion to EPIC EMR systems.
  • Managed vendor liaison activities for external data feeds, ensuring data accuracy and integrity.
  • Mapped various data formats (HL7, CCD, CDA, flat files) into an Oracle-based Legal Archive.
  • Developed bulk and custom format data load applications and tools.
  • Facilitated monthly steering committee meetings with the executive team.

.NET Software Developer, Full Stack

Hartford Healthcare
10.2014 - 02.2016
  • Note: On February, 29th 2016. Quest Diagnostics announced the completion of its acquisition of the outreach laboratory service business of Clinical Laboratory Partners (CLP), a wholly-owned subsidiary of Hartford HealthCare (HHC). Clinical Lab Partners held 95% of the market in CT. Quest Diagnostics held the remaining 5% at that time.
  • Developed and supported the Clinical Lab Partners Utilities Suite .Net application, providing functionality for call tracking, stat order tracking, home draw appointment tracking and scheduling, and lab supply orders.
  • Tuned and resolved errors in data loader applications, ensuring SQL Server data warehouse was in sync with source systems.
  • Performed database conversion of Cerner CoPath(on Sybase) to Sunquest CoPath (InterSystems Cache).
  • Created Microsoft SSRS Reports for internal and external customers.
  • Automated scheduling and revised vendor export applications.

SQL Server Database Administrator Consultant

Robert Half Technology
04.2014 - 10.2014
  • Identified customer’s SQL inefficiencies at database and applications levels. Documented and presented options for short and long term solutions, implementation included rewriting of stored procedures, index optimization and cluster schemes.
  • Created a daily process to automate maintenance of the database (table and index reorganization and/or rebuild based on database fragmentation percentages).
  • Identified performance issues within the client call center database and the two main applications that interact with it. The first was an daily automation process that brought in new customer leads from various web and IVR feeds, the second was a call center application used to reach out to interested leads.
  • Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
  • Documented analysis results and provided performance improvement feedback.
  • SQL Server 2008v2, SSIS, SSRS, Stored Procedures, Functions, Triggers, TSQL, Visual Studio 2012 (C# and VB.NET with Crystal reports), Robocopy, Putty, TFS.

Java Application Development Consultant

Robert Half Technology
08.2013 - 03.2014
  • Developed strategic plans for two aerospace clients that effectively addressed their specific needs and priorities.
  • Re-designed Java application (OBPHM (Off-Board Performance History Maintenance)). This application performs aircraft maintenance history tracking, trending and lifing of aircraft sensors, oil usage, etc. for F-16 Fighter jets. This application was running on Weblogic T3 10 and performing slowly.
  • Upgraded the technology stack from Java 1.5 with Weblogic 10.1 to use Java 1.7 with JBoss 6.2.
  • Created OSGi plugin's where possible to promote agile development and testing.
  • Built J2EE reporting tool application (EMMS Archive). The application allows users to access data for aircraft parts and maintenance history. The tool had user pages to allow free form SQL query entry as well as the ability to for users to create reports by selecting from certain tables and their column data for those not as SQL savvy. The application also had the functionality to store user created report criteria for future use. A user had the ability to access user reports, standard reports and a data dictionary report function (for users to look up column descriptions and research the columns that they may want to include in their reports).
  • Built all Oracle tables, views, indexes, triggers for EMMS Archive.
  • Coded JSP, EJB and servlets for EMMS Archive.
  • Participated in daily agile scrum meetings
  • J2EE 7, Java7, Eclipse, SVN, MVC, OSGi, JSP’s, Servlets, EJB’s, ORACLE, SQL Developer, SQL, PL/SQL, JMS, WebLogic, Apache Tomcat, JBoss, JUnit. MVC, additional Design Patterns.

App Development Sr. Specialist, Structured Analytics Environment (SAE)

Cigna
05.2008 - 06.2013
  • Designed and coded analytic Java models to identify risk, condition, and profile information about Health Care Customers and Providers.
  • Maintained a J2EE Model Metadata Application.
  • Authored and presented the Structured Analytics Environment Production Operations Manual.
  • Designed tables to ensure alignment of business goals and technical development data needs.
  • Managed a team to implement an external business customer disease management system (COBOL/DB2), saving Cigna almost $3M.

Enterprise Integration Architect

Aetna, a CVS Health
05.2007 - 05.2008
  • Engineered and coordinated builds, and served as a lead in environment data management and test integration.
  • Performed analysis of architecture and interface changes to determine enterprise project impacts.
  • Provided project integration resource allocation estimates.
  • Coordinated the test execution of in-scope projects.
  • Identified and communicated environment and coding issues and potential risks.

App Development Sr. Spec, Medical Management IT

Cigna
10.2000 - 05.2007
  • Led technical role on complex COBOL/DB2 Care Management/Well Aware Patient Disease Program identification batch application. Providing architecture, design, development, scheduling and support.
  • Performed DB2 Database Administration, Database Design, Data Modeling.
  • DB2 SQL Performance Tuning. Worked closely with DBAs to fix performance of Data Extracts. Cut Monthly batch processing time by 19 hours using High Performance Utility Extracts (HPU) to pull claim data from 32 partitions.
  • Implemented parallel partitioning solution to extract lab data. The process used DB2 System tables along with the partitioning keys to determine row volumes across partitions to automate the build of SQL extract selection criteria at batch run-time. This generated Extract load SQL ensured that the extracts were load balanced and the extracts could be run in parallel without any concern of partion overlapping or database locking conflicts.
  • Provided mentoring & training to Off Shore resources.
  • Devised and implemented processes and procedures to streamline operations.
  • Evaluated customer needs and feedback to drive product and service improvements.
  • Enhanced team skill sets with targeted training programs, elevating overall productivity and project outcomes.
  • Fostered culture of continuous improvement, leading by example and encouraging innovation at all levels.
  • Established strong working relationships with clients through exceptional customer service and proactive communication efforts.
  • Identified areas in need of critical improvement and implemented strategies to achieve targets.
  • Managed complex projects from inception to completion, ensuring timely delivery and client satisfaction.

Information Systems Specialist

Travelers Insurance
08.1999 - 10.2000
  • Application Development using CA Gen.
  • Component Based Development (CBD).
  • Maintained real-time and batch COBOL/DB2.

Systems Engineer

Travelers Insurance
01.1997 - 10.2000
  • Application development COBOL/DB2.
  • Database redesign and modeling of Self-Directed/Managed Care Systems into one (Well-Aware).
  • Designed, built, and deployed ETL processes for database data conversions.

Education

Bachelor of Science - Computer Information Systems

Westfield State University
Westfield, MA

Associate of Science - Business Administration

Asnuntuck Community College
Enfield, Connecticut

Skills

  • Healthcare Domain experience Patient, Providers, Claims, Lab, and Pharmacy
  • I have worked in both Non-Profit and For-Profit Healthcare organizations
  • Non-Profit: Hartford Healthcare
  • For-Profit: Cigna, Aetna
  • Data Architecture: Data Lakehouse, Data Mesh, ETL design, Data Modeling, Data Warehousing, Real-time streaming, Serverless Architectures
  • Data Integration & Governance: Informatica (IDQ, PowerCenter, EDC, Axon), Diyotta Studio, Data Profiling, Data Quality, Data Lineage, Master Data Management, Data Security, Audit Trails
  • Cloud Platforms: Google Cloud Platform (BigQuery, ETL, Dataflow, Composer, Pub/Sub), Terraform, yaml, Apache Airflow, Looker
  • Programming Languages: Python, SQL, Java, C#, ASPNET, VBNET, JavaScript, PL/SQL, COBOL
  • Scripting Languages: Python, Linux Shell Scripts, Bash, PowerShell
  • Databases: Oracle, DB2, BigQuery, PostgreSQL, Hadoop, SQL Server, Intersystems Caché, Sybase, MySQL, Splice Machine, IMS
  • Healthcare Data: Epic Caboodle, HL7, CCD, CDA
  • Methodologies: Agile, Scrum, Waterfall, DevOps, CI/CD, Lean (Bronze Certification)
  • RDBMS
  • Database optimization
  • Project management
  • Written communication
  • Adaptability
  • Continuous improvement
  • Interpersonal communication
  • Python programming
  • Goal setting
  • Analytical thinking
  • Interpersonal skills
  • Task prioritization
  • Team building
  • Relationship building
  • Decision-making
  • SQL Stored Procedures, Common Table Expressions (CTE), Temporary tables, Materialized Views
  • Team collaboration
  • Active listening
  • Effective communication
  • Adaptability and flexibility
  • SQL
  • ETL development
  • SQL expertise
  • Data quality management
  • Data migration
  • Data Conversions
  • Database design
  • Data analytics
  • Data lake management
  • System architecture design
  • Data governance
  • Data security
  • Data warehousing expertise
  • Key performance indicators
  • Logical and physical data modeling
  • Performance tuning
  • Data warehousing
  • Master data management
  • Data cataloging
  • Data profiling
  • Report generation
  • Change data capture
  • Metadata management
  • Structure designs
  • Data lineage
  • Enterprise information architecture
  • Data integration
  • Warehouse models
  • Teamwork and collaboration
  • Problem-solving
  • Attention to detail
  • Problem-solving abilities
  • Excellent communication
  • Critical thinking
  • Organizational skills
  • ETL processes
  • Java programming
  • Load balancing
  • Database management
  • Database development
  • Requirements gathering
  • Software development
  • Analytical skills
  • RDMS design
  • System analysis
  • Microsoft SQL server
  • Data integrity assurance
  • Documentation tools: MS Visio (for Data Models, Scheduling, Data Integration Flows) MS PowerPoint

Timeline

Data Architect - Google Cloud Data Platform

Hartford Healthcare
06.2023 - 07.2025

Team Lead - Enterprise Data Intelligence

Hartford Healthcare
08.2017 - 05.2023

Database Archive Lead - Interoperability

Hartford Healthcare
03.2016 - 07.2017

.NET Software Developer, Full Stack

Hartford Healthcare
10.2014 - 02.2016

SQL Server Database Administrator Consultant

Robert Half Technology
04.2014 - 10.2014

Java Application Development Consultant

Robert Half Technology
08.2013 - 03.2014

App Development Sr. Specialist, Structured Analytics Environment (SAE)

Cigna
05.2008 - 06.2013

Enterprise Integration Architect

Aetna, a CVS Health
05.2007 - 05.2008

App Development Sr. Spec, Medical Management IT

Cigna
10.2000 - 05.2007

Information Systems Specialist

Travelers Insurance
08.1999 - 10.2000

Systems Engineer

Travelers Insurance
01.1997 - 10.2000

Bachelor of Science - Computer Information Systems

Westfield State University

Associate of Science - Business Administration

Asnuntuck Community College

Similar Profiles

CREATE PROFILE
Theodore Provencher