TECHNICAL SKILLS:

Database: Oracle 11g, Microsoft SQL Server 2012 R2

Programming Languages: PeopleCode 8.52, SQR/SQC, SQL, Oracle PL/SQL, MS T - SQL, PeopleSoft Query, Unix Bash Shell Scripting, PeopleSoft Data Mover Scripts, XML, HTMLJavaScript - JQuery, AJAX

Batch Control: BMC Control-M; Version 6.4 - Version 7, UC4

Operating Systems: Microsoft Windows Server 2008, UNIX AIX 6.1, Open VMS 5.3, Linux Ubuntu

IDE: PeopleSoft Application Designer, PeopleSoft Nvision, Quest Toad 11 for Oracle, MSSQL 2012 Server reporting Services, XML Publisher/BI Desktop Publisher, Net Beans Java, Oracle SQL Plus, Oracle SQL Developer 11.3, Micro Focus Cobol Compiler

Change Management: Quest STAT Change Management Software, Heat, ServiceNow

Hardware: Clustered DEC 64-bit Alpha VAX System, RAID Memory Array

Networking: TCP/IP, DHCP, DNS, Ethernet, MS Active Directory, LDAP, Hubs, Routers, Switches, Apache Web Server 2.0

Cryptography: Public Key Infrastructure, sFTP/SCP/FTPs, MD-5, Gnu GPG/PGP File Encryption software, Cleopatra File Encryption software, WinSCP, CoreFTP, FileZilla

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

Developer

Responsibilities:

• PeopleSoft Campus Solutions Developer for Lone Star College supporting a ten campus institution enrolling sixty thousand students in the Houston area.
• Developed PeopleSoft Campus Solutions interfaces: PeopleSoft HCM and CS Enterprise Integration Points
• Modified custom online application logic data flow
• Admissions and Recruiting File Parser, Entity and Constituent Transaction Management Processes
• Created custom application engine process to archive the files and create the index file used by file parser utility.
• Created application package to pull admission referral source.
• Modified SCC CONSTITUENT ENTITY message schema definition to add new parent/child.
• Modified existing custom entity definition and added new child entity to remedy a failing event attendee transaction within the process.
• Modified credit official transcript BI Publisher report rtf template definition to include multiple course attributes. Using xsl, xslt, xdfo, template builder, template viewer
• Work with Business Analyst and Business Owners to configure delivered Milestone processes to be called from within a custom Application Packages to process SPEEDE transcript data and assign appropriate Student Milestones.
• Developed Peoplesoft Test Framework PeopleSoft ERP startup scripts across three pillars, CS, HCM, FSM.
• Peoplesoft Upgrade Manager (PUM)
• CS PeopleSoft Application 9.0 to CS PeopleSoft Application 9.2
• PeopleSoft PeopleTools 8.54.22 to 8.55.11

Confidential, Texas

Senior Developer

Responsibilities:

• Worked in a hosted environment with Sierra - Cedar PS Admins and SCI Oracle DBAs.
• Developed PeopleSoft Campus Solutions interfaces:
• PeopleSoft HCM, FMS and CS Enterprise Integration Points
• Academic Partnership
• Ad Astra
• Outbound enrollment file and Inbound room assignments.
• Nelnet Payment Plans
• Used Nelnet web services for payment plan reconciliation.
• Modified custom Texas Higher Education Coordinating Board (THECB) reports for five institutions.
• Lead PeopleSoft Application Architect for online hosted e-payment application using authorize.Net Payment Gateway.
• UT Permian Basin online e-payment application implemented within PeopleSoft Campus Solution environment was to correct PCI DSS compliance issues in the legacy SIS by going to a hosted e-payment solution. Orchestrated team activities to create supporting objects for hosted e-payment interface with PeopleSoft delivered hosted e-payment component:
• Performed PeopleSoft Merchant Setup and configured PIA for hosted e-payment adapters.
• Utilized a PeopleSoft delivered component interface to expose business logic at the beginning of the transaction, initiating the interface with Authorize.Net. And the CI again at the end of the transaction exposing the e-payment status and to perform the SF Quick Post COBOL that inserted status lines and any posted amounts in PeopleSoft delivered tables.
• Created a JAVA API from an Authorize.Net template and called the JAVA API from the JavaScript "Lightbox" to redirect the user to the hosted e-payment page.
• Encrypted online data transfer using a MD5 message-direct encryption algorithm in a PeopleSoft algorithm chain and transaction key for encrypting online data transfers.
• Created PeopleSoft Records/Page/Component to store an encrypted Authorize.Net username, password and transaction key.
• Configured IB Node, Message, Service, Service Operation and Document object in PIA.
• Developed PeopleSoft Application Package in Application Designer as the Service Operation.
• Developed "Bolt-on" PeopleSoft Components to house encrypted Authorize.Net Payment Gateway credentials and transaction key.
• Created the hosted e-payment interface with the Student Financials Self-Service component at key points in the transaction.

Confidential, Tyler, Texas

Software Systems Specialist

Responsibilities:

• Served the hospital as the PeopleSoft FSCM 8.9 Administrator, Security Administrator, Developer and MS SQL DBA. PeopleSoft Administrator
• Served as Senior PeopleSoft FSCM Administrator.
• Served as the PeopleSoft EPM and nVision Administrator and setup two-tier access for nVision users.
• Performed Application upgrades, lower instance refreshes, user profile creation along with component - menu and row level security.
• PeopleSoft HCM 8.9 Tax Updates A-F using Change Assistant and Micro Focus.
• Performed PeopleSoft domain analysis, used PeopleSoft 8.49 Administrative tool, WebLogic 10 Console and MS SQL Server 2012 to perform PeopleSoft Administrative tasks such as to start/stop PeopleSoft Process Scheduler, to start/stop PeopleSoft Application Server, start/stop WebLogic server, and create PeopleSoft Domains.
• MSSQL Server DBA
• Created MSSQL Server Database user accounts for database access and two-tier Nvision access, performed Database backups/restores for PeopleSoft refreshes and created database level table audits.
• PeopleSoft Security Administrator
• Created PeopleSoft user profiles for HCM and FMS and Security Join Table processes.
• Implemented PeopleSoft HCM Employee Self-Service and modified sign-on PeopleCode.PeopleSoft Developer.
• Created Confidential process to generate the outbound SUA payment order file for the dispatched SUA payments created with the SUA check run process.
• Created Application Engine process to follow the check run process and archive SUA payment order files, PeopleSoft file attachment and encryption technology using PGP.
• Created Application Engine to process inbound SUA payment order status file and "Bolt-on" Payment order status component to keep track of SUA payment order transactions.
• Created PeopleSoft Pagelets and granted the appropriate roles to present unknown SUA payment order status so any issues could be addressed.
• Setup Confidential SUA Bank Statement codes, Transaction codes and Bank Statement processing run control parameters in the PIA, then extended PeopleSoft delivered mapping base classes to read Confidential SUA bank statement into an application message, then created a Transform Application Engine process to use the PeopleSoft Application Package for transformation with the new Confidential SUA bank statement codes and transaction codes, into a PeopleSoft Business Document (PSBD1) format for a semi-manual reconciliation.

Confidential, Tyler, Texas

Senior Programmer Analyst

Responsibilities:

• Read current Ellucian Banner Student release notes for Financial Aid baseline changes.
• Work with Financial Aid Officers to configure Ellucian/Banner for Period Based Budgeting.
• Assist Functional-Technical staff to extract and document functional requirements and translate into technical specifications and estimate time to project completion.
• Create Ellucian Banner Student Self-Service “New Student Orientation” web registration application using Oracle 11g PL/SQL and Oracle Web Toolkit
• Analyze, design, code, test and maintain Ellucian/Banner ERP applications using Java, PL/SQL Oracle Active Server Pages and Quest TOAD- Installing Oracle Client and TNSNames.ora Work with the Ellucian/Banner product line including: HR, Student, AR/AP, General, Financial Aid
• Create coding standards using defining standards in nomenclature pertaining to documents, file structures, locations, and source code. Include standards pertaining to acceptable programming techniques.

Confidential, Fort Worth, Texas

PeopleSoft Specialist

Responsibilities:

• Analyzed, design, code, test and maintain PeopleSoft HCM and FMS APIs using PeopleTools and MS SQL Server 2012 Database and MS SQL 2012 Server reporting Services.
• Created multi-level file layouts in Application Designer to load GL from external systems using PeopleSoft FMS GL Import process.
• PeopleSoft Process Scheduler APIs in order to begin batch processing as files arrive and removing the need for scheduling. Served as PeopleSoft Security for all owned projects.
• Modified Kronos Time & Attendance inbound/outbound file interface from PeopleSoft HCM 9.
• Serve as Lead Techno-Functional for Centralized Accounts Receivables project that centralized AR for eight business units.

Confidential, Tyler, Texas

Manager of Programming Services

Responsibilities:

• Analyze, design, code, test and maintain PeopleSoft Campus Solutions ERP applications.
• Created and reviewed compare reports for PeopleSoft Campus Solutions/HRMS bundles.
• Create web services in PeopleSoft Campus Solutions to consume Directory Services, Department Hierarchy and Constituent ID from PeopleSoft HCM using Simple Access Object Protocol (SOAP).

Senior Programmer Analyst

• Applied knowledge from hands-on Oracle PeopleSoft PeopleTools 8.49 training to implement PeopleSoft Enterprise Campus Solutions 8.9 with customized and “bolt-on” applications and interfaces.

Programmer Analyst

• Developed SIS solutions and performed administration on Open VMS OS by creating and modifying user account profiles, assigning Access Control Lists (ACL) and troubleshooting system issues.

Confidential, Tyler, Texas

Programmer Analyst

• Began IT career as a Programmer Analyst learning a legacy Student Information System functionality and tools, data management system, operating system and hardware. First exposure to requirements gathering, functional and technical team dynamics. Showed aptitude and eagerness to learn which led to more complex assignments.
• Complex SIS projects
• Systems programming using DEC Control Language
• Cryptography Secure FTP configuration using Public Key Infrastructure Secure Telnet loopback configuration