Venkata Bhava Narayana Rao Adavikolanu

309-***-****

ac3jnt@r.postjobfree.com

Summary:

Over 14 + years of PeopleSoft HCM & FSCM applications experience and total of 18 years of IT experience

Experience in more than 10+ Full life cycle Implementations

Expert in Workforce Admin, Configuration of all the modules, Absence Management, TAM, Time and Labor, ePerformance, Talent Acquisition Manager, Benefits, Payroll and Taxes

Worked on Accounts Receivables, General Ledger, Billing, Accounts Payable and Asset Management Modules in Finance

Worked in various roles such as Project Lead, Business Analyst, Functional Analyst, Systems Analyst, Upgrade Analyst,Trainer and Subject Matter Expert

Proficient in writing PS Query’s

Expert in Implementation, Re-Implementation, Configuration, Upgrade, Fit/Gap Analysis, Business Requirement Gathering, Functional Design, Technical Design, Test Script Development, Systems Testing, Customer Support, Legacy Systems Integration, PeopleSoft Integration, Issues Management, Customizations, Troubleshooting and Debugging

Worked on various vertical industries including Automotive, Financial Services, Healthcare, Energy, Manufacturing and Logistics, Utilities, Banking, Natural Resources, Medical, Insurance, Professional Services, Government, Hospitality Services, Retail etc.

Worked on Public Sectors, Higher Education, Private Sectors

Good knowledge of Functional testing and Quality processes and SOX related documentations

Education:

Andhra University, India Bachelor of Technology in Computer Science and Engineering 1998

Functional & Technical Trainings:

Provided PeopleSoft technical training for Corporates on People Tools for PeopleSoft 8.9 and 9.0

Provided PeopleSoft Functional training for Corporates for 9.0 WFA and 8.9 NA Payroll, Base Benefits and WFA

Technical skills:

Software: PeopleSoft 8.x, 9.x [HRMS], PeopleSoft 8.x, 9.x [Financials], Microsoft Developer Environment

Functional: HCM, Financials & Supply Chain Management and Plant Maintenance

Technologies: Client Server and Web Technologies

Operating Systems: UNIX, Windows and DOS

Tools: People Tools 8x, Developer Reports, Congo’s-Impromptu and Visual Basic 6.

Databases: UDB DB2, Informix 7x and Oracle, SQL Server

Professional Experience:

CATTERPILLAR US, Peoria, IL Oct 10 – Oct 17

Senior PeopleSoft Functional Consultant

Projects:

Cat Solar Turbines San Diego Feb 16 – Oct 17

Responsibilities:

Worked as Configuration and Functional Specialist on PeopleSoft Conversion from 9.1 to 9.2 and responsible for migration of maintaining the Configuration and Custom tables

Roles include maintaining the complete Configuration of HRMS which has WFA, NA Payroll, Absence Management and Time and Labor and Custom tables and Interface tables.

Involved in System Study and requirement gathering at onsite(San Diego)

Involved in fit-gap analysis sessions and conducted workshops on NA Payroll.

Responsible for gathering business requirements for the Custom Payroll Interfaces with the payroll team.

Responsible for preparing Core NA Payroll configuration documentation for core Installation, Foundation and Common Definition tables in v9.2.

Participated and demonstrated in the workshops with Users about the implementation strategy for conversion and configuration

Created Functional design of Conversion Programs and defining of Configuration mappings

Created Functional Mappings for Payroll Reports as per CAT standards

Created Functional Mappings for GL Interface for Solar Turbines

Created Mapping programs to map the data from 9.1 to 9.2 to map all the Configuration Items from 9.1 to 9.2 like Company’s, Paygroups, Earning Codes, and Deductions etc.

Configured the Departments as per the Department structure of the Organization

Configured the Benefit Plans for the Benefit System

Configured and mapped the Performance Rating as per the company requirements

Designed a program to upload the Review Rating in the Employee Review Page

Involved in identifying the custom Components and designing of Custom programs for NA Payroll

Involved in design of converting the GL Expenses and Account Codes

Involved in Complete end to end User Acceptance Testing and documented the Test Cases.

Implemented the project and trained the users

