CHISOM CHRISTABEL AMAUBOSI

• I carried out ETL development using Azure Data Factory and SSIS
• I Identified and documented detailed business rules and use cases based on requirements analysis
• I was involved in Training employees on software to improve data management, monitored use and suggested improvements
• Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes
• Developed tables, views and materialized views using SQL
• Developed intelligence-sharing dashboards, providing company-wide access to collected data
• Collected data from wide-ranging sources
• Created data analysis tools to allow teams and Relationship Managers to query acquired information for unique details
• Designed customized data collection models for specific visualization tasks
• Reviewed files, records and other documents to obtain business information and key data informing responses to development requests
• Developed metrics derived from raw company data to track improvements in organizational efficiency
• The budget tracking dashboard
• Researched and compiled tailored monthly analytics and reports for senior management with PowerBI
• Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence
• Responded to specific BI requests from various units in the bank, creating dashboards with requested information in easily understandable formats
• Designed and implemented TSQL queries for reporting and complex solution development
• Developed, implemented and optimized stored procedures and functions using T-SQL
• Maintained complex T-SQL queries, views and stored procedures in multi- database environment with little supervision
• Maintained data delivery pipelines to support consistent and reliable availability
• Managed workload independently but collaborated with colleagues to complete larger-scale tasks in distributed team environment
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements
• Designed and developed customized extract, transform and load (ETL) applications per unit specifications
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and Files.
• Developed tables, views and materialized views using SQL.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Identified and documented detailed business rules and use cases based on requirements analysis.

Fraud Prevention Model .

I led a team that built a rule-based engine for a fraud detection system with a precision of 75% and a response rate of fewer than 220 milliseconds.

Customer Churn Prediction .

I was part of a squad that built a solution that leverages machine learning to identify customers with a high likelihood of going dormant and alerts relationship managers for proactive engagements. This resulted in a 34% increase in the average balances of customers identified within 4 months.

Retail Loan Default Prediction.

I was part of a team that built a solution that leverages machine learning to predict customers who would default on their loans and alerts relationship managers for proactive engagements. This resulted in a 40% (approx.) reduction in loan default rate from 3.12% to 1.99% in 3 months. (December 2019 - March 2020)

Product Recommendation and Cross-selling .

I led a team that built an analytical solution that is used to identify specific needs of customers and their propensity to adopt new products, for improved customer relationships, efficient target marketing, cross-selling and upselling. Which led to 25% of adoption of new products.

· Developed, updated and organized databases to handle customer and student data.

· Created scripts and processes for data integration and maintenance.

· Secured system by granting and revoking privileges