Mark Medina Email and Phone Number

• Responsible for the oversight of projects within the HR Reporting & Metrics team.• Responsible for coordinating activities of project team, identifying appropriate resources needed, and developing schedules to ensure timely completion of project.• Familiar with system scope and project objectives, and have an understanding of multiple organizational hierarchies. • Formulate and define systems scope and objectives based on both user needs and with a good understanding of applicable business systems and industry requirements. • Building relationships with various stake holders, including the HRBP community, the Business, and Finance, to ensure accuracy of the data, and value add of key metrics. • Experience using SQL server reporting services • Experience with relational databases; such as PeopleSoft. • Strong analytical and communication skills in order to take appropriate action, offer solutions and reporting based on requirements. • Report format and dashboard layout design experience.

• Coordinate and contribute to global HRIS projects to implement new functionality for end users.• Independently identify new functional and technical needs and gather suggestions from team members. • Develops data auditing techniques for HRIS team.• Primary contact for Line of Business to ensure data integrity. • Responsible for creating training manuals and curriculum for end users.• Lead training sessions for end users including line administrators, HR users and managers. • Perform mass data updates, exports, imports, clean-ups, and researches/reports on any data discrepancies.• Delivers routine daily/weekly/monthly reporting and responds to all levels of ad hoc data requests.• Write functional specifications to modify existing functionality in HRIS, which include new reports and interfaces.• Liaison with IT staff to resolve global HRIS issues.• Lead testing initiatives by developing test scripts for end users.• Lead system tests for new or modified system enhancements for user acceptance testing.• Prepare internal and external government and ad hoc reports (EEO, Vets 100, Affirmative Action Plans, etc).• Prepare quarterly and ad hoc HR metrics for line of business and HR management.

Implement and test new applications to PeopleSoft 8.9 as updates and revisions become availableRun and distribute weekly, monthly, quarterly and annual reports to V.P. of H.R., Regional Managers, District Mangers and other upper management employees.Participated in upgrade from PeopleSoft 8.0 to PeopleSoft 8.9 and development of performance tools. Administer PeopleSoft training to all new hires within the H.R. department in the Westbury office.Evaluate, design, test, implement and train users on PeopleSoft system and HR-related processes.Create and personalize queries in PeopleSoft including turnover and ethnicity reports in order to analyze trends within the organization.Administer systems security reviews and ensure integrity of data contained within the HRIS (PS) system.Troubleshoot systems problems and provide user support.Respond to intermediate ad hoc data requests.

Implement and test new applications to PeopleSoft 8.9 as updates and revisions become available.Responsible for security administration, including new user profile set ups, permission list and role creation.Run and distribute weekly, monthly, quarterly and annual reports to V.P. of H.R., Regional Managers, District Mangers and other upper management officials.Participated in upgrade from PeopleSoft 8.0 to PeopleSoft 8.9 and development of performance tools. Administer PeopleSoft training to all new hires within the H.R. department in the Westbury office.Evaluate, design, test, implement and train users on PeopleSoft system and HR-related processes.Create and personalize queries in PeopleSoft including turnover and ethnicity reports in order to analyze trends within the organization.Administer systems security reviews and ensure integrity of data contained within the HRIS (PS) system.Troubleshoot systems problems and provide user support.Respond to intermediate ad hoc data requests.Provided assistance through our Human Resources Service Center to all Barnes & Noble employees on various Human Resources/Benefits policies and procedures.Assisted with enrollment of Medical, Dental, Life and Flexible Spending Accounts. Worked extensively with our Payroll Department to ensure an appropriate and accurate payroll processes by resolving any time and labor discrepancies in PeopleSoft before payroll begins.Processed information subpoenas and employment records requests from law offices in partner with our Legal Department.Assist Regional and District managers to help retrieve information via PeopleSoft, advise correct pay rate changes, and process promotions, demotions, location transfers and other changes in PeopleSoft.Explain procedures and qualifications in regards to various Benefits questions, such as Paid Time Off, Leave of Absences, Short Term Disability, FMLA and 401k.

Managed behavioral study as experimenter and examined the effects of personality on alcohol usePlanned and executed several pilot studies for the lab as Principal InvestigatorProgram experience with S.P.S.S., MS Excel, MS Word, MS PowerPoint and Amos