PROFESSIONAL SUMMARY:

• Certified HCM Techno - Functional Consultant with around 10 years of experience in all stages of SDLC including business requirements gathering, design, data conversions, programming, development, security, system administration, system integration, user acceptance testing and documentation within PeopleSoft Human Capital Management.
• Functional Experience surrounding the upgrade and support of PeopleSoft Human Capital Management Modules including Core HR, Absence Management, Time and Labor, WFA, WFM, Base Benefits, Commitment Accounting.
• Exposure to technologies modules and applications like AP, GL, Admin, NA Payroll, Peoplesoft CRM, HCM, SAP success Factors, Oracle Financials, Masterpiece, Kronos WFM(Version 9.2, 9.1, 8.x)
• Experience in implementation, upgrade, security, development writing interfaces and administration of PeopleSoft.
• Would like to move to a transformational company where I get the opportunity to lead from front and get exposed to technical challenges.
• Support customer management to establish processes and define & track SLA’s
• Perform all technical duties independently on high-visibility programs, or mission critical aspects of given program
• Analyzes existing highly complex software and streamlining/optimizing the processes and code.
• Provided technical consulting services by acting as subject matter expert and leading clients through the entire systems development lifecycle for PeopleSoft North American Payroll, core HR & Benefits
• PeopleSoft database and systems troubleshooting and tuning to resolve complex data
• Translated requirements into client ready design documents including modeling languages such as Unified Modeling Language (UML)
• Providing expertise with web servers, gateways, application servers, and content management systems
• Solid understanding of setup tables, W-2's, year-end processing, entire HCM/payroll cycle, processes and reporting
• Familiarity with one or more relevant architecture frameworks or methodologies SOA architecture. strong analytical and problem-solving skills. Initiate and execute on multiple tasks, and work effectively, both independently and as a member of a cross-functional team
• Work collaboratively with cross-functional and project teams within HR payroll and IT.
• Worked in Handling SOX queries, responding SOX audits
• Designing, developing, and maintaining infrastructure and backend applications.
• Lead, investigate, analyzeand effectively solve problems.
• Functional understanding of SaaS application like Workday, Road-Net, ServiceNow and cognition.
• Responsible for the HCM Commitment Accounting fit gap testing, Request for Change, Modification design specifications and Quality Assurance
• Extensive experience with full life-cycle software applications development (i.e., design, construction, testing, and implementation
• Worked on Excel to CI.
• Worked with the six health centers at namely UC Davis Health, UC Irvine Health, UCLA Health, UC Riverside Health, UC San Diego Health, UC San Francisco Health
• Implemented and supported the Payroll for all UC medical centers
• Expert PeopleSoft functional analyst in Benefits, Benefits Administration, HCM security, NA Payroll, T&L, ESS, MSS and core HR.
• Improved the payroll process efficiency using parallel processing. knowledge of HCM data models and conversion from and to PeopleSoft
• Redesigning and developing enhancements to support Commitment Accounting mid-period funding changes
• Building the bridge between IT and business
• Extensive work experience with MS office suite like Word, Excel, Project and Visio.
• Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, DB2.
• Cloud Deployment Platforms such as Amazon AWS
• In-depth knowledge of the PeopleSoft architectural environment including middleware technologies.
• Experience using the PeopleSoft Application Packages.
• Analysis, design, development, testing, installation, and maintenance of information. Works independently with limited work direction
• Supported testing like unit testing, systems integration testing (SIT) and user acceptance testing (UAT)
• Strong critical thinking, problem solving, negotiation and facilitation skills.
• Worked with reporting and analyzing tools such as XML Publisher, Used PS/Query, Connected Query and Tree Manager for reporting purposes to fulfill company specific needs.
• Familiar with fluid design.
• Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Extensively worked with People Tools such as Application Designer, Approval Workflow Engine, Application Engine, Integration Broker, Application Messaging, SOA architecture, Component Interface, People Code, Security, Tree Manager, Process Scheduler, Data Mover and Query tools
• Strong knowledge of HIPAA and PII/PHI and corresponding security measures needed for the same in the solution design
• Conversion of classic pages to fluid pages.
• Self-starter; takes initiative and can work independently and deliver on time
• Conducting System Integration Testing (SIT), Functional Unit Testing (FUT) and User Acceptance Testing (UAT) to ensure system deployed meets business needs.
• A 70:30 mix of technical and functional expertise to be provided to the HCM domain.
• Extensive experience in writing Interfaces between PeopleSoft HRMS and Financials.
• Worked intensively with Security Administrator to implement Row Level Security, Single Sign on, and LDAP integration, Creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
• Knowledge of HTML, CSS and XML
• Performed the risk reward analysis for migration move from PeopleSoft 9.1 to 9.2

TECHNICAL SKILLS:

ERP Module: PeopleSoft HCM (8.x/9.1/9.2), PS HCM (Core HR, Work Force Administration, WFM, ESS, MSS, NA Payroll, Absence Management, e - performance, Benefits, Ben-Admin, Time & labor, campus solutions, CRM), AP, PO, AR, Billing, Asset Management

People Tools: Application Designer, People Code, Application Engine, Component Interface, Security, Data Mover, STAT, Integration Broker, COBOL

ETL Tools: Oracle Data Integrator (ODI), Microsoft SQL Server Integration Services (SSIS)

Reporting Tools: SQR, Crystal Reports, vision, Business Objects, BI Publisher

Databases: Oracle 11g, 12c, Exadata, DB2 and MS SQL Server

Operating Systems: Windows Server 2008, Windows server 2012 UNIX (AIX, HP, Solaris)., Red Hat 5.x to 6.11 AWS Services

EC2: Web Technologies http, html, xml, web services, java scripts, REST, SOAP, Integration Broker

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

Senior PeopleSoft Consultant

Responsibilities:

• Implementation of PeopleSoft HCM 9.2 for 10 UC campuses like UC SD, UCSF, UCLA, LBNL, & UC SD Medical centers.
• Back to back implementations on 10 campuses and medical centers
• Retrofitting of custom SQR’s for tax updates.
• Conversion from PPS to PeopleSoft 9.2 data.
• Handling SOX queries, responding SOX audits
• Created Functional Design Documents and assisted technical teams with their deadlines.
• Worked on the Union Dues projects with 40 plus unions and multiple bargaining units.
• Perform PeopleSoft development activities for UCPath, including HR/WFA, Payroll, Benefits Administration, General Ledger, Commitment Accounting and Absence Management.
• Presented the solutions to campuses and did fit gap analysis.
• Managing and Supporting the payroll of 270,000 employees & NRA employees using PeopleSoft.
• Work closely with UCPath Center to resolve Defects, provide defect-free enhancements and work on critical compliance reports.s
• Worked on Deadlocks and other production critical defects for PeopleSoft Payroll.
• Worked on custom I-131 compliance report for the state of California.
• Developed Glacier interface I-619 for updating Non Resident Alien tax data in PeopleSoft.
• Participate in support rotations, and provide on-call support services to the Payroll support team.
• Experience working in core HR & PeopleSoft TAM.
• Work with various module leads and perform complex data analysis and tests/debugs PeopleSoft production incidents.
• Worked on Integration Broker and handling interfaces.
• Support Security and Payroll related activities, enhancements, Interface developments.
• Prepare Technical Design Documents from Business Requirements and Functional Specifications. production issues related to vendor integrations issues related to Integration Broker both synchronous and asynchronous.
• Prepare test plans, migration documents and STAT CSRs for migrating Defect fixes to Testing environments

Environment: PeopleSoft 9.2, People Tools 8.56/8.57, STAT, SQR, Service Now, Position Management, Self Service, People Code, Change Assistant, Oracle 11g,12c

Confidential, Sunbury, PA

PeopleSoft Payroll Lead

Responsibilities:

• Working as a senior PeopleSoft Lead for the Confidential .
• Develop efficient, well-structured, well-documented technical solutions for HCM
• Worked on complex enhancements and automating the processes, ftp transfers for NA Payroll
• Worked on the conversion of Sage HCM to PeopleSoft HCM.
• Managed complex processes and system design.
• Worked on Kronos integration to PeopleSoft.
• Reduced functional issue resolution timeframes for PeopleSoft payroll issues.
• Experience Working with PeopleSoft Update Manager
• Provided PeopleSoft Counsel to the client
• Creating profiles for users on an on-demand basis.
• Worked with change assistant and app server configuration files.
• Modeling business processes using a variety Design and document architecture at multiple levels
• Performs upgrade and maintenance of PeopleSoft applications, middleware and servers which includes installing new software releases and system upgrades, evaluating, and installing patches.
• Perform third-party vendor assessments and lead proof of concept exercises.
• Orchestrated the lift and shift move to Exadata database.
• Recognized Subject Matter Expert for HCM Solution and knowledgeable of integrated solutions
• Maintaining and supporting the application technically, functionally and administration standpoint.
• Performing system administration tasks such database refresh, applying of tax updates and maintenance patches and bundles and security patches as and when released by Oracle
• Worked in process, scoping, and solution design during transition to Rimini St from Oracle.
• Led the transition from Oracle support to Rimini street which was very challenging and extremely complex.
• Undertook multiple design decisions which helped Confidential to make their system future ready.
• Worked directly with operations and development teams.
• Strong analytical and problem-solving skills. Initiate and execute on multiple tasks, and work effectively, both independently and as a member of a cross-functional team
• Identified opportunities in the system to improve the HR processes.
• Implemented PeopleSoft enterprise application in AWS.
• Aligns business and IT strategies with business goals.
• Technically and Functionally responsible for NA Payroll and base benefits module.
• Redesigning and developing enhancements to support Commitment Accounting mid-period funding changes
• Investigation for migration to IaaS or SaaS for PeopleSoft.
• Worked on both configuration and technical aspects of the PeopleSoft system.
• Worked on Excel to CI to load data.
• Migrations of all changes to environments and system administration experience.
• Documentation for most of the processes from zero to a stable environment.
• Provide functional and technical support to the business users on a regular basis.
• Lead requirement gathering sessions for projects related to Base Benefit and NA Payroll.
• Install and configure third-party applications for PeopleSoft such as WebLogic, Tuxedo, COBOL
• Manages, maintains, and migrates file data on PeopleSoft server systems.
• Work closely with payroll business manager to resolve urgent/time sensitive payroll issues.
• Setting up new roles and permission lists based on changes in the organization.
• In-depth knowledge of the PeopleSoft architectural environment
• Builds effective relationships to achieve business goals and mutually beneficial outcomes.
• Creation of interfaces and programs for sending and receiving data files from vendors.
• Created interfaces for new benefits vendor Unum.
• Build and maintain relationships with the client's technical staff
• Taking care of environment refresh and patches during tax updates.
• Installed operating systems and support applications in the system.
• A good understanding of the configurable aspects of Core HR.
• Strong experience with Linux/Unix commands.
• Lead team and guided, mentored my junior team members on NA Payroll and Base Benefit modules.
• Complete time sensitive tasks in time.
• Provided data reporting support to business and executive managers.
• Extensively used my oracle support website for creating Service requests. Searched and downloaded entire People Tools 8.52, 8.53, 8.54, 8.55 and 8.56 along with the application and documentation.
• Worked with COBOLS and related issues especially during tax updates.
• Evaluates and repairs PeopleSoft system errors and failures
• Ability to multi-task between projects and applications and to manage
• Worked on multiple priorities, while meeting deadlines
• Provide ongoing assistance to PeopleSoft developers and testers to resolve defects during the testing process.
• Extremely organized and worked on multiple initiatives simultaneously
• Worked with security and quarterly access review for organization.
• Documented security and access in the system. Created security and audit reports for Payroll, benefits and core HR. module managers.
• Created customizable audit reports for Payroll, HR and benefits departments separately.
• Working and tuning SQL statements, tablespace maintenance, and schema maintenance.
• UAT testing before migrating any project to Production.
• Applying tax updates patches and upgrades to the environment in an aggressive timeframe.
• Currently involved in leading charge with downloading all executables, PUM images from edelivery.oracle.com and my oracle support site since the client is running of support from oracle and they are moving towards Rimini Street.
• Working with third party system, Kronos for getting timesheet data for payroll processing.
• Extensive knowledge of Unix/Linux commands and operating system, client went from Oracle Enterprise Linux to Red Hat Enterprise Linux Server release, this is complete only for Dev environment and other environments are in work in progress.
• Worked closely with customers, business analysts, and team members to understand business requirements specific to NA Payroll and Base Benefits.
• Detailed Understanding of development and testing methodologies
• Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint).
• As a PeopleSoft administrator responsible for maintaining the overall health of the environment.
• Provide to junior resources within the team and guide them with the Standard Operating Procedures(SOP’s)
• Provide production support to the business related to PeopleSoft application.
• Worked on tasks with no guidance learnt new technologies as per the demand of my role.
• Experience in software development, including web services and APIs
• Handling SOX related queries and executing and creating live audit data on demand for auditors.
• Created multiple custom reports and interfaces to share data files with vendor(s) .
• Developed interfaces for sending files to Equifax for Verification of Eligibility, 401K, COBRA and benefit vendors
• UNIX scripting, java scripts, CSS, AWE and html experience
• Developed interfaces related for Wells Fargo when company moved from BB&T to Wells Fargo.

