Ajinkya Gurav
SQL Developer
Navi Mumbai
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
5
5
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
Data Analyst
Datamatics Global Services
Mumbai
02.2022 - Current
- Conducted thorough competitor analyses, identifying gaps in market share and opportunities for growth.
- Designed custom tracking systems to monitor 75 KPIs at once, ensuring alignment with organizational goals and objectives.
- Established culture of continuous improvement by fostering open communication channels and encouraging feedback on data analysis methodologies.
- Streamlined data processing for faster results by implementing advanced analytics tools. Achieved 60% efficiency while working on 50 Cr row size.
- Utilized advanced query optimization techniques to enhance database performance and reduce latency issues during high-traffic periods. Helped client to reduce daily data ingestion time by 25%.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
SQL Developer
Tata Consultancy Services
Mumbai
11.2019 - 01.2022
- Developed efficient stored procedures for complex business logic, reducing processing time by 25% and improving system stability.
- Automated routine maintenance tasks through scripting, freeing up valuable time for higher-priority projects. Increased overall efficiency by 50%
- Increased data retrieval efficiency by designing optimized views tailored to specific reporting needs of various departments within organization.
- Assisted in database schema design, resulting in scalable structure that supported future growth requirements efficiently.
Graduate Trainee
Tata Technologies
Pune
03.2019 - 11.2019
- Demonstrated commitment to personal growth by seeking out constructive feedback from supervisors regularly, implementing improvements accordingly form 8 months.
- Cultivated leadership skills by taking on additional responsibilities during group assignments.
Education
B.E. Computer Science - Computer Science
Savitribai Phule Pune University
Pune, Maharashtra 06.2015 - 05.2018
Diploma in Computer Science -
IOPE, Lonere
Lonere, Maharashtra 06.2013 - 05.2015
HSC Board - Science Education
Mumbai University
Mumbai, Maharashtra 07.2011 - 05.2012
Skills
SQL
Python
SSIS
SSAS (OLAP)
Data Analysis
Data Visualization and Presentations
Data Warehousing
MS Excel
Azure Data Factory (ADF)
Data formatting
Process Improvement
Data Modeling
ETL processes
SQL development
Data Migration
Query Optimization
Certification
Microsoft DP900
Timeline
Data Analyst
Datamatics Global Services
02.2022 - Current
SQL Developer
Tata Consultancy Services
11.2019 - 01.2022
Graduate Trainee
Tata Technologies
03.2019 - 11.2019
B.E. Computer Science - Computer Science
Savitribai Phule Pune University
06.2015 - 05.2018
Diploma in Computer Science -
IOPE, Lonere
06.2013 - 05.2015
HSC Board - Science Education
Mumbai University
07.2011 - 05.2012