Security Management

MANUEL (MANNY) FLORES, JR.

***** ******** **** ***, *******, TX 77433

Cell 713-***-**** Home 281-***-****

****@***.***

EXECUTIVE SUMMARY

Over 10 years of PeopleSoft and Oracle DBA experience.

. Security lead in implementing PeopleSoft Enterprise Financials and Supply

Chain Management 9.0 in four and a half months. Created security for

over 8,000 named users over 18 modules including eBill Payment,

eProcurement, eSettlements and eSupplier Connection. My role as a lead

included mentoring a team of 4 security leads and 6 functional module

leads with no previous PeopleSoft experience.

. Performed all tasks required of a DBA and PeopleSoft Technical

Administrator including security, change control, troubleshooting,

customization, debugging, upgrades and patch application.

. Administered PeopleSoft Enterprise Financials and Supply Chain

Management, Human Capital Management, Campus Solutions, Portal,

EPM/OBIEE, Oracle MDM, Oracle UPK, Enterprise Staffing Front Office and

Oracle Financials 11i systems. Responsibilities included the team lead

for monitoring, approving and applying all upgrades, fixes and

migrations.

. Provided assistance to development and contract staff for issues relating

to performance tuning and SQL creation.

. Tuned SQL statements found in SQRs, queries, application engine, COBOL

and nVision to maximize performance and thus reduce process execution

time.

. Responsible for the overall management and data integrity of the

following implementations: PeopleSoft Enterprise Financials and Supply

Chain Management, Human Capital Management, Enterprise Staffing Front

Office and Oracle Financials 11i systems database management system.

. Maintained a server environment that optimizes the efficient integration

of a variety of servers, including Application Servers, Web Logic

Servers, Process Scheduler Servers and Report Servers.

. Monitored the Process Scheduler for efficient queuing and processing of

jobs. And routinely monitored logs, tables, and reports associated with

the Scheduler.

. Coordinated the interfacing and access to the PeopleSoft database by

external sources.

. Analyzed new security roles/permissions and change requests on the basis

of best practices. Met with users to analyze, document and define

requirements associated with new development or maintenance/enhancements

to existing security roles/permissions. Reviewed completed

roles/permissions with users to ensure requirements are fully met.

Performed production security issue resolution.

. In cooperation with infrastructure security, users and internal control

specialists assisted in the development of appropriate information

security policies, procedures, and mechanisms to support Peoplesoft

security change management.

. Developed and maintained documentation for audit compliance.

PROFESSIONAL EXPERIENCE

On contract at Opera Consulting, Houston, Texas

February 2010 to present

Staff Consultant

Duties and Responsibilities:

. Responsibility for monitoring, approving and applying all security,

upgrades, fixes and migrations.

. Resolve performance problems in all areas of the PeopleSoft Human Capital

Management and Campus Solutions implementation version 9.0

Accomplishments:

. Upgraded the PeopleSoft Human Capital Management and Campus Solutions

implementation from version 8.9 to version 9.0

Lonestar College System., The Woodlands, Texas

August 2009 to February 2010

PeopleSoft Applications Security Lead/ PeopleSoft Administrator/Oracle

Database Administrator

Duties and Responsibilities:

. Planned, designed and implemented security for PeopleSoft Enterprise and

Supply Chain Management 9.0.

. Led a team of 4 security analysts with no previous PeopleSoft security

knowledge.

. Worked with six financials functional module leads to design security for

their respective modules.

. Supported the Colleague (Datatel) to PeopleSoft Enterprise Financials and

Supply Chain Management 9.0 data migration team.

. Created, maintained and supported the implementation of the PeopleSoft

Enterprise Financials and Supply Chain Management 9.0 Training instance

for end-user training.

. Provided assistance to a team of Oracle consultants.

. Supported a team of go-live help desk personnel.

. Developed a security modification process.

. Performed required PeopleSoft Administration tasks in an Oracle 11g RAC,

Oracle Enterprise Manager 10.2.0.4, Oracle Enterprise Linux v5 x64bit, HP

ProLiant VMware servers, People Tools 8.49.21, BEA/Tuxedo 9.1 and

Weblogic 9.2 environment.

. Implemented a highly available PIA environment that includes a load

