SUMMARY:

• Murthy Kanchanapelly, self - motivated, result oriented, dedicated People soft Administrator and DBA having over 16 years of strong and diverse international Experience in the IT industry
• Extensive experience as a People soft system Administrator/ DBA.
• Actively Led Implementations, Cross-Platform Migrations, Upgrades, Production Support on People soft versions 7.x & 8.x, MS SQL Server versions 6.5,7.x, 2000,2005,2008,2012, Oracle 11g in a two-tier and n-tier Logical/Physical Architectures. Has been Key Resource for companies and Met Deadlines consistently. Possess excellent Communication / Documentation skills and strong aptitude to analyze/resolve problems
• Excellent work experience in installation of People soft Applications.
• Worked PeopleTools 7.5/8.43/8.44/8.45/8.48/8.49/ 8.51/8.53/8.54 /8.55 and 9.1/9.2 Application Versions.
• Experience with Dell Quest STAT Migration Tool.
• Has excellent communication and presentation skills and Good Team Player.
• Experience with People soft Integration Broker, Process Scheduler, Upgrade Assistant and Change Assistant, PUM.
• Extensive experience with people soft Internet Architecture and Web logic and Tuxedo Application server.
• Installed PUM Image 18 for HCM and PUM Image 19 for FSCM and has the experience with Virtual Box and Native Image installations.
• Specialized in designing and implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Extensive knowledge of Relational Database Management Systems.
• Creating Database users, security and database permissions, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Experience in MS SQL Server installation, configuration, back-up/recovery, running Database Consistency Checks using DBCC.
• Applied Regs, Fixes for Financial Aid, Student Administration and Campus solutions.
• Experience in Supporting Huge Databases, Troubleshooting the problems.
• Automating the Database Maintenance tasks by creating Jobs and Alerts.

TECHNICAL SKILLS:

Databases: MS SQL Server 2000 and 2005,2008,2012 Oracle8i/9i/10g/11g

People tools: Configuration Manager, Application Designer, Data Mover, Import Manager, App Engine, Security, Process Scheduler, Process Monitor, Application Messaging Monitor, Upgrade / Change Assistant, PS/Query, Integration Broker, Ren Server, SMTP, Workflow

Hardware: PC s, UNIX Platforms (SUN, HP, IBM 9000 series)OS: Single user - DOS, Multi-user- Unix (SCO 5.0, AT & Unix, HP-UX,Solaris 2.5, AIX,Linux), Network OS-Novell Netware 4.11, WinNT 3.51, 4.0, Windows 2000,Desktop - Win 95/98/2000prof/XPPro

DBA Tools: MS SQL Server (SQL Enterprise Manager, Query Analyzer, SQL Profiler, DTS, Perfmon etc), Lite Speed and Foglight monitoring Tool.

Middleware: BEA Tuxedo Application Server

WebServers: BEA Weblogic

Version Control: PVCS Version Manager 5.3, PVCS Tracker 5.3

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA.

Senior People soft system Administrator/DBA

Environment: People soft HRMS/Financials/Interaction Hub 9.1/9.2, People Tools 8.53, 8.55,Sql Server 2012,Windows 2008.

• Day-to-day operation of databases and applications environments (production, Test, QA and development)
• Provide technical expertise to identify, troubleshoot, and resolve production support issues for the web, application server.
• Providing support for customer issues through the use of our web-based ticketing system.
• Implemented SSL and LDAP and renewed SSL Certificates.
• Involved in Upgrading People soft HR Tools and Application Upgrade.
• Responsible for migrating People soft Projects, sqr and cobols
• Applying Tax Updates, Bundles, Maintenance Packs using change Assistant and PUM.
• Setting up Application messaging and troubleshooting the messaging issues.
• Creating new People soft environments as required
• Configured People soft SES on HRMS 9.2 Application.

Confidential,Atlanta, GA

Senior People soft system Administrator

Environment: PeoplesoftHRMS/Financials9.1,9.2,PeopleTools 8.51/8.53/8.54, Oracle 11g,Solaris 10,Windows 2003/2008.

