PRABHAT RANJAN
Email: adnjm9@r.postjobfree.com Phone: (M) +91-992*******
professional experience
Shree Shubham Logistics ltd – A Kalptaru Company (September 2018 - Till now) Business Analyst/research
Design,Create and maintain application/Database as necessary to support analysis and modelling of such topics as agriculture commodity-warehouse, supply, demand, price, finance, and corporate strategy
Managing and updating data through primary and secondary research for agriculture commodity and ensuring that the information captured for each asset in the database is accurate and updated.
Preparing the reports monthly and quarterly on the basis of data maintained for clients.
Forecasting of market trends for agriculture commodity
Providing support to business user on the process/projects
Detailed market study to analyse the latest market trends in the Indian agriculture commodity.
Tracking of agriculture commodity warehouse regulations & guidelines.
Design and created of knowledge database interface for the agriculture commodity/warehouse
Crisil (S & P Company) - Platts (Feb 2016 – August 2018) Senior Analyst
Well View Tool: Using Well View, We manage complete corporate well file, tracking all changes and operations throughout the well’s lifecycle—from planning to abandonment.
Rig View Tool : Using Rig View tool, We manage a rig and well project scheduling system capable of managing well workloads such as drilling, completions, workovers, fracs and testing.
Implemented the economic analytics tool technology.
Working on application such as Opylnx, factiva, bloomberg to smooth the functioning of the organisation
Researching, data collection, data analysis, managing, updating oil and natural gas data of North America shale plays using well economic analytics tool.
Researching and data gathered for US shale basin using quarterly results, company presentation, transcript and also using the analytical/database tool such as PLS docfinder, Bloomberg, Factiva.
Maintain the data quarterly such as drilling and completion cost, lateral llength, proppant, acreage,
LOE, Production and EUR etc. For basin company wise.
Do quarterly comparative analysis for basin company wise and make the report based on it.
Gathering business requirement and handling the stakeholders and provide them with regular/periodic analytics support
Computer skills –VB, SQL, MS Office Suite (Word, Excel and PowerPoint), Python, Opylnx, Tableau
Infraline Energy - New Delhi (Feb 2015 - Jan 2016) Business Analyst-II
Create and maintain databases as necessary to support analysis and modeling of such topics as natural gas supply, demand, price, finance, and corporate strategy
Researching, managing and updating gas exploration & production data ( wells, discoveries, block) Pipelines, Refineries and ensuring that the information captured for each asset in the database is accurate and updated.
Detailed market study to analyse the latest market trends in the Indian LNG sector.
Keep track of oil and gas regulations & guidelines.
Gathering required information to create interface for the oil and gas clients.
Designing and implementing oil and gas knowledge database interface for oil and gas clients and supporting team.
Man Industries Ltd., Mumbai (March 2014 - Jan 2015) Asst. Manager
Job Description:
Create and maintain databases for natural gas /LNG supply, demand, price, finance, and corporate strategy
Researching, managing and updating exploration & production (E&P) upstream Oil and Natural Gas / pipeline projects (Midstream) projects across the globe.
Providing support to Business Development, Presales team through data updates, presentation and reports.
Work on clients approval for supply of line pipe.
Study of natural gas pipeline tender and preparing technical synopsis & offers.
Maintaining the database for US LNG terminals.
Analytical/database tool: MEEDS, SIMDEX, Gulf Oil & Gas, FPAL, JSRS, OMAN, ISNET.
Keep track of oil and gas regulations & guidelines.
GlobalData (DMV Business & Market Research Pvt, Ltd), Hyderabad (Aug 2011 – Feb 2014)
Associate Analyst (Oil & Gas-E Track)
Key Deliverables:
Researching, managing and updating Oil and Natural gas (E & P)/Midstream database-Exploration, Production, Discoveries, wells, Pipelines and ensuring that the information captured for each asset in the database is accurate and updated.
Forecasting of natural gas price for financial model
Managing and tracking timelines to ensure timely updates of the E & P database as well as delivering information to clients.
Maintaining knowledge bank of Oil, Gas and Condensate production for monthly basis.
Economic and Financial Analysis of Oil & Gas field from complex fiscal regimes (Production Sharing Agreement/Taxation/Service Contract) in North Africa/European/Asia-Pacific/North American Countries.
Production forecasting of wells.
Preparing fiscal regime (Policy and Regulatory) reports.
Working on price benchmark for crude oil and gas across the globe.
SAP - IS OIL
Database Tools: Factiva
Core Competencies
Excellent Analysis, communication/Problem
Solving/Presentation skills.
Ability to lead and belong to a team or work
Independently without supervision, interact
With multiple cross functional teams at all levels
Of management
Ability to establish rapport with the customer and build confidence.
Focused and Detail oriented.
Proactive and Enthusiastic to learn new things.
Technical Proficiency
Hands on Experience SQL/Oracle, VBA.
Well versed with MS Word, Excel and Power Point.
Hands on experience in SAP-IS Oil and Gas (TD, TSW, PSA, and PRA).
Educational Credentials
MBA-(Oil and Gas) from University of Petroleum and Energy studies, Dehradun in 2011 with 76%.
Computer Engineering from Mumbai University (Mumbai) in 2008 with 63.12%
12th from Maharashtra Board with 63%
10th from Maharashtra Board with 68.93%
Professional Accreditation
Professional Petroleum Database Management Association
PPDM Certification - Business life cycle of a well (Planning, Drilling, Completion, Production, Decommissioning)
Academic Achievements & Activities
Worked on student database management project using VB.net and oracle.
Personal Details
Languages Known: English, Hindi and Marathi
Passport Number: H1571650
DOB : 03/10/1985
Reference: Available upon request