SUMMARY:

• 20+ years of IT experience in Infrastructure, Database and System Administration, Security Administrator, Project Management, Team leading in Software Development, Implementations, Upgrades, Production Support, and Providing expertise in the areas of Plan, Design, Development, Testing and Go - live.
• PeopleSoft 6.x, 7.x 8.x and 9.x Financials, HCMS, Campus Solutions, EPM, CRM, SAP and Oracle Apps, ERP business process improvement.
• Extensive knowledge in designing, implementing and maintaining security for all the modules in Campus solutions, HCMS, ELM EPM, and Financials.
• Strong experience in installing and upgrading Financials, HR, Portal, EPM, HCM etc up to 9.2 and PeopleTools up to 8.55 including applying maintenance packs using Change Assistant and PUM
• Highly experienced in creating and configuring app servers, web servers, and process schedulers for DEV, TEST, QA, UAT, STAGING, SAND and PROD environments.
• Extensive experience in Integration Broker, LDAP configuration, Single Sign-On, Application Messaging, Application Designer, Data Mover, Configuration Manager, User Productivity Kit etc.
• Strong knowledge in Database refreshes from Production to Development, QA, Sandbox, User Acceptance Testing, Staging, and other environments.Extensive knowledge and experience in overall PeopleSoft system administration, Oracle database (9i, 10g, & 11g, 12g) administration, capacity planning, backup & recovery, application and database monitoring and performance tuning activities.
• Demonstrated knowledge base in operations, systems evaluation and enterprise architecture, (PeopleSoft) Pure Internet Architecture.
• Successfully implemented solutions at numerous Fortune 500 companies and supported over 25 projects during his tenure at Oracle/ PeopleSoft.
• PeopleSoft Architect/Lead/DBA/Administrator, ERP Security Administrator, Enterprise Architect, Performance Strategist and Senior principal consultant while working for clients within the Financing, Banking, Insurance, Healthcare, and other services industries as well as the Confidential
• Extensive Knowledge and Experience working with Internal/External Auditors, IT Compliance/Controls
• Playing a vital role in Design, Development, Support, Troubleshooting, Upgrades, Migration, Security Administration, Application Performance Tuning and Maintenance.
• Excellent communication, management, analytical, presentation, interpersonal, interaction and organizational skills, vibrant Team player/leader who loves taking additional individual responsibilities and challenges. Excellent team building, mentoring and leadership abilities.
• Willingness to provide 24x7 on-call support, remote support, production support or emergencies or crisis as required.

TECHNICAL SKILLS:

ERP: PeopleSoft 7.x to 9.2 (Human Resources, Financials (AP, AR, GL, Purchasing, Procurement), Campus Solutions (Admissions, Recruitment, Student Records & Financials. Academic), EPM), Oracle Apps, and SAP

Operating Systems: AIX, Sun Solaris, HP-Unix, DG Unix, SCO-Unix, VAX/VMS, AS/400, Novell Netware, Windows NT, 2003, 2008, and 2010.

Database /RDBMS: Oracle (8i to 11g), DB2, Informix, Sybase, SQL Server, IBM UDB/DB2, SQL, PeopleSoft/PeopleCode, C, C++, Pasca, Java, Unix shell scripting

Networking Software: VPN, TCP/IP, FTP, DHCP

Other tools: Microsoft Project, Visio, Microsoft SharePoint, Oracle Primavera, PVCS, Quest STAT, Quest SQL Optimizer, TOAD, Quest Shareplex, Visual Source Safe, Mercury tools, MS Office, and Lotus Notes, Load Runner, Control-M, OpenLoad, SQL Loader, DB Artisan, ETL, Data Stage, Informatica, Tivoli, OBIEE, Maestro Scheduler, EMC BCV technology, Symmetrix Remote Data Facility

PROFESSIONAL EXPERIENCE:

Confidential, NY

Senior PeopleSoft Administrator / Security Administrator

Responsibilities:

• Assisted in PeopleSoft Application updates and upgrades; applying bundles, maintenance packs and patches, configuring the EMhub, its agents, and change assistant
• Assisted as PeopleSoft Security Admin/ IT Control & Security to support NYU Internal Audits and External Auditors (PWC) for annual system audits for SIS, FAME, and WorkDay applications
• Responsible for gathering requirements, designing, building, testing, and maintaining the security environments to support PeopleSoft Financial applications.
• Design, develop and implement PeopleSoft application information systems security plans and procedures
• Perform security reviews and access audits, recommend security solutions, advice on application-level security configurations
• Provide security education for end users, and investigate and mitigate security risks as required.
• Responsible for all aspects of managing and monitoring access to PeopleSoft resources, including pages, processes, queries, trees, reports, components, services, integrations, customizations, and tools.
• Work closely with other teams to improve efficiencies in the security request and fulfillment process.
• Maintains security in all environments in support of development, testing, QA and production.
• Involved in PeopleTools upgrade from 8.49 to 8.52
• Assisted as a PeopleSoft Admin to support PeopleSoft Campus Solutions, Portal, EPM, and Financials Implementation, Upgrade, Production Support and Maintenance.
• Responsible for all functions associated with the build, configuration, design and support of all PeopleSoft applications in a multi-instance and multi-domain environment.
• Assisted in designing, implementing and maintaining security for all the modules in Campus solutions suite, EPM, and Financials.
• Designed weekly maintenance scripts for log cleanup and service recycles for all PeopleSoft Servers.
• Designed Maintenance Scripts to do weekly Restarts, Cache clear and Log Cleanup of PeopleSoft Domains.
• Installed people tools 8.51 and PeopleSoft Campus Solutions 9.0 applications software to build Campus environment on Oracle 10g and 11g.
• Configured multiple application servers and process scheduler’s multiple domain for load balance.
• Configured and maintained multiple web servers in PeopleSoft Campus 9.0 application.
• Monitor and tune various parameters of Tuxedo Application Servers, Batch Servers, and WebLogic Web Servers for better performance.
• Perform load balancing on Weblogic web servers, installing and configuring Tuxedo App servers and WebLogic web servers.
• Assisted in cloning and refreshing one environment from another. Assisted in automating refresh of SAND environment from Production.
• Assisted in developing security for User Profiles, Static & Dynamic Roles, Permission List, Query & Department Trees, Process Profiles and Definition Security.
• Expert in migrating established security from one environment to another.
• Synchronized security between various environments and PeopleSoft modules such as EPM, HCM and Financials.Assisted with data integration solutions using PeopleSoft Integration Broker, EPM and ETL.
• Integrated SSO (Single Sign-on) of OBIEE with PeopleSoft EPM application.
• Setup OBIEE authentication, authorization, and data security integrated with PeopleSoft.
• Setup OBIEE data filters, Table/Column security, Row level security, Roles and Catalog groups.
• Assisted in PeopleSoft Application updates and upgrades; applying bundles, maintenance packs and patches, configuring the EMhub, its agents, and change assistant.
• Involved in PeopleTools upgrade from 8.49 to 8.51.
• Assisted with Oracle RMAN backup and recovery toolset, Oracle OID, OEM and Disaster Recovery Facilities, EMC BCV and SRDF technology, monitoring tools and utilities.
• Installed and configured hosted people books in Portal 9.1 environment.
• Configured Integration Broker between within PeopleSoft applications.
• Tuned numerous Processes, Queries, SQL, Application Engine programs.
• Tuned Application server configurations to improve performance and reduce maintenance.
• Work on Oracle database security, backup/recovery strategies, monitoring tablespace growth and Unix file system for the Test and Production environments, and generate reports on performance statistics, disk space usage on Unix, and resolve production database related issues.
• Investigate the AWR statistics report every week to verify that the Production database was performing properly within the set parameters, opening tickets for various database tasks and issues such as providing Oracle security privileges to users, increasing space for tablespaces as required.
• Resolve all PeopleSoft and Oracle related problems and issues.

Environment: PeopleSoft Campus Solutions 9.2, Financials 9.0, EPM 9.0, PeopleSoft Portal 9.1, WorkDay, Oracle 10g/11g, Red Hat Linux, Windows 2008R2

