rimjhim chandra

rimjhim chandra

Data Analyst
India
Full-time Hybrid

About Me

Data Analyst with 4+ years of experience supporting business reporting, data analysis and dashboard development across e-commerce and BFSI domains. Skilled in SQL, Python, Power BI, DAX, Tableau and Advanced Excel, with …

Experience

Sales Data Analyst

E.mech solution · Ajjampur , Karnataka , India
Aug 2022 - Present · 4 years 2 months

<p>• Analyse large datasets using SQL and Python to identify business trends, patterns, performance gaps and actionable insights.</p><p>• Develop and maintain interactive Power BI and Tableau dashboards to track sales, revenue, customer behaviour and operational KPIs.</p><p>• Write SQL queries using joins, CTEs, subqueries, window functions and aggregations to extract and analyse business data.</p><p>• Use Python libraries such as Pandas and NumPy for data cleaning, data transformation, validation and exploratory data analysis.</p><p>• Perform statistical analysis, trend analysis and A/B testing to evaluate business performance and support data-driven decisions.</p><p>• Use Advanced Excel, PivotTables, XLOOKUP and Power Query for reporting, data reconciliation and analysis.</p><p>• Analyse e-commerce sales, product performance, customer purchasing behaviour and revenue trends.</p><p>• Analyse BFSI data related to loan applications, approval and rejection rates, disbursement volumes and processing time.</p><p>• Collaborate with business stakeholders to understand reporting requirements, define KPIs and deliver accurate reports.</p><p>• Explore Streamlit applications and Generative AI/LLM-based solutions to improve analytical reporting and data accessibility.</p>

DATA ANALYST

E.MECH SOLUTION PVT LTD CO. · Bangalore, India
Aug 2022 - Present · 4 years 3 months

<p>Work with business stakeholders to understand reporting requirements, confirm KPI definitions and deliver recurring performance reports for e-commerce and BFSI use cases.</p><p> Monitor 30+ business KPIs and present performance trends to 50+ business users to support operational reviews and business decisions.</p><p> Analyse monthly and quarterly business performance, highlighting sales trends, exceptions and areas where processes may be delayed or improved.</p><p> Translate analysis into concise updates and dashboard views that are understandable to both technical and non-technical stakeholders.</p><p> Write SQL queries using joins, CTEs, subqueries, window functions, aggregations and conditional logic to combine datasets and prepare analysis-ready outputs.</p><p> Reconcile report data against source records, investigate discrepancies and perform data-quality checks to support accurate and consistent reporting.</p><p> Compare performance across products, categories, branches and business periods to identify patterns and prepare findings for stakeholder reports.</p><p> Develop and maintain 20+ Power BI and Tableau dashboards covering sales trends, operational performance and business KPIs.</p><p> Build Power BI data models, manage table relationships and filter behaviour, and create DAX measures for KPI calculations and performance tracking.</p><p> Use dashboard drill-downs and trend comparisons to help stakeholders review performance, identify exceptions and focus on areas requiring attention.</p><p> Use Python and Pandas to combine datasets, group and aggregate records, handle missing values, remove duplicates and prepare data for analysis.</p><p> Automate recurring data-cleaning, validation and reporting activities, with reported manual effort savings of approximately 25 hours per week.</p><p> Support Databricks- and Python-based workflows processing more than 5 million records per month for analytical reporting.</p><p> Collaborate with business teams to resolve data discrepancies and guide 3 junior analysts on dashboard standards, SQL practices and reporting.</p>

PROJECTS

E-commerce sales analysis

E.Mech solution
Duration : 22-Aug-2022 - 19-Oct-2026

1. E-commerce Sales Analytics<p>Worked on an e-commerce sales analytics project to analyse sales performance, revenue trends, product categories and customer purchasing behaviour. Used SQL and Python to clean, combine and analyse large datasets and identify business trends. Developed interactive Power BI and Tableau dashboards to monitor key performance indicators, monthly sales, revenue and product performance. Used Advanced Excel, PivotTables and lookup functions to prepare reports and provide meaningful insights to support business decisions.</p>2. Loan Processing Analytics – BFSI<p>Worked on a BFSI analytics project focused on monitoring loan applications, approvals, rejections and disbursement performance. Used SQL, Python and Advanced Excel to analyse customer and loan data, identify processing delays and perform data validation. Developed Power BI dashboards with DAX measures to track loan approval rates, rejection rates, average processing time and branch-level performance. Shared analytical reports to help business teams monitor operations and identify areas for improvement.</p>3. ETL Pipeline Development – AWS<p>Worked on an AWS-based data pipeline project to prepare and organise data for analytical reporting. Used Amazon S3 for data storage, AWS Glue for data extraction and transformation, and AWS Lambda to automate workflow activities. Prepared structured data for loading into Amazon Redshift and performed data validation checks to maintain data consistency and reliability. This project helped support the availability of organised datasets for business analysis and reporting.</p>

Certifications

data analyst

Abhilashi University, India · Abu Road , Rajasthan , India · 2021

Skills

SQL Power BI Python Advanced Excel DAX Tableau AWS Databricks MySQL joins CTEs subqueries window functions aggregations data validation exploratory data analysis Generative AI Large Language Models (LLMs) prompt engineering Pandas NumPy Streamlit data cleaning grouping missing-value handling duplicate removal automation PivotTables XLOOKUP INDEX-MATCH Power Query data modelling dashboards KPI monitoring trend analysis data visualization AWS S3 AWS Glue AWS Lambda Amazon Redshift statistical analysis descriptive statistics hypothesis testing A/B testing Jupyter Notebook Jira Git/GitHub VS Code stakeholder communication problem-solving
Report this Profile?