George Bernard
Verified Expert in Engineering
PeopleSoft Developer
Concord, United States
Toptal member since September 29, 2022
As an experienced PeopleSoft senior programmer and analyst, George possesses over 15 years of experience providing comprehensive value-added impact to a variety of higher education institutions, government organizations, and businesses. Throughout his professional tenure, he has been an integral part of and a leader in the creation of PeopleSoft databases, programs, and software solutions that are utilized by hundreds of thousands of professionals, students, and military personnel.
Portfolio
Experience
- SQL - 20 years
- PeopleCode - 20 years
- PeopleTools - 20 years
- PeopleSoft - 18 years
- SQR - 18 years
- PeopleSoft Campus Solutions (CS) - 15 years
- Oracle PL/SQL - 4 years
Availability
Preferred Environment
PeopleSoft Campus Solutions (CS), SQL, PeopleTools, PeopleCode, SQR, Windows, Office 365
The most amazing...
...and comprehensive training system I've supported was for 200,000 sailors within the United States Navy and members of the United States Armed Forces
Work Experience
PeopleSoft Campus Solutions Senior Programmer and Analyst
CACI
- Collaborated with cross-functional teams across technical project execution and coordinated the on-time and within-budget performance of all deliverables.
- Performed agile sprints and document progress within Jira.
- Utilized and worked with the United States Navy's PeopleSoft software sustaining the confidentiality and security of confidential information and tools.
- Created and compiled detailed project technical documents. Developed all standard operating procedures for the project, including its scope and related timelines, to ensure high quality control and assurance across technical solutions.
- Performed necessary onboarding coursework and documentation necessary for the institution and for the My Navy Learning Stack Project.
- Promoted a unified application usage experience for various end users in addition to seamlessly integrating distinct components of the application, software, and programs to meet the needs of the organization and its clients and stakeholders.
- Supported the design of a comprehensive training system for 200,000 sailors within the United States Navy and various members of the United States Armed Forces, performing all requirements gathering and technical writing and documentation.
- Assessed and documented discrepancies across the current CeTARS legacy system's functionality and PS Campus Solutions to inform and develop a Campus Solutions proof-of-concept that enhanced end user experiences and information accessibility.
- Performed all functionality testing and validation to maximize overall interface, connectivity, and scalability before its release to all end-users, troubleshooting and remediating any and all technical interface and other issues promptly.
- Created a Campus Solutions sandbox database, including relevant, realistic data for Naval Education and Training Command (NETC) personnel for proof-of-concept concerning the initial design and functionality of PeopleSoft Campus Solutions.
Technical Program Lead
Corinthian Colleges, Inc
- Promoted the on-time and within-budget performance of all project deliverables and objectives. Provided comprehensive program and software solutions oversight to maximize the institution’s data collection and storage capabilities.
- Collaborated with the CCi’s project management office continuously.
- Liaised with business analysts within student records and student accounts and financial aid departments to develop various test scenarios and design documents, preemptively addressing and resolving any issues across data collection.
- Led the execution of the software conversion process while promoting sustained communication with CCi and Campus Management's stakeholders. Developed various reports and portal views as needed to accelerate data validation across all systems.
- Worked within and supported all PeopleSoft Campus Solutions modules present throughout and until project completion.
- Created 80% of all SQR conversion programs and audit capabilities while overseeing and designing the writing of 20% of all SQR conversion programs by leading a team of five software engineers.
- Directed software development for converting over 100,000 student data spanning 12 campuses and four different software systems (CS Student Financials, student records, and FA modules, Salesforce CRM, Powerfaids FA) into Campus Management's CampusVue.
- Produced all strategic planning and project scope to produce realistic timelines concerning data extraction from three legacy systems, data formatting, and new code assignments while performing all coding.
- Designed a conversion process that exported data via a unified user ID to determine when the same student's data was extracted from multiple systems, monitoring program extraction progresses and built-in extract program restart capabilities.
- Managed the data delivery process and executed conversion programs throughout dozens of test conversions and three go-live conversions (50+ hours of continuous conversion during one go-live).
PeopleSoft Campus Solutions Senior Programmer
Heald College, Inc
- Coordinated the timely resolution of numerous help desk tickets, assessing and evaluating gaps in software and program performance to ensure that effective solutions were present for end-users.
- Managed the creation and integration of comprehensive solutions and necessary improvements to the organization’s programming, including PeopleTools and the application engine.
- Designed all reporting within the internal program that staff members utilized when tracking at-risk students.
- Increased student retention rates from 75% to 95%, spearheading the development and coding of a student retention capability that centralized relevant student data so that faculty and deans could see students at-risk and provide additional support.
- Coded all program enhancements and enabled end users to include internal notes for at-risk students and create workflow task lists to track students and ensure that individuals were receiving appropriate supports.
- Created an online interface for faculty members (utilizing e-Companion) so that faculty could transport multimedia information and digital tools from one course to a different term for new students.
PeopleSoft Lead Technical Developer
Corinthian Colleges, Inc
- Created technical and functional specifications and oversaw technical staff throughout software solution delivery and programming.
- Managed many schools within a single database on behalf of CCi, ensuring that all data and programming accurately reflected each institution. Independently programmed various improvements within the institution’s technical systems.
- Developed and maintained a student ledger SQR report, utilizing tree structures to group data appropriately based on various reporting and categorization requirements. Resolved a myriad of help desk tickets and requests for technical assistance.
- Spearheaded the ability to request reports from “flat file” input. Utilized student financial tables to create a revenue recognition capability that accurately determined tuition earned each month.
- Increased efficiency across existing reports and programs (decreasing processing times to less than 5% of original time needed), evaluating program performance and remediating gaps present through effective coding and solution development.
- Developed and coded and online error correction capability for all staff members, enabling individuals to manually correct financial transactions received from external sources that possessed errors.
- Enabled data integration from multiple systems through the creation of a Federal Financial Aid reporting capability in addition to maintaining the tuition calculation and posting process for CCi’s non-term-based module programs.
- Developed an application engine program that evaluated student start dates and terms completed to assign accurate academic years, enabling automatic student repacking in financial aid in less than one year if certain conditions were completed.
- Designed and maintained all application engine processes necessary to validate and upload student financial ledger transactions from various external sources, grouping relevant data to ensure that student accounts were in the appropriate standing.
- Enhanced student financial item type maintenance, creating a single page that updated item types of all schools via a single entry, validating the input of information across specific Student Financial reporting trees.
Experience
Student Retention
Using the improved capabilities on the grading page, the faculty indicated the student's risk level by choosing a distinct color: Green, yellow, orange, or red that is both easy to see at a glance and widely associated with four corresponding levels: Good, warning, alert and danger. In addition, faculty could record risk factors such as lack of transportation, childcare, housing, job loss, etc. Once added, the information immediately appeared on all faculty and dean's office staff pages. The enhancement presented all pertinent student information on a single dashboard for the dean's office staff, adding notes and automatically generating workflow task lists. Staff could easily follow up with students.
911: Emergency
I determined the issue resulted from registering students in SR only into the current term and not loading students' history, which resulted in SR designating all students as freshmen. But in FA, students were awarded their actual grade level, i.e., senior. The freshman designation in the SR to FA interface caused a mismatch that locked up the awards page for upper-class students, preventing the printing of checks from the page.
I was able to fix the issue and had checks printing on the third day I was on site.
Education
Bachelor's Degree in Biology
Boston College - Chestnut Hill, Massachusetts, USA
Master's Degree in Strategic Management
Boston College - Chestnut Hill, Massachusetts, USA
Certifications
Security+ SY0-061
CompTIA
Skills
Tools
PeopleSoft Campus Solutions (CS), PeopleTools
Languages
SQL, PeopleCode, SQR
Platforms
Windows
Storage
Oracle PL/SQL
Industry Expertise
Accounting
Other
Office 365, Finance, Coding, PeopleSoft, Forecasting, Security Engineering
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring