SUMMARY:

• Possess vast experience in ERP systems, which spanmany roles, suchas Project Manager, Technical/Functional Lead, and PeopleSoft Consultant.
• Over 27+ years of PeopleSoft experience ranging from multiple implementations, upgrades, customizations, interfaces and custom bolt on.
• Over 30+ years of SQL experience andseveral years of IBM mainframe experience;whichcontribute to expertisein developing interfaces for custom and third party applications.
• Dedicated and goal - oriented person able to function with minimal supervision.
• Adhere to SDLC processesand SOX compliancy when delivering quality products and solutions to clients.
• Possess excellent analytical skills, which lends to being a primary problem solver in multiple projects with the ability to troubleshoot issues and provide solutionsin a timely manner. Jim has excellent PeopleSoft skills, both Functional and Technical, and has successfully demonstrated hisleadership skills.
• Possess experience providing production support with HRMS/Payroll (HCM), Financials (FSCM), CRM, and Campus Solutions.

PROFESSIONAL EXPERIENCE

Technical/Functional Consultant.

Confidential

Responsibilities:

• Functioned as the HCM SME in an upgrade effort from HCM 9.1 to HCM 9.2 tools 8.55 on PUM 22.
• Analyst the delta between PeopleSoft (PS) HCM 9.1 versus PS HCM 9.2 using the Cumulative Feature Overview tool (CFO) for the upgrade project
• Conducted multiple user session to demo the new PS HCM 9.2 features.
• Conducted Fit/Gap session to determine what is expended to be delivered during the upgrade project.
• Worked with the client in trying to eliminate as many customizations as possible and use delivered functionality instead.
• Came up with solutions in eliminating customizations by using the new HCM 9.2 frameworks
• Created new fluid functionality using the new tools like Tile Wizard, Pagelet Wizard, WorkCenter and Pivot Grids.
• Configured WorkCenters per client’s needs.
• Configured Guided Self Services.
• Configured Navigation Collections
• Configured New Life Events
• Configured Homepages.
• Configured New Fluid Tiles.
• Participated in the creation of test cases and the testing of the PS HCM 9.2 upgrade.
• Assisted in the creation of the Project Plan.
• Updated the project plan to reflect the progress of the upgrade project.
• Analyst the PeopleSoft HR Core data in the effort to convert into SAP Financials
• Analyst the SAP Financial for PeopleSoft Payroll processing
• Perform as a liaison between PeopleSoft and SAP
• Designed and developed multiple program for the conversion effort from PeopleSoft to SAP
• Designed and developed multiple interface processes from PeopleSoft to SAP
• Functioned as SME for PeopleSoft Payroll, Time and labor, absent management, benefits and core HR issues.
• Assisted in testing of the conversion processes from PeopleSoft to SAP.
• Assisted in testing of the interfaces between PeopleSoft to SAP.
• Developed processes for the student success and support program of California
• Supported the Student Education Plan (SEP) program for LBCC
• Created bolt on processes for the support of the student admission and counselor’s office
• Functioned as production support for HCM including payroll processing, Time and labor, absent management, benefits and core HR issues.
• Fixed production issues pertaining to HCM, Payroll, T&L, Absent Management, Benefits and CS
• Applied applications fixes
• Assisted in synchronizing CS faculty workload with HCM.

Confidential

Technical/Functional Project Manager

Responsibilities:

