Jitu Patel 647-***-****
Linked-in profile: www.linkedin.com/in/jitu-patel-47384719
Summary:
35+ years of total IT Experience, 18+ years as Oracle ERP Functional, Techno-Functional, Business consultant that includes all areas of IT, Best knowledge of Cloud Technology, applications and tools
Practical knowledge of Enterprise Architecture Framework, Processes and Methodologies
Functional knowledge of HCM processes that includes Core HR, Benefits, NA Payroll, Time and Labor, Absence Management and Self-Services, Financial processes such as AR, AP, GL, Inventory, Order Management, Chart Fields, Year-end processes, and IFRS, Student Admin processes including Student Admissions, Student Grading,
Solid knowledge Financial Accounting and Principles, Expert level knowledge of all accounting processes and methods which is helping myself to understand business processes and requirements
Proficiency in ERP Implementation, Upgrade and support in Human Capital Management, Campus Solutions, Financial and Supply Chain Management, Phoenix Pay, Legacy, Point of Sale systems
Experience with cross-industries: Federal, Provincial Government, Local City bodies, Semi-Government, Colleges and Universities, Super Market, Large Corporate Sector, Agriculture, Supply-Chain companies, Insurance, Banking and Financials, Health Care, Retail, IBM and Oracle consulting companies, Software Development companies
Project level experience in business analysis, business requirement gathering, Fit-gap analysis, As-Is and To-Be process, understanding client requirement and Preparing documentations
Life time working experience of all phases in SDLC, experience on designing Legacy and ERP applications using Object Oriented Processes and Methodology (OOP)
On-Project experience to prepare Functional requirements, Technical Specification, Fit-Gap Analysis documentations
Project level experience in preparing strategies for implementations and upgrade applications
Highly experienced in Impact, Fit-Gap analysis, As-is and To-be system process, cost, resource analysis
Implementation and upgrade experience on ERP, Legacy and COTS Tools
Perusing Strong knowledge of data modeling, data governance, analytic systems and processes and ETL.
Demonstrated knowledge and experience in Financial Services
Hands-on experience with database technologies such as Oracle, SQL Server, DB2, Sybase, and MS Access
Very good knowledge of data visualization and analyze tools including BI Publisher, Power BI, and SAS Visual Analytics
Exclusively worked to create use-case, test cases, involved in Unit, Regression, Integration, Smoke, User Acceptance testing, worked to provide post-product support
Extensive knowledge of creating Data Flow, Entity-Relation and Process Diagrams Performed Functional, Integration, Regression, and System testing
Excellent performance tuning practices in all the areas of consulting and developing
Expert level knowledge of configure of integration of 3rd party to/from Legacy Systems, and design to provide and consume web services, Configuration of Web Logic server for SSL (Secure https) web services
Experience in GO-Live and post-production support activities
Extreme experience on multiple Operating systems and utilities: Windows, Window Server, DOS, Unix, Linux, Mainframe, JCL, Unix AIX, Ctrl-M
Experience on virtual server tools such as VMWare, Virtual Box, Remote Desktop, Putty, WinSCP, Cisco Any Time
Experience with cross-databases OOD including Oracle, SQL Server, DB2, Sybase, MS Access, DBF, extensive experience on Text and CSV files to convert into database
Advance knowledge and experience on MS Office Excel using Formulas, Macro, Pivot tables etc. utilities
Expertise in development of SQL Queries, connected queries, queries with unions and inner-outer joins, sub-queries
Perusing knowledge and experience of Business Analytic (BI) tools Oracle BI Publisher & XML Publisher, SAS EG, SAS VA, MS Power BI, OTBI, Smart Sheet, SQL Server Reporting Services, Business Objects, Crystal Report, IBM Cognos BI
Strong command over technologies: SQL Tools, Toad, Golden, SQL Management Studio, SQL Plus, BI Tools, MS Excel, Databases, Work Flow, Integration Tools, Enterprise N-tire server technology (App, Web, Process, Database), Incident management, Cloud and Web technologies, GUI Tools
Experience on multiple programming languages: SQR, People Code, Application Engine, HTML, XML, CSS, Web Services, Java, Java Script, JSP, Python, ASP.Net, VB.Net, Visual Basic, C#, C++, Clipper, COBOL, FoxPro, DBASE III PLUS
Best working experience of MS Office Suites includes Word, Excel, Power Point, MS Access, Outlook, MS Team, MS Visio, good knowledge on MS Projects
Advance level knowledge of Microsoft Excel using Macro development, Pivot Tables, Formulas, Creating Graphs, Search Functions, and functionality which can help to reduce time line in business, Experienced in ExcelToCI functionality
Best work experience on incident management tools such as Share Point, JIRA, HP ELM, assystNet, HP QC, Excel Smart Sheet
Experienced with full Implementation and upgrades of PeopleSoft 8.x and 9.x, Involved in Workday implementation, UltiPro(UKG) Analysis and transformation
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), Data Mover, Enterprise Portal setup & development, Integration Broker, Component Interfaces, ExcelToCI, Integration Tools and Upgrade assistant, Consuming and Providing web services, configure 3rd Party document base synchronous Web services, BI Publisher
Professional Experience:
Region of Durham, Canada (Support-Part Time) Jun 2024 to March 2025
PeopleSoft Consultant (Techno-Functional)
PeopleSoft FIN 9.2, Tools 8.59
Module Working on: AR, AP, GL, Billing, Integrations
Analyzing assigned support tickets and preparing presentation documents
Design SQL Queries using SQL Developer, PS Query
Suggesting solutions on service ticket and guide to the client
Retrofit all required objects for the issues and doing unit testing
Analyzed and prepared technical documentation for 3rd party system integrations, develop, tested and migrated for functional and UAT testing
Preparing migration activities and documents
Involve in post-production support
Environment: PeopleSoft FSCM 9.2, People Tools 8.59, AR, AP, GL, Integration, SQL Queries, PS Query, SQR, SQL Developer, MS Office, MS Visio, MS Excel GC Docs, MS Team, AssystNet, ALM, SharePoint, MS Excel and Office Suite, BI Publisher
Department of National Defense, Canada (Ottawa) Nov 2022 to Current
ERP Consultant (Techno-Functional)
Upgrade Project: PeopleSoft 8.9 to 9.2, Tools 8.51 to 8.57 HCM/FSCM
Analyzing existing version of PeopleSoft and preparing presentation documents
Preparing documents on new functionality and enhancements introduced in 9.2
Documenting as-is and to-be system architecture chart
Preparing process flow chat for upgrade plan and path
Analyzing Benefits and preparing data mapping
Preparing as-is and to-be process charts
Gain best functional area expertise in UltiPro and Workday
Helping to find best option for available COST application for PeopleSoft
Analyzing Workday and Oracle HCM Cloud application implementation costs as option
Prepared detailed presentation on optional ERP implementations and presented in director level meetings
Using BI Tools such as Power BI, IBM Cognos, BI Publisher to generates the reports
Designed queries, App Engine Program, SQLs, People Code, extract reports using BI Publisher, IBM Cognos, Power BI, SQL Studio etc. available tools
Prepared different comparison excel reports using formulas, Macro, Pivot tables
Environment: UltiPro(UKG), PeopleSoft HRMS 8.9 & 9.2, FSCM 8.9 TO 9.2, People Tools 8.51,8.52, 8.57 Workday, Oracle HCM Cloud, MS Office, MS Visio, MS Excel GC Docs, MS Team, AssystNet, ALM, SharePoint, MS Excel and Office Suite, BI Publisher, IBM Cognos BI Tool
COX Auto Inc., USA-Canada Feb 2021 to Oct 2022
Team Lead – Data Conversion Intl. (PeopleSoft/UltiPro to Workday)
Migration Project: PeopleSoft/UltiPro to Workday Team Members: 25+
Interacted with the Canadian business team, USA Data Conversion team and implementer team, attended daily information and status meetings, provided updates and best solutions
Manage a Canadian data conversion team
Involved in business requirement gathering and Data Gathering Workbook Sessions
Analyzing existing PeopleSoft HCM/FSCM and UltiPro database and preparing documentations
Attending data conversion and Migration meeting, provided inputs on data migration strategy and steps
Analyzed all Data Gathering Workbooks and prepared detailed mapping requirements
Mapped all required fields for Workday conversions
Involved in all project management meetings and workshops
Documenting as-is and to-be system architecture chart and process charts
Preparing process flow chart for migration plan and path
Prepared data mapping sheets for HR application modules and tables
Created BI Queries and processes, PS Queries/SQL to pull data as per requirements
Prepared test cases and involved in unit testing
Prepared scripts and procedures for the data conversion using available tools excel, power point, word, SQL Developers, SQL Queries, Toad, Golden, IBM Cognos BI
Converted all data for Core HR, Benefits, Payroll, Time and Absence Management, Clocks, Infor
Involved in resolving defects and data quality issues
Designed few HR custom reports as per requirements
Exclusively involved in post-production activities and supports
Environment: PeopleSoft HCM 9.2, People Tools 8.57, UltiPro, Workday, MS Office, MS Visio, MS Excel GC Docs, Share Point, ADQP, IBM Cognos, BI Publisher, Power BI, MS Team, SharePoint, Smart Sheet, Kleopatra encryption tool, Pulse Secure, WinSCP, MS Excel and Office Suite
Department of National Defense, Canada (Ottawa) Aug 2020 to Jan 2021
ERP Functional Consultant
Upgrade Project: 8.9 to 9.2 and Workday/Oracle HCM Cloud Option Analysis
Analyzing existing version of PeopleSoft and preparing presentation documents
Preparing documents on new functionality and enhancements introduced in 9.2
Documenting as-is and to-be system architecture chart
Preparing process flow chat for upgrade plan and path
Analyzing Benefits and preparing data mapping
Preparing as-is and to-be process charts
Gain best functional area expertise in UltiPro and Workday
Helping to find best option for available COST application for PeopleSoft
Analyzing Workday and Oracle HCM Cloud application implementation costs as option
Prepared detailed presentation on optional ERP implementations and presented in director level meetings
Designed queries, App Engine Program, SQLs, People Code, extract reports using BI Publisher, IBM Cognos, Power BI, SQL Studio etc. available tools
Prepared different comparison excel reports using formulas, Macro, Pivot tables
Environment: UltiPro(UKG), PeopleSoft HRMS 8.9 & 9.2, People Tools 8.51 and 8.54, Workday, Oracle HCM Cloud, MS Office, MS Visio, MS Excel GC Docs, MS Team, AssystNet, ALM, SharePoint, MS Excel and Office Suite
Treasury Board Secretariat, Canada (Ottawa) Nov 2018 to Mar 2020 ERP Functional Consultant/Analyst (Oracle PeopleSoft, Data Dictionary and NextGen)
Project: Data Dictionary and NextGen, Team Members: 5
Analyzing Phoenix inbound and outbound interfaces to document data structure
Creating As-Is architecture diagram for GC version of myGCHR application and ER and Data Flow Diagrams
Analyzing data elements and created data model of MyGCHR Application, Mapped for proposed NextGen Application and prepared document for ETL process
Preparing detailed Data-Dictionary document using Excel
Exclusively worked on integration tools including Integration Broker configuration, Sync and Async Messages, Queues, Nodes, testing and implementations
Helping to analyzing Phoenix Pay Issue and documenting
Analyzing existing interfaces and integrations for related bugs
Preparing reports for analysis purpose using BI/XML publisher
Attending weekly status meeting and providing status of project work
Designed document on publishing data dictionary on GC website
Suggesting best solutions and updating interfaces based on issue assessment and resolution guide
Extremely used excel tool to analyze all reports and used Excel utilities like macro, formulas, pivot table etc
Environment: PeopleSoft myGCHR, People Tools, MS Word, MS Visio, Outlook, MS Excel, GC Docs, Oracle, DB2, and MS Access Databases, PS Query, BI Publisher, IBM Cognos BI, SQL Developer, Unix and Windows Server, HTML, Java Query, MS Excel and Office Suite, ALM
Delaware North, Buffalo, USA Mar 2019 to Jun 2019
ERP Consultant (Oracle PeopleSoft), Part Time Task Base 100% Remote work
Project: Fluid Pages Enhancement, Team Members: 4
Analyzing for requirement and conversion of existing ESS and MSS classic page into Fluid Pages including Personal Information, Pay check
Designing, development Fluid Pages, Components, Records, Fields, People Code, assigning security to newly designed objects to convert Performing unit, Integration, regression, smoke testing
Attending weekly status meeting and providing status of project work
Migrated tested objects to QA environment
Environment: PeopleSoft HRMS, FSCM, People Tools, MS Office, MS Visio, Oracle Database, PS Query, SQL Developer, Outlook, Power BI, BI Publisher, IBM Cognos
Natural Resources, Canada Mar 2019 to Apr 2019 ERP Consultant (Oracle PeopleSoft - Part Time)
Project: Report Enhancement, Team Members: 5
Analyzing current requirement for enhancement and maintenance
Designed Position Listing Report and Inactive Position Report using BI Publisher
Tested developer SQR reports in TST environment and migrated to Production
Designed, tested and migrated Workplace Committee in XML Publisher
Environment: PeopleSoft GC HRMS, People Tools, Oracle Database, PS Query, SQR, XML Publisher (BI Developer), SQL Developer, Outlook
Department of National Defense, Canada (Ottawa) Apr 2018 to Oct 2018
ERP Consultant Analyst (PeopleSoft)
Project: PS Upgrade and Support, Team Members: 15
Involved in upgrade project, assisted in fit-gap analysis, data mapping and data conversion
Presenting solution to functional and maintenance team
Prepared details technical specifications based on business requirements
Worked to retrofit existing objects and develop new as per requirement: 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
Provided solutions & creating documentations based on analysis
Involved in Designing and developing solutions, fixes and change requests Designing technical specifications and documentations based on business and functional requirement
Configured Role and User Level security to the PeopleSoft objects
Helped to configure Pay System Integrations and resolving issues
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
Applying fixes and patches in to development environment
Assisting to analyze and resolve data quality issues
Providing on-time production 24x7 support and solutions on assigned issues
Environment: PeopleSoft GC HRMS, People Tools, HP ALM, assystNET, Share Point, GC Docs, Oracle, SQL and DB2 Databases, SQL Developer, MS Office, Outlook, PeopleSoft Change Assistant, JPrint, Unix and Windows Server, ALM, BI Publisher
Oracle Canada, Govt. of Canada Project Dec 2017 to Mar 2018
ERP Consultant (Oracle PeopleSoft)
Project: myGCHR Support, Team Members: 10
Exclusively involved in myGCHR maintenance and post production support
Analyzing GC production issues and providing reports to functional team leader
Analyzed requirements and preparing documents, helping functional team to provide best solutions
Design solutions & creating documentations based on analysis
Presenting solution to functional and maintenance team
Working on Phoenix Pay 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
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
Developed SQL scripts to extract, clean and update data tables for MyGCHR and Phoenix
Involved in Unit, Regression, Integration testing and created related documents
Providing on-time production support and solutions on assigned issues
Environment: PeopleSoft MyGCHR, People Tools, Oracle Database, SQL database, PS Query, SQL Management Studio, MS Office, PeopleSoft Change Assistant, JPrint, Phoenix, Core HR, Benefits, Workforce Administration, NA Payroll, ALM, BI Publisher
Agriculture Canada, Ottawa (PWGSC) Apr 2016 to Dec 2017
ERP Consultant/Analyst (Oracle PeopleSoft)
Project: Enhancement and Support Team Members: 10
Analyzed functional and technical requirements on SABA training loading process, mapped fields values and created mapping documents
Designing technical specifications and documentations based on business and functional requirement
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 Phoenix Pay system
Assisted to analyzed production issues and provided reports
Created solution for Phoenix and GCHR data comparing on Employee’s name and address
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
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
Assisted to help resolving Phoenix pay system i49 messaging issues
Provided in-time production support and solutions on assigned issues
Environment: PeopleSoft, My GCHR, People Tools, Oracle Database, SQL Developer, ExceltoCI, Toad, PS Query, JIRA and Assyst issue tracking system, Share Point, MS Office, Phoenix, Workforce Administration, NA Payroll, MTRAC Project Migration Tool, Change Assistant, ALM
Correctional Service of Canada, Ottawa Full Time - Jan 2016 to Mar 2016
Solution Architect (ERP) Part Time - Apr 2016 to Jul 2017
Project: SDS Integration Team Members: 12
Participates in legacy team members meeting and identifying requirements
Primarily studying on PS to SDS out bound solution, preparing requirement, functional and technical documents
Identified the policies and requirements that drive out an integration solution
Design and develop technical architectures for proposed system integration, developed frameworks and strategies
Preparing power point presentations and requirement documentations
Prepared functional specifications and technical requirement documentations
Analyzing for provide and consume web service to sync with legacy system
Prepared prototype for system integration and presented to senior management team
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
Configured Web Logic server to provide SSL web services
Implemented designed system with integrated database
Generated key store certificates and performed Import-Export certificate as required
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 application
Created Management Information Reports using BI/XML Publisher
Designed PS queries to produce validation and data loading reports on SDS interface
Helped to administer PeopleSoft App, Web, Process, PUB/SUB servers
Performed Message Schema, Service Operation, SOAP testing using XML file
Prepared test cases, Involved in Unit, Integration, regression and UA testing
Environment: PeopleSoft My GCHR, People Tools, Web Logic, Integration Broker, ExcelToCI, SDS Legacy Application, Oracle Database, PS Query, SQL Developer, Toad, HP QC, MS Office, MS Visio, Snag it, ALM, BI Publisher
Employment and Social Development Canada, Gatineau Apr 2015 to Dec 2015
ERP Consultant/Analyst (Oracle PeopleSoft)
Project: Enhancement and Support Team Members: 6
Project Description:
MY GCHR is a government-wide Human Resources (HR) and Financial and Supply Chain (FSCM) 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.
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 existing environments and setup for configuration issues and suggesting solutions
Working on PS queries to replace existing queries which is not consistence and showing un-expected results
Worked with team to provide solutions for existing issues and coordinated within MY GCHR
Updated and developed new SQR report and processes to meet Business requirements
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
Re-designed existing DSB-QAS PHOENIX interfaces and PeopleSoft queries which were inconsistent with business requirements and PHOENIX functionalities
Designed and implemented role-based security (authorization and authentication) for Java/J2EE applications
Implemented PS-PHOENIX interface using Integration broker
Environment: PeopleSoft MyGCHR, FSCM, People Tools, Oracle Database, SQL Developer, HP QC, FTP Tool, MS Office, PS Query, ALM
Ministry of Government and Consumer Services, Ontario Oct 2014 to Mar 2015
PeopleSoft Consultant/Analyst (Techno Functional)
Worked on identifying requirements and the organization’s policies and requirements that fulfill the solution
Reviewed technical design and processes for LD related processes using Component Interface and SQL updates
Analyzing Labor Disruption processes which has very low performance
Added mapping and staging setup tables to remove hard coded logic from programs
Designed technical specification documentations
Re-designing LD processes using Component Interface
Removed update statements where ever causing issue of time out and deadlock
Re-wrote required SQL’s and People Code for optimizations, also re-arranged App Engine steps and actions resulted Enhanced major performance on WS process
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
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
Environment: PeopleSoft HRMS, DB2 Database, People Tools, Win SQL, Data Mover, MS Office, SQL Tools, PS Query, IBM Mainframe, JCL, Unix Shell Scripts, MS Share Point, HP QC, Component Interface, Integration Broker
WSIB, Toronto, ON, Canada Nov 2012 to Nov 2014
PeopleSoft Consultant/Analyst (Techno Functional)
Projects: HRMS Upgrade, FSCM Upgrade, GL Integration Team Members: 25
HCM/HRMS:
Involved in full upgrade, prepared technical requirement specification based on functional requirement
Involved in Retrofit of customized objects for upgrade
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 & 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
Configured Expenses Approval AWE and setup workflow for MSS/ESS
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, prepared technical requirement specification based on functional requirement
Updated and reformatted payment checks in Crystal report
Retrofitted nVision reports impacted due to upgrade version change, created new queries and updated queries for performance enhancement
Added new People code, functions, Application engine programs and Application packages to fulfill requirement, customized of People Code and HTML codes
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 with Guidewire legacy insurance application
Configure GL source values and required integration parameters
Working on PeopleSoft-Guidewire legacy system integration using Integration Broker
Involved in functional testing using test scripts and prepared testing documents
Prepared PP presentation of new technical functionality available in people Tools
Designed new reports for new requirement as per IFRS standard
Provided post-production support and helped out to resolve all defects occurs after go-live
Environment: PeopleSoft HRMS, FSCM, DB2 Database, People Tools, 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, ALM
Oracle Canada ULC, Toronto, Canada Jan 2012 to Nov 2012
Principal Consultant
Responsibilities
Oracle Canada
Analyzed and Prepared fit-gap analysis document using power point on version impact from tools 8.50 to 8.53 and application version 9.0 to 9.2
Government of Canada
Project: Upgrade and Accessibility Project team members: 5
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
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
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 HRMS, My GCHR, People Tools, SQL Server, Oracle 10g, MS Office, HTML, SQL Tool, COBOL, ALM
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 (