Sophyiya S

• Led ServiceNow migration communication for Data Factory teams, ensuring awareness of updates and action items related to application team transitions.
• Developed a plan to address BigQuery scheduled query failure permissions for the FR team, coordinating with service owners and product teams. This resulted in a faster handover of scheduled query maintenance.
• Launched multiple OE products/new functionalities as a PM

-DF issues and Requests Submission Form.

-Centralized alerts setup for Success/Failure and Schedule Adherence Dashboard.

-Identifying the proper source of truth(GCP Asset Inventory List) for products such as Asset criticality Manager, etc

• Engineered a custom BigQuery backup and restore solution for Ford, leveraging features like snapshots, time travel, dataset copies, and exports. Automated this solution using Python and Terraform modules, establishing guidelines for all organizational applications.
• Configured automated BigQuery monitoring alerts at the organizational level using Cloud Run, Cloud Scheduler, and Artifact Registry services.
• Co-led Teradata infrastructure hardware renewal for China datacenters, collaborating with China purchasing and vendor teams.
• Led a complete technology stack version update for China's Teradata infrastructure.
• Optimized slot selection for GCP BigQuery projects using ML models based on historical utilization, mitigating increased billing costs.
• Delivered training sessions on BigQuery ML and its applications to a large audience as part of Learning & Development initiatives.

• Engineered a DSA BAR solution for Teradata and migrated archive jobs from mainframe to NetBackup, eliminating the need for Teradata channel nodes and resulting in estimated cost savings of $1 million for the upcoming hardware refresh cycle.
• Played major role during the initial adoption of Google BigQuery, BigQuery DTS, and BigQuery ML services using Terraform modules.
• Led multiple Teradata datacenter migrations in both North America and China, modernizing infrastructure and reducing high-impact outages.

• Led the standardization of Oracle Plant Floor database SGAs at Ford to mitigate memory depletion-related outages.
• Coordinated the implementation of Oracle Advanced Compression Option (ACO) across all databases, resulting in annual savings of $32,000.