PROFESSIONAL SUMMARY:

• Over 8 year of professional experience in full life cycle system development involving analysis, design development, testing, documentation, implementation & maintenance of application software in PeopleSoft HRMS and HCM.
• Proficiency in upgrade, Development & maintenance of PeopleSoft Application and good understanding of software development life cycle (SDLC).
• Design, develop, test and maintain software to support the PeopleSoft HRMS and HCM (Core HR, NA Payroll, e - recruit, e-Competency,e-Performance, UK Payroll,Workforce admin, Self Service, Benefits Administration and base benefit), PeopleSoft elm and Bolton modules in PeopleSoft created from scratch
• Hands on Experience on PeopleSoft Development Tools like Application Designer, Process Scheduler, Workflow, Component Interface, Application Package, People Tools, PeopleCode, SQR, Application Engine, PS Query, XML Publisher report, File Layout, Integration Broker, Application Workflow Engine, Data conversion and Data Mover, Attachment framework, Tree Manager, PeopleSoft Roles and Security, PeopleSoft Test framework, Configuration Manager,Excel to CI, Translations, PeopleSoft Upgrade
• Strong RDMS skills and hands on experience in Oracle 9i/10g/11g
• Strong experience in writing Complex SQL queries, Views in oracle database
• Extensive Development experience with TOAD, PL/SQL Developer.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Had Functional implementation experience on Competency Management, Confidential, ePerformance, eVacation, Maintaining Personal and Job data module, HRMs Workforce Admin Functionality, International and Global Assignments, Employee Self-service(ESS), Manager Self Service(MSS), Base Benefits and Ben Admin, UK Payroll, Tree Security(from scratch), Departments, Multi currency(International assignee)
• Had extensively work on Bolton modules for project Electronic Driver Maintenance System(From Scratch),Global Grade, Multi-currency, Partner rotation(From scratch), partner State tax, Global Payroll authorization(GPA)
• Have played key roles in Business Requirements gathering, Fit-GAP analysis (Impact Analysis), writing Functional and Technical Specifications (Complete Solutioning of Project), Migration of Code, Test Planning & Execution and imparting trainings to team member & users.
• Involved in Unit Testing and system Integration Testing during most of the PeopleSoft Projects.
• Had used PeopleSoft Testing Framework and quality center for testing modules.
• Excellent in problem solving and self-learning attitude
• Strong Analytical skills to convert functional design specifications into Technical Design specifications
• Exceptional ability to quickly master new concepts, technologies, and tools.
• Proficient in performing various roles and functions including team lead, system analyst, design, development, system integration, and unit testing.
• Strong knowledge in Production Support activities.
• Strong motivational leader -setting and reaching strict goals. Results oriented - demonstrated ability to drive teams to deliver on commitments. Ability to articulate a vision and persuade others through excellent communication and interpersonal skills.

TECHNOLOGIES USED:

PeopleSoft HRMS (v9.1, v9.0, v8.9, v8.8) (Workforce Administration, PS Security, ESS & MSS, Position Management, ePerformance, eCompensation, Confidential, Confidential, NA Payroll, Campus Solution)

Application Designer PeopleTools People Code

Application Engine File Layout Component Interface

Security Administrator XML Publisher Tree Manager

Process Scheduler SQR Production Support

PS Query Performance Tuning Data Mover

Workflow Attachment Frame Work PS Security

Excel to CI Application Package Integration Broker,CM

Oracle 11g/10g/9i DB/2

Quality center

Functional Knowledge of PeopleSoft Test framework

PROFESSIONAL EXPERIENCE:

Confidential, Walnut Creek, CA

Security Architect

Responsibilities:

