To reduce the time and effort required to complete the semi-annual budgeting process for the Global Markets IT division of BNP Paribas, our team designed an automated process consisting of a Python server, SQL database, and web-based front-end. Currently, to budget and forecast headcount and discretionary costs, the process requires hundreds of hours among the ITO Business Management team, team leads, and senior management. The process is complex, time-consuming, and labor intensive; it lacks a single system to input allocations, an easy way to audit activity, and a way to track multiple versions of the data sources. The new process our team designed addresses the identified bottlenecks within the current process and aims to lessen the complexity and time of the overall process.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Zhang, Nan

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-012517-103734

Advisor

• Konrad, Renata

Year

• 2017

Center

• Wall Street-FinTech Project Center (Boston or New York) - MQP

Sponsor

• BNP Paribas

Date created

• 2017-01-25

Resource type

• Major Qualifying Project

Major

• Interdisciplinary
• Management

Rights statement

• In Copyright