SUMMARY

• Over 11 years of result oriented IT professional experience as a PeopleSoft System Administrator/Architect, managing PeopleSoft applications HCM, CRM, FSCM, PORTAL, ELM, and Application Change Management - ACM QUEST STAT, PHIRE Architect on databases such as Oracle, MS SQL Server, DB2 residing on various platforms - IBM AIX, HP UNIX, Sun Solaris, Linux, and Windows 2003/2008/2012.
• Extensive experience in Project plan, Design, Architecture, Implementations, Upgrades, PeopleSoft Update Manager (PUM) setup, Two-factor authentication setup, Installations, Setup and manage PeopleSoft environments (PROD, PREPROD, QA, TEST, and DEV).
• Production refreshes, system administration, PeopleSoft and database system performance tuning, PeopleSoft migrations, updates and fixes to PeopleSoft applications and databases, PeopleSoft security, configuration management, product enhancements, high availability and disaster recovery (DR).
• Support functional and development teams, business units of the clients and offshore teams with any PeopleSoft and database requests. Manage incident tickets, troubleshoot issues, perform root cause analysis and provide corrective actions and implement process improvement procedures to minimize human introduced errors.
• Perform 24*7 on-call rotations, implement change controls through change control process. Follow ITIL best practices for IT Service Management.
• Extensive experience in implementations, upgrades, and system administration of PeopleSoft applications HCM, CRM, FSCM, PORTAL, ELM, and Application Change Management - ACM QUEST STAT, PHIRE Architect, and Oracle Policy Automation (OPA), UPK, OEM.
• Design, Architect, and Implement PeopleSoft Internet Architecture and Batch processing for large Scale PeopleSoft applications.
• Hands on experience asDB2 DBA for mainframes and AIX environments and Lead team of 7 DB2 DBA. Provided mentoring services in DB2 DBA, Data Modeling and Development.
• Enterprise Manager 12c and 11g, Exalytics, TimesTen, OBIEE 11g, Exadata, PeopleSoft and Oracle Database administration.
• An accomplished professional with nearly 10 years of in-depth experience on different Oracle products. Interface, Elastic Search, Oracle Exadata/Exalogic, DW/EPM/OBIEE, WCAG/508 Installation, configuration and maintenance of Exadata and Exalytics machines
• ExalyticsClustering for MAA, TimesTen configuration, In-memory Cache setup, Usage Tracking
• Strengths includeData Architecture, database administration, production support,Performance Monitoring and Tuning.
• Setup and manage PeopleSoft environments (PROD, PREPROD, QA, TEST, and DEV) for HCM, CRM, FSCM, PORTAL, ELM, STAT and PHIRE Architect migration tools.
• Define configurations, potential gaps that may require system modification and identify impacts of analysis/identify downstream processes and/or reports
• Define CS 9.2 Application upgrade planning, deployment alternatives, recommend priority of deployment process and list functions to deploy in CS 9.0 prior to CS 9.2
• Install and configure PeopleSoft Update Manager (PUM)
• Install and setup Oracle databases for PeopleSoft applications, perform database refreshes, diagnose and tune PeopleSoft related Oracle queries with help of SQL queries and using Oracle 11g OEM tool.
• Install, configure, and manage Web Logic/Web Sphere web servers, Tuxedo application servers and process schedulers on UNIX, LINUX, AIX and Windows platforms.
• Performance tuning of PeopleSoft databases, web servers, application servers and process schedulers on UNIX, AIX and Windows platforms.
• Setup PeopleSoft Web servers on DMZ for internet facing applications, configure failover and high availability utilizing third party load balancers such as Net Scalar (Citrix), BIG-IP (F5 Networks), and CISCO-ACE.
• Excellent Working knowledge of network topologies, protocols, DMZ network and firewall technologies.
• Install and Configure Web logic cluster and coherence. Setup SSL for web servers, Digital Certificates for Appservers and configure REN SSL using External Keystore for RenServer.
• Setup various models of PeopleSoft report repository based on PIA architecture and configure report distribution using both HTTP/HTTPS and FTP nodes.
• Setup FTP, SFTP, and FTPS for PeopleSoft file transfers from online and batch process.
• Setup and manage PeopleSoft Integration Broker, and application messaging.
• Install and Configure COBOL compilers Server Express, Net Express 4.0/5.0/5.1 and compile/link Cobol Programs
• Install People Books help and Configuring Context-Sensitive Help/Verity Search in PeopleSoft applications
• Configure and enable Single Signon feature between multiple PeopleSoft applications and PeopleSoft application and third party applications.
• Configure LDAP for PeopleSoft integration with MS Active Directory or Oracle directory.
• Setup two-factor authentication
• Perform PeopleSoft Project Migrations with app designer and Quest STAT, and PHIRE migration tools
• Experience in using of PeopleSoft upgrade tools such as Change assistant and upgrade assistant.
• Perform load test for PeopleSoft implementations and upgrades using QTP, HP LoadRunner, IBM Rational Performance Tester and analyze load test results and implement necessary changes in Production system.
• Install and Setup database and PIA for PeopleSoft Performance Monitor.
• Setup and configure PeopleSoft third party Batch scheduling using Autosys, Control M and Cybermation ESP.
• Apply Web logic, Tuxedo patches, and co-ordinate Operating System and Database patching
• Good understanding of PeopleSoft reporting tools- PS QUERY, XMLP, SQR, Crystal, nVision.
• Ability to trace all types of PeopleSoft trace, including SQL, people code, Application Engine, COBOL
• Install, build and administer Oracle and SQL Server Databases, tune databases at Instance level for optimal performance.
• Backup databases using online and logical methods such as RMAN and Export utility
• Assess and assist in database SQL monitoring, tuning and modification and implication of various PeopleSoft delivered SQL queries.
• Write Scripts using Unix Shell and SQL for monitoring, generation of alerts and maintenance for PeopleSoft and database environments and schedule them to run periodically using crontab and task manager on UNIX and Windows systems.
• Setup Monitoring alerts for PeopleSoft environments using scripts and third party tools such as OEM, Compuware-Gomez, Smarts, Fog light, BMC patrol, HP Open view. .
• Consolidate servers for PeopleSoft development environments to save system resources and simplify maintenance.
• Network with various teams with in and out of organization - Network, Security, Database, UNIX, Windows, Desktop, Operations team, and vendors.
• Install, Configure and Deploy PeopleSoft People Tools, Oracle client, Quest STAT client, Crystal Reports client, and other applications for end users and offshore team to support PeopleSoft environments.
• Application virtualization and administration of PeopleSoft and third party tools on Citrix XenApp.
• Dell Quest STAT Implementation, Upgrade, System administration and Security Administration.
• PHIRE Architect Implementation, Upgrade, System administration and Security Administration.
• Coordinate with Auditors and generate audit reports related to PeopleSoft infrastructure.
• Provide documentation for Requirements, Design, Build and Support.
• Excellent communication skills, systematic approach and ability to work effectively in a fast paced environment leading to excellent customer service, response and delivery.
• Responsible for Installation, Upgrading, Migration of Oracle databases.
• Planning and designing databases including designing local structures and forecasting further expansions, experience in administering the production database.
• Monitoring & Tuning database performance using Statspack, TKProf and OEM.
• Managed Tablespaces, Rollback Segments, Redo Logs and other database objects.
• Used Import, Export, SQL*Loader and other tools to load and backup data including RMAN and Dataguard. Database Recovery (both complete and incomplete) from media failure.
• Created and maintained Standby database for minimum downtime.
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges for users.
• Good Co-ordination with System Administrators and Network Administrators to achieve zero down time and better server performance.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008/2012/ XP/7/10, IBM AIX, HP-UNIX, Sun Solaris, and Linux

