Yojitha

Results-oriented Data Analyst with 1.5 years of experience in SQL, Power BI, DAX, Power Query, and Advanced Excel. Skilled in data analysis, dashboard development, reconciliation, automation, and business reporting. Possesses strong knowledge of Capital Markets Fundamentals, Trade Lifecycle, Portfolio Analytics, and Financial Data Analysis, with excellent analytical and problem-solving skills.

Quality Associate - Amazon Development Center - Bangalore

(2024-05 - 2025-08)

• Analysed customer, order, and invoice datasets using SQL to identify missing records, duplicate entries, and data inconsistencies, ensuring high data quality.
• Performed data validation and reconciliation across customer, order, and invoice tables using SQL and Excel to verify data accuracy and maintain consistency.
• Developed interactive Power BI dashboards using Power Query and DAX to monitor KPIs including payment success rate, failed transactions, invoice status, and monthly transaction trends.
• Utilized advanced SQL techniques including Joins, CTEs, Window Functions, CASE statements, and Aggregations to extract, transform, and analyze large transactional datasets for business reporting.
• Delivered analytical reports and actionable insights by identifying trends in financial and operational data, supporting data-driven decision-making.
• Maintained data quality through regular audits, reconciliation, and validation of customer, order, and invoice datasets, ensuring reporting accuracy and compliance.
• Automated recurring Power BI reports and KPI dashboards using Power Query and DAX, reducing manual reporting effort and improving operational efficiency.
• Worked with high-volume transactional datasets, applying strong analytical and problem-solving skills to support financial reporting, operational analytics, and process improvements.

Civil Engineering - Civil Engineering - Indian Institute of Information Technologies (IIIT) (2023-05)

PRE UNIVERSITY COURSE (PUC) - Indian Institute of Information Technologies (IIIT) (2019-04)

SECONDARY SCHOOL EDUCATION - Z.P.H School - Gandlapenta (2017-03)