5 years of experience designing, modeling, and reporting databases using Cloud native and traditional databases as a Data Engineer, ETL designer, and database architectParticipated in all phases of data warehouse development life cycle: technical design, functional requirement documents, development, production deployment, and support.Knowledge of all phases of the software development lifecycle (SDLC) and project methodologies.Participated in requirement sessions to identify feasibility of requirements, conducting data modeling review sessions for different groups of users.A specialist in dashboards and visualizations using Xcelsius2008 and Tableau7.0/8.0/8.1.Created DDL scripts to implement Data Modeling changes. Created ERWIN crystal reports in HTML, RTF formats. Published data models in the model mart, created naming convention files, coordinated with the DBAs to apply data model changes.•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.•Implemented data migration to Snowflake data warehouse from multiple data sources.•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.•Extensive experience creating customized reports using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).•Experience with logical and physical database design, normalization and data modeling using ERWIN and SQL Server Enterprise Manager.•Strong technical skills in creating drill-down reports, handling parameterized reports, and navigating stylish report layouts in SSRS.•Good SQL Server Administration skills, including backups, disaster recovery plans, database maintenance, user authorizations, database creation, tables, indexes.•Experience designing data models using UML, MS Visio, and Erwin.•Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC.
-
Ofish RestaurantsOshawa, On, Ca -
Aws Data EngineerRobinson Mar 2022 - Jul 2023Winnipeg, 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. -
Data EngineerWorkjam Jun 2020 - Mar 2022Montreal, 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. -
Business Intelligence DeveloperCapgemini May 2016 - Jul 2018Hyderabad, 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.
Vinay D Education Details
-
Electronics And Communications Engineering
Frequently Asked Questions about Vinay D
What company does Vinay D work for?
Vinay D works for Ofish Restaurants
What is Vinay D's role at the current company?
Vinay D's current role is Data Engineer.
What schools did Vinay D attend?
Vinay D attended Jntuh College Of Engineering Hyderabad.
Not the Vinay D you were looking for?
-
Vinay Patel MBA, Ph.D.
Oil Refining (Omega-3 And Other Specialty Oils)-Lipid Chemistry-OleochemicalsSummerside, Pe -
Vinay Reddy D
Azure Devops Engineer | Data Platform Engineer | Azure | Aws | Terraform | Jenkins | KubernetesGreater Toronto Area, Canada -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial