Oracle ERP and e-commerce integration, reconciliation solution

Jang-Vijay Singh - PeerSpot reviewer

Project Description

ERP and e-commerce integration, reconciliation solution for a major healthcare provider in Northern Europe

(sub-contracted by lead Contractor to design, develop, and deliver specific usecases) 

  • Applied the complete software engineering lifecycle (SDLC) for my deliverables
  • Designed and developed fault-resilient, and scalable integration flows on Oracle Integration Cloud(OIC/ICS) iPaaS platform for complex mission-critical use-cases for Supply Chain (SCM Order management), Financials (Invoicing), Pricing, and e-commerce
  • Created a scalable solution for data reconciliation like price and item reconciliation between different systems with large data-sets (multiple data sources & formats)
  • Wrote technical architecture and design documents for parts of the solution and presented these to the customer teams
  • Developed novel and efficient solution for accessing paginated API’s
  • Developed utility services on Oracle Java Cloud Service (JCS) using technologies like Java and Apache POI
  • Developed Oracle Business Intelligence (BI) reports and custom reports for various reporting requirements
  • Created proof of concept for monitoring OIC runtime extracts with Splunk 
  • Identified core product issues, logged enhancement requests, supported Oracle teams with issue resolution
  • Liaised with customer's business analysts for initial requirements clarification, and later during functional testing
  • Supported the new system components during development, business user acceptance testing, and through to production

Highlights

Ahead of schedule
Under budget
Received recognition / award
Support from colleagues
Quality project management
Excellent Oracle tech team

Products Used

Images