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)

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)

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

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

Chesterbrook, PA

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