SUMMARY:

• 19 years of PeopleSoft implementation experience
• 8 full cycle implementations and 11 upgrades up to PeopleSoft 9.2
• Oracle Cloud implementations in HCM/Payroll/Ben Admins, FSCM, Campus Solutions Public and Private Sector.
• Large Client Implementations with PeopleSoft CRM & PeopleSoft Portal
• PMI Certified Project Management Professional
• Deep technical knowledge of all PeopleSoft Tools and a broad understanding of PeopleSoft FSCM, HCM and CS Application Suites up to and including version 9.2
• Experience managing teams and demonstrated leadership experience in the PeopleSoft Application domain.
• Proven experience to initiate, plan, execute, monitor/control and successfully close PeopleSoft 9.2 upgrades and special PeopleSoft projects.
• Excellent record of navigating PeopleSoft projects through different test cycles including System, Integration and User Acceptance Testing.
• Tenacity; ability to work through problems and reach a solution.
• Proven ability to influence project sponsors and stakeholder management.
• Ability and willingness to travel within US and abroad.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

PeopleSoft Student Financials - Senior Functional Consultant/Project Manager

Responsibilities:

• Review entire Perkins lifecycle and impact on Financial Aid and Student Financials.
• Complete Fit-Gap of Campus Community, Student Records, Financial Aid and Student Financial Account Conversion for Perkins population.
• Design Functional Specs, Testing and Reconciling student level balances.
• Wrote detailed Functional Design Documents after extensive fit-gap.
• Manage end to end FA disbursements to GL reconciliation lifecycle for continuing, separated and loan activated students.
• Planned and executed System, Integration and UAT testing cycles.
• Delivered successful production cutover for entire Perkins Bolt-On for PeopleSoft 9.0 Campus Solutions and PeopleSoft 9.2 G/L, A/P, A/Rand Billing.
• Managing after go-live support.

Confidential

Senior Consultant/Project Manager

• Confidential is using the delivered third party contract process to facilitate Confidential Pre-Paid contract billings and payments within PeopleSoft Student Financials and thereby integrating with PeopleSoft Financials General Ledger system.
• My role was to take over the consortium module, guide the entire project to do fit-gap analysis, custom development, testing and successful production push within Miami Dade.

Confidential

Senior Consultant/Project Manager

• Large MDC student population goes through cycle of charges & fees being dunned within 30-60-90-Prior to Collection, Collections, Write-Offs and Payments with use of multiple outside collection agencies.
• The regulatory compliances for these processes are extremely complex. So it was one of the most challenging part of Student Financials implementation when AR was already converted and in Production.
• The role is to take over the entire responsibility as a senior consultant and deliver under tight deadline under the budget and time constraints in PROD with help of on-site functional teams and offshore Confidential team.
• Completed streamlining Confidential and collection processes with multiple collection agencies, reconciled all old account, completed business fit-gap for Odyssey to SF conversion, created functional/technical specs, managed SYS, INT and UAT testing cycles with successful production cutover.

Environment: Confidential /Oracle Cloud Campus Solutions 9.0, FSCM and HCM 9.2

Confidential,La Crosse,WI

PeopleSoft Campus Solutions 9.2 Upgrade Specialist

• PeopleSoft 9.0 to 9.2 Campus Solutions Upgrade Assessment
• Presented upgrade approach options and overview presentation to the leadership.
• Helping to create project charter and budget proposal.
• Conducting daily Deep Dive Sessions for internal staff to understand challenges and adapt best practices for ongoing support of implemented business processes within Admissions, Campus Community, Financial Aid and Records within Campus Solutions 9.0.
• Installed PTF (People Tools Test Framework). Converting all Admissions and Financial Aid Business processes into PTF Test Scripts. Total around 80 processes converted into repository and trained staff for the rest.
• Prepared PeopleSoft CS 9.2 Demo/Sandbox environment on Oracle Linux & trained staff to handle PUM images.
• Fact finding and documenting Student Records and Student Financials business processes and configurations which were implemented in 2009 but lacked documentation.
• Mentoring staff to build Test Case Repositories for end to end business processes within Academic Advisement, Campus Community, Financial Aid, Recruiting, Student Records, and Student Financials.
• Assisting leadership decision making based on best practices and Campus Critical needs.
• Managing multiple smaller staff projects for Regs II(Bundle 43) rollout, Creating SOPs for all business processes, Campus Scheduler upgrade, HighPoint Mobile Extension Upgrade and Oracle 12 C upgrade.
• Guiding security analysis and campus wide security overhaul.
• Working on detailed project management plan for proposed 9.2 upgrade in 2017.