Confidential, NJ

Senior PeopleSoft Administrator / Lead Consultant

Responsibilities:

• Provided technical support for all PeopleSoft applications including HCMS, Financials, and EPM.
• Performed Install, configure, trouble-shoot, performance tuning and administration of PeopleSoft Web, Application and Process Scheduler Servers on Windows, HP-UX & Linux Servers.
• Configure, implement and work with Integration Broker, Change Assistant, Environment Management Hub / Agents. Configure Messaging Gateways.Performed Database and Security Refreshes from the Production environments to Development and testing environments.
• Assisted in design and development of PeopleSoft Security module, including roles, responsibilities, and organizational structures. Create and maintain user IDs in all PeopleSoft environments, respond to and troubleshoot reported problems pertaining to the PeopleSoft applications access control and integrity, identify the cause, and design or develop an approach for resolution.
• Architect and maintain integrated PeopleSoft security across application modules, including HCM, EPM, and FSCM.
• Guide technical team through the installation and configuration of OBIEE across multiple applications such as Oracle EBS and Hyperion.
• Implemented and supported OBIEE security, admin tool, create and configure metadata objects
• Worked with technical resources (DBA, Linux Administrator, Network Administrator) to build and configure the production environment.
• Responsible for Project, Code and Security migration between database environments (Dev into QA Testing, then into Production) after successful testing.
• Applying bundles and tax updates for all PeopleSoft environments.
• Applied Global Payroll 9.0 Bundles # 1-11 & GP Core Tax Updates 10A-11C.Performed PeopleSoft administration, Installation of setting up applications, Database, Application, File, Web servers, and Process scheduler.As PeopleSoft Administrator setup multiple environments, refreshed, cloned and configured databases, performance tuning, backup, and recovery.
• Generated automated scripts for faster data and setup tables conversion.
• Setup core functional setup tables, security user profiles, roles, permission list, and integrate with AD (LDAP).Applied updates, fixes, and patches for HCMS modules and PeopleTools.
• Conducted complete life cycle of testing from unit test to parallel testing.

Environment: PeopleSoft HRMS version 9.0, PeopleTools v8.49, Oracle, Sybase, UNIX, Windows NT/XP

Confidential

Responsibilities:

• Single Lead Resource to Install & Setup various databases and upgrade environments.
• Installation of setting up applications, Database, Application, File, Web servers, and Process scheduler.
• Upgrade of large and complex production database from ver. 8.88 PT 8.44 to ver. 9.0 PT 8.49.
• Apply tools and application updates, bundles, fixes, patches, troubleshoot upgrade issues.
• Define, configure, and administer PeopleSoft security and access control across multiple instances, including development, test, or production such as interacting and working closely with multiple teams to implement access control roles and permissions, ensure that security objects adhere to Oracle, PeopleSoft, and system development standards and best practices, and document the security infrastructure to be interpreted, and maintained.
• Prepared, designed, conversion and user documentation for this implementation.
• Worked closely with other Infrastructure Teams for Operating System upgrades, Database Upgrades, Backup software, Hardware capacity and other supporting software and utilities.
• Assisted in extracting and loading data from various data sources and formats into Data Warehouse.
• Provided design documentation, project plan, go-live planning for this upgrade and re-implementation project.Performing Database Refreshes based on schedule from Production to Non-production.
• Tuned many Batch jobs and PeopleSoft online activity, PS Queries and custom SQL Queries.
• Backup and Recovery for Oracle databases from Hot Backups, RMAN and Export/Import.
• Review the weekly backup logs, Statistics jobs log files for each application.
• Assisted in designing, configuring and deploying BI /Performance Management application user functionalities using your Oracle BI Suite Enterprise Edition.
• Assisted in OBIEE authentication with PeopleSoft without using LDAP server or SSO.
• Assisted in designing data architecture and data integration with dimensional data modeling, data sourcing/mapping, data flow and master data management within the implemented solution set.
• Setup dashboards via Oracle Dashboards, iBots, Metadata dictionary via Oracle Answers, Integration with Oracle Single Sign On with OBIEE and OBIEE Answers as primary ad hoc reporting tool.

