Suruchi Prasad
Canton,MI
Summary
Experienced data analyst with a strong background in data analysis, reporting, and data engineering using Snowflake,Python and various data visualization tools. Proven track record of leading large, complex analytics and reporting projects, delivering actionable insights to stakeholders across all levels. Skilled in data visualization, SQL, Excel, Python, and Azure Analytics tools. Demonstrated ability to apply a customer/stakeholder-oriented focus and user experience design best practices to ensure data analysis is easily consumable through visualization, presentation, and storytelling.
Overview
10
10
years of professional experience
Work History
Senior Associate Consultant
Infosys Limited
12.2021 - Current
- Built out install base information for BSNA, providing valuable insights that empowered senior leadership, including the COO, to make informed decisions on identifying opportunities for contract renewal and determining strategic focus areas for maximizing business growth and revenue.
- Automated a Fire Customer churn model, collaborating with stakeholders to proactively identify at-risk customers and facilitate targeted outreach initiatives. This initiative enabled representatives to engage with customers, understand their concerns, and implement necessary improvements to enhance customer retention and satisfaction.
- Implemented a system to load sales rep quotas into the SFDC portal, facilitating the seamless addition of new reps with updated quota values and enabling the modification of quota values for existing sales representatives while tracking previous changes. This streamlined process supported stakeholders in assisting reps in maintaining their quotas and achieving sales goals effectively.
- Developed a comprehensive contract management view that consolidated contract information from multiple domains and source systems, providing stakeholders with a centralized platform to access all contract details and make informed decisions. Analyzed and integrated data from various source systems, establishing a centralized contract repository for all domains within the BSNA regions
- Obtained data from identified sources and performed data mining, data scrubbing and data engineering to build data insights for stakeholders
- Analyzed and synthesized qualitative and quantitative research findings to identify key market implications and strategic challenges.
- Centralized “Quotes” information for CPQ, Compass, NexGen & Salesforce to streamline the process and improve efficiency in tracking quote-to-win ratios, resulting in a more accurate and data-driven decision-making process.
- Supported PSR Campaign Objectives in BSNA by providing data-driven insights and analysis that optimized campaign strategies, leading to increased engagement and conversion rates.
- Designed and managed the Campaign and Lead object for Blueview, enabling efficient tracking and analysis of campaign performance metrics, which optimized marketing efforts and increased ROI.
BI Data Analyst
AVB Marketing
05.2021 - Current
- Helped resolve issues with data analytics and visual representation to deliver relevant insights to senior business leaders
- Summarized conclusions of business intelligence analyses and presented findings at executive meetings
- Created visual representations of sales over time, top product categories and top SKUs within categories, YOY growth chart, YTD charts using Tableau dashboards to highlight desired aspects of key financial and performance indicators
- Manipulated Tableau parameter controls, actions and filters to achieve LOD expressions and visualize multiple facets of KPI in one comprehensive view
- Worked extensively with Advance analysis tools as well created calculated fields, bins in Tableau to create informative dashboards
- Wrote complex SQL queries in SSMS for manipulating data
- Used Power BI to create multiple dashboard reports for project stakeholders
- Assisted Data engineers in building Data warehouse by troubleshooting and identifying data issues as well as providing solutions to it.
Data Analyst
Great Lakes Ace Hardware
11.2019 - 05.2021
- Maintenance of Databases, ensuring Data integrity and Data Reporting on daily basis
- Compiled and modeled business data using SQL queries in MySQL and MS Access
- Mined data to uncover insights and identify market trends and inflection points
- Created daily, weekly and monthly reports to be delivered to business executives
- Developed SQL scripts for task automation
- Assessed data and identified issues to direct concerns to business unit leadership.
Data Analytics Intern
IHS Markit
06.2018 - 08.2018
- Performed Data Analysis on large volume of data sets for root cause analysis and data comparisons
- Developed Tableau dashboards to present findings
- Used several features like parameters, actions, drill down to build comprehensive views
- Used HIVE to write queries for identifying issues in the data and performed root cause analysis
- Developed and tested logic in SQL, based on detail requirements and design
- Developed business requirements, analysis and structured the business requirements into functional requirements and technical specification
- Work with technical leads to help create Source Data Analysis Documents to capture the requirements necessary to design, build and test a solution and deliver the same to the cross functional teams.
Data Analyst Intern
Gardner-White Furniture
09.2017 - 12.2017
- Pursued Data Analytics project with Gardner-White furniture to improve their Inventory Management System
- Developed user friendly Tableau dashboards to present the data analysis
- Performed Several analyses in sheets using complex calculations, geographical mapping, and parameters
- Applied predictive modelling concepts to help in inventory optimization
- Helped the company to focus on the 20 % of products that generated 80% profits by classifying the products into categories using data analytics
- Sales Forecasting for collections with seasonal trends at Gardner-White for year 2018 using MINITAB.
Data Research Analyst
S&P Global
07.2014 - 03.2016
- Key Driver Analysis Project: Improved trial Client conversion by 10%
- Identified key factors by performing root cause analysis
- Used SQL SERVER database for extracting data and performing analysis
- Conceptualized and led the development of a new team 'Hierarchy Management'
- The team has become an integral unit of the S & P and has been delivering the Corporate Hierarchy based on the company's stakes and investments since
- Provided requirements and evaluation to technical team in designing a tool for automating the process of building hierarchies and thereby increased the productivity of the team by 40%
- Provided Business Intelligence to Clients by conducting secondary research and analysis on the securities issued by the companies listed on the major stock exchanges over the world.
Education
Master of Science, Business Analytics - Business Analytics
University of Michigan
Michigan12.2018
MBA, Finance - Finance
Jaypee Institute of Information Technology
India06.2014
Bachelor of Science, Electronics And Communication Engineering -
Jaypee Institute of Information Technology
India06.2013
Skills
- Data Engineering
- Data Mining and Analysis
- Snowflake (SQL)
- Data Visualization Tools (Tableau, Power BI)
- Python
- Data warehousing
- Data Modeling
- Statistical Analysis
- Agile Methodologies
- Business Intelligence Reporting
- Project Management
Timeline
Senior Associate Consultant
Infosys Limited
12.2021 - Current
BI Data Analyst
AVB Marketing
05.2021 - Current
Data Analyst
Great Lakes Ace Hardware
11.2019 - 05.2021
Data Analytics Intern
IHS Markit
06.2018 - 08.2018
Data Analyst Intern
Gardner-White Furniture
09.2017 - 12.2017
Data Research Analyst
S&P Global
07.2014 - 03.2016
Master of Science, Business Analytics - Business Analytics
University of Michigan
MBA, Finance - Finance
Jaypee Institute of Information Technology
Bachelor of Science, Electronics And Communication Engineering -
Jaypee Institute of Information Technology