Manan Ranka

_____________________________________________________________________________

Project: Automated Data Visualization with Google Generative AI
Client: Internal Project
Duration: Ongoing

Description:
Developed an application leveraging Google Generative AI to create automated data visualizations from user queries. The system generates SQL queries, corrects them recursively, and produces Python scripts for data visualization, improving user interaction with data and decision-making processes.

Role: Developer

• Configured and utilized Google Generative AI for generating SQL queries and Python scripts
• Integrated SQLite for data storage and management
• Developed a Flask API for handling user requests and returning visualizations
• Implemented error handling and recursive query and code correction mechanisms
• Ensured secure and efficient database interactions

Key Activities:

• Configured Google Generative AI for SQL and Python script generation
• Developed a Flask API to handle user queries and return data visualizations
• Implemented SQLite database for tracking queries and responses
• Developed mechanisms for recursive error correction in SQL queries and Python scripts
• Ensured secure handling of potentially destructive SQL queries
• Utilized Matplotlib for creating and saving data visualizations
• Integrated dotenv for secure management of API keys and environment variables
• Followed agile methodologies for iterative development and continuous improvement

_____________________________________________________________________________

Project: Investment Advisory Portal

Client: Internal Project

Duration: 3 Months

Description:
Developed an Investment Advisory Portal for financial advisors and clients, featuring plan creation, rebalancing, subscription services, and advisor-client interaction with live market data integration. Utilized AI to enhance user experience and efficiency.

Role: Software Engineer

• Developed responsive interfaces using React.js
• Created robust APIs with Python and Flask
• Integrated front-end with back-end systems
• Managed data with MongoDB for scalability
• Ensured code quality through reviews and debugging

Key Activities:

• Gathered requirements and understood project scope
• Designed the system architecture and user interface
• Developed responsive and user-friendly interfaces
• Implemented MongoDB for data storage, retrieval, and management
• Integrated front-end interfaces with back-end systems for seamless functionality
• Followed agile methodologies (sprint planning, stand-ups, retrospectives) for efficient project delivery
• Collaborated with cross-functional teams (developers, testers, project managers) to achieve milestones