Environment: PeopleSoft EPM version 9.0, Financials 8.9, PeopleTools v8.49, ETL, IBM/ Ascential Data Stage, SQL Loader, Oracle, Sybase, UNIX, Windows NT/XP

Confidential, NJ

PeopleSoft Admin / Lead / Project Manager

Responsibilities:

• Performed Database Admin tasks including creation and maintenance of database instances, backup, recovery, upgrade, migration and Production support.
• Installation of setting up HRMS applications, Database, Application, File, Web servers, and Process scheduler.Installed and configured Web (WebLogic)/ Application Server on NT server (secondary server) Configured report distribution/processing to work on both NT servers (one is backup) with minimal changes to configuration for 2-Tier / 3-Tier users.
• Assisted in migrating Security objects from 8.8 mapped into the 9.0 Security objects.
• Design, Develop and Implement the approved 9.0 PeopleSoft security approach, including Roles, Permissions, Row Level Security, Object Security, Query Security, etc.
• Define the processes, policies and procedures for adding or modifying Users/Permission Lists via Roles.
• Establish security standards (that must align with other security areas, such as network, operating system, and RDBMS security).
• Assisted in setting up the Security Join Tables that will replace the Fast View security used in 8.8 and configured them for the 9.x Person Model.
• Applying PeopleSoft HRMS Tax Upgrades, Patches/Fixes and Production Releases Troubleshooting & Monitoring related to Application Server, Process Scheduler & Web server.
• Configuring load balancing and fail over capabilities for app and web servers.
• Cloning web instances, tuxedo domains, and perform database Refreshes.
• Performing service pack upgrades, Performing PeopleSoft tools upgrade and application upgrade.
• Maestro job schedule setup and maintenance.
• Create/Update project & process documents, checklists and keep them up to date.
• Involved in Service-Now Incident request tool - Custom design, implementation and testing.
• Synchronize self-service user profiles, roles, permission list between environments.
• Apply tax updates, bundles, fixes, patches, troubleshoot upgrade issues.
• Ongoing support to current and new interfaces, reports, queries, and audits.
• Prepared designed, conversion and user documentation for this implementation.
• Supported the resolved daily issues with Benefit admin and e-benefits module.
• Provided design documentation for this implementation project.

Environment: PeopleSoft HRMS version 8.9/9.0, SQL server, UNIX, Windows NT/XP

Confidential, Clarion, NY

PeopleSoft Lead Consultant

Responsibilities:

• Functional and Technical Lead to implement HRMS (HR, Benefits, T&L, Payroll, Eperformance, ePay, eBenefits) modules.

Confidential, New York, NY

PeopleSoft Lead/ Consultant

Responsibilities:

• Involved in functional analysis, upgrade compare review process, applying customizations/ de-customizations, patches and fixes, implementing PeopleSoft Portals, e-Pay, e-Development, e-profile, e-benefits, e-manager desktop.

Confidential, NY

Senior PeopleSoft Consultant

Responsibilities:

• Designed, Developed and Implemented the PeopleSoft HRMS applications including many custom applications such as Executive Compensation system to pay bonuses, salary increases, stock option grants and other allowances, RecruitSoft interface, Relocation system (GMAC interface) and Bonus Long term disability process, e-Performance modules.

Confidential, Washington, DC

PeopleSoft Functional Lead

Responsibilities:

• Provided Functional/ Technical consultation in implementing PeopleSoft HRMS (HR, Benefits, and Pension Admin & Payroll).
• Configured and Customized the HR, Pension and Payroll system using PeopleSoft 8.x applications.
• Assisted in installing PeopleSoft components including database server, application server, process scheduler, web server, and report distribution and application message gateway.

Confidential, New York, NY

Peoplesoft Consultant (Business Analyst)

Responsibilities:

• Involved in Gap analysis, Data Mapping, Data Conversion, Data Compares and Testing.
• Developed several new batch processes like Employee Transfers, Retroactive changes, Vested to NRD, Year-End Processing.