Patrick Campagna Email & Phone Number

Falls Church, Virginia, Us

Manage FCPS’s Lottery/Matriculation systems for the Magnet and Immersion program with a registration and admin portals. Update the database schema to include referential integrity and primary key constraints. Migrated the Angular frontend from Seven to Nine. Modify the TypeScript code to adhere to Angular Style Guide, including Singular Responsibility Principle, Naming using Agular CLI and LIFT especially Try to be Dry. Started in creating Angular spec-test files to establish code coverage. Created small ColdFusion CFC’s servers-side frameworks for database and Active Directory conductivity, and spreadsheet manipulation to reduce coding. Introduced Agile Scrum to the clients. Used JIRA in a Scrum fashion.Migrated Mentor Admin and Registration systems’ frontend from ColdFusion to Angular 11. Mentor a junior developer. Collaborate to deliver the migration on time. Used the same ColdFusion server-side frameworks used in the lottery systems. Utilize Angular Bootstrap library from most of the UI’s.Spearheaded a new low code project. Migrated Course Catalog system to Oracle APEX from ColdFusion & SQL Server. Created SQL Server T-SQL script, using the sys views and cursors to generate Oracle SQL script to create the database schema and data migration. Created a jQuery API to create reusable function to manipulate the DOM generated by APEX. Created a Confluence space to document an APEX cookbook based on my experiences and the jQuery API.

Task Lead for two ColdFusion applications built using Coldbox (MVC Framework using OO and AO design). The first application is the PBT (Project Budget Tool) that manages funding for forecasting to spending activities related to the Congressionally approved budget. The second is the COR Workstation that provides tools for the federal COR to manage their contracts. These tools includes a message center, document management capabilities, task management that can be linked to the budget and dashboards of snapshot data. ColdFusion’s version of Hibernate is used in the model layer. Created a framework using JQuery to explode tags to rendered Bootstrap panels, navigation, form groups and input groups along with tags associated with 508 compliance. The explosion is triggered by user-defined tag attributes with in the original tag. Bootstrap is also used to apply responsive design for this applications to be rendered on a tablet as well. Used JQuery to provide real-time response like drop & drag and AJAX calls. Designed & developed the SQL Server databases along with user-defined function and procedures. Create artifacts such as ER (Peter Chen version) and Use Case diagrams based on client defined requirements. Used Teamforge to manage the projects by entering epics, stories and tasks in an Agile framework.

Maintain and enhance ICE’s Immigration Bonds systems, BMIS, eBonds & EARM-Bonds. These web applications used Java 6 & 8, Hibernate, Sprint and Struts2 in the middle layers. For the presentation layer the applications used JSP, JavaScript & JQuery. The database used Oracle 11g & 12c. Maintain the Bond systems’ communication with each other using a SOAP web service. Obtained an Agile Scrum Master certificate. Maintain Kanban/Scrum board using JIRA. Participate in all steps in the SDLC, including requirements & interfacing with the client, development, testing and deployment. Maintain version control using Subversion. Substitute Scrum Master and Team Lead.

Maintained the DOT’s TRANServe user and admin systems. One of the lead developers to convert and maintain the user experience to be responsive using Bootstrap and JQuery. The user TRANServe system used CF FuseBox 5 MVC. Contributor on the design team to transform the admin TRANServe system to have a responsive experience and place it on the CF FuseBox 5 MVC. Created an API using JQuery and JavaScript to convert simple HMTL tags to a more complex Bootstrap tag structure. The structure had a responsive experience and was 508 compliant and included a table with pagination triggered by the HTML attributes.

Maintain the DOL’s E-Grant system. This is a multi-tiered system that utilizes an MVC framework. ColdFusion and JavaScript is used in the front end. ColdFusion’s CFC is used to manage the business logic. Oracle is used in the back end. Assist the Product Manager of the DOL’s GEMS system to manage client’s needs using the Agile methodology and documenting requirements. Maintain the GEM’s system utilizing the MVC framework with the same platform as the E-Grant system.

