SUMMARY

• Formerly, a Senior Principal Consultant with middle - tier system integrator, team member and major contributor on 12 PeopleSoft implementations HCM, CRM, EPM and FSM. An analytical, disciplined, productive and accomplished Project Manager / Senior Technical Architect / System Integrator / Oracle - PeopleSoft DBA with extensive experience in Project Management and infrastructure.
• Performed major tools and application upgrade. Experience includes PeopleSoft versions 5.0X through 9.0. Industry experience includes Education, Non-Profit, Retail Banking, Health Care, Telecommunications Services, Media and Pharmaceuticals.
• Seasoned Oracle Database Administrator, business process innovator and systems integrator with extensive hands-on experience and project management experience across the full IT systems life cycle encompassing visioning, planning, execution and support.
• Proven track record in ERP (PeopleSoft), CRM (Siebel), OSS (TBS), Telecom Billing (Billplex) and in-house development initiatives.

TECHNICAL SKILLS

Hardware: Sun-Fire-V445, Netra-T12, Sun-Fire-V240, Sun-Fire-480R,ULTRA Enterprise - E4000/E3000/E4500, E10K, SPARCserver-1000E, SPARCUltra2, Sun RSM2000 Disk Arrays, IBM/RS6000, DLT Tape Storage devices from Legato, 8mm Tape Storage Libraries

Operating Systems: Solaris 6.x, HP UNIX, IBM/AIX, MS-DOS UNIX AIX 5.x / 4.3.x / 4.2.x, UNIX SVR3.2 and SVR4, HP-UX, Red Hat Linux 6.x,7.x,8.x, Windows NT/95/98/XP, Windows 2000 Server, OS/2, VAX/VMS, MVS/XA, NETWARE 4.1/5.x

ERP: PeopleSoft EPM, PeopleSoft Financials V9.0/V8.x/V7.x/V6.x, PeopleSoft HCM, Payroll, Benefits, T&L V9.0/V8.x/V7.x/V6.x, CRM 8.0, Oracle Financials 10.7

Data Archiving Tools: IBM Optim

Data Privacy Tool: IBM Optim

Languages: PeopleTools V8.49/V7.x/V 6.x, PeopleCode, Application Engine, HTML, Javascript, Sql*Plus, PL/SQL

RDBMS: Oracle 10G and lower, MS SQL Server 2000, and Microsoft Access2000

Tools: TOAD 8.0, Oracle Enterprise Manager, Platinum DB Vision, Microsoft SQL server Enterprise Manager, Desktop DBA, SQLSPY, SQLLAB.

DB Monitoring Tools: Quest Monitoring Suite - Foglight, SpotLight, SQL Xpert, Space Manager,SQLab, TSReorg, Enterprise Manager, Source Safe

Middleware: Bea Tuxedo/Jolt, Cognos, ODBC,LDAP, Oracle Application server, PeopleSoft Application Messaging, Mercator

WebServers: IBM WebSphere 6.0, BEA WebLogic, Apache, IIS, PWS

Reporting & Distribution Tools: Brio, Cognos, Convoy, Crystal, SQR

Version Control Software: PVCS, Quest STAT

Job Schedulers: Tivoli Maestro, Autosys

Project Management: Plainview, MS Project

OSS: Telecom Business Solution

Connectors: Vitria/Siebel

Telco Billing: Daleen-Billplex

CRM: Siebel eCommunication 99.6/2000

PROFESSIONAL EXPERIENCE

Confidential

Manager IT

Responsibilities:

• Led E9.0 upgrade, deployed into production in January 2012
• Managed CNC administrators project plans and tasks list
• Installed and configured Weblogic 11g, SOA and BSSV
• Provided backup for primary CNC administrator
• Conducted status meeting and compiled status reports for stake holders during upgrade
• Liaison between infrastructure service provider, Database Management service group in getting tasks done as scheduled in the upgrade plan
• Technical lead for the upgrade

Senior Systems Architect

Confidential

Responsibilities:

• Installed and configured IBM Optim application for PeopleSoft Financials archiving
• Installed and configured IBM Optim application for HCM Data Privacy
• Technical Lead for PeopleSoft Financials upgrade from 8.4 to 9.0
• Leading 3 other administers in the group
• Performed SQL tuning of Application Engine data conversion scripts, fine-tuned the Change Assistant steps.
• Supported upgrade team in troubleshooting PeopleCode, Security, including all general upgrade issues
• Lead the Test Moves to Production and the Move to Production
• Tools upgrade from 8.44.16 to 8.47.15
• Applying Tax updates to HCM Databases
• Lead PeopleSoft Financials Archiving project
• Deploy PeopleSoft releases into production on a quarterly basis
• Configuring new PeopleSoft environments
• Providing leadership for PeopleSoft Infrastructure, Engineering and Operate and Maintain groups
• Established PeopleSoft Software Migration group to operate and maintain, deployment of FDM/HCM/EPM/CRM software changes
• Install/Upgrade & configure nTier PeopleSoft environments
• Responsible for administering 18 Oracle/PeopleSoft Environments ( QA, Stage, Training, Production)
• Support System testing, Stress testing effort
• Performed capacity planning for creating production databases
• Administered Performance testing with a user base of 5000
• Working with Application Testers to tune long running processes
• Responsible for implementing Change Control Management and Migration procedures

Confidential

PeopleSoft Architect/DBA, HR, Benefits, Payroll

Responsibilities:

