Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Farhan Mohammed

Merrillville

Summary

Dynamic data analyst with experience at IBM, leveraging Python and advanced statistical analysis to drive strategic insights. Successfully organized IT workshops and designed interactive dashboards, enhancing stakeholder engagement and decision-making. Proven problem solver with a passion for data visualization and optimizing analytics solutions to align with organizational goals.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Data analytics

IBM
Chicago
07.2023 - 06.2024
  • Organized IT workshops and seminars on cloud computing and big data analytics, enhancing knowledge and engagement.
  • Analyzed student behavior data using analytics tools, providing actionable insights to improve performance.
  • Collaborated with IT, Data Analytics, and BI teams to deploy analytics solutions, streamlining operations and outcomes.
  • Created reports on account and recruitment performance using Tableau and Excel, enabling data-driven decisions.
  • Applied advanced statistical methods to implement complex analytics plans, optimizing strategies and execution.
  • Monitored KPIs and industry trends in big data and AI, ensuring alignment with organizational goals and best practices.

Data Analyst Intern

cristal construction
Hyderabad
01.2022 - 04.2023
  • Leveraged large datasets and customer feedback to uncover trends and improvement opportunities, driving strategic business decisions.
  • Designed interactive Tableau dashboards to track KPIs, empowering stakeholders with real-time insights.
  • Engineered and optimized SQL queries and data models, enabling accurate reporting and forecasting.
  • Conducted statistical analysis and data preprocessing, ensuring data accuracy and reliability for analytics initiatives.
  • Partnered with cross-functional teams to deliver actionable analytics solutions, enhancing business performance.
  • Defined project scope and analytics objectives, aligning initiatives with organizational goals.

Education

Master of Science - IT Management

Indiana Wesleyan University
Merrillville, IN
01.2024

Bachelor of Science - Civil Engineering

Osmania University
Hyderabad, Telangana
01.2022

Skills

  • Python
  • C
  • Pandas
  • NumPy
  • Matplotlib
  • Seaborn
  • SQL, PL/SQL
  • Problem solving
  • Tax data analytics
  • Microsoft Excel (advanced)
  • Jupyter notebook
  • Data visualization
  • Statistical analysis
  • Machine learning
  • Data cleaning
  • Power BI
  • ETL, data wrangling

Certification

  • Certification in Python (Coursera)
  • SQL/PLSQL Certification
  • Data Analytics

Projects

Automated Data Scraping and Analysis (Python)
  • Public job posting and stock price data needed to be collected and analyzed for trends.
  • Build a reliable tool to automate data collection and generate insights.
  • Implemented data scraping with BeautifulSoup and requests.
    Cleaned and structured the dataset with Pandas.
    Created data visualizations using Matplotlib to display patterns and trends.
  • Reduced manual effort by 80% and delivered accurate visual insights, improving decision-making efficiency.

Library Database Management System

  • The library needed an efficient system to manage books, users, and transactions, reducing manual tracking errors.
  • Design and implement a relational database to handle book inventory, user records, borrowing/return transactions, and fines.
  • Created ER diagrams and normalized the database schema.
    Developed tables with appropriate relationships and constraints.
    Wrote complex SQL queries for searching, updating, and deleting records.
    Implemented stored procedures to automate book returns and fine calculations.
  • Streamlined library operations, reduced manual errors, and improved retrieval and reporting of books and transactions.

Employee Payroll System

  • The organization needed an automated system to manage employee records and calculate monthly salaries efficiently.
  • Design and implement a database solution to track employee work hours, calculate payroll, and generate payslips.
  • Created tables to store employee information, salary details, and work hours.
    Developed PL/SQL stored procedures to automate salary calculations and monthly report generation.
    Wrote queries to retrieve payroll data and generate payslips.
  • Streamlined payroll processing, reduced manual calculation errors, and ensured timely generation of accurate payslips.

Timeline

Data analytics

IBM
07.2023 - 06.2024

Data Analyst Intern

cristal construction
01.2022 - 04.2023

Master of Science - IT Management

Indiana Wesleyan University

Bachelor of Science - Civil Engineering

Osmania University

Similar Profiles

CREATE PROFILE