Frank Ogbe
Tableau Data Analyst
Waterloo,ON
Summary
- Built comprehensive workbooks, views, and dashboards using Tableau Desktop v9.x or higher.
- Performed development activities by gathering requirements, designing solutions through report development and custom using Tableau APIs.
- Have intellectual curiosity to obtain complete understanding of the existing solution.
- Maintained adequate communication with project team, explaining progress and/or potential roadblocks on the development effort.
- Responsible for successful delivery of the solution. Contributed to continual improvement by suggesting improvements to dashboards and any other processes in place.
- Worked with business teams, technical analysts, DBAs and platform administrators to design Tableau workbooks and custom Tableau reporting solutions.
- Performed training and consultation to business users and tech teams on usage of workbooks and custom solutions. Provided complete documentation for workbooks and custom solutions including high-level designs, low-level designs, and user training documentation.
- Performed administrative and support activities across a multi-environment Tableau infrastructure (DEV, QA, and PROD) including workbook and view level security administration, release management, and report troubleshooting.
- Served as a primary point of contact for workbook and custom Tableau reporting solution related issues.
Overview
14
14
years of professional experience
Work History
Data Analyst
STADXL CONSULTING
Mississauga, ON
12.2020 - Current
- Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management , Develop Feasibility Study Report for Preliminary Study of the Project, and Budget of the Project.
- Participated with individual and JAD/RAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units for business requirement gathering followed by (Agile Scrum) approach.
- Assisted the team members with documentations like Business Requirement Documents and Use Case Specification Documents by using DOORs.
- Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.
- Applied SQL for cross checking Data Validation for Referential Data in SQL Server.
- Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
- Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.
- Generate financial reports from Operating Statement Cube and Balance sheet Cube.
- Developed Complex Report Studio Reports using Tabular Objects.
- Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements' values.
- Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values.
- Created Drill- through reports and Customized Reports with Prompts (List.
- Cross tab).
- Developed Standard templates in Report Studio for developing reports.
- Environment: MS Visio, MS Office Suite, HTML, XML, Test Director, VB, Client Server, UML, Waterfall, Windows XP, Test Director, MS Project, MS Access, MS SQL ,Oracle, TOAD, Cognos 8.4, Frame Work Manager, Cognos Connection, Report Studio.
Tableau Developer/Data Analyst
Toyota Motor Manufacturing Co
Cambridge, ON
12.2018 - 12.2020
- Worked across all levels of client organizations in order to design and build attractive, easy to use, analytics, dashboards, and reports.
- Created and maintained standardized, custom and ad hoc Microsoft Structured Query Language (MSSQL) and Business Intelligence (BI) reports to support internal and external customer requirements, including the online reporting portal.
- Supported and mentored BI super-users and Data Analysts to align analytics and ensure data governance across the organization.
- Coordinated with designated BI team to assist with the design and implementation, specifically as it relates to dynamic analysis and reporting for our users.
- Used financial and business acumen to analyze and understand significance of reported numbers, and helps answer top-level business questions by harvesting and converting data into management insight.
- Conducted and coordinated tests to ensure that intelligence is consistent with defined needs.
- Synthesized current business intelligence or trend data to support recommendations for action.
- Maintained or updates business intelligence tools, databases, dashboards, systems, or methods.
- Managed timely flow of business intelligence information to users.
Tableau Developer/Business Analyst
Alterna Savings & Credit Union
Ottawa, ON
01.2018 - 12.2018
- Worked on Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.
- Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO.
- Adjust views/dashboards after initial POC presentation to CEO and CFO.
- Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
- Create views and dashboards on end client's sales data.
- Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by CEO and CFO.
- Cleanse and normalize data in MS Excel by combining from various data sources.
- Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
- Created numerous dashboards in Tableau Desktop based on the data collected from Insurance App's by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
- Developed Geo/Area Maps to show details on which states are most connected using the App vs the least states.
- Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Insurance App.
- Created Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
- Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
- Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling with Quick Filters for on demand needed information with just a click of a button.
- Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
- Build a dashboard report in which indicates the Key Performance Indicators (KPI).
- Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
- Environment: Tableau Desktop 7/8.0, Tableau Server 7/8.0, MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory.
Business/Data Analyst
Stanbic IBTC Bank
Lagos, Lagos
06.2015 - 10.2017
- Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
- Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
- Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
- Mapped current business and operational processes and recommended areas for improvement.
- Researched and compiled tailored monthly analytics and reports for senior management with Excel and SQL
Business Analyst
AlphaBeta Consulting LLP
Lagos, Lagos
04.2009 - 06.2015
- Gathered and analyzed both legal and credit datasets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
- Translated clients' needs into useable mapping and coding instructions and created functional requirements document and mock ups for reporting.
- Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Designed and implemented basic SQL queries for testing and report/data validation.
- Developed and maintained reporting using in MS Excel queries and SQL.
- Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.
- Created Test Cases and Activity Diagrams, systems Flow Charts.
- Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.
- Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
- Environment: UML, RUP, MS Visio, Windows XP, Use-case, MS Excel, MS Power Point.
Education
Bachelor of Science - Computer Science
Lagos State University
Lagos, Nigeria2007
IIBA Business Analysis
TCA Training Institute
Mississauga, ON03.2015
Skills
- Languages: SQL, VBNET, HTML
- Tableau Server, Tableau Desktop, Tableau Online (Cloud)
- Databases: MS SQL Server 2012/2008R2/2008, Oracle 9i/10g
- Activity diagrams, Microsoft Visio
- Process Mapping
- Data analysis
- Business Analysis
Certification
- Certified SQL Expert (Oracle) - 2009
- Oracle Certified Professional (Database) - 2009
- Microsoft Certified Technology Analyst - 2010
- Professional Scrum Master ll (Scrum.org, USA) - 2022
Timeline
Data Analyst
STADXL CONSULTING
12.2020 - Current
Tableau Developer/Data Analyst
Toyota Motor Manufacturing Co
12.2018 - 12.2020
Tableau Developer/Business Analyst
Alterna Savings & Credit Union
01.2018 - 12.2018
Business/Data Analyst
Stanbic IBTC Bank
06.2015 - 10.2017
Business Analyst
AlphaBeta Consulting LLP
04.2009 - 06.2015
Bachelor of Science - Computer Science
Lagos State University
IIBA Business Analysis
TCA Training Institute
Similar Profiles
KHUSHI MEHTAKHUSHI MEHTA
Business Analyst at STADXL ConsultingBusiness Analyst at STADXL Consulting
Victoria EkineVictoria Ekine
Business Analyst at STADXL ConsultingBusiness Analyst at STADXL Consulting
ABEAL AFUNYANABEAL AFUNYAN
Scrum Master (Part-Time) at STADXL Consulting LimitedScrum Master (Part-Time) at STADXL Consulting Limited