Uploaded File
Sarah
jsrossflorida@yahoo.com
239-222-3974
1075 Featherwood Ct.
Atlantic Beach, FL 32233
EDI Integration Engineer
25 years experience W2
0
Recommendations
Average rating
55
Profile views
Summary

Summary

I have worked in IT for over 25 years held many different positions and worked on different platforms. During my years in IT I have perform the following different roles: Analyst, Technical Support, Software Engineer, Data Analyst, Lead Specialist, Tester, Support, and Trainer. My background includes over 10 years in EDI, and over 15 years in Data Warehouse and mainframe.

Business Skills

My business skills include strategic planning, full development life cycle, customer service, and excellent interpersonal skills. Agile experience: Data Mart structure, incorporating system flow charts, feedback, and lessons learned into changes to the system process.

Industry Experience

My industry experience includes retail, transportation, logistics, shipping, HIPAA and health, banking, and law enforcement.

Instructional Design/Training

My background in instructional design/training include training colleagues on EDI and data warehouse, developing TMW training documents for over 100 employees. Also created two LMS websites which incorporates Knowles Andragogy theory of adult learners, Meziro Transformation learning, and Klob’s Experiential learning theories. I’m also working on my dissertation ‘Organization Leaders’ Perception: Impact of Changes in Approaches to Training Programs’.

EDI Background

I have worked in EDI for over 10 years on different platforms. Industry experience includes two years working in health industry and over eight years in the retail, warehouse/logistics, transportation, and shipping. EDI roles included Analyst, Technical Support, Software Engineer, Data Analyst, Lead Specialist, Tester, and Support. EDI software experiences include cloud base CLEO Harmony/Dashboard, Gentran 3.0 and 4.2, GIS SI 4.3, GXS, Ramp, and TradeXpress. Below will highlight my 10 plus years experience in EDI:

Retail, Warehouse/Logistics, Transportation, and Shipping

Over eight years experience incorporating agile framework into development, implementing, revisions, testing, and monitoring. EDI roles include Analyst, Technical Support, Software Engineer, Data Analyst, Lead Specialist, Tester, and Support to perform the following tasks:

  • Agile framework to incorporate EDI standards and requirements into mapping, B2B, and supporting EDI process.
  • Access information from data warehouse tables using SQL in the following environments: DB2, Teradata, Oracle, MySQL, SSRS reports, and iSeries.
  • Testing and supporting EDI process.
  • Communication support: AS2, FTP, SFTP, and VAN.

Types of EDI documents include the following Retail Documents: (810) Invoices, (820) Remittance Advice, (830) Forecast summary/embedded orders, (845) Open Ship/Debits, (846) Inventory Availability and Inquiry/Advice, (849) Ship/Debit, (850) Orders, (855) Order Response, (856) Shipping Notice, (860) Order Change, (867) Sales Order Change/Point of Sale and (997) Auto Response. Warehouse/Logistics: (940) Warehouse Shipping Order, (943) Warehouse Stock Transfer Shipment Advice, (944) Warehouse Stock Transfer Receipt Advice, (945) Warehouse Shipping Advice and (997) Auto Response. Transportation: (204) Motor Carrier Load, (210) Motor Carrier Freight and Invoice, (214) Transportation Carrier, (990) Response to a Load Tender and (997) Auto Response. Shipping: (300) Booking Request, (301) Booking Confirmation, (322) Terminal and Ramp Activity, (323) Vessel Schedule, and (997) Auto Response.

Health Industry

One year incorporating logistics into the healthcoverage

Two years in health industry working with HIPPA, and ICD 9 & 10. Incorporated agile framework in performing the following tasks:

  • ICD 9 to ICD10 conversion
  • AS400 Interface setups – Worked with throttled back other HL7 transactions in order for ADT transactions came first.
  • Mapping and communication setups.

