SUMMARY:

• Over 23 years’ experience in design, development, implementation, and upgrade of business systems.
• Functioned as a Senior HRMS PeopleSoft Consultant for 17 years where his experience and knowledge extends from Version 7.0 thru 9.2
• Expertise in various facets of software development life cycle: design, development and implementation of ERP systems (PeopleSoft) and client server applications on Windows and UNIX platforms. Integration between HCM & FSCM and between People soft and third party vendors.
• SME in integration between PEOPLESOFT TIME AND LABOR and KRONOS
• Production support and coordinating and managing between on site and off - shore resources.
• Expertise in SQR programming, Application Engine Programming, People Soft Query Tool, People Code, Application Designer, Process Scheduler, Data Mover, Component Interface, Excel To Component Interface, Tree Manager, XML Publisher, Integration Broker, Application Package, People soft Security.
• Expertise in Designing and implementing test plans, execution of test cases to verify application functionality against business requirements, with manual testing and automated test tools.
• Excellent analytical, problem solving, communicational and interpersonal skills to interact with individuals at all levels.
• Expertise in system analysis, fit gap analysis, and identifying discrepancies.
• Expertise in creating functional / technical documents based on the business needs for SQR reports and PeopleSoft Query Reports.
• Expertise in conducting Joint Application Development (JAD), to enable the users to be part of the development process.
• Make recommendations/modifications based on the existing functionality.
• SME in People soft Upgrade process, Core HR, Person Model and Benefits including Benefits Administration, North America Payroll, Time and Labor, Enterprise Portal, Integration with KRONOS devices

TECHNICAL SKILLS:

Business Applications: PeopleSoft HRMS (Payroll, HR, Person Model, Base Benefits, and Benefits Administration, Time and Labor, KRONOS time collection devices) v7.0, 7.5, 8.3, 8.90, 9.0, 9.2 PeopleSoft FSCM 9.20, People soft enterprise Portal

Related Tools: People Tools (Application Designer, Application Engine, PS Query, Data Mover, Tree Manager, Component Interface, Process Scheduler, People Code, XML Publisher, Integration Broker, Excel To CI, Application Package), Developer 2000 and other Oracle Tools

Databases: Oracle8.x, Oracle.9.x, Oracle 10G, Oracle 11G, SQL Server, and MS Access

Programming Languages and Scripts: People Code, SQR, JAVA, HTML, COBOL, PL/SQL, C, VB, C++, Shell Scripting, Perl Scripting

Operating Systems: Windows 98, Windows NT, Windows 2000, Windows XP and UNIX, Linux.

Hardware: HP-9000, SUN Sparc, IBM RS6000, DEC Alpha, and PC Workstations Job

Scheduling Tools: Auto Sys from Platinum Corporation, Control-M from BMC Software, PeopleSoft delivered Process Scheduler.

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

Responsibilities:

• Gross wage report for payroll
• Payroll to GL Master batch control report
• Implementation of KRONOS time clocks for clerical non-exempt employees (In Progress)
• Payroll>GL automation

Confidential

Technical Lead

Responsibilities:

• Configuration/Setup of information on people soft including but not limited to integration broker settings for employee data, supervisor data, schedule information etc.
• Configuration setup of time reporter data for punch employees
• Configuration of new device groups/devices on the kronos application server (Synapps)
• Configuration of new devices including but not limited to IP of the device, defining gateway, device ID and other properties that are device specific

Confidential

Technical Lead

Responsibilities:

• Compilation of technical inventory for interfaces (inbound and outbound)
• Compilation of technical document for other RICE components like Reports, Customizations, and Enhancements. These items were then discussed with the business users to discuss about the customizations that need to be carried forward and those customizations that need to be dropped
• Verification of compare reports to identify the customizations across the application. It was discussed to retrofit all the customizations
• Retrofitting of customizations for HR, PAYROLL, BENEFITS, TIME AND LABOR, LEAVE MANAGEMENT SYSTEM, and through unit testing
• Responsible for unit testing of KRONOS devices
• Responsible for unit testing of messaging between HCM and FINANCIAL application
• Responsible for unit testing of interfaces including internal interfaces, interfacing with external vendors like BANKS, INSURANCE CARRIERS etc.
• Responsible for all pre-cutover and post-upgrade activities
• Custom payable time notification process - This is a custom process that send notification to supervisors to approve the payable time of their direct reports. The notification contains the details of the direct reports with a link to the payable time approval component
• Custom time and labor enrollment process - This is trilogy of processes that has been created to automatically enroll the new hires as Time and Labor employee (Setup time reporter data for the employee) and also enroll them in applicable compensatory plans and general deductions (for the general deduction enrollment there is wait period)
• Safety awards bolt on - A custom functionality that is used on an annual basis to identify bus operators who are eligible for 5/10/15/20 year safe driver awards. Selection of employees is based on rules which is implemented during a custom setup and set of processes
• Operator’s salary step increase functionality - This is a custom functionality that has a configuration which is created based on bargaining unit rules and set of processes. This functionality is often used to determine which operators is eligible for a step increase. Once operators are identified a custom process is run that creates the appropriate step increase record in JOB
• Custom anniversary salary increase process - Based on the bargaining unit agreement, all active employees are eligible for a salary increase on their anniversary date (Date they started with Confidential ). Designed/created set of objects to enable this functionality
• Custom interface for enterprise data warehouse - Data available in EDW is used by various applications that are native to Confidential . Designed and implemented an interface, which has various kinds of employee data like demographic, payroll, benefits etc.
• Custom interface to CSOD (Cornerstone on demand vendor)
• Custom leave accrual process
• Custom process to load employee time reporter data, employee work schedules (Using file attachment and component interface)
• Implementation of tax updates
• Custom process to send reminder notification to employees to submit their time
• Custom process to lock HCM accounts for terminated/retired employees
• Custom process to synchronize the passwords between HCM and PORTAL
• Maintenance of enterprise portal by way of adding new company announcements and new employee self-service items
• Responsible for troubleshooting integration between HCM and FIN and between HCM and KRONOS devices

Confidential, Dublin, CA

Responsibilities:

• Custom configurations for defining the sub-pay groups, notification attributes, leave types, payroll configuration and an event configuration
• Designed and developed an application engine process to create snap shot data of employees for a particular event and leave types
• Worked on changing the payroll and supervisor dash boards
• Worked on workflow for approvals of the employee adjustment requests.
• Creation of custom configuration pages related to generation of Form ADV Part 2 - B
• Creation of custom data entry page for adding information related to Item 3, Item 4, Item 5 of Form ADV Part 2B
• Creation of dashboard for administrating the Form ADV Part 2 B. The following features can be administered for the dashboard
• Configuration items related to Form ADV Part 2 B
• Administering triggers created as a result of material changes to a Portfolio Managers
• Generating adhoc data feed for creation of Form ADV Part 2B documents, using an application engine process with file layout
• Mass Change feature to replace/add/.remove Portfolio Managers from several accounts at one shot) using application engine process calling a Component Interface
• Data Load
• Creation of process to capture the material changes of Portfolio Manager and to generate the data for a Portfolio Manager on an adhoc basis.
• RBAM (Risk Based Attrition Management) project using agile methodology
• Development of process to load employee override performance indicators using application engine and CI
• Development of process to load the default performance indicators for the job codes using application engine and CI
• Development of custom pages to display the EE performance indicators and job code defaults
• Development of daily custom process for sending 5 day, 15 day, 30 day employment end date reminder notifications and termination of temporary employees using application engine
• Development of a weekly custom process to report on the employee job title, business title changes using application engine
• Development of custom process to calculate the employee health cost (annual) and generate a report using an application engine
• Implementation of a new plan type (plan type 2H) involving people code changes to the online benefits enrollment form, employee benefits data entry page
• Changes to the process to display the portal content based on the work location of the employee logging into portal
• Changes to offline IPP (Individual performance plan featured on the HR portal) to provide the capability to download the IPP word document templates based on the job organization role of the employee. Providing capability to the supervisor can download the IPP word document templates of his/her direct reports.
• Implementation and support of PeopleSoft Treasury Module (FSCM application version 8.9 and tools version 8.49X)
• Developed an application engine program to load data from a flat file to People Soft tables (Equity Tables, and Risk Measurement Tables). The data consists of the prices of the equities held by Confidential )
• Developed an application engine program to load data from a flat file to People Soft tables (Market Rate Tables). The flat file contains data pertaining to the dividend accrual factor of the money market funds invested by FRK
• Developed an application engine program to load data from flat files to People Soft tables (Custom Tables). The flat file contains data pertaining to fund trial balances and the net asset value of the funds
• Developed an application engine program that invokes a CI, to load data from flat file to People Soft tables (Banking External Transaction tables).
• Developed an application engine program to load data from file attachment to custom tables.
• Developed a SQR program that invokes a shell script to extract/decrypt/format the EDI 822 file. The file is extracted from the BOFA remote location. The file is then decrypted and formatted.
• Modified the Mark-to-Market process to process the information based on the as of date entered on the run control page. This is a delivered AE process. Prior to the change, the process was extracting the information equal to the as of date entered on the run control page. The process was modified to extract the information closest to the as of date entered on the run control page.
• Improved the performance of the Cash Position Worksheet process, by adding addition criteria to the select SQL.
• Modified the prompts for the EFT (Electronic Fund Transfer) components. Change has been made to display the accounting template, bank code based on the business unit entered by the user.
• Custom process to undo an equity sale transaction.
• Custom process to delete MTM related accounting entries.
• Custom process to consolidate number of shares based on the business unit, security ID and accounting date
• Modified accounting summary page by adding the below indicated additional search criteria
• Account
• Accounting Event
• Security ID
• Modified the business process to base the routing on the business unit. Subsequent to the change, the selected payments will be sent for approval to the approver who is authorized to approve for that particular Business Unit
• Modified the business process to add an additional step to send e-mail notifications for approval (In addition to the delivered method of adding the approval to the work list of the approver)
• Added people code to include the URL of the approval component in the body of the e-mail
• Custom configuration page for defining the reviewers/approvers including their notification preferences
• Custom configuration page for defining the bank signers (at bank code and bank account level) along with their notification preferences
• Custom configuration page for defining the workflow events
• Custom process to send notifications for the EFT requests that are pending approval
• Custom process to activate/inactivate the reviewers/approvers/bank signers/bank codes/bank accounts that are participating in the workflow

