Ramya R
Senior Data Analyst • Kansas City, MO, USA • r********@gmail.com • 913****893 • drivetube.ai/•••••
Professional Summary
Senior Data Analyst with 5+ years of experience collecting, analyzing, and transforming complex datasets into actionable insights. Expert in SQL and Python, building ETL pipelines and cloud data solutions (Azure, AWS, Snowflake), developing BI dashboards (Power BI, Tableau, Looker) and production-grade ML models (XGBoost, LightGBM, TensorFlow) to support underwriting, claims, and healthcare analytics.
Technical Skills
Programming Languages: Python,R
Web Technologies: REST APIs
Frameworks and Libraries: Scikit-learn,TensorFlow,Keras
Databases: SQL,Snowflake,Azure SQL,SQL Server,Oracle,MySQL,MongoDB,Cassandra
Cloud and DevOps: Azure,AWS,S3,Glue,Redshift,Lambda,Data quality frameworks,Model monitoring
Data and Analytics: Azure Data Factory,SSIS,Apache Airflow,ETL Development,Databricks,Power BI,Power Query,Tableau,Looker,LookML,Excel PivotTables, Power Pivot,XGBoost,LightGBM,Time-series forecasting
Tools and Methodologies: Git,Jira,Agile
Skills: SAS
Work Experience
The Hartford
Connecticut, USA
Senior Data Analyst
Aug 2025 – present
Insurance company — supported underwriting and claims analytics, delivering dashboards, ETL pipelines, risk analytics, and ML models for actuarial and claims teams.
Tech Stack: Power BI, DAX, SQL, Azure SQL, Snowflake, Azure Data Factory, Python, Pandas, Scikit-learn, XGBoost, LightGBM, TensorFlow, Azure ML
- Designed and deployed enterprise Power BI dashboards for underwriting and claims analytics (Power BI, DAX, Azure SQL, Snowflake), improving executive decision-making efficiency by 30%.
- Built complex SQL queries, views, and stored procedures to extract and transform large-scale datasets from Azure SQL and Snowflake to support reporting and ML workflows.
- Developed scalable ETL pipelines using Azure Data Factory to automate data integration and orchestration, reducing manual data preparation and handoffs.
- Conducted loss trend and risk analytics using Python (Pandas, NumPy) to identify high-risk claim segments, contributing to a 12% reduction in operational risk exposure.
- Developed and deployed ML models (XGBoost, LightGBM, TensorFlow/Keras) for claim risk prediction and stratification, improving prediction accuracy by 18% over baseline models.
- Implemented data validation and model monitoring frameworks and leveraged Azure ML/cloud services for model training and deployment, improving data accuracy by 25% and tracking performance drift.
Cigna Group
Connecticut, USA
Data Analyst
Feb 2024 – May 2025
Healthcare and health-insurance analytics — analyzed claims, enrollment, and pharmacy data to support care management, compliance, and cost-control initiatives.
Tech Stack: Power BI, Tableau, Looker, LookML, SQL, Python, Apache Airflow, SAS, R, APIs
- Analyzed large-scale healthcare claims, enrollment, and pharmacy datasets using SQL and Python to identify cost drivers, utilization patterns, and patient outcome trends across 150K+ patient records.
- Designed interactive dashboards in Power BI, Tableau, and Looker (LookML) to track utilization, chronic-condition prevalence, and member engagement for clinical and business stakeholders.
- Built predictive models for patient segmentation and risk scoring to enable early identification of high-risk members and prioritize care management interventions.
- Automated reporting and ETL workflows with Python and Apache Airflow, reducing manual report preparation effort by 30% and improving report reliability.
- Ensured HIPAA and CMS compliance by implementing secure data handling, validation checks, and audit processes; used SAS for claims validation and regulatory reporting.
- Integrated data from APIs, provider feeds, and third-party sources to improve interoperability and translated SQL analyses into executive-level dashboards to inform leadership decisions.
Wipro
India
Data Analyst
July 2019 – Nov 2022
Global IT services and consulting — delivered analytics and reporting solutions for operations, finance, and customer analytics clients using BI and ETL platforms.
Tech Stack: Power BI, Tableau, SQL Server, Oracle, Python, Pandas, SSIS, Azure Data Factory, MongoDB, Cassandra, Git, Agile
- Developed interactive Power BI and Tableau dashboards to surface KPIs across operations, finance, and customer analytics, enabling data-driven decision-making for client stakeholders.
- Authored complex SQL queries, joins, views, and stored procedures to extract and transform datasets of 5M+ records from SQL Server and Oracle for reporting and analysis.
- Performed data cleaning, transformation, and exploratory data analysis using Python (Pandas, NumPy) to prepare features for forecasting and operational reports.
- Built automated ETL pipelines using SSIS and Azure Data Factory to schedule and orchestrate data flows, reducing manual reporting effort by 35%.
- Assisted cloud migration efforts from on-prem SQL Server to Azure and Snowflake and worked with semi-structured/NoSQL sources (MongoDB, Cassandra) for real-time analytics use cases.
- Collaborated with cross-functional teams in Agile/Scrum, developed data validation frameworks and quality checks that improved reporting accuracy by 20%.
Education
University of Missouri - Kansas City
Master's degree, Computer Science • Kansas City, MO
Vignan's Foundation for Science, Technology and Research
Bachelor's Degree • Guntur, India
Powered by Drivetube · Create your own profile at drivetube.ai
Explore Drivetube
- Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.