balancer, web cluster(2), application server cluster(4), and Oracle RAC.

. Identified and resolved production issues.

. Supported PeopleSoft functional team as needed.

Accomplishments:

. Led the security team to a successful implementation of security for over

8,000 named users across 16 implementing PeopleSoft Enterprise Financials

and Supply Chain Management 9.0 modules including eBill Payment,

eProcurement, eSettlements and eSupplier Connection.

. Mentored a team of 4 security analysts with no previous PeopleSoft

security knowledge.

. Mentored a team of 6 financials functional module leads with no previous

PeopleSoft security knowledge.

. Performed problem resolution of the production application server runaway

cpu and memory swap problem. Discovered that were not at the supported

Tuxedo 9.1 patch level.

. In a period of 4.5 months we successfully implemented an infrastructure

that other corporations have taken more than a year to implement. In

particular - Oracle RAC, RMAN, Oracle Grid Control, PeopleSoft plugin for

Grid control, Active Directory Integration with PeopleSoft, Implement the

ACE load balancer, SSL offloading to the Load Balancer, implement SSL for

the Active Directory integration, Finance and Portal security for the

whole organization, helped with configuring the enterprise Portal,

installation/configuration of the highly available PeopleSoft

architecture.

. A senior VP from Oracle informed us that this is the best Finance Go-Live

he has witnessed in

his many years - including both Higher Education and Business

implementations. They are most impressed that we accomplished this while

implementing such a broad suite of functionality (16 modules in Finance).

Talent Tree, Inc., Houston, Texas

May 2007 to March 2009

Database Administrator

Duties and Responsibilities:

. Administer and support strategic corporate business applications.

Corporate applications include PeopleSoft Financial 8.8.0, Human Capital

Management 8.8.0, Enterprise Staffing Front Office 8.8.0 and in-house

developed systems. These applications are used by or support 35,000

temporary associates and approximately 250 staff employees annually

through a network of over 65 offices in 23 states. These resources, as

well as strategic corporate partnerships, enable our 4,000 active clients

nationwide to increase staff productivity, concentrate on core

competencies and maximize financial efficiency.

. Administered over 70 Oracle instances across 7 unix (AIX, HP-UX and

Linux) servers.

. Identified and recommended application server, process scheduler, report

server and integration broker configuration changes to address production

issues.

Accomplishments:

. Was recognized as the 2008 Talent Tree, Inc. corporate "Above and Beyond"

employee of the year for enhancing PeopleSoft application performance.

. Performed analysis and recommended PeopleSoft best practices for the HP-

UX 11.0 HRMS 8.8.0 migration to AIX 5.3 using People Tools 8.49.06 on

Oracle 10.2.0.3.

. Installed and configured Oracle 10.2.0.3 and Oracle Enterprise Manager

10.2.0.3 on multiple AIX 5.3 servers.

. Performed analysis and recommended PeopleSoft best practices for the NT

SQL Server Financials 8.8.0 and Enterprise Staffing Front Office 8.8.0

migration to AIX 5.3 and Oracle 10.2.0.3.

. Performed analysis and recommended Oracle best practices for the disk

migration from HP internal disk to EMC CLARiiON CX3-20 disk management

system.

. Performed troubleshooting and resolved all issues on the Oracle

Financials 11i application.

. Created and supported the in-house developed Performance Management

Optimization (PXLSPMO) instance which has an internet facing access to

internal and external customers.

. Successful implementation of PeopleSoft HRMS 8.8.0 on AIX 5.3 using the

following PeopleSoft Internet Architecture: BEA/Tuxedo Version 9.1, 64-

bit, Patch Level 036, Oracle Application Server SOA Suite 10.1.3.1.0 -

J2EE Server and Web Server, Cobol Server Express 4.0 SP2, PeopleTools

8.49.06, and Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -

64bit.

. Installed and configured Oracle 9.2.0.7 on multiple HP-UX and AIX

servers.

. Successful upgrade of multiple HRMS 8.8 PeopleTools 8.43 instances on

separate new PIA homes from Oracle 8.1.7.4.0 to Oracle 9.2.0.7.

. Performed analysis of PeopleSoft HRMS production single sign-on issue and

successfully applied the tuxedo patch on production which eliminated

rogue cpu and memory processes. This fix revealed that the UNIX

