Sourav Ray Email & Phone Number

Birmingham, AL, US

Birmingham, AL, US

• Collaborate closely with stakeholders to understand their needs, automating procurement workflows using Tableau Prep and leveraging Tableau for advanced data visualization to enhance efficiency and insight extraction.
• Advanced through a rotational program to the Data and Analytics team, enhancing legacy reports through database integration, SQL query development, and fostering enhanced communication across business units.
• Supported IT modernization efforts by improving data structures and optimizing SQL processes in Snowflake, contributing to key projects that enhanced analytical capabilities.

Addison, TX, US

• Provided primary and secondary research in smart homes and smart entertainment contributing to Parks Associates’ connected consumer research portfolio.
• Identify relationships in data using SPSS, Q, and Excel to research patterns and quantify consumer trends.
• Identified and outlined Product USPs, Competitive Intelligence, and Market Landscape for market assessments.

College Station, TX, US

• Cleaned data from the criminal justice domain and performed feature engineering using R and Python.
• Developed scripts using Tidycensus and Tidyverse and censusgeocode in R and Python to extract and create 20+ variables using https://www.census.gov/
• Extracted geocoding information using the google maps API for defendant addresses for 250+ counties in Texas.
• Summarized and analyzed data using R to develop visualizations using Plotly, to understand effects of policy changes.

Delaware, US

• Forecasted market data by manipulating trends in y – o – y growth and CAGRs. Executed specific go to market strategies for various Fortune 500 clients.
• Gathered, cleaned, and performed quantitative analysis on data from:1. Various databases such as IEA, SIAM, OICA, WorldSteel, IRENA, World Bank, IMF, JRAIA, VDMA, IATA etc using Excel to identify various macroeconomic.
• Analysed qualitative data for outlining market dynamics for clients in the Industrial automation, automotive, and materials domains.
• Prepared customized reports, datasets, graphs, and tables as a part of business and industry analysis reports to meet and support the clients’ business initiatives.
• Trained, mentored, and assisted fellow associates in performing extensive market research.

Delaware, US

• Prepared company analysis reports, end-to-end industry analysis and sizing of Americas, EMEA and APAC markets.
• Assisted senior employees to understand the market potential and scope of market growth for the client’s products/services.
• Analyzed the annual report, balance sheet and the cash flows of a company, conducted SWOT, Porters 5 and PEST analysis, and derived insights using various tools to prepare corporate presentations.
• Worked on individual market research reports in the Automotive and Industrial Automation domain.

Hawthorn East, Victoria, AU

• Collected and built a primary database in excel by data obtained from a footfall study on a luxurious vehicle showroom.
• Preprocessed the data in Microsoft Excel and Python, and subsequently observed trends and patterns, across different variables.
• Prepared major variables affecting footfall, prepare heatmaps and secondary graphs from the data.
• Conveyed the results to stakeholders of MSXI – Sewells.

Pune, Maharashtra, IN

• Conducted a primary (ground field) research regarding the comparative analysis of Tata Motor Limited’s cost of parts of commercial vehicles vis-à-vis those of its competitors.
• Analyzed the data in Excel to prepare a Total Cost of Ownership datasheet/chart for Tata’s light commercial vehicle and similar vehicles manufactured by its major competitors in the market.
• Visited the TML plant in Pune, Maharashtra to understand various aspects of the vehicle manufacturing plan and process as per the customer’s demands.

Bengaluru, IN

• Worked as a technician in the after – sales division in JLR (Jaguar Land Rover) to get hands on servicing experience on top – end Jaguar and Land Rover passenger vehicles.
• Learned about various processes and routines followed in both paid and scheduled servicing on cars.
• Understood how often are cars serviced, and about the average service life of various components in a passenger vehicle.

Master Of Science - Ms, Business Analytics

Bachelor Of Technology - Btech