Caleb Mills

Caleb Mills Email and Phone Number

Sr Data Engineer @ Pratt & Whitney
Caleb Mills's Location
Yukon, Oklahoma, United States, United States
About Caleb Mills

Caleb Mills is a Sr Data Engineer at Pratt & Whitney. Colleagues describe him as "I had the pleasure of managing Caleb Mills for a year while he served in his role as a Senior Data Engineer at OU Health. Caleb is one of those rare talents that has a true understanding of data and data structure. He can design and build ETL integrations, write data analysis queries, design and build data models, and teach all aspects of his skillset to his peers with ease and clarity. Caleb also showed great skill in leading and managing projects from finish to end while always meeting deadlines. I would also entrust him with many meetings in my absence as I had full confidence in his abilities to work well with leaders in the organization. Caleb will be an asset to any team that he joins.", "Caleb is one of the best Data Engineers that I have had the pleasure to work with. He's a very collaborative and highly cross-trained professional that can fill multiple IT domain specific roles which makes him highly versatile. Caleb's prior experience as a DBA and programmer enables him to see items from a solutions architecture perspective, These are elements items that the typical Data Engineer do not typically have coming into a data engineer team. In addition to the highly versatile experience that Caleb brings - he brings a true passion to his work, but puts a highly emphasized focus on putting the customer first, mentoring those around him and being very clear of what the ask is and then executing on the ask. During my time working with Caleb, he quickly filled in a much needed informal leadership role where he dug deep into understanding data warehousing technologies like Snowflake, DBT, FiveTran, Matillion and etc.. He did an amazing job to help reduce reliance on contract labor, while also helping to implement a new modern data warehousing stack. If you find yourself reading this comment and having the opportunity to hire Caleb on your time... my suggestion is "act fast, because you won't regret it". Caleb is a team member that gives 200% everyday and adds so many intangibles to a data team culture and impact that are not easy to find.", and "I've worked directly with Caleb (both of us in Sr. Data Engineers positions) and I really cannot speak highly enough of Caleb. He's an impact player - he's highly skilled in almost everything data related, he's a great communicator, he dives head first into messy problems, he's unrelenting in finding solutions, and he focuses on the needs of the business. There's no task or project of which Caleb could not only handle but deliver stellar results. Glad I got to work with him for a time."

Caleb Mills's Current Company Details
Pratt & Whitney

Pratt & Whitney

