PROFESSIONAL SUMMARY:

• 8+ years of IT experience in the Analysis, Design, Development, Implementation and Testing in different modules of the ERP - PeopleSoft HRMS.
• Extensively worked with Inbound and Outbound Application Engine Programs using File layout and testing.
• Expertise in Application Designer, People Code, SQR, Process Scheduler, XML Publisher PS-Query, Workflow, and Application Engine .
• Proficient in Module Development, Upgrade, Interfacing, Conversion, Data Migration using People Code and People Tools.
• Knowledgeable in the creation of complex database reports using SQR, PS/Query and XML Publisher.
• Strong working knowledge of RDBMS such as Oracle, SQL Server and MySQL.
• Worked on industry products like PeopleSoft (HCM, ELM, and TAM), Oracle, HP Quality Centre and HP Application Life-cycle Management.
• Proficient in all phases of the systems development life cycle including requirements definition, data conversion, system implementation, system testing and acceptance testing.
• Experience in PeopleSoft implementation, development, customization and production support in HRMS.
• Primary areas of expertise include application development, writing conversion and interfaces programs using SQR’s, Application Engines and Excel to CI, developing reports using XML Publisher and SQR, supporting and administering PeopleSoft environments and providing technical assistance and guidance to support staff and project teams.
• Good experience in documentation of functional/technical designs, code modifications, and analyzing test results.
• Experienced in Reports, Interfaces, Conversions, Enhancements and Workflow.
• Extensive knowledge in PeopleSoft Data (Row-Level) Security, Creating & assigning Roles, Permission lists, User profile, User Security and Object Security.

TECHNICAL SKILLS:

Languages: People Code, SQL, C

Databases: Oracle 10/9 and DB2

Applications: MS Word, Excel, Power Point, Outlook, P

PeopleTools: People Tools 8.4x/8.5x (Application Designer, Maintain Security, Data Mover, PeopleSoft Internet Architecture, Application Engine, Application Package, Process Scheduler, PeopleSoft Workflow etc.), SQR, XML/BI Publisher, Approval Workflow Engine, Integration Broker.

Methodology: Agile, Object-Oriented Analysis/Design, UML, SharePoint, Unix ODBC, MS Visio 2008.

PROFESSIONAL EXPERIENCE:

Confidential, Dover, DE

Upgrade Specialist

Description and Responsibilities:

• PHRST is the Human Capital Management (HCM) component of the Confidential Enterprise Resource Planning (ERP) system
• PHRST system is an integrated software application consisting of four modules within Oracle (PeopleSoft): Human Resources, Benefits, Payroll and Time and Labor
• Central payroll operations for all state agencies, school districts, charters schools, and higher education institutions
• Apply routine PeopleSoft system updates
• Analyze and provide functional and system support for Benefit and Salary Plans
• Integrated workflow with First State Financials (FSF)
• Working on Confidential PHRST and FSF upgrade from version 9.1 to version 9.2
• Conversion of all custom Crystal reports to SQRs
• Conversion of customized delivered crystal reports to BI Publisher
• Working on adding the new Ethnic Categories to EEO4 Reports using PS N/vision which includes the EEO-4 Jobcode Count, EEO-4 Status Report by Jobcode, Terminations and Separations by Sex and Ethnic Group, EEO-4 Status Report, EEO-4 Status Report w/Seasonals and Temporary Employees.
• Developed custom records, pages and Components to meet the Business Requirement.
• Conversion of reading custom reports using BI Publisher
• Working independently and maintaining the design documents for updated notes on changes made to the reports
• Preparation of Technical Design document, Unit test case documents
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Using STAT 5.8.0 for Migration

Confidential, Atlanta, GA

Developer

Responsibilities:

• Customizing existing PeopleSoft functionality as per user requirements.
• Developing inbound, outbound interface to receive and send data from PeopleSoft HCM 9.2.
• Worked on resolving issues with workflow approvals & AWE issues.
• Developed custom pages for the maintaining GM agreements and storing GM specific Learning management fields.
• Worked on crystal Reports, SQR, XML publisher. converted Crystal to Bi publisher and SQR
• Developed custom application engine programs to inactivate the courses, learning paths etc.
• Used PHIRE migration tool for migrating the projects across different PeopleSoft instances.
• Created custom reports using BI publisher.
• Preparation of Technical Design document, Unit test case documents.
• UAT, cut over support and post production support.

