I have developed the dashboard for PTD performance of the e-telequote business for CPA and net profit/loss calculations, where I have calculated leads, Leads cost, contacts, commissions, conversion sales performance, wages from DB of a different leads sources (Google Adwards, Bing, Facebook, Onshore Leads, 2tier offshore leads).
Business Requirement:
Management was looking for all channels performance and overall performance as well of Daily, WTD, MTD, YTD, PTD stats. To see how we performed on leads and what was the cost effects to close the sale (cost of Acquisition).
Business Challenge:
Same inbound lead was coming from different vendors, so there was need to develop the mechanism to control the fraudulent activity, because once a lead is billable should not be considered billable 2nd time.
Business Factors:
Leads, Leads Cost, Onshore wages, offshore wages, contacts, Gross Sales, Fall out rate, Net sales, Net COA.
Business Logics:
Leads= leads loaded in particular date in dialer.
Leads cost=Leads* cost per lead
Wages= Hours (talktime, waittime, wraptime) *by wage rate
Lead cost per sale=cost incurred/sales
Wage per sales= wages/sales
COA=Lead cost per sale + wage per sale
Profit (loss)= revenue-COA
For net values, fall out rate was fixed for sales and that has water fall approach on other net values calculations as well.
Solution Delivery:
And for inbound leads to control the fraudulent activity I design the FIFO system to consider the billable leads, means the lead will be billable who comes first into system and we won’t consider it billable 2nd time, I used the partition function in SQL to get over with this problem.
So in that project I was doing operational and business analysis and I successfully provided the business solution to reduce the redundancy of the data for analysis.
I got opportunity while I was working in Mobilink to design and implement a major project for B2B sales so I designed the product and provided the technical solutions for CRM and reporting purposes as well.
Business Requirement:
Management was looking to get raise in sales and that product should really attract the customers and provide revenue for the company, and for system interactivity there should be live monitoring to deal with customer support issues, like live view of details at CRM level (Ledger view, data usage etc).
Business Challenge:
Interpret data, analyze results using statistical techniques, manage workforce, forecast business KPIs, optimize statistical efficiency and data quality and provide ongoing reports. Complete projects that require data mining, analysis, and presentation.
Business Logics:
Design Tinaf (Tariff plan) through analysis of historical data.
Assign Caps of data according to package plan.
Bills= price plan+extra usage.
Extra usage=extra voice or data limit* specific rate
Live data usage of CDR to get block the services of the customer if required.
Develop the use case stories for interactivity of the actors.
Solution Delivery:
I designed the graphical reports for daily sales, and forecasting on the basis of historical data. All information was aligned in the CRM for CSR to entertain the customers.