Advait Patil
Pune
Summary
Detail-oriented data analyst and database manager with a strong foundation in SQL and database concepts. Eager to further develop skills through hands-on experience in a dynamic environment. Ready to apply and enhance SQL querying and database management abilities in the desired position role.
Overview
1
1
Certification
Work History
1. Inventory Management System
- Designed and implemented a normalized Oracle database to manage products, inventory, orders, and suppliers.
- Developed PL/SQL procedures, functions, and packages for stock updates, order processing, and threshold-based alerts.
- Implemented PL/SQL triggers for reorder automation, inventory movement tracking, and auditing.
- Created reporting procedures using REF CURSORs to support Power BI visualizations for sales, stock aging, and supplier performance.
- Built interactive Power BI dashboards to monitor inventory turnover, top-selling items, and procurement trends.
Loan Management System for Microfinance
- Developed backend modules to manage loan applications, EMI schedules, repayments, and default tracking.
- Created PL/SQL procedures for automated repayment schedule generation, penalty computation, and delinquency monitoring.
- Implemented triggers to maintain loan status and track borrower history.
- Integrated with Power BI to deliver dashboards for repayment performance, default rates, and region-wise risk analysis.
- Enabled microfinance institutions to identify defaulters early and improve collection strategies.
Sales Performance Dashboard
- Designed and developed a dynamic dashboard in Power BI to visualize key sales metrics including revenue, product-wise sales, and region-wise performance.
- Used Oracle SQL for data extraction, transformation, and loading (ETL) from transactional systems.
- Implemented advanced DAX measures for trend analysis, year-over-year growth, and custom KPIs.
- Enabled drill-through reports and slicers for flexible, interactive user exploration by management teams.
- Helped identify low-performing products and high-growth regions through data storytelling.
Education
Bachelor of Technology - E&TC
Vishwakarma Institute of Technology (VIT)
01.2020
HSC - undefined
Vidyamandir Junior College
01.2016
Skills
- Languages: SQL, PL/SQL, Python
- Databases: Oracle SQL, PL/SQL, MySQL
- Data Analysis: Joins, Views, Indexing, Stored Procedures, Triggers
- BI Tools: Power BI, DAX, Data Modeling
- SQL Optimization
- Relational Databases
- Web Technologies: Django, HTML, CSS, JavaScript (Basic)
- Tools: Postman, Jira (Agile), Git, GitHub
Certification
- Object-Oriented Programming (OOPs) using Python – Infosys
- Data Structures and Algorithms using Python – Infosys
- Data Science with Python – SkillUp
- DBMS Fundamentals – Infosys
LANGUAGES
English
Hindi
Marathi
PERSONAL ATTRIBUTES
- Strong analytical and problem-solving skills
- Team player and adaptable
- Quick learner and self-motivated
Timeline
HSC - undefined
Vidyamandir Junior College
1. Inventory Management System
Loan Management System for Microfinance
Sales Performance Dashboard
Bachelor of Technology - E&TC
Vishwakarma Institute of Technology (VIT)
Similar Profiles
Cathy Mih TaylorCathy Mih Taylor
NA at NANA at NA
Ella GoreElla Gore
Esthetician Student at NAEsthetician Student at NA
KOMAL MOREKOMAL MORE
Professional Development | May 2025 – Present at NAProfessional Development | May 2025 – Present at NA
Alex EriksenAlex Eriksen
Private Swim Instructor at NAPrivate Swim Instructor at NA
Amol Dilip WaniAmol Dilip Wani
Senior Specialist – Client Services Project Manager at NICE Interactive SolutionsSenior Specialist – Client Services Project Manager at NICE Interactive Solutions