SUMMARY:

• Around 18 years of experience in Information Technology in the Analysis, Design, Development, Implementation and Testing of business application systems.
• Around fourteen Years of Extensive Experience in PeopleSoft Applications design & development as Senior Techno Functional Analyst.
• Experience in customization and implementation of PeopleSoft 9.1/9.0.8.9/8.8/8.4/8.3/8.17/8.0/7.6/7.5/7.0 HRMS/HCM and Campus Solutions (HR, Payroll, Base Benefits, Benefits Administration, and Time & Labor Campus Community, Student Admissions, Student Records). Functional knowledge in HR, Base Benefit, Payroll, eBenefit, eProfile, ELM,eLearning, eDevelopment, ePerformance, eCompensation, Employee & Manager Self Service, Business Process and Workflow.
• Strong Hands - on-Experience developing in Peoplesoft Financials products like Financials (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, eProcurement, Billing, Inventory, Project Costing) modules. Peoplesoft Financial security.
• Expertise in PeopleSoft Implementation, Testing, Integration, Upgradation, Customization, Interfacing, Reporting, Data Conversion and Troubleshooting.
• Having significant experience in Customization and Implementation using tools PeopleCode, Workflow, Application Engine, SQR, Crystal Reports, nVision, Application Designer, Component Interface, XML Publisher, Application Messaging, Upgrade Assistant and related suite of tools.
• Team player with excellent interpersonal communication skills & technical documentation skills.

TECHNICAL SKILLS:

Hardware: HP/9000, IBM PC & Compatibles.,O/S HP-Unix, Sun-Solaris 8, Ms Dos 3.2, Windows 95,98, 2000, NT 4.0,WinXP

Languages: PeopleCode, SQR, SQL, PL/SQL

RDBMS: Oracle9.x/8.x/7.x, MS-SQL Server, MS-Access

PROFESSIONAL EXPERIENCE:

Confidential, Erie, PA

Consultant

Technical Environment: PeopleSoft Financials/HCM 9.2/9.10 Purchase, Accounts Payable, Receivables and General Ledger, HR, Human Resources, Base Benefits and Benefits Administration, Data Mover, Change Assistant, SQR for 8.4 7, Oracle 11g, Windows 7, People Tools 8.55.11/8.51.10, Crystal Reports 9.0

• Worked on upgrade of HR system from 9.1 to 9.2.
• Modify existing Crystal reports to BI publisher Reports.
• Design and Develop interfaces and custom pages for integration of SAP Success Factors Recruiting to Peoplesoft.
• Worked on break/ fixes relating to production issues for Confidential .
• Used Change Assistant to apply the Tax Updates on an ongoing basis.
• Retrofit Erie customizations to the delivered peoplesoft and move the project to databases.
• Work on Financial related modules to fix the code.
• Worked on vendor load, Hyperion Interface for PeopleSoft General Ledger Data for Financial Planning and Analysis.
• Worked on tax updates for PeopleSoft to retrofit client customizations.
• Worked on recruiting customizations and Service Desk Express related customization.
• Customization to Direct Deposit File program and Direct Deposit Request for Bonus Pay.
• Vacation Accrual information feed to GL, Payedit and Payupdt customization.
• Worked on Security relating to Financials and HCM.
• Worked on Fidelity Biweekly Interface ADP Interface and ACA Payroll programs.

Confidential, Houston, TX

Consultant

Technical Environment: Peoplesoft HCM 9.10 HR, Base Benefits and Benefits Administration, AWE Approval Workflow. SQR for 8.4 7, Oracle 11g, Windows 7, People Tools 8.5.12, Crystal Reports 9.0

• Worked on the Custom Online Position Management module, design and developed new pages
• Developed AWE Workflow for the online Position Management Module which sends workflow notifications to the next level for the approval. Testing of approval process through AWE by creating test data.
• Configure and used HCM Delegation to delegate approval for the proxy.
• Created peoplesoft security roles as part of AWE and tested for Approval Monitor.

Confidential, Lebanon, NH

Consultant

Technical Environment: Peoplesoft HCM 9.10/Peoplesoft Financials 9.1 HR, Base Benefits and Benefits Administration, Peoplesoft Purchase,SQR for 8.4 7, Oracle 11g, Windows 7, People Tools 8.5.12, Crystal Reports 9.0

