Mary Chideme

Mary Chideme

$40/hr
Data Analyst /PowerBI/Azure Engineer/AI Engineer
Reply rate:
-
Availability:
Full-time (40 hrs/wk)
Age:
27 years old
Location:
Randburg, Gauteng, South Africa
Experience:
4 years
CURRICULUM VITAE Candidates Personal Details Surname: Mary Name: Chideme Title: Miss Date of Birth 16/05/1997 - Matric Certificate, Diploma or Degree obtained: • • • Power BI Dashboard Design Tableau BI Dashboard Design • • Azure Data Lake Storage • • • Main SAP skill: Microsoft Azure Data Engineer Certification Microsoft Azure Power BI Certification Microsoft Azure AI Certification (Results still pending) • • • • • • Data Modelling and ETL design Azure Data Factory V2 Designing and developing data marts using SQL Azure Databricks and Azure Function Apps& Logic Apps Azure Resource Manager skills (Terraform, Azure Portal, Az CLI and Az PowerShell) Working on Delta Loads for Transactional Data and Loading of Master Data Testing- Doing user acceptance tests and system unit tests. Training- Preparing user manuals and conducting classroom trainings Working on Delta Loads for Transactional Data and Loading of Master Data Testing- Doing user acceptance tests and system unit tests. Administration- Installing and administering the SAP BOBJ platform • Universe and Report Development- all reports are being developed using Web Intelligence and dashboards designer. Years of experience: 5 years Availability: 2 weeks’ Notice period Which client do you currently work for? Access Forex Home Address 100 Bellaire Drive Norhang Northriding Gauteng Contact Details: SA Cell: - Email:-Email:-Relevant Work Experience Employer Access Forex Client name Access Forex Industry Finance Location JHB Duration Oct2024 - Current Role Data Engineer and Power BI developer Responsibilities Data Analysis and Reporting - Enhance the performance and user experience of Power BI reports and dashboards. - Migrate operation reports in Access Forex system to Power BI dashboards - Build Financial Statement report/ Financial Position Dashboard - Write complex Dax formulas to Drive complex business requirements at reporting level - Collaborate with stakeholders to gather and analyse business requirements for designing efficient data models. - Troubleshoot, resolve, and provide technical support for Power BI-related issues. - Create and maintain comprehensive documentation for data models, reports, and dashboard. - - Developing and maintaining Business Intelligence solutions using Microsoft BI stack (SSRS, SSIS) - - Database design and Development including Tables, Primary and Foreign Keys, Indexes and stored Procedures. - - Maintained a series of Unix shell Scripts to manage batch order processing - -Integrate sales data for sales performance analysis, including revenue trends, product sales customer segmentation. - - Developing Reporting QA/UAT Test Plan, Test scripts Employer Client name ABIS Consulting Ram South Africa Industry Delivery Location JHB Duration Role Jun 2022 – Sep 2024 Power BI Developer and Data Analyst (Apprenticeship) Responsibilities Data Analysis and Reporting - Collaborate with stakeholders to gather and analyse business requirements for designing efficient data models. - Using knowledge of Kimball data modelling, such as star schema, snowflake, etc - Develop, publish, and schedule Power BI reports and dashboards aligned with business needs. - Azure Resource Manager skills (Terraform, Azure Portal, Az CLI and Az PowerShell) - Implementing and understanding of software development practices, such as SOLID principals, structuring code, testing, IOC, etc - Design, develop, and implement interactive Power BI dashboards and reports. Collaborate with stakeholders to identify reporting needs and ensure data accuracy, reliability, and effectiveness. Conduct data analysis and interpret trends, patterns, and insights using Power BI. Maintain and optimize data models, ensuring high performance and efficient querying. Integrate Power BI with various data sources (e.g., SQL databases, cloud services) to consolidate data for reporting. Apply data visualization best practices to produce clear, compelling, and user-friendly reports. Troubleshoot, resolve, and provide technical support for Power BI-related issues. Stay updated on Power BI updates, features, and best practices to enhance reporting capabilities. Create and maintain comprehensive documentation for data models, reports, and dashboards. Data Integration: - Connect Power BI reports to diverse data sources, such as SQL Server, Excel, and cloud platforms. - Utilize Power Query and DAX to implement data integration and transformation workflows. Collaboration and Support: - Partner with business users to gather insights and ensure the effective utilization of Power BI reports and dashboards. - Create data integrations using different data latency methodologies, e.g., real-time and periodic. - Perform transformations to conform the data with expected schema required by downstream operational systems. - Develop a toolset to monitor the health of data integrations, including near real-time alerting of failures, data volume metrics, resource consumption metrics, etc. - Integrate into the data team’s SCRUM ceremonies, including backlog refinement, sprint planning, demonstrations, and retrospectives, including translation of user requirements into technical requirements including complexity estimation, implement in two-week sprint cycles, collaboration into process improvement, etc. - Provide training and ongoing support to business users on Power BI functionalities and best practices. - Coordinate with IT and data teams to ensure adherence to data governance and security protocols. Performance and Optimization: - Enhance the performance and user experience of Power BI reports and dashboards. Monitor and address issues related to data refresh schedules and performance optimization. Document datasets in data catalogue, including ownership, stewardship, dictionaries, glossaries, lineage, sensitivity, etc. Employer ABIS Training & Consulting Client name Industry Location Duration Role Inhouse Projects Consultancy JHB Jan 2021- May 2020 Junior Power Bi Developer (internship) Responsibilities: - Transform data into actionable insights Develop, publish, and schedule Power BI reports and dashboards aligned with business needs. Build POC for business development solutions Build SQL stored procedures to optimise data loads and Query data uploads Develop in Power BI (desktop, service, and mobile), including Power Query and DAX Analys data with the ability to interpret data and deliver actionable insights Families data modelling concepts and data warehousing solutions Develop & enhance: Create and refine Power BI dashboards and reports that meet our business needs. Collaborate: Work with various teams to understand their data requirements, translate them into technical solutions, and deliver valuable insights. Model & process: Design and manage data models and ETL processes to ensure data integrity. Analyse: Explore data, identify trends, and provide actionable recommendations for decision-making. Optimize: Improve performance of Power BI reports and data models and troubleshoot issues. Stay current: Keep up with the latest trends in business intelligence and data visualization. REFERENCES: ➢ Michel Machakata COJ SAP MM Consultant Email:-Contact - ➢ Emanuel Mawere Project Manager Ram South Africa Email:-Contact: - ➢ Brian George Power BI Developer PPC Email:-Contact: - Summary of Skills Current skill level based on the Skill Levels table below. Skill Levels 1 = Junior (6months experience), 2 = Experienced (need supervision from time to time, can deliver at an acceptable quality), 3 = Well experienced (senior, completed a few projects at a sufficient level of this skill), 4 = Experienced (team leader, post senior), 5 = Expert (competent leader, teacher, specialist) Category Business Warehousing Data Modelling MY SQL Power BI Snowflake 1 2 ✓ ✓ ✓ ✓ ✓ ✓ Tableau dashboards Azure Data Engineer Data Fabrics ✓ 3 4 5 Years of experience 3 Years 3 Years 3 Years 4 Years 1 Years 2 Years 2 Years 2 Years Relevant qualifications Certification Certification Certification Certification Certification pending Open Sap course Certification pending Certification pending
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.