Tableau Development/ Data Analyst
Resume:
OLALEKAN BANKOLE
**********@*****.***
PROFESSIONAL PROFILE
A highly dedicated professional with a wide range of knowledge and expertise in domains such as Finance, healthcare, and banking over a period of seven years. Highly skilled in collaborating with business leaders to identify requirements, develop approaches, and introduce tools, processes, frameworks, and analytics to assess business against targets and promote business decisions. TECHNICAL SKILLS
Querying Language: MS SQL, SQL, T SQL, PL/SQL
RDBMS/DBMS: SQL Server Management Studio 2008/2012, SQL Server Express. Databases: MS SQL Server 2008/2012, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2.
ETL Tools: MS SQL Server, SSIS (Visual Studio), R Studio. Business Intelligence/Data Analysis Tools: Tableau 10.2, 10.4, 2019.2, 2019.3, 2019.4, MS Excel, R Programming, and Tableau server, Power BI. Cloud platforms: MS Azure.
Other Tools: MS Outlook, Agile Methodology and JIRA. PROFESSIONAL EXPERIENCE
H N R BLOCK BALTIMORE MD
TABLEAU DEVELOPER/DATA ANALYST JAN. 2019 TILL DATE
• Working across cross-functional teams to gather requirements, propose a technical solution, and execute against defined timelines using different Calculated Field and Parameters codes I developed.
• Develop executive and operational dashboards to monitor the velocity of the business, as well as create ad-hoc reports.
• Working with ETL team on best approach for data integration and ETL tasks by extracting, transforming, and loading data to and from different RDBMS.
• Develop an overall approach for designing a solution and evaluating risk analysis with teams by using BI tools as both investigative and predictive tools to develop insights for business decisions.
• Fluent in SQL and able to read and write complex queries, views, and stored procedures.
• Successfully applied R and Tableau for advanced statistical and predictive analysis.
• Develop KPIs and KRIs metrics that is crucial for analyzing business performance and making informed decisions against risks and control requirements.
• Create and manage complex dashboards, using insights from data exploration to build comprehensive findings with advanced and intuitive visualizations (using Tableau) and insights.
• Develop tableau reports for year over year, month over month, YTD, QTD and MTD analysis using Charts such as Line/Bar/Donut/Bubble/Funnel charts etc.
• Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.
• Working knowledge of Cloud platforms such as MS Azure. MARY T MARYLAND BALTIMORE, MD USA
DATA REPORTING ANALYST AUGUST 2016 - DEC. 2018
• Ensured correct translation of business questions and needs into precise queries and reports. Developed reports with accurate, easy to read, useful information. Effectively interpret technical and business objectives and challenges and articulate solutions.
• Worked with the development team to plan, develop, and implement BI system for KPIs for evaluating the health of the organization using my Programmed Quick Table Calculations to compute Difference (Comparing years performance in terms of profitability), YoY (Year over Year) Computation and Percentage of Difference to ascertain the DELTA VALUES, Running Total (Cumulative) to show various STACK VALUES within business years.
• Worked with team to develop ETL packages to move data from disparate source systems such as flat files, excel, oracle database into centralized SQL server.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star- Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Developed solution-based dashboards by creating various types of charts including Crosstabs, Heat/Geo/Tree maps, Pie/Bar Charts, Scatter plots and Histogram using Tableau Desktop.
• Utilized advanced table features including calculated fields, parameters, table calculations, row- level security, R integration, joins, data blending and filters.
• Built and publish customized interactive Tableau reports and dashboards as well as manage extracts and refresh schedules using Tableau Desktop and Tableau Server.
• Worked with the Business Analyst team to support UAT testing and obtain sign off.
• Worked successfully in an Agile Project across multiple features and component teams. MAINSTREET BANK LTD MARINA-LAGOS NIGERIA
BUSINESS INTELLIGENCE ANALYST JULY 2013 – August 2016
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub- queries and derived tables on SQL Server platform.
• Filtered and cleaned unwanted data based on well-defined criteria.
• Created dimensional analysis of data providing, developed numerous permanent tables, Volatile tables, Global Temporary tables, dashboards in Tableau Desktop publishing them on Tableau Server. Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports, providing interactive views, trends, and drill downs along with user level security.
• Utilized analytical skills to design develop and maintain reports, dashboards and visualizations that provide insight to internal partners and external clients.
• Executed data queries across multiple data sources in support of business intelligence reporting needs.
• Utilized Tableau to design, develop, enhance, and support Tableau visualizations including highly interactive dashboards, scorecards and reports which drilled down to detailed and analysis pathways to other supporting reports
• Involved in creating database objects such as tables, views, Stored procedures, triggers, and functions using SQL to effectively provide data description and structure.
• Created Tableau dashboards using both Extracts and Live connections from relation database tables/view and stored procedures, web services, and non-relational databases.
• Translated data and analysis into compelling presentations/written communications. Ensured report validation and audits and processes to ensure data integrity. https://public.tableau.com/profile/olalekan.bankole EDUCATION
MBA (Currently Enrolled)
University of Baltimore-USA
BSc (Hons) Economics
University of Ilorin-Nigeria
Contact this candidate