SUMMARY OF EXPERIENCE:

• Oracle PeopleTools Developer Certified Expert with 9 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, Talent Acquisition Manager and PeopleSoft Security for various business enterprises.
• Expertise in configuring related content, SES search, Search indexes and Tabbing technology.
• 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, Primavera, Confluence

PROFESSIONAL EXPERIENCE

Confidential

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.
• Working with related content services, developing search indexes, SES related setup.
• Working and retrofitting permission lists and roles.
• Developing web services for the third party related operations based on new upgraded system 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.
• 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 QA, testers and users using JIRA
• Coordinating with users, onsite and offshore teams.

Confidential

Role : Programmer Analyst

• Help in understanding the upgraded functionality with 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, helping in understanding team 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 peed 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 and preparing Go Live activities for applicable tasks.

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

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.
• 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.
• 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 Software Engineer

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

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

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.