Databases: Oracle 9i/10g/11g, MS SQL Server 2005/2008, and DB2 UDB 7/8

Application Servers: TUXEDO 8.1/10gR3/12cR1

Web Servers: Web Logic 8.1/10.3.x/12c, IBM WebSphere, Microsoft IIS, and Apache

ERP Applications: PeopleSoft HCM, CRM, FSCM, PORTAL, ELM 7.xx/8.xx/9.x

PeopleSoft People Tools: People Tools 7.5x/8.4x/ 8.53/8.54/8.55 (Configuration Manager, Application Designer, Data Mover, Process Scheduler, and Change Assistant), and PeopleSoft Update Manger (PUM)

Reporting Tools: SQR, Crystal Reports, nVision Reports, and XML Publisher

Supporting Technologies: Oracle Policy Automation (OPA) 10.4.x, UPK 11.x, OEM 11g/12c

Monitoring Tools: PeopleSoft performance monitor, OEM, Compuware dynaTrace, Service Center (SMART, opsmgr), HP Open view, Quest Spotlight

Change Management Tools: QUEST STAT 5.2.x/5.3.x/5.4.x/5.5.x/5.6.4, PHIRE Architect 9.x/10.x

Job Schedule Tools: CA Autosys 4.5/11.x, CA ESP 11.x Workload Automation Business Agent for PeopleSoft

Load Balancers: Net Scalar (Citrix), BIG-IP (F5 Networks), and CISCO-ACE

