Venkata Karthik Doddi

Senior PeopleSoft Consultant

647-***-**** (Canada)

ac31aj@r.postjobfree.com,

View my profile

Profile Summary

Fourteen years of comprehensive experience within Information Technology space spanning Enterprise Applications, Client Server and Internet technologies in designing and delivering ERP business solutions to the clients across multiple industries.

Nine years into full life cycle implementation, upgrade and support of PeopleSoft Financials covering all major modules such as General Ledger, Payables, Receivables, Billing, Purchasing, Expenses, Asset Management, Project Costing, Grants. Supplier Relation management applications such as eSettlements, eProcurement, eSupplier Connection

Five years into full life cycle implementation, upgrade and support of PeopleSoft HRMS solutions covering all major modules such as Core Human Resources(workforce administration, workforce development, position management, competency management, global assignment, career/succession planning, compensation/salary planning, HRMS security, department security tree-design/redesign), Base Benefits, Benefits Administration, Time and Labor, Absence Management, NA payroll, Payroll Interface, HCM Integration with General Ledger. Self Service applications such as Talent Acquisition Manager/Candidate Gateway

Excellent process orientation in performing project scoping, business process re-engineering, fit/gap analysis, requirements gathering, functional design, application configuration, user interactions, testing and production support.

High proficiency and hands on experience in PeopleTools Knowledge on PeopleCode, Application Engine, SQR, SQL. Integration Broker, AWE, Application Messaging and XML Publisher, Security/Portal Administration. Hands on experience in new PeopleTools 8.56 Features such as Elastic search, Fluid Design/Development, Composite/Connected Queries, Data Workbench, Navigation collections, Pagelets, Activity Guides

Strong expertise in Quality Assurance as part of full life cycle implementations of the above modules with specific emphasis on creating system/integration test plans, requirements traceability; developing manual test cases/test scripts; performing functional, integration and regression testing; managing defects and preparing comprehensive test metrics.

Good hands on experience in working with a). Automated Requirements/Testing & Defect Management Tools such as SQL Robot, Mercury Test Director 7.5/ 8.0, Quality Center, WinRunner 7x/ 8x, LoadRunner 7x/8x, Quick Test Pro 5x/6x/8x/9x, Rational Requisite Pro, Rational TestManager, Rational ClearQuest 6x,7x/ClearCase 6x/7x, DOORS, Quest Stat 4.1x. b). Databases such as Oracle 12c, 11i & 10g, SQL Server. c.) Database Interface Tools such as Toad, SQL Developer, WinSQL, nVision, Crystal Reports. d). Project Management Tool such as Microsoft Project and Microsoft Visio. e). Training development tool such as UPK 2.7 & 3.5. f). Project Methodologies such as Six Sigma, Agile and Compass.

Strong implementation/upgrade skills and high level of business process knowledge of PeopleSoft 8.3, 8.8 and 8.9, 9.0, 9.1 and 9.2 up to latest HCM Image 23 and Financials Image 25. Technical experience on PeopleTools 8.4x, 8.54, 8.55, 8.56.

Professional Experience

As an Independent consultant, the details of the various assignments that I have handled are listed here, in chronological order.

Project #1: Canadian Tire Corporation Feb 2017 – Present

Toronto, Canada

Role: PeopleSoft Solutions Architect

Involved in Implementation PeopleSoft Financials 9.2 Applications support including C2C Release 2, Credit to Cash implementation AR, Billing modules

Work with clients team to clearly outline project scope, goals, deliverables, and requirements

Effectively involve projects assigned and communicate heavily on all Functional/Technical related matters, Perform detailed root cause analysis and resolution

Meet clients team to ascertain requirements and discuss matters related to the project integration points and deliver end user training, Monitor production support issues and ticket queues

Perform independent systems analysis, unit/system testing, and debugging Assist with deployment to UAT and Production environments

Investigate and provide PeopleSoft functionality not currently utilized and provide best practice recommendations for future implementations

Create an atmosphere of competence, trust, and credibility by executing quality work on time Occasional on-call or overtime support required.

Project #2: Canadian Tire Corporation Feb 2016 – Feb 2017

Toronto, Canada

Role: PeopleSoft Senior Consultant

