Reginald Dean

Reginald Dean BI Developer / Data Analyst https://www.linkedin.com/in/reginald-dean-52ba5795/ https://public.tableau.com/app/profile/reginald.dean/viz//ReginaldDDeansResumeDashboard2023 - Midlothian, Virginia -Technical Skills Programing Languages: MS SQL, R, Python Data Visualization Tools: Tableau Desktop/Server, Power BI, MS Excel, MS Strategy Other Tools: Alteryx, Salesforce Marketing, Snowflake Data Governance, AWS, Reltio, SAP, Transcend Soft Skills: Report Writing, Analysis, Critical Thinking, Communication, Big Datasets Featured Projects COVID19 VHHA Data Analytics Team Tableau public facing dashboard has over 7 million views. The team has provided daily updates on hospitalizations & other big data key metrics I developed a Data Quality Report to ensure data was accuracy and correct during the height of the COVID pandemic this data and Tableau dashboards were invaluable resources: https://www.linkedin.com/feed/update/urn:li:activity:-/ Commission on Combating Drug Addiction and the Opioid Crisis The data team provided weekly updates on large datasets key metrics on Virginia’s Opioid Crisis, the fast increase in deaths impacted resource allocation of Narcan at the community zip code level using R for geocode mapping in Tableau. Article link below: https://wvmetronews.com/2017/11/01/presidents-opioid-commission-releases-final-report/ Work Experience BI Developer / Data Analyst Quoting Consultant, McKesson Medical Aug 2022 - Present Daily I am Using Smart sheet to manage team’s workflow and assign request, then using Sales force to pull, flat files and ETL data prep using Alteryx to run files through a pre-built workflow and perform QA and also on data design and develop data models that organize and structure data to support business intelligence and analytics requirements. I am responsible for developing ETL processes to extract data from various sources, transform it into a usable format, and load it into a data warehouse or data mart. For sales team members on medical product and supplies then using Power BI in Smart sheet to show results. BI Developer / Senior Data Analyst, Virginia Hospital & Healthcare Associate Aug 2020 – Jun 2022 Daily I would receive flat files to update my Alteryx workflows to update my output files that I updated, Tableau refresh schedule, to publish daily healthcare live data updates dashboards and regional reports I create reports and dashboards from Big data that provide insights and visualizations of data to help business users make informed decisions. For large data analysis we analyze data to identify trends, patterns, and insights that can be used to drive business decisions and strategies. Also providing all departments with daily ad-hoc data reporting updates on many healthcare projects. Data Analyst BI Developer, Virginia Department Health Mar 2017 – Jun 2019 Daily Tableau reporting on transportation and healthcare big data like flu illness and opioid epidemic numbers, using SQL to pull from database. Produced Tableau dashboards for Air Transports to monitor year to year. Overall optimize queries, data models, and ETL processes from big Data and large datasets to improve performance for auditing and reporting, using Transcend for data storage. I also ensure the quality and integrity of data by implementing data quality checks, data cleansing processes, and data governance practices. Savings, and conduct weekly ad-hoc data request for external team members using Tableau, and Power BI. Education/ Certifications - Bachelor of Science, Information Systems/ C.S [GPA: 3.1] Norfolk State University- Alteryx Designer Core Certificate