Data Analyst Business Intelligence

Charles Onwuama

Houston, TX *************@*****.*** 713-***-**** LinkedIn: Charles Onwuama

Results-driven Data Analyst BI Developer Business Analyst with 10+ years of experience in healthcare, finance, and technology industries. Expertise in data modeling, ETL processes, and business intelligence reporting to support strategic decision-making. Proficient in SQL (T-SQL, PL/SQL), Python, Alteryx, Tableau, Power BI, and Snowflake, with a deep understanding of data visualization, automation, and database optimization.

Business Intelligence & Analytics: Develop and deploy interactive dashboards (Tableau, Power BI, QuickSight) to provide actionable insights.

Database Management & ETL Pipelines: Design and optimize SQL stored procedures, triggers, and functions for efficient data processing.

Process Automation & Predictive Analytics: Implement data automation, anomaly detection, and predictive modeling to drive business growth.

Cross-Functional Collaboration: Work closely with stakeholders to translate business needs into scalable data solutions that improve operational efficiency and reduce costs.

Data Governance & Quality Assurance: Ensure data integrity, compliance, and governance for accurate reporting and decision-making.

Technical Skills

Business Intelligence & Data Visualization:

Tableau Power BI Amazon QuickSight SSRS Excel (PowerPivot, Power Query) Databases & Data Warehousing:

MS SQL Server Oracle Snowflake Microsoft Azure SQL Database DynamoDB AWS Redshift Programming & Query Languages:

SQL (T-SQL, PL/SQL) NoSQL Python SAS

ETL, Data Integration & Big Data Processing:

SSIS Alteryx SAS Base 9.x Dataedo Erwin Data Modeler Apache Spark Databricks Cloud Platforms & Technologies:

AWS (S3, Lambda, Glue, Redshift, Athena, RDS)

Microsoft Azure (Azure Data Factory, Synapse Analytics, Azure SQL, Logic Apps) Tools & Project Management:

Jira ServiceNow MS Visio

Professional Experience

Amazon – Houston, TX

Data Analyst September 2017 – Present

Project: Enterprise Data Optimization & Reporting Transformation

• Spearheaded data-driven decision-making, improving operational efficiency by 15% and reducing processing time by 20%.

• Designed and optimized 75+ interactive Tableau and QuickSight dashboards, increasing data accessibility by 30%.

• Led migration from Tableau to Amazon QuickSight, standardizing reporting processes and ensuring 100% data accuracy.

• Built SQL stored procedures, triggers, and functions to enhance data integrity and automate reporting workflows.

• Developed predictive models using Python and SQL, leading to a 15% reduction in operational costs.

• Collaborated with cross-functional teams to define business requirements, improving KPI tracking and reporting structures.

• Applied data automation and anomaly detection techniques, reducing manual intervention in reports by 25%.

• Defined and implemented data governance policies, ensuring compliance and improving data reliability across departments.

UTHealth – Houston, TX

Data Analyst May 2015 – September 2017

Project: Data Analytics & Reporting Enhancement

• Automated manual reporting processes, reducing turnaround time by 25%.

• Developed self-service dashboards in Power BI and Tableau, enabling stakeholders to explore key business metrics efficiently.

• Optimized SQL and PL/SQL queries, improving database performance and reducing query execution time by 30%.

• Conducted HIPAA-compliant analytics to ensure secure handling of patient data.

• Enhanced data collection processes, increasing the quality and completeness of electronic health records (EHRs).

• Designed ETL workflows using SSIS and Azure Data Factory, streamlining data extraction, transformation, and loading.

BBVA Compass – Houston, TX

Data Analyst March 2014 – May 2015

Project: Executive Dashboards & Data Visualization

• Designed and developed interactive Tableau dashboards for senior executives, improving data-driven decision-making.

• Implemented SQL automation using triggers, stored procedures, and functions, optimizing database processes.

• Created KPIs and risk indicators, providing insights that enhanced business operations and risk management.

• Spearheaded data validation and quality control initiatives, ensuring 99% data accuracy in financial reporting.

• Conducted data analysis on financial transactions, uncovering operational inefficiencies and cost- saving opportunities.

Education & Certifications

Education

Imo State University – Nigeria

Bachelor of Science (B.Sc.) in Computer Science 2009 – 2013

Contact this candidate