Professional Summary:
More than Twelve years of experience in the field of IT.
More than Twelve Years of Experience in Peoplesoft (V 7.0, 7.5, 7.6, 8.0, 8.3, 8.3, 8.8, 8.9, 9.0) as a Technical Consultant.
Consulting experience in Peoplesoft HRMS with Five Full Life Cycles in HR, Payroll, Ben Admin and Time & Labor and One full life Cycle experience in PS Financials (AR, AP and Billing) modules.
Involved in Production support for Peoplesoft HRMS and financial modules.
Three years of experience in Peoplesoft 8 in HRMS 7.0/7.5 to 8.0 upgrades.
Worked on Public Sector (State of CT and State of CA) and Private Sector (Utilities, Financial Institutions, HealthCare, and Education Services) implementations of Peoplesoft.
Worked with Major Consulting Firms like Deloitte, CBSI, PSG, Accenture and The Hunter Group.
Provided Peoplesoft Consulting for Fortune 500 companies (Bank Boston, Guardian Life & PPL) in HR and Financial Modules.
PeopleSoft Technical Skills:
PeopleSoft Applications:
HCM (8.3/8.8),Financials (7.5,8.3,8.8,8.9,9.0) PeopleSoft Modules: HRMS(Payroll, Benefits, Core HR, Time & Labor, Ben Admin ,e-Modules )
FM and SCM (GL, AP, PO, AR, INV, OM, CM, AM, EX, BI).
PeopleSoft Technical Skills: PeopleCode, PeopleTools (7.5x up to 8.8), Application Designer, Application Engine, Component Interface, PS Security , Integration Broker, PS/Query, SQR, Crystal Reports. RDBMS: Oracle 9i/8i/8.0/7.x, MS SQL Server, DB2, Sybase
Operating Systems: Unix, Windows XP/NT/2000/98/95, MVS
Hardware: Pentium based servers and workstations
Skill set Summary:
Skill Set:
PeopleSoft
PS HRMS (v8.8, v8.9)
PS Financials v7.5x/8.4/8.8
PeopleCode
PeopleTools
App Designer
SQR
PS Query
Crystal Report
Oracle
Component Interface
App Messaging
App Engine
Work Experience
PeopleSoft HCM (TL, HR, NA Payroll) Jan 08 – Sep 09
Confidential,Chicago Role: SME/Lead Technical Consultant Environment: PeopleSoft 9, PeopleTools 8.5, DB2, Novell Lead 12 member team in implementing Time and Labor module to integrate with HR & NA payroll for HSBC North America with more than 54000 employee population. Took on the role of SME for T&L guiding client through all the required tasks to implement and integrate the module with HR and payroll. Written Key technical specifications in integration like enrollment and history conversion design and develop crucial customizations to support existing HSBC functionality, developed complex custom and template rules to support employee compensation requirements, train & assist junior developers in application development, written extensive documentation to support HSBC technology department standards. Involved in production support for recently rolled out T&L product, assist staff in finding solutions to further stabilize the system and overall support of HRMS system. Involved in detailed fit-gap sessions with business users to identify possible delivered solutions and propose new custom functionality to support existing HSBC procedures in place Create visio documents explaining T&L functionality for existing FTE staff to bring them up to speed with the functionality. Worked with business users in understanding various task specific requirements to transform them into functional and technical specifications. Configured key T&L features like workgroups, schedules, time reporting programs, time reporting codes, dynamic groups etc. Setup test T&L system for demonstration purposes on how T&L works with sample data setup. This involves enrolling employees into T&L, enable Employee and Manager self service functionality for Time entry, actual time entry, processing time and loading time into payroll. Involved in creating and preparing several test systems by identifying all setup tables and writing extensive DMS scripts to move key setup data from one system to another. Identify key processes to run in several environments during test data creation. Written several detailed technical specifications for key T&L customizations for Offshore development Design & develop key customizations required in any implementations like One-time and on-going enrollment of EE into T&L, Automation of security for MSS and ESS, Data conversion of legacy time for prior period revisions, complex custom T&L rules, online enhancements related to MSS and custom schedule creation and maintenance Designed and developed conversion programs to convert legacy time data into T&L tables. Written data validation scripts, SQR programs for data cleanup, generate summary reports for data integrity Designed and developed key Time and Labor rules including PS delivered template rules and complex custom rules to handle state and provincial pay and holiday requirements. Designed and developed 48 rules half of which were complex custom rules. Involved in creating detailed UAT scripts for offshore for several key customizations. Involved in detailed planning and Lead System testing phase from initial enrollment of employees into T&L all the way through Payroll testing. Worked with several key functional users in identifying issues related in UAT, Parallax and Regression testing and work with technical team in fixing them. Involve in Go-Live phase to make sure that all customizations are properly migrated and all customizations work as expected. Involved in production support where issues identified are prioritized properly and resolved. PeopleSoft HCM (TL, HR, Payroll Interface) Aug 07 – Jan 08 Confidential,Chicago Role: Lead Sr Technical Consultant Environment: PeopleSoft 8.9, PeopleTools 8.47, Oracle, Novell Lead Seven member team in implementing Time and Labor conversion from CBOT to CME. Involved in writing conversion programs to convert CBOT employees into CME, identify CBOT TL rules and retrofit against existing CME rules and consolidate overall rules that currently run. Created several rules and user exits for CBOT conversion. Currently involved in writing test scripts for new modifications. Designed and developed custom Position Update Process in transitioning CBOT employee from a 37.5 standard hour schedule into 40 hour CME work week using a combination of Application Engine and Component Interface tools. Designed and developed custom conversion process to convert EE into TL and convert CBOT employee benefit balances into CME using AE and CI tools. Process Generates various reports for user preview checks in report mode and the final runs enrolls employees into TL. Developed custom process that creates permission lists for CBOT supervisor and managers for time reporting and approvals. Developed an ad-hoc tool to setup any CBOT user to manage employee’s time reporting by updating user security, create dynamic groups on the fly and update TL security. Developed various custom and template based rules for Union employees based on their union contracts. Consolidated and retrofitted several rules that currently run for CBOT into CME. Written several time entry, custom process test scripts to handle special scenarios for CBOT employees. Involved in setup of custom rule programs, time reporting codes and TRC programs for CBOT conversion. Troubleshoot Time Administration process for existing CME employee population and fix various day to day issues. Peoplesoft HCM (TL, HR, Base Benefits, Ben Admin, Payroll) Jun 06 – July 07 Confidential, (Formerly Blue Cross Blue Shield of Illinois) Role: Sr Technical Consultant Environment: PeopleSoft 8.8, PeopleTools 8.45, DB2, Novell. Part of Eight member conversion team to convert newly acquired Blue Cross Blue Shield of Oklahoma employees into HR and TL. Responsible in converting EE in Oklahoma into TL from HR, add additional functionality and also write several TL rules and User Exits. Modified originally written custom Process to Mass Enroll Employees from HR into Time & Labor. This piece involves modifications to online pages, Peoplecode and App Engine program based on Component Interface. The original version was developed by me and was responsible to modify the program based on new requirements. Created Several new TL rules to handle new requirement that came up during the Oklahoma merger. Modified existing custom functionality that disables No Direct Deposit flags for Off Cycles during Pay Calculation process for entries created by TL load process. New process involved modifying Payroll earnings at the time of TL load to allow users to enter pay lines after TL load based on TL lines and before Pay Calculation process. Modified existing custom Auto Enrollment report that identifies any job changes resulting in TL Changes. The modification involved using complex arrays to capture JOB and TL information and display the results. People soft HCM (TL, HR, Base Benefits, Ben Admin, Payroll, Position Management, eRecruit, Self Service) Feb 06 – June 06 Confidential,Hoffman Estates, IL Role: Senior Systems Analyst Environment: PeopleSoft 8.8, PeopleTools 8.44, SQL Server, Windows 2000 Part of six member technical team supporting all modules of HR. Went live with HR in May 2005.Involved in redesigning several key processes, implement customizations in all modules based on requirements in centralized issues database. Support and troubleshoot issues in existing modules and responsible for on call technical support based on a set schedule. Involved in re-design and development of existing TL processes that run hourly. Existing program is heavily hard coded, repetitive and utilizes database inserts without validating online business rules and dependencies. Consolidated three TL programs into one program using App Engine, hard coding has been replaced with setup pages and database level manipulations have been replaced with Component Interfaces. This program is designed and written to be flexible so that it could be used for future conversions of business units into HR. Customized certain pages in eRecruit (Job Posting, Applicant qualification review) to accommodate CEC specific requirements. Customized several pages in Manager Self service and Employee Self service modules to add additional custom functionality. Developed new customizations using PeopleTools, Peoplecode and SQR based on requirements in issue log. Developed several pages, components and incorporating several custom business rules using Peoplecode and other peopletools. Work with business analysts during functional testing of new customizations, fix existing modifications, and provide ad-hoc SQL statements. Incorporate new customizations and fix existing issues with T&L conversion program. Went live with last phase of 6000 employees on May 1. Employees in all business units/schools are currently live in T&L Peoplesoft HCM (TL, HR, Base Benefits, Ben Admin, Payroll, ESS, MSS) Feb 05 – Jan 06 Confidential, (Formerly Blue Cross Blue Shield of Illinois) Role: Technical Consultant (Sr Implementation consultant) Environment: PeopleSoft 8.8, PeopleTools 8.45, DB2, Novell. This is an implementation of People soft T&L product. Part of the team to identify business process needs and identify technical solutions. Responsible for converting employees to Time & Labor, setup TL and online security, major customizations to Portal and web for Employee and Manager Self service, Payroll and Leave accrual modifications to fit Time and Labor. Created multiple audit and control reports using SQR for phased rollout of employees by company. Involved in Production support. Involved in designing detailed technical design specifications based on functional documents and users input for programmers to develop/customize applications Designed and Developed Application Engine Using Component Interface for mass loading of employees from JOB into TL on a company wide phased rollout. Implemented TL Data and Component Security (Users, Roles, Permission List, and Dynamic Groups) using Component Interface and App Engine. Automated Dynamic Group creation process using App Engine/Component Interface to automate thousands of Group creation entries in the system. Designed and developed a custom application that auto enrolls employees into TL during job data hires and transfers. Worked in Initial design of technical specifications for Employee Self Service and Manager Self Service modules. Responsible in developing customizations based on initial technical specfications. Customized several delivered applications using PeopleTools. Customizations included changes to delivered Pages, Adding/modifying PeopleCode to meet business requirements. Designed and developed applications that send emails to module administrators. Done using workflow and App Engine. Developed several SQR reports for HR and Payroll modules for reporting and also for control totals for conversion application engine programs. Extensively Worked with PS/Query and Query Manager Tools to Construct Queries for day-to-day utilities for end user and also on ad-hoc basis. Developed/Modified Custom Pages, Added complex PeopleCode logic as per Client requirements to auto enroll new hires/existing job transfers. Enhanced several other PeopleCode modifications to process complex Business rules. Worked on several payroll modifications using PeopleCode and PeopleTools. Involved in implementing change requests that came up during testing phase. Involved in Production support Peoplesoft (HR, Base Benefits, Ben Admin, Payroll, T&L) Aug 04 – Jan 05 Confidential,Ventura, CA Role: Technical Consultant (Production Support, Enhancements) Environment: PeopleSoft 8.8, PeopleTools 8.43, Oracle 8.0, Windows NT. County Of Ventura went live in May 2004. Part of Production Support team and involved in enhancements to custom retirement application, writing SQR reports and support day to day production issues. Heavily involved in modifying custom retirement application to provide extra features and added functionality using PeopleCode, Peopletools and App Engine. Involved in modifying custom SQR reports to add more functionality and features to the reports. Involved in day-to-day trouble shooting of the system and overall system maintenance. Peoplesoft (HR, Base Benefits, Ben Admin, Payroll, T&L, Posn Mgt, PC, GL) Feb 03 – July 04 Confidential,Stockton, CA Role: Technical Consultant (Conversion from Unisys to Peoplesoft) Environment: PeopleSoft 8.3/8.4, PeopleTools 8.18/8.41, Oracle 8.0, Windows NT. This project is a brand new implementation of PS 8 converting from legacy Unisys system. The County has implemented almost all modules in PS financials with several modules in HR with interfacing to financial modules. My role in this project is to write and implement Technical design documents based on identified gaps in all modules being implemented, Develop conversion programs to map legacy to peoplesoft, write crucial Inbound and Outbound interfaces, setup online user security, Trouble Shooting Issues and overall system support. Involved in designing detailed technical documents based on functional documents and users input for programmers to develop/customize applications. Designed and developed crucial inbound and outbound Interfaces for Kronos (External Time Keeping System), Benefits, Payroll, Time & Labor and HR using Application Engine. Written control and validation reports in SQR to support interfaces. Developed conversion programs to convert the data from the legacy system to HR, Benefits and Payroll tables Used Application Engine/Component Interface, SQR to load data into Benefits tables and Payroll Tables. Developed custom online rules in Time Admin Process that generate extra payroll codes and generate online exceptions for benefits. These rules run for the entire employee population and generate payable time and exceptions online. Developed Crucial processes using App Engine for Position Management using App Engine that affect positions when job code is updated and all employees in job codes. These processes are scheduled to run on periodic intervals. Developed several custom applications for T&L as per county MOU. Re-Designed Peoplesoft Mass Time Approval process (App Engine) to run in batch mode independently. Involved in fine-tuning several key processes in T&L like Time Admin and Mass Time. Involved in setting up of online security for Peoplesoft online users. Created custom permission lists to define page permissions, data and process access, define roles for countywide employees. Developed custom Auto Step Increase process using App Engine that grants auto step for employees based on qualifying hours setup for employee’s salary admin plan, grade and step. Generates control reports for HR to review and correct qualifying employees. Involved in setting up and running Key App Messages to integrate HR to Financials utilizing Batch and Full Table Publish Rules. Written custom programs for GL, PC and Budgets for county. Modified Benefits related page to add county specific identifiers. County for crucial interfaces and reporting purposes uses special identifiers. Designed and developed several custom processes and reports for county specific requirements. Involved in trouble-shooting and testing the system and also involved in post-production enhancements. Converted terminated employees from Unisys to Peoplesoft and working on Year End issues. Involved in Production support, postproduction enhancements, writing “Nice to have” reports using SQR and overall system maintenance. Peoplesoft (HR, Base Benefits, T&L, Upgrade from PS 7.5 to 8) Jan 02 – Jan 03 Confidential,Sacramento, CA Role: Technical Consultant (Upgrade to V8 /Enhancements in V8, 7.5 Payroll) Environment: PeopleSoft 8/8.3, PeopleTools 8.13/8.15/8.17, Oracle 8.0, Windows NT. This project is an upgrade from PS 7.5 to 8.0 and at the same time enhancements/customizations were done to HR, T&L and Base Benefits product. Many SQR programs in PS 7.5 were converted to App Engine programs in PS 8. Customizations were made to self-service options. Existing SQR reports were modified and extra reports were added to utilize new functionality. My role in this project involves writing major interfaces to and from CALTRANS to external system called California Leave Accounting System (CLAS), building applications that were not provided with PeopleSoft and workflow. Developed App Engine programs that utilize component interface and workflow to systematically invoke emails to all the employees in a certain district being rolled out for go-live. Appropriate provisions are provided in business process to send emails to certain roles in case of email failure. Using workflow and component interface a process is automated that sends email to the security administrator to notify of new hires and also create basic information for the new hire with a predefined User ID and password. Security admin then checks the log in and sends email to employee to confirm the information. Developed crucial interfaces to and from CALTRANS and CLAS(California Leave Accounting System) using App Engine programs to maintain leave accrual balances. Incorporated a custom business rules using people code that enrolls employees into Leave accruals based on their benefit program during the hire process. Built a custom application that will allow supervisors to approve time for another supervisor’s employees. Delivered application allows only one alternative supervisor. Custom application allows more than one alternate supervisor. Developed a process using App Engine that will archive leave accrual data for all the employees leaving just the latest accrual date. Built a custom page that will show archived leave entries for employee based upon the search criteria. Written SQR programs in T&L for reporting and reconciliation purposes as and when districts are rolled out for Go-Live. Developed App Engine programs for Fiscal and Calendar year-end processing. Worked on Production support Issues People Soft (HR, Ben Admin, T&L, Upgrade from PS 7 to 8) Jan 01 – Dec 01 Confidential,Allentown, PA Role: Technical Consultant (Upgrade to V8 /Post Implementation Enhancements in V8) Environment: PeopleSoft 8, PeopleTools 8.13, Oracle 8.0, Windows 95. The main emphasis of this project is Upgrade from PeopleSoft 7 to 8 and at the same time implementing new web based enhancements to PS Time & Labor. My involvement as a part of the team is to perform various online modifications from scratch in Time & Labor in Version 8 through Web using PeopleCode and V8 PeopleTools. Involved in modifying several delivered SQR and SQC programs that were modified by PPL custom SQR programs developed by PPL as part of the upgrade process. Created Custom PPL application for Mass Time Reporting. PS T & L system allows the user to select a list of employees based on a specific T & L group and enter TRC/Quantity based on the option selected. Modified Custom self-service options for supervisors. This customization allows a supervisor to view/change the information of all the employees that report to another supervisor if he/she is assigned as an alternate supervisor Modified Weekly Elapsed Time Entry pages to BI Weekly Elapsed Time. Identified requirements needed to convert Custom built SQRs in V7 to V8. The SQR Programs were modified based on V8 changes. Worked extensively in Time & Labor self-service at both Manager and Employee level incorporating major enhancements to the delivered functionality by cloning the delivered feature of Peoplesoft and incorporating to all other areas that does that carry the feature using PS 8 PeopleTools and PeopleCode. Modified the Comp Time Enrollment Panel to incorporate cloning functionality. Involves modification to the delivered comp time enrollment panel and adding custom PeopleCode to populate extra comp time plans. Implemented a custom self Service feature in Time & Labor that will let the user logged into the web to see only the Employee(s) that directly report to him/her. In Self Service pages there is a link that allows the user to do a search on a specific employee. The Delivered PeopleSoft’s code implements Object/Class functionality that hampers the performance of retrieving the rows on the web. Modified the specific PeopleCode to tune the search in such a way to increase the performance of search retrieval drastically. Using PeopleCode/PeopleTools (Internal Links) implemented the feature to implement forward and backward navigation. Developed a stand alone application from scratch called Exception History Detail and Exception History Summary using PeopleTools and PeopleCode. This application is similar to Payable Time Detail and Summary but shows only exceptions reported. Modified Payable Time Detail and Summary pages Search record the start date will be set to the nearest date from the start date that has some Payable Time to show. Modified Online Approval Panel that involves modification to delivered Search record that prompts for Employee ID and Start Date. Developed App Engine Program from scratch that will pre-populate time for all the BI Weekly elapsed time exceptional employees so that the timekeepers can key in only the exceptions. Modified the delivered App Engine for the Rapid Update Page. The delivered App Engine runs the process synchronously. Designed and developed a page that will selectively delete rapid time batches from the system once they have been run through Time Admin Process. Designed and developed an application to maintain workgroups online. Workgroups are defined for a variety of parameters such as Department, Tax Location, and Company/Pay Group. Written custom peoplecode to populate a default Task Group and Task Profile Id’s when a new department is created online. These task groups will be defaulted on T&L page during hiring/rehiring of employees online. Customized existing Launch Pad. Currently the system loads all the employees in launch pad page based on their security. The customization will prompt department Id as search criteria and retrieve launch pad with employees belonging to only the specific department Id. Modified Weekly Elapsed Time Page’s Pages Search record to prompt for an End Date rather than Start Date (delivered) along with start date. Incorporated Online Edits for Rapid Time Reporting Page using PeopleCode. PPL utilizes about 200 SQR (modified/custom) programs that are up and running in HR Production environment in PS 7.Invloved in reviewing each and every SQR and modifying the program wherever necessary. Testing the SQR programs by running the programs through SQRW and process scheduler in the PS 8 environments PeopleSoft Financials, Distribution (AP, AR, BI and IA) Feb 00 – Jan 01 Confidential,Bethlehem, PA. Role: Technical Consultant / Functional Analyst Environment: PeopleSoft 7.5, Oracle 8.0, Windows NT The Main Emphasis of this Implementation is on PeopleSoft Insurance Administration (PS IA 7.5, 7.6). This module interfaces with AP, AR and Billing modules. My effort as a part of the financial implementation team is to setup and tune these modules so that all the interfaces with IA run properly and at the same time analyze the enhancements needed within the modules, write SQR’s to convert from legacy system to Peoplesoft, Prepare Functional and Technical Specs. Develop/test the enhancements and making sure that the enhancements are migrated properly to all the environments moving forward. Involved in Initial Design of Billing, AP and AR Modules. Performed an extensive study of the Legacy system for conversion purposes and designed the conversion methodology to be adopted for converting the existing legacy system data into PeopleSoft. Developed conversion programs using SQR to convert the data from the legacy system to PeopleSoft financials Followed PeopleSoft Express Methodology templates to analyze users requirements and prepare requirements documents for Fit-Gap analysis. Involved in preparing Fit-Gap and Scope documents for AP, AR and Billing Modules. Involved in setting up the modules based on the documents prepared coordinating with users. Developed Test Scripts and familiarize users with the Key Processes involved and walk them through the series of steps involved that complement Billing, AR and AP cycles. Developed Functional and Technical Specs for all the key modifications required. Involved in Partial Upgrade of PS IA 7.5 to PS IA 7.6 Worked on custom un-billed AR functionality. To handle this issue developed a custom application using PeopleCode in AR that allows the users to enter Payments for the policies that are unbilled. This application also involves writing interfaces using SQR’s from IA to AR to send Policy Information, creating cross-reference table in AR to hold the policy information, modifying Regular Deposit Entry panels and creating custom records to accommodate payment entries against the policies. Modified already delivered interface SQR’s to include these new features. Designed and developed custom panels in IA so that the users can edit the Information coming from the interface from AR for new policies. Designed, Developed and involved in testing the Key outbound Interfaces using SQR. Developed an application involving PeopleCode, custom Panels and using the delivered tables (Event Processor tables). This Custom application helps the operator running the batch cycle view, schedule and executes certain key processes. Worked on production Error Resolutions. PeopleSoft HRMS (HR, Base Benefits) July 99 – Dec 99 Confidential,), Hartford, CT Role: Technical Consultant Environment: PeopleSoft 7.5, MS SQL Server 6.5, Windows NT This Project was PeopleSoft Time & Labor (Public Sector V7.5) implementation .I was a part of 8-member implementation team from Complete Business Solutions Inc (CBSI). Involved in Design (writing Functional and Technical Specs), Develop and Test the enhancements needed to suit CGA’s business requirements. Designed, developed and involved in testing custom application, which keeps track of employee’s years and hours of service (Longevity). This application involves creating new records, panels and writing PeopleCode to support the application. It also involves writing custom SQR’s one of which is run as a part of every Pay Cycle and another is run twice a year, which calculates Bonus for the Employees. Designed and developed custom application that calculates employee’s leave balances. As CGA is not implementing PeopleSoft payroll module, a process needs to be developed which updates employee leave balances on a regular basis .The custom process takes the leave hours taken in the Time & Labor and updates the leave accruals in HR. This process is run as a part of pay cycle. Designed and developed custom application, which clears employees compensatory leave hours, buckets on a regular basis. Every Employee in CGA earns compensatory time based on the number of hours worked. The process clears the compensatory leaves hours earned for all the employees enrolled in a plan when a certain compensatory plan expires. Involved in writing critical reports required for parallel testing such as Overtime/Compensatory Analysis reports, Longevity payment and status reports. PeopleSoft HRMS/Financials (Project Costing, HR, Benefits and T&L) Nov\'98– June’99 Client: Confidential,DC Role: Technical Consultant Environment: PeopleSoft 7.5, MS SQL Server 6.5, Windows NT The main emphasis of this Project was on Time & Labor implementation and my duties as a part of the team is to interface Time and Labor (V7.5) with other HR modules and PS Financials (Project Costing). Implemented PS Time & Labor, Base Benefits (V7.5) and PS financial modules. My responsibility as a part of the technical team is to co-ordinate the HR modules that involve developing some key processes. These custom processes replace standard functionality provided by PS Benefits Administration and PS Payroll. Developed a process to create interface between Benefits and Time &Labor, which compares employee\'s leaves recorded in Time & Labor against the allowed leaves. This Process is used as an alternative to the Existing Payroll feature, which calculates the leave accruals. Used Tree Manager to implement query security for the custom records and views Created for custom applications. Created interface between Time & Labor and ADP that reports employees who have exceptional time reporting codes. Modified Peoplesoft delivered Mass Change for Time & Labor – Project Costing Interface to suit the needs of existing ChartFields. Involved in Writing SQR’s from scratch and modify the existing reports in Time & Labor for Benefits and Time & Labor such as Combination Edit, Annual Earnings, Payroll type Summary, Rolling 12 months annual Productive and Non Productive Earnings and Employee Profile Report. Involved in populating T&L and Benefits tables using custom SQR’s through SQRW. Client: Confidential,MA June’97– Oct‘98
Role: Technical Consultant Environment: PeopleSoft HRMS (7.0), DB2, Windows 95 Involved in writing key reports in PS Payroll using SQR’s, some from scratch and modified already written SQR’s during parallel testing. Modified Panels and PeopleCode as a part of fixing the errors occurred during parallel testing. Involved in writing custom SQR’s from scratch such as Separation Pay, Employee State Tax Audit, Offline, Online and Manual Check Reports and Modifying existing reports. Involved in Writing PeopleCode for Personal and Job Data Panels Such as generating New Employee Id, making SSN a required field, calculating service Years, Service Months, Service Days, when an Employee is Terminated. Modified Several Existing Panels and doing various customizations such as adding new translate values for ACTION in Job Data panel, Hiding and Graying out the fields in Benefit Program Participation Panel. Added Several New Panels Such as online-inquiry transaction that displays detailed information regarding applicant’s history of positions applied at BankBoston and created Functional Library. Written a process that terminates benefits and prints a report, which contains benefits details upon employee’s termination. This process is designed and developed to be a part of payroll Cycle Created a report that will audit the current active employee population and find anyone that should be assigned a leave plan, either sick or vacation. This will allow HR to enroll the employee into the correct plan.
Education: Bachelors in Computer Science Engineering
Privacy Policy
