Nathan Mott Email & Phone Number

Customer: Atmus - Project: Lift & shift all enterprise reporting to Snowflake (Jun ‘24 - present) • Added to project already in progress for 1 year • Helped organize large DE team(6+ members) for 400+ report items • Gather requirements and provide timelines to business • Coordinate DE work handoff to DA team • Tools: Snowflake, dbt, GitLab, Terraform Customer: Fortune BrandsProject: Migrate Oracle data to Snowflake with Data Vault foundation (Nov ‘23 - Jun ‘24) • Discover existing reports and build priority scope • Build Fivetran connectors to ingest Oracle EBS tables to Snowflake • Model data using Data Vault 2.0 techniques • Use dbt to transform and layer data • Develop new CI/CD processes for multiple teams in mono-repo

Remote

Customer: Chick-fil-A - Project: Learning & Development - Upgrade pipelines (Jul ‘23 - Oct ‘23) • Rebuild Alteryx workflows using enterprise architecture • Ingest 3rd party API data (Qualtrics) using Python notebooks on Databricks • Transform data through Medallion architecture using dbt Cloud • Orchestrate running ingestion and transformation using Databricks workflows • Build everything as infrastructure-as-code (Terraform) inside GitHub reposCustomer: Pacific Dental - Project: Data Extraction - Orchestration (May ‘23 - Jul ‘23) • Design Framework for multiple extractions using Matillion and Snowflake • Build Snowflake Stored procedure template • Build Matillion orchestrations • Connect to 3rd Party API (Python code) to send data • Optimize Snowflake queriesCustomer: Securian Financial - Project: Data Platform Modernization (Oct ‘22 - May ‘23) • Perform a proof of concept(POC) of Snowflake and dbt • Evaluate both platform and tools for client • Document key findings in both products • Design Snowflake overall architecture • Design Snowflake information architecture • Create templates for Snowflake automated provisioningCustomer: Securian Financial- Project: Hadoop migration to AWS Redshift (Jun '21 - Oct '22) • Migrate 14 TB of data in Cloudera HDFS/Impala to S3/Redshift • Update 50+ pipelines to run on AWS cloud • Converte 80+ Impala scripts to Redshift SQL sprocs • Configure Airflow to orchestrate StreamSets jobs • Tools: bash scripting, StreamSets, Flyway, S3, Redshift, Airflow

Remote

Customer: Quadax, Inc.- Project: Hadoop migration to Snowflake (Feb ‘21 - May ‘21) • Migrated 10 TB of data in Cloudera HDFS/Impala to Snowflake • Internal phData tools: Streamliner & SQLMorph • Other Tools: bash scripting, distcp (hadoop command), Azure ADLS, Snowsql

• Created AWS Glue crawlers and jobs to move raw csv data to refined parquet files in S3• Glue jobs were written in Pyspark using dataframes to cleanse and deliver data• Researched AWS Lake Formation as a layer on top of refined data for better catalog and access permissions

• Advised on ETL options for moving data to AWS cloud and building new structures• Researched security and encryption best practices for transmitting and storing data in AWS S3

York, Pennsylvania, United States

Pioneering big data at WellSpan Health by implementing MapR Hadoop over a seven node on-prem cluster. Self trained in Linux, Python, Spark, Hive, StreamSets. Ready to join a team that takes big data seriously, specifically the real-time streaming aspect, as the future of data.

York, Pennsylvania Area

• Develop, support and maintain an Enterprise Data Warehouse (EDW) containing clinical and administrative data• Optimize queries and warehouse solutions• Translate logical models to physical data models• Identify conformed dimensions as candidates for Master Data Management (MDM)• Work with DBA and Server teams to ensure best use of data technology• Develop ETL process to pull source data into EDW• Develop and support OLAP cube solutions using SSAS• Develop and support Tabular solutions using SSDT• Create reporting solutions using SSRS and other BI applications• Fine tune BI applications with custom MDX and DAX queries• Educate end users on reporting tools and promote use of EDW

Lancaster, Pennsylvania Area

• Database Design - coded T-SQL, tables,views,stored procedures. • Wrote custom XML/XSLT to make database calls.• Replaced old SQL techniques (cursors, text pointers, etc) to newer 2005/2008 T-SQL code• Converted SQL code with too many loops (RBAR) to Set based updates

King Of Prussia, Pa

• Worked on a team responsible for the entire back-end of an internet company with over 15,000 websites which require 24/7 uptime• Environment initially consisted of 7-10 instances of mixed 2000/2005 SQL Servers on physical machines• Helped migrate all 2000 boxes to 2005 and later upgraded them to 2008R2• Supported several database models: normalized, flat, and star schema• Coded many stored procedures used by both front-end code and back-end processes• Used new 2005 features like CTE’s, Row_Number function, and FOR XML• Very experienced with SSIS – complex data flows, script component, expressions and configuration files• Some experience in SSAS and cube building• Used Profiler to troubleshoot and tune calls to the database• Read query plan information to performance tune stored procedures• Met directly with Sales and Marketing members to gather requirements for new projects and stat requests• Supported DBA maintenance, backup tasks, and database moves• Partitioned tables and coded automatic archiving via switch command

Chesterbrook, Pa

• Answer phone and email questions from clients regarding web hosting.