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