Types of EDI documents include: (835), Health Care Claim Payment/Advice and (837) Health Care Claim, Remits (277), Response (999). HL7 documents include (ADT) Patient Admit, (ORM) Orders, (ORU) Results, (MFN) Master File Notification, (RDE) Pharmacy Order, (DFT) Charges, (MSH) Messages and (ACK) Acknowledgement.

Data Warehouse Background

I have worked in Data Warehouse capacity for over 15 years. Industry experience includes transportation and shipping, retail and logistics, and Food. Data Warehouse roles include EDI, DBA, Lead Data Warehouse Developer, and ETL Developer. Different Data Warehouse tools included DB2, Teradata, Oracle, MySQL, and iSeries. Platform includes both Mainframe and UNIX. Below will highlight my 15 plus years experience in Data Warehouse:

  • Extracting and mapping EDI data using Oracle and Microsoft SQL.
  • Writing complex SQL queries.
  • CASE statements.
  • DBA (Data Base Administrator).
  • Performance tuning.
  • Testing and validating information retrieved from both the mainframe and Data Warehouse tables.
  • Incorporating agile framework into data analysis including creating adhoc queries, ETL (Extract Transfer Load), and creating data definitions and data collections.
  • Data Modeling.

Mainframe Background

I have over 15 years experience working with mainframe processes. Industry experiences include transportation, retail, insurance, and law enforcement. Mainframe languages include: SQL, COBOLMVS, COBOLII, SAS, VSAM, PLI, DYL280, Easytrieve, CICS, OS/MVS OS390 and JCL. Agile framework was incorporated into the following tasks:

  • System Development Life Cycle
  • Testing and Validation
  • Documenting
  • Working with customers and business team to create solutions
  • Requirement gathering

Experience
Business Analyst
Information Technology
Jan 2021 - present
  • Long-term contract.
  • Working on creating mapping specs for their SAP system.
EDI Business Analysis SAP
Remove Skill
Software Developer
Transportation
Sep 2019 - Aug 2020
Atlantic Beach, FL

Provided EDI logistic solutions for the following healthcare transactions: member imports (835), encounter export (837), remits (287), response (999)

  • Incorporated DB2 SQL transactions to provide inventory of all healthcare setups in the LCAD software.
  • Incorporated a combination of the following technology to performed updates to current healthcare setups on the legacy system as changes to the healthcare industry occurred: DB2/SQL, RedPoint, and Legacy (LCAD).
DB2 EDI SQL
Remove Skill
EDI Specialist / EDI Coordinator
Chemicals/Pharmaceuticals
Mar 2019 - Mar 2019
Cary, NC

I was brought in for a 3 week contract to perform a Gap/Business analysis on their current EDI process (SAGE). My analyses included make recommendations on their current EDI process and make a determination on the need to hire an EDI employee. Using Excel to develop agile framework to make the following recommendations:

  • Charts to demonstrate the number of different EDI transactions (810, 850, and 856) processed and received errors.
  • Charts to demonstrate number of work hours split out by EDI, and non EDI work.

Other work included:

  • Monitoring EDI transactions in Sage
  • Re-transmitting EDI documents
Agile Methodology EDI Microsoft Excel
Remove Skill
EDI Analyst
Transportation
Apr 2018 - Jan 2019
Medley, FL

EDI Analyst for a transportation/shipping company. I perform EDI analysis on EDI government documents (300, 301, 322, 323, 990, 997, and 999) and EDI transportation documents (204, 214, 990, and 997).

  • Support EDI documents Cleo Harmony/Dashboard and AS400.
  • Tested and validated EDI data between the AS400 and cloud base Cleo Harmony/Dashboard.
  • Validated EDI documents in Extol and Cleo Harmony/Dashboard.
  • Support communication using EXS and AS400.
  • Incorporated agile framework of organization and government EDI rules and regulations to communicate with customers on EDI issues.
  • Perform SQL queries in iSeries to identify solutions.
  • Trained employees on EDI support.
EDI EDI Analyst Extol SQL AS/400 Agile Methodology
Remove Skill
Programmer Analyst
Transportation
Jan 2014 - Mar 2018
  • Developed training documents for TMW managed software to be used for ‘Super Users’ to train.
  • Trained Employees on Ramp EDI Software and EDI processes for logistics business.
  • Incorporated agile framework methodology into adjusting training documents based on feedback from both the Project Manager and the SME.
  • Incorporated agile framework to develop SSRS reports through TMW using Microsoft SQL.
  • Setup AS2, FTP, and database connections
  • Created an alert that checks for any inbound transactions that have not been processed for over 3 hours.
  • Mapping EDI 846, 940, 943, 944, 945, transactions in Ramp.
  • Acted as an EDI Coordinator for Comcar’s transportation business (CCC, CTL, MCT, and Coastal).
  • Was the ‘go-to’ person for the following EDI transportation transactions: 204, 210, 214, and 990.
  • Testing/Validation EDI data in Ramp.
  • Monitored EDI process in Ramp.
  • EDI support in Ramp.
  • Created Oracle Table to insert and delete customer data.
  • Created Smartsheet reports for the VP of IT.
Agile Methodology EDI FTP Oracle SSRS RAMP Logistics
Remove Skill
EDI Technical Support
Information Technology
Jun 2013 - Jan 2014
Indianapolis, IN

Supported EDI in TradeXpress and SAP

  • Setup EDI banking transactions in TradeXpressWorked on IDOC to EDI mapping in TradeXpress
  • EDI support in TradeXpress
  • Mapped SAP to EDI
  • Tested and validated EDI process in TradeXpress
  • Trained contractor from India on EDI process
EDI IDOC SAP Technical Support
Remove Skill
Teradata DBA
Aerospace/Defense
Aug 2012 - Jan 2013

Teradata DBA in the Aviation Group

  • Verified DDL sent in from developers and data modelers that it complies with standards
  • Performed system administrator upgrades, tuning, and monitoring in their EDW
  • Offered better performance on DDL
  • Offer suggestions on best practices based on RDBMS standard
  • Setup and maintained account access
Data Modeling Database Upgrades DBA Teradata RDBMS
Remove Skill
Software Engineer
Healthcare
Jun 2011 - Apr 2012
Naples, FL

I was a Software Engineer in converting and setup of over 66 hospitals that promoted Agile development methods.

  • Converted 837 flat file to ANSI X12 5010 version in Rhapsody mapping
  • Converted 835 ANSI X12 4010 and 5010 version to flat file in Rhapsody mapping
  • Converted 837 ICD9 codes to ICD10 codes in Rhapsody mapping
  • Worked on route setups in Rhapsody
  • Created multiple hospitals interfaces in AS400
  • Worked with timing of HL7 transactions on the network
  • Verified HL7 mapping of several different HL7 messages : Patient Admit (ADT), Orders (ORM), Results (ORU), Master File Notification (MFN), Pharmacy Order (RDE), Charges (DFT), Messages (MSH),Acknowledgment (ACK)
  • Trained team mates on Rhapsody mapping
Agile Methodology Software Engineer 837 Rhapsody HL7 AS/400
Remove Skill
Technical Data Analyst
Banking/Financial
Nov 2010 - Apr 2011
Plano, TX

Technical Data Analyst for the Wells Fargo/Wachovia conversion.

  • Created EDI Remittance Advice (820) based on; Migration package sent in, check delivery setup and Type of file sent in (csv, flat file, and NACHA).
  • Create Pre-Processer document to be turned over to development team.
  • Pulled files from the Unix server.
Data Analysis EDI UNIX
Remove Skill
Lead EDI Specialist
Healthcare
Apr 2010 - Oct 2010
Plano, TX

