How we design mutual fund unit allotment system

We tackled the challenge of efficiently managing mutual fund investment unit data from the BSE Star API. Here's how we designed a robust and scaleable system:

Data Retrieval and Processing
BSE Star updates units against orders throughout the market day. Handling this continuous influx of data was our primary challenge.

𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲𝘀

𝗜𝗻𝗰𝗿𝗲𝗮𝘀𝗶𝗻𝗴 𝗢𝗿𝗱𝗲𝗿 𝗩𝗼𝗹𝘂𝗺𝗲: The API returns tens of thousands of orders each run, continuously increasing.
𝗘𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗖𝗵𝗲𝗰𝗸𝘀: Checking each order against the database was becoming a performance bottleneck.

𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻𝘀

𝗡𝗼𝗱𝗲.𝗷𝘀 𝗮𝗻𝗱 𝗖𝗿𝗼𝗻 𝗝𝗼𝗯𝘀: We used Node.js to run scheduled jobs five times a day, fetching and processing data efficiently.

𝗝𝗦𝗢𝗡 𝗙𝗶𝗹𝗲 𝗳𝗼𝗿 𝗢𝗿𝗱𝗲𝗿 𝗧𝗿𝗮𝗰𝗸𝗶𝗻𝗴: We stored processed order numbers in a date-wise JSON file. This allowed us to skip already processed orders and only insert new ones, significantly reducing database load and improving performance.

This approach ensured timely updates and notifications for our clients, enhancing the overall user experience.

Subscribe to my newsletter

Read articles from Mutual Fund Developer directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Mutual Fund Developer

🚀 Innovative Software Engineer | Full-Stack Developer Greetings! I'm a seasoned software engineer with 4 years of experience spearheading the development of cutting-edge solutions for diverse industries. My passion lies in crafting robust software architectures and leading trans-formative projects that elevate operational efficiency and drive business growth. 🚀 What expertise in these segment Fin-tech (Mutual Fund) Project development experience KYC check system build own Build new ideas to easy work for team BSE Mutual Fund API setup Build innovative ideas to low costing of project via create automation of task. 🚀 What i Want I like to work with new ideas that build amazing something new for mass users. Learn from problem to get solution Supercharge existing work style I love to work with agile workflow 🌟 Expertise Highlights: Full-Stack Mastery: Proficient in crafting seamless web and app experiences using PHP, Laravel, Node.js, Flutter, and Angular. Strategic Project Management: Skilled in orchestrating end-to-end project lifecycles, from ideation and planning to deployment and optimization. Innovative Problem Solver: Dedicated to devising creative solutions that address complex challenges and deliver tangible results. 🔧 Technical Skills Snapshot: Languages: PHP, JavaScript (Node.js), API: API development, Frameworks: Laravel, Angular, Tools & Technologies: Docker, Git, RESTful APIs 🏢 Experience: I've championed the development and implementation of game-changing solutions that have streamlined processes and enhanced productivity across departments. I thrive in agile environments, leveraging strong communication and collaboration skills to lead cross-functional teams toward shared goals. I re-designed order flow after that 2cr SIP order managing. Mutual fund database management. 💬 Let's Connect! I'm enthusiastic about staying ahead of industry trends and leveraging emerging technologies to create impactfull software solutions. If you're seeking a proactive and versatile software engineer to elevate your team, let's connect! Reach out to explore how we can collaborate on innovative projects that make a difference.