Environment: PeopleSoft Campus Solutions 9.0, Oracle 12 C, OBIEE, CollegeNet, Campus Logic, C-board etc.

Confidential, Atlanta,GA

Project Manager/Functional SME

• Confidential spread across 78 different operating companies. They needed ATS solution outside of PeopleSoft HRIS to replace TAM and take advantage of all new mobile and social media recruiting tools.
• Created a streamlined workflow of the entire recruiting process to replace PeopleSoft Talent Acquisition Management (TAM) using cloud based ATS.
• Consolidated staffing and recruiting business processes across 900 branch offices and field operations.
• Consolidated use cases, requirements and received sign off from nationwide recruiting leads.
• Led discussions with recruiting leads across all Operating Companies to create completely redesigned business processes.
• Completed Fit-Gap Analysis with existing TAM functions and the new cloud based ATS
• Designed Functional Specs for integration of cloud based ATS with PeopleSoft Workforce Management after Gap Analysis.
• Led design sessions with functional
• Completed end to end workflow, requirement analysis, prototyping and deployment plans.
• Created a project plan and spearheaded the organization wide change management for new recruiting process.
• Managed project plan execution, custom development and Testing (Systems, Integration) cycles.
• Driven UAT sessions with nationwide audience of recruiting leaders from each Operating Company.
• Oversaw the integration of the new cloud ATS within ESS and MSS dashboards in employee portal.
• Successful Go-Live cutover with very aggressive project timeline.

Environment: PeopleSoft HCM/Payroll/Ben Admin/TAM 9.1, Oracle 11g, 3 rd Party Cloud Applicant Tracking System

Confidential,Knoxville,TN

PeopleSoft Upgrade Manager and Subject Matter Expert

Responsibilities:

• Cleanup of complex customizations and changes done in TAM module and helped client to bring back candidate gateway which was collapsed during last Christmas break.
• Tools upgrade project from 8.52 to 8.54. Total 7 passes to HCM, CRM and Portal. Designed strategy sessions, provided roadmap and guided in-house team to successful cutover within timeframe of 3 months.
• Completed Fit-Gap analysis for all portal customizations and created functional and technical specifications for the retrofitting to Tools 8.54.
• Enterprise Portal Branding with extensive customizations were impacted in new Tools release. Retrofitted branding as well as configured all 3 environments without any impact on end customers.
• Completed production cutover successfully during Memorial Day weekend to all 3 environments.
• Managed bolt on development project for in-house position management and labor demand with projections of jobs, positions, employees and contractors for current year and next 5 years for the leadership with a dashboard.
• Created functional and technical specifications based on required customizations to MSS workflows by collecting requirements from HR and tested new AWE workflow changes for onboarding and leave approval processes for managers.
• Completed impact analysis of Affordable Care Act (ACA) and provided roadmap to apply maintenance packs and required updates.
• Guiding complex TAM customization requirements and changes.
• Design of Pay Advice organization wide Payroll Email Notification System and roll out.
• Supported eCompensation and ePerformance Rollouts.
• Installation of PUM and 9.2 HCM Demo environment in preparation for 9.2 upgrade
• Preparing for 9.2 Application upgrade in 2016 with close to 17,000 custom objects.

Confidential, Plano,TX

PeopleSoft HR/Payro

Responsibilities:

