SUMMARY:

• Expertise 7+ years of experience as Peoplesoft HCM that includes Implementation, Upgrade, and Production Support of peopletool8.9, 9.x HCMmodules. In - depth experience in analysis, planning, development, and implementation stages, including load testing, quality assurance, and tuning.
• Analyzed current business processes and recommended ERP for companies. Implemented ERP (BSTI) for Master data, Accounting, Inventory, Order Processing, Bookings and Quality Modules.
• Involved in test data generation, designing complex scripts and regression testing of HCM and ELMsystem for SIT and UAT phase.
• Strong Expertise in Implementation, Up gradation, Data Conversion from Legacy to PeopleSoft including data mapping, File Layouts, Data mover, SQL, Interfaces from module to module and legacy to PeopleSoft Modules.
• Gathering Business, Functional and Non-Functional requirements for e-Commerce applications software projects that will identify and define the scenarios and data required to setup HRIS Audit on line fulfillment system in an E-Commerce platform.
• Extensively worked on Data integration tools like Connect & WIM also versed in integration of systems between HRMS and various Payroll systems.
• Involved in end to end project life cycle (SDLC) starting from initiating the kick-off meetings, Requirements definition, Preparation of effort estimates, Handling client approvals, Solution design-Statement of Work/Business requirement documents, Coordination with the Business, Development team & Testing team to ensure quality deliverables. Creating test plans, coordinating UAT with the Business Users.
• Experience inPeoplesoftUpgrade Methodology having worked on upgrades from 8.9 to 9.1 & 9.0 to 9.2.
• Installation and configuration of web logic 6.1, BAM 8.8, People Tools 8.42, Tuxedo 6.5/Jolt 1.2, Application Server and Process Scheduler on AIX 4.3/5.1 environments.
• Expertise in peoplesoft Concepts, tools and technologies like Application Designer, People Code, People Tools, Application Engine, Integration Broker, Workflow, AWE, Component Interface, PS Query, Process Scheduler, Security, Data Mover, SQR, XML Publisher, PS Query, File Layout, Integration Broker, Excel to CI, Web Services.
• PeopleSoft HCM 9.2, Process Scheduler (UNIX and Windows), Application Server (Tuxedo), Web Server (Weblogic), Application Designer, Data Mover, Integration Broker, SQR, BI Publisher, Change assistant and Oracle SQL 11g.
• Extensive experience on support and enhancement of peoplesoftHRMS - Time & Labor, North America Payroll, Core HRMS, Manager Self Service, Employee Self-service, Compensation and Profile Management.
• Hands-on experienced in Client / Server, 3 Tire Architecture and Application Server, worked on SQL Language Definitions such as DDL, DML and DQL, functional knowledge, in addition to Design, Fit-Gap Analysis, Implementation and Upgrade.
• Developing and customizing reports using reporting tools such as SQR, PS Query, Crystal Reports, BI Publisher (XML) and nVision.
• Partner with HRIS to articulate correct requirements for development and Design.
• Have excellent data modeling, analytical and problem solving skills and very good team player with excellent communication skills. Excellent Troubleshooting and enhancing skills.
• Serve as Consultant on PeopleSoft 9.2 HCM/Oracle 8.56 platform Implementation Project from client legacy system ADP (Automatic Data Processing), for HR, Manger Self Service, and Employee Self Service, Position Management, Benefits, Time and Labor, Compliance Management, Absence Management, and North American Payroll modules.
• Conduct walk-through sessions with the client and provided functional knowledge of PeopleSoft 9.2 Business Processes using fluid or navigator.
• Perform data mapping of ADP configuration codes with PeopleSoft action and action reason codes.
• Participate in the configuration of MSS Transactions using Auto Job data updates for Reporting Changes, Promotions, and Terminations. Document the business process flow for end-users.
• Assist end users in executing data transaction through Fluid or Navigator for Timesheet Entry, MSS/ESS, Position, Job data, Paysheets, and OneUSG customizations. Create queries for resolving data issues and provide end users reports.
• Resolve Timesheet issues for employee’s absences and punches, unapproved reporting time, and TL compliance.
• Designed and Developed Dynamic PS Query report using People code based on the input parameters provided on the page in order to reduce the complexity of conditions in where clause.

