chetansk

Designed, Developed and maintained the Farcaster-indexer for indexing Farcaster protocol events, including following/follower interactions, utilising Kafka for consuming data on the processor side and storing it in MongoDB. Designed and implemented block-ingester, a service that reads RPC calls to store block and transaction data in Postgres. Created and optimised block-processor, a service to detect and process various types of transfers (e.g., ERC20, ERC721, ERC1155 single and batch, and WETH transfers) by analysing blocks and transactions. Spearheaded the indexing of the entire Farcaster data, leveraging Hubs, Shuttle, Kafka, Clickhouse, Materialized Views, and Kafka Engine for real-time data ingestion and efficient querying. Successfully indexed multiple chains including Base, Zora, STP , and Gold, enhancing multi-chain data processing capabilities. Worked on distributed systems, focusing on improving performance, scalability, and reliability, ensuring efficient data processing and reducing latency across services.

Responsible for building blockchain indexers for Ethereum-compatible chains while leading a team of four. Indexes block, transactions, and balances data. (https:/ /xscan.io/) Handling chain integrations and helping the company reach 1Mn in annualized revenue. Developed Price tracking service for ERC20 tokens using the data from multiple DEXs. Developed ERC20 Token details service to capture metadata like decimal, logo, symbol etc. (https:/ /docs.unmar shal.io/) Developed plan-based rate limiting and payments. Developed backend for Blockchain explorer which includes smart contract verification, NFT(inventory, holders and transactions), block details, tx details, latest blocks and txs

Replaced Redis with Azure Cosmos DB in the workforce management application backend using C#. Automated the product packing service using JenkinsPipeline, integrating build, test, regression, and deploy processes. Fostered a positive and collaborative work environment, promoting teamwork, knowledge sharing, and continuous learning among team members.

Developed a Diet planner application using the MEAN Stack (MongoDB, Express.js, Angular, and Node.js) and integrated Razorpay payment gateway, responsible for complete development. Enhanced the backend application to serve multiple clients using Node.js and MongoDB.

Developed a web app for controlling remote PacketScanHD hardware using Oracle DB for storage, .Net for the front end, and C# for the backend. Implemented features for monitoring call detail records, supporting new protocols, and developing backend functionalities. Added chart representations and implemented email and SMS sending with custom filters. Developed a CSV loader application in C# to extract and transform data from CSV files into an Oracle DB.