Jamie Whalen
SOFTWARE ENGINEER IN ST. LOUIS, MO
PHONE 636-***-**** EMAIL ************@*****.***
GITHUB https://github.com/jamielwhalen LINKEDIN https://www.linkedin.com/in/jamie-whalen-58b0a4176/
LANGUAGES
• PeopleCode
• SQL
• Python
• Javascript
• HTML/CSS
• Java
FRAMEWORKS
• PeopleSoft
• Tkinter
• Spring Boot
• Flask
• Jinja
DATABASES
• MySQL
• Oracle
• Access
• SQLite
• PHPMyadmin
•
TOOLS
• PeopleTools
• Phire
• Knime
• Thymeleaf
• Bootstrap
WORK EXPERIENCE
PeopleSoft Developer, FleishmanHillard, St. Louis, March 2020– Present
Strategically planned and executed systems and application changes in accordance with company policies in order to meet production deployment deadlines.
Increased usability of PeopleSoft web application by designing and developing interface improvements based on user requests.
Documented changes in detail to allow future review of systems and application changes.
Tested and created test documentation of development changes to verify efficacy before migrations to production.
Reduced time spent on daily reporting by 15 hours per month due to creating Python scripts to automate data retrieval and data entry.
Created new reporting process to allow more visibility of daily workloads for upper management which expedited corporate decision making
Optimized SQR reporting to reduce bugs and allow multinational functionality
Performed daily tasks such as creating reports, interacting with users to troubleshoot problems and gather requirements, application maintenance, troubleshooting and on-call support for all PeopleSoft systems
Centralized Knowledge Base which contained SOPs and documentation for the Business Applications and Systems Department
Compliance Specialist, Millipore-Sigma, St. Louis, June 2015– March 2020
Increased audit capabilities by 120% due to creating automated SQL queries to check data validity via Knime
Optimized regulatory review process by developing python scripts to scrape websites for pertinent regulatory data
Created SQL queries to greatly increase scale of product impact analyses which allowed thousands of products to be reviewed simultaneously as opposed to one product at a time.
Created Microsoft Access database utilizing Google Cloud to greatly increase data accessibility for multiple remote users
Utilized SAP, Microsoft Applications (Access, Excel, Word), Google (Drive, Docs, Calendar, Gmail), Oracle, and Lotus Notes to perform daily tasks
Updated processes and created SOPs to document changes.
Undergraduate Research Internship, Millipore-Sigma, St. Louis, May 2014- August 2014
Conducted research in a microbiology lab under supervision of a mentor. Carried out protein expression of recombinant DNA using E. coli.
Utilized techniques such as HPLC, UV-vis spectroscopy, Fluorescence Spectroscopy, SDS-page and Western Blot.
Presented findings at the end of the summer
PROJECT EXPERIENCE
Task Manager Application
Programmed a desktop application to create tasks that allow the user to input any files, applications and websites associated with that task. The items open when the task is clicked. This helps streamline repetitive tasks because it allows the user to easily start working on tasks without having to open many things individually.
Utilized Python, Tkinter, SQLite
Bill Paying Application
Programmed a web application designed to track personal monthly expenses as well as expenses shared with cohabitants to streamline the recurring bill payment process.
Utilized Java, Spring Boot, PHPmyAdmin, Thymeleaf
EDUCATION AND CERTIFICATIONS
LaunchCode, LC101 Programming Course — 2019
PCAP Certified Associate in Python, 2019
University of Missouri St. Louis, Chancellors Certification in Data Analysis — 2019
Bureau of Industry and Security, Complying with US Export Controls — 2017
Bureau of Industry and Security, US Munitions List to Commerce Control List— 2017
Southeast Missouri State University, B.S. ACS Certified Chemistry — 2015