Workday Reporting Consultant Resume
Chevy Chase, MD
SUMMARY:
- 8.7 years of HRIS experience in Workday Report Writer, Workday Prism, EIB, PeopleSoft HCM, PS Query, OBIEE reporting and this includes Customization, Upgrade, Maintenance, Support and Testing.
- Involved in requirements gathering and solution design meeting with the business. Analyzed Workday new and existing reporting requirements as part of the implementation of Workday.
- Have developed Workday Reports (Simple, Advanced, Matrix, Composite, Search, Trending and Transposed), and creating Custom reports using different combinations of calculated fields and also developed dashboards (Manager, Reporting Portal, Report Administrator).
- Partnered with cross - functional teams in the development, testing and implementation of Workday reports and dashboards. (Global Benefits, IA, Compensation, TM, TA, HR shared services, T&A, payroll, security, HRBP, Employee Relations & Finance) teams.
- Extensive knowledge of various HR transactions involved in Workday modules like Staffing, Compensation, Time & Absence, Goals and Payroll.
- Security group mapping to the custom reports. Understands the domain security policy.
- Understands business knowledge very clearly on HR domain and interpret them using Workday report Writer and EDW analysis.
- Have developed core integration concept like EIB’s (Enterprise Interface Builder).
- Validate the ad-hoc reports data with the source PeopleSoft system before releasing to stakeholders.
- Knowledge on Compensation Plans like Salary, Unit Salary, Hourly, Allowance, One Time Payment, Merit, Bonus, Commission, Stock plans.
- Development and maintenance of HR dashboards weekly, monthly, quarterly, annual reports, Headcount, Hires, Terminations, Off cycles, Merits, Global Compensation, Diversity, Promotion & Turnover reports to outline and analyze some of the following: workforce trends, quarterly dashboards, monthly reporting with detailed analyses.
- Design of Workday/OBIEE Reports & Dashboards on Core HCM processes (Employee/Workforce details, Hires/Headcount/ Terminations, compensation/Diversity/benefit, Turnover reports & VIP dashboards).
- Built interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, View Selectors, Dashboard prompts and extensively used repository and presentation variables.
- Experience in preparation and execution of test plans, technical and functional specifications and review of deliverables. Expertise in Responsible to drive all testing including parallel testing, system testing, and UAT.
- Created a predictive analytics model for annualized turnover and retention.
- Design, Development & UAT Testing of SRP (Standard Reporting Package).
- Predominantly focused on design and customization of PeopleSoft HCM Modules (Core HR, Workforce Administration, Benefits, Recruiting, E-Performance, E-Compensation and NADM).
- Worked on the Data Validations & Unit Testing of reports/dashboards in Workday, OBIEE and PeopleSoft HR.
- Involved in Daily Stand-up Meeting, Sprint planning, Sprint Kick-Off, Sprint review, grooming and sprint retrospective meetings - All this is a part of Agile methodology.
- Coordinate enterprise-wide metric definitions and usage.
- Performing root cause analysis and providing technical solutions for any Issues reported or Questions raised by Client Managers and Business analyst.
- Proven Experience in all phases of ERP lifecycle Upgrade, Conversion, Interfaces, Production support and troubleshooting of PeopleSoft applications release 9.x .
- Involved in development and customization of interfaces and reports using Application Designer, Integration Tools, and Reporting Tools like Workday Report Writer, PS Query, and SQR’s.
- Excellent team player with strong analytical skills, good interpersonal, communicational skills and quick learner.
TECHNICAL SKILLS:
Reporting Tools: Workday Report Writer, Prism, EIB, OBIEE 11.1.1.7, SQR and PS Query
PeopleSoft Applications: PeopleSoft HCM 9.2/9.1/8.9/8.8
Operating System: Win 10, Win2K, Win2K3, Win2K7, UNIX
PeopleSoft Tools: 8.x, 9.x, Application Designer, Configuration Manager, Tree Manager, Query Access Manager, Process Scheduler, Process Monitor, Application Engine, PeopleCode, Component Interface, File Layout, Data Mover, Security Administration and Approval Workflow Engine
Knowledge Domain: HCM
Database: ORACLE
Migration Tool: STAT
PROFESSIONAL EXPERIENCE:
Confidential, Chevy Chase, MD
Workday Reporting Consultant
Responsibilities:
- Developed new reports and dashboards on HCM modules (Core HR, Advance compensatio, payroll, time & absence.
- Design and build custom dashboards for business users like Diversity, headcount movement, compensation and time & absence.
- Worked closely with business users to get the requirements and converted it to technical reports and dashboards.
- Created complex reports on Core HCM, payroll, time & absence and advanced compensation modules.
- Scheduling of the Workday reports and setting up alerts configurations.
- Created EIB’s for vendors to send the data.
Environment: Workday HCM, Prism and SQL Navigator.
Confidential, Montvale, NJ
PeopleSoft HCM Upgrade Consultant/ Workday Reporting
Responsibilities:
- Fit gap analysis on the PeopleSoft 9.1 & 9.2 environments.
- 2 step upgrade 8.9 to 9.1 and 9.1 to 9.2 for Canada on Core HCM modules (Employee Self-Service, Manager Self Service, Benefits & Payroll).
- Developed new HR reports and dashboards.
- Have developed new SQR, PS Queries and application engine programs as per client requirement.
- Retrofitted the HCM application to 9.2
- Have developed new Component Interfaces to load the data into 9.2 database.
- Fixing issues created by business users during testing phase.
- Created complex Workday advanced compensation reports on salary plans, stock plans, one-time payment plans and others .
- Design and build compensation dashboards for business users.
- Worked closely with business users to get the requirements and converted it to technical reports and dashboards.
- Worked on modifiyng compensation business process as per business requirements.
Environment: PeopleSoft HCM 8.9, 9.1, 9.2 & PeopleTools 8.49, 8.54, 8.56, SQL Navigator, Putty, ServiceNow Windows 10, UNIX.
Confidential
Workday HCM Consultant (Team Lead)
Responsibilities:
- Design, Development & UAT Testing of SRP (Standard Reporting Package).
- Design, Developed workday reports and dashboards using Workday report writer. Developed different types of Simple, Advanced and Matrix Reports in Workday modules like Staffing, Compensation, Time & Absence, Goals and Payroll.
- Design of OBIEE reports & Dashboards on Core HCM modules (Employee/Workforce details, Hires/ Headcount/ Terminations, compensation/Diversity/benefit, Turnover reports & VIP dashboards).
- Built interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, View Selectors, Dashboard prompts and extensively used repository and presentation variables.
- Supports PeopleSoft Queries and SQL’s on weekly, monthly, quarterly, annual reports.
- Worked on the Data Validations & Unit Testing of Dashboards, and testing of ETL changes in OBIEE.
- Responsible for the development of Custom reports & Dashboards for HR business partners.
- Created adhoc reports through complex queries and reports for Senior Management and numerous Executive Committees.
- Validate the ad-hoc reports data with the source PeopleSoft system before releasing to stakeholders.
- Development and maintenance of HR dashboards weekly, monthly, quarterly, annual reports, Headcount, Hires, Terminations, off cycles, Merits, Global Compensation & Turnover reports to outline and analyze some of the following: workforce trends, quarterly dashboards, monthly reporting with detailed analysis.
- Coordinate enterprise-wide metric definitions and usage.
Environment: Workday Report Writer, EIB, OBIEE 11.1.1.7, PeopleSoft HRMS 9.1, People Tools 8.51, Oracle 11i, Serivce Now and Windows 2007.
Confidential
PeopleSoft HCM Consultant
Responsibilities:
- Involved in meetings with users to understand the business requirements and documented technical Specifications for developer team.
- Development of interfaces and reports using Application Engines.
- Development of New Component Interfaces / Using the Existing CI’s for loading the data into PS tables.
- Conducted internal sessions on the Complex Work Units which helped the team in understanding the functionality.
- Developed custom programs (SQRs, Application Engine programs, Component Interfaces) according to the business requirements.
- Participated in the fit gap sessions with the functional consultants and business users.
- Was responsible for creation of technical design documents from the business requirement & functional documents.
- Created DMS scripts to move the setup data from the UAT environment to production.
- Developed custom pages and components so as to enable the administrators to enter the paths for inbound and outbound files. Developed validations on these pages using People Code.
- Developed number of SQR Reports, PS Queries and other application customizations for fixing issues and new enhancements.
Environment: PeopleSoft HRMS 8.8,9.1 & People Tools 8.48, 8.51, Oracle 10g, Quality Center, Windows XP.