Sai Roshan Varma Pandati
Data Analyst • Herndon, VA • r***********@outlook.com • +13******340 • linkedin.com/••••• • drivetube.ai/•••••
Professional Summary
Data Analyst with 3+ years of experience turning large datasets into forecasting, KPI, and cost-reduction insights for executive stakeholders in enterprise and services environments. Skilled in SQL, Python, Power BI and reporting automation; experienced building SLA-driven dashboards, reducing reporting latency, and standardizing variance and reconciliation processes to improve decision-making for sales, revenue, and operations teams.
Technical Skills
Programming Language: R,SQL,Python
Databases: SQL Server,PostgreSQL,Snowflake,Data Modelling
Version Control & Development Tools: Windows
Data Analysis & Visualization: Power BI,Dashboard Design,KPI Reporting,Executive Reporting,Alteryx,Forecasting,Variance Analysis,Statistical Analysis,Reporting Automation,Continuous Improvement,Pandas,NumPy,DAX,Excel,Pivot Tables
Machine Learning & AI: Time Series Analysis
Data Integration & ETL: ELT,ETL,Data Governance
Planning & Forecasting Tools: Capacity Planning
Project Management & Collaboration: Google Workspace
Clinical Data Management: Data Reconciliation
Work Experience
IT Pandits Limited Inc
Data Analyst
Sep 2024 – Present
Worked at an IT services firm supporting operational and executive reporting across transactional systems and BI pipelines used by leadership and operations teams.
Tech Stack: SQL Server, Power BI, DAX, Python
- Engineered production SQL queries using CTEs and window functions and applied query-tuning techniques to cut end-to-end reporting latency by 30% across pipelines processing 1M+ daily transactions, enabling faster operational decisions.
- Designed and delivered 12+ SLA-driven Power BI dashboards with custom DAX measures, automating executive reporting and reclaiming ~20 hours/week previously spent on manual Excel workflows.
- Standardized variance analysis and automated reconciliation routines across upstream and downstream systems, reducing manual reconciliation effort by 45% and resolving recurring metric disputes.
- Developed Python data-processing scripts to validate, transform and stage data for BI consumption, improving downstream data quality and reducing time-to-dashboard refresh.
- Implemented query performance monitoring and tuning practices (index analysis, plan review), stabilizing nightly ETL windows and reducing high-latency query incidents.
- Partnered with stakeholders to define KPIs and SLAs, documented measurement definitions, and produced dashboard training materials to increase leadership adoption and measurement consistency.
Infosys LTD
Junior Data Analyst
Apr 2021 – Sep 2022
Worked at a global IT services and consulting firm on enterprise client reporting, ETL validation, and dashboarding to support client operations and stakeholder reporting.
Tech Stack: PostgreSQL, Power BI, ETL Validation, Excel
- Accelerated enterprise client reporting cycles by refactoring SQL joins and optimizing query plans, improving execution times by 20% across business-critical reporting workflows.
- Collaborated with senior engineers to design ETL validation and data-integrity routines across staging and production, preventing 10+ data-quality defects from reaching production environments.
- Developed Power BI reports and automated data extracts to provide near real-time KPI visibility, increasing stakeholder monitoring capabilities and reducing ad-hoc requests.
- Performed root-cause analysis to resolve 50+ data discrepancies and coordinated corrective actions with cross-functional teams to strengthen data trust.
- Delivered 100+ ad hoc SQL data extracts and recurring reports using parameterized queries and scheduled jobs to support business and stakeholder requests.
- Improved dashboard usability and conducted training sessions that increased report adoption and reduced reliance on manual reporting spreadsheets.
Education
Syracuse University – Whitman School of Management
Master’s in Business Analytics • Syracuse, NY • Aug 2022 – May 2024
Coursework: Forecasting, Predictive Analytics, Statistical Modelling, Business Intelligence
CMR Institute of Technology
Bachelors in Electronics & Communications Engineering • Jun 2017 – Jun 2021
Certifications
Microsoft Power BI Data Analyst Certificate (PL-300)
Google Data Analyst Certificate
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.