• Worked with several department stakeholders to discuss administrative roles, users, functions to determine security roles and various levels of access for security groups.
• Reviewed current security and met with key HR & Finance department members to reduce redundant and obsolete roles & permission lists.
• Setup of security in creating roles, row security permission lists, department security tree and User profiles. Designed Component security based roles, permission lists assigned the appropriate roles to the user profiles.
• Applied user preferences for the users based on the business process access.
• Designed row level security based on the row level permissions and implemented across all modules.
• Assigned appropriate process groups to the user profiles for business users
• Created Definition groups to provide selective users access to the trees.
• Maintained service operation security credentials for integration broker interfaces.
• Assigned component interfaces and web libraries to business users to provide them access to use the ExcelToCI and other delivered spreadsheet upload templates.
• Created custom query trees and query access groups to provide record/query access to PeopleSoft query users.
• Managed user access to mass change templates to restrict the mass change functionality to a specific user group.
• Ran the portal security sync program to synch portal definitions as and when required.
• Worked with developers to create a custom program to apply row-level and query security across all the necessary tables.
• Maintained role combinations to enforce some role combinations are not assigned to users in order to enforce segregation of duties.

Technical Lead

Confidential

Responsibilities:

• Worked with several department stakeholders to discuss and Provide the quick solution/work around on issue (related with Taxes, Pay sheets, Off cycle-On Cycle checks & any payroll related job failure) encounter in Payroll Module.
• Serve as a Payroll support resource, and engage in all biweekly/ weekly payroll monitoring jobs and provide fix if client faces any negative results, without missing deadline.
• Work actively in processing garnishments (on a weekly basis) to AP module and creating reconciliation reports to check the accuracy of the data extracted. Also on the EFT file generation.
• Customize the delivered Paycheck (PAY003) and Payroll advice (DDP003) SQRs which also includes changing the XML template to meet the client needs.
• Lead the 3rd party interface track which takes care of all PeopleSoft inbound and outbound interfaces primarily using Application Engine, File Layout, and FTP PeopleCode.
• Take part in the security aspects which involve creating custom roles and permission lists for the various work groups as a part of the Go Live activities.
• Create custom user profile load programs to load the initial set of users using Application Engine and Component Interface. Also clone the same and modify to generate profiles for new hires (and re-hires).
• Developed Queries using PS Query for HR/Payroll/Benefits
• Handled the row security manually as most of the times new security definitions are provided by the HR/IT.
• Work with the Dynamic role assignment program which takes care of dynamically assigning (also removing) the roles based on the job bands and various other aspects defined per the security matrix.
• Create the custom time and labor row security assignment program (TL Permission List Security and Dynamic Group) based on the external approvers created in financial system and invoked from the FO ASGN CREATE message.
• Engage in the Audit project to have custom trigger-based audit records to track the changes on the main HR and Payroll records.
• Create customized reports for Payroll reconciliation
• Developed an end to end transactional approval workflow process using (AWE) for Module that required EE Information changes such as (International and Domestic Transfers, Jobdata changes, Position Changes etc.) to be approved by HR Managers.
• Involved in the configuring and testing of work flow routing rules and route control profiles for MSS using Approval Workflow Engine (AWE).

Environment: PeopleSoft 9.2 version, NA Payroll, PS Security, Benifits,ApplicationEngine(Inbound and outbound Interfaces), Component Interface, Row Level Security, XMLP reports,AWE,State, Federal, FLSA reporting,Application Security

Confidential, Houston, TX

Technical Lead

Responsibilities:

• Worked as a Technical Lead for PS HR Tree Restructuring and had done impact analysis, Solutioning, FIT-GAP Analysis and Tracking of Project.
• Mentored team to deliver modules on time.
• Prepared functional and technical specification documents.
• Involved in developing new Tree Structure, New Security Types, Roles and Permissions, PeopleCode, Data Conversion and customizing existing People Code based on user requirements for ELM as well as Core HR.
• Used EXCEL to CI conversion for existing nodes
• Involved in developing and customizing the reports using XMLP and PS Query.
• Worked with Tree Manager, Security Types, Security Access type and had introduced new security type for incorporating changes
• Development using Application Engine, People Code, PS Query, SQR, Tree Manager
• Testing the GAPS and Tracking the defects using PTF.

