Resume

Experience

Download Resume
2023 - Present
Senior Engineer
Tata Consultancy Services Ltd.
London, United Kingdom
  • Designed and implemented a robust data warehouse solution using T-SQL, enabling efficient data storage and retrieval. Utilized Azure Data Factory for seamless data ingestion, migration, and integration with SQL Server jobs to automate and orchestrate data workflows.
  • Developed a Customer Data Platform (CDP) that consolidates customer data into a single comprehensive profile, encompassing all relevant details. This enabled efficient downstream marketing strategies and business process improvements by providing accurate and unified customer insights.
  • Designed and implemented an automated Data Quality Framework to identify and flag data anomalies in the data warehouse, ensuring data integrity and reliability.
  • Developed interactive and insightful Power BI dashboards to visualize key metrics and support data-driven decision-making.
  • Developed Python-based Azure Function Apps to integrate and ingest data from various sources seamlessly using REST APIs, enabling efficient and scalable data processing.
  • Developed a Python-based automated QR code generation tool for efficiently creating and managing QR codes tailored to business needs.
  • Developed a Python-based automated marathon event bib allocation framework, streamlining the process of assigning bib numbers to participants with efficiency and accuracy. Built unit tests to ensure the integrity and correctness of allocated data.
  • Developed Apple Wallet passes using Python for TCS London Marathon runners, providing digital access to bib and wave information for seamless event participation.
  • Developed a Streamlit-based Python tool for managing the bib replacement process in London Marathon, enhancing operational efficiency and improving customer experience.
  • Developed Python and SQL-based automated tools to detect duplicate contacts in the data warehouse and merge their data to fix inconsistencies in downstream systems, ensuring data accuracy and integrity.
  • Utilized Python programming for a wide range of data analysis tasks, enabling efficient processing, visualization, and insights extraction from complex datasets.
  • Leveraged Azure Logic Apps to create seamless integrations with downstream systems, efficiently pushing data from the data warehouse for near real-time processing and analytics.
2019 - 2023
System Engineer
Tata Consultancy Services Ltd.
Ahmedabad, India
  • Worked on various projects in the Data Engineering domain, focusing on ETL processes and data pipeline management.
  • Designed and implemented data pipelines using Azure Data Factory, ensuring efficient data movement and transformation.
  • Developed and maintained SQL databases, optimizing queries for performance and scalability.
  • Collaborated with cross-functional teams to gather requirements and deliver data solutions that meet business needs.

Education

2015 - 2019
GCET College
Gujarat, India
B.E.
Mechanical Engg.
Completed Undergraduation in Mechanical Engineering.
2013 - 2015
RPTP High School
Gujarat, India
Science Stream
Completed 12th grade in Science Maths stream.

Professional Skills

Microsoft Azure Cloud
SQL Databases
Business Intelligence
Data Engineering
Power BI
Web Design
Azure Data Factory
Azure Functions
Azure Web App
Azure Logic Apps
Azure Monitoring
Azure DevOps
Data Science
GIT VCS
Dashboards

Languages

Python
SQL
Java
HTML
CSS
JavaScript