Louis Franceschi

Johns Hopkins University
School of Medicine
Phone: 410-614-4961
Fax: 410-955-0859
URL: https://www.rits.onc.jhmi.edu/


Experience
  Johns Hopkins University, Oncology - Baltimore, MD
2022-Present Sr. Systems Engineer
  • Rebuild fleet of servers on newer OS' and normalize their Active Directory and Group Policies. This was done ising a mix of Windows, Linux; all whatever more appropriate for the task.
  • Containerize many services in Linux and automated their maintenance; was responsible for all backups, function, and security strategies.
  • DBA for Oracle, MSSQL, MySQL; wrote complex report queries, performed data scrubbing and other various tasks.
  • Continuously test and update all systems and ensure they all pass security compliance while maintaining near 100% uptime.
  • Devops pipeline improvements to optimize developer contribution and code quality.
  • Continue to maintain a high degree of writing, maintaining, and delivering high quality software and ensuring the clients needs are met.
  • Started and kept documentation in markdown.
2022 Sr. Lead Software Engineer
  • Mentor new hires into becoming extremely useful engineers in very short time and with high precision.
  • Work on advanced problems that cannot be solved easily or time efficiently by other engineers.
  • Continue to maintain a high degree of writing, maintaining, and delivering high quality software and ensuring the clients needs are met.
  • Integrate DataTables builds with ColdFusion with custom module that upgrades almost all user experiences and makes the code easier to write and maintain.
2018 - 2022 Sr. Software Engineer
  • Primary programmer, engineer, and solo architect of numerous Research and Administration projects, in a group developing robust applications, scalable platforms, API's, and more.
  • Full stack development using Oracle, ColdFusion, Flex, and JavaScript, along with web frameworks such as Bootstrap and jQuery.
  • Provide reliable professional applications, automate client and group workflows, and mentor junior programmers in relational database design and JavaScript.
  • Authored advanced parsing libraries which help parse documents cleanly into HTML and similarly assist in their reconstruction into a document with stringent specifications.- Primary programmer, engineer, and solo architect of numerous Research and Administration projects, in a group developing robust applications, scalable platforms, API’s, and more. - Full stack development using Oracle, ColdFusion, Flex, and JavaScript, along with web frameworks such as Bootstrap and jQuery. - Provide reliable professional applications, automate client and group workflows, and mentor junior programmers in relational database design and JavaScript. - Authored advanced parsing libraries which help parse documents cleanly into HTML and similarly assist in their reconstruction into a document with stringent specifications.
2016 - 2018 Software Engineer
  • Modularized and built asset factories for common code segments into API's, for assets that appeared similarly implemented in several projects.
  • Upgraded the codebase to defend against new types of attacks; CSRF, XSS, and modernized existing projects to work for new version of ColdFusion.
  • Ugpraded powershell scripts to automate serveral tasks. Implemented a new versioning system with hashes and version history.
  • Helped configure, harden, and test servers to meet the requirements of the data trust committee and maintain application security and availability.
  • Main participant in key architectural decisions made for the group as the infrastructure has graduated to new servers.
  • Designed several new applications, and met with clients to obtain specifications. These sites have a rich Javascript experience and powerful validation.
  • Created a unique framework using CSS3 techniques that would best replace Coldfusion's window framework as well as modernize each site.
2013 - 2016 Sr. Programmer Analyst
  • Lead projects and junior programmers; designing architecture, schematics and teaching advanced UI design and integration to them.
  • Developed dynamic page generation solutions to allow elastic interfaces and easier to use interfaces for numerous projects.
  • Guided and directly assisted in integration with several modern API's that use a variety of languages to communicate between servers, including CTRP submissions to the NIH.
  • Analyzed and provided parsing for several research applications such as Cervical Dysplasia Research Program as well as directly tutoring a junior programmer on parsing methodology.
  • Reverse integration with EPR2020, creating local API's to assist approved research applications to get data from EPIC.
  • Engineered a multi-institutional database, MILS, that has high scability as well as extensive monitoring features for data integrity.
  • Worked with department to develop additional features to the web site (service requests, etc.)