Involved in Implementation Project ONE PeopleSoft Financials 9.2 Applications support including P2P Release 1, A2R and R2R modules

Work with C2C team to identify scenarios for custom Billing interface and participate in meetings with Functional and Business users for Petroleum, Fuelco and Retailer Business Units

Come up with scenario identification strategy and map out process flow for test scenarios

Worked with IT manager and in conjunction with implementation partner to propose better process on time consuming manual steps for PeopleSoft project migrations to cover up backlog migrations

Work with Financial manager and team to understand 8.9 in-house Security Audit reports requirements and lead the requirements from fit/gap to 9.2 version and retrofit custom audit report requirements using BI Publisher/SQR reports

Develop custom folders into Fluid Tiles and develop security audit review pages in Fluid pages with phone/tablet layout modes and added custom folders as dashboard using Fluid Portal menu under Manager self service

Added audit reports with Fluid pages with graphical view on DML statements execution status on monthly summary report and number of statements failed/success status

Built Project Costing and Journal reconcile report with Time Sheet ID/Project/Department filters using Pivot grid graphical charts and in Fluid mode

Implement 8.9 Security audit reports in 9.2 and coordinate all steps with PS Admin, Database admin. Conduct Audit reports review session with end user managers and get an approval for implementation

Involve in transition phase between support team and Implementation partner to support critical and major Production issues and coordinate the overnight fixes and escalate/update the status to managers on the production issues held in overnight support

Assist support team with quick fixes and permanent fix approaches and bridge the gap between project and support team to distinguish the issues either defects and/or enhancements

Involved in C2C Billing/AR Petroleum complex programming fixes xml/application package customisation in generating Invoices and Customer Statements per each BU

Handle and fix number of pending technical defects for C2C UAT/SIT testing phase defects

Project #3: McMaster University Jan 2014 – Apr 2016

Hamilton, Canada

Role: PeopleSoft Senior Consultant

Responsible in implementing HCM 9.2 and FSCM 9.2 applications through fit gap analysis, configuration, testing and go live support for HCM Core HR, NA Payroll, Time and Labor and Financials General Ledger, Payables, Purchasing, Receivables, Procurement, Cash Management, Asset Management and Expenses

High-level tasks performed in FSCM 9.2 Implementation project

Work in conjunction with consulting team and with Business users to identify process improvements and business analysis with detailed specifications on IT solutions.

Involved in full life cycle implementation of FSCM modules from Fit/Gap, Design, develop and UAT test

Review of integration points with Core HR team for Employee Expenses reimburse thru Financials

Analysis and configure Procurement Cards for Employee expenses thru Procurement Purchasing module

Involved in detail sessions to configure FSCM 9.2 GL, AP, AR, Expenses, AM, PO modules

Work on configuring and implement delivered bank statement layout BAI2 and EDI 820 Payment wire transfer

Setup Diners, PCard, Amex credit card transactions for Employee expenses to Employee Wallets

Configure Bank reconciliation rules for External transactions and CIBC statements as Semi and Automated reconciliation rules

Configure and integrate Payroll Journal transactions thru General Ledger

Create and modify ALL Departments trees, nVision layouts and provide end user training and document modification guide on nVision reports, Query manager tool

Support Critical and major Production issues across all Financials modules

High-level tasks performed in HCM 9.2 Implementation project

Created a program that run in batch mode and synchronise Job Earnings Distribution entries with Department Budget Table

Involved in discussions and created custom T&L Rules development is in large part based on Collective Bargaining Agreement (CBA) provisions, McMaster University policies

Work on PeopleSoft Fluid pages and retrofit self-service pages to tablet compatible mode

Created a program using Component Interface on Conversion of Position Funding source

Involved in discussions to follow Contracts/Awards configuration rules and development in a large part based on Collective Bargaining Agreement (CBA) provisions, McMaster University policies

Handle Adjust Pay Cheque Statement printing according to McMaster needs in a format that is customized to meet McMaster look and CIBC cheque printing specification requirements and Incorporate MICR and signature

Add custom functionality to allow printing zero net pay statements (including Manual Cheques)

Customise Pay Cheque and Advice RTF Templates using XML Publisher

