Riya Patel Email & Phone Number

•Enhanced performance and cost-efficiency of Redshift queries through advanced tuning and strategic resource management.•Ensured minimal downtime and uninterrupted BI operations by providing expert technical support.•Strengthened data protection and compliance in Azure Cosmos DB by designing custom data encryption and robust security measures.•Enabled seamless metadata sharing across AWS accounts by setting up cross-account access for AWS Glue Data Catalog.•Facilitated integration with external services by managing service connections in Azure DevOps.•Ensured effective historical data storage and regulatory compliance by configuring data archival and retention policies.•Enabled sophisticated data transformations in BigQuery with scripting languages (JavaScript,Python).•Revolutionized ETL processing in Azure Data Lake by optimizing integration with Azure Data Flow.•Created and managed Power BI datasets with advanced data transformation and enrichment for accurate and insightful visualizations.•Enhanced data security by using Azure Key Vault’s HSM-protected keys for applications with stringent security requirements.•Improved database performance through effective partitioning and indexing strategies.•Utilized Bayesian hierarchical models to enhance accuracy and interpretability of complex data analysis.•Optimized QlikView applications to handle large datasets for enhanced performance and scalability.•Leveraged Azure Databricks AutoML for automated machine learning model selection and tuning.•Implemented Blob Storage event notifications in Azure Logic Apps, automating workflows on data changes to improve process efficiency.•Enhanced data governance frameworks.•Utilized Azure Purview’s AI-driven recommendations to enhance data asset discoverability and relevance.•Integrated multiple data sources into a BI platform on Azure, utilizing Azure Data Lake Storage and Azure Data Factory to streamline data ingestion & transformation processes.

Hartland, New Brunswick, Canada

•Ensured data integrity and governance compliance by data versioning and rollback support in BigQuery.•Optimized data utilization in Azure Data Lake with comprehensive metadata management processes.•Streamlined workflows by integrating Azure Databricks with other Azure services.•Enhanced code management and collaboration by configuring secure source code repositories in Azure DevOps.•Improved data governance through data stewardship programs, assigning ownership, and ensuring accountability for data assets.•Ensured traceability in code changes by using Git cherry-pick with signed-off commit messages.•Safeguarded data from accidental deletions and ensured compliance by implementing Blob Storage soft delete and retention policies.•Enhanced data privacy in Snowflake with data masking and tokenization features.•Improved data accessibility by managing cloud-to-cloud integration using Azure Data Factory.•Enhanced security by configuring access controls for Azure Synapse, restricting data access to authorized users.•Ensured data consistency across servers by configuring OLAP and OLTP replication processes.•Leveraged Azure Purview to establish data lineage connections, enhancing visibility of data flows.•Ensured data resilience by implementing data replication and mirroring for disaster recovery.•Enabled proactive monitoring by creating alerts and notifications in Power BI.•Addressed business requirements and enhanced data extraction & loading by developing custom SSIS components using .NET and C#.•Controlled access to sensitive information by designing data security models in QlikView.•Enhanced data storytelling with custom visualizations in Plotly.Key Project•Developed a data governance framework for a government agency, ensuring compliance with data protection regulations and establishing best practices for data management.•Designed and implemented a data governance framework for a BI solution on Azure, ensuring data quality and regulatory compliance.

Bengaluru, Karnataka, India

•Assisted in building the ETL source to Target specification documents by understanding the business requirements.•Converted the PL/SQL Procedures to Informatica mappings, creating procedures at the database level for optimal performance.•Implemented performance tuning on a variety of Informatica maps to improve throughput.•Created DTS packages to copy tables, schemas, views and extract data from Excel using SSIS.•Expertise in creating Report Models for building Ad hoc reports using SSRS.•Developed event Triggers on executing insert, delete and update stored procedures.•Optimized existing stored procedures to achieve improved performance.•Optimized T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.•Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.•Developed Cross-Tabbed and Sub-Reports in SSRS.•Generated occasional reports in view of the factual investigation of the information utilizing SQL Server Reporting Services (SSRS).•Extensive experience in Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.•Migrated and recreated existing dimensions and cubes using star schema on 2005 server to achieve the efficiency of SSAS.•Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.•Used Look up, Pivot, Merge, Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.•Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.•Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries using SQL Profiler.•Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, & Resource Utilization.

Master'S Degree, Applied Computing

Bachelor'S Degree, Computer Engineering