Kajal Gokul Khedekar
Pune
Summary
Dynamic Data Analyst with a proven track record at Tata Consultancy Services, enhancing loan performance metrics through advanced SQL, Power BI, and Excel. Expert in predictive analytics and data visualization with Tableau and Power BI. Demonstrated leadership in driving data-driven decisions, showcasing exceptional communication and team management skills.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst (Mr. Cooper, Finance USA)
Tata Consultancy Services
Pune
12.2022 - Current
- Utilized SQL to write complex queries and clean data.
- Developed Power BI dashboards and reports for loan performance metrics.
- Employed advanced Excel techniques (such as Pivot Tables and VLOOKUP) to clean and analyze large datasets.
- Implemented SQL queries to analyze bank loan data, and provided accurate solutions.
- Used advanced Power BI features, like custom visuals and DAX expressions.
- Presented findings to support data-driven decision-making.
Data Analyst (Rushmore, USA)
Tata Consultancy Services
Pune
06.2022 - 12.2022
- Resolving mortgage-related incident tickets, such as name change, new mortgage setup, draft date change, paid-off date check, and cancellation of mortgage using DDL and DML query.
- Resolving the ticket related to the authorization of a third party or nominee with the help of SQL Loader.
- Resolving issues such as mailing address changes.
- We are receiving tickets through ServiceNow ticket tools.
- Fetching daily health check-up reports.
Education
Master of Commerce - Cost and Works Accounting
Waghire College of Arts, Commerce And Science
Pune06.2023
Bachelor of Commerce - Cost and Works Accounting, Audit and taxation
Waghire College of Arts, Commerce And Science
Pune04.2021
Skills
- Advance Excel - Data analysis and visualization
- Machine Learning – Model development, predictive analytics
- SQL - Database querying and management
- Power BI - Business intelligence and reporting
- Tableau - Interactive data visualization
- R - Statistical Analysis
- Python - Data manipulation and automation
- Jupyter Notebook
- Soft skills: leadership, communication, storytelling, presentation, team management
Certification
- PL-300 Certification: Microsoft Power BI Data Analyst
- Python Programming - ETLHIVE, Pune
- Data Analytics- ETLHIVE, Pune
- SQL Developer - ETLHIVE, Pune
- Data visualization with PowerBI - ETLHIVE, Pune
- Data visualization with Tableau - ETLHIVE, Pune
- Microsoft Power BI - Beginner's to Pro- Udemy
- Python for Data Science and Machine Learning - Udemy
- The Complete SQL Bootcamp - Udemy
Timeline
Data Analyst (Mr. Cooper, Finance USA)
Tata Consultancy Services
12.2022 - Current
Data Analyst (Rushmore, USA)
Tata Consultancy Services
06.2022 - 12.2022
Master of Commerce - Cost and Works Accounting
Waghire College of Arts, Commerce And Science
Bachelor of Commerce - Cost and Works Accounting, Audit and taxation
Waghire College of Arts, Commerce And Science
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Amol Dilip WaniAmol Dilip Wani
Senior Specialist – Client Services Project Manager at NICE Interactive SolutionsSenior Specialist – Client Services Project Manager at NICE Interactive Solutions