Data Analyst Software Developer

Somnath Baban Pawar

Data Analyst SQL Developer

somnathpawar8926@gmailcom +91-744******* Pune, Maharashtra Linkdin PROFESSIONAL SUMMARY

Innovative Software Developer with 1.5 years of experience at Vira Infotech India Pvt. Ltd., skilled in PHP, MySQL, Flutter, and Python.Experienced in developing HR automation, lead management, and data-driven applications.Proficient in SQL, Power BI, and data analytics for creating insights and reports.Strong in API integration, full-stack development, and database optimization.Passionate about building secure, scalable, and user-focused solutions that improve business performance.

PROFESSIONAL EXPERIENCE

Vira Infotech India Pvt Ltd, Software Developer 06/2024 – Present Pune India

•Developed full-stack web applications including an advanced HR management system.

•Integrated biometric attendance systems and implemented custom salary generation logic supporting dynamic payroll structures.

•Implemented payroll processing, attendance tracking, leave and advance requests with automated email alerts via Brevo API.

•Created reusable dashboards and reports in Power BI for HR insights.

•Developed an admission automation system streamlining candidate registration, document upload, and interview scheduling.

•Designed a scalable marketing tool with mass email and WhatsApp integration.

•Built mobile apps using Flutter integrated with Firebase for real- time data access. PROJECTS

Title : HR Horizon

•Developed a web-based HRM system to manage employee attendance, payroll, leave, and advance requests.

•Integrated Essl F22 biometric API for real-time attendance synchronization and verification.

•Implemented a dynamic payroll module with automated calculations for overtime, deductions, and advances.

•Built a role-based access control (RBAC) system to ensure secure, client-specific data segregation.

•Integrated Brevo API for automated email notifications on approvals and reminders.

•Designed and optimized SQL database structures and reports for HR analytics and performance tracking.

Title : UrbanLMS (Learning Management System)

Description: A web-based Learning Management System designed to manage courses, students, instructors, and assessments with real-time progress tracking. Responsibilities:

•Developed interactive dashboards for managing courses, students, and instructors using PHP, MySQL, and Bootstrap.

•Implemented role-based access control for Admin, Instructor, and Student panels.

•Designed automated grading and result generation modules for quizzes and assignments.

•Integrated email notifications for enrollment confirmations and progress updates.

•Created reporting and analytics modules to monitor student performance and course engagement.

•Optimized database queries and system performance for faster data retrieval and scalability. Title : Lead Management System

Responsibilities:

•Developed lead tracking and management modules to capture, assign, and monitor sales leads efficiently.

•Implemented status-based lead pipelines (New, In Progress, Converted, Lost) for clear sales visibility.

•Integrated email and WhatsApp APIs for automated follow-ups and client communication.

•Designed interactive dashboards and reports for sales performance and conversion analytics.

•Developed role-based access control for Admin and Sales teams ensuring secure data handling.

•Optimized SQL queries and backend logic for faster data retrieval and report generation. TECHNICAL SKILLS

Languages : PHP, Python, HTML, CSS, JavaScript

Database : MySQL, phpMyAdmin

Mobile Development : Flutter, Android Studio

Software Tools : VS Code, Googal Colab, Jupyter Notebook, WAMP & Xampp Server Other Skills : Data Analytics, Python, Data Science, Power BI, Machine Learning EDUCATION

Master of Computer Application(MCA),

Bharati Vidyapeeth, Pune

2022 – 2024 Pune, India

CERTIFICATES

•Fundamentals Of Artificial Intelligence From IIT Kharagpur -2023

•Machine Learning for Engineering and Science Application From IIT Kharagpur - 2023

Contact this candidate