Experience

Revel IT
• United States
• IT Services and IT Consulting
• 1 - 100 Employee
• Architect Data Governance/Data Warehousing

  • Aug 2021 - Present


Lightwell Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Architect - Analytics Practice

  • Sep 2017 - Present

  Columbus, Ohio Area

• Architect - Analytics

  • Sep 2017 - Present

  Columbus, Ohio Area • Designed and implemented ETL development and ETL execution architectures • Designed and developed data warehouse models • Developed and implemented ETL processes and programs to populate and maintain the data warehouse models • Implemented a back-office architecture on AWS to support internal development projects and client demos o Built and configured AWS EC2 instance (Windows 2016) o Installed and configured SQL Server 2016 with testing and demo databases o Installed and… Show more • Designed and implemented ETL development and ETL execution architectures • Designed and developed data warehouse models • Developed and implemented ETL processes and programs to populate and maintain the data warehouse models • Implemented a back-office architecture on AWS to support internal development projects and client demos o Built and configured AWS EC2 instance (Windows 2016) o Installed and configured SQL Server 2016 with testing and demo databases o Installed and configured Informatica Server o Installed and configured Informatica Clients o Wrote utility scripts to manage the ETL process o Integrated our internal EDGE tool with the environment (comprehensive meta data tool that supports the data warehouse lifecycle including generation of Informatica Mappings) o Integrated the environment into the office LAN



York Risk

• United States
• Insurance
• 700 & Above Employee

• Informatica and Linux Standards and Administration

  • Mar 2019 - Sep 2019

  Dublin, OH • York decided to build a new data and analytics center from the ground up beginning with the purchase of a full suite of Informatica products to be hosted on Google Cloud. I was brought in to specify and establish Linux and Informatica infrastructure along with the development of the requisite processes and standards. This involved hardware(VMs) and software in 3 environments, DEV, UAT, PROD. o Installed, configured and administered Informatica Products: PowerCenter, IDQ, EDC, AXON, TDM… Show more • York decided to build a new data and analytics center from the ground up beginning with the purchase of a full suite of Informatica products to be hosted on Google Cloud. I was brought in to specify and establish Linux and Informatica infrastructure along with the development of the requisite processes and standards. This involved hardware(VMs) and software in 3 environments, DEV, UAT, PROD. o Installed, configured and administered Informatica Products: PowerCenter, IDQ, EDC, AXON, TDM and S@S. Assisted with administration of MDM. o Administered RHEL 7.6 on 17 large GCP VMs. o Assisted in the definition of Informatica standards in the areas of software development, version control, security, user management. o Developed administration utilities for Linux and Informatica including server and service monitors, performance monitors and automated programs for validating compliance to corporate standards for workflows, sessions and mappings. Show less



BMW Financial Services

• Financial Services
• 1 - 100 Employee

• ETL Architect

  • Jun 2010 - Jan 2019

  Hilliard, OH • For the 3rd time in 9 years, successfully migrated the data warehouse technical environment to upgraded hardware and software in 4 environments, DEV, UAT, PREP, PROD o Upgraded to new physical servers and SAN o Upgraded from SQL Server 2014 to SQL Server 2016 o Upgraded (installed, configured, and migrated the repository) Informatica server from 9.6 to 10.2 o Upgraded (installed, configured) Informatica PowerCenter clients from 9.6 to 10.2 o Upgraded the O/S from Windows 2012… Show more • For the 3rd time in 9 years, successfully migrated the data warehouse technical environment to upgraded hardware and software in 4 environments, DEV, UAT, PREP, PROD o Upgraded to new physical servers and SAN o Upgraded from SQL Server 2014 to SQL Server 2016 o Upgraded (installed, configured, and migrated the repository) Informatica server from 9.6 to 10.2 o Upgraded (installed, configured) Informatica PowerCenter clients from 9.6 to 10.2 o Upgraded the O/S from Windows 2012 Server to Windows 2016 Server o Migrated and tested nearly 2000 scheduled jobs • Converted the commercial finance data mart to a new source system of record which included loan servicing, originations, and customer data. This included developing over 80 Informatica mappings and over 120 other staging and SQL jobs. • Assisted in the development of architecture components and processes for automating staging, dimension and fact build processes and key generation and maintenance. • Provided general production support for all jobs in the ETL schedule, including 600 Informatica jobs and 1700 total jobs. • Provided general Informatica ETL development to build and maintain a new enterprise data warehouse. The warehouse has grown to include dozens of integrated data marts including retail lending, commercial lending, dealer, customer, collections and recovery. • Built processes, utilities and scripts to manage all aspects of the ETL environment. Show less



Discover Financial Services

• United States
• Financial Services
• 700 & Above Employee

• ETL Architect

  • Jan 2016 - Jan 2018

  Riverwoods, IL • Led analysis and ETL development for re-sourcing two legacy student lending systems to a third new Student Lending system to feed the enterprise data warehouse supporting the Student Lending line of business. • Upgraded the existing Student Lending data warehouse model to support legacy reporting that was made obsolete by the retirement of the two legacy Student Lending systems. • Through data warehouse data reconciliation, provided invaluable feedback to correct hundreds of data… Show more • Led analysis and ETL development for re-sourcing two legacy student lending systems to a third new Student Lending system to feed the enterprise data warehouse supporting the Student Lending line of business. • Upgraded the existing Student Lending data warehouse model to support legacy reporting that was made obsolete by the retirement of the two legacy Student Lending systems. • Through data warehouse data reconciliation, provided invaluable feedback to correct hundreds of data migration defects. Show less



