Vikas Babu Maheshwari
Data Architect
Delhi NCR
Summary
A seasoned Data Architect, Data Engineer and a Developer with 13 years proven track record in Data Engineering, Datawarehousing and Datalake design and Implementation.
Professional Summary:
- Experience in leading, solutioning, designing and implementation of large scale enterprise level data driven applications, Big Data platforms, Data Lake, Data warehouse and Data Pipelines, ETLs and Data Modeling.
- Can provide end-to-end solutions for a data ecosystem including technical leadership, high level architecture, budget estimation, low level design, Infrastructure capacity planning, coding, testing, deployment and documentation.
- Extensively worked on the creation of data pipelines and ETLs to process structured and unstructured data at scale in batch and real time streaming and performance tuning of data pipelines.
- Experience in re-architecting legacy data ecosystems and drafting data migration strategy.
- Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle, SQL Server and DB2.
- Excellent hands on experience on Database Performance Tuning.
- Knowledge on Reporting tools like Cognos, Tableau and Jasper.
- Highly skilled, motivated team player with excellent communication and inter-personal skills.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
2
2
Languages
Work History
Datalake Architect
Project Name - GSTN
Gurgaon
01.2018 - Current
- Worked on Design and Implementation of highly available Datalake of 300+ TB size on Hive.
- Designed and implemented Batch and Real time Data Pipelines using Spark and Sqoop for Datalake
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Designed data models for complex analysis needs.
- Led projects and analyzed data to identify opportunities for improvement.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
Datawarehouse Architect
Client - TDS
Gurgaon
01.2012 - 12.2017
- Worked on Design and Implementation of Data Migration of 200+ TB data from Legacy Systems to New System.
- Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
- Integrated data from Flat files and other Databases to load into DB2 tables using Datastage and Shell Scripting.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Developed and delivered business information solutions.
System Engineer
Client - A leading US Bank
Bangalore
03.2009 - 10.2011
- Worked on multiple project for the client.
- Interacted with client to study and document the requirement specifications of the system.
- Participated in development phase which includes creation of new tables, procedures, packages.
- Involved in code and document review activities.
- Participated in Testing and Implementation phases of the project
Education
B.E. - Electronics & Communication
MDU
Rohtak 07.2004 - 06.2008
Skills
Datalake Architecture
Datawarehousing
Oracle PL/SQL
Hive
Spark
Sqoop
DB2
Informatica, Datastage
Timeline
Datalake Architect
Project Name - GSTN
01.2018 - Current
Datawarehouse Architect
Client - TDS
01.2012 - 12.2017
System Engineer
Client - A leading US Bank
03.2009 - 10.2011
B.E. - Electronics & Communication
MDU
07.2004 - 06.2008