SUMMARY:

• Around 6 years of experience as Peoplesoft Development that includes Implementation, Upgrade, and Production Support of people tool 8.9, 9.2 HCM modules.
• Expertise in end to end project life cycle (SDLC) starting from initiating the kick - off meetings, Requirements definition, Preparation of effort estimates, Handling client approvals, Solution Design-Statement of Work/Business requirement documents, Coordination with the Business, Development team & Testing team to ensure quality deliverables. Creating test plans, coordinating UAT with the Business Users.
• Experience in Peoplesoft Upgrade Methodology having worked on upgrades from 8.9 to 9.1 & 9.0 to 9.2.
• Experience in installation and configuration of web logic 6.1, BAM 8.8, People Tools 8.42, Tuxedo 6.5/Jolt 1.2, Application Server and Process Scheduler on AIX 4.3/5.1 environments.
• Expertise in PeopleSoft Concepts, tools and technologies like Application Designer, People Code, People Tools, Application Engine, Integration Broker, Workflow, AWE, Component Interface, PS Query, Process Scheduler, Security, Data Mover, SQR, XML Publisher, PS Query, File Layout, Integration Broker, Excel to CI, Web Services.
• In-depth experience in analysis, planning, development, and implementation stages, including load testing, quality assurance, and tuning.
• Experience in PeopleSoft HCM 9.2, Process Scheduler (UNIX and Windows), Application Server (Tuxedo), Web Server (WebLogic), Application Designer, Data Mover, Integration Broker, SQR, BI Publisher, Change assistant and Oracle SQL 11g.
• Hands on experience with software analysis, design development, New implementation, Upgrade, customization and testing of ERP, client/server, Data Warehouse, Enterprise Performance Management applications, for various clients in areas of Corporate, Consumer, Investment Banking, Hedge Funds, Auditing, Insurance, Commercial Real Estate and Public-sector undertakings.
• Extensive experience on support and enhancement of PeopleSoft HRMS - Time & Labor, North America Payroll, Core HRMS, Manager Self Service, Employee Self-service, Compensation and Profile Management.
• Hands-on experienced in Client / Server, 3 Tire Architecture and Application Server, worked on SQL Language Definitions such as DDL, DML and DQL, functional knowledge, in addition to Design, Fit-Gap Analysis, Implementation and Upgrade.
• In-depth proficiency of functional and technical knowledge, in addition to Design, Development, Implementation, Upgrade, Customization, Testing and Support experience in PeopleSoft AP, PO, GL, BI, AR, OM and AM.
• Expertise in developing and customizing reports using reporting tools such as SQR, PS Query, Crystal Reports, BI Publisher (XML) and nVision.
• Have excellent data modeling, analytical and problem-solving skills and very good team player with excellent communication skills. Excellent Troubleshooting and enhancing skills.

TECHNICAL SKILLS:

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8/8.3

PeopleSoft Technical Skills: Application Designer, People code, Application Engine, Data mover, Process Scheduler, PS Query, Security, Workflow, Component Interface, Application Messaging, PIA, SQR, Crystal Reports, Tree Manager.

PeopleSoft HRMS Skills: HR, Payroll, Benefits Admin, Time & Labor, Base Benefits Admin and E-Applications.

Reporting Tools: SQR, Crystal Reports, XML publisher.

Debugging Tools: SQL Trace, People Code Debugger, Application Engine Trace

Integration Tools: File Layout, Component Interface, Integration Broker, Application Messaging.

Databases: Oracle 10g, 9i, 8.x, SQL Server, DB2, MS Access.

Languages: SQL, PL/SQL, C, C++, Java.

Data Management & Batch Processing Tools: Data Mover, Application Engine, Import Manager and Process Scheduler.

Administration Tools: Portal Administration, Object Security, Workflow Administration and Query Security.

Development Tools: Visual Basic 6.0, TOAD, SQL Navigator.

Operating Systems: Windows 95/98/2K/NT/XP, UNIX, Linux.

WORK EXPERIENCE:

PeopleSoft HRIS Analyst

Confidential, Phoenix, AZ

Responsibilities:

• Worked extensively on PeopleSoft HCM 9.2 Systems configuration and support of HR, Absence Management and Payroll for North America Modules.
• Analyzed business requirements, procedures and problems to automate or improve existing systems and review and alter systems to increase operating efficiency.
• Worked with cross - functional teams to gather requirements and work on new configurations and modifications in Setup required.
• Worked on setting up new pay-groups, element groups and various other payroll setup activities.
• Performed the role of PeopleSoft HRIS consultant by working in the client's heavily customized Absence Management system.
• Responsible for performing complex updates to the employee personal and job records.
• Coordinated with technical team during data conversion using automated data conversion process.
• Processed benefits requests accurately and ensured accruals are updated correctly.
• Configured Take elements and calculation rules for Vacation, Sick, Paid Time Off, Extended leaves, Jury Duty etc.
• Configured absence accrual and leave request processing functionality, including a rules engine to compute the most complex accrual, Consumption, payout and carryover logic.
• Done setups of extended leave templates and configuration of extended leave calculation rules for client's FMLA, Maternity, Worker's compensation types.
• Configured request approval functionality, including multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service and Approval Workflow Engine.
• Utilized the attachments setup functionality and integrated the attachments definitions with FMLA templates to reduce the risk of compliance.
• Created Custom Workgroups, Schedules, template-built rules and rules programs and Preformed data integrity audits using MS Excel.
• Configured rules for Overtime, Additional straight time, Holiday for FT and PT, Comp time and Meals.
• Created business process documentation and write configuration and system data documentation.
• Designed test plans and approach to validate complex Time and Labor, Absence Management business rules.
• Utilized in-depth knowledge of functional experience in PeopleSoft HRMS (Human Resources Management System) ERP (Enterprise Resource Planning) and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Involved in analyzing business needs and worked with technical resources to develop, design and test the solution for customizations, interfaces and reports.
• Set up, run and validate the output from the jobs associated with the processing tasks, including processing and running on-cycle payroll weekly and off-cycle payrolls as scheduled or necessary each week.
• Done special processing of weekly queries and reports to ensure the accuracy of employee payroll, HR and benefit information including earnings, deductions, payroll taxes, and leave balances
• Analyzed data from multiple HR/Payroll databases in support of department needs.
• Managed a job-reclassification project. Conducted occupational research to determine if job titles were in sync with workplace norms.
• Performed a variety of payroll and human resource functions, such as creating and run ad hoc queries in PeopleSoft in support of departmental operations and projects.
• Created graphs and handouts, also preformed data integrity audits, verify table entries and key cross-reference tables in support of projects.
• Assisted in the requirements gathering, testing and change management of system implementations, upgrades, patches and enhancements.
• Collaborated with functional and technical staff through each phase. Maintained and configured HRMS system.
• Responsible for defining the test pan, analyzing the test scenarios, preparing test case document, defining the performance environment requirements specifying report templates and conducting the scripting, benchmarking and interpretation of results.
• Worked with Project lead, development and DBA's as the HR resource for the migration of the Oracle database from Oracle Austin Data Center to ITC.
• Responsible for data integrity and security by accurately and timely maintenance of the HR Oracle systems.
• Coordinated user testing; worked with DBA's and Developers to facilitate transition of interfaces for Payroll and benefits to pristine environment.
• Worked with ADP resources to upgrade payroll software from PCPW to Pay force and provided support for Pay force, ETime and ADP Connection.
• Collaborated with business users to identify areas for process improvement to reduce manual efforts. Worked in conjunction with the technical development team to develop and support interfaces to/from third party software, reports and programs.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR.

Peoplesoft Business Analyst

Confidential, Albany, NY

Responsibilities:

• Installed and configured multiple PeopleSoft 9.2 and 8.8 environments on People Tools 8.46 and 8.49 with Oracle 11g.
• Involved in PeopleSoft Application upgrade. Performed a PeopleSoft Payroll upgrade/re - implementation from 9.1 to 9.2
• Identified the objects, which needed to be retrofitted by doing the complete impact analysis.
• Created the file extract templates for core HR configuration and transaction data conversion processes and on-going interfaces for legacy to PeopleSoft system.
• Configured Load balancing and high availability on Application server, Process scheduler and Web Server.
• Created and ran Test Cases for PeopleSoft 9.2 Core HCM, TAM, ePay, eProfile, eRecruit, eBenefits, Payroll and Absence Management.
• Created and reviewed system test scripts scripted extensively on Time & Labor, Absence Management and Commitment Accounting modules.
• Prepared detailed data maps spanning Human Resources, Benefits, Time & Labor, Position Management and Payroll.
• Eliminated various 9.1 Talent Acquisition Manager (TAM) customizations by utilizing the 9.2 Flexible Processes, TAM security and AWE.
• Developed Unix shell scripts to schedule reset of Process Scheduler, and Application Server domains.
• Developed shell scripts on the Application Server to generate the average transaction time served by each Application Server Instance. Created simple scripts to monitor the tuxedo domain to check queue/server status.
• Provided Functional Inputs as a working member of the Security team in support of designing and testing assigned module application security models (including work centers)
• Comprehensive experience in setting up security in HRMS, Financials, CRM, EPM, and Portal environments
• Developed test report, interface, conversion, and enhancement programs to meet the requirements in the technical specifications.
• Customized delivered GL SQR's to run the reports for 'ALL' Business Units.
• Analyzed and planned upgrade approach and upgrade of all preproduction environments.
• Developed and Troubleshooted the XML Publisher Reports.
• Customized My Wallet and EX SHEET ENTRY page to display Procurement card information.
• Created functional specifications based on business process needs, wrote test scripts and supervised the entire customization process in collaboration with the technical team.
• Involved in the setup of business units, configuring the setup options for Supply Chain Modules (AP, Purchasing, eProcurement)
• Developed an SQR data conversion program to import payments from a third-party system to AR module.
• Customized PeopleSoft delivered Posted Voucher Listing Crystal report APY1020.rpt for AP module.
• Modified pages in GL module base on client specific requirements and created nVision reports and nplode
• Tested Enable Employee Self-service Enhancement where the user is unable to change his/her home address in Update Profile page and enabled expense payments to be routed to alternate locations (addresses) other than the address sent from Pay SERV.
• Done setting up of TAM & CG related security like Recruiting roles, Recruiting row level permission list.
• Interacted with the Users and Functional analysts to come up with new requirements for the business unit.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.
• Responsible for sending the Recruiting module from PeopleSoft to RED Carpet
• Provided Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• Analyze Human Resources/ Time & Labor/ Payroll/ Time Capture business processes, Coordinates with onsite team members and interact with client for new development work, estimation and delivery.
• Worked as Oracle functional consultant as part of Oracle HCM implementation for Oracle Core HR, CWB and OAB.
• Involved in in conversion and migration from Peoplesoft HCM to Oracle HCM.
• As primary HCM resource identified business requirements and performed tasks required for configuring Oracle HR.
• Set up payroll elements, element links and grades required for salary entry; created Extra Information types and elements to accommodate various allowances and data points.
• Coordinated with developers in design and development of reports to meet corporate standards.

Peoplesoft Business Analyst

Confidential, San Jose, CA

Responsibilities:

• Analyzed entire benefits system which had 170 benefit programs in PeopleSoft.
• Prepared reports based on the analysis based on the current configuration for different teams.
• Created Application engines to Convert Budgets and Actuals Data and inserted it to ledger table and journal tables as per client's requirements.
• Conducted meetings with different business partners to understand the requirement and documented the gaps based on the configurations.
• Analyzed the gaps and business processes and prepared solution document and reviewed with the leader ship team to get the approvals.
• Replaced most of the manual work arounds that business was following in current world with the help of configurations in Core HR and Benefits modules.
• Developed strategy and methodology of consolidating Ameritrade and TD PeopleSoft HRMS 8.8 (Payroll, Benefits, Human Resources, Time and Labor).
• Created new benefit programs for the acquisition employees and enrolled them in to the programs using a PLN event.
• Split Benefit programs into multiple benefit programs based on the pay frequency of the employees as the coverage was to begin on the first of the pay period.
• Collaborated with developers in developing the interface and to explain the requirements
• Created new eligibility and event rules to support the new benefit programs.
• Functional documents were created for a new vendor interface called standard to send Life insurance information of all US based employees.
• Worked on customizations related to critical HR transactions, such as Hire, Re - Hire, Intercompany transfer, promotion, demotion, Termination, supervisor change, full part time change.
• Conducted sessions on Time & Labor and Absence Management for the project team.
• Identified all the Business Process, Desktop reports and evaluated the required Business processes reports in Core HR.
• Replaced some of the SQLs that were run every year during and after the Open Enrollment with config changes.
• Analyzed Open Enrollment procedures for last few years and prepared a document that was to be followed during this year Open Enrollment.
• Prepared queries based on the requirements for Open Enrollment.
• Performed OE functional and user acceptance testing for client and corrected and documented the issues.
• Analyzed current payroll and benefit interfaces and processes and prepared documentation for future state on both Benefits and Payroll after the out sourcing.
• Worked with new vendors to gather the requirements for Medical, Dental and vision vendors to design file layouts and develop 834 EDI format files (HIPAA).
• As part of Affordable Care Act implementation, enabled ACA event handler, worked with ACA component interface to update records in ACA component by coordinating with developers, updated ACA eligibility field for job codes, and developed a process to calculate average hours of the employees and worked with ACA eligibility criteria for benefit programs.
• Created test cases and executed ACA changes in PeopleSoft benefits administration system.
• Gathered the requirements and designed solution for receiving the payroll inbound files from different vendors for both US and CAN employees to load payroll deductions.
• Designed solution for one-time deductions and retro adjustments for any adjustments that will be processed by the benefits vendors.
• Made changes to current benefits system to process benefits using base benefits.
• Involved in the cut over tasks and validations during the go live time for Recruiting, Benefits and Benadmin modules
• Updated configurations to process Savings (401K) and pension plans for the employees using base benefits and Payroll.
• Provided functional support to offshore for all Student Record customizations to include functional spec design, testing, and user acceptance testing
• Gathered requirements, drafted designs and tested requirements for course substitutions, foreign language waivers and certification waivers per client's business processes
• Gathered requirements, drafted designs and tested requirements course equivalency transfer credit rules
• Involved in gathering requirements for Client's core HR and Absence Management modules.
• Gathered requirements, drafted designs, developed mapping and tested requirements for conversion of comments data from client's legacy system
• Assisting with end-user training and UPK Development as required for Admissions, Campus Community and Student Records
• Researched and configured Self Service and FERPA based off client's business needs

