Resume

Sign in

PeopleSoft DBA / Administrator

Location:
Mechanicsburg, Pennsylvania, United States
Posted:
April 25, 2019

Contact this candidate

Resume:

Venu Yalavarthy

Sr. PeopleSoft DBA/Administrator/Upgrades/Infrastructure Consultant

SUMMARY:

More than 24 years overall experience in Information Services and 20 years working as Sr. PeopleSoft DBA/Administrator/Upgrade Specialist in the United States.

Expert in moving PeopleSoft Applications Inhouse to cloud like hostingAWS or migrating data to Workday or Other Cloud Application Solutions.

Proficiency in installation, configuration and Upgradation of PeopleSoft in Oracle 12c/11g/10g/9i, SQL Server 2012/2008/2005 on Windows & UNIX environments.

Excellent Administration skills in PeopleSoft, Oracle on Unix/Linux and Windows environments as well as SQL Server on Windows.

Had enough experience and proven understanding to be an Architect for PeopleSoft Applications.

Excellency in supporting Developers as well as for User community.

Proficiency in various modules such as PeopleSoft HR, Financials, Supply Chain, Portal, EPM & CRM and other PeopleSoft Applications.

Proficiency in setting up and maintaining Application Servers, PIA as well as integrating with other applications or third party products.

Experience in design, analysis, development, and implementation of Client/Server applications and Relational Databases.

Experience setting up PeopleSoft from the scratch to finish whether it’s an upgrade or new Implementation.

Experience in estimating, designing hardware for PeopleSoft new sites or upgrading sites based upon their requirements.

Experience in connecting PeopleSoft Databses to other DB Platforms like SQL Server, MySQL and other databases.

Experience in setting up PUM, Change Assistant and applying Patches/Fixes.

Experience in setting up PS Environments using both DPK & traditional methods.

Experience in setting up Reverse Proxy Web Servers for PeopleSoft and other applications / tools using Apache, Tomcat & IIS.

Experience in setting up SES & Elastic Search for PeopleSoft Applications and maintenance.

Experience in setting up OCM for Oracle Support Site.

Experience in Monitoring, resolving bottlenecks and Performance Tuning.

Experience integration PeopleSoft with OBIEE.

Good as a team player as well as self motivated.

Good communication and inter-personal skills.

Like to learn new subjects quickly and efficiently.

Flexible to work on different areas as well over times if required.

Excellency in supporting Critical Production systems 7/24.

Proven record of excellent support in minimizing downtimes with hard work and knowledge.

TECHNICAL

EXPERIENCE: Operating Systems: Win 2012/2008/2003/2000, Win 8.1/7/XP, Linux and UNIX (AIX, SOLARIS & HP)

Languages: SQR, SQL, PL/SQL, Shell, Batch Scripting

Databases: Oracle 12c/11g/10g/9i/8i, SQL SERVER 2012/2008/2005, DB2 UDB

Software: People Tools 7.5x - 8.56, Financials 7.5x – 9.2, HRMS 7.5x – 9.2, Portal 9.1, EPM 8.3 – 9.1, PeopleSoft Internet Architecture, PeopleSoft Change Asst/Upgrade Asst, PeopleSoft Update Manager, Crystal Reports, nVision, Oracle Tuxedo, Oracle Web Logic, Apache, MicroSoft IIS, Oracle Enterprise Manager, Quest FogLight, Quest Toad for Oracle, Embarcadero DBArtisan for Oracle database administration, MicroSoft Visual SourceSafe, ClearCase Attache, Quest Stat, Phire.

WORK

EXPERIENCE:

2/17 to Present HCL America.

Sr. PeopleSoft DBA / Administrator / Upgrade Specialist

Upgraded HCL Customer’s PeopleSoft FSCM application to 9.2 / 8.56 Tools.

Upgrading HCL Customer’s PeopleSoft HCM applications to 9.2 / 8.56 Tools.

Implemented Portal (IH) 9.1 / 8.56 Tools.

Designed and Built PeopleSoft Poral, HCM & FSCM 9.2 / 8.55 / 8.56 architectures on a Redhat Linux 7 and Oracle 12c Exadata platform for for Upgrades as well as Go-Live.

Setup PUM Images for both Upgrades as well as to push patches.

Setup Change Assistant for upgrade as well as to apply patch sets and tax updates.

Deployed latest PS Virtual Images to use them as Demo Environments for developers as well as to train user community.

Setup Elastic Search Servers, Performance Monitor.

Supporting Development, Functional, Security and Conversion teams for a smooth implementation towards successful Go-Live.

Prepared documentation for the existing team to create new environments, migrating code as well as Data.

Trained several teams in Upgrading, Maintenance as well as applying patches using latest methodologies like PUM, Change Assistant etc.

Worked with DBA for setup, Fine Tuning and refreshing PS databases on Exadata platform.

Environment: PeopleTools 8.54 to 8.55, FSCM 9.2 HCM 9.2, Oracle 11g-12c, SQL Server 2012, Redhat Linux, Win 2003 – 2012 64-bit, Tuxedo, Web Logic, Elastic Search, LDAP, ESP Scheduler, BI Publisher.

8/16 to 2/17 HighStreet IT Solutions, Long Island, NY.

Sr. PeopleSoft DBA / Administrator / Upgrade Specialist

Upgraded HSIT Customers PeopleSoft FSCM / HCM applications to 9.2 / 8.54 & 8.55 Tools.

Designed and Built PeopleSoft HCM & FSCM 9.2 / Tools 8.54 / 8.55 architecture on a Redhat Linux 6 and Oracle 12c platform for Go-Live.

Setup PUM Images for both Upgrades as well as to push patches.

Setup Change Assistant for upgrade as well as to apply patch sets and tax updates.

Deployed latest PS Virtual Images to use them as Demo Environments for developers as well as to train user community.

Setup SES & Elastic Search Servers, Performance Monitor.

Supporting Development, Functional, Security and Conversion teams for a smooth implementation towards successful Go-Live.

Worked on migrating insurance customer Peoplesoft HCM application to Workday.

Prepared documentation for the existing team to create new environments, migrating code as well as Data.

Trained several teams in Upgrading, Maintenance as well as applying patches using latest methodologies like PUM, Change Assistant etc.

Oracle DBA Support for creating databases, backups / restores and maintenance.

Environment: PeopleTools 8.54 to 8.55, FSCM 9.2 HCM 9.2, Oracle 11g-12c, SQL Server 2012, Redhat Linux, Win 2003 – 2012 64-bit, Tuxedo, Web Logic, Elastic Search, SES, OBIEE, .Net App connectivity, BI Publisher.

10/14 to 8/16 CIT Bank, Livingston, NJ.

Sr. PeopleSoft Administrator

Built PeopleSoft FSCM 9.2 / Tools 8.54 architecture on a Redhat Linux 6 and Oracle 12c platform.

Supporting FSCM 8.4 on Mainframe / DB2 to FSCM 9.2 on Linux / Oracle migration.

Supporting FSCM 9.2 new implementation and a platform migration to migrate data from 8.4 to 9.2.

Setup Change Assistant and apply bundles and tax updates.

Working closely with Back Office system groups regarding Servers and OS and DBA group.

Designing Production & DR architectures with appropriate fail over/Load Balancing options.

Setup PeopleSoft Virtual Image 9.2.011 to use as Demo as well as Patch management environments.

Setup PUM Image 9.2.017 to push patches.

Upgraded PeopleTools to 8.55.02.

Setup SES Search Servers, Performance Monitor.

Supporting Development, Functional, Security and Conversion teams for a smooth implementation towards successful Go-Live.

Prepared documentation for the existing team to create new environments, migrating code as well as Data.

