Trilochan Satapathy.

Tracn Inc. - Delaware, USA

Data Engineer working remotely from Bhubaneswar. Architect and maintain the company's data engineering platform (Python, FastAPI, PostgreSQL, Neo4j) powering ingestion, storage, and retrieval of heterogeneous, graph-structured data.

Build ingestion and transformation pipelines that normalize data from APIs, structured sources, and web-based acquisition into a consistent, queryable format.

Enforce data quality with Pandera/Pydantic-based validation, along with provenance and audit trails that trace every record back to its source.

Ship internal Streamlit tools for pipeline operations, data review, and QA, streamlining day-to-day operational workflows.

Cover ingestion workflows with offline, fixture-based automated tests, removing reliance on live external sources during development.

Containerize and deploy services with Docker on Railway for repeatable, maintainable production releases.

Mentibus Inc. - San Francisco, CA, USA

Fullstack Engineer working remotely from Bhubaneswar. Built and maintained full-stack applications using Next.js, TypeScript, Node.js, and PostgreSQL, continuing the architecture and development patterns established at Yadara.

Developed responsive frontend features and backend APIs using Next.js and TypeScript, with PostgreSQL as the primary data layer.

Designed and optimized database queries and application data flows for production features.

Worked across the full application stack, from UI and API development to database design and deployment.

Contributed to production systems through feature development, debugging, code reviews, and technical improvements.

Company acquired by Tracn Inc. in June 2026.

Yadara LLC - Austin, TX, USA

Senior Fullstack Engineer working remotely from Bhubaneswar. Maintained a high-traffic ticket marketplace using Next.js 14, Node.js, PostgreSQL, OpenSearch, and AWS. Integrated new features.

Set up OpenSearch to index 70,000+ event pages with geolocation-based search, improving result relevance and reducing load times by 40%.

Optimized slow SQL queries and added proper indexes, cutting query execution time by 55% for reporting dashboards.

Migrated frontend components to Next.js Server Components, improving Google PageSpeed scores from 50 to 80+ and making development 25% faster.

Deployed Dockerized microservices on AWS EC2 with Load Balancers.

Integrated real-time inventory syncing with VividSeats, StubHub Intl, and HelloTickets to keep seat availability accurate.

Created custom SVG seat maps for venues without third-party maps, improving user experience and conversion rates.

Led code reviews, sprint planning, and mentored junior developers on TypeScript best practices and testing.

Abtris Consulting and Labs - Bhubaneswar, Odisha

Fullstack Developer building and maintaining production web applications using Next.js, Gatsby, React, Node.js, PostgreSQL, and AWS across multiple client and internal projects.

Developed high-performance and SEO-focused applications, achieving improvements of up to 50% in page load times and 30% in organic search performance.

Built data-driven admin dashboards and content management systems using React, PostgreSQL, Supabase, Firebase, and BigQuery, including applications handling 10,000+ content items.

Ethnic Republic - Bhubaneswar, India

Web Developer and Admin building and maintaining e-commerce applications using OpenCart, WordPress, and React, including PayPal and PayUMoney payment integrations.

Migrated the storefront from OpenCart to a React-based application, implementing Redux/Context API state management and server-side rendering with a focus on performance and SEO.

Data Ingestion & Knowledge Graph Pipeline

Personal prototype project that ingests and normalizes multi-source data into a Neo4j knowledge graph, with PostgreSQL-backed validation and source-level provenance.

Proved out the design with offline-fixture testing and a lightweight Streamlit review UI; the architecture was later adopted as the foundation of Tracn Inc.'s production data engineering platform.

Unstoppable: Mindset Builder

Architected a motivational content platform serving 10,000+ quotes using Next.js, Node.js, PostgreSQL, and BigQuery, with an admin panel and bulk CSV/JSON workflows.

Reduced initial load time by 1.5 seconds through optimization techniques.

Reading Bharat Online Library

Built a multilingual digital library with Gatsby, Next.js, PDF.js, and AWS Lambda.

Optimized static generation and SEO, driving a 30% increase in organic traffic.

Implemented AWS infrastructure with S3, CloudFront, Lambda, and Route53 for hosting and content delivery.

Unstoppable: Mindset Builder (Ongoing)

Cross-platform application designed for positive mindset cultivation. The app categorizes quotes from renowned personalities into various motivational themes.

Developed the web component using NextJS, creating dynamic category pages showcasing quotes from different authors, books, and topic tags.

Engineered an extensive admin dashboard enabling quote management by category, addition of new books, authors, and topic tags, and user account oversight.

Implemented features for creating dynamic marketing links and bulk quote uploads.

Expanded technical skills to include SQL basics and BigQuery for analytics, PostgreSQL and Supabase for data management, and NodeJs for custom cloud functions.

MyFoodBook

Platform enabling users to create accounts and share recipes.

Engineered the front-end application using GatsbyJS and Chakra UI, focusing on user interface optimization.

Developed a user dashboard using Vite and React with Ant Design components for a seamless user experience.

Implemented Firebase for data management.

Banner Magic

Platform enabling users to connect Shopify stores, retrieve product details and images, and generate marketing banners for various platforms.

Implemented Flask for API development and gained expertise in deploying Python Flask applications on Heroku.

Utilized Firestore for data management and NextJS for creating a responsive front-end.

Zombieverse

Cutting-edge application integrating NextJS, React, Web3, cryptocurrency, and NFT technologies.

Engineered a platform enabling users to collect and trade NFTs in a gamified environment.

Integrated Web3 technology to ensure secure transactions and NFT ownership verification.

Implemented Lottie animations to enhance visual appeal and user engagement.

Integrated Metamask to facilitate secure cryptocurrency transactions.

Fresh Findings

Online platform specializing in exotic fruits and vegetables.

Utilized WordPress, WooCommerce, and Elementor to create a dynamic and user-friendly e-commerce website.

Leveraged these technologies to provide an exceptional online shopping experience for customers interested in exotic produce.

Stock Analysis App

Implemented React Native for mobile app development, exploring cross-platform capabilities.

Utilized FastAPI in Python, leveraging its performance advantages over Flask.

Successfully deployed the FastAPI application to a rendering platform.

Bandita's Healing Space

WordPress website serving as an online portfolio and platform for a Psychologist.

The site showcases services, enables client connectivity through form submissions, and includes a blog for sharing insights and updates.

Implemented Contact Form 7 and other plugins to ensure a seamless experience for both the psychologist and their clients.

Circles

In-depth exploration of Flutter for cross-platform mobile application development.

Expanded skillset to include UI/UX design using Figma, enhancing capabilities in creating visually appealing and user-friendly interfaces.

Mobile Aspects

Comprehensive WordPress site optimization and migration project.

Executed a full WordPress upgrade, including theme modernization and plugin updates.

Implemented a complete UI/UX overhaul, resulting in a contemporary and visually appealing design.

Optimized site performance, achieving a 50% reduction in load times through various technical improvements.

Successfully migrated the entire WordPress installation from the original hosting service to a new provider, ensuring minimal downtime and data integrity.