Data Engineer

• Feb 2023 - Present

Senior Data Engineer/Analyst

• May 2022 - Present

* Migrate key data from various locations into a central data warehouse, housed within redshift * Saved the company $50k in professional services cost around an NPI Registry. Completed in a few weeks * Rebuilt entire KPI suite of reports to be live and data driven * Utilized fivetran, dbt, and data modeling to improve all aspects of the business. * Migrate key data from various locations into a central data warehouse, housed within redshift * Saved the company $50k in professional services cost around an NPI Registry. Completed in a few weeks * Rebuilt entire KPI suite of reports to be live and data driven * Utilized fivetran, dbt, and data modeling to improve all aspects of the business.

Data Engineer

• Nov 2020 - Feb 2023

* Work in small companies and enterprise clients creating data pipelines via python, dbt, scripting and various other tools. * Using various data stores (AWS, Snowflake, Postgres, CSVs) to create efficient data pipelines that create a one-stop shop for the "truth" of data. * Visualize data in a series of tableau reports that update daily * Integrate these reports and data with APIs to NCOA platform and salesforce * Created logging around the process to keep data and reporting up to date

Senior Data Engineer

• Jan 2022 - Apr 2022

Part of a small agile team of data engineers. We worked together to bring data from many different stores into a data warehouse. This continued as the company grew and utilized other resources. Some of my duties consistend of: * Automated Data pipelines through various tools/software. Utilizing AWS, Lamda, DBT, Dagster, Github, Python and custom APIs * Created and maintained visualizations on PowerBI and Tableau * Worked with stakeholders and others with limited technical knowledge to achieve proper data integration and analysis.

MySQL Database Administrator

• Apr 2018 - Oct 2021

Be the one stop show for all things database, between users/developers and IT • Administer MySQL on production and development CentOS7 servers locally and in the cloud • Responsible for Entire life cycle of data including: data design, database architecture, metadata and repository creation • Upgraded MySQL from single server to a cluster with High Availability, hot backups and live monitoring via python. • Create python and bash scripts to automate backups, data migration and improve database functionality • Transformation of this data into business requirements, troubleshooting problems and tuning existing applications queries. • Generate and analyze business data trends in reports on platforms: Google Data Studio, Qlikview, Tableau and Logi Analytics • Built a fully automated data warehouse using python scripts to serve internal and external users KPI and day-to-day business needs

Data Engineer

• Jul 2015 - Apr 2018

Assist Healthcare in reducing waste and cost by utilizing and organizing data for health systems. • Created data warehouses for Healthcare from disparate data sources using T-SQL and ETL processes • Collaborated directly with clients on their data requests and essential reports, in either engineering the data, or creating another solution • Designed end-to-end solutions from raw data to visualization • Lead discussions, internal and external, to visual best practices and use cases for visual tools (Tableau, Qlikview, D3, Shiny) • Consulted clients and internal personnel on Visualization best practices • Converted Qlikview visualizations to work fluidly in Tableau

Business Intelligence Developer

• Aug 2013 - Jul 2015

• Applied basic data mining algorithms to Big Data (Hadoop, hive) providing basis for business decisions• Created a lightweight Python script that ran every 10 minutes which automated part of my job: refreshing Tableau extracts based on data warehouse refreshes• Migrated key reports from both a datawarehouse change (SQL to Paraccel) and Visualization change (Excel and Microstrategy to Tableau)• Built a Microstrategy mobile app, from Star to Snowflake Schema, using sql views and objects/reports within Microstrategy• Provided support and administration to 1400 users of Tableau desktop/server• Maintained reports in Microstrategy, or Tableau with a Javascript wrapper to create a reporting portal• Created dynamic visual reports for in house and external use

Project Lead/ Database Analyst

• Nov 2011 - Aug 2013

• Create effective ad-hoc reports using Excel and SQL to massage data • Convert varying data types (flat files, access, excel etc…) on to a 3 table system SQL to be used in tools. • Devise different cursors and stored procedures within SQL server to conserve time and resources so multiple projects can be processed at a time• Troubleshoot and augment in-house tools when they provide inaccurate tests.• Quickly learn new functions and equations in SQL from online forums• Interpret data concerning textual trends and character anomalies• Collaborate with co-workers and managers in providing on-time delivery of projects

Alarm Technician

• Jan 2008 - Nov 2011

• Maintained good-will and integrity while helping disgruntled customers • Educated myself on the new home-automation products as technicians and customers had them installed • Expanded my alarm technician training and assisted customers with internet/routers, locks, cameras and all other processes relating to home automation • Created trainings and shared knowledge effectively without the help of visual aids • Analyzed changes in product design and provided findings to management • Calculated, monitored, and reported call volume and variance

Stock/Clerk

• Sep 2006 - Dec 2007

Unload shipments and stock the front and back room. Collect inventory several nights a week counting chocolate, boxes, baskets and all other items in the store. Fill candy boxes per request of customers and work as cashier. Greet customers upon entry to the store and educate them on the candy in the store while giving a sample Unload shipments and stock the front and back room. Collect inventory several nights a week counting chocolate, boxes, baskets and all other items in the store. Fill candy boxes per request of customers and work as cashier. Greet customers upon entry to the store and educate them on the candy in the store while giving a sample

Typesetter/Graphic Design

• Aug 2000 - Apr 2002

Create ads for local businesses. Type/copy articles into Adobe pagemaker or Quark express Compile and assemble the ads and articles of the newspaper physically on paper; 2004 Create ads for local businesses. Type/copy articles into Adobe pagemaker or Quark express Compile and assemble the ads and articles of the newspaper physically on paper; 2004