HCM Business Analyst

MICHAEL W. VROTSOS

** ********* **** ******, ** *1760

Cell 508-***-**** **************@*****.***

www.linkedin.com/in/michaelvrotsos

SUMMARY: Lead HR Business Analyst with several years of implementation experience from project planning, testing and development to support, administration and enhancement.

HRIS: PeopleSoft, Workday, ADP

Technical Skills: SQL, PS Query, nVision and Crystal Reports

Productivity: Access, Excel, SharePoint & Word, Visio, HP Quality Center, Service Now

Staples, Framingham, MA 2016-present

Technology sales and service

Boston Redevelopment Authority Boston, MA 2016

Lead Project Analyst

Developed detailed project plan from list of project milestones for ADP Time & Attendance implementation.

Mapped work schedules and configured earnings rules for union employees.

Created custom ADP reports for allocation of funding codes per employee.

Coordinated rollout of electronic time clocks to warehouse locations.

Biogen Cambridge, MA 2015

Lead HR Benefit Analyst

Developed requirements for employee data extract for ADP benefit interface from Workday.

Coordinated Workday Integration review sessions with developer and ADP.

Developed and administered testing plan with Business Partners.

Managed requirements sessions with benefit vendor team and business sponsors.

Boston Children’s Hospital Boston, MA 2014-2015

HR Consultant

Developed the overall HR analytics reporting strategy for PeopleSoft 9.2 HCM application:

Defined ongoing needs for payroll data analysis, ad hoc reporting and HR metrics.

Standardized existing HR reports to eliminate duplication and improve accuracy.

Ellucian 2013-2014

Business System Consultant

University of Massachusetts Shrewsbury, MA

Provided remote support implementation of Advance 9.81 fundraising application with Service Now:

Updating SQL logic to resolve performance issues and enhance functionality of Crystal reports.

Basic web configuration and troubleshooting supporting Windows7 and Crystal Server 2008.

Fresenius Medical Care Waltham, MA 2004-2013

Lead HR Business Analyst

Directed PeopleSoft Benefit and Payroll interfaces conversion from ADP Enterprise 3.00 to PeopleSoft 9.2:

Conducted Gap/Fit Analysis of Enterprise 3.00 to PeopleSoft HCM 9.2 reporting solutions by gathering requirements from multiple departments within HR.

Identified list of delivered reports to be deployed in business object environment.

Created specifications for standardized HR reports.

Coordinated roll out of business object reports access and user training.

Created custom PeopleSoft nVision Excel queries for reporting gaps such as benefit cost analysis.

City of Cambridge-Cambridge MA 2003-2004

Consultant

Developed custom Crystal reports for PeopleSoft Asset Management 8.4 to reconcile asset depreciation with Purchasing and General Ledger.

RHI Management International 2001-2003

HealthAlliance Leominster, MA

Consultant

Functional review of PeopleSoft Payroll and Benefits Administration 8.4: designed master table for accrual plans and earning codes for hospital to standardize benefit plans.

Developed automated excel macro to import data from One Source time and attendance application into PeopleSoft Oracle database.

Created custom queries to analyze health and dental insurance costs, improve payroll processing and resolve issues such as vacation and sick accrual calculations for PeopleSoft Payroll and Benefits Administration 8.4.

Thomson Financial Boston, MA

Consultant

Designed interface approach to feed information from external Sybase system into Oracle database.

Developed SQR to import text file into PeopleSoft database for Billing and Receivables 8.4.

Davox Corporation Billerica, Massachusetts 2000-2001

Business System Analyst

Implementation of Clarify ClearSales 9.0:

Integration with Windows 95/NT OS for email functionality and ActiveX link with Actuate reports.

Security administration, mapping and export of translate values from legacy ACT system to Clarify Sales and Marketing application into Oracle database.

PEOPLESOFT Corporation Waltham, MA 1997-2000

Consultant

ADP Brokerage Information Services Marlton, NJ

Performed testing and supported production for an upgrade from Payables and Purchasing 5.1 to 7.5.

Reviewed functional set up and tested conversion data.

Implemented solutions for pay cycle processing and recommendations to improve vendor reporting.

Cahners Publishing Company Newton, MA 1996-1997

Application Analyst

Developed on-line Crystal Reports, Excel uploads and Visual Basic macros for a worldwide publishing company.

Maintained and administered PeopleSoft Payables 5.12 which supports employee expense reimbursement and vendor payments.

Customized PeopleSoft 6.0 Payables, Receivables and Asset Management chart fields to conform to company requirements.

TRAINING/ PROFESSIONAL DEVELOPMENT/EDUCATION

Clark University-Computer Career Institute: Client/Server Development Program 1996

Washington University: Bachelor of Arts Degree: French/International Development

Contact this candidate