Profile Summary
[pic]
. *+ years of IT experience with an emphasis in PeopleSoft
Implementation/Upgrade /Maintenance/Support/Integration.
. Diversified experience covering all stages of life cycle
implementation: Requirements gathering and analysis, Fit-Gap analysis,
design, development, data conversion, unit, integration and system
testing, end user testing/training, Implementation, upgrade, Post-
implementation support.
. Technical expert in using Application Designer, SQR, PeopleCode,
Application Engine, ExcelToCI, Component Interface, Integration Broker,
Crystal Reports, nVision, Process Scheduler, PS Query, Process Monitor,
Data Mover and File Layout.
. Developed complex reports using SQR, File Layouts, Application Engine,
Crystal reports, PS Query and nVision.
. Excellent functional knowledge and project experience in the areas of
PeopleSoft HCM Core HR, Base Benefits, Benefits Administration, Position
Management, ePerformance, Profile Management, NA Payroll, eDevelopment
and functional understanding of all HCM modules.
. Have excellent analytical, problem solving, communication and
interpersonal skills with ability to interact with individuals at all
levels.
. Motivated team player and leader willing to accept exciting new
challenges and with sound understanding of the IT industry.
Skills
[pic]
ERP : PeopleSoft HCM 8.x,8.8,8.9, 9.1
Core HR, Base Benefit, Benefits Administration,
ePeformance,
Profile Management and NA Payroll (Time and Labor,
Position
Management) Functional Understanding of all HR
modules.
PeopleSoft F/SCM 8.x, 8.4x, 8.8 (AP,AR)
PeopleTools : PeopleTools (8.18, 8.43, 8.45, 8.47, 8.48,
8.49, 8.50,8.51), Application
Designer,
Application Engine, Process Scheduler, Data Mover,
Workflow,
Tree Manager, Change Assistant
PeopleSoft Reporting : SQR, Crystal Reports, PS/Query, nVision
Integration Tools : File Layout, Integration
Broker/AppMessaging,Component Interface,
ExcelToCI
Languages : PeopleCode, SQL, COBOL, C
RDBMS : Oracle 9i, 10g,11g, MS-SQL Server
2000, 2005
OOP : C++, Java
Operating Systems : Windows 95/98, Windows 7/NT/2000/XP, UNIX
Others : Microsoft Office (Word, Excel, Power
Point),Remedy, Putty, Toad,
beyond
compare, Cisco VPN, Core FTP, Crimson Editor,
Oracle
Enterprise Manager, HP QC, PHIRE, Editplus
Education
[pic]Masters in Computer Science
Bachelors in Computer Science
Training & Certification
[pic]
PeopleTools Developer Certified Expert
Professional Experience
[pic]
PeopleSoft 9.1 HCM Integration for Verizon - Irving, TX Oct '12 - Feb
'13
PS Techno-Functional Consultant
Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, Base Benefits, Benefits
Administration and NA Payroll, Profile Management) PeopleTools 8.52 and
Oracle 11g
The scope of the project is to merge multiple PeopleSoft systems into one
integrated system. Retrofit/migrate custom reports and PeopleSoft
customizations to one integrated environment/system.
Key Responsibilities:
. Retrofit/migrate page and PeopleCode customizations.
. Create mapping and design documents
. Retrofit SQR, Application Engine, crystal and XML reports/processes
. Migrate custom data and integrated environment
. Create custom scripts for integration
. Work with functional team and users to resolve integration issues
PeopleSoft 9.1 HCM Upgrade for COX Enterprises - Atlanta, GA Jan '12
- Oct '12
PS Techno-Functional Consultant
Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, Base Benefits, Benefits
Administration and NA Payroll, Profile Management and Time and Labor)
PeopleTools 8.51 and Oracle 11g
The scope of work for this project is to upgrade their existing PeopleSoft
HCM 8.9 system to PeopleSoft HCM 9.1 along with implementation of newly
added requirements. Retrofit customizations and use any new
functionalities.
Key Responsibilities:
. Retrofit page and PeopleCode customizations
. Resolve and Interact with users for closure of issues
. Involved in data validation
. Help users configure new application
. Retrofit Profile Management and eDevelopment customizations
. Retrofit COBOL, SQR and Application Engine programs
. Work on Tax updates and bundles in 9.1
PeopleSoft 9.1 HCM Upgrade for CapitalOne - Richmond, VA June '11 -
December '11
PS Techno-Functional Consultant
Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, ePerformance, Base Benefits,
Benefits Administration and Payroll Interface), PeopleTools 8.51 and Oracle
11g
The scope of work for this project is to upgrade their existing PeopleSoft
HCM 8.8 system to PeopleSoft HCM 9.1 along with implementation of newly
added requirements. Retrofit customizations and use any new
functionalities.
Key Responsibilities:
. Retrofit custom workflow
. Modify custom HTML and Java code to fit in new environment
. Retrofit page and PeopleCode customizations
. Interact with users for closure of issues
. Work with Oracle on issues/bugs
. Involved in data validation
. Create custom upgrade scripts
. Support during stabilization period
PeopleSoft 9.1 HCM Upgrade/Support for Trinity Industries - Dallas, TX
March '10 - June 11
PS Techno-Functional Consultant, Customizations migration and Upgrade
Issues Lead
Environment: PeopleSoft HCM 8.8, 9.1 (Core HR, Base Benefits, Benefits
Administration and NA Payroll)
The scope of work for this project is to upgrade their existing PeopleSoft
HCM 8.8 system to PeopleSoft HCM 9.1 along with implementation of newly
added requirements. Retrofit customizations and use any new
functionalities.
Key Responsibilities:
. Lead Activities:
. Project time/effort estimation and tracking. Reporting to program
manager/steering committee
. Single point of contact to business for all upgrade project related
issues/questions/concerns
. Coordinate with functional analysts to ensure application is
rightly configured and designs meet user requirements
. Coordinate/support with offshore for upgrade activities
. Requirement Analysis/Fit Gap/Estimate LOEs/Project Planning:
. Analyzed client's requirements with a view of fitting them to
PeopleSoft HCM 9.1 application so as to minimize customizations and
make the upgraded application maintenance friendly
. Estimated level of efforts and derived a high level project plan
using compare reports, release notes and other tools
. Work with Oracle on issues/bugs
. Setups done include:
. Configure Job Subfunction and Job Code Table based on 8.8 Job
Profile IDs
. Configure Employees refresh process (PER099)
. Retrofit Ethnic groups and Military status from custom fields
. Retrofit Dependents Effective date field from custom field
. Benefits Rate Tables
. Employee Name formats
. Personal information page defaults
. Turn off type ahead feature as it affects data entry
. Functional, Technical Designs:
Major designs include:
. Document all custom processes and customizations identified in
compare reports
. Document Surebridge process which moves files generated by
processes to desired folders
. Document new functionalities that are going to be used in the new
system
. Document changes to be done for process retrofit with time/effort
. Customizing pages/components/reports/views for flexible and
efficient month-end closure
. Analyse, design, cleanse, retro fit PS-Queries
. Document Migration process
. Build & Testing:
. Coordinate build of the components per business design requirements
. Coordinate with functional analysts for unit testing
. Coordinate with users for UAT
. Lead UAT issues and assign/drive them to closure
. Maintained all upgrade environment servers
. Coordinate with DBAs for any server related issues
. Debugged conversion application engine programs to populate missing
data
. Written complex custom sql/sqr/app engine scripts to
correct/retrofit data (custom data)
. Re-applied/migrated PeopleCode customizations.
. Coordinate with load testing team to replicate some transactions in
new environment for performance check
. Retrofitted queries. Replaced modified/replaced records/fields and
joined with other records/fields in queries to match the results of
8.8. Created PS project through sqls to include queries for
migration.
. Modified SQRs to run in 9.1 environment.
. Deployment:
. Moved approved retrofitted customization to GOLD (Upgrade Staging
environment) using projects
. Managed security
. Coordinated dry runs
. Part of Managing environment creation, configuration and deployment
. Part of End-to-End Go-Live Deployment
. Performed and validated conversions
. Worked on change assistant for building environments
PeopleSoft HCM Support for Trinity Industries - Dallas, TX Dec '08 -
Feb '10
PS Techno-Functional Consultant, Support Lead
Environment: PeopleSoft HCM 8.8 (Core HR, Base Benefits, Benefits
Administration and NA Payroll)
The scope of work is to support/maintain/enhance existing HCM 8.8
application.
Key Responsibilities:
HCM 8.8 suite support/maintenance:
. Lead activities:
. Case analysis/assignment - Analyze cases and assign to appropriate
team member. First level user contact for any questions/concerns
about the case assignment, progress and delivery.
. Analyze and Estimate Time/Efforts: Analyze and estimate cost for
all new enhancements. Gathering requirements, performing fit-gap,
getting sign-off from the user. Assigning to team for low level
design.
. Miscellaneous project activities - Quality control (check lists,
approvals, reviews), delivery management (status meetings,
approvals, sign-off) and migration management (migration docs).
. Prepare SOX Audit, QR100, WSR project reports
. Monitor Time entry of the project. Make sure time entered correctly
for discretionary projects.
. Core Application Support:
Common support issues include:
. Modify/maintain benefits enrollment forms
. Payroll: Setting up pay calendars, building paysheets, debug COBOL
programs for payroll
. Kronos to PeopleSoft payline load issues
. Created functional and technical documents for change requests
. Customize reports/processes as per user requirements
. Monitor the system: Servers, process scheduler, schedule processes
. Applied Tax updates and standard patches
. Enhancements:
. Created 401k and pension vendor interfaces (Inbound and outbound)
Written SQR interfaces as there was change in vendor. Outbound
includes all employees personal, employment, loan and 401k
deduction details for the report run period. Inbound contains new,
default, closed, paid off and re-amortized loans details and
deferral amounts.
. Organization wide company changes from alpha to numeric
Identified interfaces and processes effecting the company format
change. Updated Job data company with the new numeric format using
component interface. Modified all processes affecting the change in
format.
. Reporting tables generation.
Client wants to standardize the reporting of various HR and Payroll
statistics. In the past, several individuals were involved in
producing reports and sometimes different results were produced due
to timing or a slight difference in calculating the statistics. To
accomplish this task i developed reporting tables SQR refresh
process where various statistics are pre-calculated and stored in
records on a daily basis. These tables can be used for reporting
by corporate and all the operating companies. This resolved data
inconsistencies and standardized the reports.
. Fixing payroll issues and modifying/maintaining payroll interfaces.
. Created new projects/activities
. Written new (sqr/PS-Query) reports/queries
PeopleSoft Financials Upgrade for SCA - Birmingham, AL Jun '08 - Nov
'08
Senior Software Engineer
Environment: PeopleSoft F/SCM 6.0, 9.0 (AP, AR,GL)
The scope of work is to upgrade existing Financial system from 6.0 to 9.0.
As there is no upgrade tool available to upgrade 6.0 to 9.0, re-
implemented along with newly added requirements.
Key Responsibilities:
. Requirement Analysis/Fit Gap/Estimate LOEs/Project Planning
. Created Technical Design documents as per functional requirements
. Estimated level of efforts for the technical requirements
. Build & Testing:
. Created custom upgrade scripts for Voucher, Vendor and Payment
conversion.
. Applied customizations to Requisition Header page
. Created Wachovia bank Reconciliation process
. Modified GLS7002(General Ledger Detail) and PORQ009 (Requisition
Reconciliation) reports
. Deployment:
. Coordinated dry runs
. Migrated customizations through projects across environments
PeopleSoft HCM support for Perot Systems - Plano, TX Aug '07 - May'08
Senior Software Engineer, Technical Support Lead
Environment: PeopleSoft HCM 8.8 (Core HR, Base Benefits, Time and Labor,
Learning and Development)
The scope of work is to support/maintain/enhance existing HCM 8.8
application.
Key Responsibilities:
HCM 8.8 support/maintenance:
. Lead activities:
. Case analysis/assignment - Support Issues handled through Remedy
tool. First level of contact for any Technical questions/concerns
about the case assignment, progress and delivery. Analyze cases and
assign to appropriate team member.
. Analyze and Estimate Time/Efforts: Analyze and estimate cost for
all new enhancements. Gathering requirements, performing fit-gap,
getting sign-off from the user. Assigning to team for low level
design.
. Organizing user forums - Organize calls with user groups (APAC,
Americas) to get feedback on support activities and gather new
ideas and requirements.
. Miscellaneous project activities - Quality control (check lists,
approvals, reviews), delivery management (status meetings,
approvals, sign-off) and migration management (migration docs).
. Encourage team for new ideas for process improvement. Automated
several manual process which improved support quality and accuracy.
. Core Application Support:
Common support issues include:
. Time and Labor: Issues regarding Time entry and approval
. Document Nightly Batch Jobs on daily basis called Check-outs.
Created an automated process using sqrs and shell scripts.
. Learning and Development: Issues regarding Course request and
approval work flows
. Base Benefits: Issues regarding Employees Benefits changes
. Worked as a primary on call, dealing with production failures
(Batch Process failures, rollback errors, script failures, etc) and
its resolution. Troubleshooting support issues dealing with
Application Engine, Component Interface, PeopleCode, SQR, Unix
scripts, workflow
. Created custom SQL updates to the database with DBA for issues that
can't be modified through application.
PeopleSoft Financials Re-Implementation for Vanguard Car Rental Inc -
Tulsa, OK Feb '07 - Jul '07 Software Engineer
Environment: PeopleSoft F/SCM 8.9 (AP, AR, GL)
The scope of work for this project is to upgrade existing PeopleSoft F/SCM
7.05 system to PeopleSoft F/SCM 8.9. The work involved analyzing and
reconfiguring, retrofitting customizations in the newer version, design and
development of interfaces and reports.
Key Responsibilities:
. Analyzing, designing and developing interfaces and conversions.
. Worked on reports that lists Open Items by Customer in different
buckets based on the time period which are not yet billed through
Odyssey as reflected within PeopleSoft Accounts Receivable.
. Reapplying queries and reports as per customer requirements.
Reapplied 600+ queries with the help of freshers who just got inducted
into the practice. My role was to mentor and monitor the queries
creation.
. Testing and review: Unit testing and peer reviewing the work units with a
view to deliver high quality deliverables.
PeopleSoft HCM support for VISA International - San Francisco, CA Jul '06
- Jan '07
PeopleSoft Developer
Environment: PeopleSoft HCM 8.8 (Base Benefits, Core HR)
The scope of work for this project is to support PeopleSoft HCM system.
Key Responsibilities:
. Developed Queries using Query Manager depending on the Functional and
Business analyst's requirements
. Created Technical specifications based on the given functional
specifications
. Developed inbound and outbound interfaces using SQR's
. Performed Unit Testing on various modules and prepared suitable test
cases
. Modified Crystal Reports depending on the Functional and Business
analyst's requirements
. Created LTC (long-term care) Report to enable HRIS provide a monthly data
file of current and termed employees to enable vendor to properly
administer this new program
1. Soft Systems Solutions Oct '04 to Jul '06
PeopleSoft Developer
(References and other details on request)