Data Analyst Business

Steve Ntsafack

Education:

Associate of Science in Accounting, Brookhaven College, Dallas, TX (Dec 2018)

Master’s degree in accounting & Finance, University of Yaounde 2 (SOA), Cameroon (Sep 2012)

Bachelor’s Degree in business administration, University of Yaounde 2 (SOA), Cameroon (Aug 2010)

Certifications:

AWS Solution Architect Associate, AWS, Cloud Computing.

Data Science Professional Certificate, IBM, Coursera

Data Analytics Professional Certificate, Google, Coursera (https://www.credly.com/badges/ac21c403-f54d-4029-8125-3775758bfd44)

Certified Artificial Intelligence Professional Inc, CAIPi, Application of AI in Price Prediction

Certified Artificial Intelligence Professional Inc, CAIPi, Conversational AI Hands-on Workshop for Professionals

Supply Chain/ SAP/ ERP System:

Experience in using Supply Chain system to manage the flow of goods, data and resources related to the products and services to sell. Proven knowledge in using SAP and ERP System.

Data Analyst / Business Analytics:

Experience in using statistical models to correlate various data sets and draw conclusions for strategic business improvement actions. Proficient in Data Analysis, Data Visualization, Advanced Data Mining, Data Structures, Data Models, Data Calculations.

Python / SQL:

Hands on experience in using Python for data visualization and data analysis. Proficient in creating and executing queries utilizing various data sources to provide business information.

Other Education:

Master of Science in Business Analytics, Texas A&M University-Commerce, Commerce, TX (Anticipating Aug 2022)

Technical Skills:

• Tableau • Power BI • Microsoft Excel (Formulas, Sort, VLookups, IF Statements, Filtering, Pivot tables/charts, VBA.) • SQL • Business Intelligence • Python • R • Visual Studio for SSIS • Stakeholder Management • Databases • Data Visualization • Data Mining • Data Analysis • Data Models • Data Calulations • Troubleshooting • Agile Methodology• Use Cases • ETL• ERP System• Jupiter Notebook • Data Cleaning • SAP • Requirement Analysis • Dashboard • Project Management • Spreadsheets • Finance Analytics• Jira • AWS • MatLab • Problem solving • Shell Scripting • Powerpoint • QuickBooks • Collaboration • Java • Html •

Professional Experience:

United Parcel Service (UPS), Coppell, TX Jun 2019 – Present

Data Analyst

•Analysing data for meaning and communicating results to the appropriate parties.

•Interpret data and make conclusions that are presented in a visual format to senior management.

•Extract, clean, transform, validate, or model data with the purpose of understanding or making conclusions from the data for decision-making purposes.

•Use statistical models to correlate various data sets and draw conclusions for strategic business improvement actions.

•Using Supply Chain system to manage the flow of goods, data and resources related to the products and services to sell.

•Creating and executing queries utilizing various data sources to provide business information.

•Create tools and analyse data that help with team efficiencies, scalability, and profitability.

•Use SQL to access, read, and analyze the data stored in databases (extract data, join tables together, and perform agregation).

•Design Tableau and Power BI dashboard which give a visual representation to the users.

•Using Python for Data Visualization and data analysis.

•Develope dashboards including various charts- bar charts, pie charts, scatter charts, bubble charts and shape maps.

•Manage, update and manipulate report orientation and structures with the use of advanced Excel functions includuing Pivot Tables and V-Lookups.

•Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.

•Communicate effectively with project management regarding issues and needs for projects.

Zobele USA, Dallas, TX Nov 2016 – May 2019

Business Analyst

•Provide support in the area of develop, deploy, and provide recommendations on creative and content testing.

•Assist with the end-to-end project management of reporting and ETL development projects within the team.

•Review files, records and other documents to obtain business information and key data informing responses to development requests.

•Design SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server.

•Create SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.

•Develop business architecture using requirements such as scope, processes, alternatives, and risks.

•Help to automate processes and develop quantitative business analytics.

•Communicate client's business requirements by constructing easy-to-understand data and process models.

•Translate stakeholder requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.

•Identify and reconcile errors in client data to ensure accurate business requirements.

Pecten Company, Douala Cameroon Feb 2012 – Dec 2014

Financial Analyst

•Analyse and evaluate the company's financial position and suggest options for improvements on expenses.

•Prepare product line profitability and income and balance sheet statements, consolidated statements, and various other accounting statements and reports.

•Worked with Union Africa Bank (UBA) & ECOBANK to elaborate financial services.

•Identify and frequently implements ideas or practices for improved efficiency and/or accuracy

•Analyse financial reports, making studies or recommendations relative to the accounting for reserves, assets, expenditures, and revenues.

•Prepare itemized statements, bills or invoices and record amounts due for items purchase or services render.

•Recommend financial solutions to corporate management based on detailed financial analysis.

Contact this candidate