Randy Moreau Email & Phone Number

Apex, NC, US

Lexington, Kentucky, United States

• Responsible for the initial build and setup of the Snowflake environment including designing the RBAC security model and integration with the existing Azure cloud environment
• Designed templates and reusable code to allow for an efficient migration process off their on-premises SQL Server environment into Snowflake to meet extremely short project timelines
• Lead and supported the customer as well as an onshore/offshore development team with development, design, and best practices using Azure Data Factory and Snowflake stored procedures
• Assisting with project management activities ensuring successful project timelines

Redmond, WA

• Providing Data Modeling, Data Architecture, Data Integration (ELT) solutions using Snowflake and the IBM PureData Systems for Analytics (Netezza) appliance for Data Warehousing projects
• Providing Informatica PowerCenter, Informatica Data Quality, and IBM DataStage solutions using Snowflake and the PureData Systems for Analytics (Netezza) appliance for Data Warehousing projects

Jackson, Mississippi, United States

• Responsible for the initial build and setup of the Snowflake environment including designing the RBAC security model and integration with the existing Azure cloud environment

Medford, Oregon, United States

• Lead technical architect responsible for data architecture, data modeling, and data integration design and development efforts to build a brand-new Enterprise Data Warehouse on Snowflake using Informatica Data Quality
• Consultative on Snowflake administration, usage, setup, and best practices
• Lead and support customer and consultant onshore/offshore Informatica Data Quality developers with development, design, and best practices
• Assisting with project management activities ensuring successful project timelines

Kansas City, Missouri, United States

• Consultative on Snowflake administration, usage, setup, and best practices

Apex, NC

• Designing solutions to extract data from sources such as SQL Server and NetSuite and load those into Snowflake for analytics to be created in Tableau

Hampton, New Hampshire

• Lead technical architect responsible for IBM DataStage ETL architect and development oversight
• Advising on Data Warehouse data architect and data modeling for the IBM PureData System for Analytics appliance
• Project management oversight ensuring the customer and delivery teams were meeting delivery schedules
• Technical oversight, planning, and development for a major initiative to migrate Netezza data and DataStage code over to the Snowflake platform and architecture

Greater New York City Area

• Lead technical architect responsible for IBM DataStage ETL architect and development oversight
• Advising on Data Warehouse data architect and data modeling for the IBM PureData System for Analytics appliance
• Project management oversight ensuring the customer and delivery teams were meeting delivery schedules
• QA work stream test case writing as well as oversight managing internal and customer expectations

Redmond, WA

Richardson, TX

• Responsible for overall development efforts while building a new Customer (MDM) Database solution and a Customer Data Warehouse solution using the PureData Systems for Analytics (Netezza) appliance for Data Warehousing.
• Created design diagrams, source to target mapping, and table DDL for the Customer Data Warehouse development team
• Created new tables and modified exiting table in the Customer Data Warehouse data model using Erwin after the base model was established

Rochester, New York Area

• Lead developer and implementer of nzREP+ on a PureData Systems for Analytics (Netezza) database replication project; nzREP+ is Brightlight Consulting’s Netezza replication software, which is an extension of their nzDIF.
• Gathered requirements with key stakeholders and delivered an nzREP+ Proof-of-Concept
• Created requirements, design and architecture, configuration and installation, and testing documentation deliverables

Charlotte, North Carolina Area

• Lead developer and implementer of nzREP+ on a Netezza replication project; nzREP+ is Brightlight Consulting’s Netezza replication software
• Created bash shell scripts for nzREP+ that replicate Netezza metadata and validate data between source and target Netezza hosts
• Delivered design, architecture, setup, installation, configuration, and testing documentation at the conclusion of the Netezza replication project

Reston, VA

• ETL Lead for an Oracle pl/sql to Informatica PowerCenter migration project
• Provided analysis on hundreds of Oracle stored procedures, shell scripts, and SQL files
• Delivered a level-of-effort ETL migration plan based on analysis provided
• Built a proof-of-concept in Informatica PowerCenter using a subject area from the analysis provided; which included Informatica best practices such as standard naming conventions, reusable objects, ease of readability.

Matthews, NC

• Designed, architected, and developed ELT solutions into the Enterprise Data Warehouse using Netezza Stored Procedures and SSIS
• Worked with business and technical stakeholders to understand Oracle processes and remedy issues during a migration project from Oracle to Netezza
• Identified production data quality issues within the Enterprise Data Warehouse on Netezza and provided scenarios and solutions for the technical stakeholders review