Environment: PeopleSoft 9.1/9.2, People Tools 8.52, STAT, SQR, Service Now, Position Management, Self Service, People Code, Change Assistant, Oracle 11g,12.1, 12.2, Oracle Exadata, Exalogic, Java, SOAP, REST.

Confidential, Summit, PA

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Working with functional team, end users, offshore and third-party vendors for PeopleSoftprojects related to ELM, core HR, Security and Benefits.
• Excellent customer facing and pre-sales skills, including being able to ingest large volumes of requirements and information in a competitive environment
• In depth understanding of development and testing methodologies.
• Participates in systems analysis and design using development, quality assurance and integration methodologies
• Ability to take on roles requiring co-ordination across multiple technologies and teams.
• Interact with Business to understand the Functional requirements and deliverables and also provide suggestion towards design improvement.
• Translated requirements into client ready design documents including modeling languages such as Unified Modeling Language (UML)
• Worked in Agile methodology.
• Created Audit reports for Payroll to keep track of updates on Payroll tables
• PeopleSoft HCM 9.2 knowledge and experience with configuration.
• Working knowledge of mainframe and program batch execution.
• Involved in writing SQL procedures/queries for Base Benefits
• Experience integrating CRM with other UI & middle tier technologies
• Tested and verified migration of security objects from the non-production environments to the production environment.
• Knowledge of Position Management, Self Service, T&L, Payroll, Benefits and Compensation
• Provide ongoing assistance to PeopleSoft developers and testers to resolve defects during the testing process.
• Extensive work experience with Self-service modules.
• Working with SOAP web services for sharing services with various vendors.
• Used IB to send PERSON DATA to FSCM systems.
• Experience in systems analysis, including defining functional requirements and performing high level design for complex solutions
• Created multiple AE and ExceltoCI for data conversions and AWE.
• Used application packages for getting IB data sent to other systems.
• Worked on effective extraction of data from PeopleSoft for the management.
• Confidential uses PeopleSoft CRM to take care of the customer queries and involved in streamlining that.
• Monitored and communicated all security issues related to business system administration.
• Set up roles, permission lists and created user profiles to establish security for the system
• Involved in cleaning up the copy of production based on the DDDAudit and SYSAudit reports
• Prepare ELM functional documents to streamline with business requirements.
• Performing fit gap analysis and generating reports.
• Helping with conversion from PeopleSoft CRM to Salesforce.
• Develop Requirements Traceability matrix for QA/testing, help in creation of test cases.
• Responsible for analyzing scope, planning, tracking aspects of the project.
• Translate customer requirements into formal requirements and design documents, establish specific solutions and testing that culminate in client acceptance of the results.
• Hands-on experience in scope study, requirements gathering, Functional Requirements, Fit-Gap Analysis, Design, Configuration, Change Management, Risk Assessment, End-User Acceptance Testing, Product Development, Quality Assurance and developing Functional and Tech. Specs.
• Experience with writing ad hoc queries.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Create employee self-service portal for Expense and Time Entry.
• Create the Technical design specifications based on the fit/gap session findings and Functional Design.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Effective in requirement gathering, fit-gap analysis, process and system documentation, system implementations, upgrades, testing, and end user knowledge transfer.

