Result oriented individual with a recognized experience for converting detailed analytics reports into actionable steps that focus on improving key performance indicators and facilitating for further decision making and ability to translate complex data concepts into concise and meaningful reports.
Primary Responsibilities:
To compile all Production Reports received from all departments and sections of Unit 1 & 2 duly filled by respective shift Operator and verified by Section Incharge.
Feeding of all production reports into software/excel worksheets to generate different reports, mainly:
Daily Production Report of all departments.
Daily Material Consumption Report of all departments.
Daily Wastage Report of all departments and reconciliation by dispatch.
Daily Analysis Report of Operators Performance in respect to Production & Wastage.
Daily Downtime/Idle Time Report of Operators & Production Machines.
Job Closing Report from Production to Dispatch.
Costing of each Job and comparison sheet.
Costing of Material Consumption and relevant comparison Report.
Calculation of Material Consumption for Production.
Reconciliation Report of Material issued & Consumed for all departs.
Monthly Comparison Report of Production & Dispatch.
Traceability Report of in process orders for follow up.
Monthly Closing Report of Production of all departments.
Monthly Material Consumption Report and reconciliation by Store Depart.
Monthly Analysis Report of Department wise Production, Material Consumption, Wastage & Operators Performance by Graphical Representation.
To email Daily production report to all section and Department Heads including all sales persons.
To submit all reports timely to GM and Director.
Work with production teams to plan, analyze, identify flaws and manage production activities.
Monitor the execution of production plan and identify deviations.
Attend meetings to discuss about production issues and updates.
Communicate production status and error updates to the Director and seniors on regular basis.
Prepare Analytical Reports by use of Advanced Microsoft Excel formulas mainly:
KPI Dashboard
Index & Match, Vlook up, Hlook up, Pivot Table
Sum if, Count if, Nested If, Sub Total
Conditional Formatting, MID and RIGHT Function
Drop down Box, Searchable Drop down List
Offset Function, LEN and TRIM,
Concatenate and others.
In Technology Links, I had been working on foreign funded projects. My scope of work included:
• Preparation of Foreign Funded Project’s Tenders such as JICA (Japan), Germany (GIZ) (KfW), UNICEF and other local & international organizations.
• To handle bidding including preparation of bids in line with tender requirements.
• Documentation, Preparation of Technical Proposal, Financial Proposal & other requirements for the Tenders.
• Preparation of Registration Documents, Pre-Qualification Documents of international organizations such as UNICEF, WHO & others.
• Preparation of Quotations, Purchase Orders, Proforma Invoices for various suppliers.
• Preparation of Invoices for the payment, Preparation of packing List, Commercial Invoice.
• Follow up on the payment of invoice with the finance department.
• Processing and documentation (delivery challan & invoice) for the delivery of import equipment to Clients.
• Follow up with the clients against submitted quotations.
• Email Correspondence with suppliers, manufacturers & principals within and outside country.
• Arrangement & preparation of Bank Guarantees/ Earnest Money, Pay orders for suppliers.
• Letter Drafting, Letter typing, drafting of Undertaking & other required documents.
• Arrangement of Import documents and coordination with clearing agent for the clearance of the consignment.
• Arrangement of delivery of the consignment to the required destination.
• Coordination with the logistic companies and complete follow up.
• Arrangement of the inspection and installation of the supplied Equipment in coordination with the Engineers, concerned authorities & Branch offices.
• Complete follow up of the projects and day to day reporting to General Manager Projects.
• Arrangements of Payment to suppliers.
• Settlement of Accounts with Finance Department.
• Supervision of Women Empowerment Scheme.
• Drafting of regular letters, Approval Letters, Complaint Letters and Letter for Mutual understanding (panel) with Hospitals etc.
• Preparation of Press & Photo releases for promotion of services of the Trust for urdu as well as for English Newspapers.
• Data Entry of Sadqa Bakra Service in MS Access
• Preparation of daily reports of Night Time Service on MS Excel.