Screenwriter | Fiction Writer | Voice Actor (Demo Available) | I give stories a voice—on the page, on the screen, and in the booth. SOFTWARE DEVELOPER ANALYST Multi-talented software developer analyst with more than 9 years of formal software engineering and analysis experience in warehousing, finance, healthcare, and business software with leadership roles on projects involving financial transactions, ETL, healthcare, and warehousing.

Jonathan Cesari

Screenwriter | Fiction Writer | Voice Actor (Demo Available) | I give stories a voice—on the page, on the screen, and in the booth. SOFTWARE DEVELOPER ANALYST Multi-talented software developer analyst with more than 9 years of formal software engineering and analysis experience in warehousing, finance, healthcare, and business software with leadership roles on projects involving financial transactions, ETL, healthcare, and warehousing.

Available to hire

Screenwriter | Fiction Writer | Voice Actor (Demo Available) | I give stories a voice—on the page, on the screen, and in the booth.

SOFTWARE DEVELOPER ANALYST
Multi-talented software developer analyst with more than 9 years of formal software engineering
and analysis experience in warehousing, finance, healthcare, and business software with
leadership roles on projects involving financial transactions, ETL, healthcare, and warehousing.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
See more

Language

English
Fluent

Work Experience

Application Developer 1 at Pennsylvania Labor and Industry
January 1, 2024 - June 6, 2024
Oversaw and optimized daily operational processes at Pennsylvania Labor and Industry. Enhanced the efficiency of the state-run insurance program by streamlining processes and implementing tailored software solutions. Developed Python scripts for lasting process improvements, including automating the import and update of ICD-10 database changes. Collaborated with a cross-functional team in Oracle and Microsoft SQL Server environments. Performed regular data fixes and utilized Microsoft Visual Studio for effective change management. Designed and deployed a Python application to automate the import of XML files into filtered and formatted datasets, eliminating manual data manipulation.
Business Analyst III at The Pennsylvania State University
January 1, 2023 - January 1, 2024
Acted as Project Manager, Developer, and Data Analyst. Played a pivotal role in selecting a new Fleet Management System by collaborating with multiple departments. Gathered and analyzed requirements ensuring optimal system selection and integration. Developed costing models for major departments supporting strategic budgeting. Created Python-based front-end interfaces for SQL database access and automated email reporting. Conducted data analysis for fleet optimization resulting in cost savings. Pulled environmental data via RESTful APIs to support sustainability initiatives. Maintained source code and tracked progress using GitLab and Azure DevOps.
Technical Consultant II at WellSky
January 1, 2021 - January 1, 2023
Enhanced and resolved bugs in healthcare software ensuring improved performance and reliability. Configured and maintained data exchange protocols (SFTP, FTP, FTPS, TCP/IP) for secure HL7 healthcare data transfers. Managed custom codebases tailored to client needs. Modernized legacy systems by converting 5250 clients to WellSky's HTML5 Client Solution. Diagnosed and implemented fixes ensuring system stability. Resolved authority and access issues on IBM IFS maintaining data security. Monitored errors in RPG and CL applications improving performance. Authored documentation and training materials and facilitated client training sessions.
Sr. Systems Programmer Analyst at National Book Company
January 1, 2016 - January 1, 2021
Developed algorithms using IBM RPG, CL, and SQL improving business system efficiency and reducing user errors. Built backend software processing XML and JSON data leveraging RESTful APIs. Created internal tools to track and resolve payment issues enhancing user experience. Redesigned the royalties system ensuring accurate author payments. Led warehouse system upgrades to modernize operations. Developed applications for Bill of Lading and invoicing streamlining workflows. Generated financial reports enabling informed decision making. Designed server optimization including file zipping and purging reducing costs. Redeveloped task management system improving collaboration.

Education

BS at The Pennsylvania State University
January 1, 2000 - December 31, 2004
MA/MFA at Wilkes University
January 1, 2010 - December 31, 2012

Qualifications

Team Performance
January 1, 2022 - December 31, 2022
Financial Accounting
January 1, 2022 - December 31, 2022
Corporate Innovation & Entrepreneurship
January 1, 2022 - December 31, 2022
Data Analysis
January 1, 2022 - December 31, 2022

Industry Experience

Government, Healthcare, Financial Services, Education, Wholesale & Distribution

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
See more