Amstrong PEPEZIE PETEGERENKWAN

**** ******* ****, ********, ***** 77407

Email: adcl99@r.postjobfree.com

Phone: 832-***-****

Skype: amstrong.pepezie

LinkedIn: www.linkedin.com/in/amstrong-pepezie-097725140

SUMMARY OF COMPETENCE

About 17 years of work experience as Tableau Solutions Architect, Solutions Architect, Senior Tableau Developer/Admin, Senior BI Developer, Tableau Consultant, Regional Business Intelligence Advisor and Tableau Developer/Administrator for West and Central Africa Region, Data Analyst, Business Intelligence Researcher and Program Manager with fortune Corporates, Public and Private Companies, international companies, private businesses and consulting firms in the areas of Business Intelligence, Visual Analytics, Data Warehousing, Data Management, Project Cycle Management, Consulting, Audit and Planning (Strategic and Operational).

Over 10 years of extensive IT industry experience in creating and implementing effective strategies/solutions for developing Business Intelligence/Data Warehousing (BI/DW), Client/Server applications, Tableau deployment, aspects of Database Management Systems, development and complete Project Life Cycle in Data Warehousing.

Expert in dashboards and visualizations using Tableau 10x and higher

Sound Knowledge and experience in ETL data management

Expertise in creating and fine - tuning Complex and Adhoc Tableau Reports.

Experienced in Data modelling for logical and physical databases including support designing OLTP and OLAP databases.

Proficiency in SQL and PL/SQL programming to develop Stored Procedures/Functions in Oracle and SQL Server.

Good analytical strengths, successfully working through problems and implementing solutions in time.

CAREER OBJECTIVES

I am seeking to leverage my accumulated years of experience in a fortune company where I can effectively prototype my skills and impact the bigger picture and where there are opportunities for inclusive growth and development.

Based in Houston – Texas and authorized to independently work for any employer in the USA.

KEY SKILLS AND COMPETENCIES

Extensive experience in working with databases, data visualizations tools with specialization on TABLEAU technological suite.

Strong experience in working with various platforms and data sources including Filed-based sources, Server-based relational databases and OLAP sources (Cubes) and flat file sources.

Strong technical background and experience in Data Visualization using TABLEAU 10.x and higher (DESKTOP / SERVER)

Solid experience in Tableau reports performance tuning and dashboards optimization.

Extensive experience in creating extracts (TDE), tuning existing extracts, publishing and working with TDEs published to Tableau server.

Hands-on experiences in designing and implementing data pipelines for Tableau reporting.

Solid experience in integrating Tableau technological suite with other UI/UX applications and workflows,

Solid experience in working with extract files (TDE) and creating compelling visualizations.

Experience in development of Storyboards and Dashboards using Tableau Desktop.

Created Customized and Interactive Dashboards using multiple Data Sources.

Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.

Experience in reports validation and modeling data with the purpose of understanding or making conclusions from the data for evidence-based decision-making.

Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.

Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot tables, scatter plots, pie charts and packed bubbles and use multiple measures for comparison such as Individual Axis, Blended Axis, and Dual Axis.

Strong ability to design and deploy rich graphic visualizations with Drill Down and Drop-Down menu options and Parameterization using Tableau.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and reports.

Administration of Tableau Server like Creating & Managing Users, Groups, Projects Schedules, Tasks, Server Settings.

Developed Tableau data visualization using Combo charts, Heat maps, Box and Whisker plots, Geographic Map, Cross tabs, Histograms, Highlight tables, area charts, etc.

Developed Doughnut charts for analyzing sales planning data.

Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions).

Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.

Expertise in working with data building Groups, Hierarchies and sets.

Mastery of different Formatting techniques, using Annotations and Mark labels.

Developed effective and interactive Dashboards using Parameters and Actions.

Worked on data blending and increased dashboard performance by extracting data and working with published data sources.

Created a workflow to automate stash commits to Tableau Server using Jenkins jobs.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Editing workbook slide out filters using the Java Script UltraEditor.

