Business Analyst Power Bi

*************@*****.***/ 206-***-**** /www.linkedin.com/in/sakou

Daniel Sakou

Summary:

Business Analyst and Project Manager professional with an amount of experience in Business intelligence Analysis and financial analysis with proven Data visualization skills utilizing Power BI, R, and Excel—proficiency in SQL, Microsoft Excel and Power BI, R and Power Automate flow, and Power Apps. I can organize data and answer critical business questions through reporting and dashboards. I am organized, independent, autonomous, able to set and meet deadlines and prioritize work with minimal guidance. Excellent written, verbal, listening, communicating, and negotiating skills. aggregate data from multiple sources and compile it. I can create and maintain new tables to ingest and analyze data and deep dive into large data. Communicate findings to stakeholders.

GitHub link: https://github.com/dansakoc

Portfolio link: https://dansakoc.github.io/DanielSakou.github.io/

Skills:

Microsoft Office Suite, Power Query- QuickBooks-TaxWise, SAP, Microsoft Dynamics.

We conducted a budget review process. Budget recommendation and Analysis.

Ability to write SQL queries and manipulate data with Postgres SQL – windows functions.

R programming language - Power BI, DAX, data modeling, Power Automate flow, and Power Apps. Amazon Quick Sight. Scripting. Data mining. Budgeting and forecasting.

Statistic data distributions—confidence intervals-hypothesis testing

Machine learning and predictive analytics-linear regression- logistic regression-Decision tree.

Unsupervised learning-Association rule-K-means clustering. Root cause analysis.

Language: English and French.

US GAAP principles - Financial Analysis/ tracking expenses/ tracking revenues

Excel: Advanced Excel, create formulas, pivot tables, and pivot charts, Power Query to manipulate data.

Training :

AWS training and certification: AWS Data Analytics Fundamentals

AWS training and certification: AWS certified Machine learning-specialty

Data Camp: SQL

Investopedia: become a day trader certification.

Experiences:

Business Analyst contract role AMAZON, WA JUN 2024 - MAR 2025

Evaluate the monthly and year profit and loss worksheet for different countries and use VBA to automate the sheet.

Create the regulatory fees sheet document for all countries using many sources including company AI. Summarize the information on one excel sheet using VBA.

Data ingestion in smartsheet and sheet connection for analysis

Automate smartsheet workflow.

Business Analyst contract role AMAZON WEB SERVICES, WA OCT 2023- JAN 2024

Migrate the Tableau dashboard to Amazon QuickSight.

I have created measures, tables, and charts in Amazon QuicKSight for analysis purposes.

Write and update SQL Queries to pull data and ingest data in QuickSight.

Business Analyst IV contract role AMAZON WEB SERVICES, WA MAY AUG 2022- FEB 2023

Tax Data Management Solution team -Indirect tax

Build a Business Intelligence report. Query data for the compliance team.

Prepare monthly reporting and analysis for internal business partners.

Analyze and investigate data source and downstream data. Root cause analysis. Conduct other projects. Ad hoc SQL query. Run ad-hoc analysis, research, and interpreting issues.

Reconciled Accounting and Tax amounts. Investigate non-reconciliation issues.

Work directly with cross-functional teams to gather requirements for building reports.

Business requirements

Write complex SQL queries to extract data.

Troubleshooting business operations.

Worked closely with the fulfillment center.

Business Analyst III contract role AMAZON SEATTLE, WA MAY 2021- APRIL 2022

Foreign Exchange department

Query data from SQL for investigation and analysis to resolve account variances.

Value Added Tax Analysis-Update and prepare files for all companies and regions.

Use Oracle Financial Application to perform UAT testing.

Foreign exchange variances analysis -Investigate Account issues.

Setup new ledger -Run revaluation- Setup New Templates. Create process improvement automation. Prepare monthly reporting and analysis.

Performed ad-hoc reporting and analysis. I have created a monthly reporting automated Excel sheet for the team.

Use Essbase, VLOOKUP, Pivot tables, Amazon Quick Sight, and Datanet, to Extract Data and perform various analyses.

Automated global tax workflow to reduce manual processing(project)

Automated the process of tax reconciliation analysis sheet(project)

Business Data Analyst contract role T-MOBILE BELLEVUE, WA MARCH 2021- APRIL 2021

Cut Purchase orders through SAP and extract data from SAP.

Forecasts, and budgets - Tracking actual vs forecasted budgets.

