Arshad Iqbal
adg0ob@r.postjobfree.com 416-***-**** Page-1
Pricing / Business Analyst
Highly motivated professional with a thorough understanding of Business / Price Analyst. Designed and implemented company-wide pricing strategies. Analyzed market trends, competing pricing structures, consumer data, and industry standards. Offering my extensive experience across a wide spectrum of commercial operations with reputed organizations, possessing valuable insights, keen analysis and team approach to implement best practices in Canadiana retail industry, Sobeys Inc, Rexall Pharmaceutical Group” as well as High Tech “Dell computer Inc”
Area of Expertise / Skills:
Proficient in advanced MS-EXCEL, MS-Office, SAP, ERP, CRM, SAS and TALLY 7.2.
Expert knowledge in Pricing Strategies, Data Mining and Analytics and manage historical usage data requests
Efficient in Spreadsheets, Pivot Tables, Formulas, Macros, Summary Reports, Vlookup&Hlookup.
Skilled in process mapping, problem solving, presentations, manipulation & tabulation of data.
Possess hands on experience in Six Sigma approach.
Excellent social media presence, engagement & communication strategies.
Accomplished strategist who excels at designing and implementing projects from start to finish
Excellent in Micro Strategy (BIS) BI reports, Proficient in SAP, ERP System
Professional Work Experience:
Vital Insight / Enprecis Mississauga ON February 2019 –April 2020
Business Analyst: (Contract)
Vital Insights Inc. provides customer experience management (CEM) solutions. The Company designs, develops, and distributes daily tracking and customer experience management software solutions on desktop and mobile devices that distributes, gathers, and manages customer feedbacks. Vital Insights offers its products to the automotive industry in Canada and internationally.
Key Responsibility:
Works with stakeholders and project team to prioritize collected requirements
Creating a detailed business analysis, outlining problems, opportunities and solutions
Scope of the role is to provide organizational and administrative support for the IT and Business Management Team for Business process model
Identifies and establishes scope and parameters of requirements analysis on a project-by-project basis to define project impact, outcome criteria, and metrics
Monitor project progress by tracking activity; resolving problems; publishing progress reports recommending actions
Conduct and coordinate financial, product, market, operational and related research to support strategic and business planning within the various departments and programs of the client group
Key Contribution
Analyze root causes of business problems and provide permanent resolutions
Creating a detailed business analysis, outlining problems, opportunities and solutions for a business
Rexall Pharmacy Group Ltd Ontario
Property Lease Analyst: (Contract) October 2018 to November 2018
Rexall in Canada was established in 1904 in the early days of the United Drug Company and quickly established itself as an innovator in retail pharmacy over 400 stores in all over Canada.
Key Responsibilities:
Scope of the role is to provide organizational and administrative support for the Leasing and Management staff. Prepared around 250 lease agreements for negotiation and application approvals
Verified income, assets and expenses and completed file tracking sheet for each applicant.
Investigated and response regarding rent memo discrepancy
Collaborate with various functional teams (including Marketing, Strategy, Sales, Pricing Execution, IT, BI, Finance, Operations) to ensure that pricing strategies are consistently applied
Ongoing tracking, support and resolution of offer usage and compliance amongst
Arshad Iqbal 1(416)- 732-9360 adg0ob@r.postjobfree.com Page 2
Key Contribution:
Organize land lord and tenant lease agreement file in system that can be easy access to all team member and reduce 50% wait time and process gap
Sobeys Inc. (Head Office) Ontario
Retail Price Analyst: (Contract) March 2018 to August 2018
Sobeys Inc. is proudly Canadian, with more than 111 years of experience in the food retail business. As one of only two national grocery retailers in Canada, approximately 1,500 stores in all 10 provinces under retail banners that include Sobeys, Safeway, IGA, Foodland, Fresco, Thrifty Foods and Lawtons Drugs, as well as more than 350 retail fuel locations.
Cost Harmonization project:
Work with complex data sets to help businesses determine and set competitive prices to gain market share and achieve revenue goals. Maximum possible price defined by the product price on the market and charged by the competition.
Key Responsibilities:
Carry out research and create requirements using document analysis and constant interaction with various stakeholders
Define scope and objectives for projects as a result of interaction with business owners and technical teams
Developed business cases and/or project summaries; prepare needs analysis and problem definition; identify current state, desired future state, and gap
Business case support: data collection, qualitative analysis, identifying revenue opportunities, cost savings, and profitability analysis
Create templates to assist in annual pricing reviews where applicable
Business case support: data collection, qualitative analysis, identifying revenue opportunities, cost savings, and profitability analysis
Provide financial analysis and modeling on pricing decisions for new and existing customers
Collaborate with various functional teams (including Marketing, Strategy, Sales, Pricing Execution, IT, BI, Finance, Operations) to ensure that pricing strategies are consistently applied
Report on price increases/decreases as compared to prior year
Responsible to gather and input data; build, analyze and maintain reports to support merchandise decisions utilizing systems. Executing cost and retail price changes in templates/ SAP systems
Attended weekly internal meetings. Running existing and ad-hoc reports for own category to ensure pricing, promotions, and other data accuracy
Day to day analysis of price gaps and variations, assessing and correcting costs and working across various internal and external teams to ensure proper capture of data and a smooth flow of processes
Maintained regular retail pricing strategy for assigned merchandising categories using RPO and SAP,BW Analyzer
Performs assignments and special projects in support of departmental objectives often functioning across disciplines and areas of expertise
Key Contribution:
Key contribution for this role to reduce process gap by 60% improve system performance by 75%. Worked on Delisted or deleted sku, evaluate those Item or sku to determined why system take too long to retrieve data. Mining data from “SAP” using “Tcode” and analyzing it using spreadsheets and functions such as Vlookup, Hlookup and Macros, evaluating data through harmonize cost family group as well as cost calculation and get rid of those delisted and deleted sku this procedure that improve system performance to retrieve data and create accurate CDM file for vender. Achieved Performance Target Customer’s Delivery & Support Expectations and reducing OCC (Operational control cost) by 25%,
Dell Computer Canada Inc Ontario
Business Operation Analyst (Service & Support) September 2013- December 2017
Dell is leading selling technology directly to people, as well as through retail outlets now Dell bought EMC, it was Symmetrix, a data storage solution that transformed the way data centers operated in large enterprises. By the new millennium, both Dell and EMC were market leaders.
Key responsibility:
Complete all change orders and delivery expedite requests
Investigate and process all factory returned goods with facilitated through warehouse (Genco)
Arshed Iqbal 1(416)- 732-9360 adg0ob@r.postjobfree.com Page 3
Analyze root causes of inventory problems and provide permanent resolutions
Maintaining accurate records of the inward and outward inventory stock
Review inventory performance, identify root cause. Recommend process improvements to prevent out of stocks and overstock issues. Dealing problem log with third party venders like Synnex, Tech data, and Ingram Micro for their credit issues and discrepancy
Identify and troubleshoot products that are under performing expected service levels and develop appropriate response plans
Monitor and analyze promotional performance relative to forecast, and provide analysis on variance to forecast
Prepared weekly reports to management on status of open items. Managed claims related to program or customer returns (RMA)
Work with operational counterpart to follow up on inventory, COGS and count variances
Key Contribution:
In that role a major accomplishment that I have done I was able to reduce the time spent on month end procedures by developing an excel model which automated a major returns and there credit issues process this resulted in a time saving and cut cost of 25%
Meet or exceed our Customer’s Delivery & Support Expectations Reduce by 75%, improved inventory, COGS and count variances by 25%, Improved Care C-Sat by 15% and Improved PE (Purchase Experience) by 55%. Received Dell service excellence Browns award
Automated Logic Inc Ontario March 2009- July 2013
Inventory and Pricing Analyst
At Automated Logic, we are the people behind intelligent buildings. We designed and developed the industry-leading building automation system with an intuitive, proven platform that provides real-time visibility and control of equipment, systems and facilities.
Key responsibility
Provided analytical support and expertise on retail pricing activities, processes and related projects .Keying and updated all promotional items into Tool and running integrity reports through SAP for accuracy. Investigated the authenticity of transactions in case of high value sales.
Made decisions on the outcomes of buyer claims pertaining to non-receipt, missing, different or defective products. Worked with highly confidential data and across teams and departments to develop a secure e-commerce platform
Key Contribution
Major Accomplishment due to my strong analytical, prioritization, interpersonal and planning skills recommend and implement to take initiatives to reduce slow moving inventories and developed FIFO Method to improve inventories turns over 80% and monitors their life cycle.
Other Employment History:
Fairmont Princess Hotel Bermuda January 2006- January 2009
Business Marketing and sales Executive
GlaxoSmithKline Pharmaceutical Karachi November 1999 October 2005
Sr. Medical Sales Executive
Academic education:
BSc in Science 1990
Karachi University
Master of Business Administration (MBA) 1998
The International University Missouri USA
Diploma in Accounting / Payroll Toronto 2012
Everest College Toronto
Certification:
Certificate in Marketing Management from Institute of Business Administration (1992)
Canadian Payroll compliance certification (CPC) (2012)
Voluntary
Voluntary work for Scott Mission ON Toronto
Help and prepare donation grocery bag for needy people and serve hot lunch to homeless people