Professional Summary

I have a great strength in the technical arena. I have experienced with systems and business requirements analysis complements. This knowledge gives me a greater understanding overall of system analysis programming applications both functionally and behind the scene. I am seeking a challenging PeopleSoft Programmer/Analyst position, which will allow me to utilize my computer knowledge, experience, problem solving skills, and educational background.

PEOPLESOFT/WEB PRODUCT EXPERIENCE

PROJECT HIGHLIGHTS

Confidential

SQL Developer

Platform/Environment: SQL Server 2008 R2/PeopleSoft 8.0 to 9.0

• Performed/participated in a number of full projects life cycle system analysis and programming using different computer languages and applications.
• Supported, trained, and assisted the staff, faculty, and students on various software and hardware systems such as Human Resources, Payroll, Web Development, Financial Aid, Datebook Appointment System, and Time Labor modules.
• Designed, developed, and supported 114 departments and students websites. Resolved more than 745 tickets/cases using Adobe Dreamweaver CS5, Adobe Photoshop CS5, Hyper Text markup Language HTML , Cascading Style Sheets CSS and Long Beach City College Content Management System CMS application.
• Developed and implemented the Long Beach City College Datebook Counselor Appointment Scheduling System using Oracle PeopleSoft PeopleTools 8.50.13 to create new project, fields, records, views, search records, query, pages, components, sql/sqr, sql query analyzer, PeopleCode, data mover, import manager, menus, access to permission list security, put reports on Process Scheduler, and test on PeopleSoft Internet Architecture.
• Resolved more than 100 cases using PeopleSoft Tools, Structured Query Report SQR , Structured Query Language SQL Query Analyzer, customize Human Resources management Systems HRMS modules, and Data flow analysis methods.
• Met with staff, faculty, and students to design new projects/websites and assisted troubleshoot any problems end users may have.
• Coordinated, provided, and supported more than 12 end users and 28 counselors from both Liberal Arts Campus and Pacific Coast Campus to make sure the Datebook System is working properly.
• Trained, organized, and communicated with the end users regarding to the Datebook Appointment System and written up the user guide how to use the system.
• Debugged, tested, analyzed and met complex projects deadline as assigned.
• Built and setup the Datebook Appointment Systems security for end users, counselors, and student workers at Long Beach City College.
• Maintained and developed more than 20 SQR/Crystal/nVision reports and processes.
• Responsible/plan for technical and functional analysis, design/development/testing of all major customizations, bolt-on modules, conversion, internal/external system interfaces and Structured Query Report SQR /Crystal reports.
• Written up the technical documents and business process guides using Microsoft Office for all projects and cases.
• Trained by the Ciber Consultants with PeopleSoft 8.8 Student Financials, Student Financial Aids, and Student Records Modules Learned overall the functional/technical how Long Beach City College setup the tables, business flow, rules, business requirements, and resolved real cases/problems.
• Created customized reports and queries for statistic studies and internal use.
• Evaluated and helped troubleshoots users hardware, software, and internal applications problems.
• Used Crystal as a reporting tool to extract data warehouse.
• Worked with new systems and programs languages as projects required.
• Converted the Financial Aid legacy from Safers lookup pages by designed and developed new interfaces then used Import Manager to load the data from the legacy system into PeopleSoft tables.
• Supported daily the Financial Aid/EOPS modules, and learned all the functional and technical customized processes at Long Beach City College.
• Used the in house PeopleSoft Ticket System application to support/keep track of all Financial Aid and EOPS problems and issues.
• Established and accomplished the customize sqr's and used PeopleCode to implement the special functions for the Datebook Appointment System.
• Coded the Print Schedule reports SQR for the Appointment Systems, which include the Counselor's Daily Schedule, Daily Appointment Schedule s , and Daily Appointment reports.
• Utilized PeopleCode 9.0 developed and designed the logic from the Legacy system to PeopleSoft Student Administration application for the Appointment Scheduling Systems project for LBCC.
• Self-trained the PeopleSoft 9.0 Student Administration, Human Resources Management System HRMS , Nvision, Crystal Reports, Data Management, Query, Security, PeopleSoft Reporting, PeopleCode 9.0, Student Financials, Peoplebooks, and Application Designer.
• Transferred the data from the Long Beach City College legacy Appointment System to the PeopleSoft Student Administration database using Import Manager and SQR's.
• Used several tools to implement the Appointment System project such as Development, Integration, Administration, Reporting, Debugging PeopleCode, and Decision Support tools.
• Developed, created, and designed the new pages functions for Review/Update Recurring Entries, Special Appointments, Create Front Desk Pages, Front Desk/Appointment Maintenance, Print Schedule, Delete Schedules, and Counselor ID Maintenance using Application Designer.
• Learned and utilized the new Web base PeopleSoft Internet Architecture HRMS 9.0 .
• Worked and trained with the following modules: Build Community, Administer Workforce, Compensate Employees, Manage Student Records, Manage Student Financials, Define Business Rules, Administer Financial Aids, Design Student Administration, Long Beach City College Student Administration Menu LBCC Customize Module , PeopleTools.
• Created query and ran Crystal Report file and put it in the PeopleSoft menu.

