Sr. Workday Consultant & Test Lead Resume
Akron, OH
SUMMARY:
- 9+ years of work experience in Information Technology/Systems focus on ERP business Applications - Workday HR and SAP.
- Workday integration and HRIS consultant, having 3 years’ experience in Workday implementation and production support.
- Worked in one full life cycle Workday HR implementation project including production support for HCM, Compensation, Payroll and Time & Absence modules implementation. Experience in all phases of the implementation lifecycle - discovery sessions-requirements gathering, analysis, design, development (P1, P2 and P3), testing & deployment.
- Expert in Workday Integrations, reporting and HCM Functional business process.
- Workday Pro Studio(Integrations) program completion- Certified.
- Trained in following Workday classes from Workday Education: Workday Configurable Security Fundamentals, Workday Report Writer, Calculated Fields, Integration System Fundamentals, Workday Simple Integrations and Workday Advanced Studio Training.
- Experience working on Workday EIB inbound & outbound Integrations, Workday Studio, Cloud Connecter & Document Transformation, Workday Studio, Repot writer and Calculated fields.
- Good understanding & knowledge of all Workday Integration tools, Workday Architecture & Business process framework.
- Developed technical design documents for workday HCM, Payroll and Benefits integrations and created data mapping design documents as per the integrations systems requirements.
- Developed, porotype and configured several Workday integrations (EIB, Studio Integrations, and Core Connectors) and Reports.
- Reviewed the integrations of the implementation partner and performed end to end testing of the integrations.
- Developed custom XSLT modules for Workday interfaces and document transformations in order to accommodate specific web service based interface requirements.
- Experience in using PGP encryption to deliver & receiving (SFTP) the workday integration files to/from client workday tenant, client internal systems, external vendors in order to provide HCM data for benefit purposes, Time, Payroll, Travel & Expense, Active directory and FI GL postings.
- Experience in working with external vendors for Import and export data to/from Workday via RaaS and Web Services.
- Experience in using the XML, XPATH, WSDL and XSD. Ability to write XSLT transformations to transform the web service requests to meet the integration technical requirements.
- Experience in deploying Web Services and API’s in Workday Studio.
- Worked with Workday implementation partner integrations team to schedule the integration (120+) runs in production tenant & identified the integration runs timing issues and made fixes in production & during Workday cutover deployment period.
- Developed workday custom reports and worklets. Supported client users to analyze, troubleshoot and resolve production issues with calculated fields, security issues, and integration failures.
- Experience in working with data conversion teams for extraction, data cleanup, and data validations for Workday data conversion activities from legacy SAP HCM system.
- Lead Workday QA team. Developed and owned overall Test Plan. Reviewed test plans and test documents (Test Scenarios / Test Strategy / Test Cases) to ensure all Workday integration test requirements are covered in scripts.
- Created & assisted the QA team for developing test scenarios for testing all in scope Business Processes like Hire, compensation changes, Job Changes, terminations, employee master data changes, Employee Self Service process, and Manager Self-service processes, etc.
- Liaise with HR Business Partners, Payroll, Time & Absence teams and other internal departments and third party vendors to gather requirements, developed test plans and test scenarios for Functional, End to End, System integration, User Acceptance and Parallel/Check to Check Acceptance testing in workday prototypes build - P1, P2 and P3.
- Worked in two full life cycles SAP HCM implementation projects starting from business phases Business Blue Printing (design), Go-live preparations (Realization and testing), Go-live, User acceptance and Production Support.
- Experience in SAP HR implementation, testing and support of SAP - HR modules, Success factors, BOBJ reporting, FI and ETL data validation.
- Worked as a Global HRMS test lead for Confidential to implement new Global SAP HR system in Europe and Middle East (EMEA), Asia (APAC), Latin America (LA) and North America (NA) regions - 14 rolling waves implementation for total more than 60 countries.
- Used HP Quick Center (QC)/ALM and SharePoint tools for gathering requirements, planning and scheduling tests, analyzing results, and managing defects and issues, for test management.
- Prepared, User Training Manuals and provided User Training to the end users on the processes during UAT testing and regression testing.
- Good communication skills, strong research, analytical and problem solving skills with ability to work independently and team player attitude.
TECHNICAL SKILLS:
Workday Integrations: Calculated fields, Custom reports, Cloud Connects, Core Connectors, Document Transformation, EIBs, Studio integrations, Web services (SOAP & REST), XML, XSLT, XPATH, WSDL, XSD.
Workday Functional::
HCM Processes, Condition rules & Security Configuration
Databases: Oracle 10g/11g, SQL Server 2008 R2/2012, MS Access
SQL, T: SQL
Operating Systems: Windows and Linux
Business Objects, Excel, Workday: Report Writer
Data Warehousing & BI: Oracle EDW, SQL Server, BOBJ, SQL Server 2008/2012 Analysis Services and SQL Reporting services
PROFESSIONAL EXPERIENCE:
Confidential, Akron, OH
Sr. Workday Consultant & Test Lead
Environment: Workday 27 - HCM (ESS/MSS), Payroll, Time and Absence, SAP ECC 6.4 - HR, HPQC and SharePoint
Responsibilities:
- Primary duties include business requirements gathering & system analysis for HCM, Integrations, reports, Security, testing and managing QA team for HRO2020 Workday project.
- Developed Integrations using EIB, Core Connectors and Studio integrations and developed Custom Reports for various functional areas.
- Production day to day support of Workday HCM, Integrations, Security and Reporting issues
- Assist the data conversion team to deliver the workday data loads workbook for P1, P2, P3 and Gold tenants build.
- Built several Workday Customized Reports for security related ad-hoc reporting requests.
- Maintained and run EIB to perform mass uploads such as loading one-time payments in compensation, deductions and earnings for payroll.
- Developed client payroll, time off and on EIB integration templates for import payroll input data into Workday.
- Validated the payroll calculations for employees during P1,P2 and P3 testing by manual inputting the earnings and deductions in workday.
- Loaded timekeeping files to run the payroll process in workday. Ran the payroll process & settlement and validated the GL integration files from Workday to SAP FI GL postings.
- Good understanding and usage knowledge of various WD studio assembly components for both inbound and outbound integrations.
- Experience in configuration of Workday integration run schedules and integration notification messages.
- Experience in using the XML, XPATH, WSDL and XSD. Ability to write XSL transformations to transform the web service (SOAP) requests to meet the integration technical requirements.
- Responsible for managing & developing the Workday Core HCM Integrations with Implementation partner.
- Created numerous custom reports, complex calculated fields for reports using Workday Report Writer tool.
- Expertise in developing advanced, matrix custom reports and thorough understanding of Workday data sources and business objects.
- Determine & use the appropriate data Sources & business objects to deliver the required report for the end user as per the pre-defined security access.
- Created Advanced and Matrix reports to show employee, compensation, organizational and finance data as per the company various business units’ HR partner requirements.
- Expertise knowledge using Sorting, Filtering Report Fields, providing Advanced Filtering Option, Creating Sub-Filters and by using related Business Objects in Workday Reports build.
- Worked with Project implementation partner - Project managers & test managers to escalate the issues, open defects resolutions to meet the project schedules and testing deadlines.
Confidential, Akron, OH
Workday HCM Analyst
Environment: Workday - HCM, SAP ECC 6.4 - HR, HPQC and SharePoint
Responsibilities:
- Analyzed Goodyear HR/Payroll business needs through client business users working sessions and documented new business processes and a future state design. Collaborated with the Test Team for the HR/Payroll project.
- Trained in Workday Configurable Security Fundamentals course to define and design the workday HCM security requirements for Goodyear.
- Involved in analyzing business requirements and integrations end-to-end solutions.
- Experience in requirement gathering for Integrations development for HCM, payroll, Benefits
- Collaborated with Client HR leaders to define & design the Workday security roles for HR, Compensation, Time & Absence, Payroll, Executive partners
- Worked on configuring Workday Role Based Security, User Based Security, Job based Security, Segment security and Integration System Security Groups.
- Configured Domain Security Policies & business process security policies in various Workday Security Groups.
- Worked with SOX & Audit teams to develop & provide various security reports and users access details for Audit purposes.
- During Implementation phase responsible for completing the ad-hoc Workday security role access request for all the business users and business Work stream leads.
- Developed client customized Workday user based roles for Integrations testing for business power users and developed several limited user based access roles as per the client requirements for Data validations, Reporting and Integrations testing.
- Worked as workday Security Administrator to provision the users for workday system, to assign the required security roles users and troubleshoot the user’s security access issues.
- Assisted the data conversion team to populate the Workday data conversion workbooks as per the Workday iload requirements from legacy system SAP HR to Workday P1, P2, P3 and Gold tenants build.
Confidential, Akron, OH
Lead Global SAP HR Analyst
Environment: SAP ECC 6.0 - HR, Self Services - ESS/MSS, SharePoint, Parallel Payroll testing, data transfer tools (LSMW and Win shuttle), Workday HCM.
Responsibilities:
- Responsible for gathering the functional & technical integrations requirements and prepare the design documents to build the inbound and outbound integrations.
- Assisted the Goodyear Tire & Rubber company to choose SaaS Model HR Technology & service Model(Workday).
- Supported the Workday implementation partner to document the Goodyear integrations inventory workbook, discovery & integration - requirements gathering.
- Worked with offshore SAP ABAP technical team to complete the integrations build as per the requirements and test the integrations end to end as per the schedules Go-Live dates.
- Requirement Analysis, Development of test cases for portal applications (ESS/MSS), Interfaces, data Conversions and Reports.
- Responsible for monitoring Global SAP HR implementation test progress and communicating status and issues to the Project Management/Leadership team.
- Partnered with various Global IT teams, HR Partners, internal & external vendors to gather the requirements for OM & PA implementation & integrations build.
- Worked as a Global SAP HR Analyst/Test Lead, successfully completed various test cycles as per scheduled Go-lives in North America (NA), Europe and Middle East (EMEA), Asia (APAC) and Latin America (LA) regions - 14 rolling waves implementation for total more than 30+ countries.
- Managed Five QA Team offshore members for various test cycles testing during implementation of the project.
- Tested more than 30+ countries employee’s data after Win shuttle and LSMW data conversions from Legacy systems to SAP system.
- Developed test scripts and test data for SAP HR- Employee Self Service (ESS) and Manager Self Services (MSS) web portal users’ data validations and security authorizations for data access.
- Performed individual transactions (PA40, PA20 and PA30) and documented testing results. Worked with conducting functional Unit testing, Integration testing, Regression testing and submitting results to the Management.
- Extensively tested HR - OM and PA master data transfer from SAP to Success factors and downstream LDAP systems.
- Validated and verified various SAP reports and compensation reports by running through SA38/SE38 transaction codes and validated the report data from info type tables (SE11).
- Wrote complex test scripts to verify the payroll - IT- 08 Wage type calculations for various countries. Validated & verified the IT -08 payroll wage types and amounts during payroll interface validation testing.
- Wrote test scripts for Integration testing between SAP HR and various countries Payroll & time system vendors.
- Development of detailed test plan, test cases and test scripts for Functional, Regression, UAT and System Integration testing (SIT).
- Delivered the Test plans, Test Design, Test scripts based on RICEF functional and technical design documents.
- Responsible for creating test master data in SAP HR system based on the functional and technical requirements.
- Responsible for various complex SAP HR security roles validations and testing for Europe and Middle East (EMEA), Asia (APAC) and Latin America(LA) regions - more than 60 countries.
- Responsible for SAP HR Inbound and Outbound Interfaces validations/testing between Goodyear and 3rd party vendors (Payroll & Time) in different global regions (EMEA, APAC and LA).
- Worked with several countries payroll vendors to successfully complete the Parallel Payroll testing. (Interfaces End to End testing between SAP HR and local country Payroll vendor system).
- Developed business critical payroll scripts for parallel payroll testing and integration testing.
- Conducted QA and Defect Status Meetings to ensure all the different test cycles are completing as per the project scheduled timelines.
- Development of Unit test cases, Regression Testing, Integration testing and UAT high level Documents.
- Worked directly with various countries (NA, APAC, EMEA and LA regions) end users (HRs) during the UAT testing phase and After Go-live system validations.
Confidential, Colorado Springs, CO.
Sr. ETL Analyst - HR Reporting & Freight Services
Environment: SAP BOBJ/ BI, Informatica 9.0 ETL, Oracle /8i/9i, SQL, SharePoint and HP QC 10.0/ALM 11.0, Agile Project/Testing Methodology
Responsibilities:
- Participated in business requirement walk through, design walk through sessions with functional and technical teams to develop the design documents.
- Developed detailed test plan, test cases and test scripts using Quality Center for Functional system testing and Regression Testing.
- Extensively interacted with client Subject Matter Expert (SME), Project technical leads developers, data modelers, functional and business analysts to understand the business requirements.
- Based on the Functional documents and interaction sessions with the team developed the test scripts.
- Validated /tested business critical SAP BOBJ reports - drill down/up aggregation reports.
- Involved in Data mapping specifications discussion meetings to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
- Created Test plan, Test Design, Test scripts and responsible for execution of test scripts in timely with the team
- Tested the ETL Informatics mappings and other ETL complete end to end processes testing (Data Warehouse Testing)
- Developed several complex SQL queries in test scripts for querying data against different data bases for validating Business Objects Reports data in front end.
- Ran the complex SQL queries in Oracle to validate the data in the SAP BOBJ - Crystal reports and Dashboards.
- Tested the data passed to downstream systems from Oracle DB to BOBJ reports.
- Worked with Data Extraction, Transformation and Loading (ETL) informatica team.
- Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
- Tested all the OPM phase 2 reports and prepared daily test cases execution metrics and distributed to the project team.
- Tested a number of complex ETL mappings and reusable transformations for daily data loads.
- Prepared the end user step by step guides and FAQ documents to run the various BOBJ reports in the production box.
- Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
Confidential, Long Island, NY
SAP Analyst
Environment: SAP HR, FI, SD/CRM 7.0, SharePoint and HPQC
Responsibilities:
- Validated the newly migrated data/ data conversion in SAP CRM from legacey CRM sytems such as – busienss partners, materils, Organizational structure(OM) data from SAP ECC HR system.
- Worked on functional testing of SAP payroll from legacy mainframe payroll system.
- Tested employees’ IT -08 wage amounts and various payroll critical data during data conversion.
- Prepared test cases and test scenarios tested end to end payroll process for each company code.
- Worked on testing end to end payroll functionality for the new company codes including Personnel Actions, running payroll, post payroll activities, processing Off cycle activities, Third Party activities, payroll posting, processing Garnishments, Benefits, Process models and various payroll related Programs, Reports and RFCs
- Worked on Functional testing and parallel payroll testing along with preparation of test cases and test scenarios for Wage type permissibility and Taxation changes including both positive and negative testing.
- Tested IT -08 wage type catalogue and check wag type group for basic pay, Recurring payments & deductions & Additional payments.
- Extensively tested various off-cycle (PUOC) payroll activities like check replacement, reversing payroll results, and advance payment.
- Documented detailed test cases, test plans, reports and evidence documents with detailed results along with Screenshots and used SharePoint /HP QC to store all the testing results and track activities of the testing.
- Conducted Defect Meetings, assign prioritization of defects and escalate to Project Manager.
- Validate payroll test scenarios after the corrections from the functional team
Confidential, Mount Pleasant, MI
SAP ABAP Programmer Analyst
Environment: SAP R/3 HR - OM, PA, Time and Payroll and SAP BW.
Responsibilities:
- Worked with University Technology department to assist their SAP HR system maintenance, enhancements, monitor and trouble shoot the user issues.
- Worked with CMU SAP HR technical team during implementation/maintenance and testing.
- Worked with the QA team to develop the Payroll simulation process steps and tested the process thoroughly in QA system. Payroll simulation is used to evaluate individual employees’ payroll results.
- Assisted in designing step by step end user training guides with SAP screenshots to run the various SAP HR actions – hire, change in pays, transfers and separations, PC00 M10 CALC SIMU (payroll simulation) in testing and production environments.
- Tested off-cycle workbench (PUOC) for employee Special checks, Adjustment checks and On-demand regular checks.
- Tested different updates to SAP HR system in QA environment such as custom fields update in IT 06 (address) and IT094 (Residence status).
Software Engineer
Confidential
- Supported clients in SAP – HR and Logistics support projects as a Technical Analyst.
- Troubleshoot and fix the level 1 & 2 SAP ABAP technical tickets
- Worked on ALV Reports, ALE Interfaces, Exits, Enhancements, BADI, BAPI, Function Modules issues.
