Olusegun Adenuga
Baltimore,MD
Summary
Data Analyst with a strong passion for transforming complex data into actionable insights. Proficient in Power BI, Tableau, SQL, and Excel, consistently delivers dynamic dashboards and automated reporting processes that enhance operational efficiency. Experienced in optimizing business strategies, improving performance metrics, and identifying growth opportunities through data-driven storytelling. Committed to collaboration with cross-functional teams to develop impactful data solutions that drive business success.
Overview
7
7
years of professional experience
Work History
Sr Analyst, Analytics and Reporting
DaVita Kidney Care
Baltimore, MD
11.2023 - Current
- Created high-performance reporting dashboards utilizing the SQL Server Reporting Services and Snowflakes
- Drafted database schemas to support an enterprise-wide data warehouse and BI framework using federated data marts with conforming dimensions
- Enforced software development life cycle (SDLC) to ensure a quality-tested product is delivered within the expected time frame
- Maximized reporting benefits through close communication with client and business teams to quickly implement new KPIs or metrics and fine-tune existing items
- Delivered reports or dashboards that easily tell a story through carefully designed visualizations and robust features to slice, filter, and drill through data
- Developed optimized ETL procedures using SSIS and advanced SQL queries to streamline data flows and enforce data consistency
- Engage the functional business teams with a consultative approach and be the data subject matter expert
- Ensures data quality, focusing on data consistency and clear definitions of all data elements
- Created dashboards using tableau dashboard and prepared user stories to deliver actionable insights
Technical Data Analyst
Argo Group
Baltimore, MD
11.2022 - 10.2023
- Identifies internal and external sources of data
- Determines data qualities and their impact on the output of the potential analyses
- Developed interactive Microsoft Excel dashboards for presentations purpose
- Created pivot tables in MS Excel for periodic reporting purpose
- Transformed the data by applying SQL joins and formulas to build multiple data models based on requirements
- Write SQL query, sub-queries and perform table joins and complex data merges
- Utilized Excel VBA macros to automate repetitive tasks and perform data manipulations which enhanced operational efficiency by 70%
- Extracts and compiles data from various databases for use in reporting and analysis
- Develops database queries for use in extracting and combining data
- Ensures data quality, focusing on data consistency and clear definitions of all data elements
- Programs in various computer programming languages to clean data and to connect to multiple datasets across multiple databases
- Created customized charts and custom calculations as per requirements
- Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
- Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries
- Connect Tableau server to publish dashboard to a central location for portal integration
- Extracted Data -from various data sources for periodic report (weekly, bi-weekly, monthly)
- Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently
- Created dashboards using tableau dashboard and prepared user stories to deliver actionable insights
- Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau
- Developed Tableau workbooks from numerous data sources using Data Blending
- Understand and translate high-level business requirements and detailed specifications into solid technical solutions
- Used Jira for report & project tracking
- Perform complex analyses on programs and initiatives and creates visual representations and summary reports of findings
- Develops meaningful dashboards and presentations that use information to inform and influence business activities and strategies
Data Analyst II
Citi Group
Baltimore, MD
07.2021 - 10.2022
- Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas
- Maintained Access database for the purpose of extracting reports
- Developed interactive Microsoft Excel dashboards for presentations purpose
- Write SQL query, sub-queries and perform table joins and complex data merges
- Manipulate dataset for Visualization purpose
- Performed data profiling by using Informatica to assess the quality of the data, identify anomalies and handle missing data
- Manually clean, reviewed, and corrected gaps in datasets
- Created connection to SQL server from Excel for quick reporting needs
- Developed SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements
- Work with business teams to develop reports or address data needs to provide reporting solutions
- Built interactive dashboards with Key Performance Indicator (KPI) metrics on Power BI to get insights on market performance
- Generate monthly and quarterly reports to track financial performance and compliance with regulatory requirements
- Work with cross functional teams to develop and implement strategies to optimize balance sheet management and improve profitability
- Conducted research and analysis to support business development initiatives
- Prepare financial models and presentations for senior management and external stakeholders
- Partner with relational and dimensional developers, BI analysts, data scientists, and other business stakeholders to drive efficiencies and improvements in information usage
- Collaborate with cross-functional teams to understand data requirements and translate them into effective data solutions
- Utilize SQL skills to design, develop and maintain complex SQL queries and scripts for data extraction, transformation and loading (ETL)
- Collaborate with ETL team to optimize workflows, troubleshoot issues and enhance data integrations
- Contribute to dimensional data modeling efforts, designing and implementing logical and physical data models that align with business needs and industry best practices
- Support the integration of data from multiple sources into various data warehouses, ensuring data security, accuracy and integrity
- Execute upon the strategic vision and realization of data warehousing, analytics, and decision support system development and implementation for the organization
- Comply with proper internal controls as necessary to conduct job functions and/or carry out responsibilities and/or administrative activities at the Company
Data Reporting Analyst
Landmark Health
Baltimore, MD
10.2019 - 06.2021
- Used SQL Assistant front-end tool to issue SQL commands matching the business requirements to run reports for data on Providers
- Prepare reports working with database structures and data modeling including working knowledge of SQL
- Perform on a regular basis ad hoc analysis of data sources for all external and internal customers
- Generated database reports, presentation, and documentation of analytical methods
- Conduct self-directed research to uncover problems in Medicare payments made to a variety of provider types including physicians, suppliers, hospital, and rehabilitation facilities
- Handle Strong healthcare material including experience with transaction standards (e.g., HIPAA)
- Develop Tableau visualizations and dashboards using Tableau Desktop
- Manipulated and cleaned large Excel dataset for easy interpretations
- Develop and maintain reports and dashboards to monitor key performance indicators and identify areas for improvement
- Analyze data from EHR systems to identify trends and patterns that can inform clinical decision making
- Utilizes complex SQL, Power BI and other technical skills to combine data from multiple sources, including medical claims, provider, and third-party data
Data Analyst
JPMorgan Chase
Baltimore, MD
01.2018 - 09.2019
- Analyzed, developed, tested, maintained, and supported complex data models and processes
- Created pivot report and wrote VLOOKUP formulas for data joins in excels
- Extracted Data -from various data sources for periodic report
- Provided data analysis support to the fraud investigation team in support of their investigation leads
- Created tabular reports and deployed over report server to end-users
- Prepare reports working with database structures and data modeling including working knowledge of SQL
- Perform on a regular basis ad hoc analysis of data sources for all external and internal customers
- Generated database reports, presentation, and documentation of analytical methods
- Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas
- Supported logical data designs/models by reviewing with Business stewards
- Created pivot tables in MS Excel for periodic reporting purposes
- Function as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
- Developed dashboards using power BI and SSRS to visualize and communicate data to stakeholders
- Commended for delivering timely and actionable insights resulting in significant business impacts
- Collaborate with business and technology teams to identify and document business requirements for various banking systems and applications
- Develop project plans and timelines using project management methodologies (Agile waterfall) to ensure successful delivery of projects
- Utilized SQL to extract data from various sources and perform data analysis
Education
Master of Arts - Marketing Management Technology
Eastern Mediterranean University
Skills
- Microsoft Office Suite
- SQL Server Management Studio
- Oracle
- Snowflakes
- SQL Server
- PostgreSQL/
- MySQL
- Extract-Transform-Load (ETL)
- MS Excel
- Pivot table
- VBA scripting
- VLOOKUP
- MS Power Point
- MS Word
- MS Visual Studio
- Scrum
- Agile methodology
- SDLC
- Investment Banking
- Data Governance
- Software Development
- Data warehouse
- Tableau
- Power BI
- GitHub
- QlikView
- MongoDB
- R
- SAS
- Data Mining
- Focus Groups
- Creation of Surveys
- Research Methods
- Data Analysis
- Data Cleansing
- Database Design
- Assessment of Data Quality
- Visualization of Data Insights
- Trend Identification
Timeline
Sr Analyst, Analytics and Reporting
DaVita Kidney Care
11.2023 - Current
Technical Data Analyst
Argo Group
11.2022 - 10.2023
Data Analyst II
Citi Group
07.2021 - 10.2022
Data Reporting Analyst
Landmark Health
10.2019 - 06.2021
Data Analyst
JPMorgan Chase
01.2018 - 09.2019
Master of Arts - Marketing Management Technology
Eastern Mediterranean University
Similar Profiles
Deja MorrowDeja Morrow
Patient Care Technician at Davita Kidney CarePatient Care Technician at Davita Kidney Care
Evi UtamiEvi Utami
Registered Nurse at St. Anthony’s Hospital - DaVita Kidney CareRegistered Nurse at St. Anthony’s Hospital - DaVita Kidney Care
Victoria DegueheryVictoria Deguehery
Registered Nurse at DaVita Kidney CareRegistered Nurse at DaVita Kidney Care
Mary E RowanMary E Rowan
Ohio Certified Dialysis Technician at DaVita Kidney CareOhio Certified Dialysis Technician at DaVita Kidney Care
Geron BrooksGeron Brooks
Substitute Teacher, Relay Elementary School at Kelly EducationSubstitute Teacher, Relay Elementary School at Kelly Education