Vivek Tewari

Responsibilities

• Designed, developed, and optimized ETL/ELT pipelines using Azure Data Engineering services (Databricks, Data Factory, Synapse).
• Implemented SQL-based solutions for data ingestion, transformation, and reporting across large-scale datasets.
• Enabled reporting by providing optimized tables and views for the Power BI team, while implementing complex logic and transformations beyond Power BI’s capability.
• Contributed to cloud data platform implementation projects (Azure & AWS) for clients like Expedia and NCR Corporation, including workload migrations and optimization.

Projects

NCR - Data Platform Implementation

• NCR Corporation, the global enterprise technology leader for restaurants, retailers, and banks, is the #1 POS software provider worldwide and a leading provider of multi-vendor ATM software.
• Migrated NCR’s legacy data platform (EDL, EDW, BO) to a modern Azure-based Big Data ecosystem.
• Designed and implemented data pipelines and schemas using Azure Data Factory, Synapse, and SQL DB.
• Enabled the organization split (CommerceCo & BankingCo) by separating data platforms to support BI and advanced analytics.
• Supported Power BI/Tableau teams with optimized tables, views, and complex transformations beyond BI tool capabilities.

Expedia

• Worked as part of the Central Triaging Team under DMG, responsible for data governance and ensuring reliability of data flows.
• Investigated and resolved data flow issues by performing root cause analysis (RCA) and documenting findings.
• Developed data quality and prediction tools using SQL and Collibra to automate checks and enhance governance.
• Supported compliance and governance initiatives by maintaining robust data validation frameworks across critical datasetsclass=""

Freeman

• Designed and implemented data pipelines to support analytics reporting using Azure Data Factory, Synapse, and SQL.
• Delivered tables and views to the Power BI team for report development, handling complex transformations not achievable directly in BI.
• Contributed to the development of scalable analytics solutions to enable real-time insights for events and exhibitions data.
• Ensured data accuracy, performance, and security while supporting reporting and business intelligence needs.

Responsibilities

• Worked on projects for Johnson & Johnson
• 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.