Senior Data Analyst / Data Engineer

I develop complex Oracle SQL solutions to analyze enterprise healthcare datasets and investigate production data anomalies across data warehouse and OLTP environments.

I design and maintain PL/SQL stored procedures, packages, functions, triggers, and cursors to automate validation, transformation, and reconciliation processes. I also use analytical SQL functions and performance tuning techniques to improve batch processing and reporting efficiency.

In addition, I build RAG and LLM-based solutions with FastAPI and vector databases to support intelligent retrieval and natural language access for enterprise healthcare data.

I developed and optimized Oracle SQL queries to support production analysis, enterprise reporting, and daily reconciliation workflows.

I investigated data anomalies, performed root cause analysis, and supported production validation and break-fix activities across warehouse and ODS environments. I also monitored Control-M scheduled ETL workflows and validated data replication between operational systems and enterprise data warehouses.

I worked in Agile environments while supporting multiple production requests and maintaining metadata, data dictionary, and lineage documentation.

I developed complex SQL queries and Oracle PL/SQL routines to analyze Medicare claims and enterprise healthcare data.

I collaborated with business, ETL, DBA, and QA teams to validate transformation logic, investigate production issues, and support ETL validation and deployment activities. I also maintained data governance artifacts such as data dictionary, lineage, metadata, and business rules.

I performed data cleansing, reconciliation, and query tuning to improve reporting quality and operational insights.

I developed Oracle SQL queries and PL/SQL procedures to support enterprise healthcare reporting and operational analytics.

I designed triggers, stored procedures, functions, cursors, and packages, and used analytical functions, BULK COLLECT, FORALL, and exception handling to improve batch processing performance. I also supported data warehouse and ETL validation activities.

I worked with ETL developers, business analysts, and DBAs to troubleshoot ETL failures, document mappings, and improve data quality through cleansing, reconciliation, and production validation.