Mohammed Abduljabbar Ahmed
Address: **** ******** **.,**********,**
Phone: 336-***-****
Email: ****.***********@*****.***
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