ADETAYO OYANIYI
Woodstock,GA
Summary
Senior Business Intelligence and Data Analytics Professional with 7+ years of experience designing, developing, and implementing enterprise reporting and analytics solutions using Power BI, SQL, Tableau, Alteryx, Python, and Excel. Extensive experience working with large and complex datasets including extracting, transforming, cleansing, modeling, and visualizing data to support operational, financial, and executive decision-making. Advanced expertise in Power BI front-end and back-end development including semantic modeling, star schema architecture, advanced DAX calculations, Power Query (M language) transformations, Row-Level Security (RLS), incremental refresh, Power BI Service administration, workspace governance, dataset refresh automation, and dashboard optimization. Strong experience designing ETL pipelines, developing relational data models, writing complex SQL queries, creating KPIs, automating reporting workflows, and delivering scalable analytics solutions that improve reporting efficiency and business insights. Highly skilled in translating business requirements into technical solutions and developing dashboards supporting performance tracking, operational insights, and strategic planning.
Experienced with executive leadership and strategic planning. Utilizes innovative approaches to drive business growth and operational excellence. Track record of effective team collaboration and achieving results.
Overview
7
7
years of professional experience
Work History
VP, Lead Data Scientist
JPMorgan Chase
ATLANTA, GA
06.2025 - Current
- Design and develop enterprise Power BI dashboards supporting executive reporting and operational analytics.
- Develop semantic data models using star schema architecture including fact tables and dimension tables.
- Create advanced DAX calculations including: CALCULATE, FILTER, ALL, SUMX, AVERAGEX, COUNTROWS, DISTINCTCOUNT, Time intelligence functions (YTD, MTD, QoQ)
- Develop calculated columns and measures supporting KPI frameworks.
- Create Power Query M transformations to cleanse, shape and normalize datasets from multiple sources.
- Develop SQL queries integrating enterprise datasets into reporting models.
- Write SQL queries using joins, subqueries, CTEs, aggregations and window functions.
- Implement Row-Level Security (RLS) to control data visibility across business units.
- Configure dataset refresh schedules in Power BI Service.
- Create and manage Power BI workspaces.
- Develop Power Automate workflows for automated refresh notifications and report distribution.
- Create dataflows for reusable datasets.
- Optimize dashboard performance through query optimization and efficient modeling.
- Develop dashboards supporting operational metrics and financial performance.
- Collaborate with stakeholders to gather requirements and deliver analytics solutions.
- Mentor analysts on Power BI development best practices.
- Conduct data quality assessments to identify and rectify reporting discrepancies.
- Collaborate with IT teams to troubleshoot and resolve data integration issues.
- Conduct data profiling to assess data quality and identify anomalies for remediation.
- Write complex SQL queries to support business intelligence initiatives and reporting needs.
- Conduct data profiling to assess data quality and identify anomalies in datasets.
- Collaborate with IT teams to troubleshoot and resolve data integrity issues promptly.
- Developed interactive Power BI reports to visualize key business performance indicators.
- Implemented Row-Level Security (RLS) to manage sensitive data access within reports.
- Created and maintained data models using star schema architecture for reporting efficiency.
- Streamlined data transformation workflows by automating Power Query M transformations for consistency.
- Identified data discrepancies, improving report accuracy through diligent validation processes.
- Enhanced dashboard load times through effective query optimization and resource management.
- Crafted SQL queries employing joins and aggregations for comprehensive dataset integration.
- Built reusable datasets by developing Power BI dataflows for improved analytics sharing.
- Proved successful working within tight deadlines and a fast-paced environment.
- Perform root cause analysis on data discrepancies reported by end users or stakeholders.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Evaluated new technologies related to SQL development for potential implementation opportunities, facilitating innovation within the team''s workflow.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
- Mentored junior developers on best practices in SQL development, fostering a collaborative learning environment within the team.
VP, Data Management Lead
JPMorgan Chase
Atlanta, GA
01.2022 - Current
- Created comprehensive enterprise dashboards with Power BI to provide insights into operational KPIs and financial performance metrics.
- Executed complex SQL queries and crafted stored procedures to streamline dataset extraction and transformation workflows.
- Created and optimized advanced DAX measures, ensuring alignment with business logic requirements.
- Created and defined relationships between tables within relational data models to support efficient data retrieval and management.
- Executed comprehensive Power Query M transformations focused on optimizing data cleansing and achieving standardized normalization.
- Configured row-level security settings to ensure only authorized users can access sensitive information.
- Managed dataset refresh schedules in Power BI Service, facilitating timely access to updated data for stakeholders.
- Created interactive dashboards to visualize key metrics and trends in referral program reporting.
- Analyzed performance metrics and developed KPI scorecards to support strategic leadership initiatives.
- Implemented systematic data validation checks to uphold accuracy in reporting outcomes.
- Created automated reporting frameworks that significantly decreased reliance on manual data entry and improved accuracy.
- Designed Power BI dataflows focused on maximizing dataset reusability across multiple projects.
- Developed comprehensive dashboards that provide insights into trends and track key performance indicators.
- Coordinated discussions with business stakeholders to identify and articulate specific reporting requirements.
- Developed interactive Tableau dashboards to visualize key performance indicators for stakeholders.
- Created calculated fields and parameters in Tableau to enhance data insights effectively.
- Designed data connections in Tableau to integrate multiple data sources seamlessly.
- Conducted user training sessions on Tableau functionalities, improving team analytics capabilities.
- Streamlined reporting processes through automated dashboard refreshes, reducing manual intervention significantly.
- Utilized SQL queries to extract relevant datasets for comprehensive Tableau visualizations.
Senior Data & Reporting Analyst
Frosch Travel (JPMorgan Chase Subsidiary)
01.2022 - 12.2022
- Develop Power BI dashboards analyzing booking performance and operational metrics.
- Write SQL queries to extract and integrate booking datasets.
- Develop Power Query transformations to structure datasets.
- Create calculated measures using DAX for KPI calculations.
- Design dashboards supporting client reporting.
- Ensure data accuracy across reporting outputs.
- Develop ad-hoc reports supporting business insights.
- Create dashboards supporting trend analysis and forecasting.
SQL Developer / Power BI Developer
MedStar Health
01.2019 - 01.2022
- Write SQL queries using joins, subqueries, CTEs and aggregate functions.
- Create stored procedures, views and functions.
- Develop ETL processes transforming raw data into reporting structures.
- Design relational data models.
- Develop Power BI dashboards including drill-down and drill-through reports.
- Create calculated columns and measures using DAX.
- Implement Row-Level Security (RLS).
- Create ad-hoc reports supporting business operations.
- Tune SQL queries using indexing and performance optimization techniques.
- Create temporary tables and permanent tables.
- Perform data cleansing and normalization.
- Work with large datasets to identify trends.
- Collaborate with business teams to develop reporting solutions.
- Conduct data integration testing to validate the accuracy of ETL processes and outputs.
- Collaborate with cross-functional teams to define and document data requirements for reporting.
Education
Master of Science - Information Technology
Kennesaw State University
Graduate Certificate - Data Analytics and Intelligent Technology
Kennesaw State University
Graduate Certificate - Information Technology Foundations
Kennesaw State University
Bachelor of Science - Biochemistry
Joseph Ayo Babalola University
Skills
- SQL
- Python
- DAX
- M Query (Power Query)
- T-SQL
- Power BI Desktop
- Power BI Service
- Power BI Dataflows
- Tableau Desktop
- Tableau Server
- Excel
- SSRS
- SQL Server
- Snowflake
- Teradata
- Oracle
- Azure Data Lake
- ETL pipelines
- Data Warehousing
- Data Integration
- Power Automate
- Scheduled dataset refresh
- Gateway configuration
- Alert automation
- Pivot tables
- Power Query in Excel
- XLOOKUP
- INDEX MATCH
- SUMIFS
- COUNTIFS
- Data cleansing
- Data structuring
- Alteryx
- Jupyter Notebook
- Power BI Front-end Development
- Power BI Back-end Development
- Advanced DAX Calculations
- Power Query (M language)
- SQL Query Development
- ETL Development
- Data Modeling
- Star Schema Design
- Semantic Layer Development
- Row-Level Security (RLS)
- Incremental Refresh
- Power BI Service Administration
- Power Automate Workflow Automation
- Alteryx Workflow Development
- Tableau Dashboard Development
- KPI Development
- Dashboard Optimization
- Data Governance
- Team leadership
- Relationship building
- Decision-making
- Critical thinking
- Coaching and mentoring
- Complex Problem-solving
- Client relationship building
- Results-driven
- Strategic planning
- Performance metrics analysis
- Forecasting
- Business storytelling
Timeline
VP, Lead Data Scientist
JPMorgan Chase
06.2025 - Current
VP, Data Management Lead
JPMorgan Chase
01.2022 - Current
Senior Data & Reporting Analyst
Frosch Travel (JPMorgan Chase Subsidiary)
01.2022 - 12.2022
SQL Developer / Power BI Developer
MedStar Health
01.2019 - 01.2022
Graduate Certificate - Data Analytics and Intelligent Technology
Kennesaw State University
Graduate Certificate - Information Technology Foundations
Kennesaw State University
Bachelor of Science - Biochemistry
Joseph Ayo Babalola University
Master of Science - Information Technology
Kennesaw State University
Work Preference
Open to Remote | Hybrid
Personal Information
Availability: Open to Remote | Hybrid