Expert Details
Equation Development Consultant (IBMi/iSeries)
ID: 728002
Pakistan
For thelast few years, he has had extensive involvement in Development and Integration of applications with "Equation & Midas" DBA's (related products) of Misys including Globus/T24 banking system
This has allowed him to attain considerable methodological knowledge for Deploying and Implementing Applications in the Banking Domain
Specialized Skills OS/400, RPG ILE RPG/400, jBase (T24), DDS, DDM, PL/SQL Embedding in RPG, DB2 UDB, DB2/400, CL/400 CL LE, COBOL/400, IDDU, QUERY/400, OS/400(V5R1-R3) (V4R1-R7), IBM's iSeries Model (820,810,270), AS/400 eSeries & PC's
Banking Applications
Misys Products i.e. Equation DBA, Trade Innovation Systems, Midas DBA and Globus/T24
Achievements:
• Gone through a transformation process for Globus/T24
• Involved in Core Banking Implementations at various Banks, including Sharjah Islamic Bank UAE), Masraf Al Rayan (Qatar) and Habib Bank LTD (Pakistan)
Integration b/w Equation of (Misys) eBBS of Standard Chartered Bank
• Technical Consultancy Products/Data Mapping(s), Extract development
• Actively participated for Installation / Upgradation Equation DBA from V3.41 to V3.42
• Installation of the OS/400 V5R1 Operating System iSeries Model 270
IBM's DB2 UDB and Trade Innovation (TI) of Misys
• Transmission of Data elements (Business Info other than Application Defaults) from TI (Windows NT) ? Midas DBA (OS/400) externally using DRDA, DDM facilities.
Distributed Relational Database Architecture, Distributed Database Management
• Database Administration, Definition/Adjustment of DB2 UDB Environment Variables and System Parameter(s) either for DB Storage or Performance
• DB2 UDB as Federate Server or as bridge for amalgamation of Data between iSeries and other Plate form Databases. (Using SQLOLEDB)
DB2 UDB (iSeries) ? DB2 UDB (Windows XP/ 2000) ? SQL Server 2000 (Windows 2000)
• Client n Server Configuration, User(s) Authorization, Instant, Database(s) Creation and Manageability with respect to the Application Architecture
• Normalization and Performance tuning of DB2 UDB (Multi system aspects)
• DB2 UDB Installation on Windows NT environments
• Developed Tools to Merge Databases of Ex-EBI Pakistan with Union Bank Ltd
• Developed Interfaces between Credit Card Systems (CARD PRO, ARKANSAS) and Equation DBA for Cheque, Outward Clearing, Cash payments, Card holder's Auto Debit, Merchant payment System(s)
• Integrated development with Equation DBA (Database DB2) such as Automatic collection of different Charges, Transaction Inquiry(s) access multiple Databases + Locker Management System
• Development Equation API drivers and User exist
Report Archival System
• Archival of MIS generated by MIDAS DBA (Banking System) on PC Server for Spool/Reports
Manageability, resource reduction and Iconic accessibility for Business User(s)
• Presently, Going through a transformation process for Globus/T24 and also associated as an internal resource providing wide range of Technical supervision to SIB’s IT department,
o Specific concentration on Software Project Management, iSeries System Management and Core Banking Products Set-up
o Collection of business specifications, needed Equation related add-on development i.e. User Exits and API covering majority of modules for SIB as well as the Documentation of Technical Details and User Guide preparation for Project Products and Services
o Oversaw Training & Techno Functional Support for Banks IT Team, in-house Systems
o Apart of business as usual undergoing a transformation process
Development of in-house products / procedures and EQU User exits (CMS, ECP)
• Collection of requirements specification
• Designing and timely development
• Technical Details and user guide preparation relating to project product / Services
• Conducting UAT and OAT’s with Banks business user(s) and operations
• Finally handing over developed modules / functions to Banks IT for deployment and future support
Integration Project b/w Misys (Equation) and the Global System developed and used by Standard Chartered Bank eBBS (Electronic Banking System)
• Involved in Business Process Integration (BPI)
• Involved in Mappings for Business Practices and Portfolios
• Communications with eBBS’s Technical / Business Teams
• Development of Extracts using ILE (CLP, RPG, PLSQL,DDS) i.e. main Customers, subsidiary accounts with Static and Financial information held in Equation like Balances, Cheque Req. Issuances, Loan and Deposit Deals, Running Finance, Customer / Account Level Interest Accruals, Customer Limits, Risks
• Business Analysis (Ex -Union Bank Using Equation for 65 Branches) specifically required for catering In-house Products in Line with Core Banking System
• Call Centre and Card Information, method’s of existing Functionality
• Finally responsible as Source for Balancing (Trial Balance, Branch and Currency wise)
• Development for AUTO’s HOME and PERSONAL Loans for surrounding System.
Education
| Year | Degree | Subject | Institution |
|---|---|---|---|
| Year: 1999 | Degree: Programming Diploma | Subject: AS400(Administration,Operations, RPG/CL Programming) | Institution: Meher Associates PVT Ltd. Karachi, Pakistan |
Work History
| Years | Employer | Title | Department |
|---|---|---|---|
| Years: 2012 to 2018 | Employer: Sharjah Islamic Bank (SIB) | Title: Senior Software Engineer | Department: IT |
Responsibilities:Established in 1975 to provide commercial banking services to companies and individuals. Formed under an Amiri decree issued by H. H. Dr. Sultan Bin Mohammed Al Qassimi, Member of the UAE Supreme Council and Ruler of Sharjah, the bank was originally founded as National Bank of Sharjah and became the first bank in the world to effectively convert to Islamic banking in 2002.• Appointed as Sr. System Engineer primary for Equation Development & Support, reporting to SIB Head of Development, to work specifically on an Equation Development & Support projects at SIB in Sharjah, United Arab Emirates • Presently, Going through a transformation process for Globus/T24 and also associated as an internal resource providing wide range of Technical supervision to SIB’s IT department, o Specific concentration on Software Project Management, iSeries System Management and Core Banking Products Set-up o Collection of business specifications, needed Equation related add-on development i.e. User Exits and API covering majority of modules for SIB as well as the Documentation of Technical Details and User Guide preparation for Project Products and Services o Oversaw Training & Techno Functional Support for Banks IT Team, in-house Systems o Apart of business as usual undergoing a transformation process |
|||
| Years | Employer | Title | Department |
| Years: 2010 to 2012 | Employer: BC Direct LLP | Title: Equation Development & Support Consultant | Department: IT |
Responsibilities:BC Direct operates exclusively within the transactional core banking, card and payment systems services arena, working with international banks across EMEA, Nordics, Balkans and CIS region. Services specialisation is focused on both the business process re-engineering and complete project life-cycle implementation services of core vendor technology solutions• Appointed as Equation Development & Support Consultant, reporting to Bank Al Jazira’s Head of IT and Development Division Manager, to work specifically on an Equation Development & Support Consultant project at Bank Al Jazira in Jeddah, Saudi Arabia on behalf of BC Direct • Worked as an external Site Consultant providing a wide range of Technical supervision to Bank Al Jazira’s IT department, with specific concentration on Software Project Management, iSeries System Management and Core Banking Product Set-up • Personally responsible for EQU, Related Development and Training Support, as well as the collection of specification requirements, User Exits and API Development that covered the majority of Equation modules for Bank Al Jazira • Oversaw Training & Techno Functional Support for Banks IT Team, in-house Systems Development & Support relating to specific business needs, and the prompt design and implementation of Development processes • Also responsible for the Documentation of Technical Details and User Guide preparation for Project Products and Services, as well as conducting UATs and OATs with Bank Al Jazira’s business users and operations, and the final hand-over product, modules and functions to their IT department for future deployment and support |
|||
| Years | Employer | Title | Department |
| Years: 2008 to 2009 | Employer: SOFGEN | Title: Associate Technical Consultant | Department: |
Responsibilities:Project: Equation (Misys) Implementation project at Dubai, UAE.Responsibilities: EQU. Reports development. Collection of requirements specification. Designing and timely development. Technical Details and user guide preparation relating to project product / Services. Conduct UAT and OAT’s with Banks business user(s) and operations. Finally handing over developed modules / functions to Banks IT for deployment and future support. Project: Equation (Misys) Implementation project at Doha, Qatar. Responsibilities: Development of in-house products / procedures and EQU User exits (CMS, ECP). Collection of requirements specification. Designing and timely development. Technical Details and user guide preparation relating to project product / Services. Conducting UAT and OAT’s with Banks business user(s) and operations. Finally handing over developed modules / functions to Banks IT for deployment and future support. |
|||
| Years | Employer | Title | Department |
| Years: 2008 to 2008 | Employer: Habib Bank Limited (HBL) | Title: Assistant Vice President | Department: IT |
Responsibilities:Development Team Lead, responsible soundless Banking Operation 24/7.Designing and timely deployment with measures of UAT’s and OAT’s. Equation DBA System support for (Equation Business / Non Business hour processing and Interface systems of Misys). Equation DBA EOD System support, patch(s) installation. |
|||
| Years | Employer | Title | Department |
| Years: 2007 to 2007 | Employer: Habib Bank Limited (HBL) | Title: Assistant Manager EQU Technical Analyst | Department: IT |
Responsibilities:Integration Project b/w Misys (Equation) and the Global System developed and used by Standard Chartered Bank eBBS (Electronic Banking System).Involved in Business Process Integration (BPI). Involved in Mappings for Business Practices and Portfolios. Communications with eBBS’s Technical / Business Teams. Development of Extracts using ILE (CLP, RPG, PLSQL,DDS) i.e. main Customers, subsidiary accounts with Static and Financial information held in Equation like Balances, Cheque Req. Issuances, Loan and Deposit Deals, Running Finance, Customer / Account Level Interest Accruals, Customer Limits, Risks. Business Analysis (Ex -Union Bank Using Equation for 65 Branches) specifically required for catering In-house Products in Line with Core Banking System. Call Centre and Card Information, method’s of existing Functionality. Finally responsible as Source for Balancing (Trial Balance, Branch and Currency wise). Development for AUTO’s HOME and PERSONAL Loans for surrounding System. |
|||
| Years | Employer | Title | Department |
| Years: 2006 to 2007 | Employer: Habib Bank Limited (HBL) | Title: System Analyst | Department: IT |
Responsibilities:Support of Equation DBA Banking Application, Design and Develop Function and methods integrated with Equation (As per Business need).Business Analysis and Application Development. Worked for the Co Ordination EQUATION DBA and Trade Innovation (DB2UDB of Misys). Provide support service to business user's relating Daily Retail Banking concerns. EOD Support. Setup/maintain Equation CST(s) and System Variables. AS400 Client/Server Control System, Configuration and troubleshooting of TI. |
|||
| Years | Employer | Title | Department |
| Years: 2005 to 2006 | Employer: The Arab Investment Company SAA | Title: IT Consultant | Department: IT |
Responsibilities:Principal Support of MIDAS DBA-3 Banking Application and methodical screening of IT functions for accommodation of upcoming Banking needs.Support of day to day Business issues (Midas User). Particularly involve in Dealing, Commercial Lending and Account Services Modules of Midas. MIS Generation as per user specific needs. Support for the Co Ordination issues generated between MDAS and TI Systems (No direct support for Trade Business Users). In context of Co Ordination, working to meet the requirement for Transmission of Data elements externally TI ? Midas (other than the Default Standards). |
|||
| Years | Employer | Title | Department |
| Years: 2004 to 2004 | Employer: Softronic System (Pvt) Limited | Title: Sr. Programmer Analyst | Department: |
Responsibilities:System Analysis and design, Client Site System Management (Assistance to programmers as Team lead), Application Development.Major's Services, Pharmaceutical, Finance and Auto Mobiles Domains. |
|||
| Years | Employer | Title | Department |
| Years: 2001 to 2003 | Employer: Union Bank Limited | Title: Programmer Analyst | Department: IT |
Responsibilities:Support Equation DBA Banking Application, Design and Develop Function and methods integrated with Equation (As per Business need).Provide an ad-hoc support service to business user's relating daily Retail Banking concerns (Core banking and Dealing Business). Carry through testing and diagnose issues, provide solutions in response for Implementation and deployment to Manager, Banking Applications. Review appropriate Security measurers including access control and System rebuild n recovery processes. Setup/Create Equation DBA Units, Install Releases Patches either to Unit or Base System. Setup/maintain Equation CST(s) and System Variables. AS400 Client/Server Control System, Configuration and troubleshooting of TI. Install and configure, AS400 Operating System software plus related tools, DB2 Database. Business Analysis and Application Development as and when required. |
|||
| Years | Employer | Title | Department |
| Years: 2000 to 2001 | Employer: Softronic System (Pvt) Limited | Title: RPG Programmer | Department: IT |
Responsibilities:Application Development, maintenance and User's training Client site (AS400) Support. |
|||
International Experience
| Years | Country / Region | Summary |
|---|---|---|
| Years: 2008 to 2008 | Country / Region: Dubai | Summary: He worked on EQU. Reports development• Collection of requirements specification • Designing and timely development • Technical Details and user guide preparation relating to project product / Services • Conduct UAT and OAT’s with Banks business user(s) and operations • Finally handing over developed modules / functions to Banks IT for deployment and future support |
| Years: 2008 to 2008 | Country / Region: Qatar | Summary: He worked on Equation (Misys) Implementation project at Doha, Qatar. Responsibilities: Development of in-house products / procedures and EQU User exits (CMS, ECP) • Collection of requirements specification • Designing and timely development• Technical Details and user guide preparation relating to project product / Services • Conducting UAT and OAT’s with Banks business user(s) and operations • Finally handing over developed modules / functions to Banks IT for deployment and future support |
| Years: 2007 to 2007 | Country / Region: Dubai | Summary: He worked on SCB Integration in communication with SCB Indian IT team. Many business visits during 2007 |
| Years: 2004 to 2006 | Country / Region: Riyadh, Saudi | Summary: He worked with DAR Info Tech client The Arab Investment Company S.A.A as IT Consultant |
| Years: 2010 to 2012 | Country / Region: Jeddah, Saudi | Summary: Project: Equation (Misys) Development / Support project at Jeddah, Saudi Responsibilities: EQU. Related Development and Support. He is working with Bank Al Jazira with below duties• Collection of requirements specification • Designing and timely development • Technical Details and user guide preparation relating to project product / Services • Conduct UAT and OAT’s with Banks business user(s) and operations • Finally handing over product, modules and/or functions to Banks IT for deployment and future support |
| Years: 2012 to Present | Country / Region: Sharjah, UAE | Summary: Working as Senior Software Engineer (internal resource) |
Career Accomplishments
| Licenses / Certifications |
|---|
| Pursuing for PMP Certification |
| Professional Appointments |
|---|
| Equation Development and Support Consultant, Associate Technical Consultant, Assistant Vice President, Assistant Manager EQU Technical Analyst, System Analyst, IT Consultant, Sr. Analyst, Programmer Analyst. |
Additional Experience
| Training / Seminars |
|---|
| • PMP – 35 credit hour Training for PMP Certification from Sir Syed Engineering University. • ITP (Integrated Technical Packages) of Misys Equation by Expert. Philip delos Reyes • Money Laundering Prevention • Environmental and Social risk • Operational Risk • Reputation Risk • HIV • Treating Customer(s) fairly • Smart Service Workshop & developing winning mind sets |
| Marketing Experience |
|---|
| Considerable methodological knowledge for deployment and implementation of applications in banking, services, pharmaceutical, finance and automobile domains. |
| Other Relevant Experience |
|---|
| IT system Integration, Business Process Integration (BPI), Mappings for Business Practices and Portfolios, Business Analysis. |
Language Skills
| Language | Proficiency |
|---|---|
| English | Business Communications |
Fields of Expertise
information technology, OS/400, report-generation programming language, RPG programming language, RPG/400 programming language, data conversion, application software, relational database management system, application system/400, accounting technology, data management, RPG/3 programming language, project management, database