Gerald (Jerry) Gray Email & Phone Number

Fort Worth, Tx, Us

Chicago, Illinois, Us

As the Senior Data Architect, Informatica Administrator, and Developer for the prestigious California Teachers Study at City of Hope (COH), I was entrusted with the full scope of data management responsibilities. Spearheaded ongoing improvements and optimizations to ensure a robust, scalable, and future-ready data environment.Notable Achievements:• Designed and led the transition of COH's data infrastructure from an on-premises environment to a cutting-edge AWS solution using a new ETL methodology.• Orchestrated a successful migration from SQL Server 2016 (on-prem) to AWS RDS – Oracle 19, ensuring seamless data integrity and operational continuity.• Strategically upgraded SQL Server 2012 to SQL Server 2016 across all environments, enhancing system performance and compatibility.• Defined and documented complex business rules for implementation within ETL processes, ensuring alignment with data architecture standards and business objectives.• Maintained and developed critical data models to support evolving project needs, ensuring data architecture flexibility and responsiveness.• Revived and reconfigured the Informatica PowerCenter 10.x environment on a Windows Server, enabling the resumption of data loading after a year-long outage.• Administered and optimized Informatica environments, handling migrations, upgrades, patches, and troubleshooting to maintain peak performance.• Streamlined ETL processes, eliminating bottlenecks and reducing maintenance timelines by 50%, boosting system efficiency and reliability.

Atlanta, Ga, Us

Overview: Engaged as a Informatica Data Quality SME and Data Architect consultant at Crown Castle, Inc. (CCIC) to establish a scalable Data Quality (DQ) framework and lead key data cleansing initiatives for CCIC’s Tower Site data. As the primary data quality expert, I administered and optimized Informatica’s Data Quality toolset to ensure high standards of data integrity and reliability.Notable Achievement:• Designed and developed a reusable, extensible data model to define and capture Data Quality business rules, results, and metrics, laying the foundation for a trusted, enterprise-wide DQ framework.• Architected and Implemented IDQ processes to capture and report on the cleansing activities of projects. Captures the current value of Critical Data Elements (CDE), the results of Business Rules, and Profiling results so they can be reported in PowerBI as needed.• Redesigned and implemented new account matching logic for their OneSales CRM product via Informatica’s IDQ and IICS/ICDM (CDI) significantly reducing processing time by 75% and costs.• Planned and executed the migration of the Informatica dev environment from Windows to Linux allowing the previous server to be decommissioned, recouping the costs of the old server.• Administrator of on-prem Informatica responsible for performing all admin duties including installs, patches, upgrades, server maintenance, interacting with Informatica support, database integration setup user setup and security, and other various duties as needed.

Atlanta, Ga, Us

Overview: Senior Informatica Consultant at Health First Health Group. Leverage prior experience to develop and deliver data integration/data quality solutions in a hospital/medical environment. Provide mentorship to co-workers as needed.Notable Achievement:• Developed and delivered an ETL solution for delivering medical Explanation Of Benefits (EOB) files to a third party within 6 weeks of onboarding to meet a federally mandated deadline utilizing Informatica’s Powercenter, Developer, Data Exchange, and MFT.• Took ownership of the Roster and Provider extracts to ensure timely and proper delivery to business• Assisted the SI team with the resolution of their project backlog

Bedford, Nh, Us

Overview: Led the Informatica team in an ERP integration project for Elbit Systems, integrating data from multiple BAAN and EBS systems into INFOR. Notable Achievement:• Admin of the Informatica 10.x environment responsible for installing and maintain the local on prem instance.• Setup and configured a new Informatica PowerCenter 10x environment.• Developed and implemented ETL architectural approach to implement Master and Transactional Data loads utilizing Informatica PowerCenter and Data Quality ensuring the performance of the overall load processes.

Flower Mound, Tx, Us

Overview: Served as a Senior Informatica Architect at the Dallas-Fort Worth Airport. Loaded data into the airport's enterprise data library (EDL).Notable Achievements:• Significantly enhanced process improvement by streamlining the development process, steering a 300% increase in productivity and reducing development timelines by 25%. • Conceptualized, developed, and implemented an automated dynamic unit test mapping to efficiently, and effectively conduct unit testing of individual projects.• Played a central role in the design and adoption of automated mapping, session, and worklet generator for Informatica, facilitating increased speed of the development process.• Built and Implemented a standards review process to enforce standards on all PowerCenter development.

Worldwide, Oo

