Tableau Developer Data Analyst
Resume:
Oyindamola Taiwo (Dami)
************@*****.*** www.linkedin.com/in/dami-taiwo-5b1494219
Business Intelligence Professional (7+ years’ experience) with strong background in the financial domain, good experience in credit risk, compliance (OFAC and AML), fraud, and on boarding. Also possess rich experience in data modeling, data manipulation, with outstanding leadership qualities, a burning desire to continually improve and help organizations meet their objectives through business intelligence solutions.
PROFESSIONAL SUMMARY
Broad experience creating effective, interactive and complex business reports/ dashboards using Tableau Business Intelligence Solutions.
Rich experience developing workarounds to customize Tableau Dashboards to meet business objectives
Well versed in designing and development of various dashboards using customized charts like Sankey and Sunburst charts, as well as standardized chart/graphs like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
Extensive experience working with Business Users to gather requirements, user stories, demoing dashboards and creating user manuals
Deep experience with the design and development of Tableau visualization solutions to help users to identify critical KPIs and facilitate strategic planning in the organization.
Strong experience in the optimization of dashboards performance by implementing performance tuning procedures and also by installing and upgrading Tableau servers
Over 6+ years of Data warehousing experience and creating reports using Tableau Business Intelligence Solutions (Desktop/ Server) 10.x/ 9.x/ 8.x/7.0/6.0, OLTP and OLAP Microsoft SQL Server, Oracle SQL Server as a Developer in various companies.
Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
Extensive experience in Microsoft T-SQL/PL-SQL statements (DDL and DML) including features like Temporary Tables, Ranking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
Hands on experience with Requirement Analysis, Functional Specifications, Technical Specifications, Data Cleansing, Data Modeling, Data Architecture, Gap Analysis, Data Transformations, Data Relationships and Reporting Analysis.
Proficiency in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), Test Case Document (TCD)
EDUCATION
Bachelors of English/Arts (2010)
University of Lagos
TECHNICAL SKILLS
Tableau Desktop 6/7/8,9,10,2018.x Tableau Server 6/7/8,9/10,,2018.x Tableau Online, Tableau Public, Tableau Reader, TabCmd, Microsoft SQL Server 2012/2008-R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler v7.0/v4.x, Microsoft Visual Studio 2010/2008/2005,Microsoft Access, Microsoft Office(MS Word/ Excel/PowerPoint), MS Project.
JPMC (Jersey City)
Duration: Sep 2022 Till date
Role: Tableau Developer/ Data Analyst
Responsibilities:
Develop interactive data visualizations and develop automated processes for updating content used in standardized dashboards. Create Tableau Dashboard from Scratch.
Create Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users Hold responsibility for integration points and the order in which these must be executed.
Audit datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
Data mapping.
Organized and edited data in tableau prep.
Improve Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.
Organize meeting and Monitor project of other developers to know how and when to use tools available for a given situation and can explain the
reasons for this choice.
Data Extract as need for Proper performance.
Review your work and that of others for quality, accuracy and relevance.
Perform Performance Tuning of Dashboard to achieve faster dashboard Load time.
Assist with Agile related routines (including but not limited to Daily Stand-ups, Sprint Planning, Retrospectives) and support the active management and disposition of decisions, issues, and risks. This facilitation is expected to leverage core BAC tools, including SharePoint, JIRA, etc.
Developed interactive Tableau visualizations after gathering Business Requirements, Interacting with the Users.
Gave Update on Reports on Daily Jira meetings.
Perform Data Modeling to Fit in with the BRD Requirement.
Prep data for visualization purposes in tableau prep.
Ability to work in an Agile Development team environment, collaborating with IT and vendor resources to define a solution that supports business processes.
Environment: Tableau Desktop, Tableau Server, SSIS, MS SQL Server, MS SQL Server Integration Services, SAP, MS Visual Studio 2010, Microsoft Office Visio, Erwin r8, Ultra Edit tool, SharePoint
TD Bank, (NJ)
Duration: Nov 2021 Aug 2022
Role: Sr. Tableau Developer/ Data Analyst
Responsibilities:
Develop Tableau dashboards to meet various business needs and regulatory requests as part of a project team.
Data modelling /documenting requirements / representing data and analytics team at project meetings / partner with other LOB's to identify location of data / work with data wrangling team on requirements
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
Efficiently using windows recorder for documentation purpose to support the team, best practice to be able navigate.
Develop advanced decision-making analysis, frameworks & Impact deliverables.
Periodic maintenance of Forecast dashboards.
Documentations of project and requirement gathering/ QA other developers dashboards and code review for final release
Environment: Tableau (Desktop), SQL, Hadoop (Hives and Impala), Microsoft Office Suite (Word, Excel, Power Point, Visio, Windows recorder, Outlook)
Samsung Electronics America (Ridgefield, NJ)
Duration: Jan 2021 – Nov 2021
Role: Tableau Developer/ Data Analyst
Responsibilities:
• Responsible to build all necessary contact center dashboards using big data set models from various existing data sets
• Work with Product Marketing, Consumer Intelligence and Market Intelligence to develop new Business Intelligence tools & automation that utilizes different types of data into new decision-making tools
• Leverage SQL, and visualization Tools like Tableau to share insights
• Assist in trouble shooting and defining the source of truth for KPIs and metrics and create common definitions for the business
• Develop advanced decision-making analysis, frameworks & Impact deliverables
• Facilitate key support groups development of their strategies based on guidance
• Manage Executive Communications for Top Management by developing best in class presentation and communication materials
• Lead and facilitate cross-divisional projects on key strategic issues based on senior management request
• Develop new frameworks/best practices to strategically utilize data to drive new demand & forecasting projects, etc.
Environment: Tableau (Desktop), Teradata, SQL, Hadoop (Hives and Impala), Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)m, Teradata Administrator,
EBay (San Jose, CA)
Duration: April 2017 – October 2020
Role: Tableau Developer/Admin
Responsibilities:
●Develop interactive data visualizations and develop automated processes for updating content used in standardized dashboards.
●Creates Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users Hold responsibility for integration points and the order in which these must be executed.
●Built compelling, interactive dashboards in Tableau that answer key business questions.
●Audits the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
●Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
●Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
●Reviewed, assessed, and promoted adoption and standardization of Tableau support solutions.
●Generated insights out of voluminous and complex datasets and built story lines.
●Produce complex table calculations, use of parameters, actions, filters, and other advanced options in Tableau.
●Design excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
●Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
●Create views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
●Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
●Optimized existing stored procedures and various T-SQL queries
●Wrote Dynamic Store Procedure to move data from Staging to Application
●Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
●Added more audits and alerts in SSIS Packages in case of package failure
Tools & Technologies:
Tableau Desktop, Tableau Server, WorkDay, TabCMD, MS SQL Server, MS SQL Server Integration Services, SAP, MS Visual Studio 2010, Microsoft Office Visio, Erwin r8, Ultra Edit tool, SharePoint, C#.
US Bank (Cincinnati, OH)
Duration: January 2016 to Jan 2017
Role: Sr. Tableau Developer/ Sr. Data Analyst
Responsibilities:
Utilizing Tableau Desktop to blend data from various databases and creating interactive dashboards publishing dashboards, report scheduling using Tableau Server, demoing dashboards, and creating user manual
Meet frequently with Business Users to gather requirements and/or user stories, document requirements
Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
Created Custom Hierarchies to meet the Business requirement in Tableau.
Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
Data marking
Created sheet selector to accommodate multiple chart types like Bullet charts and Stack bars etc. in a single dashboard by using parameters.
Displayed multiple measures like Dual Axis and Blended Axis for consolidated data contents.
Worked on understanding of relational database structures, theories, principles, and practices.
Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
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.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications.
Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
Environment: Tableau (Desktop), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)
Mercy Hospital (St. Louis, MO)
February 2014 – December 2015
MS SQL Developer /Tableau Consultant
Responsibilities:
Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
Optimized existing Stored Procedures and various T-SQL queries
Wrote Dynamic Store Procedure to move data from Staging to Application
Worked with project lead and business users to understand business processes, gather, and document project requirements and translate them into functional and non-functional specifications for BI reports and applications
Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction
Improved Performance by creating Clustered and Non-Clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
Data marking
Added more audits and alerts in SSIS Packages in case of package failure
Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data into the tables from Text files
Managed index, statistics and optimize queries by using execution plan for tuning the database
Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc. to clean data
Developed Master Child package using variables and Execute package task in SSIS
Scheduled jobs to call the packages and Stored Procedures as per business requirement
Deployed, tested and scheduled SSIS packages using SQL Agent
Deployed and scheduled Reports using SSRS to generate all reports including current status
Tools & Technologies: SQL Server, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, XML, MS Visual Source Safe, ServiceNow, MS Visio.
Contact this candidate