DEEPAK JAGANNATH PIRANKAR
****************@*****.*** +91-706******* Pune, Maharashtra
linkedin.com/in/deepak-pirankar github.com/deepakpirankar PROFILE SUMMARY
Analytical and backend-focused tech professional skilled in Python, SQL, MySQL, Power BI, and Conversational Design. Experience developing dashboards, optimizing queries, building backend pipelines for real-time data processing, and designing AI-driven chatbot conversations to enhance user engagement. Completed multiple projects in data analysis, full-stack systems, and conversational flows, improving performance, decision-making efficiency, and customer experience. Seeking to contribute to dynamic teams in analytics, backend development, or conversational AI roles. EDUCATION
Master of Computer Applications (MCA)Aug 2023 - Jul 2025 Finolex Academy of Management and Technology, Ratnagiri CGPA: 8.26 Bachelor of Commerce (B.Com)Aug 2020 - Jun 2023
Yashwantrao Chavan Maharashtra Open University, Nashik Percentage: 61.58% SKILLS
Programming Python, SQL
Backend MySQL, PostgreSQL, API Integration
Conversational Design Chatbot Flow Design, UX Writing Analytics Microsoft Excel, Power BI, Pandas, NumPy Tools Jupyter Notebook, Git, Vs Code
Concepts ETL, Data Modeling, Database Optimization WORK EXPERIENCE
Conversational Designer Intern Aug 2025 - Present
Chat360, Pune
• Designed and optimized AI-driven chatbot conversations to improve customer engagement and support across multiple industries.
• Collaborated with product managers, developers, and clients to define chatbot requirements and user journeys.
• Conducted testing and fine-tuning of chatbot dialogues to ensure natural, human-like interactions and seamless user experience.
Database Management Intern Jan 2025 - May 2025
Vyosim Techlab, Kudal
• Optimized SQL queries across 5M+ records, reducing execution time by 60%.
• Built and maintained backend data pipelines with MySQL and designed relational schemas with CSV-to-DB migrations.
• Collaborated with the technical team to deploy live projects using performance-tuned SQL queries. PROJECTS
End-to-End Banking Data Analytics Python, SQL, Power BI
• Extracted and analyzed banking data from MySQL using Python (Pandas, NumPy) to identify customer behavior and product trends.
• Built modular Power BI dashboards (Loan, Deposit, Summary) for real-time executive insights across 5K+ records.
• Impact: Reduced manual reporting time by 60% and improved loan decision accuracy by 15%. CERTIFICATES
• Tata Group - Data Visualisation: Empowering Business with Effective Insights Job Simulation (Forage) May 2025
• Cloud Computing (NPTEL)Nov 2024