Vaibhav Shah

Design and implement data pipelines using AWS services such as S3, Lambda and Glue. Build and maintain data warehouse and data lakes using AWS Redshift and Athena. Develop and maintain ETL workflows using AWS step functions and created Eventbridge rule to schedule the workflows. Collaborate with the Data scientists and MIS users to provide data insights and support their data needs. Created dashboards using Quicksight for visualisation purpose. Developed cube based on the business requirements to analyse the data of different products. Extract and Transform data from multiple sources using SSIS tool. Created calculated members in SSAS using MDX queries. Creating partitions in SSAS in order to improve the performance. Working on star schema to build cube using the fact and dimension tables. Partial processing of cube by scheduling jobs in sql server.

Created windows forms using C#, working with gridviews, and exporting data from the database to excel using .Net properties. Involved in database design, including creating tables, Joins, and procedures.

Developed parameterized, drill down, and linked reports using SSRS. Involved in job scheduling and monitoring for automation processes. Performed SQL scripting and writing complex queries to meet business logic and generate reports. Created and maintained SSIS ETL packages to extract data from different sources such as flat file and excel file, and transforming the data into the database. Worked on front-end web applications using C#.Net.

Developed business logic for computing revenue of different products, including creation of packages, writing complex queries, error handling, scheduling etl jobs, creating procedures, and query optimization. Responsible for optimizing SQL queries and stored procedures to improve performance time. Implemented proper use of views to prevent unauthorized access to sensitive data. Created SSIS packages to extract source data of different products and load into the database, performing necessary transformations.

Created web pages using HTML, CSS, and jQuery. Managed regular website updates, installation, and activation of plugins on WordPress. Converted PSD files to HTML. Tracked behavioral flow using Google Analytics and created templates for email marketing.