• Developed strategy, plan and execution steps for HR/Payroll Transformation from PeopleSoft 8.9 to 9.2 Oracle HCM Cloud (Oracle Managed Cloud Services).
• Plan and execution of 22000 custom objects disposition from PeopleSoft HCM 8.9 to HCM 9.2 during the upgrade process.
• Worked closely with business owners and SMEs through the fit-gap analysis to dispose 22000+ custom objects and derived mapping to 9.2 with functional users;
• Was able to get functional user sign offs after the fit-gap and guided the disposition gradually through 5 to 11 upgrade passes towards 9.2.
• Led conversion and upgrade efforts to merge Payroll to HR in PeopleSoft 8.9.
• Presented HR/Payroll merge, conversion and 2-step 8.9 to 9.2 upgrade approach to stakeholders and received leadership approval.
• Led transformation of in-house PeopleSoft 8.9 to OMCS Oracle Cloud for 9.2 in merged environment.
• Achieved Windows to Linux conversion, Oracle 10g to 11g upgrade and nonUnicode to Unicode as well as multi-lingual conversion in the same upgrade.
• Disposition sign-off and conversion of approximately 22000 custom objects from 8.9 to 9.2.
• Helped setup POC and then Implementation of PING SAML 2.0 Single Sign-on with PeopleSoft 9.2 Cloud.
• Led conversion team to develop detailed merge, conversion scripts and optimized upgrade cycles.
• Sizing of CPU, RAM and Space for all Oracle cloud environments.
• Developed set of optimum parameters for Oracle cloud instances using Oracle utilities like PSCBO Stats and SQLT. Database sizes greater than 2 TB.
• Closely worked with Oracle Managed Cloud Services (OMCS) global team to test, deploy and go-live in 9.2.
• Developed system audit procedures and checklists for all cloud environments. Devised process of applying customizations and moving to PROD.
• Tested ESS and MSS bolt-on for new processes implemented in 9.2 with HR along with custom code. Injected the custom code in the post upgrade processes.
• Ran 1 Initial pass and 10 Move to Production Test Passes, dress rehearsal and final cutover. Helped prepare cutover management plan.
• Managed cutover with all of the above steps to PeopleSoft 9.2 including merge, upgrade, custom conversions, technical and functional validations in 5 day window with a team of approximately 70 members across 2 continents.
• Go-live Support handover, staff training in 9.2.
• Led integration projects with CA ESP Scheduler, Golden Gate, Oracle HR Analytics, Ping Identity for Single Sign on, Symmetry Payroll Forms and Saba with Oracle/PeopleSoft9.2 Cloud.
• PeopleSoft 9.2 PUM server implementation and HCM 9.2 Image9 application to all cloud environments post upgrade.
• Complete hands-on support throughout the 9.2 transformation and upgrade passes.
• Successfully managed team of 17 off-shore/onsite development/conversion direct report staff in 2 different shifts.

Confidential

Project Manager

Responsibilities:

• Provided functional and technical management and leadership for all efforts supporting more than 20 medium and large worldwide clients for the implementation and support
• Modules Supported - PeopleSoft Campus Solutions (Campus Community, Admissions, Records, Student Financials, Financial Aid, Student Advisement and Student Self Service), HCM/Payroll 9.0 and FSCM 9.0/9.1. (Large private higher education client)
• Strong contribution to Sales and Proposal process. Established project vision and objectives with the clients and led proposal teams through development of project scope and approach to solution for the client.
• Developed project plans and schedules including all go-live milestones and managed multiple client expectations.
• Developed relationships with client executives at CxO levels. Strong executive presence with the ability to establish credibility in first meeting.
• Daily progress review of multiple projects, multiple teams (Onsite and Offshore in 3 countries - total 155) during the fit/gap, requirements analysis, conversion, configuration workshops, design, development and deployment phases. Utilized SCRUM methodology to run highly optimized development cycle.
• Completed technical architecture analysis and design including sizing and capacity planning for various PeopleSoft instances in DEMO, DEV, TEST, QA and PROD environments.
• Helped setup Academic Advising Audit Engine for Ugrad and Grad school. Designed degree audit reports to evaluate student degree progress. Testing of business rules related to Academic Requirements and Enrollment Requirements.
• Helped create a process for consistent method of moving data from TEST to PROD environments in order to deal with duplicate record number issues in auto numbering being used in Student Records and Academic Advisement Module.
• Functional setup and testing of business rules for grade categories, cumulative GPA, transcript types, academic course lists, academic requirements, requirement groups, entity groups, exceptions and overrides.
• Configured the Approval Workflow Engine AWE and customized item descriptions for large item base. Set up and tested some complex workflows with multilevel notifications and authorizations. Wrote functional and technical specifications for more than 20 complex workflows and oversaw the development.
• Managed small project for completing successful integration of PeopleSoft Financial Gateway and Treasury Management Interface for payments. Configured bank setup and processing statements, remittance advices etc. Completed setup of payment security rules and authorization workflows for 3rd party payments within accounts payables. Managed complex customized bolt on creation for SEPA processing and managing debit mandates.
• Helped clients negotiate hardware purchase by analyzing peaks and valleys within complex PeopleSoft environment, planned scalable architecture using SUN, IBM hardware, OS recommendations and Oracle 10g, 11i databases including farm of web servers, application servers, database servers, Hitachi SANs, file servers and F5 load balancers. Participated in development, review and release of Strategy documents (Modifications, BRICE, Reporting, Technical Architecture, conversions, interfaces and security.)
• Designed functional and technical specs to integrate Time and Labor, Absence Management to Payroll NA . Managed project with offshore-onsite combination until go-live and successful hand-over.
• Served as PeopleSoft Technical Subject Matter Expert (SME) to development groups for PeopleSoft setup and configurations including PIA(PeopleSoft Internet Architecture), web-applications, database and file servers at various clients. Handled Architecture infrastructure integrations, performance tuning, administration, and development. Mentored multiple client employees for optimizing PeopleSoft Change Management and streamlined updates/bundles/feature packs.
• 8.9 Financials Upgrade Modules - Asset Management, Payables, Receivables, General Ledger, Inventory, and Purchasing. Senior Technical consultant filling roles of supporting Oracle DBA and PeopleSoft administrator. Primary responsibilities were to perform post go live support and performance tuning tasks. Responsible for identifying causes of poor system performance after version 8.9 upgrade. Tuned online and batch PeopleSoft processes, this included but is not limited to, App Engine, PeopleCode, sqr, and queries. Performed Database parameter review/optimization. Databases were 10g 500 gig, with over 20 multi-million row tables. Utilized Oracle hints and indexes to optimize online and batch processes. Provided performance tuning tips to the development team.
• Senior Technical Consultant, Infrastructure Architect & PeopleSoft Administrator - HRMS 9.0 and FSCM9.2 installation - Senior Technical consultant filling roles of Technical Architect, planned Upgrade for 9.2. Installed DEMO, DEV, TST, QA and PROD environments on Linux RH Enterprise 4.0 box. Created multiple virtual environments.
• Performed technical architecture design for PeopleSoft HRMS 9.0 production environment utilizing Weblogic 9.2, PeopleTools 8.49.08, in a Win2k SQL Server 2008 database platform.

Confidential,PM

PeopleSoft Student Administration & HR - Higher Education

