Matthew Eichmann Email & Phone Number

Camden, New Jersey, Us

Responsible for creating and maintaining SQL stored procedures for integration of EDI data from canonical SQL tables to third party applications such as Manhattan, Softeon, and 3G by way of field mapping. Customers include but not limited to Amazon, Roland Music, Deckers, Spencer's, and Lowes.Created and modified entries in SQL control tables for configuration of operation of stored procedures.Created carrier configurations for customers in the Boomi environment.Provided off hour support for internal departments.Applications used are Boomi, SSMS, Sterling Integrator, MFT Go Anywhere, Rabbitt MQ, JIRA, Confluence, Microsoft and Google applications.

Philadelphia, Pennsylvania, Us

o EDI Billing Support, develop, and maintain an environment where EDI enhances business communication between the company and over 30 trading partners. Significantly cut EDI managing issues by identifying and resolving numerous mapping or abnormality issues in trading partner transactions. Format and process client invoices in SQL environment for Purchase Order and Non-Purchase Order invoices. Transmit invoices through FTP, HTTPS and EZ Connect applications. Updated validation rules, price list catalogs and contract dates. Performed postdate scripts for invoices. Managed National account tracking application. Research errors and issues in SQL and make corrections. Corrected CXML error in orders. Managed cost split percentages between multiple cost centers of clients.o SQL Server Execute stored procedures for reporting, data importing and maintenance using T-SQL. Research issues by creating custom T-SQL scripts. Reload ODS markets for proper inventory in SSIS environment. Run reports for micro market, lost business, and current inventory value for analysis Develop T-SQL stored procedures for data retrieval and efficiency.o Technical Support Perform technical support for multiple Excel applications and VBA code behind. Used as resource for technical issues with SQL server.

Bristol, Pa, Us

Manage client purchasing systems through SAPMaintain change requests through excel spreadsheetsResearch change requests via user contact and investigationProduce daily and monthly checks and balances and reports

o Oversee company’s database and maintain database encompassing over 800MB of data.o Create SSRS reports using Microsoft Report Builder. Created over 350 reports.o Managed company SSRS portal Configured SSRS portal for company use. Maintained user permission and folder security. Configured shared data sources for data retrieval. Managed over 100 email subscriptions to reports to both employees and external clients.o Create SSIS server jobs in Visual Studio BIDS for data import, mapping, conversion and export. Deployed server jobs to SQL server and configured for automatic processing.o Create database tables, relationships, indexes, and diagrams.o Create T-SQL stored procedures and functions. SELECT statements including but not limited to JOINS, Outer and Cross APPLYS, Filters, Grouping and Calculations. Pivot Tables.o Maintain security permissions SQL database. o Maintain company’s online SharePoint website. Create document libraries and maintain content. Maintain permissions and security. Add web parts to SharePoint Siteo Maintain company website using WordPress.o Assist employees with general help desk issues.

Hatboro, Us

Maintain company's database which encompasses over 1TB of data.Develop T-SQL stored procedures and functions in SQL server for daily processes.Build and maintain in house client specific applications in VB.net. Clients include Comcast, Citibank, and Merrick bank.Create layouts through Latitude Exchange manager for importing of data from Excel spreadsheets.Create reports using SSRS environment.Help with computer support.

• Business Intelligence/SQL/Microsoft Access Developer – May 2010 – July 2016o Business Intelligence Development Creation of over 200 SSRS reports using BIDS module in Visual Studio.• Created custom shared data sources• Created custom datasets using T-SQL stored procedures.• Reports including but not limited to tables, matrixes, lists, dynamic parameters, and graphs.• Saved working files to prevent accidental overwriting or deletion of production reports.• Deployed production reports to SharePoint internal website for consumption.o SQL Development Creation and maintenance of SQL database tables, relationships, indexes, and security access. Creation of T-SQL stored procedures and functions for proper data retrieval.• Use of SELECT, INSERT, DELETE and UPDATE statements.• Use of INNER and OUTER JOINS.• Proper filtering of data using WHERE statements.o Access Development Responsible for design and maintenance of over 120 applications for all 36 departments of Burlington County.• Created Access applications using SQL ODBC connections.• Created forms, tables, lists, and dynamic content.• Coded applications with VBA for further functionality and efficiency.• Incorporated such technologies such as XML extraction, address geocoding and network connectivity. Designed Beta applications in Microsoft Access for use as web apps in SharePoint. Creation of Access applications in a Dell Venue tablet environment. Created documentation and trained users on over 12 applications.

C.W.S. Certification, Web Page, Digital/Multimedia And Information Resources Design

Computer Programming, Computer Programming

H.S. Diploma, Electronics