Vijay Anita Manivannan

Client: Ford Credit

• Designed and developed scalable data pipelines using GCP tools like BigQuery, Dataform, and Pub/Sub to support Ford Credit EDW/GDW, a data warehouse containing loan servicing and offer data
• Implemented ELT workflows using Terraform for efficient data ingestion and transformation
• Performed performance tuning on BigQuery queries and created appropriate indexes to improve query execution time
• Environment: Google BigQuery, Terraform, DataStage, Unix, Teradata, JCL, COBOL, IMS DC, DB2

Client: Anthem

• Developed and maintained Teradata scripts and Informatica mappings as part of Anthem's SPS (Strategic Provider System) project, replacing the existing EPDSv2 system
• Environment: Informatica, Unix, Teradata

Client: Ford Credit

• Designed, developed, and maintained Datastage jobs for the Ford Credit EDW, a data warehouse containing loan servicing and offer data
• Developed and maintained Mainframe teradata jobs and cobol programs to support ETL of data into the EDW/GDW
• Environment: Datastage, Mainframe (JCL, COBOL, SAS), Unix, Teradata, DB2

Client: AT&T

• Led a 9-member team in developing and maintaining the AT&T EDW, a data warehouse containing service order data for sales compensation, sales tracking, and other business initiatives

Client: Ford Motor Company

• Led a 4-member team in developing and maintaining the Global Parts Warehouse (GPW), a 60 TB Teradata data warehouse containing material management data for Ford
• Developed and maintained Teradata scripts and DataStage jobs for various GPW applications, including FOCFPSD, MCR, SLA, PDSS