Babu M Sebastian
SUMMARY:
Sebastian is senior Software professional who merges astute strategic, business & project management skills with 12+ years of ERP experience in multiple domains (Government, Education, Healthcare, Mortgage, Insurance & Banking) Application experience that enables revenue & profit growth. Has good experience with PeopleSoft and Oracle Fusion HR, Time and Labor, Payroll, Absence Management and PeopleSoft test framework. Sebastian takes lead in design, enhancement, integration, and quality assurance & testing within varied environments, frameworks, phases, and projects, including web/cloud applications.
•Has worked on many PeopleSoft implementations and Upgrades, collaborating with process owners to analyze business requirements to test application functionality, system processes, workflow, integrations, and reporting.
•Develops quality assurance plans, test matrix, creates comprehensive scope documentation, helps define milestones, manages scope, QA project risks and issues, communicates critical issues and major milestones to project managers and ensures project is delivered on time, within scope and budget, and to the entire satisfaction of the management
•Design and Support experience in PeopleSoft HCM, FSCM, in multiple modules including HR Absence and Payroll.
•Managed Data conversion managing the overall Data Conversion phase of large complex projects to convert legacy data to PeopleSoft with multiple interfaces, applications and modules of Campus solutions, Finance, and HCM
•Proactively identify risks and document effective mitigations that achieve successful on time delivery for Data Conversion commitments (i.e., Data Conversion Strategy, Conversion Cycles, Error reporting, identifying the root cause etc.)
•Strong technical experience across PeopleSoft applications including Employee and Management Self-Service and Fluid Interface.
•Expertise on implementing and configuring Integration Broker, Web Services, Single Sign-On, LDAP, Directory Interface, Security, and Workflow.
•Well versed in fit-gap analysis, workflow analysis, and business process.
•Proficient in working with People Tools such as Application Designer, PS Query, Process, BPEL, Webservices, and IB integration, Scheduler, Process Monitor, Application Engine, Query, Security, File Layout, Application Packages.
•Implemented Workflow using Fluid/AWE, Security Administration and have taught training classes to clients.
•Strong knowledge and understanding of SQL and structured programming languages with work experience in reporting tools like SQR, Crystal report, XML publisher and PS Query, XML and BI
•Experienced on building Custom Time and Labor Rules, Absence Management, customizing SQL Objects, Actions and Conditions.
•Strong analytical, fit-gap analysis, problem solving skills and a good team player with excellent communication and interpersonal throughout requirements, design, development, and test and deployment phases of the project.
•Utilized all latest PeopleTools features including drop zones, event mapping REST API, Fluid Interface, Page Composer, Test Framework, Event Mapping, Form Builder, and fluid-based approval workflow
•participate in review of requirements, design of loading scripts and offer experience to the customer and business with Error Reports and Point issues with Data clean ups.
•Experienced with People Tools 8.56/8.57, Fluid User Interface development, BI Reporting, Integration Broker and Web Services and RESTful integration
Technical Skills
•Certified Sun Java developer with extensive experience Fluid and Oracle Fusion technologies
•Technical experience with PeopleTools 8.57, Oracle Fusion including Fast formulas creations
•Significant hands-on experience and knowledge of SQL, SQR, Application Engine, People Code, Fluid, Component Interfaces, Application Messaging, Application Packages, Integration Broker, Web Services, XML publisher and other PeopleTools and excellent troubleshooting skills.
•Experience in working with Oracle Databases, SQL, DB2 and Mainframe
•Provide technical assistance and guidance to PeopleSoft HCM user support staff.
•Perform systems related maintenance such as patching, tax updates, etc.
•Assess problems or issues and articulates potential solutions or workarounds and think out of the box
•Experienced with Internet Architecture (PIA), Fusion, Cloud architecture, databases, process schedulers and tuxedo application servers
Employment History
Organization
Role
From
To
Roriba consultancies Inc, CA
Lead Analyst
May 2014
Current
Stanford Lucid Packard children’s Hospital
Lead Analyst
April 2012
March 2014
MATL Systems Inc, CA
PM/Lead Analyst
June 2006
February 2012
PROFESSIONAL EXPERIENCE:
TriWest Health Care Alliance, Phoenix, AZ Apr 2018-Jun 2020 & July 2022 - Current
PeopleSoft Techno-Functional Consultant, HRMS 9.2
•Providing Functional ad technical support for HCM 9.2, T&L, Absence, Benefits / Pension Administration, Open Enrolments and Payroll and GL interfaces.
•Designed and implemented TL union/Region based rules for absence and payroll integration. Designed integration between absence leave accrual with Timesheet reporting, implemented Auto enrolment of employees on hire/rehire and position changes, as well as assign reporting shift schedules.
•Implemented 9.2 fluid-based self-service, Workflow approval, Approval delegation, Time and Labor and Absence Dashboard for managers, Timesheet lock for administrative operation, and Flud web Clock
•Integrated timeclocks with PeopleSoft Time and Labor enabling both HR Data publish and time upload into reported time-tables through rest-API process.
•Troubleshoot Absence management accrual and eligibility rules, reconcile FMLA leave plans with approvals and document maintenance
•Extensively enhanced test cases in PeopleSoft test framework to test HRMS and different HCM modules
•Deployed Manager Self-Service and Employee Self-Service with Fluid and activity guides
•Provides day-today production support for PeopleSoft HR and Payroll
•Supported with PeopleSoft Internet Architecture (PIA), databases, process schedulers and application servers, and installed single user PeopleTools environments for developers.
•Implemented ecAxsTM, to automate PeopleSoft role assignment, and SQLVaultRealmsTM to terminate any unknown SQLs at runtime against protected data (SSN/Name/Accounts etc.) to discourage phishing, network /password compromises etc.
Contra-Costa County, Martinez, CA Jul 2020 -May 2021
PeopleSoft Consultant, HRMS 9.2
Implemented County and CA State Payroll processing and resolved multiple issues regarding tax garnishments and retro payments
Deployed W2 and W2 consent online for 2020. The W2 implementation faced different challenges which needed co-ordination and project management with different groups and establish proper communication and controls and coordinating different testing strategies and signoff.
Implemented multiple Manager Self Service and Employee self-service modules including Open enrolment self-service, and benefits enrolment for new hires with deployment of guided processes.
Provided support for all CA State payroll processing, payroll troubleshooting interfaces and tax updates, and year-end processing
Improved upon County Benefits Administration, Pension Administration, eBenefits, Open Enrolment, Benefits billing and Performance Management Activities
Established time and labor multiple compensatory time plans and linked to different TRCs, based on different regional/SBU requirements, converting current benefits based compensatory time system to PS Absence Management and TL based multi-compensatory system. Automated Time reported enrolments, Fluid web clock, self-service, delegation and approvals.
Implemented HR92 PUM 42 including Time and Labor new Approval structure delivered with PUM 35 (enhanced from PUM 29), including new dashboard that groups most frequently used Management functions, Fluid Search by identifying and configuring Search Filters, and implement both the delivered and custom approvals.
Integrated with CalPERS system with Employee data, CCCounty benefit administrators.
implemented and configured Integration Broker for Emergency notifications with REST API JSON/URL encoding.
Defined and enhanced PeopleSoft Time and Labor’s and absence transactional analytics to provide visualized charts to view, analyze, drill down, and to act on the data. Leveraging PeopleTools Pivot Grids pivot and filter to interpret the data in a variety of ways.
Extensively utilized drop zone to reduce customizations, event mapping to capture data away from current component, Fluid based approval workflow and form builder to enable easy approval from different form factors and built dashboards and work centers for managers to easily make the best use of applications.
Helped implement PeopleSoft Internet Architecture (PIA), databases, process schedulers and tuxedo application servers, and end user Tools installations for developers and creating different environments like DEV/QA etc. and upgrading PUM and patches
Special Roriba SQLRealmsTM: Implemented ecAxsTM, a PeopleSoft bolt-on solution that will auto analyze current security set up, within the context of employee and contractor status, and provision access across FSCM/SCM/CRM/HCM and protect data changes by developers/Admins and super-users by real-time activity monitoring and disable unknown SQL runs against PII data (SSN/DOB/Grade/Account etc.), to protect against network/password compromise
Chicago Public Schools, Chicago, IL Jun 2021-May 2022
PeopleSoft Consultant, HRMS 9.2/Cloud upgrade
•Provided Upgrade support for PeopleSoft HCM modules especially Time and Labor, Absence and Payroll modules.
•Programmed PeopleSoft Test framework to add more testing scenarios to the delivered test caes
•Reconciled Leave accruals with reported time, Time reported to Chicago pension management agency
•Automated multiple time and labor processes including work schedules, auto enrolment, delegation and approvals, timesheet lock for payroll processing, FMLA /Leave approvals and many rest-api integrations
•Prepared multiple reports T&L WorkCentre and dashboard
•Retrofitted and redeveloped multiple AE/SQR/Reports to upgrade to PS Cloud HCM
•Managed auto enrolment of staff as they move thru temp/permanent positions into benefits and Time and labor for benefits enrolment and time reporting and pension programs
•Used drop zones and event mapping to reduce customizations, and deployed form builders and fluid approval workflow to take advantage of fluid deployments.
Judicial System of California Jan 2017 – Mar 2018
Peoplesoft Analyst, HRMS 9.2 HCM Modules
•Planned, scheduled and analyzed various customer issues, and resolved problems for successful upgrade
•Upgrade of Core HCM, Benefits, Time and Labor, absence and CA State specific Payroll processing
•Analyzed and implemented PeopleSoft TAM 9.2 and CG with resume parsing, onboarding and REST API integration with onboarding DocuSign forms.
•Work with technology teams to configure, develop, and implement the solutions, work with business teams to plan and implement change (training, documentation, change management)
•Helped deploy Benefits Administration, eBenefits, Time and labor and Absence Management
•Supported with PeopleSoft Internet Architecture (PIA), databases, process schedulers and application servers, and installed single user PeopleTools environments for developers
•Enabled Fluid application access for MSS/ESS and core applications
•Customized and deployed Activity guides and work centers for on boarding, benefits enrollment, and ePerformance
•Improved page functionality using drop zones and event mapping and used work centers, dashboards and approval workflows extensively.
•Designed and developed multiple reports for government audit requirements, and reporting guidelines, including CalPERS and state government and county requirements
•Perform as consultant and advisor to drive best practices and optimal use of systems resources
California State Universities, San Jose Campus Jun 2016 – Dec 2016
Peoplesoft Analyst, CS and HCM
•Engaged in the HCM/CS split and upgrade of the PeopleSoft system 9.2.
• Worked closely with clients to identify and address, through improvement plans, financial aid compliance, and operational (i.e., workflow) issues.
•Worked on ISIR Package process modifications.
•Used form builders to create new forms for approvals
•Analyzed business needs, worked with technical resources to develop, design, and test the solution for customizations, interfaces, and reports.
•Classification of modules, processes, data and security as per the business needs.
•Configured Mass Change Process to create the Employees and Student profiles.
•Created Activity Guide for Student Financials Financial Agreement.
•Enhancing the business processes so that these processes will leverage the delivered integrations and the data can be maintained in both the systems real time.
•Quarter to semester conversion issues production support.
•Modification on Degree progress report and fixed existing issues.
•Support CS and HCM Work Center, IB integration, REST API, student activity guides, and deployment
•Worked on assign and release checklists, Service indicators, or holds automatically, and with PLUS loan configurations and customized of the PLUS loan processes
AC Transit, Oakland CA Feb 2015 – May 2016
Senior Business analyst, Peoplesoft upgrade 9.2 HCM/FSCM
•Provided PeopleSoft upgrade from 9.0 to 9.2 for Core HR, TL, PY and eModules
•Provide support for payroll tax updates, payroll processing, and troubleshooting.
•Implemented eComp, for managing compensation program for employees including alerts, and approval process and extensive reporting and graphs
•Worked closely with business owners and stakeholders to develop Quality assurance programs, testing plans, phases, methodologies using Agile/Scrum
•Designed and developed Change Management and training plans
•Designed and deployed multiple work centers, and activity guides
•Integrating HR/G:/Projects
University of Michigan, Ann Arbor Apr 2014 – Jan 2015
PeopleSoft Consultant: Upgrade and Campus improvement Project
•Support UMICH in their campus modernization effort using PeopleTools 8.54 features including student activity guides, Thesis Management, Evaluation management by Entity registration via implementation of SOA Rules Engine, BPEL, BI and Web services and IB integration, and workflow
•Support SF, GL/AP/AR, Inventory and HCM upgrade Time and Labor rules configuration, and Work Center deployment
•Evaluate the existing configuration for various modules and suggest improvements to overall solution architecture Admissions, Student records, Curriculum management, Student Financials and Financial Aid
•configurations and customized of the PLUS loan processes
•Developed queries, connected queries, pop-select queries, and created many queries to help the users to generate the reports, and developed the form and approval workflows for the Registrar's office and Student record office
Stanford University/Medical Group, Palo Alto, CA Nov 2011 – Mar 2014
Functional Lead - PeopleSoft Systems
Focus: FSCM, HRMS, SuccessFactors, Student Admin
•Worked as Implementation & upgrade Lead for PeopleSoft 8.9-9.1 HRMS upgrade for the University, & support for Student administration 9.0
•Analyzed business needs, worked with technical resources to develop, design, and test the solution for customizations, interfaces, and reports, including Classification of modules, processes, data and security as per the business needs, Configured Mass Change Process to create the Employees and Student profiles, Created Activity Guide for Student Financials Financial Agreement.
•Designing, planning, and executing system testing strategies (six Sigma) for all PeopleSoft Modules including HCM, Finance, Supply chain, Clairvia, Lawson, Epic Integration, managing error logs, and resolution and reporting status to business owners and stakeholders.
•Support Stanford in their campus modernization effort using PeopleTools 8.54 features including student activity guides, Thesis Management, Evaluation management by Entity registration via implementation of SOA Rules Engine, BPEL, BI and Web services and IB integration, and workflow
•Using a component interface, converted students with an academic career of CEU to CNED by inserting rows into the student’s program plan stack.
•Integrated CS/HR/Finance/GL/SCM/BIL/Inv/and other modules
•Supported with PeopleSoft Internet Architecture (PIA), databases, process schedulers and application servers, and installed single user PeopleTools environments for developers
PROFESSIONAL MEMBERSHIPS
Ex-Member, ISACA, Silicon Valley Chapter
Ex-Member, Project Management Institute, San Francisco.
TECH SKILLS:
DBMS: Oracle SQL Server SQL Base, DB2, Informix, Sybase
Languages: Java, VC++, Pro*C, C, PL/SQL, PL/1, Basic, COBOL, Forms 3.0, Report
Writer 1.1, Menus (3.0), Dev 2000, PB-6, VB-5, SQR, XML People Code, People Tools, Actuate, Integration Broker, BEA Appserver / Webserver
ERP/CRM/ PeopleSoft FSCM, SCM, HCM, Workday, SalesForce, SAP HRMS SuccessFactor
Security Systems: PGP security based on RSA, PeopleSoft Security Workflow, SAP 4.C
Security, LDAP, COBIT/Aurisys,2FA, /Control LDAP/SSL/SSon/COBIT (ISACA), SOX SAS-70
Test /Audit Software: Aurisys, SQA Robots, Win runner, Test Director, Agile/Scrum, Redmine, Github
PeopleSoft Products: HRMS 6.0 thru HRMS 9.2, HR, Payroll, Benefits Administration, eCompensation, ePeformance, TAM. PeopleSoft, Time & Labor (T& L) & Self Service, Financial 8.4 GL, Procure to Pay (ePro, PO, AP, AM, GL, Grants), Enterprise Portal 8.3 thru 9.2, Upgrade & Security. Version 6.5 thru 9.2, PeopleTools, Crystal, Cognos, BI Reporting, PS Queries, SQR, nVision, Business Objects, HTML, & CSS
EDUCATION & TRAINING
PMP – Project Management Professional (needs renewal)
CISA – Certified Information Systems Auditor (needs renewal)
MCM - Master of Computer Management, (Diploma- IGEF, Bombay)
Win Runner, HP ALM, PeopleSoft Testing Framework, Redmine, Jeera, GitHub,Redmine
JAVA 2 Certification from Sun Microsystems
Diploma in DB2/ CICS / JCL & AS/400 Programming
Certificate course in Computer Programming - C, VC++, Unix & Oracle
PeopleSoft trained Consultant