Summary
Overview
Work History
Education
Skills
Accomplishments
Courses Certifications
Timeline
Generic

Payal Mahida

Sydney,Australia

Summary

Experienced Data Engineering Lead with over 15 years in IT, focused on building scalable data pipelines, dimensional models, and enterprise integration solutions. Deep expertise in SQL, ETL development, and advanced analytics, combined with strong knowledge of data management practices including data governance, quality, and lineage. Proven track record of leading Agile teams, mentoring data engineers, and partnering with business and technical stakeholders to design and deliver impactful, data-driven solutions.

Overview

24
24
years of professional experience

Work History

Data Engineering Lead

TCS
08.2022 - Current
  • Managed design and development of data pipelines for batch and near-real-time solutions, automating data ingestion and transformation.
  • Led onboarding and migration of data from systems including SuccessFactors and UKG Pro, ensuring seamless integration.
  • Documented high-level and low-level designs while collaborating with integration teams and business stakeholders.
  • Ensured compliance with data privacy regulations during PII data ingestion, maintaining row-level and column-level security.
  • Implemented data governance practices to uphold quality, consistency, and compliance for sensitive information across systems.
  • Mentored data engineers in development best practices, emphasizing code quality and effective pipeline management.
  • Collaborated with product managers, analysts, and QA teams to ensure project alignment and timely delivery.
  • Established data observability processes for monitoring and support handovers post-go-live.

Data Modeler

TCS
07.2021 - 08.2022
  • Designed and maintained conceptual, logical, and physical data models using Erwin and sqlDBM to align with business objectives.
  • Translated business requirements into detailed data definitions and mappings, documenting thoroughly in Confluence to support analytics initiatives.
  • Led model review sessions with stakeholders to validate semantic consistency and ensure cross-functional alignment.
  • Implemented data governance best practices, enhancing data quality, compliance, and standardization.
  • Facilitated workshops to align data solutions with business strategies and project goals.
  • Partnered with architects, project managers, and business analysts for seamless integration of data models in enterprise architecture.
  • Created entity-relationship diagrams representing data structure for clear visualization.
  • Delivered training sessions on proper use of developed models for end users.

Data Scientist

VIT
03.2019 - 07.2021
  • Collaborated with business SMEs, analysts, and stakeholders to gather requirements for data models aligned with business goals.
  • Ensured data accuracy and reliability by cleaning and validating datasets across systems for quality analytics.
  • Analyzed complex datasets using advanced querying and visualization tools to derive actionable insights.
  • Developed and presented interactive dashboards that enhanced data accessibility for stakeholders.
  • Contributed to machine learning and deep learning model development through focused research and experimentation.
  • Identified patterns in large-scale datasets, preparing comprehensive visual reports for effective communication.
  • Engaged effectively with stakeholders at all levels to maintain alignment and clarity.

Researcher and Analyst

Western Sydney University
01.2016 - 02.2019
  • Conducted research and analytical methods to devise solutions for indoor navigation challenges faced by visually impaired individuals.
  • Utilized tools such as MATLAB, Tableau, SQL, Python, R, and AWS to address business problems.
  • Analyzed inertial sensor data from smartphones to recognize patterns and derive insights.
  • Developed actionable recommendations based on big data from inertial sensors in indoor settings.
  • Executed end-to-end deployment of machine learning and deep learning algorithms, including model creation, training, and testing.
  • Presented research findings at IEEE conferences and journals to diverse audiences.
  • Streamlined research processes to adhere to strict project deadlines.
  • Collaborated with supervisors and team members to formulate relevant questions and refine data collection methods.

Coordinator, IT Instructor

SVMIT
07.2005 - 05.2015
  • Developed strategies to promote products, enhancing collaboration between internal teams and partners.
  • Coordinated meetings with external stakeholders to ensure effective communication of project progress.
  • Facilitated knowledge sharing on technology trends through organized training programs and workshops.

Software Developer

NetWeb Software Pvt. Ltd.
01.2001 - 05.2005
  • Contributed to back-end development for Contentplus project, delivering high-performance, scalable code.
  • Developed and packaged software deliverables for deployment in client production environment.
  • Collaborated with project managers to establish achievable coding milestones for software releases.
  • Implemented code fixes and developed new features for future software releases and patches.
  • Administered databases by monitoring performance, resolving issues, and maintaining servers for system reliability.

Education

Doctor of Philosophy (PhD) -

Western Sydney University
Sydney, AUSTRALIA
04-2022

Master of Technology - Computer Engineering

Sardar Patel University
01.2009

Bachelor of Engineering - Computer Engineering

Gujarat University
01.2001

Skills

  • Cloud platform :GCP & AWS
  • Pipeline automation:Batch processing & NRT
  • ETL/ELT pipelines
  • Data lineage and profiling
  • Programming: SQL, Python, R, Java
  • Version control & documentation: Git, GitHub, Jira, Confluence
  • Reporting tools:Tableau & Looker
  • Data management: Collibra, PII data handling, Metadata management
  • Data modeling: Dimensional modeling, Star Schema, 3NF, Data Vault, Kimball methodology
  • Problem solving and analytical thinking
  • Technical writing and documentation
  • Effective and strong communicator
  • Collaboration and stakeholder management
  • Continuous learning & Adaptability

Accomplishments

  • Awarded Australian government RTP scholarship (2016-2019)
  • Best Project award for e-Gram Panchayat (e-Village) project sponsored by IBM and State Government.
  • Charotar Vidya Mandal Gold Medal in Master of Engineering (2009)
  • Best Student award for excellent academic and co-curricular records

Courses Certifications

  • Preparing for the Certified Data Management Professional (CDMP)
  • SQL for Data Analysis by Udacity
  • SQL Fundamentals by DataQuest
  • Big Data Technology Fundamentals by Amazon Web Services
  • Big Data 101 by BigDataUniversity, issued by Cognitive Class
  • Neural Networks and Deep Learning by Deeplearning.ai, Coursera
  • Improving Deep Neural Networks: Hyperparameter Tuning, Regularization, and Optimization by deeplearning.ai, Coursera
  • IPython Data Science Pathway by DataCamp
  • Bluemix Essentials by IBM

Timeline

Data Engineering Lead

TCS
08.2022 - Current

Data Modeler

TCS
07.2021 - 08.2022

Data Scientist

VIT
03.2019 - 07.2021

Researcher and Analyst

Western Sydney University
01.2016 - 02.2019

Coordinator, IT Instructor

SVMIT
07.2005 - 05.2015

Software Developer

NetWeb Software Pvt. Ltd.
01.2001 - 05.2005

Doctor of Philosophy (PhD) -

Western Sydney University

Master of Technology - Computer Engineering

Sardar Patel University

Bachelor of Engineering - Computer Engineering

Gujarat University

Similar Profiles

CREATE PROFILE
Payal Mahida