Senior Consultant

Roles

Technical Project Manager

Senior Consultant

Team Lead

Technical Lead

Project Lead

System Integrations Lead

Developer/Analyst

Business Process Automation

Team Liaison

Mentor

PeopleSoft Applications

Within Higher-Education; Public Sector; Commercial

Financials/Supply Chain Management

Accounts Receivable

Accounts Payable

Billing

General Ledger

Asset Management

Order Management

HCM

Time and Labor

Benefits

Absence Management

Campus Solutions

Admissions and Recruitment

Student Financials

Student Records

Database Platforms

SQL Server

Oracle

DB2

Michael A. Hilty

Senior Software Consultant

PeopleSoft Systems

******@*****************.***

Mobile: 907-***-****

Summary

Mr. Hilty has been providing viable and effective IT solutions to today’s business challenges by applying an array of technical and business skill sets honed through over 28 years of software engineering experience. 18 of the 28 years have been spent working with Oracle’s PeopleSoft Financials Supply Chain Management (FSCM), Human Capital Management (HCM), and Campus Solutions (CS) application suites. His experiences include development, quality assurance measures, testing, implementation, maintenance and support for business applications and implementations throughout the software development life cycle (SDLC). He has proven successful in lead roles such as Technical Project Manager, Technical Lead, Project Lead, System Integrations Lead, and Senior Consultant. His strengths lie in leveraging his technical knowledge and analytical abilities and applying them to business process scenarios.

Project assignments include large-scale PeopleSoft implementations and upgrades, as well as enterprise platform conversions and application data splitting and cleansing. Defined and conducted quality assurance measures with multiple levels of test acceptance for customizations, maintenance, conversions, and process deliverables to ensure compliance with business requirements. Automated and simplified manually intensive business processes. Developed, designed and implemented SDLC procedures and controls for quality assurance as well as controls and audits for compliance with Sarbanes Oxley.

Excellent communication and documentation skills, often positioned as a liaison between the technical (DBA, network, development) team and the functional analyst and user teams.

Implementation Methodology and Career Project Experience

Participated in Software Selection and proposal phases

Designed and implemented SDLC policies and procedures

Liaison between subject matter experts, end-users and technical team members

Lead for system upgrades/new implementations/conversions and database cleansing

Lead on requirements gathering/fit-gap phases on complex business solutions

Lead of design/development/production implementation phases of complex cross system business processes including: Business Process Modeling, Data mapping and conversion, integrations and interfaces, training, security, and reporting

Developed and presented training sessions for end-users/technical teams

Provided mentorship to junior staff

Member of a team of key personnel responsible for investigating, documenting, designing, and implementing a platform change from Oracle and Unix to Microsoft SQL Server and Windows.

Application Experiences – HCM

Benefits, Human Resources, Payroll - T/L, Absence Management, Self Service

Lead responsible for requirements gathering, specification documentation, development, testing, training and implementing an Employee Account automation process

Design, development, implementation and training for customized payroll processes

Lead technical resource for production support and system performance tuning

Lead technical resource for designing, developing, implementing Benefits

Lead technical resource for database cleansing and splitting

Application Experiences – Financials/Supply Chain Management

General Ledger, Accounts Payable, Accounts Receivable, Asset Management, Projects, Billing, Inventory Management, Order Management

Designed/developed batch and online enhancements to the order management system

Production support including defect management and solution updates implementation

Implemented performance and tuning enhancements to improve system efficiency at both the database and application level

Designed and developed integrations using PeopleSoft’s integration technologies between client and both internal and external systems

Documented, designed, developed, and implemented business process enhancements and reports using Crystal, Nvision, SQR and Application Engine batch processes along with online PeopleCode

Implemented security audits for Sarbanes Oxley compliance and efficiency

Facilitated technical activities that affected the development paths for the deployment projects in Europe, Japan and North America for international company

Database cleansing

Application Experiences – Campus Solutions

Admissions and Recruitment, Student Records, Campus Community, Self Service

