Paul DePons

**** ******* ***

Lake Worth, FL ****7 USA

email/skype: ad4ssq@r.postjobfree.com

Phone: 561-***-****

SUMMARY

A seasoned professional with extensive experience in designing and implementing data warehouse solutions, including comprehensive work with Snowflake, Teradata, and Oracle systems. My expertise spans across ELT processes, cloud migrations and data mart creations, with a strong focus on enabling advanced analytics. I thrive in a collaborative environment, leveraging my technical and communication skills to drive projects forward.

PROFESSIONAL EXPERIENCE

Compucom May 2022 – April 2024

Principle Engineer / Data Architect

Provide data warehouse guidance in ETL and Administration including conversion of source applications from Amdocs to SalesForce and Oracle On-prem to Oracle Cloud.

Lead conversion and support in Legacy Oracle DataWarehouse of Oracle financial ERP source systems

Design and implementation of Snowflake Access Roles, compute warehouse definition and user assignments

Design and developed dynamic SQL to create Snowflake load scripts to include variable date formatting

Lead design and standardize snowflake stored procedures from very complicated legacy Oracle procedures and packages

Pandera Systems June 2021 – May 2022

Data Architect/Administration Consultant

Provide data warehouse administration and design on a Teradata to Snowflake Conversion. Includes conversion validation, debugging and peformance tuning of data migration, views and Microstrategy reporting.

Design and implementation of Access Roles, compute warehouse definition and user assignment

Design and developed dynamic SQL to create 100's of views to include an MD5 hash for data migration validation

Office Depot Nov. 2012 – June 2021

Data Architect/Lead Developer Nov 2003 - 2010

Provided data warehouse 24/7 ETL support.

Provided SME knowledge and technical support for legacy systems to support conversion from Teradata to Snowflake. Led effort for final shut down of Teradata.

Aided and supported multiple database upgrades, tuning and conversions

Worked extensivly with DBAs on Join Index maintenance and planning

Designed 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 reporting

Lead resource for ETL standardization and development

JM Family Nov. 2010 – 2012

Data Architect/Teradata Administration

Helped implement the initial release of Teradata data warehouse from an Oracle design.

Included automated implementation through recursive SQL of Multi-value compression as well as the implementation of a Dual Active system.

Teradata Retail Division (NCR) Nov. 2000 – Oct. 2003

Post sales Data Warehouse Consultant

Project technical lead from conception through implementation

Created Data Model designs

Led ELT team in several new data warehouse implementations.

Provided Database administration support.

Converted Data warehouse from Informix to Teradata

Provided performance tuning for Microstrategy and CRM applications.

SEARS Roebuck and Company June 1995 – Oct. 2000

Developer

Gathered business requirements

Designed, developed and supported application databases and data marts

Converted applications from Informix to Teradata Data Warehouse

Provided technical guidance to other members on team

PROGRAM LANGUAGES/SOFTWARE

SQL Snowflake Cloud Database, Teradata Database, Teradata Utilities (BTEQ, Fastload, Fastexport, Multiload, Tpump, QueryMan, UNIX/Linux Shell Scripting, Mainframe Utilities, MVS/JCL and DataStage. Erwin Data Modeler, Embarcadero Data Architect,

2022 Snowflake Certified SnowPro Core

2002 Certified Teradata Master

1998 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.

Contact this candidate