I carry diversified integration knowledge by having experience of 12 years in integration space. Worked as SOA Architect, B2B Integration Specialist, ESB designer and implementer. Exposed to different integration tools like webMethods, Dello Boomi, Bots, Mond, MuleSoft.
My Analysis:
I have gone through the source PDF and target EDI structures at high level. I feel there are no complex transformation logic required to be implemented. However I have below few questions specific to the task:
1. Have you already procured SAD login from RRC?
2. shared EDI file do not seems to be valid EDI file as it is missing few mandatory rows. That can be identified by using EDI test site provided by RRC. Prerequisite to test EDI is SAD login!
3. What is the volume of data (in terms of number of records and frequency)
4. Appreciate if you can share Excel file that you use for data entry on website
I can complete this piece of work in 1 - 1.5 days. But system needs to be set up for you to automate this to suit your frequency of reporting. We may have to evaluate if you want to keep self maintenance as an option.
My Plan of action:
Mapping from source field to target EDI field - 5-6 Hrs
Development as per above identification - 3 Hrs
Testing in RRS site to comply to website standard - 1 Hr
Discussion to tailor your automation to run source files regularly.
Thanks,
Naveen P L
9986746476