Customizing Paycheque and Pay Advice printing programs to allow up to 25 Earnings codes YTDs (plus the “Other” bucket)

Created a program that run in batch mode and synchronise Job Earnings Distribution entries with Department Budget Table

Worked on PeopleSoft Fluid pages and retrofit self-service pages to tablet compatible mode

Involved in knowledge sharing sessions with in-house developers and mentor the team with new features on Tools 8.55 and guide them on how to develop Fluid pages, Html/CSS style sheets, App class/methods

Created a program using Component Interface on Conversion of Position Funding source

Created a three steps Mass update Application engine program for annual recalculation of pension salary to accurately calculate the employee pension deductions for the upcoming Pension Plan year

Involved in setting up Coverage Codes and Group the codes and map to Calculation Rules

Provide hands on experience to Business user group and Finance team on implementing PeopleSoft 9.2 Image 20 patches/bugs

Support Critical and major Production issues in Payroll, Time and Labor and ESS/MSS modules

Project #4: Workplace Safety and Insurance Board Aug 2012 – Nov 2013

Toronto, Canada

Role: PeopleSoft Senior Consultant

As a senior consultant, the role consisted of project #A Upgrade of HCM 8.9 to 9.1 includes Core HR, NA Payroll, Base Benefits and Implementation of eRecruitment 9.1

Conduct departmental meetings to understand current process flow and suggest improvements based on new 9.1 features

Develop functional specs for special projects, data flow diagrams flow charts and functional mapping for automated solutions in support of business process operations and functions

Configure and create new Formula ID’s for the Life and AD/D and Disability Plan tables

Analysis and walk thru sessions with HR team to identify the Calculation Rules and Coverage codes, Rate IDs. Explain and map the new changes in 9.1

Document the Benefit and Pension rule changes with 8.9 and 9.1

Worked on PeopleSoft 8.9 MSS 4 level of workflow for Retire, Terminate and Job Change including HR BP and HR Trans Administrator approvals

Upgrade and retrofit the custom and bolt on definitions/PeopleCode from 8.9 to 9.1

Configure and redesign ESS/MSS 8.9 workflow in 9.1 AWE and delegation process

Install and configure PeopleSoft Test Framework (PTF) on local system to facilitate the Testing requirements. Worked with infrastructure team to update Web profiles for PTF

Worked with HR Trans users on Fit/Gap analysis for Base Benefits 8.9 and 9.1 Rate Table changes

Document the requirements on WSIB Careers internal/external Candidate Gateway requirements https://erecruit.wsib.on.ca/PSHREXTP/start.html

Configure pre and post functional steps as part of upgrade in all test passes

Analysis 9.1 Base Benefits setup changes and conduct sessions with HR department to understand the company Benefit plans and Pension policies

Document system enhancement proposals, outline issues, alternatives and provide recommendations detailing performance, costs, scheduling, time and benefits

Analysis and Implementation - Project #B Upgrade PeopleSoft FSCM 8.9 to 9.1

Perform functional analysis and gather business requirements

Analyze requirements to apply system solutions to business problems

Capturing prioritized business requirements from business process owners.

Create prototypes for new designs and walk through with business owners

Involved in Fit/Gap analysis session to assess PeopleSoft 9.1 FSCM new features

Conduct departmental meetings to understand current process flow and suggest improvements based on new 9.1 features

Handle nVision Reports conversion from EPM 8.0 to FSCM 9.1 including Security

Carrying out fit-gap analysis based on the business requirements gathered

Develop configuration design documents for all the special projects.

Develop migration scripts for the configuration data.

Develop test plans for system and User Acceptance testing.

Establish test entrance/exit criteria.

Execute system and integration testing of all the special projects.

Train business users and provide go-live support

Project #5: Legal Aid Ontario (LAO) Jun 2012 – Jul 2012

Toronto, Canada

Role: PeopleSoft Upgrade Assessment Lead

As a PeopleSoft Functional Analyst, below are the high level responsibilities in PeopleSoft Financials 9.1 Upgrade assessment phase including General Ledger/Reporting, Billing, Payables, and Receivables, Purchasing, Asset Management, Grants, Contracts, eSettlements and eProcurement

Establish PeopleSoft Financials upgrade assessment methodology to be used

