SUMMARY

• Over 12 years of experience in the field of software design, development, upgrade & maintenance of PeopleSoft applications with Oracle, SQL Server and Informix as the back end databases.
• PeopleSoft Technical and Functional experience in customization, implementation, development, deployment, integration, reporting and support of PeopleSoft Financials, Strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, File Layout, Process Scheduler, Integration Broker, Query, XML Publisher and Data Mover), SQR, nVision and Crystal Reports.
• Self - motivated person with strong debugging, problem solving, and analytical skills.
• Proficient in preparing complex reports using SQR and PS Query.
• Have good knowledge on PeopleSoft Upgrade methodology.
• Have knowledge on PeopleSoft Update Manager (PUM).
• Have good knowledge on PeopleSoft AWE.
• Excellent troubleshooting and problem-solving skills.
• Having good knowledge on Asset Management, General Ledger, Account Payables, Account Receivables, Billing and Purchasing modules.
• Thorough knowledge of RDBMS fundamentals, SQL plus, PL/SQL scripting and 2-tier and n-tier PeopleSoft application architecture.
• Created and maintained Technical Specification, Test Case and Migration Documents.
• Applied latest Bundles and Patches Provide by PeopleSoft to fix certain PeopleSoft Delivered issues.
• Good knowledge on Oracle.
• Have good knowledge on UNIX.
• Have knowledge on PS Admin tasks.

TECHNICAL SKILLS

Development Tools: Application Designer, People Code and Application Engine.

Reporting Tools: SQR, PS Query, XML Publisher and Crystal Reports.

Integration Tools: File layout, Component Interface, Integration Broker.

Data Management Tools: Data Mover and Change Assistant.

ERP: PS Financials 8.4/8.9/9.0/9.2 and PeopleTools 8.46/8.49/8.50/8.53.

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

Databases: Oracle 9i/10g/11g, SQL Server 2008, Informix.

Operating Systems: UNIX, Windows 2003, 2008.

People Tools: Application Designer, Application Engine, Component Interface, Tree Manager, PS Query, People Code, File Layout

PROFESSIONAL EXPERIENCE

Confidential, Chevy Chase, Maryland

Techno-Functional Consultant

Responsibilities:

• Prepared Technical Design documents for the various gaps identified during the Fit-Gap phase.
• Displayed expertise in retrofitting of Online Components, Processes - (AE/SQR), Reports - ( SQR/Crystal)
• Responsible for assisting in SIT and UAT phase.
• Analyze compare reports and find the customizations.
• Evaluate new application features/functionalities for use.
• Prepare test scripts for AM, PO, CM and GL modules and testing the configured scenarios, Unit testing, System and Integration Testing.
• Performing Fit/Gap analysis for the existing 9.0 functionality compared to delivered 9.2 functionality.
• Setup the Asset Disposal Approval using AWE and customized the code to send the notification e-mail to outside PS users and list all Disposal Asset details in single e-mail.
• Setup the Requisition Approval using AWE.
• Perform retrofitting of all customizations and bolt-on's in higher upgraded version.
• Responsible for Migrations and troubleshooting for team.

Environment: PeopleSoft windows workstation and Web Client, Solaris Linux, Oracle 11g, PS tools 8.51/8.53.16 , PeopleSoft FSCM 9.0/9.2, Quest Stat.

Confidential

Techno-Functional Consultant

Responsibilities:

• Analyze, design, develop and test requirements.
• Participate in technical fit/gap workshops.
• Development & Unit Testing.
• Provided support for SIT, UAT and Release Activities.
• Customizing the application based on requirement.
• Analyzed the various setups required for implementing PeopleSoft as per clients requirement.
• Developed the new SQR’s and crystal reports as per the user requirements.
• Work closely with the onsite team/customer to gather business requirements.
• Developed the extract using App Engine, File Layout and CI to read the rejected payments data and cancel the payments in PeopleSoft AP system.
• As per user statutory requirement to send all vendors balances data, setup the withholding and developed the outbound interface.
• Developed the inbound interface to load the invoice data from Buysmart system to create the vouchers in PeopleSoft system.
• Developed the custom component to maintain the commodity code data in PeopleSoft system as per the requirement.
• Developed the App Engine program to unitize the assets and update the required fields from invoice staging tables to asset interface tables to pass the data to assets as per the requirement.

Environment: PeopleSoft windows workstation and Web Client, Solaris Linux, Oracle 11g, PS tools 8.51, PeopleSoft Financials 9.1, Quest Stat, HP QC.

Confidential

Techno-Functional Consultant

Responsibilities:

• Resolved the support issues raised by end users.
• Development & Unit Testing.
• Optimized the application code for Performance gain.
• Customizing the application based on requirement.
• Developed the new SQR’s and scripts as per the user requirements.
• Developed the interface to send data to non-PeopleSoft system.
• AM data conversion from external system (FXA-Main Frame system) into PeopleSoft AM system.
• Scheduling the process using Control-M scheduling tool.
• Responsible for migration of projects from one environment to another environment.

