MUHAMMAD
RAMZAN

NEXSKILL IT TRAINING INSTITUTE

IT Trainer

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

MADODO TEXTILE MILLS, FAISALABAD.

Senior Manager – Business Analyst

• Reporting of Daily / MIS performance of production divisions: Spinning, Yarn Dyeing, Knitting, Fabric Weaving, Fabric Processing, Cutting, Stitching, Embroidery and Laundry.
• Providing absolute status of purchase orders.
• WIP reporting: How much work in process is at production area.
• Preparation of reports through SQL from Oracle database. Reporting of WIP using BI to manage inventory.
• Maintaining KPIs Dashboards.

SERVICE SALES CORPORATION, HEAD OFFICE, LAHORE.

Business Analyst

• Analysis & Reporting of company's business performance of various dimensions.
• Monitoring & reporting of any sales.
• Distribution-location-calculation 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.
• Responsible for the reporting of monthly quarterly results for entire retail shoes network.
• ORRIS Super User: New Store Creation and Master Data maintenance of existing stores.
• Departmental Functional Coordinator during system migration from RIMS to MS Dynamics AX.

METRO CASH & CARRY PAKISTAN, HEAD OFFICE, LAHORE.

Manager Business Analysis

• Analysis of Customer Buying Behavior and Life Cycle. Pre & Post analysis of promotional activities / advertising campaigns.
• Reporting of actual trade spend and bonus cards of customer level, store level & commercial level.
• Targets setting for annual sales budget and follow-up monitoring of performance.
• Providing analytical data to HOD for regular OTT meetings.
• Daily sales reporting and KPIs measurement & incentive schemes result announcements.
• Monitoring of Sales expenses.
• Project Coordinator of customers data migration during merging stores in Metro stores.

Training & Development

Excel Training of store-based Data Analysts, periodically training them in creating reports through BI tools.

NESTLE PAKISTAN LTD. FAISALABAD REGION.

Sales Administration Executive

• Handling staff traveling expense bills. Effective control and monitoring of regional impress account.
• Compilation of daily sales & stock reports, stock allocations, monitoring of stock norms.
• Handling regional invoicing system: ordering, stock allocations, monitoring of stock norms, providing stock availability information to distributors.
• Trade spend monitoring. Issuance of Budget Release sheets. Handling distributor claims.
• Sales Forecasting on monthly/quarterly/yearly basis. Target setting of distributors.