Summary
Skills
Work History
Education
Certification
Overview
CustomerServiceRepresentative
Okunade Abdulhameed

Okunade Abdulhameed

Mississauga,ON

Summary

A motivated and proactive IT professional with 6+ years of expertise in the Healthcare, Banking and Financial domains able to learn unfamiliar material and techniques quickly, exhibit great attention to detail. Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner. A wonderful team player who values collaboration, working efficiently with diverse groups and possess a very strong work ethic.

Skills

  • Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)
  • Databases: Google cloud, MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 52, 57, Oracle 9i, 10g, 11g, DB2
  • Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, Teradata-BTEQ
  • Querying language: SQL, PL/SQL, TSQL
  • Business Intelligence Tools: Tableau 91, 92, 93, 104, 105, 20191, Excel and Power BI
  • Good knowledge of portfolio analysis, management, and customer segmentation
  • Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio)
  • Experience in Data Management, Data Analysis, Data Manipulation for loading enormous amounts of data
  • Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM)
  • Frequent update and exposure to new technologies and new business lines

Work History

Senior Business Intelligence Analyst

TELUS(Contractor)
07.2022 - Current
  • Provided recommendations on reports to operations team that informed critical decision making by senior management
  • Creating Project plans, project schedules and timelines with inputs from project scope, high level requirements and collaborations with business team stakeholders
  • Managing and developing the consolidation of individual project plans into a program level integrated plan and deliver progress reports
  • Helping with the analysis and communications of critical path and periodic risk assessment on the schedule identifying potential risks/opportunities and recommend mitigation strategies/contingency
  • Documenting data migration requirements with multiple stakeholders, technical security services team, Key SMEs from Audit, Legal and HR to document challenges, requirements and help articulate project outcome for delivery following all standard protocols
  • Analyzing and acquiring data from primary and secondary data sources- creating mapping specifications for use by ETL development resources
  • Facilitating the weekly JIRA review meeting to review and update Risks, Issues, PCRs, and Dependencies in JIRA with the Technical Leads and PMs for update
  • Examining data from web traffic, My TELUS app usage, and other sources to provide insights to business performance and customer behavior
  • Evaluating and identifying critical metrics and leading indicators to drive feature adoption, cleaning and consolidating data as required to design, implement, and report on Operations scorecard
  • Developing self-servable dashboards and visualizations to promote automation of information delivery as well as effective and timely reporting practice
  • Using technology and analytics tools to develop models and analyze our data collected from various sources including web and internal channels
  • Using data to tell the story of our operations and find opportunities to improve our practices and enhance our decision-making processes
  • Understanding and translating problems and needs into recommendations and actionable tasks for the team
  • Measure the efficiency of our existing programs through analysis of available data which will include identifying issues, forming hypotheses, and synthesizing conclusions into recommendations
  • Actively seek opportunities to constantly improve our processes and perform scenario-based testing to support your recommendations.

Data Strategist

Scotiabank (Contractor)
06.2021 - 06.2022
  • Assisted the Program Manager in the implementation & delivery of a regulatory project – Bill C-86
  • Delivered insights that informed critical decision making by senior management
  • Developed Power BI visuals used in analyzing customers complaints by predicting and modelling future outcomes
  • Employ Tableau best practices formulating reports, developing SQL queries, and creating advanced Tableau dashboards — improved KPI by 15% within 2 months
  • Defined access control levels for different types of users for publishing reports to Tableau cloud
  • Create Technical / design specification based on business requirements in clear and concise format
  • Implement several DAX functions for various fact calculations for efficient data visualization in Power BI
  • Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management
  • Provide maintenance and development for the existing and new Power BI reports
  • Analyze SQL queries using joins and sub-queries involving multiple tables for validating the data against different kinds of reports
  • Using technology and analytics tools to develop models and analyze our data collected from various sources including web and internal channels
  • Understanding and translating problems and needs into recommendations and actionable tasks for the team
  • Measure the efficiency of our existing programs through analysis of available data which will include identifying issues, forming hypotheses, and synthesizing conclusions into recommendations.

Tableau Developer

American Express (Contractor)
11.2019 - 05.2021
  • Developed Tableau visuals for core engineering team mapping out their portfolios to be used in presentations for senior leadership
  • Developed direct connection between the backend couch base server and Tableau desktop which increased efficiency by 70%
  • Generated Tableau dashboards with data source/ action filters, calculated fields, and parameters on tableau reports
  • Created tableau dashboards with interactive views, trends, and drill downs along with user level security and permissions
  • Created outstanding visualization and scorecards for controls and compliance team mapping banking regulations to internal policies, standards, and processes for senior leadership teams
  • Analyzed data to identify trends and share insights ensuring normalization and consistency
  • Conducted and participated in meetings with the Business owners, Product Owners, and Product sponsors to understand the metrics for any project
  • Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading
  • Maintaining the server to fetch data to different databases while controlling access permissions, security and understanding the existing schema
  • Designing and implementing database in accordance to end users’ information needs and views.

Snr. Data Analyst /Tableau Developer

Cigna Health (Contractor)
07.2016 - 06.2019
  • Recovered $12m by initiating self-directed research to uncover outlier payments in Medicare made to variety of providers including physicians, hospital, and rehabilitation facilities
  • Developed reports to operations team to drive results which increased customer satisfaction by 42%
  • Generated various monthly, bi-yearly, yearly reports by different type of reports using SSRS
  • Pulled data from Tri-Zeto claims systems to create operational reports for applications
  • Created ad hoc queries, stored procedures, and programming scripts with SQL
  • Created Tableau dashboard for displaying monthly inventory analysis
  • Produced member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums data by pulling from data warehouse and generating day-to-day reports in support of the Actuarial Finance department for pricing, catastrophic actuarial analysis and other purposes
  • Used data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their data
  • Supported the company’s healthcare software functions, implementation and training in data governance.

Education

BBA - Business Administration

University of The People
Pasadena, CA

Certification

Certified SAFE 4 Agilist

Certificate in Big Data Analytics

Overview

8
8
years of professional experience
1
1
Certificate
2
2
Languages
Okunade Abdulhameed