SUMMARY

• Total SEVEN+ years of information technology experience, expertise in Designing, Developing, Implementing, Customizing, Upgrading, Testing, Enhancement and Production Support of PeopleSoft HRMS/HCM Applications.
• Techno Functional expertise in PeopleSoft HR, NA Payroll, Base Benefits, Automated Benefits, Self Service and Manager Self Service modules.
• Extensive User Interaction working with cross - functional users and with various teams in the organization.
• Extensive experience proposing multiple solutions to various business requirements and explaining technical alternatives to non-technical users.
• Extensive Fit-Gap Analysis, Business Analysis, System Design and Programming experience.
• Hands on experience working all the major tools and technologies within the context of PeopleSoft - Peopletools, Peoplecode, Integration Broker, Application Engine, Workflow, SQR, Component Interface, XML Publisher, etc.
• Expertise in PeopleSoft Projects Migrations between lower life cycles and production environments. Experience in taking backup of PeopleSoft projects during data refresh and upgrades.
• Strong knowledge of PIA (PeopleSoft Internet Architecture) - Application Server, Web Server & Process Scheduler Server.
• Extensive experience in Conversion, Upgrades & New Implementations.
• Strong problem solving and troubleshooting skills, highly motivated and ability to work as an individual and also as a dynamic member in a team.
• Industrious, self-motivated and a great team player, ready to embark on challenging tasks.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS 8.x/9.0

Tools: Application Engine, PeopleSoft Upgrade, Process Scheduler, PeopleSoft Workflow, Component Interfaces, PeopleCode, File layouts, PSQuery, PS nVision, OBIEE

Languages: PeopleCode, SQL, PL/SQL, Java, JavaScript, HTML, XML, SQR, C,C++

Databases: Oracle 8i,Oracle 9i,Oracle 10g & 11g, Sybase, Ms-SQL Server, MS Access

Operating System: UNIX (AIX, HP), Sun-Os, MS DOS, Windows-2000/NT/XP

Web Server: IIS, Apache, Web Logic, Web sphere

QA tools: Bugzilla.

Reporting Tools: Toad for Oracle (Quest), Crystal Reports for PeopleSoft

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

PeopleSoft Sr. Consultant

Responsibilities:

• Onboarding Project
• Developed Two way Integration using Integration Broker Messaging to load applicant information.
• Customized Manager Self Service Pages.
• Developed component Interfaces to load Person Profile, Direct Deposit and W4 into the HRMS system.
• Developed MSS reports.
• Global Benefits Redesign Project
• Developed Interface file to send Benefits eligibility data to Vebnet.
• Customized Benefits Self Service Pages for UK Employees.
• Customized Time and Labor pages for UK Employees.
• Developed a module to track Eligibility for Fuel Allowance and Car Allowance.
• Developed Non-Discrimination Test Interface file to Towers Watson.
• Provided production support to fix the production issues.
• Developed Adhoc reports using PSQUERY.
• Developed Test Plans and Test cases/Scenarios for all the newly developed Reports/Processes, Customizations and Modifications.

Confidential, Washington DC

PeopleSoft Sr. Consultant

Responsibilities:

• Responsible for Project Deliverables, New Enhancements and Production Support.
• Designed and Developed a module for tracking employee Wellness Behaviors and implement Healthy Premium Surcharge Deductions. Created a Inbound Interface using Application Engine to load employee behavior data from Aetna, Developed Panels and SQR reports to setup rules, track and administer employee wellness details, Used Workflow for communication. Developed process to load Surcharges to General deduction using App Engine and Component Interface.
• Developed many inbound and outbound Interfaces using SQR and Application Engine (Prudential LTD benefits, Cigna Medical, ElementK Learning Management, and WageWorks Transit Benefits).
• Developed Application Engine and Component Interfaces to Load Transfers between Affiliates and Mass Terminations.
• Supported Open Enrollment 2010 and 2011. Modified Self Service pages, Created OE census reports, Created Data Mover scripts to migrate setup data.
• Added online validations for Time & Labor, resolved production issues.
• Developed many Payroll, HR and Benefit Reports Using SQR, Application Engine and XML Publisher.
• Developed Security Audit Reports Using SQR and PSQUERY for SOX compliance.
• Resolved production support issues, Created SQL scripts to apply data patches.
• Implemented Google Analytics using JavaScript and HTML Objects on Self Service pages to get a better sense of usage.
• Worked with the users to deliver adhoc data/report requests.
• Worked extensively on Workflow, Application Packages, PeopleCode, Application Engine and Portal Security.
• Developed Test Plans and Test Cases/Scenarios for all the newly developed Reports/Processes, Customizations and Modifications.
• Prepared Technical Design Documents, Interface Support Documents.

Environment: PeopleSoft HRMS 9.0, Oracle 9i, PeopleTools 8.48, Oracle 10g.

Confidential, Washington DC

PeopleSoft Consultant

Responsibilities:

• Analyzed current business process and Automated the calculation, Approval and Payment of Installation Settling-In and Termination Grants for Executive Directors through Payroll using Application Engine, Workflow.
• Analyzed Staff rules coordinated with cross-functional and developed a Self-Service module for Staff Receivables and Loan Applications and automated the approval, disbursement and payroll deductions for loans. Prepared Test cases for various types of loans.
• Developed a module to administer Special MBP medical enrollments and deductions through PeopleSoft Payroll for country offices using Component Interface and Application Engine.
• Designed and Developed many complex self-service pages for staff to input rmation like Form70, Safety Net, Tax Calculation Details, Overseas Details.
• Implemented Tax law changes under very tight Timelines.
• Developed SQR Programs to Annualize Payroll earnings, calculate W2 and 1099 earnings.
• Provided production support. Proactively identified and resolved potential issues.
• Analyzed discrepancies and troubleshoot various payroll issues including Retros. Provided on-demand ad-hoc reports and Analytical data for various users.
• Customized Manager Self Service and HR Job Actions.
• Proposed and Designed Workflow/Batch Workflow for many modules using PeopleSoft Workflow, Component Interfaces and Application Engine to streamline the work of the Tax Business Unit.
• Testing of Batch Programs, Online objects and preparing test cases based on the Technical Design Specification Document.
• Modifying/Fixing code for the issues identified as part of Product/System test.

Environment: PeopleSoft HRMS 8.8, People Tools 8.46 and 8.49; UNIX, NT; Oracle 10g, SQR, PL/SQL

Confidential, NY

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the Analysis, Design and Development of PeopleSoft Benefits and Payroll System using PeopleSoft 8.x, SQR and Oracle 8i.
• Participated in the Implementation of Benefits Consolidation Process of Corporate Confidential with subsidiaries like Madison Square Garden, The Wiz and Rainbow.
• Coordinated with functional users and technical staff across subsidiaries.
• Developed adhoc reports, Analyzed various Benefit Plans and Benefit Programs offered by subsidiaries and parent company to identify commonalities and differences.
• Created new Vendors, Benefit Programs, Benefit Plans, and Deduction Codes. Created data Mover Scripts to migrate setup data to Production environment. Prepared the technical design documents for the consolidation process
• Customized e-Benefits Enrollment Forms. Developed Application Engine programs, Component Interfaces and Workflow to update staff Eligibility, to E-Mail confirmation forms. Developed vendor interface files.
• Developed new Employee Feed Back Reports based on the business need.
• Scheduling processes and reports through Process scheduler.
• Involved in setting up of new run control pages, components, menus and processes for the same module.
• Developed programs to load employee elections into the Benefit Tables.
• Developed SQR processes to load data into General Deduction and Additional Pay Data tables.
• Developed Interface files for sending Benefits Information like FSA, and 401k.
• Provided production support for Payroll Run after the Benefit Data loads, fixed payroll problems.
• Prepared Technical Documentation and test case reports.
• Coordination with Project Lead on daily status and maintenance.
• Performed Unit testing and prepared UTP.

Confidential, New York

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the Upgrade of PeopleSoft version 8,3 to version 8.9
• Reviewed compare reports and analyzing the disposition to keep vanilla or to keep custom or reapplying the customizations.
• Participated in the Retrofit development per prior customizations.
• Developed new security configuration after Analyzing current security configuration and functional roles of users. Created new permission lists and roles.
• Developed many components for the implementation of Automated Benefits. Customized e-Benefits Enrollment Forms. Developed Application Engine programs, Component Interfaces and Workflow to update staff Eligibility, to E-Mail confirmation forms. Developed vendor interface files.
• Developed complex PeopleSoft pages for Compensation Planning. Developed application engine program for fund allocation.
• Developed various custom modules like Service s, Hardship Loans and other customizations using Application Designer, PeopleCode and SQR.
• Developed outbound 401K Interface file for Vanguard.
• Unit/System Testing of Universal Reports.
• Worked extensively on Payroll, Compensation and Benefit modules. Developed SQR reports and resolved production issues.

Confidential, Minneapolis, MN

PeopleSoft Technical Consultant

Responsibilities:

• Developed custom processes for Annual Merit Increase module. Created Application Engine Programs to calculate estimated Pay Increases by employees and departments, extensively used Workflow for approval process.
• Developed conversion programs to convert HR data to a new Career Path model. Created New Job Functions, Job families, Positions and Job codes to implement the Career Path Model.
• Developed New Menu, Components, Workflow Activities, Workflow configurations, pages, Records, Portal Registry, Creating new Roles & Permissions and new SQRs
• Modified/Customized Application Engine Processes/Interfaces, SQR Processes/Interfaces /Reports, People code, Components, Pages, Records and other PS objects.
• Involved in setting up of new run control records, pages, components, menus and processes for a new Business unit.
• Migration of objects/projects from between environments.
• Unit/System Testing of Reports Interfaces and Online objects.
• Prepared Technical Specification Document, Test Case Document and Solution Outline Documents.
• Resolved production support issues assigned through Team Track.

Confidential

Software Engineer

Responsibilities:

• Analyzed the requirements and prepared a high level design document that includes analysis of the existing multiple sources of databases.
• Wrote several stored procedures/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Worked on very large database environment in terabytes and tuned queries for performance. Created and maintained parallel queries for very large datasets.
• Creating temporary tables and indexes for loading and updating data.
• Data loading using SQL *Loader.
• Imported/exported several databases through various environments.
• Writing and modifying stored procedures, complex queries.
• Created Test Cases to validate the functionality.
• Performed integration testing, regression testing, functionality testing, and System testing,
• Performed performance testing and stress testing for services module.
• Documented and tracked test results, test analysis, and reported the defects.

Environment: C# .Net, HTML, SQL, ASP, Bugzilla.