Tableau Data

ABI LAWAL

Rahway, NJ 973-***-**** ********@*****.***

Experienced Business Intelligence Professional (8+ years’ experience) with strong background in the financial domain, extraordinary analytical skills, extensive experience in credit risk, compliance (OFAC, AML, KYC, CDD, and CIP), fraud, and onboarding. 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. Specialized Skills: Tableau Business Intelligence Solutions (Desktop/ Server: versions; 2018.1,10.x, 9.x, 8.x, 7,6) and Microsoft Power BI,

PROFESSIONAL SUMMARY

• 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 experience creating effective, interactive and complex business reports/ dashboards using Tableau Business Intelligence Solutions.

• Well versed in evaluating data models to design Tableau solutions and fine tuning dashboards to increase performance

• Deep experience with the design and development of Power BI 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

• Well versed in designing and development of various Microsoft BI 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.

• Rich experience developing workarounds to customize Power BI Dashboards and reports to meet business objectives

• Involved in Tableau Server configuration, creating Users, Groups, Projects and assign Privileges etc.

• 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.

• Effective skills in applying various management tools like SWOT, Porter's generic strategies, Mc Kinsey 7s model and competitive analysis.

• Proficiency in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), Test Case Document (TCD)

ABI LAWAL

Rahway, NJ 973-***-**** ********@*****.***

US ARMY - Veteran May 2015 to 2020

Sr. Information Analyst/ Sr. Data Analyst

Responsibilities:

• Developed interactive Tableau visualizations after gathering Business Requirements, Interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.

• Extended Tableau limits to create unconventional Tableau charts such as Sankey Diagram, Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.

• Utilized performance tuning procedures to increase performance and help make dashboard more visually appealing and user friendly

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Participated in the daily stand up Scrum Agile meetings for reporting the day-to-day developments of the work done using JIRA to track the project and also to create stories, bugs and releases.

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

• Effectively used data blending feature in Tableau

• Manipulating, cleansing & processing data using Excel, Access and SQL.

• Analyzing raw data, drawing conclusions & developing recommendations.

• Worked on various kinds of data filtering as required in the dashboards/reports like quick filters, context filters, filtering measures, continuous and discrete filters.

• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.

• Ensured high levels of data consistency between diverse source systems including flat files, XML and SQL Database.

• Developed and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.

• Created users, groups, projects, Data connections, settings as a Tableau administrator.

• Created dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.

• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL Developer to provide definition, structure and to maintain data efficiently. Environment: Tableau 10.2,10.4, Tableau Server, Oracle, Microsoft SQL Server, JIRA, Microsoft Office, Microsoft Visio, Windows 7, SQL Developer. American Express (Salt Lake City, UT) March 2012 to August 2015 Sr. Tableau Developer/ Sr. Business Intelligence

Responsibilities:

• Used Tableau Desktop for blending databases and create interactive views and dashboards ABI LAWAL

Rahway, NJ 973-***-**** ********@*****.***

• Created multiple scorecards and dashboards

• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production

• Actively involved in new KPI generation for Tableau Scorecards.

• Data collection and leveraging on data manipulation teams for required data.

• Identified new metrics and enhance the existing KPI's.

• Worked extensively using Excel to validate the data and use as the source data files.

• Converted existing Excel reports in to Tableau reports

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.

• Effectively used data blending, filters, actions, Hierarchies feature in Tableau.

• Defined best practices for Tableau report development.

• Utilized JIRA in tracking project and deliverables and also in creating bugs. Stories and reports.

• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.

• Executed and tested required queries and reports before publishing.

• Converted metric insight reports to Tableau reports.

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

• Worked with Teradata database and pull data to work on BI requirement.

• Provided Ongoing support to BI application running in production & troubleshoot. Environment: Tableau (Desktop), JIRA, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook) EBay/ PayPal (Draper, UT) April 2011 – January 2012 Tableau Developer/Power BI/Admin

Responsibilities:

● Develop interactive data visualizations and develop automated processes for updating content used in standardized BI and Tableau 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/Power BI 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/BI 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 ABI LAWAL

Rahway, NJ 973-***-**** ********@*****.***

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:

Power BI, Tableau Desktop 8, Tableau Server 8, WorkDay, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, SAP, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, C#. EDUCATION

UMUC Fordham, NY

MSc Data Security June 2018- Present

Brandenburg University of Technology Cottbus, Germany MSc Power Engineering February 2011

Lagos State University Lagos, Nigeria

BSc Mechanical Engineering October 2008

TECHNICAL SKILLS

Tableau Desktop 6/7/8,9,10,2018.x Tableau Server 6/7/8,9/10 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, HTML, XML, Java, C++, C#,

Contact this candidate