Testing Tools: HP LoadRunner, IBM Rational Performance Tester 8.6, QTP, PTF

Application virtualization: Citrix XenApp

IT service management: ServiceNow

Other Tools: Microsoft Office Tools (Word, Excel, Project, Visio, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr. PeopleSoft System Administrator/Architect - Lead

Responsibilities:

• Analyze legacy system, gather requirements and design systems for new PeopleSoft Applications and supporting technologies (HCM 9.2, CRM 9.2, FSCM 9.2, PORTAL 9.1, ELM 9.2, PeopleSoft Update Manager (PUM), PHIRE Architect v9.2, IBM RPT 8.6, OPA 10.4.x, Oracle WebLogic Suite, Oracle SOA Suite, AMC Express Agent (MCIS), CA ESP Workload Automation Business Agent for PeopleSoft, Fax product integration (RightFax), Merkur Group DeliveryWare (Base Server, Rules Engine, Image Recognition Module) Connector for PeopleSoft)).
• Planning, designing, building, implementations, upgrades, maintenance packs, Tax updates, bundles and fixes to PeopleSoft applications, environment setup, database refreshes, migrations, security, configuration management, product enhancements, designing high availability, Disaster recovery (DR) solutions planning and testing for PeopleSoft applications and oracle databases.
• Build, Configure PeopleSoft HCM 9.2, tools 8.55 on Image 18 using DPK'sBuild, Configure PeopleSoft FSCM 9.2, tools 8.55 on Image 17 using DPK'sInstalled and configured PeopleSoft DEMO and System databases and applications for HCM/FSCM & Portal on People Tools 8.55 and on Oracle Databases, PeopleSoft FMS/SCM, PeopleTools, Fluid User Interface, Elastic Search, Oracle Exadata/Exalogic, DW/EPM/OBIEE
• Configure PeopleSoft Update Manager (PUM) via Change Assistant.
• Configured various management packs includingWebLogic management pack EE, Exalogic Elastic Cloud Management Pack, Exadata Management Pack, Coherence management Pack
• Design, Architect, and Implement PeopleSoft Internet Architecture and Batch processing for PeopleSoft applications.
• Install, configure, and manage Web Logic web servers, Tuxedo application servers and process schedulers on AIX, UNIX, LINUX, and Windows platforms.
• Manage PeopleSoft systems and database for HCM, CRM, PORTAL and FSCM applications, including support for multiple PeopleSoft environments (PROD PREPROD, QA, TEST, DEV, Training, and Monitoring).
• Assess and assist in database SQL monitoring, tuning and modification and implication of various PeopleSoft delivered SQL queries.
• Performed FSCM, HCM & Portal People Tools upgrade from
• Fine-tuned several server related parameters with tools 8.55
• Upgraded to HCM 9.2 Image18 using PUM through Change Assistant
• Upgraded to FSCM 9.2 Image17 and applied Bugs thru Image 18.Setup various models of reporting based on PIA architecture and configure report distribution using both HTTP/HTTPS and FTP nodes.
• Setup FTP, SFTP, and FTPS for PeopleSoft file transfers from online and batch process.
• Install and Configure Web logic cluster and coherence.
• Setup SSL for web servers, Digital Certificates for Appservers and configure REN SSL using External Keystore for RenServer.
• Setup up, configure and maintain integration broker gateway, services, service operations, queues, routings and application messages for internal and external
• Disaster recovery planning, testing. For PeopleSoft databases and applications.
• Install and configure PeopleSoft application upgrade tools, migration tools, data mover
• Install and Configure COBOL compilers Server Express 5.1 and compile/link Cobol Programs
• Install People Books help and Configuring Context-Sensitive Help/Verity Search in PeopleSoft applications
• Configure Single Signon between multiple PeopleSoft applications, PeopleSoft application to third party application.
• Configure LDAP for PeopleSoft integration with MS Active Directory.
• Setup two-factor authentication.
• Perform PeopleSoft Project (code) Migrations with app designer and using Dell Quest STAT.
• Setup Web servers on DMZ for Internet facing applications and configure firewall policies.
• Perform load test for PeopleSoft implementations and upgrades using QTP, Load Runner and IBM Rational Performance tester.
• Analyze Load test results using PeopleSoft delivered Performance Monitor, PSPING utility, PeopleSoft Logs, homegrown tools such as SQL queries, Oracle 11g/12c OEM, and OS based analytical tools such as TOP, TOPAZ, NMON.
• Document and implement necessary changes in the configuration of Web and application servers, OS resource utilization methods based on Load test analysis for the optimal performance of PeopleSoft Databases and PIA in Production system.
• Configure CA ESP Workload Automation Business Agent for PeopleSoft.
• Install and Setup database and PIA for PeopleSoft Performance Monitor for PeopleSoft environments (Production and Upgrade environments) monitoring.Apply People Tools, Web logic, Tuxedo patches complying OS and Oracle database patches.
• Manage PeopleSoft reporting - PS QUERY, XMLP, SQR, Crystal, nVision reports
• Setup all types of PeopleSoft trace, including SQL, people code, Application Engine, COBOL, etc.Install, configure, administer and upgrade Fax product (RightFax).Assist in performance tuning (SQL), and setup SQL Monitoring using Oracle SQLPLUS and shell scripting.Unix Shell scripting and setup crontab jobs, Windows Batch scripting and setup tasks through task scheduler to automate different tasks.Experience in installing MS SQL SERVER 2014, 2012, 2008 R2, 2008, 2005 and updating with hot fix and service packsand also AWS, Azure environments.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts and other RDBMS (Oracle 10g, 11g and 12c).
• Implemented In-place and Side by SideMigration of MS SQL SERVER R2 and 2008R2 to 2012
• Experience in writing T-SQL (DDL, DML, and DCL) statements
• Knowledge in Spark Streaming and Spark SQ.Experience in writing queries, T-sql..Implementing CR (Change Request) and CA (Change Amendments) requested by users.Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.Performed SQL Upgrades. SQL and building SQL Clustering.Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• UsedDTS/SSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data marts and performed action in XML.Worked on loading data from various data sources using MS Data Transformation Services (DTS).Created and integrated user defined functions and stored procedures for reporting purposes.
• Creating and Maintaining OVM. Interface, Elastic Search, Oracle Exadata/Exalogic, DW/EPM/OBIEE, WCAG/508
• Create public and private keys to communicate between UNIX servers and to run shell scripts remotely.
• Setup Monitoring alerts for PeopleSoft environments using shell scripts and third party tools such as Compuware-Gomez, Smarts, Fog light, HP Open view and Oracle OEM
• Evaluate PeopleSoft application supporting tools and technologies
• Consolidate servers for PeopleSoft development environments so as to conserve disk space and for simplify maintenance.
• Network with different teams - Network, Security, Database, Unix, Windows, Desktop and Operations team
• Install, Configure and Deploy PeopleSoft People Tools, Oracle client, Quest STAT client, Crystal Reports client, and other applications on Citrix XenApp application virtualization for end users and offshore team to support PeopleSoft environments.
• PHIRE Architect (Change Management & Version Control Tool) Implementation, Upgrade, System administration and Security Administration.
• Perform PHIRE Architect implementations and upgrades to various versions 9.1/9.2
• Prepare audit reports required for yearly Audit of PeopleSoft directory permissions on the server and PHIRE user permissions within PHIRE database
• Documentation - Technical design and architectural, project build, version compatibility, PeopleSoft architecture diagrams, infrastructure design, system build, maintenance, support, and resolutions as well as presentation materials

