SUMMARY

• Above 9.4 years of experience as a Project Lead/Senior PeopleSoft Consultant in Requirement Gathering, Analysis, Design, Development, New Implementations, Customizations, Upgrading and Testing of Applications in PeopleSoft HCM v 8.8/9.0/9.1/9.2 and FSCM v9.1.
• Expertise in Technical role and Good Functional understanding during Application Development, Implementations, Upgrade, Reports development, Data Conversion, Migrations, Production support, Scheduling, Web services and Performance tuning.
• Worked as a Lead for different teams during Application Development and guided teh team to achieve Business functionality.
• Demonstrated excellent Technical and Leadership skills on numerous projects by coordinating wif teh onsite and offshore resources, creating documentation, developing solutions and design, performing technical control and testing of delivered work, keeping track on project progress, leading meetings and conference calls.
• Proven track of record on all stages of System Development Lifecycle and object - oriented analysis, and programming methods.
• Handled End-to-End implementation, upgrade of Absence Management, Benefits modules in PeopleSoft HCM for Confidential USA.
• Performed Fit-gap analysis and Created functional requirements as an input to application design.
• Performed full-lifecycle Implementations wif emphasis on design, customization and production support.
• Experienced in PeopleSoft HCM requirement analysis, technical design, implementation methodologies, conversion/interface strategies, data mapping, development, customization, tuning, and issue resolution.
• Extensive experience on PeopleTools like Application Designer, Peoplecode, Application Engine, Component Interface, PS Security, Process Scheduler, PS/Query, Data Mover, Import Manager, Application Messaging, Web Services, Configuration Manager, Process Monitor, Application Package, Workflow, AWE, Application Packages, Integration, PeopleSoft portal and Utilities (SQL Trace and People Code trace), STAT.
• Help all business users achieve maximum utilization of teh PeopleSoft system capabilities to achieve process improvements, identifying and communicating opportunities for automation.
• Good hands on experience in trouble shooting teh problems and improving teh performance of application processes by Debugging, tuning and tracing.
• Strong SQL development skills using multiple joins, multiple unions, and sub queries.
• Excellent report-generating skills using PS/Query, SQR, Crystal Reports and XML Publisher.
• Trained employees at different levels in People Tools, SQR, design and development process.
• Good noledge in PeopleSoft Internet Architecture and its components.
• Experience in PeopleSoft HCM security wif noledge of profiles, roles, permissions and portal structure/registry, password controls, query security and tree management.
• Energetic, enthusiastic, self motivated person wif good communication skills, strong problem solving and analytical skills, accustomed to work in a team environment wif tight schedules and capable of working efficiently under pressure.
• Quick learner wif an ability to rapidly achieve organizational integration, assimilate job and employ new ideas, concepts and methods.

TECHNICAL SKILLS

ERP: PeopleSoft HCM v 8.8/9.0/9.1/9.2 , FSCM v9.1.

Enterprise Applications: PeopleSoft HCM HR, Absence Management, Employee Self Service, Manager Self Service, Benefits

People Tools: People tools v8.4x, 8.5x, Application Designer, Peoplecode, Process Scheduler, Application Engine, File Layout, Component Interface, Data mover, Configuration Manager, Workflow, Data Mover, Web Services, Application Packages

Administration Tools: Security Administration, Object Security

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

Debugging Skills: Peoplecode, Application Engine and SQR.

Database: Oracle, DB2, MS SQL Server.

Languages: SQR, SQL, PL/SQL, HTML

Web & GUI Tools: XML, HTML, JavaScript

Tools: STAT, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Project Lead/ Consultant System-Dev

Responsibilities:

• Understanding teh legacy system in dominos and prepared fit gap analysis and design documents to retrofit and upgrade teh application in Peoplesoft HCM 9.2.
• Translated design and GUI requirements into portal branding rules, including PeopleSoft style sheet creation role-based branding, templates, and themes.
• Worked alongside of business analysts and testers to communicate capabilities and limitations of PeopleSoft HCM Enterprise portal technology (as SME).
• Designed PeopleSoft Security using Security by Row Level Security, Roles & Permission lists
• Involved in creating new User profile, Roles and Permission list according to teh business requirements to access certain pages.
• Implemented online peoplecode to eliminate batch programs between teh systems and reduced teh wait time.
• Responsible for teh Data mapping, Data Conversion and Data Loading into people soft tables and preparing conversion reports using SQR, Component Interfaces and load data into people soft tables.
• Using Application Engine for performing background SQL processing against teh database.
• Created Interface between Absence and Time System to report employees who has medical and FMLA time reporting codes.
• Design, develop and implemented Short Term Disability (STD) custom process for all non management employees.
• Extensively worked on XML Publisher for Repots and generating Medical letters.
• Designed and developed peoplecode and application engine programs to send emails wif PDF attachments to teh administrators.
• Created XML files and generated XML publisher reports for FMLA Letters.
• Fixed modal window issue for all Secondary pages and updated queries, views and label changes after people tools upgrade from .

