Experience

Continuum Media

• United States
• Advertising Services
• 1 - 100 Employee

• • Feb 2022 - Present

  • Redshift database development and management for TV ad impressions, aired TV ad spend, TV ad viewership demographics, and other forms of data• ETL development using Alteryx, AWS Glue, and AWS Lambda with Python, PySpark, Pandas, and SQL to load and manipulate data within the Redshift database and to migrate data between the S3 data lake and various databases (Athena, MySQL, etc.)• Tableau dashboard development to support TV ad performance analysis of various demographics, ad campaigns, ad agencies, and advertisers• Advanced Python, PySpark, Pandas script development to support complex analytical calculations, automated downloading of data from websites to databases (Web Scraping ETL), data manipulation and transformation, and other activities• Data modeling using entity relationship (E-R) modeling techniques to design and document database structures • Write and execute SQL queries using SQL Workbench to gather data from the Redshift database to support routine and ad-hoc analyses• Meet with users to gather and document data, dashboard, and reporting requirements Show less

• • Feb 2020 - Feb 2022

  • Redshift database development and management for TV ad impressions, aired TV ad spend, TV ad viewership demographics, and other forms of data• ETL development using Alteryx, AWS Glue, and AWS Lambda with Python and SQL to load and manipulate data within the Redshift database and to migrate data between the S3 data lake and various databases• Tableau dashboard development to support TV ad performance analysis of various demographics, ad campaigns, ad agencies, and advertisers• Advanced Python (Pandas, Numpy, etc) script and algorithm development to support complex analytical calculations, automated downloading of data from websites to databases (Web Scraping ETL), data manipulation and transformation, and other activities• Data modeling using entity relationship (E-R) modeling techniques to design and document database structures • Write and execute SQL queries using SQL Workbench to gather data from the Redshift database to support routine and ad-hoc analyses• Meet with users to gather and document data, dashboard, and reporting requirements Show less



Terumo Blood and Cell Technologies

• United States
• Medical Equipment Manufacturing
• 700 & Above Employee

• • Apr 2018 - Nov 2019

  Front-end and back-end business intelligence development: • SQL Server database development and management for sales, cost of goods sold, operating expense, and other forms of data • ETL development using SSIS, SQL, VB, and Python to load and manipulate data within the SQL Server database • Data modelling using entity relationship (E-R) modelling techniques to design and document database structures • Write and execute SQL queries using Visual Studio to gather data from the SQL Server database and support routine and ad-hoc Power BI dashboards and Excel reports• Power BI dashboard development using DAX to support sales, operating expense, marketing, and other forms of analysis • Meet with users to gather and document dashboard and reporting requirements • Development of specialized algorithms using Python and/or VBA to support complex financial models, find trends in data, and to support other specialized analytical situations • Dashboard and report development in Excel to support routine and ad-hoc sales analysis, operating expense analysis, deal analysis, and other forms of analysis Systems Experience: SQL Server, SSIS, Power BI, Kivy, Excel, Access, SAP Business Warehouse (BW), and SAP Business Planning & Consolidation (BPC)Coding Languages: VBA, VB.NET, SQL, Python Show less

• • Jun 2016 - Mar 2018

  Front-end and back-end business intelligence development: • SQL Server database development and management for sales, cost of goods sold, operating expense, and other forms of data • ETL development using SSIS, SQL, and VB.NET to load and manipulate data within the SQL Server database • Data modelling using entity relationship (E-R) modelling techniques to design and document database structures • Write and execute SQL queries using Visual Studio to gather data from the SQL Server database and support routine and ad-hoc Power BI dashboards and Excel reports• Power BI dashboard development using DAX to support sales, operating expense, marketing, and other forms of analysis • Meet with users to gather and document dashboard and reporting requirements • Development of specialized algorithms using Python and/or VBA to support complex financial models, find trends in data, and to support other specialized analytical situations • Dashboard and report development in Excel to support routine and ad-hoc sales analysis, operating expense analysis, deal analysis, and other forms of analysis Systems Experience: SQL Server, SSIS, Power BI, Excel, Access, SAP Business Warehouse (BW), and SAP Business Planning & Consolidation (BPC)Coding Languages: VBA, VB.NET, SQL, Python Show less

• • Oct 2014 - May 2016

  • Excel-based report development to assist budgeting, forecasting, business case analysis and modelling, and various ad-hoc reporting activities• Data manipulation, data modelling, and data preparation to support reporting activitiesSystems Experience: Excel, Access, SAP Business Warehouse (BW), SAP Business Planning & Consolidation (BPC)Coding Languages: VBA and SQL



HomeAdvisor

• United States
• Technology, Information and Internet
• 700 & Above Employee

• Business Analyst

  • Aug 2012 - Oct 2014

  Front-end and back-end business intelligence development: • Oracle database development for sales, email marketing, and other forms of data • ETL development (PL/SQL) to load and manipulate data within the Oracle database • Data modelling using entity relationship (E-R) modelling techniques to design and document database structures • Dashboard and report development in Excel to support routine and ad-hoc sales analysis, email marketing analysis, membership retention analysis, and other forms of analysis • Write and execute SQL queries using Toad to gather data from the Oracle database and support routine and ad-hoc Excel reporting Systems Experience: Excel, Oracle Database Coding Languages: VBA and SQL Show less