- Develop data pipelines to transform data from AWS S3 into dimensionally modeled tables resulting in accurate and performant data ready for consumption in Looker Dashboards and self-service analytics - Leverage REST API calls to ingest metadata from Legacy Matillion ETL project to identify and remove unused components resulting in improved development team workflow- Redesign DDL for 1 trillion+ row tables to ensure alignment with AWS Redshift table design best practices resulting in optimized performance and minimized job runtimes - Provide technical guidance for a project to migrate from Matillion ETL to Data Build Tool (dbt) aiding in the successful implementation of dbt - Conduct GitHub based code reviews to ensure alignment of committed code with dbt coding best practices - Commit code changes to AWS Cloud formation-based Infrastructure as Code platform successfully building new AWS Redshift Clusters to increase the compute power of our data warehouse - Develop SQL scripts to identify data gaps across multiple tables at a time allowing our team to more effectively target the root cause of downstream issues - Conduct root cause analysis to determine source of data errors in the pipeline and implement necessary changes to prevent future occurrences

• Develop data models and ETL data pipelines integrating product data and ~10+ business systems for company-wide use (AWS S3, Fivetran, Snowflake, dbt, Looker)• Lead dbt project implementation and promote best practices to enable effective team collaboration and data development operations • Establish automated data quality testing to allow proactive identification and correction of inaccurate data• Advise on data modeling and data infrastructure changes to drive best practices and optimize performance • Successfully provide in-depth technical troubleshooting to identify and resolve company-wide data issues• Collaborate with multi-departmental stakeholders to scope and design solutions to translate business requirements into new dashboards and reports

Risk and Safety Solutions is borne from UC Davis and develops Risk Management SaaS for Public and private research institutions. My responsibilities include development data models, engineering ETL pipelines, and visualizations to enable our clients to find value from their data.

• Develop database models, ETL pipelines, and dashboards used by department leadership to track usage trends of multiple applications across the University of California system • Successfully clean and prep semi-structured data using ETL processes consuming data from NoSQL, Graph, and relational sources resulting in ready-to-use data for reports and dashboards • Utilize Microsoft Power BI and the Microsoft data stack to develop enterprise level dashboards and reports enabling client research institutions and government agencies to effectively manage risk and compliance regulations• Effectively co-developed a solution to acquire and visualize geospatial data to help research institutions locate and plan hazardous waste removal

- Successfully develop custom reports with Cognos Business Intelligence to meet client data reporting needs- Utilize detailed knowledge of core product business logic and SQL Server-based relational databases to customize relational data models to meet client-specific business requirements- Write T-SQL Queries in SQL Server Management Studio to identify data needed to develop reports and to research root cause of defects reported by clients - Develop dimensional data model for SaaS-based data warehouse solution to effectively meet the large-scale enterprise reporting needs for client companies - Administer Cognos Business Intelligence systems to allow for the development of models and reports, and to facilitate client acceptance testing - Conducted SSRS report development to gather data needed to provide test case documentation and traceability for clients- Accomplished an 80% retest-success rate using ad-hoc methods on highly customized SOAP-based software integrating approximately 15 large-scale enterprise systems

- Provided Linux server administration to provide testing and development environment for LAMP-based Magento eCommerce platform - Successfully gathered business requirements through effective communications with stakeholders to establish software evaluation criteria. - Researched and evaluated software from approximately 50 vendors to find the best fit to meet the eCommerce requirements for all North American sites. - Successfully installed and configured LAMP-Based Magento eCommerce Platform to provide application testing and pilot deployment. - Developed training and support to ensure end-user success for testing and pilot deployment of Magento eCommerce Platform.

- Achieved annual program funding growth of $49,360 over two years - Successfully created content design proposals as an active participant in the implementation of an Enterprise Resource Planning software package - Effectively designed and delivered customer service training for 100+ department staff members at annual training events resulting in standard customer service practices - Increased operations efficiency by implementing an online staff scheduling system for 35+ hours of weekly event programming resulting in improved staff communication by enabling instant access to schedules via mobile device - Improved human resources operations by innovatively transitioning to online payroll and event report submission system for 8 program staff facilitating data collection and analysis of effective utilization of resources - Oversaw successful business operations overhaul resulting in increased safety for 400+ program participants and full compliance with industry risk management practices

- Authored employee manuals and facilities training guide to assure quality customer service practices for 12 person staff - Created cost projection for annual program staffing utilizing large datasets to ensure accurate annual budget planning - Administered multiple funding accounts utilizing decision support software and proactive communications to facilitate efficient and timely access to funding for 36+ sport clubs - Served as a master of ceremonies at annual department-wide staff trainings (500 attendees)

- Detailed maintenance/ preparation of playing surface of Blair Field: facility used for NCAA Division I baseball and minor league baseball events - Managed facility for large events - Controlled access to event resources and equipment

- Provided Interactive customer relations - Performed for large crowds - Created high entertainment value for customers

- Managed and maintained visiting clubhouse. - Prepared supplies for coaches/players necessary for game time performance - Retrieved and stored balls and bats during games.