NISHAT AHMED
Meerut, Uttar Pradesh
️ **************@*****.***
PROFESSIONAL SUMMARY
Dynamic and detail-oriented Power BI Developer & Advanced Excel Specialist with 14+ years of experience in production operations, data management, reporting, SAP entry, and dashboard creation. Expert in transforming raw datasets into meaningful insights through clean data modeling, DAX, KPIs, interactive dashboards, and automated reports. Hands-on exposure to manufacturing processes, inventory control, manpower management, and audit documentation.
Delivers fast, accurate, and business-ready analytics for decision-making. CORE SKILLS
Power BI (Intermediate)
Power Query (ETL & Data Cleaning)
DAX (Basic–Intermediate Calculations)
Data Modeling (Star Schema, Relationships)
KPI Creation, Advanced Visuals
Drill-through, Bookmarks, Tooltips
Power BI Service (Publishing, Scheduling)
Advanced Excel
Pivot Tables & Pivot Charts
Advanced Formulas (VLOOKUP, INDEX-MATCH, IFs, TEXT, DATE)
Dashboard Designing
Power Query
Macros (Basic Automation)
Technical Skills
MS Office (Word, PowerPoint)
MS Outlook
SAP (Production + Inventory Entry)
Data Entry & Reporting
Production Documentation & Planning
PROFESSIONAL EXPERIENCE
E-COMMERCE & AMAZON OPERATIONS
EXPERIENCE
Amazon Stores Managed: KS Care Pvt. Ltd. Operations Executive Sep.2025 – Till Now
• Product listing, catalog updates, variation creation
• Keyword setup, title optimization, suppressed listing fix
• Daily order processing: Self-Ship / EasyShip
• Return/claim handling, customer messages response
• Inventory updates, stock mismatch checks, pricing monitoring
• Courier label printing, dispatch coordination
Amazon Stores Managed: Alice Enterprises Operations Executive Dec. 2023 – Aug. 2025
• Managed product listings, catalog updates, variations & keyword optimization.
• Edited product images (white background & clarity enhancement) to meet Amazon standards.
• Handled daily order processing, label printing, packaging coordination, courier dispatch
& shipment tracking.
• Managed returns, refunds, claims & customer communication.
• Performed daily inventory updates, stock mismatch corrections & pricing checks.
• Monitored account health metrics (ODR, NCR, Late Dispatch & policy alerts).
• Supported Sponsored Ads with basic campaign setup, keyword selection & bid adjustments.
Continental India Pvt. Ltd. – Tube Section, Modipuram Production Executive Jan 2014 – Oct 2023
Prepared daily/weekly/monthly production MIS using Excel & SAP.
Designed dashboards for production, quality, scrap %, and manpower utilization.
Managed shift manpower, attendance, and production planning.
Ensured quality control and maintained scrap within target limits.
Maintained ISO/BIS documentation and supported audits.
Oversaw warehouse activities, packing, labeling, and storage planning. Modi Tyre Company – Modipuram&Partapur
IT Coordinator / Mfg System Support 2009 – 2013
Managed SAP entries for production and inventory.
Ensured error-free reporting, documentation, and system support. Teaching Experience (Early Career)
Math & Computer Teacher
Sarswati Public School Bright Land Public School Royal Public School 2002 – 2009
Accountant
Purohit Sudhir & Associates 2001 – 2002
Managed accounting entries and basic financial documentation. EDUCATION
MBA (Production & HR) – Subharti University (2018)
B.Com – C.C.S. University (2001)
Intermediate – UP Board (1997)
High School – UP Board (1995)
CERTIFICATIONS
Power BI Course Certificate – Skill Course by Satish Dhawale (2025)
Master Trainer Certificate – Continental India Pvt. Ltd. (2021)
Train the Trainer – The Andragogy Consulting House (2016)
Diploma in Computer Application
STRENGTHS
Excellent communication skills
Quick learner & adaptable
Strong time and people management
Process-oriented & self-motivated
Ability to work under pressure
PROJECTS (Training & Practice)
1. Mobile Sales Analytics Dashboard – Power BI
Developed a fully interactive end-to-end sales analytics dashboard.
Cleaned and transformed raw data using Power Query.
Created KPIs: Total Sales, Transactions, Total Quantity, Avg Quantity.
Added map visuals for city-wise insights.
Built monthly trend analysis with line charts.
Added slicers for Month, Brand, Payment Method.
Designed a modern, clean business-ready layout.
2. Hospital Emergency Room Monthly Dashboard – Advanced Excel
Created a dynamic Excel dashboard using Pivot Tables, Charts, Slicers.
Designed KPIs: Monthly Patients, Avg Wait Time, Satisfaction Score.
Built gender-wise, age-group, and department-wise insights.
Used conditional formatting for data highlighting.
Delivered a visually clean & decision-ready report. PERSONAL DETAILS
Father’s Name : Irshad Ahmed
Nationality : Indian
Marital Status : Married
Date of birth : 18 Mar 1979
Sex : Male
Language known : English, Hindi & Urdu.
DECLARATION
I hereby declare that the information given above is true and correct to the best of my knowledge.
Nishat Ahmed