Environment: PeopleTools 8.54 to 8.55, FSCM 9.2 – 8.4, Oracle 10g-12c, Redhat Linux 6, Win 2003 – 2012 64-bit, Tuxedo, Web Logic, BI Publisher, nVision.

1/13 to 9/14 UVS Technologies, Washington, D.C.

Sr. PeopleSoft DBA (Team Lead)

Supporting PeopleSoft HRMS, FIN, CS & Portal 9.1/9.0 applications.

Setup Change Assistant and apply bundles and tax updates.

Re-installed Prod & non-prod architectures and improved the availability.

Supporting Developers, Testers as well as End User communities.

Worked closely with Back Office systems group regarding Servers and Windows OS.

Installed and migrated PeopleSoft Upgrade applications to Oracle 12c from 11g.

Improved Production availability from 75% to 99% after introducing Change Management as well as fixing configurations and redesigning architecture.

Working on HCM / CS Split project, HCM Upgrade to Tools 8.53 / HCM 9.2 and FSCM 8.53 / FSCM 9.2 Upgrades.

Finished multiple Initial passes and MTPs of all applications and supporting Upgrade teams.

Designed and Built Production architectures with appropriate fail over/Load Balancing options.

Setup PeopleSoft Virtual Images to use as Demo as well as Patch management environments.

Setup EMHub and Change Assistant for upgrade purposes as well as to apply patches and also setup OCM for Oracle Support.

Setup Search Servers, Performance Monitors for Production environments.

7x24 support for PeopleSoft Applications & Oralce RDBMS databases.

Environment: PeopleTools 8.52 to 8.53, HRMS 9.0 – 9.2, FSCM 9.1 – 9.2, CS 9.0 Ent Portal 9.1 – 9.2, Oracle 11g-12c, Win 2003 – 2012 64-bit, SQL Server 2005 – 2008 64-bit, Web Logic, Tuxedo, Crystal Reports / BI Publisher, nVision.

6/08 to 10/12 FORT BEND ISD, Sugarland, TX.

Sr. PeopleSoft DBA

Supporting PeopleSoft HRMS, FIN, CRM & Portal 8.9 applications.

Setup Change Assistant and apply bundles and tax updates.

Re-engineered Production architectures with proper installation and setup of PeopleSoft on 64-bit clustered Database servers.

Worked as Lead DBA / Administrator and Managed the support team as well as the upgrade projects.

Re-installed Prod & non-prod architectures and improved the availability.

Supporting Developers, Testers as well as End User communities.

Worked closely with Back Office systems group regarding Servers and Windows OS.

Installed and migrated SQL Server 2005 for HCM Production to 64-bit Clustered Servers.

Total SQL Server support for all PeopleSoft applications

Setup Proxy WebLogic Server for Employees Self Service access over the Internet with SSL implementation.

Improved Production availability from 75% to 99%.

Setup, delivered & Maintaining Win 2008 64-bit/SQL 2008 64-bit clustered architectures for HCM, FSCM, CRM & Portal Applications Upgrade from 8.9 to 9.1 and PeopleTools from 8.47 to 8.50.

Finished multiple Initial passes and MTPs of all applications and supporting Upgrade teams.

Designed and Built Production architectures with appropriate fail over/Load Balancing options.

Setup EMHub and Change Assistant for upgrade purposes as well as to apply patches and also setup OCM for Oracle Support.

Performed full upgrade and Go-Live/Cut over for FSCM, HCM, CRM and Portal to 9.1/8.50.

Setup Search Servers, Performance Monitors for Production environments.

7x24 support for PeopleSoft Applications & SQL Server databases.

Environment: PeopleTools 8.47 to 8.50, HRMS 8.9 – 9.1, FSCM 8.9 – 9.1, CRM 8.9 – 9.1 Ent Portal 8.9 – 9.1, Win 2003 – 2008 64-bit, SQL Server 2005 – 2008 64-bit, Web Logic, Tuxedo, Crystal Reports, nVision.