• Provided the day-to-day support for the PeopleSoft Financial Aid and Student Financials modules for a large, urban, multi-campus community college system servicing over 100,000 students.
• Evaluated bundle releases and tested the functionality. Made recommendations for when / how they should be applied.
• Worked with functional leads to setup new financial Aid Years and coordinated multi-campus testing efforts for each setup. Wrote specs for over 40 modifications and tested their functionality, documented their use, and deployed in production.
• Coordinated PeopleSoft integrations with external agencies to ensure financial aid processes were functional, including State Student Assistance Commission, Common Line Origination loan files and Data Center (US Dept of Ed) and US Bank. Supported financial aid mass and auto packaging, equation engine testing, troubleshooting etc.
• Provided last level of technical support for all issues related to PeopleSoft Financial Aid, Campus Community, Admissions, Records and PeopleSoft Student Financials.
• Worked with a team to troubleshoot and resolve performance issues related to Third Party Contracts, Tuition Calculation and Student posting.
• Responsible for the installation and configuration of the Demo, Dev and Production environments.
• Applied all application and tools patches required for installation utilizing Change assistant.
• Mentored FTE and streamlined patch management process.
• Provided best practices training to onsite employees; this included process design for backups, environment cloning, troubleshooting tips, and performance tuning.
• Served as the Technical Lead on upgrade from HRSA 8.9 to HCM 9.0 (tools 8.49 to 8.52). Worked closely with technical teams to manage and execute all application upgrade tasks. Retrofitted pre-existing local campus modifications to the new application / tools version and rolled out to multiple school sites. Established change management procedures and trained in-house employees.
• For major manufacturing client, installed PeopleSoft 9.1. HCM/TAM - Configured profiles, set up profile integrations for job openings, setup of recruiting statuses, screening process, customized job offer components, recruiting templates across multiple departments. Worked with power users to create the delegation framework, job opening approval workflow. Also created applicant tracking with custom applicant tracking and forwarding. Tested the complete process and customization before rolling it out to PROD. Provided power user support after go live and managed all troubleshooting aspects.
• For a retail client, setup and implemented more than 10 third-party benefit provider interfaces with PeopleSoft HCM/Ben Admin using PeopleSoft integration tools Integration Broker and Component Interfaces. Consolidated old custom integrations to PeopleSoft toolset in PeopleSoft HCM 9.0 and PeopleTools 9.1.
• Designed functional and technical specifications for legacy to PeopleSoft conversion using Integration Broker, Component interfaces and Application Engine programs. Oversaw the custom development and go-live support for a mid-size manufacturing client. PeopleSoft FSCM 9.0 and PeopleTools 9.1.
• Designed a solution and wrote functional and technical specs for a custom bolt-on for financial service company integrating data into PeopleSoft CRM Enterprise Help Desk 9.1. The application makes it easier for consumers to switch banks with mobile photo bill pay.The bank introduced a mobile photo bill pay solution to make it easier to switch new customer from another bank. All a switching customer needs to do is use their mobile phone to take a scan/picture of her bill and the app does the rest — correcting for image distortion, reading relevant data, and auto populating all of the payee info using third party OCR. The simplicity of the process also helps Bank encourage existing bill payers to increase the number of bills they pay digitally. Oversaw the development and go-live into production.
• Technical Lead role for FSCM 9.0 providing mostly level 3 support in production environment.

Environment: s: PeopleSoft 8.9, 9.0, 9.1 HCM, FSCM and CRM, Campus Solutions, with Feature Packs. PeopleTools 8.4x, 8.50, 8.52. Databases - Oracle 10g, 11i, MS SQL Server 2005 and 2007. IBM AIX, HP UX, SUN, Linux, Win 2008 etc.

Confidential, FL

PeopleSoft Team Lead

• Install and Upgrade to 8.9 FSCM and install of DEMO in SA/HR 8.9.
• Install and Upgrade to 8.0 SAHR from 7.6 start to go live and later.
• Supported Student Records and Financial Aid roll out and wrote functional and technical specification for legacy conversion for 9 different schools.
• Worked with functional leads to support them in their fit gap for Admissions, Financial Aid, Student Financials and Records. Excellent knowledge of key processes in Admissions, Campus Community, Financial Aid, Student Financials and Records was great help to troubleshoot problems in these processes.
• Planning and Set up of PeopleSoft infrastructure on IBM 690 for all environments in different LPARS. This consolidated all environments (DEMO, DEV, QA, PROD etc. total 20+) on one server in different LPARs.
• Performance Tuning of PROD environment to support peak times. This includes setting up several Proxy and web servers with multiple application server and fall back abilities. This was done on PS 8.0, 8.9, Oracle 10g, WebLogic 6 and later 8.1.
• Set up self service applications through several PIAs for course catalog, class schedule, creating user IDs, ‘forgot password’ function.
• Planned and setup PeopleSoft operator security and trained internal staff for setting up various schools user access, helped setting up student support for self service issues.
• Designed and developed Graduate School and Undergraduate School registration application as a Bolt On. These applications bring anywhere between 4000 to 5000 new applicants every year from around the world.
• Designed and built interface to Third party Credit Card transaction system and Student Financials using App Messages, App Engine and Component Interfaces.
• Resolved user issues with updates and patches in Admissions, Campus Community, financial aid, Student Financials, Records, HR, and Payroll. Also supported power users in PeopleSoft Financials Supply Chain Management in separate environment.
• Upgraded 19 PeopleSoft Database instances from Oracle version 8.06 to 8.17 and then to 9i.
• Configured upgrade assistant delivered from PeopleSoft to set up upgrades, re-designed the old upgrade process with Upgrade assistant and trained FTE. Also worked with SA/HR team to develop a fallback strategy for upgradation to 8.0.
• Performance tuning of complete PIA architecture in IBM 690. Set up scalable e-Campus catering to Students, Faculty and Staff separately on different Proxy, webserver and application server instances. Same configuration running from 2005 to 2013 handling online self service registration, enrollment, class schedules and course catalog without purchase of new hardware. PIA running 4 proxies, 14 web servers and 4 large app server domains in PROD in optimized mode.
• Successfully completed advisor tracking systems and WebCT integration with Single Sign On and LDAP on implementation in 8.0 and then migrated to 8.9.