Environment: People Tools 8.53/8.54/8.55 , HCM 9.2, CRM 9.2 FSCM 9.2, PORTAL 9.1, ELM 9.2, PeopleSoft Update Manger (PUM), Oracle 11g, WebLogic Server 10.3.6/12c, Tuxedo 11.1.1.2/12 cR1, COBOL compiler Micro Focus Server Express 5.1 WP6, Crystal Reports 2008 sp3, CISCO Web server load balancer, DMZ, AIX 7.1, Windows 2008R2, 2012, VMware, CITRIX XenApp, Phire Architect v9.1/9.2/10.x (Application Change Management - ACM), IBM Rational Performance Tester 8.6, Oracle Policy Administration (OPA) 10.4.x, Oracle WebLogic Suite, Oracle SOA Suite, AMC Express Agent (MCIS), CA ESP 11.x Workload Automation Business Agent for PeopleSoft, Fax product integration (RightFax), Merkur Group DeliveryWare (Base Server, Rules Engine, Image Recognition Module) Connector for PeopleSoft, LRS VPSX, SecureAuth two-factor authentication.

Confidential, Sunnyvale, CA

Sr. PeopleSoft System Administrator/Architect

Responsibilities:

• PeopleSoft Financials Upgrade- Financials 8.4 to 9.1, Financials 8.9 to 9.1 and Tools Release, Installation of Tools 8.51 and Tools 8.47
• HCM 9.0 to 9.2 Upgrade. Also, Enhancementand production support for 9.2 system
• Responsibilities/Activities Contributed as developer and team member to the HCM upgrade from 9.0 to 9.2 and had active role in interaction with the users andtheir specifications.
• Created new and customized existing PeopleSoft objects (Pages, Page Groups,Menus, People Code, Process Definition) andapplied SecurityInvolved in the development of SQR’s relatedto the modified payroll system in 9.2.Assigned to upgrade custom PeopleCode 9.0 installation, configuration, and testing of a Campus Solutions 9.2 and PeopleTools 8.55 upgrade as well as Microsoft SQL and integrations.
• Maintaining PeopleSoft system performance by performing system monitoring, analysis and performance tuning; troubleshooting system hardware, software, networks and operating systems, escalating application problems to vendor. to 9.2.Converted numerous custom SQRs andPeopleSoft delivered SQRs according to 9.2equirements. Configure CA ESP Workload Automation Business Agent for PeopleSoft.
• Install and Setup database and PIA for PeopleSoft Performance Monitor for PeopleSoft environments (Production and Upgrade environments) monitoring. Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MSSQLServer 2000 andSQLServer Integration Services (SSIS) in MSSQLServer 2008/2005 with .NET, Import/Export data, Bulk insert and BCP.
• Installed and configured PeopleSoft Update Manager (PUM)
• Install and setup Oracle databases for PeopleSoft applications, perform database refreshes, diagnose and tune PeopleSoft related Oracle queries with help of SQL queries and using Oracle 11g OEM tool.
• Backup databases using online and logical methods such as RMAN and Export utility
• Assess and assist in database SQL monitoring, tuning and modification and implication of various PeopleSoft delivered SQL queries.
• Capacity planning, Business continuity planning, systems sizing and tuning web servers, application servers and process schedulers on UNIX, AIX and Windows platforms.
• Setup third party load balancers for PeopleSoft web servers and configure high availability for application Servers.
• Setup various models of reporting (PeopleSoft report repository, VISTA reporting) based on PIA architecture and configure report distribution using both HTTP/HTTPS and FTP nodes.
• Setup FTP, SFTP, and FTPS for PeopleSoft file transfers from online and batch process.
• Install and Configure Web logic cluster and coherence.
• Setup SSL for web servers, Digital Certificates for Appservers and configure REN SSL using External Keystore for RenServer.
• Setup up, configure and maintain integration broker gateway, services, service operations, queues, routings and application messages for internal and external
• Disaster recovery planning, testing. For PeopleSoft databases and applications.
• Install and configure PeopleSoft application upgrade tools, migration tools, data mover
• Install and Configure COBOL compilers Server Express, 4.0/5.0/5.1 and compile/link Cobol Programs
• Install People Books help and Configuring Context-Sensitive Help/Verity Search in PeopleSoft applications
• Configure Single Signon between multiple PeopleSoft applications, PeopleSoft application to third party application.
• Configure LDAP for PeopleSoft integration with MS Active Directory.
• Perform PeopleSoft Project (code) Migrations with app designer and using Dell Quest STAT.
• Setup Web servers on DMZ for Internet facing applications and configure firewall policies.
• Perform load test for PeopleSoft implementations and upgrades using QTP, Load Runner.
• Analyze Load test results using PeopleSoft delivered Performance Monitor, PSPING utility, PeopleSoft Logs, homegrown tools such as SQL queries, Oracle 11g OEM, Gomez/Vantage alert system by Compuware and OS based analytical tools such as TOP,TOPAZ, NMON.
• Document and implement necessary changes in the configuration of Web and application servers, OS resource utilization methods based on Load test analysis for the optimal performance of PeopleSoft Databases and PIA in Production system.
• Configure PeopleSoft Agents and Support PeopleSoft Batch scheduling using Autosys.
• Install and Setup database and PIA for PeopleSoft Performance Monitor for PeopleSoft environments (Production and Upgrade environments) monitoring.
• Apply People Tools, Web logic, Tuxedo patches complying OS and Oracle database patches.
• Manage PeopleSoft reporting - PS QUERY, XMLP, SQR, Crystal, nVision reports
• Setup all types of PeopleSoft trace, including SQL, people code, Application Engine, COBOL, etc.
• Install, configure, administer and upgrade Fax Manager
• Install, create and administer Oracle Database, tune database instances and queries, backup and recovery of Oracle databases, refresh database instances from PROD using RMAN and Oracle import.
• Assist in performance tuning (SQL), and setup SQL Monitoring using Oracle SQLPLUS and shell scripting.
• Unix Shell scripting and setup crontab jobs, Windows Batch scripting and setup tasks through task scheduler to automate different tasks
• Create public and private keys to communicate between UNIX servers and to run shell scripts remotely.
• Setup Monitoring alerts for PeopleSoft environments using shell scripts and third party tools such as Compuware-Gomez, Smarts, Fog light, HP Open view and Oracle OEM
• Evaluate PeopleSoft application supporting tools like OEM, STAT and Phire
• Consolidate servers for PeopleSoft development environments so as to conserve disk space and for simplify maintenance.
• Network with different teams - Network, Security, Database, Unix, Windows, Desktop and Operations team
• Install, Configure and Deploy PeopleSoft People Tools, Oracle client, Quest STAT client, Crystal Reports client, and other applications on Citrix XenApp application virtualization for end users and offshore team to support PeopleSoft environments.
• Quest STAT (Change Management & Version Control Tool) Implementation, Upgrade, System administration and Security Administration.
• Perform Quest STAT implementations and upgrades to various versions 5.2.x/5.3.x/5.4.x/5.5.x/5.6.x
• Prepare audit reports required for yearly Audit of PeopleSoft directory permissions on the server and STAT user permissions within STAT database
• Involved in ServiceNow setup for IT service management
• Documentation - Technical design and architectural, project build, version compatibility, PeopleSoft architecture diagrams, infrastructure design, system build, maintenance, support, and resolutions as well as presentation materials