12/07 to 6/08 SYNCH SOLUTIONS, Chicago, IL.

PeopleSoft DBA

Supporting HRMS 8.9 TAM implementation.

Applied Bundles & Tax Updates using Change Assistant.

Configured non-prod architecture and worked with Networking group to setup integration for Vendors like HireRight, Resume Mirror using Integration Broker in production.

Supporting Developers, Testers as well as End User communities.

Working with different groups/companies for Production readiness and cutover tasks for Go-live.

DB monitoring and recommended solutions to resolve performance or User related issues.

And also all other PeopleSoft Admin work on daily basis.

Migrations, Change management using VSS.

Environment: PeopleTools 8.48.x, HRMS 8.9, Oracle 9i, Solaris 10, Win 2003, Web Logic 8.1, Tuxedo 8.1, VSS,

8/06 to 10/07 APEX SYSTEMS, INC., Richmond, VA.

PeopleSoft DBA

Reengineered the entire HRMS architecture on brand new servers.

Lead the Infrastructure team and the Managed the project from infrastructure and support side.

Upgraded tools from 8.19.x to 8.22.x.

Stabilized and improved existing architectures at all levels.

Reinstalled and Configured PeopleSoft FSCM and HR applications.

Supported Customer throughout the BMQA (Bill me quickly) project implementation.

7x24 support for PeopleSoft Applications, SQL Server databases.

Rolled out HRMS & FSCM 9.0 demo applications with Tools 8.49 for User training purposes.

Supported End Users as well as Developers.

Advised customer on different fronts to keep applications up and available at all times except maintenance windows.

Research, analyze and work with PeopleSoft to apply required patches.

Worked closely with Back Office systems group regarding Servers and Windows OS.

Analyzed and applied all patches for PeopleSoft third party products to DB monitoring and recommended solutions to resolve performance or User related issues.

And also all other PeopleSoft Admin work on daily basis.

Environment: SQL Server 2000/2005 32/64-bit, PeopleTools 8.1.x – 8.48, HRMS 8.3 to 8.9, Win 2000/2003, Web Logic 5.1 - 8.1, Tuxedo 6.5 - 8.1

10/05 to 8/06 OCEANEERING INTERNATIONAL, Houston, TX.

PeopleSoft DBA

Installed and Configured Quest Foglight, User Experience Monitor for all PeopleSoft applications as well as for the entire architecture.

7x24 support for PeopleSoft Applications, DB2 UDB databases.

Supported End Users across the globe as well as Developers.

Setup and Maintaining Performance Monitor for both HRMS and Fin applications.

Research, analyze and work with IBM, PeopleSoft to apply required patches.

DB monitoring and recommended solutions to resolve performance or User related issues.

Other day-to-day administration/dba tasks.

Environment: Linux, DB2 UDB 8.2, PeopleTools 8.44.x – 8.47, HRMS 8.8, Win 2000/2003, Web Logic 8.1, Tuxedo 8.1, Quest FogLight 4.2.

3/05 to 8/05 NORWOOD PROMOTIONAL PRODUCTS, Indianapolis, IN.

PeopleSoft DBA

Supported CRM, Portal, Financials and EPM production 8.8 environments hosted at IBM (formerly Corio).

Coordinated and acted as a point of contact for all PeopleSoft related activities for Norwood with hosting company.

Supported End Users as well as Developers.

Setup and Maintained Performance Monitor.

Setup Parallel Development environments for CRM and Financials for ODP implementation at a different host company iStructure.

Supported and Worked as Manager for support team as well as upgrade teams for upgrade projects Tools from 8.44.02 to 8.46 and FSCM 8.8 to 8.8 SP1MP1BNDL4.

Worked as onsite manager and coordinated work between onsite and offshore teams from Development and Functional areas of Upgrade projects.

Research, analyze and work with IBM to apply required patches.

