Data Analyst Senior

DIVYA VARAKANTHAM Email: *****.**********@*****.*** Phone number: +1-904-***-****

SUMMARY

Senior Data Analyst with 6 years of experience in leveraging advanced SQL, Python (Pandas, PySpark), Tableau and PowerBI to analyze data, uncover insights, and present actionable recommendations to stakeholders.

Skilled in working with large datasets across Azure SQL Databases, Oracle, and GCP, performing in-depth data analysis, and creating interactive dashboards to drive data-informed decision-making.

Hands-on experience with data exploration, trend analysis, and reporting, delivering impactful results in IT infrastructure, healthcare, and marketing domains.

Proficient in simplifying complex data into clear insights for technical and non-technical audiences, ensuring alignment with business goals.

TECHNICAL SKILLS

Programming & Query Languages: SQL (Advanced), Python (Pandas, PySpark), Advanced Excel.

Databases: Azure SQL Databases, Oracle, MySQL, GCP Big Query.

Visualization Tools: Tableau, Power BI.

Core Competencies: Data Analysis, Data Visualization, SQL Query Optimization, Business Reporting, Trend Analysis.

PROFESSIONAL EXPERIENCE

Azzurra Solutions LLC Feb 2023 –Present

Senior Data Analyst

Used advanced SQL to analyze IT infrastructure data, optimizing resource allocation and reducing downtime by 20%.

Built Tableau dashboards to visualize key performance metrics, enabling leadership to monitor software usage and identify cost-saving opportunities.

Leveraged Python (Pandas, PySpark) for data cleaning and analysis, ensuring high-quality, reliable datasets for reporting.

Conducted root cause analysis on system performance issues using SQL, helping the IT team proactively address bottlenecks.

Analyzed data from Azure SQL Databases and GCP, providing insights to optimize cloud resource usage and reduce costs.

Simplified complex datasets into easy-to-understand visualizations for technical and non-technical stakeholders.

Esha IVF Fertility Center, Hyderabad, India Oct 2021– Nov 2022

Data Analyst

Wrote SQL queries to analyze patient and sales data, identifying trends that led to a 15% increase in patient acquisition.

Created interactive Tableau dashboards to monitor patient engagement, helping improve retention rates by 10%.

Used Python (Pandas) to clean and analyze marketing and operational data, ensuring accuracy in decision-making.

Conducted trend analysis on historical patient data to identify seasonal demand fluctuations and guide resource planning.

Automated reporting processes using SQL and Excel, reducing manual effort by 80% and improving reporting efficiency.

Boosted patient engagement and retention by analyzing engagement data, leading to a 15% increase in service uptake through personalized follow-ups. Applied time-series analysis to identify seasonal demand patterns, resulting in a 10% improvement in retention during off-peak periods.

Presented actionable insights to stakeholders, helping optimize marketing strategies and improve campaign performance.

R12 Solutions Pvt. Ltd, Hyderabad, India June 2019 – Sep 2021

Growth Analyst

Used SQL to analyze customer and sales data, identifying opportunities to increase revenue and improve marketing efforts.

Designed Tableau dashboards to track campaign performance, simplifying reporting for stakeholders.

Conducted data analysis using Python and Excel to identify high-performing marketing strategies.

Analyzed competitor data to provide actionable insights into market trends and customer behavior.

Supported marketing teams by preparing clear and concise reports, enabling data-driven decision-making.

Junior marketing analyst

Analyzed marketing data using SQL and Excel, identifying trends and opportunities for lead generation.

Created reports and dashboards in Excel to track key metrics, improving campaign visibility for the team.

Provided data-driven recommendations to improve customer engagement and conversion rates.

Devised creative marketing strategies for lead generation, leading to the conversion of company website traffic to 8,100+ quality leads.

Contributed to the development of marketing content by analyzing its performance and suggesting improvements.

EDUCATION

Master of Business Administration (MBA) -Operations & Analytics

Woxsen School of Business – 2019 - 2021

oRelevant Coursework: Data Visualization, Business Statistics, Marketing Research and Analytics, Applied Analytics.

Bachelor’s degree

JNTU university, Hyderabad – 2015 - 2019

CERTIFICATIONS

Microsoft Certified: Azure Fundamentals

KEY ACHIEVEMENTS

Reduced manual reporting time by 80% through SQL automation and streamlined Excel workflows.

Increased patient acquisition through data analysis and targeted insights using Tableau dashboards

Contact this candidate