About Me

     After a number of years as a Research Associate in the biotechnology field, I decided to change careers to Data Analytics. Although I enjoyed analyzing scientific data, the data gathering process was prolonged and labor intensive. My time in the biotechnology field was not without its own successes. Not only was I promoted and published in scientific journals, but I also had the opportunity to help coordinate product launches, train sales associates, provide product technical support, and publish marketing materials.
     As for my education and skills; I completed my graduate studies in Economics with a 3.80 GPA while working full-time and followed up my graduate studies with a certificate in data analytics and a Tableau Desktop Associate certificate. Developing the necessary technical skills in order to collect and prepare data for analysis.
     In the Report Writer role that I hold currently, I am responsible for ad-hoc reports (created in SQL Server) that clinic managers, physicians, medical assistants, and business stakeholders require for grant purposes, patient outreach, worker performance, and/or audit purposes. I also implement and maintain Tableau dashboards according to client specifications. Some of these requests require me to research on medical terminology and procedures in order to analyze and interpret the data involved. Other duties also include training personnel on Excel capabilities (pivot tables and formulas), setting up automated reports in Business Objects/Crystal Reports, and maintaining the integrity of patient data.

Contact Details

Albert Doan
Oakland, CA 94610 US
(510)969-6105
www.github.com/a10doan
a10doan@gmail.com

Work

La Clinica De La Raza, Informatics

Report Writer • 11/2021 - Current

  • Writing complex SQL queries via Microsoft SQL Server. Running ad-hoc SQL reports for healthcare providers, department managers, physicians, and business stakeholders. Scheduling automated reports via Crystal Reports and SAP Business Objects./li>
  • Implementing and maintaining Tableau dashboards. Creating visual analyses and helping healthcare providers digest data in a more efficient manner.
  • Researching healthcare subject matter for accurate and up-to-date information.
  • Analyzing and interrogating data; identifying trends, maintaining data integrity, and making recommendations on additional metrics.
  • Training healthcare providers on utilizing Excel, Business Objects, EPIC applications, and Tableau.

    • Presidio Interactive, Digital Marketing

    Business Analyst • 3/2019 - 6/2020

  • Managed revenue reports, pulled data from various systems. Provided revenue analysis and trends.
  • Analyzed traffic affiliates and sources with poor performance. Generated reports, provided business insight to sales team and optimizing client lead conversion/acquisition costs.
  • Streamlined data collection and reporting process via Python scripts; removed manual data entry.
  • Built automated KPI dashboards via Google Data Studio/Google sheets.

    • Treasury Wine Estates, Digital Marketing

    Data Analyst Intern • 8/2018 - 11/2018

  • Identified KPIs within the digital ecosystem, provided insights and recommendations to stakeholders (sales and marketing managers). Developed new performance KPIs/metrics.
  • Created reports and dashboards on the overall health of e-commerce websites and mobile app, via Google analytics and Power BI. Performed ad hoc data requests from sales and brand managers.
  • Drove data accuracy and consistency across sources by identifying gaps and issues in data sources and dashboards.

    • Benitec Biopharma

    Research Associate III • 11/2015 - 4/2017

  • Researched scientific data and publications
  • Formulated and executed experiments. Performed data analysis on results from experiments.
  • Presented data and analysis of results to company executives and research scientists.

    • DiscoveRx Corporation

    Research Associate II • 6/2007 - 9/2015

  • Successfully launched multiple product lines.
  • Initiated a more efficient system to organize data to for sales/marketing teams.
  • Coordinated with all-levels within organization (Sales, Marketing, and Operations) for product launches.
  • Contributed to research publications/journals and scientific posters.
  • Lead training seminars for sales managers and other research associates on operating procedures and protocols.
  • Provided technical support to sales associates and managers.

    • Education

    University of California, Berkeley (UCB)

    Certificate in Data Analytics, GPA: A+ • April 2018

  • Data Visualization - Tableau, JavaScript Libraries (D3.js, Plotly.js, Leaflet.js), Python (Pandas, Matplotlib)
  • Programming Languages - JavaScript, Python, VBA scripting

    • California State University, East Bay (CSUEB)

    M.A. Economics, GPA: 3.80 • June 2016

  • Beta Gamma Sigma Honor Society
  • Thesis: Effects of Airbnb on Employment Levels and Wages

    • University of California, San Diego (UCSD)

    B.A. Biology, Minor: Economics

    Skills

    Tableau Certified Desktop Associate, Microsoft SQL Server, Python (Pandas, Matplotlib, Numpy), JavaScript (D3.js, Leaflet.js, Plotly.js), HTML/CSS, Web/Data scraping, VBA/macros, Heroku, GitHub, Git, C++, Jupyter Notebook, Social Analytics (API search/analysis), STATA, MySQL, SQL application building (SQLalchemy, Flask), JavaScript APIs, Tableau, Spark. Economic and regression analysis.

    Github Link