Set up Batch jobs monitoring and EIP monitoring.

Installed and maintaining CRM Configurator server.

DB monitoring and recommended solutions to resolve performance or User related issues.

Other day-to-day administration tasks.

Environment: Solaris 8, Oracle 9i, PeopleTools 8.44.x – 8.46, Portal 8.8, FSCM 8.8, EPM 8.8, CRM 8.8, PeopleSoft upgrade assistant, Win 2000/2003, Web Logic 8.1, Tuxedo 8.1.

12/04 to 3/05 IBM BLUE DIRECT (Business Consulting Services), Dallas, TX.

PeopleSoft DBA

Worked as a PeopleSoft DBA for General Motors HCM 8.8 SP1 upgrade project as well as Stat Administrator for Quest Stat implementation for PeopleSoft HR application.

Supporting Developers and deployment teams as well as user community on Pre-Production environments.

Performed PeopleSoft Production environments setup for Go-Live for Both OLTP & Reporting on Oracle 9i/HP-Unix platforms/Windows 2003/Citrix Metaframe.

Built custom tables and tablespaces as required and as per the design guidelines.

Refreshed several PeopleSoft development and test databases with Pre-Production data.

Responsible for setting up and maintaining App servers, Web Servers, Databases and Process Schedulers for Go-Live for OLTP & Reporting instances.

Responsible for PeopleSoft Security setup as per the implementation team guidelines and migrating to other environments as per the cutover plan.

Supporting conversion teams for data conversion from 7.5 applications to 8.8 applications.

Performing migrations of all changes between pre-prod environments as well as Go-Live migrations to Prod as part of Cut-Over plan.

Upgraded PeopleTools from 8.44.05 to 8.44.16 on all Pre-Prod and Prod environments.

Quest Stat Administration.

Other day-to-day PeopleSoft DBA tasks including database exports, database monitoring, analyzing statistics and other maintenance tasks for both Oracle and PeopleSoft components and others.

Supporting different teams 7x24.

Worked with other groups like UNIX/NT administrators during maintenance schedules and to minimize downtimes.

Environment: HP-Unix, Oracle 9i, PeopleTools 8.44.x, PeopleSoft HRMS 8.8 SP1, PeopleSoft upgrade assistant, Citrix, Win 2000/2003, Web Logic 8.1, Tuxedo 8.1, Quest Stat, BMC Petrol and Oracle Ent. Manager.

8/04 to 12/04 BANKONE/CHASE CORPORATION, Columbus, OH.

PeopleSoft DBA

Worked as PeopleSoft Administrator for JP Morgan Chase/BankOne merger environments as well as for BankOne production application environments.

Supported Developers on application merger project as well as user community on production for all bank one branches across United States.

Performed PeopleSoft environments setup for merger integration project on Oracle 9i/HP-Unix platforms.

Refreshed several PeopleSoft development and test databases with Production data.

Performed installation and maintaining Application Servers, Process schedulers and web servers for all new merger applications as well as maintaining current production components.

Applied Time & Labor custom bundles delivered by PeopleSoft on merger environments, as this is the first time implementing T&L.

Upgraded PeopleTools from 8.19 (JP Morgan Chase) and 8.20.01 (BankOne) to 8.21 (common platform for merger integration project).

Performed migrations between PeopleSoft environments and to production after testing thoroughly with users in User Acceptance Testing using Kintana.

Coordinated with different teams like Security, LDAP, Novell and Systems Admin groups for seamless applications maintenance and to minimize downtimes.

Other day-to-day PeopleSoft administration tasks.

Environment: HP-Unix, Sun Solaris, Oracle 9i, PeopleTools 8.2x, PeopleSoft HRMS 8.3, PeopleSoft upgrade assistant, Citrix, Win 2000/2003, Web Logic 8.1, Tuxedo 6.5, Mercury Kintana, Oracle Ent. Manager.

6/04 to 7/04 CORIO, INC., Phoenix, AZ.