• Worked on the project for HR Benefit Reclassification and Position Control Project.
• Modified existing SQL Queries that are being used by the users at the DHMH.
• Modified SQR interfaces and reports related to Benefit Reclassification as well Position Control Project.
• Worked to resolve defects relating to customized pages for cloning of position and position distribution.
• Designed and Developed business processes to use in workflow to notify the managers in the event of a proposed or approved position distribution changes.
• Modified existing crystal reports as per the user requirements and develop new reports.
• Modified pages and peoplecode for the benefit reclassification and position control changes.
• Worked on Developing Workflow solutions using business process Workflow and AWE for the custom Position Distribution.
• Worked on Workflow for Purchase requisitions coming through brainware.

Confidential, Cambridge, MA

Consultant

Technical Environment: Peoplesoft HCM 9.10 HR, Benefits, Time and Labor, Absence Management, SQR for 8.4 7, Oracle 11g, Windows 7, People Tools 8.5.12

• Worked on enhancement customizations post upgrade to peoplesoft HCM 9.1
• Design and develop Employee change forms for self service transactions, extensively used peoplecode to validate online transactions coming through self service pages.
• Design and develop application engine program to reset online consent for year end forms so that the employees can view their W2’s online by means of pdf documents. Configure the year end forms to set the appropriate flags to enable to view payroll information through self service pages.
• Worked on peoplecode for online pages relating to Home and Mailing address for Harvard employees, developed code to dynamically produce webtext using Text catalogs.
• Worked on Job Data Extract and Job Data Upload application engine processes which use component interface for the job Data component. Developed online pages for the inquiry pages to view the uploaded information and the status of such data after the load process ran.
• As part of customization worked on Identification data related pages for the Harvard HR systems and Absence Management pages in PeopleSoft's Manager Self Service.
• Worked on design and developed the online pages for the childcare scholarship form for self service.
• Used AWE for approval routings to take the business processing to the next step.

Confidential,NYC

Consultant

Technical Environment: Peoplesoft HCM 8.90, SQR for 8.4 6.16, Oracle 11g, Windows 7, People Tools 8.47.16

• Involved in conversion from PeopleSoft to Workday.
• Design and develop programs for conversion for HR, Payroll and Benefits Data from peoplesoft to Workday system
• Worked on SQR and Application Engine program to write interfaces from peoplesoft to other systems.
• Interact with functional users to develop conversion programs for the new system

Confidential, New York, NY

Consultant

Technical Environment: Peoplesoft HCM 9.00, General Ledger, Commitment Control Budgeting,SQR for 8.4 7, Oracle 11g, Windows 7, People Tools 8.5

• Involved in CSR fixes for custom Labor Accounting and Distribution modules at Columbia.
• Worked on modifying existing fringe Queries used by the departments in the reconciliation of the distribution to departments.
• Worked on Department roll forwarding programs for the current fiscal year used in Commitment Control budgeting for the university. Used the Budget Data, Budget Earns data and Salary distribution for the employee as a way to distribute the earnings distribution in different account codes. Worked on providing the file extracts for mass cost transfer where the earning were distributed into a suspense code.
• Used the custom transfer process to transfer distribution from one account code to another.
• Worked on fixing the application engine programs relating to Encumbrances and Fringe distributions.
• Worked on program relating to extraction of historical data from LDS system to peoplesoft.

Confidential, Albany, NY

Consultant

Technical Environment: Peoplesoft Financials 8.90, Accounts Payable, General Ledger, Purchase, AR, Billing, etc., SQR for 8.4 6.16, Oracle 11g, Windows 7, Unix, People Tools 8.49.21

• Designed and developed a sqr program to setup user preferences for the user profiles in the system
• User preferences will be based on the security roles and other security options.
• User preferences relating to AP, AR, GL, Commitment Control, Travel and Expense, and PO etc are assigned using sqr program. This program is used for setting up user preferences for new user profiles as well as maintenance purposes.
• Automate route control assignments to users based on the workflow roles.
• Developed scripts to setup users as requestors, buyers, and requestor authorized users and buyer authorized users.
• Upload user profiles and roles using the exceltoCI utility for users in different environment.
• Security access to allow users of GL to upload budget journals, journals import, voucher load etc.
• Designed and developed Application Engine program for mass creation of user profiles, and other user preferences.
• Created sqr program which clones user profiles based on an existing user profile in the same environment as well across databases.
• Creating and maintaining permission list and roles for financial system security. Granting/revoking users access to financial system.
• Production support and trouble shooting issues of daily operations.
• Design and develop new processes to automate financial security setup and to minimize errors. Query and security queries.
• Troubleshoot security administration, Application Messaging and troubleshoot Integration Broker for Message Errors and access to XML published reports.
• Troubleshoot Workflow configurations for approval routings that take the business processing to the next step.

