We provide IT Staff Augmentation Services!

Consultant Ps Admin/upgrade Specialist/oracle Db Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Accomplished Consultant/IT Executive with hands on experience combining technical and business solutions to support overall corporate strategic growth specifically in Identity and Access Management.
  • Effective leading teams and leveraging operations and technology that consistently meet and exceed business objectives.
  • Extensive technical knowledge and track record of success and strong hands on skills.
  • Project Management - Onsite & Offshore Teams for Confidential
  • Oracle/PeopleSoft ERP Implementation and Upgrades FSCM 9.2 & HCM 9.2
  • Deployed entire PeopleSoft instance to Oracle Cloud.
  • Overall Technical Architecture Strategies Design/Implement
  • Strong Data Base Performance Tuning experience Oracle 11g, 12c PeopleSoft 5.0 thru 9.2
  • Team Leadership & Effectiveness
  • Hands on PeopleCode, App Engine, Integration Broker, CI, Approval Work Flow Engine
  • Strong skills PeopleSoft Financials Reporting using nVision, BI Publisher, SQR and crystal.
  • Client Relations Proposals and Orals presentations
  • Enterprise Portals (Interaction Hub)
  • Identity and Access Management LDAP, SSO Integration with PeopleSoft Portal Security
  • Design and setup PeopleSoft Security - Roles/permission lists/Single Signon/Signon Peoplecode
  • Thorough understanding of PeopleSoft Technical Architecture and data model.

TECHNICAL SKILLS:

  • Oracle Exalogic Cloud and ExaData Cloud
  • PeopleSoft FSCM 9.2
  • HRMS 9.2
  • People Tools 8.55
  • PeopleCode
  • SQR
  • Crystal Reports
  • BI Publisher
  • XML Publisher n-vision
  • Application Engine
  • Micro focus COBOL
  • Application Server Tuxedo
  • Process Scheduler
  • Web server
  • Weblogic
  • WebSphere
  • Fusion Middle ware
  • SOA Suite
  • LDAP
  • Oracle Identity Manager
  • Oracle Internet Directory
  • Application Messaging
  • Integration Broker
  • Data Mover
  • Full Application Upgrade
  • Full life cycle projects
  • Java
  • Application Classes
  • Portal
  • Data Mover
  • Approval Workflow Engine
  • Change Assistant

PROFESSIONAL EXPERIENCE:

Consultant PS Admin/Upgrade Specialist/Oracle DB

Confidential

Responsibilities:

  • Oracle database cloning to create new non-prod instances, routine refresh from prod to non-prod instance for testing training using scripts.
  • Backup and recovery of all Oracle/PeopleSoft databases
  • Oracle Dataguard active/active standby setting up maintenance and annual disaster recovery simulation testing
  • HP-UX korn shell scripts/Linux scripts for Oracle refresh cloning, backup recovery and PeopleSoft app/web/prcs server clean cache/bounce start/stop scripts.
  • Maintain over 100+ Oracle databases.
  • Install / upgrade and apply critical patches for Oracle 11g 12c
  • Install / upgrade and apply patches apply tax updates for PeopleSoft and experience with Change Assistant/PUM.
  • Hands on coding using PeopleCode/App Engine./SQR besides shell scripts/PL-SQL stored procedures and triggers for Administering/maintenance/monitoring
  • Oracle Enterprise Manager 12c Cloud control - monitoring perf tuning Oracle databases.
  • Implemented Oracle Transparent Data Encryption

Confidential

Consultant

Responsibilities:

  • PeopleSoft Admin Part of the team that migrated PS Financials/HCM/CRM/Portal from HP to Oracle Exalogic/ExaData Cloud based platform.
  • Specifically helped with PeopleSoft backend server infrastructure and server side components.

Confidential

Consultant

Responsibilities:

  • Led technical and functional teams and key decision makers developing and shaping technical standards, guidelines and execution for PeopleSoft Upgrade 9.1 to 9.2 (FSCM Supply Chain, eProcurement, GL AP AM KK, PeopleSoft Interactive Hub Kerberos Single Sign-On implementation.)
  • Implemented SSO using Kerberos authentication and integration of FSCM into PeopleSoft Interactive Hub so users can sign-on without having to enter User ID or Password.
  • Advise Oracle DBAa and PeopleSoft Admin Team on Production Support and Upgrade FSCM/Portal DEV/TEST/TRN/PROD 9.1 to 9.2 instances of App Servers, Process Schedulers and Web Servers, applying updates/patches/bundles.
  • Setup configure PeopleSoft Performance Monitor.
  • Used Oracle DataGaurd standby database for running PS Queries in order to offload heavy query processing.
  • Setup of the PeopleSoft 9.2 FSCM 9.2 and Portal Interactive HUB 9.2
  • Advised the Security Team with setting up, trouble shooting and supporting PS Security roles, rule based membership, synching HR with Portal and FSCM using Integration Broker.

