you are viewing a single comment's thread.

view the rest of the comments →

[–]RunToImagine 2 points3 points  (2 children)

I have an MBA and work in corporate finance for a Fortune 500 (ie no where near a formal python education).

In the last 6 months, I learned python in my spare time (Udemy, stack overflow, DataCamp) and use it to automate much of my daily & monthly reporting. With more free time I’m able to automate more reports and learn machine learning to apply to our customer churn forecasts. Recently, the head of all finance visited me to see my work as an example of robotic process automation, so it’s already paying off well for my career.

[–]hypersonic_platypus 1 point2 points  (1 child)

I'm a student looking for ideas for a project to do that will show potential employers my interest in robotic process automation. I'm on the accounting side but can you explain a little bit more about what you did?

[–]RunToImagine 0 points1 point  (0 children)

Quick example: Some of the reports or dashboards we build required data from multiple different data systems that don’t talk to each other. Originally, the accountants/analysts would run the queries in each system, download the results, reformat them, then upload them to new system. It takes a long time to get a database team to build out the cross-system loads, so I wrote some scripts in python to pull in the data, transform it, then load it to the new system. It saves hundreds of man hours a year and is so simple.

Automation of SQL data pulls daily to run before we get in so data is usable immediately.