Establish key activities, milestones and timelines for engagement

Lead the gathering of current state high-level business processes from department stake holders

Analysis the current organisation PeopleSoft reporting and accounting structure and identified the changes in core General Ledger Accounting allocation structure and calendar’s period open and close, Journal processing and cut off dates

Provide an overview of PeopleSoft Financials 9.1 features to department stakeholders

Lead the identification of business process gaps where near final state business requirements may not be readily configurable via a vanilla upgrade

Lead the inventory and identification of customizations and enterprise integration points

(EIPs) that will be assessed for replacement by vanilla functionality maintained or upgraded

Complete a customization, EIPs and vanilla upgrade implementation catalogue

Establish a business functional requirements specification (BFRS) that will be used to support a business case, along with upgrade request for proposal

Conduct demo’s to Business groups and department stake holders to get awareness of PeopleSoft Financials 9.1 new features

Project #6: Bayshore Home Health Apr 2011 – May 2012

Mississauga, Canada

Role: PeopleSoft Functional Consultant

As a PeopleSoft Functional Lead worked on implementation of PeopleSoft Financials 9.1 including Accounts Payable, Accounts Receivable, Billing, eSettlements, General Ledger, Purchasing, Expenses and Asset Management

Main responsibilities include interaction with business users and analysis, demonstrate Fit/Gap analysis between legacy system and PeopleSoft HCM

Performing detailed gap analysis with a review of delivered functionalities compared to the business requirements.

Conducting conference room pilot on a few business process areas and deltas related to the application.

Designing Setup Manager to generate list of project implementation tasks based on the product features selected.

Loading data using component interface into control, transaction and prompt tables.

Meetings with the SME’s to discuss their business needs and requirements

Undertaking detailed application configuration by populating setup tables in prototype environment with sample data.

Identifying areas to be customized to meet the identified requirements.

Conduct brain storming sessions with Business users to review configuration templates. Participate in system configuration for all modules. Analysis on PeopleSoft module functionality and had walk thru reviews with Business users to identify configuration setup

Worked on implementation tasks for configuration build, conversion activities and dev phases

Assisting the client in process redesign where feasible to avoid customization

Initial testing to confirm that the proposed configuration meets the business requirements

Training users to complete setup tables following the prototype example

Writing functional specifications for development where customization was necessary

Coordinating the migration of configuration and development from prototype and development environments to testing environment and then to production environment

Developing end-user training guides prior to implementation

Management and documentation of process overviews

Project #7: The Canadian Depository for Securities Limited Mar 2007 – Apr 2011

Toronto, Canada

Role: PeopleSoft Techno Functional Consultant

Projects: #1: PeopleSoft Upgrade 8.0 SP2 versions to 8.9 and PeopleTools version 8.47

Responsible to Upgrade the PeopleSoft Financials 8.0 (SP2) to 8.9 work on Functional analysis

Analysis and compare feature releases for Payables, Purchasing, Receivables, eBill, Billing, General Ledger

Responsible to Upgrade PeopleTools v8.47

Fit-gap analysis and compare release across PeopleSoft modules

Upgrade configuration documents, Vanilla Compare reports, SQR jumpstart compare reports

Created UAT scripts and perform testing in coordination with users in UAT phases

Coordinated Project meetings, Oracle Upgrade (Sandbox) Lab meetings, Vendor team meetings and technical framework for development activities

Follow up with team for any technical issues or Functional clarifications

Projects: #2: Electronic wire transfer and Electronic Distribution of Remittance Advices

Presented white paper with different approaches on integration of wire transfers project profile and scheduled demo for an approval from CFO (Chief Financial officer)

Responsible for High Level design document and Development Cutover (DCut) cost and analysis and effort estimates

Development of new Application Engine program using XML publisher to automate electronic process custom remittance advices (PDF format) to Vendors

Setup of EFT in PeopleSoft Accounts Payable

Development of new SQR to generate EFT file in Bank of Montreal’s (BMO) 80-character file format

Generation of a consolidated EFT remittance advice that can be sent directly to the Finance Accounts Payable printer

Projects: #3: Direct input of Manual billing data to PeopleSoft Financials v8.9

Developed a prototype in PeopleSoft, project profile and shown demos with different Business Units for project initiative approval

