Supply Chain Business Consultant

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 (

Contact this candidate