Lead EDI specialist in the setups and EDI integration for hospitals, providers, suppliers, and vendors.

  • Worked closely with hospitals and suppliers to set up the EDI integration through weekly meetings and constant communications.
  • Setup, tested, and implemented EDI transactions for hospitals, providers, suppliers, and vendors.
  • Mapping: Worked with global variables and uploading data from the BP into the map.
  • Made corrections and modifications to the BP.
  • Help train new contractors joining the EDI group.
  • Created peer reviews for all EDI integration.
EDI
Remove Skill
Lead EDI Tester
Food/Beverage
Apr 2008 - Dec 2009
Frisco, TX

Tester to ensure the EDI processing was correct. GXS and GIS (SI)

  • Verified connection on the GIS server
  • Tested XML maps
  • Tested and verified EDI transportation EDI transactions – 204, 214, 990, and 997
  • Picked up files sent in from the SAP system using UNIX and sent them out through the VAN
  • Help with migration from GXS to Gentran (SI) 4.3
  • Tested GIS 4.3 maps and corrected extended rules issues
  • Tested all the above transactions in Unix environment; using both Unix and Slick Edit
EDI XML UNIX SAP GIS
Remove Skill
EDI Programmer Analyst
Information Technology
May 2006 - Jan 2008
Fort Worth, TX

Added Enhancements and development of EDI Envelops, and MAPS for both ANSI X12 and EDIFACT.

  • Set up trading partner to access the VAN through Sterling Commerce
  • Set up business process in both ANSI X12 and EDIFACT using GIS 3.0 and migrating to 4.2.
  • Worked with customers and venders in Europe, North America and Asia to set up EDI process
  • Set up inbound and outbound transactions for both vendors and customers which included transactions Invoices (810), Remittance Advice (820), Forecast summary (830) which included embedded orders, Open Ship and Debits (845), Inventory Availability (846), Ship and Debit (849), Orders (850), Order Response (855), Shipping Notice (856), Order Change (860), Sales Order Change (867), Point of Sale (867) and Auto Response (997) using MAPPER 3.0 and Gentran 3.0.
  • Created Envelopes in Gentran 3.0 and 4.2
  • Made enhancements to existing COBOL/CICS programs and OS/MVS JCL.
CICS Cobol EDI Sterling
Remove Skill
Programmer/Analyst
Insurance
Nov 2005 - May 2006
Louisville, KY

Work on the EDI team that created, modified, and enhanced test and production FTP and NDM applications.

  • Acted as liaison between new Humana Customers, Vendors to support the automated enrollment and eligibility processes.
  • FTP files to and from the client’s server encrypting or decrypting for use on the mainframe using OS/JCL and FTP commands.
  • Documented procedures for operations, which included scheduling and restart process.
  • Help with data analysis for receiving files from CMS organization which deals with discount Medicare coverage for seniors. Created a QUICKJOB to create files which I then import to Excel Spreadsheet for Senior Vice President of Humana to look at.
EDI FTP JCL Microsoft Excel Medicare
Remove Skill
Lead Data Warehouse Developer
Hospitality and Entertainment
Jun 2005 - Sep 2005
Louisville, KY

I developed an ETL process on Point of Sales for Pizza Hut in Canada. I was renewed to work on Pizza Hut Engineering Project.

  • Extracted information using SQL calls to the DB2 and Teradata 5.1 database.
  • Used COBOLMVS with TELON and JCL to transform sales information.
  • Loaded information onto the Teradata database using Fast Loads and MLOAD.
  • Data analysis for the Engineering Project to load oven settings for Pizza Hut stores throughout the world. Which included designing and loading of teradata tables using joins to other tables, and creating a technical document which outlines the table layouts and design specification.
  • Data Analysis including creating adhoc queries.
  • Creating logical data models, data definitions and data collections.
Data Analysis Data Warehousing DB2 ETL SQL Teradata Cobol
Remove Skill
Lead Data Warehouse Developer
Retail
Sep 2004 - Feb 2005
Tampa, FL

