Yaswanth Rosannagari
Professional Summary
Data Analyst with 0 years of professional experience, including an internship focused on product and client-facing analytics. Skilled in Python, SQL, Pandas and Power BI, with hands-on experience cleaning and modeling datasets up to 200K+ rows and delivering executive dashboards. Experienced in exploratory data analysis, RFM-based customer segmentation and clustering using scikit-learn, and building KPI visualizations with Power BI and DAX. Worked on e-commerce and customer-behavior projects using SQL Server and SQL for ETL, aggregation and forecasting. Comfortable working in Jupyter Notebook and Google Colab and producing stakeholder-ready reports and Excel PivotTable summaries. Seeking an entry-level Data Analyst role where I can apply analytical rigor and dashboarding to improve product and marketing decisions.
Technical Skills
Work Experience
- Analyzed engagement trends across client-facing platforms using Python and Pandas; identified behavior patterns that increased insight accuracy by 45% for leadership decision-making.
- Designed and deployed interactive Power BI dashboards with DAX measures and drill-downs to monitor 20+ KPIs, enabling faster leadership decisions and reducing manual reporting effort.
- Structured and modeled 200K+ records in SQL by applying joins, normalization and indexing to improve query reliability and downstream reporting.
- Validated and cleansed source data by implementing transformation checks and Python scripts (NumPy), preventing recurring anomalies in reporting pipelines.
- Executed exploratory data analysis in Jupyter Notebook using Pandas and Matplotlib to surface retention drivers and inform targeted client interventions.
- Automated recurring ETL steps with SQL queries and Python scripts to streamline weekly reporting cadence and improve data readiness for analysts.
- Versioned analysis notebooks in Git and prepared executive summaries and PivotTable reports in Excel for stakeholder reviews.
Projects
- Cleaned and engineered features on a 3.9K-record customer dataset using Python and Pandas in Jupyter Notebook and Google Colab, improving analysis readiness and reducing missing values by 35%.
- Performed EDA and SQL-based queries to uncover purchase patterns across gender, age groups and shipping types to inform segmentation strategy.
- Built RFM segmentation and implemented clustering with scikit-learn to classify loyal and returning customers, enabling targeted campaigns that increased revenue potential by 28%.
- Developed an interactive Power BI dashboard to visualize KPIs, purchase frequency and product performance for business stakeholders.
- Integrated 23K+ transaction records and 5.6K+ customer records into SQL Server, applying deduplication and validation routines to improve data cleanliness and query performance.
- Authored optimized SQL Server queries to calculate sales trends, repeat purchases and revenue by category to accelerate insights for marketing and product teams.
- Automated demand forecasting and performance tracking with SQL aggregations and Python preprocessing to improve short-term planning precision.
- Identified high-value product categories and frequent shopper cohorts via cohort analysis, guiding promotions that increased potential revenue opportunity by 22%.
Education
Certifications
Powered by Drivetube · Create your own profile at drivetube.ai
Everything on Drivetube
Six products, two of them free forever. Start wherever you are.
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 BoardFree
Verified jobs, posted in the last 3 days
verified openings crawled ATS-by-ATS from 140,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 - Resume Writing ServicesFrom $25.99
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 - Drivetube HireFree tier
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.