SUMMARY OF EXPERIENCE:

Oracle PeopleSoft Developer Certified Expert with 8 years of experience in PeopleSoft Development, Upgrade, Production Support and Maintenance projects which includes Design, Development, Testing, Upgrade, Production Support and Maintenance of PeopleSoft Applications.

• Proficient in PeopleSoft PeopleTools Application Designer, Application Engine, Component Interface, Data Mover, PeopleCode, Application Packages and various other developer tools.
• Expertise in Integration Broker, PS Security, Data Conversion, Interfaces, Excel to CI, SQL, SQR.
• Basic functional knowledge of PeopleSoft Human Capital Management modules of Payroll for North America, Compensation, Base Benefits, Benefits Administration, Workforce Administration, Position Management, HR Self Service, Manager Self Service, Enterprise Learning Management and PeopleSoft Security for various business enterprises.
• Extensive knowledge in technical aspects of PeopleSoft HRMS Applications.
• Expertise in creating PL SQL, Stored Procedures with Oracle and IBM DB2 databases.
• Worked in PSHCM upgrades from 8.9 to 9.2 and 9.0 to 9.2.
• Proficient in mini upgrade deployment like Bundles, Tax Updates, Patches and Tools Upgrade.
• Proficient in developing New PS Objects, Retrofitting and Customizing the existing Objects.
• Experience in creating, enhancing and retrofitting inbound and outbound interfaces using SQR, SQC, Application Engine and Component Interfaces.
• Maintaining and Scheduling Batch Jobs and providing support through all the phases of development and implementation.
• Possess very good knowledge of Software development cycle, and Prototypes.
• Experience leading a team in a development environment.
• Independently prepare functional designs, technical designs, code, documentation and review that meet the needs of complex business requirements and provide support for System and UAT testing, and supervise the work with other programmer analysts.
• Strong knowledge of and adherence to development standards including testing and migration procedures and implementing best practices.
• Well versed in the Global Delivery Model for execution of projects involving onsite and offshore teams and in providing Knowledge Transfer sessions with clients and offshore team.
• Self-motivated fast learner, diligent, hardworking and active team player with high analytical and problem solving skills and effective communication. Skilled in proactive identification and resolution of critical issues
• Demonstrated proficiency in leading and mentoring individuals to maximize productivity and forming cohesive team environment.

TECHNICAL SKILLS

• ERP Packages : PeopleSoft HRMS and ELM 8.3, 8.8, 8.9, 9.0, 9.2
• PeopleTools : Application Designer, Application Engine, Process Scheduler, Data Mover, Excel to CI,
• PeopleSoft Security, Component Interface, Configuration Manager, PeopleCode,
• DIRXML transactions
• PT Versions : Tools version 8.17, 8.47, 8.48, 8.49, 8.51, 8.53
• Reporting Tools : SQR, PS Query, XML Publisher
• Web Languages : HTML
• Schedulers : PeopleSoft Process Scheduler
• Change Management : Microsoft Visual SourceSafe, PVCS, Rational Clear Case, Rational Clear Quest
• Database : Oracle, Oracle 9i, Oracle 10g, Oracle 11g, IBM DB2, Microsoft Access
• Operating Systems : Windows, UNIX, MS-DOS
• Migration Tools : STAT
• Others : JIRA, DART

DETAILS OF THE PROJECTS WORKED ON

Client : Confidential

Confidential is an American international electronic commerce company with headquarters in Seattle, Washington, Confidential. Amazon uses PeopleSoft Enterprise Resource Planning ERP for maintaining their Workforce Administration, e-Performance, e-Management, Employee, HR and Manager Self Services, Payroll for NA Interfaces , Global Payroll, Time and Labor few modules , Talent acquisition Applicant and Pre hire , Workforce development and other HR modules. This project is for upgrading their systems from PS 8.9 to PS 9.2 systems and implementing master files for providing data to global pay interfaces.

Role : Programmer Analyst

