Ray Passage Oracle OIC * Data Integration * Cloud API * PL/SQL * ETL * Python *

Data Warehouse Architect/Developer

Linedata

Apr 2013 - Jan 2017 (3 years 10 months)

Data Integrator

Dendreon

Mar 2019 - Current (7 years 2 months)

As a Data Integrator, I was responsible for designing, creating, maintaining, and deploying critical cloud and on-premise OIC integrations and pipelines to support the company’s Transportation Management System, Master Data Management (MDM), immunotherapy treatments, and logistics/scheduling database. I possess strong knowledge of OIC application-driven orchestrations, schedule orchestrations, and various integration styles, including publish and subscribe, along with expertise in configuring OIC connections using RESTful, SOAP, and Oracle adapters. My role involved configuring Oracle, Salesforce, and third-party APIs with various endpoint actions (POST, PATCH, GET, DELETE) and building request and response payloads in JSON, XML schema, XSD

Data Integration Developer

Dendreon

Mar 2019 - Jul 2025 (6 years 5 months)

As a Data Integration Developer, I was responsible for designing, creating, maintaining, and deploying critical cloud and on-premise OIC integrations and pipelines to support the company’s Transportation Management System, Master Data Management (MDM), immunotherapy treatments, and logistics/scheduling database. I possess strong knowledge of OIC application-driven orchestrations, schedule orchestrations, and various integration styles, including publish and subscribe, along with expertise in configuring OIC connections using RESTful, SOAP, and Oracle Salesforce adapters. My role involved configuring Oracle, Salesforce, and third-party APIs with various endpoint actions (POST, PATCH, GET, DELETE) and building request and response payloads in

M

Data Warehouse Architect/Developer

Mantis Technologies Software Solution Provider

Jun 2012 - Mar 2013 (10 months)

As a Data Warehouse Architect/Developer, I was responsible for designing and developing robust DW/BI architecture, including ETL processes and star schemas, specifically tailored for materials management to support Boeing’s Goldcare Performance Metrics program. My role involved extensive data analysis and troubleshooting to ensure optimal performance and reliability of the data warehouse. Additionally, I utilized SQL to manage and query large datasets effectively. I also engaged in online research to stay updated on best practices and resolve complex data architecture issues, which was essential for maintaining the integrity and efficiency of our systems. This commitment to continuous learning and problem-solving significantly contributed t

S

Technical Lead

Seattle City Light

Mar 2003 - Mar 2012 (9 years 1 month)

As a Technical Lead, I was responsible for overseeing the development and implementation of technical solutions, ensuring high-quality deliverables that met project requirements. My role involved report development and data analysis, utilizing SQL to extract and manipulate data effectively. I also led troubleshooting efforts to resolve complex technical issues, ensuring minimal disruption to project timelines. Additionally, I engaged in online research to enhance my understanding of geographic and technical challenges, which proved essential in devising innovative solutions and improving overall project outcomes.

Ray Passage

About

Detail

Timeline

Résumé