MAJResume

MELANIE A. JOHNS

**** ******* ***

Hudson, OH ***36

330-***-**** – Home

Summary of Qualifications

HR Business Analyst experience working within LAWSON (v.7.1.2) and PeopleSoft v. 9.0, (HR, Benefit and Payroll modules, upgrades v. 90); implementations and patches, etc. Working knowledge of SQLPlus, UNIX, Lotus Notes, Powerpoint, Pfeditor, PeopleTools. Provide end-user documentation and classroom training materials. Served as a tester to work out all system problems prior to rollout to User Group/Functional Team; primary contact between User Group and Technical Support. Prior experience also in system conversion and implementation of HR and Payroll Peoplesoft modules. Served as “Train the Trainer” in concept for training and development of user group. Create, execute, edit and document test scripts – ETL, ERP, create and modify flowcharts, test workflow as well as provide user training and support. Data mapping and set up of payroll for multi-state, multi company environment and conversion of 401(k) and health care contribution processing to third party vendors. Currently work as primary contact between Users and Technical Staff, analytical and problem solving, and interpreting needs of community.

 Team Lead/Project Management – Peoplesoft implementation to v 6.0, Peoplesoft Super User, ad-co reporting

 Experience with Windows 98, HRMS, Lotus Notes, SQL, Unix, TSO, ORACLE environments.

 MSOffice products including Word, Excel, Powerpoint, Access, MS Front Page

 Compensation analysis, job grade reviews, reporting, etc.

 Deadline driven – consistently meets all deadlines with a quality product.

 Ability to communicate (written and verbally) with all levels of personnel in a professional manner.

 Previous software implementation experience with a Payroll/HR software package including, third party vendors, 401(k) contribution processing, government reporting, year-end close.

 Customer Service – implemented 800 number, same day check process, customer service attitude/culture.

 Payroll/HR functions include employee relations, recruiting, EEO Labor Laws, employee retention, employee benefit programs (401(k), ESOP, FSA, etc.).

Experience

AmTrust Bank, Cleveland, OH April 24, 2007 – Present

SR. Business Analyst

 Respond to needs of the organization by gathering, investigating and analyzing user and business requirements for business processes and technology needs. Author test scripts.

 Partners with Technical Group in designing, implementing and maintaining system and new functionality. Ensure standards are met. Problem solving, analytical and ad-hoc reporting.

 Acts as internal consultant and direct and lead employees to best practice and system use. Review, test and implement all system fixes, upgrades and resolve system problems. Web development and support.

 Maintain report inventory and documentation, and production schedules to ensure system performance and integrity. Develop and implement ETL processes.

Westfield Group, Westfield Center, OH Oct. 2004 – April, 2007

SR HRMS Analyst

 Provide HRMS expertise. Maintain knowledge of integrated Payroll, HR and Benefit modules.

 Respond to needs of the organization by gathering, investigating and analyzing user requirements for business processes and technology needs.

 Partners with Technical Group in designing, implementing and maintaining system and new functionality. Ensure standards are met. Develop and implement ETL processes, ERP implementation, Web support.

 Respond to HR, Payroll, and Benefit User communities regarding their needs and optimum system usage and performance.

 Acts as internal consultant and direct and lead employees to best practice and system use. Maintain all HR, Payroll, Benefit tables.

 Review, test and implement all system fixes, upgrades and resolve system problems. Web implementation and support,

 Design and develop reports, interfaces and processes for the more complex needs of the organization, using PeopleSoft delivered reporting tools such as Query, Crystal, SQR, etc.

 Maintain report inventory and documentation, and production schedules to ensure system performance and integrity.

 Participates in all system upgrades, ensuring customizations are documented and re-established after upgrades/fixes.

 Maintains strictest standards of confidentiality regarding all HRMS data and business activities.

 Establishes and manages disaster recovery activities for HRMS.

St. Vincent Charity Hospital June,2003 – Oct. 2004

Sr. HRIS Analyst (Consultant Position)

 Worked as Consultant on Lawson (version 7.24) HR, Payroll, Benefit, Nurse scheduling systems.

 Acted as liaison between User Community and Technical staff to provide system solutions and resolve problems as needed.

 Compensation analysis, review, etc.

 Developed nurse tracking system for state mandated testing. Produced ad hoc reports for HR, Payroll and Benefit departments.

 Maintained reporting and inventory systems.

 Prepared end user training documentation, provided new employee training on Lawson based environments.