• Day-to-day operation of databases and applications environments (production, Test, QA and development)
• Provide technical expertise to identify, troubleshoot, and resolve production support issues for the web, application server.
• Providing support for customer issues through the use of our web-based ticketing system.
• Implemented SSL and LDAP and renewed SSL Certificates.
• Configured Application messaging and XML Publisher
• Responsible for migrating People soft Projects, sqr and cobols
• Applying Tax Updates, Bundles, Maintenance Packs using change Assistant.
• Setting up Application messaging and troubleshooting the messaging issues.
• Creating new People soft environments.

Confidential, Tempe, AZ

Lead People soft System Administrator/DBA(Database Management)

Environment: SQL Server 2012/2008/2005/2000, Peoplesoft HRMS 9.1,PeopleTools 8.51/8.53/8.54, Oracle 11g,AIX,Windows 2003/2008.

• Day-to-day operation of databases and applications environments (production, Test, QA and development)
• Provide technical expertise to identify, troubleshoot, and resolve production support issues for the web, application, and database servers.
• Providing support for customer issues through the use of our web-based ticketing system
• Implemented SSL and LDAP and renewed SSL Certificates.
• Configured Application messaging and XML Publisher
• Performing database refreshes from production as requested
• Ensuring recoverability by implementing, monitoring, and maintaining database backups
• Tuning and Optimizing Data Access.
• Advise management on applications implementations, upgrades and general maintenance
• Responsible for migrating People soft Projects, sqr and cobols
• Applying Tax Updates, Bundles, Maintenance Packs using change Assistant.
• Setting up Application messaging and troubleshooting the messaging issues.
• Creating new People soft environments.
• Performing database backups and refreshing databases.
• Responsible for managing the team and involved in sizing the disk space.

Confidential,AZ

People soft system Admin/DBA

Environment: People Soft 8.8 HRMS Portal, EPM, People Tools 8.42/8.46.06, Application Engine, People code, Application Messaging, SQR, SQL Server 2000 and 2005 and Windows NT/2000/2003, ETL, Tuxedo Application Server, Web logic8.1/5.1,Foglight Monitoring Tool

• Day-to-day operation of databases and applications environments (production, Test, QA and development)
• Provide technical expertise to identify, troubleshoot, and resolve production support issues for the web, application, and database servers.
• Providing support for customer issues through the use of our web-based ticketing system
• Performing database refreshes from production as requested
• Ensuring recoverability by implementing, monitoring, and maintaining database backups
• Created and implemented Disaster Recovery Plans.
• Ensure efficiency of batch and online database operations through ongoing system monitoring and tuning. Provide senior technical expertise to mentor other staff members in tuning SQL statements.
• Supports the HR development team as necessary to implement customer service requests and resolve incident tickets

Confidential,AZ

Lead People soft System Administrator / DBA

Environment: People Soft 8.8/8.9 Financials, Portal, CRM People Tools 8.42/8.46.06 /8.48.09,Application Engine, People code, Integration Broker, Application Messaging, Change Assistant, SQR, SQL Server 2000 and Windows NT/2000/2003, Lite speed, Foglight Monitoring Tool, Tuxedo Application Server, Web logic8.1/5.1,Unix,Oracle9i,STAT,

• Responsible for performing day to day activities like Monitoring app server, Web server and People soft Database.
• Responsible for Refreshing and Restoring Databases.
• Responsible for scheduling the Batch Jobs in Sql server
• Designed database structures, Constraints, Stored Procedures on SQL Server 2000
• Responsible for Optimization of Databases
• Gathered requirements from end users and proposed business solution for the application
• Trouble shoot and Resolved Crystal Check Printing and People soft Printing.
• Responsible for Setting up the Load Balancing and Failover for Multiple Application Server Domains.
• Involved in the migration of Objects from Dev to test, test to Production using Qwest stat Change Management Tool
• Upgraded STAT from 5.2.0 to 5.3.2.
• Responsible for Applying patches and fixes and Maintenance Packs.
• Involved in upgrading CRM & Portal from 8.8sp1 to 8.9.

Confidential

People soft system admin/DBA

