|
|
Title: |
Peoplesoft Campus Solutions consultant
|
Location: |
US-New York-Long Island
|
Work History: |
PROFESSIONAL EXPERIENCE:
Principal Peoplesoft Consultant, PeopleSoft/Oracle Corporation, CA 06/03-Present
PeopleSoft Financial Aid and Regulatory Updates (ISIR, NSLDS, Profile, Corrections, COD, CRC)
Responsibilities:
• Was the Team Lead in all the financial aid regulatory updates.
• Updated the Financial Aid module on a regular basis as the Federal Government changes their data specifications & business rules in their Institutional Student Information Record (ISIR), Profile Application, Common Origination and Disbursement (COD) and Common Record Commonline (CRC) etc.
• Architected the fit gap analysis, working along with the business analysts.
• Provided Technical Design Document detailing all modifications to PeopleSoft objects and batch code.
• Created new Aid Year specific objects which includes creating records, pages, components, Peoplecode, AE, File Layouts SQR, COBOL etc from the previous years
• Gathered Financial Aid changes from the federal government and analyzed the differences in the data specifications for ISIR, NSLDS, COD and CRC and provide all technical analysis of the impact to the PeopleSoft application
• Incorporated the regulatory changes to the Financial Aid application
• Developed new Records, Pages, Components, Peoplecode
• Set up and maintained security for the new components. Created new File Layouts for the current aid year
• Modified Application Engine and COBOL based on requirement
• Created Single User Environment for development and testing
• Modified and developed SQR & Crystal Reports. Created & executed unit test plans
• Did system testing, setting up of run-control and process scheduler routines, performed unit and integrated system testing and validated all system functions before and after Regulatory updates were applied.
• Developed new module Loan Counseling for PeopleSoft 9.0 which involves creating new objects, Peoplecode and Application Engine program to process Entrance and Exit Loan Counseling data from Central Repository.
• Used Person Model Concept for retrieving data from HRMS tables to be used for Campus Solution processes.
• Involved in frequent interaction with functional and technical members of the team to make them understand the various methods to write effective coding and optimize the system.
Environment: PeopleSoft Campus Solutions 8.1/8.9/9.0, PeopleTools, Peoplecode, Application Engine, File Layout, COBOL, SQR, Seagate Crystal Reports, Process Scheduler, Report Manager, Data Mover, Net Express.
UCAS
Responsibilities:
• Was the Team Lead in all the financial aid regulatory updates.
• Developed a new module UCAS for the United Kingdom to support a centralized Admissions process
• Architected the fit gap analysis, working along with the business analyst.
• Worked closely with the analyst to gather requirements and information to design technical specifications for the development.
• Involved in receiving data, transforming them and processing in the system according to functional requirements.
• Modified and developed PeopleCode, Records, Pages, Components, Application Message.
• Developed Application Engine programs and Application Message to process Inbound data
• Was responsible for setting up and Maintaining PeopleSoft security
• Set up Run Control and Process Scheduler routines for new batch processes.
• Created Test Plans
Environment: PeopleSoft Campus Solutions 8.9/9.0, PeopleTools, PeopleCode, Application Engine, Component Interface, Application Package, Process Scheduler, Data Mover
Studielink
Responsibilities:
• Developed a new module Studielink for the Netherlands to support a centralized Admissions process
• Involved with receiving messages, transforming them and processing in the system according to functional requirements.
• Modified and developed PeopleCode, Records, Pages, Components, Messaging and Integration Broker.
• Developed new Application Engine programs to process Inbound and Outbound files
• Developed new Application Packages for processing XML files
• Developed Equations to validate outbound XML transactions
• Developed Equation Engine driver program using COBOL to process equations
• Was responsible for setting up and maintaining PeopleSoft security
• Worked on Data analysis, Mapping and conversion and integration of Legacy System to PeopleSoft Application.
• Set up Run Control and Process Scheduler routines for new batch processes.
• Set up Integration Broker for external system – setting up external and internal IB connectors, IB gateways. Inbound/outbound interfaces
• Created XML Data files from the XML schema for unit testing
• Worked closely with the analyst to gather requirements and information to design technical specifications for the development.
• Created Test Plans
Environment: PeopleSoft Campus Solutions 8.9/9.0, PeopleTools, Peoplecode, Application Engine, Component Interface, Application Package, Application Messaging, Integration Broker, COBOL, Process Scheduler, Data Mover, Net Express
Architecture Tasks
Responsibilities:
• Was extensively involved in the architectural tasks to be performed for new release of PeopleSoft Campus Solution 9.0.
• Architecture tasks involved maintaining Setup Manager metadata, updating Table Loading Sequence (TLS), deliver Entity Relationship Diagram, and performance related initiatives.
• Created and modified Setup Manager meta-data which helps in identifying the setup tasks required to support a specific implementation and presents those tasks in the sequence in which they must be completed
• Set-up and maintained PeopleSoft security.
• Refined and validated the Table Loading Sequence for Release 9.0.
• Reviewed Parent-Child relationships for newly created records, created ERD Groups and attached it to the components to generate CS ERD diagrams,
• Delivered performance/benchmark definition, which is used to communicate real-world, tuned application performance to Customers, Sales Prospects, and Market Analysts.
• Created Data Load projects for all new batch processes developed in CS 9.0 using Data Expansion Tool which helps Performance & Benchmarking team to tune the application.
• Created stand alone tuning definitions for the Batch process delivered in CS 9.0
• Created Use Cases for Single User Testing (SUT) and Multi User Testing (MUT) for Performance Initiatives
Environment: PeopleSoft Campus Solutions 9.0, PeopleTools, Process Scheduler, Report Manager, Data Mover
Satisfactory Academic Progress (SAP)
Responsibilities:
• Developed a flexible tool that will allow campuses to calculate the SAP status following common policy criteria, i.e. graduated GPA cut-offs, max units, etc.
• Created Technical Design Documents
• Developed new Setup Tables, Pages, Components and PeopleCode
• Set up single user environments for Upgrade, Development and Testing
• Created Application Engine program to calculate SAP based on the rules defined by the Campus
Environment: PeopleSoft 8.1/8.9, PeopleTools, PeopleCode, Application Engine, Process Scheduler, Data Mover
Support & Enhancements - PeopleSoft HCM (A2B Upgrade)
Responsibilities:
• Was responsible for all technical tasks related to A2B upgrade
• Involved in the Design & development of Sensitive Data Access Framework.
• Involved in the creation and complete testing of jobs using the Ascential Datastage.
• Analyzed audit reports like SYSAUDIT and DDDAUDIT reports and took necessary actions to remove the discrepancies found.
• Worked on problem tickets from all the modules related to Development support.
Environment: PeopleSoft HRMS 8.3/8.9, People Tools v8.19/8.46, Oracle 9i, Ascential Datastage, X-Gen Transformation Generator, Windows
Admission Loads
Responsibilities:
• Had the ownership of maintenance requirements for the multitude of Admission Loads CRS, AMCAS and GMASS etc.
• Delivered all necessary code and object modifications to enable processing of these load with new data specifications as received from the external testing agencies.
• Created Technical Design Documents detailing all modifications to PeopleSoft objects.
• Developed new Admission Load Processes TAC for PeopleSoft CS 8.9 ANZ customers.
• Created Post process to port data from staging tables into PeopleSoft Application Tables
• Created and Modified Pages, Components, Application Engine, SQR, etc
• Delivered Unit Tests to ensure changes have been executed correctly.
• Worked on issues reported by customer, creating Impact Analysis for the changes involved and develop resolution for the incidents.
Environment: PeopleSoft 8.1/8.9, PeopleTools, Peoplecode, Application Engine, Component Interface, Application Package, Process Scheduler, Data Mover, SQR
Component Interface for Campus Community
Responsibilities:
• Developed Component Interface for Campus Community Setup components in CS 8.9
• Created Excel Interfaces using ExceltoCI utility to port data from legacy systems into PeopleSoft Application
Environment: PeopleSoft 8.1/8.9, PeopleTools, Peoplecode, Application Engine, Component Interface, Application Package, Process Scheduler, Data Mover, SQR
Support Development on Student Records, Student Financials and Contributor Relationship
Responsibilities:
• Developed new Records, Pages, Components and Peoplecode
• Set up and maintained security for the new components.
• Modified Application Engine and Application Package based on requirement
• Created Single User Environment for development and testing
• Modified and developed SQR & Crystal Reports. Created & executed unit test plans
• Did system testing, setting up of run-control and process scheduler routines, performed unit and integrated system testing and validated all system functions.
• Used Person Model Concept for retrieving data from HRMS tables to be used for Campus Solution processes.
• Involved in frequent interaction with functional and technical members of the team to make them understand the various methods to write effective coding and optimize the system.
Environment: PeopleSoft 8.1/8.9, PeopleTools, Peoplecode, Application Engine, Component Interface, Application Package, Process Scheduler, Data Mover, SQR
Unicode Conversion
Responsibilities:
• Unicode is a universal character set that encoded every character required to write virtually every written language. In Unicode each character can occupy 0-3 bytes as against the ASCII each character is 1 byte
• Worked extensively in converting COBOL programs for Unicode Compliance.
• Converted the COBOL programs using PeopleSoft delivered conversion utility.
• Changed the existing COBOL programs for Unicode compliance without breaking the logic.
• Animated, debugged and compiled all COBOL programs using NetExpress. Compiler.
• Involved in running regression test scripts using Rational Robot
Environment: PeopleSoft 8.1, COBOL, Net Express, Rational Robot
Software Engineer, SG Software Asia Pvt. Ltd 01/01-06/03
Responsibilities:
• Analyzed and implemented the various enhancements that are required by the End-User for Fimatrade* system
• Involved in the design of the new interfaces that were required for the newly added markets into the system
• Used JFC Swing (for UI Development), Rational Rose for the development of Use cases
• Designed the tables and GUI
Environment: MS SQL Server, Java
Software Engineer, Data Systems Pvt. Ltd 02/99-12/00
Responsibilities:
• Analyzed the requirements
• Designed and developed the Information Repository Management Systems and Multi Room Multi Chat Service in-house projects
• Designed tables, GUI using JSP and applets and Tested the whole system
Environment: Java, Oracle, JSP, Servlets
|
Skills: |
GEORGE DE MELLOW
George is a Certified Peoplesoft Consultant with close to ten years of IT industry experience and six years of Techno-Functional experience in PeopleSoft, which includes development and support of PeopleSoft Student Administration application version 8.1, 8.9 & 9.0. He has worked extensively on core Product development of PeopleSoft Campus Solutions 8.9/9.0. His PeopleSoft Campus Solutions expertise includes lead role in Campus Community, Admissions and Financial Aid modules involving new features, regulatory updates, enhancements and support development activities. He has good experience with PeopleTools, PeopleCode, Application Designer, Application Engine, Maintain Security, Utilities, Process Scheduler, Process monitor, Report manager, Component interfaces, Application Package, COBOL, SQR, Crystal Reports, XML Publisher etc. George has extensive Seagate Crystal Reports 8.5 development, SQL, SQR and XML Publisher reporting experience. He was the architect for data load projects, for adding new features and to define Performance & Benchmarking for PeopleSoft Campus Solutions 9.0. George has excellent communication and interpersonal skills.
TECHNICAL SKILLS:
ERP: PeopleSoft 7.5/8.1/8.9/9.0, PeopleTools, PeopleCode, Application Engine, File Layouts, Component Interface, Application Package, Maintain Security, PS-Query, Process Scheduler, Report Manager,
PeopleSoft Campus
Solutions Modules: Financial Aid, Campus Community, Recruiting and Admissions, Student Records, Contributor Relationship, Student Financials.
Reporting Tools: SQR, Crystal Reports, MS-Excel, XML Publisher
Operating Systems: Windows 95/98/2000, NT 4.0
Languages: SQL, COBOL, Java
Database: Oracle 10.x, MS-SQL Server, MS-Access
Other Tools: MS 2000 Suite – Word, Excel
CERTIFICATIONS:
• Certified Peoplesoft Consultant - People Tools 8.42
TRAINING:
• Functional training on UCAS (Universities and Colleges Admission Services) – UK specific.
• Functional training on Campus Solutions Financial Aid module.
|
Education: |
EDUCATION
• Bachelor of Engineering in Electrical and Electronics from Madras University, Madras, India
|
Endorsements
|
 |
George has received 0 endorsements.
|
George has endorsed 0 Members.
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
Public Messages
|
|
| From |
Date |
Message |
No public messages. |
|
|
