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.

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.

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.

Master'S Degree, Applied Computing

Bachelor'S Degree, Computer Engineering