Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic

Abhinav Yalamanchili

Canadian Citizen

Summary

Results-driven Business Analyst with 3+ years experience in data analysis, forecasting, and dashboard creation using Excel, Tableau, and Power BI. Proficient in gathering business requirements, managing data, and providing actionable insights to facilitate decision-making across diverse therapeutic areas. Skilled in utilizing JIRA/Confluence for project coordination and agile methodologies, with a focus on enhancing process efficiency and forecasting accuracy.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Business Analyst

Scarsin Corporation
10.2022 - Current
1. Patient-Based & Prescription Forecasting:
  • Forecasted patient and prescription trends across 10+ therapeutic areas, contributing to accurate revenue projections and strategic planning.
  • Collected and analyzed patient-level data from multiple databases, improving the precision of patient-based forecasts by 20%.
2. Excel Dashboard Development & Reporting:
  • Developed and tested user-friendly Excel dashboards to communicate key performance indicators (KPIs) and risk potential to brand managers and business leaders, reducing report preparation time by 30%.
  • Created scenario-based models that helped portfolio managers and manufacturing controllers make data-driven decisions, increasing forecast adoption by 15%.
3. Business Development & Revenue Forecasting:
  • Supported business development forecasting exercises, identifying potential revenue opportunities and assessing cost implications, resulting in a 25% improvement in early-stage financial assessments.
  • Reconciled forecast assumptions with analyst and modeller reports, reducing data discrepancies by 10% and ensuring alignment with secondary data sources.
4. Data Management & Reporting Solutions:
  • Managed data analysis, transformations, and loading into forecasting solutions, streamlining data processing and improving reporting accuracy by 20%.
  • Created PowerPoint presentations for client teams, tailored to specific business needs, enhancing client satisfaction scores by 10%.
5. System Testing & Training:
  • Supported solution testing and dashboard development, ensuring system reliability and reducing post-launch issues by 15%.
  • Trained 30+ users on forecasting and reporting solutions, increasing system utilization across departments by 25%.

Business Analyst

N. Harris Computer Corporation
04.2022 - 09.2022

1. Requirements Gathering & Analysis:

  • Facilitated requirements-gathering sessions with business stakeholders and clients, identifying process gaps that led to a 20% improvement in project delivery accuracy.
  • Translated business requirements into functional specifications, reducing rework time by 15% and ensuring clearer communication across teams.

2. Data Analysis & Reporting:

  • Analyzed customer usage data, providing actionable insights that contributed to a 10% increase in customer retention.
  • Automated 30+ recurring reports, cutting manual reporting time by 50% and increasing report accuracy by 25%, driving more informed business decisions.

3. Process Improvement:

  • Optimized end-to-end business processes, reducing cycle time by 30% through workflow automation and enhancing overall operational efficiency.
  • Implemented process changes that decreased service ticket resolution time by 20%, resulting in a 15% improvement in customer satisfaction scores.

4. Project Management:

  • Led cross-functional project teams to deliver projects on time and under budget, achieving a 95% on-time delivery rate.
  • Utilized Harris's project management modules to track progress, reducing scope creep by 25% and aligning project outcomes with client expectations.

Forecast Analyst

Scarsin Corporation
08.2021 - 03.2022
1. Data Collection & Analysis:
  • Collected and analyzed over 500 data points weekly on COVID-19 trends and intelligence, identifying key drivers to support accurate pandemic forecasting.
  • Conducted root-cause analysis on major forecast variances, reducing discrepancies by 25% through identification of trends and corrective actions.
2. Forecast Development & Accuracy:
  • Developed and maintained sales and health forecasts with an accuracy rate of 90%+ by gathering, validating, and analyzing comprehensive data.
  • Improved forecast accuracy by 15% through collaboration with cross-functional teams and building a centralized repository for forecasting and risk analysis.
3. Stakeholder Collaboration & Reporting:
  • Collaborated with stakeholders to establish measures for forecast accuracy and bias, ensuring alignment on key forecasting metrics.
  • Prepared and presented detailed forecast review reports to senior management, driving actionable changes based on forecast reviews.
4. Process Optimization & Implementation:
  • Identified and led opportunities to improve forecast accuracy, resulting in a 20% reduction in forecasting errors through the implementation of new methodologies.
  • Developed and updated Standard Operating Procedures (SOPs) and system documentation, ensuring adherence to company standards.
