Oracle Manager
Resume:
SONAL SHAH
**********@*******.***
Peoplesoft Administrator
SUMMARY
. An Information technology professional with 10 years of experience in
various areas of the Software Development life cycle including analysis,
design, testing, implementation and support. Worked with major-global
Financials, Insurance-Brokers and Credit rating companies. Current with
various top-notch technologies with more focus on server side expertise
including databases administration, Server Administration and Operating
System mechanics.
. Excellent adaptability for new technologies and enthusiasm for
challenging projects.
. A team player with a "CAN DO" attitude in all facets of project
development, and has a proven track record of success.
. Excellent communication and Interpersonal Skills.
TECHNICAL EXPERIENCE
. Ten (10) years of total experience in various areas of the Software
Development Life cycle like Analysis, Design, Testing, Implementation and
support.
. Over seven (7) years working experience as a Peoplesoft DBA, involved in
Installation, Configuration, Administration and Tuning of Peoplesoft 8.x.
Very familiar with PeopleSoft Schemas and objects. Experience with
PeopleCode debugging and PeopleSoft SQL Code.
. Around Four (4) years of experience as an Oracle DBA, involved in
Installation, configuration, Administration and Performance tuning of
Oracle 9i and Oracle 10g databases.
. Experience in software installations, configuration and implementations.
. Extensive experience in logical modeling, physical design, data
architecture.
. Very strong experience working as development DBA support and production
DBA support offering 24 X 7 supports.
. Strong skills as Team lead, implementing and managing large scale systems
(multiple servers and multiple databases) across different time zones.
. Excellent experience working on Peoplesoft HRMS, CRM, Financial and EPM
modules - all version 8.
. Experience and strong knowledge with Datawarehousing database
architectures including installing/configuring Datawarehousing tools like
Informatica Powermart.
. Strong experience working on Datamodeling tools like ERWIN.
. Strong Client server development experience in Visual Basic, VBA, HTML,
SQL Server.
TECHNICAL SKILLS
Hardware: HP - UNX, Sun Fire 4800, Sun Fire 6800, Ultra 540, Compaq
Proliant, Intel Platform, IBM Regatta.
Operating Systems: HP - UNX 11, Solaris 8, UNIX/Solaris 5, AIX 5.1, Linux,
NT 4.0, MS-DOS, Win 95, Win 98, Win 2000, Win XP, Windows 2003
Software: Oracle Enterprise Manager, Oracle DBA studio, Desktop DBA, Site
Minder (LDAP), Kintana, STAT 4.1, Dream Weaver, FrontPage, Office 95,97,
2000, Web logic 5.3, 6.1, 8.1 & 9.2, Java/applets/JSP, Net Dynamics 4.0,
Visual Basic 5.0, 6.0.
ERP: PeopleSoft: Tools 8 (all), Financial 8.x, EPM 8.3, HRMS 8.3, 8.8, 9.0
Financials 8.8, 8.9, CRM 8, S-pro 8.4, Portal 8.4 & 8.9, Business
Interlink, BAM, Mohomine Resume Ext. Peoplecode, sqr, application engines,
application designer.
Reporting: Hyperion: Central 3.x, Analyzer 6.1.1, 6.2.1, Reports 2.0.1,
2.5.03, Crystal Enterprise 8.x, Crystal reports 2.5.03, Essbase OLAP server
6.5.3, Essbase Integration Server 6.5.3, EDS 6.5.4.
Protocols: TCP/IP Named Pipes, HTTP, HTTPS (SSL).
Case Tools: Oracle Designer 2000, Erwin 4.0, SQL Navigator 3.0, Toad,
DBArtisan 8.0.1.
Databases: Oracle 10g (10.1.0.4), Oracle 9i, Oracle 8i, Oracle 8/7, MySql,
SQL Server 7/2000, Sybase 11/12, Access, Dbase, FoxPro/Clipper, Essbase
6.5.4.
SONAL SHAH
**********@*******.***
Page Two
Professional Experience
KPMG, Montvale, NJ 2007 - Present
Senior PeopleSoft Admin/SQLServer DBA
Worked part time remotely to maintain and support PeopleSoft sandboxes for
KPMG's HRMS and Financial 8.4 initiatives. These sandboxes hosted a series
of training for KPMG's Audit and Advisory committee with an intention to
cope up with their clients needs with similar PeopleSoft technologies.
. Worked on hardware & software procurement, cost analysis and timeline for
fresh installs of HRMS & Fin 9.0
. Wrote and executed a series of sql server scripts using OSQL utility to
extract data from these environments, load them into similar Oracle
environments at client side with Oracle as the backend.
. Troubleshooted and fixed issues with Process Scheduler (report repository
setup, windows service setup and scheduled to boot automatically after
scheduled and non planned reboots of the server), PeopleBooks (setup
context sensitive help, corrected 'Page cannot be displayed' error) and
other Security related concerns for the committee.
. Handled the monthly PIA maintenance, post the regular firmwise installs
of OS patches and fixes on a regular basis for more than a year.
Newark Public Schools, Newark, NJ 2007 - 2008
Senior PeopleSoft Admin/Oracle DBA
Was brought in as a super support personnel for NPS (Newark Public School)
Business Portal - A Direct District investments in technology for both
business & educational systems showcasing newly implemented PeopleSoft
technologies in HR 8.8, Financials 8.9 and Portal 8.9 - all with
PeopleTools 8.46.06.
. Solely responsible for the complete administration, support and
maintenance of all the PeopleSoft initiatives at the district - an
environment encompassing 65 servers, 33 databases and equivalent PIAs
using Nortel Network's Alteon 3408 for load balancing the production web
servers on a MicroSoft Windows 2003 Operating System.
. All facets of PeopleSoft administration including but not limited to,
migrations, application bundles, tax upgrades, environment refresh,
frequent performance glitches, load balancing production application
servers, audit mandated change passwords of super accounts every
quarterly, running AE version program to eliminate data integrity errors
caused by multiple straight database SQL updates, troubleshooting varied
behaviors of various components in test Vs production databases, Process
Scheduler issues with regards to report repository postings, WinWord
hanging etc.
. Extensively worked on the #1 complain of the "Not so technology savvy end
users" - Performance.
Successfully identified various levels of performance hindrance from
running traces in production, running multiple budget checking at the
same time, to networking protocols, to incorrect proxy settings, to non
ideal workstations, and many more to gain confidence of these district
employees loyal to the old legacy systems.
. Satisfied the Chief Information Service Officer's request on restricting
users using the NPS Business Portal link to use the signon.html webpage
for PeopleSoft Access to HR & Financials. Created customized WebLogic
logout.html and signin.html pages in development and production to avoid
production work in training environments and to avoid users saving their
logout pages as their favorite entry to the Portal.
. Switched my role to a techno-functional, as and when required while
dealing with users who have been trained long time back on eProcurement,
PO and other modules.
. Worked as a Portal Administrator for single signon from Portal to
PeopleSoft (HR and Fin) and other non-PeopleSoft third party applications
and switched to a role of Security Admin as a backup to our Security
Administrator.
. Used Integration broker to configure nodes to access various PunchOuts to
facilitate ordering school and business supplies from
SchoolSpecialty.com, WBMason, and LakeShore etc.
. Reconfigured Production RenServers to facilitate processing output to
Windows and view Printable RFQs & POs online for Financials users.
. Decommissioned and created a newer Production application server by
installing Oracle, PeopleTools, BEA Tuxedo, Crystal and MicroSoft office
Word to support WinWord format for recruitment letters for HR.
. Performed database related administrative work on Oracle 10g. Scheduled
automated refreshes of Backup environments from Production. Wrote Dos
command line scripts that were invoked daily as part of the
SONAL SHAH
**********@*******.***
Page Three
Windows Scheduled task to run, backup, copy and boot up of the
environments as part of the district's "Save
Energy" Policy.
. Regularly checked the alert logs on all the production databases to
capture contentions in the database.
. Completed handled and successfully executed quarterly Disaster Recovery
tasks at a offsite location for NPS and at Carlstadt Disaster Recovery
facility to ensure continuity of business.
. Documented PeopleSoft related DR tasks for quick and easy step through
guide for future DRs.
. Identified the PeopleSoft launch page sluggishness to be attributing to
incorrect entries in the host file, rectified it and wrapped up the long
time concern of all the PeopleSoft users across 89 schools in the
district not to mention the Central office employees.
. As and when required, brought all the stakeholders together and
coordinated a multi-faceted team with Networking, developers, software
engineers and myself as a PeopleSoft admin/Oracle DBA to address district
wide issues in accessing culprit sections of PeopleSoft to troubleshoot
and resolve.
. Received a lot of kudos in a very short time on my communication skills
and attempts to keep all the teams up to date on my findings and
resolutions.
Chubb & son, A division of Federal Insurance Company Little Falls, NJ
2006 - 2007
PeopleSoft Technical Manager
Adept at designing and implementing technology-enabled business solutions,
worked as a PeopleSoft Technical manager for Chubb and Son as part of a
high-talent team, replacing a legacy HR solution with PeopleSoft HRMS
version 8.8 SP1 with Tools 8.46.05, primarily with Benefits and Payroll
modules.
. Direct team management responsibility in implementing a large scale and
highly complex interface exchange system between PeopleSoft HR and other
internal but outsourced applications within Chubb. Neatly shaped up an
excellent vendor rapport between Chubb and external vendors such as
CitiGroup, Cigna, Jefferson Pilot, Lincoln Financials Group, ADP etc.
. Supported all PeopleSoft environments, direct involvement in
troubleshooting and resolving technical issues and coordinating technical
changes with infrastructure and networking team.
. Applied in some and guided in others - various Tax updates as well as the
early daylight savings time patches in both PeopleSoft and on the JRE for
all the instances.
. Involvement in configuration as well as elimination of the use of Master
Process Scheduler as part of load balancing automated semimonthly
processes.
. Extensively used online Process Scheduler to create, configure and
schedule with notifications various pay cycle related PeopleSoft Jobs
keeping in mind the dependencies between each processes and reports.
. Successfully developed and deployed the online check printing and advice
printing SQR with embedded Chubb logo and signature fonts with MICR
Line.
. Diurnal PeopleSoft Admin activities included administering the PeopleSoft
Internet Architecture for all the eleven instances, both online object
migrations, as well as source code migrations on the server in the form
of sqrs and app engines, environment refreshes, enabling purge,
monitoring disk utilization on the servers, watching the performance of
the servers, load balancing Tuxedo, debugging developer codes as part of
troubleshooting functionalities, etc.
. Off and on Security Administration work including registering components
to the customized menus, user accounts and profile setups for
development, system integration, parallel testing and Chubb acceptance
testing.
. Documented detailed change control and maintenance processes including
security, server access, code remediation and emergency change requests
etc.
. Prepared high level project plans, design specs and technical bible for
the future state Operations team.
. Orchestrated the close of deal for hardware procurement of check printing
printers and printer cards.
SONAL SHAH
**********@*******.***
Page Four
Moody's Investors Service Jersey City, NJ 2005 - 2006
Sr. PeopleSoft Technical Administrator
Worked as the sole PeopleSoft Administrator, as part of a swat team working
towards performance tuning of the newly implemented CRM 8.9 application - a
platform for the System Analysts involved in the credit rating initiatives
of the company. Maintaining and supporting the HRMS 8.8 & Financials 8
PeopleSoft suites for the organization using STAT 5.0
. Tuned the Weblogic 8.1, and Tuxedo 8 to perform at its optimum capacity,
including the Java Heap Size, Sybase packet size, number of PSAPPSRV
processes, Jolt and other weblogic timeout parameters.
. Worked hand in hand with the network administrators using the network
Sniffer, to eliminate the Network bandwidth issues for this global
implementation servicing Japan, Europe and North America.
. Recommended and implemented various AIX kernel parameter changes
including tcp window sizing parameters, sb_max, and ulimits for the
UnixId etc.
. Fixed the PSAPPSRV spawning, Version corruption and various other
peoplesoft related issues of the application and troubleshoot'd various
application errors and helped Sybase dba tune various sqls.
. Involved in software procurement of monitoring tools for various
PeopleSoft components eg: FogLight from Quest, I3 from Mercury. Also
helped in the company's initiatives to procure Sybase
diagnostic/monitoring tools eg: Snapimonn and SQL Capture.
. Using my UNIX shell scripting technical skills - resolved the application
hang issues due to high disk utilization, thus increasing productivity of
the CRM sales analysts.
. Implemented SSL (Secured Socket layer) for the web server (Weblogic -
5.1, 6.1 & 8.1) using VeriSign as the certificate Authority.
Marsh & McLennan Companies, Inc., Hoboken, NJ 2004 - 2005
Senior PeopleSoft System Administrator
As a Sr. PeopleSoft SysAdmin, supported and enhanced a North American
Payroll system within an Enterprise Portal.
. Worked intensely with Integration Broker, content references and node
definitions.
. Implemented App messaging: creating messages, message nodes, channels,
configuring Integration Gateway for both the Portal and content provider
- HRMS.
. Integrated both PeopleSoft and non-Peoplesoft applications with Portal,
using Single SignOn.
. Tuned Weblogic webserver, Tuxedo, and other key PIA components as part of
the Prep Up for the Open Annual Enrollment '04.
. Troubleshooted existing issues with Portal and HR Report Repositories.
Implemented Report Repository Single SignOn.
. Applied security to developers to access their components.
. Extensively involved in the writing, maintaining and actively responding
to the heartbeat scripts in Unix Shell scripts, App Engine program for
email and page notification for messages stuck in "NEW" or "Error" status
as part of the App Message Monitoring, monitoring server Stats and User
Activity during the current crucial peak usage of Annual Benefits
Enrollment for the year 2005.
. Implemented load balancing using the WebLogic Round Robin strategies for
the multiple web servers.
. Supported network flow using Secured Shell Tunnels (SSH Tunnels) for both
the internet and the intranet access to the system through the various
DMZs in the organization.
. Used a home grown - Change Control system for migrating online objects.
. Downloaded, analyzed and installed Tax Updates and various other fixes
for the North American Payroll system on a regular basis.
. Regularly refresh database instances and PIA from production.
. Used Visual Basic 6.0 to write a program as part of a Utility creation to
migrate/ftp files to the various HR and Portal file servers.
SONAL SHAH
**********@*******.***
Page Five
Citigroup, Inc. New York, NY 1999 - 2004
COE (Center of Excellence) (2002 - 2004)
Regional (APAC) Team Lead: Peoplesoft/Oracle DBA Lead
As a PeopleSoft HRMS Team Lead, implemented a HRMS application for
CitiGroup's Asia and Pacific centers. A Pioneer in most of the PeopleSoft
applications installed & implemented in CitiBank - these includes HRMS,
EPM, Financials, sPro and Portal. Worked as a liaison between the
PeopleSoft infrastructure team (COE) and mediating changes for other
supplemental team in the organization including but not limited to Network,
NT/Unix SAs and Global Database Management group (GDMG).
. Designed, developed, implemented and managed large-scale multi-vendor
information technology systems for 20+ Asia-Pacific countries.
. As a team lead, assured the development community, adhered to CitiTech
standards/assets and leverage it to deliver an effective solution with
minimal risk.
. As a Sr. Architect, administered and configured the various n-tier
components of a PIA. This included the Application Server, Web Server,
Database server and NT/Unix Process scheduler Server.
. Database Administration of all the dev, UAT and production databases for
a global data warehousing. Managed 65+ database instances on UNIX as well
as Windows NT OS.
. Provided comprehensive business continuity during both planned and
unplanned outages. Installed and configured Oracle Standby database and
created a replicated PIA to fail over as part of a Disaster Recovery
process for the global applications. Assured COB. (Continuity of
Business).
. Performing all the Oracle administrative and development DBA tasks on
heterogeneous system platforms. This included modeling, performance
tuning and capacity planning for a HR and Finance warehouse.
. Installation, configuration and troubleshooting of PeopleSoft EPM 8.3,
HRMS 8.3 and Portals 8 applications.
. Worked as a PeopleSoft Security administrator involved in critical
security changes necessary for Audit and Compliance. Provided expertise
for the configuration, installation and rollout of system architecture in
support of corporate franchise and channel initiatives.
. Proficient in People Tools including Application designer & Data mover.
. Installed and registered the Informatica Power Mart Server.
. Analyzed the systems requirements, did the capacity planning and involved
actively in the budget planning of new hardware procurement for
PeopleSoft EPM 8.3, HRMS 8.3 (all modules inc ESS, Payroll, Benefits),
CWO 8.4 and Portals 8sp1 applications.
. Used STAT tool to migrate all the customized objects (both online and
batch) and projects across the different environments.
. Installed Kintana and STAT (product of Quest software) - SCM tools and
integrated it with PeopleSoft 8.18. Worked as a Sr. PS migrator and
software upgrader.
. Involved in working with EPM set up and various Metadata objects such as
Technical Metadata, & Business Intelligence.
. Worked with Citigroup's System administrators to automate various
administrative functions like automatic backups and power recycles of
various UNIX and NT servers with automated restart of the applications
using "cron".
. Liaisoned with various vendors for application specific hardware/software
enhancements.
. Participated in various meetings for project planning, reviewing,
compliance and accuracy /deadline requirements.
. Efficiently communicated to various Corporate Data Center support
organizations on the resolution of system integration and performance
issues.
SONAL SHAH
**********@*******.***
Page Six
Citigroup, Inc., (Continued)
Citivision / Compass (1999-2001)
As a Sr. Oracle DBA and lead database developer in designing and
implementing an institutional-grade financial portal for the citivision.com
system - a collaborative effort between Citibank and Salomon Smith Barney
and Compass - a web enabled enterprise solution, serving Citibank with its
Customer related inquiries.
. Used Erwin to design the huge and complex database structures that was
implemented to Oracle where all the corporate data is stored using
Forward Engineering.
. Extensively used Oracle Administrative tools to create database
instances, maintain it using backup strategies delivered by Oracle
including RMAN, import/export, sql loader etc.
. Analyzed tables after multiple truncations on database objects.
. Used Oracle Migration Workbench 1.3.0 to bring in data from other
corporate similar systems (SQL Server/Sybase).
. Wrote an Oracle Package (global variables, 12-procedures) to handle the
portal User Creation Process.
. Managed the physical storage structure such as data files, control files
and redo log files.
. As part of the Security implementation, developed and assigned roles and
privileges to the users by means of SQL Scripts with DCL commands as well
as with OEM.
. Created function based indexes, mentored developers not familiar with
Oracle, tuned queries and used hints to force index usage in their
queries for performance.
. Used Forward engineering to generate and create the table definitions,
indexes and constraints.
. Used SQL*Loader to insert data extracted from Lotus Domino Servers.
. Wrote many PL/SQL Procedures to transfer data during siphoning. Data was
extracted using Lotus pump technology and then using these PL/SQL codes,
they were inserted into the respective tables. Used correlated subquery
and outer joins.
EDUCATION
DISM - Diploma in Systems Management (Jan '93), Apple Industries, Surat
India.
BS - Bachelor of Science (Jan '92), South Gujarat University, Surat, India.
Training - Oracle, VB, PeopleSoft, Sybase etc.
Contact this candidate