SUDHA AYYANGAR
Sudha.Ayyangar@gmail.com
Over 17 years of experience as a Systems Analyst and Programmer including 10
years in PeopleSoft Administration and support of HR, Benefits and Payroll and
Financials environment.
* PeopleSoft HRMS 8.81 (HR, Benefits and Payroll)
* PeopleSoft SCM 8.81 (eProcurement)
* PeopleTools 8.46/8.44/7.5/7.0/6.0 * SQR/SQL
* PeopleSoft Query * PeopleCode
* Application Engine * EDI Manager
* Crystal Reports * COBOL
* Sybase 11.1.1 * ORACLE 9i
EDUCATION
Bachelor's Degree in Computer Science and Engineering, India (1991).
Ranked 4th in Madras University.
WORK EXPERIENCE
1. GMAC ResCap (Horsham, PA) August 2003 – Present
As a Consultant from EDS and later as an Employee of GMAC ResCap
PeopleSoft Administrator supporting PeopleSoft HRMS 8.8 and SCM 8.8
applications:
Act as a liaison between HR, Procurement, DB, Infrastructure and Web teams
PeopleTools upgrades
Migration of production and development environments from Horsham to Dallas
Total re-configuration of the demo, dev, model and production application
servers for optimal performance
Trouble shoot all application server related problems with minimal down time
Performance monitoring and tuning of the application servers to accommodate peak
usage
Application upgrade from HRMS 8.8 to HRMS 8.8 SP1
Application upgrade from SCM 8.8 to SCM 8.8SP1
Implement Tax updates, application bundles and various in-house projects
Implement SCM 8.8 eProcurement module
Integration of HRMS 8.8 application with SCM 8.8 application through Integration
Broker
Application upgrade of various maintenance packs for SCM 8.8 SP1
Development and production support work on SCM 8.8
Periodic check of PeopleSoft Customer Connection for any application/security
updates
Maintain Tree Security and User profiles
Involved in the technical side for various in-house projects and interface for
both PeopleSoft applications
NT configuration for process scheduler and crystal reporting
CIFS/ACL sharing of unix directories through NT
Active directory sync up with PeopleSoft
Constant interaction with the IT Help Desk to facilitate better and timely
support
Sarbanes-Oxley compliance
Implementation of data conversion strategies and acquisition strategies to
accommodate new employees to the application
Mentor for other PeopleSoft administrators
Environment: PeopleSoft HRMS 8.81, SCM 8.81, PeopleTools 8.46, PeopleSoft
8.44, Oracle 9i, WebLogic 8.1, UNIX, NT
2. CIBC World Markets (New York City) August 1998 – August 2003
As a Consultant from Mastech and later as Consultant from EDS
Implementation and maintenance of PeopleSoft HRMS (HR, Benefits and Payroll
modules):
Actively involved in the merge of Oppenheimer data with CIBC into PeopleSoft
6.0.
Generated the GL interface from PeopleSoft Payroll to the General ledger system
for the Payroll transactions.
FTE/Head Count Reporting
Upgrade from PeopleSoft Versions 6 to 7 and later from 7 to 7.5
401k inbound and outbound interface to/from the vendor.
Self-Funding Benefits interfaces for various plans.
Automation of FTP to/from vendors with encrypt/decrypt facility using PGP
software.
Payroll Inbound interface to upload commissions details into pay-sheets
W-2 printing
Rebuilt the Department Security tree for a new Rollup of Departments
Extension of Benefits for Terminated Employees
3. CIT (Livingston, New Jersey) February 1998 – July 1998
As a Consultant from Mastech
Implementation and maintenance of PeopleSoft Financials (GL, PO and AP
modules):
Daily maintenance of the PeopleSoft Financials modules.
Setup an automatic run control schedule for journal edit and post for the whole
year.
Setting the speed code types against purchase orders and also established the
processing of speed codes by employees.
SQR for the automated third party voucher load and edit process into the system.
Reformatting the purchase order in the delivered SQR.
Writing an SQR to extract data for Ceridian payroll existing on mainframe to
process the vouchers paid for employees through AP on a bi-weekly basis.
Crystal Reports for the year-end calculation of the voucher totals.
Also worked on a new Credit Exposure System using Visual Basic and SQL Server,
which was used by management to obtain credit details by each operating company.
Highlights: Called back again by the old client (See 5 below) for a different
project.
Environment: PeopleSoft Financials (AP, GL, PO), SQR, Crystal Reports, DB2-MVS,
VISUAL BASIC, SQL*SERVER.
4. JP Morgan (New York City) July 1997 – January 1998
As a Consultant from Mastech
Customization of PeopleSoft GL module:
Calendar Generation: Created a module for Yearly Calendar Generation to keep
track of the non-working days so that the Journal postings do not happen on
holidays. All the batch processes like Edit, Post and Average Daily Balance were
modified to use the above calendar.
- Local/Corporate Accounts: As a global company, the regulatory and corporate
requirements were different and both had to be satisfied. Batch processes like
the annual close, ADB, journal post, and the on-line Journal Entry panel were
modified so that the appropriate ledgers were updated.
- Flexible Suspense Processing: When suspense entries are created from the
journal edit process, a new journal should be created that reverses the suspense
from the original journal. A panel was created to bring the journals on-line, so
that they can be modified if necessary, then edited and posted. Changed the
COBOL modules for journal edit to create suspense journals.
Journal Description: Automated the journal description entry for year-end
journals, suspense journals and allocation journals.
Move/Merge: Generated a process to better control and document the processing of
move/merge of accounts and other chart-fields within business units for the ADB
ledger rows.
Allocation Changes: Generate a preview mode for the allocation request in a
separate view only allocations ledger and then confirm load, edit and post if the
allocation looks good.
- Annual Close Changes: The delivered annual close process creates period 999
entries and directly inserts them into the ledger with no supporting journals. A
journal entry backup for posted activity was needed. Changed the COBOL program
to pick all the Period 999 entries to create year-end journals with a status of
valid and posted. Also for “unclose” option, the year end journal entries are
deleted.
- ADB Changes: Added logic for the span of from and to dates across different
years in ADB processing. Added base amount was also averaged in ADB processing.
Previously the transaction amount was averaged.
- Reports: This included Journal Entry Detail Report, Journal Suspense Report,
Copy Journals, and Load Journals.
Environment: PeopleSoft Financials (GL), SQR.
5. CIT (Livingston, New Jersey) January 1997 – June 1997
As a Consultant from Mastech
Enhanced the PeopleSoft Financial Account Payable module by creating an
interface with a Ceridian system for the expense accounts (T&E accounts) using
SQR. Implemented a few known fixes in the PeopleTools 6.0, which involved changes
in Query, View creation, PeopleCode changes and Panel Designer. Created an
interface from XMS system, for import of Voucher data from XMS to PeopleSoft.
Created an EDI manager module for data transfer to/from PeopleSoft Application
from/to an external system. Created new and modified existing Application Engine
VCHREC as part of customization. Was involved in the design and coding phases.
Also designed a module for automated sharing of run control ids that carries run
control information of 160+ business units for GL
Environment: PeopleSoft Financials 6.0 (AP, GL, PO, AM), SQR, Application
Engineering, Crystal Reports, EDI Manager, Windows NT, DB2-MVS.
6. Bangor Hydro Electric Company (Bangor, ME) October 1994 – December 1996
As a Consultant from Mastech
CIS Conversion System: Transfer of data from mainframe VSAM files into ASCII
files and upload into ORACLE 7.0 database in UNIX platform using C.
Customer Accounting System: Daily maintenance and enhancement for this billing
and accounting of electric sales system that supported over 97,000 customers
Mainframe, VS COBOL, CICS, VSAM.
Financial Statement Reporting System: Collate data from mainframe on a monthly
basis for the revenue being billed to be processed in Paradox 5.0 to generate
financial statements for upper management reporting.
Environment: IBM 4381, UNIX, ORACLE 7.0, C, VSAM, CICS, VS COBOL, PARADOX 5.0
7. Household Financial Corporation (Chicago, IL) January 1994 –September 1994
As a Consultant from Square D
Worked with a team of 20, in the development, testing and implementation of
Integrated Financial Services. The project involved replacing an existing IMS
DB/DC and COBOL/MVS system with a Sybase/UNIX client/server system. It also
involved re-engineering existing programs to comply with ADA/ACE concepts.
Provided daily support and maintenance of the existing systems.
Environment: IBM ES-9000, MVS/ESA 4.2, VS COBOL, IMS DB/DC, XPEDITER, FILEAID.
8. Square D Software Ltd., India August 1991 –
December 1993
Involved in the design, development, testing and implementation of the
following projects:
Shares Accounting System
Integrated Training Information System
Personnel Information and Payroll System
Financial Accounting System
Tapioca Administration and Payment System
Environment: IBM ES-9000, MVS/ESA 4.2, VS COBOL, DB2 2.3, CICS 3.1.1, GML, TURBO
ANALYST, UNIX SVR 4.0, C, INGRES 6.2.
|
