Post Job Free

Resume

Sign in

Data Peoplesoft

Location:
Elkridge, MD
Posted:
February 24, 2021

Contact this candidate

Resume:

** ***** ** ** ********** in Retail, Higher Education, Finance Industries, Staffing firms and Government Agency, Banking.

** ***** ** ********** *********** and Lead experience in all phases of SDLC including PeopleSoft Analysis, Fit Gap, Design, Development, Customizations, Implementation, Upgrade, Production Support, Integration, Data Conversions, Data Migration, Training, Reporting, handling off shore team, Team Coordination.

Involved in 7 upgrade projects, 3 conversion projects and 2 implementation projects.

Immense experience working with Third party systems (Concur Expenses, Smart- ERP, Smart-Post, CAPPS payroll, Smart-post, CDAS) integration and maintaining their systems and maintain consistency and accuracy with the data.

Expertise in developing EDI Solutions to Integrate and transact with PeopleSoft application.

Experienced in techno-functional analysis, gathering user-requirements, project development, Project Lead with troubleshooting system issues, working closely with third party vendors.

Proficiency in writing complex SQL’s in Oracle and SQL Server.

Strong understanding & proficiency in implementing Interfaces/Batch Jobs/Conversion Programs using SQR’s and Application Engine Programs.

Possess excellent communication and interpersonal skills and a very good team player and a Team leader.

PeopleSoft Skills:

People Tools Versions

8.58,8.57,8.56,8.55,8.54,8.53,8.52, 8.51,8.48,8.46,8.45,8.42/8.x

People Tools

Application Designer, People Code, Application Engine, Component Interface, File Layout, Process Scheduler, Integration Broker, PS Query, Data Mover, Security), Application Packages, Pagelets, Excel to CI, Fluid pages development.

Reporting Tools

XML Publisher/BI Publisher, SQR, nVision and Crystal Reports.

Change Management

Dell Stat, Phire

Modules

PeopleSoft FSCM (General Ledger, Accounts Payables, Commitment Control Accounting, Cash Management, Financial Gateway, Purchasing, Inventory and Asset Management)

PeopleSoft HCM (Payroll for North America, Base Benefits, Benefits Administration, Time and Labor, Global Payroll, Absence Management, Talent acquisition management/ Candidate gateway).

PeopleSoft ELM, Concur (Expense Management Tool), Smart ERP (New Hire Automation)

Peoplesoft Campus Solutions (Financial Aid, Enrollment and degree planning).

Methodologies and tools

Waterfall, Agile (Rally, VersionOne, Kanban)

Other

Approval Workflow Engine, Approval Process Setup, Server Administration, Notification Alerts, Dashboards, Forms.

Work Experience

Allegis Group, MD JUN’18 – Current

Role: PeopleSoft Developer

Project: Design, Development & Lead

Leading an offshore team for production support work and using Agile methodologies for development.

Experience in Account Payables module and Implemented intermediary banking for the wire payments through Financial Gateway.

Handled work of the App support team with teams residing in the states and offshore.

Held Daily standups to get the status of the work assigned and to clear the roadblocks that the developers and testers have encountered.

Modified the Bank Checks logo using Crystal reports as per the bank’s requirements.

Made changes to the templates of BI publisher reports and converted the Crystal reports to BI publisher.

Created some new reports as per the client’s requirement for reporting purposes and sent across the banks.

Created a custom SQR that handles a list of SQLs to be automated for the Automation team to be run called CTX.

Expertise in custom Expense Management tool (Concur Expenses).

Integrated Concur with AP and AR modules and build custom reports and built custom pages where the data entered on PeopleSoft page can be seen on Concur expenses page and wise versa.

Created complex pages that modify the sequences on the workflow rules page as desired by the user.

The custom CTX creates run controls and updates the tables that handle many other steps such as closing the pay cycle and processing the ‘Print Wire Advices’ processes.

