| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
Lake Worth, FL Street Address USAemail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLESUMMARYA seasoned professional with extensive experience in designing and implementing data warehouse solutions, including comprehensive work with Snowflake, Teradata, and Oracle systems. With over 20 years experience working on RDBMS migrations, my expertise spans across ELT processes and more recently cloud migrations to Snowflake from both Teradata and Oracle with a strong focus on enabling cost efficient advanced analytics. I thrive in a collaborative environment, leveraging my technical and communication skills to drive projects forward.PROFESSIONAL EXPERIENCECompucom May 2022 April 2024Principal Engineer / Data ArchitectEngaged to help lead the migration from Oracle on premises to Snowflake including1. Design and implementation of Snowflake Access Roles and compute warehouse definition2.Design and develop dynamic SQL to create Snowflake load scripts3.Lead design and standardize snowflake stored procedures from legacy Oracle PL/SQLLead conversion and support in Legacy Oracle Data Warehouse of Oracle financial ERP source systemsProvide data warehouse guidance in ETL and Administration including conversion of source applications from Amdocs to SalesForce and Oracle On-prem to Oracle Cloud.Pandera Systems June 2021 May 2022Snowflake Conversion Architect/Administration ConsultantProvide data warehouse administration and design on a Teradata to Snowflake Conversion. Included conversion validation, debugging and performance tuning of data migration, views and Microstrategy reporting.Design and implementation of Access Roles, compute warehouse definition and user assignmentDesign and developed dynamic SQL to create 100's of views to include an MD5 hash for data migration validationOffice Depot Nov. 2012 June 2021Data Architect/Lead Developer Nov 2003 - Nov. 2010Teradata to Snowflake Conversion.1.Led consulting development team with SME knowledge and technical support for legacy systems to support conversion2.Provided review and communication to OD support team on conversion efforts and progress3.Created SQL to create and standardize Snowflake DDL from Teradata table definitions4.Created dynamic Shell scripts to extract data from Teradata and load into snowflake5.Led effort for final shut down of Teradata.Lead resource for ETL standardization and developmentAided and supported multiple database upgrades, tuning and conversionsWorked extensively with DBAs on Join Index maintenance and planningDesigned logical and physical data models using 3NF as well as data marts.Created automated Unix scripts for data movement, DDL generation and data validation for the Snowflake and Teradata conversion.Lead for CCPA compliance reportingJM Family Nov. 2010 2012Data Migration Architect to TeradataLed migration team conversion to Teradata data warehouse from an Oracle design.Included automated implementation through recursive SQL of Multi-value compressionImplementation of a Dual Active DB system.Teradata Retail Division (NCR) Nov. 2000 Oct. 2003Post sales Data Warehouse ConsultantTechnical lead from conception through implementation of Teradata RDBMSCreated Data Model designsLed ELT team in several new data warehouse implementations.Led Migration of data warehouse from Informix to TeradataProvided Database administration supportProvided performance tuning for Microstrategy and CRM applications.PROGRAM LANGUAGES/SOFTWARESQL Snowflake Cloud Database, Teradata Database, Teradata Utilities (BTEQ, Fastload, Fastexport, Multiload, TPump, QueryMan, Viewpoint), UNIX/Linux Shell Scripting, Mainframe Utilities, MVS/JCL and DataStage. Erwin Data Modeler, Embarcadero Data Architect,2022 Snowflake Certified SnowPro Core2002 Certified Teradata Master1998 Graduate work in Information Systems (Roosevelt University)Courses included: Database Design, Information Systems Design and Implementation.Masters of Science in Management (University of Wisconsin at Milwaukee).Bachelor of Business Administration (University of Wisconsin at Eau Claire).Other languages: French: Lived two years in France. |