•Applications: PeopleSoft V 4.9 – 7.5, Siebel V 99 – 2000, and Oracle Developer 2000.•Languages – SQR, Pro*C, SQL, PL/SQL, Java, CORBA, C++, C.•Databases - Oracle (8.x and 7.x), Object Store (OOD), SQL Server, MS Access.•TIBCO – TIBCO Rendezvous v6.x |
Siebel System Administrator/ Oracle DBA
• Successfully upgraded and migrated Oracle Database from 8.15 to 8.17 on Sun E450 to Sun E420.
• Responsible for 24x7 monitoring and fixing of problems with the Siebel CRM system and eSupport application and servers. Day to day administration of Siebel eCRM system including maintenance of tables, installation of thick and thin Siebel client software, and resolution of end-users requests.
• Enhancements to system as per user request, supported eServices application. Created and formalized backup procedure for Development and Production Oracle databases.
• Contributed towards the upgrade of Siebel system from 6.0.12 to 6.2.1.
• Installed TIB/Hawk and created rules to monitor production system.
• Environment: Siebel V99 and 2000 CRM, TIBCO RV, TIBCO Hawk, Actuate 4.5, Oracle 8i, Unix and Windows NT and 2000.
Jul. 1999 SAIC. San Diego, CA
Systems Analyst / Developer –HRMS
• Developed custom panels, records, created and added fields to the existing PeopleSoft delivered record definition, process definitions, menu items and wrote required PeopleCode for the new panels to run interface programs.
• Performed database-related work like alter, create, truncate and drop test tables and fine tuned SQR programs and SQL queries written by team members.
• Environment: PeopleSoft HR V 7.5, Windows 98, Oracle 8.04, and MS Binder.
Oct. 1998-Apr. 1999 Litton-PRC Inc. Woodland Hills, CA
Systems Analyst –HR, Payroll, Base Benefits
• Developed custom panels, records, process definitions, menu items and wrote required PeopleCode for the new panels to run interface programs.
• Converted data from Legacy system (Mainframe) to PeopleSoft using SQRs, data mapping.
• Modified and enhanced SQR programs, crystal, nVision, Process Definition, run control panels, Menu items, panel groups created by programmers.
• Trained end-user to access and run new interface program.
• Environment: PeopleSoft HR, Payroll, Benefits V 7.01, SQR 3.1,Crystal Reports 5.0, Windows 95, UNIX, Oracle 7.3
|