DENNIS JOHN, Software Analyst

DENNIS JOHN

Software Analyst

Burgan Bank

Location
Kuwait - Al Kuwait
Education
Diploma, Database administration
Experience
22 years, 3 Months

Share My Profile

Block User


Work Experience

Total years of experience :22 years, 3 Months

Software Analyst at Burgan Bank
  • Kuwait - Al Kuwait
  • My current job since August 2021

Burgan Bank is the one of the leading bank in Kuwait. I have been working here with middle ware integration team and the key responsibilities are in integrating the different end user system with the Core Banking system.

Application System Specialist at Public Authority of Manpower
  • Kuwait - Al Kuwait
  • September 2016 to August 2021

Public Authority for Manpower is a body under the ministry of Kuwait handling the private employments and private company sector. Here I appointed to migration and enhancement project of the existing system. My main responsibility here is to model the business process by studying the existing system as well as with user interaction. In addition to this, I will have to validate the system study done from some of the vendors who are a responsible different part of the project. It is a very big project and lasts up to 4 years with around 20 employees.

System Analyst for sw migration at Burgan Bank Kuwait
  • Kuwait - Al Kuwait
  • February 2016 to August 2016

Burgan is leading bank in Kuwait with many advanced technologies in place. I worked here as BO requirement analysts and system developer during the core banking system migration.

Oracle Developer and Business Analyst at Kuwait Application Service Providers
  • Kuwait - Al Kuwait
  • March 2008 to February 2016

KASP is the IT division of Boodai Group of Companies. Boodai is having a different type of business in the Middle East. The main areas of business are airways, aviation (Ticketing), Trading, Workshop of major equipment, Sale of major equipments, Transportation, Real estate, Port Operations Etc… KASP is handling the IT requirements of all the business in Boodai.

The following are the major projects done with KASP.
My major role was database administration and implementing the functionalities with stored procedures.
• Management Information System Automation (Ahli Bank of Kuwait)
(End-to-End Implementation)
1. Extraction, Transformation and Loading
2. Data warehousing
3. Installation and maintenance of BO 4.1
4. Report development Using BO 4.1
5. Migration of existing financial and CBK reporting reports to BO 4.1s
• Material Management system for AUB Bank( Integrated with Gargantua workflow system)
(End-to-End Implementation)
1. Workflow systems (EDMS)
2. Material Management system
3. Fixed assets
4. Annual Budget Automation
5. Report development using BO 3.1
• HRMS for Boodai Group of companies with reporting (SAP BO)
(SAP BO 3.1 report development)
6. Designing the universe to generate time and attendance and payroll reports
7. Incentive, Overtime reports
8. Salary and indemnity reports
9. Leave Processing reports Etc…
• Fleet Management System for CITY BUS with reporting (SAP BO)
(ETL-DW and report development)
1. Emergency and Wayfarer ticket tracking and data warehousing
2. Different revenue reports and performance reports
• Bonded Warehouse system for Customs ( Jassim Transport Company)
1. Warehouse Management - inventory system
2. Item movement and yard management reports
3. Cost and Revenue reports
• Container and Stevedoring system for Jassim Transport Company
1. Container movement - Port operations
• Workshop Management system for Boodai Trading Company (SAP BO)
1. Call management system along with inventory system
• Data Warehousing project for Boubyan Bank with reporting (SAP BO)
Developed an ETL for data warehousing for Sybase database
• Treasury Management system for Boodai Group of Companies
Development of treasury reports

Oracle Developer and Business Analyst at Kuwait Application Service Providers
  • Kuwait - Al Kuwait
  • March 2008 to February 2016

KASP is the IT division of Boodai Group of Companies. Boodai is having a different type of business in the Middle East. The main areas of business are airways, aviation (Ticketing), Trading, Workshop of major equipment, Sale of major equipments, Transportation, Real estate, Port Operations Etc… KASP is handling the IT requirements of all the business in Boodai.

