Gaurav Kumar
Kolkata
Summary
Results-driven Power BI Data Analyst with a strong background in Revenue Assurance, specializing in visual data analysis and interactive dashboard development. Proven ability to analyze market data, ensure data quality, and perform detailed forecasts that drive strategic business decisions. Core competencies include data visualization, analytical problem-solving, and effective communication of insights. Committed to leveraging advanced analytical skills to contribute to organizational success.
Proficient in advanced leveraging tools and methodologies to mitigate revenue risks and enhance financial performance.
Skilled in stakeholder collaboration and creating compliance frameworks to foster operational efficiency and efficacy in revenue assurance and contract management.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Revenue Assurance Analyst
British Telecom
Kolkata, IN
07.2022 - Current
- Created and updated interactive dashboards using Power BI.
- Refined ETL workflows, resulting in a 20% increase in productivity.
- Collected and combined data from various origins for enhanced Data Analysis.
- Collaborated closely with team members to achieve project objectives and meet deadlines.
- Updated and maintained databases with current information.
- Specialized in utilizing Power Query and DAX for data analysis.
- Provided support and guidance to colleagues to maintain a collaborative work environment.
- Worked with cross-functional teams to achieve goals.
- Designed, developed and implemented firmware to support embedded system product concepts.
- Performed comprehensive market assessments to evaluate product lines.
- Enhanced data quality metrics to align with business reporting needs.
- Proficient in end-to-end contract analysis for precise revenue forecasts, aligning with company objectives.
- Minimized revenue and cost leakage by meticulously reviewing all product-related contracts.
- Performed comprehensive assessments to optimize OSS and BSS frameworks.
- Conduct Revenue Assurance Audits to ensure precise billing and offer in-depth analyses with suggestions for revenue protection.
- Skilled in Accounts Payables with specialization in Invoicing and High-Value Audits for Clinical Billing.
- Introduced new controls, driving continuous improvement in processes.
- Oversaw monthly cost analysis, performed revenue reconciliation, identified potential revenue growth opportunities to enhance financial outcomes.
- Led monthly reviews of revenue metrics with management for strategic planning.
- Skilled at using revenue tools like margin tools, Glossy, and ATMT to streamline financial processes.
Business Analyst
Tata Consultancy Services
Kolkata, IN
07.2020 - 07.2022
- Worked with different stakeholders enhancing process efficiency and compliance.
- Performed comprehensive contract reviews covering all product areas, enhancing billing efficiency.
- Provided assurance to Senior Management.
- Developed and maintained secure and compliant business environment through effective risk management strategies.
- Conduct revenue assessments for accurate financial reporting.
- Collaborated with the team on innovative solutions in regular meetings.
- Created detailed documents to facilitate training initiatives.
- Conducted comprehensive assessments for OSS and BSS optimization.
- Conducted monthly revenue reviews with management, aiding informed decision-making.
- Enhanced resource efficiency by analyzing detailed business requirements.
SAP SD Consultant
Tata Consultancy Services
Kolkata, IN
07.2018 - 06.2020
- Configured and customized complex pricing conditions in SAP system.
- Managed various Master Data tasks.
- Managed operations for the Third Party Process.
- Implemented and optimized consignment process.
- Monitored and resolved issues in Idoc configurations.
- Streamlined route determination methodologies.
- Assisted with intercompany billing operations.
- Assisted in managing free goods.
- Implemented efficient SAP SD solutions to streamline order processing.
- Resolved crucial problems promptly, resulting in decreased system outages.
- Conducted end-of-project SAP training, offering user assistance and verifying effective system adoption.
- Managed maintenance and troubleshooting in production environments.
- Ensured timely updates and collaboration on production support.
- Ensured SLA compliance in ticket resolution and provided weekly reports.
- Addressed problems related to order to cash process.
- Completed month-end reports according to deadlines.
Process Associate
Tata Consultancy Services
Kolkata, IN
06.2016 - 07.2018
- Expertise in conducting accurate Back Billing assessments and obtaining necessary approvals.
- Skilled in performing various tasks related to the role of an ombudsman.
- Expertise in handling Billing operations using SAP ISU.
- Created comprehensive technical and device master data for Connection Object, Premise, Device Location and Installation.
- Specialized in BP and TMD creation within SAP CRM.
- Proficient in coordinating technical operations and billing procedures to ensure seamless utility services.
- Delivered comprehensive training sessions for efficient SAP usage.
Education
Bachelor of Arts - English Honors
Ranchi University
RanchiSkills
- Business intelligence
- Power BI Data Visualization
- Interactive Dashboard Design
- SQL proficiency
- SAP
- ServiceNow Platform Expertise
- IFRS expertise
- GAAP
- Credit analysis
- Data Transformation Expertise
- Visual Data Analysis
- Contract Review
- User Acceptance Testing
- MS Excel
- MS Office
- Order to Cash
- Agile Methodologies
Accomplishments
- Star Performer & Just to say Award
Certification
- Power BI: Interactive Dashboards
- SQL Essential Training
Interests
Sports, Photography, Acting & Stand-up
Timeline
Revenue Assurance Analyst
British Telecom
07.2022 - Current
Business Analyst
Tata Consultancy Services
07.2020 - 07.2022
SAP SD Consultant
Tata Consultancy Services
07.2018 - 06.2020
Process Associate
Tata Consultancy Services
06.2016 - 07.2018
- Power BI: Interactive Dashboards
- SQL Essential Training
Bachelor of Arts - English Honors
Ranchi University
Similar Profiles
Rahul JoonRahul Joon
SEO Manager at British TelecomSEO Manager at British Telecom
Michael SheehanMichael Sheehan
Senior field service engineer at British TelecomSenior field service engineer at British Telecom
Asha PaloAsha Palo
Agile Delivery Manager at British TelecomAgile Delivery Manager at British Telecom