Excel
Projects
PowerBI
Projects
SQL
Projects
Me
Hello! I'm Ravi Singh, I have a strong passion for data-driven work, which fuels my desire to uncover insights that drive strategic decision-making. In my current role as a Transaction Risk Investigator and Trainer at Amazon, I analyze transaction patterns to identify risks and enhance operational efficiency.
This experience has equipped me with robust analytical skills and proficiency in SQL and data visualization tools, allowing me to transform complex datasets into actionable strategies. I believe my background in risk investigation will provide valuable insights into data integrity and performance optimization, making me a strong asset to your team.
Skills
MySQL
Excel
PowerBI
Complaince management
fraud investigation
mentoring
training coordiantion
team building
Projects
Domain/Function: Brick and Mortar
This project provides an in-depth analysis of the company's financial health and market position, generating reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using both fundamental and advanced Excel techniques.
Domain/Function: Restaurant/Hospitality
Developed an Excel dashboard to analyze sales for a coffee brand chain, showcasing advanced Excel skills. Integrated data from various sources with dynamic charts and graphs to illustrate trends, top-selling products, and store performance. Used pivot tables and slicers for effective data analysis,
Domain/Function: Brick and Mortar
Created a Power BI report for Atliq Hardware, analyzing sales, financial performance, and marketing effectiveness. Visualized sales trends, assessed financial metrics, and evaluated marketing strategies across markets. Used interactive visuals and filters to deliver comprehensive insights.
Domain/Function: e-commerce
Developed a Power BI report for Zomato, analyzing sales trends, order volumes, customer gains, and city performance over the years. Used interactive visuals, complex data models, and dynamic filters to visualize revenue patterns, order trends, and city-specific metrics, enabling data-driven decision
Domain/Function: Brick and Mortar
This project conducted a comprehensive sales and financial analysis of Atliq Hardware Company using SQL queries to extract, manipulate, and analyze data from their sales database. The objective was to gain insights into sales performance, identify trends, and assess financial health over time.
Domain/Function: Restaurant/Hospitality
this project performed a detailed sales analysis of various pizza types using SQL queries to extract and analyze data from a pizza business database. The primary objective was to understand sales trends, customer preferences, and the overall performance of different pizza varieties over time.
Experience
Amazon, Remote - Virtual Customer Associate
July 2022 - October 2022
Amazon, Bengaluru - Transaction Risk Investigator
August 2023 - Present