I’m an experienced finance professional and licensed stockbroker looking to use my experience in these areas along with my ability to code to create useful processes and analyses. I have a bachelor’s degree in business administration from the University of Missouri St. Louis and a master’s in data analytics from Southern New Hampshire University. Additionally, I have taught myself VBA, C++, C#, R, Python, and SQL. I started out working with Visual Basic to manipulate Excel files and progressed to using macros to control Outlook and communicate with the mainframe terminals using IBM reflections. After discovering that I could automate tasks for my work I began reading books and watching lectures online to learn C++. To practice coding I completed nearly every C++ challenge on hackerrank.com.
In more recent roles I have been a heavy user of SQL and have used it to provide risk analysis as well as make business cases to interested parties. I have become proficient with SQL and served on a task force that helped to optimize long-running queries and manage user spaces. I regularly assist others with queries as they seek to understand errors with unions, how to create window functions or troubleshoot other errors.
Additionally, I have created reporting through Tableau and Excel which is often automated with the use of Tableau Server or C#. My firm has a strong end-user computing platform that allows me and my team to generate automated ETLs and reports. Through this, I have familiarity with tools such as Jira, Confluence, Git, and Chron Scheduling. Using these tools I help to provide insight into market risk for both front-line teams and upper management.
When developing new reporting or answering questions from business partners I work to understand their needs and provide timely results. I believe communication is important and work to ensure that end users are happy with any result. I borrow ideas from agile development and try to provide results as I get them to ensure that all parties are aware of progress and work to provide results that answer any questions as they arise. My experience and knowledge that comes from working in finance operations and risk provides me with a foundation to understand the client’s needs.
Michael Lewis II 