VEERESHPATIL G S

Accenture – Client: Ford Motor Company

• Led schema migration efforts from Teradata (TD) to PostgreSQL and Google BigQuery, ensuring seamless data structure adaptation across platforms.
• Identified and resolved migration-related schema issues, especially in datatype mismatches, column compatibility, and view transformations between TD and PostgreSQL.
• Conducted detailed analysis of schema limitations and platform constraints, aligning technical solutions with Ford’s business requirements and expectations.
• Collaborated closely with cross-functional teams to design and validate schema migration strategies, optimizing for performance and scalability.
• Diagnosed complex data integrity issues in tables and views post-migration, implementing varied troubleshooting approaches for different platforms.
• Played a key role in defining best practices for schema conversion methodologies, enhancing process repeatability and minimizing risk across future migrations.

• Successfully orchestrated and managed intricate data workflows using Google Cloud Dataflow, ensuring seamless data movement and transformation in alignment with business requirements.
• Designed and implemented robust data pipelines, following industry best practices and utilizing GCS for storage.
• Leveraged Apache Airflow to create and maintain data workflows, providing scheduling, monitoring, and dependency management for critical data processes.
• Developed and executed reconciliation processes in Big Query to validate data accuracy and consistency across different stages of the data pipeline, mitigating potential data discrepancies.
• Incorporated Cloud Functions for automation within the data processing workflows, seamlessly interacting with GCS.
• Implemented an automated data by using cloud monitoring system to detect and alert on data anomalies
• Monitored data loads and provided Timely support to troubleshoot issues, optimize performance, and ensure the smooth ingestion and storage of data.
• Prioritized and organized tasks to efficiently accomplish service goals.
• Completed day-to-day duties accurately and efficiently.
• Modified existing software systems to enhance performance and add new features
• Utilized Google Cloud Platform (GCP) services such as Big Query and Google Analytics to gather and analyse campaign data while protecting personally identifiable information (PII) with encrypted and hashed identifiers.
• Developed and executed strategies for CCPA compliance within digital marketing campaigns, implementing stringent data privacy measures
• Spearheaded initiatives to streamline user data deletion requests, employing Python scripts for automated data ingestion and deletion workflows.
• Collaborated cross-functionally to enhance ingestion processes, ensuring seamless updates to Big Query and Google Analytics datasets in compliance with CCPA guidelines.
• Developed and maintained documentation for data handling procedures and compliance measures, ensuring transparency and accountability in data governance practices.
• Provided technical guidance and training to teams on data privacy best practices and compliance requirements.