• Responsible for administering 10 Oracle databases ( Demo, Development, Quality Assurance, Test, Production for PeopleSoft HRMS)
• Created infrastructure strategy, Database Capacity Planning.
• Administered Performance Testing
• Prepared test bed for performance testing
• Executed performance testing on HR and Payroll modules with a user population of 200
• Configured and administered Stress Test
• Developed Instance strategy, application standards, implementing customizations, identified interfaces and bridges.
• Responsible for implementing Change Control Management and Migration

Confidential

Project Manager/Oracle DBA, PeopleSoft Financials/HRMS upgrade Project

Responsibilities:

• Managed a Team of 10 Consultants and 5 client employees to upgrade PeopleSoft Financials 7.51 to 8.0 SP3, EPM and Upgrade HRMS 7.52 to 8.3
• Installed and Configured PeopleSoft Financials 8.0, HRMS 8.3
• Responsible for internal and external audit of the project
• Provided a Data archiving strategy for archiving GL & AP transaction data
• Managed Financials and HRMS upgrade Project Plan
• Allocated resources and assigned tasks
• Conducted Status Meetings, Steering committee meetings to update status of the project
• Worked along with DBA's in running upgrade assistant tasks
• Created different databases required for upgrade
• Performed capacity planning for building out production environment
• Performed extensive performance tuning post upgrade (Web Server, Database, Application)
• Installed and configured Financials 8 SP 3 and HRMS 8.3 applications and Demo databases
• Established Changed Control, System Testing, Patch applying Policy, Software Configuring Management procedures

Confidential

Enterprise Systems DBA

Responsibilities:

• Upgrade PeopleSoft HRMS/Financials from Version 7.51, 7.52 to Version 8.0 Service Pack 1 using upgrade assistant.
• Implemented archiving solutions for archiving GL and Asset Management data
• Planned and managed upgrade project plans which included assessment, construction and deployment.
• Installed and configured PeopleSoft 7.5/8.0 Financials and HRMS 7.5/8.0 using the PeopleSoft Physical 3-tier architecture. Currently supporting 10 PeopleSoft databases. Installation, configuration and maintenance of client, middle tier and back end components of PeopleSoft application.
• Sizing and configuration of Sun E4500 Servers with A1000 storage arrays for PeopleSoft, Billplex, TBS applications.
• Installed and Configured PeopleSoft CRM and performed package evaluation
• Performed Fit/Gap analysis for PeopleSoft CRM and presented the findings to evaluation committee
• Managing ESPs and subcontracted resources.
• Assisting in defining Confidential ’s enterprise systems architecture to enable the full Telco supply chain across product development, order fulfillment, provisioning, billing and customer service. (eCRM/Commerce, CRM, OSS, BI and ERP).
• Interact with PeopleSoft Global Support Center (GSC) to resolve problems, research and download patches from PeopleSoft site and apply patches, test and migrate to production.
• Perform data conversion, data loads and customized development work (changes to delivered PeopleSoft panels, records, etc.) as new PeopleSoft modules are implemented. Perform minor and major application and PeopleTools upgrades.
• Perform database administration tasks for the Oracle relational database management system (RDBMS): define, create, and maintain Oracle databases, establish and maintain database backup and recovery procedures to support point-in-time recovery, migrate and refresh databases between the development and production environments, support the use of database import/export and load utilities.
• Responsible for setting up web servers for accessing the PeopleSoft HRMS and Financial databases using the web browser.
• Tune and troubleshoot application issues related to JOLT
• Install and configure Siebel eCommunication software. Provided support in upgrading Siebel Communications 99.6 to Siebel eCommunications 2000.
• Installed Application Siebel servers, mobile and thin client installations. Mobile client Database extraction, synchronization.
• Performed data loads using EIM and SQL loader.
• Installed and configured Daleen Billplex, OSS-Telecom Business Solution (TBS) software
• Administered Performance Testing, created test bed, documented results
• Administering Development/Test/Production TBS and Billplex database.
• Provide support in integrating of all application components, new and legacy, across Confidential ’s systems environment via Vitria’s EAI middleware platform as well as point-to-point batch interfaces.

Confidential

Senior Principal Consultant

Responsibilities:

• As a Technical Team Lead successfully implemented PeopleSoft HRMS 7.0 and migrated Oracle Databases from 7.3.4 to 8.0.5 on SUN E10K.
• Created infrastructure, capacity planning for production databases
• Creation and Maintenance of multiple development environments for Design and Construction stages
• Ongoing administration of development environments, including object migration, updates / patches / fixes, and security
• Performed Stress Test for PeopleSoft Payroll
• Presented a Archiving Strategy for archiving Personal, Job and Employment data
• Managed technical resources for data conversion and PeopleSoft modifications.
• Database maintenance through PeopleSoft tools (DDDAUDIT & SYSAUDIT etc)
• Database growth forecasting and capacity planning using sizing scripts and PeopleSoft tools.
• Database performance monitoring, tuning and error analysis using Trace & PeopleSoft Logs
• Provide Systems Development group with expertise on PeopleSoft’s logical database configuration
• Designed, Developed and implemented the database backup and recovery procedures and scripts
• Created and maintained multiple databases (Demo, Development, Integration, System Test and Production)
• Administer Oracle Application 10.7 (GL, PO, AP, INV, PAS & FA) databases. Refreshed QA databases with Production on a regular basis. Applied Oracle patches to correct application abnormalities.