Environment: PeopleSoft 9.1, People Tools 8.53, SQR, Remedy, People Code, STAT, Oracle 11g, CA Service Desk, HP Quick Test Professional (QTP)

Confidential, Jonesboro, AR

Web Developer

Responsibilities:

• Translate manager requirements into formal requirements and design documents.
• Writing reports and working mostly on the design aspects
• Created content for the University website for the English department
• Assisted with the website design and content.
• Worked with blackboard campus management application.

Confidential, Eden Prairie, MN

PeopleSoft Technical Consultant

Responsibilities:

• Analyzing Pages, Components, and Menu Definitions for vulnerabilities ASM tickets. Develop policies, procedures, and strategies related to the use, rights, access, and work flow relevant to security and/or PeopleSoft Human Resources systems.
• Assisting clients with application architecture design, assessment and optimization including definition, documentation and implementation of new application architectures
• Advanced query skills. knowledge Ben-Admin, MSS, ESS.
• Worked with Java Preprocessor directly involved in managing the application.
• Extensive work experience with Self-service modules like ESS and MSS.
• PeopleSoft implementation from 8.9 to 9.2 for Payroll.
• Worked in Fluid pages conversion
• Used Excel to CI to load data into payroll tables.
• Worked with upgrade from and dealt with data conversion, and retrofitting.
• Knowledge of Position Management, Self Service, T&L, Payroll, Benefits and Compensation
• Served as PeopleSoft security liaison between IT and business, performed daily analysis.
• Worked on complex NA Payroll designs and code changes.
• Strong Unified Modeling Language (UML) experience.
• Strong knowledge of HIPAA and PII/PHI and corresponding security measures needed for the same in the solution design
• Understanding of 360-degree view functionality of CRM
• Extensive work experience with third party vendors and application providers.
• Experience with ESP Scheduler and batch processing
• Handled and wrote code for Java Pre-Processor used for hourly employee’s wage calculations.
• SQR reports like zbncdta.sqr and ptax.sqr written from scratch for PeopleSoft NA Payroll.
• Worked in security audits using a wide variety and range of sqls and sqrs.
• Developing security test conditions/scripts and data.
• Worked with iScripts for avoiding the PeopleSoft component buffer restriction.
• Created and maintained requirements traceability matrix for the Confidential requirements.
• Extensively used audit records to provide security to the HCM system.
• Monitored the technical performance related issues of the application.
• Worked in PeopleSoft Security administration and functional aspects of Payroll.
• Used HP Quality Center to achieve Quality and defect management.
• Provided second level support for escalation of ongoing PeopleSoft Production issues.
• Explained the core technical concepts to the end users in layman terms.
• Extensive experience in PeopleSoft Security administration
• Analyze business requirements to identify process improvement opportunities and solutions utilizing PeopleSoft functionality in Absence Management.
• LDAP skills and Directory Services
• Provide 24/7 on-call support using onshore/offshore model.
• Worked with Integration Broker and PeopleSoft Web Services for integrating SIM and CRM to HCM module.
• Solid understanding of HCM functionality including NA Payroll processing, W2, state, federal and FLSA reporting
• Impact Analysis of issues and monitoring the progress made towards issue resolution
• Testing/Fixing of Change Requests. Write system specifications for customizations, reports, queries or other needed specifications
• Developed Payroll & Benefits related queries and interfaces for HCM modules like Absence Management.
• Production support and monitor the jobs. Monitor and report on the status of project to the client.

Environment: PeopleSoft 9.2, People Tools 8.53, SQR, People Code, Application Engine, Benefits and Compensation, Oracle Financials, HP Quick Test Professional (QTP), HP ALM, Oracle 11g/12c, CA Service Desk, UNIX.