Olasunkanmi Angela

ABISOLA ANGELA OLASUNKANMI BI ANALYST | DATA ANALYST Nigeria. - - https://public.tableau.com/app/profile/olasunkanmi.angela/vizzes SKILLS Programming Language: SQL Data Visualization: Tableau, Power BI, MS Excel Other Tools: MS PowerPoint, QuickBooks, Zoho, Data Analysis Tools: Pivot Tables, Office 365, MS Excel Soft Skills: Teamwork, Problem-solving, Communication, Quick Learning, Critical thinking, Organizational skills, Report Writing, Research, and Analytical skills. WORK EXPERIENCE Aug 2013 – Present Sep 2023 Sep 2023 Soldier Nigerian Army • Create reports, and communicate insights to appropriate superior authority • Executive Assistant with sole responsibilities of handling routine clerical tasks, scheduling appointments, coordinating calendar, ensured sensitive and classified information are discreetly handled • Drafting and formatting official letters, memos and reports • Data entry of personnel records • Organizing military events, official meetings and training programs • Ensured high accuracy and quick retrieval of information which reduced administrative workload by 75% which thus led to high productivity amongst troops Data Analyst Intern PwC Virtual Internship (Forage) • Create comprehensive dashboards to facilitate trends such as peak call times, common customer issues, and agent performance • Analyse the data and uncover the reasons behind customer churn and provided insights to address this underlying issue and created dashboard with customer insights and trends which is used as a roadmap for making improvement • Used Power BI to provide a comprehensive analysis of the company's current gender demographics at the executive level, offering insights for improving and strategies for a more balanced representation Data Analyst Intern Accenture Virtual Internship (Forage) • Data cleaning by removing irrelevant columns, change the data types before loading into the power query for transformation • data modelling by merging the relevant tables using the power query editor • Data visualization by analysing the top 5 categories, unique categories, total score by content, monthly score and sentiment analysis PERSONNAL PROJECTS Title: Payroll analysis Title: Call center performance Performed a payroll analysis to gain clarity on how payroll analysis provides deep insights into employee compensation and workforce trends. Data was generated by ChatGPT, prepared, process with Excel and the analysis was carried out with SQL. Performed a Call center analysis to gain clarity on customer service operations over a year period which is a good measure of customer satisfaction, trends and agents’ performance with services rendered over the specific period. Data was prepared, processed and the analysis was carried out with Excel while visualization was done with Tableau ChatGPT MS excel SQL Tableau Excel EDUCATION 2016 – 2020 Bachelor of Science, Economics University of Calabar Transcripts CERTIFICATION 2019 • Associate Accounting Technician West Africa ATSWA - ICAN 2023 • Associate Data Analyst DataCamp