We provide IT Staff Augmentation Services!

Peoplesoft Interface Batch Analyst Resume Profile

Richmond, VA

Summary

  • Over 9 years of experience as PeopleSoft Techno-Functional with expertise in Design, Development, Customization, Implementation, Conversion, Report, Upgrade, and post-Implementation support of PeopleSoft FSCM 9.1 GL, AP, AR and PeopleSoft HCM 9.1 Core HR, North America Payroll, Benefits
  • Extensively used PeopleTools such as, Application Engine, Process Scheduler, Process Monitor, Configuration Manager, File Layout, Data Mover, Component Interface, Upgrade Assistant, PeopleSoft Security, SQR, and Application Designer in developing and customizing PeopleSoft applications.
  • Experienced in working with Report Generation using SQR, XML Publisher, nVision, Crystal Report and PS Query.
  • Experienced in using component interface and Integration broker to integrate PeopleSoft application with legacy systems
  • Very much involved in all the Fit Gap Analysis of the business requirements of the clients with new system and time lines to implement the same.
  • Provided support to payroll batch jobs and finance batch jobs and quickly resolved any issue within batch cycle.
  • Having good experience in working with users tickets and resolved their issue on time
  • Worked very closely with business users and provided support to their needs.
  • Played major role in design and implementation of finance batch for state transportation system which they want to combined with other state agencies system. BMC-Control-M scheduler is used to schedule the batch.
  • Handled most of the interfaces which state transportation system connected with other state agencies.
  • Analyzed and implemented all Tax Updates released by Oracle in HR systems.
  • Analyzed and implemented all patches and bundles as and when required.
  • Used Data Mover for loading data from one database to another database.
  • Proficient in developing new Inbound and Outbound SQR Interfaces that well suited to the Business Requirements for the various clients.
  • Created Interface files to load HR data to Legacy systems and also loaded data from Legacy systems to HR systems.
  • Created reports with Benefits and Payroll information by pulling the data from PeopleSoft applications using SQR programs.
  • Proficient in Customization, Maintenance, Interfacing/ Reporting, Data Archival, W2 processing, Tax Updates, Production Support and Testing.
  • Assisted several other Upgrade Projects for reapplying customizations.
  • Involved in performing requirement analysis, project planning and design skills including developing
  • Expertise in implementation phases including Design/Build, Unit, Integration and end User testing, Cut-off strategy, Go-live and Post go-live support and maintenance.

TECHNICAL SKILLS

PeopleSoft Application

PeopleSoft HCM 9.1 North American Payroll, Core HR, Benefits.

PeopleSoft FSCM 9.1 , GL, AP, AR

People Tools

Release 8.52 - Application Designer, PeopleCode, Application Engine, Tree Manager, Workflow AWE , Application Packages

Batch Scheduler

BMC- Control M , CA7

Reporting Tools

SQR, XML Publisher, Crystal Reports, PSQuery, nVision

Debugging Tools

SQL Trace, People Code Debugger, Application Engine Trace

Integration Tools

File Layout, Component Interface, Integration Broker,

Excel to CI

Languages

SQL, PL/SQL, UNIX Shell Scripting

Data Management

Batch Processing Tools

Data Mover, Process Scheduler, Configuration Manager, Change Assistant, CA7 scheduler.

Databases

Oracle 10g, 11g

Operating Systems

UNIX, Windows

Professional Experience

Confidential

Role: PeopleSoft Interface Batch Analyst

Description: Enhancement and support of PeopleSoft Finance system which includes modules as Account Payable, Account Receivables, General Ledger, Purchase and Project Costing. Also have PeopleSoft HR systems with core HR and Time and Labor. This is a base financial system to serve as a statewide financial system.

