Swapnil Virkar
Thane
Summary
Experienced Software Developer with a strong background in ERP systems, particularly in the ceramic manufacturing domain. Skilled in database design, complex SQL/PLpgSQL functions, query optimization, and API development. Proficient in full-stack development using Java, JSP, HTML, CSS, JavaScript, and AJAX. Hands-on experience with reporting tools like JasperReports and Excel integration. Adept at system analysis, UI/UX layout planning, and delivering high-performance solutions. Known for team coordination, problem-solving, and end-to-end project execution.
Overview
4
4
years of professional experience
Work History
PL/SQL Developer
ITAAKASH Strategicerp Software PVT LTD
Mumbai
04.2021 - Current
Worked in Ceramic Manufacturing Domain with modules like: Sales, Product, Production, Planning & Scheduling, Inventory, Purchase, and Finance
Role and Responsibilities:
1) Database Management:
- Restore and generate database backups
- Create and alter tables as per business logic
- Write complex PL/pgSQL functions and custom SQL queries
2) Software Development:
- Build forms and fields based on business requirements
- Develop and modify backend APIs integrated with Java application
3) System Design and Development:
- Design UI/UX layouts using JSP (HTML, CSS, JavaScript, AJAX)
- Finalize data flow as per database structure
- Understand new requirements, coordinate with team, perform testing, and handle delivery
4) Query Optimization:
- Optimize slow-running queries
- Use indexing and query rewriting techniques for performance improvement
5) Reporting:
- Use Jaspersoft for report generation
- Generate reports in Excel and DOCX format
6) Team Support:
- Help team members in understanding tasks and resolving complex issues
- Participate in planning and knowledge sharing for better project delivery
Education
BCA - IT
Sahyog College of Management Studies And IT
Thane04-2021
Skills
- Database: PostgreSQL, PL/pgSQL, SQL Optimization, Indexing, Backup & Restore
- Backend Development: Java, JDBC, API Development
- Frontend Technologies: JSP, HTML, CSS, JavaScript, AJAX
- Reporting Tools: JasperReports (Jaspersoft), Excel Report Integration, DOCX Report Generation
- Tools & Platforms: Git, Docker, Eclipse, pgAdmin, Apache Tomcat
- Data Handling: Complex Joins, JSON Handling, Stored Procedures, Query Tuning
- Requirement Analysis
- Technical Documentation
- Testing & Delivery Management
Languages
Marathi
First Language
Hindi
Advanced (C1)
C1
English
Intermediate (B1)
B1
Timeline
PL/SQL Developer
ITAAKASH Strategicerp Software PVT LTD
04.2021 - Current
BCA - IT
Sahyog College of Management Studies And IT
Similar Profiles
Mahesh ParabMahesh Parab
BUSINSS HEAD at ITAakash Strategic Software Pvt LtdBUSINSS HEAD at ITAakash Strategic Software Pvt Ltd
JITESH YADAVJITESH YADAV
PRODUCT MANAGER at ITAakash Strategic Software Pvt. LtdPRODUCT MANAGER at ITAakash Strategic Software Pvt. Ltd
Neha TamkhaneNeha Tamkhane
Software Developer(SQL) at StrategicERP Business Automation Solutions(Kanjur)Software Developer(SQL) at StrategicERP Business Automation Solutions(Kanjur)