BAAX, LLC - now Lightwell Inc.

• United States
• IT Services and IT Consulting

• Partner – Vice President of ETL Development and Technical Infrastructure

  • Oct 2004 - Sep 2017

  Columbus, Ohio Area • Partner in a new data management consulting company with life-to-date revenues of $51 million+ and 20 employees. • Developed and managed client relationship responsible for revenues of $2 million for a client in the fashion retail industry. • Managed and mentored development teams. • Due to relatively small team sized and aggressively bid projects, I and my partners spent considerable time personally performing the work in addition to our business development responsibilities as… Show more • Partner in a new data management consulting company with life-to-date revenues of $51 million+ and 20 employees. • Developed and managed client relationship responsible for revenues of $2 million for a client in the fashion retail industry. • Managed and mentored development teams. • Due to relatively small team sized and aggressively bid projects, I and my partners spent considerable time personally performing the work in addition to our business development responsibilities as owners. Show less



EXPRESS

• India
• Writing and Editing

• Data Warehouse Architect

  • Jan 2009 - Jan 2011

  Columbus, Ohio Area • Supported the data warehouse conversion from Island Pacific Retail System to Oracle’s Retail Management System (RMS). • Prior to the RMS conversion, upgraded the warehouse to support multi-currency, multi-language and multiple distribution centers. The ETL consisted of BTEQ, Fastload, and Multiload scripts in a Teradata environment. • Hired and led a five-person team to complete the 18-month Internationalization project. • Designed and built a Franchise Data Mart to support Express’… Show more • Supported the data warehouse conversion from Island Pacific Retail System to Oracle’s Retail Management System (RMS). • Prior to the RMS conversion, upgraded the warehouse to support multi-currency, multi-language and multiple distribution centers. The ETL consisted of BTEQ, Fastload, and Multiload scripts in a Teradata environment. • Hired and led a five-person team to complete the 18-month Internationalization project. • Designed and built a Franchise Data Mart to support Express’ foray into international franchising. • Was the SUSE Linux system administrator for the conversion from Teradata MP RAS. • Performed the original MP RAS administration to support the data warehouse split from Limited Systems. • Built application infrastructure for an Arthur Allocation implementation. This was a “green-field” implementation necessitated by contractually required separation from Express’s former parent corporation, Limited Inc. • Installed and integrated 5 HP-UX BL860C blades. • Performed all UNIX administration and database administration duties including the support of application installation and testing. • Trained an Express employee in HP-UX 11iV3 administration. Defined and documented all system administrator duties and processes. • Trained an Express employee in Oracle 10.2.0.4 administration. Defined and documented all DBA duties and processes. • Implemented, documented and tested disaster recovery and automatic failover of hardware, OS and database. • Successfully implemented a production cutover to the new infrastructure. • Coordinated project communications between infrastructure and application teams including the equivalent teams at Limited Inc. Show less



Toyota Financial Services International Corporation

• Data Warehouse Architect

  • Oct 2004 - Oct 2008

  Torrance California • Managed, designed, developed and implemented an enterprise data warehouse solution for automobile lending. • Played a key leadership role in all phases including: environment assessment, business analysis, solution design, infrastructure acquisition and configuration, ETL design and implementation, testing, and the generation of BI reports and dashboards. • Developed critical portions of a metadata-driven application to quickly and accurately generate Informatica components for data… Show more • Managed, designed, developed and implemented an enterprise data warehouse solution for automobile lending. • Played a key leadership role in all phases including: environment assessment, business analysis, solution design, infrastructure acquisition and configuration, ETL design and implementation, testing, and the generation of BI reports and dashboards. • Developed critical portions of a metadata-driven application to quickly and accurately generate Informatica components for data validation and data model construction. • Owned and performed the development of the ETL process for the auto lease and origination systems. • Owned and performed the execution schedule for all warehouse processes until turnover to the offshore team. • Trained and mentored Toyota personnel to take over the operation, testing and validation of the warehouse. • Led the gap analysis, remediation and testing portions of a consolidation project in preparation for the successful shutdown of several legacy warehouses. • Designed and automated distribution of originations reports and dashboards (Hyperion) in preparation for the successful decommissioning of a MicroStrategy installation. • Developed a comprehensive validation solution to monitor the integrity and content of each data load to the warehouse. • Traveled every other week to Torrance California for 4 years. • Came in on time and under budget for all 9 consecutive statements of work. Show less



Boeing

• United States
• Aviation and Aerospace Component Manufacturing
• 1 - 100 Employee

• Lead Senior Engineer - CAD/CAM

  • Jun 1989 - Nov 1996

  Greater Seattle Area

• Director of Engineering Information Systems - National Wind Tunnel Complex

  • May 1995 - Jul 1996

  Cleveland/Akron, Ohio Area