Business Analyst and Developer
United Group
Total years of experience :18 years, 1 Months
Responsibilities
• Designed, developed and implemented integration process for WMS(Infor) & Mobile sales application with ERP application Orion Enterprise©
• Developing data marts and dimensional views for building cubes for business intelligence tool.
• Developed EDI transaction process using Oracle Stored Procedures and functions, which is utilized for creating orders, invoices and other payment orders, integrated with Orion Enterprise© for WMS application used in our external warehouse locations
• Developed various analytical reports for the sales, procurement & Financial modules.
• Designed, developed and customized oracle forms, oracle reports and discoverer reports as per client requirements
• Sales Order Automation - enable Upload of order details from excel through the automated scheduler.
• Performance tuning on Oracle related objects and Front end application
• Carried out basic DB maintenance activities
• Designed & Developed auto emailing upon specific operation in ERP Application
• Enabled approval of documents through email.
• Configured customized Orion menu screens and setups
• Provided implementation support for integration of WMS with Orion
• Developed a standalone VB.Net Application for the internal Leave approval process.
• Configuring ODBC Data connectivity to Extract data Microsoft Excel and Created Power pivot for huge volume of data
• Involved in building Data marts using dimension modeling.
• Address business requirements and devise technical and functional solutions to resolve queries
• Manage interactions with client and onsite teams
• Allocate work to the team members
• Provide inputs to team members and assist then in work completion and implementation
• Mentor and guide the team for enhanced process efficiency and time-management
• Interacted extensively with customer and onsite implementers to gain comprehensive business knowledge
• Designed and developed the file exchange process utilising ORION Enterprise and NDI (National Data computers Inc. a 3rd party software vendor). This facilitated the creation of accurate and timely forecasts of customer demands and also provided enhanced visibility to real-time, enterprise-wide data throughout the supply chain
• Developed EDI transaction procedures using Oracle Stored Procedures and functions, which was utilised for creating orders, invoices and other pay orders, integrated with Orion Enterprise©, which is largely used by Wal-Mart, Costco and Red Bull
• Designed, developed the Wal-Mart/Costco EDI File exchange process, an undertaking that involves stringent needs evaluation, review and creation of custom exchange processes
• Designed, developed and customised oracle forms, oracle reports and discoverer reports as per client requirements
• Configured customised Orion menu screens and setups
• Simulate and fix bugs in the product within restricted timelines and ensure they meet the SLA (Service Level Agreement)
• Provided implementation support for integration of WMS with Orion
Involved in Development of the below List of application for their In-House utilization having Oracle 9i as Database and Form 6i & Visual Basic 6 as front end respectively.
• Human Resources System
• Consultant Information System
Software Systems (Work Integrated Learning)
Electronics and Communication