resources were more than adequate for the current demand. Once we were

no longer cpu and memory bound I recommended that we use the unix

webserver to circumvent the single sign-on problems that occur when using

the windows webserver. Token authentication problems occurred when the

application traversed the unix and windows webserver.

. Performed analysis of PeopleSoft HRMS production application server hang-

up issue and recommended that since we now have available unix resources

we can increase the PSAPPSRV application server processes and increase

the PSAESRV process scheduler settings. The implementation of the

recommended configuration changes eliminated the application server

hangups.

On contract at Ron Obenhaus & Associates, Inc., Houston, Texas

Customer: Talent Tree Crystal, Inc., Houston, Texas

February 2007 to May 2007

IT Consultant (Oracle/PeopleSoft)

Duties and Responsibilities:

. Administered the PeopleSoft Financial 8.8.0, Human Capital Management

8.8.0 and Enterprise Staffing Front Office 8.8.0 systems.

Responsibilities included the monitoring, approving and applying all

upgrades, fixes and migrations.

. Was the resident guru in troubleshooting performance problems in all

areas of the PeopleSoft Financials, Human Capital Management and

Enterprise Staffing Front Office system.

. Monitored, identified and implemented index enhancements to ensure

maximum performance.

. Provide assistance to development staff for issues relating to

performance tuning and SQL creation.

. Tuned SQL statements found in SQRs, queries, application engine, COBOL

and nVision to maximize performance and thus reduce process execution

time.

. Responsible for the overall management and data integrity of the

PeopleSoft Financial, HRMS and Front Office database management system.

. Maintain a server environment that optimizes the efficient integration of

a variety of servers, including Application Servers, Webservers, Process

Schedulers and Report Servers.

. Monitor the Process Scheduler for efficient queuing and processing of

jobs; manage the regular clean up of logs, tables, and reports associated

with the Scheduler.

. Install PeopleSoft patches and fixes using the necessary tools (Data

Mover, etc.) and utilities.

. Coordinate the interfacing and access to the PeopleSoft database by

outside sources.

. Create database storage structures and objects.

. Allocate system storage and planning future storage requirements for the

database system.

. Modify the database structure.

. Control and monitor user access to the database.

. Backup and recover the database.

. Maintain system security.

. Monitor and optimize database performance.

. Monitor and maintain Net8 connectivity on servers and clients.

. Plan and implement the disaster recovery plan.

Accomplishments:

. Eliminated PeopleSoft Weblogic webserver port contention by creating a

separate domain configuration for each instance on both development and

production.

. Implemented the 2007 daylight savings time fixes on 8 HP-UX servers and 1

Linux server. The fixes were at all levels of the PeopleSoft

implementation (unix server (HP-UX 11), linux server (2.4.9), oracle

database (Version 7, 8i and 9i, Application version 8.8 and tools 8.45)

and JRE executables for the PeopleSoft application server and process

scheduler).

. Successfully migrated Oracle instances (Version 7, 8i and 9i) from HP

disk to EMC CLARiiON disk.

. Performed all tasks required of an Oracle DBA and PeopleSoft Technical

Administrator including change control, security, troubleshooting,

customization, debugging, upgrades and patch application.

On contract at Robert Half Technology, Houston, Texas

Customer: GLOBELEQ, Inc., Houston, Texas

January 2007 to February 2007

Technical Writer

Duties and Responsibilities:

. Researching, developing, planning, writing, and editing windows/network

administrator transition documentation. In essence performing a brain

drain on the exiting windows/network administrator.

. Write and update technical documentation, ensuring technical accuracy,

clarity, readability, and adherence to established GLOBELEQ, Inc style

standards.

. Work with information technology staff responsible for the execution of

the transition plan in order to understand and validate procedures to be

documented.

. Rewrite material and/or works with originator(s) to affect necessary

correction(s) and modifications.

. Review final product for physical presentation and intelligibility to

ensure quality of final product. Seek timely correction as appropriate.

Accomplishments:

. Wrote approved transition plan documentation for the information

technology personnel responsible for successful transition from the

exiting to the entering windows/network administrators.

. The global implementation essential services documented included Windows

2003 servers and workstations, WAN, VPN, CheckPoint Enterprise Pro

