Business Intelligence Developer
Pakistan
Implementation of two Data warehousesExperienced in ETL PipelinesOwnership of Data integration layerProduction ownership of Credit scoring model Production ownership of Crop Price prediction modelDaily, Quarterly and Monthly State Bank reportingPower BI and IBM Cognos for Data Analysis Automation of State bank regulatory reportingOracle EBSIFRS 9Requirement gathering sessions with management and business stakeholders.Designing of Information Source Document (ISD) for defining all the finalized fields.Technical Specification Document (TSD) for defining the technical structure.Functional Specification Document (FSD).Designing of Data Pipelines, Parsing and profiling of T24 XML data into RDMS.Designing Star & Snowflake Schemas.Batch/Shell Scripting for file sharing between Linux to windows. Development of dynamic corporate dashboards, data marts, data lakes by integrating the in-house application with T24 core banking & Oracle Financial application.Designing and maintenance of LDM, and SDM structures to support the daily running of the data warehouse. Build and validate data models and analysis layers.Monitoring of ETL jobs and troubleshooting any issues relating to the ETL jobs. Maintain the Metadata and documentation process to support the data warehouse. Creating Ad-Hoc queries and reports as needed along with providing ongoing analytical support for these requests. Data Science credit scoring model that aims to streamline the loan approval and disbursing process for banks. The objective was to predict the probability of default customers using a machine learning algorithm. Secure Loan, Unsecure Loan,Customer ,AA Lending,AA Accounts, TDR,COB REPORTS.Financial Regulatory Reports Analysis & Mapping in T24 BI Insight.T24 integration with other BB channels for Loan payment.