Roopa Devadiga

Results-driven Data Analyst with strong expertise in analysing large-scale enterprise datasets using SQL, Python, and Power BI. Skilled in data cleaning, automation, validation, and exploratory data analysis (EDA), with a focus on delivering accurate insights for data-driven business decision-making. Proven ability to transform complex datasets into actionable insights and improve efficiency through SQL and Python-based automation.

Data Analyst - Flexera - Bengaluru, India

(2023-06)

• Performed advanced data analysis using SQL and Python on large-scale datasets.
• Wrote SQL scripts to identify duplicates, detect anomalies, and ensure data integrity.
• Wrote and optimized complex SQL queries (CTEs, window functions, multi-table joins) against Oracle and MySQL databases to support analytics and compliance reporting.
• Automated data cleaning and transformation workflows using Python (Pandas, NumPy).
• Conducted EDA on enterprise datasets containing thousands of software asset records to identify trends, anomalies, and optimization opportunities.
• Developed web crawlers to enrich internal asset data with external software metadata, improving asset discovery coverage.
• Built reusable Python scripts for data validation and automation.
• Integrated SQL and Python workflows to automate data pipelines, reducing manual processing effort and improving reporting efficiency.
• Delivered actionable insights to stakeholders to support data-driven decision-making.
• Developed interactive Power BI dashboards to support executive decision-making and business intelligence initiatives.

Associate Content Analyst - Flexera - Bengaluru, India

(2021-09 - 2023-06)

• Managed and analyzed software asset datasets within ITAM/SAM system.
• Performed data normalization, categorization, and cleansing to improve accuracy.
• Worked on keyword-based mapping and taxonomy structuring.
• Conducted data validation and quality checks for consistency.
• Identified and resolved data inconsistencies across multiple sources.
• Collaborated with stakeholders to meet business and compliance requirements.
• Improved asset visibility through structured data management.

B.E. - Computer Science & Engineering - MITK (2017 - 2021)