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 the team to achieve Business functionality.
• Demonstrated excellent Technical and Leadership skills on numerous projects by coordinating wif the 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 the PeopleSoft system capabilities to achieve process improvements, identifying and communicating opportunities for automation.
• Good hands on experience in trouble shooting the problems and improving the 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 the legacy system in dominos and prepared fit gap analysis and design documents to retrofit and upgrade the 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 the business requirements to access certain pages.
• Implemented online peoplecode to eliminate batch programs between the systems and reduced the wait time.
• Responsible for the 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 the database.
• Created Interface between Absence and Time System to report employees who have 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 the 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 the 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 the 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 the eligible Labor agreements for wire line associates of Confidential USA.
• Developed new SQR program to implement the 4 day and 10 day Attendance exemption for New York employees and generate reports.
• Developed Application engine programs to find the discrepancies between the PeopleSoft and third party system and send emails and reminders to the 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 the requirement
• Identified all customized interfaces, reports and queries, prepared design documents to list the impact of the upgrade on these programs, and identified parts of the program dat needs to be altered
• Developed, retrofitted and customized SQR and online PeopleSoft objects and security definitions as per the Business requirement.
• Performed Unit testing for all retrofitted objects and documented the changes.
• Performed Customization on Online pages in Travel and Expense Module for all international employees of Confidential .
• Developed workflow for the 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 the 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 the disciplinary actions.
• Worked on the 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 the business requirement.

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

Confidential

Consultant System-Dev

Responsibilities:

• Involved in User discussions to understand the overall requirements of the various Labor Unions and participated in creation of BRD.
• Travelled onshore to directly interact wif the Business users in order to understand the requirements first hand.
• Involved in creation of Functional flow diagrams and created Technical Designs.
• Initiated walkthroughs of the application wif the users to reduce the manual work and automate the process.
• Created data conversion programs to load data from the legacy system.
• Develop custom reports utilizing XML, SQR, and File Layout wif Application Engine.
• Involved in detail design, development, testing, conversions and modifications of the application as per the client requirement.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both the 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 the roles dynamically through batch process.
• Worked directly wif business users to develop enhancements to business processes to improve the employee experience when using the 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 the 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 the existing system to accommodate the application into ONE-HR.
• Involved in retrofitting the application into dashboards to make the application user friendly and make it easier for the 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 the STD process which inserts the 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 the approvals sent by the Absence Reporting Center (Dominos) and update the absences and track the balances and eligibilities.
• Developed new application to change the 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 the payroll time data into the AMTS system and calculate the eligibilities and exemptions.
• Created online screens to correct the data feed sent by the payroll system.

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

Confidential

Analyst

Responsibilities:

• Retooled and upgraded the 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 the new environment.
• Developed and created online objects, Batch programs and reports to retool the application from DB2 formats to Oracle format.
• Extensively worked online peoplecode, Application Engine programs and SQR’s and created online objects to achieve the exact business requirement.
• Developed Style sheets and java script to improve the look and feel of the application.
• Worked closely wif the clients and system users to achieve the exact requirement and functionality.
• Efficiently Handled and resolved the data conversion issues
• Detailed impact analysis was done to identify the 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 the onsite counterpart to develop and deliver the application which meets the user expectations.
• Worked on WLI (Wire Line Integration) project to make the 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 the 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 the clients to understand the functionality to resolve the issues.
• Involved in providing the estimation on work effort for the new Enhancements.
• Enhanced SQL’s and Views to improve the performance of the System.
• Created AMTS application reports using PS Query and Crystal Reports.
• Worked on the 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 the 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 the 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 the 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 the requirement.
• Tailoring Peoplecode from Compensation History.
• Involved in creating Technical Design Documents and Unit Testing of the Applications developed to meet the Business Requirement.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both the systems.
• Involved in client meetings to understand and propose Business Requirements and enhancements to be done to meet the Functionality.

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