Environment: PeopleSoft 9.1,People Tools 8.5, Oracle 11, Tree Manager(Department tree restructuring), SQR,Roles and Permission List, Security Types, Department and row level security. PeopleCode, Application Engine,Component,PSQuery,Excel to CI,Component Interface, XMLP, Employee Learning Module, Configuration Manger,DataMover,Application Package

Confidential

Technical Lead

Responsibilities:

• Estimated Business requirement, had set up the time lines, allocated resources and assigned tasks
• Executed various Project Management related activities as per the release process, planning detail implementation and deployment plan for application including test environment (SIT, UAT)
• Coordinating with stakeholders for definition of project scope, and preparation of various project artifacts like Project Charter, Business Case, Project Plan etc.
• Worked as team lead of 5 technical resources to deliver the quality product on given time.
• Interaction with all functional analysts, SME’s and business user to understand the business process
• Involved in discussions with clients, and for providing application design documents.
• Facilitate system and integration testing including other interacting applications.
• Provide training/mentoring to new entrants on the application.
• Responsible for the design, development and review of the team’s deliverables.
• Involved in the preparation of project metrics and quality initiatives of the team.
• Worked with the team in technical requirements related to PeopleSoft and Cobol as an SME
• Built and maintained relationship with the Business & IT executives
• Fixing Production Bugs, Solving issues of HRMS core modules assigned in Service Manager
• Job monitoring and process scheduler related tasks
• Providing Technical and functional Training to team for faster turnaround of issues
• Creating documents for fixing Recurring Issues
• Direct interaction with client while solving issues
• Reviewing code changes made by team and testing before sending to client
• Worked on enhancements and Light Projects tickets
• Assigning tickets to team and reviewing the work done
• Play Support lead and implementation lead for minor enhancements
• Was responsible for Impact Analysis, Retrofit customization and Testing during upgrading system from 8.9 to 9.1 for ePerformance, Confidential, Confidential, Interfaces and Reports.
• Worked on Application Engine, PS Query, PeopleCode, File Layout, Components Interface, Integration Broker, Workflow, XMLP/BI Publisher, Tree Manager, Attachment framework, Security Framework

Environment: PeopleSoft 9.1,People Tools 8.5, Oracle 11, Application Engine, PS Query, PeopleCode, File Layout, Components Interface, Integration Broker, Workflow, AWE, XMLP/BI Publisher, Tree Manager, Data Mover, Attachment framework, Security Framework, Application Security, Row Level security,Application Package, PeopleSoft Upgrade, Configuration Manager

Confidential

Technical Upgrade Lead

Responsibilities:

• Developed an end to end transactional approval workflow process using (AWE) for a custom GPAModule that required EE Information changes such as (International and Domestic Transfers, Jobdata changes, Position Changes etc.) to be approved by HR Managers.
• Involved in the configuring and testing of work flow routing rules and route control profiles for MSS using Approval Workflow Engine (AWE). Confidential, eCompensation and Variable CompensationImplementation enhancements and Support, custom Module - InternationalAllowances, CustomModule- GPA.
• Worked on Customizations which Involved in Creation/modification of Records, Pages, Components, ComponentInterfaces, AppEngine, PSQuery etc.
• Fixed problems by updating existing Appengine, Apppackages, CI, PSQuery, and PeopleCode.
• Worked on Confidential Implementation, Customizations, enhancements and support.
• Worked on various reports using XMLpublisher and Appengine.
• Interacted with Users to understand the business process and interact with functional users and also other developers for Peer review process.
• Developed several Custom Outbound Interface using (AE) to load data from PeopleSoft to 3rd party vendors ( JDE, DMI, CSoftetc)
• Reviewed and DevelopedTechnical design specifications based on Functional Documents.
• Used People Code extensively to code for Application Engine, Component Interfaces and for other objects. This involved coding at the record, page and component level.
• Developed a number of batch processes using Application Engine tool and SQR’s.
• Created queries using PSQuery Manager which were used for Crystal reports.
• Analyze/Identify/Document and resolve or escalate any existing system logic difficulties.
• Tuning and DebuggingPeopleCode and Application Engine Programs.
• Modifying SQR for DataLoads, Tuning, aging etc. TuningPages Performance after collecting SQL from trace.
• Involved in setting updeliveredExcel To CI and loading Employee Data into different PS Tables.
• Modified delivered E-Recruit objects (pages, components, records, fields etc.) to develop the TCH required E-Recruit Application.
• Modified delivered Employee Self Service, Manager Self Service and other related eApplication objects to retrofit the business requirements of the client
• Upgrade, Production Support & Enhancements of HCM