Lead responsible for requirements gathering, specification documentation, development, testing, training and implementing complex enhancements including:

oOnline Applications

oStudent Search Matching

oCRM customized bolt-on

oAutomated Student Account Creation/Maintenance

oBlackboard integration

oSystem and application performance tuning

oDatabase cleansing and splitting

oSecurity migrations and support

oProduction support on complex issues

Professional Experience

Dynamic Campus Solutions June 2009 – December 2015

Wausau, Wisconsin

Senior Technical Consultant Campus Solutions 9.1, HRMS 9.0, FSCM 9.0, PeopleTools 8.54

Conducted and documented functional user requirements sessions and technical design specifications for several projects involving system integrations between PeopleSoft and third party such as Blackboard, financial institutions, as well as internally between PeopleSoft HR, Campus Solutions, Financials, Portal, Active Directory, and Domino. These projects automated manually intensive business processes. Some of these more notable projects include:

oBlackboard data population and updates from existing PeopleSoft system

oOnline applications and integrations with Financials

oEmployee Account creation and maintenance automation

oStudent Account creation and maintenance automation

oProspective Student “CRM” tracking system

oDatabase splitting (HCM and Campus)

oDatabase application data cleansing and splitting

oCustomized time entry approval process and notification

Developed, customized and implemented custom processes for lock box transfer, vendor data, daily and monthly forms, along with integrations to and from Campus and HCM

Provided production support to Financials, HCM and Campus

Facilitated and defined testing at key points through the development life cycle to ensure successful implementation, user requirement satisfaction and quality assurance.

Defined test cases and process scenarios along with documenting, tracking and managing defects. Testing measures included unit, UAT, system, and performance testing.

Supported end users and staff during user acceptance testing to ensure defects and issues were identified, tracked, corrected and documented, both during development and user testing

Onsite mentor to development team for technical direction and facilitate unit testing scenarios and data content to ensure end user requirements would be met

Worked closely with functional users, supervisors and managers and technical team developers and analysts to implement cross system processes

Coordinated offsite development team members’ work and deliverables

Commonwealth of Massachusetts May 2009

Boston, Massachusetts

Technical Team Trainer PeopleTools 8.48

Conducted mentor training for the business analysts and technical team members

Prepared and conducted mentoring sessions on the following

oSQL (for the Business Analyst)

oTools delta (8.1x to 8.48 PeopleTools)

oApplication Designer delta and “debugging/troubleshooting” tips

oIntegration Broker overview including case studies

Additionally, investigated and jump started the use of integration technologies with time keeping systems integrated with PeopleSoft

State of Indiana Sep 2008 – April 2009

Indianapolis, Indiana

Technical Team FSCM 8.9, PeopleTools 8.48

Brought on board to provide needed expertise in solving User Acceptance issues encountered in extensive customizations of application for an 8.9 upgrade

Key tasks included: Workflow added to the Asset Management module; customized cash deposit interface and approval process; customized advice emails; customized escheatment process; 1099 conversions

Performed regression and envelope testing for quality assurance measures as well as business requirement fulfillment

Tools utilized include workflow, security, extensive PeopleCode and Application Engine resolving AR, AP and AM issues and new development

Batch work includes custom SQR and Crystal development and issue resolution

LCRA (Lower Colorado River Authority) July 2008 – August 2008

Austin, Texas

Integration Broker Specialist FSCM 9.0, PeopleTools 8.49

Technical analysis/debugging of integration communication points for PeopleSoft system to and from client’s MAXIMO system

Developed, tested and documented proof of concepts and integration templates, both outbound and inbound, using SOAP messages via Oracle’s SOA architecture

K&L Gates, LLP June 2008 – July 2008

Pittsburgh, Pennsylvania

Senior Development Role HCM Talent Acquisition 8.9, PeopleTools 8.48

Enhanced the eRecruit components to enable the User the option of including various attachments to the system generated notification email sent to the Interview team and to include the full interview schedule within the email text