Confidential, Pleasanton, CA

Responsibilities:

• Confidential International has two People Soft v8 systems. One system houses the data of RH staff employees. The other system houses the data of Protiviti employees (Protiviti is a Risk consulting and Internal Audit Company, which was acquired by Confidential International)
• A custom tool was developed to merge the Staff and Protiviti systems
• A v8 GOLD environment was created (HCM8GOLD), which is the repository for setup data (Core HR table data) and Protiviti specific tools objects (Records, Fields, Pages etc.)
• Compare process was executed to identify the similarities and dis-smilialties between the Staff and Protiviti tools objects (The staff People Soft system was considered as the source and the Protiviti People Soft system was the target)
• Protiviti specific objects were maintained in HCM8GOLD. The regular production changes to the Protiviti tools objects were also applied in the HCM8GOLD environment
• The custom merger tool was executed in HCM8GOLD environment, which would then bring over the core HR setup data (Company Table, Department Table, Job Code Table, Benefit Program Table etc.) to HCM8GOLD environment
• The setup data was then copied over to the target environment, which is the environment that was upgraded.
• The custom tool was then migrated to the target environment. When the custom tool was executed in the target environment, it would merge the transaction data (All the records which have the emplid field were considered as transaction tables. Examples are PS JOB, PS HEALTH BENEFIT etc.) from the Protiviti system into the Staff System, which is the target of the upgrade.
• The merger exercise was repeated in all the 9 test MTP passes and during the cut-over
• Was a core member of the team running the upgrade passes. In addition to myself, there was another resource in the core MTP team. The two of us executed the initial upgrade pass, all the 9 test MTP passes and the cut-over
• The upgrade to v 9.0 was done in two stages as shown below
• Upgrade from v8 to v8.9 (To tools version 8.49.15)
• Application Upgrade from v8.9 to v9.0
• Was responsible for setting up the upgrade jobs for all the test MTP passes and for the cut-over. The activities included the following
• Creation of required directories in support of the upgrade (Output, Staging etc.)
• Loading the template into the change assistant
• Setting up the upgrade options
• Setting up the environment for the upgrade (Defining the source, target etc.)
• Creation of upgrade job
• Performance tuned the delivered data conversion AE programs, by fine tuning the SQL statements. This drastically reduced the time needed for conversion
• Modified the delivered data conversion program to align with the requirements of Robert Half
• Added custom steps to the upgrade job, as per the business requirements of Robert Half
• Analyzed the compare report during the initial upgrade.
• Discussed with the business to decide which customizations have to be carried forward
• Retrofitted the customization as per the decision of the business users.
• Played the role of lead developer in benefits module
• Was instrumental in customizing several functional aspects of eben, as illustrated below
• Modified employee benefits summary, to display deduction before-tax and deduction after-tax
• Provided the capability to print the benefits summary in pdf format, by using row set based XML publisher
• Introduced the functionality of certificates, for the following
• Enrollment of disabled dependent/beneficiary
• Enrollment of student dependent/beneficiary
• Enrollment of domestic partner dependent/beneficiary
• Enrollment with Kaiser Benefits Vendor
• Worked extensively in revamping the benefits carrier interfaces, based on the benefits snap shot approach. The following carrier interfaces have been revamped
• Kaiser, BCBS, Cigna, VSP, COBRA, Sun Life (For Canada)
• Worked on retrofitting the benefits related reports and interfaces for v9
• Worked on retrofitting the people code for v9
• Worked on applying tax updates during the upgrade process (tax updates for 2008, 8-B, 8-C, 8-D, 8-E, and 8-F and 9-A, and 9-B for 2009) were applied during the upgrade process
• Revamped the ABBR update process, by converting the program from SQR to AE/CI
• Revamped the HCE (Highly Compensated Employee) process, by converting the program from SQR to AE/CI
• Developed a supplemental conversion program for benefits, which was executed after the upgrade, in each of the test MTP passes and cut-over.
• Developed a custom benefits finalization process, which is executed along with the benefits administration process (Before and after the execution of the ben admin COBOL)
• Modified the ben final program to process OE events and to send notifications to EE’s for enrollment, reminder to enroll, and finalization of enrollment
• Modified the text on the enrollment and detail pages (for all plans) as per the requirement of open enrollment
• Created a process to upload geographic location codes from a flat file
• Create a onetime process to prime the beneficiary information for plan types 21, 22, 25, and 27, based on the beneficiary information for plan type 20.
• Modified the people code to change the display on the eBenefits SS pages (Made changes in enrollment, summary and detail pages)
• Modified navigation collections and pagelets to display additional information for OE2010
• Design and development of Non-Hire data entry page
• Design and development of Hire data entry page
• Design and development of update verify page
• Development for AE program for loading the data from Non-Hire page to hire page
• Development of AE program for reading the data from CIC file and loading into Hire-Page
• Development of AE program for updating the pay status on the Main page
• Development of AE program for updating the pay status on the Update verify page
• Development of queries for extracting information from hire and non-hire pages

