Data Analyst Power Bi

Edwin Nkengafac

Waukee, Iowa 469-***-**** *****.*****@*****.*** linkedin.com/in/edwin-nkengafac

Driven and curious data analyst with experience working with, SQL, R, Excel, Tableau, Power BI and several programming languages. With a passion for creative innovation and complex problems, I am eager to further implement my skills and improve my data analysis experience with a detail-driven data team. Excellent understanding of business operations and analytics tools for effective analyses of data.

PROFESSIONAL SUMMARY

•Utilized MS SQL, Business Intelligence (BI), Data Warehouse, Data Analytics, tableau and other dashboards/visualization toolsets for data intelligence and analysis.

•Proven ability to identify business needs and develop valuable solutions to advice accuracy and process efficiency.

•Experienced in developing, Implementing, documenting, monitoring and maintaining the data warehouse extracts, transformations and ETL process in various industries like Financial, Health Care, Government and Airline Industry.

•Delivered BI reporting solutions in Power BI, Reporting Services (SSRS).

•Experience across entire Microsoft Bi suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.

•Worked on small- and large-scale projects. Believe in team work. Have delivered as a team member, team lead and as independent consultant.

•Excellent communication and leadership skills.

Professional Experience with Microsoft Skills:

•Microsoft Power BI Desktop Troubleshooting

•Data visualization and modeling Data query language: SQL, DAX

•Data warehousing and analytics ETL (SSIS, SSRS, SSAS)

•CI/CD principles Eye for detail

•Microsoft Excel (Advanced: VBA, Macros, Pivot) Critical thinking

•Communications skills Teamwork skills

•Problem-solving skills

CERTIFICATIONS

•Microsoft Certified Data Analyst Associate [DA-300] (Analyzing and Visualizing Data with Power BI)

•Scrum Master

EMPLOYMENT HISTORY

Business Intelligence Analyst

JBS/SWIFT Company April 2019-May 2024

•Oversaw data collection and consolidation for reporting.

•Designed and built dashboards used to monitor performance metrics.

•Utilized: advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards.

•Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in power Bi to validated static and dynamic data for data validation.

•Communicated effectively across multiple platforms and departments by performing various QA tasks and evaluating workflow.

•Aligned with Agile Methodologies, scrum stories, and sprints in a Python-based environment in association with data analytics and Excel data extracts.

•Running different tasks and operations using company safetychain and excel analysis to derive operations for company growth and reduce discrepancies and minimize lost.

DATA Analyst

Ajinomoto May 2016-April 2019

•Successfully interpreted data in order to draw conclusions for managerial action and strategy.

•Partnered directly with the executives team as the first data hire to formulate and reports on KPIs

•Used statistical techniques for hypothesis testing to validate data and interpretations

•Identify procedural areas of improvement through customer data, using SQL to help improved profitability retention by 8%

•Presented data and conclusions to team in order to improve strategies and operations

•Proposed solutions to improve system efficiencies and reduce total expenses

•Database modeling, ETL and creation of analytical processes.

•Developed dashboards, chart box and other reporting solution by using SSRS.

Business Intelligence Frameworks

I-Ping Solutions March 2012-May 2016

Company name

•Intensively worked on Data Quality Analysis, Data lineage and Data Standardization data structures, database design, data warehouses, business intelligence/analytic tools, ETL, and data integration.

•Developed reporting solutions for large data sets (Big Data) using SQL, SSRS, and SSIS.

•Manage the planning and development of design and procedures for metrics reports

•Extensively analyzed exiting data models and provides insights for future projects.

•Develop new reports and delegate tasks to team members

•Perform market analysis to efficiently achieve objectives, increasing sales by 24%

•Investigate and conduct studies on the forecasts, demand, and capital of products

•Worked with various data flows tasks, merge, joins, aggregate and SSIS packages

Academic Qualification

MSc in Business Analytic (on going) Bharat/Maharishi University 2023--

Associate in Accounting, Indian Hills Community College, Iowa 2014-2016

Diploma in International Trade and Development, Trapca.org, Arusha 2010-2010

Bachelor of Economics and Information Technology, University of Buea 2006-2009

References upon request

Contact this candidate