SUMMARY:

• Over 8 + years of experience in Planning, Designing, implementing, sizing, architecting, maintaining and supporting PeopleSoft Systems in complex environments with extensive experience in Multi - Step/Multi- Lingual application Upgrades along with Microsoft Sql and Oracle DB base and 2 + years of experience in AWS cloud on various areas such as EC2, RDS, S3, EBS, Lambda, Elastic load balancer and Virtual private cloud applications with Strong aptitude, Innovative, self-motivated and result oriented Professional.
• Upgrade Specialist with extensive experience in Multi-step and Multi lingual Upgrades across PeopleSoft application and Tools upgrades.
• Hands-on in Building servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.
• Involved in the migration and implementation of multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53 Glacier, EC2, RDS, SQS, SNS and Lambda.
• Wide experience in PUM, DPK, PRP, patches, Tax Updates, bundles and maintenance packs across PeopleSoft Applications and Tools Patches.
• Worked in complete end to end Oracle DBA Support right from Planning, Implementation and Ongoing DBA support
• Oracle Database Installation, Patching, Upgrades & Refreshes
• Hands-on on proactive monitoring through Enterprise Tools, troubleshooting and Performance Tuning
• Expertise in PeopleSoft Architecture and solution Consultant on Infrastructure Design, System Sizing, Capacity Planning to assure a sound system and network infrastructure satisfying business requirement of the customers.
• PeopleSoft Administrator with widespread experience in support and maintenance of PeopleSoft systems in a variety of platforms/operating systems
• Specialized in cut-over window optimization for PeopleSoft Application Upgrades and Optimize upgrade process flow to suit customer requirements.
• In-depth experience in analysis, planning, load testing and performance tuning.
• Maintained PeopleSoft Security like Creating roles, Dynamic roles, Profiles, Users and managing permissions, Active Directory and Single Sign on.
• Proficiency in Security Architect and Solution Design Architecture.
• Comprehensive Experience in Troubleshooting Web Server, Application Server, Process Scheduler and Application Designer hitches in 2-tier, 3-tier.
• Implemented robust, highly available, failover and load-balancing capability for Portal, HRMS/HCM, FSCM, CRM web servers that handle the end user accessibility to PeopleSoft applications on UNIX environment.
• Possesses abreast of advancements and emerging trends in data management and storage systems, networking and multi-platform communication technologies; consults with vendors and other sources in industry and product direction, functionality and capabilities.
• Communicate clearly and effectively to diverse audiences of technical and non-technical personnel, both orally and in writing with strong problem solving skills.

TECHNICAL SKILLS:

Operating System: Linux, UNIX, Solaris, Win NT/2000/2003, 2008.

Databases: Oracle 9i, 10g, 11g, 12c and Sql server 2005, 2008 and 2012.

ERP: PeopleSoft HRMS - HCM v7.5 to v9.2, Financials v8.8 to v9.2, CS, CRM v8.8 to v9.1, Portal v8.8 to v9.1

People Tools: 8.x/8.4x,8.55 Web logic Server 51/6.1/8.1/9/10/10.3, Tuxedo 6.5/8.1/9.1/10.

WORK EXPERIENCE:

Confidential

Environment: Oracle12c, PeopleSoft FSCM HRMS v9.1 - v9.2Tools v8.55.13 & v8.55.21, IBM-AIX 7, Oracle Solaris 10, Windows Server 2012 R2 6.3 and Server 2016 NT 10

Responsibilities:

• PeopleSoft Upgrade Specialist and Administrator for FSCM Upgrade from 9.1 to 9.2.
• Responsible for scheming Solution Design Architecture of Infrastructure.
• Deployed Multiple PUM image in single UNIX server.
• Implemented and optimized PeopleSoft Elastic Search.
• Accountable for Security Mapping and Architecting Security matrix.
• Liable for PeopleSoft custom fluid Branding and custom fluid Tiles.
• Involved in Setup, Configure & manage OEM Grid Control.
• Implemented audit logs to track user level activities and configured centralized database to store database audit information and generate automated mail alerts.
• Implemented high Availability solutions including Oracle RAC and Dataguard.
• Tuned Application Engine to reduce the upgrade run time.
• Performing Migrations and applying latest Bug Fixes and PRP Updates from PUM Image.
• Providing PeopleSoft administrative support to Tech team.
• Fetching custom and customized application configuration data across environments.
• Spring-cleaning PeopleSoft Environments through Audit reports.

Upgrade specialist and PeopleSoft Administrator

Confidential

Responsibilities:

• PeopleSoft Upgrade Specialist and Administrator for HCM Upgrade from 9.1 to 9.2.
• Deployed multiple PUM image in single UNIX server and handling multiple tools version on single server.
• Configured S3 buckets, policies and the IAM role based policies.
• Migrated application and database from In-house to Cloud (Oracle/AWS)
• Involved in database encryption and user security management
• Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto- scaling, load balancers (ELBs) in the defined virtual private connection
• Specialised in loading Multi-Language in PUM Update Image.
• Implemented PeopleSoft Elastic Search.
• Tuned the Performance of Data Conversion & Data loading.
• Performed delta Migrations and applying latest Tax Updates from PUM Image.
• Handled PeopleSoft user security.
• Customized Change assistant template to accommodate the custom data conversion script.

Upgrade specialist and PeopleSoft Administrator

Confidential

Environment: Microsoft SQL Server, People Tools v8.54, HRMS v9.1 - v9.2, RHEL 7, IBM AIX 6 servers, Windows 2012

Responsibilities:

• Configured, Integrated and Organized SES.
• Performed Database refresh from production to non-prod environments.
• Configured Push Notification.
• Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager). Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2003 Server.
• Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments.
• Assisted users by installing Sybase client on their PC's, provided database access by adding their logins, creating roles, granting privileges, unlocked accounts, reset passwords.
• Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.
• Involved in database Load and performance testing.
• Created SQL Server audits and policies to monitor activity on SQL databases to ensure databases were in compliance, and met the Service Level requirements of our clients.
• Scheduled full, differential, and transactional log backups for user created databases in production environments.
• Responsible for setting up security, and providing user access to SQL Server instances and objects.
• Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.
• Optimized the cut over window with tuning and parallel activity.
• Retained custom configurations and security after upgrade.
• Customized Change assistant template to accommodate the custom data conversion.

AWS Solutions Architect

Confidential

Environment: AWS - EC2, S3, Glacier, DBMS, RDS, SQS, SNS, SES, CloudFormation, VPC, Redshift, DynamoDB, Oracle 12c, 11g, 10g, Linux

Responsibilities:

• Responsible for launching Amazon EC2 Cloud Instances using Amazon Web Services (Linux) and Configuring launched instances with respect to specific applications and regions.
• Involved in cross Platform Database migrations and migrations from Physical to Virtual environments (Hybrid Migrations).
• Installed and configured SQL Server 2008 along with Integration Services (SSIS), Analysis services (SSAS), and Reporting services (SSRS).
• Responsible for migration of packages from SQL Server 2005 to SQL Server 2008 using SSIS.
• Participated with business analysts in order together requirements for design and implementation of database.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed Handshaking architecture for overall data transfer from the OLTP to Staging area and finally into OLAP with SSIS and T-SQL stored procedures.
• Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation of the OLAP databases.
• Developed, deployed and monitored SSIS Packages including upgrading SSIS using upgrade advisor.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created parameterized reports and matrix reports using Report builder for the roles of the customers.
• Responsible for designing, creating and deploying the reports into the production server.
• Installed applications on AWS EC2 instances and configured the storage on S3 buckets.
• Responsible for S3 buckets creation, policies and the IAM role based policies.
• Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto- scaling, load balancers (ELBs) in the defined virtual private connection.
• Responsible for creating monitors, alarms, and notifications for EC2 hosts using Cloud Watch.
• Involved in the migration and implementation of multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53 Glacier, EC2, RDS, SQS, SNS and Lambda.
• Build and configure a virtual data centre in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer.
• Created User Accounts, Roles and granting required access Permissions and Privileges to the users.
• Implemented SQL, PL/SQL and T-SQL queries, packages, functions, stored procedures, triggers, tables, views, materialized views, indexes.
• Involved in the 24X7-support rotation for all the Production, Test, and Development databases.
• Upgrade Specialist for PeopleSoft Application HRMS from 8.9 to 9.2 and People Tools from .
• Provided on-call production database support and complete IM tickets and within the SLA.
• Performed multi-step HCM application upgrade i.e from HCM v 8.9 - v9.1 and to v9.2
• Created HCM92 demo instance using PeopleSoft DPK.
• Optimized the Cost of the Queries by altering and creating appropriate index structures
• Deployed PUM and extracted PUM Package and applied PUM objects, fixes.
• Configured, Integrated and deployed SES.
• Performed Performance Tuning using SQLTRACE, EXPLAIN PLAN, SQL and Indexing.
• Configured LDAP and installed SSL at web server level and load balancer level.
• Monitoring the table space growth and long running sessions.
• Performed Partitioning and sub-partitioning of records and indexes as per customer specific and Data Management.
• Created Custom Data conversion Script.
• Customized PeopleSoft Fluid branding, colour and Logo as per customer requirements.
• Adhering the relevant compliance policies and implement SOX audit findings.
• Worked on PeopleSoft MAA (Maximum Availability Architecture).
• Worked on Production support ticket on severity basis in rotation shift.

PeopleSoft Administrator

Confidential

Environment: Oracle 9i - 12c, PeopleTools v7.5 - v8.53, PeopleSoft HRMS v7.5 - v9.2, RHEL 6, Windows Server R2

Responsibilities:

• Upgrade Specialist for PeopleSoft Application HRMS from 7.5 to 9.2 and PeopleTools from 7.5 to 8.53.
• Performed multi-step HCM application upgrade i.e v7.5-v8.9-v9.1-v9.2.
• Executed application upgrade in Upgrade assistant and in change assistant.
• Deployed PUM, Extracted Package and Applied in target environment.
• Performed Data and object Migrations.
• Accomplished PeopleSoft Database Reorg.
• Designed the physical and logical layout of the servers based on user requirements, scalability needs and uptime requirements.
• Worked very closely with the developers on troubleshooting issues in a heavily customized system.
• Tweaked data conversion AE to accomplish multi-step upgrade without losing custom and customized customer legacy data and objects.
• Involved in Identifying major Instance tuning areas like Memory, I/O, CPU, Space and Network.
• Implemented partition and sub - partition for historical data records as per the logical point.
• Maintained the production/Non-production systems for PeopleSoft applications.

PeopleSoft Administrator

Confidential

Environment: Oracle 11g, People Tools v8.50, People Tools v8.52, Solaris 8PeopleSoft HRMS v 8.9 - v9.1, WebSphere 7.0.0.7/7.0.0.15, Oracle Tuxedo.

Responsibilities:

• Installed BEA Products (Web logic & Tuxedo) and People tools on Solaris Server, configured App server, batch server, webserver domains.
• Installed Digital for various environments and configured Single Sign On.
• Implemented LDAP, SSL in WebSphere 7.0.0.15.
• Upgrade Specialist for PeopleSoft Application HRMS 8.9 to 9.1 and People Tools from .
• Analysed the impact of the customizations and modified the conversion scripts to accommodate the customization according to customer requirements.
• Responsible for the Installation, Configuration, and Maintenance of Oracle 12c/11g/10g Single Instances and RAC databases for High Availability and Disaster Recovery.
• Created Oracle Databases for SIT, UAT and parallel instances using Production Data pump export.
• Liable for health check-up for Oracle Database backup, File system alert on space issue, application server, web server, Database and on assigned tickets.
• Handled change requests as per Change process with appropriate approvals
• Performed Go-Live execution and post Go-Live production support.
• Inscribed Bash files and UNIX shell scripts to schedule reset (shutdown, clear cache and start-up) of Process Scheduler, Application Server and web server domains.

PeopleSoft Administrator and Upgrade Specialist

Confidential

Environment: Microsoft Sql Server, PeopleTools v8.51, PeopleTools v8.52, PeopleSoft HRMS v9.1, FSCM v9.1CRM v9.1, Web Logic 10.3.3, 10.3.4, Oracle Tuxedo 10gr3, UNIX and Windows servers

Responsibilities:

• Lead Consultant for PeopleSoft Tools upgrade from .
• Provided all sorts of PeopleSoft admin support to the development and testing databases.
• Planned, organized and integrated to manage the broad range of complex data and systems, upgrade, administration and maintenance activities.
• Optimized the cut over window.
• Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.
• Configured, and supported and Log Shipping and Database Mirroring strategies to support our client's High.
• Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Implemented SSL and provided path breaker solutions which stopped the Go-Live for customer in their previous attempt with different Vendor.
• Responsible for handling 4 production database and 24 non-prod environments and their related issues.
• Installed PeopleSoft in Solaris 10 & windows servers.
• Designed and provided sizing for infrastructure based on the customer requirements and useability.
• Downloaded the required PeopleSoft FSCM Maintenance Packs & Bundles and Oracle database patches and their respective pre and post bundles, patches from oracle support and applied in the target environment.
• Performed People Tools Upgrade from v8.50-v8.52.
• Provided PeopleSoft admin support to the development and testing databases.
• Performed backup, recovery and database refresh from PROD to non-Prod environments.
• Configured PeopleSoft Test framework (PTF).
• Prepared clear, concise and accurate proposals, reports, documentation and other written materials.

PeopleSoft Administrator for Production Support.

Confidential

Environment: Microsoft server 2008, PeopleTools v8.51, PeopleSoft HRMS v9.1, Web Logic 9.2/10.3.3, Oracle Tuxedo 9.1/10gr3, Red Hat Linux

Responsibilities:

• Executed the Audit Reports and cleaned the exceptions from the database.
• Installed software’s in RHEL 5.5 and created PeopleSoft database.
• Configured App, Web and Process scheduler domains and all the required PeopleSoft configurations (REN, IB, Verity and SSL).
• Performed patching, upgrade and migration on multiple development, test and production databases from 9i to 11g and migrated it to different platforms.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, SSRS and SSIS services.
• Excellent backend skills in creating SQL objects like tables, stored procedures, views, Indexes,triggers, rules, defaults, user defined data types and functions.
• Experience in Performance Tuning by Index Defragmentation, optimizing executionplans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures, Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in data Import/Exportutilities tools like SSIS, SSRS, BCP, BULK INSERT.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Performed Project Migrations and provided solutions to critical application issues.
• Provided PSADMIN support to the development team.
• Responsible for troubleshooting Web, App, Process Scheduler & Application Designer issues in 2-tier, 3-tier.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Involved in Analysing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Worked on the production support on critical ticket basis.
• Provided 24-Hour on-call production support on a rotational basis.
• Upgraded PeopleSoft HRMS Application from 8.8 to 9.1 and People Tools from .
• Analysed the impact of customization and providing custom, customization and new objects- retrofitting report.
• Created data reconciliation report.
• Performed security administration and implemented SJT row level security.
• Managed user level security (Creating users, logins and roles, granting permissions) to the required pages based on the functionality.
• Provided all sortsof Oracle DBA & PeopleSoft admin support to the development and testing databases.
• Performed daily health checks and prepared DB stats reports.
• Applied Maintenance Packs, Bundles, Tax Updates, and Oracle database patches.
• Performed Performance monitoring and tuning the PeopleSoft environment during testing phase in order to identify delinquent capacities and tune the system accordingly and additional monitoring scripts were setup to monitor and notify on critical system events.

PeopleSoft Administrator for Production support

Confidential

Environment: Linux server, SQL server 2005, Windows server 2008, People Tools v8.51, PeopleSoft HRMS v8.9, FSCM v8.8 and CRM v8.8, Web Logic 10.3.3, Tuxedo 10gr3

Responsibilities:

• Designed and provided sizing to the infrastructure.
• Installed People Tools and Configured Web, App and Process Scheduler in Red Hat Linux Server.
• Integrated PeopleSoft applications (HRMS, FSCM and CRM) with Integration Broker.
• Provided PeopleSoft Production Support and responsible for day-to-day activities both in non-PROD and PROD environments.
• Configured SMTP, REN server and Report node and file transfer protocol.
• Handled change requests as per Change process with appropriate approvals.
• Worked on Database refresh from production to UAT and Portal Database.
• Adhered to the quality and timely delivery of the resolution to the customer for PeopleSoft production system. Optimized and tuned all PeopleSoft applications (FIN, CRM, EPM and HRMS).
• Responsible for resolving issues with architecture, application, and other related environment components in a timely manner, including root cause and complete resolution documentation.

PeopleSoft Administrator

Confidential

Environment: Red Hat LINUX, People Tools v8.48/v8.50, FSCM v8.9, Web logic 8.1, tuxedo 8.1

Responsibilities:

• Installed People Tools, FSCM application and Configured Web, App and Process Scheduler in UNIX server as multi-server domains with load balancing (F5).
• Upgraded PeopleSoft People Tools from .
• Performed maintenance and production Support for PROD, non-PROD environments and provided solutions for critical issues.
• Downloaded, Extracted and applied PeopleSoft bundles, pre - post patches and required fixes.
• Configured SMTP, integration broker, REN server, report node and installed SSL in the Web logic Server.
• Installation, Configuration, Maintenance and Administration of MS SQL Server 2008 R2.
• Involved in setting up Transactional Replication and Snapshot replication.
• Involved in Setting up Log shipping.
• Involved in database mirroringandInvolved in Creating Back upStrategy.
• Involved in Designing (Logical and Physical) of Customer Database.
• Created & managed the Database Users, Login,Roles,Profiles and Security.
• Automated Backup/Restore Jobs as well as reduce the Backup/Restore time up to significant amount
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using MS SQL.
• Creation of Jobs, Schedules, Alerts using MS SQL Server Agent and Notifications usingMSSQL Mail
• Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to MS SQL server. Worked as MS SQL Server administrator.
• Worked on performance tuning of Database and Query tuning.
• Involved in resolving blocking and dead lock Issues by using MS SQL commands Using T-SQL.
• Monitoring Event viewer, MS SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP utility.
• Extracting, Transforming and loading of data using SSIS.
• Deployed and scheduled SSIS Package.
• Compiled COBOL Programs.
• Responsible for handling 3 production database and 18 non-prod environments.