Confidential, Dublin, CA

Developer

Responsibilities:

• Running upgrade scripts through People Soft Change Assistant (Involved actively in pass 4, pass 5, pass 6 & production cut over pass)
• Resolving issues during upgrade testing in GL, AM & AP modules
• Modifying the SQR programs / reports and application engine programs to work in the upgrade version
• Configuring four new NT servers for the upgraded version (Installing software and configuring NT process schedulers)
• Application of patches/fixes to address the bugs in version 8.9
• Creation of custom People Soft definitions (Pages, Records, People Code etc.) for the Control-M scheduling tool.
• Modifying HR - FS & FS HR interfaces to cater the requirements in FSCM version 8.9
• Configuring Application Servers, Web Servers and Process Scheduler servers for the new upgrade environments (On Unix Boxes)
• Provided Post Go-Live Support

Confidential, Dublin, CA

Responsibilities:

• Conducted JAD (Joint Application Development) meeting with the vendor, business user and the technical team.
• Development of interface to send the employee data feed once a month
• SFTP’ing the interface to the vendor
• PGP encrypting the file before uploading to the vendor’s site
• Automating the Interface using ControlM scheduling tool
• Developing a People Soft page, for the users to log in to the vendors site
• Encrypting the Employee ID details and the data time stamp
• Sending the information to the vendor
• Conducted JAD (Joint Application Development) meeting with the vendor, business user and the technical team.
• Development of Interface to send the employee feed, on the first day of every month
• FTP the file to Recovery Database server
• Automate the process to execute on the first day of every month
• Development of PeopleSoft objects, to enable the users to enter phone information of the employees
• Implementation of Single Sign On for the Travel Services

