Summary:

• Over 12 years’ experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• Worked in PeopleSoft 9.2, PeopleSoft 9.1, PeopleSoft 9.0, PeopleSoft 8.9, PeopleSoft 8.8 Upgrade projects.
• Extensively worked with People Tools such as Application Designer, Application Engine, Process Scheduler, Data Mover, PeopleCode, Workflow, Component Interface, File Layout, XL to CI, Approval Workflow Engine (AWE), Application Packages, Integration Broker, PeopleSoft security (Roles, Permission lists, User profiles), HTML, PeopleSoft Update Manager(PUM), project migrations and Unix Scripts.
• Worked on PeopleSoft HR Modules - Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), ePerformance, Candidate gateway/TAM, Absence management, Position Management, Base Benefits, Benefits Administration, North American Payroll, Compensation and Time & Labor.
• Worked on inbound and out bound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using SQR, Application Engine, Component Interface and File Layout.
• Worked on the latest toolset People tools 8.55. Developed new pages, components using the fluid designs.
• Used PeopleSoft REST services extensively for exposing PeopleSoft components to outside applications.
• Project migration done using Application designer and STAT tools to SIT, UAT and Production and knowledge on data migration workbench.
• Expertise in developing, Customizing Interfaces and Conversion programs using SQR, Application Engine and Component Interfaces for HCM modules.
• PeopleSoft technical skills include People Tools (Application Designer, People Code, Application Engine, Component Interface, Process Scheduler, PS Query, SQR, Data Mover, Security Administrator and Definition Security, Integration Broker and SOA.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Expertise in the creation of complex reports using SQR, and PS/Query by translating client business requirements into technical specifications. Hands-on experience using template-based reporting tool XML Publisher.
• Worked with reporting and analyzing tools such as SQR, BI Publisher /XML Publisher, PS/Query, Crystal.
• Worked on setting up Fluid pages, PeopleSoft Work Centers / Dashboards / Navigation Collections, Pivot tables and Related content services.
• Created new dashboards and work centre and used pivot grids to create reports for leadership.
• Strong expertise in Branding and HTML5, CSS 3 and JavaScript.
• Strong database skills include data modeling, database design, Oracle server-side programming in PL/SQL and Oracle database administration.
• Knowledge of app server configuration, PIA, Process Scheduler, web server.
• Excellent troubleshooting and problem-solving skills.
• Well-versed exposure on Agile and Waterfall SDLC model.
• Worked on tickets and enhancements based on JIRA.
• Team player with excellent interpersonal communication skills and technical documentation skills.
• Gather Data conversion/ Consolidation requirements for foundation and employee data tables and build the code for all the setup tables and Transactional tables for new 9.1 environments.
• Gather Data conversion requirements for any key functionality that should be migrated to 9.1 as a part of upgrade.
• Strong knowledge of Software Development Life Cycle(SDLC) & Software Development Test Cycle(STLC) methodologies such as Agile, SCRUM.

TECHNICAL SKILLS:

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8/8.3/8. x

PeopleSoft Technical Skills: Application Designer, PeopleCode, Application Engine, Data mover, Process Scheduler, PSQuery, Security, Component Interface, File Layout, Tree Manager, Process Scheduler, STAT.

PeopleSoft HRMS/HCM Skills: Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), ePerformance, Candidate gateway/TAM, Absence management, Position Management, Base Benefits, Benefits Administration, North America Payroll, Compensation, Time & Labor and E-Applications.

Reporting Tools: PSQuery, SQR, Crystal Reports, BI/XML publisher.

Integration Tools: File Layout, Component Interface, Integration Broker, Approval workflow engine(AWE).

Databases: Oracle 9i/10g/11g/12c, Toad, SQL Server, DB2, MS Access.

Languages: SQL, PL/SQL, C, C++, Java.

Operating Systems: Windows 95/98/2K/NT/XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

HCM PeopleSoft Developer

Environment: People Tools 8.54/8.55, People Code, People Soft HRMS (HR, Base Benefits), SQR, Oracle 9, Java script tools in PeopleSoft, BI Publisher, App Package, Integration broker and SOA, component interface

Responsibilities:

• Identified required PeopleSoft tables and prepared mapping documents for data conversions from Workday to PeopleSoft (PeopleSoft HR, Payroll, Benefits, and Time & Labor, Absence Management).
• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54/8.55
• Used the Application Engine for writing the Component Interfaces in Payroll and Base HR modules for reapplying the business logic associated with PeopleSoft delivered components using the existing PeopleSoft Component APIs.
• Worked on various conversion interfaces from legacy systems to PeopleSoft Payroll system.
• Getting STD data from Workday to PS and process STD data create STD letters using XML Publisher.
• Developed application engine program for loading WD data from Flat Filed to PeopleSoft Payroll tables using component interfaces.
• Loaded the PS tables from Legacy systems to PeopleSoft systems using component interfaces.
• Developed a number of validation edit to make sure the data is clean before loading the data into the application tables.
• Involved in the development and re-design of ESS and MSS modules.
• Established the connection between PeopleSoft and Third-Party systems for bi-directional data flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging.
• Wrote SQR/PL-SQL scripts to extract Mass change/Application Engine/SQL view scripts.
• Prepared Reports for ARC.
• Customizations and making necessary changes on a regular basis as per the client’s needs.
• Configured the PeopleSoft interaction Hub to develop the landing page for the self-service applications.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft HCM with third party services and publish the employee information from PS HCM to other application.
• Created a custom Application Package for implementing error handling for the custom Load Applicant Data.
• Designed and Developed different custom reports using XML Publisher in TAM module.
• Developed two nightly processes, which include Application Engine and Component Interface to insert the HR Self Service transaction data into job component performing all the job component validations.
• Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.
• Extensively worked on fluid responsive design for ARC screens.
• Creating BI Publisher reports (utilizing connected query) for mortality and life insurance confirmation information.
• Created custom Benefits inbound interface to handle open enrollments and daily enrollments to load into Ben Admin tables, which comes from other UT system.
• Adding modification to display employee name on hyperlink for Manager Self Service.
• Worked on inbound and out bound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using SQR, Application Engine, Component Interface and File Layout.
• Developed Inquire panels for Dependent Benefits and Employee Benefits.
• Applying 9.2 related changes to custom Report Time detail page for T&L.
• 9.2 modifications to custom Excess hours report SQR. 
• Perform and /or facilitate Code Reviews of all objects and ensure compliance with coding standards.
• Ensure generation of Unit Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of End to End Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of test cases for Integration and performance testing and ensure successful completion of the test phase.
• Created new Permission lists and Roles for the Benefits Self Service module.
• Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports .
• Created a number of reports using Pivot Grids and used them to create Dashboards and Work centers.

Confidential, Irving, TX.

Consultant - System Development

Environment: People Tools 8.54/8.55, People Code, People Soft HRMS (HR, Base Benefits), SQR, Oracle 9, Java script tools in PeopleSoft, BI Publisher, App Package, Integration broker and SOA.

Responsibilities:

• Identified required PeopleSoft tables and prepared mapping documents for data conversions from legacy to PeopleSoft (PeopleSoft HR, Payroll, Benefits, and Time & Labor, Absence Management).
• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54/8.55
• Used the Application Engine for writing the Component Interfaces in Payroll and Base HR modules for reapplying the business logic associated with PeopleSoft delivered components using the existing PeopleSoft Component APIs.
• Worked on various conversion interfaces from legacy systems to PeopleSoft Payroll system.
• Getting STD data from AMTS to ARC and process STD data create STD letters using XML Publisher.
• Developed the SQR program to read the STD data from Metlife file and load into AMTS and ARC tables and processed.
• Developed application engine program for loading ARC data from Flat Filed to PeopleSoft Payroll tables using component interfaces.
• Loaded the ARC tables from Legacy systems to PeopleSoft systems using component interfaces.
• Developed a number of validation edit to make sure the data is clean before loading the data into the application tables.
• Involved in the development and re-design of ESS and MSS modules.
• Established the connection between PeopleSoft and Third-Party systems for bi-directional data flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging.
• Wrote SQR/PL-SQL scripts to extract Mass change/Application Engine/SQL view scripts.
• Prepared Reports for ARC.
• Customizations and making necessary changes on a regular basis as per the client’s needs.
• Configured the PeopleSoft interaction Hub to develop the landing page for the self-service applications.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft HCM with third party services and publish the employee information from PS HCM to other application.
• Created a custom Application Package for implementing error handling for the custom Load Applicant Data.
• Designed and Developed different custom reports using XML Publisher in TAM module.
• Developed two nightly processes, which include Application Engine and Component Interface to insert the HR Self Service transaction data into job component performing all the job component validations.
• Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.
• Extensively worked on fluid responsive design for ARC screens.
• Creating BI Publisher reports (utilizing connected query) for mortality and life insurance confirmation information.
• Created custom Benefits inbound interface to handle open enrollments and daily enrollments to load into Ben Admin tables, which comes from other UT system.
• Adding modification to display employee name on hyperlink for Manager Self Service.
• Worked on inbound and out bound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using SQR, Application Engine, Component Interface and File Layout.
• Developed Inquire panels for Dependent Benefits and Employee Benefits.
• Applying 9.2 related changes to custom Report Time detail page for T&L.
• 9.2 modifications to custom Excess hours report SQR. 
• Perform and /or facilitate Code Reviews of all objects and ensure compliance with coding standards.
• Ensure generation of Unit Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of End to End Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of test cases for Integration and performance testing and ensure successful completion of the test phase.
• Created new Permission lists and Roles for the Benefits Self Service module.
• Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports .
• Created a number of reports using Pivot Grids and used them to create Dashboards and Work centers.

