PROFESSIONAL SUMMARY:

• Technical consultant with around 9 years of experience in PeopleSoft ERP
• Experience in the implementations, upgrades of PeopleSoft systems, specifically FSCM and HRMS/HCM packages
• Worked extensively on Tools: Application Designer, PeopleCode, Application Engine, File Layout, Component Interface, ExcelToCI, Application Package, Integration Broker, PS Security, Data mover, Configuration Manager and Reporting Tools: SQR, nVision, Crystal Report, XML/BI Publisher, PS Query
• Worked extensively on technologies like Data Conversion, Integration, Interfaces (Inbound/Outbound), Online Customizations
• Worked on integration between PeopleSoft to 3rd party integration using web - services
• Worked on mapping functional requirements to technical requirements
• Involved in preparation of Technical Design Documents, Development, Unit Testing, User Acceptance Testing and production support activities
• Has working knowledge of retrofitting the customizations during upgrades
• Developed reports using PS Queries, SQR, XML/BI Publisher
• Extensively worked with Security Administrator to implement security at various levels. Created Roles, Permission Lists, User Profiles, Portal Security, Folders, Content References, and Definition Security
• Developed Application engine programs for inbound and outbound processes using file layouts to load data from files to PeopleSoft system and to write data to files respectively
• Performed extensive Debugging and Performance tuning of various processes. Well versed in utilizing tools and utilities like PC Debugger, Application Engine trace for troubleshooting
• Used Excel to CI to load employee data from file to ERP system during implementation
• Created Component Interfaces to load set up data from file to PeopleSoft system using File Layouts during implementations
• Modified SQL, SML/BI Publisher, nVision and Crystal reports in the latest version
• Planning and Implementing Post-Production support and services like End-User Training, Data Archives and Reporting
• Maintained security by creating User Profiles, Roles, Permission Lists for different clients during implementations
• Migrated projects to production environments as a migration admin and assigned respective roles and permission lists
• Ran compare reports, did impact analysis, keep-drop and fit-gap analysis during Upgrades
• Extensively used Process Scheduler for setting up the reports to run at specific time
• Involved in all the phases (planning through to post go-live) of project implementation life cycle
• Participated as a trainer for PeopleSoft Interns and trained them on People Tools

TECHNICAL SKILLS:

ERP package: PeopleSoft Financials 9.2/9.1/9.0/8.9/8.8 and PeopleSoft HCM 9.2/9.1/9.0/8.9/8.8

Modules: FSCM (Accounts Payable, Accounts Receivable, Billing, PO, OM, AM, General Ledger) and HCM (Core HR, Base Benefits, NA Payroll, Time and Labor, Absence Management)

People Tools: Tools v 8.55/8.54/8.53/8.50/8.45

Development Tools: Application Designer, People Code, Application Engine, Process Scheduler, Component Interface, Integration broker, File Layout, ExcelToCI, Application package, Application Messaging, AWE, SOAP /REST based Web services

Reporting Tools: SQR, PS Query, Crystal Reports, XML/BI Publisher

Administrative Tools: Data Mover

Database: Oracle 11g/10g/9i, SQL Server

Operating Systems: Windows 95/98/NT/2000/XP, Windows7

Languages: Java, Unix, SQL, PeopleCode

Other Tools: Oracle SQL Developer, Microsoft SQL Server, TOAD, SOAP-UI, STAT

Defect Tracking Tools: HPQC

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, Arizona

Consulting Track Lead

Responsibilities:

• Upgraded the FSCM Application from 8.4 to 9.2 and PeopleTools from 8.48 to 8.54
• Work closely with the business user to create technical design documents and PeopleSoft objects to the customer business needs
• Involved in fit/gap analysis, analyze customization of online objects after reviewing the compare reports, detail design, development, testing. Troubleshoot/debug, performance tuning and Production Support. Developed and tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover
• Involved in changing Search records to establish row level security.
• Worked on SOAP based web services where handled synchronous service operations
• Worked on row set based messages
• Tested web services using handler tester and SOAP UI
• Developed Various Application Engines for the custom processes to inbound data from flat files to the database
• Developed Conversion program to load unprocessed accounting entries into GL
• Developed Queries and reports using Query Manager and XML Publisher based on the functional and business analyst's requirement
• Worked on Excel to CI, Data mover for loading bulk data into PeopleSoft system
• Managed security by creating roles and permission lists
• Customizing existing Interfaces and Queries to suit client requirements
• Perform code reviews, specifications reviews, update related logs & send regular weekly updates to client as part of our own quality process
• Give demos to the client about the finished developments before user testing

Environment: PeopleSoft v8.4, v9.2, Tools v8.48, v8.54, Oracle Database 10.2.0.x

Confidential, New York, NY

Consulting Track Lead

Responsibilities:

• Developed online customizations as per business needs to provide an end-to-end integration
• Developed bolt on pages required for interfaces & testing online applications
• Modified the delivered Positive Pay program to trigger BI Publisher reports dynamically based on the Bank Account configuration
• Developed BI Publisher reports to run based on Positive Pay form used by the bank used in the Pay Cycle run
• Involved in the conversion of AP crystal checks into XMLP version
• Developed custom CI and ExceltoCI to load chunks of data into the delivered components
• Worked on AP, AR and GL modules for data conversion purposes
• Customized the views to accomplish row level security
• Tailored PeopleCode to implement data validation and to enforce field level security
• Developed interfaces using Integration Broker
• Developed XML publisher reports to replace some old SQR reports
• Developed Pivot Grids and Pagelets as per the client requirements
• Involved in migration of the projects to qualification environment and delivering the final packages to be installed in client environment
• Wrote Data Mover scripts for Migration of Data across different Databases for the Custom and Delivered tables to fix the Data Conversion Issues
• Involved in developing test plans and test scenarios for various modules of FSCM Application to ensure proper business compliance
• Provided Technical support to SIT, UAT, and deployment
• Created Technical design document and Unit test document for all the processes developed
• Integrated FIN system with HCM systems using Web Services (Integration Broker)
• Maintained the issue log for the failed jobs as part of defect prevention plan

Environment: PeopleSoft v8.4, v9.2, Tools v8.48, v8.55, Oracle Database 10.2.0.x

Confidential, Arizona, Phoenix

Technical Consultant

Responsibilities:

• Worked on merger activities of Vons with Confidential System
• Worked on Performance tuning of major custom and delivered payroll job’s which were crucial on the PayDay
• Worked extensively on development of Conversions as per the client requirement
• Worked extensively on North American Payroll and written multiple interfaces to load data into PaySheet tables
• Worked on generation of Paysheet for Terminated employees using App Engine
• Worked on retrofitting of Sqr objects from 8.8 to 9.2 along with the new enhancements to them
• Worked on Job, Personal data & Payroll data conversions to extract and load data from Legacy system into PeopleSoft 9.2
• Worked on Inbound interfaces to load Employee Job & Personal data from PRISM to PeopleSoft
• Worked on Custom Payroll processes like SLIM & Relief which are used to pay employees based on client specific rules
• Worked on Performance tuning activities related to Payroll Jobs
• Worked on Merger related activities of Multiple Divisions into 9.2
• Converted multiple manual jobs into Automated ones thereby decreasing manual effort and increasing overall system performance
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance
• Involved in unit testing and peer testing and defect fixing

Environment: PeopleSoft v8.8, v9.2, Tools v8.49, v8.54, Oracle Database 10.2.0.x

Confidential, Highland Heights, Ohio

Technical Consultant

Responsibilities:

• Played a key role in Retrofitting PeopleSoft Objects, SQRs, UNIX Scripts
• Worked closely with the business analyst to create technical design documents and PeopleSoft objects to the customer business needs
• Developed/Carried forward/Retrofitted objects in the new environments based on the requirement - Migrated objects to the target environments using data mover
• Retrofitting objects - PeopleCode, SQL, SQRs and AEs based on the requirement and Build the objects
• Customized and tested the SQRs and App Engine programs based on new requirement
• Developed bolt on pages required for interfaces & testing online applications
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance
• Discussing and providing support during the system testing and UAT to solve any functional/technical issues that arise and finish them within SLA time lines
• Involved in unit testing, peer testing and defect fixing

Environment: PeopleSoft v9.0, v9.2, People Tools v8.49, v8.54, Oracle Database 10.2.0.x.

Confidential, Morris Plains, NJ

PeopleSoft Specialist

Responsibilities:

• Analysis of the requirements to understand the complexity/effort and impact
• Worked closely with the business analyst to create technical design documents and PeopleSoft objects to the customer business needs
• Created new PeopleSoft objects (Panels, Panel Groups, Menus, People Code, and Process Definition) based on the requirement
• Retrofitting objects - PeopleCode, SQL, SQRs, PS Queries and AEs based on the requirement. And Build the objects
• Customizing and testing the existing SQRs, PS Queries, and AEs based on new requirement
• Developed bolt on pages required for interfaces & testing online applications
• Prepared scripts and developed the conversion programs to move data from legacy to PeopleSoft 9.1 HCM system
• Prepared online reports using SQRs and Application Engines
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance
• Worked extensively on Time and Labor to send the data to the 3rd party systems
• Involved in defect fixing and send the daily status report on all the defects assigned
• Maintaining track of the defects raised and status of them

