Gorla Swetha

Gorla Swetha

Data Analyst
India
منفتح على العروض
Full-time Remote

نبذة عني

Data Analyst with 2+ years of experience at Flipkart in a high-volume e-commerce environment, supporting data analysis, reconciliation, data validation, KPI reporting, and process automation. Skilled in SQL, PL/SQL, Pyth…

الخبرة

Data Analyst

Flipkart Pvt. Ltd. · Bengaluru, India
Oct 2024 - حتى الآن · 2 سنوات 1 شهر

<p>Analyzed high-volume operational and financial datasets using SQL and PL/SQL to identify anomalies, discrepancies, reconciliation gaps, and recurring data-quality issues.</p><p> Performed root-cause analysis on receivables-to-payment matching issues and developed automated PL/SQL solutions using analytical window functions to track running totals and improve reconciliation accuracy.</p><p> Designed multi-tier data-quality validation logic, including Invoice-to-Payment and Credit-to-Debit matching, to ensure accurate, consistent, and auditable analytical outputs.</p><p> Automated audit reporting using Oracle UTL FILE and maintained structured issue tracking through ServiceNow to support timely investigation and resolution of data issues.</p><p> Reduced manual reconciliation effort by approximately 40 hours per month through automation and improved data-validation controls.</p><p> Profiled, cleaned, and validated high-volume datasets from internal ledgers, external payment gateways, and tax deduction records to identify anomalies, inconsistencies, and data-completeness issues.</p><p> Developed dynamic netting and reconciliation calculations to identify Excess/Short cases and support KPI, operational, and financial reporting.</p><p> Investigated data discrepancies and communicated root-cause findings to business and technical stakeholders to support remediation and month-end closure activities.</p><p> Prepared analytical reports and ad-hoc data extracts to support business decision-making and operational monitoring.</p><p> Reduced manual review effort by approximately 20 hours per month through automated reconciliation and improved data-quality controls.</p>

المشاريع

B2C Payment Reconciliation & Data Quality Automation

Flipkart Pvt. Ltd.
المدة : 03-Oct-2024 - 30-Sep-2026

<p>Developed and supported a data reconciliation and validation solution for high-volume B2C payment data using SQL and PL/SQL. Analyzed data from internal ledgers, payment gateways, and tax-related records to identify anomalies, discrepancies, and Excess/Short cases. Performed root-cause analysis on data mismatches, implemented validation and reconciliation logic, and automated reporting processes to improve data accuracy and reduce manual review effort. Worked with business and technical stakeholders to investigate issues and support operational and month-end reporting.</p>

الشهادات

Microsoft Power BI Desktop for Business Intelligence

udemy · Bengaluru , Karnataka , India · 2026

المهارات

SQL PL/SQL Python Advanced Excel Data Cleaning Data Profiling Power BI QlikView Dashboard Reporting KPI Reporting Data Visualization Data Preparation Data Modelling Power Query DAX Dashboard Development Data Validation Data Quality Analysis Anomaly Identification Reconciliation Analysis Root-Cause Analysis Data Accuracy Machine Learning Concepts Report Automation Trend Analysis Metrics Reporting Ad-hoc Analysis Audit Reporting Oracle ServiceNow Stakeholder Communication Problem Solving Documentation Attention to Detail Collaboration Adaptability
الإبلاغ عن هذا الملف الشخصي؟