Yogitha Devarapally
Professional Summary
Associate Data Analyst with 2+ years of experience delivering ETL workflows, SQL analytics, dashboarding, and automated reporting to support business decisions. Experienced with Python (Pandas, NumPy), SQL, Power BI, Tableau, Excel, and statistical tools (SAS, SPSS). Skilled at converting raw data into validated KPIs and interactive dashboards consumed by business stakeholders.
Technical Skills
Work Experience
- Partnered with cross-functional stakeholders to gather analytic requirements and translate business questions into repeatable data models and dashboards using Power BI and SQL.
- Engineered reusable ETL pipelines in Python (Pandas) to extract and transform data from operational sources for reporting, improving data preparation consistency across reports.
- Performed exploratory data analysis to discover trends and anomalies, producing insights used in weekly stakeholder reviews and decision-making.
- Built interactive KPI dashboards in Power BI and Tableau that centralized key operational metrics and reduced time-to-insight for business users.
- Authored complex SQL queries to join, aggregate, and filter relational datasets for ad-hoc analysis and scheduled reporting delivered to business teams.
- Automated recurring reporting tasks and validation checks with Python and SQL to reduce manual effort and ensure consistent data quality in production reports.
- Analyzed structured and unstructured datasets using SQL and Python to identify patterns and operational trends supporting business reporting.
- Designed and maintained Power BI and Excel dashboards to monitor KPIs and share actionable insights with technical and non-technical stakeholders.
- Cleaned and transformed raw data—handling missing values and outliers—using Python and Excel to improve downstream reporting accuracy.
- Wrote optimized SQL queries to retrieve, join and aggregate data from multiple sources for recurring reports and ad-hoc analyses.
- Automated routine data preparation and reporting processes to improve operational efficiency and reduce manual processing time.
- Conducted statistical analyses with SAS and SPSS to support forecasting and performance measurement communicated via reports and presentations.
Projects
- Processed EEG time-series data applying noise reduction and signal preprocessing routines to improve model input quality.
- Engineered time-series features using NumPy and Pandas to capture temporal patterns relevant to emotion states.
- Trained and evaluated deep learning classification models that achieved high predictive accuracy on the validation set.
- Visualized model performance and feature distributions to communicate results to academic reviewers and peers.
- Queried and aggregated healthcare datasets using SQL to prepare a clean dataset for modeling and analysis.
- Performed data cleaning and outlier handling in Python to ensure reliable model training and evaluation.
- Built classification models using scikit-learn and validated performance achieving solid classification accuracy.
- Presented model findings and risk indicators through Power BI dashboards to illustrate insights to stakeholders.
Education
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.