Tapiwa Sunde

Business Intelligence Senior Developer

SUMMARY :

Tapiwa is an Oracle BI Certified Developer, Tableau Developer/Analyst, who possesses experience with Business Intelligence technology and architecture, including data warehousing, dimensional modeling, OLAP functionality, reporting tools. Providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and designing/using dashboards. Developed & maintained expertise with: Tableau, Oracle, Excel Analysis and support of Business Intelligence & Analytics products, data warehouse, Data Visualizations and interactive Dashboards. Also has acted as a Tableau Development Lead over teams of up to 4 Tableau Developers.

EDUCATION

MBA from Northern Kentucky University, 2006

Bachelor's Degree in Finance from Northern Kentucky University, 2003

Oracle BI Certified

TECHNICAL SKILLS

Oracle 11g, Tableau, Oracle Business Intelligence, Web, Dashboards, Delivers, Agents, SQL Developer

EXPERIENCE

ApolloIT, Dallas, TX 06/2016 – Present

Sr. Tableau Developer

Analysis, modeling, design, and development of Tableau reports and dashboards for analytics and reporting applications.

Working with visualization tools such as Tableau and OBIEE.

Tableau Development Lead over a team of up to 4 Tableau Developers and 2 BAs.

Mentoring and training, coaching, directing team activities and priorities, as well as reporting team progress and performance to upper management. Tableau architecture, design, development and end user experience.

Various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Developing Dashboard reports for the Key Performance Indicators for the top management.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Working with large Database, Oracle, Netezza.

Utilizing Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.

Developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data with the usage of quick filters for on demand needed information.

Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.

Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the Senior Management.

Creating Projects, Sites, Site Users and Publishing Workbook.

Refresh Extracts from Tableau Server.

Data Extracts, Schedules for round Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

Designed and developed Interactive Dashboards with drill-down capabilities (Prompts, Action Links).

Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.

Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export for Management Dashboard reporting.

Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

Developed highly polished executive level dashboard prototype for the Operations group.

Designing and developing custom reports and Visualizations using BI Analytics and making them available in Dashboards. Implemented drill in place so that users could view data at the granular level and make effective decisions concerning the business.

Migration of the Repository and Webcat.

Business Intelligence, Data warehousing, Data architecture, Data modeling.

Clear Peak, Denver, CO 01/2016 – 05/2016

BI Consultant

Worked closely with Business Analysts, discussed and gathered the analytics requirements.

Design and development of Tableau visualization solutions.

Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.

Generated various dashboards in Tableau server using various sources such as Oracle / Excel .

Created users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Preparing Dashboards using calculations, parameters in Tableau.

Relational database structures, theories, principles, and practices.

Created drill down and drill up in worksheets in tableau.

Created report schedules on Tableau server.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Blended data from multiple databases into one report by selecting primary key's from each database for data validation.

Prepared proof of concept for best practices in Tableau deployment.

Developed Dashboards and preparing ad-hoc Reporting.

Documented reports and developments.

Tableau Desktop and Tableau Server.

Prepared Dashboards using calculations and parameters in Tableau.

Created Actions, Implemented Conditional formatting using Parameters.

Implemented Data Blending.

End to end experience in designing and deploying data visualizations using Tableau.

Created Projects, Sites, Site Users and Publishing Workbook.

Permission to User Groups, Permissions on Workbook and Projects.

Refreshed Extracts from Tableau Server.

Scheduled Alerts, Server Maintenance & Data Connections.

Tableau Server Administration and Infrastructure experience.

Designed and developed custom reports and Visualizations using BI Analytics and making them available in Dashboards. Implemented drill in place so that users could view data at the granular level and make effective decisions concerning the business.

Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.

Developed Variables and did Cache Management.

Used Analytics, WebLogic and Enterprise Manager.

Designed, debugged and optimized the Dashboards / Reports.

Set up and busted reports using agents.

Used Action Links to connect summary reports with detail reports.

Worked in a multi-user development environment (MUDE) to make changes and additions which met business requirements.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Designed and developed Interactive Dashboards with drill-down capabilities.

Customized and Developed OBIEE Analytics Reports and integrated them into Dashboards.

Created groups and assigned the users to the groups and attached the groups to the respective roles.

Created group level security for intelligence dashboards and assigned user to groups based on Business Requirements.

Used EM for general Admin that includes RPD upload to the server, create roles and policies.

Used WebLogic / Console for Administrative functions such as creating users and groups, and restarting servers.

UT Share, Fort Worth, TX 11/2012 – 12/2015

Obiee, Tableau Developer, nVision Developer

Extracted data from different sources connecting them and used the same to create dashboard.

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

Developed strategy and technical specifications for implementing reporting portal / semantic layer in conjunction with data layer.

Designed and developed of Tableau visualization solutions.

Created users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

processes and problems in order to effectively develop technical solutions to their requirement.

Created data blending in case of merging two different datasets.

Prepared Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

Found efficient ways to make graphs and tables visually exciting, and pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Developed, organized, managed and maintained graph, table, slide and document templates that will allow for efficient creation of reports.

Proof-read all documents and maintain accuracy of information and preparing SOP.

Developed a Dashboard and prepared Adhoc Reporting.

Tableau Server / Administration.

Identify new metrics and enhance the existing KPI's.

Dashboard Visualization through Tableau BI application.

Built, published, and customized interactive reports and dashboards, report scheduling using Tableau server.

Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau.

