SUMMARY

• Over 10+ years’ experience in Oil and Gas Exploration, Production, Transport and Revenue Sharing; Hydrocarbon Accounting; Electricity Billing and Power Consumption Allocation; Geographical Information Systems (GIS); Oil Pipelines Data Management; Enterprise Data Warehousing and ETL; Data Science /Machine Learning; Business/ Artificial Intelligence; and Process Automation (Eclipse, TIBCO ActiveMatrix BusinessWorks, EC BPM)
• Over 10+ years of Information Technology experience in designing and developing wide range of Web - based software applications using API’s that integrate with VB.Net, WellView, ArcGIS, Visions, Spotfire, Crystal Reports, TOAD, Oracle Database, Business Objects, OSI PI, and SQL Server
• Possess expert knowledge of oil and gas production/ transportation allocation procedures and methodologies and over 10+ years extensive working understanding of leading industry-wide hydrocarbon accounting software packages such as Tieto Energy Components and Merrick P2 (Procount, eVIN)
• Strong knowledge of crude oil scheduling and nomination workflows, working with trading teams, shippers and terminal operations in coordinating crude oil/ LNG lifting, pipeline volume accounting, shippers’ production and lifting entitlements, cargo planning, managing storage and dead-stock inventories for various crude grades and blends, analyzing forecasts, and processing lifting and cargo documentations
• Good Understanding of Design, Development, Deployment and Distribution of reports and analytics using TIBCO Spotfire, Tableau, Power BI, Cognos, Info Desktop, Business Objects Enterprise XI and Crystal Reports with demonstrable expertise in database design including creation of tables, schemas, views, stored procedures and triggers in Oracle, OSI PI and Microsoft SQL Server environments and proven implementation experience in Data Warehousing, Data Management and Extract-Load-Transform (ETL) methodologies
• Broad technical know-how in gathering and translating customer requirements into technical specifications, developing documentations, publishing, and sharing project files in Microsoft SharePoint
• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems
• Experience in the translation of complicated enterprise specific business rules and procedures into appropriate business logic components such as code libraries, stored procedures and security models
• Effective leadership skills in mentoring junior staff, developing human capacity, demonstrating capital stewardship, and sharing of knowledge among team members within the organization
• Focused, detailed, technology-driven, people-oriented and self-motivated team player
• Strong interpersonal and customer interaction abilities with demonstrable verbal and written communications skills to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Databases & DBM Environments: MS SQL Server, Oracle, Microsoft Access, Oracle ADF, Oracle SQLDeveloper, TOAD

Data-warehousing: OLAP, SQL data transformation services (DTS), ETL

Reporting Tools: Microsoft Reporting Server, Business Objects XI, Crystal Reports XI R2

Geographical Mapping Tools: ArcGIS, ArcMap, Flex, Silverlight, Web ADF, ArcSDE

Oil/Gas: Tieto Energy Components (Production, Transport, Revenue-Sharing modules), Avocet, Metegrity Visions, WellView, ProSource, Open Pipelines Database (PODS)

Enterprise Resource Planning Tools: JD Edwards

Visualization and Analytics: TIBCO Spotfire, Cognos, Xcelsius, Visual Studio Chart, OWC 11, Tableau, Micro-Strategy

Programming Languages: Visual Basic, Java, SQL, PL/SQL, T-SQL, ASP, ASP.Net, Iron Python, VB.Net, C#, R

Web Technologies: HTML, VB-Script, JavaScript, DHTML, XML, Ajax, ColdFusion, CSS

Microsoft Office Technologies: Word, Excel, PowerPoint, Access

Cloud Environments: Amazon AWS, Microsoft Azure

PROFESSIONAL EXPERIENCE

Confidential, Spring, TX

Production/ Entitlement Data Analyst

Responsibilities:

• Coordinating the upgrade of Tieto Energy Components from version 8 and 10 to version 11.2 for Confidential ’s Chad-Cameroon, Papua-New Guinea and Gorgon, Australia operations to use new functionalities and features for oil/ LNG transport management
• Developing crude oil lifting scorecard in Spotfire to analyze missing data and other validation metrics prior to generating lifting program for joint venture partners in Confidential ’s Chad-Cameroon operations
• Developing Spotfire application for analyzing transported crude oil volumes, showing daily entitlements, allocated production, dead-stock share, and opening and closing balance for shippers and joint venture lifting accounts
• Writing R scripts and Python scripts to transform and format data, create statistical analysis, and display key performance indicators
• Designing and implementing automated well test validation, 36 Hour LNG Cargo Departure Notice, and production allocation data validation processes using Eclipse IDE, TIBCO ActiveMatrix BusinessWorks and EC BPM for Confidential ’s Chad, Australia, and Papua New Guinea operations
• Writing complex PL/SQL packages, triggers, functions and synonyms to handle sub-routines, oil, water, gas allocation logic using TOAD and Oracle SQLDeveloper;
• Creating classes, tables, views, materialized views, database links, and indexes in Oracle database using TOAD and Oracle SQLDeveloper
• Utilize TIBCO Spotfire and macro-based Excel spreadsheets to create interactive user-interfaces that provide insights (dashboards, analytics and reports) such as lifting account entitlement charts, period process train storage yield plots, daily rundown actual versus forecast analytics, and other crude pipeline transportation metrics and performance indicators. Also scheduling data updates and publishing dashboard on Spotfire Webplayer to allow business users consume analysis on the Web

Confidential

Technical Architect

Responsibilities:

• Interfacing Tieto Energy Components with Aviva - Confidential ’s plant-equipment management system to identify equipment and instrumentations that have impact on field production using Extract-Load-Transform (ETL) procedures
• Creating TIBCO Spotfire user-interfaces to provide insight (dashboards/ report) on plant-equipment operations and associated severity of equipment downtime on oil/gas production, scheduling data updates and publishing dashboard on Webplayer
• Writing Python scripts in TIBCO Spotfire for extracting XML and RSS data into Spotfire, dynamically connecting to enterprise data warehouse using Information Designer, scheduling data updates, creating pivot tables using Transformations, handling complex processes including dynamic pages navigation, custom filtering and marking
• Writing R scripts in TIBCO Spotfire using TERR to compartmentalize oilfield equipment data, and use Apriori and Eclat algorithms to establish pattern of association between two or more equipment failures
• Using predictive and prescriptive analytics to model the probability of equipment failure, associated production downtime, and recommending preventive intervention/remediation
• Writing logical layer algorithm in C# using TIBCO Spotfire API for simulating the structures of downhole equipment and wellbores in 3-dimensional space. Created high-speed zooming, panning, and rotating features and other functionalities

Confidential, Houston, Texas

Energy Components Support/Data Analyst

Responsibilities:

• Configuration of volumetric and mass allocation algorithms, rules and formula in Energy Components for determination of equity on wells and reservoir assets
• Set up of Energy Components allocation network for producing assets including wells, sand-reservoirs, completion/completion-intervals, facilities classes (platforms/manifolds/jackets) and terminals
• Audit data entered into Energy Components by field staff for accuracy and completeness using automated scorecards, verify authenticity of well test and reservoir parameters data, and run daily and monthly production allocation procedures
• Created hydrocarbon Production Reports, Well Test Reports, Asset Management Reports, Operations Reports and Engineering Reports with parameters, cross-tab objects, Charts and OLAP cubes using Crystal Reports XI R2
• Created Oil and Gas Production Accounting and Revenue reports for Confidential ’s profit sharing contract and Joint Venture operations in Nigeria
• Collaborated with a large team of IT professionals from Confidential ’s Energy Technology Company (ETC) in Houston on installation, configuration and upgrade of Energy Components
• Served as the production reporting subject matter expert (SME) and primary contact on Crystal Reports
• Provided day-to-day technical application support of Energy Components to end users
• Interfaced with Production Allocation, Asset Management, Commercial, and Finance team members and other users to gather requirements and specifications for reports - creating comprehensive Design Documents, flow-charts, templates and models for the reports
• Developed program in Visual Studio 2005/2010 for extracting oil and gas production and well test data from Energy Components Oracle database into XML and transmitting the XML data on the World wide Web into the Nigerian National Petroleum Production database to facilitate Confidential Nigeria’s compliance with regulatory requirements of online submission of production data

