Powered by
Codebasics DA Bootcamp

Shaik Imran

Data Aspirant

+91 7674863746 [email protected]

Resume

Hello, I am

Shaik Imran.

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

I am data enthusiast with a passion for turning data into meaningful insights. With over 3 years of experience in IT, I began my journey in Hyderabad Infosys, specializing in implementation support with Unix, SQL and Excel. I discovered my knack for data analysis and decided to pursue this captivating career.

I am eager to apply my technical skills and analytical mindset in a dynamic environment where I can help drive data-informed decisions. Let’s connect to discuss how I can contribute to your team!

Key Skills

SQL

Power BI

Excel

Python

Stakeholder Management

Project Planning

Data Vizualization

My Projects

My Experience

SQL Query Optimization: Developed and optimized SQL queries for daily operations (EOD – BOD), reducing processing time by 20% and speeding up data retrieval.
Automated Client Reports: Automated recurring reports using advanced Excel features, cutting reporting time by 40% and providing real-time data for stakeholders.
Root Cause Analysis: Analyzed support tickets using SQL and Excel to find recurring problems, which helped the team resolve similar issues faster and reduced root cause analysis time by 20% - 30%.
Improved Ticketing System: Created Excel reports to track ticket status and resolutions, improving efficiency by 15% by identifying issues faster.
Collaborated Across Teams: Identified repetitive issues across Finacle and tested problematic functionalities in testing environments, resolving them early to prevent operational impact and avoid similar issues from recurring.

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/shaikimran1/

+ 91 7674863746

https://github.com/Shaik-Imran1

Excel Project

Excel Analytics: Extracting Business Insights for AtliQ Hardwares

Domain/Function: FMCG

Analyzed extensive datasets, extracting insights with Excel for informed decision-making. Leveraged ETL processes and Excel's Power Query/Pivot for efficient data handling. Produced impactful sales and financial reports guiding strategic decisions.

View Project
Engagement

View Project
on GitHUB

Excel Analytics: Extracting Business Insights for AtliQ Hardwares

Customer sales report : Provides net sales performance of each customer across years.

Excel Analytics: Extracting Business Insights for AtliQ Hardwares

Market performance vs target report across years: Enables stakeholders to assess the country's performance and compare it to set target.

Project Details

Efficiently analyzed vast datasets, uncovering valuable insights using Excel to drive informed decision-making.
-The project effectively utilized ETL processes and harnessed Excel's Power Query and Power Pivot functionalities to streamline data extraction, transformation, and report generation.
- Created insightful sales and financial reports that provided valuable business insights, aiding important strategic decisions.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar E-Commerce

AtliQ Hardware aims to enhance competitiveness by transitioning from Excel to Power BI for advanced analytics. My goal: empower data-driven decisions.

View Project
on GitHUB

Business Insights 360

Home page of BI360 dashboard

Business Insights 360

Finance view of BI360 dashboard

Project Details

This project aims to create a single, versatile report accessible to stakeholders across sales, marketing, finance, and executive teams. The primary focus lies in catering to the diverse needs of each department while ensuring comprehensive insights and usability.

1. Strong Data Modeling
2. User-Centric Report Design
3. Drill-Down Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modeling with over 10 tables
4. Selecting appropriate visuals and formatting
5. Principles of dashboard design
6. Utilizing bookmarks
7. Deployment in Power BI service
8. Incorporating stakeholder feedback
9. Metrics in Sales, Marketing, Finance & Supply Chain

Live Interactive Dashboard

PowerBI Project

Revenue and Booking Insights

Domain/Function: Hospitality

AtliQ Grands, a luxury hotel chain, is losing market share and revenue due to strategic moves by competitors and ineffective management decisions. Without an in-house analytics team, they hired a 3rd party to analyze their historical data and provide insights to regain their competitive edge.

View Project
on GitHUB

Revenue and Booking Insights

User-emphatic landing page of dashboard.

Revenue and Booking Insights

Data-modeling of tables

Project Details

Cleaned and analyzed historical revenue data.

Created key metrics including Total Revenue, RevPAR, and ADR using DAX formulas:
Total Revenue = SUM(Revenue[Amount])
RevPAR = [Total Revenue] / SUM(Rooms[Available Rooms])
ADR = [Total Revenue] / SUM(Rooms[Occupied Rooms])

Developed an interactive dashboard based on the provided mock-up, featuring charts and tables for revenue, occupancy, and ADR metric

Insights:

Analyzed trends and performance by hotel segment and location.
Provided recommendations for revenue optimization and competitive positioning.

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

Domain/Function: Consumer Goods

AtliQ Hardware, a leading computer hardware manufacturer, faced challenges in data-driven decision-making. To enhance their analytics capabilities, This project showcases the use of SQL for extracting insights and visualizing data in Power BI.

View Project
on GitHUB

Consumer Goods Analytics

Implemented complex queries using Common Table Expression (CTE) and Joins.

Consumer Goods Analytics

Generated report as per request by using CTE and Window functions.

Project Details

➡️ Problem Statement:

AtliQ Hardware, a prominent computer hardware manufacturer, faces challenges in making timely, data-driven decisions. To address this, management is expanding its data analytics team by recruiting junior analysts. The head of data analytics initiates a SQL challenge to assess candidates' technical skills and soft skills.

➡️ Tools Used:

MySQL: Concepts like Joins, CTEs, Subqueries, Window functions, String functions, Numeric functions, Date functions, and more.

Canva: Created slides for presenting findings.

💡 In this project, I've learned the importance of ad hoc SQL queries for gaining quick insights and identifying trends. Importing & understanding data, querying tasks, presenting outcomes, enhanced my SQL and problem-solving skills.