Analyzed the impact of PUMS and helped in testing the PUM for Payroll Functionality

Worked as Onsite and Offshore Functional Lead for the Project

Brazil PeopleSoft Conversion from GHRMS 8.0 to 9.2 Aug 14-Dec 15 15

Responsibilities:

Implemented PeopleSoft Conversion from 8.0 PeopleSoft to 9.2 PeopleSoft for Brazil.

Worked as a Functional Lead for Interfaces and identification of differences between 8.0 and 9.2

Identified all the Tables functionality and Components functionality which were different from 8.0 to 9.2

Created Mapping functions to map the different Job Codes and Salary grades etc. from 8.0 to 9.2

Designed Conversion Programs for all the WFA programs to incorporate the differences between 8.0 and 9.2

Implemented Metrical Functionality for Brazil which was a new feature in 9.2

Designed programs that had less data like Passport etc.

Created Mappings and functional conversion programs for Profile Management

Provided Functional mapping for the Payroll Interface for Payroll

Involved in identifying and implementing the Brazil specific functionality from 8.0 to 9.2.

Worked as Onsite and Offshore Functional Lead for the Project

Implemented all the Conversion Programs for Go Live and resolved the issues

Involved in support of payroll interfaces in extracting the data from 9.2

Provided Post Implementation Functional Support for 3 months which included resolving Functional issues.

Took part in the Internal and External project Audits

E* Trade Implementation Dec 13-Aug 14

Responsibilities:

Employee Shares of CAT are maintained by E*TRADE the contribution percentage of shares are based on the Salary grade of the Employees.

Worked as Product Specialist for E*TRADE EIP(Earnings Incentive Program) implementation for India and Brazil

Involved in System Study and requirement gathering at onsite(India)

Involved in functional mapping for the ETL programs for extracting the data from PeopleSoft system

Worked as a liaison between the customer and the developers

Role indicates creating functional scenarios and the checking the test cases in the files for E*TRADE

Involved in Creation of Shell Scripts for placing the data files

Conversion Programs from Legacy Systems to PeopleSoft 8.9 Oct 09-Nov 13

Responsibilities:

Caterpillar Acquired Company’s like Anchor Couple, Progress Rail, Bucyrus etc. all these companies are spread across the globe

Worked exclusively as a Conversion Specialist from Legacy systems of the respective companies to PeopleSoft 8.9 of CAT.

Supported NA Payroll functionally for processing Garnishments and generating of yearend W2s for various

Designed country specific programs for each Conversion as each country has to support the country specific functionality like National ID etc. and some CAT specific Functionalities

Created the Fuctional mappings for programs that were using AppEngines, Components Interfaces and File Layouts

Involved in development of the PeopleSoft Conversion Programs for WFA programs like Job, personal data and supporting the Country

Supported in Creating the Payroll Interfaces for all the countries

Implemented Conversion programs for 15 country’s where CAT is present to name a few (Italy, Germany, Hungary, Poland, Australia, China, UK, Mexico, USA etc.)

Supported Congo’s reports partly

Supported the configuration and functional issues after post implementations

Created an Employee Review program for uploading the Employee Review Data with Custom Functionality of CAT

Created Excel to CI’s for country specific requirements

Created a SQR program to extract a STIP Report

Created a Flexi pay program for processing the additional pay components of the Indian CAT employees

Created Payroll Interface for Mexico

Asurion, US Aug 09 – Aug 10

Techno Functional Consultant

Technical Consultant for Maintenance and Support of PeopleSoft HRMS 9.0 application.

Client is Insurance Company.

The technical environment includes: PeopleSoft 9.0 and People Tools 8.49.

Roles & Responsibilities:

Involved in customization of Route control profile at Onsite as a part of Customization to the customer

Integrated route control page and Work Flow Approval as per the requirements of the Customer

Functional / Technical understanding of the client’s Business requirements in HRMS

Customizations / Modifications to People Code,SQR and Application Engine and CI as there was a database upgrade from DB2 to Oracle

Created Test Scripts and did the functional testing of all the modules like WFA, Payroll to check if the database syntax was corrected implemented

Provided post implementation support after the database upgrade

Worked on the Performance tuning of the SQLs after converting from DB2 to Oracle

