Learn Data Skills
Beta
Ashraf Selim

Ashraf Selim

Business intelligence analyst

Egyptian Propylene and Polypropylene

Technologies

My Portfolio Highlights

My New Course

Introduction to Power BI

My New Course

Introduction to DAX in Power BI

My New Course

Case Study: Analyzing Customer Churn in Power BI

I possess a high level of proficiency in data analysis, business intelligence, and strategic thinking. Through effective collaboration with C-level executives and top management, I actively promote data-driven decision-making, provide valuable insights, and offer support in achieving organizational goals. Prudent Business Intelligence Analyst with 8 years providing employers with valuable and actionable data to drive profit growth. Practiced filtering information to find and highlight vital metrics and revelatory findings. Keen to support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.

My Work

Take a look at my latest work.

course

Intermediate SQL Queries

course

Introduction to Power BI

course

Data Visualization in Power BI

course

Case Study: Analyzing Customer Churn in Power BI

course

Introduction to DAX in Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Egyptian Propylene & Polypropylene | Jun 2018 - Present

Data Analyst | Business Intelligence Analyst BIA | Data Visualization

Egyptian Propylene & Polypropylene - Business Intelligence Analyst 06/2018 - Presente Cairo Egypt, • Develop and implement a data-driven decision-making culture within the organization, promoting the use of data analytics and business intelligence tools at the executive and senior management levels. • Collaborate with executive leaders and senior management to identify key business questions and objectives and translate them into actionable data analysis projects and strategies. • Gather, analyze, and interpret complex data sets from various sources to generate meaningful insights and recommendations for strategic decision-making. • Design and deliver senior-level dashboards and reports that provide real-time visibility into critical business metrics, key performance indicators (KPIs), and performance indicators. • Conduct in-depth market and competitive analysis to identify trends, opportunities, and potential risks, and present findings to executive leaders and senior management. • Develop and implement advanced analytics models and techniques, such as predictive modeling, machine learning, and data visualization, to uncover hidden patterns, forecast outcomes, and drive business growth. • Provide guidance and support to executive leaders and senior management in leveraging data analytics to optimize operational efficiency, improve customer experience, and drive revenue growth. • Collaborate with technology teams to identify and implement data infrastructure and tools that enable effective data analysis and business intelligence capabilities. • Stay up to date with industry trends, emerging technologies, and best practices in data analysis and business intelligence. • Generated standard and custom reports to provide insights into business performance. • Developed complex dashboard and reporting tools to track business performance metrics. • Utilized data visualization techniques to present and explain complex data sets. • Implemented business intelligence solutions to increase operational efficiency. • Created data models to support decision-making processes. • Updated and developed scripts and queries to extract and analyze data from multiple sources. • Generated ad-hoc reports to evaluate specific business requirements. • Collaborate with finance and accounting teams to ensure accurate financial analysis and reporting, and support budgeting, forecasting, and cost optimization efforts. • Created data analysis tools to allow teams to query acquired information for unique details. • Analyzed data to identify root causes of problems and recommend corrective actions. • Collaborated with stakeholders to identify business needs and data sources. • Developed customized reports, summarizing and presenting data in a visually appealing format. • Communicate complex analytical concepts and findings clearly and concisely to executive leaders and senior management, facilitating data-driven discussions and decision-making. • Identified patterns and trends in large data sets and provided actionable insights. • Created dashboards to monitor and track key performance indicators. • Designed and developed data pipelines to acquire, clean, and process data. • Collected data from wide-ranging sources. • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
Show More

Egyptian Propylene & Polypropylene | Nov 2016 - May 2018

Assistant Department Head Financial Analysis and Cost Control

Assistant Head Department Financial Analysis 2016 – 2018 Egyptian Propylene & Polypropylene Cairo Egypt • Recording, classifying, and summarizing financial transactions and events in accordance with accepted local accounting principles and financial reporting standards. • Manages all aspects of headquarters accounts receivable, cash receipts, and banking, including the review of supporting documentation. • Manage standard cost Center process in line with corporate policy, fully responsible for setting and maintaining the accuracy of standard costs. • Prepares monthly, quarterly, and yearly closing activities. • Prepares Monthly Special Reports and reviews the Computation of staff salaries monthly. • Review all inter-company transactions and generate invoices as necessary. • Complete all month-end reporting activities according to the closing schedule in terms of both time and quality and Monthly analysis of financial performance. • Perform cash flow forecasting, budgeting, and analyzing margins, variances, and cost analysis. • Coordinates with external and Internal auditors for the quarterly and yearly audit process. • Created and executed sales promotions in partnership with store management. • Created an environment focused on helping customers feel welcome, important, and appreciated. • Conducted detailed financial analysis to identify and evaluate changes in operations, trends, and potential areas of improvement. • Collected data and developed detailed spreadsheets to identify trends and create revenue, profitability, and expense forecasts. • Developed forecasting tools to analyze revenue variances and capitalize on industry trends. • Conducted due diligence on potential investments and presented findings to investors. • Helped clients make optimal decisions on amounts and timing of capitalization. • Researched macroeconomic, industry, and company-specific data to inform investment decisions. • Tracked prices, yields, and other trends to correctly interpret impacts on investment programs. • Developed financial models to assess potential investments and identify potential risks. • Collaborate with finance and accounting teams to ensure accurate financial analysis and reporting, and support budgeting, forecasting, and cost optimization efforts. • Created data analysis tools to allow teams to query acquired information for unique details. • Analyzed data to identify root causes of problems and recommend corrective actions. • Collaborated with stakeholders to identify business needs and data sources. • Developed customized reports, summarizing and presenting data in a visually appealing format. • Communicate complex analytical concepts and findings clearly and concisely to executive leaders and senior management, facilitating data-driven discussions and decision-making. • Identified patterns and trends in large data sets and provided actionable insights. • Created dashboards to monitor and track key performance indicators. • Designed and developed data pipelines to acquire, clean, and process data. • Collected data from wide-ranging sources. • Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Oriental Weavers | Feb 2013 - Oct 2016