Customized the BIIF001 App Engine to avoid populating the fields ACTIVITY_ID and BUSINESS_UNIT_PC in the BI_HDR table as per the Functional user requirements.

Converted a huge set of crystal reports to BI Publisher as per the client requirement which includes designing, Development and unit testing.

Extensively involved in FSCM Architecture Approval Workflow engine, Application Packages (EOAW_CORE) to generate Asset Management and AR related Email Verbiage.

Developed a new custom panel for allow partners to directly review and amend STB Attributes.

Helped many colleagues resolve their roadblocks with design and with development. Guided the testers with test plan reviews and insisted them on additional test case results in their reviews.

Held many code reviews to make sure the teammates follow client standards and to make sure the code doesn’t suffer from any performance issues.

Environment: PeopleSoft FSCM 9.2 (Treasury, Cash Management, AP, AR, Financial Gateway), People Tools 8.57 People Code, App Engine, HTML, CSS.

HUMC, NJ JUN’17 – MAR’18

Role: PeopleSoft Developer

Project: Design, Development

Responsibilities:

Working on Time and Labor customized process to send information across different systems.

Extensively developed customized pages for Employee Scheduling project.

Converted customized pages to fluid pages to be accessed on mobile devices.

Built complex BI publisher report that runs for 200 recently merged hospitals.

Built pages that use HTML area in the grid that change dynamically based on the employees scheduled and open schedules. The manager could change the scheduling which will reflect the data in T&L modules.

Modified delivered fluid App package to resolve the bug on the fluid-based approvals.

implemented security for fluid components and tiles.

Developed Custom app engines that generate daily reports and sends across to the third-party systems as an email.

Written new Bi publishers to create honors certificate for student who did exceptionally well.

Replicated Scheduling project for student nurses in Campus solutions.

For the Advising appointment module customized the Planner functionality for students and made it available to the Advisors. Modified the What-if report and other advisement reports.

Extensively involved in the Medical School Customizations.

Customized App engine process to load the letter of recommendations.

Fixed the 3CENGINE issue with the communication generation process.

Modified delivered fluid App package to resolve the bug on the fluid-based approvals.

Environment: PeopleSoft HCM 9.2 (HR – T&L, Core HR) Campus Solutions 9.2 (Financial Aid), People Tools 8.55 People Code, App Engine, HTML, CSS.

Allegis Group, MD OCT’14 – JUN’17

Role: PeopleSoft Developer

Project: Design, Development and Reporting

Responsibilities:

Experience in Absence Management and Global Payroll implementation project.

Created formulas, brackets, rules and arrays for sick plans in Absence Management.

Customize Absence Management with Fluid and Classic mode based on the requirement and roll out for different operating companies.

Experience with Oracle to resolve the existing bug in AM system for Fluid.

Created a CI for new hire load and employee data update for the new countries that were included in PeopleSoft.

Implemented Global payroll for USA, CAN and GBR.

Created GP Positive input CI were the data can fetch from a staging table/ file option on the run control page.

Core HR Production support specialist handling production tickets.

Experience in various People Tools such as Application Designer, Data Mover, Object Security, Process Scheduler, PS Query, XML Publisher, App Messaging, Integration broker and People Code.

Did upgrade of PeopleSoft from 9.1 to 9.2 and did upgrade during GP project implementation and did PUM upgrades from 6 to 21.

Enroll employees into benefit plans and setup dependent and beneficiary data.

Expertise in a custom module (Concur) that handles expenses approver.

Implemented New Hire Automation for the staffing firm’s custom module SmartERP.

Designed front end pages, CI App engines.

Created custom SQR starting from the technical Spec design, building new SQR’s and modifying existing SQR’s to enhance performance.

Created SQC and procedures to remodel existing SQR’s to avoid redundant code and robust performance.

Worked as a technical resource who can work on implementing fluid for employee self-service where we can view the personal information of an employee and status reports and also view benefits.

