SUMMARY

PeopleSoft/Oracle Architect and Certified Oracle DBA with over fifteen years experience implementing/upgrading/supporting ERP solutions for numerous organizations including telecom, financial, banking, private and government sectors.

• Skilled in PeopleSoft architecture and administration, PeopleSoft Oracle SOA, PeopleTools, Web technologies and database administration of Oracle, DB2 and MS SQL Server.
• Experienced installing, upgrading and supporting PeopleSoft Financials core modules plus others , HRMS, EPM, CIS/RMS, CS, ELM, Portal and CRM versions 7,7.5, 8.8, 8.9, 9.0 and 9.1. Experienced installing and upgrading EPM servers for interactive reporting to provide forecasting and dashboard reporting capabilities. Extensive development and administration experience with ETL Data Stage tools.
• Senior consulting experience representing PricewaterhouseCoopers/IBM Consulting and BearingPoint, Inc. in multiple roles including Technical Lead/Manger, PeopleSoft Administrator/DBA/Developer and Technical Architect on over twenty PeopleSoft initiatives.
• As Senior Architect for PWC/IBM and BearingPoint, assessed PeopleSoft architecture and presented documented assessment, hardware/software requirements, and priority of recommendations for various clients.
• Provided documentation, training and mentoring in the area of PeopleSoft applications and database management, as well as technical production support.
• Skilled at working with all organizational levels including stakeholders, functional users, managers, developers, sales, and executives. Experienced creating and delivering presentations.
• Education includes Bachelor of Science in Computers and Mathematics and studying towards Master of Science in Mathematics.

General

• I troubleshoot and resolve most difficult issues a chaotic office and lower the panic and stress levels for my clients and their employees.
• I have over 15 years of experience in IT consulting with demonstrated abilities as a Programmer, System Analyst, Architect, DBA and Project Lead
• I have expertise in all major releases of PeopleSoft / Oracle implementation and upgrades
• I have extensive Project Management skills
• I have extensive experience in Oracle PeopleSoft and SOA technology
• I have extensive experience dealing with Sarbanes-Oxley
• I have expertise in tuning PeopleSoft / Oracle applications
• I have extensive development experience using Application Designer , Application Engine , SQR, Data Stage and ETLs
• I have extensive experience working with SQL Server 2000, 2005, 2008
• I have extensive experience working with Oracle 11g/ 10g RAC/ 9i / 8i environments
• I have working knowledge of ASP model

EXPERIENCE - LONG TERM PROJECTS / FULL TIME JOBS

Confidential

PeopleSoft Technical Lead Architect / DBA

• Defined pMQ Series integration for inbound and outbound interfaces.
• Setup Financial Gateway for external integration with US banks via Integration Broker.
• Setup Web Services and configured WSDL integration with 3rd parties.
• Configured Workflow and setup Blackberry integration with PeopleSoft workflow process.
• Resolved various OS conflict issues with nVision/ Crystal running on Win 2008SP2 64bit
• Dealt with specific issues related to Windows running on VM and AIX LPARs.
• Setup LDAP for PeopleSoft, configured special application security required by the client
• Served as a technical contact to resolve most technical defects and support issues related to implementation project in various environments.
• Mentored Clients DBAs/ Developers/ PS Admin / Security staff on PeopleSoft standards and methodologies.

Confidential

Oracle Architect/DBA

• Oracle architect on Oracle Apps implementation and support projects within the organization.
• DBA support for Siebel and OBIEE implementations
• On-going DBA support as needed
• Database creation, Backup Recovery, Performance tuning, Storage management, Schema management, Adherence to OFA standards, and Quest Tools
• Installed and Configured Oracle Grid and linked all prod and dev/test databases
• Setup company wide database workflow and notification processes.

Confidential

Technical Lead Architect PeopleSoft 9.0 FIN Re-Implementation

