Data Analyst Tableau Developer

FRED OPPONG SARPONG

773-***-**** **** Amsterdam Circle, Montgomery, Illinois, 60538 aduj9c@r.postjobfree.com

Tableau and SQL Developer

SUMMARY

Highly motivated, self-starter, detail-oriented Business Intelligence Developer with over 7 years involvement in Business Intelligence, Visualization, Data Warehousing, Data Modelling and Data Analysis.

A Data Analyst and a Database Developer skilled in T-SQL programs, SQL Server Platforms in addition to Complex Query writing from both the Financial and Health Care data sets.

Skillful in tabular, matrix, parameterized SSRS reporting, ETL, SSIS Package Deployment and Creation with different transformation tools including Lookup, Merge join, Multicast, Conditional Split, Data Conversion Transformation, Slow Changing Dimension etc.

Experience in Data modeling for Dimensional and Star schema designs in Data Warehousing

Experienced in providing demonstrations of the use of Tableau functionalities for doing Trend and Forecast Analysis for Executive and Operational Management to enhance strategic decisions.

Excellent communication and leadership skills, rapidly learns and adapts to new technologies, a team player and a productive independent worker who meets deadlines on projects.

TECHNICAL SKILLS

Operating Systems: Microsoft Window XP Professional, Windows 10, Linux and UNIX.

Databases/BI Tools: Tableau – 10.1, 10.2, 10.5, 2018.3, 2019.4, 2020.3 (Desktop, Server, Prep, Public & Online), SQL Server/Management Studio (2008, 2012, 2016), T-SQL, SQL Query Analyzer, Oracle, ETL, Visual Studio (SSIS and SSRS), Agile (Kanban and JIRA), Power Point and Microsoft Office tools (Power Point, Excel and Word)

Alteryx, Python and R Integration into Tableau for predictive analysis.

WORK EXPERIENCE

CFA Institute (Insight Global) 03/2021– Present

Data Analyst – Tableau

Implements technical solutions to CFA business needs by translating their business requirements and finding innovative resolutions for stakeholders

Transforms data and creates reports by visualizing business metrics and creating of dashboards with the use of the most recent functionalities in Tableau desktop versions.

Creates interactive dashboards and customized worksheets and visualizations using Calculated Fields, Filters (global, context and quick), Parameters and Table Calculations.

As a Tableau Server Administrator, I organize and manage the Tableau server / site's contents, permissions, authorizations, users and groups.

I lead the Migration of UPNs (with permissions and content) from Tableau server user credential (old) to a new user credential generated by the IT team in the Active directory and

saved the organization over thousands of dollars external contractors were charging for this migration task.

Evaluates and improves existing systems and collaborates with teams within the business to integrate new systems to streamline workflow and company processes.

Reynolds Consumer Products (Judge Group) 07/2019 – 02/2021

Data Visualization Analyst

Extract and transform raw data from various data sources (Spreadsheets, SAP, SQL, Postgresql etc) into useful information to enable more effective strategic, tactical, and operational insights.

Transform business requirements from internal Partners into dashboards that are functional and easily accessible.

Collaborate with the Data Scientist on end-to-end process to ensure data can be easily refreshed as needed.

Develop best in class solutions for visualizations across the organization and recommend ways to improve data reliability, efficiency and quality.

Build dashboard and reporting proofs of concept as needed; develop reporting and analysis templates and tools.

Manage the team’s content on Tableau Server – Users, groups, workbooks, data sources, permissions, coordination etc.

Lead the effort of migrating proof of concept Tableau dashboards to production.

Optum Rx (Insight Global), Chicago, Illinois 05/2018 – 06/2019

Data Analyst/ Tableau Developer

Built out OptumRx Operational Metrics, Clinical Program Metrics, and Book of Business (Medicaid, Medicare, Commercial etc.) metrics into Tableau through the creation of new dashboards from SQL, SAS and Excel data sources.

Developed Business Intelligence Scorecard for PBM, Clinical and Insurance Claims data sets for tracking remediation metrics.

Built and maintained SQL scripts and complex queries for extracting data for analysis ensuring optimized data sources and automated data flow.

Prepared and Validated data sets using SQL, excel and Tableau functionalities (LODs, Table Calculations, Calculated Fields, Joins and Data Blending) to ensure optimization and data integrity.

Built out Self-Service reports and visualizations in Tableau for internal users and upper management reducing reporting time by 60%.

Created insightful and easily understandable Insurance/Financial Claims Reports and Outcomes dashboards with Medicare and Medicaid data sets in Tableau using Sets, Bins, Hierarchies, Groups, Actions, Parameters and complex Formatting.

Created ad hoc Tableau dashboards in a quick turnaround time for upper management reporting from large sets of PBM and clinical data sources for which I received 3 “Bravo awards”

Citadel (Open Systems), Chicago, Illinois 01/2018 – 04/2018

HR Data Analyst

Carried out a Data Source Replacement Project on Tableau dashboards which had static data sources in excel with dynamic data sources from a SQL Server and partly maintained the semantic layer to ensure data integrity and automated updates.

Single handedly created a Data Dictionary from 32 Data Sources to enhance quick and easy access to the different data sources, some with the same records but different Headers and vice versa.

Executed a Tableau dashboard maintenance project overhauling and formatting some visualizations/views to ensure optimized and meaningful business reporting

Carried out a data visualization project on Employee Turnover Rate in Voluntary/Involuntary Terminations per Business Units, Functions and Departments for upper management

Used Excel Functions like Vlookup, Pivot Tables, Index and Matching to generate tables and create reports for end users.

Created Dashboards, stories and reports using calculated fields, parameters, sets, hierarchies and groups in Tableau

Vein Clinics of America (Medix), Downers Grove, Illinois 06/2017 - 12/2017

BI/ BW Developer

Translated technical requirements and specifications in data modelling into Business needs.

Formed and deployed SSIS packages with the different transformation tools such as Data Conversion Transformation, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Multicast, Slowly Changing Dimension, Aggregate and Derived Column.

Assisted in creating SQL database objects like tables, triggers, views, indexes, stored procedures, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Worked with teams and clients to integrate resource systems to build and deploy BI solutions.

Created visualizations, dashboards and reports for requested projects with Tableau and SSRS.

Citigroup Smith Barney, New York 03/2015 - 05/2017 Tableau Developer/Data Analyst.

Generated Dashboards with the different models of charts in showing the performance of the different critical KPIs simplifying strategic planning by management.

Occasionally carried out Tableau administration duties in adding users and group, data connections, managing licenses and task scheduling in Tableau.

Performed the Optimization of data connections and designing, background task scheduling and incremental refresh for daily, weekly and monthly reports in the tableau server.

Used Calculated Fields, Table Calculations, Data Blending and the different types of joins to bring data from different data sources to one platform to enhance and enrich data analysis and visualization.

Created dashboards where a variety of views were connected by Actions and provided an interactive reporting setting of the Revenue Impact Analysis, Pricing Opportunity Analysis, Markets Overview and Inventory Control.

EDUCATION

MBA - Logistics and Supply Chain Management

Kwame Nkrumah University of Science & Technology (KNUST), Ghana, West Africa

Bachelor of Science – Agriculture Economics

Kwame Nkrumah University of Science & Technology (KNUST), Ghana, West Africa

Contact this candidate