Menlo Park, Ca, Us

Working on a contract for Association American Medical Colleges. Working on a development team to maintain existing ColdFusion applications and REST web services using Java. Other client side technologies that are being utilized include CSS, JavaScript and JQuery. JIRA is being used to verify requirements with the business analysts and QA. Oracle databases are used on the back-end. Present enhancements and fixes to internal clients before releasing to production. Create SQL and PL/SQL scripts to maintain sound data. Created a PL/SQL script to combine duplicate applications into a single one and altered any dependent records. Maintain REST web service written in Java using Spring and Hibernate. Tomcat and Maven is used in the Development environment. This web service is used for the medical colleges to export applicants’ data. Maintaining the Mark-up Tool application that allow staff to write comments directly on medical college PDF applications. Using the Apache PDFBox & FontBox 3rd party Java API and Java to development enchantments and fix bugs. Maintaining the Print Service reporting system that renders applicants’ data in a PDF. This application uses Java. Maintaining the model objects to either reconfigure existing data to new business requirements or add a new type of applicant data. Lead developer on the Single Sign-on (SSO) project. Created a conduit written in ColdFusion CFC for all existing AAMC CF applications to utilize the Java security context objects for SSO. Lead developer to upgrade School Tools CF application to be compatible to IE 10 & 11. This required a major reconstruction of the JavaScript & CSS code base using JQuery

Us

Use PL/SQL to query information from an Oracle database. These queries range from simple ad-hoc reporting to complex reconciling of corrupt financial data. Analyze eBusiness products from a Point of Sales vendor, Micros. These products focus on analysis of financial data for the corporate office and field users. Serve as client liaison between HMSHost corporate and Micros with responsibilities including logging issues, communicating updates and managing test cycles. Primary contact between Micros and “top three” fast food chain, an HMSHost-owned restaurant. Maintain a system to report financial variances and data anomalies.

Washington, Dc, Us

Awards - Received a special merit award in 2014 for my work on combining redundant databases - Received a special merit award in 2011 for my work on upgrades for the student/faculty/administration exam systemsMajor Achievements - Created a new school wide database by combining stand-alone departmental databases to improve maintenance and exchange of information between departments. - Successfully developed and implemented new features to the Exam Management System by conducting requirement meetings with faculty, staff and students. - Created a new web application using Adobe Flex to manage course, faculty, and student data for the Office of the Registrar and Office of Disability. - Created a new web interactive application using ColdFusion, JQuery, JavaScript, and CSS to manage course and sensitive faculty information for the J.D. and L.L.M programs. - Created a new web real-time interaction application using ColdFusion, JQuery, JavaScript, and CSS to submit and manage applications for the Law Clinics programs.ResponsibilitiesManaged web-based applications using advanced ColdFusion concepts. ColdFusion Components (CFC) was used in tandem with Object Orientation (OO) methodology to create complex course, faculty, student and staff data types. Created database conductivity objects using CFC’s that could accept the user defined complex data types to query, update, insert and delete database records. Created a three-tier architecture for the web applications. Used Fusebox for managing the Exam Management System and Course/Faculty Evaluation system. Managed a web-based application for the Office of the Registrar and Office of Disability using Adobe Flex version 3 and 4.

Bethesda, Md, Us

Major Achievements - Created a new database and data models for franchise owners to manage the remodeling jobs from demolition to reveal - Creating a new web based application to manage design projects using ColdFusion, ColdFusion Components, CSS. I was a project lead for this application development.The applications were RedHouse, Franchise Database System (FDB), Case Job Estimate System (CJES) and Case Estimate Administration System (CEAS). All applications used SQL Server 2005. RedHouse and FDB used ColdFusion MX8 and JavaScript on the front end. CFCs were used to manage business requirements. CJES and CEAS used Adobe Flex 3 for user interaction and to manage business requirements by applying OO principles. Database development and conductivity were managed though T-SQL scripts, stored procedures and triggers using SQL server. This position required some DBA duties. Maintained and developed four in-house applications along with respective databases.