Skip to content

Navya S

Data Analyst • Chicago, IL • s********@gmail.com • +14******102 • linkedin./•••••

Professional Summary

Data Analyst with 5 years of experience delivering data-driven insights and scalable analytics solutions across insurance and enterprise domains. Strong expertise in SQL, Python, Power BI, Tableau, and cloud data platforms (Azure, AWS). Proven track record improving data quality, automating ETL/reporting workflows, optimizing query performance, and enabling leadership decisions through clear KPI visualizations and statistical analysis.

Technical Skills

Programming Languages: Python,R
Frameworks and Libraries: Pandas,NumPy,SciPy,Scikit-learn,PySpark
Databases: SQL,Snowflake,SQL Server,PostgreSQL,MySQL,Oracle,MongoDB
Cloud and DevOps: Azure Synapse Analytics,Amazon Redshift,Azure Cosmos DB,AWS S3
Data and Analytics: Excel,Data Cleaning,Data Validation,Exploratory Data Analysis,Statistical Analysis,Power BI,Tableau,Dashboard Development,KPI Reporting,Data Visualization,Azure Data Factory,AWS Glue,Informatica,Azure Stream Analytics
Tools and Methodologies: Git,GitHub,GitLab,Agile,Scrum,SDLC
Skills: PL,SAS

Work Experience

MetLife
USA
Data Analyst
Aug 2024 – Present
Tech Stack: SQL, Python, Pandas, NumPy, Azure Synapse Analytics, Azure Data Factory, Azure Stream Analytics, Azure Cosmos DB, Power BI
  • Designed and implemented data validation and cleaning processes using SQL and Python (Pandas, NumPy) for large-scale insurance datasets, improving reliability of downstream reporting and analytics.
  • Built and optimized scalable data models and complex SQL transformations in Azure Synapse Analytics to accelerate BI queries and reduce report runtime for policy and claims analytics.
  • Automated end-to-end ETL pipelines with Azure Data Factory and Azure Stream Analytics to consolidate policy administration and claims data into Azure Cosmos DB, reducing manual report preparation and improving data availability.
  • Developed interactive Power BI dashboards to monitor policy performance, claims trends, customer retention, and operational KPIs, enabling leadership to act on real-time business insights.
  • Performed exploratory data analysis and statistical modeling in Python to identify customer retention drivers and policy risk indicators, improving policy risk classification accuracy by 15%.
  • Partnered with Business, Finance, Actuarial, Compliance, and Engineering teams to translate business requirements into scalable analytics solutions, standardize KPIs, and ensure data accuracy across reporting systems.
Hexaware Technologies
India
Business Data Analyst
Jan 2020 – Nov 2022
Tech Stack: SQL, Python, Pandas, Excel, Power BI, Tableau, AWS Glue, Informatica, Amazon Redshift, Snowflake
  • Collaborated with stakeholders to gather reporting requirements, define KPIs, and translate business needs into dashboards and automated reports that supported operational decision-making.
  • Validated and transformed enterprise datasets using SQL, Python (Pandas), and Advanced Excel to deliver accurate business reports and KPI dashboards for revenue and operations teams.
  • Designed and developed Power BI and Tableau dashboards to surface customer behavior, revenue trends, and operational KPIs, improving stakeholder visibility into key metrics.
  • Developed ETL workflows using AWS Glue and Informatica to automate data ingestion and integration across multiple systems, increasing data consistency and reducing manual workloads.
  • Designed and optimized data models in Amazon Redshift and Snowflake, improving SQL query performance by 35% and enabling faster dashboard refresh cycles.
  • Performed trend and statistical analysis using Python to identify business patterns, support forecasting, and present actionable recommendations to business stakeholders.

Projects

Analyzing Divvy Bike Data in PostgreSQL
Tools Used: PostgreSQL, SQL, Excel, Data Cleaning, Data Analysis
  • Analyzed 500,000+ Divvy bike trip records using PostgreSQL and complex SQL aggregations to identify rider behavior, station utilization, ride duration, and peak demand.
  • Performed data cleaning, trend analysis, and KPI reporting to evaluate member versus casual rider usage and provide operational recommendations.
  • Created analytical reports and visualizations to communicate insights that supported recommendations for improving bike-sharing operations.
Airbnb Market Analysis Study
Tools Used: Python, Pandas, SQL, Tableau, EDA, Statistical Analysis
  • Conducted exploratory data analysis on Airbnb listings across major U.S. cities to evaluate pricing patterns, occupancy trends, and neighborhood performance.
  • Analyzed listing availability, host activity, seasonal demand, and pricing behavior to identify high-performing market segments and produce business recommendations.
  • Designed Tableau dashboards and interactive visualizations to present pricing trends, occupancy metrics, and market insights for stakeholders.

Education

Illinois Institute of Technology
Master’s in Information Technology and Management, Specialization: Data Analytics • Chicago, IL • Jan 2023 – Dec 2024
Mahatma Gandhi Institute of Technology
Bachelor of Technology, Electronics and Communication Engineering • Telangana, India • Jul 2016 – Sep 2020

Certifications

Microsoft Power BI Data Analyst Professional Certificate — Microsoft
Career Essentials in Data Analysis — Microsoft and LinkedIn

Powered by Drivetube · Create your own profile at drivetube.ai