Responsible for functional analysis and Development Cutover (DCut) cost

Responsible for High Level design document with an effort estimates

Development of new pages to complete Billing Data Sheet module with a user billing data validation

Developed a notification process between managers of business users and users for every action

Applied new row level security based on custom user group Department ID.

Generation of email notification to groups with a PDF attachment of completed Billing Data Sheet for manager’s review

Projects: #4: Corporate HST, New Tax rules governance effective July 1, 2010

Responsible for functional analysis to apply correct taxes to billing transactions:

oLoaded to PeopleSoft Financials thru the customized Billing Interface program

oentered online

ogenerated thru the Recurring Bills functionality

Handled new tax rates and business rules

oRecord and report tax related accounting information associated with financial transactions to correct General Ledger account and department (cost centre) combinations

Generated customer, participants and non participants, invoices showing HST charges

Modified existing Billing interface Application Engine program to incorporate new tax rules based on Customer location and services used from different regions.

Changes impacted on PeopleSoft Financials v8.9 AP, BI, AR, AM, GL

Projects: #5: PeopleSoft Hosting Transition to new Vendor

Worked on proposal questionnaires and involved in Discovery phase to size the database and application usage

Provided complete information from the PeopleSoft Financials system to size the effort estimates on changes

Worked on outbound interfaces using Application Engine program and SQR program to integrate third party systems like Corporate Billing System with new PeopleSoft vendor

Created a new SQR to generate a Vendor details file and automated the batch run to interface the process with new Finance Purchasing system (SpendMap)

Added FTP outbound interface procedures (FTP-Process-UNIX, FTP-Process-NT) in cdsoven.sqr to transfer vendor data file from Application server (above path) to FTP server. Created a new sqc (cds_secure.sqc) to complete above step

Modules worked on PeopleSoft Financials v8.9 AP, BI, AR, AM, GL

Project #8: ING US, Atlanta Nov 2005 – Feb 2007

Tata Consultancy Services

Role: PeopleSoft Technical Consultant

ING US implementation of Time and Labor and Absence Management 8.8 Applications

Involved in the up gradation of Applications from 8.3 to 8.8 versions

Handled various types of SR’s related to technical way like SQL Scripts, PeopleCode, Application Engine programs and Component Interface

Customized the Workflows to send the mails to treasury box for accounting details

Developed Reports by using reporting tools SQR, Crystal Reports and Ps-Query

Worked in component Interface to create interface to PS and Taleo process

Written various types of sturdy PeopleCode as per the requirement to implement the business rules and validations

Developed the Application Engine program to send email attachment to HR box for employee leave details

Developed the component interface for outbound to Ariba application

Project #9: Birlasoft Limited Apr 2005 – Oct 2005

Role: PeopleSoft Technical Consultant

Project Description: ESA PeopleSoft Financials and HRMS 8.4 Global Payroll Implementation

Involved in the customization part in all the modules of ESA like Projects, Resource Management, Travel & Expenses and Contracts

Developed Project Initiation Requisition page, which is the basis for the creation of Projects in Birlasoft

Designed Workflow for getting approval from the Respective heads

Developed Reports by using reporting tools SQR, Crystal Reports and Ps-Query

Worked in Data Mover to migrate the data between PeopleSoft Databases

Worked in component Interface for creating New Assignments and for closing the old assignments

Written PeopleCode as per the requirement to implement the business rules and validations

Worked in the Security for providing authorization to Respective users

Project #10: Moody’s Investor Services, NY Jul 2004 – Mar 2005

Birlasoft Limited

Role: Technical Consultant

Project: Moody’s Investor Services, NY - PeopleSoft HRMS Global Implementation v8.8

Performed new Implementation of PeopleSoft Global HR 8.8 at the Moody’s Investor Services

Developed new Views, Pages, Components, and Records for HR users for data entry

Worked hand with the functional development team from Bearing Point

Has provided technical support for PeopleSoft Payroll to ADP Interface

Worked with PeopleSoft 8.8 Recruit modules. Added pages to existing components.

Investigated PeopleCode functionalities for the Recruit module

Implemented PeopleSoft HR 8.8 Portal administration and Security administration