firewalls, Microsoft Exchange, Microsoft Identity Integration (MIIS)

servers, and Microsoft SharePoint.

. My Subject Matter Expertise was key in minimizing the time required by

the IT personnel. In addition, I was able to make recommendations and

address gaps.

. Rewrote documentation addressing the global (U.S., Panama, Egypt,

Singapore and London) end-user requirements. It involved everything from

Windows 2003 networking (Domain Controllers, Active Directory, DNS, DHCP,

WINS, DFS, Security, Group Policies, etc.) and desktop applications

(Exchange, Microsoft Office, etc.).

On contract at Robert Half Technology, Houston, Texas

Customer: Hewitt Associates, Inc., The Woodlands, Texas

January 2006 to February 2006

Client Security Administration

Duties and Responsibilities:

. Process all security requests for Bank of Montreal, Harris Bank, Nesbitt

Burns Bank, Unisys and McKesson.

. Manage tier 1 personnel. Create and maintain protocols for validation of

requests before requests are created in Siebel CRM.

. Receive and validate security requests via Siebel CRM. Validation

includes checking application request forms are approved, completed,

reasonable and appropriate.

. Process application request forms requesting access to PeopleSoft HRMS 7

and 8, Siebel CRM, Docent, Actuate, Web Intelligence, SkillSoft, UNIX

(user) and Oracle (user).

. Process all development access requests for the previously mentioned

environments.

. Document all pertinent process steps in Siebel ERM in order to provide

audit trails in anticipation of audit compliance verification.

. Perform monthly termination checks to ensure all terminated employees

user accounts have been removed.

. Process all requests within the documented service level agreements.

. Write client specific documentation for the processing of all application

requests.

Accomplishments:

. My extensive PeopleSoft, UNIX and Oracle knowledge was key in identifying

previously overlooked security gaps.

. Rewrote documentation addressing the client specific application request

form requirements.

On contract at Robert Half Technology, Houston, Texas

Customer: TOTAL E&P USA, Inc., Houston, Texas

August 2005 to September 2005

IT Consultant/Technical Writer/Subject Matter Expert (SME) in UNIX

Administration, Oracle Database Administration and Oracle Database Based

Applications

Duties and Responsibilities:

. Researching, developing, planning, writing, and editing Disaster Recovery

Procedures and Information Technology Instruction Manual documentation.

. Write and update technical documentation, ensuring technical accuracy,

clarity, readability, and adherence to established TOTAL E&P USA, Inc

style standards.

. Work with Information Technology staff responsible for the execution of

the Disaster Recovery Plan in order to understand and validate procedures

to be documented.

. Rewrite material and/or works with originator(s) to affect necessary

correction(s) and modifications.

. Review final product for physical presentation and intelligibility to

ensure quality of final product. Seek timely correction as appropriate.

. Provide Subject Matter Expert (SME) in UNIX Administration, Oracle

Database Administration and Oracle Database Based Applications to ensure

usefulness of documents.

Accomplishments:

. Wrote approved Disaster Recovery Procedures (DRP) for the Information

Technology (IT) personnel responsible for successful restoration of the

data center operations in the event of a disaster at the

TOTAL E&P USA, INC. offices in Houston, Texas.

. The DRP procedures addressed detailed responsibilities for the key

personnel and vendors (Caprock Communications, SAFESITE and SUNGARD).

. The recovery procedures were written in order to get the essential

business services up and running to manage the crisis without being

concerned about the non-essential services.

. The essential services documented included Sun Solaris 8 servers and

workstations, NetApp filers, StorageTek tape libraries, Oracle databases,

Legato Networker, Geoquest GeoFrame and Landmark Graphics Corporation The

Oilfield Workstation/client server (TOW/cs).

. My Subject Matter Expertise was key in minimizing the time required by

the IT personnel. In addition, I was able to make recommendations and

address gaps.

. Rewrote documentation addressing the end-user requirements. It involved

everything from Windows 2000 networking (Domain Controllers, Active

Directory, DNS, DHCP, WINS, Security, Group Policies, etc.) and desktop

applications (Notes, Microsoft Office, etc.).

Cared for terminally ill mother and mother in law

July 2002 to June 2005

Mariner Post-Acute Network Inc., Houston, Texas