Confidential

Responsibilities:

• Created SQL Queries that extracted production, injection, well test, pressure and reservoir characterization data from Tieto Energy Components’ Oracle, OSI PI historian, and financial data from JDE Enterprise One databases using TOAD, SQL Server, Oracle SQLDeveloper and Oracle ADF
• Developed Data Warehouse and Extract-Load-Transform (ETL) models to enable streaming of data from Energy Components, OSI PI and JDE database to an integrated SQL Server database and configuring the procedures for nightly and monthly builds
• Designing high-end analytics showing monthly production and injection rates, cumulative volumes, gas-oil-ratios, percentage water composition, well count, 3D wellbore trajectories, surface maps, productivity index and pressure draw-down using TIBCO Spotfire
• Connecting to WellView and ArcGIS API’s to render well schematic diagrams and spatial maps of oil pipelines on Web interfaces; and using Data Warehousing techniques to link pipeline data in Visions to spatial data in ArcGIS and to production data in Energy Components to report, analyze and spatially render daily flow rate and repair information of surface and sub-surface assets
• Developing custom controls and functions in Spotfire and Visual Studio for retrieving image files (surface maps, well schematics, well logs and stratigraphic sections) stored in SharePoint for petro-physical and geological applications
• Writing logical functions in C# using TIBCO Spotfire API and d3 programming framework to simulate 3-dimensional well trajectories, well schematics and drilling formation zones
• Applied development methodologies and developed strategies for feasibility analysis, flowcharting, project sizing, quality assurance, documenting, coding and testing of Spotfire application projects for diverse functional groups
• Applied Lean Sigma methodologies in identifying opportunities for streamlining workflows and processes in oil and gas exploration and production
• Co-ordinated functional requirements gathering for Business Intelligent solutions
• Co-ordinated corporate-wide standardization of reports and analytics by defining design specifications, templates, security and change management processes

Confidential

Responsibilities:

• Supported the full software development lifecycle of Confidential ’s geospatial applications especially in front-end development using Visual Studio .Net and Silverlight
• Worked extensively with ESRI ArcGIS Web tools like Web ADF, JavaScript, Flex, REST and Silverlight Web Mapping components to create interactive Web-based mapping applications showing the geographical locations of oil and gas pipelines in Confidential ’s Nigeria/Mid Africa operations
• Collaborated extensively with GIS analysts using the typical core ESRI ArcGIS client geospatial framework; developed, maintained and published map services; and provided support to GIS server environments
• Developed Entity Relationship and Extract-Load-Transform (ETL) models to enable integration between the database for pipelines (Visions) and the database for oil production (Energy Components) in order to adequately report the volume of hydrocarbons passing through each pipeline
• Responsible for creating and maintaining the standard for naming pipelines, flow-lines and risers in Confidential ’s Nigeria operations
• Developed Web applications used by Confidential Nigeria’s Construction Services and Offshore Construction groups for capturing daily repairs carried out on pipelines, and created Web services that enabled multiple systems to interoperate and share information across the enterprise
• Analyzed and reviewed the Pipelines Open Data Systems (PODS) to determine database structures and entity relationships for oil pipelines in Confidential Nigeria
• Utilized GIS systems like ArcGIS, ArcServer and ArcObjects in creating geographical map layers and supported Upstream ArcMap systems