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.