SUMMARY

• Fourteen years of IT experience in software design, development of ERP and client/server applications with extensive experience in PeopleSoft Enterprise HCM.
• Over 12 years of experience as PeopleSoft Technical/Functional Consultant in implementation and upgrades including system design, Fit - Gap-Analysis, converting legacy/external systems in PeopleSoft HRMS 9.2, 9.1, 8.8, 8.3, 8.0 (HR, Benefits Administration, Base Benefits, Payroll, Time and Labor, e-Benefits, e-Pay, e-Recruit, e-Performance and Profile Management, Enterprise Portal).
• Led teams of developers and mentored other team members working on different modules.
• Experience in implementing Section 508 compliant PeopleSoft applications.
• Extensive experience working with People Tools i.e., Application Designer, Application Engine, Application Messaging, Data Mover, Import Manager, PeopleCode, Upgrade Assistant, Workflow and Security Administration.
• Experience in writing complex reports using SQR, PS Query, PS nVision and Crystal Reports.
• Experience in using Integration Tools like Component Interfaces, Integration Broker and Application messaging for interacting within and outside PeopleSoft applications.
• Extensive experience in PL/SQL, Stored Procedures, Triggers and database level audits using Oracle, SQL Server and DB2.
• Experience training, preparing documentation for end user and other team members.
• Acquired in depth knowledge of PeopleSoft modules working on production support.

TECHNICAL SKILLS

ERP - PeopleSoft Modules: PeopleSoft HRMS 9.2, 9.1, 8.8, 8.3, 8.0 HR, Ben Admin, Base Benefits, Payroll, Time & Labor, e-Benefits, e-Pay, e-Recruit, e-Performance and Profile Management, and Enterprise Portal

ERP Tools: People Tools - Application Designer, Application Engine, Application Messaging, Component Interface, PeopleCode, Upgrade Assistant and Workflow.

RDBMS: Oracle 7.x/8.0/9i/10g/11g, SQL Server 2000, MySQL

Reporting Tools: SQR, Crystal Reports, PS Query, PS nVision and XML Publisher

Other Languages: Java, C, C++, PHP, JSP, ASP, VB.

Operating Systems: Windows 95/98//NT/2000/XP, Unix, Linux

Testing Tools: Win Runner, Load Runner, Test Director, Rational Suite and HP Quality Center.

PROFESSIONAL EXPERIENCE

PeopleSoft Senior Functional/Technical Consultant

Confidential, Austin, TX

Responsibilities:

• This upgrade involved setting up standards for a State-wide ERP System. Conducted user meeting with stakeholders to change Time and Labor business process and capture requirements.
• Redesigned custom Consolidated Time Sheet to be scalable for a State-Wide PeopleSoft implementation by leveraging off PeopleSoft 9.2 delivered functionality.
• Developed 508 Compliance Standards and provided technical knowledge for the development team to improve the accessibility of the system.
• Collaborated with Oracle to develop new POC for Grids, Style sheets for Color Contrast and other creative design changes to pages.
• Analyzed and developed fiscal year-end conversion process to comply with State regulations, position reorganization/reclassification including pay raises, closing leaving balances, etc.,
• Designed data model for converting data from existing systems to the new CAPPS system, instrumented in pushing for Component Interface approach to run data through online edits.
• Worked with the Database Administrators to tune Time Admin and archive data thereby decreasing processing time from 4 hours to 45 minutes.
• Prepared detailed Functional and Technical Design Documents, which are being used as a template to onboard other State Agencies on to this State wide ERP implementation.
• Mentored developers working on the project; presented development, scalability standards to ensure all the Manager Self-Service and Employee Self-Service pages meet the client requirements to accommodate new agencies.
• Performed intensive User-Acceptance Testing and Peer-Review Testing. Carried out performance-level testing, minimizing time-taken for running processes.
• Prepared documentation and worked with client team for knowledge transfer.

Environment: PeopleSoft HCM 9.2, PeopleTools 8.53, STAT, PL/SQL, Oracle 11g.

PeopleSoft Senior Functional/Technical Consultant

Confidential, Austin, TX

Responsibilities:

• Gathered business requirements and Re-Implemented existing custom e-Performance module in PeopleSoft 9.1 changing the business process to fit the new design.
• Setup Profile Manager for each Job Code in the organization and populated them with standardized Job description, Task and Standards.
• Implemented a 508 Compliant PeopleSoft HRMS 9.1 system for Confidential working closely with Accessibility, Dept. of Assistive & Rehab Services (DARS) experts and Oracle.
• Develop Accessibility Standards/Guidelines for Section 508 Compliance which is used by the development team to redesign pages with headers, tab order, color contrast, grid labels and Image tags to meet 508 compliance and readability with JAWS screen reader.
• Developed a centralized edit repository holding functions for all HR Action/Action Reason code edits. All HR actions entered through core Job Component, Manager Self-Service are edited against the same library eliminated the need to duplicate edits.
• Developed data conversion programs to convert data from the custom tables to delivered e-Performance and JPM tables.
• Developed enhancement for awarding merit increase using Manager Self-Service which validates the transaction and after being approved by the defined approval process, inserts the transaction into Job data through a custom component interface.
• Developed data conversion SQR to convert data from the existing reported time staging table to TL RPTD TIME table.
• Prepared detailed Functional and Technical Design Documents, which are being used as a template to onboard other State Agencies on to this State wide ERP implementation.
• Led meeting with business stakeholders in gathering requirements and developed rules for Time Admin Process.
• Prepared development, documentation and accessibility standards for the team.
• Lead teams of developers working as both Functional and Technical lead for different modules.
• Mentored developers working on the project; presented development, accessibility standards to ensure all the Manager Self-Service and Employee Self-Service pages meet the client requirements.
• Prepared and presented to other State agencies to consolidate all legacy systems into a centralized ERP implementation for Confidential .
• Prepared User Documentation and Online Help using Authoria.

Environment: PeopleSoft HCM 9.1, PeopleTools 8.51, PL/SQL, Quest Toad, Oracle 11g.

PeopleSoft Section 508 Compliance Specialist

Confidential, Washington, DC

Responsibilities:

• Identified current Accessibility/Section 508 compliance issues with deployed PeopleSoft HCM 9.1 pages by navigating all the end-user accessed pages and using JAWS software.
• Worked on remediation of pages with headers, tab order, color contrast, grid labels and Image tags to meet 508 compliance and readability with JAWS screen reader.
• Worked with Oracle to fix issues with grids to read both column and row name in Accessibility mode on Employee Time Sheet and Manager Approve Time Page.
• Developed documents outlining Section 508 Compliance best practices, development standards and testing guidelines which can be used for any future enhancements to the PeopleSoft system.

Environment: PeopleSoft HCM 9.1, PeopleTools 8.51, SQL Developer, Oracle 11g.

PeopleSoft Techno-Functional Consultant

Confidential, Austin, TX

Responsibilities:

• Implemented a custom Time & Labor Consolidated Time Sheet (CTS). CTS enhancement enables employees/managers to enter, approve/deny reported time for 31 days and view leave balances on the same page. This enhancement has over 150 online edits to validate user input thereby preventing Time Admin exceptions.
• Implemented custom SQR process to synchronize the custom reported time record and delivered TL RPTD ELPTIME record.
• Developed SQR to Automate the Time & Labor Enrollment process when an Employee is hired/rehired into HR module.
• Redesigned SPRS (State Payroll Reporting System) Application Engine to process and report Pay-impacting transactions from the Audit records to the State Comptroller Office.
• Implemented custom e-Performance module with complete lifecycle from generation of Employee Performance Plan to finalizing by the employee’s second level manager.
• Created a custom workflow process to handle events trigger for the e-performance self-service module.
• Analyzed and developed fiscal year-end conversion process to comply with State regulations, position reorganization/reclassification including pay raises, closing leaving balances, etc.,
• Involved in integrating existing third party recruiting application (Recruitmax/Vurv) with PeopleSoft HRMS applications using Component interface.
• Developed Payroll process to create pay sheets and load pay lines for Off-Cycle payroll generation to refund/adjust employee Benefits with the ERS benefits reconciliation file. The process included data validation, calculation of employee pay, confirmation of payroll information, and payment distribution. The process is complete when the employee receives compensation either by check or direct deposit.
• Worked with DBA team and testing team in archiving tables and rebuilding indexes to improve performance of Time Admin and Pay Calc Process.
• Performed intensive User-Acceptance Testing and Peer-Review Testing. Carried out performance-level testing, minimizing time-taken for running processes.
• Worked on security administration creating roles, permission lists and users for various modules that were added.
• Provided technical support, on-call support for troubleshooting failed programs, processes and weekly migrations for all modules.
• Documented Project, which includes Functional specification, Technical design, and User guide detailing customizations for project maintenance.
• Prepared training guides with screenshots for the better understanding of the end users.

