Manager Data

*

Sohail Iqbal Mob: (+***) – ********

Doha, Qatar Email: ***********@*****.***

* My job was made redundant due to COVID-19/Oil & Gas price crash. Objective

An E&P Information Solutions professional with 15+ year of experience seeking an opportunity to apply and further develop my skills, technical expertise, and experiences in managing and supporting IT solutions in the domains of wells, subsurface, and production.

Profile Summary

Experienced in managing wells and subsurface applications portfolio, including gathering users’ requirements and understanding them from the business perspective, proposing IT solutions, handling users and vendor communication, managing queue of users’ requests, troubleshooting issues, managing application licenses, handling coordination between local IT and the global IT support to ensure applications availability and reliability.

Competent and experienced in production operations data management workflow implementation for the upstream oil and gas industry, from data collection from the field (automatic data acquisition from data historian or manually input data by operators), data quality checking, data processing, data access and security, data reporting and visualization, and linking to petroleum engineering applications, where the goal is to reduce time spent in data collection and consolidation, allowing petroleum engineers to put more focus and spend more time on production analysis. This also includes implementing and executing back allocation workflow, and production loss management.

Experienced in performing issue identification, troubleshooting, problem solving, analysis, and pro-actively prevent possible issues and identify areas for improvement related to production operations data management and reporting, therefore ensuring that the daily and monthly reports are delivered on-time to the oil company organization, government and partners.

Demonstrated experience in integrating production data management with automated data acquisition, production monitoring workflows such as well status detection, well production estimation calculation, production back allocation, loss management, gas lift optimization, and data feed to production engineering software, well and network models, data visualization and reporting dashboards, and automatic alarm notifications, forming a complete Digital Oil Field solution that enables exception based production surveillance.

Demonstrated experiences in performing assessment of user requirements through discussion and interviews with engineers and operators, designing the solution, establish role and responsibilities, define standard operating procedures and performing implementation.

Demonstrated experience in evaluating wells and subsurface applications, to grasp understanding of the current technical configurations, user requirements and expectations, and the cost associated with maintaining the solutions, to contribute to the organization’s effort to understand and inventory its applications portfolio, to define the way forward for each application to reach strategic alignment with the organization’s objectives.

Experienced in handling data transfer, query, loading, and reporting by means of database tools (Oracle PL/SQL, SQL Server T-SQL), reporting/dashboard tools (Tibco Spotfire, PowerBI, Biztalk, SQL Server Integration Services & Reporting Services, Crystal Report), and other tools (such as excel VBA).

Experienced in delivering trainings of data management system and reporting tools to both general users and administrators. Architected/designed systems and their disaster recovery plans. Key Skills

Production Data Management System Specialist DOF & Realtime Systems Expert System Design, Implementation, Administration & Support Full Stack Developer and SME Data Analysis/Integration/Reporting Application Programming/Maintenance/Bug Fix IT Software Project Management Business/System Analysis 2

Experience

1. Qatar Petroleum – Qatar, Doha. Oct 2019 – Jun 2020 Sr. Systems Engineer (Subsurface & Production)

Interacted with user communities in the field operations and reservoir domains to gathered user requirements, identified the gap, and proposed solutions. Managed enhancement requests and projects, supervised and provided technical guidance on the implementation.

Coordinated with the embedded support and communicated with vendors to ensure applications availability and functionality for the users. It is achieved by ensuring databases, servers, interfaces, client installation and setup, license, and all required software components are working properly to be used by the applications.

Performed queue management for tickets in the AssytWeb-IT and organized task using MS planner.

Provided advice to the business focal point, users, and within team regarding subsurface and wells applications, both for technical (architecture, configuration, processes, application usage, errors, etc.) and non-technical (such as cost scheme, escalation channels, service agreement, etc.) aspects, as well as for areas of improvement.

Worked on systems vulnerabilities using Qualys and address those per security teams’ guidelines. Worked with auditors to mitigate the audit findings per company policies.

Monitored license and service utilization in OpenIT, ensured all purchased licenses and services are utilized efficiently, and followed up with any required adjustment

Managed around 6 assets (Offshore/Onshore/International with user base of 100+ and 1000+ wells) in the domain of fields operations and reservoir, which included OFM, Avocet, P2 EnergyComponents, Petex DOF Suite (IVM, IFM, IPM), PI/AF OsiSoft