• Managed all phases of the software development lifecycle (SDLC) for dozens of custom solutions.
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Guided teams in the development and design of relational database management systems (RDBMS)
• Focused teams on business objectives, the improvement of business processes and tracked progress to ensure project milestones were completed on time and with the desired results.
• Generated all of the desired documentations for an easy turnover delivery.
• Worked closely with both the Technical and Functional team to design the best solution for the client.
• Managed multiple projects which is part of the Admission to Graduation university wide project which involves a Supplemental Application in used in the gathering of additional Course Work for applicants to SJSU Eligibility process, Impaction process, Transfer Credit evaluation, Pre-Matric audit and reporting.
• Oversee all of the design sessions and guided the team in the whole design process.
• Documented all of the test cases and test plans associated with all of the Use Cases.
• Created the Functional Design Documentation (FDD) and the Technical Design Documentation (TDD)
• Analyzes multiple data issues, design a cleanup process and prevent the problem from reoccurring.
• Developed test plans and use case scenarios
• Reported the progress of the project to the stakeholders of the project.
• Ensures that deliverables meet the technical and business requirements.
• Ensures all deliverables are documented, reviewed, and completed in a timely manner.
• Responsible for achieving team milestones.
• Responsible for coordinating all Technical activities performed by the IT DBA, Network, Server, Security, and Support Teams.
• Works with the appropriate resources to assure necessary hardware and software to support implementation is available.
• Works with Technical Director and the Technical consultants to develop training plan for technical staff.
• Worked with staff in the validation all of the PeopleSoft Personal data information, biographic data and mostly all the common table between core HR and CS have in common.
• Analyze all of the changes needed for the PS Payroll/ADP Interface in compliance of the new California law of splitting all of the earnings in separate earning code.
• Made all changes needed for the PS Payroll/ADP Interface in compliance to the California law
• Debugging and fixing all COBOL issues
• Performance tuning
• Analyzed and retrofitting customizations for version 9.2

Confidential

Technical/Functional Consultant/Business Analyst

Responsibilities:

• Observe User’s daily task and recommend solutions.
• Fixed production issues pertaining to HCM, Payroll, T&L, Absent Management, Benefits, TAM, CS, FSCM, CRM, ELM and Portal issues.
• Worked closely with the CS users on day-to-day issues both functional and technical
• Tested some of the custom delivered processes to QA the results
• Guided client in the batch Matriculation and Term Activation process
• Created custom report to help the user identify a specific group of students
• Suggested solutions to the CS users with the use of the delivered functionality
• Created both the functional and technical specification for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Supported and developed customize processes for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Assisted the users in the use of the Mass Change process
• Analyst Academic Advisory, Admissions, Campus Community, Student Records,
• Transfer Credit, Student Finance and Financial Aid for Reporting needs
• Generate reports to validate the current converted Transfer Rules
• Analyst Requisition, AP, GL, Expenses, eProcurement and AR for Reporting needs
• Create multiple Reports of HCM, CS and FSCM per User’s Reporting needs.
• Cleaned up any conversion issues which included common tables between HCM and CS like the Personal data information and biographic data.
• Support all benefits interface issues
• Supported multiple clients as a Production Support Analyst for HCM/Payroll Check Print Process for Value Added clients.
• Research and analyze the business requirements and gathered functional and technical requirements for multiple clients.
• Worked with all of the clients in testing of all of the requested changes.
• Enhanced ADP’s Check Print Process to make it more flexible to service multiple client’s in various PeopleSoft Versions.
• Modified ADP’s Check Print Process to make it more efficient and lessen hard coding in all the programs
• Supported multiple clients as a Production Support Analyst for AP, GL, AR, PO and RE
• Work closely with multiple users to create customized reports for their special needs
• Analyzed, designed, developed and tested customized processes per user request

Confidential

Technical/Functional Consultant/Business Analyst

Responsibilities:

• This department was the central production support for all of the CUNY.
• Supported multiple clients as a Production Support Analyst for HCM, FSCM, CS, CRM, ELM and PORTAL
• Fixed production issues pertaining to HCM, Payroll, T&L, Absent Management, Benefits, TAM, CS, FSCM, CRM, ELM and Portal issues.
• Supported the Benefits department during open enrollment, daily benefits issues, administration of benefits, setup of new benefits and monitored all processes.
• Developed custom interfaces for multiple benefits providers.
• Supported the employee self service
• Support both functional and technical specification for CS including Academic Advisory, Admissions, Campus Community, Student Records, Transfer Credit, Student Finance and Financial Aid.
• Supported and developed customize processes for CS including Academic Advisory, Admissions, Campus Community, Student Records, Transfer Credit, Student Finance and Financial Aid.
• Identify data issues in the CS conversion
• Participated in all of the User’s Acceptance Testing
• Functioned as a QA tester, for all new changes, patch updates or any new development going to production.
• Worked with users on day-to-day issues both functional and technical
• Guided client in the batch Matriculation and Term Activation process
• Created custom report to help the user identify a specific group of students
• Functioned as the liaison between the Functional Team and the Technical Team.
• Research and analyze the business requirements and gathered functional and technical requirements
• Created Functional specifications documentation for any enhancements required by the users
• Created Technical specification documentation for any enhancements required by the users
• Analysts, trace, debug and fix daily production issues in HCM, FSCM, CRM, ELM, EPM and PORTAL
• Analyzed, designed, developed and tested custom process solutions as needed in HCM, FSCM, CRM, ELM and PORTAL
• Created multiple customized interfaces to and from the PeopleSoft in HCM, FSCM and CS.
• Supported and customized the Self-Service application for HCM/Payroll.
• Supported and customized the Self-Service application for CS.
• Functioned as an integrator/developer of interfaces both internal and external to PeopleSoft.
• Supported multiple interfaces to and from PeopleSoft in HCM, FSCM and CS.
• Interfaced with Oracle On-Demand on issues and processes
• Tracked issues and progress with Oracle On-Demand via CRM and Remedy
• Analyzed all test plans and test procedures to insure accurate results
• Created multiple test script to test new patches and bundles applied
• Analyzed test results to validate data accuracy
• Developed and retrofitted custom code using PeopleCode, App Engine, SQL, and SQR.
• Analyzed, designed, developed, and tested the conversion of Transfer Credit for multiple Institutions.
• Analyzed, designed, developed, and tested process to automate the population of setup tables for Transfer Credit.
• Analyzed, designed, developed and tested multiple regulatory reports including NSC reporting
• Analyzed, designed, developed, and tested the Student Transfer Credits conversion and setup.
• Track and document production issues using CRM and Remedy
• Created custom aging reports for CRM
• Analyzed, debugged, fixed and tested user problems as they occur
• Analyzed, debugged, fixed and tested client’s customization
• Provides recommendations around functional design and configurations
• Conduct testing of all new delivered processes
• Conduct all Quality Assurance for new processes
• Analyze and fix SQL code for performance tuning
• Analyze and fix setup issues
• Research and analyze the business requirements
• Design, develop, and test new process per Client’s needs.
• Used SharePoint to storage Production documents
• Utilizing Crystal coding and use SQL/Developer for performance tuning.
• Utilized Control-M batch job scheduler and Stat change control package
• Create multiple Reports of HCM, CS and FSCM per User’s Reporting needs.
• Cleaned up any conversion issues which included common tables between HCM and CS like the Personal data information and biographic data.
• Functioned as production support for HCM including payroll processing, Time and labor, absent management, benefits and core HR issues.
• Functioned as the liaison between the Functional Team and the Technical Team.
• Fixed production issues pertaining to HCM, Payroll, T&L, Absent Management, Benefits, TAM, CS, FSCM, CRM, ELM and Portal issues.
• Research and analyze the business requirements
• Gathered Functional and Technical requirements
• Created Functional specifications documentation for any enhancements required by the users
• Created Technical specification documentation for any enhancements required by the users
• Analyze, design and develop custom process solutions as needed for CS including Academic Advisory, Admissions, Campus Community, Student Records, Transfer Credit, Student Finance and Financial Aid.
• Analyze, design and develop custom process solutions as needed for HCM including HR, Payroll, T&L and ABM
• Analyzed, designed, developed and tested the conversion effort
• Supported multiple clients as a Production Support specialized.
• Analyzed, debugged, fixed and tested user problems as they occur
• Analyzed, debugged, fixed and tested client’s customization
• Provides recommendations around functional design and configurations
• Functioned as a QA for all new changes or development going to production.
• Analyzed all test plans and test procedures to insure accurate results

Confidentia

Technical/Functional Consultant/Business Analyst

Responsibilities:

• Primary function was conversion.
• Functioned as the liaison between the Functional Team and the Technical Team.
• Research and analyze the business requirements
• Gathered Functional and Technical requirements
• Documented the data mapping effort for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Created Functional and Technical specification documentation for conversion for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Coded and design program for conversion effort for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Created Functional and Technical specification documentation for conversion effort any enhancements required by the users
• Participated in all of the User’s Acceptance Testing
• Functioned as a QA tester, for all new changes, patch updates or any new development going to production.
• Analyzed, debugged, fixed and tested SQR programs
• Analyzed, debugged, fixed and tested App Engine programs
• Analyzed, debugged, fixed and tested Component Interface
• Analyzed, debugged, fixed and tested Integration Brokering
• Created new customized processes using Component, Pages and applied Security
• Assisted in clarifying and creating specs for all of the users functional needs
• Created security access for all customized processes
• Evaluated the users functional needs and created functional specs for the users
• Help Analyzed, debugged, fixed and tested setup issues
• Replacing multiple consultants my primary function is to convert La Salsa restaurant employees from Ceridian to PeopleSoft.
• Functioned as the liaison between the Functional Team and the Technical Team.
• Research and analyze the business requirements
• Gathered Functional and Technical requirements
• Created Functional specifications documentation for any enhancements required by the users
• Created Technical specification documentation for any enhancements required by the users
• Did the Fit/Gap Analysis, Data Mapping and data analyst
• Created all task list and tracked the progress of the project
• Assisted in clarifying and creating specs for all of the users functional needs
• Design and coded all programs for conversion including the employee self-service.
• Coordinated and tracked all of the users task in the conversion effort
• Analyze the source system (legacy system, Ceridian) and its functionality to be able to understand the conversion efforts needed.
• Retrieved all data from Ceridian using eSource
• Coordinated all of the testing efforts
• Analyzed all test plans and test procedures to insure accurate results
• Analyzed all test results of all of the testing efforts
• Analyzed and designed validation report for the conversion effort
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester for the conversion effort.
• Production support
• Create new custom processes per user request
• Retrofit Tax Update and batches.
• Designed, coded and implemented open enrollment processes for all of the employees, including implementing processes and interfaces to all of the new vendors
• Developed Components, Pages and applied Security
• Designed, coded, and implemented a process that converts employees by business unit to be enrolled, and eliminate the generation of paper checks and replace it by getting paid via debit card instead.
• Created security access for all customized processes
• Evaluated the users functional needs and created functional specs for the users
• Help Analyzed, debugged, fixed and tested setup issues
• Primary function is production support for all of the daily Help Desk issues and production problems.
• Assisted in clarifying and creating specs for all of the users functional needs
• Functioned as the liaison between the Functional Team and the Technical Team.
• Research and analyze the business requirements
• Gathered Functional and Technical requirements
• Created both the functional and technical specification for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Supported and developed customize processes for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Created Functional specifications documentation for any enhancements required by the users
• Created Technical specification documentation for any enhancements required by the users
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester, for all new changes, patch updates or any new development going to production.
• Analyzed, debugged, fixed, and tested COBOL code.
• Analyzed, debugged, fixed and tested PeopleCode
• Analyzed, debugged, fixed and tested SQR programs
• Analyzed, debugged, fixed and tested App Engine programs
• Analyzed, debugged, fixed and tested Component Interface
• Analyzed, debugged, fixed and tested Integration Brokering
• Created new customized processes
• Created security access for all customized processes
• Developed Components, Pages and applied Security
• Supported AP, TR, PO, AR, BI, GL, AM, HR, PAYROLL, T&L, Absence Mgmt, BA, ELM
• Evaluated the users functional needs and created functional specs for the users
• Help Analyzed, debugged, fixed and tested setup issues

Confidential

Project Manager

Responsibilities:

• Evaluated the current system to generate the SOW for the upgrade effort from PeopleSoft version 8.1 to PeopleSoft version 8.9
• Identified all of the steps needed for the upgrade effort
• Identified all of the customizations
• Created the project plan for the upgrade effort
• Created the project plan for the Payroll Tax update 6-A
• Created the project plan for the tools upgrade PeopleTools version 8.1 to PeopleTools version 8.2
• Developed Components, Pages and applied Security
• Functioned as the liaison between the Functional Team and the Technical Team.
• Research and analyze the business requirements
• Gathered Functional and Technical requirements
• Created Functional specifications documentation for any enhancements required by the users
• Created Technical specification documentation for any enhancements required by the users
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester, for all new changes, patch updates or any new development going to production.
• Analyzed, debugged, fixed, and tested COBOL code.
• Analyzed, debugged, fixed and tested PeopleCode
• Analyzed, debugged, fixed and tested SQR programs
• Analyzed, debugged, fixed and tested App Engine programs
• Analyzed, debugged, fixed and tested Component Interface
• Analyzed, debugged, fixed and tested Integration Brokering
• Coded multiple SQRs used for Asset Management balancing
• Supported AP, PO, AR, BI, TR, AM and GL.
• Design and code multiple interfaces and processes to and from Treasury
• Design and code multiple customization for the Treasury module
• Developed and design Component, Pages and applied Security
• Design Processes using SQR, PeopleCode and Process Scheduler.
• Conducted peer reviews for the delivered product
• Created security access for all customized processes

Confidential

Technical Consultant

Responsibilities:

• Coded multiple SQR management reporting and interfaces to Corporate HR/Payroll
• Coded multiple SQRs to create extract for the HYPERION budget forecasting system. Data where both from the HR/Payroll and Financial system (AR, BI, AM, GL, AP, PC)
• Design and code all processes necessary for the interface to HYPERION.
• Upgraded all processes into version 8.8
• Conducted the User’s Acceptance Testing of the interface process between PeopleSoft HCM, FSCM and Hyperion
• Coordinated and conducted the user training for the finished product
• Coordinated changes and completion of task for other departments
• Upgraded all processes to HCM (HR, PAYROLL, T&L, AM, BA) version 8.9
• Upgraded all processes to FSCM version 8.9
• Created new customized processes
• Developed Components, Pages and applied Security
• Designed, coded, and implemented open enrollment processes for all of the employees, including implementing processes and interfaces to all of the new vendors.
• Created security access for all customized processes
• Evaluated the users functional needs and created functional specs for the users
• Did production support
• Automated several manual processes
• Created Functional and Technical specification documentation for conversion for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Coded and design program for conversion effort for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Evaluated current production and development state and wrote standard and documentation to stabilize the environment.
• Created new customized processes
• Performed the User’s Acceptance Testing for all of the developed customized processes
• Developed Components, Pages and applied Security
• Created security access for all customized processes
• Synced up the HCM and Learning management system (ELM).
• Designed a customized system to combine all 1099 reporting and process for both Financials and Payroll
• Coded multiple SQRs for 1099 loads, process and reporting
• Created Panels for users to view all data and fixed data if necessary.
• Created all Run Control Panels to execute all SQRs.
• Coded custom PeopleCode for security for all the panels.
• Did production support for HR/Payroll and Financials
• Performed the User’s Acceptance Testing for all of the developed customized processes

Confidential

Technical/Functional Consultant

Responsibilities:

• Assisted in clarifying and creating specs for all of the users functional needs
• Created Functional and Technical specification documentation for conversion for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Coded and design program for conversion effort for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Created multiple interfaces for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Coded multiple SQRs for reporting and interfaces.
• Evaluated about 100 SQR for report security issues
• Coded PeopleCode and Application Engine
• Applied Updates to PeopleCode, Application Engine, Cobol programs and objects
• Designed and coded an automated interfaces process. This would also cut down on the development time for future interfaces. This automation process included pages, PeopleCode, tables, table views for error processing, table describing the input layout and a translate table used to convert data values from old to new. Part of the delivered product was a process-flowchart, program-flowchart, and step-by-step instructions in the development of future interfaces. The client was very pleased with the results. They are now using this as their new standards for new development.
• Designed, coded and implemented open enrollment processes for all of the employees, including implementing processes and interfaces to all of the new vendors
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester, for all new changes, patch updates or any new development going to production.
• Supported all processes in production
• Created new customized processes
• Developed Components, Pages and applied Security
• Created security access for all customized processes
• Evaluated the users functional needs and created functional specs for the users
• Supported the financial system on a multi-currency system
• Acting as key player in the customization of Position Management in PeopleSoft Version 8.8.
• Fixed production issues.
• Working with PeopleCode and Workflow.
• The client stated that Mr. Dauglash accomplished more in 2 days then the previous consultant had in 4 weeks.

