Senior Analyst/manager · Hris Resume
SUMMARY
- To obtain a challenging position as a Business Analyst which utilizes my full lifecycle implementation experience and offers opportunities for continued growth and advancement.
TECHNICAL SKILLS
Technical: PeopleSoft 8.9, PS Query, ADP Enterprise v5, ADP Enterprise v4, ADP Reporting, ADP eTime, ADP ReportSmith, ADP Streamline, ADP Pay @ Work, Microsoft SharePoint, HP Quality Center, Toad for Oracle, MySQL, SQL*Plus, SQL Server Management Studio, PGP Encryption, Expert in MS Excel, MS Office, Adobe Creative Suite, Workday Human Capital Management
Languages: HTML, Java, SQL, ORACLE SQR, PeopleCode, eCODE
Databases: Oracle, MS SQL Server, Access
Platforms Methodologies: Windows, Unix, Linux Agile Scrum, XP, Test Driven Development, Waterfall
PROFESSIONAL EXPERIENCE
Confidential
Senior Analyst/Manager · HRIS
Responsibilities:
- Defined system requirements for PeopleSoft 9.2 implementation through functional and technical specifications, led fit - gap sessions with all HR functional areas and assisted with scope of modifications by identifying alternative solutions.
- Managed all aspects of integration of Direct Capital Corporation into ADP Enterprise Version 4 (Ev4). Tasks included data mapping, data conversion, foundational and operational configuration, and reporting.
- Implemented Ev4 and Streamline globally for NACCO Rail. Responsible for project management tasks including project plan tracking, status reporting, and stakeholder management.
- Applied noledge of ADP's HR & Payroll technology, policies and procedures to evaluate and identify reengineering and automation opportunities to improve productivity and help maximize the efficiency of the shared services organization.
- Utilized in-depth noledge of system workflow and systems architecture to make appropriate recommendations for HRIS system upgrades, process improvements, self-service, and outsourcing initiatives.
- Responsible for Quality Assurance of HR and Payroll transaction processing by performing systems audits and validations to ensure appropriate controls were in place to safeguard data integrity and on-going compliance in response to Sarbanes-Oxley requirements.
- Provided functional and operational support for core HR processing, reporting, interface management, and foundation table maintenance. Managed system security access and audits of HR systems and processes.
- Partnered with functional areas including: Payroll Operations, Benefits, HRIT, HR Service Center and Strategic Staffing to develop seamless workflows that provide a higher level of client service
- Authored requirements analysis, functional specifications, system specifications, and scope and vision documents throughout the software development life cycle.
- Responsible for evaluating Workday HCM module with respect to core business functionality requirements and new system initiatives
Confidential
Control Systems Specialist · Americas Payroll
Responsibilities:
- Acted as the Project Manager on a new system implementation that allows for automatic upload of International Assignee Taxation information. System improved the data accuracy by over 75% from the previous business process
- Acted as the QA Manager as part of the Multijurisdictional (State to State) Taxation Risk Mitigation program for travelers. System included individual modules within the PeopleSoft HR and ADP Enterprise Payroll Applications as well as multiple interfaces between the two systems. System enabled Confidential to realize annual reduction of $1.25 Million of withholding audit risk
- Responsible for developing complex SQL queries to support regulatory reporting requirements (DOL, SOX, IRS) for Payroll and Benefits
- Managed all Outbound and Inbound payroll / benefits interfaces with third party applications including ADP Ev5, PeopleSoft HR and Hewitt. Provided production support and Root Cause Analysis for identified issues while ensuring data integrity, security and compliance. Enhanced interface efficiency and production control report accuracy by 92% providing risk mitigation and reduced manual labor by 10hrs/week
- Appointed as SME in PeopleSoft 8.9 and ADP Ev5 Application Testing (Black/White Box, System Level Load, Unit, Regression, UAT, Integration and Functional Testing)
- Acted as the IT/Business liaison by conducting Gap and Impact Analysis when defining new system requirements and troubleshooting application or process issues
- Responsible for managing multiple QA environments across HR business functions while ensuring the numerous project milestones are met
- Managed Payroll processing for approximately 100 International Assignees by working closely with the external vendor KPMG
Confidential
HR Shared Services Change Team · Consultant
Responsibilities:
- Acted as the QA Manager as part of the Multijurisdictional (State to State) Taxation Risk Mitigation program for movers. Authored Functional Specifications Document (FSD) and Use Cases Specifications that included individual modules within PeopleSoft HR and ADP Enterprise Payroll System as well as multiple interfaces between the two systems.
- Developed comprehensive test plans including functional, regression, system and user acceptance tests based on technical specifications.
- Primary liaison between internal cross functional business groups and the offshore development team throughout the software development life cycle (SDLC).
- Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists in PS 8.9.
- Supported production deployment by monitoring systems, tracking issues and solutions. Coached and developed Payroll staff on all aspects of system enhancements including policies, procedures and operation.
- Provided sign-off for all projects prior to production deployment based on review of test results, impact analysis, contingencies.
- Supervised the transmission of payroll outbound and inbound interfaces to ensure data integrity and process compliance. Acted as the single point of contact for data discrepancy issues between HR, Payroll and Benefits systems.
- Wrote complex SQL reports to support Payroll and Benefits regulatory reporting requirements and ad-hoc requests using ADPR, PS Query and MySQL
Confidential
HR Shared Services System Integration Team · Consultant
Responsibilities:
- QA Lead for the payroll and benefits system upgrade from ADP PCPW TO ADP Enterprise Version 5 for approximately 5,000 employees in North America.
- Reviewed business requirements documents and authored technical specifications through peer reviews and walkthroughs. Responsible for driving continues process improvement by recommending and implementing improvements to efficiency and quality on policies, procedures and systems Interface
- Executed test cases inADPEnterprise 5.3 and PeopleSoft HR 9.0 using automated batch loads and manual data entry. Test objectives including execution steps and expected results were logged in HPQC
- Maintained compliance with Sarbanes-Oxley legislation and updated pay policies according to federal, state, labor and tax regulations for multiple locations, states and jurisdictions throughout project lifecycle.
- Prepared monthly, quarterly and year-end reports for senior management utilizing ADPR and PS Query Manager. Wrote complex SQL queries to validate tax filings were accurately prepared by third party vendor
Confidential
Human Resources Information Systems · Consultant
Responsibilities:
- Responsible for creating complex ad-hoc HR reports for senior management, regulatory industries and third party vendors using PS Query, PeopleTools, PeopleCode, SQR, Crystal, Oracle procedures.
- Enhanced/modifiedexisting PS 8.9 customized SQL/SQRs to improve performance using advance features like Load lookup and Arrays as well as analyzed the Component Processor Flow to determine a more efficient PeopleCode program order
- Executed System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
- QA Manager for process modification requests in PS HR 8.9 including new records, fields, pages, components and menus using application designer
- Appointed as SME in data remediation among multiple HR systems and Sarbanes-Oxley (SOX) compliance regulations. (Black/White Box, Regression, UAT, and Functional Testing)
- Involved in designing, developing and testing customized PeopleSoft HR enhancements to the Payroll, Time & Labor and Base Benefits modules and issue tracking in HP Quality Center
Confidential
Human Resources Information Systems · HR Assistant
Responsibilities:
- Managed IBM WCM databases associated with the company’s internal web-based information portal
- Partnered with IT system developers on establishing an enterprise-wide PeopleSoft HRMS platform that spanned multiple Verizon Business Units
- Acted as the QA / Testing Manager for system upgrade to PeopleSoft 8.9 from Alltel
- Accountable for implementation and management of PeopleSoft ELS security tables in compliance with PwC and SOX Requirements
- Created PeopleSoft HRMS 8.9 troubleshooting documents for Production Support Team
