ORC Expert Advisory Services ORC International

  home    |    find an expert    |    request an expert    |    join our network    |    about us     expert login  
Expert Consulting and Expert Witness Services
  
  search tips 
Share this page:  Send to LinkedIn Send to Facebook Tweet This Email Print

 Expert  728002

Expert in Equation Development and Support (AS400/RPG/CL/SQL)


Available for your Consulting and Expert Witness Needs

Pakistan
Education Work History Career Accomplishments Consulting Services Expert Witness Market Research

Summary of Expertise:

Listed with other top experts in: 

Expert has worked in the IT profession for 10 years in designing / implementation with organization including several Banks and software houses. For thelast few years, he has had extensive involvement in Development and Integration of applications with "Equation & Midas" DBA's (related products) of Misys (based on DB2 AS/400 and DB2 UDB family) This has allowed him to attain considerable methodological knowledge for Deploying and Implementation of Applications in the Banking Domain Specialized Skills OS/400, RPG ILE RPG/400, 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

Achievements: 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)

 • 

information technology

 • 

OS/400

 • 

report-generation programming language

 • 

RPG programming language

 • 

RPG/400 programming language

 • 

data conversion

 • 

application software

 • 

relational database management system

Expert has worked for the implementation / designing / Development of Application Software in following business domains 1. Banking 2. Services 3. Pharmaceutical 4. Finance 5. Auto Mobiles

He also has considerable experience in Development using ILE/ CL / RPG / SQL

 • 

application system/400

 • 

AS/400 control language


Show Secondary and Basic Areas of Expertise

Education:
Year   Degree   Subject   Institution  
1999   Programming Diploma   AS400(Administration,Operations, RPG/CL Programming)   Meher Associates PVT Ltd. Karachi, Pakistan  

Work History:
Years   Employer   Department   Title   Responsibilities

2008 to 2009

 

HAI Associates Inc.

 


 

Associate Technical Consultant

 

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.

2008 to 2008

 

Habib Bank limited, Pakistan.

 

IT

 

Assistant Vice President

 

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.

2007 to 2007

 

Standard Chartered Bank. Pakistan

 

IT

 

Assistant Manager EQU Technical Analyst

 

Prime is 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.

2006 to 2007

 

Habib Bank limited, Pakistan.

 

IT

 

System Analyst

 

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.

2005 to 2006

 

D.A.R INFO TECH,Riyadh, Saudia Arab

 

IT

 

IT Consultant

 

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).

2004 to 2004

 

Softronic System (Pvt.) Limited, Pakistan.

 


 

Sr. Programmer Analyst

 

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.

2001 to 2003

 

Union Bank limited, Pakistan.

 

IT

 

Programmer Analyst

 

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.

2000 to 2001

 

Softronic System (Pvt.) Limited, Pakistan.

 

IT

 

RPG Programmer

 

Application Development, maintenance and User's training Client site (AS400) Support.


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.


Consulting Services:
Selected Consulting Examples:
  • 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.
Click the green button above to contact Expert for a free initial screening call regarding your expert consulting needs.  Expert is available for consulting to corporate, legal and government clients.  Remember, your initial screening call to speak with Expert is free.

Expert Witness:
Click the green button above to contact Expert for a free initial screening call regarding expert testimony, litigation consulting and support, forensic services, or any related expert witness services.  A few litigation needs include product liability, personal injury, economic loss, intellectual property (patent, trademark, trade secret, copyright), and insurance matters.  Remember, your initial screening call to speak with Expert is free.

International Experience:
Years   Country / Region   Summary
2008 to 2008   Dubai   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
2008 to 2008   Qatar   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

2007 to 2007   Dubai   He worked on SCB Integration in communication with SCB Indian IT team. Many business visits during 2007
2004 to 2006   Riyadh, Saudi   He worked with DAR Info Tech client The Arab Investment Company S.A.A as IT Consultant
2010 to   Jeddah, Saudi   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


Language Skills:
Foreign Language   Description
English   Business Communications

Market Research:
Considerable methodological knowledge for deployment and implementation of applications in banking, services, pharmaceutical, finance and automobile domains.

Click the green button above to contact Expert for a free initial screening call regarding your marketing research, industry research, and company research needs.  For research needs involving multiple experts or secondary research, a Research Director can be assigned to coordinate the work into a custom report for you as a potentially quicker and more cost effective alternative to doing this work yourself or hiring a boutique consultancy.  Remember, your initial screening call to speak with Expert is free.

Additional Skills and Services:
Training/Seminars

• PMP – 35 credit hour Training for PMP Certification from Sir Syed Engineering University. @HBL 2008 • ITP (Integrated Technical Packages) of Misys Equation by Mr. Philip delos Reyes at HBL e-Learning@SCB 2007 • Money Laundering Prevention • Environmental and Social risk • Operational Risk • Reputation Risk • HIV • Treating Customer(s) fairly @HBL 2006 • Smart Service Workshop & developing winning mind sets

Other Skills and Services

IT system Integration, Business Process Integration (BPI), Mappings for Business Practices and Portfolios, Business Analysis.


 

Need the right expert?  We can help!

home       find an expert       request an expert       join our network       about us

Intota is now ORC Expert Advisory Services

FOLLOW ORC ON