ANABEL ARBENG AJAGA
Wolverhampton,ENG
Summary
With about four years of experience in data analysis, I excel in working with diverse data sources and transforming complex datasets into actionable insights that support informed decision-making. My strong problem-solving skills, keen attention to detail, and polished presentation abilities have been refined through my work as a data analyst with various clients. I am proficient in statistical analysis, data mining, and visualization techniques, which allow me to uncover valuable insights and identify trends. Additionally, I am skilled in developing predictive models to enhance business strategies and decision-making processes. My extensive experience in data analysis is complemented by a solid educational background. I am adept with statistical and data analytics tools such as Excel, SQL, and Power BI. Specializing in leveraging data insights for business decisions, I am also proficient in Microsoft Office and data manipulation, which enhances my ability to provide valuable analytical solutions. As a dedicated and detail-oriented analyst, I am ready to contribute to the success of dynamic organizations in this multifaceted role.
Overview
5
5
years of professional experience
Work History
Data Analyst
TechDrive Consulting Limited
, UK
01.2023 - Current
- Fetch data from SQL Server, Azure, and other sources, applied ETL skills to structured and unstructured data using power query editor, created data models and visualizations to answer business questions.
- Prepare insightful dashboards and reports from complex datasets to make informed decisions and recommendations to management teams writing DAX functions and using visualization charts in Power BI.
- Integrated ETL of structured and unstructured data into Power Query, cleaned data and applied DAX functions.
- Led 10 data extraction, warehousing, and analytics initiatives that reduced operating costs by 20% and created customized programming options.
- Use DDL and DML queries in SQL Server to write 6 complex scripts that increased the volume and query accuracy automation by 94%.
- Lead 5 data extraction, warehousing, and analytics initiatives to reduce operating costs by 20% and create customized programming options.
- Migrate 3 reports weekly from SQL into Power BI, tested for accuracy and quality before publication.
- Support the capacity building activities of staff by sharing watch me do it videos of BI tools.
- Directed a seamless data migration from on-premises to Azure-cloud platform using a hybrid of Agile and Waterfall methodologies.
- Ensured GDPR compliance and implemented robust data security protocols during migration.
- Managed and aggregated data across multiple systems using SQL on the company’s database, conducting detailed analyses to provide actionable insights for senior management.
- Improved decision-making efficiency by 25% through clear, concise presentations of complex data, enabling stakeholders to swiftly adjust strategies in implementing the data migration.
- Implemented data security measures to protect sensitive information, ensuring compliance with industry regulations during the data migration.
- Tools and Skill: Excel, SQL, Power BI, Presentation, Team Leadership, Performance Management
BI Developer
I-ping solutions
, USA
01.2021 - 01.2023
- Company Overview: Dallas Texas, USA
- Completed tasks such as data acquisition, data processing, data integration, information reporting, automation of manual processes and some business process streamlining, achieving an increase in operational efficiency by 20%.
- Ensured data integrity, data security and accuracy through rigorous data cleaning, validation and transformation processes, enhancing trust in analytical outputs and resulting in a 18% reduction in data-related errors.
- Built and optimized data pipelines, enhancing data processing efficiency by 15%.
- Implemented data quality checks and ensured data integrity, adhering to data governance standards and policies.
- Utilized SQL to design and execute queries on client data within Fusion Intelligence's enterprise software products, improving data retrieval speed by 30%.
- Conducted performance tuning and optimization of SQL queries and data access patterns to improve system efficiency.
- Create DAX Queries to generated computed columns and computed tables in Power BI.
- Involved in creating new stored procedures, optimizing existing queries and stored procedures.
- Used Power BI, Power Pivot to develop data analysis prototype, used Power View and Power Map to visualize reports.
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
- Explored data in a variety of ways and across multiple visualizations using Power BI tool.
- Generated various weekly, monthly, and quarterly sales reports for different business needs using Power BI.
- Responsible for creating complex stored procedures, triggers, tables, views, temp tables, joins, user defined functions.
- Designed Charts with Lines, Bar Graphs and Columns to generate reports with Cumulative Total.
- Create measures to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
- Dallas Texas, USA
Education
Master of Science - Information Technology with specialization in software development
Pan -African Institute For Development (Paid-Wa)
BueaBsc - Sociology and Anthropology/ Economics
University of Buea
CameroonSkills
- Excel
- Pivot Tables
- Power Query
- VBA/Macros
- Data visualization
- Data modeling
- ETL processes
- DAX functions
- Team leadership
- Data cleaning
- Data validation
- SQL;DDL/DML/DQL/DCL/Window functions
- ETL processes
- Power BI
- DAX
- Data Modelling
- Data Migration
- Dashboards
- Data Cleaning
- Data Visualization
- SAP
- PowerPoint
- Word
- SharePoint
- Agile
Languages
English
First Language
French
Upper Intermediate
B2
Timeline
Data Analyst
TechDrive Consulting Limited
01.2023 - Current
BI Developer
I-ping solutions
01.2021 - 01.2023
Master of Science - Information Technology with specialization in software development
Pan -African Institute For Development (Paid-Wa)
Bsc - Sociology and Anthropology/ Economics
University of Buea