Confidential

Upgrade/Technical Lead Consultant

Responsibilities:

• Acting as key player in the upgrade process HRMS/Payroll from 7.56 to 8.3 in a DB2 platform.
• Assisted in the installation of PeopleSoft version 8.
• Upgraded the client into version 8 using the Upgrade Assistant.
• Applied Updates to PeopleCode, Application Engine, Cobol programs and object update by copying project into Application Designer
• Fixed and modified upgrade scripts
• Coded about 15 SQRs to replace production SQRs for more efficiency and better performance.
• Upgraded 200 in-house SQRs to version 8.
• Customized App Engine program per client’s needs.
• Applied 54 necessary patches for version 8.
• Reapplied PS COBOL Customizations.
• Converted 30 COBOL into SQRs.
• Production support
• Created new customized processes
• Created security access for all customized processes
• Functioned as Primary Technical Lead and Support for the Upgrade of HRMS/Payroll from 7.56 to 8.17 tools and Version 8.4 Application.
• Created the project plan for the Upgrade Process
• Monitored the progress of the Upgrade Process
• Coordinated with the DBA for all of the backups needed for the Upgrade Process.
• Fixed and modified upgrade scripts
• Applied Updates to PeopleCode, Application Engine, Cobol programs and object update by copying project into Application Designer
• Assisted in the installation of PeopleSoft version 8.
• Upgraded the client into version 8 using the Upgrade Assistant.
• Coded about 20 SQRs to replace production SQRs for more efficiency
• Created custom application for HRMS.
• Apply 50 necessary patches for version 8.
• Evaluated the conversion of Self Service into ePay, eProfile and eBenefits.
• Created Technical specs based on functional needs.
• Retrofitted existing Payroll interfaces to and from including ADP.
• Retrofitted existing Benefits interfaces to and from multiple insurance carriers.
• Evaluated all changes to production to ensure there was no impact to the Upgrade Process
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester, for all new changes, patch updates or any new development going to production.
• Supported Production processes
• Created new customized processes
• Created security access for all customized processes

Confidential

Lead Technical/Functional Consultant

Responsibilities:

• Acting as Primary Technical Support for Financial and Campus Solutions modules
• Created Functional and Technical specification documentation for conversion for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Coded and design program for conversion effort for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Assisted in mapping, coding and design for conversion effort for CS including Academic Advisory, Admissions, Campus Community, Student Records, Student Finance and Financial Aid.
• Coded multiple SQRs, PeopleCode and Application Engine programs for multiple processes such as the EDI process, Bank Reconciliation, Positive Pay, AP Check Print and more.
• Wrote the AP Check Printing SQR in 2 days, because the client needed it ASAP. The delivered Crystal check printing process did not worked. The client wanted to go live but could not print an AP check. The previous consultant worked on this program for 3 months and was not able to deliver.
• Designed, coded and implemented open enrollment processes for all of the employees, including implementing processes and interfaces to all of the new vendors
• Applied Updates and fixes.
• Applied Updates to PeopleCode, Application Engine, Cobol programs and object update by copying project into Application Designer
• Created multiple interfaces to the current legacy systems and other PeopleSoft applications.
• Created multiple interfaces for the Student Campus Solution Modules including (Student Records, Financial Aid, Admissionsand Student Finance).
• Created an interface from Student Admin to GL.
• Created an interface from Payroll to GL.
• Assisted in upgrading the client into version 8 using the Upgrade Assistant.
• Created new customized processes
• Created security access for all customized processes
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester, for all new changes, patch updates or any new development going to production.
• Production support
• Evaluated the users functional needs and created functional specs for the users
• Functioned as Primary Technical Support for AR, BI, AP, PO, GL, TR, and AM.
• Coded conversion programs for Asset Management and Treasury.
• Primary problem solver for the client.
• Analyzed, debugged, fixed and tested delivered application bugs in the application and APP Engine programs
• Applied 30 patches for version 8
• Assisted in the upgrade from version 8.13 to 8.15
• Created and modified existing Pages, Components and PeopleCode
• Applied Updates to PeopleCode, Application Engine, Cobol programs and object update by copying project into Application Designer
• Coded 15 SQRs for the interfaces of PeopleSoft to the legacy system.
• Designed and coded a voucher editing process including a vehicle to fixed invalid vouchers prior to entering the AP system. This process cut down the time spent by the client in cleaning up data once entered in the AP system.
• Wrote Application Engine programs for Multiple processed like the EDI process, Bank Reconciliation and Positive Pay
• Created and Assisted Users in the use Crystal Queries
• Customized App Engine programs per client’s needs.
• Fine-tuned PeopleSoft Applications by adding indexes, dropping indexes, fixed SQL issues and performed database tuning.
• Help setup and test all year-end processes including all of the 1099s
• Created Technical specs based on functional needs.
• Created new customized processes
• Created security access for all customized processes
• Participated in all of the User’s Acceptance Testing
• Functioned as a tester, for all new changes, patch updates or any new development going to production.
• Production support

