Sql Server Process
Resume:
Mayank Bakhru
BACKGROUND
ERP Implementation Professional specialized in PeopleSoft Administration,
installations, configuration, upgrade, performance tuning, integration,
query tuning, refreshes. Areas of expertise include:
Fit Gap Analysis Installation Integration
Change Management Upgrade Query Tuning
Methodologies
Environment Refreshes Production Support Performance Tuning
SYSTEMS
ERP: PeopleSoft HR 9.0, Financials 8.9, Portal 9.0, CRM9.0, EPM
PeopleTools Version: 8.1x, 8.2x, 8.42, 8.47, 8.49
Database: Oracle 10g, 9x, 8x; SQL Server 2000
OS: UNIX, Windows 95/98/2000/NT, Linux (RHEL 4.5), Sun Solaris 10,
PROJECTS EXPERIENCE
Pfizer INC, Gladstone, NJ Jan '07
till Date
PeopleSoft Administrator
Scope:
Responsible for Application upgrade for HRMS 8.3 to 9.0 and 8.8 to 9.0,
also was involved with Installs and Tune ups of PeopleSoft environments,
applying upgrade Bundles patches to environment using CA tool, Configuring
Integration Broker.
Responsibilities
. Upgrade for HRMS 8.3 to 9.0
. Upgrade for HRMS 8.8 to 8.9
. PeopleTools upgrade to 8.49.02
. Configuring EMF Setting up Change Assistant
. Creating new instances of PeopleSoft.
. Migrations of Projects
. Applying Bundles, Patches, Tax Updates and fixes.
. Applying Maintenance Packs
. Tweaking Data conversion
. Applying Upgrade bundles
. Running Compare reports and explaining them to Clients.
. Writing custom queries to compare objects beyond app designer.
. App server and Process scheduler tune-ups
. Query tune ups
. Configuring report nodes
. Writing custom SQL scripts to reduce the index creation during the
upgrade.
. Setup and maintain the Appserver and Process Scheduler.
. To setup log / traces as and when required.
. Configuring Integration broker
. Setup and maintain features Application Messaging.
. Weblogic tune ups
. PeopleBooks install enabling Verity Search
Post Go-live Support
. Installing and Managing PIA, Tuxedo Application Server Domain, Web
Servers and Process Schedulers
. Setup Enterprise Management Framework
. Applying maintenance packs, bundles etc to CRM, HR and PORTAL env.
. Managing and synchronizing Batch environments during the mass migrations
and compiling cobols
. Tweak the setting for process schedulers and application servers
. Providing support by troubleshooting and fine tuning performance issues
related to entire PeopleSoft Batch and Application server environment
. Creating new web sites on 10gAS for new environments
. Perform migrations of PeopleSoft objects using STAT
. Automating synchronizing migrations to clone databases
. Automating Project BUILD activity
. Writing windows batch scripts to achieve above listed automation.
. Integrating all the PeopleSoft environments HR/CRM/POR
. Writing Custom queries to facilitate Migrations and project migration
between different tools
. Setting up Users in STAT and PeopleSoft 9.0
. Applying Tax updates.
. Tweaking long running queries
. Create and administer new user roles and security within the STAT realm.
. Integrating CRM, HR and Portal instances.
. Integrating external systems
o TALX for Paycheck viewing
o Integrating Pfizer careers with external vendors
. Ensuring PS environment health by resolving issues from system(SYSAUDIT)
and data dictionary audits (DDAUDIT)
. Automating Migrations.
. Setting up email based reporting system for tracking team's work
. Designing and generating team performance reports.
. Designing and generating SYSTEM performance reports.
. Resolving day to day Production issues faced by the users.
. Configuring and maintaining Application Messaging using Integration
Broker between HR and CRM systems e.g. HRHD 360
. Installing and managing Digital SSL Certificates on Web Server .
. Managing Tuxedo Application Server Domain, Web Servers and Process
Schedulers on UNIX operating system.
. Managing batch jobs on Autosys.
. Applying PT 8.49.20 peopletools patch.
. Upgrading Verity & Tuxedo.
. Application Support for Solaris 10 OS upgrade.
. Administered moving middle-tier server to Linux RHEL 4.5
. Wyeth integration activities
. Automating daily chores
.
Software : HR8.3, HR8.8, HR8.9,HR 9.0, Portal 8.8, Portal 9.0, CRM 8.9, CRM
9.0 on Oracle 10.2.03, server2k and Sun solaris 9, WIN2k, WebLogic 5.1/6.1
/ 8.1sp5/9.1, PT 8.48.06, 8.49.02, PT 8.49.20, STAT 5.2.2, sun E15K, Sun
E25K, Sun solaris 10
Navisite Inc, Atlanta, GA Jan '06
till Dec' 06
PeopleSoft Administrator
Scope:
Responsible for Installs and Tune ups of PeopleSoft environments, applying
Bundles patches to environment using CA tool, Configuring Integration
utilities XMLLINK and IB, performing post refresh activities, Application
Upgrade
Responsibilities
Managing gamut of clients on multiple PeopleTools versions and multiple DB
platforms.
Creating new instances of Peoplesoft.
Integrating various PeopleSoft Applications using Integration Broker /
XMLLINK
Migrations of Projects
Configuring and maintaining Enterprise Management Framework & Change
Assistant.
Applying Bundles Patches and fixes.
Applying Maintenance Packs
Generating and analyzing Compare reports.
Managing and synchronizing Batch environments during the mass migrations
and compiling cobols
App server and Process scheduler tune-ups
Query tune ups
Configuring report nodes
Setup and maintain the Appserver and Process Scheduler.
To setup log / traces as and when required.
Windows server administration
Writing Batch scripts to automate the SQL server backups.
Configuring PeopleCode Debugger
Configuring Integration broker.
Installing and managing Digital SSL Certificates on Web Server.
Setup and maintain features Application Messaging.
To resolve the day to day Production issues faced by the users.
Weblogic tune ups
Ensuring PS environment health by resolving issues from system(SYSAUDIT)
and data dictionary audits (DDAUDIT)
PeopleBooks install enabling Verity Search
Upgrade for HRMS 8.3 to 8.9
POST Refresh Activities
Working with Remedy tickets to facilitate maintenance of PS systems
Software: Fin 7.5 - 8.8, HR 8.3 - 8.9, Portal 8.8 on Oracle 8x\9x,
MSSQL,DB2 server2k and HP-Unix, WIN2k, WebLogic 5.1/6.1 / 8.1sp5, PT
8.47.04
Citigroup, Warren, NJ May '05 till
Dec '05
PeopleSoft Administrator
Scope:
Responsible for the migration of projects / SQLs using STAT, Informatica,
responsible for Integrating Portal with other regions. Writing the UNIX
shell scripts for weblogic monitoring. Planview Administration/install,
installing Business Objects.
Responsibilities
. Integrating Portal with third party products and other regions.
. Migrations of Projects
. Written shell scripts for weblogic monitoring
. Setup and maintain the Appserver and Process Scheduler.
. Weekly checkouts for Portal
. To setup log / traces as and when required.
. Managing Projects between different Application Instances.
. Setup and maintain features Application Messaging.
. Planview Administration / Install
. Installing Business objects to interface with Planview.
. To resolve the day to day Production issues faced by the users.
Software: Fin 8.4, HR 8.8, Portal 8.8, EPM 8.8 on Oracle 8x\9x and Unix,
WebLogic 6.1 / 8.1, Stat, PlanView.
Broadcom INC., Irvine, USA Sept '04 till
May '05
PeopleSoft Administrator
Scope:
Maintaining the instances, handling the backup and refresh processes,
responsible for the migration of projects / SQLs, Involved in Application
Upgrade for financial from 8.4 to 8.4 sp2, Query Tune ups, also responsible
for Integrating HR and Financials.
Responsibilities
Managing refresh(s) of the mirror env.
Integrating the financial and HR instances
Upgrade PeopleTools from 8.2x to 8.4x
Query tune ups
Migrations of Projects
Tweaking Appserver and process scheduler for better performance
Setup and maintain the Appserver and Process Scheduler.
To setup log / traces as and when required.
Maintaining DEMO / DEV / Production instances for each Application
instance.
Managing Projects between different Application Instances.
Setup and maintain features Application Messaging.
To resolve the day to day Production issues faced by the users.
Software: Fin 8.4SP2, HR 8.8, Portal 8.8 on SQL Server 2000, Windows 2000
Server, WebLogic 8.1
Wipro Technologies Aug '03 till
Aug '04
PeopleSoft Administrator
Scope:
To maintain the PeopleSoft Application instances. To support the in-house
developments in PeopleSoft Applications such as HRMS, Finance and CRM on
People Tools 8.43. To configure and maintain these Applications on a
regular basis.
Responsibilities
. Installations for PeopleSoft instances HR and Finance, CRM
. Integrating the financial and HR instances
. Query tune ups
. Tweaking Appserver and process scheduler for better performance
. Carrying out Impact Analysis for Importing the Projects from Development
to Production Environment.
. Configured the SingleSignon for all Instances.
. Configured LDAP
. Multiple People-Books installation.
. Requirement Analysis for In-house development.
. Setup and maintain the Appserver and Process Scheduler.
. To setup log / traces as and when required.
. Maintaining DEMO / DEV / Production instances for each Application
instance.
. Laid down the Backup procedures for all the Instances.
. Managing Projects between different Application Instances.
. Setup and maintain features Application Messaging.
. To assist the Development Team in setting up Roles/Permissions and other
Server side activities for the developers.
. To resolve the day to day Production issues faced by the users.
Software: PeopleTools 8.43, PeopleCode, SQR, Application Engine, Query,
Oracle
Contact Information
Email: ************@*****.***
Phone: 732-***-****
EDUCATIONAL ADDENDUM
Degree: Bachelor of Information System (Honors)
University: Guru Gobind Singh Indraprastha Univ., New Delhi
Contact this candidate