JLL, US Oct 08 – Jul 09

Techno Functional Consultant and Offshore Lead

Offshore Lead and Technical Consultant for Maintenance and support of PeopleSoft FSCM and HRMS applications .Client is a major Construction company.

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.9, People Tools 8.48 (App Designer, People Code, and PS Query), PeopleSoft HRMS 8.9 and SQR, AppEngine, CI

Roles & Responsibilities:

Coordination with functional users and gathering the requirements

Involved in creation of Financial reports for AP,AR and GL

Production support for AP.AR and GL and worked on break fixes and Customizations

Production support for HRMS issues like WFA module

Involved in Customization of App Engines, Component Interfaces

Involved in enhancements and resolving issues in FSCM

Participation in Client Conference calls.

CATTERPILLAR US, Peoria, IL Jan 08 – Sep 08

Techno Functional Consultant and Onsite-Offshore Lead

Onsite system study and Offshore Lead for Maintenance and support of PeopleSoft HRMS application and CRN (Congo’s Report Net).

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.9, People Tools 8.48 (App Designer, People Code, and PS Query), PeopleSoft HRMS 8.9 and SQR, CRN 8.1.

Roles & Responsibilities:

System study at Onsite(Peoria, IL) and interaction with the client

Coordination with functional users and gathering the requirements directly

Involved in the design of EEO reports for CAT

Functional / Technical understanding of the client’s Business requirements in CRN

Customizations / Modifications to People SQR

Designing of Reports in CRN using Framework Manager

Managing the offshore team

IBM Daksh, Gurgaon, India Oct 07– Dec 07

Techno Functional Consultant

Technical Consultant for Production Support and maintenance of PeopleSoft HRMS application. System study and hand holding of the support and worked at Gurgaon interacting with the clients directly.

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.9, People Tools 8.48 (App Designer, People Code, and PS Query), PeopleSoft HRMS 8.8 and SQR.

Roles & Responsibilities:

Coordination with functional users and gathering the requirements directly

Functional / Technical understanding of the client’s Business requirements in HRMS

Customizations / Modifications to People Code, SQR and Application Engine.

Involved in design of Leave Management System in PeopleSoft

PeopleSoft FSCM Support, US & UK Dec 06 – Sep 07

Techno Functional Consultant

Team Lead for the production Support and maintenance of PeopleSoft Financials (AR, GL, AP, AM and Expenses) application. Client is a Warranty group Company in US and UK and implemented PeopleSoft 8.9. Went to US for the system study and hand holding of the support to offshore and working as the Offshore Team Lead and interacting with the US and UK clients directly.

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.9, People Tools 8.48 (App Designer, People Code, and PS Query), PeopleSoft HRMS 8.8, FSCM 8.4 and SQR.

Roles & Responsibilities:

Worked as Techno Functional Consultant for Complete AR Module

Coordination with Onsite UK and WE Team.

Responsible for direct GL import and Edit processing and batch process.

Functional / Technical understanding of the client’s Business requirements in AR and GL

Production support and resolving issues on AR update process for UK business users

Responsible for all the issues and process adherences

Customizations / Modifications to n-Vision, People Code, SQR and Application Engine.

Participation in Client Conference calls.

PeopleSoft FSCM & HCM Support, Australia Apr 06 – Nov 06

Techno Functional Consultant

Project involves maintenance & enhancement of PeopleSoft Financials & HR applications. Client is leading Power-generating Company in Sydney, Australia. Worked as the Offshore Team Lead. Involved in the development of Global Payroll Absence reports, Supported Finance modules AP, AR and GL.

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.8, People Tools 8.44 (App Designer, People Code, and PS Query), PeopleSoft HRMS 8.8, FSCM 8.4 and SQR.8.9, People Tools 8.48 (App Designer, People Code, and PS Query), PeopleSoft HRMS 8.8, FSCM 8.4 and SQR.

Roles & Responsibilities:

Issue Analysis/Resolution.

Team Lead for the Offshore Team

Coordination with Onsite Team.

Functional / Technical understanding of the client’s Business requirements.

Customizations / Modifications to SQR, People Code, PS Queries and Application Engine.