Updating Repository for javascript code used to filter Tableau reports.

Creating Java API for integration with Tableau Server.

Release management.

Mastery of Project Management Cycle.

Knowledge in Full Life Cycle Development of Data Warehousing.

Good understanding of OLAP (Cube) Concepts.

Good knowledge of Data modeling techniques (Conceptual, Logical and Physical Models).

Strong SQL skills (Nested select, stored procedures, advanced queries, views, transactions, etc.)

Excellent team player.

Excellent communication, problem-solving, organization and planning skills

Good knowledge of Data warehousing and ETL/Informatica processes.

Basic knowledge of Python 2.0 and R for window scripting.

Solid experience in the design and implementation of Tableau CI/CD processes.

Cloud Platforms & tools: Google Cloud Platform – BigQuery, Spark SQL, Databricks, S3, Amazon Athena, AWS Redshift, Amazon Glue Services, SOS Program Database, Monitoring and Reporting Database (proprietary databases).

RDBMS: Oracle 10g/9i/8x, MS SQL Server, MYSQL Server, DB2, MS Access

ETL Tools: Databricks, Informatica, Alteryx, Tableau Prep and SSIS

Scripting Languages and Tools: IPython 3.6, Java, Jupyter Notebook, Ipython Command Line Utility, Spyder-py3, SQL, SQL Developer, Notepad ++

Workflow Orchestration and automated testing tools: Apache Airflow, Kinesis CI, PuTTY, tabcmd,

Other BI Tools /utilities: Toad, SQL Plus, SQL Developer, Jenkins, Bamboo, Postman, MS Power BI, UltraEdit, Agile Methodology, JIRA, Confluence, Stash, Source Tree, Machine Learning (CA Flow Dock), Github Enterprise, Tabjolt, R for Windows, Java Script, SQL Server Management Studio, Microsoft Visual Studio, Word, Excel, PowerPoint, Access, Publisher, etc.

Professional Experience

Tableau Solutions Architect / Sr. Tableau Developer

VIACOMCBS Inc. New York City, NY April 2018 to Present

The role aims at designing, validating and implementing Tableau Technological suite deployment and supporting applications within the Media Technology Services Department at VIACOMCBS International Corporation Corporate office. The role is both strategic and operational. It involves designing and implementing Tableau reporting infrastructure and integration with other applications for enhanced UI/UX experience, designing and implementing CI/CD processes for Tableau workbooks and data source deployment.

Major tasks and responsibilities

Design, validate and implement state-of-the-art technical solutions on AWS and Databricks (Big Data) platform that address customer's requirements for scalability, reliability, security, and performance.

Design and implement the report development environment and infrastructure.

Provide recommendations with respect to cloud migrations and prepare technical implementation roadmaps for AWS and Databricks platform adoption.

Create functional design specifications, reference architectures, and assist with other project deliverables as needed.

Build and implement a workflow that integrates Stash and Tableau Server by triggering Jenkins builds, Databricks notebooks and using curl command and Tableau REST API.

Collaborate with other project teams on technical solutions and provide recommendations.

Elaborate user stories with detailed Acceptance Criteria.

Coordinate and provide guidance between Product Owners and the Tableau Technical team offshore and onsite.

Facilitate offshore functional clarifications.

Document procedures and workflows based on functional specifications.

Partner with application mangers and developers to ensure projects meet end user requirements and are completed successfully.

Compile and present updates for projects and key initiatives, such as milestones and percent complete client management with respect to Tableau reporting.

Provide end user documentation, training, implementation coordination, and post implementation support on Tableau reporting as needed.

Design, develop, document and unit testing of BI Reports using Tableau.

Provide status of development efforts, along with any required technical docs, in meetings to Manager and internal team.

Provide any required KT to internal development team.

Ensure that best practices & methodologies are followed as prescribed by the Manager.

Knowledge management activities including reviewing the knowledge repository.

Ensure code migration from development to QA and design and implement release activities.

Strategic orientation of Offshore and Onsite teams.

Senior Tableau Coach/Trainer