Peoplesoft HCM Analyst

Confidential, New York, NY

Responsibilities:

• Worked as Oracle functional consultant as part of Oracle HCM implementation for Oracle Core HR, CWB and OAB.
• Involved in in conversion and migration from Peoplesoft HCM to Oracle HCM.
• As primary HCM resource identified business requirements and performed tasks required for configuring Oracle HR.
• Set up payroll elements, element links and grades required for salary entry; created Extra Information types and elements to accommodate various allowances and data points.
• Coordinated with developers in design and development of reports to meet corporate standards.
• Worked with Project lead, development and DBA's as the HR resource for the migration of the Oracle database from Oracle Austin Data Center to ITC.
• Responsible for data integrity and security by accurately and timely maintenance of the HR Oracle systems.
• Coordinated user testing; worked with DBA's and Developers to facilitate transition of interfaces for Payroll and benefits to pristine environment.
• Working with ADP resources to upgrade payroll software from PCPW to Payforce and provided support for Pay force, ETime and ADP Connection.
• Collaborating with business users to identify areas for process improvement to reduce manual efforts. These activities included developing data loaders, training users on use of Mass Update functionality, working with Developers to design audit reports and programs to automate upload of Merit Increases and Performance Ratings.
• Working in conjunction with the technical development team to develop and support interfaces to/from third party software, reports and programs.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR.
• Identified and addressed client needs: building solid relationships with clients, developing an awareness of Firm services.
• Set up of elements to implement new Cellular Stipend Allowance and coordinating testing through import to Payroll system.
• Participate in Oracle HR System testing for innovative solutions and upgrades.
• Worked extensively in the Customizations of AP, BI, AR, Contracts, T&E, PO, and GL of PeopleSoft Financials.
• Wrote the Integration and System test scripts in PO, AP, BI, AR, T&E, KK and GL.
• Analyzed the business requirements and created several Test Plans to use as a basis for testing the system.
• Conducted Functional tests checking all screens, customized menus button and options.
• Reapplied Customizations in SQRs and Application Engine interfaces to carriers/vendors, time entry inbound from multiple systems, benefits, HR interfaces and reports.
• Worked with the developers, functional analysts and business users by holding several sessions to analyze what new changes were needed to replace the existing functionality.
• Documented all the new changes and created several scripts to test the functionality.
• Worked on Project Costing, Contracts, Grants, Billing, Accounts Receivables, Accounts Payable, eProcurement, Purchasing, Commitment Control and General Ledger.
• Customized the delivered PeopleSoft Journal Entry Header page and Journal Inquiry Page to record the user comments.
• Configuring PDL process for applications and test scores from clients' legacy system
• Reconfiguration of set-up table to ensure items supports client business needs
• Troubleshooting security issue triggered during User Acceptance Testing
• Configuration validation between environments to ensure clean migrations. Sessions, configuration, testing and end-user training
• Assist clients with the implementation and optimization of PeopleSoft Campus Solutions modules.