Manager Data
Resume:
Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 1 of 8
SUMMARY
** ***** ** ** ********** out of which 11+ years of experience in PeopleSoft Technology from 8.x – 9.2 versions which includes design and development of PeopleSoft Core HR, NA Payroll, Global Payroll, Base Benefits, ePerformance, eRecruit and Time & Labor modules.
Experience in end-to-end delivery of solution (design, development, peer review, testing and documentation) and also experience in preparing Estimation and Project Plan.
HCM Upgrade experience from PeopleSoft application 8.8 to 9.1
Having experience in PeopleSoft 9.2 Fluid User Interface Home Pages
Strong in Application Designer, Application Engine, Process Scheduler, PeopleCode, SQR, PS Query, Crystal reports, Component Interface, File Layout, Integration Broker, Data Mover and Security.
Strong experience in Batch processing, Upgrade, Migration, Data Conversion, Interfaces Development, Integration and Integration development (Component Interface, Integration Broker, AWE and Application Messaging).
Design and update HR processes after taking approval from business as per organization vision.
Implement web-based solutions for all HR modules e.g. Recruitment, Self Service, Payroll, Time Entry system to make HR system user friendly and allow user to access HR system from any location.
SCORE CARD
Skills Years of Experience
PeopleSoft HCM Technical 12+
PeopleSoft SQR, Application Engine 12+
Approval Workflow Engine 2+
PeopleTools 12+
EXPERIENCE
PeopleSoft HCM Consultant Feb 16 – Present
TD Ameritrade, Omaha, NE
Part of Upgrade Team to work on TDA custom changes, enhancements and TDA custom code retrofit from 9.1 to 9.2.
Performed unit testing for retrofitted objects and customized objects.
Worked on customizing the delivered Application Engine programs for e-Performance.
Worked on the Benefit interfaces to send the Benefit information to third party vendor.
Worked on Component Interface for hiring new persons in HR.
Addressed the IB issue between PeopleSoft HCM and CRM.
Performed and /or facilitate Code Reviews of all objects and ensure compliance with coding standards.
PeopleSoft Skills
PeopleSoft HCM
Core HR
ePerformance
Base Benefits
Open Enrollment
ESS & MSS
eRecruit
NA Payroll
Compensation
Time & Labor
Security
Fluid Pages
Technical Skills
PeopleTools
PeopleCode
SQL
UNIX Shell Scripts
SQL Scripts
Crystal Reports
XML
SQR
Application
Engine
Component
Interface
File Layout
Integration Broker
AWE
Excel to CI
Application
Package
Education
MCA -Masters in
Computer
Applications
Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 2 of 8
Addressed issues on Fluid approval pages for Adhoc Salary Change, Promotion and Transfer pages.
Configured Approval Fluid for Adhoc Salary approval, Termination and Promotion.
Worked on e-Verify/I9 process to validate the employee data with USCIS portal.
Prepared technical design document to send Employee data from PeopleSoft to SailPoint
Created a AE process to send the associates information from PeopleSoft to SailPoint system.
Created new page to map the pages and CI to load the pages for Security Access Control Reporting.
Supported Web Service operations to check the Hire Employee data from HCM to CRM
Added custom code to avoid the delivered Emergency Contact issue and Classic page approval page.
As part of Upgrade, identified the Emergency contact Fluid tile page issues which is getting data from custom Emergency contact records.
Added a new home fluid tile page and also created custom tile page to added in ESS & MSS.
Modified and created navigation collection, Tile Wizard to add a custom and delivered pages through Fluid tile.
Created Tile Wizard to get more than one page access on the Fluid Tile menu.
Modified custom Cobra PayFlex process based on business requirements like stop terminated employees, populate the correct event code, exclude non-US populations, proper translate value for Spouse.
Created a script to clean up pending Term approvals hierarchy tables.
Worked on Scottrade conversion. Scottrade company has been taken over by TDA. We converted employees to PeopleSoft.
Created Person, Job, Benefits and Tax component interface to load the SCT data to load to PeopleSoft.
Modified the existing New Hire Email process to fetch the SCT populations.
Modified the views (Remedy, Sharepoint, Sailpoint) which sends data from PeopleSoft to other applications to incorporate SCT employees.
Created new interfaces Job and Employee files to send data from PeopleSoft to Salary.com vendor.
Environment: PeopleSoft HCM 9.2 (Core HR, ESS, MSS, Payroll for NA, Benefits, Recruiting, PeopleTools 8.55, PeopleCode, Application Engine, File Layout, Component Interface, Integration Broker, Application Package, AWE, Data Mover, Unix scripts, SQR process and SQR reports). Senior PeopleSoft HCM Techno Functional Consultant Feb 15 – Feb 16 ROSS Stores Inc., Dublin, CA
As a Senior PeopleSoft HCM Developer, led a Taleo Implementation project which allows the business to recruit the employees in PeopleSoft.
Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 3 of 8
Created a Rehire eligibility Application Engine and File Layout process based on the Rehire file from Taleo.
Created foundation (Organization, Location, Requisition, and Department) data process from PeopleSoft to Taleo.
Created a New Hire/Update Application Engine, CI and File Layout process based on the input file from Taleo.
Created Decryption and Encryption process to decrypt and encrypt the files which received from Taleo and sending the files to Taleo.
Created Employee ID Sync process which sends the Employee Id details back to Taleo and created Term process which sends the terminated employee’s data to Taleo.
Worked on File layout which imports data from CSV file into custom records.
Worked on Integration Broker to send the employee info to the Vendor during the Hire process for New Badge creation.
Interacted directly with users to gather the Requirements and created the Functional and Technical documents.
Lead the Sick Leave enablement project which gives Sick and Vacation plan for Part time associates for specific locations.
Modified the custom SQR processes (On-cycle and Off-cycle) which inserts data to Pay earnings and Pay other earnings table.
Modified the custom Benefit and Leave Plan SQR processes to include the Part time associates to enroll on leave plan/benefits.
Modified the custom Print and Advice Check report to display the Sick Leave balances and modified the online page to show the leave eligibility date and leave balances.
Working as an Onsite and Offshore coordinator and providing requirements to Offshore and guiding them for Technical and Functional flow of the projects.
Ensure accurate and reliable effort estimates that dovetail with the overall Project Plan.
Work with IT team to validate the Solution Design and approach.
Coordinate with IT Team for Testing and Acceptance processing of deliverables.
Worked closely with the functional and business users for analyzing the change request and to provide the technical solution in the technical specification.
Lead the Development Team and clarify any issues that may arise during the development process.
Perform and /or facilitate Code Reviews of all objects and ensure compliance with coding standards.
Ensure generation of Unit Test Cases and monitor Test Results and make any required code corrections.
Ensure generation of End to End Test Cases and monitor Test Results and make any required code corrections.
Ensure generation of test cases for Integration and performance testing and ensure successful completion of the test phase.
Created new Permission lists and Roles for the Benefits Self Service module.
Used Data mover scripts to migrate the user data between different environments. Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 4 of 8
Transferred the Taleo inbound and outbound files through secured FTP server
Created CA Jobset to trigger the Jobs to process the files. Environment: PeopleSoft HRMS 8.0 (Core HR, Payroll for NA, Benefits, Recruiting, PeopleTools 8.42, PeopleCode, Application Engine, Integration Broker, File Layout, Unix scripts, Component Interface, SQR process and SQR reports).
Senior PeopleSoft HCM Consultant Feb 13 – Dec 14
PETCO Animal Supplies Inc., San Diego, CA
Designed, developed and implemented Recruiting system using Component interface to load employee’s Hire and demographic data from Taleo to PeopleSoft HR System.
Prepared detailed estimate for medium and complex PeopleSoft Object development.
Developed Application Engine to create Post Hire Data and General Deduction data.
Worked on project to automate daily Interface File loads, Developed Batch process via UC4 Scheduler.
Developed a system to pay employee using an automated system by using Pay card provided by Bank for different stores and corporate employees that should be loaded into the system.
Developed Application Engine to generate Direct Deposit Accounts for new hires.
Modified and created Pages and Components to setup different Security Roles to various kind of users on both PeopleSoft and Taleo System.
Configured and tested Emails using PeopleSoft 8.8 on different Pre and Post Hire Process.
Managing Infrastructure Systems Configuration and Administration.
Responsible for the PeopleSoft day to day integration Touch Point functions & operations.
Created Technical specification for all the New Hire and Post Hire Functional documents.
Created Unit test case, E2E test case and integration test case documents with different scenarios with screen shots and database level data.
Supported PeopleSoft North America Payroll Production Support for PETCO.
Coordinated with project team of Business Analyst, Technical developers (onsite and offshore), testers and project manager.
Worked on data formatting and conversion process.
Developed My Time Management Integration with 3rd party Day force System and PeopleSoft HR for Employee Information.
Worked on Bolton module OPA (Online Personal Action) for Manager Self-Service for various Employee Transfer and Job Change (salary change, promotion, etc.)
Process Changes (Ex. New Hire Process) developed interface for I9 and Tax forms Vendor like CIC and LexisNexis.
Created Approval Workflow Engine with two levels of approval to approve the employee’s request like Employee Transfer, Promotion, Report Change, Compensation Change etc. Created this to avoid the manual tasks for HR approval.
Integrated the PeopleSoft HR users with PeopleSoft finance system to provide the levels of manager hierarchy to approve the Purchase order and Payable amounts. Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 5 of 8
Environment: PeopleSoft HRMS 9.1 (Core HR, Payroll for NA, Benefits, Recruiting, Manager Self-Service, PeopleTools 8.48, PeopleCode, Application Engine, File Layout, Component Interface, Integration Broker, Unix Scripts, SQR process and SQR reports).
Senior PeopleSoft HCM Consultant Jul 11 – Jan 13
Sears Holdings Corporation, Chicago
To upgrade and enhance PeopleSoft application to support future growth and to enhance, standardize, streamline and automate the operations and administration of Human Capital Management activities.
Compared and modified the existing delivered 8.8 version SQRs with 9.1 and updated based on the latest changes
Compared and modified the existing custom SQRs and upgraded with latest version changes
Active involvement in collecting Business requirements, Preparing Estimations and Project plans.
Carried out Analysis, Specification preparation, page design, Interfaces, Reports, Data migrations, Coding and Testing of Application Engine. Importing data into PeopleSoft systems from Flat files using File Layout, Application Engine and Component Interface.
Worked on creating lot of PS query to generate reports to users to get the list of users that are enrolled during the open enrollment. Also created PS queries to generate reports for Payroll department.
Loaded the external system applicants in to PeopleSoft e-recruit tables using file layout.
Modified the Applicant page with client specific customizations.
Customer had lot of custom SQRs and lot of customization in PeopleCode, pages, records, Components etc., Upgraded the all custom changes module by module like Core HR, Benefits, and Payroll.
Compared the existing interfaces and updated the fields, records based on the latest PeopleSoft version changes.
Worked in Performance Tuning of the SQRs, and Queries coordinating with Oracle DBA.
Developed Data Mover scripts for importing and exporting data.
Worked with PeopleSoft security team to resolve user access related issues. Environment: PeopleSoft HRMS 9.0 (Base Benefits, Ben Admin, eRecruit, Payroll for NA, People Tools 8.49, SQRs, TOAD, Windows NT, PeopleCode, Application Engine, UNIX shell script, Component Interface, File layout.
PeopleSoft HRMS Consultant Jun 08 – May 11
New York Stock Exchange, NY
NYSE HRMS Implementation, Implemented six countries data (PRT, NLD, FRA, BEL, USA, UK) into a single system. Client facing role for complete PeopleSoft project Implementation for various HRMS modules at Onsite.
Active involvement in collecting Business requirements, Preparing Estimations and Project plans.
Active involvement in Functional & Technical analysis of the client business processes.
System study from Existing Total Cash planning system, Employee Self Service & Manager Self Service and implementing for five countries.
Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 6 of 8
Estimations for Design of Pages and reports.
Developed SQR to create Benefit Audit Report for Health and life .This Program creates a bunch of Benefit Audit Reports giving the details Plan Level / Dependent / Beneficiary of the Limited Brands.
Developed SQR to generate ‘Enroll in Benefits’ events into BAS Activity table for new hires (event date set to two month waiting period benefits effective date; thereby presenting new hires with benefit plans and rates in effect as of benefit enrollment date rather than as of hire date).
Knowledge sharing with the team about NYSE Implementation case study done at onsite. Assisted the team members in the design of the system at offshore.
Carrying out Analysis, Specification preparation, page design, Interfaces, Reports, Data migrations, Coding and Testing of Application Engine. Importing data into PeopleSoft systems from Flat files using File Layout, Application Engine and Component Interface.
Preparing the Unit test cases.
Created custom page and process to handle the Total Cash plan module to provide the yearly Bonus to eligible employees.
Worked on e-performance module to handle the employees’ performance.
Created a custom process to handle the e-performance appraisal approval hierarchy.
Worked on the Roll up Hierarchy to load the organizational Roll up Hierarchy in to a Flat table. This process is Application Engine which runs on a Daily basis to update the Supervisor information and their Hierarchy.
Administering Open Enrollment and Event Maintenance. Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans. Developed complex SQR program that creates multiple reports dynamically based on various parameters.
Set up the different Benefit Plans and Benefit Programs.
Set up the different Calculation Rate codes under Rates and Calucation Rules.
Worked in Open Enrollments in Ben Admin.
Setup the deduction codes for Health & medical plans.
Actively involved in Auditing HR Information such as Wrong Department alignment, Grade, Job code, Business title mismatch with Position, Job and Compensation etc.,
Modified the e-performance XML report objective template. Environment: PeopleSoft HRMS 9 (Code HR, Payroll for NA, Benefits, e-Performance, ESS, MSS, Open enrollment, Integration Broker, PeopleTools 8.49, PeopleCode, Application Engine, Component Interface, SQR process, SQR reports and PeopleSoft Taleo Integration). PeopleSoft Technical Consultant May 04 – May 08
AXA Australia, Melbourne, Australia
Active involvement in Functional & Technical analysis of the client business processes.
System study from Mainframe and designed all screens, Reports and Record structures templates and prepared technical design document for FITS Payment systems.
Estimations for Design of Pages and reports in FITS PeopleSoft Suspense Account Management, Payments & Receipts, UPS (AXA Unit Pricing Systems), Cash History and Bank Reconciliation. Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 7 of 8
Knowledge sharing with the team about all systems study done at onsite. Assisted the team members in the design of the AXA applications at offshore.
Carrying out Analysis, Specification preparation, page design, Interfaces, Reports, Data migrations, Coding and Testing of Application Engine. Importing data into PeopleSoft systems from Flat files using File Layout and App. Engine.
Development of Reports related to FITS PeopleSoft Suspense Account Management, Payments & Receipts, UPS (AXA Unit Pricing Systems), AXA Cash History, AXA Bank Reconciliation (SQRs, Crystals, PS-Queries) and Online PeopleBook help.
Preparing estimation for all Concepts & Projects and assigning work to team members.
Allocation the Activity Tracking Code to Team members.
Preparing the Unit test cases.
Environment: PeopleSoft Finance 8.8 PeopleTools 8.45, Oracle 9i, Payments, Receipts, Unit Pricing System, Cash history, Bank Reconciliation applications. PeopleSoft HRMS Technical Consultant Aug 03 – May 04 Sears Holdings Corporation, Chicago
Designing Technical design documents based on functional design documents.
Coding fresh SQR to be inducted into the Product as a part of the HRMS 8.8 Customization.
Induction of changes in the existing customized Customer added SQR’s and reapplying customizations in the PeopleSoft Delivered Customer Modified SQR’s to Accommodate changes between PeopleSoft 7.5 and PeopleSoft 8.8 along with addition of code in suite 8.8 functional changes.
Development of new PS Queries based on design documents and Upgradation of PS Queries with the capability to cater to PeopleSoft 8.8.
Creation & Customization of Records, Fields, Pages through Application Designer.
Customization of Various customized Reports through SQR. Running Reports through Process Scheduler.
Import data from Text files through File Layout and validate all values through CI and stores data to database using Application Engine.
Basic Setup based on Company details like Company information, Location, Department, Job Code, SetId, Business Unit, Permission List and Security etc.
Developed App Engine to update various employee data tables.
Designed and developed customized component, pages and changed PeopleCode as per user requirements.
Created Application Engine programs using PeopleSoft File Layout, imported data from external files (.csv, .xml) to PeopleSoft Tables.
Environment: PeopleSoft HRMS 8.8, Employee Self Service, Workforce Administrator, Workforce Development, Setup HRMS, Tree Manager, PeopleTools, Security, SQR, PeopleCode, SQL, Oracle, Windows, PS/Query, Application Engine, Component Interface, Query Manager, Toad. Vijayalakshmi Ramanathan
PeopleSoft HCM Consultant
Email: *********@*****.***
Mobile: 925-***-****
Page 8 of 8
VB Developer Apr 99 – Apr 03
Inventory Management System, Information Management System
Form Designing like Supplier, customer, Vehicle and Dispatch Details etc.,
Database Designing, Coding and Testing.
Report designing.
Users and Security measures.
Environment: SQL Server 7.0/Visual Basic 6.0, Crystal Report
Contact this candidate