Shadrick is a skilled IT professional with six years of experience in the Healthcare, Financial, and Banking domains. He has expertise in Business Intelligence, ETL, and analytics tools (especially Tableau and PowerBI) for analysis, extraction, manipulation, research, and reporting of data in different visualization formats with the ability to translate them into clear and concise specifications.
Tableau Public: https://public.tableau.com/app/profile/shadrick.myers.jr1400Hire Shadrick
Responsible for developing, analyzing, and reporting key risk indicator and key performance indicator metrics. Utilized BI tools to identify gaps through the study of discount data and to reveal patterns in discounts that could easily be corrected thereby increasing revenue. Gathered, analyzed, and documented business requirements, as well as developed supporting materials, such as use cases, flowcharts, models, specifications, and reports. Performed daily integration and ETL tasks by extracting, transforming, and loading data to and from different RDBMS. Performed Tableau Server admin duties, added users/groups from Active Directory, and scheduled instances in Tableau Server, including weekly data dumps. Wrote complex SQL queries for extracting data using SQL concepts. Developed Database Triggers, Views, CTEs, and Stored Procedures to facilitate data entry and query optimization.
Created users and added users to user site. Used statistical techniques, such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems. Implemented hierarchies in Tableau with portfolio as the highest level, followed by application and project details. Generated KPI’s driven data reports for customer satisfaction survey results. Provided data architecture and modeling to ensure that data within the Claims Management System (CMR) was in line with compliance guidelines. Converted user requirements into business requirements, analyzed them, and segregated them into high-level and low-level business requirements. Harmonized disparate data sources for use in Tableau by leveraging data blending and joins.
Utilized data visualization tools, including Power BI and Tableau, to provide an easy-to-understand interface to end-users. Designed and created reports using Excel file, SQL Server, and Oracle databases. Created Tableau dashboards. Utilized SAS and other software to provide ad hoc reporting; tables, listings, and graphs for clinical trial data; regulatory submissions; Risk-Based Monitoring; and publications. Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS. Extracted, manipulated, and built complex formulas in Tableau, in addition to using LOD calculations, for various business calculations. Worked in an Agile Environment and interacted with several groups to achieve a common deliverable goal based on the business requirements.