Supervising Senior Accountant

Oriental Weavers Carpet - Supervising Senior Accountant 02/2013 – 10/2016 Cairo Egypt • Assist in analyzing financial information to prepare financial statements. • Assist in ensuring accurate entries and timely monthly, quarterly, and year-end close. • Resolve accounting discrepancies and irregularities. • Financial audit preparation and assist in coordinating the audit process. • Ensure accurate and appropriate recording and analysis of expenses. • A member of the 'JDE' ERP implementation team: communicate the requirements & test the features and follow up with the implementer to ease and smooth the implementation process. • Assist the accounts manager in the preparation of the monthly reports and the quarterly financial statements. • Reconcile the figures in the subsidiaries with the GL figures. • Assist the financial controller in analyzing the periodic financial statements of the company and its sister companies to evaluate the company's liquidity, solvency, results of operation, and financial position. • Introduced the preparation of cash flow & cash budget. • In charge of validating all payments before sending the payment vouchers for the management's approval. • Prepared monthly journal entries and reconciliations. • Completed year-end closing processes with controllers and external auditors.

Oriental for urpan devlopment | Jan 2011 - Jan 2013

Accounts Payable Supervisor

Accounts Payable Supervisor 06/2011 – 01/2013 Oriental for Urban Development Cairo Egypt • Reviewing & and matching the invoices with purchase orders and receiving documents • Prepares for proper coding of invoices to general ledger expense accounts and updates to inventory records. • Monitors cash flow reports and checks to ensure that all discounts are taken, and that accurate and timely payments are made. • Review checks and vouchers to verify proper payments before signature by the controller. • Reconciles subsidiary vendors' ledger with accounts payable total and with general ledger. • Ensure accurate preparation of purchase journals and budget reports. • Ensure that a proper record is kept of purchases subject to withholding tax in preparation for periodic audits by state inspectors. • Perform training of new accounts payables clerks, assigns specific. • Trained and supported new hires to educate them on process flow and interdepartmental procedures. • Interacted with corporate vendors, upper management, and peers. • Oversaw monthly accounting close process for timely and accurate reporting of financial information. • Maintained internal controls over disbursement functions by strict Sarbanes-Oxley guidelines. • Tracked expenditures and prepared reports for records and management review. • Entered job costing data from payroll records and supported payroll administration process. • Delegated tasks to administrative support staff to organize and improve office efficiency.

Greater cairo for urpan devolpment | Jan 2008 - Dec 2010

Senior Account Receivable

Acoyuntas Payable Supervisor 01/2008 – 12/2010 Garetear Cairo for urpan devolpment Cairo Egypt • Control collections stay within forecast days outstanding. • Customer Aging & and days in sales statistics • Receivables are processed in an accurate and timely manner & and reconciled. • Billings are processed in an accurate and timely manner supported with the right dunning letters. • Responsible for submission of the: Cash forecasting - Cash and delinquencies • Revenue statistic information • Monthly and quarterly revenue reports to corporate headquarters. • Posted customer payments by recording cash, checks, and credit card transactions. • Recorded deposits, reconciled monthly bank accounts, and tracked expenses. • Reconciled account information and reported figures in the general ledger by comparing them to bank account statements each month. • Maintained account accuracy by reviewing and reconciling checks monthly. • Streamlined daily reporting information entry for efficient record-keeping purposes. • Created detailed expense reports to facilitate reimbursement for business expenses incurred. • Presented audit findings to the accounting manager after reviewing results and paperwork. • Implemented new accounting processes to decrease spending and workflow downtime. • Compiled budget figures by reviewing past budgets, evaluating estimated income, and assessing expenses. • Generated invoices upon receipt of billing information and tracked collection progress. • Reconciled company bank, credit card, and line of credit accounts, investigating and resolving discrepancies to keep accounts audit-ready. • Effectively communicated with clients about payment needs and kept updated detailed and accurate ledgers. • Handled day-to-day accounting processes to drive financial accuracy. • Prepared bills receivable, invoices, and bank deposits. • Updated aging reports based on daily audits. • Posted revenues by verifying and entering transactions from lock box and local deposits. • Supported management by processing invoices and documents with consistent on-time delivery. • Entered figures using a 10-key calculator to compute data quickly. • Reduced financial discrepancies, effectively reconciling bank accounts and organizing information into accounting software. • Maintained excellent financial standings by working closely with the bookkeeper to process business transactions. • Managed complex problem-solving for upper management to complete projects on time and within budget.

Oriental Weavers | Jan 2007 - Dec 2007

Accountant

Accountant - Oriental Weavers 01/2007 – 12/2007 Cairo Egypt Jan 2007 - Dec 2007 (1 year) • Prepare quarterly financial statements. • Maintain accurate fixed assets register & depreciation schedules. • Reconcile cash transactions to general ledgers and bank statements. • Arrange the payment of staff salaries through the computerized payroll system. • Generate invoices and credit notes by standard procedures to ensure effective cash. • and credit control. • Monitor construction in progress account. • Respond to customer inquiries and complaints, by telephone or in writing, after having checked the • relevant facts from existing records. • Prepare withholding tax forms.

My Education

Take a look at my formal education

Bachelor of Commerce (BCom), accountingAl-Azhar University | 2005
Corporate Finance Institute® (CFI)
business intelligence analysisDataCamp | 2022
Introduction to Power BI, Business inelegant analysis  · (OctoberDataCamp | 2022
DataCamp

About Me

Ashraf Selim

Ashraf hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free