Data Analyst - Amazon Transaction & RCA

PRIYANSHU SIROHI

Uttar Pradesh, India +91-706******* **********@*****.***

PROFESSIONAL SUMMARY

Detail-oriented Data Analyst with a strong foundation in data interpretation, pattern recognition, and process analytics. M.Com (Finance) graduate with hands-on experience in transaction analysis, root cause analysis, and business insights generation. Skilled in Excel, SQL, and Python for data manipulation and reporting. Adept at translating complex datasets into actionable recommendations for stakeholders.

PROFESSIONAL EXPERIENCE

Concession Abuse Prevention Associate Amazon 2023 – 2024

Handled large volumes of customer transaction data to detect behavioural anomalies, refund abuse patterns, and risk signals — supporting data-driven decision-making across operations.

Built and maintained structured data reports and dashboards to track KPIs including resolution rates, SLA compliance, and case volume trends.

Conducted root cause analysis (RCA) on recurring transaction irregularities, generating insights that contributed to process improvements and a measurable reduction in case recurrence.

Documented case outcomes and analytical findings using internal case management tools, ensuring data integrity and audit-ready reporting.

Consistently exceeded productivity, quality, and accuracy targets in a high-volume, deadline-driven analytical environment.

TECHNICAL SKILLS

Data Tools & Analytics: Microsoft Excel (Advanced), Google Sheets, SQL (Querying & Data Manipulation), Python (Pandas, NumPy — Foundational)

Visualisation & Reporting: Power BI (Foundational), Excel Charts & Pivot Tables, Data Dashboards, Structured Reporting

Analytical Methods: Root Cause Analysis, Pattern Identification, Transaction Analysis, KPI Tracking, Process Efficiency Analysis, Data Quality Control

Soft Skills: Stakeholder Communication, Data Storytelling, Cross-functional Collaboration, Attention to Detail, Deadline Management

PROJECT

Sales, Purchase & Inventory Management Dashboard (Microsoft Excel)

Designed and developed an interactive Excel dashboard to automate and streamline sales, purchase, and inventory tracking processes.

Utilized Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, IF, SUMIFS, COUNTIFS, INDEX-MATCH, and Conditional Formatting to analyze and visualize business data.

Automated data consolidation and reporting, reducing manual effort and improving reporting accuracy.

Implemented interactive slicers and filters to enable real-time data exploration and decision-making.

Developed automated inventory tracking mechanisms to identify low-stock items and maintain optimal stock levels.

Generated monthly and quarterly reports, providing actionable insights for business operations and management.

Improved data accuracy, reporting efficiency, and overall visibility into business performance through automation and dashboard-driven analytics.

EDUCATION

Master of Commerce — Finance (M.Com) 2022 – 2024

Relevant: Financial Accounting, Corporate Finance, Banking & Credit Management, Financial Statement Analysis Bachelor of Commerce (B.Com) 2019 – 2022

Relevant: Accountancy, Business Finance, Auditing, Economics, Business Law

Contact this candidate