(Processbook, PI Builder, CoreSight), OpenIT, AssytWeb, Qualys, MS PowerBI, SQL Server Reporting Services, SQL Server and Oracle.

Projects:

Oxy to QP Transition & others

Received historic data from Oxy, built loaders for real-time hi-frequency (identified UOMs), OpenWells jobs, daily/monthly volumes, PTA survey and welltest data to load it into Avocet. Supervised the customization and implementation of welltest workflow in Avocet with Schlumberger and obtained business sign-off. Identified the performance issues in welltest workflow and provided resolution steps for Schlumberger development team to implement.

Lead database administration handover project to DBAs by first addressing the audit findings, security teams concern and complying with the DBAs standards.

Coordinated the upgrade of AWM & DecisionPoint to Avocet 2017 for 3 QP fields with 400+ wells.

Participated in QP Intelligent Oil Field project. Proposed and coordinated the Avocet 2017 & OFM 2016 Citrix implementation in QP environment. Developed business case for PDMS standardization project. 2. Occidental Petroleum of Qatar Limited (OPQL) – Qatar, Doha. Nov 2008 – Oct 2019 Support/Administration

Interacted with users face to face and handled & prioritized problems, escalated and identified any critical issues.

Installed, configured applications, maintained licenses, applied patches and done upgrades.

Answered incoming calls from clients, processed emails and logged calls.

Followed procedures/checklists and updated support documentation and authored precise knowledge base articles. Software and Application Suites

Landmark TOWcs 2010 – 2019 Merrick eVIN systems 2010 – 2019 Schlumberger OFM 2013 – 2019/ DSS 2010 - 2015 Oracle Primavera P6 – 2019 NetSolution Payroll Management System: 2010 – 2019 Oxy ScadaWeb 2010- 2019 Weatherford LOWIS 2010- 2019 IBM Maximo 2009-2017

SharePoint 2009-2013 CA Unicenter Service Desk (USD) 2008 – 2013 NetIQ Vigilant Policies Center (PSPG) 2008 – 2012 OneOxy/Oracle Discoverer Reports 2009- 2011 FileNet/OxyDocs 2008 - 2009 OpenWells 2010 - 2019

Development

Developed new applications, components & functionality to existing systems.

Carried out design, construction, review and defect analysis activities.

Responsible for database design and development and Application Tuning.

Defined and generated screen formats and report designs.

Providing suitably tested fixes to defects within the sanctioned delivery process. 3

Authored and updated relevant documentation.

Developed in accordance with policies regarding secure coding & standards.

Interacted with users face to face and on site to ascertain requirements.

Investigated alternate configurations & implemented better solutions.

Developed software in accordance with agreed design with consideration for usability, software quality and future maintenance.

