David Crabtree Email & Phone Number

Worldwide, Oo

Business to Government Portal• Supported development of flows using OmniScript, DocGen, and Salesforce Public Sector Solutions (PSS).• Resolved blockers and supported developers in adoption of Deloitte standards and procedures.• Assisted business facing product owners with bridging the gap between requirements and implementation.• Utilized agile project management including gathering requirements, preparing user stories, discovery of technological capabilities, technical documentation, source control, code review, and POCs.Citizen Facing Government Portal• Architected a solution that efficiently integrated into existing architecture with a focus on low code solutions. • Designed data architecture and entity relationships.• Coordinated with business facing product owners to ensure properly vetted requirements and implementations that most efficiently meet client expectations.• Collaborated with teams responsible for integrated system, such as a legacy government worker portal and pdf transformation service, to plan for and institute changes to APIs on both sides of the system.• Extended our custom framework to include additional client required functionality.• Utilized agile project management including gathering requirements, preparing user stories, discovery of technological capabilities, technical documentation, source control, code review, and POCs.Business to Government Portal• Architected a design solution for a community facing application including a data entry flow, review of records from entered data, and reporting.• Coordinated with business facing product owners to ensure properly vetted requirements and implementations that most efficiently meet client expectations.• Directed developer tasks, assisted with trouble shooting of necessary tools and implementation approaches including custom code and Salesforce tasks.• Utilized agile project management.

Worldwide, Oo

Citizen Facing Government Portal• Supported the development of a custom-built framework within the Salesforce platform to allow for a quicker time to market of data input screens. • Assisted in configuration and construction of a citizen portal based in Salesforce communities.• Created server level code and configuration for automation of data refinement from citizen provided information.• Construction and refinement of APIs necessary for validation of user information, identity, and transformation to legacy systems to streamline processes and reduce worker intervention.• Provided support to fill in for developer lead and architect roles for supporting other developers and reviewing/approving changes to the code base.• Built screens using the Salesforce LWC framework and Salesforce Lightning Design System• Supported Tableau CRM development, configuration, and data setup.• Utilized agile project management.

Fort Worth, Texas, Us

• Involved in 5 implementations in varying capacities, Salient projects are outlined below.• All projects required agile project management. This included gathering requirements, preparing user stories, discovery of technological capabilities, technical documentation, and POCs.Custom Tableau CRM Middleware• Using Agile methodologies, collected requirements and constructed a custom application with an Angular front end and spring boot backend with extensive integration to the Salesforce REST API for automatic and on-demand loading of databases from Teradata, Db2, and MySQL to Tableau CRM• The tool was hosted on a Linux VM based on an on-premises server.• This tool was used to load a 100 GB+ dataset to Tableau CRM for the Sales and Marketing teams that visualized annual trending of revenues and was frequently used in executive level discussions.• Dashboard development required advanced techniques in Tableau CRM such as modifying the JSON structure directly and the use of bindings.Marketing Cloud Engagements and Data Visualization• Coordinated with product owners to develop targeted email campaigns.• Implemented an apex-based batch class to connect to the Marketing Cloud API and collect email sends. These were then imported to Tableau CRM and transformed with dataflows to visualize information in dashboards.• Collated 100+ csv files containing 15 years of historical Marketing Cloud data to a single document using a python script for historical visualization in Tableau CRM and used dataflows to combine it with current data.Sales Freight Rate Tool• Our team implemented a Salesforce Communities based tool to allow customers to lookup rates for freight. The tool allowed requesting a rate if one was not available, tracking the approval status, and communicating with the appropriate stakeholders via chatter.• A REST API was developed to retrieve rates from a preexisting endpoint using apex.

Fort Worth, Texas, Us

• Involved in 6 implementations in varying capacities, Salient projects are outlined below.• All projects required agile project management except for 3 that were waterfall or a mix of agile and waterfall. This included gathering requirements, preparing user stories, discovery of technological capabilities, technical documentation, and POCs.Clerical Task Modernization• Coordinated with IBM mainframe based clerical subject matter experts and developers in a Waterfall project management structure to modernize and automate railcar reporting tasks by loading events to Salesforce via Tibco.• Developed reports and dashboards that provided metrics previously unavailable to leadership.Customer Support Self-Service Community• Provided customers with a self-service portal that allowed for viewing of open cases leading to a 10% reduction of customer generated cases.• Gathered requirements from and demoed results for leadership and relevant stakeholders.• Assisted in the development of process builders, flows, objects, fields, and lightning layouts.Accounts Receivable• Worked with business stakeholders and to translate requirements to developers using the Agile framework.• Directed proper transformation of from Db2 via informatica to summarize and display information on record layouts using Visualforce.• Configuration of custom objects and layouts

Fort Worth, Texas, Us

• Ad hoc configuration of list views and queues on Salesforce Service Cloud supporting 50+ end users• Creation of email templates, dashboards, and reports for management• Functioned as the business facing Salesforce administrator for Customer Support• Subject matter expert on Tableau CRM, provided POC’s to management and gathered feedback for enhancements. Developed lenses and dashboards to report on custom sentiment via data collected from Salesforce, Qualtrics surveys, and Genesys call data and transformed via dataflows to relate metrics to relevant Salesforce account, contact, and case records.

Waco, Texas, Us

Summer research internship with Dr. Sanghoon Kang.Resultant research publication:The response of human bacteria to static magnetic field and radiofrequency electromagnetic field.Crabtree DPE, et al. J Microbiol. 2017.

Houston, Texas, Us

Summer Medical And Research Training (SMART) program internship.Research under Dr. Janet S. Butel on Simian Vacuolating Virus 40 (SV40) in Syrian Golden Hamster intestinal tissue samples.Related research publications:Viral microRNA effects on pathogenesis of polyomavirus SV40 infections in syrian golden hamsters.Zhang S, et al. PLoS Pathog. 2014.Effects of route of inoculation and viral genetic variation on antibody responses to polyomavirus SV40 in Syrian golden hamsters.Swain JL, et al. Comp Med. 2012.

Master Of Science - Ms, Computer Science

Non-Degree Seeking, Computer Science

Master Of Business Administration - Mba, Finance, General

Bachelor Of Science - Bs, Biology & Biochemistry (Minor)