Overview
Summary
Skills
Work History
Education
Additional Information
Timeline
Sithara Sreeramachandra

Sithara Sreeramachandra

Graduate Business Analytics Student at UMass Amherst; Looking for Internship/Full-time roles
Amherst,MA

Overview

4
4
years of professional experience

Summary

Hey there!

I am a dedicated data enthusiast with a passion for making a positive impact. Equipped with a Bachelor's degree in Industrial Engineering and Management, along with over four years of experience at esteemed organizations such as KPMG and Groupon, I have honed my skills in transforming raw data into valuable insights. Proficient in SQL, Excel, and Python, I excel at analyzing data and generating meaningful conclusions.

Currently, I am pursuing further academic enrichment at the Isenberg School of Management, complementing my practical expertise with theoretical knowledge. I thrive on solving complex puzzles and navigating through intricate data sets to uncover valuable insights. Whether it involves devising effective strategies or collaborating with peers, I am committed to utilizing my skills to drive tangible results. Currently seeking new opportunities to apply my expertise and contribute to meaningful projects, I invite you to reach out to me at sitharavs1@gmail.com. Let's work together to create something extraordinary!

Skills

  • Programming Languages: T-SQL, Python, R
  • Tools: Tableau; SSIS; Google Sheets; MS – Excel, PPT, Project, Fabric, Power BI; SAP Analytics Cloud; JIRA, Confluence, Trello Boards; Salesforce CRM
  • Skills: Excel (Power Query, Lookups, Analytic Solver); Python (NumPy, Pandas, Matplotlib); Power BI (DAX, Dataflow); SQL(Window Functions, CTEs); Data (Cleansing, ETL, Mining); Tableau (Visualization, Table calculations)
  • Softskills: Attention to detail , Team player, Individual contributor, Quick learner, Adaptable, Problem solving, Critical thinking, Decision making, Time management

Work History

Business Intelligence Analyst

Groupon Shared Services Pvt Ltd
Bangalore, KA
02.2022 - 08.2023
  • Analyzed customer service agent (employees) performance utilizing Google Sheets and Teradata SQL. I performed calculations on key metrics like resolution rate, productivity, and CSAT (Customer Satisfaction) scores. Designed an all-in-one Tableau dashboard for comprehensive employee performance assessment and target alignment with KPIs. This dynamic analysis reduced the manual work by 75% in performance evaluation.
  • Created a dynamic target identification system to adjust monthly goals, alongside a dashboard featuring key metrics like productive task hours, customer satisfaction, productivity, and resolution rate and many other KPIs. Reduced manual labor in updating metrics in multiple places with one data source, and generating comparison reports like Week - on - Week , Month - on - Month automatically.
  • Collaborated with groupon customers and merchants in customer service resolution requests and reported them to stakeholders. Supported strategic decision-making processes by delivering timely and accurate insights from complaint requests and pre-analyzed datasets.
  • Formulated a Teradata SQL-based resolution rate algorithm for merchant operations, leveraging historical data. The algorithm quantified qualitative columns like “status” using binary numbers and summation, resulting in a calculated resolved score. This innovation boosted efficiency by an impressive 60% in targeting open cases and swiftly identifying resolutions.
  • Modeled automated reporting systems in Google sheets to dynamically compute gross profits from coupon sales, differentiating between periods before and after promotional campaigns. This process was completely automated in terms of data loading, transformation and building final calculations.
  • Designed a Tableau dashboard tailored for phone channel customer service agents, enabling an in-depth analysis of calls handled, call resolutions times and speed to answer metrics to evaluate productivity performance of customer service agents.
  • Streamlined reporting processes for increased efficiency and accuracy with the development of productivity and performance dashboards.

Data Analyst

KPMG Global Delivery Center
Bangalore, KA
07.2019 - 02.2022
  • Developed SQL stored procedures for automated audit calculations, troubleshooting, and adapting scripts for unstructured data challenges and produced detailed financial reports to analyze O2C &P2P process. This increased the report generation efficiency by 30%.
  • Built 'Capacity Planning Dashboard' in Power BI to monitor server storage, track client progress and analyze client capacity, which reduced manual file searches for clean-up by 90%
  • Devised a Power BI dashboard with a macro-enabled data entry system to monitor COVID-19 cases among employees, facilitating resource tracking, recovery time analysis, and analyzed insurance enrollment trends
  • Performed UAT (User acceptance testing) on KPMG Clara tool which is a collaborative frontend - backend platform for automated audit analysis.
  • Guided junior data analysts from non-STEM backgrounds regarding understanding & interpreting financial data alongside using Microsoft SQL Server and querying T-SQL.
  • An audit filing season is a "Busy season" with workload of over 12 hours a day. Involved myself in an effectively fast-paced environment during USA's audit filing busy season in the months of January, February & March for the years 2020, 2021 and 2022. I was also given "SPOT" award for my productivity in actively analyzing high volumes (over 5 million record transactions) efficiently during the busy season.

