SAI RAKESH KARANAM
Senior Data Analyst • Dallas, TX • k****************@gmail.com • 469****636 • drivetube.ai/•••••
Professional Summary
Senior Data Analyst with 5 years of experience transforming complex insurance and pharmaceutical data into actionable insights using SQL, Python, Power BI and Tableau. Proven track record building executive dashboards, designing semantic models, automating ETL/reporting pipelines, and delivering predictive analytics that improve fraud detection, forecasting accuracy, and operational efficiency.
Technical Skills
Programming Languages: Python,R
Frameworks and Libraries: Pandas,NumPy,scikit-learn
Databases: SQL,SQL Server,MySQL,PostgreSQL,Oracle,Snowflake,BigQuery
Cloud and DevOps: AWS,S3,Redshift,Athena,Azure Synapse Analytics,Google Cloud Platform
Data and Analytics: Excel,Power BI,Tableau,Looker,Google Data Studio,DAX,Power Query,Jupyter Notebook,Google Analytics,SAS,SPSS,Pivot Tables,VLOOKUP,Cohort Analysis,Trend Analysis,Time Series Analysis,Customer Segmentation,Churn Analysis
Tools and Methodologies: Git,JIRA,Confluence,Microsoft Office Suite,Agile,Business Analysis,Data-Driven Decision Making
Statistical Analysis & Modeling: Statistical Modeling,Hypothesis Testing,Regression Analysis,A,B Testing,Predictive Analytics,Survival Analysis
ETL & Integration: SSIS,Azure Data Factory,Informatica,Alteryx
BI & Reporting: SSRS,SSAS,Crystal Reports,Executive Dashboards,KPI Reporting
Work Experience
GEICO
Dallas, TX
Senior Data Analyst
Nov 2024 – Present
Worked on insurance analytics supporting underwriting, claims, pricing and executive reporting; provided dashboards and analytic models used by underwriting, finance, and claims teams.
Tech Stack: SQL, Python, Power BI, Tableau, DAX, Power Query, Snowflake, SQL Server, Excel
- Analyzed 20M+ policy, claims, customer, and pricing records using SQL and Python to improve data accuracy by 18%, enabling faster, data-driven underwriting and pricing decisions.
- Developed interactive Power BI and Tableau executive dashboards tracking loss ratio, claim frequency, policy retention and premium trends, cutting executive reporting time by 65% for 50+ stakeholders.
- Designed Power BI semantic models and 50+ DAX measures with Power Query to standardize 30+ insurance KPIs, reducing report development effort by 40% and improving dashboard performance by 30%.
- Performed statistical analysis and data mining on claims to surface fraud patterns and high-risk segments, contributing to a 12% improvement in fraud detection accuracy.
- Implemented Row-Level Security, dynamic filtering and parameter-driven reporting across enterprise Power BI assets to provide secure access for 200+ users in underwriting, finance and claims.
- Automated recurring reporting and ETL validation with Python and SQL and optimized Snowflake/SQL Server queries, reducing manual reporting by 20+ hours/week and shortening dashboard refresh times by 55%.
Pfizer
India
Data Analyst
Jan 2020 – May 2023
Delivered pharmaceutical and clinical-trial analytics to clinical operations, medical affairs and commercial teams; produced dashboards, regulatory reports and predictive models to support trials and sales planning.
Tech Stack: SQL, Python, R, SAS, Power BI, Tableau, SSIS, SSRS, Power Query, Excel
- Analyzed clinical and commercial datasets using SQL, Python and SAS to increase data accuracy by 20% and reduce analysis turnaround time by 35% through automated data processing.
- Built Power BI and Tableau executive dashboards providing real-time visibility into clinical trial and commercial performance for 50+ stakeholders, reducing manual reporting by 60%.
- Designed sales forecasting and drug performance models using R and Python, improving forecast accuracy by 18% and informing quarterly commercial planning.
- Performed hypothesis testing, survival analysis and safety monitoring to accelerate clinical data review by 25% and support evidence-based trial decisions.
- Produced regulatory reports with SAS and SSRS, reducing report preparation time by 40% while maintaining 100% compliance with FDA reporting standards.
- Developed SSIS ETL workflows and automated reporting using Power Query and Python to reduce data refresh time by 45% and save 15+ hours/week for clinical operations teams.
Education
Webster University
Master of Science in Data Analytics • October 2025
Certifications
Microsoft Certified: Data Analyst Associate (PL-300) — Microsoft
Tableau Desktop Specialist — Tableau
Google Data Analytics Professional Certificate — Google
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.