• Architected and designed technical infrastructure for the Republic global Financial Re-Implementation project.
• Developed and executed conversion from PeopleSoft 7.5 DB2 legacy system data to PeopleSoft FIN 9.0 on SQL Server 2008.
• Architected the high availability and failover infrastructure of PeopleSoft at Republic
• Supported PeopleSoft implementation/integration/migration including database administration support and application support and responsible for overall management of databases and data integrity of the PeopleSoft Financials databases
• Solely configured all the web servers, application servers and database layer for Production, Reporting, Test and Development environments
• Installed and Setup PeopleSoft FIN 9.0, PeopleBooks, Weblogic, Tuxedo App Server using MS SQL Server Database 2008
• Worked with the users on the Production issues, relating to process tuning, Application Server tuning, Process scheduler automation
• Provided PeopleSoft administration for production, DEV, TEST and staging environments.
• Defined tuning options for Application servers Tuxedo and Weblogic web servers
• Involved in increasing the performance for overall system with database, application and server tuning.
• Performed analysis, traced and debugged processes, which were running slow. Took necessary action to improve performance.
• Involved in Web Server, Application Server configuration and set the parameters to obtain optimum performance.
• Redesigned/enhanced many delivered processes such as file attachments functionality, GL Workflow and other.

Lead PeopleSoft Architect

Confidential

• Primary PeopleSoft Architect and Oracle database administrator in implementation of Global PeopleSoft ELM 9.0 system that reside on multiple environments configured in virtual n-tier architecture for development, test and production. Oracle 10g RAC.
• Configured Application Server / Process Scheduler / Web server domains and perform tuning and load balancing as necessary
• Configured SCORM/AICC content in a PeopleSoft ELM v9.0 environment
• Responsible for Messaging Integration between ELM9.0 and HRMS 8.8 and performance tuning of all conversion /EIP jobs and application engines. Improved performance of many delivered Oracle/PeopleSoft processes and provided Oracle with resolutions which will be included in subsequent bundles/patches for other clients that are experiencing the same issues.
• Resolved current database performance issues and created plan for future growth in databases capacity planning including hardware/software.
• Created and implement Disaster-Recovery strategies
• Developed standard configuration procedures for PeopleSoft application and Oracle RDBMS installation and documented in SDD.
• Resolved on-going performance issues with SQL statements using Indexes, optimizers and using hints in SQL statements
• Performed system maintenance including disk space management maintain backup, restore procedures.
• Installed and configured Secure Socket Layer SSL certificates for weblogic 8.1
• Installed and configured Oracle 11g database, applied latest patches

Snelling Staffing Services

Confidential

• Architected and executed conversion process to move legacy system data from PeopleSoft 7 to 8.9.
• Setup Integration Broker, developed custom messages between Portal FIN and HR
• Developed Office Locator custom application for PS Portal and integrated it with FIN and HR
• Provided technical support for HRMS 8.9 and Portal 8.9 applications.
• Provided quick turnaround solutions for the client in some of the key business aspects such as billing, stuffing by re-engineering the process.
• Customized PeopleSoft objects as necessary using Application Designer , PeopleCode, SQR , etc

Technical Architect / PeopleSoft Administrator/ Oracle DBA / Developer/ Upgrader

Confidential