View
Sr Data Engineer
Caleb Mills Work Experience Details
  • Pratt & Whitney
    Sr Data Engineer
    Pratt & Whitney Feb 2023 - Present
    East Hartford, Ct, Us
  • Ou Health
    Sr Data Engineer
    Ou Health Jan 2022 - Jan 2023
    Oklahoma City, Oklahoma, Us
    Sr Data Engineer architecting pipeline solutions into our cloud based data warehouse- Administering and developing Snowflake object security, tables, procedures, monitoring usage, etc- Developing data ELT pipelines using Fivetran - Creating data transformations for Snowflake objects using dbt's cloud based development tool- Developing ETL packages in SSIS for SQL Server 2019 for data ingestion from the Electronic Medical Records systems such as Meditech and others- Administering SQL Server 2019, as needed; managing the database backup job, index maintenance, agent jobs, etc.
  • Ppok
    Sr Database Administrator
    Ppok Jun 2018 - Dec 2021
    Oklahoma City, Oklahoma, Us
    - Administered three production SQL Server clusters with seven Availability Groups spread over two data centers for disaster recovery. In total, there were 22 SQL Server Instances to administer and monitor with the addition of many single server instances from SQL Server 2008 to 2019, with most using 2016 to 2019. - Created a configuration database to manage all instances and maintenance ran against them on our independent Job Server; this included backups, index maintenance, auditing, etc. - Wrote 30+ SSIS packages to perform these maintenance task automatically, and wrote Power BI and SSRS reports to keep track of performance indicators over time. - Worked with the Application Development team and the Analytics team on query tuning and performance improvements using SQL Execution Plans.
  • Ppok
    Sql Developer/Analyst Iii
    Ppok Apr 2015 - May 2018
    Oklahoma City, Oklahoma, Us
    Senior EDW developer focused on building out the new warehouse, reporting and dashboarding, and process improvement to existing ETL pipelines- Wrote and re-wrote many SSIS ETL packages, SSRS and Power BI reports, SQL Server Stored Procedures, and performance tuned that TSQL to best of my ability. - Implemented a Kimball method star schema Data Warehouse, and wrote the ETL SSIS packages to load it on a daily basis. - Modified an existing ETL process that handled all of the company's incoming claims and brought the load times down from 3 to 4 hours, or more on bad days, to 20 minutes. In addition, this opened the door to process external claim flat files on the same day instead of the following day as the process had been. This enabled the company to generate reports and dashboards now for the previous day instead of always two days behind.
  • Vha Inc.
    Etl Developer
    Vha Inc. Aug 2011 - Mar 2015
    Irving, Texas, Us
    Senior lead developer for the EDW and all incoming and outgoing business processes via ETL- Administered our local SQL Server 2008 R2 instance and a Rocket D3 v9.02 mvBase database- Wrote many SSIS packages to extract data from our D3 database and write it into our SQL Server Data Warehouse so we could use that data for reporting, exporting, comparing to new import files, etc.- Wrote a new Eligibility Import process using SSIS and Stored Procedures that allowed all of our eligibility files to be processed in a matter of minutes instead of the 8 hours it was taking with separate Access Databases for each client. The process not only improved efficiency greatly but also increased the accuracy as all files were now handled with the same logic inside the code.
  • Oklahoma Heart Hospital
    Applications Developer
    Oklahoma Heart Hospital Sep 2008 - May 2011
    Oklahoma City, Ok, Us
    Technical lead developer for the Business Applications MIS team that oversaw the Internet, Intranet, Payroll, HR, Accounting, Patient Billing, and several others. - Implemented and administered SharePoint 2007 as the company Intranet- Wrote custom C# webparts for the Intranet home page and other pages as needed- Wrote and performance tuned many SQL Stored procedures. The most impact was made on payroll where it decreased the processing time from 4 hours per company down to 45 minutes over 6 companies (4.5 hours of processing time vs 24 hours)- Created SSIS packages to import and export hospital data for HR, Payroll, the Business Office, and Accounting.- Improved the company's public website with many enhancements that included a complete revamp of the HR section. It was modified from being a simple post card advertisement to an interactive site with full company information and benefits, and job postings for the candidates to apply for via its integration with HRLogix.
  • Chesapeake Energy
    Developer/Analyst
    Chesapeake Energy Dec 2006 - Aug 2008
    Oklahoma City, Ok, Us
    Developer focused on designing .NET applications that interacted with Livelink's document management system, Kofax's document imaging software, and SharePoint.- Built a custom C# .NET webpart for SharePoint that aggregated multiple workflow assignment systems into one location so managment and other users had one location to find all active task.- Developed Livelink Web Report searches using ASP.NET to help geologist find documents fast while integrating key geological data from other Oracle databases. Instrumental in pushing for Materialized Views which ultimately sped up user accessibility by 90%.- Created workflows in K2 and built ASP.NET C# webpages around the workflow steps to allow users to interact with the workflow, upload relevant documents or comments, and attached a user's approval.- Build an asynchronous C# Windows application for the mail room to allow them to quickly search for employee offices that saved an estimated 2.2 hours per day over the old method.
  • Kerr Mcgee Oil & Gas Corp
    Analyst
    Kerr Mcgee Oil & Gas Corp Dec 2003 - Dec 2006
    Junior developer responsible for all service tickets for the team, Intranet modifications and enhancements, building document management process, and assigned work on the public Internet site.- Created a Livelink classification structure for IT application documents that allowed users to find documents through three classifications. - Worked with the team to redesign Kerr-McGee.com into a classic ASP site with the content management system backend so Corporate Communications could update any webpage on their own.- Designed a SQL database, TSQL procedures, workflow, and internal website to manage SOX access request and change controls.- Built internal Intranet sites using XSL to consume the XML output from Livelink's website and document system

Caleb Mills Education Details

  • University Of Oklahoma
    University Of Oklahoma
    Management Information Systems
  • The University Of Tulsa
    The University Of Tulsa

Frequently Asked Questions about Caleb Mills

What company does Caleb Mills work for?

Caleb Mills works for Pratt & Whitney

What is Caleb Mills's role at the current company?

Caleb Mills's current role is Sr Data Engineer.

What schools did Caleb Mills attend?

Caleb Mills attended University Of Oklahoma, The University Of Tulsa.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.