Vinay D Email & Phone Number

Oshawa, On, Ca

Oshawa, On, Ca

Winnipeg, Manitoba, Canada

• Developed a production level application to migrate the data from legacy systems to Snowflake. • Designed and developed reporting dashboards for business through DOMO. • Designing architectures for deployment or implementation in multistate environments. • In-depth understanding of Snowflake database schemas and table structures. • Determine the Snowflake virtual warehouse sizing based on the workload. • Implemented data migration to Snowflake data warehouse from multiple data sources. • Bulk loading from the external stage (AWS S3), internal stage to Snowflake via copy command. • Used SNOW PIPE for continuous data ingestion from the S3 bucket. • Working knowledge of AWS cloud services such as EC2, S3, RDS, Athena, Lambda and Glue. • Perform troubleshooting to analyze and resolve critical issues. • Deployed applications in AWS cloud through Streamlit. • Have good knowledge of ETL and hands-on experience in ETL.

Montreal, Quebec, Canada

• Azure data factory to ETL package and pipelines • Migrated DTS packages from SQL Server 2008 to 2016 and scheduled their execution time.• Created SSIS packages using Active X scripts and with Error Handling.• Wrote stored procedures for report generation in SQL Server2016.• Successfully deployed reports in various sources like XML, Web browser and PDF.• Working on Document databases to query and Experience in creating hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.• Experience in Creating DAX Expressions create Date to yearly columns and implement partitions in Tabular Models for Power BI.• Experience on publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for upcoming data in power BI server.• Experienced on creating multiple kind of Report in Power BI and present it using Story Points. • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Power BI.• Worked on Python script for ETL process cloud environments• Designed ETL pipeline using python notebooks which runs on Azure Databricks • Experienced in using Apache spark for Running parallel ETL scripts. Using RDD’S• Experienced using Azure blob storage and retrieve info based on the FRD and business needs • Created and Maintained Database Maintenance Plans.

Hyderabad, Telangana, India

• Merging existing databases and designing new data models according to requirements, performing daily database backup & restoration, and monitoring database performance.• Developed T-SQL statements to retrieve data and provided performance tuning for T-SQL• Developed joins and subqueries for complex queries involving multiple tables.• Developed triggers, stored procedures, and data manipulation using DDL and DML.• For designing and testing, install and configure SQL Servers 2012 and 2014.• Solved business problems by analyzing reports and fixing bugs in stored procedures as needed.• Implemented complex Stored Procedures, Views, Triggers, Tables, and other SQL joins.• Perform validation checks to maintain the integrity of the data.• I created a robust system for the effective processing of financial data from multiple external sources after research, design, and creation.