Mohammed Abduljabbar Ahmed

Address: **** ******** **.,**********,**

Phone: 336-***-****

Email: adjv5k@r.postjobfree.com

Summary Skilled SSRS developer with 12 years of experience. Supported different department in oil company in data warehouse management, creating and customizing business reports. Leaded an initiative to convert manually prepared reports to SSRS reports.

WORK

EXPERIENCE

Dec-2011 - Present

Production Programmer

Greater Nile Petroleum Operating Company

(GNPOC), Heglig, Sudan.

Responsibilities:

Administrating Production Database System, Field view, OFM software and Back allocation Engine.

Produce a variety of field production statistics and field engineering activity reports on a weekly, monthly, quarterly and annual basis.

Prepare, monitor, track and report on various

production performance indicators, including

comparisons of actual values versus targets.

Compile user requirements and specifications for reports.

Design, create and test SQL reports using SSRS.

Validate report functionality with internal staff/end users.

Respond to users to troubleshoot and/or improve

existing reports.

Optimize SQL server queries to efficiently and quickly retrieve data.

Liaise with IT and System Engineer to ensure that all data back-ups are made in a timely manner. Monitor ongoing systems development.

Ensures that all data gathered and entered into the Production Engineering System are accurate, complete and reliable.

Participated in database management system upgrade project replacing Oracle database with MSQL.

Jul-2008 – Dec-2011

Production Technologist

Greater Nile Petroleum Operating Company

(GNPOC),Heglig, Sudan:

Responsibilities:

Gathering and validating various production and well data.

Monitoring the daily operations and well reports including the review of basic process parameters, by reading and assessing logs, laboratory tests and

production results and discussing operation issues with production personnel.

Maintaining appropriate databases for well and

production data and analyzing the productivity of

assigned wells on a daily basis.

Preparing reports and discussing findings with

supervisor.

Recommending production optimization to increase production as deemed necessary.

Following up and recording wireline work carried out by contractors. Checking charts and downhole results, as necessary and forward to petroleum development

personnel.

Preparing programs for well production testing to be carried out by service companies.

EDUCATION

2001 - 2006

Bachelor Degree of Petroleum Engineering,

University of Khartoum, Faculty of Engineering, Petroleum Engineering Dept.

Training Dec 2015 SQL Server Reporting Services. Integrated Solution Center, Cairo, Egypt.

Feb 2012 Oracle SQL Developer.

Aptech Institute, Khartoum, Sudan.

Dec 2009 Electrical Submersible Pump (Components, Design and operation)

Powerlift Company, Taicang, China.

Nov 2008 PCP (Components, Design and operation)

PCM Company, Heglig Training Center, Sudan.

SKILLS Excellent T-SQL development skills to write complex queries involving multiple tables.

Creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS.

Writing expressions in SSRS and fine tuning the reports.

Experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions and Views.

Familiar to work with Crystal report.

REFERENCES References available on request

Contact this candidate