Grayson Bates Email & Phone Number

San Francisco, California, Us

Business support analyst and analytic consultant• Developed and executed a communication plan around a compliance based initiative for a 10,000+ employee technology organization• Partnered across organizations to understand appropriate criteria for time submission expectations and integrated knowledge into reporting structures and visualizations• Drove time reporting compliance increase of 22% over 8 months through bimonthly analytics of submission data and strategic communication and reporting • Built out a Tableau Dashboard allowing managers to monitor bimonthly reporting data representative of workload, employee activity and financial data for a technology organization with a multibillion dollar budget• Created bimonthly executive summary around time submission compliance for review by Technology Infrastructure leadership• Responsible for performing ad-hoc SQL queries and data collection for business partners that involved sensitive and non-sensitive HR data• Manage, update and troubleshoot Tableau dashboards for 6 different technology support call centers that facilitate direct managerial oversight of workload, capiacity and performance• Owned and improved monthly Excel based financial report that integrated time submission data and call center metrics for technology support command center • Partnered with Business Services Communication team to establish business requirements and manage the subsequent develop of SSRS reporting tool that enabled accurate new hire onboarding communication • Maintained monthly update of server install and decom tableau reports for Technology Infrastructure executive operations review• Responsible for documentation of all owned business initiative processes for purposes of repetition and reproducibility• Performed duties for weekly Vulnerability Management audit cadence encompassing the entire Technology Infrastructure organization for regulatory compliance

Charlotte, North Carolina, Us

• Analyst responsible for supporting a Customer Action Recommendation Engine and Customer Intent Prediction built in the cloud based platform SAP HANA• Mastering SQL HANA script that drives the performance of the recommendation engine harnessing the power of Gradient Boosted Decision Trees or Logistic Regression machine learning methodologies to determine which products would be accepted by which customers (while integrating eligibility criteria)• Responsible for communicating between business stake holders and development teams to understand issues and resolve them in a prioritized yet timely manner• Responsible for receiving input from stakeholders in order to continuously suggest and communicate to developers ways to improve the end user experience to increase efficiency, ease of use and ultimately profitability• Cross trained by other members of the support team (marketing, Checkpoint general web interfaced used by DE customer service representatives, Commerce web interface used in handling Non-Regulated products handled by 3rd party vendors, Security and permissions) to act as proxy in the event of their absence• Responsible for granting relevant temporary/permanent permissions and accesses to individual managers on a per request basis to both query and make changes to database schemas within the SAP HANA framework • As a support team we are tasked with understanding, triaging and executing solutions in a timely manner as BCM Remedy tickets are submitted from different departments throughout the program

• Created detailed Excel Spreadsheet of competitor pricing and product offering data surrounding each of 12 sales locations• Performed competitive analysis to optimize pricing structure and offerings using basic Excel techniques and Python scriptingSales Manager• Managed sales lot in Concord, responsible for inventory maintenance, costumer relations and negotiations• Subject to and met individual and lot performance goals, generating $150,000 in revenue during 12 month tenure

Charlotte, Nc, Us

- Python Scripting, Pandas data manipulation, VBA Scripting & Excel- SQL Database Queries- Database manipulation and Navigation- Visualization with Matplotlib and Seaborn - Interactive Visualization with Plotly, Tableau and D3 - API navigation and Web Scraping using Beautiful Soup - Web Development and Publication using JavaScript and Flask- Machine Learning

• One of 4 individuals to open speak-easy style craft cocktail lounge • Responsible for weekly liquor orders, biweekly material accounting/ordering/pickup and zeroing tender at the end of each shift

• Responsible for collecting profits from individual stores and transferring records into a detailed Excel spreadsheet weekly• Maintained Excel database detailing store front expenses and profits directly communicating with company owners weekly• Assisted in installation and troubleshooting of new computer software • Responsible for daily secretarial duties as needed by owner

Fort Mill, Sc, Us

Sales Representative • Finished in the top 18% of the company for 8 consecutive months• Chosen to launch DTV Global, a conglomerate business focusing on the sale of all major telecommunications companies at RV• Responsible for mentoring new hires to ensure a seamless transition into the sales force

Chapel Hill, Nc, Us

Worked for Dr. Daniel Matute identifying drosophila by sex and species, preforming field collection and population tending in order to increase population size. Tending and growing populations enabled the execution of mating experiments, population crosses, and facilitated collections for PacBio/additional bioinformatics analysis. Traveled with research team to Sao Tome Africa to preform field collections of both migratory and endemic island Drosophila species. Collections are being used to further understand ecological basis for species divergence and reproductive isolation.

Chapel Hill, Nc, Us

Worked in the lab of Dr. Anthony Richardson on a research project that examined the effect of gene knockout on detoxification efficacy and metabolic response to NO in S. aureus at the Idh-hmp locus. This project investigated S.aureus'​ ability to subvert the innate immune system's use of Nitric Oxide and ultimately aimed to reduce inpatient infections by staphylococcus bacteria in hospitals. Duties included gel electrophoresis, agar preparation, antibiotic phage preparation, antibiotic phage transduction, simple PCR, and Nitroc Oxide diffusion assays.

Bachelor Of Science (B.S.), Biology, Chemistry Minor

Data Analytics Certification, Data Analytics, Visualization And Web Development