Responsibilities:

  • Monitoring the daily batch cycle which loads daily agent's information to HR system.
  • The existing FTP transfer process is replaced with Middleware architecture MoveIT. Involved in making these changes to support finance system.
  • VDOT merged with 143 other state agencies, so the batch has been modified to handle new agencies too.
  • Played major role in designing and implementation of phase 2 finance batch.
  • Providing complete batch production support.
  • Created, modified and tested financial reports using SQRs and nVision.
  • Generated Summary Ledger, Detail Reports and Journal Entry Details Reports on a daily basis through nVision using the user defined Chart Fields.
  • As part of implementing AR, developed Application Engine programs to allow the system to accept minimum amount and charge interest on remaining amount, etc.
  • Developed Queries using PS Query for end-users.
  • Involved in Testing the application
  • Involved in creating user-documentation of the different projects Unit Test Plan, Technical Design and Training documents .
  • Timely resolved all look back issue in BMC- Control M schedule and ensure all the processes completed as expected.

Confidential

Role: Project Lead PeopleSoft HR Systems

Description: Enhancement and support of PeopleSoft Human Resource Management System which includes Core HR, Base Benefits, North American Payroll.

The system is used for HR event maintenance, benefits enrollment and processing, payroll processing, and interface processing, balancing, and control. The system leverages custom ancillary systems and external vendor systems for various functions. PeopleSoft also feeds and get data from other systems on daily, weekly and monthly basis.

Responsibilities:

  • Providing complete payroll production support Employee and Agent Payroll
  • Developed, implemented and Monitored the hourly jobs which load the agent information personal and job from HR system to agent payroll system and also new hire information from global eRecruit solution center to HR systems and also ensure all information loaded successfully.
  • Monitoring the daily batch cycle which loads daily agent's information to HR system and feeds from Finance system AP, GL .
  • Played major role in the PeopleSoft upgrade project of the HR systems from verison 8.8 to 9.1
  • Created reports with Benefits and Payroll information by pulling the data from PeopleSoft applications using SQR programs
  • Created SQRs to migrate the data from legacy systems to PeopleSoft
  • Created and also modified delivered application engine to create new hire employee reports.
  • Year End Form Print Involved in creating and printing the year end forms - W2, W2C, 1099, 1099C, PR W2 using XMLP
  • Created custom HR and finance Reports with PSQUERY or crystal reports based on user requirement.
  • Modified delivered pages and developed custom pages extensively employing peoplecode, component interface, application packages and messaging.
  • Desinged and implemented the workflow AWE as per business requirement.
  • Designed and developed custom PS page to store details of leave plans. Also made modifications in delivered PS pages as per business needs.
  • Performed data conversion by writing interface programs both in SQRs and App. Engine.
  • Modified custom leave accrual Application Engine Program created process definitions and jobs, performed batch scheduling.
  • Ensured daily job to refresh security tables for new join employees completed successfully
  • Ensured job to create profile for new join employees to access self-service and for terminate employee's profiles will be locked.
  • Monitoring all payroll batch cycle and resolve any issues with in SLA.
  • Working on Adhoch activities like, loading overtime pay and special feed from various system
  • Involved in executing special payroll cycle during year end.
  • Involved in applying all Tax Updates delivered by Oracle to the system.
  • All Tax Updates will be applied to development region and system region before it applied to production.
  • Tax Updates changes will be validated by running complete payroll cycle in system test region.
  • Tax Updates performance will be validated by running regression test in limited population regions.
  • Involved in running test payroll cycles in all required UAT phase as required by business team.
  • Involved in applying required bundles and fixes delivered by Oracle to the system.
  • Major contribution to the implementation of a custom data archival tool.
  • Involved in environment preparation to start the archival process.
  • Involved in most of the key year end activities and ensure smooth year end in every year.
  • Designed and executed supplemental payroll for both employee and agents in year end for Group Term Life Imputed Income for Retirees.
  • Involved in applying yearend tax update Tax Update E and Tax Update F in all test and Production regions.
  • Involved in running yearend tax allocation programs and fixed any issues if there is any out of balance.
  • Involved in trouble shooting and fixing problems at development, System Testing and post-production stages
  • Involved in Reapplying customization and testing of upgrade from HRMS 8.8 to HCM 9.1
  • Worked with DBA's in resolving issues related to Payroll calculation and confirmation.
  • Working on enhancements and fixing problems which includes, technical and functional understanding of the application.
  • Working on issue tickets of end users and will get resolved on time
  • Ensured all the outbound after the payroll process are successfully created and released to vendor.
  • Participated in Disaster Recovery drill and ensured payroll process to run successfully with no issues.
  • Timely resolved all look back issue in CA7 mainframe schedule and ensure all the processes completed as expected.

