Skills Synopsis

• Applications PeopleSoft Workforce Administration, Payroll for Confidential, Benefits, eRecruitment, Candidate Gateway, eProfile, Base Benefits, Benefits Administration, Time and Labor, Absence Management, Employee/Manger Self Service, PeopleSoft HRMS Portal Packs, Process Scheduler, PeopleSoft Financials Purchasing, Procurements, Accounts Payables, General Ledger, Commitment Control. PeopleSoft Enterprise Learning Management.
• RDBMS Oracle 8.x/9.x/10.x, Microsoft SQL Server.
• Languages SQL, SQR, C, PeopleCode
• Application Version PeopleSoft FSCM 8.0/8.8/9.0/9.1, PeopleSoft HRMS 8.0/8.8/8.9/ 9.0
• Tools PeopleTools 8.x, 8.4x, 8.50, 8.51, Crystal Reports, PS Query, Datamover, Application Engine, File Layouts, Component Interface, Integration broker, BI Publisher, Excel to CI, Approval Workflow engine, Email Collaboration.
• Operating System Windows 98/NT/2000/XP, Unix
• Hardware

Experience Summary

• Around 7.5 years of experience in software consulting and PeopleSoft Implementation projects. Experience working in all the phases of systems development life cycle, Including Data Conversion, System Implementation, Application Testing Unit, Functional, Integration and UAT Testing and support.
• Comprehensive knowledge of Software development Life Cycle SDLC with thorough understanding of various phases like Requirements Gathering, Analysis, Design, Development and Testing.
• Expertise in technical design for package software solutions, software development, end to end testing and database optimization techniques
• Adept at creating and transforming functional requirements into technical solutions.
• Experience in performing fit-gap analysis.
• Well versed in different management scenarios like change control, Quality Assurance, Defect Tracking, System Integration, and Scheduling.
• Extensive experience in developing conversions from Legacy systems to PeopleSoft.
• Expertise in design, development and support of PeopleSoft RICEW objects.
• Experience in developing testing plan for the RICEW objects.
• Supporting various test executions from technical stand point during various phases of testing life cycle.
• Technical scope including integration, conversion and potential gaps requirements.
• Performed ongoing support for applications including system/batch monitoring and processing, handling user questions and queries, investigating and solving system problems.
• Post Production Support for PeopleSoft FSCM.
• Experience in Public sector implementation projects.
• Experience in Quest STAT Version control and change management tool.
• Experience in HP Quality center for testing and defect resolution maintenance.
• Good knowledge on PeopleSoft Financials Purchasing, Payables, General Ledger and commitment control modules.
• Exceptional problem solving skills coupled with excellent communication and interpersonal skills.
• Excellent track record for meeting deadlines and submitting deliverables on time.

Professional Experience

Confidential

Sr. Technical Consultant, Reports Lead

• Worked closely with end-users in resolving issues, providing application support and troubleshooting user access and performance issues.
• Developed Custom component to trigger PSQuery from a hyperlink/Pushbutton.
• Developed several pre-processors that are scheduled to run on a daily basis for the reports.
• Involved in tuning performance tuning of the reports by writing effective SQL's and using indexes.
• Developed outbound extract to third party from CAM module to VendRep system.
• Developed many custom pages and components.
• Involved in complete documentation of the objects including the migration forms.
• Developing technical design for PeopleSoft reports.
• Updating the status of the deliverables to the PMO and project plan.
• The scope of this project is implementing the PeopleSoft Finance system to the largest financial state in the United States. Currently working as a Lead developer and Reporting Lead for the design, development, delivery and support of PeopleSoft reports using SQR and OBIEE BI Publisher.
• Lead a team of 4 members.
• Work allocation to the resources.
• Work estimation and providing LOE for the scope changes.
• Responsible for the delivery of PeopleSoft and OBIEE BI Publisher reports.
• Review of the Project deliverables and ensuring quality product.
• Responsible for developing reports for Cash and Deal management modules using SQR's and BI Publisher.
• Involved in fixing defects and bugs in the interface bulk loads for various PeopleSoft transactions using ODI, Integration broker and various other People Tools objects.
• Issue tracking and Defect resolution using HP Quality Center.