Implemented pivot grids within manager self-service where the grid dynamically shows the information in the form of graph of a pie chart as desired to see the information.

Remodeled most of the SQR’s to use Load Runner to reduce the Database access and increase processing speed and overall system performance.

Created JOB’s for batch of SQR’s that run as a stream of processes.

Global Payroll Implementation Project which involves Germany, UK, India, Sweden, France, Dubai and Canada.

Extensively worked on retrofitting the custom Canadian hire CI’s.

Retrofitted the SQR’s for Canada.

Built a component Interface app engine that accepts two inbound data from file and staging table to process POSITIVE INPUT for employees for Global Payroll.

Created custom App Engines for One Time Positive Input. Used Delivered CI for this process.

Handled the latest PUM updates and retrofitted the delta objects.

Created complicated pages that take care of Approval rules which deal with Reordering and Re-Sequencing of the rules when the user makes any changes to the rules.

Coded the pages for random inserts, deletes and modify of the rules on the page.

Involved in Requirement gathering, creating technical design and conducted code reviews for the code developed by other users.

Experience on custom module (Smart ERP) used New Hire Automation.

Created App engine that sends out electronic Year End consent to the Employees based on their personal information.

Modified personal data page to make the Year End Consent visible on the user data.

Experience in Year-end reports processing and budgeting.

Environment: PeopleSoft HCM 9.2 (HR /TAM, GP, AM), ELM (9.2) People Tools 8.52/8.53/8.54/8.55 People Code, App Engine, Component Interface, SQR Oracle.

TXDOT, TX Apr’14 – Oct’14

Role: PeopleSoft Developer/Analyst

Project: Design, Development and Reporting

Responsibilities:

fixed bugs in TAM conversion with related content services and web profile configuration.

Handled offshore team in Manila and guided them in retrofitting CAPPS customizations.

Worked with the team in fixing the code which can work with the CAPPS customizations.

Though we followed waterfall model we had daily morning standups and evening status meetings to get an update.

Involved in the upgrade project for retrofitting the customizations and leading the team in Manila.

Involved in the end user meetings and gathered requirements for enhancements during the upgrade process.

Heavily involved in system testing for TAM, Account Receivables and Account Payable modules.

Modified existing App packages to add security for CAPPS customizations.

Extensively involved in fixing the defects caused by the upgrade from 9.1 to 9.2.

Retrofitted customizations in 9.2 environments that are needed for Texas state agencies.

Generated compare reports between 9.1 and 9.2 environments to retrofit security for different roles in TAM such as Recruiter, Hiring Manager, Recruitment Administrator.

Modified existing BEN100a SQR to fetch the termed dependents only from the past 35 days instead of getting the old data from the time the employee has been hired.

Modified the Paycheck program (Pay003 and Ddp003) XMLP to modify the report as per the user requirements.

Good knowledge on CAPPS payroll as I was involved in retrofitting customizations and also did enhancements.

Involved in testing pages, components and role security for different modules by interacting with users and gathering requirements.

Environment: PeopleSoft HCM 9.2 (HR /TAM), FIN 9.2 (AP, AR) People Tools 8.52/8.53 People Code, App Engine, Component Interface, App Packages SQR Oracle, Windows 7.

EZCORP, TX Mar’13 – Apr’14

Role: PeopleSoft Developer/Analyst

Project: Design, Development and Reporting

Responsibilities:

Extensive Experience on core HR module for conversion of JOB, PERSONAL DATA and POSITION DATA in both 9.1 and 9.2 environment.

Created DEPTID’s, JOBCODE’s, LOCATION’s mapping from old to new data and loaded the CSV file into records using File layouts which would be used for conversion process.

Heavily involved in upgrade of PeopleSoft from 9.1 to 9.2 and tools 8.52 to 8.53.

Converted the HR and payroll data for Canada.