Cheniere Energy Houston Texas – Oct 2019 (2 weeks)

The Tableau Trainer for Cheniere Energy (Oil and Gas Company) responsible for planning and conducting Tableau training engagements to drive adoption and sustainability of data and Analytics solutions. Sometimes required to join consulting delivery projects from time to time, whenever training scheduling allows, to be able to make immediate impact for clients on active projects.

Responsibilities

Planning, preparing and conducting technical and best practice Tableau training to prospective and existing clients based on Tableau Desktop, and Tableau Server.

Working collaboratively and independently to design, develop, and market training solutions and services

Working with our Partner (Tableau Software) to stay up to date on all Tableau Trainer Certification requirements

Developing Standard Operating procedures to aid clients in using and administering Tableau solutions

Playing the change management role on Tableau projects to drive adoption of solutions and services provided by consulting team

Work with partners to regularly stay abreast of changes to Analytics technologies and delivery framework, and in turn help ramp up internal consulting team on such changes

Learn and constantly refresh on techniques to delivery Tableau training in ways that drive enthusiasm and passion in classroom or virtual training sessions

Senior Tableau Developer/Admin

UnitedHealth Group Houston Texas – May 2017 to April 2018

The Optum Triple Aim Analytic Services project aims to build Minimum Viable Products (MVP) to meet business and client requirements based on Medicaid, Medicare and Health and Human Services data using the Tableau Business Intelligence technology suite. The results of this project will provide the platform and operational and analytical services needed to meet and exceed the State Medicaid analytics market needs.

Major tasks and responsibilities

Ensuring that existing reports, wireframes, User Interface/User Experiences and user stories/features are consistent, so that there is accurate documentation reflecting UHG set of reports so that UHG has a high-quality report meeting business goals.

Ensuring that existing/legacy reports are consistent across all environments (Development, Test, Stage and Production Tableau Servers).

Updating Repository for JavaScript code used to filter Tableau reports.

Analyze reports to determine the underlying performance issues, pinpoint slow worksheets, slow queries, and long render-times on dashboards and develop an improvement plan.

Setting Tableau dashboards performance goals (Definitions for simple, moderate, complex reports, as well as for the optimal environment/machine requirements determined as part of the developmental process).

Scaling of reports within the Business Intelligence Data Layer and performance tuned to generate and display results regardless of filter selection, within the timeframe specified within the MVP Requirements.

Creating Tableau Data Extracts (TDE) for workbooks and publishing to Tableau server as reusable data sets for multiple reports.

Scheduling Tableau Data Extract refreshes in Tableau server and troubleshooting as necessary when extract refresh fails.

Adding the “No data to display” message in all reports when a filter selection is applied and yields no summarized data results set.

Definition of Dashboard Rendering Results for simple, moderate, complex system responses, as well as for the optimal environment/machine requirements determined as part of the developmental process.

Ensure that all modules across UHG reports are consistent in User Interface design/format and content/field ordering so that the reports module is presented in the same manner across UHG solution.

Monitor Unfiltered Pre-Performance in performance recorder in Tableau Desktop.

Monitor Unfiltered Post Performance in performance recorder in Tableau desktop.

Summarize findings of Tableau Report performance tuning.

Summarize Reusability of data sources and Business Intelligence layer.

Document lessons learned for future performance tuning.

Document technical specification for tableau dashboards for institutional memory.

Report benchmarking to access initial and actual dashboard load times for references.

Update calculated fields, dimensions and other fields including logos, legends (from image to non-image) in all reports to reflect UHG production specifications.

Lead the upgrading of all reports/dashboards to Tableau 10.2.

Updates to existing wireframes and reports to add in instructional text where there are hidden tables or visualizations.

Data source migration from DEV-TEST-STAGE-PROD

Site migration to new dedicated Tableau environment/server and pointing filters and links to the reports.

Ensuring the system provides the initial return of summarized data within a maximum of 15 seconds response time for 90% of the dashboard results.

Identify the problem spots of dashboards by running and interpreting performance recording.