Confidential

Platform/Environment: Informix/PeopleSoft 7.51/8.0

• Developed an open enrollment interface for Benefit Department using SQR. Test various payrolls to make sure the data has loaded in the system and deduction has taken from employee's health, life or disability benefits. I was a team lead for this project and Payroll and Benefit supervisors were participated.
• Developed Harrington Unemployment Interface that captures all employees that got paid and terminated for the specified Pay Period End Date.
• Developed a Department Listing report for Human Resources that maintain the listing of the employees in the department s .
• Developed a Payroll Wages Analysis report that shows the employees payroll and benefit data.
• Developed the Divestitures flat files that contain employee's personal, payroll, tax, and benefit information.
• Designed new Records and Panels definition, as well as, putting many reports and interfaces PeopleSoft on-line.
• Trained by Condol International specialists in Time Labor, Human Resources, Benefit, and Payroll Processes.
• Supported Human Resources and Payroll daily and resolved any issues that end users may have.
• Involved in the Nsync Project that synchronized two HR/Payroll systems into one single instance. These processes helped the two systems to remain consistent, applied tax upgrades to both instances of Payroll databases Hardees and CKE , and application upgrades.
• Supported all of the PCN Personnel Change Notices data collected from the current Back Office system each week that validated and approved before loading the data to PeopleSoft. This process prevents unapproved or unauthorized data from being updated in the PeopleSoft system.
• Created queries for HR/Payroll using PeopleSoft Query and SQL Editor.
• Supported end users with PCN, Paybase, Citrix Program Neighborhood, VNC, and other applications that need to resolve any HR/Payroll issues.
• Developed a training conversion data for Training Department using SQR. This SQR helped to load data from MS Access into PeopleSoft database. The Administer Training Module tables were setup and Student Training and Non-Employee Data panels were modified to fit the requirement.
• Concentrated in design, code, develop, troubleshoot, and debug new and existing reports, interfaces using PeopleTools, Sql/Sqr, and PeopleCode.

Confidential

Platform/Environment: Sybase/PeopleSoft 7.0/7.1

• Developed six Fringe Union interfaces for Payroll Department using SQR.
• Developed SQR's for Human Resource to import Grievances and I9.
• Created the data files for Grievances and I9 using Microsoft Access '97 and documented the
• procedures for end users.
• Modified the data conversion SQR's for the Hash Totals to validate record counts, errors, insert errors and bad errors.
• On-line changes/customizations data design, panel, menu design, as well as putting reports in the process scheduler.
• Modified the Import Definitions and Run the edit/loaded data using Import Manager.

Skills

Operating Systems: Windows 3.1, 95, 98, 2000, ME, XP, Vista Enterprise, 7, 8, Macintosh, Microsoft NT Server NT Workstation 3.51 4.0, Workgroups, MS-DOS, UNIX, LINUX

Relational Database: Microsoft Access, SQR/SQL, HTML, PeopleSoft Query, SQRW, Crystal Report

For PeopleSoft, SQL Server 2008 R2

Productivity Tools: MS Word, MS PowerPoint, MS Excel, MS Access, MS Outlook, MS Lync 2010, WordPerfect, Adobe Photoshop CS5, Adobe Dreamweaver CS5, Adobe Acrobat 9 Pro, doPDF 6, Facebook, Twitter, Internet Explorer 10, Mozilla Firefox, Safari, Google Chrome, Opera, Bing, Yahoo Messenger, Laserfiche/scanner, HP laser printers, Canon Digital Camera/Camcorder, iPod Touch/iPad, iphone5, VLC/Windows Media Player, Windows DVD Maker, Apple, HP, Dell, Toshiba, IBM, Sony VAIO, and Compaq Laptops/desktops , ESET Smart Security, LBCC CMS Content Management System Application, Windows Remote Assistant SQL Editor, Programmer's File Editor PFE , Multi-Edit, ExamDiff, TextPad, Cutftp32, JotPlus, I view32, Symantec Client Security, Gadwin Systems, Evast-virus cleaner, Adware, SnagIt, CCleaner, Winzip/7-Zip, Citrix Program Neighborhood, Paybase, VCNviewer, QmodemPro, Laplink Pro, Lotus Notes, Groupwise, Microsoft Visual Basic, Netzero, JUNO, Netscape Communicator, OzeMail, L.Ainet, MSN-Microsoft Network, Magic Partisan, Norton System Works 2002, Nut Bolt, SnagIT32