Confidential

PeopleSoft Team Lead

• Worked as a technical team lead for PeopleSoft Implementation at a New England University which implemented Student Administration (Campus Community, Admissions, Financial Aid, Student Financials and self service modules), HRMS, Payroll, and Financials (AR/AP/GL etc.); served as a technical mentor for all the upgrades, patches as well as security and database maintenance.
• Completely supported roll out of Student Administration, HRMS and Financials from initial project planning, fit-gap, conversion, development and execution. Resolved functional and technical issues with Admissions, Campus Community, Student Records, Course catalogs and Student Enrollment for UGRAD and GRAD schools.
• Supported various student enrollment peaks after go-live. The successful enrollment execution model was shared with 2 other universities UConn and UMass and thereby used to resolve issues they had with the enrollment process.
• Completed upgrade from PeopleSoft 7.6 to 8.0, conversion, fit-gap, customization and go-live phases in 8.0 across all schools. Built cutover plan and executed critical registration cycles.
• Helped URI to correctly size up the PeopleSoft environments and migrated to IBM LPAR architecture.
• Set up and implemented complete user security in PeopleSoft for Graduate, Undergraduate Schools. There was a huge backlog of patches and fixes for more than 10 months when I joined the project. Developed a strategy and set up a plan for all the coming upgrades, patches throughout the implementation cycle from DEMO to PROD. Implemented the plan to apply patches and upgrades in Student Administration/HRMS as well as Financials environment by coordinating with one functional team member for each module.
• Created row level and PeopleSoft security matrix based on functional responsibilities and groups of users for each school. Documented and configured security mapping to roles and permission lists in 8.3 and trained internal resource as a security administrator.
• Set up entire change management process for PeopleSoft Student Admin, HR and Financials. Acted as a mentor and troubleshooter to pin down any problem in the change management process and fix them; streamlined the entire change management process to a backlog of only 2 weeks for fixes delivered by PeopleSoft.

Environment: PeopleSoft 7.6, 8.0, 8.9 with PeopleTools 7.6, 8.1, 8.2, 8.43, 8.45, 8.47. Database is Oracle 8i, 9i and 10g. IBM AIX 4.33, 5.1, 5.2 with IBM SP 30 and later IBM 690 with multiple LPARS.

Confidential, Durham NC

PeopleSoft Student Administration / All modules