The following are the major projects done with KASP.
My major role was database administration and implementing the functionalities with stored procedures.
• Management Information System Automation (Ahli Bank of Kuwait)
(End-to-End Implementation)
1. Extraction, Transformation and Loading
2. Data warehousing
3. Installation and maintenance of BO 4.1
4. Report development Using BO 4.1
5. Migration of existing financial and CBK reporting reports to BO 4.1s
• Material Management system for AUB Bank( Integrated with Gargantua workflow system)
(End-to-End Implementation)
1. Workflow systems (EDMS)
2. Material Management system
3. Fixed assets
4. Annual Budget Automation
5. Report development using BO 3.1
• HRMS for Boodai Group of companies with reporting (SAP BO)
(SAP BO 3.1 report development)
6. Designing the universe to generate time and attendance and payroll reports
7. Incentive, Overtime reports
8. Salary and indemnity reports
9. Leave Processing reports Etc…
• Fleet Management System for CITY BUS with reporting (SAP BO)
(ETL-DW and report development)
1. Emergency and Wayfarer ticket tracking and data warehousing
2. Different revenue reports and performance reports
• Bonded Warehouse system for Customs ( Jassim Transport Company)
1. Warehouse Management - inventory system
2. Item movement and yard management reports
3. Cost and Revenue reports
• Container and Stevedoring system for Jassim Transport Company
1. Container movement - Port operations
• Workshop Management system for Boodai Trading Company (SAP BO)
1. Call management system along with inventory system
• Data Warehousing project for Boubyan Bank with reporting (SAP BO)
Developed an ETL for data warehousing for Sybase database
• Treasury Management system for Boodai Group of Companies
Development of treasury reports

Software Developer at Kuwait 2000 Company
  • Kuwait - Al Kuwait
  • January 2007 to February 2008

Worked as Oracle DBA, Forms Developer and Reports Developer

Kuwait 2000 Company is providing fully-customized software for hospitals and Clinics. We have currently had 12 clients. We computerized these hospitals and we got satisfactory certificates from the clients. Our clients include Taiba Hospital, Alorf Mansour hospital, and Al Safat American medical centre, Bayan Dental Clinics … Our product different modules GL, AP, AR, OPD, IPD, Appointment Scheduling, X-Ray and Laboratory, Pharmacy, Medical records etc… I am having a good experience with these hospital-related modules, which are also developed in Oracle 6i/10g and Oracle DB

Oracle DBA Trainer at Pinnacle Innovative Technologies P (Ltd.)
  • India - Chennai
  • October 2004 to November 2006

 Database Administrator: Worked as a Database Administrator for the Developing wing of the PIT. Creating and managing databases with respect to the needs of the application for the developing wing. And also creating and implementing Database at the client-side. Tuning the Database related issues from the client-side. Tuning of storage structures, processes, memory etc… are needed depending upon the problems found at the client-side.
 OCP Trainer: PIT is an Oracle Certified Partner. I worked as a trainer for Oracle Certification professionals. Given training for creating, managing, tuning etc… as coming under the syllabus of OCP certification path.

VB Developer at Netware Solutions Calicut
  • India - Chennai
  • January 2002 to September 2004

Information Technology: Worked as s Programmer and DBA at Netware Solutions, Calicut. Netware Solutions Concentrated on computerizing educational institutions, Hospitals, Medical Shops, Textiles, Hotels etc… The Applications are developed in Forms Developer 6i and database was Oracle 9i

Education

Diploma, Database administration
  • at Oracle University
  • January 2004

(Oracle 9i DBA) Oracle Certified Associate from Oracle University. The two modules coming under OCA completed successfully. Those are Introduction to SQL, Database Fundamentals-I.

Higher diploma, Oracle DBA
  • at Oracle University
  • January 2004

- (Oracle 9i DBA) Oracle Certified Professional from Oracle University. The four modules coming under OCP completed successfully

Higher diploma, Computer Science
  • at DOEACC- Govt. of India, under AICTE - DIT
  • January 2002
Diploma, Computer Science
  • at DOEACC- Govt. of India, under AICTE - DIT
  • January 2002
Bachelor's degree, Computer Science
  • at Chaudhary Charan Singh University, Meerut
  • March 2001

Specialties & Skills

Oracle database/PLSQL
Oracle forms and reports
System Analysis
ETL tools
Business Objects report 4.1
SW developemt

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

English
Expert

Training and Certifications

Oracle Certified Professional 9i (Training)
Training Institute:
Oracle University
Oracle Certified Associate 9i (Certificate)