Duration
18 March 2025 - 09 March 2026
Technology Stack
Next.jsPrismaTailwind CSSPostgreSQLMySQLMongoDBRedisBullMQHighchartsshadcn/uiZoho EmailDigital OceanPM2Nginx
Section 1 of 6
Overview
Renewalytics Services Pvt. Ltd. is a New Delhi-based company specializing in AI-powered renewable energy forecasting and grid management solutions. The company leverages advanced ML/DL models, weather intelligence, and digital twin technology to help integrate solar, wind, and hybrid renewable energy projects seamlessly into the grid while ensuring DSM compliance and optimal performance. Renewalytics manages 3.22+ GW of capacity with >92% forecast accuracy, providing 24*7 RTC support across 13+ state networks covering 34+ total sites with 45+ compliance automation processes. Key clients include TrueRe, Dalmia, ReNew, Refex, UPC Renewables, SEIT, Sembcorp, Avaada, SPRNG, ACME, Amplus, LR Energy, Ampin, and Gentari.
Section 2 of 6
Responsibilities
Client Engagement
- Connect with clients to understand their requirements and translate them into technical solutions.
- Act as a bridge between technical teams and clients, ensuring clear communication and requirement alignment.
- Work with major renewable energy clients including TrueRe, Dalmia, ReNew, Refex, UPC Renewables, SEIT, Sembcorp, Avaada, SPRNG, ACME, Amplus, LR Energy, Ampin, and Gentari to deliver customized forecasting and grid management solutions.
Full Stack Development
- Developed and maintained 3 major full-stack applications using Next.js, Prisma, Tailwind CSS, PostgreSQL, MySQL, and MongoDB.
- Took complete ownership of application development lifecycle from requirement gathering to deployment.
- Designed and implemented responsive UI/UX components using shadcn/ui and Tailwind CSS ensuring cross-device compatibility.
- Implemented role-based access control (RBAC) systems across all applications for secure user management.
Infrastructure Management
- Managed server infrastructure using Digital Ocean, PM2, and Nginx.
- Monitored system logs and ensured optimal server performance and uptime.
- Set up and managed cron jobs for automated data fetching and processing tasks.
- Implemented automated database backup strategies for PostgreSQL, MySQL, and MongoDB to ensure data integrity and disaster recovery.
- Regularly cleared MongoDB logs and optimized storage to manage limited server resources efficiently.
- Optimized APIs and database queries for improved application performance.
Integrations
- Integrated Zoho Email API for automated email notifications and alerts.
- Developed scripts to fetch data from multiple sources including SFTP, FTP, and various client APIs.
- Implemented satellite data fetching from FTP servers for DGR (Distributed Generation Resources) integration.
Section 3 of 6
Project 1: FNS (Forecasting & Scheduling Platform)
Overview
- Company's flagship subscription-based product managing 3.22+ GW of renewable energy capacity.
- Handles solar, wind, and hybrid plants with STU (State Transmission Utility) and CTU (Central Transmission Utility) classifications.
- Led the complete revamp of the FNS platform using Context API for state management, shadcn/ui for modern UI components, and Highcharts for data visualization.
Key Achievements
- Improved application performance by 80% through implementation of caching, memoization, and Context API optimization.
- Managed 34+ plants across 13+ state networks with automated data fetching at 1-minute, 5-minute, and 15-minute intervals based on client data formats.
- Developed robust backend scripts for data collection from multiple SFTP, FTP, and API sources.
- Implemented dual database architecture using MySQL and MongoDB for efficient data management.
- Set up automated database backup systems and log management to optimize server resources and ensure data safety.
- Regularly upgraded APIs to incorporate new requirements, enhance performance, and adapt to evolving business needs.
- Achieved >92% forecast accuracy across all managed sites with 24*7 RTC support and 45+ compliance automation processes.
Features
- Replaced old table-based data displays with interactive Highcharts visualizations to show differences between manual and model forecast data.
- Built modern, accessible UI components using shadcn/ui component library for consistent design system.
- Implemented role-based access control for operations and ML teams.
- Created automated report generation system for plant performance calculations.
- Developed features to support smooth operations for both operations teams and ML teams.
- Built comprehensive dashboards with Highcharts for real-time data visualization and trend analysis.
- Designed intuitive interfaces for managing DGR data and plant-specific calculations.
- Enhanced and upgraded existing APIs to accommodate new client requirements and improve system functionality.
Technical Highlights
- Utilized Highcharts for advanced data visualization including time-series analysis, comparative charts, and performance metrics.
- Leveraged shadcn/ui components for building responsive, accessible, and visually consistent user interfaces.
- Implemented Context API for efficient state management across the application.
- Established database maintenance routines including regular backups and MongoDB log rotation to manage storage constraints.
- Iteratively upgraded APIs to support new features, improve performance, and meet changing client specifications.
Section 4 of 6
Project 2: ExcelFlow
Overview
- Client-based project managing data from 33 renewable energy plants (solar and wind).
- Most challenging project requiring rapid development to meet tight client deadlines.
- Tech stack: Next.js, PostgreSQL, Redis, BullMQ, Zoho Email integration.
Technical Challenges
- Processed large XLSB files (minimum 15MB) uploaded by plant zonal heads, with each file containing 16+ sheets.
- Handled inconsistent data formats across sheets with different attribute names for similar data.
- Dealt with varying date formats across different sheets requiring intelligent date parsing.
- Implemented binary search algorithm combined with date indexing (checking every 100th index) to efficiently locate target date data in large files.
- Managed storage limitations through efficient database design and regular maintenance including backups and log cleanup.
Performance Optimizations
- Implemented parallel sheet processing using BullMQ for fast data scraping and processing.
- Created plant-specific configuration files for XLSX sheet formats, making error handling and debugging easier.
- Utilized PostgreSQL for efficient storage and retrieval of processed data.
- Leveraged Redis for caching and improving response times.
- Optimized database storage through automated backup schedules and log rotation strategies.
Features
- Generated 32+ notifications per plant based on processed data.
- Developed separate calculation logic and reports for solar and wind plants.
- Created multiple report types for solar plants with plant-specific calculation logic.
- Implemented automated email alerts and reports via Zoho Email integration.
- Built Highcharts dashboards for site analysis, plant analysis, plant-level and inverter-level comparative analysis.
- Integrated satellite data fetching from FTP during DGR upload process.
- Matched Excel calculations with code output to ensure accuracy against client-provided references.
- Implemented authentication, verification, and password reset functionality.
- Designed responsive UI for optimal user experience across devices.
Role Contribution
- Played a key role in both UI/UX design and backend calculation implementation.
- Managed end-to-end development from data scraping to report generation and notification delivery.
- Established database maintenance practices to ensure system reliability within resource constraints.
Section 5 of 6
Project 3: RealSync
Overview
- Client-side project focused on user management and interface improvements.
Features
- Implemented role-based access control (RBAC) system for secure user management.
- Created complete authentication system including user verification and forget password functionality.
- Designed and implemented UI/UX improvements for better user experience.
- Developed responsive interface ensuring compatibility across different devices and screen sizes.
Section 6 of 6
Conclusion
At Renewalytics, I've gained invaluable experience in the renewable energy sector, working on mission-critical applications that manage 3.22+ gigawatts of clean energy capacity across 34+ sites in 13+ state networks with >92% forecast accuracy and 24*7 RTC support. The role has strengthened my skills in full-stack development, performance optimization, complex data processing, and client communication. Working on challenging projects like ExcelFlow taught me how to solve complex technical problems under tight deadlines, while managing FNS—the company's flagship product with 45+ compliance automation processes—gave me end-to-end ownership experience. The exposure to renewable energy domain, combined with hands-on experience in infrastructure management, database administration, and multi-database architecture, has significantly enhanced my technical expertise and problem-solving abilities in real-world production environments.