Confidential

Consultant System-development.

Environment: People Tools 8.42, People Code, People Soft HRMS (HR, Base Benefits), SQR, Oracle 9

Responsibilities:

• Leading the team as a POC.
• Involvement of Client’s calls.
• Developed MMRP Letters using XML publisher.
• Developed SQR reports for generating the employee MMRP information as per the requirements.
• Involved in developing new Components and pages.
• Worked on Benefits admiration customizations.
• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54
• Participating in Fit/Gap analysis & defining the organizational process related customizations to new functionality under 9.2
• Identifying the level of effort for retrofitting customization to 9.2
• Involved in converting data from Legacy system to   PeopleSoft   using Application Messaging, Component Interface and Application Engine.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Involved and identified Uni-code problem in data which crashes the COBOL procedure called by the Payroll Interface.
• Analyzed the Customizations to the delivered SQR reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired. 
• Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports .
• Designed and Developed interfaces, reports using SQR, Application Engine, Component Interface. 
• Designed and developed several interfaces to load data into   PeopleSoft   Payroll from different vendors/systems using SQR, Application Engine and Component Interface. 

Confidential

Senior Analyst

Environment: People Tools 8.42, People Code, People Soft HRMS (HR, Base Benefits), SQR, Oracle 9

Responsibilities:

• Involved in preparing a document identifying the retrofits that need to be done to meet the business requirements.
• Performed key role in compare objects analysis for PeopleSoft HCM and identified list of objects for retrofit and removals.
• Created Fit Gap, Functional Design Documents and technical design documents.
• Coordinating with Onsite for HRMS - Batch module to get understanding on Pfizer existing customization and shared the information with offshore team to create Technical specifications and resolving issues related to retrofitting and executing batch objects.
• Worked on the SQR and Application Engine retrofits as a part of upgrade from 9.0 to 9.2.
• Modified and Retired some of the People code, SQR’s and Application Engine as part of retrofits in upgrade.
• Developed Application Engine/Component Interface Programs for Data Conversion.
• Performed post-upgrade production support for various issues and documented the same.
• Production Support.
• Developed SQR reports for generating the employee absence information as per the requirements.
• Closing tickets.
• Worked with new enhancements.
• Re-tooling.

Confidential

Analyst

Environment: People Tools 8.12, People Code, People Soft HRMS (HR, Base Benefits), SQR, Windows NT, DB2

Responsibilities:

• Customized the application by modifying the Records, Pages, using Application Designer to full fill the Business user requirements.
• Views work created to accomplish row level security.
• Tailored People Code to implement data validation and enforce field level security.
• Developed SQR reports for generating employee information as per the requirements.
• Extensively used process scheduled for setting up the reports to run specific time and used Process Monitor to status of the reports.
• Prepared and documented Unit Test cases along with parallel System Testing.

Confidential

Sr. Software Engineer

Environment: People Tools 8.12, People Code, People Soft HRMS (HR, Base Benefits), SQR, Windows NT, Oracle 9i

Responsibilities:

• Created & modified Fields, Records, Pages as per the Client requirements.
• Created Application Engine Program for Payroll interfaces.
• Creating Application Engine programs such as writing data to a file, reading from flat file and batch processing by adding new Sections, Steps and Actions through Application Designer.
• Created technical designs and scripts using People code and SQR’s for Payroll and Base Benefits Modules.
• Used Process Scheduler and Process Monitor for running Application Engine.
• Created run control panels for all the SQR’s for scheduling them on process scheduler to generate reports and flat files.
• Generated SQR Reports for the Employees details.

Confidential

Software Engineer

Environment: People Tools 8.12, People Code, People Soft HRMS (HR, Base Benefits), SQR, Windows NT, Oracle 8i

Responsibilities:

• Created & Customized Fields, Records, Views, Pages, Components and Menus as per the client’s requirements.
• Modified People Code according to Business Rules as a part of development.
• Extensively worked on People Code to validate data, setting default values for fields, Calculations and events. Exposed to different functionality in PeopleSoft Version 8.0 (Pages, Components, and People Code).
• Customized PeopleSoft Delivered SQR reports in Hiring & Benefits Modules.
• Developed conversion programs in SQR to move data from the Legacy system to existing PeopleSoft tables.
• Developed new queries using PS/Query to replace some delivered SQR’s.
• Created run control panels for all the SQR’s for scheduling them on process scheduler to generate reports and flat files.
• Debugged, updated and modified existing SQR programs.
• Wrote SQR programs to upload Flat file information into People Soft database for HR & Benefit tables.
• Used Process Scheduler and Process Monitor for running SQR, Application.
• Worked on SQL Trace and People Code Trace.
• Scheduled and Modified SQR Reports