Mahammad Ashfaq

PLANNING & SCHEDULING ENGINEER MAHAMMAD ASHFAQ 7 YEARS PLUS EXPERIENCE IN PLANNING & EXPERTISE IN DATA ANALYSIS PROFILE SUMMARY Portfolio 35+ Projects 7+ 300+ Years of Experience Project Reports 1M+ Data Transformation CONTACT - -Saudi Arabia - Khobar Experienced Planning Engineer with a proven track record of utilizing Primavera P6 to drive project success. Skilled in data analysis and automation using cloud-based systems, with a strong focus on data visualization using Power BI. Committed to delivering results and driving efficiency through the use of technology and innovative solutions. linkedin.com/in/ashfaq2ashu/ SOFTWARE Planning Scheduling Data Analysis Data Visualization using Power BI Primavera P6 Level 4 Scheduling E X P E R I E N C E Schedule monitoring Performance measurement Lead Planning And Scheduling Engineer Earned value analysis MIA Arabia Company - Al Khobar, Saudi Arabia Delay Analysis Detailed Schedule Analysis Microsoft Excel Power Query & M-Code Advanced Excel Dashboard Reports Data Analysis Power BI Transform and model the data DAX Dashboards April 2019 to July 2024 (Present) Planning Phase: Defining the scope of work and developing work breakdown structures (WBS) and work packages for engineering, construction, and procurement. Defining detailed deliverables for engineering and procurement and developing planning packages with a progress measurement system (PMS) for construction in terms of Direct Man Hours, Procurement, and Engineering in terms of Cost and Indirect Man Hours respectively. Creating S-curves for engineering procurement and construction and overall project. Preparing narrative reports defining the procedures for development of progress measurement system. Developing a master schedule in Primavera P6 that incorporates all work packages. Creating data models for quantity, budget cost, man-hours and cash flow tracking. Developing a dynamic look-ahead template and sharing it with the project team. Creating master databases based on schedule and BOQ, creating a link between databases and daily reporting sheets using cloud systems for automatic progress updates. Preparing weekly, monthly, and progress reports. Monitoring and Control Phase: Photoshop Dashboard Preparation Info-graphics Logos Monitoring the progress of projects at different stages of development and preparing daily and weekly progress reports to ensure that the project stays on track. Proactively assessing progress and completion forecasts, identifying potential schedule delays, and providing solutions to mitigate any issues. OTHER SOFTWARE Google Sheet - Google Scripts SQL Python WordPress Figma VSDC EDUCATION Creating look-ahead schedules and monitoring critical activities based on the project schedule, using Rolling Wave Planning to stay ahead of potential delays. Demonstrating a strong proficiency in Earned Value Management, forecasting the ETC (estimate to complete) at any stage of the project. Preparing Time Impact Analysis reports by inserting delay fragments into the P6 schedule and analyzing the impact on the project timeline. Developing Delay Justification Reports that clearly show the variance caused by the contractor side, to provide transparent reporting to all stakeholders. Preparing Delay Analysis - for the submission of EOT Claims Data Analysis/Management Report: XII-PHY MATH CHEM & STATS Standardizing templates and formats for data collection, and sharing them with different departments to gather the data. Cleaning and transforming collected data using Excel and Power Query for analysis and reporting. Preparing management level portfolio dashboard reports, encompassing Earned X - SCHOOLING Value Management (EVM), procurement status, manpower and equipment status, and cash flows using visualization tools like Power BI. Strong knowledge of statistical analysis and data mining techniques, ability to MECHANICAL ENGINEERING (B.E) CERTIFICATION Google Data Analyst Primavera P6 - Oracle Six Sigma Statistics PG in Piping Engineering AutoCAD i-Point INTEREST Reading Internet Survey Math LANGUAGE English Hindi Arabic PUBLISHING American Journal of Materials Science Fabrication and Characterization of an Eco-friendly Biodegradable Epoxy/Chitosan Composites perform data analysis and interpretation. Identifying patterns, trends and insights in large datasets, and presenting them in a clear and concise manner. Communicating data findings and recommendations to stakeholders. MAJOR PROJECTS HANDLED Prepared more than 100+ schedules in Primavera P6, including baseline, recovery, and revised schedules. E X P E R I E N C E COUNTRIES Planning Engineer SMEC - India Saudi Arabia Bahrain India CERTIFICATION Jun 2018 to Mar 2019 Prepare Primavera P6 project schedules, including Work Breakdown Structure (WBS), activities, logic, and activity coding to an appropriate level of detail for effective project and program management. Monitor and report on progress against the plan and make changes as required. Liaise with Lead Engineers to obtain progress updates and identify potential variance issues. Familiar with and capable of using tools such as engineering progress and measuring programs to produce plans. Provide the Project Manager with clear and concise progress and variance reports to enable accurate and timely client and internal reporting. Manage baselines and implement change control on the project schedules in PRIMAVERA P6 ORACLE DATA ANALYST GOOGLE conjunction with the wider project controls system. Critically review consultant and contractor programs to ensure logic and alignment with project objectives and key dates. Incorporate appropriate contractor summary activities into program schedules. Work with the Project Manager to ensure all change notices are addressed in a timely manner by coordinating the resources to address the change and track the associated cost. Develop and manage project schedules throughout the full project life cycle with an understanding of engineering, consenting, procurement, logistics, and construction activities associated with multi-discipline engineering projects. Lead project planning workshops with the project team to obtain the required information for schedule development. Analyze programs to critically comment on logic, sequence, and task duration and review and analyze programs to identify solutions and strategies that can optimize or reduce program duration, provide recovery options for program delay, and mitigate future project program risks. E X P E R I E N C E Scheduling Engineer Konkan - India POWER BI MS & LINKEDIN 6 SIGMA AVETA Jun 2017 to Jun 2018 Develop project schedules using Primavera P6 software, ensuring accuracy, completeness, and compliance with project requirements. Conduct schedule analysis to identify potential issues, risks, and opportunities for improvement, and provide recommendations to the project team. Work closely with project managers and stakeholders to develop and maintain project schedules, and ensure timely and effective communication of schedule updates. Collaborate with other members of the project team to integrate schedules and ensure consistency across all project activities. Create and maintain project dashboards, reports, and other documents using Excel, and provide regular updates to project stakeholders. Develop and maintain resource-loaded schedules, and assist with resource planning and forecasting. Participate in project meetings, and provide schedule updates and analysis as required. Identify and escalate issues or risks that may impact project schedules or budgets, and work with the project team to develop mitigation strategies. Continuously improve scheduling processes and tools, and implement best practices to enhance project performance and efficiency.