ASHUTOSH NAYAK

• Requirement gathering and specifications from client and translate it to system.
• Development of file and query-based campaigns using Query Enrichment, Deduplication, Schedule, Recurring delivery, Update activity etc.
• Responsible for creation of Email and SMS Delivery templates and scheduling.
• Created Push notification campaigns through registration tokens.

Client: Apple Inc.

Project Title: GBI Systems Migration from Teradata to Snowflake.

Description: This project aims to transition the major finance projects primarily set up on Teradata to Snowflake.

• Built Snowflake tables, views, and procedures to support scalable data models.
• Developed Python automation scripts to extract Snowflake data and export compressed files to AWS S3.
• Engineered Snowpipe, Streams, and Tasks pipelines, and implemented CDC for continuous data ingestion.
• Worked with Airflow DAGs for scheduling, monitoring, and workflow orchestration.
• Earned recognition from clients and onsite teams for high-quality delivery.

Client: Apple Inc.

Project Title: Firebird Phase 2.

Description: The project is aimed at inducting data from the source (SAP BODS) into the GBI EDW.

• Ingested and integrated data across 24+ interfaces within the EDW.
• Built and deployed ETL workflows (File2Stage, Stage2Core), database objects, and Autosys jobs.
• Performed comprehensive UAT data validation prior to production rollout.
• Recognized by clients and onsite teams for delivery excellence.

Client: Apple Inc.

Project Title: Taiwan Corporate Income Tax.

Framework: Apple-specific, Filos ETL Metadata, GBI Deployment Tool.

Description: Project focused on reporting tax-inclusive amounts charged to application owners by Apple in compliance with Taiwan’s Corporate Income Tax (CIT) regulations.

• Delivered project components across the full SDLC lifecycle.
• Built Teradata procedures for tax computation logic.
• Developed Unix shell scripts for automated data loads and job orchestration.
• Implemented Apple-specific ELT pipelines and reporting workflows.
• Monitored source → core → semantic data flows for accuracy and consistency.
• Maintained semantic replication to sync primary and backup databases.
• Resolved production issues and high-priority support tickets.
• Created KT and transition documentation for support teams.

Client: Apple Inc.

Project Title: Primary Database Migration – EDDIES to CRESCENT.

Description: Set up target database infrastructure and executed the migration of all Finance data threads from the EDDIES environment to the CRESCENT platform.

• Coordinated with global EDW and Support teams to execute database migration activities.
• Created and promoted Finance thread objects across DEV → PROD environments.
• Implemented Apple-specific semantic replication for semantic object synchronization.
• Engaged directly with clients for requirement gathering, and led on-time delivery of project milestones.
• Received recognition from the client and onsite teams for quality delivery.