FRED OPPONG SARPONG
Tableau and SQL Developer with over 8 Years of Experience
Highly motivated, detail-oriented Tableau Data Visualization Developer with over 7 years involvement in Business Intelligence, Data Warehousing, Data Management and Data Analysis.
A Data Analyst and a Database Developer skilled in T-SQL programs, SQL Server Platforms in addition to Complex Query writing.
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, Derived Column, Slow Changing Dimension etc.
Experienced in providing demonstrations of the use of Tableau products for Upper Management and training team members.
Excellent communication skills, quick learner, a team player and outstanding independent worker who meets deadlines on projects.
Operating Systems: Microsoft Window XP Professional, Windows 10, Linux and UNIX.
Databases/BI Tools: Tableau – 9.0, 10.1, 10.2 & 10.5 (Desktop, Server, Public & Online), SQL Server (2008, 2012, 2016), T-SQL, SQL Query Analyzer, Oracle, ETL, SSIS and SSRS.
Agile (Kanban), Power Point and Microsoft Office tools (Power Point, Excel and Word)
Optum Rx (Insight Global), Chicago, Illinois 05/2018 – Recent
Data Analyst/ Tableau Developer
Build out OptumRx Operational Metrics, Clinical Program Metrics, and Book of Business metrics into Tableau through the creation of new dashboards from SQL, SAS and Excel data sources
Build out Self-Service reports in Tableau for internal users and upper management to access.
Document processes so that existing resources can make future enhancements or resolve production issues
Create ad hoc Tableau dashboards in a quick turnaround time for upper management reporting from large sets of PBM and clinical data sources.
Prepare and Validate data sets using SQL, excel and Tableau functionalities to ensure optimization and data integrity.
Train end users on the use and maneuverability of the Tableau functionalities.
Citadel (Open Systems), Chicago, Illinois 01/2018 – 04/2018
HR Data Analyst
Carried out a Data Source Replacement Project on dashboards which had static data sources in excel with dynamic data sources from a Tableau Server to ensure automatic 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 meaningful business reporting.
Expedited numerous data validation jobs using Excel and the Tableau engine to ensure quality data/reports for the end users
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 business needs to technical requirements and specifications in data modelling.
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, 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
WebMD, Manhattan, NY 06/2015 – 05/2017 Tableau & ETL Developer (contract)
Established and developed best practices guide for Tableau implementation in Tableau Desktop, Tableau Server and Tableau Online.
Consulted with the business clients and vendors of the organization to enable the creation of customized worksheets, dashboards and story points.
Created interactive dashboards and customized worksheets and visualizations using calculated fields, Filters (global, context and quick), parameters and table calculations.
Built and supported the transformation of various data inputs into the enterprise Data Warehouse (EDW).
Performed ETL (SSIS) functions, process documentation, & helped implement a mass import routine to bring groups of people into Active Directory.
Generated queries to retrieve data from SQL server and created T-SQL statements which loads data into required databases.
Citigroup Smith Barney, New York 03/2013 - 06/2015 Tableau Developer/Data Analyst (contract)
Delivered the various ways of well-organized data visualization presentation and analysis to management using the different tableau functionalities
Generated Dashboards with the different models of charts in showing the performance of the different critical KPIs simplifying strategic planning by management in the organization.
Demonstrated visualizations and analysis with different levels of aggregation of data to bring dynamism in Tableau analytics which explains the lows and highs in the company’s performance.
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 data blending, union all 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.
Seattle Children’s Hospital, Seattle, WA 02/2012 - 03/2013
Tableau Developer (contract)
Extracted data and analyzed system inventories to identify data anomalies and ensure accounts are properly coded in inventory management systems.
Used Tableau functionalities to facilitate batch updates to inventory management systems, pushing anomalies to the appropriate parties for correction, and related follow-up actions.
Assisted Analysts supporting inventory and Data Management related tasks using Tableau reports.
Developed and implemented innovative dashboard, stories and support tools for evaluating company processes, business problems, and/or ROI of products and services.
Maintained effective working relationships with Procurement Teams, Logistics Teams, Store Operations, Distribution Center and external partners.
Provided recommendations for business process improvement in Business Intelligence.
Philips Lighting Company, Somerset, NJ 09/2011 - 02/2012
SQL Server/SSIS/ETL Developer (contract)
Created ETL packages using SQL Server SSIS Designer to extract data from flat file and excel files.
Obtained and analyzed the informational business requirements from various clients.
Loaded data from flat files into SQL Server database tables, performed bulk insert, and table import.
Created Stored Procedures, SQL queries with group functions, multi-table joins, sub-queries, set operations, T-SQL stored procedures and user defined functions for data analysis. Implemented stored procedures and effectively queried databases.
Carried out data extraction and Data Migration activities from SQL Server database tables into flat data files and Excel sheets.
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