Confidential

Lead Technical/Functional Consultant

Responsibilities:

• Functioned as Primary Technical Support including production support
• Conducted the Gap/Fit analysis and implementation of Position Management.
• Implemented the Learning Management system (ELM)
• Functioned as the primary technical consultant in the evaluation of the GAP analysis.
• Coded about 30 SQR to convert the client from PeopleSoft 3.1 to 7.5. This was done in 4 weeks, because the client was behind schedule in the conversion process. This effort put the client back on schedule. The original consultant was not able to produce the SQRs so the client asked me to work double time to get the job done.
• Applied Updates to PeopleCode, Application Engine, Cobol programs and object update by copying project into Application Designer
• Wrote all the conversion programs in SQR and COBOL.
• Was the primary resource when something has to be develop ASAP or troubleshooting a problem
• Was the primary problem solver.
• Created Technical specs based on functional needs.
• Automated the Los Angeles City Budget Approval Process (APR) by creating panels, PeopleCode and SQRs.
• Implemented and supported Human Resource and Position Management System in a DB2 platform.
• Assisted in the eBenefits and Self service implementation
• Assisted in the Tuition reimbursement implementation
• Created and modified existing Panels and PeopleCode to go with the Panels
• Coded over a hundred SQRs for Reporting and fixes to the current production system.
• Coded programs for the interfaces of PeopleSoft to the legacy system (Payroll, Retirement, etc.)
• Redesigned current table structures and modified SQL statements to enhance performance.
• Evaluated the customization of LADWP and replaced custom tables with delivered PeopleSoft tables to help the client implement the new version of PeopleSoft as vanilla as possible.
• Converted COBOL programs to SQRs.
• Assisted in the installation of PeopleSoft in OS390/DB2
• Fine-tuned PeopleSoft Applications by adding indexes, dropping indexes, fixed SQL issues and Database tuning.
• Supported the Production System.
• Created new customized processes
• Created security access for all customized processes
• Designed, coded and implemented open enrollment processes for all of the employees, including implementing processes and interfaces to all of the new vendors.
• Participated in all of the User’s Acceptance TestingFunctioned as a tester, for all new changes, patch updates or any new development going to production.
• Coded about 20 SQRs for the conversion of HR/Payroll, this was done in 3 weeks because the previous consultants SQRs did not work.
• Coded about 10 SQRs for the interfaces to HR/Payroll.
• Coded SQRs and designed panels and PeopleCode for the time entry system for Payroll.
• Setup run controls, Panel and security for the reporting and processes.
• Functioned as technical lead and support of the production system.
• I was asked to give technical recommending to the client of the best approach to get the job done.
• Created Technical specs based on functional needs.
• Automated some manual daily processes.
• Fixed delivered PeopleSoft problems
• Automated the Personal termination process.
• Retrofitted existing Payroll interfaces to and from including ADP.
• Designed the conversion process for Asset Management in a DB2 platform.
• I was the primary consultant the client came to if a SQR had to be written ASAP or if a problem arouse and another consultant cannot get the job done in the time frame allocated for the task. This was true for all the modules being implemented.