Apeksha P

Data Analyst

Bengaluru, Karnataka, India 1+ yrs exp 89 · Excellent

About

Data Analyst with hands-on experience in SQL, Power BI, Excel, DAX, Power Query, and Python. Skilled in data cleaning, validation, transformation, analysis, visualization, and reporting. Experienced in working with financial and transactional data to identify trends, analyze performance, and generate actionable business insights. Strong analytical and problem-solving skills with a focus on data accuracy, business understanding, and data-driven decision-making.

Skills & Expertise (27)

Excel Advanced

8.0/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Shopify Financial Reporting Data Reconciliation Data Validation NumPy Pandas Transformation Power Query Visualization Charts If VLOOKUP XLOOKUP PivotTables Aggregations Joins ORDER BY GROUP BY WHERE Select

Work Experience

Data Analyst Intern

Beeskilled

Jul 2026 - Present

Cleaned and analyzed sales data using Excel, including PivotTables, Pivot Charts, XLOOKUP, and formulas, to identify revenue and sales trends. Queried sales datasets using SQL to analyze product, category, and revenue performance and generate business insights. Cleaned and transformed data using Python, Pandas, and NumPy, including handling missing values, filtering records, and creating calculated fields. Applied data validation and analysis techniques to prepare datasets for reporting and decision-making.

Bookkeeping Executive

Outbooks

Jul 2024 - Apr 2026

Managed large volumes of financial and transactional data for international clients, ensuring data accuracy and completeness. Collected, validated, cleaned, and categorized data from multiple sources to support accurate financial reporting. Performed data reconciliation and discrepancy analysis across multiple data sources to identify and resolve inconsistencies. Prepared financial reports and analyzed transactional datasets using Microsoft Excel. Worked with e-commerce transaction data from Shopify, Amazon, eBay, Klarna, and Clearpay. Collaborated with cross-functional teams to deliver accurate reports within deadlines.