Work with database team on optimizing at the database level.

Ensure and support release management.

Senior Tableau Developer (Consultant)

Xerox Commercial Solutions Houston, Texas – April 2017 to May 2017

The aim of the project was to migrate about 65 Tableau reports and dashboards previously consuming data from SQL Server to start pointing to the cloud instance of AWS RedShift.

Major tasks and responsibilities

Data source migration from SQL Server to AWS RedShift.

Repointing reports to AWS RedShift and ensure consistency across all reports.

Creating extracts (TDE) and publishing to Tableau server as reusable data sets for consumption by multiple workbooks.

Schedule extract refreshes in Tableau server based on report usability.

Fix any defects that occur in Tableau dashboards because of the migration.

Matching Calculated fields, dimensions, filters to their correct values from SQL Server to RedShift.

Report benchmarking to access initial and actual dashboard load times in AWS RedShift.

Identify report with significant drop in performance due to the migration and setting performance goals.

Pre and post migration performance recording to identify changes in the workbook performance.

Senior BI Analyst – Tableau Developer

Sanjoh and Associates Law Firm Houston, Texas – December 2015 to April 2017

The project is to develop dashboard and create stunning data analytics and visual reports using the Tableau Business Intelligence technology suite.

Major tasks and responsibilities

Organized participatory data modelling sessions to design the overall data management framework for the business.

Hired data entry specialists to enter client data into the database.

Build the data framework from scratch using various tools and technologies.

Designed, developed and implemented Tableau Business Intelligence reports.

Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.

Publish dashboard reports to Tableau Server.

Schedule the published dashboards from Tableau Server on weekly basis.

Sending dashboards to users by emails with the help of admin team with subscriptions.

Provide training/demos to users on Tableau Desktop for development.

Resolve various performance issues and analyze the best process distribution for different projects.

Use Tableau Server to publish reports online.

Produce various reports including bar charts, crosstabs, highlight tables, pie charts, line graphs, combined charts, shared axis charts, heat maps, tec., using spring functions, calculated fields and logical functions.

Create Saved Data sources, publish on Tableau Server for usage with Operational/Monitoring Dashboards.

Administer user groups and scheduled instances for reports in tableau.

Build complex formulas in Tableau for various business calculations.

Publish Workbooks by creating user filters so that only appropriate teams can view it.

Combine Data sources by Joining Multiple Tables and using Data Blending.

Tableau Developer Consultant (Part-Time Remote)

West Orange Nephrology Winter Garden, Florida, March 2016 to May 2017

The West Orange Nephrology is one of the largest Nephrology Centers in the State of Florida, which is in steady expansion. The Centre is a privately owned Medical Centre having a heavy client portfolio with many dialysis centers distributed all over the State. The project is to develop dashboards proactively and create informing and engaging data analytics and visual reports using the Tableau Business Intelligence technology suite.

Major tasks and responsibilities

Provide training to Business users in using Tableau.

Blended data from multiple data sets by using linking feature in Tableau Desktop.

Extract, Transform and Load tables from Electronic Medical Services (EMS) Database to TABLEAU Desktop for analysis.

Develop analytical reports from several data sources by blending data.

