SUMMARY:

• 7+ Years of experience in PeopleSoft HCM Implementation, Design, Customizations, Upgrades, Reporting and Production support Projects using People Tools.
• Worked on PeopleSoft 9.2 Core HR, NA Payroll, Talent Management, Workforce Administration, Time and Labor, Absence Management, Employee Self Service, Payroll, Base Benefits and Dash - boarding.
• Expert in designing reports in SQR, Crystal Reports, BI Publisher, PS Query and PL/SQL scripts used for databases and integrations.
• Experience in implementing and supporting integrations and HR reporting including coexistence of PeopleSoft HCM with Oracle HCM cloud (HCM Fusion), Oracle transactional business intelligence (OTBI), and Taleo Client Connect (TCC).
• Technical knowledge of PeopleSoft HCM 8.x/9.x, People Tools 8.4x-8.5x, XMLP Publisher, Application Engine, SQR, People Code, Component Interfaces, File Layout, Application Packages, Integration Broker, Object/Definition security, Data Mover, Process Scheduler, PL/SQL Oracle, PS Query, PeopleSoft PIA Security and Portal Technologies.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader(HDL) Tool which includes Workforce structure data, Worker data, Work relationship data and Salary info.
• Expertise in File-based loaders (FBL), Spreadsheet loader, PeopleSoft Payroll Batch Loader(PBL), OTBI Reports, BI Publisher reports, HCM Extracts.
• Expertise in Configurations, Personalization, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.
• Experience of end-to-end HRMS/HCM implementations and post-production support and SOX compliance, conducted fit-gap sessions with HR, Pension, and Benefits business groups and gather business requirements for the Upgrade.
• Experience in Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI and experience in managing HR data requests and Assemble, analyze and format data into useable reports.
• Have Configured Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings, Voluntary & Involuntary Deductions, Pre-Tax elements, Employer Liabilities, etc.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
• Extensive work experience in understanding of Time Reporting Codes, Workgroups, TRC Programs, Value Lists, Template Built Rules and Custom Time & Labour Rules.
• Extensively used File-based loader (FBL), Spreadsheet Loader and Payroll Batch Loader (PBL) for Migration/Data loading/Conversion of several business objects related to Core HR as well as Payroll modules.
• Expertise in coordinating and bridging gap between IT and business to exchange ideas, leading geographically dispersed teams to resolve issues and roll out innovative and strategic reporting roadmaps utilizing key performance Indicators (KPI's) and business performance metrics.
• Proficient in troubleshooting issues using a methodical and analytical approach in solving the issues and focused on end user satisfaction.

TECHNICAL SKILLS:

ERP: Core HR, Payroll, Base Benefits, Benefits Administration, Time and Labor, Payroll Interface, Employee Self Service modules, General Ledger, Accounts Payables, Accounts Receivables, Purchasing, Inventory, Expenses, Resource Management, Projects, Budgets, Asset Management and Time Collection Devices (TCD)

People Tools: Application Designer, Application Engine, Application Package, Web Services, PeopleSoft Internet Architecture, PeopleSoft Upgrade, Process Scheduler, Workflow, Component Interfaces, Integration Broker, People Code, Data Mover, PS/Query, Upgrade Assistant, xml Publisher, AWE.

Reporting Tools: SQR 3.x/4.x/6.0, Crystal Reports

Programming: People Code, SQL, PL/SQL, C, C++, Visual Basic 6.0/7.0, HTML, XML, JavaScript, Java and VBScript

Database: Oracle 11g, 9.i/8. i/8, SQL Server, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Erlanger, KY

Sr. PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Worked on multiple Projects & Involved in the production & support and upgrade of HR/Benefits/Payroll, Time & Labor modules using PeopleSoft 9.2 and People tools 8.54, developed conversions programs to load Payroll and Benefit tables in PeopleSoft using SQR and Import manager.
• Led the data extraction project from. This involved extracting data out of PeopleSoft initially to help configure all the required hierarchy organizational data required prior to extracting the employee transactional data.
• Used Application Engine Program, PS Query, SQR and complex SQL statements extensively for multiple purposes including - reporting, database mass updating, third party outbound and inbound interfaces, data reconciliation/manipulation and conversion of data from PeopleSoft modules
• Created Workgroups, Rule programs, Value lists, Defined Schedules, shifts and Time periods, Build Calendar. And had helped users in understanding the Time & Labour rules and how Time is calculated in PeopleSoft.
• Made changes to the existing custom load process to retrieve payable time from T&L. successfully loaded the payable time to payroll using custom load process.
• Worked with in projects involving multiple enterprise wide, large scale PeopleSoft HCM application Implementations, enhancements, upgrade projects and support and management engagements from Onsite, Offshore).
• Worked on configuring new departments, company, pay group, locations, earnings, deductions and action/action reason data into PeopleSoft.
• Have performed multiple Client Interfacing roles - Technical Consultant, Test Lead, Business Analyst and Support Lead for PeopleSoft HCM Systems.
• Developed Queries using PS Query and export the results with Microsoft Excel and Crystal Reports to perform further calculations and made reports.
• Involved in resolving the trouble tickets and issues related to custom reports and processes and worked with the People Tools 8.54 Integration Broker and involved in setting up the local gateway and created different target nodes as per the requirement.
• Worked in modifying the SQR interfaces/reports based on the regular service requests by first preparing the design and impact analysis. Reports included Absence History, Employee Review Audit, and Department Salaries using SQR and Crystal Reports for HR to name a few.
• Submitted processes to process scheduler to run daily tasks at a time or run recursively by creating a Recurrence definition to run at specific intervals.
• Design and Development of Interface programs to move data from Corporate Directory Services into PeopleSoft tables and involved in Data mapping between the two systems.
• Developed Application Engine programs and used File Layout and Component Interface to load data from flat file to PeopleSoft system. Written and modified People Code for validations.
• Developed and customized on-line pages and menus using People Tools and worked on PeopleSoft Security, online application & data and had good exposure to security administration.
• Worked with Payroll Users in updating Pay sheets and calculating salaries for a specific pay period to perform pay in Payroll module and used pay calculations to calculate employee's gross pay and process manual checks.
• Worked on Benefits Administration in resolving Ben Admin issues, worked closely with Benefits team for requirements gathering and converting functional requirements into technical requirements and developed the functionality.
• Supported Payroll (Payroll Administration - Pay Sheet, Pay Calc & Pay Confirm Processes) and worked on issues related to payroll.
• Maintained 150+ integrations and batch processes in PeopleSoft daily from source to target systems including schedules and vendor communications with major vendors in Recruiting, Benefits, Payroll and Stocks etc.
• Did HR Reporting, Data analytics and visualization using PeopleSoft Reporting tool, Alteryx and Tableau desktop reporting on the company portal.
• Did requirement gather, Effort Estimation, software development in Minor and Major enhancements, Unit Testing, Review, Offshore-coordination.