5. Training & System Enhancement:
  • Trained 50+ users on COVID forecasting systems, enhancing system adoption and usage across departments.
  • Collaborated with technical teams to integrate COVID intelligence into forecast models, streamlining the forecasting process for better decision-making.

Research Analyst /Co-op

Workplace Safety Insurance Board
05.2020 - 04.2021

1. Research & Development:

  • Led a research project from inception, developing an automated solution to detect Noise-Induced Hearing Loss (NIHL) using audiogram data, delivering the final product within 6 months.
  • Conducted comprehensive research on NIHL, identifying key patterns and trends that contributed to a 30% improvement in diagnostic accuracy.

2. Data Analysis & Automation:

  • Developed data models and algorithms to automate the analysis of audiogram data, reducing manual analysis time by 40% and improving the overall efficiency of the process.
  • Performed in-depth investigative analysis on audiometric datasets, ensuring accuracy and validity of results, which increased the precision of hearing loss detection by 20%.

3. Agile Project Management:

  • Collaborated with cross-functional teams in a SCRUM environment, ensuring timely delivery of project milestones and maintaining a 95% on-time completion rate across sprints.
  • Facilitated sprint planning and daily stand-ups, ensuring alignment of tasks with deadlines and mitigating any potential blockers that could hinder progress.

4. Stakeholder Collaboration:

  • Worked closely with stakeholders to define project scope and expectations, integrating feedback into the research process to align with business goals.
  • Delivered presentations and reports on the progress and outcomes of the research, enhancing stakeholder confidence in the project by 15%.

5. Innovation & Process Improvement:

  • Identified opportunities for further automation in audiometric testing, leading to a proposal for a new solution that could reduce overall process time by 25%.
  • Contributed innovative ideas that were later adopted into the company’s product roadmap, leading to increased interest in automated health solutions.

Education

Masters of Engineering - Electrical and Computer Engineering

Carleton University
Ottawa, Canada
04.2021

Bachelor of Engineering - Electronics and Telecommunication Engineering

Symbiosis Institute of Technology
Pune, India
05.2018

Skills

  • Tableau
  • Advanced Excel
  • Python
  • R
  • Power BI
  • MySQL
  • MS Office
  • Google Analytics
  • JIRA/Confluence

Accomplishments

    1. Automating the process of Noise Induced Hearing Loss from audiogram Data (R and Python)

  • Taking the audiogram input as image and coming up with a Json file containing the symbol locations as output.
  • Image was resized at various factors for OCR to detect as many labels as possible.
  • Mapping of labels to the closest lines and deriving linear equations.
  • Detection of symbols and converting the pixel values to coordinate values and generating a Json file as output.
  • Academic Projects

    1. Generating Insights from Diabetes Patients dataset (R and Python)

  • Evaluated, cleansed, and analyzed Diabetes Patients dataset to generate fundamental insights based upon different column values.
  • Calculated correlation to identify which columns are most important for analysis.
  • 2. Stock Pricing and Prediction (R and Python)

  • Used deep learning to predict future stock trends and gathered meaningful insights like stock variations as per the stakeholder requirements.
  • 3. Brain Tumor Detection (MATLAB)

  • Converted MRI scans into grayscale images and picked up images with contours to identify whether the tumor is cancerous or benign or malignant.
  • 4. ECU Tuning (Arduino)

  • Tuned the ECU of Duke 390 by collecting data from various sensors like Hall sensor, Coolant sensor, Vehicle Speed Sensor, Fuel Temperature Sensor to improve engine performance.

Certification

Diploma in Business Management, Symbiosis Institute of Business Management, Operations Management, Financial Accounting, Marketing Management, Entrepreneurship, HR Management

Languages

English
Native or Bilingual
German
Elementary

Timeline

Business Analyst

Scarsin Corporation
10.2022 - Current

Business Analyst

N. Harris Computer Corporation
04.2022 - 09.2022

Forecast Analyst

Scarsin Corporation
08.2021 - 03.2022

Research Analyst /Co-op

Workplace Safety Insurance Board
05.2020 - 04.2021

Masters of Engineering - Electrical and Computer Engineering

Carleton University

Bachelor of Engineering - Electronics and Telecommunication Engineering

Symbiosis Institute of Technology
Abhinav Yalamanchili