• Participating in project estimations, project plans, project plans review, discussion with users and providing inputs for upgrading PS HCM 8.9 system to 9.2 system
• Help in understanding the upgraded functionality of new online features and their setups to decide the Go No Go decisions with the new features and helping in upgrade activities.
• Operational support includes like object comparison, migrations, data validation, data conversion, supporting upgrade change process, quality assurance of all development work, training technical staff, training users on new functionalities.
• Analyzing and identifying the impacted objects to decide retrofit or customize or retain the objects. The objects includes all kind of PS objects like PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs, Application Packages, style sheets and other type of objects.
• Retrofitting SQRs, SQCs and other impacted processes.
• Developing Oracle scripts to import and export data to different environments.
• Performance tuning of different processes which helped to speed up the production activities.
• Converting all the record level audits to Database level triggers.
• Studying current business processes and recommending future businesses with new advanced PS features.
• Performing Unit testing based on the test plans and providing support for functional, integration, system, performance and UAT testing for defect free upgrade process.
• Testing end to end Client system functionalities.
• Fixing the defects reported during System testing and UAT.
• Tracking and logging the defects identified and reported from testers and users using JIRA
• Coordinating with users, onsite and offshore teams.
• Providing support through all the phases of upgrade, leading the deployment activities and preparing Go Live activities
• Designing frameworks for different country's employee LOA maintenance and integrating banking with employee self-service module based on company and business requirements.

Confidential

Confidential is the world's leading aerospace company and the largest manufacturer of commercial jetliners and military aircraft combined. Boeing uses different HRMS modules and ELM for maintaining their Human Resources HR operations related to Employee core HR data, payroll data, benefits information and their training activities.

Confidential

Role : Technology Lead

Responsibilities:

• Participating in project estimations, project plans, project plans review, discussion with clients and providing inputs for upgrading PS HCM ELM 9.0 to 9.2
• Providing support for in understanding new features from upgrading PT 8.51 to PT 8.53 and helping in upgrade activities.
• Help in understanding the upgraded functionality along with new online features and their setups to decide the Go No Go decisions with the new features.
• Operational support includes like object comparison, migrations, data validation, data conversion, supporting upgrade change process, quality assurance of all development work, training technical staff, training users on new functionalities.
• Analyzing and identifying the impacted objects to decide retrofit or customize or retain the objects. The objects includes all kind of PS objects like PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs, Application Packages and many others.
• Working as Lead for Data validation and Data Conversion track completely to identify the risks and to provide support for successful data migration as part of upgrade from 9.0 to 9.2 environments.

Confidential brokerage and banking company, based in Confidential. uses PeopleSoft Enterprise Resource Planning ERP for maintaining their Human Resources HR operations related to Employee core HR data, payroll data and benefits information. The PeopleSoft Human Resources Management System HRMS also integrates closely with other Legacy and Finance applications as a part an Enterprise-wide Integration. This project required analyzing issues and enhancement requirements in the current applications, designing, developing solutions and testing the application.

Confidential

Role : Developer Technology Lead

Responsibilities:

• Participating in project estimations, project plans, project plans review and discussion with clients and providing inputs, prototypes and design patterns.
• Requirements gathering by understanding both functional and non-functional specifications with inputs from business analysts and providing high level estimates of analysis for identifying the gaps and issues.
• Preparing the detailed project development schedule while accounting for individual tasks and dependencies
• Providing proper impact analysis and identifying the risks in order to ensure the proper delivery of the project
• Preparing the Technical Fit Gap document based on the analysis and list of objects with Go/No-Go decisions list, from the Fit Gap document and input from users and providing proper estimates for the complete implementation cycle.
• Preparing and performing technical review of Design, Coding and Test of developmental activities.
• Performing Unit testing based on the test plans and providing support for functional, integration, system, performance and UAT testing for defect free releases.
• Fixing the defects reported during System testing and UAT.
• Tracking and logging the defects identified and reported from clients or users.
• Providing support through all the phases of implementation, leading the deployment activities and preparing Go Live activities.
• Providing support after post production and responding to production issues with appropriate solution based on inputs from users or analysts with analysis, effort estimation, test cases and solutions in order to fix the issues in timely manner with minimal production impact.
• Preparing and participating knowledge transfer sessions and document understanding.
• Coordinating with different client vendor teams.
• Providing support for miscellaneous activities such as routine maintenance and database refresh.
• Deploying Tax updates, Bundles and other mandatory patches delivered by Oracle.
• Integrating PS System to other Legacy and Financial Systems through Integration Broker and using Send Master for testing the internal transactions.
• Developing or customizing Excel to CI for data load, PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs.
• Developing Oracle scripts to import and export data to different environments.
• Customized, implemented and providing support to the delivered PS Benefits module, to provide an additional service for the employees through customized Self Service Created a new On demand event functionality to create an event in Bas Partic when employee wants to enroll in business's new plan.
• Fixing NA Payroll production issues mostly at the time of payroll run.
• Customized HR Process for creating Case Management system to log and track the Employee facing issues and harassments.
• Customizing the PS Security and providing required access to the people by assigning proper roles.
• Developing or customizing different processes which include SQR, App engine, Component Interfaces.
• Deployed, tested and implemented Tools upgrade from 8.49 PT to 8.51 PT with the support of database administrators.
• Providing support for PeopleSoft DIRXML transactions to keep the data flow in sync through different systems and at the time of driver updates.
• Worked on Performance tuning of different processes which helped to speed up the production activities.

Confidential

Role : PeopleSoft Developer Technology Analyst

Total Confidential is an overall effort to restructure complete Compensation module according to business rules.

Responsibilities:

• Participated in project estimation of work product in order to provide right information
• Requirements gathering by understanding functional non-functional specifications with inputs from business user and provided high level estimates which helped effectively in design, development and testing phases
• Provided impact analysis, high level design, design specifications at high level and unit test plans for complex programs.
• Created application architecture to provide deliverables including development and review of the artifacts.
• Performed functional, integration, system, user testing activities based on plans and also involved in performance testing.
• Preparing the Technical Fit Gap document based on the analysis and list of objects with Go/No-Go decisions list, based on the Fit Gap document and input from users
• Estimation for the effort involved to retrofit/customize the objects in Target version
• Coordinating with Offshore and end user on the tactical requirements and enhancements as a single point of contact and also mentored/trained prospective project members
• Estimating the effort required, preparing technical documents and other development activities
• Review of Design, Code and Unit Test results including preparation of detailed test plans and test execution
• Performed an additional role of Configuration Manager.
• Developed a new Tier and Range system for Geographical system based of postal codes.
• Customized the existing Job Code setup Compensation Module to include an association with Tier and Range system All the Geographical locations are divided in to 3 tiers and each tier has been allocated for different ranges based on postal codes.
• Customized the Employee Grade system to be replaced with Tier and Range system Employees compensation will be decided on Employee's work location by assigning proper Tier and Range.
• Developing or customizing Excel to CI for data load, PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs.
• Creating and Enhancement of SQR programs, customizing the existing App Engines and delivered App Engines, Component Interfaces.
• Developing Oracle scripts to import and export data to different environments
• Performance tuning on the customized system by customizing the existing PeopleSoft SQLs.
• Enhanced the SQR processes to include and initiate the UNIX commands to deliver the output files for various vendors.

Confidential

Role : PeopleSoft Developer Software Engineer

This project required analyzing issues and enhancement requirements in the current applications, designing, developing solutions and testing the application and providing support to critical issues.

Responsibilities:

• Requirements gathering, analyzing the business cases, responding to the critical production issues and leading the offshore team.
• Providing impact analysis, estimating the effort required and preparing technical documents based on business functionalities.
• Preparing and review of the detailed Design, Test plans and Test execution documents
• Developing or enhancing SQC files, SQR programs, App Engines, and other online objects as per the business requirements.
• Deploying Tax updates, Bundles and other Oracle delivered mandatory patches.
• Integrating PS System to other Legacy and Financial Systems through Integration Broker and using Send Master for testing the internal transactions.
• Developing or customizing Excel to CI for data load, PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs.
• Developing Oracle scripts to import and export data to different environments.
• Provided support to fix the production issues in different areas like PeopleSoft Payroll for North America, Compensation, Base Benefits, Benefits Administration, Workforce Administration and PS Security
• Customizing the PS Security and providing required access to the people by assigning proper roles.
• Developing or customizing different processes which include SQR, App engine, Component Interfaces.
• Provided support for PeopleSoft DIRXML transactions to keep the data flow in sync through different systems and at the time of driver updates.
• Helped in handling migrations between different environments through STAT tool and helped in audit reporting by running Undocumented Object Wizard.
• Published research results to client on broken fonts between 8.48 PT and 8.49 PT versions.
• Based on my research, after 8.49 PT upgrade, successfully installed a TTF type fonts on printer instead of 8.48 supporting font setup on servers and developed enhanced SQR, SQC and property files to support fonts from printer on to the checks. As a result, were able to provide security for check signatures while generating pay checks for the employees.
• Successfully generated Pie Charts and provided live examples to present and implement the Pie charts in our current system.

Confidential

Role : PeopleSoft Developer Software Engineer

Confidential is a leading Retail chain. Sears has merged with one of its close competitor Confidential uses PeopleSoft 8.3 HRMS on Mainframes and Sears Holding systems uses PeopleSoft 8.8 HRMS on UNIX. It is a combination of integration, upgrade and development methodology to migrate Kmart operations from the PeopleSoft 8.3 HRMS on Mainframes to the corresponding Sears Holding systems in the PeopleSoft 8.8 HRMS on UNIX for the applications of core HR, Benefits and Payroll.

Responsibilities:

• Providing impact analysis, estimating the effort required and preparing technical documents based on functionalities
• Preparing the design documents, developing the existing SQRs and processes
• Preparing and Review of Design, Code and Unit Test results
• Prepared and participated in knowledge transfer sessions and document understanding
• Enhancement or retrofitting the existing SQR programs, retrofitting the existing App Engines and other online objects as per the business requirement
• Analyzed on the processes and provided impact analysis for data conversion from PeopleSoft 8.3 HRMS to PeopleSoft 8.8 HRMS
• Developed new SQR processes to convert and report the new record structures and missing fields from records which are part of Data Conversion.
• Helped in converting the 8.48 PeopleSoft HRMS version data to support 8.48 PeopleSoft HRMS version data.
• Provided SQL scripts for reporting and data import through IBM DB2.
• Handled all the migrations between different environments through UNIX and Putty tool in development environments.

Confidential

Role : Software Engineer

Confidential is a fortune 100 company and one of the leading Retail Industry in Confidential. Nonexempt Target e-Merit System is a system for generating the merit amount for the employees of Target Corporation based on the eligibility and based on the merit amount their Annual compensations are decided. It involved online objects, Application engines, PS Queries and SQR Reports. This was an end-to-end application development project involving requirements elaboration, design, build, testing, implementation and support.

Responsibilities:

• Coordinating with on-site team for requirements gathering and for enhancing the programs.
• Analyzing the requirements, providing impact analysis, and providing fix or work around solutions to the production issues.
• Estimating the effort required and preparing design documents, technical documents based on the business functionalities.
• Review of Design, Code and Unit Test results.
• Prepared and participated in knowledge transfer sessions and document understanding.
• Helped in implementing and enhancing the Position Management System according to the client provided business architecture.
• Developing or enhancing SQC files, SQR programs, App Engines, and other online objects as per the business requirements.
• Modified the huge number of SQR reports to generate the required columns dynamically based on the selections from user.
• Implemented graphics in the SQR and online reports.
• Provided SQL scripts for reporting and data import through IBM DB2.
• Handled all the migrations between different environments through STAT tool and helped in audit reporting.