Data Analyst Tableau Developer

Isaac Olu Fadeyibi

***********@*****.*** 443-***-****

Project-focused and innovative Business Intelligence Developer with over 5 years of experience in BI reports, Dashboard Development, Data Analysis/Reporting, Data Warehouse, Modeling and Database Development. Consequently, I am a highly analytical and process-oriented data analyst with in-depth knowledge of database types and reporting; research methodologies; and big data capture, curation, manipulation, visualization.

PROFESSIONAL SUMMARY

Over 5+ year of IT experience in BI (Power BI, MSBI, SSRS, SSIS, SSAS and Tableau) and SQL Server Azure/2016/2014.

Working experience on various business domain like healthcare, insurance, banking, entertainment, and retail.

Experience in Industry standard methodologies like Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) using Waterfall, Agile models using Scrum methodology involving in Analysis, Design, Development, Testing, and Implementation of MSBI solutions.

Broad experience in various Agile Ceremonies (Product Backlog, Epis, Feature Walk, User Story Prioritization, Sprint Backlog, Sprint Points, Daily Scrums, S print Velocity, Burndown chart, Burnup chart, JAD Sessions, Sprint Review, Sprint Retrospective).

Having hands on experience in Microsoft Azure Cloud applications, includes Azure Data Factory, Data Lake, Azure Datawarehouse, Azure SQL Server, Power BI.

Expertise in TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Joins, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2016/2012/2008 R2.

Strong Technical knowledge in SQL Server BI Suites (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various third-party tools.

Specialist in Understanding the Technical Specification and creating and modifying the SSIS packages according to the Business requirements. Experienced working with Database Architecture for Design and Development of Data models and Data warehouse

Adept in building customized interactive reports and Dashboards using MicroStrategy, Tableau, SSRS and Power BI.

Experience in Developing and Extending SSAS Cubes [MDX & Tabular], Building the Dimensions, Deploying, Processing SSAS objects, Cubes with Snowflake Schemas and Star Schema using SQL Server Analysis Services (SSAS)

Proficient in developing OLAP cubes using SSAS measures, measure groups and dimension members in SQL Server Analysis Services using Dynamic Analysis expression (DAX), mathematical formulae, and user-defined functions.

Expertise in Normalization, Performance Tuning, Development Life Cycle source control and ticketing systems and Version Control tools while Design and Development of Data warehouse.

Competence in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS. Developed the SSAS 2012 Tabular model reports from Data warehouse using SSDT.

Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access

Good knowledge in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS.

Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Configured Check Points, Break points, Event Handlers, and Logging to the SSIS packages.

Worked on change requests, identifying the defects, and working on resolution, processing on SSIS Packages.

Generated Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Accountable for building reports in Power BI from the Scratch and Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Experience in generating on-demand and scheduled reports for business analysis using SSRS.

Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.

Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using ERWIN 3X/4X.

Technical Skills

BI Tools:

Power BI, Excel, SSRS, Tableau

Querying Tools/Programming Language:

SQL, T-SQL, PL-SQL, Python, R

Database:

SQL Server, MySQL, Oracle, Teradata

ETL/Other Tools:

SSIS, ADF, AWS Glue, Erwin Data Modeler

Project Management:

Project Management SDLC, AGILE, WATERFALL, KANBAN, JIRA, MONDAY

Professional Experience

Kacidy Inc, Washington DC

BI Developer Feb 2019 – Present

Collaborated with senior management, subject matter experts, and IT teams to define business requirements

Transformed business requirements into functional and nonfunctional requirements.

Created complex stored procedures to perform various tasks including, but not limited to index maintenance, data profiling, metadata searches, and loading of the data mart.

●Developed and implemented reporting, analytics, and data visualization solutions with Power BI.

●Utilized Power BI to create dynamic reports and dashboards with Drill down and Drill through.

●Write DAX to create calculated columns and measures in providing KPIs with insights.

●Troubleshoot slowly running reports and dashboard elements to improve report performance.

●Deployed and shared the reports to Power BI service, Mobile Apps and SharePoint Server and setup gateways, Row Level Security for end user interactions.

●Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (POWER BI).

●Design automatic data delivery process for reporting data using various tools like SQL, Power BI, and Tableau

●Develop Tableau workbooks from numerous data sources using Data Blending.

●Develop Tableau visualizations and dashboards using Tableau Desktop.

●Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

●Design and build ETL process to support analysis and reporting

●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

●Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server

●Designed and build scalable/reusable data models and ETL (Extract Transform Load) processes to support analysis and reporting on platforms like Teradata, SQL Server, Oracle, Hadoop, performing routine maintenance, and address special requests.

●Coordinated cross-functionally to accomplish assigned tasks.

●Created technical specification document, including the implementation methodologies using tools and technologies such as SQL, Power BI, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (POWER BI).

●Managed the business metrics reporting process and perform ad hoc reporting requests

●Engaged in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.

●Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

●Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

●Created and Scheduled Date-Driven and Standard Subscriptions with different rendering options like PDF, CSV, EXCEL etc. using data sources from SQL Server.

●Manages and oversees all aspects of technology and business projects to ensure it is completed on time and within budget

Oak Ridge National Bank (ORN) Oak Ridge, TN (Contractor)

Tableau Developer/Data Analyst April 2017 – Feb 2019

ORN Bank provides retail, commercial, and corporate banking services primarily in the United States.

The company operates in three segments: Community Banking; Wholesale Banking; and Wealth,

Brokerage, and Retirement. I was working for their debit card rewards program project which aimed at

marketing campaigns and customer profiling. This helped the Business to plan our effective reward

campaign strategies for customers having variety of financial profiles.

Fulfilled numerous data request for financial profiling.

Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.

Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.

Interacted with the existing database developers and DBA to understand the existing schema.

●Using Tableau server, l created permissions and privileges for designated / authorized users.

●Connect Tableau server to publish dashboard to a central location for portal integration.

●Implement Tableau mobile dashboards via Tableau mobile application.

●Involve in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

●Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.

●Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a back-end database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.

●Develop Tableau workbooks from numerous data sources using Data Blending.

●Develop Tableau visualizations and dashboards using Tableau Desktop.

●Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

●Designed, developed, and tested the ETL strategy to populate data from multiple source systems.

●Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.

●Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.

●Experienced in development, visualizations, dashboards, and scorecards using Power BI.

●Experienced in using Power BI Query editor and DAX for dashboards and reports customizations to meet end-user needs.

●SQL, ETL, SSIS, POWER BI, SSRS, Data Warehousing & Mining, Data Analysis and BI Reporting, Good communication, Interpersonal skills, Fast Learner & Team Player, Agile.

●Experienced in all areas of SQL Server development including Queries, Stored Procedures, User-defined Functions, Views, Joins, Triggers, Case expressions, and data integrity.

●Deep knowledge of different Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools.

●Highly experienced in SQL development concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and strong knowledge of SDLC principles.

●Skilled in performing data transfers between different heterogeneous systems (Excel, Flat Files, XML file) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.

●Knowledge in Azure cloud.

Certifications

Project Management Professional (PMP): Project Management Institute (ACTIVE)

Certified SAFe Agilist (SPC5): Scaled Agile Inc. (ACTIVE)

Certified Scrum Master (CSM): Scrum Alliance (ACTIVE)

Education

Master of Science in Project Management (Expected)

Morgan State University, Maryland USA

Master of Business Administration (MBA)

Obafemi Awolowo University – Nigeria

Bachelor of Science in Economics

University of Ibadan – Nigeria

Contact this candidate