Peoplesoft Hrms Resume Profile
Wilmington, DE
Experience Summary
- Over 23 years of professional experience in IT services, delivering projects to finance, banking, bard Processing, mortgage, healthcare, government, financial service, media, telecommunication, transportation, manufacturing and IT Services industries.
- Managed multiple infrastructure projects in a Program during transition period of acquisitions mergers and streamlined operations for post transition period for several clients.
- Successfully migrated entire company infrastructure to new data center saving clients tens of millions of dollars by combining platform migration, upgrade, and server consolidation projects into single project delivered in record 9 month timeframe.
- Interacted with CIOs, CTOs, COOs, Chief Architects, and Program Managers, and presented architectural designs, solutions, and project strategies and plans.
- As Database Architect and project manager designed and successfully delivered data center migration, platform migration, upgrade, server consolidation with high availability in single weekend of multi-terabyte databases with minimal business interruption.
- Responsible for supporting an estimated 600 databases for around 100 enterprise applications running on over 150 servers.
- Over 21 years of Oracle DBA experience in server and DB sizing, design, installation, upgrades, multiple platform migrations from one O/S to another O/S, configuration, tuning, working with vendor for problem resolution, support multi-terabytes size production databases with 5000 users in 24X7 global environments running business critical applications. Installed OEM Grid control, developed RMAN scripts for backup and recovery, standby databases for DR using Data Guard, Real Application Cluster RAC implementation, support, ASM, patching, and all aspects of Oracle infrastructure administration.
- Excellent proven hands on skills in UNIX administration, Shell Scripting, data analysis, data modeling, system analysis, requirement gathering, system design, logical database design, physical database design, backup, recovery, high availability, disaster recovery planning, and implementation and testing.
- Developed ITIL based Standard operating procedures, service catalog for global IT, IT Services costing model that is instrumental in creating transparency to business on IT spending, gaining clients repeated business by reducing 1.2 Million IT services cost. Created strategies for IT Service cost reduction, presented strategies to IT executive, initiated and executed strategic projects to reduce IT cost successfully.
- Excellent IT Operational experience and worked closely with service desk managers to improve customer experience.
- Hands on Project Management with over 15 years of IT Infrastructure delivery experience, strong technical background, IT Service Management and IT Service Delivery experience for ERPs like PeopleSoft, Siebel, Arbor, Lawson, CableData etc.
- As Project Lead created infrastructure delivery strategies, project plans, schedules, budgets, TCOs, staffed projects, identified risks, contingency plans and QA plans, defined roles and responsibilities, and managed delivery of infrastructure.
- Managed multiple complex projects simultaneously, involving matrix delivery teams consultant, driven projects through corporate governance, financial, architectural, change reviews boards, worked with vendors, coordinate procurement, logistics, infrastructure delivery, coordinated tasks with systems, network, security, and storage teams.
- Improved customer satisfaction by align with business users, improving IT services, reducing incidents, improving response times, resolving problems by root cause analysis, implementing problem resolving solutions, and providing metrics.
- Liaison with application, business owners in defining SLA, and worked closely with service desk in incident resolution.
- Task force member for Corporate governance process, SDLC, and change control process design
- Interacted with Corporate Security Office, internal SOX auditors, enforcing SOX, HIPPA and other corporate security policies. Identified security, DR risks and implemented mitigation solutions across IT departments.
- Developed plans for infrastructure local failover, DR drills, and datacenter power shutdown and move projects. Developed minimal downtime to minutes for Oracle upgrades/switchover/failover using Data Guard.
- Regularly conducted status meetings executive presentations to Sponsors, Sr. Management, program managers, peer managers and clients with accomplishments, issues and escalations.
- Excellent communication, presentation, leader ship, people, management, and analytical skills.
ERPs: PeopleSoft HRMS/ELM 9.1, PSTools 8.5 Oracle Financial 11i, BMC Remedy 7.1 BMC Portal, Siebel, DataStage Tools: Microsoft Project, Power Point, Word, Excel, VISIO, Access, NIKU Databases: Oracle 11gR2/10g/9i/8i/7.x/6.x SQLServer 2005/2000/7 Dbase IV Case Tools: Designer, ERStudio, Erwin Process and Data Modeler, Toad Data Modeler Hardware: Cisco UCS, IBM 8230 Power7, RS/6000, P770, P570, P630/ HP9000 -V2250, K380, D390, H70, E55, E45 / SUN Ultra1, 10, E420, E450, E4500/ VAX 34XX Cluster / DEC Alpha / Windows / Macintosh
Operating Systems: AIX 6.1/5.3, HP-UX, Sun Solaris ULTRIX, SCO, Oracle/RedHat Linux 5,6 , Windows
Languages: Java, MS .Net, .Net Framework, C , C, PL/SQL, HTML, XML, UML, Shell Scripting
Confidential
Database Architect
First Data is one of the global leaders in providing Debit, ATM card processing, merchant payment processing, Point of Sale processing around the world. On day-to-day basis it processes around 30 Million transactions.As architect, re-designing the Debit transactions settlement system from current file based processing into Oracle database based settlement system that is flexible to allow new frequent settlement cycles.
Confidential
PeopleSoft HRMS
Confidential is a leading, independent, diversified, financial services firm. Founded in 1919, a leading automotive financial services company with over 90 years experience providing a broad array of financial products and services to automotive dealers and their customers. Ally Bank is an indirect wholly owned subsidiary of Ally Financial Inc. and a leading franchise in the growing direct online and telephonic banking market. On November 21, 2012 the Bankruptcy Court entered orders approving the sale of the Ally Bank's mortgage servicing platform to Ocwen Loan Servicing, LLC and Walter Investment Management Corp., closing the deal on February 15, 2013. Walter Investment Management Corp WAC formed a new company Ditech Mortgage Corp. Until December 2013 all of Walter's applications were hosted in Ocwen's data centers for a multi-million dollar investment. The goal of this project is to design a new data center infrastructure with high availability and flexibility in the shortest duration possible and in a cost effective manner to run Ditech's applications. Objectives include allowing flexible infrastructure for current and future economic conditions, platform migration, upgrade, server consolidation in the most important objective is single week end downtime for whole company migration into new data center.
- Saved an estimated 6 million dollars by delivering all applications to run in Ditech data center 3 months earlier than Transition Services Agreement TSA deadline.
- Database infrastructure delivery is lynchpin for this migration as all 100 applications rely on database infrastructure.
- As Database Architect analyzed current infrastructure, and made up of 60 plus Unix servers running on 10g and 11g Oracle databases running on different flavors of Unix accessed by about100 applications.
- Planned, designed and successfully migrated 20 production databases sizes ranging from 500GB to 6 TB over single weekend from old data center to new datacenter with least down time.
- Architected processes to migrate from Sun Solaris and HP-UX to Linux platform, upgrade from 10gR2 to 11gR2, and converting from single instance to highly available clustered environment.
- All Production databases run on single three node 11gR2 RAC with DR capability to remote site to running RAC.
- Designed and delivered four 3 node RACs for production, staging, development and testing to run in 24X7 environments with 2000 user base.
- Delivered this project in a record 9 months.
- Managed multi-terabyte Data warehouse databases like Data Stage and many OLTP databases.
- Headed a team of 10 DBAs and managed all migration activities of database infrastructure that had also included Microsoft SQLServer 2005/2008 to SQLServer 2012.
Environment: CISCO UCS, RedHat Enterprise Linux 6.2, MS Windows XP, 2000/2003, Oracle11g, Data Guard, OEM Grid Control 12c, RMAN, RAC, NetApps, VMWare, ServiceNow, Microsoft Project, and Toad 12, OEM 12c, Tomcat, Apache, .Net, IIS, Datastage, BusinessObjects
Confidential
Lead Database Administrator
Confidential Health and Hospitals Corporation HHC is a 6.7 billion integrated healthcare delivery system with its own 385,000-member health plan, MetroPlus, and is the largest municipal healthcare organization in the country. HHC serves 1.3 million New Yorkers every year and more than 450,000 are uninsured. HHC provides medical, mental health and substance abuse services through its 11 acute care hospitals, 4 skilled nursing facilities, 6 large diagnostic and treatment centers and more than 80 community based clinics.
- As Lead Database Administrator responsible for over 100 database in 24X7 environment with Oracle running on versions 11gR2/10g RAC and standalone environments supporting PeopleSoft HRMS 9.1, PeopleSoft ELM 9.1, Quest STAT 5.5, Oracle Financials 11i, Oracle Identity Management 11g and BMC Remedy Service desk 7.1 production, development, QA environments. Lead team of DBAs and manage upgrade and datacenter move projects of Database infrastructure.
- Migrated databases from one platform to another platform like AIX to Linux, Windows to Linux. Sized Servers for multiple ERPs like Oracle Financials, PeopleSoft, BMC Remedy, Foglight etc.
- Installed and configured OEM Grid control 12c/11g management packs.
- Installed and configured RMAN with IBM Tivoli Data Protection, and VERITAS NetBackup for Oracle for backup of about 100 databases for restore recovery.
- Configured Oracle Standby databases for high availability and upgraded with 15 minutes downtime using Data Guard.
- Performed patching, upgrade, SQL Tuning, Trouble shooting, working with Oracle to open Service requests for resolving issues.
- Played key roles for DR drills, and implementation of multiple data center move of database infrastructure.
- Responsible for Remedy Service Desk Database installations, configuration and upgrade, CMDB, security remediation and numerous infrastructure and service delivery upgrades.
- Responsible for database infrastructure capacity planning, infrastructure upgrades, project schedules, estimates, issues, risks, contingency plans, QA, delivery of database infrastructure for Production, development, and QA environments.
- Provide databases services based on ITIL based Enterprise Service Management Remedy database infrastructure, and implemented best practices for successful delivery of IT services, manage SLA and service restoration, incident and management and worked closely with service desk, external vendors to improve IT services.
- Developed procedures streamlining operations through standard operating procedures, reducing incidents and implementing problem resolutions.
- Installed and configured IBM AIX 5.3/6.1/Linux based Oracle 11gR2/10gR2 Real Application Cluster with multi-node RACs for Production/Development/QA load testing environments for PeopleSoft, Remedy, and OIM etc.
- Support E-commerce Oracle Financials, and Oracle Identity management Oracle 11g environments for Production, Development and QA. Configured OIM, OID for maximum availability architecture with automatic failover.
- Install and administer Web Logic environment. Automated PeopleSoft interface sent to Mainframe through sftp.
- Manage and troubleshoot Esker Delivery Ware 5 environment for paperless e-commerce fax integration and routing e-faxes to facilities.
Environment: IBM AIX 6.1, 5.x, IBM-8233-E8B, Power 7, 9117-MMA, LPARs, P630, P570,P630 RS6000, GPFS 3.x, Enterprise Linux 6, RedHat Linux, MS Windows XP, 2000/2003, Oracle11g/ 10g, Data Guard, OEM Grid Control 11g/10g, RMAN, RAC, EMC Clarion/ESS Storage, Tivoli Data Protection for Oracle: version 5.5.1.0, VERITAS NetBackup for Oracle - Release 6.5, VMWare, BMC Remedy, Microsoft Project. Toad 10, Foglight6,Foglight5, BMC patrol, Esker Merkur Deliveryware 5 Document management. PSTools 8.5x, PeopleSoft HRMS 9.1, PSTools 8.51, Oracle Identity Management 11g, BMC Remedy Service Desk 7.1, Quest Stat 5.5, Oracle Fusion Middleware 11g, BPEL, Oracle Financials 11i 11.1.10
Confidential
Manager, Database Information Management
Confidential Purchased by RR Donnelly in 2010 a leader in global financial services offering financial communication, acquisitions merger filings, based on SEC related activities and information management, printing and solutions. Bowne, one of the world's largest financial communications companies with global presence in Confidential.
- Managed multi-million dollar IT service management, infrastructure project delivery, capacity planning, created infrastructure delivery strategy, project schedules, budgets, estimates, costs, issues, risks, contingency plans, QA, defined roles responsibilities, delivery of infrastructure for development, QA and production environments.
- Lead multiple projects in Integration Program into Bowne from acquisitions of Vestcom, and streamlined post transition operations.
- Managed ITIL trainings, ITIL Service Management Assessment project, IT Cost model projects and implemented ITIL based best practices for successful delivery of IT services, managed SLA and negotiated OLA, service restoration, incident and management and worked closely with service desk, external vendors to improve customer service.
- Presented strategies on IT cost reduction and streamlining operations to executives and Sr. Management. Developed a cost model to provide transparency on IT spending and reduced it support costs by 1.2M.
- Streamlined operations through standard operating procedures, reducing incidents and implementing problem resolution plans. Boosted DBA team moral and increased productivity by 5 times and created a model team in global operations.
- As a Lead DBA responsible for services in complex global 24X7 Oracle with 10/9i/8i, 10g RAC, OEM Grid control, management packs with RMAN with IBM Tivoli Data Protection integration for backup, restore recovery, Oracle Standby databases for high availability Data Guard, MS SQL Server 7/2000/2005 clusters.
- Played lead roles for DR drills, and implementation of site power down, multiple data center move of database infrastructure.
- Lead diverse highly skilled technical team, supporting about 600 Oracle and MS SQL Server Databases for about 150 applications.
- Lead Remedy Service Desk upgrade, CMDB, security remediation and numerous IT infrastructure and service delivery projects.
Environment: IBM AIX 5.x, 4.3.3, P630, P570, P630 RS6000, HPOpenVMS, MS Windows NT, 2000, Oracle10g/ 9i/8i/ 8.x/7.x, Data Guard, OEM Grid Control, Erwin, RMAN, RAC, MS SQL Server 2005/2000/7.0/6.5, EMC Storage, Tivoli Data Protection 5.x for Oracle, Citrix, BMC Remedy, Project Central, SharePoint, VMWare, LanDesk, Microsoft .Net, C , Microsoft SharePoint
Confidential
- Installed Arbor formerly Kenan cable and telephone billing system and administered databases of Customer, admin, catalogue databases in multi server architecture in Solaris environment.
- Installed Siebel 2000, on Solaris, and played critical role in migrating Siebel from NT to UNIX/Linux environment.
- Designed and developed Java based Server and C based client socket system for MD5 key generator to encrypt messages.
- Gathered business requirements, involved in design, development, QA of iO systems, Corporate IS systems related to iO project. Designed and developed 3.2 million customers data replication from Corporate IS systems to Engineering Systems. DBA for over 25 Oracle databases sizing from 500GB to 2TB with 24X7 availability
- Played key role in Architectural design through implementation phases of the project.
- As a Project leader for Mediation Project involving Subscriber Management Systems SMS and Entitlement Message Management Generation EMMG , transitioned the project from Accenture. Lead 4 DBAs and 4 Java developers.
- Project leader Sr.DBA for Mediation project in Digital Set Top Box project Interactive Optimum or iO .
- Designed data mapping between various iO systems for Enterprise Reporting project, designed data extraction processes for interfaces to Remedy, Arbor, Mediation, Customer Index, InTouch, and Account Management Systems. Designed and developed data extraction and loading system for Cable Modem Bricking interfaces.
- Focal point for Database issues resolution for interactive Optimum iO Digital TV systems.
Environment: Sun E420, E4500, Sun Solaris 5.6 to 5.8, HP 9000/800 Series V class 2250, K380, H70, E55, E45, HP-UX 11/10.2/9.2, Oracle 8i/ 8.x/7.x, Designer 2000,Discoverer 3, EMC Storage, Veritas VM and Tandem
Confidential
companies all around the world. As a senior DBA and UNIX administrator, solely managed, designed and implemented Corporate Data Warehouse for KWE. Supported Oracle databases for Oracle financials, Lawson and other databases. Migrated applications from Sun Solaris to HP-UX Unix, IBM AIX, Windows to Unix.
Environment: HP 9000/800 Series V class 2250, K 380, H70, E55, E45, HP-UX 11/10.2/9.2
Oracle 8.x/7.x, Oracle Financials, Lawson, Power Builder, Developer 2000, Designer 2000,Discoverer 3, Omni Back II, Glance, and Perfview Monitor
Confidential
PeopleSoft HRMS
As a DBA at Andersen Consulting involved in server tuning and performance enhancement of Oracle 7 database supporting PeopleSoft Human resource management system running IBM AIX RS/6000. This is an effort of moving from ADP/Unisys Mainframe system to a Client/Server environment. Also, involved in the upgrade of PeopleSoft from 4.0 to 4.1. Developed SQL Loader control files for loading data into Oracle database which reduced processing time drastically compared to conventional People Soft import utility.
Environment: IBM RS/6000, AIX, Oracle 7, PeopleSoft HRMS 4.1 and Crystal Reports