Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ojiaku Ohams

Albany,NY

Summary

BI Developer with 5-6 years of experience facilitating data-driven decisions and leveraging data to promote effective data strategy, data governance, and data management by designing dashboards, ad-hoc reports, and visualizations using Tableau, Power BI, Python, Alteryx, Snowflake, and other Cloud technologies like AWS and Azure. Along with experience working directly with senior management, directors, senior VPs, and other business stakeholders on issues regarding reporting, data-driven decision making, and reporting needs.

Overview

4
4
years of professional experience

Work History

Tableau Developer

Santander Bank US
Westborough, MA
10.2022 - Current
  • Designed clean executive dashboards that provided actionable insights and facilitated decision-making.
  • Served as a Tableau subject-matter expert by providing recommendations and training to senior managers, VPs, directors, and project managers.
  • Lead requirement analysis effort to ensure requirements are specific, measurable, and realistic.
  • Collaborated with data scientists, data owners, and other technical teams to test data models, ensure data quality, promote effective data strategy, and adhere to data governance policies.
  • Combined data from multiple sources using ETL tools, blending, joins, and data models to provide actionable insights.
  • Performed extensive data discovery, data validation, and analyzed data trends to provide and visualize conclusions.
  • Developed wireframes and plans for data analysis and visualization to support business needs.
  • Redesigned complex reports and dashboards from other tools, such as MicroStrategy, QlikSense, PowerPoint, and PowerPivot, into Tableau and Power BI.
  • Participated alongside other team members in building and curating complex databases for the organization.
  • Performed ad-hoc reporting analysis, manipulated complex data using SQL, Alteryx, Excel, Tableau, and Power BI.
  • Created tables, materialized views, stored procedures, and Custom SQL using features like CTEs, temp tables, dynamic SQL, sub-queries, and complex joins.
  • Created design documents, requirement documents, mapping documents, user manuals, and other project documents as needed.

Senior Data Analyst/Tableau Developer

Horizon Blue Cross Blue Shield NJ
Newark, NJ
07.2021 - 07.2022
  • Standardized data collection and extraction process by developing and enforcing ETL processes using Alteryx and SSIS.
  • Migrated reports from Cognos, MicroStrategy, PowerPoint, MS Excel into Tableau and Power BI.
  • Established effective automated ETL processes with Alteryx and Python to replace manual processes.
  • Wrote DAX calculations and LOD calculations for reports in Power BI and Tableau.
  • Utilized Alteryx to publish data to Tableau Server and automate the reporting process.
  • Provided real-time reporting capabilities to help facilitate timely data-driven decisions.
  • Extracted data from multiple databases and data warehouses, and combed data for Tableau reports.
  • Wrote SQL queries using advanced features to validate data in Power BI and Tableau reports.
  • Utilized SQL queries to analyze data, compare files, and build database objects for Tableau reports.

Tableau Developer

Key Bank
Cleveland, OH
09.2020 - 07.2021
  • Developed clean visualizations to convey complicated data in a straightforward fashion to support data-related decision-making.
  • Compiled and analyzed large data to determine data quality, data suitability, and discover patterns in the data.
  • Migrated dashboards and data sources to cloud environments like Snowflake and AWS Athena.
  • Wrote complex SQL queries for data validation and to create database objects to boost performance of Tableau Dashboards.
  • Used dashboard actions and customized charts (Pareto, Waterfall, Sankey, and Sunburst) to create effective dashboards.
  • Designed Alteryx workflows and SSIS packages to help automate Tableau Dashboards.
  • Collaborated with stakeholders to understand business requirements and develop appropriate visualizations.

Education

Bachelor of Science - Business Economics

SUNY At Albany
Albany, NY
05-2017

Skills

  • Client Management
  • Database Management
  • Requirements Analysis
  • Programming Languages: Java, C#, Net, Python
  • Data Modeling
  • Data Validation
  • Dashboard Creation
  • ETL Tools

Timeline

Tableau Developer

Santander Bank US
10.2022 - Current

Senior Data Analyst/Tableau Developer

Horizon Blue Cross Blue Shield NJ
07.2021 - 07.2022

Tableau Developer

Key Bank
09.2020 - 07.2021

Bachelor of Science - Business Economics

SUNY At Albany

Similar Profiles

CREATE PROFILE
Ojiaku Ohams