Data Analyst

MATTHIAS DIMEJI EKUNDAYO

**** ******* ***** *********** ** L5M 0V8 ● 647-***-****●ac6hxa@r.postjobfree.com

https://www.linkedin.com/in/matthias-dimeji-ekundayo-88a08344/

Time management ● Organized● Problem solver ● Critical thinking● Analytical● Detail oriented

PROFILE

Oracle SQL certified with 7 years of combined international work experience in business analysis and data analysis specializing in the telecommunications, finance and information technology industry

Skilled in Requirements Gathering, Data Analysis, Data mining, Microsoft Excel & Oracle Database

Knowledged in Tableau, Cognos, PowerBI, Procedural Structured Query Language (PL/SQL), Oracle SQL & SQL Server

Efficient use of Microsoft Excel (Pivot, Vlookup) and Crystal Reporting, Application Support

Able to effectively and consistently meet deadlines, flexible to adapt to a dynamic environment and conflict resolution skills

WORK EXPERIENCE

Business Intelligence & Reporting Analyst

TD Bank May 2018 – Present

Developed Interactive Dashboard for the Call Quality of the Make It Personal (MIP) Interactive Scores

Projected the Full Time Equivalence (FTE) for Creekside, Montreal & Edmonton Banking Services (BKS) for F19 using Actuals of F18

Integrated the new Call Quality Dashboard in the current Know Your Business(KYB) Dashboard

Extracted, Transformed & Loaded (ETL) Virtual Worker data for the Innovative Automation (IA) Dashboard

Modified the Call Quality database to conform with the new Call Quality data format

Gathered, extracted, manipulated, analyzed and visualized data using Excel, SQL & Tableau

Ensured data accuracy and created executive and operational reports

Built large-scale team communications

Understood requirements, investigated, and effectively communicated recommendations

Worked effectively with internal stakeholders to identify, escalate and collaborate regarding potential risks

Supported the continued enhancement and evolution of the Operations Team through transparent communication

Incentive Business & Data Analyst

www.gloworld.com Aug.2013 - Dec.2017

Developed Ongoing Revenue Service Commission (ORSC) incentive for Globacom dealers nation-wide

Actualized credit note for Small & Medium size Enterprise (SME) incentive using Crystal Report

Created Glozone credit note using Crystal Report and, Achieved building up Glozone incentive

Extracted, Transformed & Loaded (ETL) data from Enterprise Resource Planning (ERP), Intelligent Network (IN) and Operational Data Store (ODS) systems for computing incentives for Globacom dealers nation-wide

Produced Functional Specification Document (FSD) for new SME and Postpaid incentives

Gathered the requirements (from SalesHQ) of the business rules of new dealer incentives while developing the solution, conducting User Acceptance Test (UAT) and getting subsequent sign-offs

Designed report on the geographical location of where Call Detail Records (CDR) are burnt by mining data from Operational Data Store (ODS) with cell information from Base Station Subsystem (BSS)

Built report that maps CDR to the geographical address of the Base Transceiver Station (BTS

Carried out retrospective analysis and provided recommendations on the performance of Globacom dealers nation-wide

Transmitted incentive data from Dealer Performance System (DPS) to Partner Management System (PMS) aired to the dealers on-line, real-time

Established Eagle Eye report that tells the location of where the serials bought by dealers are being burnt so as to monitor that dealers develop location, sell stock within their vicinity and not encroach in other dealers’ location

Supported Human Resource Management System (HRMS) & Omnidoc Applications

Ensured the Dealer Performance System is fully functional and adheres to the business rules

Management Information Systems (MIS) Specialist

www.jdpcijebuode.org/micro-financecgee Nov. 2012 – Aug.2013

Transferred & analyzed data from the ledgers into the software on the computer systems

Audited transactions recorded on the ledgers and provided report of each branch monthly

I.T Instructor

Cobol Consulting Firm Nov.2010 – Oct.2011

Tutored A+, Oracle SQL and Web Designing

EDUCATION and RESEARCH

Bachelor of Science Degree in Computer Science Babcock University, Nigeria

"Computerization of Hospital Medical Record" Undergraduate Thesis for Degree in Computer Science

Contact this candidate