Analysis, Specification Preparation, Coding and Testing of the Application and Reports.

Review of deliverables to ensure adherence to standards and quality

Participation in Client Conference calls.

Enhancing the Client’s Application and ensuring adherence to standards and quality.

Maintenance of PeopleSoft HRMS & Support for an HR Consulting firm Mar 05 – Mar 06

Techno Functional Consultant

Client is a HR Consulting firm incorporated in USA having 15000+ associates & 80+ offices world over. Project involves maintenance & enhancement of PeopleSoft HRMS application of client’s client. Worked as Team Member and interacting with the Clients directly and also taking care of the Process and deliverables. Mainly taking care of the Interfaces of HR and Payroll. Involved in enhancements interfaces of Payroll and HR

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.8, People Tools 8.44 (App Designer, People Code, PS Query),

PeopleSoft HRMS 8.8 and SQR.

Roles & Responsibilities:

Coordination with Onsite Team.

Functional / Technical understanding of the client’s Business requirements.

Issue Analysis/Resolution.

Customization of SQR, People Code, PS Queries, CI, and AE.

Analysis, Specification Preparation, Coding and Testing of the application and reports.

Review of deliverables to ensure adherence to standards and quality

Participation in Client Conference calls.

Enhancing the Client’s Application and ensuring adherence to standards and quality.

Support the batch Job activities.

Seibel Monitoring and creation of Seibel tickets

Migration of Database from UDB DB2 to Oracle for a Client of a Global HR consulting firm Jan 05– Feb 05

Techno Functional Consultant

The UDB to Oracle Migration project was carried out for a Client of a Global HR consulting firm incorporated in USA having 15000+ associates & 80+ offices world over the project includes generating the Impact Analysis for SQRs and Pages against identified patterns, coding and testing of the same.

The technical environment included: PC Pentium, Windows XP, PeopleSoft 7.5, People Tools 7.5 (App Designer, People Code, and PS Query) and SQR.

Roles & Responsibilities:

Conversion testing and debugging of SQRs from UDB DB2 to Oracle.

Testing the Functionality in PeopleSoft

PeopleSoft Financials – Accounts Receivables Oct 04 – Dec 04

Team Lead & Techno Functional Consultant

Client is a Global staffing Services provider firm headquartered in Wisconsin, U.S. and having over 1,000 offices in the US and 4,300 offices worldwide. This short term Project was carried out for the PeopleSoft application rollout for Spain. This included development of SQRs for different reporting needs of AR, GL and billing module.

The technical environment included: PC Pentium, Windows XP, PeopleSoft 8.4, People Tools 8.44 (App Designer, People Code, and PS Query) and SQR.

Roles & Responsibilities:

Development of Collection Reports and testing of SQRs for Accounts Receivables module.

PeopleSoft Financials – Billing Jan 04 – Sep 04

Team Lead & Techno Functional Consultant

Client is a HR Consulting firm incorporated in USA having 15000+ associates & 80+ offices world over. Project involves maintenance & enhancement of client’s PeopleSoft application including Financials. Working as a Team Lead (offshore) for the client. Involved in an effort to enhance an existing Finance package. As a part of this effort, planned, developed and maintained many of the needed enhancements to the PeopleSoft Finance package. Involved in database migration project (migrating PeopleSoft Financial application from Informix database to UDB DB2), which is a major project for client. Implemented Tax ware concept for Billing. Involved in implementation of Sarbanes-Oxley Act for the project. Involved in Congo’s migration work from Eureka. Involved in Implementation of Tax ware Update. Involved in UDB migration from Infomix to DB2.

The technical environment included: PC Pentium, UNIX, Windows Xp, Informix 7.32, DB2, PeopleSoft 8.x, People Tools, PeopleSoft Finance 8.4 and SQR V 6.1.4.

Roles & Responsibilities:

Team Lead for a 4 member Offshore Team.

Coordination with Onsite Team.

Functional / Technical understanding of the client’s Business requirements.

Issue Analysis/Resolution.

Analysis, Specification Preparation, Coding and Testing of the application and reports.

Review of deliverables to ensure adherence to standards and quality

Participation in Client Conference calls.