Environment: PeopleSoft HCM v9.2, People tools 8.53, Oracle.

Confidential

Project Lead/ Consultant System-Dev

Responsibilities:

• Lead a team on Peoplesoft HCM Absence - 4 Day Exempt and 10 Day Cap projects.
• Served as a business and technical advisor, employed best practices and project management methodology to guide team to TEMPeffectively use teh solution to meet business requirements and ensure member satisfaction
• Conduct Conference Room Pilots and demos on New design and implementations
• Create Master Test Plan and Test cases for UAT and coordinate teh UAT wif Business users.
• Act as Liaison between HR users and Technical team.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation. Provided production support and functionality enhancements to improve HR and Payroll efficiencies.
• Provide status reports to higher management and made sure project timelines are met.
• Initiated Daily calls to discuss project direction, scope changes, and other issues.
• Tailored online peoplecode to provide exemptions for employees who are wifin teh eligible Labor agreements for wire line associates of Confidential USA.
• Developed new SQR program to implement teh 4 day and 10 day Attendance exemption for New York employees and generate reports.
• Developed Application engine programs to find teh discrepancies between teh PeopleSoft and third party system and send emails and reminders to teh supervisors and absence administrators.

Environment: PeopleSoft HCM v9.1, People tools 8.52/8.53, Oracle.

Confidential

Consultant System-Dev

Responsibilities:

• Compared objects between source and target databases to identify objects for retrofitting as per teh requirement
• Identified all customized interfaces, reports and queries, prepared design documents to list teh impact of teh upgrade on these programs, and identified parts of teh program dat needs to be altered
• Developed, retrofitted and customized SQR and online PeopleSoft objects and security definitions as per teh Business requirement.
• Performed Unit testing for all retrofitted objects and documented teh changes.
• Performed Customization on Online pages in Travel and Expense Module for all international employees of Confidential .
• Developed workflow for teh approval process in Travel and Expense modules.
• Developed Inbound and Outbound Application Engine programs using file layout to upload Vouchers into PeopleSoft system.
• Performed Complex End to End testing in Accounts Payable and Accounts Receivables Modules during system testing.
• Worked on Application Designer in developing Run control pages and Menu customizations.

Environment: PeopleSoft FSCM v9.1, People tools 8.53, Oracle.

Confidential

Project Lead/ Consultant System-Dev

Responsibilities:

• As an Implementation Lead, managed teh team in design and development activities for Attendance Control Plan project to meet client requirements.
• Involved in discussion wif Onshore and clients and created Technical designs.
• Developed Application Engine programs to send emails and reminders to complete teh disciplinary actions.
• Worked on teh Details designs and development for Workplace accommodations.
• Created and customized new pages, records, fields and components through Application designer.
• Worked wif Process Scheduler, Process Monitor, Edited Run Control, Granting security access and scheduled programs on recurring basis.
• Customized and created new message catalog information according to teh business requirement.

Environment: PeopleSoft HCM v9.1, People tools 8.52, Oracle.

Confidential

Consultant System-Dev

Responsibilities:

• Involved in User discussions to understand teh overall requirements of teh various Labor Unions and participated in creation of BRD.
• Travelled onshore to directly interact wif teh Business users in order to understand teh requirements first hand.
• Involved in creation of Functional flow diagrams and created Technical Designs.
• Initiated walkthroughs of teh application wif teh users to reduce teh manual work and automate teh process.
• Created data conversion programs to load data from teh legacy system.
• Develop custom reports utilizing XML, SQR, and File Layout wif Application Engine.
• Involved in detail design, development, testing, conversions and modifications of teh application as per teh client requirement.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing teh Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both teh systems.

Environment: PeopleSoft HCM v9.1, People tools 8.52, Oracle.

Confidential

Consultant System-Dev

Responsibilities:

• Extensively worked on peoplesoft objects to delegate access and created dynamic views for search records.
• Worked on Peoplesoft security to create new custom roles and assign teh roles dynamically through batch process.
• Worked directly wif business users to develop enhancements to business processes to improve teh employee experience when using teh self-service application; resulted in a reduction in support staff.
• Developed and customized new pages, records, fields and components through Application designer.
• Created SQR to grant Absence supervisor roles to teh supervisors wif associate’s as direct reports.
• Developed online pages for Absence supervisors to delegate access to Administrator, Cross Coverage and Executive roles.

Environment: PeopleSoft HCM v9.x, People tools 8.5x, Oracle.

Confidential

