Skip to content

Koteswarrao Jamalapuram

Data Analyst | AI & Business Intelligence • Dallas, TX • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Data Analyst and Business Intelligence Engineer with 4+ years of enterprise experience designing automated data pipelines, AI-driven analytics workflows, and scalable BI reporting solutions across healthcare, logistics, and e-commerce domains. Builds end-to-end ETL/ELT pipelines in Python and SQL with cloud data warehousing on AWS Redshift and Snowflake, and delivers executive-grade dashboards in Power BI and Tableau. Integrates OpenAI APIs and Azure OpenAI to automate document extraction, anomaly detection, and insight generation at enterprise scale. Experienced with dimensional modeling techniques including star schema design to optimize reporting performance. Operates confidently in Agile delivery environments using JIRA and Confluence, translating complex business requirements into production-ready analytical solutions.

Technical Skills

Programming Language: Python,R
Backend Technologies: Pydantic,SQLAlchemy
Databases: MySQL,Oracle,Redis,Stored Procedures,SQL
Cloud Platforms: AWS,S3,Lambda,EC2,Azure
Version Control & Development Tools: Git,GitHub,GitLab,Bitbucket,UAT Testing
Data Warehousing: Star Schema
Data Analysis & Visualization: Pandas,Power BI,Tableau,Excel
Generative AI & LLMs: Azure OpenAI,RAG Frameworks
Data Integration & ETL: Data Validation,ETL and ELT Pipeline Development,Data Cleansing and Transformation
Project Management & Collaboration: Agile Scrum,Confluence,Jira

Work Experience

Publicis Groupe (Client: United Healthcare)
Dallas, TX
Data Analyst
Sept 2026 – Present
Embedded with United Healthcare's data and finance teams through Publicis Groupe, supporting enterprise financial reporting, automated document processing, and BI dashboard delivery for healthcare operations and executive stakeholders.
Tech Stack: Python, SQL, OpenAI APIs, RAG Frameworks, AWS Redshift, Power BI
  • Engineered automated financial data extraction pipelines using Python and SQL to parse unstructured enterprise financial documents and invoices at scale, improving processing accuracy across downstream reporting workflows.
  • Integrated OpenAI APIs with RAG frameworks to automatically extract, validate, and structure key financial metrics from multi-page PDF reports, loading curated data into AWS Redshift for executive consumption.
  • Designed anomaly detection routines and automated data quality validation checks that significantly reduced data discrepancies before deployment to executive BI dashboards serving healthcare finance teams.
  • Built scalable ETL pipelines on AWS using S3, Lambda, and Glue to orchestrate financial document parsing and route validated records to Redshift for downstream reporting across cross-functional stakeholders.
  • Developed interactive financial performance and audit dashboards in Power BI, enabling real-time visibility into healthcare transaction metrics and automated document processing status for senior leadership.
  • Modeled dimensional data structures in Redshift using star schema design to optimize query performance and support high-concurrency executive reporting on healthcare financial KPIs.
Lumen Technologies
Delray Beach, FL
Data Analyst
Jul 2025 – Sept 2026
Supported Lumen Technologies' logistics and supply chain analytics function, building BI solutions, cloud data infrastructure, and AI-assisted reporting tools to improve operational visibility across distribution and shipment tracking workflows.
Tech Stack: SQL, Pandas, Power BI, Tableau, Azure OpenAI, Oracle
  • Analyzed complex logistics and shipment tracking datasets using SQL to surface trends, delivery bottlenecks, and performance gaps, delivering findings directly to operations leadership.
  • Developed interactive Power BI and Tableau dashboards to track logistics KPIs including on-time delivery rates, exception volumes, and operational efficiency metrics across distribution regions.
  • Integrated Azure OpenAI into analytical portals to automatically summarize delivery exception details and produce plain-language insight reports for non-technical business stakeholders.
  • Optimized database queries in Oracle, reducing data retrieval time by 26% during high-volume distribution periods through targeted index redesign and query refactoring.
  • Built automated data transformation and cleansing pipelines using Pandas to standardize incoming logistics datasets and ensure accuracy before executive reporting deployment.
  • Deployed centralized analytics storage on AWS using S3, EC2, and RDS to consolidate logistics data from disparate operational sources into a single queryable layer.
  • Constructed dimensional data models with star schema structures to optimize Tableau dashboard performance and reduce report execution time across high-cardinality logistics datasets.
Coforge
India
Data Analyst
Feb 2021 – Nov 2023
Worked within Coforge's analytics practice supporting an e-commerce client, delivering sales performance dashboards, customer behaviour insights, and automated reporting pipelines to drive merchandising and inventory decisions.
Tech Stack: Tableau, MySQL, SQL, Python, R, OpenAI APIs, Redis, Excel, ETL
  • Designed dynamic Tableau dashboards to monitor e-commerce sales performance, customer behaviour trends, and inventory levels, providing merchandising teams with daily operational visibility.
  • Developed complex SQL queries, views, and stored procedures in MySQL to power enterprise KPI reporting for sales, inventory, and customer retention metrics.
  • Introduced OpenAI APIs to analyze customer search patterns and generate automated product recommendation insights, surfacing actionable outputs for the product and marketing teams.
  • Conducted customer segmentation and sales trend analysis using Python and R, identifying high-value customer cohorts that informed targeted promotional strategies.
  • Implemented Redis caching on frequently queried reporting endpoints, improving API response times by 27% and reducing database load during peak e-commerce traffic periods.
  • Automated data quality checks and cleansing routines across structured ETL workflows, improving overall report accuracy and eliminating manual remediation steps.
  • Applied Excel Power Query and pivot tables for deep-dive financial and operational analysis, producing ad-hoc executive presentations to support management decision-making.

Education

Florida Atlantic University
Master of Science in Computer Science • FL, USA • Dec 2025
Sai Spurthi Institute of Technology
Bachelor of Technology in Computer Science • India • May 2023

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

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • 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
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ 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
  • Written by senior career writers

    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
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    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
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.