MANOJ KUMAR GUPTA
*****.*****.*****.**@*****.***
PROFESSIONAL SUMMARY
Software professional with 5+ years of experience in Analysis, Design, Coding and
•
implementations of Projects using .Net technologies for Oil and Gas industry.
Excellent understanding of Oil and Gas domain.
•
• Expertise in developing Windows applications using C# in Visual Studio 2005, 2008 and
2010.
• Experienced in implementing Service Oriented Architecture (SOA) techniques like
Windows Communication Foundations (WCF).
• Good Knowledge of .NET concepts like LINQ, Entity Framework, LINQ2SQL.
• Hands on experience in creating Stored Procedures, Functions, Triggers and Views
using T-SQL in Microsoft SQL server 2005/2008 R2.
• Working experience on SSIS.
Experience in Software development models such as Agile (SCRUM/Kanban) and Water
•
Fall methods of SDLC.
• Expertise in working with customers on technical feasibility analysis.
• Expertise in onsite-offshore working model and team co-ordination, guiding team
(including onsite and offshore), work delegation, providing 24x7 support and ensuring high
availability of system.
• Excellent Written, Analytical Skills, Verbal Communication skills with a customer
service oriented attitude.
• Expertise in providing technical guidance to Business Analysts, Software Engineers, QA
Testers and other team members in diagnosing and resolving complex defects.
Proven ability to work with cross cultures.
•
EDUCATION
Bachelor of Technology, Information Technology – JIIT, Noida, India (2009)
Skills
Business Domain : Oil and Gas
Framework, Language : .NET 4.0/3.5/2.0, C#, C/C++
Client Technologies : XML, HTML, JavaScript, VBscript, jQuery
Services, Web Server : WCF, Web Services, SOAP, REST, IIS 7.5/6.0
Data Access : LINQ to SQL, ADO.NET, Entity Framework
Database, ETL : SQL Server 2005/2008 R2, SQL Server Integration Services (SSIS)
Development Tools : Visual Studio 2012, 2010, 2008
Other Tools : Perforce, LinqPad, XmlPad
CERTIFICATIONS AND AWARDS:
• Microsoft SQL Server 2008, Database
Development certified.
• Earned Production Optimization
Software Certification of Appreciation at Weatherford.
• Got Most Valuable Player Award at
Infosys for the delivery of quality work in Wellscribe project.
• Onsite coordinator of the team receiving
RnR award for the WALI project at Infosys.
PROFESSIONAL EXPERIENCE
CLIENT: Weatherford International – Houston, Texas
ROLE: Technology Analyst
PROJECT TITLE: WALI (WellView and Lowis Integration)
September 2013 to present - Onsite
July 2011 to September 2013- Offshore
Project Description:
This is a robust system designed to exchange well drilling and the production data using
WITSML standard. The databases are mapped to the WITSML objects to make the system
Energistics complaint. The latest WITSML standard has been used to validate the data before
exchange.
Responsibilities
• Implementation of the WCF services for
the server to consume the received objects and convert the XML to C# objects.
• Actively involved in database fields
mapping with the WITSML object fields using Entity-Framework (Schema First
Approach).
• Actively involved in Database changes
and Stored procedure optimization.
• Implemented business layer using C#.
• Developed applications using XML,
JavaScript, C#, LINQ to SQL.
• Involved in estimation and planning of
the project deliverables.
• Worked with deployment team in
deploying on the test servers and the point of contact in UAT for the end Customer.
• Responsible for Onsite/Offshore team
communication, work assignment to offshore team.
• Performs code analysis and review for
the work done by my team.
• Responsible for end to end system
integration testing of the developed code.
• Coordinates with India team of 6
members for various deliverables.
• Take Scrum Master’s responsibilities in
the daily standup meetings with my team.
Environment:
C#, WCF, SQL server 2008R2, WITSML, LINQ, Entity-Framework, XML, IIS 7.5, Perforce
CLIENT: Weatherford International – Houston, Texas
ROLE: Technology Analyst
PROJECT TITLE: WellScribe September 2013 - Present
Project Description:
Wellscribe is a product used by the rig crew to enter the data. It captures information in the field
and ensures accuracy as each event is entered as it occurs on site. It also consists of a barcode
scanner that simplifies data input by eliminating keystrokes.
Responsibilities
• Maintenance and development for the
product.
• Actively involved in gathering
requirement from the end customer.
• Implemented major changes on the
Admin tool of the product in C#.
• Coordinates with the QA team and the
deployment team.
• Performs issue Analysis, Design,
Coding and Unit testing.
• Actively participated in the Pilot for the
product with end Customer.
• Optimization of the queries in Compact
SQL database to reduce the processing time on mobile.
Environment
C#, WCF, SQL server 2008R2, SQL compact database, XML, IIS 6.0, Perforce
CLIENT: Weatherford International – Houston, Texas August 2013 - September 2013
ROLE: Technology Analyst
PROJECT TITLE: POC: WellScribe Dashboard:
Project Description:
It is a tool that extracts data about the wells from a database and marks the wells on the Google
maps. The user can click on the marker to get the complete information of the well.
Responsibilities
• Analysis, design and code for the tool.
• Research work on the Google maps API
v3.
• Queries and stored procedures for
extracting the data from the different tables and views.
• Developed WCF services returning
data in JSON format to expose the different functions for the client to get the data.
• Developed Html pages to consume in
services using jQuery and
Environment
SQL server 2008R2, C#, Javascript, Google maps API, jQuery Perforce
CLIENT: Weatherford International – Houston, Texas July 2009 - August 2013
ROLE: Technology Analyst
PROJECT TITLE: WSM (Well Service Management)
Project Description:
WSM is the major component of the LOWIS (Life of Well Information Software) used across the
Oil and Gas industry. This product is a well management suite designed to help improve the
bottom line for the production operation. This software provides an efficient way to gather and
store well information.
Responsibilities
• Development and optimization of
Queries and Stored procedures in SQL.
• Analysis and Debugging to find root
cause for the issues and resolving the issues.
• Development based on the requirement
and features.
• Code review and peer testing for the
changes made by my team.
• Involved in domain knowledge sessions
with the client and the senior members of team.
• Developed customizations for different
customers using C++, XML, Html, and Javascript.
• Trained my team members on the
technical and domain skills required for the project.
Environment
SQL server 2005/2008R2, C/C++, Html, Javascript, VBscript, ChartFx, XML, Perforce, TFS
CLIENT: Weatherford International – Houston, Texas June 2012 - September 2012
ROLE: Technology Analyst
PROJECT TITE: OpenWells
Project Description:
It is an ETL tool that is used to import data from the OpenWells Data repository to the WSM
database. This tool validates and cleans the incoming data before loading the data to the other
database.
Responsibilities
• Requirement gathering for the project
involving direct meetings with the customer.
• Analysis and design of the SSIS
package.
• Queries and stored procedures for
extracting the data from the different sources.
• Coding in C# for forming the queries
and the UI layer.
• Integration testing after integration with
the modules developed by others for Cross references.
• Deployment on the test server and
Environment
SQL server 2008R2, C#, Javascript, SSIS, Perforce, TFS