Enhancements utilized PeopleCode modifications and development in application packages, page, component and record, along with page design and modifications

University of Utah Dec 2007 – May 2008

Salt Lake City, Utah

Technical Team Lead HCM 8.9, PeopleTools 8.49

Technical team lead responsible for implementation of an electronic personnel action form application which focuses on using workflow, integration technology and custom PeopleTools development to increase client effectiveness

Extensive development with nearly all Application Designer objects with primary attention to PeopleCode, Components, Component Interfaces, Page design, Application Engine, security (permissions and roles), approval rules sets, activities and Query/SQL

Defined test scenarios and coordinated testing efforts with end users and developers

Analysis and diagnosis of issues in various areas of the application, including integration broker

Provided technical knowledge transfer to the team for post implementation support

Coordinated work effort required by development/technical team

Port Authority of Allegheny County Aug 2007 – Dec 2007

Pittsburgh, Pennsylvania

Integration Broker Specialist Financials 8.9, PeopleTools 8.48

Implemented integration from PeopleSoft to an external third party system resulting in business transaction information being processed both inbound and outbound to streamline a business process between a PeopleSoft system and a non-PeopleSoft system

Mapped the inbound and outbound PeopleSoft messages to the third party schema to correctly send and receive/process information

Worked closely with DBA/Admin to work and resolve interface communication issues

Defined testing scenarios and data cases with business process owners and end users to ensure business requirements were satisfied

Documented and conducted knowledge transfer sessions for the new processes and technologies

Pinnacle Food Corporation July 2007 – August 2007

Philadelphia, Pennsylvania

PeopleSoft HCM 8.9 Upgrade Team HCM 8.9, PeopleTools 8.48

Tasked with assisting with conversion of external and legacy data to conform to new requirements in the 8.9 system, as well as assist in the effort to bring forward customized SQRs to support existing business processes and interfaces to third party systems and/or vendors. Tasks included:

oDeveloped customized processes to facilitate data conversion from 8.0 to the 8.9 system including ExcelToCI

oAssisted with enabling the new row level security using the Security Join Tables

oProvided technical support to project team and assisted in move-to-production upgrade tasks and upgrade support during cutover

Rain Bird Corporate Services August 2006 – May 2007

Los Angeles, California

PeopleSoft FSCM 8.9 Upgrade Team Technical Lead FSCM 8.9, PeopleTools 8.48

Responsible for the technical tasks associated with the complex upgrade from FSCM 8.0 SP3 non-multi-lingual, non-Unicode SQL Server 2000 to FSCM 8.9 multi-lingual on SQL Server 2005 Unicode, of which some of these include:

oWorked closely with DBAs to coordinate upgrade related DBA tasks and understanding of database requirements throughout the upgrade cycles

oInstalled and configured Change Assistant and templates to be used in tools and application upgrades in the most efficient manner feasible

oIdentified and resolved issues with the processes and tools associated with the upgrade and documented, optimized and tuned the upgrade tasks where possible

oPerformed multiple regression and parallel tests to ensure each aspect of the upgrade was conforming to expectations and business process requirements

oAssisted with various technical tasks as needed by the DBA support team including backups, restores and database management tasks as well as the PeopleSoft Internet Architecture

oProvided support and guidance to the development, functional and security teams within the upgrade environments, including documentation of technical tasks and processes

Provided support for production issues within the SCM environment during MTP tests as well as post go-live

Worked closely with the Security administrator to facilitate security updates, migrations, and configurations

3M July 2005 - August 2006

St. Paul, Minnesota

PeopleSoft 8.8 Financials/Sourcing/Rollout Path Coordinator-Environment Team

Facilitated technical activities that affected the development paths for the rollout (deployment) projects (these include activities in Europe, Japan and North America):

oLiaison between operations and infrastructure groups to development teams both within North America and offshore

oCoordinate processes and procedures to ensure system integrity of the environments

oIssue/Defect focal point for tracking, managing and documenting testing defects and general system issues