Market Research Intern

Mindtree
Bangalore, Karnataka
06.2018 - 07.2018
  • Developed a comprehensive business model leveraging SWOT Analysis, value propositions, and revenue stream mapping to establish a herb-based manufacturing venture specializing in medicinal products, as part of a Corporate Social Responsibility (CSR) initiative endorsed by the Maharashtra Government in India.
  • Conducted extensive product-market research to identify market opportunities, competitive advantages, and potential challenges, ensuring alignment with both business objectives and societal needs.
  • Collaborated with stakeholders and experts in the field to ensure the viability and sustainability of the proposed business model, integrating ethical and environmental considerations into the framework.
  • Explored innovative strategies to maximize social impact and community engagement, emphasizing the importance of holistic development and sustainable practices in business operations.
  • Developed frameworks for monitoring and evaluating the social and economic impact of the initiative, aiming to establish benchmarks for success and continuous improvement.

Quality Control Analyst Intern

Volvo
Bangalore, Karnataka
06.2017 - 07.2017
  • Utilized quality control tools including scatter plots and fishbone diagrams to conduct root cause analysis, identifying and addressing field failures of on-site excavators.
  • Collaborated with cross-functional teams to gather data and insights, fostering a comprehensive understanding of the underlying issues contributing to equipment and component malfunctions.
  • Implemented corrective actions based on root cause analysis findings, aiming to improve the reliability and performance of on-site excavators and reduce downtime.
  • Developed preventive maintenance strategies to mitigate future failures, incorporating predictive analytics and condition monitoring techniques to enhance equipment reliability.
  • Established continuous improvement processes to systematically address emerging issues and drive innovation in equipment design and maintenance practices.

Education

Master of Science - Business Analytics

University of Massachusetts Amherst, Amherst, MA
08.2023 - Current
  • Currently holding 3.94/4 Grade Point Average (GPA)
  • Completed the below courses -

1. Data Management for Business Leaders (SCH-MGMT 601)- Coursework - Use of MS Excel and learn to load and wrangle data using basic IF's and aggregate functions, Lookup formulas, Pivot tables, Power Query and Power Pivot, VBA-Macros.

2. Business Intelligence & Analytics (SCH-MGMT 602) - Coursework - Use of MS Access to understand SQL and data normalization.

3. Data Science for Business Leaders (SCH-MGMT 657) - Coursework - Predictive Modeling(Supervised Segmentation & Logistic Regression), Classification, Clustering, Model Performance Analysis, Exploratory Data Analysis along with case studies.

4. Statistics for Business (SCH-MGMT 650) - Coursework - Probability Distributions, A/B testing case examples, Hypothesis Testing, Sampling, Normal Distributions, ANOVA, Simple & Multiple Linear Regression

5. Project Management (SCH-MGMT 656) - Project management techniques, terminology and trends, define project success
measures and methods, analyze quality, cost and efficiency with the project management process. Case study on being a hypothetical project manager, how would I handle the situation - using Microsoft Project software.

6. Data Mining (SCH-MGMT 655) - Coursework - Data retrieval, manipulation and visualization. Machine learning techniques like classification, prediction, time-series forecasting, cluster analysis, kNN, decision trees. Neural Networks. Use of statistical analysis in predictive modeling and hands on case study for each topic.

7. Business Application Development (SCH-MGMT 609) - Coursework - Introduction to python - lists, tuples, conditional statements and loops, json requests to extract data from web, Querying databases using python, Cleaning and manipulating data with NumPy and Pandas, Data visualization using Matplotlib and Seaborn libraries. Linear Modeling with scipy library and statsmodels using Simple Regression, Multiple Regression.

