Streamlining Data Reconciliation

A Lean Six Sigma Yellow Belt project was done to save time spent in recon of data from two different sources in an investment bank back office. In the KYC process, there was a dual data entry concept where 2 analysts were capturing the details in an excel file. The excel files were reconciled and then the data was uploaded to the server. The manual recon was time consuming. Hence, a macro was created to auto-recon the files and auto-upload the data to the server. This macro saved 0.9 FTE per month.