About
Motivated B.Com Graduate with strong foundation in Advanced Excel (VLOOKUP, Pivot Table, Power Query), SQL and Power BI. Certified in MSCIT and Tally Prime with GST. Successfully completed 3 projects analyzing 1000+ records, building interactive dashboards and improving accuracy by 98%. Detail-oriented, quick learner, seeking Fresher Data Analyst role.
Projects3
Sales Analysis Dashboard
Analyzed 1000+ sales records from multiple Excel sheets, cleaned data using Power Query, removed duplicates and errors. Applied VLOOKUP and XLOOKUP to merge product and sales data, created Pivot Tables and an interactive Power BI dashboard with bar and line charts, including slicers for filtering. Identified top 5 selling products and low sales months, aiding management in quick business decisions.
- Excel
- Power BI
- SQL
Bank Statement Analysis & Reconciliation
Imported 500+ bank transactions and company ledger data into Excel. Used VLOOKUP and conditional formatting to find and correct 45+ mismatched transactions. Created an automated reconciliation sheet with formulas and prepared the final Bank Reconciliation Statement in Tally Prime, ensuring cross-checking with GST entries for accuracy.
- Excel
- Tally Prime
E-Commerce Sales & Customer Analysis
Analyzed 1500+ e-commerce orders data, cleaned customer and order information. Wrote SQL queries involving JOINs and GROUP BY to identify repeat customers, canceled and returned orders, and payment failures. Created city-wise and product-wise sales reports in Excel and built Power BI dashboards showing revenue, profit, and customer retention metrics, including KPI cards.
- Excel
- SQL
- Power BI
Education1
Bachelor of Commerce
Smt.G.K.G.M.Jaysingpur