• As the Technical lead/PeopleSoft DBA, completed major upgrade for PeopleSoft Financials from 8.0 to 8.9 AR, BI, GL, AP, PO, AM, EX, PO, OM .
• Upgraded PeopleSoft HRMS from 8.8 to 8.8SP1 MP4 and applied 2005/2006 Tax Updates. Upgraded PeopleSoft Tools from 8.45 to 8.46 /8.47 version.
• Configured single signon across all PeopleSoft applications including PORTAL
• Installed and upgraded CRM from 8.0 to 8.9 version on PT 8.46
• Installed and configured PeopleSoft EPM v8.9 applications. Applied MP4 to all EPM environments. Installed and upgraded BAM servers for interactive reporting.
• Install /Configure and implemented PeopleSoft EPM 8.9 with Ascential DataStage 7.5 for on Window and UNIX servers. Loaded and executed all Ascential ETL's for FSCM and HRMS data marts. Customized ETL's as needed.
• Optimized and tuned all PeopleSoft client applications FIN, CRM , EPM, HRMS and PORTAL .
• Installed and configured Business Objects dimension reporting tool for EPM. Configured Business Objects LDAP.
• Provided support for the existing CRM 8SP1 / HRMS 8.8 and Portal 8.8 applications.
• Customized PeopleSoft objects as necessary using Application Designer , PeopleCode, SQR , etc
• Managed all technical aspects of the upgrade projects including designing the technical architecture, running the conversion scripts using the change/upgrade assistant, managing all the development activities, performing PeopleTools upgrades, and setting up the Weblogic web application server, PIA, Tuxedo Application Server, and Oracle 9i databases on UNIX platform.
• Confidential Sr. Technical Architect Team Lead
• Served as Technical Lead / PeopleSoft DBA on upgrade of PeopleSoft Financial all modules from 8SP1 to 8.4SP1 and PeopleSoft EPM 8.8 Data mart , Warehouse
• Migrated customizations, applied patches, and performed other DBA functions using Oracle 9i database.
• Upgraded PeopleSoft tools from 8.43.10 to 8.45.14
• Setup Weblogic web application server, PIA, Tuxedo Application Server, and Oracle databases on Solaris UNIX platform.
• Installed/configured Oracle databases
• Applied database and application patches
• Provided extensive tuning of the application engines such as PC PRICING, EX TO PC and others
• Performed database cloning on different environments
• Created and maintained Standby database using Oracle Data Guard.
• Administered Microsrategy and Informatica applications.
• Administered the Informatica server and ETL tools
• Installed / Administered ControlM /BMC scheduling systems
• Administered Citrix and UNIX Servers.
• Developed and configured archiving strategy to archive project data. Implemented solution.
• Configured LDAP
• Managed the team of four DBA's
• Provided technical support for clients running Oracle Financials eBusiness Suite11

Confidential Principal Consultant

• Served as PeopleSoft Administrator/Oracle DBA, Architect, Upgrade Specialist, and Installer for several clients including XL Capital Inc, GM and other
• Worked with HRMS and FDM modules from 7 to 8 on various platforms including Oracle, Solaris, HP-UX, AIX, NT, and Citrix
• Upgraded AP/GL modules from 7.5 to 8.0 to 8.4 on Oracle 8i/Solaris 2.8 platform
• Provided PeopleSoft administration and DBA services on a global implementation of PeopleSoft Financials and EPM for XL Capital and HRMS for GM General Motors
• Was responsible for configuring, tuning, and administering the Oracle 8i databases and Tuxedo application servers running on Sun Solaris and Unix HP platforms
• Established development standards, database instance strategy, and data migration procedures
• Serving as the focal contact for all technical issues and provided knowledge transfer to other PWC consultants
• Installed and configuring the Citrix MetaFrame solution for WAN access and set up the SharePlex software to allow real-time replication of the production database to a reporting server
• Performed extensive Oracle, SQR, and application engine tuning to improve the performance of the AP/GL/HRMS modules
• Established standards and procedures for PeopleSoft data management and development
• Migrated customizations, applied patches, and performed other DBA functions
• Worked in assignments involving software installations, Tuxedo application server setup and tuning, upgrades, performance tuning of the application and database

Confidential Team Lead / Sr. Programmer Analyst

• Was responsible for full support of book/page production systems, management and schedule of Jr. programmers
• Designed, coded and supported unique scheduling system for GTE directories using PowerBuilder
• Provided daily ongoing customization and support on a 24-hour basis
• Coordinated software migration and testing between several applications
• Performed risk factors analysis and disaster recovery planning
• Developed and maintained the logical data model and database structures needed to support the scope of the Oracle project within the organization
• Created and optimized the physical model, data security as well as implementing backup and recovery procedures
• Performed data storage management, PL/SQL and Pro C programming and day-to-day database maintenance
• Coordinated, tested and supported problem resolution
• Established policies and procedures for change control, data management, and setting guidelines and standards for development
• Performed database administration functions for the Oracle 7 databases
• Performed modifications and enhancements of all White Pages conversion programs to migrate data

EXPERIENCE - SHORT TERM PROJECTS

PeopleSoft HR / FIN

Confidential

• Applying MPs/bundles to both Financial and HRMS systems
• Training WSD stuff on patch application process
• Created documentations, provided client with the list of recommendations
• Configured pass through LDAP

