Jonathan Yeo
Pilot Point,TX
Summary
Results-driven professional specializing in data warehousing, ETL processes, and cloud integration. Proven track record in leveraging tools like Informatica and Snowflake to enhance operational efficiencies and collaboration across departments.
Overview
25
25
years of professional experience
2
2
Certifications
Work History
Manager Business Systems
RTX Inc
Dallas, Tx
11.2025 - Current
- Managed business systems for RTX Corporate, integrating internal and cloud-based systems using Informatica IDMC, Matillion, and Databricks to streamline data access.
- Supported numerous government defense projects through effective data integration with Snowflake and databases.
- Developed operational strategies that enhanced process efficiency across various departments.
- Facilitated collaboration among departments, resulting in improved workflow efficiency.
ETL Team Lead/Consultant
DataFluency LLC
Dallas, Tx
11.2003 - 11.2025
- Developed enterprise-level data integration systems utilizing Agile methodologies and Six Sigma principles.
- Leveraged Oracle SQL Server, SAP HANA, and AWS Redshift to enhance data management capabilities.
- Integrated Hadoop and Informatica BDM to optimize data processing capabilities.
- Utilized SQL Server SSIS for effective data transformation and integration processes.
- Enhanced data integration workflows by employing Intelligent Data Platform methodologies.
- Implemented industry best practices, improving organizational standards and performance metrics.
- Supported Raytheon Global Enterprise Services by delivering innovative cloud analytics solutions.
- Analyzed customer feedback to pinpoint areas needing enhancement in service delivery.
Consultant
HP
Dallas, Tx
02.2012 - 02.2013
- Delivered 24/7 critical support for Cigna’s claim processing system.
- Resolved major issues to restore HP's compliance with Cigna requirements.
- Resolved major issues, restoring HP's compliance with Cigna requirements.
- Applied new procedures, ensuring Cigna's continued partnership with HP.
- Managed project documentation, ensuring compliance and accuracy throughout.
- Mentored junior team members on best practices and methodologies.
Developer
Oracle Corp.
Toronto, CA
08.2011 - 12.2011
- Wrote PL/SQL procedures and packages to enhance data processing capabilities utilizing Oracle 11g and OWB.
- Developed Oracle procedures to streamline data loading into Metasolv Telecom provisioning system for Frontier Telecom.
- Participated in code reviews to uphold coding standards and enhance team practices.
- Troubleshot technical issues, delivering timely support to application users to minimize downtime.
Developer
UTC
Hartford, Connecticut
11.2010 - 12.2011
- Developed and implemented Financial Analysis Data Warehouse for United Technologies, enhancing analysis and reporting capabilities for UTC global operations, including ODS for Financial Management using Informatica 9, sourcing from JD Edwards, SAP, Baan, Oracle e-business Suite, and legacy systems. Introduced AGILE project management methodology to UTC and completed Phase 1 of Data Warehouse implementation.
- Developed software solutions in Java and Python, contributing to project deliverables and enhancing application performance.
- Collaborated with teams to design user-friendly interfaces, improving user experience for applications.
- Implemented code reviews to ensure quality and adherence to best practices.
Data Conversion Specialist
Ameripath
Dallas, Texas
11.2009 - 11.2010
- Recruited back to Ameripath’s Data Conversion team to help with New Lab Implementations. Extracting, Transforming, Profiling data and loading into new Pathway lab systems, along with providing ETL, D/W expertise with the new D/W initiative. ETL using PL/SQL, XML,Oracle 10g, Packages and Procs. Loading data into Oracle OM/SQL Server utilizing SSIS, and Oracle CRM systems.
- Collaborated with IT teams to resolve data conversion issues, facilitating successful project implementations.
- Streamlined data entry processes for patient records and laboratory results, enhancing overall data integrity.
- Validated data against source documents to ensure accuracy and reliability.
ETL/Data Warehouse Manager
USPI
Dallas, Texas
02.2007 - 11.2009
- ETL/Data Warehouse Manager. Solely responsible for Data Warehouse and BI and Cube reporting systems. Utilizing Informatica and Microsoft SQL services, Analysis Services, and Reporting Services and OLAP. Upgrading Infa V7 to V8. SSAS Cubes Support and Redesign. Utilizing Informatica Push Technology. Supporting clients' existing D/W. Designing, Modeling and Development of further phases and enhancements to D/W and new Data Marts to feed new Executive BI and Reporting requirements. Informatica Admin and DBA. Using Informatica Web Services.
- Supervised daily warehouse operations, enhancing team performance through effective management.
- Coordinated inventory control and organized stock replenishment to maintain optimal stock levels.
- Monitored safety compliance and enforced proper handling procedures.
Development ETL Lead
Idearc Media
Dallas, Texas
11.2008 - 03.2009
- Managed Informatica production systems on Oracle, Teradata, and UNIX, ensuring system reliability and performance.
- Executed daily operational tasks with precision
- Contributed innovative ideas and solutions to enhance team performance and outcomes.
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
ETL Specialist/Oracle DBA
Ameripath
Dallas, Texas
06.2005 - 02.2007
- Delivered DBA production support and customer support while designing database and implementing backup processes using RMAN for new Lab Information System.
- Assisted in managing patient records and ensuring accurate documentation.
- Coordinated communication between medical staff and patients effectively.
- Implemented best practices for maintaining compliance with health regulations.
Lead Production DBA/Support
BlockBuster
Dallas, Texas
07.2004 - 07.2005
- Executed data modeling and design for new warehouse and online applications using ERWIN, enabling real-time data push with Oracle Advanced Queues.
- Managed database systems for efficient data storage and retrieval.
- Monitored database performance and resolved issues proactively.
- Implemented security measures to protect sensitive customer information.
Data Modelling/Migration/Development DBA specialist
Metasolv Corp
Denver, Colorado
01.2004 - 07.2004
- Led team of developers in migrating customer data from legacy system to new TBS system, ensuring data integrity during Metasolv Customer TBS implementation.
- Administered databases for optimal performance and reliability.
- Implemented backup and recovery procedures for data security.
- Monitored system health and resolved issues promptly.
ETL Design Consultant
Flowserv
Salt Lake City, Utah
10.2003 - 01.2004
- Developed ETL processes with Ascential DataStage to efficiently load data into Oracle ODW for Flowserve.
- Created detailed design proposals using industry-standard software tools.
- Collaborated with clients to understand design needs and preferences.
- Conducted design reviews to ensure alignment with client expectations.
Project Lead/ETL Development
Cambridge ISG
Dallas, Texas
07.2003 - 11.2003
- Led project teams to ensure timely completion of deliverables.
- Facilitated communication between stakeholders and team members to ensure alignment and clarity on project objectives.
- Developed project plans outlining timelines and resource allocation.
- Supported data warehousing extract team in generating data extracts for Fortune 500 customers from Cambridge's claims processing system to enhance data availability in Oracle-based data warehouse.
ETL Project Manager
Alliance Data Systems
Dallas, Texas
01.2003 - 10.2003
- Led team of ETL developers in data extraction, conversion, and loading from legacy energy provisioning system to new system, ensuring smooth transition for major energy corporation.
- Led project planning sessions to define objectives and deliverables.
- Developed project timelines and monitored progress to ensure adherence.
- Collaborated with cross-functional teams to streamline project workflows.
Ab-initio and ETL resource
HEB Pharmacy Division
San Antonio, Texas
01.2003 - 07.2003
- Facilitated design and development of Data Warehouse to enhance Microstrategy BI reports and optimize Ab-Initio production jobs through performance tuning.
- Executed daily operational tasks with precision in a fast-paced environment.
- Contributed innovative ideas and solutions to enhance team performance and outcomes.
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
Informatica/ETL Lead
Waste Management
Houston, Texas
07.2002 - 07.2003
- Joined Waste Management's Project Phoenix team to design and implement the Enterprise Data Warehouse by extracting data from WM's IBM AS400 systems across 25 regions and 770 sites. Designed baseline and staging area data definitions using ERWIN and executed the ETL process across multiple phases, consolidating Accounts Receivable data from 700+ AS-400 libraries into a two-terabyte Oracle 8i Operational Data Store on an AIX server with Informatica PowerCenter 6.2 and PowerExchange. Customized an Informatica Analytics Data Warehouse using OWB, sourcing data from a Customer ODS and a Peoplesoft EPM ODS, before loading into Informatica Business Analytics for executive reporting utilizing Business Objects 5.0 and 5.1.
- Operated computer systems to monitor waste processing and collection schedules.
- Executed data entry tasks for service requests and customer accounts using software tools.
- Reported on waste disposal metrics and assessed service efficiency to inform operational improvements.
Project Manager
Threshold Consulting
Tampa, Florida
01.2003 - 04.2003
- Led cross-functional teams, aligning project objectives and ensuring timely delivery of milestones.
- Developed project plans outlining scope, timeline, and resources required.
- Facilitated regular meetings to communicate project progress and address challenges, fostering collaboration among team members.
- Managed ETL development at Threshold, creating SQL Server-based data warehouse for commercial advertising client, utilizing Informatica and SQL Server.
Informatica/ETL/DBA Development Team Lead
Kintetsu Global IT (KGIT)
Dallas, Texas
02.2002 - 07.2002
- Executed data loads of IATA rate loading information into a global web-based system using Informatica Version 5.2, transferring data from Oracle, SQL Server, flat files, Access, and Excel to Oracle targets to maintain data availability and integrity.
- Administered database systems for efficient data storage and retrieval.
- Monitored system performance and implemented necessary optimizations.
- Collaborated with teams to design and implement data security measures.
Informatica Developer/Administrator
American Airlines
Dallas, Texas
12.2001 - 02.2002
- Developed ETL processes for data integration and migration projects.
- Optimized existing workflows to enhance data processing efficiency and reliability.
- Collaborated with cross-functional teams to define data requirements and specifications.
- Developed and deployed Oracle database to support core CRM functionalities, enhancing data accessibility and user experience.
Principal DBA Consultant
Intelinet Systems
05.2001 - 12.2001
- Consulting with the Professional Services director to set up Intelinet's Oracle offerings and partnership. Working with the Professional Services Director to help set up Intelinet's Remote DBA Service offering, including designing developing and presenting the DBA offerings to clients. Supporting all of Intelinet's Remote DBA customers using OEM 2.2, Web server access using Oracle 8I and 9I products. Supporting Intelinet's other professional Service offerings including Oracle's Application offerings, Oracle 9I Applications Server and Oracle CRM OWB. Designing, developing and implementing Oracle iportal solutions for Intelinet's customers, and own internal Intranet sites. - Using iPORTAL, HTML. Designing, Developing and implementing Oracle's Portal-to-go product - 9iAS Wireless solutions for Intelinet's customers. Project Management of many of Intelinet's Customers. Providing consultancy to Intelinets clients on Data Migration ETL and Data Warehousing design and Implementation for various clients using OWB, PL/SQL and ORACLE ETL tools, small ETL, Data Cleansing and Loads - Several short Assignments - Simple to Mid-level complexity Loads, Approximately 20-30 tables for each. Performing Assessment of the Customer's Oracle Databases, and recommending changes, including Tuning, Backup Strategies etc. Designing/Implementing and Testing Backup and Recovery Strategies, Upgrades, Installations, Conversions etc for Intelinet's Customers. Performing assessments on customers current Strategies and recommending improvements. Contract for Vartec Telecom – Providing Oracle and TBS Expertise to Vartec as they transitioned to METASOLV TBS from their homegrown legacy system – SQL Server, Oracle 8i, and METASOLV TBS Version 5.
- Administered database systems to ensure data integrity and security.
- Monitored database performance and optimized queries for efficiency.
- Collaborated with developers to design and implement database solutions.
Education
BSc. - Computer Studies
University of Manchester Institute of Science and Technology
Manchester, England01-1987
Skills
- Data warehousing and migration
- Data integration and quality
- Cloud services integration
- Informatica PowerCenter and IICS
- Master data management (MDM)
- Database administration
- SQL Server and Oracle expertise
- Data mining and profiling
- Performance tuning strategies
- Project management and reporting
- ETL processes
- Team collaboration
- Agile methodologies
- Project planning
- Process optimization
- Problem resolution
- Effective communication
- Cross-functional teamwork
- Workflow efficiency
- Quality assurance
- Regulatory compliance
- Key performance indicators (KPIs)
- Team leadership
- Stakeholder management
- Staff training and development
- Lead generation strategies
- Policy implementation
- Change management
Certification
• Oracle Data Warehouse Overview, Oracle
• Informatica BDM Developer Training
• Informatica BDM Admin
• Amazon Web Services (AWS)
• Informatica BDM Developer Training
• Informatica BDM Admin
• Amazon Web Services (AWS)
References
Available on Request
Timeline
Manager Business Systems
RTX Inc
11.2025 - Current
Consultant
HP
02.2012 - 02.2013
Developer
Oracle Corp.
08.2011 - 12.2011
Developer
UTC
11.2010 - 12.2011
Data Conversion Specialist
Ameripath
11.2009 - 11.2010
Development ETL Lead
Idearc Media
11.2008 - 03.2009
ETL/Data Warehouse Manager
USPI
02.2007 - 11.2009
ETL Specialist/Oracle DBA
Ameripath
06.2005 - 02.2007
Lead Production DBA/Support
BlockBuster
07.2004 - 07.2005
Data Modelling/Migration/Development DBA specialist
Metasolv Corp
01.2004 - 07.2004
ETL Team Lead/Consultant
DataFluency LLC
11.2003 - 11.2025
ETL Design Consultant
Flowserv
10.2003 - 01.2004
Project Lead/ETL Development
Cambridge ISG
07.2003 - 11.2003
ETL Project Manager
Alliance Data Systems
01.2003 - 10.2003
Ab-initio and ETL resource
HEB Pharmacy Division
01.2003 - 07.2003
Project Manager
Threshold Consulting
01.2003 - 04.2003
Informatica/ETL Lead
Waste Management
07.2002 - 07.2003
Informatica/ETL/DBA Development Team Lead
Kintetsu Global IT (KGIT)
02.2002 - 07.2002
Informatica Developer/Administrator
American Airlines
12.2001 - 02.2002
Principal DBA Consultant
Intelinet Systems
05.2001 - 12.2001
BSc. - Computer Studies
University of Manchester Institute of Science and Technology