Charles Okafor

Senior Credit Portfolio Analyst

Renmoney

Mar 2023 - Sep 2024 (1 year 7 months)

• Reduced risk and improved sales by identifying high and low-risk portfolios through predictive analysis.
• Spearheaded collaboration with product owners, ensuring streamlined product optimization through meticulous analysis of key product metrics.
• Automated data reports with SQL and Power BI, leveraging AWS Redshift (PostgreSQL) for efficient data querying and extraction.
• Managed portfolio data by ensuring improved data quality through extracting and transforming relevant portfolio data, while also creating dashboards in Power BI using DAX to enhance data visualization and reporting capabilities.

Business Intelligence Developer

Carbon

Feb 2022 - Jul 2022 (6 months)

• Built and managed data pipelines to deliver data through API on GCP.
• Resolved business data needs by developing pipelines to serve data using SQL on GCP's BigQuery.
• Built, managed, and delivered dashboards to stakeholders on Tableau and Data Studio, utilizing SQL for data extraction and management. Additionally, leveraged Data Studio to create insightful dashboards, enhancing data visualization and reporting capabilities for stakeholders.

Data Scientist

IRI

Jan 2022 - Nov 2022 (11 months)

• Analyzed advertising data and developed reports for clients. • Built marketing mix models to derive insights on marketing and advertising spend in relation to sales. • Ensured proper delivery of clean data and reports to clients by carrying out thorough data wrangling. Additionally, utilized cloud computing to analyze data on the organization’s personalized cloud system, which enhanced the delivery of insights on marketing campaigns through effective marketing mix modeling.

A

Technical Project Lead

AgroVerified

Apr 2021 - Nov 2021 (8 months)

• Recruited developers to successfully build the alpha and beta version of agroverified.com.
• Managed end-to-end project delivery, ensuring an agile approach to the complete product lifecycle.
• Reviewed code and provided insights for bug fixes, enhancing the overall efficiency of the website.
• Utilized AWS to create computer instances that facilitated project management and streamlined development processes.
• Developed both the conceptual and physical data models of the application, ensuring robust data architecture to support project objectives.

Information Security - User Access Analyst

Interswitch Group

Nov 2019 - Feb 2022 (2 years 4 months)

• Extracted and analyzed user access data across all platforms using SQL to review privileges and delivered analytic reports using Tableau and PowerPoint.
• Built and delivered a user access matrix product using Excel and SQL.
• Collaborated with internal control, compliance, and systems admin teams to deliver analytic access reports. Reviewed access companywide to prevent privilege escalation using SQL. Additionally, utilized PostgreSQL for advanced data analysis, enhancing the depth of insights provided to stakeholders and ensuring comprehensive user access management.

Service Operations Analyst

Interswitch Group

Aug 2017 - Nov 2019 (2 years 4 months)

• Managed and analyzed the Payment Card System using Postilion's Postcard system and SQL.
• Extracted and analyzed transaction data using SQL and Excel.
• Configured merchants' details on the database using SSIS ETL packages and stored procedures. Additionally, utilized PostgreSQL to extract, transform, and update the database, delivering comprehensive reports and dashboards to banking clients, which enhanced data visibility and informed decision-making processes.

About

Detail

Timeline

Résumé

Charles Okafor

About

Detail

Behavioral traits