Converted the benefit data and payroll data into the new environment after loading the job rows job rows only for the employees that were converted in the new system.

Created new positions using Component Interface CI_POSITION_DATA for the conversion process in the new system.

Loaded the Personal Data from the old system to the new system using CI_PERSONAL_DATA during the conversion process.

Created the hire rows for the employees in the new system based on the source systems JOB information using CI_JOB_DATA_EMP with the action HIR.

Loaded update rows for the employees having a specific criterion based on the information gathered from the user using CI_JOB_DATA and loaded the rows that would be useful for the conversion process.

Setting up TL rules, rule programs and the related TL configuration items.

Setting up AWE, Time and Labor Security.

Involved in Time Approvals and Payable Status.

Integrating with third party Time entry systems using TCDs.

Created Component interfaces which create job posting on the Job Portal using TAM.

Modified the front-end job portal to accommodate additional Applicant information needed by the third-party websites for TAM.

Integrated the third-party company database with PeopleSoft database for getting the application test information and results for TAM.

Created conversion row for all the active employees in the new system with a conversion date which have position number in them along with reports to information.

Heavily involved in production support for the old system on Benefits, Payroll and core HR modules.

Carried forwarded all the customizations made to the SQR’s and Application Engines during the process of upgrade from 9.1 to 9.2. In HR modules such as Payroll, Benefits and TAM.

Worked on setting up full and incremental sync from HR to FIN using Integration Broker.

The incremental Sync was setup to load a person data into finance when a person was added in HR using Integration Broker.

Worked on Service operation, service handlers and routings to enable Integration Broker sync.

Modify the Application engine (B_BAS200) which would run after the PayCalc (PSPPYRUN) to calculate the adjustments that would be reflected on the Pawn stores side.

Developed online objects using Application Designer as per the design requirements and extensively used PeopleCode (Record PeopleCode, Application Engine PeopleCode and CI PeopleCode) for the online validation and to implement the business rules.

Provided functional assessment for current PeopleSoft business processes and recommended improvements for processing in 8.9 environments and provided documentation for all future JOB data load process.

Environment: PeopleSoft HCM 9.2 (HR /Payroll/ Benefits/TAM/Time and labor) People Tools 8.52/8.53 People Code, App Engine, Component Interface, SQR Oracle, Windows 7.

Allegis Group, MD Oct ‘12-Feb 2013

Role: PeopleSoft Developer

Project: Upgrade, Development and Production Support, Transition.

Responsibilities:

Provide production support for HCM, General Ledger and Asset Management Modules.

Performed PeopleSoft Server administration for all Production and Non-Prod servers hosting HR and Finance applications.

Was extensively involved in transition from Peoplesoft to SAP on HR modules.

Wrote programs to convert legacy peoplesoft HR data to SAP acceptable data.

Extensively involved with the Data Center Move and setting up the DR Environments.

Modified the Startup and performance Unix Shell Scripts for the new 9.1 environments.

Extensively involved in Administering PS Admin Tool and setting up and correcting the configuration settings of Tuxedo, Process Scheduler, Web Server and Jolt.

Created a Benx040 which is a custom benefit integration process that was created to send over the Benefit information to PeopleSoft that the client receives from CYC (Connect your care).

Created a Custom process to send over the information to TALX vendor for the employees enrolled into benefits.

Environment: PeopleSoft FSCM 8.8, HCM 9.1, People Tools 8.49, 8.51, Oracle 10g.

Hilton Worldwide, TN July’11–Oct’12

Role: PeopleSoft Developer/Analyst

Project: Design, Development and Reporting

Responsibilities:

Working on Performance Tuning the IC-AR Inbound - Item Status update process.

Resolved issues for CARS Pending Items based Single Assessment Process.

Resolved Issues in CLAIMS for Voucher Generations Process.

Performance Tuning of PS Queries.

Verified and compared all the process performances during the database upgrade.

Worked on Modifying the nVision Reports per Business Requirements.