2012 - 2013 Programmer Analyst
  • Development of the Order Sets Generator for Oncology research nurses.
  • Tutor junior programmers in platforms and languages used by RITS
  • Develop web applications using a combination of Coldfusion, Oracle, and JavaScript, most notably utilizing jQuery libraries, as well as AJAX and JSON to enhance the user experience.
  • Working with users to design and develop robust solutions for managing cancer research data in a user-friendly, well organized fashion to improve the quality of their workflow.
  • Create Photoshop enriched web interfaces to keep up with modern expectations from users.
  • Strengthen the security of all current applications by using proper methodology against SQL injection, browser hijacks and cookie validation using monitoring tools such as Charles.
  • Develop several unique widgets using jQuery that perform custom complex tasks, an example being a searchable auto-complete dropdown.
2011-2012 Web Database Programmer
  • Developed several application interfaces utilizing the Flex 3 SDK and ActionScript languages.
  • Designed a new web interface for a project that would try to best mirror the capabilities of flex into the ColdFusion languages by using jQuery.
  • Developer in creating the Hematologic Malignancies Database, requiring several reports, designs and unique features.
  • Worked on a multi-institutional project that was required compatible across each institution and account for all of their individual needs.
  • Designed a system to manage and update a page interactively, including Spry headers and dropdowns.
  • Designed an application that would send a file to a Linux server for statistical analysis with passed parameters then retrieve and store the results after a program processed the results.
  • Created many of automated tasks needed to help improve utility and stability of certain applications.
2010-2011 IT Specialist
  • Fixed several application interfaces using Flex 3 and ActionScript languages that needed updating or structual changes.
  • Helped repair the Office of Research Administration database by both expanding and repairing the Flex interface, as well as reauthoring the scheduled tasks used to collect the data.
  • Changes in many applications to improve efficiency greatly by introducing different methodologies.
  • Various work to help improve utility of many applications.
2008 e4e Business Solutions - Hunt Valley, MD
Quality Assurance
  • Tested hardware, such as video cards and software products against requirements, for quality control.
  • Reported results in an organized manner to a database for internal tracking and progress monitoring.
  • Worked in a team to devise hardware and software assignments tasks efficiently.
  • Helped maintain an up-to-date and actionable list of knowledge with colleagues to lessen repeated tasks.
2003-2006 Law Office of M. Heather L. Wirth - Hereford, MD
Assistant
  • Installed and maintained a small computer network which consisted of printing devices, and computers.
  • Performed maintenance on systems and devices, installing hardware and organized computer backups.
  • Helped manage the billing, which included tasks such as writing a bill for clients, as well as managing the company checkbook utilizing excel formulas and other algorithms.
  • Converted handwritten documents, and contact information for the firm into a digital format.
Education
January 2023 Mid-Michigan ColdFusion Group
Seminar - Intro to AlpineJS with Ray Camden
October 2015 Adobe
Webinar: Introducing the New ColdFusion
November 2013 Teratech - Rockville, Maryland
Seminar - Fixing Slow ColdFusion apps
2006-2010 Stevenson University - Stevenson, Maryland
BS in Computer Information Systems
Computer Languages
Javascript, CSS, Java, HTML, ColdFusion, PHP, ActionScript, Objective C, C#, XML, C++, Python, Lua, VB, Flex
Databases
Oracle, MS SQL, MySQL, PL/SQL, Access, PostgresSQL
Miscellaneous Computer Skills
TCP/IP, Pentesting, Hardware, Ajax, jQuery, Bootstrap, Photoshop, Active Directory, Group Policy, Splunk, SCCM
Operating Systems
Windows, RedHat, Debian FreeBSD, Ubuntu, Backtrack 4, Solaris, Fedora, Android