SUMMARY

• Over 10 plus years of experience in IT in analysis, design, development and testing.
• Over 9 years of experience in implementation and Upgrade in ERP applications.
• Proficient in developing customizations in PeopleSoft Financials GL, Commitment Control, AP, AR, BI, TR, T E, PeopleSoft SCM INV, CM, AM and PO and HRMS applications.
• Extensively worked with People Tools - Application Designer, Process Scheduler, Data Mover, Workflow, Integration Broker, Import Manager, Security Administrator, and Tree Manager Component Interface along with Reporting Tools - SQR, PS Query and nVision.
• Involved in upgrade projects like people tools upgrade 8.40 till 8.5 , application upgrade 8.0 to 8.4 8.8 to 9.0 and database upgrade Oracle 10i to 11g .
• Well versed in utilizing tools like PC Debugger, Application Engine trace for troubleshooting.
• Work with users and other teams to gather project requirements. Perform the analysis and design needed to produce the required Functional Design Documents FDD and Technical Specifications to ensure 100 user satisfaction e.g., no unscheduled downtime, prompt inquiry response problem resolution, journal entries applied on time and error free, etc. .
• Excellent data modeling, analytical and problem solving skills.
• Adaptable to work both as a team member as well as independently.
• Experience with SDLC and Sarbanes-Oxley compliance in the area of Segregation of Duty.

EXPERIENCE

Confidential

• Designed developed about 10 conversion programs using Component interfaces and application engines. Conversions include : Vendors, Liens , 1099 , Debts, Investments, Procurement and Revenue Contracts, FBIC Fringe Benefits , Purchase Order.
• Drafted technical specifications for all conversion programs, and updated with post-development changes.
• Developed reconciliation queries for all the conversions.
• Migrated all the conversion projects to testing environments using Stat tool.

Security Tasks

• Supporting and maintaining security for about 69,000 state wide users spreading over 72 agencies across 6 environments.
• Handled user security by creating user profiles, custom Roles, Permission Lists, Role Queries and User Preferences, custom Data Permissions, Route controls.
• Supported the Security migration to Production for Go-Live April, 2012
• Resolved Workflow incidents and issues in PO, AP and GL modules. Debugging and Re-routing WorkList items to the correct supervisor.
• Used BMC Magic to track and resolve incidents, Mercury QC for defect tracking.
• Resolved user profile Messaging errors between Portal and Financials in production.
• Maintained and updated Security handbook manual.

Environment: Fin/SCM 9.00, Tools 8.49.33, Oracle 11g, Mercury QC 9.0, Stat 5.6.2, SDE Magic 9.0

Confidential

• Modified the bank account length from 5 to 10 digits along with increasing the check length from 7 to 10 for processing AP checks.
• Worked on people code issues in AP, PO.
• Modified existing SQRs based on user needs.
• Upgraded the current Check Printer system from People Tools 8.48.08 to Tools 8.49
• Created a new crystal program NWCNCK.RPT for printing Canadian checks with a French translation of the Business entities.
• Designed technical specifications from the functional design documents for all tasks.

Environment: PS Fin 9.0, People Tools 8.48.08/8.49, Oracle 10g, UNIX, Crystal Reports.

Confidential

• Automated the PS self study completions from LMS and eliminate the manual load effort. This streamlines the process of granting access to Managers in a more timely fashion.
• Designed a new component interface program to automate the mass creation of user profiles for new and rehire employees for NA and European group templates.
• Developed a new AE program to automate global PS feeds sent to Account courier, a 3rd party system.

Environment: PeopleSoft Fin 8.9, HCM 8.9, People Tools 8.47.05, Oracle 9i, UNIX, PS/Query.

Confidential

Team member in the successful Year-End Closure and reconciliation in GL, AR, T E. The goal of reconciliation was to tie PS data to legacy and provide financial statements.

Environment: PS Fin/SCM 8.8, People Tools 8.47, Oracle 9i, UNIX, PS/Query, Crystal Reports 9.0.

Confidential

PeopleSoft 8.0, Technical AP, GL, PO

Environment: PS Fin/SCM 8.04/SP1, People Tools 8.44, Oracle 9i, UNIX, Crystal Reports 9.0.

Confidential

PeopleSoft 8.8 AP, PO, GL, TR, INV, CM

Environment: PS Fin/SCM 8.80.01, People Tools 8.46.03, DB2, UNIX, Peoplecode, PS/Query.

Confidential

PeopleSoft 8.0, Technical AP, PO, GL

Environment: PS Fin/SCM 8.19/SP3, People Tools 8.19, Oracle 9i, UNIX, Crystal Reports 8.0/9.0.

Confidential

PeopleSoft 8.4 Upgrade Upgrade of PeopleSoft 8.44 to 8.46MP5 - GL, AP, AR, AM, EX, INV, GL, AM, BI, PO.

Applied retrofits to all the objects after the MP5 application.

Environment: PS Fin/SCM 8.4/SP2/MP5, People Tools 8.44/8.46MP5, Oracle 9i, CrystalReports 9.0.

Confidential

PeopleSoft 8.8 HR, T L, AP, PC Contracts

Environment: PS Fin/SCM 8.8.0, People Tools v 8.45.11, Oracle 9i, PS/Query, Data Mover.

Confidential

PeopleSoft 8.8 Upgrade GL, AP, TR, EX, PO, INV, CM, AM

Environment: PeopleSoft v 8.8, People Tools v 8.46, Oracle 9i, Crystal Reports 9.0, Quest STAT.

Confidential

PeopleSoft 8.0 Implementation GL, AP, AM, PC, BI, Margins, HR Cap-Gemini Project

Lead Developer for analysis and development for GL, Project Costing and Margins.

Environment: PeopleSoft 8.0, People Tools 8.12 PS/Query, Crystal Reports 8.0, nVision, Oracle 9i.

Confidential

PeopleSoft upgrade 7.5 to 8.4 AR, BI, GL, Contracts, Pay/Bill, Project Costing

• Created 12 new SQR interfaces to feed Access Database with RES pay-rolling business data. RES has about 50 million in revenues each year with 3000 checks per week.
• Provided production support to functional users during weekly billing process run.

Environment: PeopleSoft v8.4, People Tools v8.42, Oracle 9i, Crystal Reports 8.0.

Confidential

PeopleSoft Upgrade GL, AR, AP, PO, AM, INV, CM, BI, Contracts

Upgraded PS GL, AR, AP, PO, AM, INV, CM, Contracts BI objects from 7.53 to 8.4.

Environment: PeopleSoft 7.53/8.4, Peoplecode, PS/Query, Crystal Reports, nVision, DB2.