Confidential, Newark, DE

Senior Managing Consultant

Responsibilities:

  • PeopleSoft Financials Re-plat forming Upgrade Financials 8.8 to 9.1 and converting from DB2 on mainframe to Oracle 11g RAC on Linux. Functional fit/gap analysis, design and functional specs documents GL/AP/AM .Worked closely with PSADMIN in setting up the new instances and as Upgrade Specialist. Designed and implemented the methodology for converting the entire PS FSCM database from DB2 to Oracle. Converted and compiled custom and delivered COBOL from DB2 to Oracle. Created interfaces and Data conversion programs in App Engine and SQR. Technical accomplishments and effectively leading onsite and offshore teams contributed to the successful completion of the project on time and on budget.
  • Led technical and functional teams and key decision makers developing and shaping technical standards, guidelines, IT roadmaps, usability and scalability.
  • Created optimized overall Technical architecture strategy to implement PeopleSoft FSCM 9.1 GL/AP/AM/AR and Portal 9.1Infrastructure from scratch. Data Conversion and Design interfaces to legacy systems and Financials Data warehouse.
  • Combine two PeopleSoft HCM 9.1 Oracle 11g instances, upgrade and implement new functionality using new features. Integration of Identity Management solution with single sign-on for PeopleSoft was included in the design. The biggest breakthrough came in the design and execution of the initial pass to establish the methodology since Oracle does not provide an out of the box solution for this type of task. Applied HCM 9.1 Feature Pack and Tools Upgrade to 8.53

Confidential, Newark, DE

Principal Consultant

Responsibilities:

  • Architecting the entire Oracle Identity Management Solution interfacing PeopleSoft Financials 9.0, Siebel, UCM, IPM, and SOA AXF. Used delivered connectors, Connector Factory and custom entity adaptor to implement custom solution and keeping the identities in sync. Architected the solution with Weblogic clusters with failover domains for OID and OIM and Portal.
  • Integral member of a PeopleSoft FSCM GL/AP/AM/PO/eProcurement EPM and ELM project.
  • Designing, configuring the technical infrastructure and ensuring the successful implementation of Financials Transformation project using LDAP integration with Open LDAP and PeopleSoft.
  • Partnered with project teams to improve the performance of FSCM and Financials GL interface to Payroll and administration of general ledger accounts payables batch process performance tuning.
  • Led efforts to implement improvements targeted toward streamlining processes, working with technical teams under strict budgetary and time constraints in FSCM Upgrade 8.9 GL/AP/AM/KK. Implemented Single sign-on authentication for PeopleSoft Financials with LDAP Authentication using Oracle Internet Directory and Active Directory.
  • Performance tuning of PeopleSoft GL closing process from 3 hours to 20 minutes.
  • Led the successful Full Application upgrade of PeopleSoft FSCM 8.8 to 8.9 (GL/AP/AM). Break fixes and performance tuning HRMS TAM module and candidate gateway, including configuration setup.
  • Provided leadership on a PeopleSoft Financials transformation project, implementing functional and Oracle SQL Performance Tuning solutions that provided a technical infrastructure to include general ledger, KK, AP/AR, and PeopleSoft EPM Data Warehouse.
  • Oracle DBA/PS Admin PeopleSoft implementation 8.9 FSCM HRMS. DB backup recovery/PeopleSoft app server/prcs scheduler/web server tech architecture config/setup.

Confidential, Philadelphia, PA

Deputy CTO

Responsibilities:

  • Executive level role leading all technical functions, tasked with implementing processes to improve help desk, networking, and PeopleSoft corporate applications. Served as lead strategist supporting all levels of management, driving long-range direction and goals of technological planning and development.
  • Performance Tuning of Batch/Online PeopleSoft.
  • PeopleSoft HCM Upgrade 8.9, Single Sign-on authentication LDAP Active directory with PeopleSoft Portal (2)

INDEPENDENT CONSULTANT

Confidential, Newark, DE

Responsibilities:

  • Rolled out the technical infrastructure and fit/gap analysis, prepared functional specifications and designed nine invoices and sales reports in PeopleTools Application Engine and SQR. PeopleSoft 8.1 Oracle 9i on Solaris and .Net front end. Oracle SQL performance tuning to stream line Billing Batch process cycle.
  • Troubleshot and tested infrastructure, software configuration, data migration, and recurring database issues.
  • Upgraded PeopleSoft 8.0 Human Capital Management with PIA J2EE Architecture.
  • HCM payroll interface, admin workforce, base benefits, time and labor, open enrollment, and training and recruitment.
  • Wore many hats as a crystal reports developer, application engine developer, system administrator, and DBA, installing backend servers and applications, web, and batch.
  • Engineered a robust infrastructure by logically dividing business units into three major divisions, implementing PeopleSoft Financials across remote sites for easy access and use.

We'd love your feedback!