Vivek Tewari

Responsibilities

• Worked on projects for major US-based MNCs
• Managing Data in Azure Data Warehouse
• Ingest, Process & Create Data Models in Databricks Using SQL, Python, & PySpark
• Build Pipelines & Other Services in Azure Data Factory to ingest data from various sources

Projects

Supply Chain Resilience

• In this Project, I'm a part of the data engineering team, which is responsible for managing ETL using ADF, databricks notebooks, MS-SQL, Python, and PySpark to process raw data & make data models.
• Responsible to maintain MS-SQL Databases & creating T-SQL, Stored Procedures & Functions
• Responsible for managing Pipelines and Other features of Azure Data Factory to ingest data from various sources.

Responsibilities

• Lead Backend Development Team.
• Provide Reports throughout Organization using Self made Reporting tool and MyDBR Reporting Tool.
• Write Complex MySQL Queries, Build Stored Procedures & Functions in MyDBR Reporting Tool
• Provide Data Insights & Visualizations by analyzing data using MySQL, Excel, and R.
• Manage MySQL Database and perform Bulk DB Operations.
• Create & Manage Linux EC2 Instances on AWS to run Nginx web servers.
• Developed & Manage Reporting engine in Laravel on AWS.
• Started working to move existing ETL process to Azure Data Factory
• Work as Back-end developer.
• Train Data Interns

Achievements

• Promoted as Tech Lead on Aug - 2021.
  
• Promoted as Associate Tech Lead on Oct - 2019.
  
• Promoted as Sr. Software Developer on Oct - 2018.

Projects

MyDBR Reporting Tool

• Configure LEMP in EC2 instance of AWS to run this tool
• Create MySQL Stored Procedures with complex & multiple SQL Queries to build KPI Dashboards, Graphs & Charts.
• Build Stored Procedures to perform ETL operations from Transactional DB to Reporting DB and schedule these procedures using the cron job feature of this tool.
• Alert notifications and daily business reports are made and scheduled in this tool to provide business data to stakeholders every morning.

Laravel Custom Reporting Tool

• This Reporting tool is a Custom In-house application built on MySQL, Laravel & PHP by myself
• In this tool, you can submit your MySQL query and make a new report which you can Download, Schedule, Send to Email, and View.
• You can also parameterized your SQL query so that user can download dynamic reports as per their need.

CMS / Backend Panel Development

• I was part of Backend Development Team which is repornsible to built & manage CMS Portal using Laravel & PHP
• Requiremnet gathering, Bug fixing and Task asssignments to developers were part of my job

Bulk MySQL Database Operations

• I was responsible for moving bulk data between Database Instances.
• Performing DB Cleanup and Table Optimizations were some key roles of me in this project
• Responsible to mange & configure Reporting Instances on AWS

Responsibilities

• Start working as a Dot Net Developer.
  
• Manage MS-SQL Databases for Multi Networking businesses
• Made online and offline standalone applications for mid-range businesses using C# and MS-SQL Server.
  
• Switch work domain to web development

Achievements

• Achieved Rising Star award.
  
• Achieved Best Employee award.

Projects

Multi Label Marketing (MLM) Management System

• This system manages all the account transactions through out satellite branch as well as main branch and calculate agents commission from a complex algorithm.
• Manging Large volumne data from various branches in MS-SQL by writing Complex T-SQL Queries and Stored Procedures
• Technology Used: .net framework, C#, MS-Sql Server, Crystal Report.

Cold Storage Management

• This system manages inventory, accounts, chalan printing of a Cold Storage.
  Cold Storage keeps large number of inventory from a huge number of customers (farmers). So that it is dificult to mange all this manually and here this system serve his purpose very well.
• Technology Used: .net framework, C#, MS-Sql Server, Crystal Report.

Attandance Management System

• Intrigated with finger print scanner this system takes attandance and calculate shifting hours.
• Also it capable to produce payslip based on employee's attandance.
• Technology Used: .net framework, C#, MS-Sql Server, Crystal Report.