SAMUEL MATTERN

***** ***** ***** **********, ** *1311 818-***-**** adt2bk@r.postjobfree.com www.linkedin.com/in/smattern3/en

Information Technology Management

APPLICATION DEVELOPMENT & MANAGEMENT ENTERPRISE IMPLEMENTATIONS BUSINESS SYSTEMS ANALYSIS

Experienced IT manager offering 30+ years of success leading all phases of diverse technology projects Managed technology teams in diverse situations and settings: private & public companies, $12mm to $120 billion per year, heavy process cultures and extremely casual environments; and companies that experienced dramatic transitions such as merger or closure.

Over 27 years of experience on the AS/400 (iSeries) platform. Technical management, development, administration, architecture, infrastructure & security.

Expertise in ANSI X12 EDI with over 20 years of experience. Implementation and management experience with retail, distribution, mortgage, and mortgage insurance trading partners.

Enterprise Data Compliance Secure and confidential data integrating per the most rigid requirements demonstrated and ensured through daily SQL query reporting enforcement of data obfuscation policies.

Expert in agile and waterfall project management methodologies. Able to manage large project teams and known for high-quality deliverables that meet or exceed timeline and budgetary targets.

Core strengths are building and managing motivated, skilled team members Establishing strong relationships with clients and project partners and an obsession with problem-solving. Proficient in SDLC management process from concept to implementation, both waterfall DMAIC and Agile methodologies.

Skills Summary

IT Management:

Systems and applications ownership

Report to Executive Management

P&L responsibilities

Resource management

Maintenance contract agreements - bidding, negotiation, renewal

ITIL and PMP Certifications in progress

Application Risk and Governance:

Confidential/Secure Data – NPPI, Access Reviews, PCI Compliance, Risk Audits

Regulatory - OCC Mandates, HUD Regulatory/Audits, MERS, CFPB, Dodd-Frank, FCRA, DOJ Orders

SOX & SEC Compliance – Integrated in Global Security Requirements

BC/DR – Annual planning, exercise, improvements

Customs Audits – Duties/Tariffs

Federal Ad Hoc Audits

Business Systems Analysis

Custom Software Development

Database Design (RDBMS)

Systems Engineering

System Migrations/Integrations

Enterprise-wide Implementations

SDLC: Waterfall & Agile

Requirements Analysis

ROI Analysis

Costing & Budgeting

Project Scheduling

Testing/QA/Rollout/Support

AS/400 (iSeries) Expertise:

OS/400. RPG, RPG ILE, CL, API and DB2 SQL programmer

ERP Software. CA-KBM, JDA MMS, BPCS, PKMS and DMAS software.

Utilities. OpenText TrustedLink EDI Software, Hawkeye, TLAshford Bar Code Software, Sequel, DBU, ACOM, SQL, IBM I Access, NuBridges Trailblazer (ZMOD) and Turnover.

Mgmt. Tools: MS Visio, Cognos, SharePoint, Maximo, MicroStrategy, Remedy, HP ALM (Quality Center)

Work Experience

Home Depot, Simi Valley CA Plumbing Product Management 04/22 – Present

Responsible for providing in depth knowledge of plumbing, bathroom and kitchen products.

Maintain department standards for product placement and inventory control

Achieve department goals of key performance indicators through customer service and standard operating procedures

West Valley Pool and Spa, Chatsworth CA Sole Proprietor 01/18 – 01/22

Perform duties in cleaning, filtration, and maintenance of swimming pools and spas.

Maintain, clean and service pool equipment

Subcontractor for pool equipment upgrades and surface refurbishments.

Bank of America Mortgage Division, Agoura Hills, CA Test Data Management - Application Programmer V (Contractor: TEKsystems) 09/17 – 12/17

MSP (Mortgage Servicing Package) for servicing outsourcing project to BKFS (Black Knight Financial Services)

Test Data Management team for Test Best Health and Data Conditioning across multiple platforms

Platforms serviced: AS/400, Data Warehouse Mainframe, Oracle; utilizing TOAD, DB2, BKFS, SQL/400.

Database integrity analyzed using SQL queries and Excel tables.

Development of automation scripts in VBA.

Documentation author of TDM Playbook for on-boarding, best practices, procedures, etc.

Bank of America Mortgage Division, Agoura Hills, CA Test Environment Build Developer (Contractor: Collabera) 04/16 – 07/17

Test Environment Deploy and Support technician for AS/400 systems with high utilization of DB2, SQL/400 and other DB tools.

Highest completion rate of inbound and outbound technical service request among TEB staff

Developed Outlook and Excel VBA scripts to improve response times and monitor issue progress

Technical OS400 support of profile, object authority, job management and advanced operational support.

Turnover support administrator for bank test environments.

Advanced support to special deployment FTE leads.

Documentation author of TEB Playbook for onboarding, best practices, procedures, etc.

Denso Products & Services Americas, Inc (DPAM), Long Beach, CA Senior EDI Programmer/Analyst (Contractor: Intellikore) 07/15 – 10/15

Provided AS/400 RPG ILE/CLP program development, analysis, application designs and support in a multi-language, cross-platform environment. Utilized standard AS/400 tools/utilities Hawkeye, DBU, Turnover, ESEND, Robot, DB2, SQL/400 and TAATOOL.

Data integrity and validation utilizing SQL and Query/400.

Built interfaces to processes data to/from TrustedLink EDI translator for cross platform transfer and validation between AS/400 BPCS and Oracle systems.

Developed new EDI processor program to move customer-specific exceptions from hard coding to control tables to handle exception rules, re-built translation formats (maps) for each customer for integration with the new interface, and new Trading Partner Relationship profiles for each.

