Aishwarya Khinvasara

Data Analyst

Gridlogics•  November 2020 - November 2021

Centralized data from multiple vendors into a unified database through SQL queries, ensuring efficient preprocessing. Conducted thorough patent research to extract relevant information, expanding the database. Collaborated with clients to understand their requirements, utilizing the in-house Patseer tool for thorough data analysis. Generated monthly PowerPoint decks using key performance indicators (KPIs), offering tailored solutions to address client-specific problems. Guided extensive projects, foreseeing challenges in mapping out steps from one point to another. Presented impactful solutions by leveraging SQL data analysis and effectively communicated the analysis and decisions to business teams and executives through verbal, visual, and written channels. Balanced between strategic and detailed levels to address data-related needs, seamlessly transitioning to a long-term perspective. Generated concise reports encompassing finance, risk, and revenue generation while leading a team. Cooperated with cross-functional teams to establish success criteria and assessment metrics for product features, leading to the implementation of automated workflows and a notable 18% reduction in workload.

Business Anaylst

ZS Associates•  March 2018 - January 2019

Performed SQL based analytical operations on critical dimensions to identify potential hospitals/physicians. Provided data-driven recommendations to expedite the targeting process for client sales representatives, resulting in 10% cost savings for clients. Explore experiments, amplify insights, and embrace the intricacies of navigating diverse routes without relying on a single definitive database for patients across various cancer stages. Equipped the team with multiple datasets to implement machine learning algorithms, enabling the development of forecasting models to anticipate the condition of cancer patients. Defined performance metrics for drugs in accordance with client specifications. Conducted quantitative analysis on sales, pricing, and market trends for both the client and its competitors' drugs. Developed Tableau reports to present findings to top tier management and clients, supporting the strategic planning of marketing policies. Examined patient data across the disease timeline using SQL and produced drug consumption patterns using Tableau.