CorkVision is an AI-powered platform for wineries that integrates with existing operational, marketing, compliance, and shipping systems to centralize data and generate actionable insights. We are seeking student support to research and document the data schemas, authentication methods, endpoints, and transformation logic required to harmonize data from third-party platforms like MailChimp, ConstantContact, Klaviyo, RedChirp, UPS, FedEx, and Avalara into our unified data model. This is a continuation of our successful mapping work with Commerce7, WineDirect, and Shopify.

Primary Deliverables:

1. A source-to-target data mapping document for each platform (MailChimp, ConstantContact, RedChirp, FedEx, UPS, Avalara).
2. Documentation of each platform’s API structure, including endpoints, rate limits, pagination, authentication, and common response schemas.
3. Suggested transformation logic (e.g., enum normalization, timestamp conversion).
4. Identification of primary keys and relationship modeling (e.g., linking campaigns to customers or tracking numbers to shipments).
5. Identification of any data fields critical for AI analysis or business reporting.
6. Risk and limitation notes for each platform’s integration constraints (e.g., webhook limitations, lack of historical data access).

Ideal Student Background:

• Data science, information systems, computer science, or business technology
• Experience or coursework in API integration, data modeling, or business intelligence
• Familiarity with RESTful APIs and JSON data formats
• Comfort working with documentation (e.g., Swagger, Postman, or direct API specs)

Learning Outcomes:

• Gain hands-on experience in API data mapping and architecture documentation
• Understand the unique challenges of data normalization across disjointed SaaS platforms
• Learn to think through integration design from a real-world, scalable SaaS product lens
• Contribute to a real startup with direct applications in AI and business analytics

Tools or Systems Students Might Use:

• Postman or Insomnia (for API exploration)
• Google Sheets or Excel (for mapping outputs)
• Notion (for project management and documentation)
• Swagger UI / API documentation portals
• GitHub (if students are adding config or schemas)

Company Supervision & Mentorship: Students will be working closely with the founder of CorkVision and a technical advisor. Weekly check-ins will provide guidance and iterative feedback.

Long-Term Vision: This mapping project will support CorkVision’s broader roadmap of predictive analytics, automated marketing, and guest intelligence modules that rely on clean, structured data across the wine industry’s fragmented toolset​