SUMMARY:

• Over 7 years of experience in PeopleSoft & Database Administration.
• Expertise in Oracle SQL, PeopleSoft Administration & Oracle DBA Activities.
• Solid understanding of PeopleSoft technical architecture and tools with good experience in analysis, planning, development, and implementation stages of client Databases for PeopleSoft, worked closely with project teams to ensure database changes are coordinated with application requirements and handled all Database Administration functions very well. Based on my experience of working with several US and European clients, provides mentoring of best practices to application developers and clients.
• Key personal strengths are good Analytical Skills, Commitment, Ability to learn on the job and Flexibility.
• Excellent client interactions, on - site/offshore co-ordination and presentation skills.
• Involved In PeopleSoft upgrade - People Tools & PeopleSoft Application Upgrade.
• Reporting Tool Experience - Cognos TM1 Administration, Oracle OBIEE Admin and OFSAAI.
• ETL Tools like Pentaho.
• Oracle Certified Associate 10g in Database Administration.

TECHNICAL SKILLS:

Hardware: Pentium based PCs

Operating System: Windows95/98/2000/NT, Redhat: Linux, Oracle Enterprise Linux -4/5.

ERP Applications: PeopleSoft FSCM 8.4/8.8/9.1, HCM 8.8/8.9/9.1, EPM 8.8, CRM 8.9/9.1, Oracle OBIEE 11.1.1.5 / 11.1.1.7.

Databases & ERP Tools: Oracle: 9i/10g/11g, Oracle 11gR2 RAC Administration, People Tools Application Designers, People Tools 8.x Data Mover, PeopleSoft Change Assistant, OBIEE, OFSAA, IBM Cognos, Cognos TM1, Pentaho.

Web Servers: BEA Web logic 8.1, 10g, Oracle Web Logic Server 11g & Oracle Application Server 10g, Apache, Oracle Fusion Middle Ware 11g

EXPERIENCE SUMMARY:

Confidential, Lebanon, New Hampshire

Environment: Oracle Web Logic 11G, Oracle Secure Enterprise Search 11.2.0.0, Oracle database 11.2.0.1.0 , People Tools 8.52/8.53, Sitefinity

PeopleSoft Admin/PeopleSoft Database Administrator

Responsibilities:

• Built PeopleSoft Test Environments for Finance upgrades of PT 8.53.11 & FSCM/SCM 9.2
• Project migration/compare report/ Fit Gap Analyzing during Finance upgrade.
• End - to - end PeopleSoft Administration & supports end users/developers.
• Project Migration activity during Development & Production.
• Taking oracle hot/cold Backup & performing restore.
• Applying Tax updates on HR environments.
• Performing Environment refreshes & post refresh activities.
• Troubleshooting of various issues in day-to-day activities.
• Maintaining User Profiles, Roles and Permission List.
• Apply Tax updates and People Tools Patches using Change Assistant.
• Monitoring & Scheduling PeopleSoft jobs/payroll jobs.
• Work on daily PeopleSoft Activities, Running SQR and SQL.
• Troubleshooting of various issues in day-to-day activities.
• Oracle SES Secure Enterprise Search 11.2.0.0 Administration, Building SES environments/server configuration, Applying bundles/patches, building indexes/ identifying crawling issues.

Confidential, New York

Environment: Oracle Web Logic 10.3.1.0/11 G, Oracle Fusion Middle ware 11g, Oracle database 11.2.0.1.0 , STAT 5.6.4, Harvest 7.0, Cognos TM1 10.1.1 FP1, Oracle OBIEE 11.1.1.7, DB2/AIX64 9.7.7,People Tools 8.51,Data Stage as ETL

PeopleSoft Admin/ Admin/Cognos TM1 Admin

Responsibilities:

• Built Cognos TM1 10.1.1.1 FP1 Environments for DEMO, Test, QA, Prod Instances with Integrated SSO Login.
• End - to - end PeopleSoft Administration including 3rd party tools like Data Stage, Optim.
• Implemented Cognos TM1/Cognos BI Run Time with Microsoft Active Directory Integrated Login.
• Project Migration activity during Development and Testing Phase.
• Troubleshooting of various issues in day-to-day activities.
• Maintaining User Profiles, Roles and Permission List
• Apply Tax updates and People Tools Patches using Change Assistant.
• Flat file migration using Harvest tool.
• PeopleSoft package promotion using Qwest STAT from Dev to Prod.
• Monitoring & Scheduling PeopleSoft jobs/payroll jobs running on Mainframes/ESP Schedulers.
• Work on daily PeopleSoft Activities, Running SQR and SQL.
• Troubleshooting of various issues in day-to-day activities.
• Oracle OBIEE Administration - repository migration, Catalog Migration, User Creation, Service Recycle.
• Oracle OFSAAI Administration - User Creation/Authentication, Metadata dump Archive/Restore, Data Model Upload, Migration, Service Recycle

Confidential

Environment: People Tools 8.48/8.52/8.53 , HCM8.9/9.1/9.2, Web Logic 10.3.1.0/11 G, Oracle database 10.2.0.5.0 , STAT 5.6, Harvest 7.0, Cognos TM1 10.1.1, Oracle OBIEE 11.1.1.7

PeopleSoft Admin/DBA

Responsibilities:

• Built Demo/Development Environment for HR Upgrade Using People Tools 8.52/8.53 & HRMS 9.1/9.2.
• Project Migration activity during Development and Testing Phase.
• Troubleshooting of various issues in day-to-day activities.
• Maintaining User Profiles, Roles and Permission List
• Apply Tax updates and People Tools Patches using Change Assistant.
• Perform Database refreshes for Development, QA & UAT from Production exports.
• Flat file migration using Harvest tool.
• PeopleSoft package promotion using Qwest STAT from Dev to Prod.
• Monitoring & Scheduling PeopleSoft jobs/payroll jobs running on Mainframes/ESP Schedulers.
• Work on daily PeopleSoft Activities, Running SQR and SQL.
• Troubleshooting of various issues in day-to-day activities.
• Monitor Alert log, listener log, Mainframe Logs and other system events daily.
• Oracle OBIEE Administration - repository migration, OBIEE Application Administration.
• Implemented Cognos TM1/Cognos BI Run Time with Microsoft Active Directory Integrated Login.

Confidential, Ohio

Environment: PeopleTools 8.48, PeopleSoft FSCM 8.9, HCM 8.9 WebLogic 10.3.1.0

PeopleSoft Admin/DBA

Responsibilities:

• Setup, configuration, analysis and monitoring of production servers
• Working on PeopleSoft Daily activities.
• PeopleSoft Object Migration Using Qwest STAT.
• PeopleSoft Administration - Start/Stop PIA components, configuration of PIA components, Application messaging, Audit reports.
• COBOL linking & Compilation.
• Troubleshooting & handling customer cases to resolve PeopleSoft issues
• Support end users & developers.

Confidential

Environment: PeopleTools 8.50, PeopleSoft FSCM 9.1, HCM 9.1, Oracle 11g R2 RAC, RedHat-Linux 5.0WebLogic 10.3.1.0, Oracle Application server10g, Oracle Access Manager (OAM) & Web Gate 10.2.1.0

TECHNOLOGIES: PeopleTools 8.50, PeopleSoft FSCM 9.1, HCM 9.1, Oracle 11g R2 RAC, RedHat-Linux 5.0WebLogic 10.3.1.0, Oracle Application server10g, OAM & Web Gate 10.2.1.0

PeopleSoft Admin/DBA

Responsibilities:

• Involved in architecture design and proposed one best suited to the client’s requirement.
• Planning, Creation and Maintenance of PeopleSoft Demo, Development, Testing, Staging, Pre-Production & Production Instances.
• PeopleSoft System (Shell) database creation for FIN & HCM application.
• Monitoring access time, performing validation checks, and using other methods to monitor and analyze database performance.
• Performed Database Upgrade from Oracle 11.1.0.0 to Oracle 11.2.0.0.
• Involved in Real Architecture Cluster (Oracle RAC) implementation - Oracle 11g and Oracle 11g 4-Node RAC Implementation for HRMS - Prod/ProdSupp & 2-Node RAC Implementation for Finance - Prod/ProdSupp.
• Performed Oracle Cluster patching for RAC Instances.
• NON RAC to RAC conversion of Database.
• Implemented latest People Tools Patches, Weblogic Patches, Jrocket Patches, and Oracle Database patches/CPU Patches.
• Setup, configuration, analysis and monitoring of production servers.
• Application Server Load Balancing and Fail-Over Testing.
• Application Server and Batch Server Level Traces.
• RPS (Reverse Proxy Server) Implementation using Oracle Application server & coordinating with Network/BIGIP Team for network changes.
• Installed People Books & Configured Help.
• Installed oracle Identity Manger & Web Gate Installation on each of Middle Tier to configure SSO.
• Configured Report Node, Integration Broker, and Integration Gateways between different PeopleSoft Systems.
• Peoplesoft performance tuning to meet standard bottlenecks.
• Cobol Compilation & Resolving Micro Focus Cobol license Manager Issues.
• Coordinate with Helpdesk and Networks/BIGIP teams regarding production configuration changes.
• Provided overall Production and Implementation Support for PeopleSoft Application Integration and Solutions on RAC environment.
• Configuration of Change Assistant for PeopleSoft Maintenance.
• CEMLI Migrations using Qwest STAT & PeopleSoft Application Designer.
• Coordination with Refresh Team for applying Post Refresh Activities & resolving Issues after Instance Refresh.
• Involved in DBA activities and Shell Scripting.
• Coordination with Onshore Team & involved in Client meetings & SDM/Production manager for on call support for resolving issues.
• Extensively worked on Severity issues, to meet SLA agreement.
• Create and maintain system documentation, handoff & hardware sheet documentation.

Confidential

TECHNOLOGIES: Oracle 9i, Oracle 10g & 11g, Linux/ Oracle Enterprise Linux,People Tools 8.45/48/49/50 , PeopleSoft Portal 8.8, CRM 9, FSCM 8.8/8.9, HCM 8.9/9.0, Web Logic 8.1 SP5/10, Oracle Application Server 10g

Responsibilities:

• Involved in team of 50+ members spread across various Oracle offices.
• Worked as PeopleSoft Administrator and Oracle DBA for production environments.
• Implemented Maintenance Packs & Bundles, People Tools Patches, and Tax Updates, POCs, DST patches and Oracle database patches/CPU patches.
• Configuration of Change Assistant for PeopleSoft Maintenance.
• Import and Export Data through Data Mover.
• Migration of projects and external objects (images, customized web pages etc.) to various environments.
• Running audit reports & analyzes them.
• Project Migration, SQR Object Migration, AWR reports & Compare reports Analysis, Configuration of Node Definitions, COBOL Compilation in Linux environment.
• Troubleshooting & handling customer cases to resolve PeopleSoft issues.
• Database Administration - Start/Stop Database, Monitoring alert/trace log, Resolve Database issue, Database Patch Analysis/ Patch Execution & SQL Execution, Export/Import, Tablespace Management, AWR Reports etc.
• Application Patching - Patch Analysis, Application of patches, post patch review, People Tools Patching, Tuxedo/Weblogic Patching with latest Jrocket version.
• PeopleSoft Administration - Start/Stop PIA components, configuration of PIA components, Application messaging, Audit reports.
• Maintaining Database Security & PeopleSoft Security.
• Follow up with Global Product support for Product issues.