Environment: PeopleSoft v8.3, v9.1, People Tools v8.17, v8.51, Oracle Database 10.2.0.x

Confidential, Mendon, MA

Business Analyst

Responsibilities:

• Involved in preparing Keep-Drop analysis, Data Lineage, Data Mapping documents
• Created new and customized existing PeopleSoft objects (Panels, Panel Groups, Menus, People Code, and Process Definition) as per the requirement
• Played a significant role in Retrofitting PeopleSoft Objects, SQR
• Worked closely with the business analyst to create technical design documents and PeopleSoft objects to the customer business needs
• Retrofitting objects - PeopleCode, SQL, SQRs and AEs based on the requirement and build the objects
• Developed bolt on pages required for interfaces & testing online applications
• Created various permissions, roles & user profiles to fit user’s requirement
• Involved in developing test plans and test scenarios for various modules of FSCM Application to ensure proper business compliance
• Involved in unit testing, peer testing and defect fixing
• Worked on Delta changes and prepared Test scenarios
• Giving demo to the client about the finished developments before user testing

Environment: PeopleSoft v8.3, v9.1, People Tools v8.17, v8.51, Oracle Database 10.2.0.x

Confidential, Atlanta, Georgia

Business Analyst

Responsibilities:

• Involved in Keep-Drop Analysis, Impact Analysis, and Estimations
• Created new and customized existing PeopleSoft objects (Panels, Panel Groups, Menus, People Code, Process Definition)
• Retrofitting objects - PeopleCode, SQL, SQRs and AEs based on the requirement and build the objects
• Used Excel to CI to import data in higher volumes into the PeopleSoft system
• Developed an Interface to publish the Denied Party Screening data from External system to Order Management using Application Engine, File Layout and Component Interface
• Worked on online PeopleCode to meet the customizations, validations and dynamic SQLs
• Developed bolt on pages required for interfaces & testing online applications
• Created new Pages, Components for the new requirement of the client
• Developed Technical Design documents and Unit Test Case documents
• Worked on Correspondence (For generating a PDF doc online to give complete information for the user)
• Involved in unit testing, peer testing and defect fixing

Environment: PeopleSoft v8.9, v9.1 People Tools v8.49, 8.51 Oracle Database 10g

Confidential, Somerset, NJ

Technical Consultant

Responsibilities:

• Customized existing SQRs as per the new requirement
• Retrofitted People Code programs
• Retrofitted and tested Application Engine programs
• Customized existing Interfaces and Queries to suit client requirements
• Developed ad-hoc reports and ad-hoc queries and developed run control pages as per requirements and attached to menu to run SQRs
• Developed Interfaces to populate Project Costing data into Billing
• Developed Interfaces using Application Engine for writing file of employees who are eligible for Confidential Auto & Home policy based on employee status code
• Extensively used Process Scheduler for setting up the reports to run at specific time
• Involved in the daily status calls
• Involved in developing test plans and test scenarios for various modules of FSCM application to ensure proper business compliance
• Adjusting existing definitions on pages for accurate design purpose
• Involved in Keep-Drop Analysis, Impact Analysis
• Involved in Unit testing and prepared UTCs

Environment: PeopleSoft v9.1, People Tools v8.50, Oracle Database 10g

Confidential

Technical Consultant

Responsibilities:

• Gathering requirements from the onsite coordinator and analyzing user requirements
• Worked as Batch monitoring person which includes ABEND analysis and quick fixing
• Worked closely with the business analyst to create technical design documents
• Involved in developing test plans and test scenarios for various modules of FSCM Application to ensure proper business compliance
• Development and Enhancement of online objects
• Configured the application to add new business logic as per the user requirement
• Developed reports using SQR, PS Query based on Technical Specifications
• Adjusting existing definitions on pages for accurate design purpose
• Modifying existing PeopleCode for Objects
• Customization of existing Interfaces and Reports to suit client requirements
• Developed Run Control Pages as per requirements and attached to menu to run custom SQRs
• Resolved Technical issues raised during the daily working of the university
• Sending the project daily status report

Environment: PeopleSoft v9.0, People Tools v8.49, Microsoft SQL Server 2005