Saim Khan

About Saim Khan

1-Experience and Leadership: Accumulated 8 years of experience as an MIS & Data…

Experience

1. Senior Data Analyst

   airtel

   Apr 2019 — Present · Gurugram, IN

   1-Collection Management:Manage collection at the Pan India circle level and coordinate with respective circles.2-Data Handling:Handle various data aspects at the invoice level and manage segments like key government ISPs, focusing on day-to-day collection tracking.3-Problem Reporting:Highlight and report all system problems to the IT department with detailed analysis.4-Problem Resolution:Provide solutions for payment-related problems, collection issues, and data mismatch problems across all circles in Pan India.Key Achievements:5-Daily Reports:Collect daily reports using WinSCP and extract relevant data for analysis.6-Database Management:Upload the entire database into SQL and maintain a daily tracker using queries.7-Database Development:Develop and implement databases, data collection systems, and data analytics strategies for statistical efficiency and quality using SQL Queries and Microsoft Access.6-Reporting and Dashboard Design:Design reports and dashboards using Advanced Excel.Generate ADDHOC reports and share data as per Circle requirements.9-Data Transformation:Modify raw data into representative reports for daily collection analysis conducted by the organization.10-Collection Oversight:Manage daily collection figures for 23 circles, including monitoring amount reversals, investigating reasons behind reversals, and overseeing active accounts and over 1 million active invoices.11-MIS Reporting:Perform MIS reporting on a daily, weekly, and monthly basis, involving comprehensive data collection and analysis.13-Financial Performance:Weekly Statements:Show revenue, costs, and profits.Compare weekly financial performance against budget or forecasts.15-Circle Coordination & Team Collaboration:Coordinate with the Pen India circle team for daily Circle requirements.16-Achievement and Goal & Customer Satisfaction:Achieve Circle Satisfaction as a significant accomplishment.