Dharmistha Vekariya

Business Data Analyst Analytics Engineer @Vosyn

CA

Lead end-to-end BI projects and research and document data requirements, data collection methods, administrative policies, access rules, and user requirements.Implementing Airflow to orchestrate data pipelines; developing Tableau and Power BI dashboards using DAX and Power Query to analyze departmental KPIs across millions of records, enabling auto-refresh and reducing manual reporting by 60%.Build and optimize ETL pipelines using Python, Spark, SQL, and DBT to ingest, transform, and standardize HR, operations, and transactional data; automate workflows in Databricks with PySpark and convert raw data into Delta Lake tables.Implement secure integration between Databricks and Azure Data Lake using Service Principals and Managed Identities, applying RBAC to maintain security and compliance. Improve data scalability through partitioning and Z-order optimization.Generate weekly and monthly data quality and model performance reports using Python; apply clustering and predictive modeling to analyze translation accuracy and improve AI tool performance.Built and deployed a fraud detection model using Isolation Forest to identify abnormal purchasing patterns, preventing financial loss and strengthening internal controls.Perform advanced SQL operations, including window functions, CTEs, and conditional logic to support analytical reporting and decision-making.

Saurashtra University, Rajkot

Bachelor of computer application, Information Technology

Victorian Institute of Technology (VIT)

Master's degree, Information Technology