Specialist System-Dev

Responsibilities:

• Involved in Technical Gap analysis wif functional team for ONE-HR system.
• Modified teh existing system to accommodate teh application into ONE-HR.
• Involved in retrofitting teh application into dashboards to make teh application user friendly and make it easier for teh users to access.

Environment: PeopleSoft HCM v9.x, People tools 8.5x, Oracle.

Confidential

Specialist System-Dev

Responsibilities:

• Involved in Requirement gathering and designs of FMLA Frequency and Duration and Short Term Disability automation projects.
• Created batch (SQR) process to automate teh STD process which inserts teh STD data sent by external system into Absence tables on a daily basis and worked on process scheduler to schedule jobs.
• Researched and delivered printer friendly options for custom PeopleSoft pages.
• Created Application Engine programs to send data to external Dominos systems.
• Developed batch programs to update teh approvals sent by teh Absence Reporting Center (Dominos) and update teh absences and track teh balances and eligibilities.
• Developed new application to change teh existing system and make it more users friendly and efficient.
• Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed batch process to load teh payroll time data into teh AMTS system and calculate teh eligibilities and exemptions.
• Created online screens to correct teh data feed sent by teh payroll system.

Environment: PeopleSoft HCM v9.x, People tools 8.5x, Oracle.

Confidential

Analyst

Responsibilities:

• Retooled and upgraded teh whole Peoplesoft HCM AMTS application from DB2 environment to Oracle Environment.
• Retrofitted custom SQRs and Application Engine programs so as to ensure they successfully run in teh new environment.
• Developed and created online objects, Batch programs and reports to retool teh application from DB2 formats to Oracle format.
• Extensively worked online peoplecode, Application Engine programs and SQR’s and created online objects to achieve teh exact business requirement.
• Developed Style sheets and java script to improve teh look and feel of teh application.
• Worked closely wif teh clients and system users to achieve teh exact requirement and functionality.
• Efficiently Handled and resolved teh data conversion issues
• Detailed impact analysis was done to identify teh objects, compared between old and new model to retro fit. All customized objects were identified, exported and migrated.
• Involved in user meetings and technical discussions wif teh onsite counterpart to develop and deliver teh application which meets teh user expectations.
• Worked on WLI (Wire Line Integration) project to make teh AMTS system available for all wireline associates also.

Environment: PeopleSoft HCM v8.8/9.0, People tools 8.4x,DB2, Oracle.

Confidential

Analyst

Responsibilities:

• Worked on AMTS (Absence Management Tracking System) Production support and Enhancements.
• Providing technical support for teh existing application and was responsible for Analysis, Troubleshooting and Problem Resolution.
• Cleaned up all objects from SYSAUDIT and performing analysis for objects such as menu, menu groups, panel groups, panels, records and fields, People Code and reviewing all custom batch processes such as SQR, AE and prepare document for all re-mapping.
• Monitored and tuned scripts to achieve optimum performance levels.
• Provide support by troubleshooting and fine tuning performance issues related to PeopleSoft batch programs.
• Worked wif teh clients to understand teh functionality to resolve teh issues.
• Involved in providing teh estimation on work effort for teh new Enhancements.
• Enhanced SQL’s and Views to improve teh performance of teh System.
• Created AMTS application reports using PS Query and Crystal Reports.
• Worked on teh new enhancements for FMLA Compliance including technical design documentation, development and Unit testing and Production Support.
• Solely worked on FMLA Compliance Enhancements like creating new objects for state law eligibility, Flu symptoms, Time data and Absence status correction.
• Created new objects for creating FMLA certification only for West employees wifin teh AMTS system.
• Developed FMLA Compliance Reports using SQR’s and Crystals.

Environment: PeopleSoft HCM v8.x/9.x, People tools 8.4x/8.5x,DB2, Oracle.

Confidential

Associate IT Consultant

Responsibilities:

• Worked on PS Query to achieve teh Business Functionality for Employee and Manager Self Service.
• Developed Reports for Jubilee, Birthday, using PS Query.
• Customized and created SQR reports and creating Views for Compensation History Details and for Northern Irish Reports. Was sole responsible for Northern Irish Reports which is one of teh biggest assignment
• Conducted system and unit quality assurance testing. Created program and system workflow documentation.
• Customized/created new Views, Pages, Components, and Records for achieving teh requirement.
• Tailoring Peoplecode from Compensation History.
• Involved in creating Technical Design Documents and Unit Testing of teh Applications developed to meet teh Business Requirement.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing teh Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both teh systems.
• Involved in client meetings to understand and propose Business Requirements and enhancements to be done to meet teh Functionality.

Environment: PeopleSoft HCM v8.8, People Tools 8.4x, SQR, PS Query, MS SQL-Server.