Avinash N Bhiwale
Navi Mumbai
Summary
Skilled Oracle PL/SQL Developer with 2+ years of experience in designing and implementing database solutions for GPS-based products and logistics applications. Proficient in writing optimized SQL queries, stored procedures, triggers, and packages, ensuring high performance and scalability. Expertise in performance tuning, query optimization, and implementing advanced database features such as partitioning and analytical functions. Strong understanding of Software Development Life Cycle (SDLC) and proven ability to deliver quality solutions within deadlines. Recognized as a "Star Performer" for consistent dedication and impactful contributions to organizational goals.
Overview
3
3
years of professional experience
Work History
Software Engineer
Autoplant System India Pvt Ltd
07.2022 - Current
- Designed and implemented database solutions for GPS-based logistics applications, enhancing operational efficiency
- Developed and optimized high-performance PL/SQL procedures, triggers, and packages to manage trip data and generate reports
- Created control files for efficient data loading, reducing processing time by 30%
- Tuned complex SQL queries, achieving a 25% improvement in query performance
- Collaborated with cross-functional teams to integrate database solutions with ERP systems, enabling seamless data flow
- Project #1: Integrated Vehicle Tracking System
- Client: Varuna, Bacardi, Zuari Cements, Ultratech Cements, Ambuja Cements, Coldex, Cream Bell, Vadilal
- Duration: July 2022- Present
- Environment: Oracle 12c/11g SQL and PL/SQL
- Role: Oracle PL/SQL Developer
- Description: Designed and implemented solutions to monitor vehicle movement, optimize routes, and generate compliance reports
- Integrated data with ERP systems for strategic KPI reporting
- Responsibilities: Wrote efficient PL/SQL procedures, triggers, and packages to generate trip data and client-specific reports
- Designed and implemented partitioned tables and indexes to manage large datasets effectively
- Investigated and resolved performance issues using Explain Plan and advanced tuning techniques
Education
B.E. - Information Technology
Dr. D Y Patil College of Engineering
Akurdi, Pune01.2022
HSC - Physics, Chemistry, Mathematics
Late Vimalbai Gangadhar Sec. & High Sec. College
01.2018
SSC - English, Hindi
Matsyodari Vidyalay
01.2016
Skills
- SQL
- PL/SQL
- Oracle 9i
- Oracle 10g
- Oracle 11g
- Oracle 12c
- Windows
- Linux
- Tortoise SVN
- Serena PVCS
- JIRA
- Analytical Functions
- Partitioning
- Query Optimization
- Performance Tuning
- Software development life cycle (SDLC)
- MySQL
Accomplishments
- Star Performer, 2023-2024, Recognized for consistent excellence and impactful contributions to key projects.
- Employee of Qatar, 2022-2023, Awarded for outstanding performance and dedication.
Languages
English
Marathi
Hindi
Disclaimer
I hereby declare that all the information furnished above is true to the best of my knowledge.
Personal Information
Date of Birth: 09/22/2000
Timeline
Software Engineer
Autoplant System India Pvt Ltd
07.2022 - Current
B.E. - Information Technology
Dr. D Y Patil College of Engineering
HSC - Physics, Chemistry, Mathematics
Late Vimalbai Gangadhar Sec. & High Sec. College
SSC - English, Hindi
Matsyodari Vidyalay
Similar Profiles
SANTOSH KUMAR BENIWALSANTOSH KUMAR BENIWAL
Service Executive at Autoplant System India Pvt. Ltd.Service Executive at Autoplant System India Pvt. Ltd.
Esha MayekarEsha Mayekar
Human Resources Manager at Autoplant Systems Pvt LtdHuman Resources Manager at Autoplant Systems Pvt Ltd
SOWVIK BANERJEESOWVIK BANERJEE
SFA Engineer II at Hitachi System India Pvt Ltd(Godfrey Philips Ind Pvt Ltd)SFA Engineer II at Hitachi System India Pvt Ltd(Godfrey Philips Ind Pvt Ltd)