Environment: PeopleSoft HRMS 8.3, People Tools 8.22, Quest Toad, Oracle 10g

PeopleSoft Consultant

Confidential, Chantilly, VA

Responsibilities:

• Performed Fit Gap analysis and analyzed client’s legacy system (Personal Payroll System) for implementing Time and Labor module.
• Led meetings with functional users and functional analysts and designed Functional specification and User documentation for Time and Labor rules.
• Worked with functional users to develop Time periods, Holiday Schedules and Calendars in Production environment. Created TRC (Time Reporting Codes) and TRC Programs.
• Involved in designing and creating Workgroups. Developed workgroups by categorizing employees by their duties and unions.
• Involved in designing and developing Rule Programs. Prioritized Rules in Rule Programs and attached Rule Programs to the related workgroups.
• Created new SQL objects for rules. Modified PeopleSoft SQL objects according to user requirements.
• Designed and developed Rules. Modified PeopleSoft rules, Template20, Template21, and DFLTTRC according to user requirements.
• Developed 32 rules, which are, Threshold Rules (Period and Daily), Exceptions (Holiday and Over Time) and Holiday calculation rules for different departments according to their union agreements with County of Fairfax.
• Assisted functional users in enrollment of time reporters in development and test environments. Worked to fix bugs after time reporter’s data conversion from legacy to PeopleSoft.
• Worked with technical team to develop Costing interface and General Ledger interface to load TL PAYABLE TIME data.
• Trained functional users to create rule variations, rule types, fixing exceptions and understanding Time Administration process.
• Coordinated development of data mover scripts to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.
• Developed Time and Labor security. Defined dynamic groups with combination of multiple workgroups for Time Administration process.
• Worked with functional team and testing team in System Test, User Acceptance Test and Parallel Test for Time and Labor.
• Prepared documentation and worked with client team for knowledge transfer.

Environment: PeopleSoft HRMS 8.8, PeopleTools 8.42, Oracle 9i, Windows 2000

Computer Info. Specialist/Graduate Student

Confidential, Manhattan, KS

Responsibilities:

• Designed and regularly updated the OEIE, ESL office website using ASP, Jscript, Flash, CSS and HTML.
• Interacted with clients to determine specifications and developed software based on those specifications.
• Executed deadline driven projects leading a team of 6 student programmers.
• Developed eZ Video Rental Library an online video rental service for renting and reserving Video media.
• Designed the User Interface using HTML, JSP and JavaScript
• Installed SSL Certificate for secure transaction processing, other notable feature include search engine which uses dynamically generated XML to display results
• Designed and implemented a Purchase Order Financial System using Java Data Objects (JDO) to study the feasibility of JDO for cross-platform web applications.
• JDO was used for transparent, automatic read, write, querying of Data objects instead of JDBC and SQL queries.
• The results showed that the response time from database was much faster than that of JDBC and it enables cross platform porting of web based applications without any changes.

Environment: J2EE Application Server, Java Data Objects(JDO), JSP, Oracle 9i, MySQL, IIS Web server, ASP, Jscript, CSS, HTML, PHP, CGI/Perl.

Confidential

Responsibilities:

• Developed data conversion scripts to convert the data from the legacy system to PeopleSoft HR tables such as Personal Data, Job Data, Employment Data and Payroll tables such as General Deduction & General Deduction code and Benefit related tables.
• Created import definitions for PeopleSoft Import Manager to convert legacy system data into PeopleSoft tables such as Garn Payee table, Garn Spec tables.
• Was involved in writing SQRs to convert the legacy data into PeopleSoft Core tables for Direct Deposit, Savings Bonds, Earnings, Taxes and their balances and was involved in testing of these SQRs and the data that was converted into the PeopleSoft tables.
• Was involved in designing & development of issues Tracking System using Workflow Administrator.
• Was involved in writing functional and technical documentation for Geneva interface, Hewitt interface, US member firm partner tax, FLS interface etc.,
• Was involved in writing/ modification of code for various input and output interfaces.
• Used Process Scheduler to attach the SQRs at the front end.
• Was involved in developing unit test scripts, Test plans, Test data and Unit Test Conditions.
• Was involved in documentation of the SQRs and the Conversion process.
• Redesigned all existing reports using SQR, Query, and Crystal Reports.
• Conducting technical discussions with the end users for generating Business Critical Queries, Elective Queries using PS/Query.

Environment: PeopleSoft 8.0, People Tools 8.14, SQL Server 2000 and UNIX