8. Web-Analytics (SCH-MGMT 662) - Coursework - Fundamentals of digital marketing and web analytics, case studies on understanding search engine optimization (SEO), search
engine marketing (SEM), and display advertising. Understand and implement KPIs in marketing campaigns.

  • Professional Development: "Career Pro & Development" course that prepares us with importance of resume building, cover letter, framing LinkedIn profiles and networking activities and team building.
  • Relevant Academic Projects (Master's Coursework) -

1. Built a manual entry macro in MS Excel using VBA functionality where we enter the details of a location with its latitudes and longitudes and solve traveling salesman problem in calculating shortest and efficient route.

2. Analyzed Adidas sales dataset to identify the particulars of which products contribute to 20% of sales that give 80% of profits using pareto analysis considering parameters like gender, product category, location, discount percentage. Evaluated seasonal trends and performed time series forecasting to predict sales of each product category in major cities.

3. Developed a forecasting model utilizing Bayesian probabilistic concepts and regression analysis to predict the chances of surpassing the Dow Jones Industrial Average stock rate beyond 40,000.

4. Utilized classification analysis techniques, including K-Means clustering, Random Forest, and Naive Bayesian models, to comprehensively assess various approaches for automating the evaluation of customer eligibility, aiming to predict loan approvals and denials with precision and efficiency.

5. Use of Google Analytics and Google Ads to measure website and ad campaign performance.

6. Crafted a comprehensive project spanning from conception to execution for an AI Marketing tool launch, meticulously planning and distributing resources across planning, design, business, sales, and software development over a one-year timeline, utilizing Microsoft Project for resource and budget allocation, while also creating project charters and interim closeout reports.

7. Deployed the Zomato restaurant dataset within the R Studio environment and SAP Analytics Cloud to predict the average cost incurred by two individuals dining at a restaurant. This predictive analysis factored in various parameters including location, cuisine type, rating, and the number of reviews, enabling a nuanced understanding of dining expenditure trends and customer behavior patterns.

Bachelor of Engineering - Industrial Engineering & Management

BMS College of Engineering (Visveswaraya Technological University), Bangalore, Karnataka, India
08.2015 - 06.2019
  • Secured 8.77/10 Cumulative Grade Point Average (CGPA)
  • Most relevant Analytical Industry based Coursework:

1. Production Technology

2. Industrial Production & Engineering

3. Statistics for Engineers

4. Management & Entrepreneurship

5. Operation Research (Basic - Intermediate - Advanced)

6. Quality Assurance & Control Checks

7. Engineering Economy

8. Product Design & Development

9. Product Management

10. Simulation Modelling & Analytics

11. Financial Account & Costing

12. Productions & Operations Management

13. Supply Chain & Logistics Management

14. Decision Modeling Lab

15. Enterprise Resource Planning (ERP)

16. Total Quality Management

17. Industrial Design & Ergonomics

18. Lean Manufacturing - Six Sigma

19. Project Management

  • Most relevant industry related projects -

1. Enhanced the efficiency of a vegetable vendor's supply chain by leveraging WhatsApp as a platform to connect with daily customers, facilitating continuous orders and ensuring consistent sales, while also establishing a network with customers to foster better relationships. Additionally, utilizing WhatsApp reduced physical strain by minimizing time spent pushing carts. Moreover, this method facilitated informed procurement decisions by providing insights into supply and demand dynamics, while also offering detailed data on WhatsApp regarding quantities, prices, and payments, streamlining overall operations.

2. Created and engineered an innovative groundnut pod plucking device. Successfully constructed a functional prototype, demonstrating a remarkable efficiency rate of 92% in reducing time consumption. Conducted in-depth analysis of the product development life cycle, ensuring alignment with customer needs and preferences. Employed cutting-edge technologies and materials to optimize performance and durability, resulting in a highly competitive and marketable solution.

Additional Information

AWARD - Spot award for Efficient Performance during FY21 Busy Season in KPMG Feb 2021

Timeline

University of Massachusetts Amherst - Master of Science, Business Analytics
08.2023 - Current
Business Intelligence Analyst - Groupon Shared Services Pvt Ltd
02.2022 - 08.2023
Data Analyst - KPMG Global Delivery Center
07.2019 - 02.2022
Market Research Intern - Mindtree
06.2018 - 07.2018
Quality Control Analyst Intern - Volvo
06.2017 - 07.2017
BMS College of Engineering (Visveswaraya Technological University) - Bachelor of Engineering, Industrial Engineering & Management
08.2015 - 06.2019
Sithara SreeramachandraGraduate Business Analytics Student at UMass Amherst; Looking for Internship/Full-time roles