Experience

66degrees

• United States
• Business Consulting and Services
• 300 - 400 Employee

• GCP Data Engineer

  • May 2022 - Present



TEKsystems

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Engineer - Onsite at Meta

  • Nov 2021 - May 2022

  Menlo Park, California, United States - Creating pipelines using an Airflow-like Python Data Pipeline Framework, Spark and Presto - Leading Better Data Engineering initiative which has improved the following statistics thus far: - Increased the number of critical tables meaningfully documented by 37% - Decreased the number of unused pipelines by 58% - Decreased the number of unused tables by 44% - Increased number of critical tables with data quality checks by 53% - Successfully organized… Show more - Creating pipelines using an Airflow-like Python Data Pipeline Framework, Spark and Presto - Leading Better Data Engineering initiative which has improved the following statistics thus far: - Increased the number of critical tables meaningfully documented by 37% - Decreased the number of unused pipelines by 58% - Decreased the number of unused tables by 44% - Increased number of critical tables with data quality checks by 53% - Successfully organized migration of over 2000 downstream assets from legacy to current datasets by working with over 300 downstream asset owners - Decreased pipeline compute usage and runtime by replacing inefficient functions, optimizing data types and changing join order Show less



Epsilon

• Advertising Services
• 700 & Above Employee

• Senior Traffic Quality Data Analyst/Data Engineer

  • Apr 2020 - Aug 2021

  Remote WFH - Created and maintained data processing scripts that collectively process 40 GB of data from over 1000 files per week - Created underlying tables, views and queries that married internal data with third-party data sources to drive Tableau BI reports used by nearly every member of the department, including C-level executives - Ensured integrity and timeliness of mission-critical data in over 200 tables across 2 PostgreSQL databases - Ensured quality of team's scripts by… Show more - Created and maintained data processing scripts that collectively process 40 GB of data from over 1000 files per week - Created underlying tables, views and queries that married internal data with third-party data sources to drive Tableau BI reports used by nearly every member of the department, including C-level executives - Ensured integrity and timeliness of mission-critical data in over 200 tables across 2 PostgreSQL databases - Ensured quality of team's scripts by developing coding best practices, creating a Python library containing frequently-used functions and maintaining the BitBucket (git) repository

• Traffic Quality Analyst

  • Jun 2019 - Mar 2020

  Westlake Village, California, United States - Streamlined SQL query development process by creating custom, light-weight SQL functions to perform calculations that adhere to our Media Rating Council accreditation requirements - Decreased time required to perform site reviews from an average of 65 seconds per site down to 7 seconds per site by developing an Excel-based tool using VBA and creating easy-to-follow flow charts - Designed and developed a Python-based Data Pipeline Framework from the ground-up to automate the… Show more - Streamlined SQL query development process by creating custom, light-weight SQL functions to perform calculations that adhere to our Media Rating Council accreditation requirements - Decreased time required to perform site reviews from an average of 65 seconds per site down to 7 seconds per site by developing an Excel-based tool using VBA and creating easy-to-follow flow charts - Designed and developed a Python-based Data Pipeline Framework from the ground-up to automate the process of ingesting, formatting, and validating files from FTP/SFTP Servers, Emails, RESTful APIs, Scraped HTML and Raw/Binary data sources into GreenPlum/PostgreSQL databases - Dramatically reduced SQL query cost by optimizing queries and using automated Python scripts to create small aggregate tables from large, heavily-used tables during off-peak hours

• Publisher Integration Engineering Apprentice

  • Jan 2019 - Jun 2019

  Westlake Village, California, United States - Integrated new publishers into our ad network by generating JavaScript tags to be used directly on their site or integrated into third-party tools like Google Ad Manager (Formerly DoubleClick) - Resolved integration issues by: - Monitoring, intercepting and modifying bid requests from publisher pages using Fiddler and Charles - Testing internal and third-party endpoints using cURL, Postman and Python - Recreating region-specific issues by spinning up AWS EC2… Show more - Integrated new publishers into our ad network by generating JavaScript tags to be used directly on their site or integrated into third-party tools like Google Ad Manager (Formerly DoubleClick) - Resolved integration issues by: - Monitoring, intercepting and modifying bid requests from publisher pages using Fiddler and Charles - Testing internal and third-party endpoints using cURL, Postman and Python - Recreating region-specific issues by spinning up AWS EC2 Virtual Machines in multiple regions to run Python scripts that send the HTTP requests and log the responses to be compared for inconsistencies - Reviewing HTML and JavaScript on publisher pages to find any elements that could interfere with the ad-serving code

• Traffic Quality Apprentice

  • Jul 2018 - Dec 2018

  Westlake Village, California, United States - Created a Python tool to validate website quality by crawling them and extracting links, analyzing content for inappropriate keywords and taking screenshots to be reviewed manually later - Created complex SQL queries used by entire team to conduct routine investigations - Developed Excel workbooks that automated daily reporting tasks using VBA and PostgreSQL integration



Berkeley Method of Entrepreneurship Bootcamp

• Student Mentor

  • Apr 2017 - May 2018

  UC Berkeley, Berkeley, CA & Hong Kong Baptist University, Hong Kong These bootcamps were facilitated by the Sutardja Center for Entrepreneurship and Technology at University of California, Berkeley and were held on the UC Berkeley and Hong Kong Baptist University campuses. - Mentored 20 international and domestic startups, improving clarity in pitch decks, coaching elevator pitches, and streamlining business models - 3 Hong Kong startups went on to raise over 100k HKD each and ended up in HK's Cyberport Accelerator