Monthly quotes & reporting - Reconciled and balanced from month to month when variances occur.

Business intelligence Analyst contract role Microsoft Redmond, WA April 2020- October 2020

Visual studio department

Analyze the ticket data and identify inconsistent reporting root causes.

I Worked on ticket title issues, taxonomy improvements, documentation gaps, and improvements to help the customer support service clean data and implement change to efficiently identify root causes in the future.

I extracted and Analyzed data to identify trends and patterns. Interpret data and deliver end-to-end deep data analysis.

I Identify anomalies, trends, and opportunities to impact key performance metrics by monitoring existing metrics.

Regularly Present findings to management for decision-making.

I used Excel to create formulas, pivot tables, and pivot charts to better understand the data.

I used Power BI, SQL, Power Query, and PowerPoint to perform my work.

Work closely with the stakeholders to provide insights on findings.

I Evaluated each region's performance and helped improve their result.

Business Data Analyst contract role ASP Everett, WA Sep – Dec.2019

Interpret data, analyze results using statistical techniques, and provide ongoing reporting.

Financial statement analysis - Create Visualization to discover data insight.

Acquire data from primary or secondary data sources and maintain databases.

Identify, analyze, and interpret trends or patterns in complex data sets.

Worked with management to prioritize business and information needs.

Locate and define new process improvement opportunities.

Working alongside teams within the business or the management team to establish business needs.

new data collection and analysis processes - Provided recommendations for decision-making.

Database Maintenance-Analyst contract role CBRE (MICROSOFT ACCOUNT) Redmond, WA January 2019 – September

Innovation and Information Technology Department

Data maintenance - Identify gaps and analysis of data to find patterns.

Catching up errors that occurred during data migration. Comparing data sets.

Data entry, data cleanup - Migrating data between two systems. Trained new hires.

Return to Vendor -Analyst contract role Costco Ecommerce Issaquah, WA Nov. 2017 – Oct.2018

Sorting, for a bulk data migration - Maintaining client reports.

Update returns to be processed - Reconciling client accounts.

Analysis and decision-making regarding refunds and returns.

Conduct a mid-year inventory. Conduct other department projects -

Worked on the OMS (Order Management System)

Update vendors’ costs: working on the aging of vendor’s accounts documents.

Update the vendor’s freight costs through the vendor’s account portal.

Processed return requests via multiple PC applications- Trained new hires.

Accounting Assistant BB tax Accounting Corporation Renton, WA June 2015 – February 2016

Processed employee payroll (weekly, monthly, semimonthly)

Ran 941 summary report form/ ran payroll summary report.

Generated invoices / performed variance analysis.

Reconciled financial transactions/bank reconciliation.

Financial statement analysis and processing.

Processed accounts receivable and accounts payable.

Income Tax Assistant IRS volunteer Bethpage Federal Credit Union Elmont, NY December 2012 – April 2013

Prepared individuals and small business tax.

Counseled individuals and business on taxes issues and advantages

Education & certification :

AWS certified Cloud Practitioner issue Feb 2025

Fundamental understanding of IT services ans their uses in the AWS Cloud.. Familiarity with AWS global infrastructure, Core AWS services, Clouds concepts, Security and Compliance, Technology such as compute, storage,networking, databases, Billing and Pricing concepts, cost management tools.

AWS Certified AI Pratictioner issue Dec 2024

Understand AI, ML, and geneartive AI concepts, and strategies in general and on AWS. Ability to determine the correct type of AI/ML technologies to apply to specific use cases and know how t use AI,ML, and generative AI technologies responsibily. Familiarity with AWS global infrastructure, Core AWS services and uses cases, AWS service pricing models, and the AWS shared responsibility model for security and compliance in the AWS Cloud.

Certificate in Data Analytics: Techniques for Decision Making University of Washington,

Seattle

Course: Data Analysis Essentials-Data Visualization-Predictive Analytics

Learn R programming languages, Power BI, DAX expression, SQL, Power Pivot, Power Query

Statistics tools, Machine learning, classification, regression, unsupervised learning,

Project: machine learning creates a model to determine house prices in King County (WA)-R

Project: Study company A to evaluate sales region marketing strategies and create a report for decision-making Power BI

Masters Finance & Accounting Keller Graduate School of Management, Abidjan

Project: fundamental analysis and technical analysis of a particular company stock to hold a buy or sell position

Masters Management & Accounting University Felix Houphouet Boigny, Abidjan

Contact this candidate