Technical Business Analysis Consultant
Sun Life Financials
Total des années d'expérience :16 years, 4 Mois
• Analyze and interpret data in existing databases to support projects and resolve data issues. Wrote DLF Specs by interpreting SQL procedure transformation rules from source data loads to target tables.
• Map source system data, to data warehouse models (both staging and presentation layer facts/dimensions).
• Identify and assess potential data sources.
• Gather requirements from the business for reports and extracts, and provide functional requirements and technical documentation for the developers and QA testers
• Interviews business users to determine requirements for data, reports, metadata, service levels, data quality, and performance.
• Writing Data Extraction, Load & Transformation Specifications & data mapping documents Including Data Dictionaries
• Perform specifications walkthroughs with the business, developers and QA analysts.
• Develop a deep and comprehensive understanding of our Group Benefits business, systems and customers.
• Create well-written, clear, concise and above all accurate document artifacts including functional specifications, gap analysis documents and mapping documents
Tools : SQL Server (2012, 2016), SSIS, SAS, Cognos Express, JIRA, ReportNet and Teradata SQL, MySQL Workbench 6.2
Responsibilities:
• Lead and assist in the analysis, design, development and implementation of analytical tools mainly Basel Models using SAS.
• Undertaking statistical / mathematical modelling to support risk management using SAS & Paragon.
• Supporting the management of ongoing analytical systems.
• Providing insight and assisting in the development and provision of management information to our stakeholders.
• Developing and maintaining effective relationships with key stakeholders to ensure effective delivery of projects.
Key Achievements
• Performed analysis to produce a two-stage LGD model for RBS Invoice Finance business that will be replacing the existing model. This model has already been approved by the committee and now at the implementation stage.
• Produced and presented an Annual Review pack for Secure and Unsecure Recovery Rate model suite for mid-corporate customers.
• Performed many peer-reviews on work produced by other colleagues.
• Set up an improved Models Help Desk process to deal with stakeholder queries on commercial risk models.
Tools
• SAS Enterprise Guide v4.3, Paragon, Mainframe SAS, SQL and Teradata SQL
Responsibilities:
• Producing validation reports for a variety of scorecards (application, fraud and Basel).
• Communicating model reviews to senior management, group risk, portfolio managers and other stakeholders to give a true picture of scorecard performance.
• Explaining deterioration in quality or performance measures and their impact on business.
• Suggesting actions to keep models fit for purpose.
• Implementing monitoring reports into monitoring system to produce front-end (stability/PSI) and back-end (lift/Gini, Accuracy) monitoring.
Key Achievements
• Presented model validation review for Basel (PD, EAD and LGD) for mortgage models.
• Successfully presented model validation review for current accounts, unsecured loans and application fraud models to senior management.
• Presented a very comprehensive review for one of the most material behavior models to group risk, senior management of portfolio and decision science staff.
• Implemented monitoring for fraud, loan and current account application scorecards.
• Delivered presentations on 'Emotional Intelligence' and 'Building Better Scorecards'.
Tools
Base SAS, SQL and Teradata SQL.
1. Project : Generic Reporting Engine Client: General Motors Europe Project Description: Generic Reporting Engine is client server application written in C#, VB.Net and .NetFrramework 2.0. This Application provides a way of creating Excel Spreadsheets, Word and PDF documents on a server without having either application running. Utilised a combination of XML, XSL and C# to implement an application to read a SQL Server database, and creating reports into Excel Spreadsheets, Word and PDF document for General Motors top management. 2. Project: General Motors CISPAC (Multi country Multi lingualWeb based Customer Survey Reporting System) Project Description: The chief goal is to provide the AD/AR network of Opel/Vauxhall, Saab and Daewoo with web reporting of responses daily as well as monthly and quarterly aggregate reporting. Each day, surveys returned and processed will be posted to the GME CSI site, under the appropriate dealer, a snippet file containing the image of the comment section will accompany the survey when available. 3. Project : Snippet Creator Project Description: Customers feedback Questionnaires include a section where free text can be written. These text section needs to be extracted from the main questionnaire scanned as tiffformat and made available for viewing on the website.Snippet Creator is a .Net application which replaced the existing legacy application. The new .Net application is robust and includes error handling and logging. Below is a summary of the tasks done by the application? • Periodically check for new questionnaires to process. • Create a new file from the free text area (snippet). • Upload the file by FTP to the web servers • Retry logic in the upload. • Logging details of any errors and notify users by email 4. Project : C# .NET based System utilities (i.e. File Format Converter, Import Reviewer ) 5. Writing Ad-hoc SQL queries for Ad-hoc reports and system Debugging.
In Sabbatical Year I graduated with MSc Technology Entrepreneurship from University College London.
Traveled across Europe( France, Spain, Switzerland, Germany, Luxemburg, Belgium, Holland, Denmark, Sweden, Portugal, Cyprus & Turkey), North Africa ( Egypt & Morocco) & North America (USA & Canada).
During my stay at M & S International I worked as Analyst Programmer and served number of clients including TESCO, European Telecom and ABN-AMRO Bank . 1. Project Title: Sonetto (Categorization Management System) Client Name: TESCO PLC, UK Designation: Software Engineer Project Description: I was involved in designing and Implementation of system named SONETTO (Product Categorisation System). Sonetto can be described as a data management tool for companies that wish to manage their products and catalogues of products more dynamically than they can at present. I participated in the analysing of System, Designing & Implementing of Object Model. Creating User Interface, Writing Stored Procedures & Maintaining the Database. 2. Project Title: MIBS (Management Information and Billing System) Client Name: Global Communications Ltd, European Telecom Designation: Programmer Project Description: As a Sr. Software Developer/Analyst, involved in the redesigning and Implementation of package named MI&BS (Management Information & Billing System), which deals with mobile dealers and their different Tariffs. The Software provides all types of informative, analytical and statistical reports to the management for the future decisions. It provides Billing calculation support for the dealers as well and generate all the daily life reports with addition of date-wise, monthly and yearly basis comparative reports such as sales detail & analysis, product sales & analysis. 3. Client Name: ABN AMRO Bank, New York Period: August 2000 to April 2001 Designation: Software Engineer (Team Leader) Project Description: As a Software Engineer, involved in the design an e-Commerce application, Risk Exposure Monitoring System namely TradEx.. This application enables the bank to observe control and manage the risk they have taken on their customer banks and corporation.This system is base on n-Tier architecture that contain following tiers. In this System my jobs & responsibilities were analyzing the system, designing database architecture for system. Designing and Implementing object model and business objects for the system. Identifying and assigning the task to the junior and trainee Programmers. 4. Client Name ABN AMRO Bank New York Designation: Software Engineer. Project Description: As a Software Engineer, was involved in the design an e-Commerce application for correspondent banking name RCS(Reimbursement Claim System). This system supports correspondent banking trade related activities and is currently running in ABN AMRO Bank N.Y and their correspondent bank worldwide. This system is base on n-Tier architectureas follows; 5. Client Name: ABN AMRO Bank, New York & Mashreq Bank, Dubai Designation: Software Engineer Project Description: As a Software Engineer, involved in the development of banking system Name RCL (Reimbursement Claim Letter System Desktop Version), which is designed for ABN AMRO Bank, New York & Mashreq Bank, Dubai who provides correspondent banking services to their correspondent banks. This system is base on 3-Tier architecture.
I served as computer science faculty member for two years.I taught computer science subjects e.g Data structure, Operating System, Computer Networks & Programming Languages to graduate and post graduate students. I was also involved in curriculum design and academic scheduling plans for graduate and postgraduate classes.
• M.Sc Technology Entrepreneurship University College London • PgD in Business Studies London college of Business Studies
• M.Sc (Computer Science) Karachi University Karachi Pakistan