SUMMARY

• Above 9 years of experience in Requirement Gathering, Analysis, Design, Development, New Implementations, Customizations and Testing of Applications in PeopleSoft HCM v 8.8/9.0/9.1/9.2 .
• Expertise in Technical role and Good Functional understanding during Application Development, Implementations, Reports development, Data Conversion, Migrations, Production support, Scheduling and Performance tuning.
• Lead 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 of Absence Management Tracking System (AMTS) a custom module 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 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, Configuration Manager, Process Monitor, Application Package, Workflow, PeopleSoft portal and Utilities(SQL Trace and People Code trace).
• 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 knowledge in PeopleSoft Internet Architecture and its components.
• Experience in PeopleSoft HRMS security wif knowledge 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

Enterprise Applications: PeopleSoft HCM 8.x HR, Absence Management Tracking System, Employee Self Service, Manager Self Service

People Tools: Application Designer, PeopleCode, Process Scheduler, Application Engine, File Layout, Component Interface, Data mover, Configuration Manager, Workflow, Data Mover

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

Consultant System

Responsibilities:

• Understanding the legacy system in dominos and prepared fit gap analysis and design documents.
• 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 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 2 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 and load data into people soft tables.
• Using Application Engine for performing background SQL processing against the database.
• Design, develop and implemented Short Term Disability (STD) custom process for all non management employees.
• 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 .

Confidential

Project Lead/ Consultant System-Dev

Responsibilities:

• Lead a team on 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 effectively 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.

Confidential

Consultant System-Dev

Responsibilities:

• Developed and implemented an application for Reporting Tardiness.
• Worked on SQR’s to create new reports for Employees tardiness.
• Partnered wif the key project stakeholders including Business Team, Integration team and IT development teams to define project scope, develop/refine project schedule and develop overall project plan.
• Developed components and pages to check the Employee information about his attendance score card, Attendance history and discussions held by their supervisor and employee.
• Created new online screens for documenting the tardy discussions held between the supervisors and their direct reports.
• Tailored peoplecode to integrate the tardy discipline logic for Attendance Control Plan into the discussion documentation components.
• Designed and developed SQR program to load the Time data into the peoplesoft system and calculate the FMLA balances.
• Worked on Application Designer in developing Run control pages and Menu customizations.
• Developed Application engine programs to send emails to supervisors.
• Implemented custom security by creating different roles and permission lists.

Confidential

Project Lead/ Consultant System-Dev

Responsibilities:

• As a 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.

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.

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.

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.

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 Confidential system and calculate the eligibilities and exemptions.
• Created online screens to correct the data feed sent by the payroll system.

Confidential

Analyst

Responsibilities:

• Retooled the whole Confidential 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 Confidential system available for all wireline associates also.

Environment: PeopleSoft HRMS v9.x, 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 Confidential 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 Confidential system.
• Developed FMLA Compliance Reports using SQR’s and Crystals.

Environment: PeopleSoft HRMS v8.8, DB2.

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 HRMS v8.8, People Tools, SQR, PS Query, MS SQL-Server.