Helping customers integrate their data/systems on Workday.- Majority of experience Workday financial integrations

- Manage /Design ETL process for Investment data sources. Receive/Retrieve files, extract and load into MSSQL for data analysis.- Act as consultant to EDI team for IBM Sterling File Gateway and Sterling Integrator changes/troubleshooting.- Work with team to:--- Create, manage, install virtual Windows and Linux systems as needed.--- Manage and apply security updates to Windows and Linux systems--- Backup and restore data with Veeam and HP Data Protector--- Create/Edit Active Directory Accounts--- Create/Edit DNS entries- Install, configure, maintain Red Hat Enterprise Linux systems for medical billing system- Install, configured and maintained IBM Sterling File Gateway for SFTP connections with internal and external partners.--- Develop new BPML processes and maps to process investment market data - Built frame work on Linux for medical claims software and migrated from HPUX Unix to Red Hat Enterprise Linux- Integrated Linux sign on with Active Directory – Improved security and simplified management of user access (300 daily users)--- Controlled access to systems based on Active Directory groups--- Automated weekly data restore from production to test systems--- Scheduled and on demand restore via webpage using PHP and Linux scripts- Manage GlobalScape an FTP legacy application- Working on long term goal to move all FTP traffic to Sterling File Gateway

- Existing SI code inefficient and problematic. Installed SI 5.2.4 and built system from the ground up---- Successfully migrated to new SI system 10/2014 - Rebuilt existing external SOAP web service in SI--- Improved status/error messages and tracking--- Moved BASE64 encode/decode from Unix script to SI custom service adapter--- Moved internal real-time request from FTP to SOAP request--- Created XML map to extract/build required XML for SOAP response messages--- These changes reduced round trip response time from 20 seconds to 1.5 seconds- Designed XSLT to format email messages coming from SI- Developed and implemented automated archiving process to keep 6 months of data on Unix file system - Continuous process improvement and elimination of manual processes- Develop Unix scripts to monitor file system, Document counts, Database, Communications and SI health- Worked with application team to standardize input/output of app data to SI --- Updated all maps to accept new format 270/271, 276/277, 834, 835 and 837s (Pro/Int/Dental) correlation table. Producing better visibility of document processing.- Developed envelope generator in PHP to build new trading partner envelop setups and load into SI--- Only requires user to input TP Name, Sender ID, select Receiver ID and select documents--- Used SI workflowLauncher.sh to launch custom BP that loads envelope in SI and sends email- Configured SI LDAP to authorize users against active directory for increased security- Created an EDI Search database using BPML, MySQL and PHP. Allows EDI Analysts to research and view EDI documents in seconds what usually takes 20-30min of searching. Also provides visibility for reporting on document volume--- Installed MySQL JDBC on SI--- Installed MySQL and developed database tables--- Created web page for querying the DB using PHP and CSS--- Utilize PHP LDAP functionality to authorize users against active directory

- Migration from Gentran/GIS 4.3 to SI 5.2 – Successfully upgraded on 04/23/2013- Stabilize SI by improving system maintenance, streamlining existing BPs and queue tuning- Installed SI 5.2 on for a development server- Rewrite Business Process to improve system health and performance.- Fixed/improved SI maps- Worked with healthcare EDI documents - 270/271, 276/277, 834, 835 and 837s (Pro/Int/Dental)- Identify manual processes and automated with SI- Developed bigbrother.sh script to monitor file system and SI queue heartbeats.- Converted delivery of files in/out of backend from FTP to NFS increasing efficiency and dependability- Developed generic SFTP BPs to PUT/GET data from internal/external partners with minimal configuration

- Partners with IBM to provide clients with post sales implementation for Sterling Integrator (SI) and Sterling File Gateway (SFG).- Provide detailed documentation of installation/configuration process- Provide consulting on best practices- Update/Develop/Design SI business process (BPML) for clients- Update/Develop/Design SI maps- Clients serviced:* Reebok-CCM Hockey – Map changes* Silgan Plastics – BP development for SFTP* PHH Mortgage – SFG installation and configuration

Partnered with clients to manage/develop their EDI systems- Stanley Black & Decker: implementing EDI 215 documents from a QAD ERP.- Georgia Pacific: --- Upgrading AAFES 850/855/810/856 maps--- Vistex maps EDI to XML--- Update 40 invoice (880 & 810) maps --- Update 880 invoice maps to accept both credit and debit memos

Develop and support EDI integration with all Georgia Pacific divisions.UNIX, LINUX, TrustedLink Enterprise, Gentran Integration Suite (GIS), Sterling Integrator (SI)

Responsible for all EDI integration with ERP (QAD MFG Pro) system using TrustedLink.

Developed and maintained EDI programs/transactions with ERP (PRMS AS/400) and TrustedLink iSeries.