Muhammad Ramzan Email & Phone Number

Lahore, Punjab, Pakistan

• Analysis of Sales & Operations department data at various dimensions
• Excel based Dashboards preparation and updation on periodic basis
• Company’s sales performance analysis (growth and targets achievement) at National Level, Region Level, and store level. Daily, MTD, and YTD results
• Footfall/Traffic and conversion analysis. Update on other KPIs; transactions, IPT and RPT etc …
• Analysis of store audit results, so that preventive actions can be taken
• Field staff payroll analysis

Lahore

• Training Courses:
• Microsoft Office 365 (Word, Excel, PowerPoint)
• Microsoft Excel – Beginner, Intermediate and Advanced Level
• Advanced Excel Reporting & Dashboarding
• Structured Query Language (SQL)
• Data Analytics using Advanced Excel, Power Pivot, SQL and Power BI

Faisalabad, Punjab, Pakistan

• Reporting of Daily / MTD performance of production divisions; Spinning, Yarn Dyeing, Knitting, Fabric Dyeing, Fabric Processing, Cutting, Printing, Embroidery and Laundry.
• Providing absolute status of purchase orders. How much product quantity is under process at various stages of production.
• WIP reporting: How much work in process is at production units. Reporting of WIP Aging to manage inventory.
• Maintaining KPIs Dashboard.

Head Office, Lahore

• Business Analyst
• Analysis & Reporting of company’s business performance at various dimensions.
• Monitoring & reporting of any sales manipulation/fraudulent activity, using SQL from Oracle database.
• Design & develop Oracle BI Publisher reports for field team.
• Preparation of Excel-based Dashboards and Data visualization for Senior Management’s decision-making. Team performance reports and KPIs evaluation on monthly/quarterly/yearly basis.
• Responsible for daily/monthly targets setting for entire retail stores network.

Lahore Head Office

• Manager Business Analysis
• Analysis of Customer Buying Behavior and Life Cycle. Pre- & Post analysis of promotional activities / marketing campaigns.
• Reporting of actual trade spend and bonus cards at activity level, store-level & customer-level.
• Targets setting for annual sales budget and follow-up monitoring of performance.
• Providing analytical data to HOD for regular CFT meetings.
• Daily sales reporting and KPIs measurement & incentive schemes result announcements.

Faisalabad Regional Office

• Collecting & compilation of daily sales & stock reports.
• Handling regional invoicing system, ordering, stock allocations, monitoring of stock norms, providing stock availability information to distributors, providing information of served-unserved orders to distributors..
• Effective implementation of collection of advance payment against orders.
• Trade spend monitoring. Issuance of Budget Release sheets. Handling distributors claims, checking and follow-up for settlement.
• Sales Forecasting on monthly/quarterly/yearly basis. Target setting of distributors on monthly basis.
• Regular maintenance of sales data as well as record of all communication. Regular compilation of data from distributions and calculating relevant KPIs

Lahore

• Maintain files of job applications, issue interview call and joining letters.
• Maintain personal files of all employees of the organization.
• Prepare and maintain leave record & attendance record of employees.
• Files maintenance & routine office correspondence.

Faisalabad

• Providing assistance in Research projects.
• Correspondence and files management.
• Preparation and regular updation of Doctors Directory.
• Automation of Lab Reports in Lotus 123.

Master Of Computer Science, Computer Science

Bachelor Of Science (B.Sc.), Math A-Course, Math B-Course & Statistics

F.Sc., Pre-Engineering Group (Physics, Chemistry & Mathematics)

Matric (Science Group)