Enhancing the Client’s Application and ensuring adherence to standards and quality.

Support the month Begin / end batch Job activities.

Estimations, Casual Analysis and PMR Reports.

CMMS Jul 02 – Dec 03

Techno Functional Consultant

Computerized Maintenance Management System (CMMS) helps an organization in keeping an installation to the acceptable standard, monitor and analyzes the health of the plant. The system has been designed to streamline the maintenance activities of NPCIL (Nuclear Power Corporation of India Ltd)

Technical Advisor, Component Development, Database Design Site Inspection, Data porting, Acceptance Test, User Training and commissioning of Software. This project was developed and implemented using VB 6.0 and Oracle 8i.

Roles & Responsibilities:

In charge of the NPCIL Kaiga site and implemented the CMMS Software

Actively involved in Analysis, design, Specification Preparation, Coding and Testing of the application and reports

Have prepared documentation like SRS, DD, UTP and User Manual.

Creation of database at client site. Design and development of necessary triggers and procedures to create link between other databases like materials and finance to access data. The activities also extend up to tuning and administration of the database till hand over of the application.

User training on the product and Product administration training on the security modules for system administrator. Made the system Online and integrated with the Materials and Employee software.

Enhancing the Client’s Application and ensuring adherence to standards and quality

Maintaining backup and execution of scripts

IMPACT Apr 01 – Jun 02

Programmer & Offshore Support

IMPACT (Integrated Maintenance Plan and Condition Monitoring Trend) is a complete plant Maintenance solution customized for BHANDAR IMAM PETROCHEMICALS COMPANY, MARSHAIR, IRAN

Computerized Maintenance Management System, which simplifies the cumbersome processes involved in the Equipment Maintenance function. Housing all the basic details, which aid the efficient functioning of the system? It stores information with respect to the assemblies and sub-assemblies used in an Organization or Plant, and activities associated with the same. Preventive Maintenance for performing maintenance jobs on sub-assemblies, at frequent intervals, in order to prevent occurrence of failures. Oil and lubrication analysis. Condition monitoring with respect to performance, vibration and shock pulse of static equipment.

Roles & Responsibilities:

Involved in customization of the software

Have prepared documentation like DD, UTP and User Manual

Designed Work Flow Management

Pre-shipment Acceptance with Clients

Providing offshore support

Topaz Dec 99 – Mar 01

Programmer and Implementation with User Acceptance

This is a complete Enterprise Assets Management ERP product (Total Productivity of Assets to Z) customized according to the Shalimar Wire Industries Limited (SWIL) Company’s requirement.

Sales:

Sales System will completely automate the day to day activities of the Marketing Department, which will also function as a Management Information System (MIS), Like Information regarding competitor’s pricing will be available to management as a support for deciding on policy matters. To provide a Management Information System (MIS) with the help of past sales data, competitor's information, trend analysis, sales projection, etc. And MIS statements in an effective way so that it represents the latest information available. Two separate flows have been maintained for Domestic and Exports based on the Customers Requirement.

Accounts Receivables:

AR will register the customer and his details if the customer confirms the order the customer is issued a policy with certain Terms and conditions. The customer no that is generated in this system is carried out through the entire system. The finalization of the accounts is closed in this module.

Integrated with Accounts Payables and Sales System

MAVERIC (Material Administration Vendor Evaluation Rating Inventory):

Topaz Maveric is another materials module of Topaz ERP, which provides the functional user of material department of Exploration industries with a wealth of technical and functional convenience. The product is a Multi-Project Multi-Location Materials Management System, which can take care of Materials requirement of end users placed in varied geographical locations. It addresses all the activities right from the Material cataloging, through Requests, Procurement, to the final supply of materials to the remote users.

Roles & Responsibilities:

User Training and Implementation at the clients place

Developed all the applications at client place on interacting with the client on day to day basis

Functional Design and development of Sales System onsite for automating all the work carried out by various departments for domestic Sales and Export Sales. Integrating with AR, Materials, Operations Modules

Functional Design and development of Customer oriented Screens and Integrating with Sales Module

Involved in the coding and developing of cataloging oriented screens and integrated with the sales module.

Contact this candidate