Erik Ferguson Email & Phone Number

New York, New York, Us

New York, New York, Us

Bringing best DBT and Modern Data Stack practices to large enterprises, I lead JCrew's conversion from a legacy SAP warehouse to a Fivetran-Snowflake-DBT stack. I architect data solutions for problems before they arise, reverse engineer legacy code, design the logical data model for the BI team, and educate developers on how to take advantage of the benefits of modern tooling.

Lawrenceville, New Jersey, Us

By leading adoption of AWS, Fivetran, Snowflake, and DBT Cloud, and Looker, I enabled Billtrust to build their first prescriptive analytic models and migrate away from the Microsoft SQL stack. I standardize our usage of new technologies and create processes that simplify both the technological & human problems the data team faces while implementing our modern data stack. Led engineering efforts in implementing the first machine learning models for internal business decisions and for implementing customer facing analytics.------------------------ Some Specialties ------------------------___________________________________________________________• Snowflake: Developed an administration strategy from scratch for our data warehouse. Built monitoring and budgeting solutions for the company and eventually took over management of the account relationship.• DBT Cloud: Drove efforts to adopt DBT as the transformation layer of the company. Built our development standards with a committee and wrote out over 50 models to help migration efforts from SSIS. Eventually took over management of the account relationship.• Apache Airflow: Developed the terraform for our first implementation of Managed Workflows for Apache Airflow (MWAA). Wrote 10+ ELT pipelines connecting to a variety of RestAPI's and internal company systems. Built the infrastructure and processes that fed into Airflow.• CI/CD: Converted our cloud data infrastructure to Terraform and worked with DevOps to implement CICD processes

New York, Ny, Us

Database development, ETL, and tSQL - lots of it- Member of a three person team that modeled and built an AWS RDS SQLServer database to serve as the business intelligence source of a multi-billion dollar class action settlement.- Programmed an ETL application with Excel VBA and sprocs to clean and load claimant transaction information from over seventy different sources.- Scripted and performed ETL operation on 5 large ad-hoc data transfers for company using Excel PowerQuery and VBA- Owned project to migrate a dozen regular audits and reports from manual execution onto SSRS, saving over 4/week of unbillable time- Created over 50 complex custom SQL reports under high pressure deadlines- Designed stored procedures to automate regularly performed CRUD ops.

New York, New York, Us

Part of Citi's Chief Data Office Data Services Division, specializing in OTC Derivatives- Develops complex SQL queries to extract contract data based on stakeholder requests- Derive insights about data problems through Python/Pandas and VBA analysis- Developed 5+ VBA apps to automate parts of the OTC derivatives workflow- Trains new team members on the contractual database's logical structure / querying with SQL- Assist preparing BRD's & FRD's with OTC Lead Analyst- Part of an SME Training Program that includes ongoing Agile/Scrum trainings

Master Of Business Administration (M.B.A.), Finance

Bachelor'S Degree, Music Theory And Composition, Composition Emphasis