Developed, executed, coordinated and supported technical processes and controls for Sarbanes Oxley compliance with regards to separation of duties in production and test environments

Provided support as backup Security Administrator as well as liaison with Database administrators and server administrators on tasks involving the various components of PeopleSoft

Provided production support for issues/defects, migrations, maintenance

Hudson Highland Group May 2004-July 2005

Pittsburgh, Pennsylvania

PeopleSoft 8.8 DBA/Technical Project Manager

Worked with Functional Implementation team to develop Technical Project plan used by DBA team to implement PeopleSoft 8.8 for three applications (Financials, Staffing Front Office, and Human Capital Mgmt) on an Oracle/UNIX platform

Provided support on issues dealing with environment and systemic items

Implementation of change control procedures, security procedures and models

PeopleSoft Administrator responsible for applying application and technical patches, project management and communication between Users, Developers, and management

Lakeshore Technical College December 2003-May 2004

Cleveland, Wisconsin

PeopleSoft 7.6 SA and Financials Production Systems Support

Kept production systems current by applying PeopleSoft fixes and bundles to Student Administration (7.6) and Financials (7.5 SP2) modules

Applied patches to production systems during off hours when appropriate

Managed and applied Student Administration (8 SP1) fixes and bundles for upgrade tests

Provided tracing, troubleshooting, and assistance with issue analysis when needed

Smead Manufacturing January 1998-October 2003

Hastings, Minnesota

PeopleSoft 8 Supply Chain Management Upgrade Technical Lead FSCM, HRMS 8.0, Tools 8.1x

Developed, maintained and provided production support for supply chain functionality

Technical lead on various upgrades and conversions from PS 7.02 to PS 8 SP3, including member of core platform conversion team to migrate PeopleSoft from Oracle/UNIX to SQL Server/Windows

Provided performance tuning of database, applications, and upgrade conversion processes

Provided Quality Assurance and Change Control standards (Policies and Procedures)

Liaison between development and technical employees; worked closely with security, DBA, and PeopleSoft administrators

Applied PeopleSoft changes and updates and maintenance packs

Performed troubleshooting of COBOL applications

Highmark, Inc. Blue Cross and Blue Shield Dec1996 - Dec 1997

Pittsburgh, Pennsylvania

PeopleSoft 6.0 Financial Systems Implementation Functional and Technical Lead

Provided application review and quality analysis of customizations

Developed a customized billing system to interface with PeopleSoft Financials and other external corporate systems

Wrote detailed specifications for a PeopleSoft conversion/interface application

ServiStar, Inc. June 1996 - December 1996

Butler, Pennsylvania

PeopleSoft Financials Conversion Consultant

Developed PeopleSoft SQR reports for Accounts Payable, Accounts Receivable, Billing and General Ledger and conversion processes to load into PeopleSoft from the legacy system

Developed C application interface to Informix for use in a third party Voice Recognition Unit (VRU) credit approval system

Additional Software Knowledge and Experience

PeopleTools v5-8.54

Application Packages

Component Interface

PeopleCode

Application Engine

Page design and development

Datamover

Configuration Manager

PIA Administration

PeopleSoft Security (including Auditing)

Workflow

SQL & PeopleSoft Query

SQR Programming

COBOL Programming

Crystal Report Writer

Tracing & Tuning

Data conversion/split

UNIX

IScript

LDAP integration

T-SQL

XML

Weblogic

Integration technologies:

Integration Broker

Services

Messages

SendMaster

BPEL

Excel to CI

File import/export

Microsoft Office suite

PVCS Version Control

Academic Background

AA, Long Beach City College, Long Beach, California

PeopleTools training: PeopleTools 8.10, PeopleTools I and II, PeopleCode, 8.48 Server Administration; 8.48 Integration Tools

Additional PeopleSoft Training: PeopleSoft Upgrade, PeopleSoft three-tier Architecture, Application Development methodology, TQM techniques and methodology, PeopleSoft Application Tuning Techniques, Visual C++

PeopleSoft Technical Certified Consultant

Contact this candidate