• Design and run data analyses to guide decision-making• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.• Designed and implemented SQL queries for data manipulation, reporting, and complex solution development.• Daily Streaming reports: preparing and updating portfolios for external debt collection companies.• Analysis of data using Excel Power Pivot, Slicer functionality, DAX calculation, and preparation of reports.• Implemented code solutions to answer analytic questions and test and assess new methods.• Developed complex dashboards, customized reports, and presented data in a visually appealing format using Power BI.• Outsource analysis- Updating the progress and performance portfolio for the outsourcing companies.• Monitoring and analyzing the number of calls through 3CX call and Zoiper system through data cleaning, arrangement, and processing.• Produced monthly reports using advanced Excel spreadsheet functions to check on progressive performance, evaluate and compare the general performances.• Performance reports- Performance evaluation for various teams and identifying areas of improvement.• Customer care Data analysis- Analyzing and keeping summary records of customer feedback from the customer care department.• DPD tracking- Analyze and keep records of DPD.• Payroll Management- assist HR in computation for various rewards offered to staff by the Company.

• Portfolio performance Monitoring and control• Record information about the financial status of customers and the status of collection efforts in the company’s system.• Advise customer on ways of clearing their debts while communicating to them the importance of paying their debts and consequences of non-payment• Record information about the financial status of customers and the status of collection efforts in the company’s system.• Advise customers on ways of clearing their debts while communicating to them the importance of paying their debts and the consequences of non-payment.

• Maintain a high level of customer service.• Advise customers and answer any questions they may have• Prepare sales report for the Manager