Mirion

• United States
• Appliances, Electrical, and Electronics Manufacturing
• 400 - 500 Employee

• Acquisition Project Analyst

  • Feb 2016 - Jul 2016

  San Ramon, California - Created the Enterprise Resource Planning system (ERP) migration plan with estimated costs, timeline, resources, constraints and potential roadblocks for 3 different migration options by synthesizing data from project managers that had completed similar migrations, vendors, consultants and online research - Streamlined supply chain management systems by identifying geographic and product line overlap which allowed us to consolidate our manufacturing and sales systems - Decreased… Show more - Created the Enterprise Resource Planning system (ERP) migration plan with estimated costs, timeline, resources, constraints and potential roadblocks for 3 different migration options by synthesizing data from project managers that had completed similar migrations, vendors, consultants and online research - Streamlined supply chain management systems by identifying geographic and product line overlap which allowed us to consolidate our manufacturing and sales systems - Decreased software licensing costs by analyzing software usage across every PC on the network and identifying redundant and outdated software that could be cut and recommended cheaper alternatives to expensive applications - Reviewed and redlined 150 page service level agreements to protect the interests of both companies and to ensure that we had everything we needed to migrate all business systems from the old network under Canberra's parent company to our network including license allocations, appropriate timelines, contingencies and all necessary hardware Show less



Shred-it

• Canada
• Information Services
• 700 & Above Employee

• Accounts Receivable Specialist

  • Jul 2015 - Feb 2016

  Concord, California - Worked in Call Center environment responsible for fielding customer inquiries regarding billing and service issues for the Northern California Region - Collected $500,000+ in overdue payments during my first 3 months with the company - Conducted trainings on how to identify and reconcile accounts with unapplied payments, misapplied payments, inaccurate invoices or account overages, allowing these tasks to be delegated to other coworkers and decreasing DSO by one third from 60 to… Show more - Worked in Call Center environment responsible for fielding customer inquiries regarding billing and service issues for the Northern California Region - Collected $500,000+ in overdue payments during my first 3 months with the company - Conducted trainings on how to identify and reconcile accounts with unapplied payments, misapplied payments, inaccurate invoices or account overages, allowing these tasks to be delegated to other coworkers and decreasing DSO by one third from 60 to 40 days outstanding - Contacted and collected from evasive customers by using company websites and LinkedIn to find points of contact within the company and to update any incomplete, false or inaccurate contact information Show less



IKEA

• Netherlands
• Retail
• 700 & Above Employee

• Home Delivery/Full Service Handout Coworker

  • Feb 2013 - Sep 2013

  Emeryville, California - Decreased counting errors and invoice validating time on large orders by collaborating with the warehouse team to develop a product picking and cart loading procedure that made all product labels easily read without having to remove items from the cart - Reduced incidences of missed, cancelled and rejected deliveries by developing a method to diagnose and solve common issues which included creating a lists of questions to address the root cause of each specific issue and lists of… Show more - Decreased counting errors and invoice validating time on large orders by collaborating with the warehouse team to develop a product picking and cart loading procedure that made all product labels easily read without having to remove items from the cart - Reduced incidences of missed, cancelled and rejected deliveries by developing a method to diagnose and solve common issues which included creating a lists of questions to address the root cause of each specific issue and lists of solutions to resolve each issue when it arises - Gracefully resolved customer concerns by using empathy and active listening to fully understand the issue, offering the most equitable solution possible within my authority and escalating the issue only when all other avenues have been exhausted - Swiftly processed orders for delivery which included accurately keying in customer data, verifying and labeling each item, and maintaining up-to-date shipping manifests - Assisted the IKEA Business Team in designing retail and office spaces for local businesses. Duties included establishing realistic timelines, ensuring adequate product stock, and suggesting products based on availability Show less



adidas

• Germany
• Sporting Goods
• 700 & Above Employee

• Advanced Retail Professional

  • Apr 2011 - Apr 2013

  San Francisco, California - Consistently achieved the highest KPIs within my department, beating sales-per-hour goals by 25% and items-per-transaction goals by 50% on average - Maintained a positive rapport with other district stores to track down hard-to-find items for customers as well as organize inter-store gatherings and get-togethers - Boosted sales by analyzing sales figures to identify key products and trends that informed how to organize the sales floor in a way that maximized product… Show more - Consistently achieved the highest KPIs within my department, beating sales-per-hour goals by 25% and items-per-transaction goals by 50% on average - Maintained a positive rapport with other district stores to track down hard-to-find items for customers as well as organize inter-store gatherings and get-togethers - Boosted sales by analyzing sales figures to identify key products and trends that informed how to organize the sales floor in a way that maximized product exposure - Created and executed visual merchandising plans using style inspiration from online media, local fashion and looks from our customers - Worked with marketing executives to put on unique in-store events including a meet-and-greet with the Mexican National Soccer team and a video game release party for Electronic Art’s "Need for Speed: The Run" Show less



Danville Bowl

• Front Supervisor, U-18 League Coordinator, Head DJ

  • Apr 2008 - Jun 2011

  Danville, California - Listened attentively to clients in order to establish clear goals for their events and coordinated with team members as well as outside vendors to meet deadlines and stay within budget - Increased league sign-ups by creating and executing marketing plans to capture existing customers and sponsoring local events - Performed as DJ during private events and thrice weekly for "Cosmic Bowl"