PeopleSoft DBA

Worked as PeopleSoft Administrator to Corio Customers (Corio is an application hosting company).

Supported Customers Go-Live projects for Financials, CRM, EPM, Portal environments.

Performed PeopleSoft environments setup on Oracle 9i/Solaris platforms.

Refreshed several PeopleSoft development and test databases with Production data.

Performed installation and maintaining Application Servers, Process schedulers and web servers for the above applications.

Installed and resolved problems with Troy Printer for online secured check printing.

Performed several cold backups of databases as well as running statistics for performance improvement.

Setup PeopleCode debugger.

Applied Patches and fixes.

Upgraded PeopleTools from 8.44.02 to 8.44.09.

Took care of customers 7x24 and a smooth transition to production.

Supported different modules in above applications.

Performed migrations between PeopleSoft environments and to production after testing thoroughly with users in User Acceptance Testing.

Installed and maintained CRM Configurator server.

Application, Database and OS level security for PeopleSoft.

Installed Component Interface (Control-M).

Integrated applications using Application Messaging and Integration Broker.

Other day-to-day administration tasks.

Environment: Solaris, Oracle 9i, PeopleTools 8.44.x, Portal 8.8, FSCM 8.8, EPM 8.8, CRM 8.8, PeopleSoft upgrade assistant, Informatica PowerMart 6.1, Win 2000/2003, Web Logic 8.1, Tuxedo 8.1.

2/04 to 5/04 FREDDIE MAC, McLean, VA.

PeopleSoft Administrator

Installed and Administering Quest Stat 4.1.7.

Supporting Quest Stat implementation for PeopleSoft Applications change management.

Worked as part of Enterprise Change Management and PeopleSoft Environment groups.

Installed Quest Stat 4.1.7 development and Production environments on SQL server 2000 and configured for PeopleSoft change management.

Setting up and maintaining PeopleSoft Staging Environments for Quest Stat as well as Quest Stat Development, Test and Production environments along with associated PeopleSoft environments for Dev & Test.

Gathering requirements from different PeopleSoft business owners, developers and Configuring Quest Stat Service Domains for all PeopleSoft Production Environments.

Creating, configuring and testing thoroughly Stat Workflows for each Stat Service Domain (PS Production Environment).

Integrated successfully three out PeopleSoft production environments with Quest Stat so far and working on three more.

PeopleSoft and Quest Stat security including interfacing between LDAP and Quest Stat.

Performed and participated in a full cycle Quest Stat Implementation for PeopleSoft change management.

Identifying and resolving Quest Stat Production Issues.

Upgraded Quest Stat 4.1.7 to 4.1.8 on SQL Server 2000.

Responsible for taking Quest Stat Live for seven PeopleSoft Production environments on time and within the budget.

Responsible for gathering all the requirements to Integrate Quest Stat for all PeopleSoft Production Environments.

Successfully implemented first service domain AR Billing Live within 45 days of Stat Installation.

Administering PeopleSoft applications on Oracle 9i and DB2 UDB.

Environment: AIX, Oracle 9i/8.1.7.x, DB2 UDB 8.1/7.2, SQL Server 2000, PeopleTools 8.18.x – 8.4.x, HRMS 8.3, Portal 8.4, FSCM 8.4, EPM, PeopleSoft upgrade assistant, Win 2000, Web Logic 5.1 sp10/6.1 sp2 WebServers, Quest STAT 4.17/4.1.8, Rational ClearCase, Rational ClearQuest.

6/03 to 1/04 CITI GROUP, New York, NY.

PeopleSoft Administrator

Supported and maintained 24x7 critical worldwide multi lingual applications of PeopleSoft HRMS 8.x, Portal 8.42, FSCM 8.42, EPM 8.3/8.8.

Team Lead for FSCM (sPro) Applications and primary for architecture re-engineering teams.

Supported Development, Test, and Production environments of worldwide applications.