Environment: PeopleSoft HCM v9.1 (Core HR, e-Performance, e-Recruit, ESS, MSS), People Tools v.8.53, TOAD, Oracle SQL Developer v2.1.1.64, PeopleCode, ApplicationEngine, SQR process and SQR reports, ExceltoCI, IB, AWE, SMC, RemedyForce, JDE, C-Soft, DMI, Infinium.

Confidential

Technical Analyst

Responsibilities:

• Involved in customization and development of existing/new components and reports from Function designs
• Developed an end to end transactional approval workflow process using (AWE) for a custom GPA Module that required EE Information changes such as (International and Domestic Transfers, Jobdata changes, Position Changes etc.) to be approved by HR Managers.
• Worked with Integration Broker to accept transactions from another department to populate custom table in PS. Also used Send Master utility during testing phase.
• Involved in the configuring and tetsting of work flow routing rules and route control profiles for MSS using Approval Workflow Engine (AWE).
• Worked on Attachment Framework functionality of PeopleSoft used it for Students loan and Court orders in Payroll
• Developed Queries using PS Query for HR/Payroll/Benefits
• Developed a Custom SQR for Payroll to Compare the Payroll for Current and Prior Pay Periods and Calculate the difference between the Pay Periods.
• Worked on a custom Payroll Interface that sends a Labor Workx Employee Interface File to API Labor Workx using an Application Engine.
• Developed, Tested a Custom SQR with a Composite Payroll Audit Data based on the Legacy reports
• Modified, Tested the Custom Interfaces with Payroll & Benefits
• Developed Custom Payroll Report to compare between current and prior Pay Periods
• Worked on Payroll Conversion from GEAC Employee Tax Data file to PeopleSoft Federal Tax Tables
• Converted the Legacy Employee Direct Deposit Data into Peoplesoft Direct Deposit Tables.
• Modified Delivered SQRs to fit the user’s needs in HR, Payroll, Benefits Modules
• Monitored Payroll Processing
• Implement row level security for XMLP Reports output
• Worked on Form P35, Form60 and HMRC Reports - These reports are generated once in a year for all employees for tax, saving and deductions from the Employer.
• Worked on PDF Templates using Acrobat reader for these forms
• Created reports using XMLP and PS Queries
• Unit Testing of reports, Attachments and SQR developed or modified during project.

Environment: PeopleSoft 8.9,People Tools 8.5, Oracle 11, Attachment Framework, BI Publisher to create PDF Template, SQR, XML Publisher,Application Security and data security

Confidential

Technical Analyst

Responsibilities:

• Designed security for Confidential Region
• Created Various Security spreadsheet and access Matrix for defining segregation of duties for peopleSoft (Admins,Managers, Employee,POI) and access to functionality as per weatherford business process
• Primary Permission List defined one per country, one per region for System Admin or COE Group as per weatherfordBP.
• Created Generic roles created for country specific functionality (Global,Country,Generic) per Application
• Collating data from the super spreadsheets for creating unique combination using Payroll company,ProductLine,Sub-Product Line, Location, Department and used for generating PeopleSoft department ID’s for each of the logical as well as the physical departments.
• Defining ranges for country, Payroll Company
• Define Naming convention for Roles and permission list to be assigned for functionality identification.
• Excel to CI for loading Logical departments in department table
• Created complex Query to insert nodes in table of SQR per507 which involves parent child relationship among departments so that Department tree can be formed. correction made using tree Manager
• Modified existing WFSCHED process used for creating Service USER ID to notify admin of Confidential region.
• The Department tree created dictate row level security for employees and security by permission list is used for access to all POI’s without job.
• Designed security maintenance form for security prod support for New Hire, New role, Change Roles,Termination, Leave of Absence
• Dynamic roles user program created to assign and delete roles to user upon rules dynamically
• Migrating roles,Permissionlist using App Designer
• Tree migration done using peoplesoftTREE EXPORT feature to save existing tree in file and then XML file is used to create tree in production for Confidential region
• Portal security sync process after migrating new role, permission list