ENVIRONMENT: PeopleSoft HCM 9.2, People Tools 8.54, Oracle 11i, SQL*plus, SQL Tools.

Confidential, New York City, NY

PeopleSoft HCM Functional C onsultant

Responsibilities:

• Provided project-wide troubleshooting in PeopleSoft development tools, application and tools SQL, and Oracle DBA-related challenges and configured the PeopleSoft Payroll system which included Earnings codes, Earnings Programs, Pay-groups, Pay Calendars, Pay Run Ids.
• Debugged issues related to several payroll processes which included Load Time and Labor, Pay Calculation, Pay Confirmation, completed in-depth analyzes of PUM images delivered by Oracle which included identifying bug fixes as well as identifying new enhancements which have been delivered.
• Set up Time Reporting codes, Time Reporting programs, Workgroups, Rule programs in PeopleSoft Time and Labor and built Templated built as well as Custom Time and Labor rules, managed all verification and validation activities for all production modifications including projects, releases and changes.
• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 9.1 and People tools 8.53
• Extensively worked on lot of Interfaces (In & Out bound) and Reports for converting data from AS400 system to PeopleSoft and responsible of the design, development and testing of all HR, Payroll, Benefits and Ben Administration.
• Customized and implemented PeopleSoft HRMS modules, customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Extensively involved in performing customizations to the HR application by creating new fields, pages and components, used File Layout Definition tool to get data from the legacy system.
• Worked on setup of Set ID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System Generated SQR reports to create summary reports on payroll details check and validate the data.
• Submitted absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enabled plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise e-Benefits Self-Service Estimate Pension function.
• Involved in PeopleSoft Enterprise HCM solutions to integrate pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.
• Developed, modified and debugged People Code and Application engine programs, analyzed the Component Processor Flow to determine where People Code programs can be placed more appropriately.
• Used Application Engine, People Code and SQR extensively to create processes, outbound files and reports, designed an application engine program using File Layouts to load New Hire interface file with all New Hired employees' information after each day and load them into the people soft tables.