March 1999 to May 2002

Manager of Database Administration

Duties and Responsibilities:

. Administered the PeopleSoft Financials and HRMS systems. Which included

the responsibility for monitoring, approving and applying all upgrades,

fixes and migrations.

. Was the resident guru in troubleshooting performance problems in all

areas of the PeopleSoft HRMS and Financials system.

. Monitored, identified and implemented index enhancements to ensure

maximum performance.

. Provide assistance to development staff for issues relating to

performance tuning and SQL creation.

. Tuned SQL statements found in SQRs, queries, application engine, COBOL

and nVision to maximize performance and thus reduce process execution

time.

. Responsible for the overall management and data integrity of the

PeopleSoft Financial and HRMS database management system.

. Maintain a server environment that optimizes the efficient integration of

a variety of servers, including Application Servers, Web Logic Servers

and Report Servers.

. Monitor the Process Scheduler for efficient queuing and processing of

jobs; manage the regular clean up of logs, tables, and reports associated

with the Scheduler.

. Install PeopleSoft patches and fixes using the necessary tools (Data

Mover, etc.) and utilities.

. Coordinate the interfacing and access to the PeopleSoft database by

outside vendors.

. Create database storage structures and objects.

. Allocate system storage and planning future storage requirements for the

database system.

. Modify the database structure.

. Control and monitor user access to the database.

. Backup and recover the database.

. Maintain system security.

. Monitor and optimize database performance.

. Monitor and maintain Net8 connectivity on servers and clients.

. Plan and implement the disaster recovery plan.

Accomplishments:

. Implemented all components of the PeopleSoft 8 Internet Architecture in

preparation for the HRMS and Financials upgrade. The PeopleSoft 8

environment is being used for in- house application development.

. Successfully transitioned from a legacy payroll/financials system to an

enterprise deployment of PeopleSoft HRMS and Financials running on an

Oracle 8i RDMS and HP-UX version 11 on a HP N-Class Server connected to

an EMC2 Symmetrix disk array.

. The PeopleSoft HRMS system processes payroll checks for over 65,000

employees and is currently accessed by 453 facilities. It is currently

accessed by over 1,000 users.

. The PeopleSoft Financials system processes financial data for 653

business units and is currently accessed by 453 facilities. It is

currently accessed by over 1,200 employees.

. Migrated various legacy systems from acquired companies running on an IBM

SP2 system. These system applications included Medic, Achieve, Mestamed

and Lawson financials.

. Supported seven production databases and thirty support and legacy

databases on seven servers.

. Performed all tasks required of a DBA and PeopleSoft Technical

Administrator including change control, security, troubleshooting,

customization, debugging, upgrades and patch application.

. Technical lead in helping Mariner Post-Acute Network achieve 342nd

ranking in the Information Week's 500 in September of 2001.

Petroleum Geo Services Inc., Houston, Texas

March 1998 to February 1999

Database Administrator

Duties and Responsibilities:

. Responsible for the overall management and data integrity of the

PeopleSoft Financial and HRMS database management system.

. Monitor the Process Scheduler for efficient queuing and processing of

jobs; manage the regular clean up of logs, tables, and reports associated

with the Scheduler.

. Provide assistance to development staff for issues relating to

performance tuning and SQL creation.

. Install PeopleSoft patches and fixes using the necessary tools and

utilities.

. Tune SQL statements found in the reporting utilities SQRs, queries, and

nVision.

. Create database storage structures and objects.

. Allocate system storage and planning future storage requirements for the

database system.

. Modify the database structure.

. Control and monitor user access to the database.

. Backup and recover the database.

. Maintain system security.

. Monitor and optimize database performance.

. Monitor and maintain Net8 connectivity on servers and clients.

. Plan and implement the disaster recovery plan.

Accomplishments:

. Implementation of PeopleSoft Financials 7.5 on a worldwide basis.

. Supported an implementation staff of over 40 people.

. Implemented and supported all tiers (application server, file server,

report server, database server and clients).

. Performed all tasks required of a DBA and PeopleSoft Technical

Administrator including security, troubleshooting, customization,

debugging, upgrades and patch application.

INTOOL Inc., Houston, Texas (a subsidiary of Global Industrial

Technologies)

July 1991 to March 1998

