Data Migration Consultant

• Jun 2022 - Present

• Analyze Salesforce Configuration to push data via DBAmp and SQL Server • Insert, Update, Delete, Transform client data to meet Salesforce CPQ requriements • Query and extract data from databases such as Zuora, Service Titan, and NetSuite • Collaborate with a tram in GitHub and Atlassian to develop code relating to Sales Cloud, CPQ, and Service Cloud • Customize applications in Excel, Word, and Google Docs to facilitate and track Data Migration best practices • Analyze Salesforce Configuration to push data via DBAmp and SQL Server • Insert, Update, Delete, Transform client data to meet Salesforce CPQ requriements • Query and extract data from databases such as Zuora, Service Titan, and NetSuite • Collaborate with a tram in GitHub and Atlassian to develop code relating to Sales Cloud, CPQ, and Service Cloud • Customize applications in Excel, Word, and Google Docs to facilitate and track Data Migration best practices

Lead Data Evangelist

• Feb 2022 - Jun 2022

• Customize Salesforce to improve Sales performance, track Marketing data, and follow project development• Guide junior members through the Data Evangelist program, introduce them to clients and assist with projects• Work with over 100 clients to optimize data inputs and develop analysis via Machine Learning (ML)• Visit clients on-site to improve interpersonal connections and validate project goals• Responsible for administering Fracta's Salesforce account, by activating and deactivating user accounts, developiung new custom objects, creating up reports and dashboards, and setting up web-to-lead pathways

Data Evangelist

• Feb 2020 - Feb 2022

• Tracked client software use and feedback in Salesforce CRM to improve features and design new projects• Assisted customers to modernize their databases by digitizing information from hardcopies• Shared knowledge in weekly meetings, and discussed new ideas, client feedback, and feature performance• Developed a data pipeline to automate cleaning, formatting, and mining client data via python and SQL• Curated data in Amazon Web Service in S3 for automated storage, beta testing, and processing• Collaborated with engineers on Asana to resolve bugs, describe feature requests, and enhance performance

Sabbatical

• Oct 2019 - Feb 2020

Competitive Drive Tester

• Aug 2019 - Oct 2019

• Tested various Navigation software through route driving• Collected and submit GPS data using a mobile application device • Trained new personnel to operate GPS devices, apps, and workflow• Troubleshooted field equipment and communicate solutions

GIS Analyst

• Mar 2018 - Jul 2019

• Analyzed, validated and enhanced data content and assembled new content for consumer applications• Created tickets using a proprietary system to describe bugs, new feature ideas, or clarify uses of a new tools• Collaborated with team members via Quip to edit maps and optimize new procedures• Automated geospatial processes in python to provide Engineers with Geospatial Shapefiles as required

Data Manager Specialist

• Mar 2013 - Mar 2018

Database Management: • Maintained multiple relational databases, and developed SQL Queries and reports to find discrepancies Data Analysis • Summarized and analyzed data via Macros in Excel data and send data feeds to peers and supervisors Geospatial Analysis Task • Designed maps of ports, study sites, and fish habitat use with ESRI’s ArcMap and QGIS • Connected geospatial data between Google Earth and ArcMap Database Management: • Maintained multiple relational databases, and developed SQL Queries and reports to find discrepancies Data Analysis • Summarized and analyzed data via Macros in Excel data and send data feeds to peers and supervisors Geospatial Analysis Task • Designed maps of ports, study sites, and fish habitat use with ESRI’s ArcMap and QGIS • Connected geospatial data between Google Earth and ArcMap

Fisheries Biologist

• Jun 2011 - Mar 2013

Mekong River Artisanal Fisheries Monitoring Project: • Architected a relational database in MS Access to manage data collection • Designed a UI to improve data entry into an Access Database via field validation rules and macros • Generated applications in R to analyze information on environmental, social and market value Geospatial Analysis Tasks: • Referenced geolocations of watershed and flood area features in ArcMap and Google Earth • Analyzed Salmon Redd densities along rivers in ArcMap by creating point locations, polylines, and polygons • Estimated percent cover of wetlands and wells by digitizing features from satellite imagery • Verified coordinates of samples from field transect data collected via Trimble GPS units Sacramento Riverbank Protection Project • Standardized sample design, improved Access database and UI for more efficient data entry • Recovered damaged data files, reformatted video data, and combined data from desktop and GPS device • Developed and documented data collection methods to gather metrics in a standardized fashion

Scientific Technician

• Sep 2010 - Dec 2010

• Constructed an annotated bibliography from literature review in MS Excel. Record data from epibenthic megafuana at sea using towed camera sled, and ROV (Remote Operated Vehicle) Beagle on board RV FULMAR • Constructed an annotated bibliography from literature review in MS Excel. Record data from epibenthic megafuana at sea using towed camera sled, and ROV (Remote Operated Vehicle) Beagle on board RV FULMAR

Fisheries Technician

• Jul 2010 - Sep 2010

• Seasonal Employment • Rescue steelhead trout in Carmel River • Collect juvenile steelhead via beach seine and electrofishing • Seasonal Employment • Rescue steelhead trout in Carmel River • Collect juvenile steelhead via beach seine and electrofishing

Scientific Aid

• Apr 2010 - May 2010

• Retrieved and sort invertebrates into general taxonomic classes and families from sediment samples. Sediment samples were retrieved from coastal soft substrates of Monterey Bay • Prepared storage solutions from ethanol and water • Retrieved and sort invertebrates into general taxonomic classes and families from sediment samples. Sediment samples were retrieved from coastal soft substrates of Monterey Bay • Prepared storage solutions from ethanol and water

Fisheries Technician

• Aug 2009 - Sep 2009

Seasonal Employment • Rescued steelhead trout in Carmel River • Collected juvenile steelhead via beach seine and electrofishing. Seasonal Employment • Rescued steelhead trout in Carmel River • Collected juvenile steelhead via beach seine and electrofishing.

Scientific Technician

• Dec 2008 - Jun 2009

• Mapped fauna locations (POI) of estuarine invertebrates using a GPS unit • Identified and logged POI coordinates of marine epifauna from Photo Stills collected from ROV transects in Antarctica • QA/QC datasheets, clean vials with acid, and calibrate equipment. Operate centrifuge to test salmon tissue samples for mercury • Mapped fauna locations (POI) of estuarine invertebrates using a GPS unit • Identified and logged POI coordinates of marine epifauna from Photo Stills collected from ROV transects in Antarctica • QA/QC datasheets, clean vials with acid, and calibrate equipment. Operate centrifuge to test salmon tissue samples for mercury

Salmon Ecology Internship

• Apr 2007 - Aug 2007

• Marked and recaptured steelhead and coho salmon using tagging technology to evaluate weir effectiveness in Scotts Creek. • Participated in a Research Expedition on R/V David Starr Jordan to track Salmon Migrations along the coast of Northern California. • Collected scale and fin samples for DNA analysis, conducted redd surveys in Scotts Creek, entered data into a palm held computer pad, estimated effectiveness of weirs to recapture adult salmon with statistical software and DARR 2.0 (Darroch Analysis with Rank Reduction), and summarized results in a report. • Assembled and disassembled fish traps and weirs.