Hugo Guan Email & Phone Number

• Dove into Box Tops For Education receipt scan data and designed a strategy to handle data outliers in unit price andquantity to reduce over-statement of total dollars by 6%, translating to over $10M in reductions
• Owned all consumer privacy requests for General Mills and fulfilled each task on time (530 and counting) to comply withCalifornia Consumer Privacy Act (CCPA)
• Migrated on premise Cloudera Hadoop data lake into Google Cloud Platform by interviewing stakeholders andcompleting documentation of tables for review by internal committee
• Gained an intimate knowledge of consumer privacy regulations and then spoke with stakeholders across the consumerspace to understand their data and then inform them on how to handle consumer PII
• Lead efforts in marketing consumer space to integrate automation where possible by speaking with a variety of businessstakeholders, application owners, and third party vendors
• Documented consumer data lake and presented findings to business in a data dictionary and sizing spreadsheet

• Developed and automated Python script to scan Netezza database daily to detect inaccurate drug prices being paid to pharmacies which saved $1.5M monthly
• Deployed automated Python scripts using Apache Airflow to run SQL queries to generate weekly reports to save team members time as well as reducing manual errors
• Queried Netezza data warehouse containing big data with SQL to produce analytical and government audit reports daily
• Used Sqoop command lines to transfer tables from Netezza to a cloud based Hadoop database deployment
• Created stories and dashboards via Tableau to present complex data sets to non-technical audiences
• Enhanced other teammates’ complex SQL queries that were having issues with big data sets (100M rows)

• Owned project as main technical BSA for a cloud based solution for the finance team due to new FASB compliance
• Wrote technical specifications for eight integrations from cloud software to on premise Oracle E-Business Suite
• Designed Visio data flow chart of all project interfaces for a high level view and to assist in project management
• Participated in testing effort at every level including; integration, system, user acceptance, and conference room pilots
• Engaged business stakeholders and vendors on a daily basis to ensure project effort was aligned and in scope

• Secured a stretch goal of scanning 4,500 databases in 10 months, versus an original objective of 3,000 in 12 months
• Performed enterprise wide scan to collect and analyze PHI/ PII data and gained healthcare industry knowledge
• Recognized for strong client relation skills by multiple project managers
• Gathered requirements from client and designed test cases based off of web application wireframes
• Managed handing off of final deliverables containing potential sensitive objects for each application scanned

• Disciplined in writing test cases with Microsoft Test Manager and Team Foundation Server
• Tested web application in multiple environments (Dev, QA, Production) and submitted daily bug reports
• Aided in the gathering and solidifying of technical and business requirements for the application
• Maintained cloud based database/application for clients who needed consolidated reports from multiple terminals
• Attended daily Scrum meetings with senior developers and received updates from offshore team concerning differentsoftware specifications and requirements

• Learned and then applied knowledge of HTML and CSS to help update and maintain the university library’s website
• Created new HTML pages frequently for new material and books that the library had recently acquired
• Searched for bugs and errors within the website and deployed fixes for them daily
• Trained on several different programs for assignments such as Adobe Dreamweaver and Photoshop

Master Of Science - Ms, Data Science

Bachelor Of Business Administration - Bba, Management Information Systems