Back to Developers
Shammi Akhtar Akhtar

Shammi Akhtar Akhtar

Data Analyst

Noida, U.P.
85
Profile Score

About

Motivated and analytical professional with experience in evaluating dashboards and developing reports. Certified Excel Specialist proficient in Excel, SQL and Power BI. Focused collaborator dedicated to interdisciplinary communication.

Skills & Expertise (29)

Excel Advanced
8.3/10
3
Years Exp
SQL Intermediate
7.7/10
3
Years Exp
Power BI Intermediate
7.6/10
2
Years Exp
Python Intermediate
6.8/10
2
Years Exp
Pandas Intermediate
6.5/10
2
Years Exp
Advance Excel ETL V-lookup H-lookup X-lookup Sum Ifs Index Match Count Ifs Advance filter Slicer Data Visualization Data Modeling Power Query Editor SSIS Predictive Analytics Statistical Modeling Descriptive Statistics ANOVA Statistical Testing Statistics Postgre SQL MySql Seaborn Matplotlib NumPy

Work Experience

Graduate Engineer Trainee

SKS ISPAT, POWER LTD

Sep 2020 - Jan 2021

Design and develop mechanical components and systems. Analyze and troubleshoot mechanical problems. Create and maintain technical drawing and schematics. Develop and maintain quality assurance protocols.

Data Analyst

CONTECHUB SOLUTION PVT.LTD.

Mar 2024 - Aug 2024

Design and create meaningful data visualizations to report and communicate insights. Import data from MS excel and Snowflake schema for generating Power BI reports. Utilize Power Query in Excel to connect to diverse data sources, importing and transforming data to excel reports. Verify customer and account data by reviewing, correcting, deleting, recovering, or reentering data. Extract data from sales force and created reports on daily basis and weekly basis and monthly basis. Create, view and share report in excel in pivot model as per client requirement.

Executive

VIKASH ENTERPRISES

Jun 2021 - Mar 2023

Created and Maintained weekly and monthly sales reports. Created dashboard which shows revenue generated and their total sales and Payout. Created Target vs Achievement report, ARPC (Average revenue per client) wise report for each client. Imported data from MS excel and prepare reports. Create and maintain data entry forms. Update existing records with new data.

Education

Bachelor of Technology - Dr. K.N. Modi Institute of Eng. & Tech., A.K.T.U.

- · Afghanistan

Senior Secondary Certificate Examination - Maharaja College, B.S.E.B.

- · Afghanistan

Secondary School Examination - Park Mount Public School, C.B.S.E.

- · Afghanistan

Certifications

Data Analyst

Ineuron benguluru · 2024

I completed data Analyst certification course.

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceFeb 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (29)

Excel SQL Power BI Python Pandas Advance Excel ETL V-lookup H-lookup X-lookup +19 more