Confidential

Role: Upgrade specialist

Responsibilities:

  • Actively involved in all stages of upgrade from PeopleSoft Financials 8.8 to 9.0
  • Created the upgrade strategy by analyzing various modules in the system.
  • Developed technical specification documentation for the new changes brought out in version 9.1
  • Involved in running Upgrade scripts using Change Assistant. Analyzed Upgrade Compare reports to identify and document existing customizations
  • Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations, and bringing them over successfully into PeopleSoft 9.1
  • Conducted multiple fit-gap sessions and prepared detailed design documentation. As on how to Perform Data conversions along with the Functional team and Users
  • Used Application Engine, File Layout Component Interface to load Customer Data from external system to Accounts Receivables
  • Developed SQR Interfaces and Processes to load data from external systems into General Ledger module. Before loading, the data would be edited through chart field validations and combo rules
  • Gathered security requirements in meetings with module leads and designed permission lists on modular basis for each business function
  • Implemented an Approval Workflow Engine to setup approvals for vouchers of certain amount in Accounts Payable.
  • Created Data mover scripts for Migration of Data Across Different Databases for the Custom and Delivered Tables to fix the Data conversion Issues
  • Provided Post-Production support, this involved finding and resolving known issues with the delivered product as well as client enhancements.

Confidential

Role: Upgrade specialist

Description: PeopleSoft HRMS database upgrade from version 8.8 SP1 to 9.0

Responsibilities:

  • Performed a PeopleSoft Enterprise Upgrade from HRMS Release 8.8 SP1 to HRMS 9.0 with Maintenance Pack 2 to be applied later.
  • Involved in running Upgrade scripts using Change Assistant.
  • Analyzed Upgrade Compare reports to identify existing customizations
  • Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations, and bringing them over successfully into PeopleSoft 9.0
  • Involved in reapplying customizations of Application Designer objects.
  • Applying patches and fixes / Maintenance Packs from Customer Connection.
  • Involved in interaction with NA consultants on a daily basis to resolve issues that occur through the course of the upgrade
  • Customizing the fields, records, pages and menus, PeopleCode, Crystals and SQR reports as per the client requirement
  • Verified DDDAUDIT and SYSAUDIT reports and cleaned up the database prior to executing the initial pass of upgrade
  • As part of database preparation for upgrade downloaded and applied required patches, fixes and bundles for the upgrade
  • Worked with the functional analysts to determine what changes can be dropped and what need to be brought over to the new release
  • Documenting customer problem information, recommendations and resolution in Accounts Receivables module
  • Used PeopleCode to control the program flow logic and validation to meet the current business requirement

Confidential

Role: Upgrade Consultant

Description: PeopleSoft HRMS database upgrade from version 8.8 SP1 to 9.0

Responsibilities:

  • Performed a PeopleSoft Enterprise Upgrade from HRMS Release 8.0 SP1 to 8.9 with Maintenance Pack 4 to be applied later.
  • Involved in running Upgrade scripts using Change Assistant. Analyzed Upgrade Compare reports to identify existing customizations.
  • Involved in reapplying customizations of Application Designer objects.
  • Applying patches and fixes / Maintenance Packs from Customer Connection.
  • Involved in interaction with NA consultants on a daily basis to resolve issues that occur through the course of the upgrade.
  • Developed an SQR report to show employees for whom garnishment was going to be withheld. Developed an Application Engine interface to read from a flat file and populate custom PS tables.
  • Customizing the fields, records, pages and menus, PeopleCode, Crystals and SQR reports as per the client requirement
  • Verified DDDAUDIT and SYSAUDIT reports and cleaned up the database prior to executing the initial pass of upgrade
  • Created both inbound and outbound interfaces.
  • Fixed various defects in custom PS pages, SQRs, Application Engine Programs both in Time and Labor and Payroll for North America.

Hire Now