System Analyst / Senior Application Developer
Nissan Middle East FZE
مجموع سنوات الخبرة :23 years, 6 أشهر
Involve in the in-house development of a new large scale application named PRISM which is used for Spare Parts sales business and is interfaced with SAP Financials and Nissan global ordering system
Efficiently maintaining and supporting a large legacy application called NORRIS used for Vehicles Ordering, Invoicing, Documentation and interfaced with SAP Financials and Nissan global ordering system
Meetings with clients/stakeholders regarding change request raised by them.
Supervise the team members to develop the store procedures, packages, functions, triggers and designed application as per FS.
Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
Query analysis and optimization related to performance issues.
Analyze problems and propose solution to best fit in existing system.
Write automated procedures / functions
Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.
User Training
Data Modelling
Creating audit reports
Software Documentations
Problem Specification / Definition
Program Specification
User acceptance test scripts
Working on Oracle 10g Suit
Working on BRIO
Analyze problems and provide solutions
Developed complex reports
Checking existing reports and makes its performance batter.
Write automated procedures / functions
Data Modelling
Working on Oracle 9i and Developer 6i
Analyze problems and provide solutions
Data Modeling
Software documentation
Problem Specification / Definition
Program Specification
User acceptance test scripts
Working on Oracle 8i and Developer 6i
Analyze Inventory for create Inventory Module
Analyze problems and provide solutions
Data Modeling using Erwin.
Working on Oracle 8i and Developer 6i
Maintain Financial & Inventory applications.
Administrate Database Management Systems.
Analyze problems and provide solutions by application & generating meaningful reports.
Software Implementation at the user end as well as end user training.
Maintaining Hardware and Network
Installing & troubleshooting Operating System
Analyzing, structure design & programming of the projects.
Assisting & checking the subordinates to assure the best performance.
Working on Oracle (7, 8 & 8i) and Developer 2000 (Rel. 2) and Developer 6/6i
Deployment & Implementation of the software at the user end as well as end user training.
Prepared program on oracle (7 & 8) and using Developer 2000 (Rel 1 & 2).