Work in EDW group at Publix a grocery store chain.

  • Created AC Nielsen rating reports that is used to report on external sales using BTEQ and Fast Export.
  • Was part of a team that designed “Items Not Scan” process that reports on stores and top 1500 items that were not sold in a qualified store, so representatives can be sent out to that store to determine the cause. This was designed using Fast Exports, BTEQ and JCL.
  • Performance enhancements in a Teradata 5.1 environment.
  • Performance tuning of MLOAD, FASTLOAD, and complex SQL queries.
  • Used PMAN in test environment to monitor performance of complex SQL queries.
  • Created and maintain complex SQL queries.
  • Extracted data from DB2 and other data source, transformed data using SYNCSORT, FASTLOAD or COBOL, then loaded data to the Data Warehouse using complex SQL queries that included inner and outer joins to other tables and to itself.
  • Handled performance issues of long running SQL queries using PMAN and explains to identify the problem.
  • Data Analysis including creating adhoc queries.
  • Creating logical data models, data definitions and data collections.
Data Analysis Data Warehousing DB2 SQL Teradata SYNCSORT Cobol BTEQ
Remove Skill
Lead Developer
Transportation
Mar 2004 - Sep 2004
Raleigh, NC

Work in EDW group at United States Postal Service.

  • Handle several billion row processes table on a large 38 node processor.
  • Created Korn Shell Scripting to create Teradata tables.
  • Created Korn Shell Scripting to extract a file that was landed on the server; then manipulate the data and finally, load the data to the data warehouse.
  • Fixed long running shell script loading aggregate Teradata table by including collect stats on tables.
  • Fixed spool space problem when multiple inserts to same table; by adding multi-thread inserts.
  • Handle all EDW promotion requests.
  • Created Teradata temporary worktables.
  • Perform MLOAD, FASTLOAD to Teradata tables.
  • Perform BTEQ to gather information from Teradata tables.
  • Data Analysis including creating adhoc queries.
  • Creating logical data models, data definitions and data collections.
Data Analysis Data Warehousing Korn Shell node.js Shell Scripts Teradata BTEQ Scripting
Remove Skill
ETL Developer
Transportation
Jan 2003 - Jun 2003
Roanoke, VA

Was assigned to the Financial Decision Support System. Lead Developer for the extract, transformation and load of financial applications to the Teradata data warehouse platform.

  • Used CASE tools to manipulate data.
  • Wrote SQL to join Teradata tables together, create reports, and verify information.
  • Used Query Man to perform optimization of queries, and gather information from the Teradata tables.
  • Expert in OS/MVS OS390 JCL tools.
  • Resolved Teradata table problems and issues.
  • Used BTEQ to monitor Teradata table load for any anomalies and unique violations.
  • Performance tuning of Teradata tables by looking at the primary indexes.
  • Used Queryman to verify test results and to test scripts.
  • Data Analysis including creating adhoc queries.
  • Creating data definitions and data collections.
  • Designed logical data models using Erwin.
Data Analysis Data Warehousing ETL ETL Developer SQL Teradata Erwin Data Modler
Remove Skill
Sr. System Developer
Transportation
Jun 1997 - Jan 2002
Fort Worth, TX

I was assigned to the 2 Terabyte Data Warehouse shop that supported the cost system in 1997 to 2000. In 2001 was reassigned to the Data Warehouse team that supported the finance system.

  • Data Modeling tool used Hummingbird 5 years to design views and tables.
  • Designed Teradata tables and views for the Finical Cost system.
  • Performed MLOAD and FASTLOAD to load cost information to Teradata tables
  • Used Hummingbird BI/GQL to report on information from the Teradata Data Warehouse.
  • Worked closely with DBA, Team Lead, and Project Manager in designing of Teradata tables for the Cost system.
  • Wrote COBOLMVS programs to extract information from DB2 tables using embedded SQL code. Also to create and manipulate data to be loaded to the Teradata tables.
  • Supported business clients by providing answers, reports, or special services. In COBOL, SAS, ALS, RPGII, JCL, DB2, Teradata, SQL, and DYL280.
  • Resolved problems and issues pertaining to the Data Warehouse.
  • Data Analysis including creating adhoc queries, ETL tools using Hummingbird, also creating data definitions and data collections.