Greater Seattle Area

• Provided expertise and best practices experience on a Data Warehouse project using Informatica PowerCenter as the ETL tool
• Created source to target specifications and built Informatica PowerCenter code from those specs

Charlotte, North Carolina Area

• Designed and architected an ELT solution for an Oracle to Netezza migration project using Unix scripting and NZSQL
• Extracted technical requirements from existing Oracle PL/SQL and Informatica PowerCenter code
• Participated in business requirements gathering sessions

Research Triangle Park, NC

• Implementing Informatica Standards and Best Practices
• Re-coding PL/SQL programs into Informatica code for the existing Data Warehouse environment
• Training and mentoring other developers on the use of Informatica

• Responsible for re-building the ETL infrastructure and re-coding PL/SQL programs into Informatica code for the existing ODS reporting environment
• Working as part of the Business Intelligence team to design and architect a new Enterprise Data Warehouse environment for the company
• Designed and architected the Informatica (version 8.6.1) infrastructure and ETL code that would be used for the Enterprise Data Warehouse

• Worked on a team as the lead ETL Architect that created a reuseable ETL solution which combined near real-time ETL loading, error checking and reprocessing of records, and ETL statistics gathering; data model in ERWin.
• Managed a group of 4 to 6 ETL develops for an ODS project, making sure the complex ETL architecture was understood, client standards were followed, and deadlines were met
• Worked on an inventory analysis project as a lead analyst creating deliverables such as current inventory spreadsheets and Visio diagrams
• Managed a group 4 ETL developers on a Facets (Trizetto application) upgrade project in which COBOL extracts were re-written into Informatica code and existing Informatica extracts were remediated with the new Facets.

• Worked on a team as the lead ETL Architect that created a reuseable ETL solution which combined near real-time ETL loading, error checking and reprocessing of records, and ETL statistics gathering; data model in ERWin.
• Managed a group of 4 to 6 ETL develops for an ODS project, making sure the complex ETL architecture was understood, client standards were followed, and deadlines were met
• Worked on an inventory analysis project as a lead analyst creating deliverables such as current inventory spreadsheets and Visio diagrams
• Managed a group 4 ETL developers on a Facets (Trizetto application) upgrade project in which COBOL extracts were re-written into Informatica code and existing Informatica extracts were remediated with the new Facets.

• Lead architect in all phases of ETL analysis, design, architecture, coding, and testing.
• Managed and mentored a group of 5 to 8 ETL developers associated with all aspects of Data Integration and Data Warehousing, overseeing all ETL architecture, design, and development.
• Trained developers in Informatica PowerCenter (version 7.1.1) including file & reconciliation architecture, legacy data conversions, coding & naming standards, and complex reuseable objects.
• Configured and tuned Informatica environments and code to reduce job run-times and performance bottlenecks. Job run-times were reduced from 12 hours, running over 1000 sessions, to less than 6 hours.
• Developed the architecture and custom Change Data Capture ETL code to move data from an on-line database system to an ODS database in near real-time.
• Worked with business analysts to create technical specification documents.

• Worked as a lead ETL Architect in designing a file extract architecture for quickly reading data from an Enterprise Data Warehouse.
• Managed and trained a group of 4 to 6 developers, overseeing all ETL architecture, design, and development, associated with file creation sourced from an Enterprise Data Warehouse and creating complex ETL reuseable.
• Successfully planned, tested and implemented an upgrade from Informatica’s PowerCenter version 1.73 to 5.1.1 and from 6.1.1 to version 7.1.1 at a couple of different client sites.

* Gathered requirements for data extraction from Sappi’s source system, a DB2 database on an OS390 mainframe. Wrote programs in SAS that extracted the data and sent it to the Data Warehouse Server* Assisted in mapping the data from the source systems into the Stage Schema. The Stage Schema was build using the ERWin modeling tool* Gathering of requirements.

* Worked at the Keane Corporate Office* Worked at Sappi Fine Paper

* Worked at the Keane Corporate office supporting the corporate email system and the Sales application.* Expanded knowledge of hardware and software while working in a help desk environment

Bs, Computer Information Systems

Activities and Societies: Broomball, JV HockeyHonors/Activities: College Reading & Learning Association (CRLA) Master Tutoring.

Minor, Accounting

High School Diploma, Computers