Farouk Ajayi

Dynamic Data Analyst with a strong proficiency in data manipulation, analysis, and visualization, cultivated through rigorous project engagements and extensive learning initiatives. Demonstrates a high level of competence in leveraging Python, SQL, and advanced data visualization tools to extract actionable insights from complex datasets. Proficient in translating these insights into clear and accessible formats, catering to diverse stakeholders and enabling effective, data-informed decision-making. Committed to maintaining a cutting-edge understanding of data analytics trends and methodologies to drive continuous enhancement in data-driven strategies.

RELIANCE HEALTH CARE INSURANCE CLAIM– Project – Arlington heights, IL

• Conducted comprehensive data analysis on a healthcare claims dataset, utilizing advanced SQL queries and techniques to extract valuable insights.
• Identified and analyzed the gender distribution of patients, allowing for targeted marketing strategies and improved healthcare service planning.
• Determined the most common medical diagnosis, enabling the development of proactive measures to address prevalent health issues.
• Conducted meticulous data preprocessing and cleansing, adeptly identifying and rectifying missing values using advanced techniques, resulting in a robust and high-quality dataset for analysis.
• Conducted an extensive revenue analysis, employing advanced data grouping to identify fields of study with the highest total fees collected, aiding resource allocation and financial planning.

Customer Sales Analysis

• Utilized SQL to extract data from different related tables from customer sales databases using JOIN and VIEW,
• Explored the distribution of payment methods used by customers, optimizing payment processing systems and improving customer experience.
• Transformed and filtered data by using aggregating and filtering function to improve reporting process, Analyzed sales revenue distribution across different product lines and branches, identifying top-performing segments and optimizing resource allocation.

Business Insights and Analytics with SQL 

• Transformed and processed data by using Excel to ensure data completeness and validity.
• Conducted in-depth customer segmentation analysis using SQL, calculating average sales per customer segment to inform strategic targeting and resource allocation.
• Analyzed revenue distribution across different markets (regions) by utilizing SQL to identify the top five revenue-generating markets from database.

• SQL: Querying and Managing Data, Khan Academy
• SoloLearn Data Analysis Course
• Tableau Creator Training