V S K Ayyappa
Deputy Manager - Power Bi Developer @Aurobindo Pharma Ltd
Signup · Get unlimited contacts
WORK HISTORY
Deputy Manager - Power Bi Developer @Aurobindo Pharma Ltd
Hyderabad, IN
Power BI & SQL Developer – Sales AnalyticsAurobindo Pharma |[Hyderabad, India |[01/2019]• Designed and deployed interactive Power BI dashboards to monitor sales performance, product-wise revenue, and market trends across multiple regions.• Utilized SQL queries for extracting, cleaning, and aggregating large volumes of sales data from internal databases for business analysis.• Performed advanced data transformations using Power Query for merging, filtering, and reshaping data to create a unified reporting layer.• Created complex DAX measures and calculated columns to track KPIs such as sales growth, volume vs. value contribution, and regional performance.• Developed Excel-based reports and pivot tables for quick sales snapshots, supporting ad-hoc decision-making and monthly reviews.• Automated report refresh cycles using Power BI Gateway, ensuring real-time data availability for stakeholders.• Collaborated with sales and marketing teams to gather reporting requirements, improving data-driven strategy execution.Assistant Manager – Archival ManagementAurobindo Pharma Limited |[Hyderabad], India |[01/2011] – [12-2018]• Managed the archival and retrieval of critical documents across departments, ensuring regulatory compliance with cGMP, WHO, USFDA, and other global standards.• Maintained accurate document lifecycle tracking using Excel and database systems, ensuring traceability, security, and timely retrieval.• Coordinated with QA, QC, Production, and R&D teams for the structured storage of batch records, SOPs, validation documents, and audit trails.• Implemented process improvements for document classification, retention, and digital scanning to support efficient knowledge management.• Supported internal and external audits by facilitating rapid access to archived data, contributing to successful regulatory inspections.
EDUCATION
Google Data Analyst, Google Data Analytical Certificate
Dr. B. R. Ambedkar Open University, Hyderabad
Master of Business Administration - MBA, HR
Ravindarabharathi Vidyanikethan
SSC, social
Andhra University
Master's Degree, MA Economics
ABOUT V S K AYYAPPA
I am a Pharma Domain Data & Compliance Professional with 7+ years of experience at Aurobindo Pharma Limited, specializing in regulatory documentation management, audit tracking, and compliance reporting.Over the past few years, I have developed strong expertise in Power BI, SQL, and Advanced Excel to transform operational and compliance data into meaningful dashboards and actionable insights.My core strengths include:• Power BI (DAX, Data Modeling, Power Query)• SQL Data Extraction & Analysis• Pharma Documentation Lifecycle (GxP, USFDA, WHO audits)• KPI Reporting & MIS AutomationI am currently seeking opportunities in: Power BI Analyst MIS Executive – Pharma Reporting Analyst Business Intelligence RolesI bring a unique combination of Pharma Domain Knowledge + Data Analytics Skills that helps bridge the gap between business and technical teams.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.