Amar Jadhav

Developed and optimized complex MS SQL queries, stored procedures, and indexing strategies to improve performance.
Designed database structures supporting large-scale analytics and enterprise reporting.
Automated recurring data processing tasks to improve efficiency and reduce manual effort.
Collaborated with cross-functional teams to support audits, reporting, and business decision-making.

Developed and optimized complex MS SQL queries, stored procedures, and indexing strategies to improve performance., Designed database structures supporting large-scale analytics and enterprise reporting., Automated recurring data processing tasks to improve efficiency and reduce manual effort., Collaborated with cross-functional teams to support audits, reporting, and business decision-making.

Developed interactive SSRS reports using Tablix, Matrix, Charts, and Drill-through functionality.
Optimized SQL queries and report execution performance for faster data retrieval.
Managed report subscriptions, scheduling, and user access control.
Provided production support for SQL and reporting-related issues.

Developed interactive SSRS reports using Tablix, Matrix, Charts, and Drill-through functionality., Optimized SQL queries and report execution performance for faster data retrieval., Managed report subscriptions, scheduling, and user access control., Provided production support for SQL and reporting-related issues.

Handled SQL database administration including backups, restores, and scheduled jobs.
Developed stored procedures, triggers, and indexes to enhance system performance.
Supported business teams with data extraction, analysis, and reporting requirements.
Maintained technical documentation and ensured database stability.

Handled SQL database administration including backups, restores, and scheduled jobs., Developed stored procedures, triggers, and indexes to enhance system performance., Supported business teams with data extraction, analysis, and reporting requirements., Maintained technical documentation and ensured database stability.

Duration: 9 Months
Tools: SQL Server, Power BI, Tableau, Excel
Hands-on analytics internship undertaken to strengthen data analysis and visualization skills.
Analysed the Adventure Works Cycles dataset to identify trends in sales, revenue, customer behaviour, and product performance.
Designed and implemented a relational data model integrating sales, customer, product, and regional dimension tables.
Performed data cleaning, transformation, and validation using SQL (JOINs, CTEs, CASE statements, aggregations).
Calculated key KPIs including total sales, profit margin, year-over-year growth, and category-wise performance.
Developed interactive Power BI and Tableau dashboards with slicers, drill-downs, and filters.
Analysed 39,000+ bank loan records to study borrower behaviour and loan repayment trends.
Cleaned and validated large datasets using SQL and Excel to ensure data accuracy.
Built Power BI and Tableau dashboards showing year-wise and state-wise loan distribution and loan status.
Conducted KPI analysis on loan grades, interest rates, revolving balance, and home ownership trends.
Delivered insights to support credit risk analysis and lending decisions.
Analysed HR datasets with 50,000+ records to study employee attrition and workforce trends.
Calculated HR KPIs including department-wise attrition, job role vs work-life balance, and promotion impact.
Conducted analysis on attrition vs monthly income and average working years across departments.
Developed interactive Power BI and Tableau dashboards to visualize attrition patterns and retention metrics.
Provided actionable insights to support HR decision-making and retention strategies.