Sourav Sharma

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.

Data Analyst Training

GRAStech Training Institute — Noida, India

• Gained practical exposure to Advanced Excel, SQL, Power BI, Python, and Machine Learning for data analysis.
• Built interactive dashboards and business reports in Power BI using real-time datasets.
• Wrote complex SQL queries for data extraction, transformation, and aggregation.
• Applied Excel techniques including Pivot Tables, VLOOKUP, Power Query, and data cleaning for dataset preparation.
• Designed mock business case projects to simulate real-world analytics scenarios.
• Learned and applied core concepts of KPIs, ETL, data modeling, and business metrics.

Employee Work Delegation & Weekly Task Tracking | Google Sheets, Apps Script, Power BI

• Designed an employee work delegation system in Google Sheets to assign daily tasks and non-daily (ad-hoc) work.
• Created employee-wise task sheets automatically updated from a central master sheet.
• Enabled employees to update task status (Pending / In Progress / Completed) directly in their sheets.
• Used Google Apps Script to:
  Auto-transfer assigned tasks to respective employee sheets
  Track whether employees filled or updated their task sheets
  Capture task completion timestamps
• Built weekly tracking logic to monitor:
  Task completion vs pending work
  Employees who did not update their sheets
  Daily vs non-daily task performance
• Cleaned and structured task data using Power Query for reporting.
• Developed Power BI dashboards to visualize:
  Employee-wise task completion rate
  Weekly productivity trends
  Pending and overdue tasks

Production MIS & Automation | Google Sheets, Power BI

• Designed a central master sheet in Google Sheets connected to multiple department sheets.
• Used Apps Script to:
  Auto-transfer job data to respective team sheets
  Trigger updates when task status changes
  Reduce reporting time significantly
• Connected structured data to Power BI for real-time visualization.

Employee In–Out & Time Utilization | Google Forms, Google Sheets, Power BI

• Collected employee entry, exit, and return data through Google Forms, automatically merged into Google Sheets.
• Automated data adjustment, validation, and structuring in Google Sheets using Google Apps Script.
• Cleaned and transformed attendance data using Power Query to create analysis-ready datasets.
• Built Power BI dashboards to visualize employee-wise attendance, outside time, total working hours, and productivity trends.

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.

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.