Environment: People Tools 8.4x/8.5x, HRMS 8.8/9.1, CRM 8.9/9.1 FSCM 8.8 SP1/9.1/9.2, PeopleSoft Update manager (PUM), Oracle 9i/10g/11g, Web Logic 8.1/10.3.x, Tuxedo 8.1/10gR3, COBOL compiler Micro Focus Server Express 4.0/5.0/5.1, Crystal Reports 2008 sp3, NetScaler (Web server load balancer), DMZ, Quest STAT 5.2.1/5.3.2/5.4.2/5.5. x/5.6.x, Autosys 4.5/11.x, VISTA 5.2, Fax Manager, AIX 6.1, HP UNIX 11.11 and Windows 2003/2008R2, VMware, CITRIX XenApp, Compuware dynaTrace, Service Center (SMART, opsmgr).

Confidential

PeopleSoft System Administrator

Responsibilities:

• Description: Hexaware has been invited by Mannai Corporation for implementing PeopleSoft Campus Solutions at QFIS. This system will help QFIS to automate the admissions/Enrollments functions. The system would be used by the QFIS Staff to schedule classes, enrolling into classes, generate letters, grading and producing transcripts. Students/Faculty will have self service facilities to check their schedule, classes, and announcements. The system will also be used by external Visitors who will apply for admissions over the internet. People tools upgradation, Orace 11gRAC
• Analyze Load test results using PeopleSoft delivered Performance Monitor, PSPING utility, PeopleSoft Logs, homegrown tools such as SQL queries, Oracle 11g OEM, Gomez/Vantage alert system by Compuware and OS based analytical tools such as TOP,TOPAZ, NMON.
• Document and implement necessary changes in the configuration of Web and application servers, OS resource utilization methods based on Load test analysis for the optimal performance of PeopleSoft Databases and PIA in Production system.
• Configure PeopleSoft Agents and Support PeopleSoft Batch scheduling using Autosys.
• Install and Setup database and PIA for PeopleSoft Performance Monitor for PeopleSoft environments (Production and Upgrade environments) monitoring.
• Apply People Tools, Web logic, Tuxedo patches complying OS and Oracle database patches.
• Manage PeopleSoft reporting - PS QUERY, XMLP, SQR, Crystal, nVision reports
• Setup all types of PeopleSoft trace, including SQL, people code, Application Engine, COBOL, etc.
• Install, configure, administer and upgrade Fax Manager
• Install, create and administer Oracle Database, tune database instances and queries, backup and recovery of Oracle databases, refresh database instances from PROD using RMAN and Oracle import.
• Assist in performance tuning (SQL), and setup SQL Monitoring using Oracle SQLPLUS and shell scripting.
• Unix Shell scripting and setup crontab jobs, Windows Batch scripting and setup tasks through task scheduler to automate different tasks
• Create public and private keys to communicate between UNIX servers and to run shell scripts remotely.
• Setup Monitoring alerts for PeopleSoft environments using shell scripts and third party tools such as Compuware-Gomez, Smarts, Fog light, HP Open view and Oracle OEM
• Evaluate PeopleSoft application supporting tools like OEM, STAT and Phire
• Consolidate servers for PeopleSoft development environments so as to conserve disk space and for simplify maintenance.
• Network with different teams - Network, Security, Database, Unix, Windows, Desktop and Operations team
• Install, Configure and Deploy PeopleSoft People Tools, Oracle client, Quest STAT client, Crystal Reports client, and other applications on Citrix XenApp application virtualization for end users and offshore team to support PeopleSoft environments.
• Quest STAT (Change Management & Version Control Tool) Implementation, Upgrade, System administration and Security Administration.
• Perform Quest STAT implementations and upgrades to various versions 5.2.x/5.3.x/5.4.x/5.5.x/5.6.x
• Prepare audit reports required for yearly Audit of PeopleSoft directory permissions on the server and STAT user permissions within STAT database
• Working on security reimplementation of PeopleSoft v9.1 AR, AP, GL, AM, Purchasing, eProcurement and Billing modules.
• Proposed enhancements to improve access provisioning process and turnaround time for issue resolution
• Design, document create new roles and permission lists for each business group granting the appropriate standard access for users while eliminating excess access and conflict of duties.
• Setup definition security to grant full definition access to developers in development and restricted read only access in test and production environments.
• Configured security objects and User Preferences within Set up Financials/Supply Chain.
• Manage all migrations of development and security objects via People Tools projects and Data Mover Scripts.
• Conducted multiple security requirements and design validation sessions with the client.
• Performed Database and Security Refreshes from the Production environments to Development and testing environments.
• Involved in a real time Disaster recovery test for various PeopleSoft instances.
• Involved in increasing the performance for web server, Application Server & Batch Servers by configuring the server parameters.
• Perform day-to-day system administration activities for enterprise information security solutions.
• Maintain the security administration of PeopleSoft Financials 8.8 by implementing the changes in the security structure as per the requirements from the business.
• Extensively used PSADMIN utility to Administer, Create & Configure Application Server and Process Scheduler Servers.
• Setup excel to CI in order to upload users in PeopleSoft.
• Re-design access requirements for system user ids like BATCH and REPORTING accounts.
• Have been involved in the analysis, design and test Security for the PeopleSoft product suite at Lab Corp. Work includes Security Templates, Security Matrices, and Workshops for Business Users.
• Extensively used MS-Access for creation of spreadsheets for security access creations for different applications depending upon the Security Matrix.
• Work with the Portal Administrator to develop Single Sign on Solution with existing LDAP, PeopleSoft Portal and other PeopleSoft applications. Design the internal and business security process for users. Establish best Security standards.
• Design and create new roles and permission list for all business users to grant appropriate access in the new upgraded application.
• Implemented Site-Minder SSO configuration with LDAP integrations. Configured PeopleSoft LDAP directory and prepared documentation required for LDAP.
• Designed and planned the Security model with the upgrade to v9.1
• Prepared step-by-step go-live security conversion process and checklist.
• Involved in designing Roles, Permission List and user profiles group for the new employees who join Lab Corp.
• Generated Private Key on the web server to get the certificate from Certificate Authority
• Imported Root and Digital certificates on the web server
• Configured SSL through Web Logic Admin Console
• Installed PeopleSoft client for the Users and trouble shoot login issues
• Installed People Books and configure help in PeopleSoft applications
• Performance tuning for Application Server and Web Server
• Migrated PeopleSoft Objects and Data through Application Designer and Data Mover
• Applied Maintenance Pack, Bundles, Patches, and Fixes using Change Assistant
• Trouble shoot the development issues
• Apply Application Server (TUXEDO) patches and Web Server (Bea Web Logic) patches
• Supported for Go - Live and post production
• Refreshed PeopleSoft Application Database from Production to Development, Test and QA
• Post refreshes configuration like Change DB Links, Report Node configuration, Integration Broker configuration, REN Server configuration and Change Single Sign on Links & Active Directory server path
• Created documentation for new setups and issues resolution