Systems Analyst

Confidential, Milpitas, CA

Responsibilities:

• Data Upload using Import Manager
• Modification of custom payroll interface SQR programs
• Preparation of functional document in consultation with the business users in regard to the business rules and validations to successfully modify the JOB DATA panel and JOB record.
• Conducting JAD (Joint Application Development) meetings with the end users, business users and the technical team.
• Modification to the JOB DATA panel by inclusion of 3 new panel fields.
• Modification to PS JOB record by inclusion of 3 new additional fields
• Development of People Code
• Development of custom SQR for data load
• Preparation of functional document, in co-ordination with the business users, incorporating the business rules and interface field mapping between the People Soft system and Authoria system
• Creation of custom panel for severance data entry
• Creation of custom records/tables for storing employee severance information
• Creation of custom SQR for upload of quarterly earnings data.
• Creation of custom SQR for interfacing severance information to Mellon (Vendor).
• Preparation of functional document, in co-ordination with the business users, incorporating the business rules and interface field mapping between the People Soft system and Authoria system
• Interface process (SQR) for loading Employee Data, Employee Benefits Data, Dependent Data from PeopleSoft to Associate Resource Center(ARC).
• The customized SQR has been designed / scheduled to run on a daily basis.
• Creation of custom SQR for exporting data from PeopleSoft to Concur expense tracking application.
• Preparation of document in consultation with the users in Europe for the following
• Various business entities that need to be created for a new site (Business Unit, Company, Job Codes, Departments, Pay Groups etc)
• Validation that need to be built in for the National ID format and the minimum age for employment
• Implementing the changes in the production system after thorough testing in the test environment
• Modification of programs & queries to reflect the employees hired for the new site
• Changing the currency code for Turkey from TRL to TRY
• Preparation of functional document indicating the activities to be carried out for implementing the currency code change
• Conducting JAD (Joint Application Development) meetings with the end users, business analysts and the technical staff.
• Setting up of new currency code in the system
• Associating the new currency code with various business entities like Pay Group, Business Unit, Job Codes etc.
• Uploading the employee data to reflect the new currency

Confidential

Production Support

Responsibilities:

• Modification and enhancement of existing SQR reports, processes as per the requirements of the client.
• Modification and enhancement of People Code and Customized Panels
• Monitoring and maintenance of scheduled processes.
• Maintenance of Test and Production Databases
• Resolution of the issues reported by the users.
• Implementation of PeopleSoft fixes and patches.
• Migration of objects from test database to production database.
• Refresh of test database with production database.
• Maintenance and modifications to the custom panels, records etc.,
• Creation of new reports/processes as per the requirement of the client.

Developer

Confidential, Pleasanton, CA

Responsibilities:

• Developed custom Interfaces (COBRA, DCRA & Commuter Benefit Plan) using SQR for new vendors (Benesyst & Wage Works) as part of Open Enrollment project for 2004. (Developed 4 out of 5 new interfaces).
• Collaborated with Business Analysts & Users in determining the information needed to be sent in the interfaces to the vendors.
• Created custom process definitions, panels, panel groups and menus for the new vendor interfaces.
• Setting up of security for the newly created interfaces
• Migrated the new interfaces and PeopleSoft objects to production.
• As part of production support modified the existing custom SQR's as requested by the users and migrated to production.
• Involved in creation of shell scripts for FTPing the output files from UNIX server to NT server (to a shared folder of the network), when the users run the interfaces on the UNIX server.
• Involved in creation of Auto Sys Jobs ( Confidential ) for one of the Interfaces created for Open Enrollment 2004.
• Modification in the HR to FS Interface

Programmer/Analyst

Confidential, San Mateo CA

Responsibilities:

• Running Upgrade scripts thru upgrade assistant for HRMS.
• Identifying customizations via compare reports.
• Collaborated with business analysts to evaluate version 7.5 customizations to be carried forward to new application versions.
• Tuning and debugging Upgrade scripts.
• Modifying custom SQR interfaces and reports, Application Engine Programs for both HRMS and FSCM applications.
• Retrofitting pages, customizing records definitions and People Code.
• Architect of the Organizational Tree and the subsequent data sharing processes between FSCM and HRMS.
• Developed custom tree upload process (SQR).
• Developed custom SQR for flattening organizational tree.
• Made changes in the HR to FS Interface.