Lavanya Billapati
Data Analyst • Missouri, USA • l********************@gmail.com • +13******474 • linkedin/••••• • drivetube.ai/•••••
Professional Summary
Data Analyst with 3+ years of experience delivering enterprise analytics, automated ETL pipelines, and executive dashboards across healthcare and financial services. Skilled in SQL, Python, Power BI, and Tableau to analyze large-scale datasets, automate reporting workflows, and surface operational insights. Proven record improving reporting efficiency and enabling data-driven executive decisions.
Technical Skills
Programming Language: Python,R,SQL
Databases: SQL Server,MySQL,Data Modeling
Cloud Platforms: AWS,S3,EC2
Version Control & Development Tools: Jupyter Notebook,Git,GitHub
Data Warehousing: Data Warehousing
Data Analysis & Visualization: Pandas,NumPy,Excel,Exploratory Data Analysis,Statistical Analysis,Hypothesis Testing,Power BI,Tableau,DAX,K-Nearest Neighbors,Data Cleaning,Pipeline Automation,KPI Reporting,Dashboard Development,Trend Analysis
Machine Learning & AI: Regression Analysis,Logistic Regression,Random Forest,Classification
AI/ML Frameworks & Libraries: scikit-learn
Data Integration & ETL: ETL,Data Transformation
Quality Assurance & Compliance: Root Cause Analysis
Work Experience
Johnson & Johnson
USA
Data Analyst
May 2024 – Present
Worked in healthcare operations analytics at a global healthcare company, delivering operational dashboards, ETL automation, and predictive insights to clinical and executive stakeholders.
Tech Stack: SQL Server, Power BI, Python, Pandas, DAX, Power Query, Excel, AWS S3
- Built enterprise-scale SQL Server data models and optimized analytics queries to power executive operational dashboards, reducing report generation time and ad-hoc request handling by 30%.
- Developed interactive Power BI dashboards tracking patient outcomes, resource utilization, and operational KPIs to accelerate executive decision-making and reduce manual report assembly.
- Automated ETL pipelines using SQL and Python (Pandas), improving data freshness and eliminating repetitive manual processing in recurring reports.
- Designed and implemented automated data validation frameworks and reconciliation checks to increase reporting accuracy and strengthen data governance.
- Performed healthcare utilization and cohort analyses to identify operational inefficiencies and recommended changes that contributed to a 20% improvement in targeted performance metrics.
- Built predictive models to identify high-risk patient populations using Python and scikit-learn, enabling targeted care interventions and supporting readmission-reduction initiatives.
Comerica Bank
India
Data Analyst
Jul 2021 – Dec 2022
Delivered analytics and reporting for banking operations, lending portfolios, and transaction monitoring to support risk, finance, and compliance teams.
Tech Stack: MySQL, Tableau, Python, Scikit-learn, Git, Excel, Jupyter Notebook
- Authored and optimized SQL queries against lending, customer, and transaction datasets to supply risk teams with timely insights and speed identification of high-risk accounts.
- Developed Tableau dashboards visualizing lending performance and portfolio risk metrics to provide senior managers daily oversight of portfolio health.
- Automated recurring reporting pipelines using SQL and Python, cutting report turnaround time by 40% and reducing manual effort for monthly and ad-hoc reports.
- Refactored and tuned SQL queries to improve reporting performance and data retrieval speed, reducing query runtime and improving analyst productivity.
- Conducted exploratory data analysis and implemented K-Nearest Neighbors anomaly detection in Python to flag suspicious transactions for fraud monitoring and compliance escalation.
- Partnered with finance and business stakeholders to translate requirements into executive dashboards and KPI reports that informed lending and risk decisions.
Projects
Healthcare KPI Dashboard
Tools Used: Power BI, SQL, Python, DAX, Power Query
- Designed Power BI dashboards to analyze patient outcomes and hospital utilization across key operational KPIs.
- Built SQL transformations and data models to support executive KPI reporting and ensure consistent metric definitions.
- Automated reporting workflows to reduce manual report preparation and accelerate availability of insights for leadership.
Loan Analytics Dashboard
Tools Used: SQL, Python, Power BI, Scikit-learn
- Analyzed 10,000+ lending records using SQL and Python to surface trends in approvals, defaults, and customer segments.
- Developed Power BI dashboards tracking approval rates, default risk, and portfolio segmentation for business stakeholders.
- Built predictive models to score credit risk and support portfolio decision-making.
Healthcare Readmission Analytics
Tools Used: SQL, Power BI, Python
- Performed SQL-based exploratory analysis on patient admissions to identify readmission patterns and drivers.
- Created dashboards highlighting readmission trends and treatment effectiveness for clinical operations.
- Presented data-driven recommendations to improve care planning and reduce readmission risk.
Education
Webster University
Master of Science, Cyber Security (Data Analytics Concentration) • United States • 2023 – 2025
Nalla Narasimha Reddy Group of Institutions
Bachelor of Technology, Computer Science & Engineering • India • 2018 – 2022
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.