Confidential, Columbus, OH

Consultant

Technical Environment: Peoplesoft HCM 9.10, SQR for 8.4 6.16, Oracle 11g, Windows 7, Unix, People Tools 8.51.00

• Worked on PeopleSoft HR modules testing the impact of the new tools version on the existing processes.
• Worked on testing various sqr reports and processes, testing of time and labor related activities like the TCD Interface.
• Testing of base benefits, benefits administration and cobra qualifying events.
• Testing of application messages like TIME ELAPSE ADD, DEPT SYNC and HIRE REQUESTS.
• Setup Integration broker between Finance and HR modules to send the messages asynchronously.
• Testing of custom sqr programs to check for the impact of the new date time format mask for people tools 8.5 version. Testing of GL Accounting Line Dist and GL Interface related programs to validate the actual distribution for combo codes in the HR system
• Worked on modifying campus Community, Student Admissions, and student record application engine programs.
• Used the TL Group Refresh, schedule assign and Time Admin process to load time to payable time for biweekly and monthly employees.
• Used manager selfservice for time and labor to enter prior period adjustments and reported time for employees
• Testing of payroll data changes for the current pay period, employee tax data, and JED data changes. Involved in testing of Payroll Processes and Leave Accrual and verify the Time and Labor Processes.
• Testing of PeopleSoft security with respect to roles and permission lists and to test department level, college level and as well OHR users level security.
• Involved in testing of recruiting activities that is driven by security regarding the approval of job openings for various department level users.

Confidential, New York, NY

Consultant

Technical Environment: Peoplesoft FInancials 9.00.00, HCM Peoplesoft PHIRE, SQR for 8.46.16, Oracle 9.2, Windows NT, Unix, People Tools 8.49,

• Worked on PeopleSoft Financial modules like Project Costing and Accounts Receivables modules.
• Design and develop custom modules for project costing and AR. Worked on designing and developing custom online menus, pages for Associate Work Order page where project and activity are associated with the customers.
• Build custom security views to filter data based on agencies entering the work order for the agencies.
• Worked on application engine program which calculates the additives like the overhead, Fringe, FAI, Net Overhead and flat rates for Labor, Material and Equipment related work orders.
• Design and develop online pages for the setup tables required for custom AR module.
• Worked on HR Benefit interfaces like the FMLA outbound Interface using application engine. Worked on sqr reports like LOA notification report, Benefits Confirmation Forms and Invoice Tracking Report.
• Worked on design and development of online pages related to project costing used people code to validate the data for business logic for those pages. Developed XML publisher reports for the queries using pdf and rtf templates.
• Worked AWE for workflow notifications related to recruiting solutions.

Confidential, Natick, MA

Consultant

Technical Environment: Peoplesoft HRMS/HCM 9.00.00, SQR for 8.46.16, Oracle 9.2, Windows NT, Unix, People Tools 8.49

• Working on upgrade project of HRMS from version 8.8 to. HCM 9.0 during the build and test phase of the project.
• Involved in development of Payroll interfaces from HR system to ADP Payforce.
• Worked on reports relating to employee benefit plan changes, HMO terminations. Worked on interface which sends the leave balance information to the ADP.
• Worked on developing program to load the interface file data to the leave accrual tables and report relating to Sick vacation adjustment report and oline queries for the HR department.
• Worked on conversion of data from inbound PTO file from ADP. Used ADP files for Fidelity 401k savings information and time info for the system.
• Used data mover scripts, SQR, unix, and worked on online customizations.
• Worked on resolving defects from UAT used the clear quest tool. Used application debug tools to fix the problems in the peoplcode relating to the pages.
• Worked on the security roles and permission lists that will give access to session administrations in the training and enrollment based on the location. Also worked on testing the training requests online extensions which involved security by business units for different locations.
• Design and developed online pages, menus for the run control pages used for setting preferences.

Confidential, St Louis, MO

Techno functional Consultant

Technical Environment: Peoplesoft HCM and Campus Solutions 9.00.00, SQR for 8.4 6.16, SQL Server 2005, Windows NT, People Tools 8.49

