Raghav K Email & Phone Number

United Kingdom

Bangalore

Upstream Production & Production Operations Data Platform Development for Far-East & Middle East Energy Majors• Performed a multi-faceted role as a Domain Consulting Lead, Data Modeller, Informatica & Azure Technical Manager & Client Engagement Manager for a complex Digital Twin programme in the Production Operations space.As Domain Consultant: Performed Business Analysis of time-series sensor data from Aspentech IP21, Cognite Data Factory, Caterpillar Solar Insight, Production Deferment data from Energy Components, Maintenance & Materials data from SAP PM & MM modules. Designed business queries to ingest history & incremental data from REST API, ODBC, SQL Server, Oracle, SOAP API & File data sources.• As Data Modeller: Created a bespoke Data Model for Upstream Production Operations to emulate the Microsoft Common Data Model. Created Conceptual & Logical models for Asset, Production, Location, Maintenance & Operations Business Areas & related Data Families & created the related Physical & Dimensional Data Models for ADLS Curated Zone & Synapse Conformed Zone.• As Technical Manager: Created guidelines for handling inserts, updates, deletes for master & transaction data on ADLS Parquet layer & Synapse Dimensional schema layer including data persistence, versioning, managing SCD types & late arriving facts, parquet partitioning & data distribution on Synapse. Assisted Informatica IICS & Azure developers in creating expressions & transformations to achieve data loading as per these standards.• As Technical Manager: Created execution plans & drove simultaneous delivery tracks, managing a 10-member team of Informatica IICS Developers & Admins, Azure Data Architects & Testers.• As Client Engagement Manager: Drove all levels of client touchpoints for Wipro – stand-ups, technical reviews, sprint reviews & Programme Management meetings. Was the single point of decisions from Wipro for Client Business Owner, Product Owner, data source & data consumer teams.

Greater Bengaluru Area

Designed an SQL Server based Operations Data Store (ODS) for Upstream Oil and Gas data.Designed staging and curated zone data models based on data & reporting requirements.Created business queries and performed data ingestion optimization to ingest and transform data using SSIS ELT pipelines.

Bangalore

For US Based Oil & Gas Supermajor at Infosys Technologies – India• Identified Automation opportunities & other cost optimization opportunities by extracting insights from ITIL (Service Now) ticket data using Pareto Charts, Word Cloud Analysis, Heat Maps, Trend Charts, etc. in Power BI.• Experienced in Oil & Gas reporting – Production reports, Drilling Performance, Field Activities, AFE & Costs, basic SAP reporting, KPI reports for org performance and PMO governance reports.• Queried a wide variety of structured & unstructured data sources – Service Now REST APIs, Azure DevOps REST APIs, SQL Server TSQL, Excel and SharePoint Lists and created Date Tables & other lookup tables using Power Query to create strong data models for reporting.• Adept at data extraction, transformation and clean-up using TSQL, PL/SQL, Power Query, DAX, Excel commands & formulas and Regular Expressions.• Experienced with full gamut of Power BI service options – publishing apps, scheduling, subscriptions, dashboards, security, licensing and SaaS & PaaS data connections.

Bangalore

Augmented client PMO using standardized processes and templates.Improved project data capturing and reporting by implementing latest technology standards such as SharePoint Project Online, Power BI, custom SharePoint pages and Excel automation.Created powerful, interactive visualizations in Power BI to drill into project status related data and provide data insights.

For US Based Oil & Gas Supermajor at Infosys Technologies – India• Managed a variety of Azure projects including migration & re-architecting of legacy apps to utilize Azure PaaS & SaaS offerings effectively, development of AngularJS, ReactJS apps, Swagger & other REST APIs utilizing Azure DevOps GitHub repos, deployment & maintenance using CI/CD pipelines & Azure App Insights.• Utilized Agile Scrum techniques, Office 365 toolset and Azure DevOps to execute continuously developed & simultaneously supported projects for Oil & Gas Upstream.Build, Configuration, Architecture and Support of IT tools & technologies in the Oil & Gas Domain.Designing business processes in Upstream Oil & Gas E&P and implementing technologies to enable them.Domain tools deployed and supported - FlowCal, Energy Components, Landmark EDT, Landmark Decisionspace Geosciences, IHS Petra.

Houston

IT Consultant with Infosys for BP, worked on Hydrocarbon Accounting (HCA) and Upstream Data Management. Configured and implemented of AGA recommended solutions for Natural Gas Measurement and HCA, based on upstream network configuration.Domain tools supported - FlowCal, Energy Components, OSI PI.Configured, deployed and supported monitoring applications for Deep Sea and Shallow Water OIl drilling.Drilling tools & techs. - Kongsberg Sitecom, WITSML, PPDM, configuration of Rig servers, Rig to Onshore data transfer.Past Projects with Infosys (2005-2009, Mysore, India):Developed Internal Change Management software for BP - C#, ASP.Net, Oracle PL/SQL.Multiple projects for Insurance majors - Northwestern Mutual, Allstate - using VB, VC++, ASP, Oracle PL/SQL.

Mysore, Karnataka, India

Developed Internal Change Management software for BP - C#, ASP.Net, Oracle PL/SQL.Multiple projects for Insurance majors - Northwestern Mutual, Allstate - using VB, VC++, ASP, Oracle PL/SQL.