Created and Modified PS Queries using AR, AP, CARS, CLAIMS, GL Tables as per Business Requirements.

Resolved issues in GL where users were unable to use the "Drill to Source" Option to view underlying Vouchers for the Journals.

Extensively worked with the HCM Upgrade team and functional users in order to develop, support and resolve technical issues in Workforce Administration, Payroll, Benefits, Time and Labor during the upgrade from v8.8 to v9.0.

Extensively involved in data analysis and conversion programs and reviewed the compare reports, performed fit gap between 8.8 and 9.0, tune the Data, load Application Engine programs and actively involved in the testing and issue resolution during the parallel test and the post-production support.

Developed several reports for Pension Administration which Provides summary information about a calculation and its benefit formulas. This SQR report showed each benefit formula processed during the specified calculation.

Involved in setup and design of automated benefits enrollment process, setting up core tables in HR and Benefits Administration, defining eligibility rules and creating event rules.

Environment: PeopleSoft HCM 9.0, People Tools 8.49, Oracle 10g.

FedEx PA Dec’10 – May’11

Role: PeopleSoft Developer/Analyst

Project: Design, Development and Reporting

Responsibilities:

Worked on customized module CDAS. It basically deals with the running of payroll for the truck drivers and the ISP’s associated with them.

Extensively worked on Application Engines which would calculate the price for the scanners leased by the ISP. The Application engine would even calculate the adjustments required for the disputes filed by the ISP’s for the invoices sent.

Designed the Bill Calendar pages that would allow the users to assign an Invoice Run Id’s to the bill cycle. This Bill Period would be further divided into sub-periods for which the billing for that sub-period would be calculated and send to the ISP’s respectively.

Extensively involved in data conversions and generated the flat files from tables then used Import Manager, SQR, and SQL Plus to insert the data into PeopleSoft.

Created pay calendars to process payrolls.

Developed Conversion Programs to move data from the legacy system into PeopleSoft tables using SQR as the primary tool and generated status reports after performing validation.

Developed Inbound and Outbound interface to validate and send Payroll Data.

Used UNIX environment to run the Interface and different reports that were developed.

Developed Application Engine programs and used File Layout and Component Interface to load data from flat file to PeopleSoft system. Written and modified PeopleCode for validations.

Involved in analysis, design, development, testing and implementation of PeopleSoft HRMS, Payroll, Benefits, Billing, Account Receivables, General Ledger and benefits administration modules.

Environment: PeopleSoft HCM 9.0 (HR /Payroll/CDAS/T&L, TAM) People Tools 8.50 People Code, App Engine, Oracle 9i, XP.

Wake Forest and Baptist Health, NC July’09–Nov’10

Role: PeopleSoft Techno/Functional and Upgrade Consultant.

Project: Upgrade Project

Responsibilities:

Involved in Integrating PeopleSoft with, ADP using PeopleSoft Payroll Interface and Involved in implementing the Interface of PeopleSoft with external Payroll system, sending PeopleSoft HR data to ADP Payroll services

Worked with creating a new Job entry process. This took care of the requests made by various departments to accept the new employees (or changes to the existing information) as entered by them.

Modified existing workflows like promotion and salary change approval from a two-step to three step process. Worked on AR Auto Maintenance Process modifications and made changes to the delivered (AR_AUTOMNT) AE Program to meet Business Requirements.

Heavily involved with customer statements issue where statements were being sent to Incorrect Customer Address. Modified the SQR.

Developed an Interface process using sqr to load the invoice data from the external system IC2 to FMIS Accounts receivables (Inbound IC2- AR Process).

Developed an Interface process using sqr to load the Penalties data from the external system CIS to FMIS Accounts receivables (Inbound CIS - AR Process).

Environment: PeopleSoft HRMS/FSCM/ELM 8.8/8.9, People Tools 8.48, DB2.



Contact this candidate