Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ibrahim Ayoola

Indianapolis,IN

Summary

Over 8 years of extensive experience in data analysis, data quality management, and gathering requirements. Proficient in data analysis, system analysis, business requirement gathering, and data warehousing concepts. Experience with SharePoint and the use of JIRA. Extensive experience creating SSIS packages and jobs. Data manipulation, data definition, data control, and excellent report writing. Experienced and comfortable working on databases like MS SQL Server, Teradata, and Access Database. Expertise in business intelligence software like Tableau, Power BI, and Excel. Experience in the integration and extraction of data from various sources, like Microsoft SQL Server, Teradata, and flat files, into a staging area. Technical expertise in data profiling, data mapping, data cleansing, data security, and data quality management.

Overview

11
11
years of professional experience

Work History

Data Analyst II

MHS Indiana
Indianapolis, IN
07.2023 - Current
  • Extract, transform, and load data into databases using SQL queries.
  • Knowledge of pulling membership, provider, revenue, and claim record.
  • Created visualizations and reports for management, highlighting findings and recommendations.
  • Developed and maintained databases, reorganizing data for clarity and accessibility.
  • Utilized Teradata to generate recurring and ad hoc reports for reporting needs.
  • Retrieved and analyzed Medicaid data from multiple sources to produce daily reports, securely transferring them to stakeholders.
  • Loaded daily 834 membership files into corresponding tables in SQL Server.
  • Automated report generation to enhance efficiency in data analysis processes.
  • Identified high-risk members through reports, analyzing utilization patterns and measuring outreach effectiveness.
  • Developed and automated ETL packages using SSIS to load flat files from the source location into SQL Server.
  • Created various data visualization dashboards in Power BI for senior leadership to review dollars spent on various claims.
  • Designed and developed a data pipeline architecture to load recurring files from the vendor into several tables in our database.
  • Developed validation steps for several recurring reports.
  • Developed and automated a lot of ETL processes in SSIS to reduce a lot of manual work, and also increased data accuracy by creating data validation tasks.
  • Generate the monthly supplemental pregnancy file submitted to the State of Indiana for kick payment.

Data Analyst II

Elevance Health Inc
Indianapolis, IN
11.2022 - 06.2023
  • Create and maintain required databases, spreadsheets, and tracking mechanisms.
  • Manage data collection and sampling procedures to accurately collect data.
  • Run a query to convert RID (Medicaid ID) to Subscriber ID, and send the result in an Excel format to team members.
  • Retrieve, extract, and analyze Medicaid data from various sources to create daily reports and SFTP the reports to the right stakeholder.
  • Collaborate with internal teams and stakeholders to understand reporting requirements and data needs.
  • Clean, transform, and validate Medicaid data to ensure accuracy and data integrity.
  • Develop and maintain reporting templates, dashboards, and visualizations using reporting tools and software.
  • Create a report to monitor and track performance against HEDIS benchmarks and targets.
  • Retrieve HEDIS files from various sources and load them into the database.
  • Maintain documentation of HEDIS data loading processes, file structure, and data transformation rules.
  • Perform data manipulation operations, like importing and exporting data from various external file formats using SSIS.
  • Develop, update, and maintain current SQL programs.

Data Analyst

Unity Healthcare
Washington, DC
09.2020 - 09.2022
  • I work on a Medicaid management project serving the internal business community (Claims, Billing, Membership Customer Service, Membership Management, Provider Management, and Advanced Health Care Management) and the project team.
  • Create, execute, and analyze basic test scenarios to verify that client requirements are built into the system design.
  • Perform various analyses on various monthly reports, giving insights on the activities of providers using BI tools such as Tableau, Excel, and MS SQL.
  • Applied various Excel functions like MATCH, INDEX, VLOOKUP, etc., to perform data validation and analysis.
  • Write various complex SQL queries to help in the aggregation of providers' incentives, which serve as a basis for their payment.
  • Help in the fine-tuning of basic, standard stored procedures within the reporting team.
  • Append and clean the reporting database for better optimization.
  • Helping to perform better intelligence on the available client's data with the use of T-SQL and alongside other business intelligence tools.
  • Responsible for analyzing raw data and writing T-SQL scripts to manipulate data for data loads and extracts.
  • Create source and target mappings, transformation, load, and data cleansing rules.

Data Analyst

Dominion Energy
Richmond, VA
01.2020 - 08.2020
  • A member of the retail data team responsible for the WGL Virginia, and WGL Maryland market.
  • Involved in translating the business requirements into data requirements across different systems.
  • Writing complex SQL queries that aggregate data to help calculate providers' incentives.
  • Involve yourself in designing and creating tables, views, complex stored procedures, and indexes.
  • Improve query performance.
  • Data profiling for accurate, better reporting, and analysis.
  • Helping to perform better intelligence on the available client's data with the use of T-SQL.
  • Performed daily data manipulation using SQL and prepared reports on a weekly, monthly, and quarterly basis.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Perform data manipulation operations, such as importing and exporting data from various external file formats using SQL.
  • Acquire data from primary or secondary data sources, and maintain databases/data systems.

Network Administrator

Cloud & Wares Technologies Ltd
08.2014 - 08.2019
  • Troubleshoot and resolve problems with programs and systems.
  • Worked closely with end users to solve problems related to hardware and software.
  • Installed and supported hardware and software for desktops, servers, and printers.
  • Managed employee access, security roles, and permissions.
  • Monitored system upgrades, patches, and new configurations.
  • Determined and alleviated hardware, software, and network issues.
  • Installed and supported hardware and software for desktops, servers, and printers.
  • Monitored system upgrades, patches, and new configurations.
  • Supported various operating systems and server technologies.
  • Determined and alleviated hardware, software, and network issues.
  • Provided troubleshooting and testing to support the network.

Education

Bachelor of Science - Computer Science

University Of Lagos (UNILAG)
Lagos,Nigeria
06.2010

Certified SQL Data Analyst -

Skills

  • Project methodologies: Waterfall and Agile
  • Database management: RDBMS and SQL Server
  • Data visualization: Tableau and Power BI
  • Excel proficiency
  • ETL tools: SSIS
  • Data processing: Mapping, mining, cleansing
  • SQL querying
  • Data warehousing
  • Data analysis

Timeline

Data Analyst II

MHS Indiana
07.2023 - Current

Data Analyst II

Elevance Health Inc
11.2022 - 06.2023

Data Analyst

Unity Healthcare
09.2020 - 09.2022

Data Analyst

Dominion Energy
01.2020 - 08.2020

Network Administrator

Cloud & Wares Technologies Ltd
08.2014 - 08.2019

Bachelor of Science - Computer Science

University Of Lagos (UNILAG)

Certified SQL Data Analyst -

Similar Profiles

CREATE PROFILE
Ibrahim Ayoola