Ekta Pratap Email & Phone Number

Delhi, India

Gurugram, Haryana, India

Co, Gurgaon

· Having a complete understanding of the data flow between various components of the Database and thereby enabling new requirements / enhancements in the BI system· Assist CLM/Data team in customer segmentation.· Identify KPIs and analysis areas to track opportunities for revenue enhancement.· Coordinate development schedules with IT, Marketing and Vendor· Establish BI training programs for the business users.· Vendor management… Show more · Having a complete understanding of the data flow between various components of the Database and thereby enabling new requirements / enhancements in the BI system· Assist CLM/Data team in customer segmentation.· Identify KPIs and analysis areas to track opportunities for revenue enhancement.· Coordinate development schedules with IT, Marketing and Vendor· Establish BI training programs for the business users.· Vendor management for BI related regular/ad hoc issues· Managing timely data quality and completeness, engaging with multiple stakeholders· Coordinate development schedules, activities and staff across all project teams.· Define data and tools standards, including tools for use in data acquisition and preparation, data modeling, metadata management and structured queries.· Work with the technology team to help in building the business intelligence roadmap from a user and a technology perspective· Establish training programs for the business users.· Managing multiple data sources to provide an integrated view of our customer/revenue KPIs vis a vis the competition .· Automation of regular reports to optimize maintenance and reporting operations.· Maintaining a repository of all ad-hoc queries to enable easy searching and use of same definitions by the entire team. Show less

Ncr

· Providing Pre and Post analysis of campaigns and their impact on various KPIs such as usage, decrement, ARPU- All Campaigns are divided between Target groups and Control Groups and impact is analyzed accordingly.· Prepare trackers and presentations for ad-hoc analysis.· Perform UAT on new developments/changes in BI· Support BI driven standard programs like waterfall, Multi-SIM, VLR, CLM segmentation, campaign effectiveness by query development, data… Show more · Providing Pre and Post analysis of campaigns and their impact on various KPIs such as usage, decrement, ARPU- All Campaigns are divided between Target groups and Control Groups and impact is analyzed accordingly.· Prepare trackers and presentations for ad-hoc analysis.· Perform UAT on new developments/changes in BI· Support BI driven standard programs like waterfall, Multi-SIM, VLR, CLM segmentation, campaign effectiveness by query development, data extraction and validation.· Regular/Ad hoc Reporting, analytics, and data exploration for company/circle-wide revenue, usage, and recharge · Providing BI support to business users pan-India, coordinating with BI development/support team and circles to solve business users queries· Ensure data consistency across various reporting sources. Show less

• Data extraction from data warehouse using tools like AQT/Queryman/SQL Scripts/ business objects• Data analysis and presentation to the functional heads• Automate regular MIS reports and dashboards• Tracking of Key KPIs on daily/ weekly/ monthly basis.

• Lead and managed close to 25 IT projects involving oracle, PL-SQL , VB and MS-Access• Understand the business requirements and provided the functional design document for the above IT projects.• Implemented critical IT packages across the Indian operations• Handled support and enhancement related queries/ requests • Lead a team of 4 to manage pan India requests for data extraction/analysis.

• Programming with foxpro and visual basic.• Handled inhouse as well as client site installed programs.

Master'S Degree, Zoology, First Division

Pgdba, Business Administration And Management, General, First Division