DORCAS OLU
Summary
Senior Data Analyst with extensive experience in utilization Tableau Solutions, data visualization, data analysis, report development. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data analyst/Tableau Developer
PepsiCo-IL
04.2022 - 04.2023
- Worked in collaboration with various SMEs and business-side stakeholders to prioritize requirements and develop interactive dashboards that address key business issues
- Created storytelling dashboards in Tableau to help answer questions surrounding KPIs
- Combined data from multiple sources using joins and blending in Tableau
- Created views in Tableau that was shared with different departments for further analysis
- Scheduled reports using Tableau server, publishing data to Tableau server, embedding data in Tableau workbook to automate Tableau reports
- Reviewed SQL functions, logics, stored procedures, and views that were used to generate data for Tableau
- Created interactive reports and dashboards using Power BI, with experience in using Power View (PV) and Power Pivot (PP) for data modeling and visualization
- Implemented complex DAX (Data Analysis Expressions) formulas to create calculated columns, measures, and tables for advanced data analysis and modeling in Power BI
- Created interactive reports and dashboards using Power BI, with experience in using Power View (PV) and Power Pivot (PP) for data modeling and visualization
- Used other tools like Excel, SQL, and SAP HANA for data validations, data profiling, and further analysis
Tableau Developer/Data analyst
BNSF Railway
02.2021 - 03.2022
- Develops and maintains business intelligence applications including operational reports, dashboards,using SQL,Tableau & power-bi
- Experienced in using Power Query to extract, transform, and load data from various data sources into Power BI for analysis and visualization purposes
- Skilled in creating custom calculations and measures using DAX and M language in Power BI to derive insights and provide meaningful data visualizations
- Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics.
Tableau Developer/Data Analyst
CA Technologies
07.2018 - 04.2021
- Collaborated with Subject Matter Experts to analyze specifications and participated in the Design Team and user requirement gathering meetings
- Designed effective self-serving Tableau reports utilizing Tooltip Visualizations, Dashboard Actions, and Cross Database joins, and Role Level security
- Created Tables, Views, and Stored Procedures to as data sources for dashboards to optimize Tableau performance
- Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards
- Develop new and modify existing SQL code based on the requirements to generate data reports
- Scheduled reports using Tableau server, publishing data to Tableau server, embedding data in Tableau workbook to automate Tableau reports
- Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix
- Created customized Tableau charts such as Pareto, waterfall, Donut, Sankey, and Sunburst to address business questions
- Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights
- Utilized ETL/ELT processes, data analysis, and Power BI to ensure data accuracy and completeness, creating various chart types, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots, and Slicers
- Created External filter, internal filter, and Context filter to improve performance
- Efficiently combined data from multiple sources using Data Blending and Cross Database
- Demo dashboards, trained users, and created user manual/instructions and design document
- Used Alteryx for Data Cleansing and as a reporting tool.
Tableau Developer/Data Analyst
Compass Bank
12.2015 - 05.2018
- Designed interactive Tableau Dashboards and automated the dashboards using Alteryx and Tableau Server
- Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights
- Utilized ETL/ELT processes, data analysis, and Power BI to ensure data accuracy and completeness, creating various chart types, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots, and Slicers
- Accomplished wide range of development activities involving requirement gathering, documentation, code, and reports developments, to testing and release/deployment
- Work closely with business side stakeholders to design effective visualizations to address business needs
- Generated well-tuned SQL queries and used these queries as Custom SQL in Tableau
- Created Tables, Views, and Stored Procedures to as data sources for dashboards to optimize Tableau performance
- Scheduled reports using Tableau server, publishing data to Tableau server, embedding data in Tableau workbook to automate Tableau reports
- Published data to Tableau server and schedule independent refresh schedules of published data sources
Education
Certified Medical Billing And Coding Specialist - Medical Billing And Coding
Academy of Allied Health Sciences
Newark, NJ08.2023
Bachelor of Science -
University of Lagos
2010
Skills
- Technical Specifications
- Spatial Visualization
- MS SQL Server 2000
- Business Intelligence Data Modeling
- HIPPA Compliance
- Medical Terminology
- ICD-10-CM Coding
- HCPCS Coding
Certification
- [Medical Billing and Coding]
Timeline
Data analyst/Tableau Developer
PepsiCo-IL
04.2022 - 04.2023
Tableau Developer/Data analyst
BNSF Railway
02.2021 - 03.2022
Tableau Developer/Data Analyst
CA Technologies
07.2018 - 04.2021
Tableau Developer/Data Analyst
Compass Bank
12.2015 - 05.2018
Certified Medical Billing And Coding Specialist - Medical Billing And Coding
Academy of Allied Health Sciences
Bachelor of Science -
University of Lagos