Database Administrator/IT Analyst

Duties and Responsibilities:

. Conduct and coordinate the analysis, design and implementation of

computer-based information systems to meet user requirements.

. Leader in systems software development and maintenance.

. Effectively interface with designated employees in all departments to

ensure that the design and implementation of application programs is

consistent with department and company goals.

. Conduct full range of programming tasks including program design, coding,

testing, debugging and documentation for a variety of applications

programs and develops programs of a non-routine nature.

. Support applications by the creation, modification and enhancement of

PL/SQL procedures, functions, triggers and packages.

. Provide assistance to development staff for issues relating to

performance tuning and SQL creation.

. Tune SQL statements found in the reporting utilities SQRs, queries, and

nVision.

. Create database storage structures and objects.

. Allocate system storage and planning future storage requirements for the

database system.

. Modify the database structure.

. Control and monitor user access to the database.

. Backup and recover the database.

. Maintain system security.

. Monitor and optimize database performance.

. Monitor and maintain Net8 connectivity on servers and clients.

. Plan and implement the disaster recovery plan.

Accomplishments:

. Conversion of CICS based HR system to PeopleSoft HR 6.0.

. Conversion of mainframe system to Pivot Point's Point.Man Client/Server

ERP software.

. Implementation Team Leader with responsibilities in the areas of sales

orders, marketing, customer service, manufacturing, ISO 9001 compliance

and electronic commerce.

. ISO 9001 Internal Quality Auditor.

. Technical lead in helping Dresser Industries achieve top ranking in the

Computer World's Premier 100 in September of 1992.

. Performed database functions to facilitate the integration of PeopleSoft

(Human Resources), Getpaid (Credit & Collections), AltC (MRP forecasting)

and ShopVue (shop floor data collection).

. Performed analysis and coding for the gage calibration system that was

key in INTOOL's ISO 9001 certification.

Farah USA, Inc. El Paso, Texas

June 1989 to July 1991

Systems Analyst

Accomplishments:

. Performed analysis for converting HP 3000 IMAGE database manufacturing

engineering system to IBM 4381 VSAM file structure system.

. Performed analysis for the restructuring of Universal Product Code

assignment, maintenance, and transmission to electronic catalog process,

which contributed to the creation of the Model Stock System and the Sales

Force Order Entry System (used on laptop computers operated by Farah's

nationwide sales force).

El Paso Housing Authority, El Paso, Texas

February 1988 to June 1989

Programmer/Analyst

Accomplishments:

. Enabled transition from software vendor dependence to in-house

improvement and development of software.

. Designed and controlled the use of data structures, procedures,

backup/recovery and security.

EDUCATION

B.B.A Computer Information Systems from the University of Texas at El Paso

COMPUTER SKILLS

LANGUAGES

. Oracle 11g (11.1.0.7)PL/SQL, PeopleTools 8.49, SQR 8.49, COBOL Server

Express 4.0 SP2, PeopleSoft Tools 8.49.21(Data Mover, Change Assistant,

Apache, BEA Weblogic 9.2, Oracle Application Server SOA Suite 10.1.3.1.0,

BEA Tuxedo/Jolt 9.1, Query, EDI, nVision, Application Engine, Security

and PeopleCode), Legato Networker, Crystal, SQL Windows, Object Oriented

Programming, Erwin Data Modeling and Informix

. MVS COBOL and CICS.

DATABASES

. Oracle 11.1.0.7 RAC, Oracle Enterprise Manager 10.2.0.4, Oracle 10.2.0.3

64 bit, Oracle 9.2.0.7 64 bit, Oracle 8.1.7.4 64 bit, SQL Server,

Informix, SQL Base, Access, Approach

OPERATING SYSTEMS

. Oracle Enterprise Linux v5 x64bit, HP-UX 11.11, AIX 5.3, Linux 2.4.9,

Sun Solaris 8, UNIX SVR4 and Windows (2008, XP, 2003, NT, 98, and 95)

HARDWARE

. HP ProLiant VMware servers, IBM P-550, HP 9000 N Class, Sun V880, NetApp

Filer Disk Storage, STORAGETEK Tape Libraries, EMC2 Symmetrix and

CLARiiON disk management systems, NCR and IBM mainframe

Contact this candidate