JYOTIRANJAN TRIPATHY

Serve as a Senior Technical Architect leading an elite cross-functional team of 16 engineers. Own end-to-end architectural blueprints and solution delivery for multi-million-dollar modernizations.

Project 1: Global Supply Chain Analytics Modernization (Client: Ericsson)

• Objective: Modernize and consolidate a legacy ecosystem of heterogeneous, disconnected supply chain systems into a single, global, centralized data access platform to cater to enterprise business users.
• Engineered semantic data models and scalable layers in Snowflake using Data Vault 2.0 to capture and refine data structures from SAP S/4HANA and disparate source systems, enhancing data accessibility for enterprise users.
• Pioneered automation system leveraging Snowflake Cortex AI and LLMs (Claude/GPT-4) to ingest execution metadata and analyze performance trends, enabling auto-generation of optimized query codes for improved query performance.
• Resiliency Engineering: Designed highly resilient, metadata-driven frameworks for pipeline restart ability, error handling, failure recovery, and real-time alerting using Streamlit and Snowflake stored procedures.
• Tech Stack: Snowflake (Cortex Analyst, Snowpark), AWS (SageMaker, Bedrock), AWS Glue, Databricks, dbt, SAP HANA, Azure DevOps, QlikSense, PowerBI.

Project 2: EDW Modernization & Migration (Client: NXP Semiconductors)

• Objective: Design an enterprise-grade cloud data warehouse platform capable of handling highly complex semiconductor manufacturing plant data and transactional factory floor metrics.
• Drafted technical proposals and delivered proof-of-concept (POC) frameworks for expansive Snowflake on Azure implementation, facilitating stakeholder buy-in and project direction.
• Data Pipelines & Lineage: Designed end-to-end ETL architecture utilizing Talend Data Fabric and created ingestion models within Talend Data Catalog 8.0 to enforce strict enterprise metadata governance.
• ERP Database Integration: Orchestrated data engineering workflows to support a major corporate migration from legacy SAP ECC databases to S/4HANA, safely piping data through to Teradata Vantage and Snowflake layers.
• Tech Stack: Talend 8.0 Data Fabric, Azure Databricks (PySpark), Teradata Vantage, Oracle, Snowflake on Azure, S/4HANA, Git, Azure DevOps.

• Spearheaded big data engineering, cloud migrations, and performance optimization for a high-volume healthcare product portfolio powered by advanced Speech Recognition, NLP, and NLU engines.

Project 1: Fluency Align (Auto-Scribing Data Platform)

• Core Impact: Migrated the core reporting platform from a legacy PostgreSQL dimensional data model into an agile, highly performant Data Vault 2.0 architecture on Snowflake.
• Performance Engineering: Rewrote legacy NoSQL data extraction mechanisms into specialized native MongoDB JavaScript queries, slashing data extraction and CSV conversion times from 5 hours to just 20 minutes.
• Hybrid Cloud Design: Formulated hybrid data warehousing schemas, implementing incremental data extraction strategies using Change Data Capture (CDC) tracking on AWS DocumentDB.
• Tech Stack: Talend Cloud for Big Data 7.3, PostgreSQL 12, Amazon MSK, MongoDB 4.2, AWS (Lambda, EC2, S3, CloudWatch), Snowflake on AWS.

Project 2: Fluency For Imaging & Fluency Direct

• Massive Scale Infrastructure: Acted as a primary architect coordinating the massive physical data center migration to AWS across five global regions (US, UK, Germany, Canada, and Sydney).
• Analytical Logging Systems: Developed real-time application log analysis pipelines, ingesting system data through Amazon MSK and routing it to Elasticsearch and Splunk for rapid system diagnostics.
• Big Data Lake Delivery: Managed a 200 TB capacity analytics lake on Amazon Redshift, structuring optimized workflows to parse and ingest unstructured XML records using XQuery and REST APIs.
• Tech Stack: Talend Cloud, Redshift, AWS Lambda, Ansible, Terraform, Perl, SpagoBI, Kafka, StreamSets, MarkLogic.

Project 3: CDI Collaborate & CDI Engage (Computer-Assisted Documentation)

• Operational Optimization: Managed hourly batch data pipelines processing high-velocity clinical data. Optimized transactional MongoDB queries to strictly enforce indexing rules, minimizing source system processing overhead.
• Tech Stack: Talend Open Studio 6.3, PostgreSQL 10, Oracle 11g, MongoDB, MarkLogic, Elasticsearch, PowerShell, Perl.

• Process Optimization: Managed the Sales Incentive Quota Performance (SIQP) operational data store, processing sales transactions to feed downstream compensation engines.
• Automation: Engineered master job start/end automation via UNIX scripting, implementing advanced parameterization and Slowly Changing Dimension (SCD Type 2) data loads inside Informatica.
• Tech Stack: Informatica PowerCenter 9.5, Oracle 11g, TOAD, HP-UX, PL/SQL, SSIS, Business Objects.

• Data Integration: Directed ingestion pipelines for COOP, the second-largest retail chain in Sweden, successfully centralizing and parsing complex corporate transactional data streams flowing out of 40 disparate source systems.
• Tech Stack: Informatica, Oracle 11g, PL/SQL, UNIX Shell Scripting.

• Global Product Delivery: Co-developed the Oracle Airlines Data Model (OADM) for Oracle Technology, delivering a standardized, pre-built enterprise airline data warehouse product made available via the Oracle e-Delivery cloud.
• Custom Software Engineering: Authored a standalone validation utility (.exe) using PowerShell for client QANTAS Airlines, allowing one-time configuration profiles to automate partner loyalty data formatting.
• Tech Stack: Informatica 9.0, Oracle 10g/11g, Siebel Loyalty, PL/SQL, Erwin, OBIEE, UNIX.