Software (C#, ASP.NET, MS SQL Server, Oracle & OsiSoft PI) Auto Allocation System ScadaWeb 2.0 and MPFM Well Test HR PoB (Personnel on Board) Field Loss Management System Project Implementations

Coordinated the business process study and requirement gathering.

Prepared the servers per vendor’s recommendation and help setup the required application environment.

Preparing test environment and obtain user sign-off/UAT (User Acceptance Test).

Coordinate the training for different user groups based on their roles.

Defining and generating screen formats and report designs. Software and Application Suites

Petroleum Experts Digital Oil Field (GAP, Prosper, IFM/MC, IVM) OsiSoft PI/AssetFramework Kappa server integrated with OFM and other standard Oxy systems

Field Loss Management System

OpenWells migration to Citirx by eliminating AutoSync Schlumberger OFM Standardization Net Solution Payroll Management System 2014

Reporting & Visualization

Manipulating, cleansing & processing data using Excel, Access and SQL & Oracle.

Analyzing raw data, drawing conclusions & developing recommendations.

Writing T-SQL scripts to manipulate data for data loads and extracts.

Developing data analytical databases from complex production source data (ODS).

Designing, developing and implementing new functionality.

Advising on the suitability of methodologies and suggesting improvements.

Carrying out specified data processing and statistical techniques.

Supplying qualitative and quantitative data to end users. Software

Microsoft SQL Server Reporting Services Tibco Spotfire Crystal Reports MS Excel

Oracle Discoverer

Disaster Recovery: Responsible for conducting annual applications DR, remedy the findings by coordinating with app owners, document and improve overall process by not only optimizing it but also introducing efficient changes. 3. Oceaneering International Dubai – UAE Mar 2006 – Sep 2008 Developer

Worked directly with Applications Development Manager and World Wide Maintenance Manager in Houston.

Worked as lead developer on an in-house specialized application developed in VB6/Access called Globally Assured Maintenance Management Application (GAMMA).

Modified and debugged the existing code and added the new functionality as and when required.

Documented all the changes, fixes and enhancements using Source Safe.

Created GAMMA’s manuals in doc/pdf format and demos using Adobe captivate.

Provided GAMMA training to operations/project manager and project coordinators. Support

Worked directly under guidance of World Wide ROVs Maintenance Manager in Houston.

Worked on a rigorous 24/7 schedule as a member of GAMMA Support team to resolve issues that are being reported by offshore/onshore users.

Interacted extensively with ROV maintenance, operations, project managers and project coordinators.

Assisted offshore supervisors/crew members and resolved their issues on a priority basis. 4

Tracked and followed-up on issues using MKS until they were resolved. Database Reporting Specialist

Received instructions directly from World Wide Supply Chain Manager and Inventory Analyst in Houston.

Prepared Excel Reports from SQL Server and PeopleSoft and uploaded to eMatrix.

Helped inventory analysts prepare excel reports to track and scrutinize current status of inventory in different regions.

Created utility using VBA to pull data from existing spec sheets for ROV systems around the world and dumped into newly created database. Created an interface to the database for giving data manipulation functionality to the management. Software and Languages

VB6, VBA, Excel, Access, SQL Server 2000, PeopleSoft, eMatrix, Macrovision and GroupWise/Outlook API. 4. Pakistani School Ajman – UAE Dec 2004 – Mar 2006 Analyst/Developer

Analyzed the existing manual system and gathered requirements specs.

Designed, developed and implemented desktop application Class Schedule Management System (CSMS).

Coded based on UML specs a web based system to track employee’s history called ETracking. a. CSMS helps administration to create yearly class schedules for different classes within a school without putting extra burden on teachers. Once a schedule is finalized, reports are generated and circulated and classes are conducted accordingly. b. ETracking is a comprehensive web based tracking system designed to empower the management to use it up to their requirements which include employee’s daily attendance, leave, activities, and performance appraisals etc. It is designed to provide management with a bird’s eye view of the employees’ performance in all respects throughout the financial year. Software and Languages

C#, Visual Studio 2005, ADO.NET, ASP.NET, Crystal Report, .NET Charting and SQL Server 2000. 5. Xpert Technologies May 2004 - Nov 2004

Software Developer

Trained in the basic concepts of GPS and related hardware gaining hands-on experience of Falcom STEPP and its practical use in Fleet Management.

Developed and documented reusable components for developers to communicate with Falcom STEPP and also created visual interface to configure Falcom STEPP by setting different parameters.

Wrote SQL-Scripts to automate the dumping of test data into databases, modified database structure and created stored procedures.

Developed different reports in ASP.NET to display vehicle tracking history and logs.

Co-developed window services to handle the incoming data with the aid of MS Message Queuing.

Partially developed window service to process the incoming SMS and to forward them to destination by making use of third party component.

Wholly developed taskbar resident services management tool for administrator.

Received training on GIS and Map Digitization from experts and worked on Arc View by ESRI a. MxTRAK is a web-based Fleet Management Service that enables vehicles fitted with STEPP devices to be easily configured and monitored in real–time, around the clock, anywhere in the world. For those with limited or slow internet access, the desktop version MxTRAK Client allows users to display vehicles on digitized maps and run reports QUICKLY. Whenever you require the latest vehicle positions, simply dial up to the internet and the latest vehicle positions are automatically downloaded to your PC.

b. Scribo sets a new standard in performance and reliability for sending SMS text messages from your mobile handset to other mobiles outside the UK. You simply type in your destination number, leave a space and then enter your message. Upon completion you send the message to our hub for delivery. Simple as that. The recipient will receive the message instantly and would not know that the message came through Scribo and would be able to reply. Software and Languages

Visual Studio 2003, C#, ASP.NET,.NET Framework 1.1, SQL Server 2000, ESRI Arc View 3.1 and MS Message Queuing. 6. Guide For Your Country (FZ-LLC) Jun 2002 – Dec 2003 Webmaster Cum Supervisor

Ensured that website is up and running all the time and verified quality of graphics and authenticity of data. 5

Identified problems/bugs in site and notified developers.

Reviewed, tested and helped developers optimize website for search engine optimization.

Developed a second website for HSF (Haji Siddique Foundry)

Wrote SQL scripts, developed reusable components and designed data grid reports.

Supervised a small team of graphic designers and data-entry operators. a. Guide For Your Country is easy to use directory based country-wise business search engine. Search business by location up to street/building level with driving directions. Find information about real estate, rentals, doctors, clinics, hospitals, music, travel, car rental, hotels, restaurants, computers, schools, colleges and universities nearest to your workplace or residence. Global Business Guide is designed for less internet savvy home and business users. Software and Languages

Visual Studio .Net, Visual C#, ASP.NET, SQL Server 2000, Macromedia Dreamweaver/Fireworks MX. Applications/Technologies/Frameworks Years of Experience Avocet Recent

Energy Components Recent

Power BI Recent

Microsoft Visual C#(ASP.NET, Forms) 14 Years

SQL Server Design & Development 14 Years

Oracle 9, 10, 11g & 12c 10 Years

Tibco Spotfire 9 Years

Oracle Primavera 6v7 9 Years

Petroleum Experts Digital Oil Field - (DOF IVM/IFM) and IPM Suite 8 Years Landmark TOWcs Production Accounting 8 Years

OxyLIMS 8 Years

Microsoft SQL Server Reporting Services (2005, 2008 & 2016) 8 Years Merrick eVIN 2008 8 Years

Weatherford LOWIS 5.0 8 Years

OSIsoft PI/AF (ProcessBook, DataLink, PIOLEDB, ICU, CoreSight) 7 Years Schlumberger OFM 7 Years

Matrikon OPC Tunneller (OPC DA) 7 Years

Telerik Rad Controls 2012, 2013, 2014 7 Years

Crystal Reports 9-12 5 Years

CA Unicenter Service Desk 11r 5 Years

SharePoint 3.0, 2010 5 Years

JavaSrcipt 5 Years

Maximo, Credo, Pride 4 Years

DexExpress Controls 9, 10 & 11 4 Years

CMDB - ChangeGear 3 Years

Oracle Discoverer 3 Years

JIRA/MS Planner 3 Years

Kappa Server 5.20 2 Years

FileNet/OxyDocs 2 Years

6

Trainings Courses & Awards

Advanced MS Power BI Training - Jan 2020

Advanced Digital Oil Field Developer course by Petroleum Experts Scotland, UK – March 2018

Oracle D2K Programmer’s course from “SUIS” Computer Institute Mansehra, Pakistan – June 2001

Java Programmer’s course from “Logics” Computer Center Abbottabad, Pakistan – June 2002

2542 – Advanced Data Access Development with MS Visual Studio 2005 – May 2008

2547 – Advanced Windows Form Technologies with MS Visual Studio 2005 – May 2008

Be a Safety Leader in Occidental Petroleum of Qatar - July 2009

Business Focused IT Project Management by Quanto Strategies – February 2011

Course 6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services – October 2011

The 5 Choices to Extraordinary Productivity (Franklin Covey) May 2012

Employee of the month for outstanding performance April 2012, July 2012, October 2012,

Building PI System Assets and Analytics with PI AF (November 2012)

Project Management Fundamentals by Bbusinesss (June 2013) and many more…. Others

Familiar with TM1, LINQ, SharePoint, Red Hat Linux 7/Unix, Window 2000 Professional, Windows 2000 Advance Server and VAX Mainframe OS. System Analysis & Designing, OOP, SOA and Graphics using C language. Education Bachelor of Science in Computer Science, Jan 1998-May 2002 Sharjah College at Sharjah, UAE.

Driving License Qatar’s valid driving license.

Nationality Pakistani.

DOB 10th March 1979.

Gender Male.

Marital Status Married.

Languages English/Urdu/Hindi.

Certification MCSA Track (Part 1 done)

Honor & Activities PROGRAMMING CONTEST

As a member of the Sharjah College team participated in the “Second National Programming Contest” held at American University of Sharjah on 14/03/2002. SPORTS: Table Tennis, Badminton, Cricket (Captain Oxy, member of Oceaneering Cricket Team), Volley Ball, bowling and Snooker.

As member of the Sharjah College Table Tennis team won the runner-up trophy in inter – college competition held at Gulf Medical College Ajman.

FORUM: Member of MSDN and OSIsoft community.

READING BOOKS: Alchemist by Paulo Coelho, Monk who sold his Ferrari and mostly computer books especially Advanced Remoting by Ingo Rammer.

Contact this candidate