SUMMARY:

An accomplished IT professional with over 15 years of comprehensive experience which includes implementation, customization, upgrade and maintenance of PeopleSoft applications. Strong PeopleSoft technical skills, along with business functional requirements analysis, functional and technical design documents, and excellent communication skills with functional users.

• Peopl eSoft ERP FSCM, HCM
• Business Analysis, System Integrations
• SDLC, IT Project Management Methodologies
• Analytical Problem Solving, Troubleshooting
• Process Improvement & Re - engineering
• Applications Development & Customization

TECHNICAL SKILLS

• PeopleSoft 9.x/8.x/7.x/6.x, HRMS, HCM, Financials, FSCM
• PeopleTools 8.5x/8.4x/7.5x, Application Designer, Application Package, PeopleCode, Application Engine, SQR, Component Interfaces, Integration Broker, Application Messaging, Work Centers, Fluid UI Design, Workflow, PS Query, BI Publisher, Portal
• Process Scheduler, Setup and Configuration, Compare Reports, Security Administration, Upgrade Tools, Data Mover, PeopleSoft Test Framework 8.52, Tree Manager
• Oracle 8/9i/11g, SQL Server 2012, DB2, SQL/Plus, SQL Developer, Golden 32, TOAD, Oracle Database 11g SQL Tuning
• PeopleSoft University s, Project Management s, Certified Managing IT Projects, JIRA Software, Mercury Tools, Visio, Microsoft Projects, Excel, Word, PowerPoint, SharePoint, Windows Operating Systems, Unix, Visual Basic, COBOL, C++, Google Apps
• STAT 5.6 Administration and Migration Tools, PHIRE PeopleSoft Migration, Job Scheduling Tools (TWS 8.6)

PROFESSIONAL EXPERIENCE:

Senior Software Engineer/PeopleSoft Developer

Confiddential, Anaheim, California

Responsibilities:

• Provided production troubleshooting support for PeopleSoft FSCM9.2 applications including AR, BI, eBill, AP, eSupplier, Cash Management, eSettlement, Contracts, Purchasing, Asset Management, Project Costing and Lease Administration. Performed root cause analysis to resolve and prevent issue recurrence.
• Made process improvements and streamlined the interface processes between Hyperion Essbase, PeopleSoft Contracts, Billing, and Project Costing. Designed and developed user-friendly processes starting from the front end data input to the end reconciliation queries.
• Performed as technical lead to research, cleanup and resolve post-implementation AM defect data by writing complex SQL statements. Resolved issues for Tax books Bonus Depreciation, Mass Change processes and daily open transactions for depreciation calculation. Wrote work instructions for functional users to archive data. Trimmed 95% of Depreciation reporting data to improve overall system performance.
• Performed business requirements gathering, functional design documentation and created technical design specifications for CKE Units Master Realignment project.
• Maintained interface processes between PeopleSoft HCM and FSCM. Performed programming tasks to send benefits files to 3rd party vendors.
• Designed and developed an App. Engine process to automatically update all scheduled jobs’ run control parameters according to fiscal month end business requirements.
• Worked with Oracle support to apply PUM images and patch PeopleSoft applications.
• Performed business analysis and supported the development of dashboard and reports. Created complex queries for new business functional needs. Modified and enhanced PeopleSoft-delivered BI Publisher reports.
• Developed and uploaded customer contact information to collaborate with PeopleSoft-delivered functions for billing invoice email attachment requirements.
• Provided technical support for the PeopleSoft FSCM 9.2 implementation project during UAT stage. Validated and troubleshot UAT issues for customized codes in Application Engine, PeopleCode and SQR.
• Used PeopleSoft Testing Frameworks and the User Productivity Kit (UPK). Prepared test scenarios and conducted testing with functional users throughout the project implementation testing phase.

Senior Programmer Analyst/Business Application Engineer

Confidential, Glendale, California

Responsibilities:

• Provided 24/7 production troubleshooting support for corporate PeopleSoft ERP Applications including Financial AM/AP/AR/GL modules and HCM/Payroll/Benefits.
• Used IT project management techniques as a team lead and/or team member to implement many corporate IT projects including PeopleSoft HRMS/Financials Applications and Tools upgrades, applying application bundles and patches, tax updates, systems conversion, data archiving, data cleansing, banks’ electronic files transfers and inbound/outbound interface files processes.
• Performed fit gap analysis and documented functional requirements. Wrote technical design specifications for PeopleSoft processes developments and customizations.
• Prepared Test plan, Test scripts and Test scenarios for unit testing, integration testing and user acceptance testing to ensure systems and applications integrity and quality.
• Developed work instructions and prepared materials for functional users.
• Performed Business Analysis for development of new interfaces from/to 3rd party systems, system wide changes for audit requirements, and business-as-usual application updates and alterations.
• Supported key functional users in Configuration management to adapt and control system-wide financial set-up in line with financial business requirements and corporate reporting needs.
• Fully utilized PeopleSoft Development Tools to convert and/or customize PeopleSoft delivered processes to be streamlined and automated scheduled to run. Proficient in the use of Application Designer, PeopleCode, Application Engine, Component Interface, Integration Broker, Data Mover and Process Scheduler.
• Designed and developed PeopleSoft Financials data reporting systems using PeopleSoft Reporting Tools like PS Query, XML and BI Publisher, Crystal reports, nVision and SQR.
• Utilized SQL performance tuning skills to enhance overall PeopleSoft applications performance. Fine-tuned SQL statements to speedup database processes.
• Worked closely with corporate tax department and utilized comprehensive SQL skills to reorganize tax data and saved the corporation $6 million in federal taxes.
• Established and maintained global PeopleSoft application development standards within IT development teams and provided technical guidance, as well as process expertise, to all developers to ensure projects and support tasks were efficient and in accordance with corporate policies.
• Developed and maintained the IT SOX general control programs for the PeopleSoft HRMS and Financials applications to ensure SOX compliance in all processes.
• Performed as STAT administrator to establish and execute PeopleSoft objects migration process.

PeopleSoft Applications Programmer

Confidential, Diamond Bar, California

Responsibilities:

• Converted and implemented district’s payroll and HRMS system from mainframe to PeopleSoft. Worked closely with business functional users to set up business configurations.
• Supported and maintained district’s PeopleSoft applications modules including Financials AP, GL modules and HRMS Payroll/Benefits in technical and functional aspects. Resolved functional users’ daily business process problems and issues.
• Applied PeopleSoft upgrades and performed system integration tests. Established the process steps for payroll interface to Financials GL. Designed and developed payroll, benefits costs, tax costs data interface to PeopleSoft Financials Project module. Led and supported year-end processing.
• Customized PeopleSoft delivered processes to meet the district’s special needs and tuned up slow delivered SQL statements to save overall system run time.