Data Analysis Data Warehousing DB2 ETL Project Management SQL Teradata Cobol Data Modeling DBA JCL SAS
Remove Skill
System Developer
Insurance
Feb 1995 - Jun 1997
Bedford, TX

Developed insurance forms using ZICKS/ZACK. Installed and tested changes to the PMSC health insurance online software package using COBOLII and CICS. Created reports using Easytrieve.

  • Enhanced insurance reporting system from 12 hours to five minutes with the use of Easytrieve.
  • Added customer information to the PMSC online screen with the use of COBOLII and CICS.
  • Installed and test policy print procedures.
  • Testing and debugging using XPEDITER, File Aid.
XPEDITOR Easytrieve Cobol
Remove Skill
System Developer
Government
Jan 1991 - Feb 1995
Dallas, TX

Installed, supported, and tested Dallas County Book-in, Bond, Pretrial, and Vault jail systems using COBOL, Hyper Faster, and Amogos. Also maintained and installed changes to the security system using RACF.

  • Project manager on the development of an online system that tracks the number of persons arrested by offense or by date of offense using COBOL, OS/MVS OS390 JCL, Hyper Faster, and Amogos.
  • Trained officers to use this system and set up weekly status schedules.
Project Management JCL Cobol
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Doctoral in Instructional Design Technology
Keiser University, 2015 - 2020

Dissertation Proposal: Organization Leaders’ Perception: Impact of Changes in Approaches to Training Programs

Developed 2 learning management websites:

  • Ramp EDI Tool Taking EDI to the Next Level: https://ramptrainingcurriculum.weebly.com/
  • Power of SQL: http://basicsql.weebly.com/

Master's in Information Systems Management
Keller Graduate School of Management, 1998 - 2003

Thesis: Designed an Online Banking system that links the current DB2 subsystem to NCR 5100 Teradata Data Warehouse system - loading the information to the internet using NCR S26XLP II web server. Enterprise and business data model was designed along with the tables and views. Microsoft Access was used to create and test the tables and views. Cost benefit analysis and budget was done through Microsoft Project.

Bachelor's in Information Systems
DeVry University, 1988 - 1990
Skills
Cobol
2008
13
EDI
2021
11
JCL
2006
9
Project Management
2002
8
SQL
2020
7
Data Analysis
2011
6
Data Warehousing
2005
6
DB2
2020
6
Teradata
2013
6
Agile Methodology
2019
5
Data Modeling
2013
5
DBA
2013
5
ETL
2005
5
FTP
2018
4
Logistics
2018
4
Oracle
2018
4
RAMP
2018
4
SAS
2002
4
SSRS
2018
4
Easytrieve
1997
2
SAP
2021
2
UNIX
2011
2
XPEDITOR
1997
2
AS/400
2019
1
CICS
2008
1
GIS
2009
1
Sterling
2008
1
XML
2009
1
837
2012
1
BTEQ
2005
1
Business Analysis
2021
1
Data Marts
0
1
Database Upgrades
2013
1
EDI Analyst
2019
1
Erwin Data Modler
2003
1
ETL Developer
2003
1
Extol
2019
1
HIPAA
0
1
HL7
2012
1
IDOC
2014
1
Instructional Design
0
1
iSeries
0
1
Korn Shell
2004
1
Medicare
2006
1
Microsoft Excel
2019
1
mSQL
0
1
MySQL
0
1
node.js
2004
1
Performance Tuning
0
1
RDBMS
2013
1
Rhapsody
2012
1
Scripting
2004
1
Shell Scripts
2004
1
Software Engineer
2012
1
SYNCSORT
2005
1
Technical Support
2014
1
Training
0
1