Shreya Sinha Roy

Shreya Sinha Roy Data Analyst Bangalore, India | - |-| LinkedIn | GitHub Business operations analyst with 3.5 years of software engineering experience, specializing in the financial services sector. The job responsibilities involved enhancing process efficiency and coordinating with internal and external stakeholders. Skilled in SQL, Excel, Python, and Power BI with a customer-first approach to resolving operational issues and optimizing transaction processes. Technical Skills • • • Analytical Tools: Microsoft Excel (Advanced), Power BI Languages: SQL, DAX, Python (Basic) Soft Skills: Communication, Stakeholder Management Work Experience Senior Software Engineer Capgemini India Pvt. Ltd | Bangalore, India | Sept 2021 – Present • • • Operational Leadership: Delivered weekly operational reports to clients in the banking sector, ensuring process enhancements and iterative feedback integration. Stakeholder Management: Established strong communication channels with clients, addressing their concerns promptly to enhance trust and satisfaction. Technical Solutions: Spearheaded the modernization of around 4 client applications, facilitating the shift to a cloud environment, which streamlined operational efficiency. PROJECTS 1. Analysis of Blinkit Data Using Excel: - ( L i n k ) Tools Used: Microsoft Excel Objective: The objective is to comprehensively analyze Blinkit's sales performance, customer satisfaction, and opportunities for optimization using various KPIs and visualizations in Microsoft Excel. Key Insights: • The top-selling categories are Fruits and Vegetables, and Snack Foods, each generating $0.18M in sales. • Tier 3 cities are driving the maximum sales of the company whereas tier 1 cities are at the minimum. • Despite being a crucial category, Health & Hygiene serves only 520 different items and derives sales of $0.07M only. 2. National Fuel Market Analysis Using Power BI: - (Link) Tools Used: Power BI Objective: This data analysis project is designed to investigate the trends and fluctuations of fuel prices across Argentina during the last few years, focusing on various fuel types and sellers. Key Insights: • The average price of Gasoil Grade 2 across all provinces lies below 0.4k$ • 4 different types of products are sold by the company "AUTOMOVIL CLUB ARGENTINO". • Among all the products, Gasoil Grade 3 has the highest sales which is around 3117.26k. 3. Analysis of Sales Data for a Merchandise Brand: - (Link)(Presentation) Tools Used: Microsoft Excel Objective: Imagine Ankur Warikoo and his team are set to launch a global brand named Warikoo’s Wonderland, which will offer a range of merchandise and ornaments. The purpose of this project is to analyze the sales data of this brand for 2023-24. Key Insights: • • • Quality Concerns: A significant 75% of clothing products are receiving negative reviews due to poor quality. This is a critical area that requires immediate attention to enhance customer satisfaction and loyalty. Demographic Insights: The primary customer base consists of young adults aged 20-35, particularly those who have recently entered the workforce. This demographic should be a focus for tailored marketing campaigns. Product Category Performance: The clothing category drives the majority of sales, indicating its importance to the brand’s overall performance. 4. Danny’s Diner SQL Case Study: - (Link) Tools Used: MySQL Workbench Objective: Analyzed transactional data to provide insights into customer behavior, spending patterns, and popular menu items at Danny's Diner. Key Insights: a. Identified top-spending customers and their favorite menu items. b. Provided recommendations on menu optimization and targeted promotions based on customer preferences. Courses & Certificates • • • • Power BI A-Z: Hands-On Power BI Training for Data Science! (Udemy) The Complete SQL Bootcamp: Go from Zero to Hero (Udemy) Excel Basics for Data Analysis (Coursera) SQL Basic Certificate (HackerRank) EDUCATION ● Techno International New Town, Kolkata Master of Computer Application (MCA) - ● Vidyasagar College (University of Calcutta) Bachelor of Science (Computer Science Hons) -