Biju J Ampattu

Email adif9o@r.postjobfree.com

Contact : ***-587-***-****

Location: Calgary Alberta

Residency Status: Canadian citizen

Summary of experience/Skills

Supervisory experience

•Managed interfacing with engineering group, procurement group, construction group, subcontractors, vendors,clients etc.

•Handled the project for management /client reporting.

•Performed mentoring for juniors in both technical and soft skills

•managed time & material contract, cost reimbursable as well as LSTK type contract

•managed revenue, P&L, cost, time, risk for project.

•Total experience of 25years +. Can handle independently functions like t cost planning, cost control, estimating, risk management, contract administration.

•Exceptional knowledge in handling big data sets to tailor into project reporting ; which can be from multiple data entities.

•Having a good experience in situ & oil sands projects.as well pipe line projects

•Experienced in working with both owner/operator & EPC companies.

Cost Management skill

•code of accounts developments,Budget development from Target price

•Define & perform earned value for both reimbursable & lump sum jobs, Define & perform productivity calculation- for both reimbursable & lump-sum Jobs

•Define & perform cost forecasting- for both reimbursable & lump-sum Jobs, Invoicing( Invoice verification, submission, follow up & approval from client)

•Define & perform change management( trend & changes order preparation, follow up & approval from client)

•Margin analysis & Margin status ( YTD,ITD- Margin, reporting period margin, comparison with target both In $value & % basis.

• Performed cost variance analysis, quantity variance reporting, project financial status report and assist Project managers data analytics on actionable intelligence in projects.

•Timesheet coding, time sheet verification, cost code corrections, project reconciliation /Close out WRT to time sheeting & cost coding.

•Managing risk register

•Good understanding of PMI,AACE,GAAP,SOX requirements and guidelines.

Data Analyst/Data science

MS Excel & Associated Packages in Microsoft office application environment for Data analysis.

VBA, C++, SQL,Post gres-SQL SAP, Oracle, shell scripting

Python & Related packages( see below package for details) for Data analysis.

Data Preprocessing, Data wrangling,Statistical Data modelling, Data visualization,Performance tuning.

Creating data models,Working with DAX in power BI,Visualizing data

Updated with latest trend in Data analysis/Big data/ Data science/ Deep learning market place, well versed with web scraping used to assist information /knowledge search/research.

Project Management Systems

•Hands on experience in developing the control Budget from cost estimate.

•Hands on experience in assisting the development of PEP

•Hands on experience in assisting the development of PCP

•Hands on experience in base lining the Cost & Time Plan.

•Hands on experience in developing, implementing, managing schedule Level 1, Level 3 schedules.

•Defining & implementing Project Code of accounts from Organisational code of accounts.

•Integrating schedule & Cost reporting requirements from subcontractors to Master time schedules & Periodic cost reporting to have Integrated reports for the Projects

•Managed subcontractors in Both Lump sum & cost reimbursable type contracts.

•Reconcile all COA elements in Projects for projects close out.

•Preparation of lessons learned summary for project controls.

Estimating Management skill

•Performed estimates for engineering & construction WRT quantity, labor, equipment & materials, cost allowances and contingencies.

•Performed estimates for both lump sum and cost plus jobs.

•Hands on experience in developing estimating Class 4,Class 3,Class2,Class 1

•Performed materials take off for bulks (Steel, Pipes, Cables etc) to put up estimates together.

•Handled a team estimators for putting up together estimate & forecasting.

Microsoft Excel skills

•Handling data from multiple data sources in excel & make meaning full presentation.( Performed Integration of data from oracle & legacy systems from Organization, Performed Integration of data from SAP & legacy systems from Organization).

•Detail-oriented, competent, 'Excel Programmer' with hands on experience in writing code for Excel macros, maintaining database. Expertise in ensuring updated data records and preparing apt reports with the help of formulas.

•Adept in developing programs using different languages, including C++, python, Power Shell, SQL, Excel VBA, SQL according to project requirements.Excellent understanding of software development life cycle. Advanced Knowledge of Oracle, MySQL,SAP,Postgres-SQL and shell Scripting

•Skilled in loading and extracting data from databases into worksheet.Ability to document test events and coding details.Adept in troubleshooting technical problems and creating Excel templates.Provide assistance for solving technical problems.Remodelled user-defined functions and tabs for different instructions

•Worked as per project requirement to design and program scripts to load historical data and monthly data into database.Performed routine data standard requests to ensure accuracy and confidentiality of the data.Query & analyze aggregate data: with excel & pivot table mastery.

•Complete knowledge of Excel functions and macro programming.Expertise in SQL server database design and development, capable of maintaining clean, accurate, and updated data records.

Microsoft Access skills

•Handling data from multiple data sources in excel & make meaning full presentation.( Performed Integration of data from oracle & legacy systems from Organization, Performed Integration of data from SAP & other data legacy systems from Organization.

•Created own Automated for reporting system in Project controls

•Usage of advanced VBA,VBScripting,

•Demonstrated above mentioned skill in a project control environment to make meaning full data analytics.

•Used all functionality in Microsoft Access for optimal use of data compilation.

Oracle skills

•Worked on the following modules such as Accounts Payable, Accounts Receivable,GL,HR, Oracle Projects, Oracle purchasing

•With user documentation of oracle will be able Extract data from Oracle and prepared many useful reports by integrating data from Oracle, Legacy systems for project monitoring & Project controlling.

SAP Skills

•Worked with FICO, MM, HR, Projects module in SAP.

•Trained as developer in SAP

•With user documentation of SAP, can Integrate data from SAP & organisation legacy systems for useful reports in project monitoring & controlling.

Primavera

•Using Primavera since 1995 .

•Developed schedules level 1, level 2, level 3, level4 schedules.

•Can use API. as well pass transfer data between Primavera & other Legacy application bidirectionally also use the same data for Data analysis.

•Performed resource loading,update and maintain resource loaded schedule.

Reporting

•Performed & Managed Biweekly, Monthly, Schedule updates.

•Performed & Managed Biweekly, Monthly, Quantity reporting.( Man-hours & Bulks).

•Performed & Managed Biweekly, Monthly, cost reporting.VAriance reporting,Margin analysis,Average Dollar per hour cost etc.

•Performed Biweekly & Monthly, Project reporting, Project Narrative, Project Presentation both for Client & Management.

Organization Currently /Worked for: SNC-Lavalin,PCL,Worley Parsons,Bechtel,Alstom,ABB

Roles can be handled independently

Planning,Costing,Estimating,Risk management,Contract administration

Details of Projects Handled

Organization role in the contract: Shell De bottlenecking Jackpine & Muskeg mine & Miscelleanous Projects

Employed Organization Jacobs Engineering

Period 2016 Feb – 2020 Aug

Customer : shell

Designation/Title Project control Manager

:

Organization role in the contract: FEED for PetroJunin,petro Urica,Petro Miranda.

Employed Organization SNC-Lavalin Period 2014Oct– 2016 Jan

Site name Petro Junin Customer : PDVSA

Designation/Title Project control Manager

Scope: CPF Well pads and associated piping

Organization role in the contract: Cold Lake and Polaris pipelines in Alberta.

Employed Organization :: Aecon Period 2013Apr – 2014 Oct

Site name Cold Lake and Polaris pipelines Customer : Interpipeline

Designation/Title Project control Manager

Scope:Aecon and Somerville joint venture was awarded for the installation of 560kms of underground pipeline to expand the two pipelines. the Foster Creek extension will be twinned with a new 36-inch diameter pipeline and the Cold Lake mainline from La Corey to Hardisty, Alta., will be twinned with a new 42-inch diameter pipeline.

Organization role in the contract: LSTK of Utilities plant,pipe rack,Electrical house.

Employed Organization: PCL- Industrial Management Edmonton - Canada Period 2010 Nov – 2013-March

Site name Kearl Oil Sands Project Customer : Imperial Oil

Designation Project control Manager

Scope: General contractor for Utilities silo civil mechanical electrical and instrumentation works for utilities plant Scope also includes associated pipe rack modules E house associated equipment . contract value was close to $ C 700 million,

Organization role in the contract: cost reimbursable job for sustaining Project of scottford Upgrader

Employed Organization: PCL- Industrial Edmonton - Canada Period 2008 August– 2010 Oct

Site name Keystone Oil Pipeline project between Hardisty and Bindlos Customer Trans Canada

Designation Project Cost Lead

Scope: Keystone Oil Pipeline project between 5 sites between Hardisty and Bindloss construction activities had stretched across 300 kilometers (dia 30 in ).PCL was the full general contractor with pipe spool fabrication,stringing, welding,coating inspection testing, also installation of associated 5 pump stations and misc works

Organization role in the contract: cost reimbursable job for sustaining Project of scottford Upgrader

Employed Organization: WorleyParson Edmonton - Canada Period 2007May– 2008July

Site name Suncor- Firebag Customer Shell

Designation Project Controls Lead

Scope:Firebag well Pads project to help deliver increased bitumen supply from Suncor's Firebag facility near Fort McMurray in Alberta, contract scope include C$190 million engineering, procurement and construction

Organization role in the contract: JERP - Captive power plants + Miscworks

Employed Organization : Bechtel Period 2004 October- 2007 April

Site name JERP - Refinery, Jamnagar, India Customer Reliance industries Ltd

Designation Project Controls Lead

Organization role in the contract: EPC for DHDT

Employed Organization: Larsen & Turbo. Period 2002 June - 2004 October

Site name Indian oil corporation Panipat - Refinery, India Customer Indian Oil Corporation

Designation Senior Planning Engineer.

Organization role in the contract: EPC for Solvent De-waxing unit

Employed Organization: Larsen & Turbo Period 2000 Jan - 2002 May

Site name Indian oil corporation - Digbhoi refinery, India Customer Indian Oil corporation

Designation Cost Engineer

Organization role in the contract: PMC

Employed Organization: ABB-Lummus Period 1997June to 1999 December

Site name Essar oil - Vadinar refinery Customer Essar oil

Designation : Planning Engineer.

Organization role in the contract: LSTK of EPC for Power Plant

Employed Organization : ABB Period 1994May -1997 June

Sitename 657MWJhanoor Gandhar CCPP Customer National Thermal Power Corporation

Designation : Field Engineer /Commissioning Engineer./ Warranty engineer.

Organization role in the contract: EPC of Power Distribution package

Employed Organization: ABB Period 1991 December – 1994May

Sitename Durgapur steel Plant Customer Durgapur steel Plant

Designation. EIT / Field Engineer

Educational Qualification: Bachelors- of Engineering in Mechanical Engineering REC Calicut

Contact this candidate