Integrated sPro application with iPlanet/Siteminder policy servers using LDAP directory server.

Prepared project plan and upgraded FSCM (sPro) application from 8.4 to 8.4SP1 and PeopleTools 8.42 to 8.42.10.

Integrated sPro application with PeopleSoft Portal along with single sign-on.

Configured gateways, Nodes using Integration Broker, tested application messaging, and synchronized users successfully for single sign-on.

PeopleSoft Project Migrations between instances using Quest STAT.

PeopleSoft Security and Single Sign-on using LDAP and integrated with PeopleSoft Portal.

Setting up and maintained Application Servers, Process Schedulers, Web Servers, and Reporting Servers.

Rebuilt PeopleSoft DEV, TST, UAT & PRD environments including PIA from scratch as per client/PeopleSoft standards (re-engineering).

Supported Supply Chain Management application as a Lead including Billing, Inventory, Order Management and other modules.

Applied Patches and Fixes including Multi Lingual Patches.

Environment: Sun Solaris, Oracle 9i/8.1.7.x, PeopleTools 8.18.x – 8.42.10, HRMS 8.3, Portal 8.4, FSCM 8.4, EPM 8.3/8.8, PeopleSoft upgrade assistant, Win 2000, Web Logic 5.1 sp10/6.1 sp2 WebServers, Netscape iPlanet, Quest STAT, Netegrity Siteminder.

4/03 to 6/03 AMERICAN RED CROSS, Washington, D.C.

PeopleSoft Administrator

Supported critical implementation PeopleSoft HRMS 8.x and Portal Production (ESS).

Supported Development, Test, and Production environments.

Creating, Cloning and maintaining Oracle Databases for PeopleSoft Development, Test and User Acceptance environments for HRMS and Portal Production.

PeopleSoft Project Migrations between instances.

PeopleSoft Security.

Setting up and maintaining Application Servers, Process Schedulers, Web Servers, and Reporting Servers on AIX.

Worked on Building PeopleSoft Production environment including PIA from scratch.

Modules supporting HR, Payroll, Benefits Admin, Base Benefits and Portal.

Applied Patches and Fixes.

Environment: AIX 4.3, Oracle 9i/8.1.7, PeopleTools 8.18.x, HRMS 8.0 sp1, Portal 8.x, Win 2000, Web Logic WebServers, TOAD for Oracle DB Administration and Oracle OEM for Oracle, Rational Clearcase Attache.

8/02 to 4/03 HARVARD UNIVERSITY, Cambridge, MA.

PeopleSoft DBA

Worked as part of DBA group.

Supported critical implementation, Live, and Post Live phases of PeopleSoft HRMS 8.x.

Supported Development teams 24x7.

Supported Development, Test, and Production environments.

Created, Cloned and maintained Oracle Databases for PeopleSoft Development, Test and Production environments.

PeopleSoft Project Migrations between instances.

PeopleSoft Security.

Setting up and maintaining Application Servers, Process Schedulers, Web Servers, and Reporting Servers on Sun Solaris.

Built PeopleSoft Production environment from scratch including 12 Web Servers & 4 Application Servers with Load Balancing.

Built and maintaining PeopleSoft Internet Architecture with load balancing.

Performed Volume Stress Testing using WinRunner, LoadRunner.

Performance Tuning.

Modules supporting HR, Payroll, Benefits Admin, Base Benefits, Time & Labor and Portal.

Applied Patches and Fixes.

Environment: Sun Solaris, Oracle 8.1.6, SQL SERVER 2000, PeopleTools 8.17.x, HRMS 8.0 sp1, PeopleSoft EPM 8.x, Win 2000, Apache & WebLogic WebServers, LoadRunner, WinRunner, DBArtisian for Oracle DB Administration, TOAD for Oracle DB Administration and Oracle OEM for Oracle.

9/00 to 8/02 LAHEY CLINIC, Burlington, MA.