Involved in creating dashboards by using Level of Detail expressions (LOD's).

Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc.

Produce Data visualizations and interactive dashboards, which helped business get a good handle on the team's productivity.

Responsible for data Analysis and providing recommendations to higher management.

Migration to new versions of Tableau.

Develop and forward dashboards to teams via email using Tableau Reader.

Administered user, user groups, and scheduled instances for reports in Tableau.

Built complex formulas in Tableau for various business calculations.

Reporting and Analyzing projects.

Develop Views and interactive Dashboards using Parameters, Filters, Actions, Bar/Pie/Funnel/Bullet/Dual, Axis charts, Area/Geo/Heat maps, scatter plots etc., in Tableau Desktop (version 7, 8.1 and 8.2).

Strong understanding of Data integration, Ability to identify trends and patterns.

Regional Business Intelligence – Tableau Developer / Admin

SOS Children’s Villages International Dakar, Senegal – December 2011 to March 2016

International Office for West and Central Africa

SOS Children’s Villages International is an international development organization working in 135 countries and territories around the world. The International Office for West and Central Africa is based in Senegal (West Africa) and covers 18 countries. The BI Analyst is charged with developing, testing and rolling out business solutions to improve the performs of programs and projects in the sub-region.

Major responsibilities:

Led the implementation and roll-out of Programme Database and other Databases in the region and all tasks related (workshops and trainings, coordinate further development and releases, participate in global conferences, steer the regional support network).

Led the implementation and roll-out of TABLEAU 8.x / 9.x in the region and all tasks related (workshops and trainings, coordinate further development and releases, participate in global conferences, steer the regional support network).

Supported the strategic orientation and coordination of the regional programme department.

Optimized of existing tools for Business Intelligence and the generation of new ones according to the need of the programme policy implementation and programmes development.

Supported the International Business Intelligence project in Austria to develop a system for data management, reporting, evaluation and learning.

Designed Guidelines; validate new BI tools and systems according to the need of the organization with focus on the programmes.

Supervised external consultants, co-workers working in the field and projects related to Business Intelligence.

Supported the dissemination of research results and systematization, at the internal and external level of the organization.

Follow up on the implementation of other systems or BI tools.

Guide the process for identifying and designing key indicators, key performance questions and parameters for monitoring project performance and evaluating projects.

Monitor and support programme related data input into Databases in close cooperation with Member Support Advisors (Data Entry Specialists).

Ensure capacity building on systems and programme related data input in close cooperation with Member Support Advisor (Data Entry Specialists).

Perform quality spot-check of programme related data and validate data entered by countries into the Database in close cooperation with Member Support Advisor (Data Entry Specialists).

Provide first-level user support with regards to PROGRAMME DATABASE and TABLEAU.

Ensure transparency on programme planning by tracking programme plans/proposals in database (e.g., Lucy) and review alignment of programs with strategy.

Monitor performance KPIs for programme, e.g., as defined in the Change Matrix and perform audit.

Support the further development, rollout and operation of global systems/database applications in line with SOS standards for software development (ALM).

Manage and coordinate development, rollout and operation of regional and local systems/database applications in close cooperation with regional IT and in line with SOS standards for software development (ALM).

Coordinate the preparation of management information / reports / analysis in the Regional Office. Support countries in Strategic and Annual planning processes.

Provide technical support in the setting up of functional structures (organograms, working methods and procedures) to enable the Regional Office and countries achieve their objectives.

Data Analyst Consultant

Fisheries Engineering Co. Ltd, Japan Douala, Cameroon, February 2014

Major achievements:

Development of questionnaire / interview guide for data collection on household demographic survey in the project area.

Administration of questionnaire to beneficiaries and stakeholders on the project site.

Designing of the data analysis framework, data analysis and dissemination of results.

Organization of a public hearing with stakeholders and the local population on delocalization.

Physical assessment of project site and demarcation.

Data Analyst - Consultant

French Development Agency Yaounde, Cameroon, February to June 2011

Major achievements:

Analysis of the Terms of Reference for the Evaluation mission and conceptualization of technical offer;

Conception of the evaluation grid (data collection, compilation & analysis methods and tools);

Training and supervision of external data collection teams on the field;

Evaluation of 127 community projects of diverse nature (Agriculture, Health, Livestock, Human Rights, etc.) in the West, South and South West Regions of Cameroon;

Evaluation of the France-C2D- ACEFA global BI systems and tools including databases;

Organization of core stakeholders briefing meetings at regional level prior to evaluation mission;

Facilitation of regional evaluation restitution workshops;

Preparation of regional technical evaluation reports and the final evaluation mission report;

Development of an action plan for the implementation of recommendations.

Data Specialist – Consultant (Part-Time)

Japanese International Cooperation Agency Yaounde, Cameroon, May 2010 – November 2010

Key achievements:

Baseline survey of the project area and revision of the program global framework/design;

Designed and implemented a Participatory Monitoring and Evaluation system for the project;

Systematic capacity building of project stakeholders (Field Workers) and pilot families (project beneficiaries) on M&E and related topics;

Management of project activities in the project zone.

Research and production of project documentations (M&E Handbook, brochures, monthly progress reports, quarterly reports, etc.) in French and English;

Strengthening relations between JICA Cameroon, local government institutions and councils through the systematic and continual exchange of information;

Facilitation and reporting of quarterly coordination/planning workshops;

Designing of capacity building modules and training of project stakeholders on diverse topics;

Research and production of a Family Management Agreement (FMA) Handbook.

Program Manager

Agbetsi International Cameroon Yaounde, Cameroon, January 2006 to January 2010

Major Responsibilities:

Strategic orientation of the Program Department.

Produce consolidated reporting to Project Steering Boards, including milestone summary, key issues, risks, benefits, summary of costs incurred;

Establish standards, tools and procedures for use on projects, including Issue, Risk, Change and Information Management;

Set up and manage support functions covering Monitoring and Evaluation, planning, tracking, reporting, quality management and internal communication;

Building and implementation of monitoring and evaluation systems for projects and programmes and ensure capacity building of stakeholders on Monitoring and Evaluation;

Design various guidelines for project/programme implementation;

Conduct research on development issues, publish and disseminate outcomes;

Manage the organizational documentations;

Review programme activities for compliance with procedures and standards;

Manage the support and provision of project tools and equipment;

Preparation of organizational monthly and annual activity reports;

Assist with the design and production of user documentation;

Organization and facilitation of workshops, conferences, seminars, etc. and other public events.

BI Researcher

African Development Bank Group (Grassfield Project) Bamenda, Cameroon, December 2005

Key achievements:

Building, testing, implementing and updating Business Intelligence systems and tools.

Reports analysis and feedback to steering committee.

Feasibility studies for the physical realization of projects of diverse nature;

Impact assessment of project’s physical realizations and backstopping;

Evaluation of the impact of involving beneficiaries in performance feedback systems development;

Organization, facilitation of quarterly coordination/orientation workshops and Reporting.

Academic Qualification

2010: Professional Masters in Project Analysis and Evaluation, CODEV International Institute of Management, Yaounde - Cameroon.

2005: Masters in Animal Biology, University of Yaounde I, Yaounde - Cameroon.

2000: Bachelor of Science in Microbiology (Honours), University of Buea, Buea- Cameroon.

1997: General Certificate of Education in Mathematics, Physics, Chemistry and Biology.

1996: General Certificate of Education in Mathematics, Physics, Chemistry and Biology.

Research works and publications

2017: “Category of Service Performance Tuning – Summary of Findings and Improvements”. In collaboration with United Health Group, Rocky Hill, Connecticut.

2015: “Social Impact Assessment of SOS Programs in Ivory Coast, Senegal and Togo”. In collaboration with Nordic Consulting Group, Denmark.

2014: “Program quality assessment toolkit for improve program performance”. In collaboration with SOS Children’s Villages International.

2014: “Program Database user feedback survey in West and Central Africa Region”. In collaboration with SOS Children’s Villages International.

2011: “ Family Management Agreement: A new vision of the Cameroonian Family”. In collaboration with the Japanese International Cooperation Agency.

2010: “Impact of involving beneficiaries in the Participatory Monitoring and Evaluation Mechanism of the Grassfield Project in the North-West Region of Cameroon”. In collaboration with the African Development Bank Group.

2008: “Children’s Government Guide”. In collaboration with the United Nations Children’s Emergency Fund (UNICEF) and Plan International.

2007: “Ten tips for the successful animation of a children’s group”. In collaboration with Plan International.

2007: “Fermons la Porte á la Grippe Aviaire” (“Let’s Close the Door to Bird Flu”) and “Boîtes á Images sur les Mesures de Prévention de la Grippe Aviaire” (“Image Box on Bird Flu prevention

Contact this candidate