PROFESSIONAL EXPERIENCE:

PeopleSoft Functional HCM/Payroll Functional Consultant

Confidential, Seattle,WA

Responsibilities:

• Implemented Base Benefits and Affordable Care Act as per OPM guidelines. Converted OPM guidelines to Business requirements for implementing Affordable Care Act.
• Day to day Interactions with client to clarify requirements and provide input and advice regarding PeopleSoft (HCM/FSCM), Kronos and other ERP capabilities.
• Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, PeopleSoft Payroll Interface and Fusion Benefits from Oracle Cloud systems in HR Achieve.
• Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
• Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting
• Planning and delivering CRM strategies across the company encouraging customer retention and customer loyalty. ... Overseeing direct communications with customers through the CRM.
• Responsible to Maintain,Upgrade and Patch ERP System,Write reports using Crystal, Excel or SSRS,Define and document ERP procedures and, train users on ERP functionality .
• Troubleshoot and resolve all problems ERP related.
• Primary contact for newer employees within the company at ELM helping with questions and guidance to ensure new employees fully understand situations they may encounter.
• Worked on setting up the Benefit rules, rates and plans for Medical, FSA, and Long Term Care Setup the ACA Eligibility rules for Benefits Enrollment and Termination. Involved in testing the Interfaces to FEHB, OPM, RITS and GL.
• Created a mapping document for HR and Personal Conversion between ADP system and PS HCM 9.2. Developed conversion programs (using Application Engine) for HR, Personal and Taxes.
• Developed Payroll Conversion program using Application Engine between ADP and PS for Fed Tax, State Tax, Local Tax, Balances (Deductions, Earnings and Tax), Direct Deposit Distribution, Garnishment Details, Pay Check, Pay Line, Pay Other Earns and Pay Special Earns.
• Set up Time Reporting codes, Time Reporting programs, Workgroups, Rule programs in PeopleSoft Time and Labor.

  Planned implemented and configured PeopleSoft Payroll Tax tables that included State Tax tables, Garnishments, Deductions.

• Configured Employee State Tax data, Direct Deposits and Garnishment Overrides and Successfully Set up and configured Pay check Modeler in PeopleSoft HCM 9.2. Worked on creating Tax Form Definitions, Tax Form print Parameters and Loading Year End Data records and involved in other Year-end setup.
• Created Dashboards, Workcenters for various Payroll requirements. Extensively used Fluid to create Payroll specific tiles.

  Managed all verification and validation activities for all production modifications including projects, releases and changes.

  Involved in testing Time and Labor scenarios such as Time reporting, Adjustments and Time interface to external database.