Overview: Brought onboard to provide technical consulting to clients as assigned. Charged with unifying efforts across internal and client teams, delivering training to junior team members. Conducted data analysis and facilitated meetings with relevant stakeholders to gain insights into data use. Prepared daily status reports tracking overall team progress.Selected Client Success:• Securian Financial Group: Built an initial annuities data model for the Enterprise Data Store (EDS) and Datamart layers, using the Star-schema methodology and GUIDs (Globally Unique Identifiers). Aided the automation of two manual reports through the identification of the needed business rules. Developed a scoring matrix and overview for integration, data quality, data catalog, and MDM vendor software tools. Partnered with offshore resources to develop source-to-target mappings.• Google: Supported the MDM team in attaining the goal line. Redesigned existing SQL jobs for tuning and automation within their BigQuery environment. Rewrote and tuned SQL for more efficient running with less manual input.• McDonald's: Took accountability for the reporting, tracking, and updates of the testing cycles for the data integration US team. Developed and executed process to pull JIRA issues into Excel and Oracle for more advanced reporting. Delivered data strategy for handling backups and recovery within an AWS environment, including EC2, S3, and RedShift.• State of Rhode Island: Tasked with designing and maintaining tables required to execute ETL loads, using the star-schema methodology in a hosted Oracle environment. Supervised a team of 8 on-site and 4 offshore resources in the technical design and application of solutions. Championed the adoption of a more organized hybrid Agile methodology enabling the team to deliver every two weeks as opposed to every month. Spearheaded the redesign of poorly performing ETLs, leading to over 300% improvements in performance.

Fort Lauderdale, Fl, Us

Overview: Solicited to shape the direction and pace of data integration at National Oilwell Varco (NOV). Collaborated with the data architect to design required facts and dimensions necessary for implementing the data warehouse. Improved existing development processes to facilitate operational efficiency. Notable Achievement:• Developed a source-to-target document standard to capture business transformation rules, identify inferred data transformations, and generated raw DDL for Erwin and raw Join and filter logic for Informatica.• Decreased development review time by 150% and QA review time completely.• Fully automated Source to Stage data process (1000 mappings), reducing development timeline by 6 months.

New Jersey City, New Jersey, Us

Led multiple projects focused on designing, developing, and refining ETL architecture and processes. Acted as the Informatica SME, applying Data Architecture and Management best practices to optimize database design and integration strategies across various initiativesNotable Achievements:• Redesigned ETL architecture framework, introducing a new logging process to extract near real-time workflow and parameter data from the Informatica repository, enhancing monitoring and troubleshooting capabilities.• Developed an automated solution to convert 1,000 manual reports into efficient ETL processes, ensuring timely and accurate data reporting.• Delivered a daily incremental load process to populate IBM’s Unified Data Model for Healthcare (UDMH) as part of the Integrated Kidney Care (IKC) initiative, improving data accuracy and availability for healthcare analytics.

Reston, Virginia, Us

Overview: Implemented changes needed for ICD10 standardization at the University of Utah, Health Systems. Designed and implemented ETL processes that loaded a star-schema data mart. Strategized and executed the re-architecture of a Lawson purchase order process within Informatica, resulting in a 300% reduction in runtime. Spearheaded the redesign of the Lawson warehouse pull to allow for incremental loads and to guarantee all incoming fields met business requirements.

Irving, Texas, Us

Overview: Operated as lead ETL Engineer over 5 developers for the CDI Technology group at Targetbase. Architected and designed ETL approaches to load data into star-schema data marts. Architected the General Mills – Net Insights enhancement project which required modeling several dimensions and the ETL solution that allowed the reporting of customers by marketing campaign as well as differentiating between paid, local, and organic searches. Enhancement facilitated reduced processing time from over 50 hours to less than 4 hours.

Wayne, Pa, Us

Overview: Functioned as senior Informatica ETL Architect/Developer with the Judge Group while working at Raytheon. Architected, designed, and developed all mapping and external logic to integrate Product Data Management (PDM) data with the Product Verification system (PVI). Provided support for User Acceptance Testing.

Overview: Served as Principal Consultant/Architect for data delivery projects across various customers. Designed and delivered data solutions based on client's business needs. Clients included: Time Warner Cable, Autotrader.com, Dell Computers, DSC Consulting, Health Markets, Devon Energy, and AT&T. Designed and implemented ETL processes to load data into the facts and dimension in the data warehouse using both star-schema and snowflake methodologies.

Stamford, Ct, Us

Frisco, Texas, Us

Cincinnati, Oh, Us

Bethesda, Md, Us

Wakefield, Ma, Us

Wayne, Pa, Us

Us

Fort Worth, Texas, Us

Us

Arlington, Virginia, Us