Ahamed Buhari

Aspiring Data Analyst proficient in Excel, SQL and Power BI, with a strong background in data cleaning, analysis, and visualization. Proven ability to derive actionable insights from complex datasets through academic projects and self-directed learning. Motivated to apply data-driven solutions to real-world problems and committed to continuous professional development. Dedicated to contributing effectively to organizational goals and fostering a positive work environment.

Project Title: B2B E-Commerce

Tool : Power BI

Power BI B2B e-commerce project is to create a data-driven analytics platform tailored for business-to-business transactions. It aims to provide insights into sales trends, customer behavior, inventory management, and financial performance to optimize decision-making and enhance operational efficiency in the e-commerce domain.

Key Achievements:

• Created interactive dashboards to visualize key performance indicators.
• Analyzed sales data to identify trends and forecast future performance.
• Monitored customer behavior to inform marketing strategies.
• Managed inventory data to streamline supply chain operations.
• Evaluated financial performance to support strategic planning.

Project Title : Sales and Finance Report for Retail Company

 Tools : Microsoft Excel, Power Query, Power Pivot, DAX

• Utilized Excel's ETL capabilities, incorporating Power Query to automate data cleaning, saving approximately 4 hours of repetitive manual work.
• Created detailed Profit and Loss (P&L) reports using Pivot Tables and advanced formulas.
• Produced insightful charts, employed conditional formatting, and utilized Power Pivot for a comprehensive view of revenue streams and expenses.
• Implemented DAX measures, achieving a 90% improvement in reporting accuracy and efficiency.

Power BI:

• Managed data modeling, data cleansing, joins, and relationship building.
• Created conditional and calculated columns.
• Hands-on experience with various charts including Area, Stacked Bar, Cards, Donut, and Clustered charts.
• Worked with various functions such as aggregate, date, logical, math, and string.
• Utilized filters including advanced filter, basic filter, and Top N filter.
• Developed formulas for reports using Data Analysis Expressions (DAX) language.

SQL:

• Written complex SQL queries, including subqueries and join conditions.
• Ability to understand business requirements and data models.
• Vast experience in Oracle advanced SQL programming using analytical functions, subqueries, indexes, and set operators.
• Proficient in creating, modifying, and effectively using database objects like tables, constraints, sequences, indexes, group functions, and views.
• Experienced in query tuning using materialized views and indexes.
• Knowledgeable in various SQL commands including DDL, DML, DCL, and TCL.
• Assisted in designing and structuring databases, including defining tables, relationships, and constraints.

Excel:

• Proficient in Microsoft Excel (including VLOOKUP, PivotTables, and Charts)
• Data analysis and visualization .
• Good Knowledge in use basic functions like SUM, AVERAGE, COUNT, MIN, and MAX.
• Hands on experience in cell formatting such as font style, size, color, borders, and background colors.
• Good Knowledge in Cleaning and preparing data using text functions, find and replace, and data validation

• Completed Data Analyst course at BESANT TECHNOLOGY,CHENNAI
• Completed Excel - Mother of Business Intelligence from Codebasics. (https://codebasics.io/certificate/CB-51-34320)
• Complete HACKERRANK Basic SQL certificate.(https://www.hackerrank.com/certificates/3e8d6f6f1061)

• Leadership
• Problem Solver
• Analytical Thinking
• Communication skills
• Organizational skills