Dairy Mart Convenience Stores August, 2000 – January, 2003

Sr. HRMS Analyst

 Oversee HR, Payroll and Benefit reporting requirements including Health, 401(k), COBRA, and Insurance premium billing.

 Manage/motivate a staff of 8 team members.

 Research, analyze and maintain systems in support of HR, Payroll and Benefit administration and projects. Trained staff on system utilization and updates.

 Acted as liaison with IS staff and HR/Payroll/Benefit Departments.

 Compensation analysis, review, grade levels, etc.

 Developed process for HR information reporting needs as required for internal/external reporting. Produced ad hoc reports as necessary for mid to executive level management.

 Prepared tax and government reporting for Payroll, HR areas. Balanced payrolls, taxes, and third party reporting.

 Prepared end user documentation and training materials. Oversee testing of system upgrades, conversion of data and implementation of new systems.

 Maintained HRIS systems to ensure efficient operation and processing. Assured all projects adhere to accepted professional standards, schedules and produced all HR reporting requirements.

 Converted system to ADP payroll system.

National City Bank July, 1999 – August 2000

HR Business Analyst

 Responsible for analysis, coordination, progression tracking and testing through completion of incoming technical requests from User Community, insuring compliance with company/legal regulations.

 Facilitate work for IS Management Team to coordinate and monitor assignments to successful completion.

 Tracked and resolved project issues, provided post implementation support.

 Created transition plan for process owners.

 Evaluated requests from User Community to identify alternative solutions to best accommodate user’s needs.

 Document, prioritize and problem resolution key elements to position.

 Decision making, problem resolution and customer interaction, including status report updates, cost/benefit analysis.

 Consolidate technical documentation and upgrade to make one reference document with solution and cost analysis.

 Liaison between User and Technical groups.

 Assisted with various team projects including Employee Health Intranet site maintenance, upgrade (PeopleSoft v.8.0 HR, Payroll).

KEY SERVICES, Cleveland, OH April , 1998 to January, 1999

Sr. Quality Business Analyst

 Provide training, advisement and support to User Community

 Responsible for Business Acceptance Testing system(s) to ensure zero defects prior to User Acceptance.

 Create scripts, testing scenarios, flow charts and document results.

 Decision making, problem resolution.

 Work closely with other technical teams (MODS, Workflow, Edify Group etc.) in order to resolve any problems found during testing.

 Test on-line employee systems, web sites, prior to implementation to field users, using SQL, UNIX, VRU

 Experience with creating SQL statements, UNIX environment and Peoplesoft HR, Payroll and Benefit Admin. Modules. Provide training and support to User Group(s).

CALIBER SYSTEM, INC. (formerly Roadway Services, Inc.) Akron, OH Feb, 1986 to March, 1998

Payroll Manager for a Fortune 500 Company

 Served as Team Lead for “Train the Trainer” in system conversion of mainframe Payroll and HR to Peoplesoft both HR and Payroll modules.

 Responsible for management of all phases of payroll through W-2 process and year end filings for multi-company, multi-state payroll operation; including tax reporting, unemployment reporting and bank reconciliation process.

 Responsibilities also included employee relations, problem resolution, recruiting/retention abilities.

 Knowledge of EEO Labor Laws, ERISA, Worker’s Comp, ERISA, etc.

 Administered /Tuition Assistance Plan and company car program for over 1,500 employees.

 Responsible for contribution processing of 401(k) Plan of over $3M per quarter.

 Supervised a staff of 5 employees. Cross-trained staff to safeguard process, implemented Quality Improvement Program for Payroll area.

 Provide training and presentation materials, training and post-implementation progress/support

 Management responsibilities including departmental budget, staffing, scheduling and inventory control.

Continuing Professional Development /Education

 B.S. in Business Administration– University of Akron, May ‘87

 Kent State University – undergraduate work specializing in Journalism, January ‘81 – January ‘83

 Real Estate License – May,1986

 Peoplesoft Training – HR Modules, Payroll Processing, Ben Admin., PeopleTools – November ’96 to Present

 Managing Diversity Training

 Project Management Training

 Critical Management Training

Accomplishments

 Implemented Quality Improvement Program for Payroll Department.

 Implemented 800 number Customer Service process, same day check processing.

 Developed Tuition Reimbursement System.

 Developed post-implementation support process.

Contact this candidate