Scott Trudeau Email & Phone Number

Lake Zurich, Il, Us

As an independent contractor I partner with other firms when they have a need for a cloud data architect. I specialize in Snowflake, AWS, Azure, ADF, and Power BI.

Lake Zurich, Il, Us

As a Lead Developer, led a team of ETL resources in the design and implementation of a high performing analytic environment in Azureo Designing and Implementing Terraform scripts to create DEV, UAT, and PROD environmentso Developing Data Factory jobso Utilizing Power BI Admin APIs to populate Power BI Usage dashboardso Calling Azure Data Directory (Graph API) via Data Factoryo Developing high performing Power BI Usage dashboards

Lake Zurich, Il, Us

As a Lead Architect, led a team of ETL resources in the design and implementation of a high performing data warehouse on Snowflakeo Designing and Implementing Snowflake role hierarchyo Implementing SSO between Azure ADFS and Snowflakeo Configuring Snowflake Privatelink and IP whitelistingo Defining Row Access Policies, Data Masking, and Tagging to limit access to certain datao Creating Tasks and Streams to load and transform data in Snowflakeo Migrating all Snowflake objects from DEV / QA / PRODo Architecting Talend, Ataccama, and Qlik Replicate ETL jobso Managing Query Surge environment (Data Monitoring tool)

Seattle, Wa, Us

As a Solution Principal at Slalom, I am responsible for:Managing consultants and solution architectsEstablishing a Modern Culture of Data practiceMentoring cloud data practitionersManaging Slalom's national Snowflake account (28 markets)Presenting at learning events for Chicago clients - Zero to Snowflake in 90 minutesEngineering robust solutions to solve client issuesCloud Data Architect (AWS/Redshift/Snowflake focused) for Chicago area clientsPre-Sales support

Seattle, Wa, Us

As a Solution Architect at Slalom, I am responsible for:Establishing an Oracle Center of ExcellenceMentoring Oracle BI practitionersProviding demonstrations to clients (Current and Prospective)Guiding consultants on best practicesEngineering robust solutions to solve client issuesManaging other BI consultants' careers

Seattle, Wa, Us

US FoodServiceAs a BI Lead/Architect, assisted with completion of OBIEE design for implementation of multiple subject areas.Deconstructed metrics into base elementsIdentified dimensionality requiredIdentified database gapsEstablished BI standards and best practicesCreated high level design and architecture documents for internal and external BI projectsAssisted client data team with development and testing of new framework for populating aggregation tables using PL/SQL.Lead the implementation of Oracle Business Intelligence Applications (OBIA - Peoplesoft GL)Developed POC for business to demonstrate hierarchy capabilities available within OBIEEConsolidated and improved use of initialization blocks within OBIEE repository as part of overall performance improvement effort.

Lisle, Il, Us

Managed the implementation of Siebel Analytics (Fusion Edition). Gathered user requirements, installed/configured/customized Informatica and DAC on UNIX, and installed/customized OBIEE on Linux.Developed 1099 solution by federating multiple Data Warehouse and CRM databases into one OBIEE subject areaProvided project turn-around expertise with emphasis on regaining customer confidenceResponsible for the recruiting, management, and career development of consulting staffProduced project status reports, managed the team, and resolved day-to-day issues with emphasis on SDLCLed workgroup sessions with business managers to gain final approval on business requirements and solution documentsCoordinated efforts from multiple areas of the business in order to deliver projects on time and on budget

Lisle, Il, Us

Architected the ETL, Data Structures, and Reporting Catalog to provide Treasury with SEC Regulation AB compliant reportingImplemented the first OBIEE solution at Navistar to support the sale of receivablesProvided mentoring for InternsDesigned system to transform operational marketing data into a robust historical trending applicationDeveloped Prototypes of new applicationsBuilt team dynamics

Lisle, Il, Us

Employee - Identified as a Key PromotableMember of Enterprise Data Warehouse (EDW) TeamLead Extract Transform Load (ETL) architect for the EDW infrastructureFacilitated meetings with SMEs and project sponsorsOrganized and lead large meetings to gather requirementsTranslated functional designs into technical designsManaged multiple off-shore resources in the development and testing of new applicationsProvided direction and support for other analystsCreated data models to support technical designsDesigned user interface for warranty analyticsPerformed multiple tasks efficiently and effectivelyCarried out quality assurance on Warranty Analytics applicationPresented end-user applications to upper managementLead training sessionsMentored EDW InternsAssist with financial audit and internal-IT auditProvide vehicle center GAAP data to KPMG auditorsCreate SDLC documents to support requestsAchieve SOX compliancy for all data requestsGenerate user-access documentation for internal-IT audit

Lisle, Il, Us

Member of Enterprise Data Warehouse (EDW) TeamLead programmer on truck financial databases and KBI databasesDeveloped UNIX shell scripts to transform mainframe data into Informix dataUtilized DataStage ETL to extract, transform, lookup, and insert/update dataUsed Prism to generate lookup programs and database insert programsComposed AWK scripts to manipulate data, perform calculations, format data, and print dataEmployed SQL to create temp tables, extract data, and insert dataConstructed JCL to extract data from DB2 tables and FTP the results to UNIXConsulted with business users to create business rules, documentation, and test source dataCreated data models utilizing Select SETuned existing scripts and applications to improve efficiency and quality of data

Member of an Oracle Real-Time Data Warehouse (ODS) TeamAdministrator of Impromptu OLAP CatalogDeveloped and implemented OLAP catalog, trained users on catalog, designed standard and ad hoc reports, and made all enhancements and corrections to production catalogDesigned, developed, and implemented Sybase stored procedures and Oracle triggers that converted Sybase data into Oracle dataTested, supported, and modified stored procedures and triggers through unit testing, system testing, and user acceptance testingWrote and supported Unix shell scriptsCreated Oracle views, tables, and indexesGenerated provider directories for EDI transferAssisted data analyst analyze data models, denormalize data, and coordinate models with Impromptu Catalog