Data Analyst with less than a year in SQL, Python & Power BI for business insights.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Roshan Jha is an aspiring Data Analyst with a Bachelor of Commerce (Business Statistics) and a foundational work experience in business development. He possesses strong skills in SQL, Python, and Power BI, demonstrated through personal projects focused on sales, exploratory data analysis, and customer behavior. Roshan excels at identifying trends, generating actionable insights, and providing recommendations to improve business performance and customer experience.
CCS University
Bachelor of Commerce · Business Statistics
August 1, 2020 – June 30, 2023
Pregrad
BUSINESS DEVELOPMENT ASSOCIATE
September 1, 2024 – March 1, 2025
Noida, Uttar Pradesh, India
SQL EXPLORATORY DATA ANALYSIS EDA
September 1, 2025 – June 1, 2026
Conducted comprehensive exploratory data analysis using SQL on multidimensional datasets to uncover key business insights. Utilised advanced SQL features (window functions, aggregations, time-based trends, cumulative sums) to detect seasonality and sales trends. Determined customer distribution by country, finding top contributing countries with the highest customer base, useful for regional targeting. Analyzed gender split of customers, identifying imbalances in customer demographics for better marketing campaigns. Ranked products by revenue, revealing the top 5 products generating the highest sales and the bottom 5 underperforming products, guiding product lifecycle decisions.
CUSTOMER BEHAVIOUR ANALYSIS
September 1, 2025 – June 1, 2026
Calculated total spend per customer and identified high-value patrons to inform targeted marketing strategies. Evaluated pre- and post-membership purchases, showing the loyalty program increased engagement and points accumulation. Determined first and most popular menu items per customer, enabling personalized promotions and upselling opportunities. Designed loyalty points system analysis, including item-specific multipliers and first-week bonuses, quantifying program effectiveness in customer retention.
SALES STORE ANALYSIS
August 1, 2025 – June 1, 2026
Analyzed retail store sales dataset using SQL to identify top-selling products, profit-driving categories, and customer preferences. Identified trends in product demand, customer behavior and operational delays - improving reporting accuracy by 90% and uncovering inefficiencies in 30% of total transactions. Generated insights that led to a 25% improvement in inventory planning accuracy, a 20% reduction in delivery days. Supported targeted marketing campaigns that increased customer engagement by 15%. Provided actionable recommendations for improving customer experience and store profitability.
Cultural Fit Analysis
The candidate's projects demonstrate a proactive approach to learning and applying data analysis skills, which aligns with a growth-oriented culture. The business development experience, while not directly technical, shows an ability to engage with stakeholders and understand business needs, which is valuable for a data analyst role. The personal projects indicate self-motivation and initiative. However, the lack of diverse work experience beyond a single business development role limits the assessment of cultural adaptability in varied professional settings.
Soft Skills & Operational Fit
The candidate's project descriptions indicate an ability to work with cross-functional teams (marketing, operations, product) and translate data insights into actionable recommendations, which suggests good communication and problem-solving skills. The business development experience also points to relationship building and market research capabilities. However, without specific psychometric or English test scores, a deeper assessment of soft skills and operational fit is limited.