Chandra Mohan
((mob): 609-***-****
E-mail : adht8r@r.postjobfree.com
Objective
Aim to be a part of progressive company where I can apply my existing knowledge and creativity, acquire new skills, and contribute effectively to the organization.
Summary
Working as a LIMS Technical Consultant with Shell for Thermo LIMS (Sample Manager), Integration Manager space taking care of several applications and involved in multiple projects. Worked as a SME for LIMS- SampleManager. Effectively worked on Onsite-Offshore project model giving effective solutions for the business needs. Saved 2M USD for shell by merging multiple sites into one Global template by reducing infrastructure and support maintenance cost.
Skills:
Strong engineering professional skills in VGL, Oracle Database, Software Development and SQL. Handled Sample Manager Upgrade projects and delivered for multiple sites in Shell. Migrated Sample Manager and Integration manager to Azure environment. Worked on end-end deployments of Sample Manager and Integration Manager. Business Analysis, Requirement Gathering, Incident, Problem, Change and Release management.
Work Profile
Expertise in Upgrading sample Manager to the new environment and to the higher versions.
Gathering business requirements and providing solution based on the business requirements.
Expertise in VGL programming/Info Maker reporting tool and Integration Manager Transformations.
Good knowledge and experience in Data Migration using PL/SQL and industry standard tools, importing and exporting database.
Expertise in Analyzing the Requirements, Designing, Coding/ Implementation and Fixing Defects.
Good team player. Capable of grasping new technology, process and tools quickly. Always keen to learn and deliver with quality on time and highly productive.
Effectively worked on Onsite-Offshore project model giving effective solutions for the business needs.
Possess good communication and interpersonal skills and ability to work as individual and as a team.
Good knowledge on Oracle database having hands-on experience in SQL, PL/SQL.
Experience provisioning, operating, and maintaining systems running on AWS
Capabilities to provide AWS operations and deployment guidance and best practices throughout the lifecycle of a project.
Expertise with application / data migration to/from AWS.
Experience with configuration and management software such GIT.
Identifying appropriate use of AWS operational best practices
Deploying, managing, and operating AWS environments
Professional Summary
Working as a LIMS Technical Consultant for IBM India Pvt Ltd. from March-2016 to till date.
Worked as a Senior Software Engineer for Wipro India Pvt Ltd from Nov-2015 to March -2016.
Worked as a Software Engineer for IBM India Pvt Ltd. From May-2010 to Nov-2015.
Software Exposure
LIMS
Thermo Sample Manager 2004 R2/10.0 12.1 SP2
Programming Languages
Thermo LIMS, VGL, C++, VC++, MFC
Databases
Oracle 9i/10g/12c, PL-SQL
Development Environments
VGL Report Development, Visual Studio 2016
Web Technologies
HTML, DHTML, XML.
Reporting Tools
Infomaker 9.0, 12 Crystal Reports, Report Designer
Education
Completed Master of computer Applications from Osmania University,Hyderabad with an aggregate of 70%.
Industrial Work Experience
PROJECT: SAMPLEMANAGER
Time period: April 2013 to till date
Client: SHELL
Designation: LIMS Technical Consultant
Technologies: VGL, ORACLE. AWS Support
Description: LIMS is a web-based application that uses a database to collate laboratory information. This application is used for the efficient testing of samples that routinely pass through a typical lab - whether process testing, quality assurance, or R&D by sorting test Information and organizing it into specific report formats to meet regulatory requirements. The complete testing routine is managed, from sample login to testing, re-testing, and final Reporting.
Responsibilities:
Delivered Few projects for shell by upgrading sample manager from SM 10 SP1 to SM 12 SP2.
Expertise in Report designer and work flows in sample manager.
Worked on Enhancements based on Business requirement.
Worked on Data migrations as part of global system setup for all the OU’s in Upstream across the globe.
Worked on separation projects as part NCOC separation from Shell.
Worked on Deployments of new code fixes.
Analyze data in the application.
Determine data extraction and migration requirements.
Design most cost-effective solution to meet requirements.
Extraction of data as per business requirements using tools like TOAD, SQL Developer.
Interact with the client and functional support to have a common understanding on goals.
Worked extensively with other database objects such as cursors, functions, triggers, indexes, sequences, views and writing SQL queries using Joins and Merge.
PROJECT: INTEGRATIONMANAGER
Time Period: April 2013 to till date
Client: SHELL
Designation: Senior Software Engineer
Technologies: VGL, ORACLE.
Description: The main purpose of this project is to Read/Write the data from source and transform it into
The format which is understandable by the destination and store it.This is done by the IM Agent. The Integration manager is designed as a distributed, scalable system it provides a Platform for directional or bidirectional communicator between two disparate of similar Application end point in the enterprise and is loaded in target system. The tool is designed for the transformation developing the mapping tool for the transformation.
Responsibilities:
Configured the file agent and dynamic agent which are responsible to manage the data flow between laboratory instruments and LIMS.
Developed new transformations.
Configured the new instrument in integration manager.
PROJECT: EZCHROM
Time Period: April 2013 to March 2017
Client: SHELL
Designation: Senior Software Engineer
Technologies: VGL, ORACLE.
Description: The main purpose of this project is to analyze the sample from the instrument and store the result in the IN folder, which is read/write from integration manager and store in the LIMS. Once the result file will be processed, it will be there In the copy folder to make sure file has been processed and if any error occurs, It will be there in the error folder.
Responsibilities:
Conducted DR tests for EZChrom Application to make sure that application can bring back to normal within minimum time to avoid business loss if any critical issue comes on the primary server.
Bug fixing which comes in the from of the incident.
If there is vendor dependency then I worked with 3rd party like Agilent, PIMA etc with the incident process to fix any critical issue.
Configure the instument on the other EZServer if any EZSserver is having an issue to avoid business loss.
PROJECT: AIM EDMS
Time Period: May 2010 to June 2015
Client: SHELL
Designation: Software Engineer
Technologies: C++, VC++, MFC, Oracle
Description:
The AIM system offers the functionality to manage technical data and documentation relating to Assets. AIM builds upon core SAP PM Functionality to provide seamless integration with the engineering processes systems interfacing with FileNet, K2 Workflow & SAP systems. AIM is a system for managing documentation and technical data relating to Assets. AIM has a Windows interface (with familiar drop-down menu style). All the information is held in an integrated AIM-SAP system. AIM is a system that allows Asset information to be electronically managed.
Responsibilities:
Involved in fixing the bugs in the application.
Involved in developing the various enhancements to the application based on the client requirement.
Client interaction.
Incident analysis, First and second-line customer liaison with the purpose of maximizing the first call resolution rate.
First and second-line support: remote and on-site support
Recording &tracking incident information.
Recording &tracking Problem information.
Participate in reconfiguration/installation of PC environment
Document operational support procedure
PROJECT: ENERGY X-CHANGE
Time Period: May 2011 to Aug 2014
Client: SHELL
Designation: Software Engineer
Technologies: WINDOWS NT, C++
Description: Energy Xchange (EX) is a software application that integrates several tools and support services for managing pipeline business. EX supports these functions:
Operations
Tariffs
Nominations and Pipe Line Scheduling
Revenue Accounting
The different EX modules allow employees throughout Shell Pipeline to add and file tariffs, create monthly pipeline schedules and field measurement tickets, generate allocation splits, and show loss/gain for analysis. EX also allows for shipper analysis, allowance oil management, and database reporting.
Responsibilities:
Involved in fixing the bugs in the application.
Involved in developing the various enhancements to the application based on the client requirement.
Client interaction.
Incident analysis, First and second-line customer liaison with the purpose of maximizing the first call resolution rate.
First and second-line support: remote and on-site support
Recording &tracking incident information.
Recording &tracking Problem information.
Participate in reconfiguration/installation of PC environment
Document operational support procedure
PROJECT: LOLA
Time Period: Feb 2012 to March 2013
Client: SHELL
Designation: System Engineer
Technologies: C++, MFC
Description: For supply and distribution of Shell’s oil and petroleum products and as well as crude oil etc, Shell uses an application called LOLA. I used to support that application. The application was critical to shell’s business. Hence this application uses to have 24x7 supports as well, which I use to handle. This requires strong problem solving and analysis skills with in minimum time. This also requires strong communication skills and domain knowledge of Oil and Petroleum industry. The application LOLA uses to communicate with lot of external applications like CH-GSAP, OP-GSAP, Autobus and Docserver etc. For these external communications LOLA uses to use Lola interfaces. For communicating with each different external application there used to be a specific LOLA interface. This new interface was required to replace the existing weighbridge application interface.
Responsibilities:
Involved in fixing the bugs in the application.
Involved in developing the various enhancements to the application based on the client requirement.
Client interaction.
Incident analysis, First and second-line customer liaison with the purpose of maximizing the first call resolution rate.
First and second-line support: remote and on-site support
Recording &tracking incident information.
Recording &tracking Problem information.
Participate in reconfiguration/installation of PC environment
Document operational support procedure
Achivements
Got Gem of shell award twice for outstanding performance in prime applications.
Got many appreciations from client for overall performance.
Got best performer award for delivering Sample Manager upgrade project on time.
Personal Profile
Languages Known: English, Hindi, Telugu
Hobbies: Listening to Music, Playing indoor games
Traits: Effective and hardworking, Good learning capacity