Resume of PeopleSoft/Oracle DBA

Title
PeopleSoft/Oracle DBA

Primary Skills
PeopleSoft, Oracle, Unix, RMAN

Location
Canada-ON-Brampton

Posted
Feb-22-08

Sr. PeopleSoft/Oracle DBA

Background
Mr. Sandhu has over 12 years of experience in relational database installation, configuration, creation, tuning, maintenance and user management. He has extensive experience as a Lead PeopleSoft Administrator, Oracle database administrator, EPM administrator, Change management STAT administrator, Application/database tuner, and system architecture specialist, RMAN, SQL Backtrack. Serving as the team lead for various projects and an Oracle instructor, he is excellent at assisting other members of the project team. He has been involved in multiple PeopleSoft installations and upgrades including Financials, HCM, Payroll, Benefits, and Student Administration. He has managed, administered and coordinated complete life cycles of multiple system and applications projects in multiple industries including financial, manufacturing, telecommunication and consulting.


Summary of Qualifications

• Strong technical and leadership skills including worked as an part-time instructor in top universities including Georgetown Univ. DC, George Washington Univ, DC and Virginia Tech., VA.
• Ability to work and manage projects independently, with a proven ability to meet and exceed set goals and deadlines.
• Work effectively with colleagues and clients at all levels.
• Detail oriented multi-faceted skill set, with exemplary organization and project management skills.
• Strategic thinker and planner, skilled in the design and execution of effective IT solutions.
• Working in PeopleSoft HCM, Benefits, Payroll, Student Administration, eRecruit, PeopleSoft Financials and PeopleSoft CRM, PeopleSoft change management using Quest STAT and others.
• Strong skills in business process analysis, relationship development and strategic alliances building.


Technical Training

• Successful Project Management
• PeopleSoft Server Administration 8.4x
• PeopleTools I & II
• Oracle 10g Backup and Recovery.
• Oracle 10g Performance Tuning.



Technical Proficiencies
? Products: PeopleSoft HCM, Payroll, Financials, CRM, PIA, BEA Tuxedo, Application Servers, IBM WebSphere, WebLogic, Quest STAT
? RDBMS / DBMS: Oracle 10g/9i/8i/8/7.x, DB2, SQL Server
? Component Interface: PeopleCode, PeopleTools, SQR, Business Object, Application Engine.
? Oracle Tools: SQL Backtrack, OEM, RMAN, Erwin, Export/Import, SQL*Loader.
? Languages: C/C++, JAVA, Java Script, XML, ASP, VBScript
? Application Server: Oracle Application Server
? Operating Systems: Sun Solaris, HP UX, AIX, and Windows


Education

Bachelors Degree in Electrical and Electronics Engineering (BS)








PROFESSIONAL EXPERIENCES

IBM Canada Sep 2005 -- Till Date

• Currently working on PeopleSoft/Oracle implementation for Canadian Tire in HCM 9, Benefits, Payroll, Pension, Time and Labor on PeopleTools 8.49.02
• Sr. IT Specialist with IBM and responsible for supporting multiple clients for production support and upgrade of Oracle databases and PeopleSoft applications (Student Admin, Financials, HCM) including 3rd party softwares.
• Successfuly upgraded PeopleSoft Financials for University of Alberta from 8.4 to 8.8 MP1 on PeopleTools 8.47.05
• Upgrade Oracle databases from 9i to 10g on AIX and Windows environments.
• Responsible for database backups and recovery as and when required including testing disaster recovery using SQL Backtrack.
• Provide 24X7 on-call support to all designated clients.
• Developed and proposed new backup strategies in accordance with customer needs.
• Apply Oracle database releases, PeopleSoft tools and application patches.
• Extensive in hand knowledge of Autosys for scheduling PeopleSoft batch jobs, Oracle database nightly backups, troubleshooting, adding new jobs, changing existing jobs.
• Worked extensively with configuring Integration broker between PeopleSoft financial and HR/Student Admin application including setting up page out if any channel is stuck or in error.
• Worked on creating troubleshooting documents for production support as reference document for other members of the team.
• Automated refresh of non-production databases and PeopleSoft file system from production environment.
• Create new PeopleSoft databases for new application upgrades or for new application testing.
• Worked extensively on unix and windows scriptting.
• Provide training to new team members.



Choice Hotels Intl (CHI) Mar 2004 -- Sep 2005

• Upgrade PeopleSoft FSCM from 8 SP1 to 8.8 SP1 MP1 and PeopleTools from 8.19.12 to 8.45.14
• Installed, configure, tuning of WebServer (WebLogic 8.1), Application server and process schedulers.
• Successfully configured new Financials PeopleTools 8.45 Integration broker with existing HRMS PeopleTools 8.19 Application messaging.
• Tuning and running simultaneous data conversion app. engine programs during upgrade to reduce the total time to be taken for upgrade.
• Applied required PeopleSoft bundles, patches and fixes using Change Assistant.
• Configured production and QA databases with new PeopleSoft performance monitor database.
• Worked extensively with internal and external auditors to get Sarbanes Oxley certification.
• Team Lead for vanilla implementation and configuration of new Peoplesoft budgeting BAM & ABM application.
• Successful implementation of EPM 8.8 budget.
• Extensively worked with Ascential ETL mappings for EPM 8.8 in reference to creation of ODS and correcting errors for FSCM destructive/incremental loads.
• Meet with the customers to define requirements.
• Create new PeopleSoft release demo, dev and QA databases. Also refresh of PeopleSoft non-production databases from production database.
• Installation, configuration, managing Quest STAT for version and change management tool for PeopleSoft/Oracle applications.
• Provide necessary maintenance and upgrade to new versions of STAT.
• Provide necessary training to new team members and troubleshoot issues for developers.



