Prashant Mane

I am a BE Mechanical Engineer with more than 5 years of experience in Oil and Gas industry Project Management Software called EPCPROMAN with implementation, Administration and end to end project management through software.

I was part of a Data team in my previous companies where I need to maintain data, share cleaned data to planning team for building final reports. I have experience of cleaning the data in excel extracted from software. I have very good knowledge of DAX functions, Power Query in Power BI. Also, I have experience of SQL select queries and stored procedures and Trigger Functions. I have knowledge of Tableau Visualization tool.

I have also experience of using MS Excel formulas such as VLOOKUP, Index Match, Pivot table, Sum if, Count if, Conditional Formatting etc. for cleaning data and make it suitable for final report building.

Dec 2021 - Feb 2022

Epic Piping LLC, Abu Dhabi – EPCPROMAN Software Administrator

• Lead Auto spool software team for generating Isometric drawings and generating various Engineering reports required for pipe fabrication industry. 
• Responsible for Total co-ordination with US team for receiving PCF files, Processing PCF files before importing, assigning work front to team for daily piping isometric generation in Auto spool, Troubleshooting Auto spool errors and data errors. 
• Data management for Auto spool software with respect to input and output.

Nov 2019 - August 2020

JEL Maintenance Pte Ltd, Singapore- EPCPROMAN Software Admin

• Lead member of company's newly formed Digital team by assisting and working with project team. 
• Conduct Auto spool, EPCPROMAN & Spool barcode Training to ensure increased productivity with the use of software in construction industry.
• Analyze Errors in Auto spool & EPCPROMAN Deliverable reports, and solve them in timely manner.
• Reporting to Management about ISO Drawings and SPOOL Drawings Receiving and Issuance Progress on weekly basis.
• Implementation of Spool Tracking through bar code.
• Create and Customize AUTOSPOOL and EPCPROMAN Project Setup suitable with 3D software extracted IDF's/PFC's, and also aligned with CLIENT and CONSTRUCTION team requirement. 
• Make customized reports in EPCPROMAN software as per project and planning team’s requirement and extract them in Excel and send them after data cleaning as per company’s internal reporting format
• Made Gantt Chart and S-Curve reports in PROPLAN software which is part of EPCPROMAN software suit. 

Jan 2019 – October 2019

Onshore Construction Company Pvt Ltd, Mumbai – Assistant Planning engineer EPCPROMAN

• Implementation and running of EPCPROMAN Software for the VGOHDT Project for end client IOCL Gujrat Refinery.
• Updating live status of all activities like fit up, welding, NDT etc. in the software.
• Preparation of Daily and Weekly progress Reports. 
• Feeding data to Billing team for preparation of Monthly RA Bill. 
• Identification of work front and planning activities in accordance.
• Cleaned data in Excel maintained by QC team and made the data in Excel which can be uploaded in the software and by doing this almost 2 years of backlog data got uploaded in the software and it helped to claim pending Bill as data was previously not present in the software.

Sept 2018 – January 2019

Concepts India Pvt Ltd, Mumbai – Site Engineer

• Supervising of workers for completion of work.
• Acquisition of drawing and related documents necessary for the work.
• Keeping maintain proper documentation of work completed.
• Understanding work constrains.
• Procurement of consumables and materials from stores.
• Day to day consulting with superiors for maintaining smooth running of project.

April 2016 – July 2018

Paras Cadd Pvt Ltd, Mumbai – Piping Engineer (EPCPROMAN Implementation)

• Training & Implementation of EPCPROMAN Software Suite on the client premises or on client sites.
• Responsible for Material Control and tracking using EPCPROMAN software in the AIR PRODUCTS Kochi Refinery project.
• Material Reconciliation done in Excel by extracting data from software.
• Remote support and troubleshooting issues related to EPCPROMAN software to clients in their projects.
• Cleared backlog of Six months data entry in software by making data suitable to upload in software by using Excel V-lookup and other formulas.
• Checking isometric drawings generated from software for quality of drawing and making record of them to ensure minimize the errors in future drawings.
• Project Support, troubleshooting software issues remotely for existing clients.

Feb 2012 – Feb 2013

Bureau Veritas Pvt Ltd, Mumbai – Third Party Inspector

• Third Party Inspection for various projects as per Bureau Veritas standard.

• BE Mechanical
• Microsoft Power BI Desktop for Business Intelligence, Udemy E-Learning.
• MySQL for Data Analysis and Business Intelligence, Udemy E-Learning.
• Procurement Management, Udemy E-Learning.
• SQL Essential Training, LinkedIN E-Learning.
• Excel Essential Training, LinkedIN E-Learning.
• SQL Basic Certificate - HackerRank