Data Analyst / May, 2024 — December

Consolidated siloed data systems that slowed compliance reporting by integrating them into a Snowflake platform, designing scalable schema models and secure data flows that improved reporting accuracy, strengthened audit readiness, and delivered actionable business insights. Integrated Snowflake with AWS S3 implementing star schema models to unify siloed datasets and enabling Tableau dashboards that improved reporting accuracy by 40% and delivered insights for risk reporting and lending decisions. Optimized Snowflake query performance by leveraging clustering keys, micro-partition pruning, schema design strategies, and warehouse workload tuning, reducing compute overhead and cutting dashboard latency by 30%. Collaborated with finance and compliance teams to define regulatory KPIs, design data flows (source, staging, curated) and implement validation rules, enhancing trust in audit and compliance reporting. Built automated ELT pipelines in Apache Airflow using Python + SQL for DAG scheduling and dependency management to load data into Snowflake daily, reducing refresh times by 30% and keeping Tableau dashboards up-to-date for near real-time operational and compliance decisions. Automated scalable ETL pipelines with SQL, PySpark, and AWS serverless tools (Lambda, Step Functions, Athena) to ingest and process terabytes of structured and semi-structured data daily, reducing onboarding and refresh times by 60%. Developed visually appealing and interactive dashboards using Power BI's Power Query and DAX for effective data visualization and storytelling. Implemented granular IAM-based security policies across AWS data pipelines, safeguarding sensitive financial data and ensuring 100% compliance with internal governance and SOC2GDPR requirements. Automated CICD workflows with Bitbucket and Terraform for ingestion pipelines, standardizing deployments across dev, test, and production environments and improving reproducibility with built-in version control. Designed an agentic LLM workflow using Python and LangChain for Text-to-SQL generation with schema awareness (DB schema, tables, primary keys, foreign keys, relationships), multi-step reasoning, database interaction, and SQL-to-natural-language summarization, supporting OpenAI GPT and Hugging Face models. Gathered business requirements and documented processes using Visio process maps, maintaining documentation in SharePoint including Business Requirements Documents (BRDs), Configuration Documents (SCDs), and test plans and presenting deliverables to stakeholders. Developed predictive models (time series regression) using Python (Pandas, Scikit-learn) to forecast spending patterns and detect anomalies, improving decision accuracy and reducing false positives by 20%. Automated Excel-based risk assessment and executive reports with VBA, INDEX-MATCH/VLOOKUP, and Pivot Tables. Built Power Pivot/DAX models for 1M+ rows and centralized reports in SharePoint for stakeholder access. Built reusable Python scripts for data wrangling, data quality, and drift detection to validate schema and category-level changes in financial datasets; integrated alerts into Tableau dashboards reducing manual QA effort by 70%. Leveraged JIRA to track project progress, maintained extensive documentation on Confluence pages. Conducted knowledge training sessions on BI dashboards for key users, enabling self-service analytics and improving user adoption, leading to 30% fewer change requests in reports and a higher number of active report users. Conducted AB testing on Tableau dashboard layouts and navigation flows, improving usability and increasing stakeholder engagement by 15%.

Data Analyst / December, 2020 — June, 2023

Designed and delivered Power BI dashboards by integrating Oracle Fusion OTBI subject areas with Power Query/DAX, tracking 10+ KPIs (product lifecycle status, product readiness, % approval rates, user adoption metrics); presented insights to leadership and boosted executive decision-making by 25%. Developed scalable data models and SQL queries in Oracle OTBI to design 40+ reports tracking product lifecycle and change management KPIs, reducing dashboard load times from 25s to 15s and enabling self-service analytics. Applied statistical methods for trend analysis and anomaly detection on 1.2M+ records and conducted AB tests to identify inefficiencies and optimize Invacare’s supply chain for cost savings and revenue growth. Developed custom SQL-based data models in BI Publisher and tuned queries (joins, indexing, parameterization) to extract large medical device datasets (500k records) from Oracle Fusion database tables; optimized runtime by 40%. Automated scheduling of pixel-perfect BI Publisher reports by aligning to business cycles (daily, monthly, quarterly) and staggering heavy jobs during off-peak hours, which reduced server load and guaranteed timely delivery to stakeholders. Implemented BI Publisher bursting schedules to consolidate data processing into a single execution and distribute role-specific outputs in multiple formats (Excel, PDF, CSV) via email/SFTP; improved accessibility for 50+ global users. Maintained governance and audit readiness for scheduled reports by retaining job history for traceability and validating outputs, parameters, and delivery channels; reduced redundant schedules by 25% and ensured full compliance. Led UAT and data validation across integrated systems to ensure accuracy and reliability; supported quarterly Oracle Cloud release cycles by executing regression scripts, validating fixes, and maintaining stability of the PD module. Conducted root-cause analysis on part revisions and change impacts to prevent inventory errors; provided hypercare support post go-live by resolving defects, enhancements, and integration issues. Configured Role-Based Access Control (RBAC) for 150+ global users via Oracle Security Console, preventing unauthorized changes and achieving zero findings in internal IT audits. Collaborated with 3+ cross-functional teams (Product Operations, Supply Chain, Engineering) to gather requirements, create business requirements documentation (BRD) and deliver dashboards to support board-level strategic planning and data-driven decision-making. Led Agile PLM to Oracle Cloud PLM migration by leveraging FBDI templates (ZIP via UCM) for item, BOM, and ECO data loads. Developed Excel/SQL pre-validation scripts to enforce attribute and LOV compliance, eliminating 95% of staging import errors and ensuring data integrity for go-live. Configured 200+ product and regulatory attributes, BOM structures for PD module and built Oracle Integration Cloud (OIC) workflows to automate change orders and data mapping, cutting ECR/ECO cycle times up to 80%. Implemented UDI attributes (FDA product codes, submission numbers, marketing authorization types) and automated UDI/CO submission workflows to meet medical device regulatory requirements with validation and error-handling logs to achieve 100% FDA submission accuracy and enhance compliance tracking.