Automated analytical reporting process

Financial statement

eLoan company presented under eKredit trademark is a modern financial service focusing on providing consumer loans online.

Existing enterprise system used by the customer is not flexible enough to create specific reports. Data presented in enterprise database was disparate and required verification and manual routine operations to create a bunch of daily reports.

We analyzed existing data structure and were able to automate the whole process from reports creation and verification algorithms to sending the reports to financial analysts by email.

Technology: PostgreSQL, Python (pandas + xlsxwriter)