Environment: HRMS 8.9, People Tools 8.47.11, MS SQL Server 2003/2005, Oracle 10g, Windows 2000/2003.

Confidential

PeopleSoft System Administrator

Responsibilities:

• Involved in project management, Infrastructure setup and Upgrade.
• Setup and configured People Books for PeopleTools 8.45, CRM 8.9, FSCM 8.8 and also PeopleTools 8.47 and Application 8.8 SP1 on WebLogic Server. Configured context sensitive help and F1 help for the both the environments.
• Configured the UPK Player 8.0 on the People Books Web Server Successfully for European Financial Databases.
• Fine Tuned the Production Web/App/Batch servers for optimal Performance.
• Integrations with Service Manager via Web Services and Legacy Connector
• Responsible for gathering requirements, system design, and system development for Asset Manager and Connect.it Integrations.
• Integration with third party vendor for Advance Shipping Notice
• Integration with Oracle Payables for Supplier and Invoice Data
• Integration with Tibco Messaging System to HP OpenView
• Integration with Barcode Scanning solution AMI Asset Track for Inventory Audits, IMACs, and Receiving
• Install People Books for HRMS, Financials, EPM and CRM.
• Setup PeopleSoft DEMO database
• Installed Oracle 9i database on Red hat LINUX 4.0
• Installed TUXEDO 8.1, Web Sphere 5.1 and created server instances
• Installed People Tools 8.47, CRM 8.9 Application, and required patches
• Created and Configured Application Server Domain, Web Server Domain and Process Scheduler Domain
• Setup PeopleSoft Pure Internet Architecture
• Configured Report Nodes, Integration Broker and REN Server
• Configured Single Sign on between PeopleSoft Applications
• Installed PeopleSoft client for the Users and trouble shoot login issues
• Installed People Books and configure help in PeopleSoft applications
• Performance tuning for Application Server and Web Server
• Migrated PeopleSoft Objects and Data through Application Designer and Data Mover
• Applied Maintenance Pack, Bundles, Patches, and Fixes
• Performed Data migration from DB2 to Oracle 9i and resolved some issues while migration
• Corrected mismatch Data types in CRM, PORTAL databases
• Applied Patch People Tools 8.47.05 and Maintenance pack FSCM MP1
• Installed people books and configured Context search and Verity search
• Involved in database tuning, SQL Tuning, Analyzing Tables, Indexing.
• Involved in Tuning Application server and Web server
• Ran load cache program and distributed cache files
• Designed and implemented Migration procedures and policies for external and internal objects and for data
• Installed and configured BIG-IP load balancer for web server
• Updated databases by applying Updates/Fixes/Patches

