Vanitha Sekar Email & Phone Number

Bengaluru, Karnataka, India

Bangalore

• Revenue Management - Acquisition/Engagement • Analyzing Product Wise Key metrics of VAS/Core business like Activation, Grace, Churn, Net Adds, Leg-wise Revenue, Penetration, ARPU, AOS, Song Download Per User, Recharge Pattern, Validity, Content & Pricing• Develop and schedule reports in SQL server. • Developed advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and T-SQL stored procedures, user-defined functions (UDFs) for data analysis• End to End Automation of Projects / Process by using SQL, VBA, Batch File & Shell ScriptChurn Analysis:-• First level, based on business requirements, we will extract the data by using SQL queries• On top on master level data, analyze region & month & operator wise Churn, Acquisitions• AOS on user level • Analyzing month, channel, region, operator wise churn percentage• Checking the engagement% on month & channel wise by using played data.Dashboard KPIs Reports:-• Generating products dashboards in Power BI• Publishing reports on Power BI services.

Bengaluru, Karnataka, India

• Manage the Monthly, Weekly & Daily Reports, creating in MS-Excel and SQL through in-depth analysis and producing actionable information.• Automated various reports using VBA & SQL scripts. • Meet the Client’s expectations of the visualization request provided in the reports.• Create SQL queries for data manipulation and retrieval from SQL server.• Review, analyze and interpret large datasets, formulate reports and data sources to ensure that all business requirements are met and provide recommendations based on findings.• Responsible for working on the various types of VAS products Financial reports - Revenue reports. • Share regularly scheduled and ad-hoc reports from the assigned business system.• Identifying issues and recommending new process improvement approaches• Manage the Monthly, Weekly & Daily Reports, creating in MS-Excel and SQL through in-depth analysis and producing actionable information. • Automated various reports using VBA & SQL scripts. • Meet the Client’s expectations of the visualization request provided in the reports. • Create SQL queries for data manipulation and retrieval from SQL server. • Review, analyze and interpret large datasets, formulate reports and data sources to ensure that all business requirements are met and provide recommendations based on findings. • Responsible for working on the various types of VAS products Financial reports - Revenue reports. • Share regularly scheduled and ad-hoc reports from the assigned business system. • Identifying issues and recommending new process improvement approachesSkills: Microsoft Excel · Access · Microsoft Office · SQL

Bachelor Of Computer Science Engineering, Computer Science, First Class With Distinction

Bachelor Of Engineering - Be, Computer Science, First Class With Distinction