Database ETL Developer / Data Engineer
Resume:
Neal Lee Webster
Data Professional / Database ETL Developer / Data Engineer
adyysh@r.postjobfree.com
Dallas, Texas
https://www.linkedin.com/in/neal-w-92558b7
Executive Summary
Visa Status / Work Authorization
United States citizen - Authorized to work for US employers
Technical Proficiencies
Platforms
Microsoft SQL Server (on-premise and cloud), Azure, AWS, Snowflake, GCP, Oracle
Languages
SQL (T-SQL), Python, R, C#, Bash, CMD, PowerShell, EasyLanguage, HTL, CSS, JavaScript
ETL
Databricks, dbt, SQL Server Integration Services (SSIS), Azure Data Factory (ADF), AWS Glue, AWS Data Pipeline, Airflow, Informatica, Talend, Matillion, Fivetran, IBM Data Stage, Pentaho Data Integration, Alteryx, Cloudera, Oozie scheduler, SQL Agent, Cron, Hadoop, Spark jobs, Luigi, PySpark, Spark, Change Data Capture (CDC), Slowly Changing Dimensions (SCD), Temporal System Versioned Tables, Tableau, Power BI
Tools
API, Jupyter Notebook, SQL Server Management Studio - SSMS, SSRS, Visual Studio Code, Excel, Swagger, RedHat Decision Manager, RStudio, Visio, PostMan, AWS S3, AWS LAMBDA, Power BI, Alation, Collibra, WinSCP API, SVN, TFS, GIT, Idera, Redgate
Databases
MSSQL, Snowflake, Teradata, Cassandra, MySQL, Redshift, DynamoDB, Aurora, Oracle, Redis, Postgres
SDLC
Agile, Scrum, Waterfall, Hybrid
Strengths
Data Engineering, Data Integration, ETL, Database Development, Distributed Systems Integration, Data Modeling. Advanced working SQL knowledge and experience working with relational databases, advanced query authoring (T-SQL). Data Science, Machine Learning, Data Governance, Process Improvement and Automation, Requirements Analysis, Deployment Planning, Release Execution, Production Support, Root Cause Analysis (RCA), Artifact Documentation (i.e. BRD, AC, TRD, QA, UAT, PPV), Change Control Management.
Career Summary
Tredence Inc. San Jose, CA (REMOTE) February 2022 – Present (1 Year, 8 Months)
●Sr. Data Engineer - Data Warehouse / Global Data & Analytics
Ulterra Drilling Technologies Fort Worth, Texas (REMOTE) December 2021 – February 2023 (1 Year, 0 Months)
●Sr. ETL Developer - Data Warehouse / Systems Integration
PennyMac - National Mortgage Acceptance Fort Worth, Texas (REMOTE) March 2014 – December 2021 (7 Years, 8 Months)
●Sr. Data Engineer - BI Systems / Servicing IT
●Sr. Database Developer - Enterprise Data Warehouse / Central IT
●Sr. Database Systems Analyst - Enterprise Data Warehouse / AppDev IT
Guitar Center, Inc. Westlake, California February 2011 – March 2014 (3 Years, 1 Month)
●Sr. Systems Analyst/Programmer - IT ERP & Control Systems
●Technical Business Analyst - Sales Audit / IT Accounting
Lions Futures Management, Inc. Van Nuys, California April 2008 – February 2011 (2 Years, 6 Months)
●Programmer Analyst - IT Data Integration / Trade Desk Automation
UBS Wealth Management Oxnard, California May 2008 – August 2008 (4 Months)
●Intern, Analyst
Career Experience
Sr. Data Engineer - Data Warehouse / Global Data & Analytics February 2022 – Present
Tredence Inc., San Jose, CA (REMOTE) 1 Year, 8 Months
●Databricks to parse large JSON data from API’s. Flattened and deserialized the JSON data. Looped through each deeply nested list of key value pairs in the JSON data to prepare the JSON data to insert into staging database an, cleansed and loaded into data warehouse.
●Databricks to extract from data warehouse, transform, and format into JSON and pushed data to external API. Parsed tabular data from source database tables and serialized the data into JSON format to POST to JSON API’s.
●Built data pipelines and workflows with Databricks to ingest data from external API’s and delta load into data warehouse.
●Snowflake database development. Created tables to stage data for ETL processes and store ODS and transactional data.
●Parse JSON API responses to load/insert into Snowflake database. Developed Python scripts to create custom API connectors to ingest data from external vendors; Capterra, StackAdapt, Rollworks, LeadScale, Xing, Demandbase, Facebook, Google and parse JSON API responses to load/insert into Snowflake.
●Created views in Snowflake for data presentation used by Power BI.
●Data Warehouse development using Microsoft SQL Server on RDS, Snowflake, AWS Glue, Lamda, and Redshift for the Consolidated Corporate Support Services (CCSS) program.
●Developed data pipelines with Matillion and FiveTran to load historical and daily delta loads of marketing analytics data.
●Built automated data pipelines to ingest/load data to/from AWS S3 via Python.
●Translated and converted stored procedures, view definitions, and functions from Oracle PL/SQL to Microsoft T-SQL.
Sr. ETL Developer - Data Warehouse / Systems Integration December 2021 – February 2023
Ulterra Drilling Technologies, Fort Worth, Texas (REMOTE) 1 Year, 0 Months
●Worked on multiple projects and provided production support simultaneously.
●Built Databricks ETL’s and ELT’s for on-premise and cloud MSSQL Server environments.
●Developed and enhanced SSIS packages to increase data throughput.
●Refactored existing Databricks ETL’s to run via delta load rather than truncate and load.
●SQL development - created and altered stored procedures, enhanced existing stored procedures, and SQL Agents jobs.
●Data Modeling - created database requirements by analyzing APIs via JSON responses.
●Transferred from data sources like flat files, XML, JSON documents to RDBMS and vice versa.
●Developed data visualizations with SSRS, Power BI, and Tableau.
●Used Python for file processing to convert JSON files with nested elements to CSV files.
●Python to read data from databases (MS SQL Server and Cassandra) to Pandas data frames.
●Compare large files and identify differences.
Sr. Data Engineer - BI Systems / Servicing IT February 2019 – December 2021
PennyMac - Private National Mortgage Acceptance Company, Fort Worth, Texas (REMOTE) 2 Years, 8 Months
●Migrated MSSQL Server on-premise to Snowflake.
●Provided critical production support for Snowflake DWH and on-premise data warehouse.
●Implemented bulk and delta load ETL’s using SSIS.
●Documented data mapping for Data-Sources to Data-Targets.
●Collected business requirements to build rules into rules engine for automated loss mitigation reporting.
●Developed additional data quality checks via T-SQL and faster file processing via Python for investor reporting ETL’s.
●Increased investor reporting rating from “C” to “A” by implementing improved data quality controls and automation.
●Significantly reduced latency/run-time (12+ hours to less than 3 minutes) using T-SQL and Python for investor reporting by refactoring existing ETL’s.
●Developed Python scripts to upload and download data files from AWS S3.
Sr. Database Developer - Enterprise Data Warehouse / Central IT October 2015 – February 2019
PennyMac - Private National Mortgage Acceptance Company, Fort Worth, Texas (REMOTE) 3 Years, 4 Months
●Strengthened production and backend development across multiple reporting and application database servers by producing complex data workflows that adhere to the data management policy quality requirements.
●Spearheaded daily stand-up meetings with onsite and offshore developers, and championed bi-weekly Sprints to collaborate on how to enhance backend processes, and address and resolve any defects or bugs.
●Support the self service reporting capability through development of a pilot, and support of the user community in their ability to conduct ad hoc analytics projects.
●Development effort of the self service capability and collaborated with data stewards to identify user reporting needs, identify the data sources/systems, and integrate them into the analytics platform.
●Defined data connections and package data extracts.
●Responsible for collecting, collating, and triaging issues and problems with data.
●Communicate issues and other relevant information (e.g. root causes) to those staff members that are able to influence remediation.
Sr. Database Systems Analyst - Enterprise Data Warehouse / AppDev IT March 2014 – October 2015
PennyMac - Private National Mortgage Acceptance Company, Moorpark, California 1 Year, 7 Months
●Facilitated all phases of SDLC process. Partnered with LOB to create business requirement documents, development, deployment, and post-release production validation.
●Lead analyst in the kick-off and implementation of enterprise wide Data Governance program.
●Produced complex data workflows that adhere to the data management policy and data governance quality requirements.
●Data Profiling and Data Governance via SQL and Collibra.
●Spearheaded enhancements to backend processes and addressed defects or bugs.
●Administer ETL methodologies to enhance current processes for in-network data movement across databases and APIs with external vendor systems.
Sr. Systems Analyst/Programmer - IT ERP & Control Systems February 2013 – March 2014
Guitar Center, Inc., Westlake, California 1 Year, 1 Month
●Liaison between onsite and offshore inter-department business users and development teams.
●Facilitated the management of completed projects and resolution of any issues and bugs for internal customers throughout the enterprise including Accounting, Treasury, Operations, EDW, POS, Contact and Distribution Centers.
●Collaborated with business stakeholders to obtain effective strategic, tactical, and operational insights of the business requirements to enhance critical financial systems.
●Improved ERP application that supported over 2,500 concurrent users across the entire enterprise from corporate offices to distribution centers located throughout the United States.
Technical Business Analyst - Sales Audit / IT Accounting February 2011 – February 2013
Guitar Center, Inc., Westlake, California 1 Year, 11 Months
●Implemented balance sheet reconciliation application to increase financial controls by the development of a semi-automated program to automate manual processes of over $5M in transactions per month and reconciled over $70M in transactions per month.
●Lead Accounting and Financial Operations by documenting procedures for accurate reconciliations and efficient management of customer payment issues.
●Created test cases, scripted batch job for data conversions, data mapping, error handling, proper logging of issues, and validation of ERP bug fixes and enhancements in sub-ledger and general ledger.
●Facilitated QA and UAT for on-shore and offshore teams.
●Conceptualized the automated processes for mapping and conforming data extraction from internal and external remote services.
●Recipient of the Innovator Award of the Year award for automating systems to replace repetitive, manual, and error prone reconciliation / accounting of balance sheets, accounts receivable, and accounts payable.
Programmer Analyst - IT Data Integration / Trade Desk Automation April 2008 – February 2011
Lions Futures Management, Inc., Van Nuys, California 2 Years, 6 Months
●Leveraged internal programs and third-party APIs to integrate high frequency trading applications into the proprietary trading software.
●SalesForce development and process automation.
●Converted trading systems from EL (EasyLanguage) to C# for retail and all non-retail customers.
●Managed offshore developer teams located in Philippines and India by preparing functional and technical required documents.
●Overhauled and maintained cloud-based customer relationship management software and deployed customer specific software installation, maintained file schemas (XML), and identified, documented, and QA’d bug fixes and enhancements.
●Migrated from the Microsoft Mail Exchange Server to the Google Apps Enterprise.
●Lead software training sessions for employees and clients for in-person and online sessions.
Intern Analyst May 2008 – August 2008
UBS Wealth Management, Oxnard, California 4 Months
●Collected and analyzed data for mid-year performance review for approximately 30 financial advisors.
●Worked closely with operations manager, gained understanding of administrative & back office operations for managing fixed income, equity & insurance products for clients.
●Partnered with the branch manager to facilitate a recruiting project for financial advisors.
●Compiled & ranked production statistics for over a dozen financial advisors.
●Created PowerPoint presentations for weekly, monthly, and quarterly sales meetings.
●Created Excel templates for office administrator & branch manager
●Researched equity and fixed income markets culminating in a one year investment outlook and potential investment strategies.
Domain Knowledge
Mortgage
Securitization, Hedging, Pricing, Correspondent, Servicing, Default Reporting, Loss Mitigation Reporting, Investor Reporting, Bankruptcy, Foreclosure, Positive Pay, Retail Origination, NMLS Quarterly Reporting
Capital Markets
Equities/Securities, Derivatives, Fixed Income, Futures, Liquidity Analysis, Depth of Market, Order Flow, Order Types, FIX Protocol, HFT, Algorithmic Trading, CTA, CPO, POA Accounts, Discretionary Accounts, Managed Accounts, Block Allocations, Order Execution and Settlement and Auditing, Backtesting, VAR, Leverage, Margin Requirements, CFTC/NFA Registration and Audit
Finance & Accounting
SOX, Balance Sheet Reconciliation, General Ledger Journal Entries, PnL, Capex (Capitalized Expenditures), AP/AR Reconciliation, Tax, COGS, Inventory, Treasury Positive Pay, Unclaimed Property, Aged Accounts, Obsolescence, ERP applications (PeopleSoft, Microsoft Dynamics 365, SAP HANA)
Retail & eCommerce
ERP (Enterprise Resource Planning), Inventory Accounting, Sales Audit, Payment Gateways, Merchant Systems, Payment Settlement, Multi-Channel (PO, Contact Center, Distribution Center, Inventory, PPS), Fraud Detection, Procurement Analysis, Reverse Auctions, Three-Way Reconciliations (POS vs Merchant Processor vs Bank Settlement) CRM applications (SalesForce, HubSpot, SAP Sales Cloud, )
Data Science & Machine Learning
Data Engineering, Data Integration, ETL, Database Development, Distributed Systems Integration, Enterprise Data Management, Data Modeling, Data Science, Machine Learning, Data Governance, Process Automation and Improvement, Requirements Analysis, Artifact Documentation (BRD, TRD, PPV), QA, UAT, Deployment Planning, Release Execution, Production Support
Education
Bachelor of Science, Information Technology - Western Governors University, Utah (not completed)
Bachelor of Science, Accounting - California Lutheran University, California (not completed)
Certificate, Enterprise Project Management - University California Santa Barbara, California - 2011
Associates Degree, Moorpark College, California - 2010
Soft Skills
Communication: Ability to communicate clearly and efficiently to team members and clients, verbally and in writing. Able to present ideas in a variety of ways depending upon audience and context. Excellent active listening skills.
Organizational Skills: Can plan and prioritize work. Follows tasks to their logical conclusion and makes sure that everything has been done to the right standard. Good attention to detail.
Team Work: Able to enthuse and maintain project interest. Comfortable working both individually and as part of a team. Prepared to challenge ideas within a group in a personable and constructive manner.
Quantitative Management: Ability to determine process measures and track to determine process effectiveness and efficiency. Results oriented: Able to drive things forward regardless of personal interest in the task.
Coursework & Continued Education
Data Science Certificate - Coursera with Johns Hopkins University Online
Algorithms: Design and Analysis - edX with Stanford Online
Statistical Learning with Applications in R - edX with Stanford Online
Series 3 - FINRA/NASD Exam - National Commodities Futures
Series 30 - FINRA/NASD Exam - Futures Branch Manager
Series 31 - FINRA/NASD Exam - Managed Funds Futures
Series 63 - FINRA/NASD Exam - Uniform Securities Agent State Law
Series 65 - FINRA/NASD Exam - Uniform Investment Advisor Law
Security Futures and Arbitrator Training - National Futures Association
Motivation
Solving complex problems.
Using data to drive decision making.
Continuous learning and development.
Collaborating with others.
Making an impact.
Awards & Distinctions
Annual Spotlight – PennyMac
Quarterly Spotlight – PennyMac
Innovator of the Year – Guitar Center
Data professional, database developer, and effective communicator with advanced working knowledge of SQL and Python for Data Warehouse, ETL development, data migration, and data engineering.
Worked with multiple Data Warehouse and ETL tech-stacks on-premise, in the cloud, and hybrid.
10+ years providing production support, managing mission critical enterprise data systems, triage ETL failures, perform root cause analysis while simultaneously participating in sprints where I code, deliver new products, and data integrations.
10+ years hands-on development experience building and deploying data pipelines, ETL’s, data integrations, and data warehouses using various DBMS’s from numerus API’s, ERP’s, CRM’s, EDI’s, flat files, and ODS’s.
Implemented solutions for data integrity, data quality, data reconciliations, data governance, and analytics reporting.
Strong ability to lead and facilitate every phase of the SDLC process and produce project artifacts.
Experience in both Agile and Waterfall environments. Effectively work with small local teams and large distributed offshore teams.
10+ years eliciting business requirements, writing functional and technical documents, data mappings. Perform impact analysis, dependency analysis, data analysis, release planning, and post-production validation.
Effectively document and present current vs. future state diagrams and project statuses to a technical and non-technical audience.
Contact this candidate