Environment: People Soft 8.8/8.0 Student Admin, Portal, CRM People Tools 8.20/8.45,Application Engine, People code, Integration Broker, Change Assistant, Application Messaging, SQR, SQL Server 2000 and Windows NT/2000, Tuxedo Application Server, Web logic8.1/5.1,Linux

• Installed/Configured /Administered/Trouble Shooted BEA/Tuxedo NT Application servers which also includes setting up Connectivity from Application servers to MS SQL Server.
• Responsible for Refreshing and Restoring Databases using SQL Servers.
• Applied Regs, Bundles and Fixes for Financial Aid,Student Administration and Campus solutions.
• Capacity planning in estimating and sizing of tables
• Backup and Recovery of production databases and tuning production databases for better performance.
• Managing security tasks like granting and revoking permissions
• Setup Report Distribution in People soft environment using Report Repository.
• Responsible for Application server performance Tuning.
• Setup People books with Context sensitive help.
• Troubleshoot all the pieces of People soft which include Web server, Application Server, Process scheduler and Database Server.

Confidential, Boise, ID

People soft System Admin

Environment: People Soft8.8 HRMS(HR, Pay Roll, Benefits, Self Service,),PORTAL,CRM People Tools 8.44/8.45,Change Assistant, Upgrade assistant, Oracle 9i and AIX 5.2,Linux webservers,Windows, Tuxedo Application Server 8.1, Web logic 8.1, Vista Plus, ESP, Citrix

• Wrote shell scripts to automate Application, Web and Batch servers startup.
• Setup Application messaging between HR and CRM .
• Involved in the migration of Objects from One environment to another using Change management tool(Bug zilla Tool) .
• Involved in Applying patches and fixes using Change Assistant and Tax updates.
• Responsible for Application server performance Tuning.
• Responsible for Automated Unix shell scripts.
• Responsible for Running and Reviewing Audit Reports.
• Involved in Upgrading Tools from 8.44 to 8.45.18
• Configured Change Assistant for applying Patches
• Responsible for installing and configuring Change Assistant and Upgrade assistant.

Confidential

People soft System Admin/DBA

Environment: People Soft 8.3/8.8 HRMS(HR, Pay Roll, Time and Labor,), Portal, People Tools 8.44,Application Engine, People code, Application Messaging, SQR, Oracle9i and Sun Solaris, Tuxedo Application Server, Web logic8.1

• Responsible for performing day to day activities like Monitoring app server, Web server and People soft Database.
• Responsible for providing the Security using Security Administrator Tool and solving security related issues like users not able see the pages, user account got locked etc.
• Responsible for taking the Backup of Database.
• Involved in the migration of Objects from Dev to test, test to Production.
• Responsible for Running and Reviewing Audit Reports.
• Involved in Applying patches and fixes.
• Responsible for installing and configuring Upgrade assistant.
• Involved in Upgrading People soft from 8.0 to 8.3

Confidential,san Francisco, CA

People soft Admin / Security Administrator/DBA

Environment: People Soft 8.3 HRMS(HR, Pay Roll, Time and Labor,),Financials, People Tools 8.20,Application Engine, People code, Application Messaging, SQR, SQL Server and WINDOWS, Tuxedo Application Server 6.5,Weblogic

• Responsible for the production of support of AMAT Applications.
• Refreshing and restoring the Databases.
• Responsible for post refresh activities after Database Refresh.
• Responsible for configuring the People soft servers.
• Responsible for migrating the objects.
• Involved in Applying patches and fixes.
• Handled the People soft issues like unable to run the reports, pages are not being displayed, cache problems etc….

Confidential, NY

People soft Admin/Security Administrator

Environment: People Soft 8.x HRMS(HR, Pay Roll, Time and Labor, Benefits and Admin, Base Benefits), People Tools 8.13,Application Engine, People code, Application Messaging, SQR, SQL Server and Windows NT/2000,Tuxedo Application Server 6.5,Weblogic.

• Involved in handling the requests from Developers and users.
• Responsible for creation of permission lists, users and Roles
• Involved in migration of objects.
• Setting up the Report distribution nodes.
• Responsible for creation Process scheduler domains and Application server domains.