Computer Science Corporation (CSC) Jun 1999 -- Mar 2004

• Worked as Technical Team Lead for PeopleSoft Upgrade of HRMS, Payroll North America, Benefits Administration, Time and Labour for Education Testing Services(ETS), Princeton, NJ.
• Successfully completed PeopleSoft Upgrade of Financials and CRM to PeopleSoft 8.8 SP1 and PeopleTools 8.43.10.
• Performed performance tuning for PeopleSoft application server and process scheduler.
• Installed and configured multiple WebSphere/WebServers on different ports within single machine
• Automated process of clearing cache on weekly basis for Application servers, WebServer, and PeopleSoft process scheduler.
• Implemented PeopleSoft 8 for BT group of companies in the US.
• Setup and Configuration of PeopleSoft HRMS 8 SP1/8.18 Vanilla system in HP-UX, Oracle 8i infrastructure
• Create Development, QA, UAT Databases for BT US PeopleSoft8 Implementation.
• Device Project Plan and Execute a Data Migration projects for migrating data from PeopleSoft7 onto PeopleSoft8 HRMS.
• Integration of Development, QA efforts and Implementation into production.
• Performed logical/physical database backups using various methods, including exports, cold backups, hot backups, and Oracle Recovery Manager backups.
• Performed database refresh from global database to local development databases.
• Set-up Web Server and Application Server and iteratively made configuration changes on the Web servers and the Application servers.
• Responsible for applying patches to the Oracle and PeopleSoft environments.
• Served as PeopleSoft 8 and Oracle 8i administrator on HP-UX and AIX with responsibility for installing, configuring, tuning, and maintaining entire 3-tier environment.
• Created and implemented detailed systems document with all the directory structures of their PeopleSoft Internet Architecture.
• Performed database tuning which included changing the entire SGA, increasing number of rollback segments, restructuring location of data files, changing size and location of redo log files and setting up archive logging to improve database performance.
• Responsible for Installation, Configuration and Support of the PeopleSoft Application servers, Process Schedulers and Web Servers.
• Developed and automated Unix shell scripts to backup both logical and physical backups to tape using the OS backup.
• Provided 24/7 support for the Financial and HRMS PeopleSoft/Oracle production databases.
• Involved in design, development, enhancement and maintenance of PeopleSoft HRMS (Human Resource, Benefits) and PeopleSoft Financials.
• Interfaces and Conversions, Migrations and Reporting.
• Analysis, Coding, Writing Specifications and Interacting with Users for Application Implementation, Upgrade, Customizations and Enhancements.
• Setup new Operator Classes, and Operators using Operator Security tool to restrict and enable user access.
• Develop new SQR and Crystal reports to suit the user requirements and needs.
• Created PeopleSoft Queries reports as requested by department managers.
• Migration of different applications from development database to test database and then to production database.
• Making the process automated for taking nightly Backup's of all the development and test databases.
• Responsible for refreshing of the development databases from production database and to mask the data.
• Made kernel configuration recommendations and assisted in the tuning of the HP kernel, which resulted in a dramatic improvement in system, performance and the ability to handle increased user activity.


Complete Software Solutions Nov 1997 - May 1999

• Administered Oracle 7.3 Inventory Management & Financial Application databases.
• Implemented Oracle Enterprise Manager on 3-tier scale; setup jobs/events and agent configuration.
• Worked in PeopleSoft Financials, Payroll Interface, Custom SQRs, and Custom Queries.
• Developed vendor interfaces, PeopleCode, PeopleTools, customized applications by creating new records, panels, panel groups, giving security.
• Design and develop new records/ panels, and modify the existing objects to meet company specific business needs.
• Setup new Operator Classes, and Operators using Operator Security tool to restrict and enable user access.
• Designed and Configured the Symmetric Replication as a pilot project for the Inventory at 4 of the warehouses, with 1 central Master definition site & 4 other Master definitions sites with 8 tables under the replicated environment for the online-transaction replication. This is performed for Oracle 8 on Windows NT platform.
• Handled tasks like space management, User & Resource management, backup monitoring, and Recovery management.
• Reorganized the existing databases for better performance.
• Ported Data to Oracle Databases from/to oracle as well as non-oracle databases using SQL Loader.
• Configured Standby databases for the most critical production database.

Software Specialist July 1996 -- Oct 1997

• Worked in PeopleSoft HRMS in the modules of Administer Workforce, Base Benefits, Benefit Administration and Payroll Interface.
• Setting up Benefits and Payroll foundation tables for various Benefits plans.
• Develop new SQR and Crystal reports to suit the user requirements and needs.
• Design new run control ids' for panels and attached to process scheduler to run reports (SQR & Crystal) from PeopleSoft application.
• Customizations for US Regulatory purposes, SQRs, Upstream Downstream Web applications.
• Created PL/SQL packages, stored procedures, functions and triggers.
• Developed SQL Loader scripts to migrate large amount of data from AS400 into Oracle tables.
• Using Oracle forms developed a system for the internal use to assist in the projects monitoring.
• Designed & documented the specifications of the system
• Developed, Testing and implementation

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in Canada-ON-Brampton »
View all resumes in Canada-ON »

View other PeopleSoft/Oracle DBA resumes, Database Administrator resumes