SAMUEL ANDOH-MENSAH

ad3g9p@r.postjobfree.com 443-***-****

Summary

More than 14 years of Tableau Developer, Data Analyst, ETL functions and data mapping experience. Visionary with the exceptional ability to identify new ideas and develop them from conception to completion. Decisive team leader who recognizes the importance of group cohesiveness and focused goal achievement.

Skills

Databases: MS SQL Server, Oracle, DB2, MySQL

BI Tools: SSIS, SSAS, SSRS, Tableau 2022.3, Python 3, PostgreSQL

Tableau Prep Builder and Conductor

Health Catalyst: SAM Designer, Source Mart Designer

Microsoft Windows

Dynamics CRM

Alteryx

Tableau Bridge

Data Bricks

Experience

Dept Of Economic Security

Snr Tableau Developer

04/2020 - Current

Tested the ETL process for both before data validation and after data validation process

Tested the messages published by ETL tool and data loaded into various databases

Involved with data cleansing/scrubbing and validation

Plan, build and implement data solutions based on DataBricks

Design and create ETL processes supplying Data Warehouse

Implement effective metrics and monitoring process in Databricks

Monitoring Tableau Dashboard and create new dashboard

Developing new reports using existing data sources and models or creating entirely new data models from scratch (SSRS) Designing and implementing data collection and management processes such as surveys, focus groups, customer satisfaction surveys

(SSRS) Developing Workbooks and Hyper Extracts on Tableau Desktop

Preparing data for use by Tableau. Created data in the web using Tableau Bridge

Wells Fargo (Contractor) Arizona, AZ

Tableau Developer/SQL/Data Analyst

03/2018 - 04/2020

Design and develop ETL workflows and datasets in Alteryx to be used by the predictive tool

ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

Extracting data from various sources using Alteryx

Importing flat files into SQL database using SSIS

Design and develop ETL workflows and datasets in Alteryx to be used by the predictive tool

ETL specific for creating datasets (to be used by Tableau Data Extract for BI) Expertise in identifying data-related inconsistencies, gaps and effectively communicating with Data Engineering and Business Teams

Created Actions in Worksheets, dashboards for interactivity and to compare data against different views

Using Tableau Prep Builder to perform EDA Developed various reports in web intelligence based on the client requirements

Created worksheets by creating join/data blending, custom SQL and data source filters

Combined multiple worksheets into one view using Dashboards

Validating Data to make sure number of records are same from the source

Data mapping

Bon Secours Community Hospitals Baltimore, MD

Tableau Developer

11/2016 - 03/2018

Create outcomes and readmission of heart failure dashboards that depict encounters, readmission rate, mortality rate, average loss and show system wide readmission rate encounters, number of encounters by days, group number of encounters by case process and geo-density dashboard Create data dictionary that explains all the field names in the individual dashboards

Write effective, scalable code using python

Develop back-end components to improve responsiveness and overall performance using python

Test and debug programs Implement security and data protection solutions using

Building visualization using python Coordinate with internal teams to understand user requirements and provide technical solutions

Create reports for NPIC on quarterly basis using SQL and work closely with clients at various levels within the environment

Write effective, scalable code

Develop back-end components to improve responsiveness and overall performance

Integrate user-facing elements into applications

Test and debug programs Improve functionality of existing systems Implement security and data protection solutions

Assess and prioritize feature requests

Coordinate with internal teams to understand user requirements and provide technical solutions

Perform ETL to extract data from various sources to different

Destinations and migrate data from both SQL and Oracle to Health Catalyst application to create entities, events, rules, populations, metrics, summary metrics, and reporting clients

Using Health Catalyst ATLAS to create population summary.

Time Warner Cable Charlotte, NC

SQL/ETL Data Analyst (Contractor)

08/2013 - 10/2016

Creating digital dashboards for management to visualize operational information using Tableau

Gather data from different data sources like MySQL, Excel Develop reports, dashboards using Tableau 8.3 for quick reviews to be presented to Business and IT users Developed POCs by building reports and dashboards using Tableau 10.5 to demonstrate quick wins Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control

Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc

Developed Ad-hoc reports using Tableau Desktop, Excel and BI Tools: SSIS, SSAS, SSRS, Tableau

Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.

Covenant Health Knoxville, TN

Data Analyst (Contractor)

09/2010 - 06/2013

Wrote complex SQL queries for validating the data against various kinds of reports generated by Business Objects XIR2 and using BI Tools: SSIS, SSAS, SSRS, Tableau

Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources

Prepared reports outlining adverse trends and appropriate recommendations

Performed data reconciliation between integrated systems

Writing Complex queries and store procedures Performing Data Mugging using Python Tableau Server Administrator

Using Access to Update recordset Creating and Modifying a QueryDef Created a Report Using MS Access Migrating Tables from Access to SQL using SSIS(ETL) Trouble shooting error handling Debugging and Testing in Access

Setting Database password from VBA Ability To Write Queries in Access Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis using Tableau

Education and Training

University of Maryland Baltimore County (UMBC)

MBA, Data Science

University of Cape Coast, Ghana

BS (Accounting)

Contact this candidate