Cricket and Analytics
Achal Jain
Billing Analyst
Pune,MH
Summary
Detail-oriented professional with a background in telecom billing, utilizing SQL,, and Unix Shell Scripting for data analysis and automation. Proven ability to generate actionable insights and optimize processes, combined with experience in data visualization using Tableau and Power BI. Seeking to transition into a Data Analyst role to apply analytical skills and drive data-driven decision-making for business growth
Overview
5
5
years of professional experience
2
2
Certifications
Work History
Senior Executive
VOIS
07.2023 - Current
- Managed postpaid billing support processes, ensuring accurate and timely billing for customers in the telecom sector.
- Analyzed customer billing, usage, and payment data to identify trends, discrepancies, and optimize processes for improved efficiency.
- Collaborated with cross-functional teams to troubleshoot billing issues, resolve queries, and streamline processes.
- Assisted in the automation of billing reports, reducing manual efforts and increasing efficiency by 20%.
- Developed Tableau/Power BI dashboards to track KPIs like ARPU, churn rate, and revenue forecasts, driving data-driven business improvements.
- Utilized SQL to extract and analyze telecom customer data, uncovering insights into usage behavior and network performance.
- Analyzed telecom data to identify Rejected Events and Fraudulent Activities, helping save 8% in potential revenue leakage.
Systems Engineer
Tata Consultancy Services Ltd.
07.2019 - 06.2023
- Utilized SQL and Unix Shell Scripting for automating billing processes and optimizing performance.
- Analyzed and resolved production issues by creating SQL procedures, functions, and triggers to enhance data processing efficiency.
- Extracted and manipulated data from Oracle DB using Oracle SQL Developer for report generation and customer insights.
- Monitored and triggered the billing cycle to ensure accurate end-to-end billing and supported reject event processing analysis.
- Generated daily reports and collaborated with teams to improve data quality and automate recurring tasks.
- Provided knowledge transfer on Rating & Billing Management (RBM) and acted as the SPOC for critical tasks and system deployment
Education
Bachelor of Technology - Electrical Engineering
Bharati Vidyapeeth College of Engineering
Pune, India 04.2001 -
Skills
SQL
Accomplishments
Received On the Spot Awards 4 times for actively participating and Project and Extra-curricular activities.
Received TCS Internal GEMS for actively Monitoring Awards.
Received Loyal Employee Award.
Certification
Upgrad Business Analyst Course
Interests
Dance
Poetry
Timeline
Upgrad Business Analyst Course
06-2024
Senior Executive
VOIS
07.2023 - Current
Systems Engineer
Tata Consultancy Services Ltd.
07.2019 - 06.2023
Bachelor of Technology - Electrical Engineering
Bharati Vidyapeeth College of Engineering
04.2001 -
Oracle SQL by Udemy
Similar Profiles
Rakesh Kumar BeheraRakesh Kumar Behera
Deputy Manager at VOISDeputy Manager at VOIS
Rohan KhandareRohan Khandare
RAN planning engineer at VOISRAN planning engineer at VOIS
Dospinescu AlexandruDospinescu Alexandru
Customer Solution Architect at VOISCustomer Solution Architect at VOIS