Environment: PeopleSoft 9.2, People Tools 8.53, Oracle 10g, Windows, UNIX.

Confidential, Columbia, SC

PeopleSoft Consultant

Responsibilities:

• The project involved implementation, customization of PeopleSoft HCM (HR, Payroll, and Benefits).
• Gathered requirements, designed, developed and tested application enhancements.
• Played key role in development of Interfaces using SQR’s, Application Engine.
• Developed custom reports using SQR and XML Publisher.
• Created custom approval process using Application Workflow Engine (AWE) for terminations.
• Designed and developed an SQR process to generate files, containing all checks issued and reversed, to be used for Account Reconciliation.
• Developed an Application Engine program to generate a file (biweekly or annual) containing hours worked in Terminals to be used for staffing and budgeting purpose.
• Developed an automated process to calculate and load adjusted salary used to determine life and disability benefits for commissioned employees using Application Engine and Component Interface.
• Created a SQR process to load the file containing Short Term Disability monthly payments from Hartford. Developed custom objects to store short-term payments made to employees.
• Resolved various issues with Time Admin runs.
• Designed and developed a custom process to enrol employees in Time and Labour using Application Engine.
• Developed a Reconciliation process to report variances between Reported time and Payable time using SQR.
• Created Test scripts and executed various test cycles for System testing and parallel testing.
• Developed custom reports needed per the client requirements using PS Query.
• Worked in a Production Support role to resolve issues related to Payroll processing.
• Provided quality documentation including Design Documents, and Test Scripts.

Environment: HRMS 9.2, People Tools 8.53, SQR, Oracle 11i, Windows NT, UNIX, Toad.

Confidential, Bedminster, NJ

PeopleSoft Techno-Functional Consultant

• Requirements Analysis for new Change requests.
• Development and Retrofitting.
• Integration and System Testing Support.
• UAT Support for Job change transaction
• Deployment
• Support bug fixes and issues reported in Job change transaction, Termination
• Status reporting to Verizon Communication Management.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.

Environment: People Soft HRMS 8.8/9.1, People Tools 8.45/8.51, Windows, Application Designer, People Code, SQR, SQL, PS/Query, Crystal Reports, Oracle 10, PL/SQL.

Confidential, Altamonte Springs, FL

PeopleSoft Developer

Responsibilities:

• Involved with functional team to gather technical and reporting specifications and information for customizations, and designing reports.
• Worked on various People Tools such as Application Designer, Application Engine, Maintain security, Object Security, Process Scheduler, Process Monitor, PS Query, nVision, and Tree Manager.
• Modified and tested various SQR interfaces like General Ledger activity, Posted Journal summary and Journal entry details
• Designed an nVision report, which shows Revenue by Worksite for Business Unit, Products, and Departments by period. The report lists about the details of the revenue for each account in details by period.
• Designed an nVision report, which gives the monthly summary of total revenue by product for the given period.
• Designed an nVision report, which gives the Revenue for Department/Location by time spans. This report mainly summarizes about the revenue of each and every staffing office around the US to monitor the marketing leader’s business.
• Modification and development of new reports and queries using SQR, Seagate Crystal Report, nVision, Tree Manager, PeopleSoft Query for analysis, data integrity, reconciliation of the flow of data among modules of PeopleSoft
• Designed a Crystal Report, which captures Lost Orders for each Business Unit, Product and department by period. The report lists about the details of the lost orders and their contacts
• Designed a Crystal Report, which captures Open Orders for each Business Unit, Product and department by period. The report lists about the details of the lost orders and their contacts Interfaces
• Generated a report using SQR to display the error data in the file sent by the carriers by comparing with the system tables.
• Developed new SQR Report, which gives the business unit breakdown of vendor information along with the total amount paid during the year.

Confidential, Troy, MI

Technical Developer

Responsibilities:

• Involved in all steps of admin, development and most of the parts of PS 9.1 Upgrade.
• Generated Compare Reports between 8.8 Production and 8.8 Demo to identify customizations.
• Involved in decision process of customizations and suggested users in keep/drop decisions.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Implemented single sign-on for various benefit vendors.
• Retrofitted the Time & Labor rules.
• Retrofitted the departmental security and permission lists using Tree Manager.
• Created new roles and permission lists for user’s security and followed Corning methodology to migrate to production and maintained documents for audit.
• Worked on integration between People soft and third party application Oracle Identity Manager (OIM) to retrieve User Profile data.
• Tuned conversion SQL’s to decrease the execution time which helped to minimize the cutover time.
• Involved in the production cut over plan and Go-Live activities.

Environment: People Soft HRMS 8.8/9.1, People Tools 8.45/8.51, Windows, Application Designer, People Code, SQR, SQL, PS/Query, Crystal Reports, Oracle 10, PL/SQL.

Confidential, Orlando, FL

PeopleSoft Technical Developer

Responsibilities:

• Worked on different kinds of issues on Core HR, Payroll, and TAM in System Integration Testing.
• Liaison between the development and business teams to discuss and configure efficient solutions.
• Involved in running the PS Delivered Application Engine process for data conversion from current version to the newer version.
• Created new and customized Record definitions, Pages, Components for the client specific functionality.
• Customized and modified ePerformance, eCompensation, eRecruit pages upon user requests.
• Built custom configuration pages to the users to be able to add items that are used in ePerformance documents.
• Involved in the business process meetings with client along with Project management to identify the customizations.
• Fixed the issue in PeopleCode when Operating Unit is getting blank on Task Profile Page.
• Fixed the PeopleCode related to AddAttachment () function in PeopleCode when user is uploading the resumes as attachments in TAM.
• Developed several SQR outbound interfaces to transmit the benefits related data to the vendors
• Fixed the issue by activating the Service Operations and Domain Node when the data is not transferred from Prepare for Hires to Manager Hires and from Manage Hires to Person Data.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Developed complex SQR reports and SQC’s to suit the needs of the company. Used Process Scheduler to make SQR available from within PeopleSoft.
• Involved in user training to use the new system, Preparing the user guide and job aids for end user training.

Environment: PeopleSoft HRMS 9.0/HCM 9.1, PeopleTools 8.48/8.51, SQR, TOAD, ORACLE 10g, STAT 5.3, SQL PLUS 9.0.1.

Confidential

Programmer Analyst

Responsibilities:

• Prepared System appreciation documentation during the initial discovery phase of project. Attended knowledge transition sessions with Clients SMEs to get thorough understanding of existing application.
• Worked closely with onsite coordinators to understand the requirements and prepare functional designs/Detail design document
• Estimated the project and planned project implementation in multiple phases
• Lead the application development team which was responsible for changes to the mainframe system.
• Acted as point of contact to the front end java development team
• Published timely status of project to onsite coordinators
• Worked on all phases of Application development - Coding, Unit Testing, UAT and IT support, Implementation and Post implementation stabilization
• Provided application support by being primary on call on a rotation basis

Environment: PeopleSoft HCM 9.0, People Tools 8.47, Oracle, Windows, UNIX.

Confidential

PeopleSoft HRMS 8.9 Reimplementation

Responsibilities:

• Analysis and Preparation of Technical Design Documents.
• Development and Customization of new pages and records.
• Development and Customization of queries using PS Query.
• Preparation of Data Conversion templates for the Data Conversion of Base Tables and Transaction Tables.
• Preparation of Module Specifications and Technical design documents for Data Conversion and Interfaces.
• Preparation of Test Cases.
• I was involved in Testing and reviewing the components, Data Conversion AEs and Interfaces created by Team members. Also assisted in development of Data Conversion AEs.
• Preparation of AE in combination with File Layout and Component Interface for the Data Conversion of major Transaction components like Hire, Personal, Job and Position Data components.
• Involved in Creating New Records, Pages, Components, Menus & customizing existing Pages & Peoplecode.

Environment: Languages & Tools PeopleSoft HRMS 8.9, People Tools 8.47, People Code.