
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Junior Data Analyst with 1+ years in Power BI & SQL Data Modeling
Results-driven Data Analyst & Business Intelligence professional with 1+ year of hands-on experience transforming raw business data into executive-ready intelligence across the diamond and jewellery industry. Proficient in Power BI dashboard development, SQL-driven data modeling, DAX, Power Query, Excel automation, and SAP ERP. Proven track record of reducing manual reporting time by ~40%, automating 60% of recurring MIS reports, and sustaining 99%+ data accuracy in high-volume environments. Adept at KPI tracking, RFM segmentation, ETL pipeline design, and business analysis - with clear communication skills to translate data insights into strategic decisions for senior stakeholders.
Hemchandracharya North Gujarat University, Patan
Master of Computer Applications (MCA) · Computer Applications
August 1, 2022 – June 30, 2025
Hemchandracharya North Gujarat University, Patan
Bachelor of Commerce (B.Com) · Commerce
August 1, 2019 – June 30, 2022
Imarticus Learning
PG Program in Data Science & Analytics · Data Science & Analytics
N/A – June 30, 2025
Aurita Diamond Pvt. Ltd.
Junior Data Analyst
January 1, 2026 – Present
Ahmedabad, Gujarat, India
RBZ Jewellers Pvt. Ltd.
Junior MIS Executive
April 1, 2025 – January 1, 2026
Ahmedabad, Gujarat, India
Customer Analytics & RFM Segmentation Dashboard
June 20, 2026 – Present
Objective: Identify high-value customers and improve marketing campaign targeting for a 1,000+ customer base. Built multi-page Power BI dashboard segmenting customers by Recency, Frequency, and Monetary value using Python (Pandas) and SQL cohort queries. Delivered actionable segments enabling the marketing team to re-engage lapsed high-value customers - improving campaign targeting efficiency and retention tracking.
Sales Trend & Forecasting Dashboard
June 20, 2026 – Present
Objective: Enable data-driven inventory planning and reduce overstock during festive seasons. Developed YOY trend dashboard with seasonal overlays, growth rate metrics, and forward-looking indicators using DAX time-intelligence functions. Insights directly shaped inventory procurement strategy - reducing overstock incidents and improving stock turnover ratio during peak demand periods.
Stock Aging & Inventory Analysis Automation
June 20, 2026 – Present
Objective: Highlight slow-moving inventory to support markdown decisions and reduce holding costs. Automated stock aging report categorizing SKUs into 30/60/90-day aging bands using SQL and Excel; integrated live refresh into Power BI for continuous monitoring. Enabled management to take timely markdown actions, directly reducing inventory holding costs and improving warehouse utilization.
Gold Price Prediction System
June 20, 2026 – Present
Objective: Develop a time-series forecasting model to predict gold price movements for procurement strategy. Applied regression and Hidden Markov Models (HMM) to historical price data, achieving a 94.23% prediction accuracy baseline with scope for further optimization. Model outputs provided procurement team with forward price signals to optimize buying decisions and hedge against commodity volatility.
Cultural Fit Analysis
The candidate's project diversity, ranging from customer analytics and sales forecasting to inventory management and financial prediction, indicates a broad interest in applying data analysis across different business functions. Their experience in both a Junior Data Analyst and Junior MIS Executive role, coupled with a PG Program in Data Science & Analytics, shows a commitment to the data field. The focus on delivering actionable insights and improving business processes aligns well with a results-oriented culture.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills through project descriptions (e.g., identifying high-value customers, reducing overstock, highlighting slow-moving inventory). Their experience in automating reports and building dashboards indicates an operational fit for roles requiring efficiency and data-driven decision support. The professional summary also highlights clear communication skills for translating insights to stakeholders.