Sonj McCoy

Experience

• 

  Ontogen Corporation

  Jan 1996 - Jan 2002

  Scientific Database Administrator/Software Specialist

  Managed MDL, Daylight and Oracle research databases on an SGI server using SQL Plus and Toad. Developed chemi cal and biological research databases using ISIS/Host and Oracle. Created Oracle tables and views for in-house scientific applications using SQL and PL/SQL. Installed and distributed Oracle 8i client for software developers and scientists. Developed compound submission forms using ISIS/Excel and VBA. Installed and configured Oracle 7.3.4 server and database. Setup new SGI server to store research databases. Show less

• 

  Consultant

  Jan 2003 - Jan 2006

  Scientific Database/Application Developer

  Projects:Proteomics Database and Application, Ambrx, La Jolla, CAConstructed corporate research database and front-end application that captures research data in Research departments. The database captures cloning, expression, chemical and protein registration. Data-entry and query GUI forms were developed using VBA and MS Access. LIMS Database and Application, Genomics Institute of the Novartis Research Foundation, GNF, La Jolla, CADesigned and developed a Protein Research Database for the Protein Science Department that captures cloning, expression, purification and crystallography data. Constructed the back-end database for Protein Research in MySQL on a Linux platform. Used VBA and MS Access to develop front-end data-entry and project management GUI forms. Show less

• 

  Virginia Tech

  Jan 2006 - Jan 2017

  Business Intelligence Developer

  Designed and developed dashboards, documents, and ad-hoc reports using MicroStrategy and Hyperion Interactive Reporting. Provided user testing and analysis on a variety of ad-hoc reports in order to ensure user functionality and data accuracy. Relevant dashboards created include College of Agriculture and Life Science Administration, Corporate Research Center, VT Foundation, Grant Search, Alumni, and Graduate Admissions. Relevant ad-hoc reports cover the areas in finance, HR, payroll, grants, and internal audit. Managed the university web application for parameter-driven reporting and distribution of SAS and SQR reports. The application is an enterprise Java application that is parameter-driven and schedules/processes SAS and SQR reports on a UNIX platform. Show less

• 

  The George Washington University

  Jan 2018 - Jan 2020

  Business Intelligence Analyst

  Designed and developed dashboards using Tableau, Splunk and BMC Smart IT. Provided analysis on a variety of ad-hoc reports in order to ensure user functionality and data accuracy. Designed and built new dashboards and reports covering the areas of help desk ticketing, call centers, call usage and chatbot AI (Artificial Intelligence) data. Provided advice and solutions on data quality issues. Conducted monthly training sessions to promote self-service reporting.

• 

  Booz Allen Hamilton

  Oct 2020 - now

  Data Visualization and Business Intelligence Analyst