Created Permission lists, Roles, User Profiles. Created Department Security tree.

Implemented security based on both location and department and Implemented portal security

Submitted processes to the Process Scheduler to run daily tasks recursively at specific intervals

Education

Bachelor of Technology in Information Technology 2004

oUniversity of Madras, India

Training / Continuing Education Summary

Continuous self directed or class room trainings to achieve Role / Project Role based competencies.

Business Planning and Consolidation (BPC) 7.5 user Training from PA & SAP 2011

The Canadian Depository for Securities Limited – 4-Days

oUsage of new BPC 7.5 web interface and benefits of SAP EVDRE and customization of DTS packages

Business Advisor Capability 2010

The Canadian Depository for Securities Limited – 2 day in-class & self study

oSignificance of developing business advisor capabilities besides focusing on Technology skills.

Spendmap Purchasing Plus 2010

The Canadian Depository for Securities Limited – 3-Days

oUsage of new Spendmap Purchasing application of complete user process flow to create requisitions to Purchase order with workflow.

International Finance 2009

Self study

oOptions and Opportunities offered by International Financial markets, ways to maximize profits while effectively minimizing the risk when dealing at global level.

Securities Line of Business 2008

Self study

oGlobal Trading Methodologies, Clearing and Settlement process, Forex, Market types and behavior.

LinkedIn Recommendations from Previous managers

Nicole Longstaff, PMP, McMaster University, managed Venkata

"Karthik has been an invaluable part of the PS HCM support team at McMaster. The high quality of his work and ability to effectively work with our business to understand their requirements has been critical to solving complex system issues. Karthik cares about doing a good job and will go the extra mile when necessary. I highly recommend Karthik for any PS HCM related role that would leverage not only his technical skills but also his leadership ability."

Joe Baker, Senior Project Manager WSIB, managed Venkata

"I had the privilege of having Kart work on my Project Team during the HRMS upgrade and implementation of HRMS new Modules at the WSIB. During this year and a half initiative Kart not only displayed his expertise as a PeopleSoft Developer but as a Functional Expert as well. As project Manager I had many occasions where I drew on Karts superior Stakeholder relation skills as well as his functional expertise. I can truly say that without Kart’s contributions the project would not have received the success that we did. Thank you Kart for a job well done. "

Ramya Chandrasekaran, WSIB

"It is my pleasure to recommend Vekata Karthik Doddi, his performance working as a People Soft consultant with one of our well known client proved that he will be a valuable addition to any company. I have known Venkata for a little over two years in my capacity as a Sr. Recruiter at Procom. Venkata worked for me on a particular rather niche project as a consultant with one of our client and based on his work, I would rank him as one of the best consultants we have ever had in his domain. Venkata is highly intelligent and has good analytical and communication skills. Highly recommended

Frank D'Addio, CPA, CA, was Venkata's Vendor – Legal Aid Ontario (LAO) Experience

"Venkata played a big role in our success on a PeopleSoft Financials 9.1 Upgrade assessment at our client. Venkata successfully demonstrated PeopleSoft 9.1 functionality to experienced PeopleSoft end-users and stakeholders. He did this in several organized sessions, proficiently answering questions and expertly demonstrating functionality in a clear, concise manner, all in PeopleSoft 9.1 in real-time, while highlighting benefits and opportunities for cost savings and improvements for our client. Venkata also greatly assisted on Page6 gathering functional requirements, interviewing stakeholders, and providing inputs into the business case for the upgrade. Venkata is extremely knowledgeable in PeopleSoft 9.1, is reliable, trustworthy, possesses great communications skills, is personable and a solid team player. Venkata joined our project mid-stream and made an immediate positive impact. It was a great pleasure to work with Venkata and I strongly recommend him."

Jackson Lun, MBA, CPA, CGA, CPA (Illinois), ITIL, Manager, Finance Systems and Operations, The Canadian Depository for Securities Limited (CDS), worked with Venkata at The Canadian Depository for Securities Limited (CDS)

"Venkata has provided support to the PeopleSoft financial system and has engaged in the development and implementation of numerous initiatives. He is very knowledgeable and is technically competent with a good understanding of the business perspective."

Contact Venkata on LinkedIn

Contact this candidate