Venkatesh KN

Experience

• 

  Petrolink

  Dec 2012 - Oct 2021

  ● Performed Root cause analysis for about 1 million records of real-time data related to drilling. Teamedup with data engineers to understand the structure of data engineers and to understand the data andproactively shared jupyter notebooks on the prior basis.● Collaboration with the team to manage and implement solutions, and provide immediate decisionsrelated to clients. All the reports were being queried via postgres-SQL interface, and shared thereports in .xlsx format. Used Excel Vlookup for preparing reports and also used Python/Pandas toremove outliers from the data.● Facilitate application support to international clients ,from the US, middle east and Europe, viz. Oxy,Exxon, Chevron.● Real time delivery services and troubleshooting issues related to configurations and bugs. ● Alsoprepare essential KPI reports for clients and the business-team. All the live dashboards werePrepared in PowerBI and shared to the stakeholders around the globe Show less Supporting and coordinating with various global clients & Service Providers in transmission of LWD /MWD / Mudlog data streaming in as WITS/WITSML from rig site to the secured servers of the clients.Also, to track live data, we prepared multiple dashboards on powerBI for the purpose of analysis andreal time decision making.● Check the drilling data quality, report any abnormalities in it and notify the clients. ● Troubleshootdata transmission issues by working with various service companies to ensure constant real-time dataavailability. Also worked on fraud detection analysis, all the inferences were showcased in an PowerBIDashboard.● Prepared multiple dashboards for the clients for easy tracking of key-metrics ondaily/weekly/monthly basis.● The ETA for data analysis and reports was reduced from 1 day to 5 minutes, by introduction of BItools like PowerBI and DaX. Show less • Remotely supporting critical real-time data transmission from worldwide rigs for multinational client•Ensure quality of master data, particularly XML and Data visualization through Real-time viewer applications.•Provide quality assurance of imported data, working with quality assurance analysts if necessary.•Formulate calculations for Real-time data improvisation, replication of data to various production servers, carry out failover between servers, utility migration with data transfers.•Monitor production environment (applications) to proactively identify production issues.•Identified issues to be logged into Incident Management system (Jira) and tracked through the Incident life cycle. Show less

  • Senior Data Analyst

    Sept 2017 - Oct 2021

  • Senior Data Analyst

    Dec 2015 - Sept 2017

  • Junior real time admin

    Aug 2015 - Dec 2015

  • Junior real time admin

    Dec 2012 - Aug 2015
• 

  Standard Chartered

  Feb 2022 - now

  Specialist