Jitu Patel 647-***-****
Summary:
**+ years as a PeopleSoft Functional, Techno-Functional, Business consultant out of life time IT experience, 33+ Years of total IT experience that includes all areas of IT
Proficiency in ERP, PeopleSoft Implementation, Upgrade and support in HCM/HRMS, GCHR, Phoenix Pay System, MTRAC, MyGCHR (North American Payroll, Base Benefits, Position Management, Health and Safety, Workforce Development, ELM–Enterprise Learning Management, Absence Management, Time and Labor, Interfaces, eRecruitment, Campus Solutions, Student Admin, Student Academic, Recruiting and Admissions, Student Financials, Employee Self Services, manager Self Services, ePerformance, Personal security) Modules and FSCM (GL, AR, AP, PO, Billing, AM, EPM, Cash Management)
Experienced in PeopleSoft version 8.x, 9.1, 9.2 and tools version 8.4x, 8.51, 8.52, 8.53, Knowledge of 8.55, 8.56
Project level experience in business analysis, business requirement gathering, Fit-gap analysis, As-Is and To-Be process, understanding client requirement and Preparing documentations
Expert level knowledge of configure Integration Broker Gateways, Nodes and design to provide and consume web services, Configuration of Web Logic server for SSL (Secure https) web services
Expert level knowledge of creating & migrating maintenance packages using Change Assistant
Expertise to convert classic components, pages into fluid pages
Expert level knowledge of impact analysis by version change for upgrade
Extreme knowledge of data mapping, data conversion and migration from Legacy system data (Oracle, SQL Server, DB2, Sybase, DBF, Text and CSV files) to PS Oracle, MS SQL server
Expertise in development of connected queries, queries with unions and inner-outer joins, sub-queries and ExcelToCI functionality
Extensive knowledge of creating Data Flow Diagram, Entity relation Diagram, and Data Mapping
Performed Functional, Integration, Regression, and System testing
Experienced in all phases in SDLC
Expert level knowledge in Excel using Macro development, Pivot Tables, Formulas, Search Functions, and functionality which can help to reduce time line in business
Worked to setup Time and Labor Rules, Developing App packages for Applying Time and Labor rule in Self Service Module
Experienced with full Implementation of 9.1 and Full upgrades of PeopleSoft 8.x and 9.x
Strong command on People Tools that includes App Engine, People Code, App Packages, App Designer, Integration Broker, AWE, Work Flow, Change Assistant, Fluid User Interface, SQL, PS Query, Query Access Services (QAS), and Data Mover
Experienced in PeopleSoft Enterprise Portal setup & development, Integration Broker, Component Interfaces, Integration Tools and Upgrade assistant, Consuming and Providing web services
Expertise to configure 3rd Party document base synchronous Web services to Consume in PeopleSoft
Expertise to design and develop customize reports using PeopleSoft and third party tools
Strong command over reporting tools such as SQR, SQL Query, PS Queries, XML Publisher, Crystal Reports and more than 10 Years of experience on mainframe COBOL
Extensive knowledge of SQL functionality, SQL queries in any database
Expertise for performance tuning on App Engine Programs on Component Interface
Good command over Unix AIX commands
Expertise in Microsoft Office Tools, MS Visio and Excel using Pivot table and charts, Database tools Toad, Golden, SQL Server Studio
Worked on Debugging, Tracing, Troubleshooting and Testing of PeopleSoft Applications
Excellent performance tuning practices in all the areas of consulting and developing
Solid knowledge of Financial Accounting and Principals
Expert level knowledge of all accounting processes and methods which is helping myself to understand business processes and requirements
Exclusively involved in support AM and T&L functionality
Experience in GO-Live and post-production support activities
Great experience on other technologies including c#, Java, .Net, VB, COBOL, FoxPro, Clipper and other GUI tools
Professional Experience:
Treasury Board Secretariat, Canada (Ottawa) Nov 2018 to Current PeopleSoft Consultant
Analyzing Phoenix inbound and outbound interfaces to document data structure those designed in SQR and app engine programs
Involved in modification of App Engine Programs, People Code, Records, Pages, SQR
Exclusively work on integration tools including Integration Broker configuration, Sync and Async Messages, Queues, Nodes, testing and implementations
Designed queries using unions and inner-outer joins, sub-queries and connected queries
Analyzing for data elements for NextGen applications from MYGCHR
Preparing Entity Relationship and Data Flow Diagrams
Creating As-Is architecture diagram for GC version of PeopleSoft
Working for Analyzing Phoenix Pay Issue and documenting
Preparing reports for analysis purpose using BI/XML publisher
Involve in analyze existing data elements in PeopleSoft and preparing detailed Data-Dictionary document
Designed web page and published on TBS web site
Attending weekly status meeting and provide detail summary on issues and resolutions
Analyzing existing interfaces and integrations for related bugs
Suggesting best solutions and updating interfaces based on issue assessment and resolution guide
Environment: PeopleSoft GC HRMS 9.1, People Tools 8.51, MS Office, MS Visio, MS Excel GC Docs, Oracle Database, PS Query, SQL Management Studio, SQL Developer, Cisco Any Connect, Unix and Windows Server, Putty, WinSCP, Outlook . HTML, Java Query
Delaware North, Buffalo, USA Mar 2019 to Jun 2019
PeopleSoft Consultant, Part Time Task Base 100% Remote work
Analyzing for requirement and conversion of existing classic page into Fluid Pages
Designing, development Fluid Pages, Components, Records, Fields, People Code as part of development activity
Assigning security to newly designed objects
Performing unit, Integration, smoke testing
Migrating developed objects to QA environment
Attending weekly status meeting and providing status of project work
Converted Employee Pay check view pages from classic to fluid and migrated to QA/PRD environment
Converting Employee Personal Information pages to fluid
Environment: PeopleSoft HRMS 9.1, People Tools 8.54, MS Office, MS Visio, Oracle Database, PS Query, SQL Developer, Cisco Any Connect, Unix and Windows Server, Putty, WinSCP, Outlook
Natural Resources, Canada Mar 2019 to Apr 2019 PeopleSoft Consultant (Part Time)
Analyzing current requirement for enhancement and maintenance
Designed Position Listing Report and Inactive Position Report using SQR
Tested developer SQR reports in TST environment and migrated to Production
Designed, tested and migrated Workplace Committee in XML Publisher
Environment: PeopleSoft GC HRMS 8.9, People Tools 8.51, MS Office, MS Visio, MS Excel GC Docs, Oracle Database, PS Query, SQR, XML Publisher (BI Developer), SQL Management Studio, SQL Developer, Cisco Any Connect, Unix and Windows Server, Putty, WinSCP, Outlook
Department of National Defense, Canada (Ottawa) Apr 2018 to Oct 2018
PeopleSoft Consultant
Involved in upgrade project from 7.5 to 9.1
Assisted in fit-gap analysis, data mapping and data conversion
Worked to retrofit existing objects: People Code, Pages, SQR, BI/XML Publisher Reports, SQL, PS Queries, App Engine Programs, App Packages, Records, Fields,
Exclusively involved in setup Integration broker for internal system Military to Civilian and external system Phoenix, providing support to resolve day-tot-day issues
Involved in Go-Live war room activities and providing 24x7 support
Analyzing post-production issues, preparing reports, suggesting best solution
Design solutions & creating documentations based on analysis
Involved in Designing and developing solutions, fixes and change requests using development environment on People Code, Application Engine, Pages, Components, records, PS Query, SQR, BI/XML Publisher and SQL to correct defects and implement features as required by business
Designing technical specifications and documentations based on business and functional requirement
Configured Role and User Level security to the PeopleSoft objects
Exclusively involved in apply changes as per Program Center’s requirements
Developed SQL scripts to extract, clean and update data tables for 8.9, 9.1 and Phoenix
Applied service and maintenance packages as per release instructions
Involved in production support activities including migrating projects & objects to BA, PP, TST and PROD environment, resolving issues on integration broker and app-web servers, set up security for users
Presenting solution to functional and maintenance team
Exclusively worked for report designing and maintenance using PS Queries and BI/XML Publisher
Developed test cases for unit testing
Involved in analyzing functional requirements and preparing documents
Applying fixes in to development environment
Worked to create package for each reported issue and sending to maintenance team using Oracle tool Change Assistant
Exclusively working to design connected queries and union queries with inner and outer joins
Assisting to analyze and resolve data quality issues
Working to apply packages in TST environment for functional team
Involved in Unit, Regression, Integration testing and created related documents
Providing on-time production 24x7 support and solutions on assigned issues
Environment: PeopleSoft GC HRMS 7.5, 8.9, 9.1 People Tools 8.51, 8.52, HP ALM, assystNET, Share Point, GC Docs, Oracle Database, SQL database, PS Query, SQL Management Studio, SQL Developer, MS Office, PeopleSoft Change Assistant, JPrint, Cisco Any Connect, Unix and Windows Server, Putty, WinSCP, Outlook
Oracle Canada, Govt. of Canada Project Dec 2017 to Mar 2018
PeopleSoft Consultant
Exclusively involved in GC 8.9/9.1 maintenance and post production support
Analyzing GC production issues and providing reports to functional team leader
Design solutions & creating documentations based on analysis
Presenting solution to functional and maintenance team
Working on Phoenix integration and message loading issues to load batch input file, updating objects such as Messaging page, App Engine program, Integration broker, App messages regarding inbound and messages, Process definitions, Records
Re-designed Phoenix inbound batch process to import more than one inbound Phoenix message files at same time to reduce loading time
Developed test cases for unit testing
Analyzed functional requirements and preparing documents
Applying fixes in to development environment
Packaging solution for each reported issue and sending to maintenance team using Oracle tool Change Assistant
Exclusively involved in apply changes as per Program Center’s requirements
Worked for Designing and developing solutions, fixes and change requests using development environment on People Code, Application Engine, Pages, Components, records, BI/XML Publisher Reports, PS Query, SQR and SQL to correct defects and implement features as required by business
Exclusively involved in apply changes as per Program Center’s requirements
Developed SQL scripts to extract, clean and update data tables for 8.9, 9.1 and Phoenix
Working to apply packages in TST environment for functional team
Developed PS queries using connected queries
Designed reports on Leave Balances and summary using BI Publisher
Involved in Unit, Regression, Integration testing and created related documents
Helping functional team to provide best solution
Providing on-time production support and solutions on assigned issues
Environment: PeopleSoft GC HRMS 8.9 People Tools 8.51, 8.52, HRMS 9.1, Oracle Database, SQL database, PS Query, SQL Management Studio, MS Office, PeopleSoft Change Assistant, JPrint, Cisco Any Connect, Pidgin IM, Zimbra, Phoenix, Workforce Administration, NA Payroll
Agriculture Canada, Ottawa (PWGSC) Apr 2016 to Dec 2017
PeopleSoft Analyst
Exclusively worked for component interface based JOB and Position data mass update process by involving design component interface, records and app engine program
Updated SQR used for Personal Security enrollment where enrollment number was reaching at maximum number limit
Involved in business requirement analysis and preparing documentations
Analyzed for hacked data from non-production environments and provided detail reports on periodically hacked data elements
Designed process to mass upload employees training enrollments from CSV file to save manpower and avoid manual data entry mistakes
Updated ExceltoCI templates to upload Payroll & HR Data into Phoniex system
Assisted to analyzed production issues and provided reports
Created solution for Phoenix and GCHR data comparing on Employee’s name and address
Analyzed functional and technical requirements on SABA training loading process, mapped fields values and created mapping documents
Participates in bi-weekly status meetings and suggested solutions for exiting issues
Analyzing production issues and implemented best solutions within time frame
Involved in unit testing and prepared detailed test reports
Involved in Designing and developing solutions, fixes and change requests using development environment on People Code, BI/XML Publisher Reports, Application Engine, Pages, Components, records, PS Query, SQR and SQL to correct defects and implement features as required by business
Designing technical specifications and documentations based on business and functional requirement
Assigned Role and User Level security to the newly designed PeopleSoft objects
Prepared SQL queries by adding inner and out joins, also designed connected queries to pool production data for analysis purpose
Exclusively involved in apply changes as per Program Center’s requirements
Developed SQL scripts to extract, clean and update data tables for 8.9, 9.1 and Phoenix
Exclusively worked for analyzing and resolving issue for Phoenix pay system in PeopleSoft production environment
Designed PS Queries to design various report on Benefits, Leave Transactions and Time and Labor, used PS Queries to produce reports through BI Publisher
Assisted to help resolving Phoenix pay system i49 messaging issues
Assisted to functional team members in testing
Designed test cases, Involved in Unit, Integration, regression and UA testing
Provided in-time production support and solutions on assigned issues
Environment: PeopleSoft HRMS 8.9, 9.1 My GCHR, People Tools 8.51, 8.52, Oracle Database, SQL Developer, ExceltoCI, Toad, PS Query, JIRA and Assyst issue tracking system, FTP Tool, WinScp, Putty, Share Point, MS Office, Phoenix, Workforce Administration, NA Payroll, 8.9 Maintenance, MTRAC Project Migration Tool, Change Assistant
Correctional Service of Canada, Ottawa Full Time - Jan 2016 to Mar 2016
Solution Architect (PeopleSoft) Part Time - Apr 2016 to Jul 2017
Participates in legacy team members meeting and identifying requirements
Analyzing exiting SDS to PeopleSoft interface and preparing documents
Primarily studying on PS to SDS out bound solution, preparing requirement, functional and technical documents
Generated key store certificates and performed Import-Export certificate as required
Configured Web Logic server to provide SSL web services
Analyzing for provide and consume web service to sync with legacy system
Identified the policies and requirements that drive out a integration solution
Design and develop technical architectures for proposed system integration, developed frameworks and strategies
Preparing power point presentations and requirement documentations
Created SQL and PS queries by adding joins (Inner, Outer) and unions to pool data from different tables
Assigned Role and User Level security to the newly designed PeopleSoft objects
Configured user level security to interface which designed for integration with T&L Legacy system
Prepared functional specifications and technical requirement documentations
Designed system architect for proposed integration system with SDS
Configured Integration broker, Nodes, Messages, Message Queue, Service and Service Operations
Developed and configured integration processes, web services, components and protocols
Exclusively designed and tested secured web services (SSL/HTTPS) to be consume by third party time scheduling system
Designed large application packages and app engine programs to process request messages and send response messages across both systems
Developed Component interface based system to update leave information
Involved in supporting Phoenix Pay system by resolving messaging issues to upload i49 files
Involved in customization and new development of report/process using SQR
Created Management Information Reports using BI/XML Publisher
Configured and executed ExcelToCI template for updating Person Addresses
Designed PS queries to produce validation and data loading reports on SDS interface
Helping to resolving Phoenix pay system i49 messaging issues
Helped to administer PeopleSoft App, Web, Process, PUB/SUB servers
Performed Message Schema, Service Operation, SOAP testing using XML file
Prepared prototype for system integration and presented to senior management team
Implemented designed system with integrated database
Prepared test cases, Involved in Unit, Integration, regression and UA testing
Helped to analyze and resolve issue for Phoenix pay system in PeopleSoft production environment
Environment: PeopleSoft HRMS 8.9, 9.1 My GCHR, People Tools 8.51, Web Logic, Integration Broker, ExcelToCI, SDS proprietary system, Oracle Database, PS Query, SQL Developer, Toad, HP QC, FTP Tool, WinScp, MS Office, MS Visio, SDS Legacy system, Snag it, Phoenix, Workforce Administration, NA Payroll, Messages, 8.9 Maintenance
Employment and Social Development Canada, Gatineau Apr 2015 to Dec 2015
PeopleSoft Analyst
Project Description:
MY GCHR is a government-wide Human Resources (HR) Information Technology application which will provide better value for the delivery of Government of Canada HR services by replacing over 40 HR solutions with a single central standard. Mr. Patel’s role is to analyze, categorize, resolve and report on PeopleSoft issues within the environment.
Working on supporting post-production defects and helping to resolve
Analyze and replicate defects in My GCHR environment, preparing documents and assign to MY GCHR help desk
Follow up and updating defect details, solutions and other details on HP QC
Analyzing configuration issues and suggesting solutions
Working on PS queries to replace existing queries which is not consistence and showing un-expected results
Updated and developed new SQR report and processes to meet Business requirements
Studied existing environments and setup
Prepared mapping and technical documents for de-normalization process
Assisted new users with on-boarding, creating roles and assigning role based securities
Designed new reports using XML Publishers
Exclusively worked to design PS queries, used extended knowledge of developing connected queries
Re-designed existing DSB-QAS PHOENIX interfaces and PeopleSoft queries which were inconsistent with business requirements and PHOENIX functionalities
Worked with team to provide solutions for existing issues and coordinated within MY GCHR
Designed and implemented role-based security (authorization and authentication) for Java/J2EE applications
Implemented PS-PHOENIX interface using Integration broker
Environment: PeopleSoft My GCHR 9.1, Tools 8.53, Oracle Database, SQL Developer, HP QC, FTP Tool, MS Office, PS Query
Ministry of Government and Consumer Services, Ontario Oct 2014 to Mar 2015
PeopleSoft Analyst (Techno Functional)
Reviewed technical design and processes for LD related processes using Component Interface and SQL updates
Analyzing Labor Disruption processes developed back 2012 which has very low performance
Worked on identifying requirements and the organization’s policies and requirements that fulfill the solution
Added mapping and staging setup tables to remove hard coded logic from programs
Removed update statements where ever causing issue of time out and deadlock
Enhanced major performance on WS process
Re-wrote required SQL’s and People Code for optimizations, also re-arranged App Engine steps and actions
Cloned existing WS AE program to new, replace most of SQL tables by temp tables and made it runnable in parallel processes for performance improvement
Working on performance improvement and enhancement for all LD processes
Re-designing LD processes using Component Interface
Designed Leave Report using AE from scratch
Developed SQR reports towards functional requirements
Designed new SQL queries to pool information from existing database for union dues, Stat Holiday time load etc.
Designed required reports BI/XML Publisher
Designed and developed Crystal reports
Provided assistant to resolve SIT and UAT testing TPR’s
Prepared test cases, Involved in Unit and Integration testing, created test documentations
Designed technical specification documentations
Environment: PeopleSoft HRMS 9.0, DB2 Database, People Tools 8.51, Win SQL, Data Mover, MS Office, SQL Tools, PS Query, DB2 Tool, IBM Mainframe, MS Share Point, HP Quality Center, Component Interface, Integration Broker
WSIB, Toronto, ON Nov 2012 to Nov 2014
PeopleSoft Analyst (Techno Functional)
Analyzing functional and technical impact due to version change to upgrade 8.9 to 9.1 for HCM and FSCM on vanilla and customized components
Created Excel Macro to prepare version change impact report of upgrade version on PS Objects : SQR, SQL, PS Queries, nVision, COBOL
Created compare reports for Demo to Production version of database for version 8.9 and 9.1
Prepared reports using PS and SQL queries, Excel Pivot tables, Formulas and search functions
Involved in fit-gap analysis, mapping field values
HCM/HRMS:
Involved in full upgrade from version 8.9 to 9.2
Prepared technical requirement specification based on functional requirement
Exclusively designed formulas for Base benefits calculations
Configured Expenses Approval AWE and setup workflow for MSS/ESS
Involved in Retrofit of customized objects for upgrade of Base benefit, NA payroll, eRecruitment, ESS and MSS modules
Re-customized Employee’s and Pensioner’s Benefit Summary and Premium Calculation Statement
Involved in configure and setup different Leave plan, carry forwarded leave balance from legacy system, customized Leave Balances in ESS and MSS modules
Designed customized leave absence reports
Designed Benefit premium Report and Benefit Statement from scratch
Re-customized Automated Step Increment App Engine process, designed Employee Review Page, created new process to upload Employee’s data to review online next salary review date
Added new People code, functions, Application engine programs and Application packages to fulfill requirement, customized of People Code and HTML codes
Provided post-production Go-Live support
FSCM:
Involved in full cycle of upgrade from version 8.9 to 9.2
Prepared technical requirement specification based on functional requirement
Added new People code, functions, Application engine programs and Application packages to fulfill requirement, customized of People Code and HTML codes
Updated and reformatted payment checks in Crystal report
Designed GL legacy imported transactions acceptance and rejection reports in CSV and Text files, and secured ftp’d to shared folder using application engine program
Configure and setup 3rd party document base synchronous web services for reconciliation with PeopleSoft GL/AR data
Prepared SQL queries using Unions, Left, Inner and Outer joins
Designed reports as per IFRS standard
Configure GL source values and required integration parameters
Working on PeopleSoft-MACS legacy system integration using Integration Broker
Retrofitted nVision reports impacted due to upgrade version change, created new queries and updated queries for performance enhancement
Involved in functional testing using test scripts and prepared testing documents
Involved in production support for day-to-day production issues including Application Engine Programs, Batch Job processing, People Code, SQR,BI/XML Publisher and scheduled jobs
Prepared PP presentation of new technical functionality available in people Tools
Provided pros-production support and helped out to resolve all defects occurs after go-live
Environment: PeopleSoft HRMS 8.9 to 9.2, FSCM 8.9 to 9.2, DB2 Database, People Tools 8.48, 8.49, 8.52, N-Vision, Query, Data Mover, SQL Server, MS Office, SQL Tools, DB2 Tool, IBM Mainframe, MS Share Point, HP Quality Center 10.0, Win SQL, Kanban Agile Method, BI Publisher, AWE, Workflow, Integration Broker, 3rd Party Web Services, Crystal Report
Oracle Canada ULC Jan 2012 to Nov 2012
Principal Consultant
Responsibilities
I have been assigned on various projects.
Government of Canada (Upgrade and Accessibility Project)
Worked on analyzing object to upgrade 8.9 to 9.1
Prepared PP presentation of new technical functionality available in people Tools
Prepared technical requirement specification based on functional requirement
Retrofitted changed object due to upgrade for Base benefit, Position Management, ELM, eRecruitment, Absence management, and Health & Safety modules
Design and updated reports developed in SQR and BI Publisher
Re-customized Employee’s Benefit Summary and Premium Calculation Statement
Worked on accessibility project to enable listening functionality to the visible inspired employee via Jaws software in PeopleSoft GC HRMS application
Added new People code, functions, Application engine programs and Application packages to fulfill GC requirement, customized of People Code and HTML codes
Prepared reports using PS and SQL queries, Excel Pivot tables, Formulas and search functions
Helped to implement Absence Management module
Assisted to configure Absence Management module by assigning different vacation and leave plan, prepared design to display online leave balances
Involved in functional testing using test scripts and prepared testing documents
Environment: PeopleSoft GC HRCS 8.9, My GCHR 9.1, People Tools 8.51, 8.52, SQL Server, Oracle 10g, MS Office, HTML, SQL Tool, COBOL
Verizon Wireless (HCM 9.1 Upgrade Project)
Assisted to prepare comparison of new functionality available in People Tools 8.52
Designed Excel Macro to prepare version change impact report of upgrade version on PS Objects: SQR, SQL, PS Queries, N-Vision, COBOL
Converted and mapped TAM (Talent Acquisition Management) from prior version
Prepared excel sheet and Power point presentation for new functionality and enhancement available and submitted report to higher authorities
Assisted in fit-gap analysis for HCM upgrade modules Core HR, North American Payroll, Benefit, Time and Labor and Absence management
Prepared PP presentation for upgrade project
Provided guideline to migrate Accomplishment tables to JPM profile tables, analyze and created fit-gap reports, data mapping sheets and documents, migration strategy and helped to migrated tables in to new version
Prepared comparison report, ran data conversion scripts and processes, prepared validation reports and migrated object summary
Established leave plan and converted data from Legacy system, re-customized reports as some tables of absence management has been changed in upgrade version
Prepared excel sheet and Power point presentation for new functionality and enhancement available
Resolved data object issues and migrated in test database
Helped in resolution of data inconsistency
Assisted to implement Absence Management module
Prepared reports using PS and SQL queries, Excel Pivot tables, Formulas and search functions
Environment: PeopleSoft GC HRMS 8.9 to 9.2, People Tools 8.53, MS SQL Server, MS Visio, MS Office, SQL Tool, SQR
MetLife Insurance (PS FSCM and IP/M SOA Sync Project)
Created request and followed up to create cloud base environment for PeopleSoft FSCM, IP/M (Image Processing Management) and SOA servers
Configured Integration broker Nodes, Services, Messages to provide functionality of synchronization of Oracle IPM/SOA server with PeopleSoft FSCM Account Payable
Added Functionality and customized online express invoice entry page to populate all available and not entered Invoices available on IPM/SOA server while entering purchase invoices
Configured and customized AWE for Review AP Regular Voucher
Designed Workflow for Approval and Review of AP Quick Voucher Entry
Successfully tested demo and presented to client by Oracle team and implemented at client
Environment: PeopleSoft FSCM 9.2, People Tools 8.4x, 8.51, 8.53, Oracle 11 G, ADF, SOA, IP/M, MS Office, SQL Tool, AWE, Work Flow, Integration Broker
Algonquin College, Ottawa
Prepared fit-gap analysis PP presentation for HRCS 8.9 to 9.1 at Algonquin College, Ottawa
Involved in retrofit of PeopleSoft Custom objects such as App Engine Programs, People Code, SQR and Crystal report impacted by upgrade version
Worked for create and migrate project for updated objects, involved in tracking and resolving issues, coordinated testing, and monitored progress
Exclusively worked to extract, transform and load student admission and personal information from csv file and loaded into appropriate tables
Involved in applying new patches and bundle to upgraded version
Prepared process to import legacy system data and converted for Student Records and Admissions
Customized student invoices and receipt format
Configured AWE for student academic class approval
Designed interface to help international student for retrieving information from system and store esteemed student information to system