Find Jobs
Hire Freelancers

Answer Bank Case Study Manipulating Excel Data

$15-25 USD / hour

Lukket
Slået op over 3 år siden

$15-25 USD / hour

I work at a Bank in HR and developed a test for new hires to take home. It is a one page Excel file with Attributes and a one page Excel file with fake random account opening data (no real info), given reject rates and you have to review data and come up with assumptions as to why it is happening and root cause for rejects. takes 1-3 hours. Depending how good you are at sorting Excel data. Want someone outside bank to do it and see if they get same results. I email you the excel files and you email back. By this test, we would like to evaluate the following skills: 1. Ability to analyze the data. 2. Be able to ascertain the root cause(s) of the problem. 3. Document audit findings in a clear and structured way. 4. Suggest improvements in internal controls environment based on the identified findings. 5. Present all of the above in a clear and concise audit report. Background: Bank Mobile App performs the verification of their customers identity before the opening of their accounts through the Know Your Customer (KYC) process. The verification is performed by checking the following: - (1) the government-issued photo ID of the customer to confirm that the document is valid and authentic. - (2) the facial picture of the customer to confirm that the face in the picture is the same with that on the submitted ID The customer will 'pass’ the KYC process and get onboarded if they 'pass’ the documentation and facial similarity checks. If the result of any check is not 'clear’, the customer has to then submit all of the photos again. The pass rate is defined as the number of customers who pass the KYC process (both the Documentation and Facial Similarity checks) divided by the number of customers who attempt the entire process. Each customer has up to 2 attempts to pass KYC checks. Problem statement: The pass rate has decreased substantially in the recent period. Questions: 1. Based on your analysis, briefly explain what testing you would expect to perform on the report spreadsheet before analysing the data. 2. What are the root causes of the KYC pass rate decreasing? 3. What are possible solutions to resolve any identified root causes and would you recommend any changes to the internal control system? Please write an audit report, outlining the root causes and suggested solutions. Relevant files: • Reports of all Document and Facial Similarity checks • Attributes explaining the results of each check performed The candidate is free to use any method including Excel or any scripting language to parse and analyse the data. Please show all your work and assumptions Skills: Excel Macros, Data Mining See more: bank statement excel data xls, case study examples telecomunication data, case study data center, financial statement case study excel, firms face turbulence uncertaintydiscuss role strategic planningresponse outline perspective strategy support answer case study , bank loan case study oracle plsql, financial data analysis case study, national bank case study workforce planning, furniture bank case study, regression case study using excel, excel data analyse, answer law case study assignment, case study report excel, how to answer a case study assignment, manipulating excel data in r, example of how to answer a case study, bank of america big data case study, vijaya bank case study, grameen bank case study, case study on big data analytics pdf
Projekt-ID: 28626549

Om projektet

5 forslag
Projekt på afstand
Aktiv 3 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
5 freelancere byder i gennemsnit $22 USD/time på dette job
Brug Avatar.
Hi There! I've read your project details for Answer Bank Case Study Manipulating Excel Data. I can deliver your work in less than 24 hours with professionalism. I am giving you surety of 100% satisfaction. I will give you unlimited revision until you are satisfied. You are invited to review our Portfolio below. https://www.freelancer.com/u/sainil786 Can we please discuss your requirements? Thanks & Regards Anny}
$20 USD på 19 dage
4,8 (122 anmeldelser)
5,9
5,9
Brug Avatar.
Hello uoyetunde,   We have 20 years of strong experience in Logo Design, Mobile App Development, Photoshop, as a result, we can successfully complete this project.   Please, review our profile here: https://www.freelancer.com/u/tangramua Here detailed information about our company, our portfolio, and the client's recent reviews.   Also, we wanted to personally discuss questions about your project, which helps us to give you the right estimation.   Best regards, Tangram Canada Inc.  
$22 USD på 5 dage
5,0 (6 anmeldelser)
4,1
4,1
Brug Avatar.
18 in 5 hours in week I am working in different MIS in my banking job so I used to do this in my daily routine in office
$20 USD på 5 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi, I'm confident about solving any of your problems. Let me know we can work closely to complete it real quick!
$30 USD på 40 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Atlanta, United States
0,0
0
Medlem siden dec. 19, 2020

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.