Rahul Madarapu adg8fx@r.postjobfree.com

+1-832-***-**** https://github.com/madarahr

Greater Houston Area https://www.linkedin.com/in/rahul-m-a2aa687/ DATA ANALYST / DATA ENGINEER / DATA ARCHITECT

Data Architect/Engineer with significant global experience within the Upstream segment of the Energy industry. Experienced technical advisor capacity with diverse roles such as Well Engineer, Technical Analysis, Business Development, and Project Management expertise. A committed professional who has a proven ability to initiate and execute innovative projects by leading multi-disciplinary teams in harsh business environments. Certificate in Data Analysis and Visualization from the University of Texas, Austin. Skilled in Python, SQL, MongoDB, Big Data with Spark, Machine Learning, and data visualization with Tableau. An advocate towards the use of Big Data and Machine Learning models to transform the landscape of decision making. HIGHLIGHTS

● Data mining, Data analysis, Data Visualization

● Python, SQL, JavaScript, Spark, MongoDB, Tableau, Big Data, Machine Learning (Supervised / Unsupervised)

● Crystal Ball, @Risk, Microsoft Office

● Compass, Openwells, StressCheck, Wellcat, Stringnosis

● Multilingual (Russian, Hindi, English, Telugu, Spanish Level II) EDUCATION

● Data Analysis and Visualization, University of Texas, Austin - 2020

● Master of Science in Petroleum Engineering, University of Alaska Fairbanks 08/1996 – 05/1998

● Bachelor of Science in Chemical Engineering, Osmania University, India 08/1992 - 06/1996 PORTFOLIO

● Predicting_Green_Energy – A machine learning model for a wind and solar farm in Texas and predicting the peak power output during the say based on weather forecast.

● Cryptocurrencies – An investment bank’s investigation into offering cryptocurrencies as an investment portfolio for its customers. Unsupervised Machine Learning using Python, sklearn, plotly, hvplot, matplotlib.

● Credit_risk – Using statistical information of loans and borrowers, an analysis of the prediction of low and high risk borrowers is made. Supervised Machine Learning using Python, Scikit-learn. Algorithms used were Balanced Random Forest Classifier and Easy Ensemble AdaBoost Classifier.

● Big_Data – From large datasets from AWS S3, perform an analysis using pyspark in Google Collabs on retail of sporting goods in the USA and presenting the results into PostgreSQL.

● Movies-ETL – Extract data from Wikipedia and Kaggle to perform an Extract-Transform-Load (ETL) process on the data using Python a load it into PostgreSQL.

PROFESSIONAL EXPERIENCE

08/2020 – Domain Expert Consultant, ONGC, India

Advisory role as an engineering consultant for challenging High Pressure and High Temperature (HPHT) drilling campaign in the Bay of Bengal.

10/2019 – 04/2020 Well Engineer Consultant, Shell, USA Front End Engineering and Well Design (FEED) for Deep Water exploration campaign in Mexico. 11/2013 – 05/2019 Senior Drilling Engineer, Repsol, USA Performed technical evaluations of opportunities for new ventures, acquisitions/divestment and farm-in/farm-out.

● Performed data analysis and developed Capital Expenditure (CAPEX), Operating Expenditure (OPEX) and Abandonment Expenditure for bid rounds between 2017 and 2018 resulting in acquiring 6 and 4 Exploration blocks in Mexico & in Brazil respectively.

● Developed a probabilistic methodology using Monte Carlo simulations to develop a project time and cost for business development opportunities.

● Examined several ‘Vendor’s Cases’ of numerous acquisition opportunities in detail and developed CAPEX/OPEX, liability costs and risks which led to company’s largest acquisition worth US$8.3 billion. 09/2011 – 10/2013 Drilling Engineer, BP, USA (Alaska) Analyze offset Wells for performance data, geological risks and applied drilling engineering of complex wells and input to ‘Major Projects’.

04/2008 – 08/2011 Drilling Project Support Manager, TNK-BP (JV of BP), Russia Evaluated key metrics (Key Point Indicators and performance) of drilling efficiencies and recommended application centered practices or technologies for improvement. Interfaced and made recommendations to executive team and initiated appropriate projects.

● Completed a $2 Million comprehensive study of Underbalanced Drilling (UBD) that included the largest ever pre-screening comprising of 321 reservoirs and ranked them based on applicability.

● Completed in-depth reservoir analysis and Basis of Design to ascertain if UBD is technically feasible and economically viable in 5 of the high ranked reservoirs. 05/1998 – 04/2008 Global Team Lead / Technical Advisor, Baker Hughes, Inc. Performed Applications Drilling Engineering to develop market driven strategy based on market research with Product Line Managers. Championed and advocated new technology products, managed technology & knowledge transfer by generating technical publications, best practices, and operational manuals. CERTIFICATIONS

● Well Control IWCF Level 4 Surface/Subsea Supervisory

● Basic Offshore Safety Induction & Emergency Training with Compressed Air Breathing System (BOSIET CA-EBS)

● Adult and Pediatric First Aid/CPR/AED – Red Cross

● Basic Incident Command System for Initial Response – IS-00200.c – Emergency Management Institute (FEMA) PUBLICATIONS

● Advances in Coiled Tubing Re-entry Access Bypassed Reserves on Alaska’s North Slope – SPE 107665

● Coiled Tubing Gyro MWD Improves Kickoff Direction Accuracy for Cased Hole Re-entry Drilling – SPE 106405

● Application Appropriate Drilling Tech. Excel in Managed-Cost Mature Asset Environments – SPE 104182

● A Simulation Study of Enhanced Recovery of Schrader Bluff Heavy Oil by Immiscible and Miscible Gas Injection

– SPE 76776

Contact this candidate