L Jyothsna Chintapalli
Data Analyst
About
Data Analyst with 3 years of combined professional experience in data analysis and reporting, operations, and client management within a fast-paced, compliance-driven environment. Skilled in data collection, cleaning, and validation using Microsoft Excel (VLOOKUP/XLOOKUP, Pivot Tables, SUMIFS/COUNTIFS), with working knowledge of SQL (MySQL) and Power BI for querying, dashboard reporting, and trend analysis. Experienced in preparing MIS/status reports, identifying data inconsistencies, and communicating findings to stakeholders. Applied these skills to analytics projects on visa case turnaround time and operational productivity using Excel, SQL, and Power BI, and certified in SQL, Excel, and Power BI for data analysis.
Skills & Expertise (19)
Work Experience
Data Analyst
ND Overseas Pty Ltd
Apr 2023 - Mar 2026
Maintained and analyzed application-tracking spreadsheets in Excel for 400+ case records, using Pivot Tables and VLOOKUP/XLOOKUP to monitor status, turnaround time, and approval trends. Performed data validation and quality checks on client-submitted documents (financial, academic, employment), maintaining 98% data accuracy across case files. Prepared daily, weekly, and monthly MIS reports summarizing case progress, approval ratios, and process bottlenecks for management review, using IF statements and charts to visualize status and trends. Applied SUMIFS/COUNTIFS-based tracking to flag pending documentation and prioritize follow-ups, improving case turnaround time. Identified inconsistencies and gaps in application data through detailed cross-verification, supporting a strong approval rate and reduced reapplication cases. Supported senior team members with ad-hoc data analysis and reporting requests, ensuring accurate and timely turnaround. Identified opportunities to improve reporting and data-tracking processes, reducing manual follow-up effort and improving reporting consistency.
Assistant Manager
Kotak Mahindra Bank
Oct 2010 - Jan 2011
Loan documentation and banking operations support.
Front Desk & Assistant Para-Legal
I.L.T.C. (US Immigration Law Office)
Sep 2007 - Jun 2009
US immigration documentation (H-1B, Green Card) and client communication.
Education
Master of Business Administration (MBA) - Acharya Nagarjuna University
2019 - 2022 · Afghanistan
Post Graduate Diploma in Banking & Financial Services (PGDBFS) - NIIT (IFBI)
- 2009 · Afghanistan
B.Com (Computers) - Acharya Nagarjuna University
- 2004 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (19)
Click a skill to find developers with the same skill
