Abhilasha Patil

Engaged in skill enhancement to align data analysis capabilities with market demands.

Practiced proficiency in data analysis tools and techniques for improved performance.

• Enrolled in online course at VIT, Bangalore, specializing in Artificial Intelligence and Machine Learning.
• Acquired comprehensive knowledge and practical skills in AI and ML technologies.

• Executed SQL query optimization and database defragmentation, achieving up to 20% reduction in load times.
• Developed efficient ETL processes for data extraction, transformation, and loading into target database.
• Created tailored Power BI dashboards following comprehensive data analysis.
• Designed, implemented, and tested RESTful APIs in Python to enhance application functionality.
• Managed role-based access control within SQL Server to ensure appropriate user permissions.
• Optimized front-end queries in applications to enhance end-user experience with SQL Server back-end.
• Mentored junior developers on best practices for SQL development and optimization techniques.
• Generated reports and analyzed data to develop insights on key performance and operational metrics.

• Developed data visualizations and dashboards to track business metrics using Tableau.
• Created visualizations using tools like Tableau and Power BI to communicate findings to non-technical stakeholders.
• Assisted in identifying opportunities for improving data collection and analysis processes.
• Performed exploratory data analysis on large datasets to identify trends and outliers.
• Analyzed large datasets to identify trends and patterns.
• Created SQL queries to extract relevant information from relational databases for various projects.

• Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
• Optimized queries using SQL tuning techniques, enhancing performance by 11%.
• Created data visualizations and reports in Excel and SQL for annual reports, aiding client progress analysis.
• Provided technical support for reports, dashboards, and tools to ensure functionality.
• Identified customer needs promptly, enhancing service delivery efficiency.
• Documented technical specifications and user manuals for future reference.
• Developed complex stored procedures and triggers to improve database performance.

• Developed SQL queries and .NET framework to automate postal code updates in CRM, minimizing manual input.
• Created custom SSRS reports for comprehensive SQL database analysis, enhancing information delivery speed.
• Collaborated with Data Analyst team to design dashboards in Excel for improved data visualization.
• Utilized T-SQL scripting for creating stored procedures, functions, and triggers to enhance database functionality.
• Designed complex reports using SQL Server Reporting Services to meet business requirements.
• Provided SQL coding guidance to team members, facilitating knowledge sharing and efficiency.
• Optimized SQL queries and stored procedures, achieving significant reductions in execution time.
• Developed PowerBI dashboards to track key performance indicators, supporting data-driven decision-making.

• Worked on more than 5 commercial websites from scratch which involves complex coding in C#, designing using HTML, java-script and managing database using SQL which helps the client to get profits from 15-20%.
• Develop MS-SQL queries and procedures, create custom reports, and modify ERP user forms to enhance organizational productivity by 20%.