Shreeya Patel

Data Analyst

• Recreating the AP Store Dimension table in Teradata by following an existing Oracle script, which involves building numerous supporting tables and using SQL to replicate the final integrated output.
• Automated manual report validation using Python, developing a script that identifies missing 5-minute interval gaps, skipped sequences, timestamp irregularities, date mismatches, and duplicate entries in large Excel files.
• Designed and scheduled Tableau Prep flows to automate data refreshes, and developed a Tableau dashboard to visualize GLP-1 medication trends, enabling timely insights for business stakeholders.

Business Analyst

• Facilitated pre-planning and planning activities in the Clinical Utilization Management department by organizing meetings, tracking action items, and collaborating with cross-functional teams to identify impacted neighbors and trains for feature development.
• Collaborated with product managers, developers, and QA teams to advance key MedCompass features, including integrating a Grievances & Appeals section and developing two radiation oncology transactions reports from Novologix - one summarizing error trends, and another detailing individual error records.
• Documented requirements and created user stories in Rally; tracked progress throughout the project lifecycle to support delivery and team alignment.

• Worked in an Agile environment, actively participating in sprint planning, daily stand-ups, and retrospectives while independently delivering sprint tasks tied to SLA-driven feature updates and system improvements.
• Resolved high-priority defects, including SLA mapping discrepancies across internal systems and backend logic issues that caused duplicate records and incorrect case routing.
• Built and deployed system enhancements such as SLA auto-tagging in email subject lines, pagination and search functionality in user dashboards, and CRM WebAPI automations to update case flags based on business rules.

• Designed and built a new project tracking page within an internal site, featuring an editable, searchable grid with advanced filters, real-time auto-refresh, and Excel integration for exporting, editing, and re-uploading data.
• Improved data visibility and manageability within the supply chain department by digitizing project information and reducing manual processes.

• Conducted comparative analysis of ongoing and historical projects to identify trends and generate actionable insights, contributing to timely project completion and strategic decision-making
• Used SQL to extract and consolidate data from large datasets. Built custom tables and applied advanced filters in Excel for clearer data analysis. Created bar and area charts in R to visualize trends and support data-driven decisions.