ROBERT D. HAYES

** ******** ****** 857-***-****

Wilmington, MA 01887 ac15v7@r.postjobfree.com

Senior Business Analyst

Highly experienced, analytical, and results-driven Senior Business Analyst. In depth mathematical and science knowledge. Outstanding architect, design and development skills. Unique ability to quickly find and solve complex technical problems. Successful track record of ensuring product reliability, producing high quality products, and meeting on time delivery deadlines that ultimately leads to a significant increase in customer satisfaction. Technical expertise includes:

SQL, SQL *Plus, PL/SQL

MS Office 365 – Word, Excel, Power Point, Visio

Toad, Java, Visual Basic, Image Solutions

SAP ERP – Financials

Oracle Financials - EBS

Oracle Projects (Cost & Billing)

ADP HR/Payroll

SAP PBW – Retail Work Bench - POS

MS SQL Server 2016 – SSIS, ETL

DnB Credit Manager and Collection Manager

PROFESSIONAL EXPERIENCE

Securitas, Wilmington, MA 03/2017 – Present

Mobile Patrol Officer

Providing security check points to over 30 major companies on a weekly basis. This includes inside and outside on most of them using PROLIVE software application.

Provided training to new patrol officers.

Check computer rooms for temperature readings and report any issues.

Work with law enforcements when problems occur.

Gather weekly time sheets from officers for payroll purposes.

Responding to alarm calls when needed.

Sullivan / Dixon Company, PC., Lowell, MA 09/2016 – 03/2017

Independent Consultant

Worked on gathering requirements from stakeholders for a newly customer Web retrieval application. Also, worked on archiving past year’s tax filings into system below for back-fit purposes.

Led business users in the user acceptance testing (UAT), logging any bug fixes and setting priorities until the system was free of any known bugs before go-live.

Wrote user training documents, use cases, user scenarios, user stories, test scenarios, test cases, and expected test results.

Led the system design, database model and the creation of database tables using MS SQL server 2016 services such as Integration Services (SSIS) having used ETL for data loads of several Tax software applications into a centralized database for future Web retrieval on filed taxes. This also included working with a consultant on setting up the company network infrastructure for current and future goals.

Responsible for interviewing and hiring contractors for this project after vendor selection.

Wrote functional specifications documents based on mockup designs with the intent of modifying the final GUI screens after development. Also, included non-functional requirements.

Designed Mockup screens and reports for stakeholders and business users, using MS Access for this presentation on the to-be system.

Worked with several vendors on RFQ’s for selecting the right servers, database and security for housing the Tax project data within the planned budget for this project.

Acted as a PM for this project, tracked and reported project status to stakeholders and owner.

Held meetings with stakeholders (CPA’s) and gathering business requirements.

CLARKS AMERICAS INC., Newton Upper Falls, MA 2006 – 06/2016

Senior ERP Application Manager / Business Analyst

Wrote functional and technical specifications based on the business requirements and use case requirements as well testing the system modules, which included SQL extracts from the Oracle ERP system for the Java team of (5) programmers, for the SAP consultants to load the data into SAP which also required matrix tables to be built for the data conversion. This also dealt dealing with Pentaho ETL tool for loading varies data formats into our BI warehouse universes. Also, worked with different businesses on reconciling the data before and after the data loads based from the use case requirements and checking the end results from our testing, built all test scripts for these loads using SQL Loader. Then working with the Business Objects, QA and DBA teams in flushing out any issues, like performance on batch and/or online data transactions while these took place.

Worked with the business users on fixes and new requirements which includes process work flows, API’s, functional and technical specifications. Worked with the PMO team and reporting to upper management, time, cost and weekly progress, etc.

Worked with Deloitte on Oracle ERP database volumes for table sizing, business flows and data mapping into SAP for the conversions and integration tasks that would follow.

Performed 3rd party system enhancements such as ADP HR/Payroll, AMT Direct - Retail Lease Management POS, EDI feeds, Manhattan inventory data integration to the SAP system, provided reconciling and end user training. Also designed and created Oracle database tables for storing all data interfaces and worked with BI team on creating universes linking data structures for reporting purposes.

Redesigned customer invoicing, credit memos and monthly statements for emailing and faxing PDF files to our customers. Provided estimates and tracked weekly progress and reporting to upper management.

Worked with IT Operations on scheduling jobs between the USA, Canada and UK and provided operation documentation.

Worked on a Vertex O series in the Cloud tax software project for SAP Finance, Retail, ECom and B2B applications and providing daily support for ongoing activities.

Support Oracle ERP due to auditing purposes for the business and reporting after SAP Conversion.

Managed Oracle ERP R11 system upgrades and customizations, worked with cross-functional teams.

Led the migration of moving an ADP HR/Payroll client server (in-house) to ADP’s Web portal. This required lots of data mapping, configuration, upgrades, enhancements, implementation, maintenance and UAT activities. Worked with the Financial stakeholders on gathering requirements, functional and technical documents for automating the data interfaces between these systems. The second phase included implementing ADP Time Saver for our Retail and Warehouse employees and removing some interfaces built in the first phase of this project.

STONE & WEBSTER ENGINEERING & CONSULTING., Stoughton, MA 1987 - 2006

Senior Business/Technical Analyst/Programmer

Managed global support of Oracle ERP system under several sets of books. Implemented Oracle patch sets and configurations to keep application software current and working with Oracle on TAR resolutions. Trained end users and supported other legacy systems residing on multiple platforms (Mainframe/Client Server) for daily operations.

Combined 2 FileNet Optical Imaging systems through acquisitions for centralization to support client billings and employee expenses. Wrote functional overviews and technical documents for implementation. Led FileNet consultants in merging all scanned documents over to a new storage device for future growth and provided training to end users.

Led data migration strategy for Oracle ERP system for the acquisition of EDS having many companies, residing in a Cost Point ERP system. Wrote functional overviews and technical documents for this integration and served as techno-functional advisor for all customizations relating to these modules. Project required extensive travel to Charlotte, North Carolina.

Led conversion strategy for Oracle ERP system for the acquisition of E&I having many companies, both domestic and foreign, residing in a JD Edwards ERP system. Wrote functional overviews and technical documents for this integration and served as techno-functional advisor for all customizations relating to these modules and a reconciliation process using MS Excel for end user validation. Project required traveling to Monroeville, Pennsylvania and Baton Rouge, Louisiana.

Designed and developed an interface between a Materials Management (Marian) application and Oracle Purchasing for all major projects. Responsibilities included Gap Analysts, functional and technical documents, design and development of this conversion application.

Managed global support of Oracle ERP system. Additional responsibilities included: analysis, design and implementation of custom PL/SQL packages for all field site applications such as Platinum Accounting (C/S), Timberline Payroll (C/S) and a Craft Time Collection system into Oracle Financials and Projects.

Led the design of an interface between a custom Procurement application and Oracle Purchasing for recording commitments for payment purposes within Oracle Financials after collecting requirements.

EDUCATION/TRAINING

Education: Northeastern/Ashwood University, Management Information Systems

Software Engineering – Bachelor GPA 3.93 (Summa Cum Laude)

Training: Oracle Corporation - P/L SQL – Advanced P/L SQL, Performance Tuning,

Financials, INV, WIP, BOM, Workflow and Administration

Microsoft Corporation - Office Visual Studio

IBM Corporation - DB2 Applications

SAP Deloitte - Application Configuration – SPRO, T-Codes, SQVI, Etc.

ReconNet – Retail Cash Management

Pentaho – ETL

Business Objects - BI

Contact this candidate