Sarah
jsrossflorida@yahoo.com
239-222-3974
1075 Featherwood Ct.
Atlantic Beach, FL 32233
EDI Specialist / Business Analyst
33 years experience W2
0
Recommendations
Average rating
184
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
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
Data Analysis
2011
7
SQL
2020
7
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
SAP
2021
3
Easytrieve
1997
2
UNIX
2011
2
XPEDITOR
1997
2
AS/400
2019
1
CICS
2008
1
GIS
2009
1
Microsoft Excel
2021
1
Sterling
2008
1
Warehouse
2005
1
XML
2009
1
837
2012
1
ADT
0
1
Analysis
2021
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
Java
2021
1
Korn Shell
2004
1
Loading
2005
1
Medicare
2006
1
mSQL
0
1
MySQL
0
1
node.js
2004
1
OPTIM
2003
1
Performance Tuning
2005
1
Project Assistant
2019
1
RDBMS
2013
1
Requirements Gathering
0
1
Rhapsody
2012
1
Sage
2019
1
Scripting
2004
1
Shell Scripts
2004
1
Software Engineer
2012
1
SYNCSORT
2005
1
Technical Support
2014
1
Training
0
1