PeopleSoft Administrator

Supported critical production as well as development and testing environments.

Supported Development team (size: 15).

Supported User community (size: 100s).

Worked on PeopleSoft 8.xx upgrade from HR 7.51 to HR 8.3, FDM 7.52 to FDM 8.4 & EPM 8.3 and Data Warehousing.

Installed and Administered HighJump product Par Inventory (Inventory tracking with handhelds) and integrated with PeopleSoft FDM 8.4 to streamline and automate Inventory at Lahey Clinic hospital supplies.

Setup and Maintained exclusive Windows server for HighJump product including Security at PeopleSoft Database level.

Creating and Maintaining Oracle Databases for PeopleSoft 7.5x/8.x.

Cloning & Refreshing environments for PeopleSoft/Oracle.

Monitored Oracle and PeopleSoft environments.

PeopleSoft Security.

Setting up and maintaining Application Servers, Process Schedulers, Web Servers, and Reporting Servers.

Coordinating with other departments like Network support, systems support, super users and managers.

Responsible in PeopleSoft Internet Architecture setup and maintenance.

Supporting and maintaining critical production systems with minimum downtime.

Modules supported HR, PAYROLL, BENEFITS, GL, AP, AR, PO, MM, Inventory, Budgets, Projects & Fixed Assets and others including Self Service.

Applying Patches and Fixes including Tax Upgrades on regular basis.

Environment: Aix 4.3, Oracle 8.1.6/9i, PeopleTools7.59, 8.17& 8.41, HRMS7.51 & 8.3, FDM7.52 & 8.4, EPM 8.3, NT4.0 SP6, AutoSys Scheduler, Win 2000, Weblogic, IBM WebSphere, IBM HTTP Server, Mercur & Gentran, HighJump products.

3/98 to 9/00 ARTHUR D. LITTLE, INC. Cambridge, MA.

PeopleSoft DBA

Worked with PeopleSoft Group (PSG) Consultants.

On line support for Development/Testing teams (size: 90).

Created and configured Databases for PeopleSoft Applications both Financials and HR.

Installed and Configured PeopleSoft Applications with Oracle RDBMS environment.

Customized and created shell scripts as per the requirements of the team and to perform DBA responsibilities as well as PeopleSoft administration.

Patches and Fixes.

Creating and configuring Process Schedulers for databases.

Extensive operational skills on UNIX and NT environment.

Solid knowledge in PeopleSoft both sides Development and Administration.

Updated skills for PeopleSoft 7.5x release.

Upgraded PeopleTools from 7.51, 7.52, 7.54, 7.54.1, 7.55, 7.56 & 7.58.

Upgraded Application Releases 7.50 to 7.51 (HR) and 7.50 to 7.51 to 7.52 (Financials).

Worked for a Global project for the team size 50 in US and across the globe size 90.

Extensively used and done Data Mover, PeopleTools and Security Administration.

Trained couple of Junior level employees to become experts.

Worked on Multi Language application development project as well as upgrades.

Supported developers in USA, UK, Swiss, and Germany etc.

Environment: IBM AIX 4.2, Windows NT/2000, Oracle 7.3/8i, SQL Server 7.0, PeopleTools 7.5x, PeopleSoft HRMS 7.51, PeopleSoft Financials 7.52, AutoSys.

EDUCATION

OSMANIA UNIVERSITY, Bachelor of Engineering [Major in Computer Science]

TRAINING

CTREC Hilton

SQL Server 2008 DBA

Windows 2008 Administration

PeopleSoft Training (Learning Tree International)

PeopleTools I, PeopleTools II, Configuration & Administration, Data Management Tools

Learning Tree International

Oracle 8x DBA

Quest Software

Quest Stat Administration

Software Solutions Integrated, Ltd.

Diploma in Oracle RDBMS

Ram Informatics, Ltd.

Diploma in Oracle DBA and Designer 2000



Contact this candidate