• Worked on upgrade of HRMS from version 8.9 to HCM 9.0.
• Worked on modifying online pages for customizations relating to employee self service module involving Training and Development,
• Customized the profile management to suit to the WashU requirements. Modified the pages and used peoplecode to customize the summary pages relating to Faculty, Training and Course Enrollment for employee training.
• Worked on modifying the pages related to ELM like course session, catalog items, equipment and location related pages. Also worked on setting up requestor setup for learning classes. Worked on objects relating to ELM like profile management and organization data of the person. Worked on security related items for the ELM module.
• Worked on modifying the training request, schedule and administration pages and configuration.
• Worked on creating or modifying security Roles and Permission lists to have the same security as in prior version.
• Worked on modifying the permission lists to grant access to the pages that are part of the existing roles and test the roles and permission lists and also data security for the manager as well other users appropriately.
• Worked on modifying the existing queries and sqr programs to in corporate changes as per the new version. Worked on sqr programs like database audit prior to paysheet and contractual employee pay maintenance and training related crystal reports.
• Worked during the testing phase, created QA test scripts for the users to test the functionality.
• Set up ePerformance related objects in the profile management like Competency, responsibilities, Goals etc

Confidential

Techno Functional Consultant

Technical Environment: Peoplesoft HCM and Campus Solutions 9.10.00, HRMS, Base Benefits, Payroll and Benefits, Campus Community, Student Admissions, Student Records SQR for 8.4 6.16, Oracle 9.x, UNIX, People Tools 8.49, Hyperion 8.3.2.122, Quality Center QTP 9.2.

• Worked during the development phase of the project to make customizations using peopletools, peoplecode SQR, Hyperion and other tools.
• The newly implemented Student Information System has some components that are common to HR as well as the Students system. Worked on component interface and peoplecode relating to HR and Campus solution Personal and bio demographic data.
• Involved in identifying and customizing the online pages and peoplecode so that the HR system retains its functionality and at the same time appropriate to the SIS system.
• Involved in design and development of new program relating to Federal Work Study Program for Campus Solution students who are paid through the HR system.
• Create test data for campus solutions and use of such data for interfaces and reports used by the HR systems.
• Personal Audit program and Position Data Information interfaces.
• Developed sqr program to auto load new hire data for the purpose of testing of interfaces, reports and online functionality.
• Used component interface and peoplecode to customize the common components shared between the two applications.
• Used application upgrade to compare the code in different environments and use of data mover to move table data.
• Worked on applying the customizations and migration of projects between different environments. Involved in the testing of Campus community, Student Admissions and HR areas. Worked on Hyperion reports.
• Worked on application engine programs and sqr’s for Student Admissions, Campus Community and Student Records. Worked on security relating to HR and Campus solutions.

Confidential

Technical Consultant

Technical Environment: Peoplesoft Financial 8.4, AP, AR, GL & PC, Billing Peoplesoft HRMS/HCM 8.3/8.8, HR, Payroll, SQR 6.14, Oracle 9.x, UNIX, People Tools 8.46, Lotus Notes, Remedy, Crystal Reports, Business Objects 6.5.

• Designed and developed conversion program to upload AP, AR and GL Information from legacy system of local country to Peoplesoft Global Financial System.
• Extensively used Application Engine and SQR tool for conversion, Reports and Batch Processes.
• Developed a custom application engine program to upload and setup user profile from a csv file
• Designed and developed a sqr program to setup user preferences for the user profiles in the system
• User preferences will be based on the security roles and other security options.
• User preferences relating to AP, AR, GL, PC, PO and Billing are assigned using sqr program. This program is used for setting up user preferences for new user profiles as well as maintenance purposes. This process is run online as well as in batch to set the preferences appropriately based on addition and deletion of roles and other general ledger business units.
• Creation of new security roles and permission lists based on inputs from global financial management team.
• Assignment of AP, AR and GL Setid, Business Unit and pay cycles based on roles
• Involved in setting up Query security, Process security and Workflow securities for user permission lists.
• Designed and developed Application Engine program for mass creation of user profiles, assigning business unit and other user’s preferences.
• Created sqr program which clones user profiles, assigns business units and setup user preferences based on the profile to be cloned.
• Creating and maintaining permission list and roles for financial system security. Granting/revoking users access to financial system.
• Production support and trouble shooting issues of daily operations.
• Enhance existing process to automate financial security setup and to minimize errors. Query and security queries.
• Application security administration.
• Involved in the QA testing of the reengineered process to be able to move into production.
• Work closely with QA manager and other team members in coordinating the testing of the applications. HRMS Upgradation
• Involved in PS HRMS upgradation from 8.3 to 8.8.
• Comparing and copying the PS objects between source and target systems.
• Re-applying the customization after upgradation.
• Modified customized SQR Reports, Interfaces and Application Engine to get them work in new release.
• Running, Monitoring and trouble shooting conversion programs.
• Maintaining different level of security for HRMS systems.