Summary
Overview
Work History
Education
Skills
Additional Information
PROJECT 1
PROJECT 2
Timeline
Generic

Sourav Sharma

NOIDA

Summary

Detail-oriented Data Analyst with recent experience in handling complex datasets using Advanced Excel, MySQL, Power BI, and Google Sheets. Backed by 4 years of experience in the accounting field, I offer a solid foundation in financial data, budgeting, and reporting. Skilled at transforming raw data into actionable insights, and leveraging financial knowledge to drive smarter business decisions.

Overview

6
6
years of professional experience

Work History

Accountant

G.S PRINT SOLUTION
01.2023 - 08.2025
  • 3-Way Matching – Match invoice with PO and GRN to ensure accuracy before booking
  • Invoice Matching – Match vendor invoices with purchase orders and delivery challans.
  • Invoice Verification – Receive, verify, and process vendor invoices per company policy
  • Invoice Processing in SAP – Process AP invoices in SAP using 3-way match.
  • Employee Reimbursements – Process reimbursements in SAP as per policy.
  • Freight & Clearing Allocation – Allocate freight and clearing costs using 2-way match with quotation and invoice.
  • TDS Deduction – Deduct applicable TDS and ensure proper tax coding.
  • Month-End Close – Support month-end and year-end AP closing activities.
  • Provision Booking – Process monthly provisions for expenses..
  • Reconciliations – Perform vendor reconciliations (domestic & overseas); year-end as per IGAAP.
  • Invoice Verification (SAP) – Verify and approve purchase, clearing & freight invoices in SAP.

Process Developer

Stratsol Software Systems
01.2022 - 01.2023
  • Transactional processing for accounts payable invoices in SAP
  • Invoice Match With 2-way and 3-way Match Before Processing In System
  • Answer email queries from vendors and internal partners.
  • Review of invoice deductions, claims, and expenses to ensure compliance with company policies.
  • Work to resolve discrepancies with clients, departments, or individuals.
  • Purchase order approval.
  • Approve Vendor Payment And Also Reject that Despute

JUNIOR ACCOUNTANT

K.D EXPORTS
06.2019 - 01.2022
  • Bills receivable or bills payable.
  • Reconciliation of ledger of all debtors and creditors.
  • Maintain sales and purchases.
  • Bank reconciliation.
  • Banking and daybook maintain on Tally.
  • Prepare monthly financial reports as per the requirement of CA.
  • HANDLE VENDOR'S PAYMENT.
  • Invoicing on Tally.

Education

Bachelor -

CCS University
01.2021

High School Diploma -

NOIDA PUBLIC SCHOOL
Noida, India
01.2018

Skills

  • Data analytics
  • Data cleaning
  • Excel proficiency
  • SQL
  • Power BI
  • Machine learning basics
  • Python
  • Data processing
  • Data Modelling
  • Strong communication
  • BI tools knowledge
  • SAP Applications
  • Accounts Receivable
  • General Ledger Documents
  • Journal entries
  • Accountancy
  • Processing of Payments

Additional Information

Data Analyst Training
GRAStech Training Institute[NOIDA, India]

  • Gained hands-on experience in Advanced Excel, SQL, Power BI, and Python for data analysis.
  • Built dashboards and reports using Power BI with real-time datasets.
  • Wrote complex SQL queries for data extraction and aggregation.
  • Cleaned and transformed datasets using Excel (VLOOKUP, Pivot Table, Power Query).
  • Created interactive visuals and reports for mock business cases.
  • Understood key data concepts like KPIs, ETL, data modeling, and business metrics.

PROJECT 1

Sales Performance Dashboard | Excel, SQL, Power BI

  • Data Preparation (Excel): Cleaned and standardized 10K+ sales records, ensuring accuracy in profit, discount, and shipping cost fields.
  • Data Analysis (SQL): Queried large datasets using JOIN, GROUP BY, and aggregate functions to identify monthly trends, top-performing categories, and customer segments.
  • Dashboarding (Power BI): Designed an interactive dashboard using Power Query + DAX measures (Profit Margin %, Avg. Discount, Shipping Cost %) with dynamic slicers for region, category, and time.

PROJECT 2

Personal Finance & Credit Risk Analysis | SQL, Excel, Power BI

  • Data Preparation: Cleaned and standardized 32K+ financial records (income, expenses, savings, loans, credit score). Converted record_date into datetime for trend analysis.
  • SQL Analysis: Queried dataset using GROUP BY, aggregations, and window functions to segment users by income, expenses, and credit score bands.
  • Power BI Dashboard: Built an interactive report to visualize:
    Income vs Expenses across regions & job titles.
    Debt-to-Income ratio impact on credit scores.
    Loan distribution by type (Education, Mortgage, Business, Personal).
    Savings-to-Income ratio for financial stability analysis.

Timeline

Accountant

G.S PRINT SOLUTION
01.2023 - 08.2025

Process Developer

Stratsol Software Systems
01.2022 - 01.2023

JUNIOR ACCOUNTANT

K.D EXPORTS
06.2019 - 01.2022

Bachelor -

CCS University

High School Diploma -

NOIDA PUBLIC SCHOOL
Sourav Sharma