Achievements:
· Improved the efficiency of Order Management system by streamlining operations from 3 systems into 2 – achieved through migrating information from Lotus Notes to Unison using Oracle scripts . This also reduced user errors by 80%.
· Pro-actively identified and immediately resolved long standing integration issues between the Order Management system and the CRM system. This streamlined and updated customer profiles and avoided unnecessary duplication of entries. The correctly updated information avoided delays, errors and re-working of accounts.
· Developed up to the minute reports of the progress in sales volume and revenue for marketing, finance and CRM departments. Using MSSQL scripting tool SSRS - Reporting Services 2005, this enabled management to develop and alter strategies based on most updated information and any unforeseen changes.
· Tested, identified and reported systems issues related to finance reporting
· Provided ‘continuous improvement’ intelligence to management by initiating a process of regular stakeholder interviews. This identified 7 areas for product enhancements as well as ongoing further training requirements.
Main Activities:
· Pro-actively identified data issues by monitoring results of end day staging jobs.
o Analysed and ensured data integrity to avoid user errors between CRM System ,Order Management Systems and Sales Application. This was achieved by creating stored procedures for complex data sets from multiple platforms and database.
· Helped improve user efficiency by responding promptly to system user queries relating to functionality, data flow, and provided technical advice to users . This covered Administration, Bug/Error, Change Request, Data Issues, QA/Train data.
· QA tested development and product enhancements, bug fix versions, and new application software. Verified application logic and reliability of results.
· Provided all 1st and 2nd level application support and resolution management. Liaised with Problem Management and Development teams regarding the progress of problems assigned. Kept customers informed re status of their individual issues/incidents.
· Using SQL reports, continuously monitored support call volumes which helped avoid potential escalation.
· Installed application software for users.
· Efficiently managed user access level maintenance for all Business Systems (CRM, Order Management, Sales ) .
· Generated adhoc reports from Oracle and MSSQL databases.