Abinaya Lakshmipathy
Hyderabad
Summary
Results-driven Lead Data Analyst with 9+ years of experience in data analytics, business intelligence, and data visualization. Expertise in Tableau, Power BI, Python, and SQL, delivering high-impact dashboards and analytical solutions for leadership and global stakeholders. Proven track record of improving reporting efficiency, including reducing report generation time by 50% through SQL optimization and AI-assisted development tools. Experienced in designing AI-driven solutions and building AI agents using LLMs and MCP frameworks to automate data querying, reporting, and analytical workflows. Skilled in transforming complex data into actionable insights to support strategic decision-making, operational efficiency, and healthcare analytics initiatives. Seeking to leverage advanced analytics, AI-driven automation, and leadership capabilities in a Data Analytics or Business Intelligence leadership role.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Visualization & Reporting Analyst Level II
Bristol Myers Squibb Pvt Ltd
01.2024 - Current
- Optimized data integration from multiple sources such as IQVIA and DEL layer by developing advanced SQL queries and Python scripts, enabling efficient analysis of product data from AWS Redshift and MySQL to assess commercial impact across global regions.
- Collaborated with global stakeholders across US, Spain, Italy, UK, and Japan to gather business requirements and deliver actionable insights on sales performance, market trends, and patient journeys, ensuring alignment with business objectives.
- Ensured data accuracy, security, and regulatory compliance by implementing robust validation frameworks and adhering to standards including HIPAA.
- Designed and developed interactive dashboards and enterprise reporting solutions using Tableau, Power BI, and Excel, enabling business users to make data-driven decisions.
- Played a key role in the migration and optimization of enterprise dashboards during the transition from Tableau to Power BI, improving report performance, optimizing DAX measures, and redesigning data models to enhance scalability and maintainability.
- Demonstrated strong programming expertise in Python, SQL, and data modeling, developing automation scripts and reusable components to streamline data processing and reporting workflows.
- Developed Python-based applications using Plotly Dash to build advanced, interactive analytical tools for data visualization and business reporting.
- Converted Tableau Prep workflows into optimized Databricks pipelines, improving data processing efficiency and enabling scalable cloud-based data transformation.
- Utilized Databricks for big data processing, ETL development, and performance optimization, supporting large-scale analytics initiatives.
- Coordinated with clinical and commercial teams to track product performance, sales trends, and patient journeys across US and global pharmaceutical markets.
- Built AI agent-based solutions based on business requirements to support intelligent data querying, automation, and analytical workflows.
- Developed a successful AI-powered analytics dashboard from scratch using ThoughtSpot for EX-US markets, enabling natural language querying and AI-driven insights for global business users.
- Led a 6-member analytics team, managing project planning, sprint execution, and task tracking using JIRA, ensuring timely delivery of analytics solutions.
- Enhanced data integrity and governance by applying meticulous attention to detail when reviewing and analyzing data maintenance and validation processes.
Data Analyst (Subscription & Retention)
DAZN Software Pvt Ltd
08.2023 - 12.2023
- Analysed customer data from Snowflakes to evaluate the impact of email and push notifications on subscriber engagement across multiple regions.
- Collaborated with global stakeholders (US, Spain, Italy, UK, Japan) to gather business requirements and deliver insights on customer subscription and retention.
- Performed churn and retention analyses to support strategic decision-making in diverse markets.
- Developed comprehensive reports using Excel, PowerPoint, Power BI, and Looker to communicate key performance metrics.
- Leveraged SQL to build and optimize datasets, ensuring efficient data querying and analysis.
- Processed and visualized Snowflake data to provide clear insights into customer events and relationships.
Data Analyst
Accellor Software Pvt Ltd (PopcornApps Software Pvt Ltd)
04.2022 - 08.2023
- Migrated Ericsson and Nokia ticketing system data from MS SQL Server to Salesforce using DQL queries and automated loading tools.
- Transformed and cleansed data with Python (Pandas, NumPy, Simple Salesforce) and Excel to support seamless data integration.
- Configured Salesforce environments by creating permission sets and migrating customer MDM to Salesforce Sales Cloud.
- Developed dynamic dashboards and reports in Tableau CRM Analytics, Power BI, and Excel to visualize key performance metrics.
- Built scalable ETL pipelines leveraging Python, Alteryx ETL.
- Led a 3-member on-site team, managed user stories in JIRA, and provided technical training to junior team members.
- Collaborated with clients across technology, finance, and healthcare sectors to deliver tailored data solutions.
- A software development company specializing in advanced technology solutions.
Data Analyst
Suvarna Technosoft
04.2019 - 04.2022
- Designed and implemented interactive dashboards for HIMS using Tableau and Power BI, delivering dynamic pharmacy sales visualizations and the transition of Tableau reports into Power BI.
- Performed comprehensive exploratory data analysis and transformation on monthly drug details, large hospital datasets, and MRD data using Python, Excel, SQL, and Power Query.
- Extracted and integrated data from diverse sources, including APIs, SQL Server, and web scraping with Selenium.
- Collaborated with senior business analysts to define project scope and document both functional and non-functional requirements.
- Developed automated workflows in Databricks to streamline patient-level reporting.
- Trained staff on BI tool usage and best practices enhancing overall data literacy.
Data Analyst
Suvarna Technosoft Pvt Ltd
02.2015 - 06.2017
- Designed and implemented data models to transform raw data into actionable insights using Tableau and Power BI.
- Developed interactive performance dashboards, scorecards, and reports monitoring KPIs and support data-driven decision-making.
- Extracted and integrated data from client databases with custom SQL and advanced Excel techniques (formulas, pivot tables, conditional formatting).
- Provided production support for BI platforms by creating calculated fields, groups, bins, sets, and hierarchies in Tableau Desktop.
- Translated business requirements into technical specifications, documenting data algorithms, models, and relationships.
- Optimized existing BI systems with technical enhancements to improve data visualization and reporting efficiency.
- Designed, developed, and deployed comprehensive business intelligence solutions to drive performance improvements.
Education
M.TECH-CSE -
Saveetha Engineering College
05-2015
BE-CSE - undefined
Periyar Maniammai University
05-2012
Skills
- Python for Data Engineering & Analytics (Pandas, NumPy, PySpark, Plotly Dash)
- Advanced SQL & Data Modeling
- Power BI Development (DAX, Power Query, Data Modeling)
- Tableau Dashboard Development & Optimization
- AI & LLM Integration (AI Agents, Prompt Engineering, MCP)
- Databricks & PySpark ETL Development
- Microsoft Fabric Analytics Platform
- Business Intelligence Migration (Tableau → Power BI, PowerBI MCP Modelling)
- Data Pipeline Development & ETL Automation
- Machine Learning & Exploratory Data Analysis
- Interactive Data Applications (Python Plotly Dash)
- Workflow Automation (KNIME, Alteryx, Tableau Prep)
- GitHub & Agile Development (Git, GitHub Copilot, JIRA)
- Enterprise Data Analytics & Visualization
Accomplishments
- Retention Improvement: Led a team initiative that improved retention rates by 15% within three months through targeted data analysis and strategic interventions.
- Efficiency Enhancement: Reduced report generation time by 50% by optimizing SQL scripts and leveraging GitHub Copilot and AI-assisted development tools to streamline data processing.
- Dashboard Development: Designed and developed interactive business intelligence dashboards, increasing stakeholder engagement by 40% across global regions.
- Data Migration Success: Successfully migrated 500,000+ records while ensuring high data integrity, accuracy, and accessibility.analytics and reporting.
Certification
- Hacker Rank Python Certified: Certification demonstrating proficiency in Python programming.
- Tableau Certified: Certification indicating skills in data visualization using Tableau.
- Salesforce Associate: Certification for Salesforce Associate role, validating basic Salesforce skills.
- Salesforce PD1: Certification for Salesforce development skills.
- Salesforce PD2: Advanced certification for Salesforce development skills.
- Microsoft Azure AI fundamentals certified AI-900: Certification validating knowledge in Azure AI fundamentals.
Languages
English:
Advanced (C1)
Tamil: Native
Telugu: Proficient
Hindi:
Beginner (A1)
Timeline
Visualization & Reporting Analyst Level II
Bristol Myers Squibb Pvt Ltd
01.2024 - Current
Data Analyst (Subscription & Retention)
DAZN Software Pvt Ltd
08.2023 - 12.2023
Data Analyst
Accellor Software Pvt Ltd (PopcornApps Software Pvt Ltd)
04.2022 - 08.2023
Data Analyst
Suvarna Technosoft
04.2019 - 04.2022
Data Analyst
Suvarna Technosoft Pvt Ltd
02.2015 - 06.2017
BE-CSE - undefined
Periyar Maniammai University
M.TECH-CSE -
Saveetha Engineering College
Strengths
- Industry Experience: Over 9 years of professional experience in data analysis and business intelligence.
- Leadership Skills: Led multiple teams enhancing productivity and project delivery.
- Technical Expertise: Proficient with tools like SQL, Python, Tableau and Power BI , AI tools for data handling.