Colin Ekedigwe

Data Analyst Intern

Allied Irish Banks•  March 2023 - September 2023•  Dublin, Ireland

Conceptualized, developed, and launched dynamic communication campaigns across multi-channel platforms, including email, SMS, and push notifications, driving targeted customer engagement. Leveraged SQL techniques to identify and segment target customers based on complex business criteria, implementing robust exclusion rules to enhance campaign precision. Spearheaded the creation of 5+ Customer Interaction Management (CIM) campaigns using Teradata, enabling highly personalized and data-driven customer communication. Engineered and optimized 40+ email templates in HTML, seamlessly converting them to JSON format for system integration, while conducting rigorous pre-production testing to ensure full quality compliance for business reviews. Created detailed user guides on Confluence for onboarding purposes, such as Python environment setup and FAQ sections for status codes and campaign builds. Worked collaboratively in an agile environment and performed the role of Scrum Master during team standups. Reviewed reconciliation reports and ensured all governance tasks (e.g., JIRA tracking) were completed.

Part Time

Infosys, EE•  August 2021 - March 2023•  Wexford, Ireland

Resolved 100+ customer queries weekly, including billing issues, account updates, and mobile plan adjustments, ensuring a high first-call resolution rate. Guided customers through troubleshooting steps for network connectivity issues, SIM activation, and device setup, ensuring smooth operation of their mobile services. Enhanced customer retention by addressing billing discrepancies and optimizing mobile service setup processes.