Environment: Financials 8.9, HRMS 8.9, CRM 8.8, PORTAL 8.4, People Tools 8.46/8.47, Oracle 9.2.0.1/10g, DB2, AIX, Red hat LINUX 2.1/3.0/4.0, Windows 2000/2003, VMware ESX, BIG-IP Load balancer

Confidential, Denver, CO

PeopleSoft System Administrator

Responsibilities:

• Database performance monitoring and optimization
• Applied 9.2.0.7 Oracle patch to the database
• Involved in performance tuning like tables analyzing, SQL tuning, indexing.
• Performed Database backups using RMAN
• Migrated several Projects from Development Database into QA Testing Database and then into Production.
• Configured Application Server, Web Server & Process Scheduler Server.
• Involved in Tuning Application server and Web server.
• Setup Report Repository for all new PeopleSoft environments.
• Updated databases by applying Updates/Fixes/Patches after backup on timely basis and kept the record of the updates/fixes/Patches
• Provided support for development team in resolving issues, object migration and data migration.
• Deployed Web servers & configured PIA for multiple sites.
• Refreshing production database on to development and test environments

Environment: People Tools 8.46, CRM 8.9, Financials 8.9, Oracle 9.2.0.7, HP UNIX 11.11, Sun Solaris 5.8, AIX 5.3 and Windows 2000/NT.

