Data Warehouse Team Leader
Hyundai Information Technology Co. Ltd. Korea
مجموع سنوات الخبرة :32 years, 4 أشهر
Presentation Made:
• Delivered the Data Warehouse Presentation, on behalf of the Consortium lead by Hyundai IT to the Management of Bangladesh Bank (the Central Bank of Bangladesh), Dhaka on 9th & 10th of August 2004, the Project being Funded by WB - The World Bank. The Consortium comprised Eight (8) Multinational Company, from Korea, Singapore, India & Malaysia). Each Partner give the Presentation pertaining to their Expertise
• Delivered the Data Warehouse Presentation to the Management of the Central Bank of Syria on 30th of June 2005
Managing the Data Acquisition Gateway (DAG), All the Banks & DFI’s submit frequency wise data through DAG to State Bank of Pakistan, after receiving the Data to DAG Server, Extract Transform & Loading (ETL) to Analysis Server (Cube define) and then providing Analysis access to users through Cube (Using MS OLAP).
Wrote System Requirement Study and System Detail Design documents
Interacting with End Users and Decision Makers for their OLAP Analysis Requirements.
Performed BPR and Rationalization.
Designing Universes/Data Marts Using Business Objects, Erwin and Oracle Warehouse Builder9i.
Writing Data Cleansing and ETL Scripts Using PL/SQL Developer and Oracle warehouse builder.
Data Loading in Oracle Database Using SQL Loader and ODBC
Use Microsoft DTS to extract/ Loading data
Involved in Technical Meta Data definition and deployment.
Developed and published OLAP &ROLAP Application, Cubes using, Business Objects Report Designer, MS OLAP, and Oracle Discoverer.
Oracle 9i Database Administration General work.
User Training and User Manual Preparation.
Wrote System Requirement Specification and System Design Documents for above-mentioned Banking Areas. Design the Dimensional and ER Models.
Performed the Data Cleansing. Wrote ETL Scripts using Oracle Warehouse Builder and PL/ SQL for the Data Marts.
Was also involved in OLAP Cube Building and Developed the Analytical Framework using MS OLAP
Accomplishments:
Customization of Pak Model Bank
Unit Testing, SIT, UAT Support.
Successful Data Migration, Successful Go-Live
Successful done Year closing
Responsibilities:
Implementation of Trade Finance (TF) Module
Parameterized setting of Trade Finance module
Performed functional testing after installation of TF module
Supervised and conducted User Acceptance Testing-UAT
as functional consultant and fixed UAT issues
Developed technical documentation to resolve technical issues
Performed Data Migration from PIBAS toT24
Developed MIS Reports and Deal Slips of Trade Finance Module
Performing post implementation support
Data Migration from Core Banking PIBAS to T24
Implementation of Delivery SWIFT Module
Setup and parameterization of Swift Module
Prepared setup document for business users to generate
the MT940 and MT950 (Statement of Account) for outgoing modules
Assist to Business users to parameterization
Implementation of Local Developed ALERTS System
Developed and Implemented ALERTS module, through SMS and eMail.
Implementation of NIB Solution
Customization done on T24 Charge mechanism,
as per deposits Customers are tagged as GOLD,
SILVER etc, through parameter defined for GOLD
10 Pay Order free per month, through this customization
customer will enjoy 10 free PO every month and if
customer makes more then 10 POs then have to pay
as defined charges. Same solution implemented on
every Charge transaction.
Worked as Manager Software Development. I worked as a team leader of 25+ Analyst & Programmers. And under my supervision 45+ Application Software Systems/ Modules were developed. These Modules Covered the Twentyseven (27) Sections and Four (4) Department of the Banking Zone, the State Bank of Pakistan.
The Core Banking Systems for the Central Bank, was Developed in Informix 7.2, O.S. SCO Unix Open Server R 5
Team Management, Project Supervision, System Analysis, Design and Implementation were Key Responsibilities.
Also I Created 3-Tier Architecture using Form & Report Server and Developed database applications in Oracle 8.x & Oracle Developer 2000
My key responsibilities here were to System Study, Design, Development and Implementation (Accounting, Share Accounting, Inventory Control, Hotel Management, Dental Clinic, Travel Agencies database applications in RDBMS.