Confidential

PeopleSoft HR database Tuning

• PeopleSoft HRMS tuning of production system
• Improving nightly batch cycle by 20-30
• Training ERS stuff on new features of oracle and peoplesoft
• Created documentations, provided client with the list of recommendations
• Advised client on how to implement solutions

Confidential

PeopleSoft consultant

• Applied HR tax updates / Maintenance packs
• Develop custom interfaces with 3rd party application.
• Design and develop Cigna Interfaces

Confidential

PeopleSoft Administrator/ DBA/ Technical Architect / Developer

• Responsible for Database Administration, Development, Upgrade and support of front-end
• Systems for CIS, HR and FIN in the organization.
• Upgraded PeopleSoft Financial System from version 8.4 to 9.0 on PT 8.48.13, applied latest MP5.
• Upgraded PeopleSoft CIS from version 7.6 to 8.95 RM using PeopleTools 8.46
• Upgraded PeopleTools to version 8.48 for HCM 8.8
• Trained Client Developers and DBA's
• Provided tuning recommendations and implemented solutions to improve system performance.
• Installed Oracle 10.2.0.2/ Setup OEM and upgraded all client databases
• Upgraded all client Oracle databases from 9.2 to 10.2.0.2 to 11G
• Applied PS and Oracle patches as needed
• Managed all clients SUN / Solaris Servers / Windows 2003 and Databases environments
• Provided production technical support for all client's PeopleSoft applications HR, FIN, ERM
• Performed database refreshes as needed
• Setup Integration broker and configured messages between HR / FIN

Confidential

Oracle / Siebel Technical Lead/DBA

• Provided technical support for Siebel 8 implementation and post go live production support.
• Installed and configured Oracle 10g database, applied latest patches
• Configured Oracle 10g Grid environment
• Performed extensive performance tuning for Siebel Application online and batch processes.

GlaxoSmithKline

Confidential

• Analyzed Global PS HR 8.9 Infrastructure environment and recommended changes that have improved overall system performance.
• Recommended the sizing for the GPS International Australia Production PeopleSoft instance.
• Performed extensive Application Engines tuning to process over 10,000 messages to MQ Series on the daily basis.
• Tuned and improved overall HR system performance by over 50 .

Holocaust Museum

Confidential

• Installed PeopleSoft Financial 8.9 / PT 8.48 on SQL Server 2005.
• Setup Web Server / Apps Server / Process Scheduler.
• Installed and configured Oracle 11g
• Lead Architect on FIN PeopleSoft 9.0/PT8.49 re-implementation, conversion.

Confidential

PeopleSoft Administrator / Tuner

• Optimized and tuned Tuition calculation program for Student Admin PeopleSoft application.
• Performed overall SQL Server 2005 Database tuning
• Created documentations, provided client with the list of recommendations
• Trained client's DBA

Confidential

PeopleSoft HR database Tuning

• Extensive Oracle / PeopleSoft Tuning for HRMS GM production system
• Created documentations, provided client with the list of recommendations
• Advised client on how to implement solutions

SKILLS

• PeopleSoft Application Implementation, Project management skills
• Operating System: Windows, VAX/VMS, Sun Solaris 2.x, Citrix, HP-UX, AIX, Red Hat Linux
• Software: PeopleSoft FIN, CRM, PORTAL, HRMS, EPM , nVision, SQR, Crystal Reports, MS Office
• Languages: C, C , Pro C, PL/SQL, SQL, PowerBuilder, Unix Shell Script, Assembler, Pascal, Fortran, LISP, Cobol, Pro Cobol, Prolog, Basic, PeopleCode
• RDBMS: Oracle 11.x/10.x/9.x/8.x/7.x, SQL Server 2000/2005/2008
• Tools: BMC ControlM, PeopleTools PS Query, Application Engine, Application Designer, Data Mover , SQA Robot, Lotus Notes, Tuxedo, Oracle Enterprise Manager, Maestro, ControlM, Remedy, Informatica, SharePlex, SQL Navigator, Reflection, Norton Leveraged Packages