Environment: PeopleSoft Financials 9.0, PeopleTools 8.49, PeopleCode, SQR, Application Engine, PS Query, Application Designer, HP Quality Center, UNIX, STAT, Oracle 11i, OBIEE.

Confidential

Sr. Technical Consultant

• Involved in setting up of integrations broker gateways, nodes, messages, Queues, Services, service operations, routings.
• Involved in translating the Functional requirements into Technical documents.
• Technical Role includes working on Retrofit activities related to application upgrade.
• The scope of this project is upgrading the existing PeopleSoft 9.0 Financial system to PeopleSoft 9.1 Financial system with the tools being upgraded from 8.49 to 8.51
• Developed custom Approval Workflow engine using Application Package for Contract Approval process which includes setups.
• Assisting Functional folks in resolving the issues and speeding up the Testing activities.
• Involved in cleaning up the copy of production based on the DDDAudit and SYSAudit reports
• Implemented eProcurement using Punch-out integration with 3rd party vendor TxSmartbuy.
• Configured eProcurement Approval Workflow Engine AWE .
• Customized PV DC POOM XSLT Transform application engine to capture the custom field information coming from the third party.
• Involved in customizing the Billing invoice report using XML publisher.
• Developed Data Mover Scripts to move configuration data across multiple environments.
• Involved in the technical discussions with the client directly.
• Involved in complete documentation of the objects including the migration forms.
• Worked on Tree Manager to move PeopleSoft Trees between different instances.

Environment: PeopleSoft Financials 9.1, PeopleTools 8.51, Oracle 11g, Approval Workflow Engine.

Confidential

Sr. Technical Consultant Custom module development.

• Involved in translating the Functional requirements into Technical documents.
• Primary person responsible for complete design of custom module for Contracts Audit in PeopleSoft Finance.
• The scope of this project is implementing the PeopleSoft Finance system to the largest financial state in the United States. Worked as a lead developer supporting the design and development of the custom module called 'Contract Audit Module'
• Involved in design and development of this custom module, all components including the set up and the transaction components.
• Involved in the technical discussions with the client directly.
• Involved in complete documentation of the objects including the migration forms.
• Developed many custom pages and components having complex requirements, including creating HTML pages.
• Developed custom Application Engine processes to send the information from PeopleSoft system to the external vendor.

Environment: PeopleSoft Financials 9.0, PeopleTools 8.49, PeopleCode, SQR, Application Engine, PS Query, Application Designer, HP Quality Center, UNIX, STAT, Oracle 11g, OBIEE.

Confidential

Sr. Technical Consultant Lead Conversion Developer.

• Involved in the conversion of data for Talent acquisition management from legacy Active Recruiter to PeopleSoft.
• Developed mapping template from legacy PeopleSoft HRMS 8.0 to PeopleSoft HRMS9.0.
• Primary person responsible for complete development of conversion of Personal and Job related data from PeopleSoft HRMS 8.0 to PeopleSoft HRMS 9.0.
• The scope of this project is to re implement the PeopleSoft HRMS system from 8.0 to 9.0, Implement Talent Acquisition Management eRecruitment and Enterprise Learning Management ELM .
• Developed conversion programs to convert data into Enterprise learning management ELM .
• Developed SQR's to extract data from the legacy 8.0 system into flat files.
• Developed SQR's to stage the data from the files into temporary staging tables
• Developed Application engines using CI's for migration of the data from the legacy PeopleSoft HRMS 8.0. To PeopleSoft HRMS 9.0.
• Developed a custom application engine process to load Resumes and other supporting attachments of the applicants.
• Running complete data conversion cycles for different phases of testing individually.
• Developed complex SQR reports Head count, Demographic with Excel output by providing a variety of formatting options.
• Developed SQR reports for the 'No Show' functionality in ELM for courses.
• Developed SQR to trigger mail to the applicants by using a call system command and shell script.
• Developed records, pages, components menus to cater to the business needs.
• Customized delivered pages and components in ELM according to the business requirements.
• Created Process definitions, recurrence definitions.
• Documenting the technical specifications and unit test results for data conversions, reports, interfaces and enhancements.

