Umar Ashraf Email & Phone Number

Mississauga, ON, CA

Power BI ProjectLed the implementation of Power BI project in the organization which included the following stages: Requirements Gathering, Data Collection and Mapping, Data Architecture and Modeling, Report Creation and Dashboard Distribution.Collected Business requirements to understand KPIs and Business needs and implemented solution through Power.

Performing regular margin analysis and analysing profit margins.Preparing daily, weekly and monthly reports that reflect the financial operations of the business.Producing and analyzing monthly and quarterly reports, including the Profit & Loss statement in the areas of Vendor Management, Sales and Product Management.Reporting Monthly Business KPI's.Adhoc.

London, Canada Area

• Monthly/Weekly Reporting of KPIs (Revenue, GM%, Trailing Metric, Customers) by market and segment to Executive Team.
• Statistical analysis of large quantities of data to determine product trends, seasonal variations and impact of business initiatives on the overall revenue and profitability of the company,
• Customer segmentation of VAR market in US to outline key customers for marketing initiatives.
• Development of reporting tools for vendor cost management, channel inventory position and monthly goals review.
• Price sensitivity analysis of price changes to determine their causal impact on revenue and number of customers using google analytics R tools.
• Providing recommendations for optimal pricing based on product positioning and lifecycle stages.

Mississauga

• Consulted startup ventures and small enterprises for Strategy preparations and financial planning.
• Conducted market research and industry analysis specific to the product markets.
• Worked closely with customers to transform Business Requirements into Functional specifications
• Performed detailed financial analysis which included equity analysis, cost and revenue analysis and payback analysis.
• Prepared short term and long term implementation plans and risk mitigation plan as per the recommended strategy.
• Provided recommendations to optimize financial leverage and highlighted tax advantages for clients.

Brantford

• Consulted regarding Organizations strategy, financial planning and Market analysis to improve demand, product reach and profitability of their Solar LED and LED line of products.
• Evaluated financial statements to highlight cost improvement factors and performed 5 year cash flow projections.
• Conducted competitive analysis related to market sizing and identified key target markets.
• Prepared the Final Pitch/Marketing Plan to be presented to the Management which included market segmentation, marketing channels evaluation and brand development strategy.

• Supervised a team of six engineers and optimized Cellular network KPIs of the assigned region.
• Forecasted quarterly customer traffic using modeling techniques and planned annual departmental fiscal budget.
• Performed Technical evaluation of project bids submitted by vendors and presented analysis to top management.
• Acted as Liaison for negotiations with vendors on delivery milestones and procedure guidelines.
• Managed the implementation of Network Modernization project (2G to 3G) which included co-ordination with vendor and 3 internal teams, formulation of activity night procedures and acceptance report templates.
• Prepared end to end Project Budgets (around $20million) and analyzed Expansion equipment needs for the project.

• Worked in P&O Department to plan new sites for Business Development and improvement in Quality of Service.
• Responsible for daily stats monitoring for more than 700 BTS sites, which included data extraction from SPOTS server, Report Formulation and analysis of worst performing cells.
• Planned 1000 BTS sites and organized surveys and drive tests in a record time of 1 year during initial launch phase.
• Co-ordinated with Sales & Distribution Directors to meet regional sales KPIs and improve customer satisfaction.

Master Of Business Administration (Mba), Accounting And Finance, A

Activities and Societies: • Awarded Research Associate position in Wilfrid Laurier University for outstanding performance in first.

B.E, Electronics