Alekya Peesu
Professional Summary
Data Analyst with 4+ years of experience delivering reporting, dashboards, and ad hoc analysis across healthcare, banking, financial services, and pharmaceutical supply-chain domains. Strong hands-on experience writing complex T-SQL and Snowflake queries to extract and transform large enterprise datasets for reporting and analytics. Skilled in building production Power BI reports with DAX, authoring Tableau visualizations, and producing accurate Excel-based reconciliations and automated templates. Experienced with Python and R for data cleansing, automation, and statistical analysis. Regularly gather and translate business requirements into validated reports, perform data reconciliation and quality checks, and present actionable insights to technical and non-technical stakeholders. Proven ability to improve reporting reliability and reduce manual effort through query optimization, parameterized extracts, and report automation.
Technical Skills
Work Experience
- Analyzed healthcare claims and membership datasets by authoring complex SQL queries in Snowflake and SQL Server to prepare curated datasets for reporting.
- Built Power BI reports with DAX measures and parameterized filters to surface enrollment and utilization KPIs for operations and clinical teams.
- Designed Tableau visualizations to highlight trend patterns and exception cases, enabling stakeholders to identify high-priority operational issues.
- Validated and reconciled source data using Excel and SQL to ensure report accuracy prior to stakeholder distribution.
- Gathered and documented reporting requirements from clinical and operations partners and translated them into data models and report specifications.
- Automated recurring data extraction and refresh processes using stored procedures and parameterized SQL to reduce manual preparation.
- Developed T-SQL queries and stored procedures in SQL Server to extract customer and transactional data for recurring operational reports.
- Created Power BI dashboards to present KPIs and exception monitoring for finance and risk stakeholders.
- Constructed Tableau reports to visualize transaction trends and identify outliers for operations review.
- Performed data validation and reconciliation using Excel to verify financial aggregates and feed reconciled datasets into reporting pipelines.
- Translated business and compliance requirements into documented data specifications and report logic for engineering handoffs.
- Streamlined report refresh by parameterizing SQL extracts and implementing scheduled exports to reduce manual refresh steps.
- Authored complex SQL queries to extract and aggregate large financial datasets for performance and risk analysis.
- Implemented Python scripts in Jupyter Notebooks to automate data cleansing and pre-processing workflows for downstream reporting.
- Applied R for statistical analysis and model-based insights to answer ad hoc client reporting questions.
- Designed interactive Tableau dashboards to visualize trading and operational metrics for stakeholder consumption.
- Performed data reconciliation and validation across multiple sources using SQL and Excel to improve reporting reliability.
- Partnered with business partners to define KPIs and translate analytical findings into actionable recommendations.
- Extracted and transformed production and supply-chain data using SQL Server to prepare datasets for operational reporting.
- Automated recurring reports and data cleansing tasks using Python scripts and Excel VBA macros to reduce manual effort.
- Built Power BI dashboards to track production KPIs and inventory levels for operations managers.
- Developed Tableau visualizations to communicate process performance and deviations to stakeholders.
- Implemented data validation rules and reconciliation procedures to improve data quality for supply-chain reports.
- Created standardized Excel templates and pivot-table based reports to streamline regular operational reporting.
Education
Certifications
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.