Senior Business Analyst
malomatia
Total years of experience :19 years, 3 months
Acting as a liaison between the software development team and the business team
Collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications and detailed test plans.
Creating process models which can be simulated, analyzed to help the business executives in decision making
Study the current state of the processes. Prepare and model the AS-IS process map and the TO-BE scenario.
Utilizing BPMN methodology to prepare Business Process Flow Diagrams.
Contributes to process improvements and reengineering by presenting alternatives and proposing solutions
Prepare project management documentation for project tracking purposes e.g. project charter, risk mitigation plan, test plans, project plans (MS Project) and keep them updated as changes are observed
Preparing Project Initiation documentation, costing, estimating and planning projects
Preparing proposals for change requests, new projects, integration exercises including business case, user experience brief, timelines and pricing
Prepare reports on the key performance indicators of the product to the client on a regular basis.
Preparing testing scenarios (Scripts), Conducting User Acceptance Test (UAT), maintaining Quality Assurance.
Lead and coordinate with the offshore technical team on project status, execution and deployment and ensure on-time delivery
Participate in writing Request for Proposals RFP, Target Architecture, Gap Analysis and roadmap.
Participate in Data Migration team from old to new system for Ministry of Economy and Commerce.
Providing business consultancy for FlexCube Retail FCR core bank system with full understanding of the back end database for such products like CASA (Current Accounts/Saving Accounts), Deposits (Term Deposit/ Certificates of Deposit), Credits (Loans/Overdrafts/Collections)
Responsible for many Data Migration project and building and using ETL tools SSIS, DTS, and SQL scripts
Providing suggestions on alternate technical solutions to meet client requirements more efficiently
Handling the communication between the bank and the vendor regarding the open issues and fixes
Executing test scenarios and test scripts and making necessary changes in the projects to meet requirements
Interacting with the SME’s and Stakeholders to get a better understanding of client business processes and gather business requirements, and helping in defining business case.
Performing object oriented analysis and design and developed workflow diagrams using MS Visio.
Utilizing UML methodology to prepare Use Case Models, Flow Charts, Activity Diagrams using MS Visio
Documenting and explaining complex business operations to software developers
Assisting junior developers by assigning tasks, monitoring performance, and ensuring quality of deliverables.
Ensure all projects are delivered with good quality, meeting user requirements, on time and within budget.
Writing Deployment Plans, User Guide, Technical Documentations and other reports
Achievements:
Bank Data Warehouse: Project Leader for building and maintain complete Data Warehouse (ETL, Staging, and Data Marts) for Banking and Operations business areas with clear simplified results to business users.
Egabi Reporting System: Project leader for implementing this generic system to automate all bank reports whether required by Central Bank or not, extracting bank data from different sources (Retail, Corporate, Credit Cards) and representing data in unified and business oriented.
E-Service System: Lead development of E-Service intranet framework to serve all bank’s staff to automate many daily business areas
Data Retention Model: Designed complete solution with proper interface to keep the historical data of the DWH against agreed policies.
Reuters Support Application: Lead development of application to support and help the treasury department in their daily work operations; balancing and managing the daily cash flow and liquidity of funds, handling investments, foreign exchange, asset/liability management and cash instruments.
Data Verification Process: Built model to verify the uploaded data in DWH against the source data in old core bank system, giving final status and validate the data before dependent reports generation.
Modbank DWH Data Dictionary: Designed and documented centralized repository of information about DWH database, including data modeling, RDBMS, data types, default values, access rights, brief textual description, integrity constraint and other general database information.
Trade Finance Migration: Designed solution to migrate TF system data and functionalities from old core bank system to third party application. The system covers customer/banks information, customer accounts(Current/Saving/Overdraft), bank accounts (Nostro/Vostro), LGs (Local/ Foreign), LCs (Import/Export), BCs (Import/Export), Cash Cover information for LGs, LCs and BCs, Collateral Time Deposits.
Barclays Africa Reports/Extracts: Designed financial reports such as Average balances, Daily balances, EOM closing position, GL Income Movements, Loans, and TDs.
Developing and maintaining core banking modules (Retail Banking, Loans, Credit Facility, Trade Finance)
Provide full support for the core bank system and implemented solutions and applications.
Analyzing, debugging and proposing solutions for production errors in core banking system Banking Vision.
Handling all databases aspects required for development environment.
Preparing the testing scenarios (Test Script) and conduct User Acceptance Test (UAT).
Gathering and analyzing user requirements and do gapping analysis.
Providing fully technical document for new enhancements and writing deployment plans.
Performing object oriented analysis and design and developed workflow diagrams using MS Visio.
Preparing detailed flow charts and other UML diagrams outlining system capabilities and processes.
Working with user and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines
Providing training sessions to end users of new developed applications and modules
Perform code review of existing architecture looking for performance improvements, and suggestions for future scale-out strategies.
Achievements:
Core Bank System Implementation: Project leader for implementation of core bank system in Kuwait branch, and maintain the consistency with main entity, Conduct all UAT phases, writing all required documentations.
T24 Implementation/Testing Project: Part of implementation team and doing UAT testing for some modules (Cash, Payments, Deposits, Trade Finance, and Treasury), support and management of the Close of Business COB batch and EOD operations.
T24 Migration Project: Part of migration team from legacy core bank system Bank Vision BV to T24
Satellite Systems Integration: Integrate all non-core bank satellite systems with new core banking system T24 through middleware web services application.
VIP Accounts Security: Developed second level of security for VIP customers’ accounts across all modules.
IBAN Implementation: Developed IBAN generation/validation module in all systems which are concerned with payment processing from the core banking, middleware, and front application to the online services.
Signature Verification Tool: Developed tool to extract complicated accounts signatures from old core bank system BV to Oracle DB and built proper interface to enable business users to do the required verifications.
Al-Ansari Exchange Gift Card: Developed module for new product Gift Card in BV core bank system and created new payment channel between the bank and the third party merchant.
E-Statement Implementation: Participated in developing and implementation, the summary of financial transactions which have occurred over a month will be delivered to customers via email.
Developing and maintaining core banking system EasyWay (commercial sector)
Developing and support many systems and web applications.
Handling all databases issues required for development environment including creation of database skeleton and objects (complex queries, procedures, triggers, functions, views and database Design)
Designing and delivering ETL models to transform and consolidate data from several data sources, and do some data manipulation. The ETL developed by SQL Server Scripts, Data Transformation Service DTS and SQL Server Integration Services SSIS
Implementing database migration solutions between various types of database servers
Writing full deployment plans for new systems and enhancements.
Troubleshooting and solving end user problems in a production environment.
Preparing technical documents and test scenarios for new applications and enhancements
Developing ERD, Flowcharts, Activity diagrams and other UML diagrams using Visio and Enterprise Architect.
Implementing reverse engineering for existing legacy systems in order to upgrade them.
Participating in gathering user requirements, systems analysis, and design.
Achievements:
Trade Finance System: Developed from scratch, the system is handling financial transactions involving the Facilities, Letter of Credit LC, Letter of Guarantee LG, Telex Transfer TT and Bills Collection BC.
Al-Istisna Contact System (Contract of Manufacture): Developed from scratch, the system is financing all the materials that customers need for construction works with installments and flexible settlement methods.
Estimated Financial Budget System: Developed from scratch, the system is estimating the cost of some services and expenses comparing this budget with the actual budget by end of the financial year.
Cheques Suppliers System: Participated in developing and implementing, the system is handling the full business process between the bank and suppliers focusing in financial impact and printing cheques.
Single Sign on Modules: Participated in developing some modules of the intranet applications which is serving all bank users and managing business workflow, such as MIGS Merchant Web Application (Maker/Checker), Certified Certificates, and Unified Beneficiary.
Manage SSIS Packages Application: Fully developed tool to monitor the SSIS packages, control over them, giving status, logging the errors and ability to scheduling.
Pull Tandem Data (ETL tool): Built and delivered complete ETL model to transform data from source legacy Tandem database. The model is creating its own database structure dynamically based on source data.
CBK Reporting System: Participated in developing and supporting, this web-based application is collecting data from different data sources to generate all required reports to the Central Bank of Kuwait CBK.
Alaric Core Banking System: Participated in implementing and testing Alaric core banking system (Transaction Switching, and Payment channel integration).
Teaching VB.NET, C#, VB6 and MS Office.
Responsible for developing and maintaining applications that manage all internal company procedures.
Participated with the project manager in all phases during the project life cycle.
Provide technical support for usability issues.
Participated in systems analysis and design.
Achievements:
HR System Upgrade: Upgrade the system to serve all the company’s branches instead of the local branch only and added new features.
Attendance System: Fully designed and developed, the system is managing all aspects of attendance, plus creating all required reports.
International Telephone Calls Logging System: Fully designed and developed, the system is recording all logs of outgoing telephone calls, sending alerts and reports to the concerned managers.
Responsible for developing and maintaining windows applications that manage all internal procedures for employees and the transactions with clients/suppliers.
Achievements:
Suppliers System: Manages all company deals with the suppliers.
Investments System: Deeply handles the business investments of the company.
Pull Investments Data Tool: ETL tool gathering data from legacy systems to SQL DB. The tool developed by Data Transformation Service DTS
Responsible for developing and maintain windows applications as the company’s products.
Responsible for gathering and analyzing requirements
Achievements:
User Complaints Manager System: Recording user complaints, prioritizing them, assigning them to proper departments, sending warnings before due, recommending common solutions and provide required reports.
Customer Service System: Managing the workflow for customer service department and Reception section.
Education Institution System: Handling reception procedures, books stock, timings scheduling, high level financial process, instructors data and customers data.
Pharmacy System - Multiple branches: Handling customer service, treasury and inventory.