• Troubleshoot Payroll issues as part of daily production support and supporting N/A payroll for Semi-Monthly, Bi-Weekly and LTIP payrolls in order to confirm the checks in the timely manner.
• Redesigned most of the Time and Labor rules and written most complex rules to stabilize the environment and tested all the rules by compiling and running the time and Admin process.
• Performed initial analysis on System requirements and evaluated the existing Payroll & Time entry system to come up with impact analysis, necessary customizations which would be required once the move to People soft Time and Labor would be accomplished.
• Performed end user training, which included Rule Development, Rule Migration best practices, Self Service for Time and Labor employees.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• Supporting Payroll activities like SIF Creation, Invoice Creation in AP to Nine Business Groups for smooth closure in Oracle HRMS (EBS R12).
• Monitoring and supporting 20 Integration between Fusion and EBS in case of any issue debugging the same to fix.
• In preparation for EBS R11 to R12 Upgrade developed training guides and conducted training in the following areas:
• Created roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Involved in the Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Developed and implemented proactive leave administration processes, programs and communications to improve the management and compliance.
• Administered leave of absences process; coordinated, managed and tracked FMLA, short- term disability, long term disability and company's leaves.
• Coordinate, track and manage all company leaves of absences - including FMLA, state and municipal leaves, company provided leaves, military leave, jury duty, etc.
• Intake of leave requests through HRIS/payroll systems-including sending required notices, forms and letters and determining leave eligibility and leave approvals/denials and re-certifications.
• Communicate with employees, managers and human resources professionals to coordinate the return to work process, including accommodation requests and leave expirations.
• Consult with benefits department, as needed; to coordinate changes to benefits as a result of employee's leaved.
• Develop, generate and present reports on a regular basis to analyze leave data.
• Involved documenting the functional and technical impact analysis for the P5 (Payroll processing partitioning) Project. Gone through a lot of internal and external interfacing applications, functional components and the complete PeopleSoft Application Engine, Batch, Custom, delivered modules, SQRs, COBOLs, JCLs and ESP part of their impact analysis exercise.
• Collaborate with functional and technical staff to coordinate integrations with vendors as well as internal applications.

  Research and resolve the applications issues.

Peoplesoft HCM Time and Labor/Absence Management

Confidential - Greensville, SC

Responsibilities:

• Involved in analyzing business needs and worked with technical resources to develop, design and test the solution for customizations, interfaces and reports.
• Configured General Element Information such as Data Retrieval Elements, Calculation Elements, Organizational Elements, Industries and Categories, Element names etc in PeopleSoft Global Payroll.
• Conducted various workshops and brain storming session with the client to make them understand what the new system offers and how their specific requirement can be mapped to current system flow.
• Also worked extensively to solve user issues in Position Management, Performance Management and Absence Management and Payroll during post production support.
• Also worked on Full Position Management for MSS functionally for various custom modules. Involved in development retrofit and Unit Testing of Core HR and e-Performance Module.
• Configured TCD Supervisor, TCD Task Profile and TCD Task Templates.
• Configured both XML and Flat file integration with TCDs.
• Configured Integration Brokers with TCD, resolved issues with Services, which would read TCD data into Peoplesoft.
• Configured Time clocks to interface with the Peoplesoft Time and Labor system.
• Configured Time Reporting codes, Time Reporting Programs, Workgroups, Rule Programs, Value Lists in Peoplesoft Time and Labor.
• Set up, run and validate the output from the jobs associated with the processing tasks, including processing and running on-cycle payroll weekly and off-cycle payrolls as scheduled or necessary each week.
• Special processing of weekly queries and reports to ensure the accuracy of employee payroll, HR and benefit information including earnings, deductions, payroll taxes, and leave balances.
• Managed a job-reclassification project. Conducted occupational research to determine if job titles were in sync with workplace norms.
• Performed a variety of payroll and human resource functions, such as creating and run ad hoc queries in PeopleSoft in support of departmental operations and projects.
• Created graphs and handouts, also preformed data integrity audits, verify table entries and key cross-reference tables in support of projects.
• Responsible for defining the test pan, analyzing the test scenarios, preparing test case document, defining the performance environment requirements specifying report templates and conducting the scripting, benchmarking and interpretation of results.
• Supported Payroll (Payroll Administration - PaySheet, PayCalc and Pay Confirm Processes) and resolved multiple issues related to payroll.
• Set up Time Reporting Codes, Time Reporting Programs, Workgroups, Holiday Schedules, Compensatory plans and Value lists.

Environment: PS HCM 8.8 (HR, Time and Labor, Payroll NA, Core Benefits, Absence Management), PS Tools 8.54/8.55, PeopleCode, Application Package,, AWE, XML, XML Publisher, Oracle 11G/12C Environment: PS HCM 9.2 (HR, Time and Labor, Payroll NA, Core Benefits, Absence Management), PS Tools 8.54/8.55/8.56 , PeopleCode, Application Package, Application Engine, SQR, IB, Workflow, Web Services, AWE, XML, XML Publisher, Oracle 11G. Workday HCM (Core HR, Compensation, Benefits, Time Tracking, Payroll and Security).

