Summary
Overview
Work History
Education
Skills
References
Timeline
Barista

Susan Ajere

Richmond,TX

Summary

Highly skilled and detail-oriented Business Intelligence Developer with six years of extensive experience in SQL, Snowflake, Power BI, Azure Data Factory (ADF), Python, and SSRS. Demonstrated success in optimizing data processing efficiency, ensuring data integrity, and orchestrating seamless transitions to Power BI. Eager to leverage expertise in data modeling, ETL processes, and advanced visualization techniques to deliver actionable business insights and drive organizational growth.

Overview

7
7
years of professional experience

Work History

Business Intelligence Developer

QUADAX INC
06.2018 - Current
  • Conducted detailed data analysis to determine data structure, content, and quality, utilizing SQL and Snowflake
  • Led transition from legacy system to Power BI, overseeing assessment, planning, data migration, development, data security and training.
  • Developed complex Power BI dashboards with global filters, KPIs, and advanced analytics features.
  • Implemented dynamic Row-Level Security (RLS) system at both Data Source and Power BI report levels, along with user groups consisting of over 50 clients and 5000plus users, to ensure highest level of data security.
  • Automated ETL processes and tasks utilizing Python and Batch Script on Remote Server to significantly enhance data processing efficiency.
  • Developed robust data processing pipeline utilizing Python to seamlessly store Power BI audit logs within Snowflake Data Warehouse.
  • Spearheaded development and deployment of high-performance big data pipelines using SQL stored procedures, Python, and Azure Data Factory (ADF) to support advanced analytics initiatives.
  • Collaborated with cross-functional teams to iterate on deliverables, ensuring alignment with business needs.

Business Intelligence Developer

MEMBER FIRST MORTGAGE
11.2016 - 06.2018
  • Gathered requirements and created reports and dashboards for various mortgage processes using Power BI and SSRS
  • Significantly improved digital loan default model development, leading to remarkable 10% decrease in non-performing loans and 50% reduction in processing time. Played crucial role in feature engineering and model refinement, enhancing predictive capabilities and operational efficiency.
  • Scheduled ETL packages and SQL Server jobs to automate data processes
  • Designed and established KPIs to monitor performance and drive strategic insights
  • Published reports and dashboards using Power BI, ensuring data accuracy and accessibility for web clients
  • Identified process improvements to enhance efficiency and accuracy of workflows.

Education

Bachelor of Science - Computer Science

University of London
Egham, UK
08.2015

Skills

  • Data and Statistical Analysis
  • Power BI Suite (Power Query, Power Pivot, DAX)
  • Database Management (MS SQL server, MySQL, Snowflake)
  • Programming Language (SQL, Python, R)
  • Data Modeling, Data Analysis and Visualization
  • ETL development (ADF, SSIS, DBT)
  • Data Governance and Security
  • BI tools (Power BI, Tableau, MicroStrategy)
  • JSON mapping

References

Available upon request

Timeline

Business Intelligence Developer

QUADAX INC
06.2018 - Current

Business Intelligence Developer

MEMBER FIRST MORTGAGE
11.2016 - 06.2018

Bachelor of Science - Computer Science

University of London

Similar Profiles

CREATE PROFILE
Susan Ajere