ENVIRONMENT: PeopleSoft HR, Payroll, Ben Admin, T&L, TAM, ESS PeopleSoft HCM 9.1, PeopleSoft HCM 9.2, People tools 8.53, People Code, Web logic, Toad, Oracle 11g.

Confidential, Miami, FL

PeopleSoft HCM Functional Consultant

Responsibilities:

• Conducted user interaction sessions to allow business owners and users to gain familiarity about the new functionality delivered in HCM 9.1
• Analyzed existing Time and Labor configuration, which included Time Reporting Codes, Time Reporting Programs, Workgroups, and Value Lists to make sure the configuration has been set up correctly.
• Responsible for the design of Inbound and Outbound interfaces in Time and Labor, retrofitting Time and Labor Rules, set up Time Calendars, Manager Time Calendar view options, Compensatory Time Plans.
• Defined Exceptions, PeopleSoft Application Engine sections, Validation criteria, Override reason codes, worked on mapping the Time Reporting Codes to Earning Codes, Created Leave Plans and Benefit Plans as well Benefit Programs.
• Responsible for Requirements Gathering and Fit-Gap Analysis proposing workable solutions to develop new functionality and some workarounds.
• Involved in the reviewing, writing & execution of Test cases pertaining to Time and Labor, Core HR and Payroll and supervised the team to make sure about the configuration needed for 9.1 version, created and maintained a configuration document.
• Implemented the solution design decisions and tailors the designated application to meet the requirements of the end users, configured and set up the online rule processing in Peoplesoft Time and Labor.
• Implemented workflow using Approval Framework (AWE) for Time sheet Approval and responsible for coordinating status reports, updates for the solution they are responsible for, as well as participating on teams and working with the end-users to assure that requirements are incorporated within the solution design.
• Worked closely with the business customers to create new customized BI dashboards, responsible for assisting and assigning work to team members and assuring timely completion of project milestones and deliverables.
• Prepared Test plans, which included Test scripts to make sure SIT, UAT are completed in an efficient manner and supported Bi-weekly Payroll Processes, Holiday Payrolls and Time& Labor processes, which included Time Administration, Batch Approval and AWE.
• Designed and configured multiple Time and Labor rules using a delivered template, custom SQL objects and User Exits.

ENVIRONMENT: PS HCM 9.1 (HR, Time and Labor, Payroll NA, Core Benefits), PS Tools 8.53, People Code, Application Package, Application Engine, SQR, IB, Workflow, Web Services, AWE, XML, XML Publisher, Oracle 10.1

Business Analyst

Confidential, California, CA

Responsibilities:

• Worked with Generic templates in creating a new Email Notification Template which is used to send Emails to Retire and terminated employees with hyperlink containing encrypted employee data to complete the survey.
• Worked on BI- Publisher, XML reporting to generate PDF reports, created new pages, permission list, roles and registered them in PeopleSoft portal.
• Maintained PeopleSoft user security using user profiles, roles & permission lists and conducted internal sessions on the Complex Work Units which helped the team in understanding the functionality.
• Participated in the fit gap sessions with the functional consultants and business users and was responsible for creation of technical design documents from the business requirement & functional documents.
• Supported reports and HR interfaces, New Hire and Department Change report and worked Extensively with Component Interface and App Engine.
• Created Dynamic Security Roles, Permission lists, Row level security and attached them as applicable to maintain data security for the components.
• Participated in walkthrough and defect report meetings periodically and created Test plans and Test Cases as per the business and Technical requirements.
• Coordinated disparate technical/functional teams to create design and deliver on-time solution, prepared Requirement Traceability Metrics and Test documents by analyzing the Functional and Business Requirements and prepare Test plans based on it.
• Played key role in Functional, Integration and Regression testing, created DMS scripts to move the setup data from the UAT environment to production.
• Responsible for defining the scope of the project, gathering business requirements and preparing Business Requirement Document (BRD), and Functional Requirement Document (FRD)
• Used agile development process to deliver software throughout the SDLC life cycle absorbing changes and new requirement as the project proceeds
• Involved in multiple phases of SDLC for enterprise level projects, as a client facing consultant, with a focus on the Microsoft platform. Responsible for leading and supporting various projects, as a trusted advisor, for publicly traded clients in a Waterfall and Agile environment.
• Developed process flow diagrams (flow charts) using MS Visio to identify and analyze process flows and gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing, created project plans, taking into consideration projects mission, process flow, timelines, requirements, and documentation.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

ENVIRONMENT: Agile, SDLC, Waterfall, PL/SQL, Toad, MS Excel, SQR's, Crystal Reports, testing.