Environment: PeopleSoft 8.9,People Tools 8.5,HR Tree Security, Application Security,Datasecurity,Application Engine, Tree Export,SecuritySets,Security Types

Confidential

Technical Analyst

Responsibilities:

• Worked with Product Owner and Developer Team in Gap Analysis, scoping and design as per the business requirements, Backlog Refinement and coordination with stakeholder
• Lead technical phases of the Fit-Gap sessions
• Reviewed with the help of the team all modifications made to the PeopleSoft application and to the business processes and the effect of the conversion on such modifications.
• Created Fit Gap technical design documents and documents for process re-engineering.
• Created and modified Application Engine, App Packages, SQRs, PeopleCode, Component Interfaces, excel to CI, Integration Broker, PeopleCode programs during the phase of the project.
• Worked with team in preparing and reviewing design documents like Use Case, HLD, LLD, Test scripts and Lessons learnt
• Creating TDS from functional specs documents
• Development of new and Modifications in existing screens and Reports based on requirements
• Creating Performance templates for reporting
• Worked on PeopleCode, File Layout, XMLP, Application Engine
• Unit and functional testing

Environment: PeopleSoft 8.9,People Tools 8.5, Oracle 11, PeopleCode, XMLP Reports, Apllication Engine, WorkFlow, Components, Roles and Permission List

Confidential

Senior Developer

Responsibilities:

• Requirement analysis, creating detail design and unit test case documents.
• Worked on customizing the screens and functionality as per GAPS
• Worked on AWE, Workflow, PeopleCode, Translations, Application Engine, Component Interface, Application Packages, subpages, PS Queries
• Keen focus on performance tuning, testing and quality assurance
• Generated reports using XML publisher, File layout and PS Query

Environment: PeopleSoft 8.9,People Tools 8.5, Oracle 11, WorkFlow, PeopleCode, Translation, Application Engine, Component Interface, PS Query, XMLP

Confidential

Senior Developer

Responsibilities:

• Involved in Creating Technical and Functional designing
• Implement Row Level security for Reports and online pages
• Created new and modified existing PeopleCode, Application Engines, Reports, XMLP publisher, RTF Templates for certificates etc.
• Used EXCEL to CI for uploading job task, job code etc. in the system
• Modified interface where IB Messages were used for writing data in PeopleSoft ELM product.

Environment: PeopleSoft 8.9,People Tools 8.5, Oracle 11, PeopleCode, Application engine, Integration Broker, Excel to CI, XMLP, Roles and Permission, PS Query

Confidential

Senior Developer

Responsibilities:

• Requirement analysis, creating detail design and unit test case documents.
• Designing Functional and Technical Specifications
• Modified existing and written new codes to accomplish development
• For phase 3 Single handedly done Analysis, Coding and Testing of modules from Offshore
• Worked on PeopleCode, XML Publisher, File Layout, Application Engine, Component Interface, Translations, Workflow, Roles and Permissions.
• Developed complex Inbound Interface for writing Violation to the system which includes CSV reading and Loading data in system
• Worked on creating reports using File Layout, PS Queries and XMLP
• Direct Interaction with client for requirement gathering and understanding changes
• Involved in testing of GAPS

Environment: PeopleSoft 9.1,People Tools 8.5, Oracle 11,PeopleCode, Components, XML Publisher, File Layout, Application Engine, Component Interface, Translations, Workflow, Roles and Permissions, Data Mover, Configuration Manager, Inbound Interface, PS Query