Samuel Mattern Email & Phone Number

Los Angeles, CA, US

• Develop and maintain complex financial models to evaluate potential investments, including valuation models, pro forma financial statements, and scenario analyses.
• Analyze financial statements, market trends, and economic conditions to provide insights and recommendations.
• Investment Research
• Conduct industry and market research to identify emerging trends, potential investment opportunities, and competitive dynamics.
• Monitor and report on portfolio company performance, industry developments, and relevant financial metrics.
• Data Extraction and Reporting

• IBMi Systems Administration, including OS upgrades & migrations, device setup, security configuration, and performance tuning.
• Short-term RPG/CL development and break-fix projects
• Third-party IBMi-based software installation and configuration

Charlotte, NC, US

• 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.
• Development of automation scripts in VBA
• Documentation of TDM Team Playbook

Charlotte, NC, US

• Test Environment Deploy and Support technician
• 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.
• Support for MSP (Mortgage Servicing Packaging) for iSeries transition to BKFS for outsourced servicing.
• Turnover support administrator.

• Provided AS/400 RPG ILE/CLP program development, analysis, application designs and support in a multi-language, cross-platform environment. Utiliized standard AS/400 tools/utilities Hawkeye, DBU, Turnover, FMG, ESEND.
• 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.
• 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.

Charlotte, NC, US

• Responsible for operations of Shared Services Home Loan & Insurance EDI Services application to provide lights-on (BAU) support for its clients, deliver on its initiative portfolio, and ensure 100% compliance with.
• 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.
• 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.
• 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.
• Flawless oversight of Application Governance, such as Secure/Confidential Data Governance, Business Continuity Planning and DR Exercises, NPI/PCI Compliance, application access reviews, approved.
• Provided backup application support for companion application team for Connect:Direct (NDM) management.

Torrance, California, US

• Member of acquisition team managing KBM iSeries environment 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.

Seattle, WA, US

• Member of 3PL interface team: ownership of two Distribution Centers and two EDI interfaces.
• Technical design and EDI interface implementation specialist.
• Member of Back-of-House team for integration to forward facing systems.
• SQL report developer.
• Team representative to Global Business Solutions Systems committees and Test Case teams.

Montebello, California, US

• Managed 10 servers Windows network environment and iSeries ERP platform. Windows 2008 server, Exchange 2010 and ISA server.
• Managed electronic trading partner relationship with Wal-Mart, Kmart/Sears, Kohls, JCPenney, Macy’s and others.
• 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 retail supplier scorecards and selling reports.
• Managed phone and printer/copier contracts.
• Attended Wal-Mart Retaillink and KSears IMA training.

Irvine, CA, US

• Analyzed business processes with respect to KBM software running on IBM iSeries platforms.
• 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.
• Received, reviewed, and qualified user requests for program modifications, 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 maintained trading partner EDI programs utilizing RPG, RPG ILE, CLE, SQL and ODBC interfaces MS Access programs.

US

• Managed all IT 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.
• Implemented and maintained proper procedures, controls, and testing for SOX and PCI
• EDI Administration of 850 and 810 documents including setup, transmission monitoring, and problem resolution. Also includes QRS data interchange operations.

• Performed programming duties in RPG and CLP for a pharmaceuticals distributor.
• Managed EDI, FTP, SNADS, and file transfers to Pharmaceutical distributors.
• EDI Administration of 850 and 810 documents including setup, transmission monitoring, and problem resolution.
• Performed System Administration for iSeries, including OS/400 upgrades, user profile management & security, backup management, hardware configuration.
• Worked with Department Managers to improve or develop new IT solutions to increase productivity.
• Administration for Windows 2000 server and MS Exchange 5.5.

• Managed all IBM AS/400 system activities including direction of programmers, design and implementation of programs, and hardware setup.
• Performed programming tasks in RPG IV, RPG ILE, DDS and CL, and well as preparing Statements of Work for project approvals and communicating functionality to programmers. This included cost vs. benefit, as well as.
• AS/400 production system was DMAS ERP software, with T.L.Ashford and Peregrine TrustedLink packages, as well in-house modifications.
• Implemented EDI program for 810, 855, and 850 documents.
• Organized, coordinated and supervised physical inventories, including design of P.I. programs, G/L vs. perpetual reconciliation, and acted as liaison to outside audit teams.
• Developed Work Order system for secondary product processing and Bill-Of-Materials system for creating and exploding assemblies.

Westlake Village, CA, US

• Supervised all inventory control functions for a national music retail company, including physical inventory coordination and reconciliation, G/L vs. perpetual reconciliation, and direction of 8-person inventory.
• Systems administrator for Prime mainframe and member of systems conversion team.
• Implemented cycle count program to aid Loss Prevention personnel.
• Migrated data to new POS system.
• Lowered irreconcilable differences and shrinkage losses while reducing personnel and department expenditures.