EDI Documents managed: Purchase Order (850), Purchase Order Acknowledgment (855), Shipping Schedule (862), Planning Schedule with Release Capability (830), Invoice (810), Remittance Advice (820), Application Advice (824), Advanced Ship Notice (856).

Bank of America Mortgage Division, Agoura Hills, CA Application Manager, Lead Cnslt – Apps Prog Engin 06/11 – 04/15

Responsible for operations of Shared Services Technology HLIT EDI Services application to provide lights-on (BAU) support for its clients, deliver on its initiative portfolio, and ensure 100% compliance with Application Governance requirements.

Manage a team of professionals providing BAU 24x 7 onshore/offshore support of Business Technology Groups and their external trading partners, such as HUD, MERS, MI Companies, EPS, Credit Reporting Agencies, Investor Reporting, USDA/Rural Housing, and Balboa Insurance.

Successfully delivered implementations of major Federal Regulatory initiatives: OCC Oversight Mandates, Consumer Financial Protection Bureau (CFPB), Dodd-Frank, Fair Credit Reporting Act (FCRA), MERS, and HUD Rule changes.

Managed SDLC (Waterfall & Agile) from concept through production in warranty phase, including BRD, HLD, LLD, ACD documentation meetings, release management activities, QA supervision, code review, and operational readiness (GO-NO/GO).

Flawless oversight of Application Governance, such as Secure/Confidential Data Governance, Business Continuity Planning and DR Exercises, NPI/PCI Compliance, application access reviews, approved communication/encryption standards, etc.

Provided backup application support for companion application team for Connect: Direct (NDM) management.

Alcoa Fastening Systems, Sylmar, CA iSeries System Engineer (Contractor: KForce) 03/11 – 06/11

Member of acquisition team managing KBM iSeries environment with BPCS Manufacturing integration for transition to QAD & Oracle platforms.

Managed relocation of iSeries and redeployment in a Twinax-free environment.

Architect and implementation project manager of a factory labor tracking bar code solution.

Designed and implemented paperless document solutions and decommission of impact printing operations. Customized MRC report application for automated report distribution and routine business processes in KBM ERP package to better leverage personnel daily tasks.

Starbucks Coffee Company, Seattle, WA EDI Functional Analyst (Contractor: Redspec) 09/10 – 12/10

Member of 3PL interface team: ownership of two Distribution Centers and two XML EDI interfaces.

Technical design and EDI interface implementation specialist for Back-of-House team for integration to forward facing systems. XML Schema testing.

SQL report developer using AQT interface for reconciliation of JDA MMS vs. staging file data vs. service provider reporting.

Team representative to Global Business Solutions Systems committees and Test Case teams.

All Access Apparel, Montebello, CA Vice President of Information Technology 12/09 – 6/10

Inovis TrustedLink EDI administration of 810, 824, 850, 855, 856, 864, and 832 documents for prominent retail trading partners. Managed AS2 certificates in Inovis BizConnect and maintained GDSN 1Sync data pool.

Managed electronic trading partner relationship with Wal-Mart, Kmart/Sears, Kohls, JCPenney, Macy’s and others.

Managed 10 servers Windows network environment and iSeries ERP platform. Windows 2008 server, Exchange 2010, MS SQL Server 2005 and ISA server.

Managed retail supplier scorecards and selling reports and attended Wal-Mart and Ksears training.

SQL and Query/400 validation, as well as embedded SQL in RPG programs to generate discrepancy reporting.

Jacuzzi Group Worldwide, Chino, CA Business Analyst (Independent Contractor) 12/07 – 12/09

Analyzed business processes with respect to KBM software running on IBM iSeries platforms integrated with BPCS Manufacturing Module.

EDI Administration for hard-line trading partners such as Lowes, Ferguson, Hughes Supply. Document mapping and management using Inovis TrustedLink. AS2 certificate management using Trailblazer.

Big Hammer Marketing Data Pool Administration, 1Sync GDSN and web data support for Lowes, Home Depot and Ferguson accounts.

Drafted functional requirements, consulted with business sponsors on budget impact, and recommend best course of action for company’s interest.

Project management from business sponsor request through revision, testing, user sign-off, coding, change activity request (CAR), change control board presentation, promotion, and post-promotion follow-up.

Developed and maintained trading partner EDI programs utilizing RPG, RPG ILE, CLE, SQL and ODBC interfaces MS Access programs.

Shoe Pavilion, Pinole/Sherman Oaks, CA Information Technology/Retail Systems Manager 09/05 - 07/07

Managed all Information Technology and Retail Systems functions for a publicly-traded retail company with 108 stores and 1200 employees.

Directed operations of production platforms: IBM iSeries, running JDA MMS Software for merchandise management; and Point-Of-Sale (POS) systems utilizing Excellenet (Sybase) Polling Servers and Datavantage Store21 POS Software at point-of-sale.

Implemented and maintained proper procedures, controls, and testing for SOX and PCI Compliance.

QRS UPC Catalog initiative to improve inventory accuracy, track usage for replenishment, and identify shrinkage.

PDI Enterprises, Valencia, CA RPG Developer/iSeries System Admin/Business Analyst 10/03 – 09/05

Performed programming and admin duties in RPG and CLP for a pharmaceuticals distributor.

Front-end application was a pharmaceutical package integrated with BPCS Distribution module.

EDI Administration of 850 and 810 documents including setup, transmission monitoring, and problem resolution.

Electronic offer flat files submission to McKesson, AmerisourceBergen, Cardinal Health and secondary market pharmaceutical distributors.

Contact this candidate