Peoplesoft HCM Consultant

Confidential -Westlake,TX

Responsibilities:

• Involved in the production & support and upgrade of the PeopleSoft HCM 8.8 (HR, Benefits and Benefits Administration, Payroll, E-performance, Time & Labor) modules based on organizational needs and requirements.
• Performed the Fit - Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Extensively worked on Tax Updates in functional implementation parts and involved in year-end tasks particularly by applying payroll tax updates for running the payroll as expected.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Applied Engine, People Code Fix Packs, Maintenance Packs, Service Packs and Tax Updates, as well as regular tax updates, patches & bundles to all relevant instances applied the Bundles, patches Tax Updates and resolved issues related to year-end processing.
• Designed screens and setting up for the Talent Acquisition, Candidate Gateway, e-Recruit for End Users, and assisted training manager in designing HRM Send-user training documents and prepared Standard operating procedures (SOP)
• Identified all the Business Process, Desktop reports and evaluated the required Business processes reports in Core HR.
• Improved the Absence Approval page in Manager Self-service in order to update or delete the approved absence and established up the Absence Data and Developed Report for Employee Absence and Track Vacations.
• Designed solution for one-time deductions and retro adjustments for any adjustments that will be processed by the benefits vendors.
• Onboarding of Insight acquisitions (BlueMetal, Datalink, and Cardinal Solutions) into our CRM environment from different CRM systems (Salesforce and Microsoft Dynamics). Instrumental with source- CRM data extraction and loading, field mapping/migration, and the recreation of business processes, reporting, and automation in target- CRM .
• Made changes to current benefits system to process benefits using base benefits.
• Involved in the cut over tasks and validations during the go live time for Recruiting, Benefits and Benadmin modules.
• Assisted in developing Project Proposal, Business Case and Business rules.
• Gathered business requirements from stakeholders and translate them into detailed requirement specifications.
• Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Performed requirements gathering process in iterative approach using RUP methodology.
• Prepared Business Requirement Document (BRD) and Software Requirement Specification (SRS)
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Worked in designed and development of Project document templates based on SDLC methodology.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Work with architects and Business Analyst to design SRS as well as HLD.
• Performed Gap analysis and implemented updates for the Data Warehousing Application.
• Managed and documented the change requests.
• Maintained Requirement Traceability Matrix.
• Understanding the key concepts of SWIFT messaging and the routing rules set up for delivering the trade messages to the providers.
• Involved in User Acceptance testing (UAT) and validation of the application

  Environment:SQL Server 2000, Visual Basic, Sybase, MS Project, MS excel, MS Word, MS Visio, and MS Power point

Business Analyst

Confidential - Atlanta, GA

Responsibilities:

• Understand business requirements from user interviews to convert requirements into technical specifications.
• Conducted joint requirements planning sessions with stakeholders (fixed income business heads) and SME's (Information Technology, Risk and Operations) to gather requirements for FRD (Functional Requirements Document)
• Used Rational Unified Process as the development methodology to plan project time-line and other project deliverables based on different phases in the project.
• Used SQL queries for data validation, involved in UAT, executing test cases, evaluating test results and preparing test summary reports.
• Proactive in responding to client inquiries and resolved discrepancies. Identified, prioritized, tested and proved essential business functions to assure compliance with vendor and internal auditing.
• Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with outside vendor relationships.
• Created Use Cases and Use Case Diagrams to define the Functional requirements of the application using MS Visio. Used MDM for Data storage and normalization.
• Generated Unified Modeling Language (UML) diagrams such as Activity, State Transition, Sequence Diagrams and Workflow Diagram to demonstrate critical processes.
• Excellent experience in design and development of Data warehousing solutions and generation of OLAP reports.
• Involved in the Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.

Environment: SQL Server 2000, Visual Basic, Sybase, MS Project, MS excel, MS Word, MS Visio, and MS Power point