Used data blending, filters, actions, Hierarchies feature in tableau.

Defined best practices for Tableau report development.

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

Executed and tested required queries and reports before publishing.

Converted metric insight reports to tableau reports.

Working extensively with Tableau Business Intelligence tool to develop various dashboards.

Analyzing the data using Statistical features in Tableau to develop trend analysis.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

Webcat, RPD and System-Jazn-data file deployment to all the 3 environments.

Configured The RPD for the Financials and HR Modules.

Created / Modified Metadata repository (.rpd) by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers for the STAT Data source.

OBIEE ad-hoc reports for all the campuses.

Documented of reports and developments.

Worked on Tableau Desktop and Tableau Server.

Prepared Dashboards using calculations and parameters in Tableau.

Worked with Tableau developing Dashboards.

Created users and groups in Tableau and defined security.

Created Actions, Implemented Conditional formatting using Parameters.

Implemented Data Blending.

End to end experience in designing and deploying data visualizations using Tableau.

Used excel sheet, flat files, CSV files to generated Tableau Adhoc reports.

Created Adhoc reports for users in Tableau by connecting to various data sources.

Created Projects, Sites, Site Users and Publishing Workbook.

Permission to User Groups, Permissions on Workbook and Projects.

Refreshed Extracts from Tableau Server.

Scheduled Alerts, Server Maintenance & Data Connections.

Tableau Security (Authentication, Authorization).

Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).

Provided daily production support and problem resolution for Obiee and nVision applications.

Built prototypes for demonstration and illustrations for the business.

Provided end user training.

Supported existing reports and developments.

Documented reports and developments.

Merged the Production RPD with the Usage Tracking RPD.

Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.

Developed Variables and did Cache Management.

Used Analytics, WebLogic and Enterprise Manager.

Designed, debugged and optimized the Dashboards / Reports.

Configured the Oracle BI Scheduler server and creating agents to alert users.

Set up and busted reports using agents.

Used Action Links to connect summary reports with detail reports.

Worked in a multi-user development environment (MUDE) to make changes and additions which met business requirements.

Built star schemas in the repository using the primary and foreign keys.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Catalog and RPD and Security Store migration.

Designed and developed Interactive Dashboards with drill-down capabilities.

Customized and Developed OBIEE Analytics Reports and integrated them into Dashboards.

Created groups and assigned the users to the groups and attached the groups to the respective roles.

Created group level security for intelligence dashboards and assigned user to groups based on Business Requirements.

Used EM for general Admin that includes RPD upload to the server, create roles and policies.

Used WebLogic / Console for Administrative functions such as creating users and groups, and restarting servers.

Worked with Tableau Desktop and Tableau Server.

Prepared Dashboards using calculations and parameters in Tableau.

Worked with Tableau developing Dashboards.

Implemented Data Blending.

End to end experience in designing and deploying data visualizations using Tableau.

Used excel sheet, flat files, CSV files to generated Tableau Adhoc reports.

Created Adhoc reports for users in Tableau by connecting various data sources.

GPC Auto Parts, Atlanta, GA 12/2011 – 09/2012

OBIEE Developer / Admin

GPC sells auto parts and they needed Analytics of Financial Management, environment implementation, RPD configuration, dashboards, reports, and queries for Business Intelligence users.

Worked closely with Business Analysts, discussed and gathered the analytics requirements from different subsidiaries.

Created / Modified Metadata repository (.rpd) by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers.

Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.

Developed Variables and did Cache Management.

Used Analytics, WebLogic and Enterprise Manager.

Designed, debugged and optimized the Dashboards / Reports.

Configured the Oracle BI Scheduler server and creating agents to alert users.

Worked in a multi-user development environment (MUDE) to make changes and additions which met business requirements.

Built star schemas in the repository using the primary and foreign keys.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Catalog and RPD migration.

Designed and developed Interactive Dashboards with drill-down capabilities.

Customized and Developed OBIEE Analytics Reports and integrated them into Dashboards.

Created groups and assigned the users to the groups and attached the groups to the respective roles.

Created group level security for intelligence dashboards and assigned user to groups based on Business Requirements.

Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports.

ACS, Dallas, TX 02/2006 – 11/2011

OBIEE Developer

ZF develops and produces transmissions, steering systems, axles, and chassis components as well as complete systems for passenger cars, commercial vehicles, and off-road machinery. They needed Analytics of Financial Management and Procurement applications, as well as dashboards, reports, and queries for Business Intelligence users that leverage these tools.

Interacted with Management to identify key Dimensions and Measures for business performance, this allowed management to quickly focus on relevant aspects of the business and make effective and profitable decisions.

Worked closely with Business Analyst, discussed and gathered the analytics requirements from different user groups.

Created / Modified Metadata repository (.rpd) by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers.

Designed, debugged and optimized the OBIEE RPD / Dashboards / Reports.

Configured the Oracle BI Scheduler server and creating agents to alert users so that they can be proactive and make important business decisions quickly and at less cost.

Worked in a multi-user development environment (MUDE) to make changes and additions which met business requirements.

Built star schemas in the repository as well as using the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.

Used Filters and provided customized prompts appropriately to avoid excessive data showing up on reports.

Created pivot tables allowing managers to analyze the business from different perspectives and in an orderly summarized manner.

Created reports and Dashboards and assigning the dashboards to the users and groups.

Trained users so that they could efficiently navigate the dashboards.

Contact this candidate