Nandita Ganesh

513-***-**** • ad4u20@r.postjobfree.com • LinkedIn

Open for Internship & Full-Time opportunities starting May 2024 PROFESSIONAL SUMMARY

Experienced Business Intelligence Analyst with 3 years of expertise in ETL, SQL, Tableau, Power BI and MicroStrategy. Proficient in data analytics and visualization, delivering strategic solutions and optimizing operational efficiency. Seeking Business Intelligence and Analytics roles to drive impactful outcomes and create value for stakeholders. EDUCATION

University of Cincinnati, Carl H. Lindner College of Business Aug 2023 - Aug 2024 Master of Science, Business Analytics CGPA 3.97

Vellore Institute of Technology (VIT), School of Bio Sciences and Technology Jun 2016 - Jun 2020 Bachelor of Technology, Biotechnology CGPA 3.71

WORK EXPERIENCE

Business Intelligence Analyst Cognizant Aug 2020 – Jun 2023 Banking and Finance – Standard Chartered Bank

• Led end-to-end project development, from requirements gathering to implementation and delivery, in APAC region, assessing asset management and security risks in banking. Collaborated with cross-functional teams to identify and address challenges.

• Leveraged SQL and MicroStrategy to track escalated risk tickets, deriving actionable KPIs like total reported risks, resolution time, and breach identification. Achieved 12% backlog reduction by determining strategic measures to overcome blockers.

• Streamlined risk categorization to reduce 15% misclassification in high-risk vulnerabilities. Reported findings to stakeholders, showcasing data visualization skills and technical-to-business translation. Luxury Retail – DFS Group

• Applied agile methodology to update 2017 analytic reports for luxury retail client, improving accuracy by 20% through analysis of customer loyalty points program changes. Conducted in-depth customer data analysis to identify growth opportunities.

• Created new metrics using SQL to reflect customer membership hierarchy, sales type distinctions, retention rates, and redemption metrics. Quantified impact on revenue and satisfaction.

• Optimized regional sales reporting in MicroStrategy, enhancing decision-making by 10% and identifying and rectifying a sales gap worth $2M. Collaborated on tailored documentation aligned with business objectives. Pro Bono Healthcare Analyst Consultant Dakshas Healthcare Ecosystem Aug 2021 - Jan 2022

• Achieved a 16% reduction in healthcare costs compared to primary private healthcare services by spearheading the development of KPIs to assess COVID-19 status in rural regions of India. Quantified vaccination rates, mask and testing kit availability, and healthcare personnel proximity.

• Executed a zip code mapping initiative, collaborating with on-ground NGOs to collect and analyse data efficiently using Google Analytics and Excel. Used Tableau to design a dashboard for identifying gaps in COVID resources.

• Developed a network of secondary healthcare providers to optimize unused capacity for treating marginalized patients. Successfully mapped 5% of marginalized patients to the nearest available healthcare providers, advancing equitable healthcare access.

ACADEMIC PROJECT

Risk Scoring Model Great American Insurance Group Jan 2024 – Apr 2024

• Led data analytics and visualization project aimed at enhancing the property insurance underwriting risk model, focusing on stakeholder engagement and data analysis to optimize risk scoring.

• Engaged stakeholders to understand business requirements and employed metrics such as loss ratio, claim frequency, and profit margin to pinpoint key factors affecting model efficacy.

• Utilized SQL, Excel, R, and Tableau to analyse a decade of historical data, resulting in a model achieving over 70% predictive accuracy. Optimized underwriting strategies with a focus on risk aversion. SKILLS

• R, Python, SQL, MicroStrategy (ANL Certification), Tableau, Power BI, Microsoft Excel

• Data wrangling, data cleaning, data management, ETL, data mining, data, analysis, descriptive statistics, pivot tables, statistical modeling, hypothesis testing, regression analysis, time series forecasting, data visualization, DAX, data validation, scoping business requirements, end-to-end project development, JIRA, stakeholder engagement.