Environment: PeopleSoft windows workstation and Web Client, Sun Solaris UNIX, Oracle 10g, PS tools 8.44/8.46, PeopleSoft Financials 8.4/9.0.

Confidential, Overland Park, KS

Technical Consultant

Responsibilities:

• Prepared Technical Design documents for the gaps identified during the Fit-Gap phase.
• Retrofitting of Online Components, Process - (AE/SQR), Reports - ( SQR/Crystal Reports)
• Responsible for Migrations and troubleshooting for team
• Provided the assistance in SIT, UAT and warranty phase.
• Fit gap analysis between 8.8 & 9.1 applications.
• Ran compare reports for 8.8, 9.1 versions and analyzed the customizations.
• Customized SQR’s according to user requirements.
• Installed new software Peoplesoft HRMS version 9.1 & People Tools 8.5.

Environment: PeopleSoft windows workstation and Web Client, AIX UNIX, Oracle 8i/11g, PS tools 8.44/8.5, PeopleSoft HRMS 8.8/9.1.

Confidential, Toledo, Ohio

Technical Consultant

Responsibilities:

• Conducted research on the system requirements and technically evaluated the Project.
• Restructured the components to accommodate new structure.
• Developed the new sqr’s/Crystals and modified the existing sqr’s/Crystals to accommodate the new structure.
• Assistance in SIT, UAT and warranty phase.
• Optimized the application code for Performance gain.
• Developed the new components to provide the manager access to proxy users.

Environment: PeopleSoft windows workstation and Web Client, UNIX, Oracle 9i, PS tools 8.46, PeopleSoft HRMS 8.8.

Confidential, Richmond, Virginia

Technical Consultant

Responsibilities:

• Smooth Production technical support.
• Resolving the critical issues within the time limit.
• Process and Interface creation for integrating the Third Party Applications and files.
• Applied latest Bundles and Patches Provide by PeopleSoft to fix certain PeopleSoft Delivered issues.
• Created and maintained many Technical Specification, Test Case and Migration Documents.
• Maintained all code Reviews, Design Review and Test Reviews.
• Configured the Application Server, Web Server and Process Schedulers.
• Documentation of migration plans and Migrated the PeopleSoft projects to Production database.
• Job Monitoring and Status check.
• Extensively used Data Mover to refresh production data with other development environments.

Environment: PeopleSoft windows workstation and Web Client, HP UNIX, Informix, PS tools 8.49, PeopleSoft Financials 9.0.

Confidential, Richmond, Virginia

Technical Consultant

Responsibilities:

• Retrofitting of Online Components, Process and Reports.
• Provided the assistance in SIT, UAT and warranty phase.
• Customized processes according to user requirements.
• Analyze compare reports and find the customizations.
• Participate in technical fit/gap workshops.
• Performing Fit/Gap analysis for the existing 8.4 functionality compared to delivered 9.0 functionality.
• Analyze all the technical enhancements brought in by PeopleSoft in higher version.
• Perform retrofitting of all customizations and bolt-on’s in higher upgraded version.

Environment: PeopleSoft windows workstation and Web Client, HP UNIX, Informix, PS tools 8.46/8.49, PeopleSoft Financials 8.4/9.0.

Confidential, Richmond, Virginia

Technical Consultant

Responsibilities:

• Smooth Production technical support.
• To analyze, design, develop and test resolutions for service requests and bugs reported.
• Resolving the critical issues within the time limit.
• Coordination with the Functional team and the offshore team.
• Adhering to quality audit
• Developed the interface which will fetch the data from PeopleSoft Ledger Table, and sending to AS/400 system.
• Process and Interface creation for integrating the Third Party Applications and files.
• Applied latest Bundles and Patches Provide by PeopleSoft to Fix certain PeopleSoft Delivered issues.
• Created and maintained many Technical Specification, Test Case and Migration Documents.
• Maintained all code Reviews, Design Review and Test Reviews.
• Configured the Application Server, Web Server and Process Schedulers.
• Documentation of migration plans and Migrated the PeopleSoft projects to Production database.
• Job Monitoring and Status check.
• Customizing the application based on requirement.
• Enhancements to automate certain delivered PS functionalities.
• Maintained a clean environment by clearing discrepancies found in SYSAUDIT and DDDAUDIT reports.
• Extensively used DataMover to refresh production data with other development environments.

Environment: PeopleSoft windows workstation and Web Client, HP UNIX, Informix, PS tools 8.44/8.46, PeopleSoft Financials 8.4 SP2.

Confidential

Technical Developer

Responsibilities:

• To analyze, design, develop and test resolutions for service requests and bugs reported.
• Development & Unit Testing.
• Optimized the application code for Performance gain.
• Resolved the issue with Anchor fund in expense allocation process.
• Job Monitoring and Status check.
• Customizing the application based on requirement.
• Developed the new SQR’s and scripts as per the user requirements.
• Developed the extract using App Engine and File Layout to fetch the Ledger data and send to non-PeopleSoft system for reporting purpose.

Environment: PeopleSoft windows workstation and Web Client, Windows Server 2003, Oracle 9i/SQL Server, PS tools 8.43, PeopleSoft Financials 8.4.