Environment: PeopleSoft HRMS 8.0, 9.0, PeopleSoft Enterprise Learning Management 9.0, PeopleTools 8.49, PeopleCode, SQR, Application Engine, PS Query, Application Designer, Component Interface, UNIX, Shell script.

Confidential

Senior Developer.

• This project is a global consolidation of 3 regional PeopleSoft instance's into a single global PeopleSoft instance which are on different versions and different database platforms.
• Developed conversion programs using SQR to convert data Personal, biographical and Job data into PeopleSoft system.
• Supporting the data conversions by fixing the issues during the testing phase.
• Developed SQR reports to validate the converted data for data integrity.
• Developed SQR's to convert data for Absence Management.
• Cloned ABS701.sqr to populate the leave balance tables for the converted data.
• Developed the SQR program to insert current row for the records in the Job component.
• Develop the Interface for Benefits provider Fidelity Inbound and Outbound .
• Fix Issues for the inbound and outbound Interfaces to the exchange system from PeopleSoft
• Developed payroll reports using Crystal reports for Central Europe and Middle East Asia Visa group.
• Involved in migration of PeopleSoft object between different PeopleSoft instances.
• Involved in developing and modify queries according to the client requirement.
• Developed a custom reporting table for the HR Business Partners.
• Developed a custom app engine to populate the data into the above reporting table.

Environment: PeopleSoft HRMS 8.8/8.9, PeopleTools 8.46/8.48, Application Designer, PeopleCode, SQR, Crystal Reports, Application Engine, PS Query, MS SQL Server.

Confidential

Senior Developer

• Developed custom report to display the Personal and job data direct reports of the manager who runs the report.
• Customized the Job component by adding a new page JD JOB DATA with the custom fields.
• Customized Job Junior record to store additional custom data for Business Title, HR Business Partner, Mail Stop and high performer by adding the custom fields.
• Developed an outbound interface to send payroll/compensation related information to Ceridian payroll vendor. The nature of the interface for this was changes only file.
• Developed several SQR's to load the data from the SAP flat files into temporary staging tables
• Played a key Technical Developer role with primary responsibility of converting data from the legacy SAP system to PeopleSoft HRMS.
• The scope of the project is global PeopleSoft implementation for 10 countries from legacy SAP system hosted by Confidential to PeopleSoft HRMS with benefits and payroll being outsourced to Workscape and Ceridian vendors.
• Developed SQR's to load data into the PeopleSoft tables from the temporary staging tables. Developed a custom application engine program to mass update supervisor id changes using component interface. Developed an interface to send the biographical information from PeopleSoft system to third party vendor Workscape. Developed outbound interface to send Compensation and performance information from the PeopleSoft system to Authoria. The information sent to Authoria is used for annual salary planning.
• Developed PS Query's to support the users business requirements. Developed custom reporting record to be populated using an application engine which is scheduled to run daily in batch. Developed a custom App Engine to populate the data into the above table. Customizing the ESS MSS pages to the client's country specific requirements and texts. Developed PSQueries based on the client requirement.

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.48, PeopleCode, SQR, Application Engine, PS Query, Application Designer, Component Interface, UNIX, Shell script, Workflow.

Confidential

Developer - Retrofits

• The Scope of the project is upgrading the Finance Application from PeopleSoft 8.0 to PeopleSoft 8.8.
• Worked as an offshore development team member. Involved in retrofit of Custom objects. Developed and retrofitted customized Crystal reports Resolved the issues of the retrofits during testing cycles. Extensively worked on custom objects in SQR, Application Engine, PeopleCode and online enhancements. Developed Technical specs for the custom objects. Developed Unit Test plan. Migrated objects between different instances.

Environment: PeopleSoft FSCM 8.8, People Tools 8.44.15, Oracle, SQR, Crystal Reports