• Working as a core technical team leader in full implementation cycle and supporting production, maintenance with user support in the critical situation when the project is going live. This project was with Confidential in Durham, North Carolina which implemented the PeopleSoft Student Administration for Admissions, Student Financials, Financial Aid and Student Records. This position required constant interaction with users and developers.
• Developed complete performance test plan and carried out performance testing for PERF database which is replica of PROD. Attacked problem processes and suggested remedies for tuning. In the process of upgrading from PeopleSoft 7.0 to PeopleSoft 7.5 worked as a technical team lead. Helped in house employees to apply all the patches and the bug fixes with applying RegsI, RegsII, Regs III, Regs IV etc. Responsible for operational support to around 350 worldwide users during this process. These include different aspects reflecting the changes in the COBOL procedures, DMS scripts, SQRs and PeopleCode. Also responsible for resolution of the Trouble Reports in timely manner which is the database of these problems.
• Resolved problems with the batch tuition calculation process, Cashier’s office opening and closing and quick post COBOL programs by debugging and modifying COBOL programs in Student Financials. Customized the award communication process, loan origination process, ISIRs, profiles and different external system data (EDI) interfaces.
• Converted several mass change definitions to SQRs, customized letter generation in the mail merge application, Student Communication setup, and customization of SQCs and wrote new SQCs as per the client specific needs. Also designed and documented the SQR and SQL standards for the future use.
• Streamlined and developed the evaluation rating calculation method based on different test scores like SAT and ACT etc. for 8 different schools since PeopleSoft provided procedures and method were not fit for Duke’s specific needs. Wrote all the technical documentation for communication management process, evaluation calculation process as well as the communication in Financial Aid.
• Providing constant user support to the admissions, financial aid module and ready for the Student Records and Student’s Financials module which is about to go live. In Student Financials, worked with functional power users to support conversion activities and fix problems in processes after fixes in Tuition Calc, Billing, Refund, Cashiering and GL interface. Also providing constant support to the functional folks who are testing these modules. Interacting with PeopleSoft Inc. for needed bug fixes and patches. Also assisting the DBA to troubleshoot and fix problems and fine tune the performance of the database and the application server middleware. Troubleshooting UNIX shell programs and environment settings; Working with system administrators and operators to monitor UNIX processes and file systems. Supported the developer who is building the World Wide Web self service application module using HAHT and PeopleSoft.

Confidential, Cleveland OH

PeopleSoft HRMS and Payroll Module

• Wrote SQR interface from PeopleSoft HR/Payroll to SAP Financials (General Ledger). This process of 4 phases produces several different reports and flat files that contain all the information concerning General Ledger. This interface accesses several PeopleSoft tables to get data related to earnings, deductions, benefits, taxes & accruals. At end, all the balanced data gets posted to SAP General Ledger.
• Wrote SQR interface from PeopleSoft Payroll System to SAP Accounts Payable. This interface collects information about some employees having wage garnishment automatically withheld from their pay and remitted to the appropriate entities. For Operating Units utilizing SAP financials and PeopleSoft, information about wage garnishments is forwarded to SAP via flat files. The flat file contain all the information necessary to create a Vendor Invoice in SAP and are loaded into the SAP accounts Payable/Vendor Invoice function via BDC processing.
• Wrote SQR interface which runs at the end of each pay period to send employee information for Employment Verification and Public Assistance Verification (TALX). This interface sends an output file at each pay end date after pay-confirm to TALX (Government organization which maintains data for every employee earnings for current year and past two years for Loan verification and public assistance purposes.) This file contains all active, inactive employee’s personal and earnings data for current and past 12 pay periods as well as earnings data past two years. This interface also produces the report for total data send.
• A set of SQR programs written for Archiving History Information: Payroll information from the old pay history file had been converted into PeopleSoft history database. The system is modeled after the PeopleSoft paysheet tables. This includes pay check, pay earnings, pay oth earns, pay deduction and pay tax. The system was designed to look and feel like the pay summary in PeopleSoft. The system allows Payroll personnel to lookup history information using the same panels and query tools used in the PeopleSoft production database. These SQR generates several files as well as reports.
• Customized various PeopleSoft delivered various SQR reports according to Confidential needs. These include Compensation Mgmt, Contractual Agreement Report, Union membership report, Deduction not taken report etc.
• Designed and wrote technical specs. for all these projects.
• The database used was Oracle 7.3 under HP-Unix.
• Streamlining processing of vendor files that included payroll and base benefit data. These files behaved like interface files to payroll systems- (both US and Canada), 3rd party benefit providers, appraisers and training providers.
• Modifying SQRs associated with payroll registers to help in funding accounts, balancing accounts and transferring data to the General Ledger system. These SQRs were then run through process scheduler for different pay groups.
• Modified SQRs for better performance and tuning which includes modification of joins and use of load-lookup.
• The database used was Oracle 7.3 under HP-Unix.