Built a backend system for an online store, setting up APIs, managing database relationships, and testing endpoints with Insomnia.
Used Flask to develop the REST API, ensuring efficient and secure communication between the client and server.
Employed SQLAlchemy for seamless interaction with the PostgreSQL database, managing product inventory, customer data, and orders.
Optimized API performance and database queries to ensure smooth system operation and scalability.
Deployed the application on AWS, ensuring high availability, scalability, and reliable performance in a production environment.
Delivered an operational and efficient backend system that meets the needs of the online store and its users.
Developed a Django-based chatbot integrating with the Salesforce API to fetch customer details in real-time based on user input.
Implemented dynamic email requests for customer lookup, providing seamless customer support automation.
Executed unit tests, including mock testing with unittest.mock to simulate Salesforce API calls and handle edge cases like missing emails and invalid inputs.
Automated API testing with Insomnia to verify request-response cycles and ensure functionality.
Offered advantages over Salesforce’s Einstein bots, such as cost-effectiveness, full customization, external system integrations, and syncing with Salesforce.
Developed a Hospital Management System with CRUD functionalities for patients, doctors, and appointments, along with a well-structured database schema.
Used Python with Django for development, PostgreSQL for the database, and Insomnia for API testing, with Git for version control, and deployed the system on AWS for cloud hosting.
Achieved a functional system, overcame foreign key constraint challenges, and improved maintainability with Django ORM for better scalability and readability.
Enhanced Sales & CRM Efficiency: The project focuses to streamline B2B sales processes, improving communication, collaboration, and real-time data tracking.
Automated Sales Insights: Implemented automated reporting for key sales KPIs (revenue, conversion rates, deal velocity) to support data-driven decision-making.
Improved Sales Process Visibility: Addressed challenges like manual tasks, data fragmentation, and limited automation, enhancing transparency and workflow efficiency.
Optimized Customer Data Management: Centralized B2B customer interactions and deal progress in Salesforce, providing a holistic client view for better relationship management.
Scalable & Adaptive CRM Solution: Customized Salesforce to align with business objectives, automate lead management, service requests, and improve user experience across sales and service teams.
Automated Sales Workflows: Reduced manual effort by automating opportunity naming, lead assignments, and record transfers, making sales operations more efficient.
Stronger Customer Engagement: Implemented automated birthday greetings and seamless B2C to B2B transitions, enhancing customer relationships and satisfaction.
Proactive Sales Management: Introduced real-time alerts for high-value deals, stagnant opportunities, and contract renewals, ensuring timely follow-ups and reducing missed revenue.
Improved Data Accuracy: Automated lead source validation and client transition reports, ensuring clean data and better decision-making.