email@example.com 416-***-**** Page-1
Pricing / Business Analyst
Highly motivated professional with a thorough understanding of 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 Canada 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:
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.
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
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.
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.
Develop business cases and/or project summaries; prepare needs analysis and problem definition; identify current state, desired future state, and gap
Arshad Iqbal 1(416)- 732-9360 firstname.lastname@example.org Page 2
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
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.
Complete all change orders and delivery expedite requests
Investigate and process all factory returned goods with facilitated through warehouse (Genco)
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
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 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.
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.
Arshed Iqbal 1(416)- 732-9360 email@example.com Page 3
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
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 monitor their life cycle
Other Employment History:
Fairmont Princess Hotel Bermuda January 2006- December 2009
Business Marketing and sales Executive
GlaxoSmithKline Pharmaceutical Karachi November 1999 December 2005
Sr. Medical Sales Executive
BSc in Science 1990
Master of Business Administration (MBA) 1998
The International University Missouri USA
Diploma in Accounting / Payroll Toronto 2012
Everest College Toronto
Certificate in Marketing Management from Institute of Business Administration (1992)
Canadian Payroll compliance certification (CPC) (2012)
Voluntary work for Scott Mission ON Toronto
Help and prepare donation grocery bag for needy people and serve hot lunch to homeless people