Confidential, Cerritos, CA

PeopleSoft Admin

Responsibilities:

• Involved in the upgrade Process of HRMS/ FDM modules from 7.5 to 8.0/8.1
• Database Administration for Production, DEV, INT and Staging Environments
• Involved in increasing the performance for overall system with Database, application and server tuning
• Did analysis, trace and debug the process which are running slow and took necessary action to get good performance
• Create, Alter the table spaces and maintained the space for large volume of data
• Configuring different instances with different Application and Web Servers
• Involved in web server, Application Server configuration and set the parameters to get better performance in PSAPPSERV.CFG and configuraton.properties files
• Monitoring/ Tuning various PeopleSoft processes for Application Engine, SQR Reports, SQL Queries etc.,
• Creating table spaces, tables/index, views plans and packages
• Configured Oracle for PeopleSoft Application and configured client
• Executing PeopleSoft scripts and resolved the SQL Scripts
• Involved in Resolving space related issues, Resolving security and authorization issues, Data Migration, Applications support
• Involved in Writing DMS Scripts Across DMO and SYS Databases and wrote customized scripts for customized applications of HRMS and Financial modules
• Running PeopleSoft Delivered DMS Scripts for the implementation of PeopleSoft (Web, Database, App Server) and Solutions
• Made effective usage of Single Sign-on Capability for PeopleSoft Applications avoiding the user to login to the various applications of PeopleSoft again and Again
• Installation and administrating the BEA Tuxedo Application Server and Database Server
• Helped the user to Run payroll processes & Custom Processes and troubleshoot the payroll Error Message, if any.

Environment: PeopleSoft Applications 8.0/8.1 for FDM and HRMS, Oracle and AIX, People Tools 8.42/8.44, CRM 8.4/8.8,HRMS8.8, and FIN8.4SP2, Oracle and UNIX