Nihar Meher E-Mail: Mob: +91-: Good Knowledge in Such As Parsing, Commit Phase

Nihar Meher
E-Mail: [email protected]
Mob: +91-9986276797
Professional Overview:
 Having 3+ Years of IT experience in Oracle PLSQL development.
 Associated with Marlabs Software pvt. Ltd. Bangalore from December 2013 to September
2017.
 Extensive experience in developing stored Procedures , Functions , Triggers , Views , Cursors ,
Packages, Exceptions, Joins, Sub queries and Set operators.
 Created Tables, Views, Constraints and Index.
 Experience in Bulk Collect, Bulk Bind operator and Collections.
 Aware of OLAP Features, Analytical Functions in Oracle.
 Involved Explain plan and investigate the performance issues.
 Good exposure on advanced topics Like Analytical Functions, Indexes, Partition Tables,
SQL Loader and UTL_FILE package, External Tables, Ref Cursor and Dynamic SQL.
 Created Packages, Procedures to automatically drop table indexes and create indexes for the
table.
 Good experience in Performance Tuning using Explain Plan, Hints, Auto trace and Indexes.
 Good Knowledge in ORACLE PERFORMANCE AND TUNING such as Parsing, Commit Phase,
Database Architecture, SQL Tuning, SQL Completing Processing, and Sub query
Unnesting, Predicate Pushing etc.
 Technically Proficient in UNIX Shell Scripting and Job Scheduling in Unix/Linux Platform.
 Worked in Production Support, attending production call, troubleshooting application and
resolving bugs.
 Good implementing complex business rules as logics within database SQL, PLSQL and make
them reusable to access in the other components of the project.
Working Experience:
 Worked in Marlabs Software pvt. Ltd. Bangalore as a senior Software Engineer from
December 2013 to September 2017.
Educational Qualification :
 Completed B.TECH in Electronics and Telecommunication Engineering (ECE) from BPUT in the
year 2012.
SOFTWARE KNOWN
Operating systems : Windows XP/7/8/10, UNIX

Languages : C, C++, SQL, PL/SQL
Packages : MS Office 2003/07/10
DB Packages : Oracle 9i/10g/11g
DB Tools : SQL *PLUS, TOAD
PROJECT DETAILS
Project 1:
Project Name: ADBS (Advance Development Banking System)

Client: IDBI Bank
Role: Oracle PLSQL Developer
Description:
ADBS is a user Internet Application, where in client/internal user will login and initiate extraction of
reports, summary, image files etc. Application also caters as a collection on tax returns, cheque payment
tracking mechanism for few countries. In ADBS clients login into the Application form and internet
browser, the authentication message of the user id and login is passed onto the IDBIDAP and then to Citi
safe word or cyota for further validations of user id. Once the user is authenticated he can opt for
various like fetching reports and summary, for which application will connect to COTS. All the retrieves
data and images from various applications is displayed on the browser and has facility to save locally in
various forms and formats.
Roles and Responsibilities:
 Created index to facilitate easy user interface implementation and tuning.

 Developed stored procedures to retrieve customer information.
 Developed stored procedures and triggers to facilitate consistent data entry into the database.
 Tested database performance issues (monitoring and tuning) to ensure database optimization.
 Wrote SQL Statements for complex joins, sub queries using simple mathematical logics so that
the query got tuned.
 Clear documentation was prepared of all the processes like program specification, bugs fixing
logs & change requests for future reference
 Developed views to facilitate easy user interface implementation and enforce security on critical
customer information.
 Performed SQL and PLSQL performance and tuning using Explain plan, Auto trace, Hints,
indexes.
 Extensively involved in using Hints to direct the optimizer to choose an optimum query
execution plan.
 Used Bulk collection for better performance and easy retrieval of data by reducing context
switching between SQL and PLSQL.
 Created records, Tables, Collection for improving query performance by reducing Context
Switching.
 Handled errors using Exception Handling extensively for the debugging and display the error
message.
Project 2:
Project Title : ESBS (Enterprise Service for Banking System)

Client : ANZ Bank, Australia
Description
This is an IFX (interactive Financial Exchange) protocol based middleware for the financial institutions.
The greatest features of this application is, it is developed upon SOA (service oriented Architecture).The
main objective of this system is to translate the different channel specific messages to the format which
can be understood by different available hosts and vice versa. It is very useful to the top the financial
institutions in every way.
Responsibilities:
 Involved in Modifying various Shell Script using VI editor and scheduled the Job.
 Monitoring the Log files and log Information.
 Monitoring the Production Server.
 Provide L1 and L2 support to tickets.
 Track the tickets through ticketing tools and resolve that as per SLA.
 Involve in doing DML statements.
 Created index to facilitate easy user interface implementation and tuning.
 Involved in writing various SQL queries.
Declaration
I hereby declare that above statement are true to the best of my knowledge and belief.
Place: Bangalore Nihar Meher

Nihar Meher E-Mail: Mob: +91-: Good Knowledge in Such As Parsing, Commit Phase

Uploaded by

Copyright:

Available Formats

Nihar Meher E-Mail: Mob: +91-: Good Knowledge in Such As Parsing, Commit Phase

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Nihar Meher E-Mail: Mob: +91-: Good Knowledge in Such As Parsing, Commit Phase

Uploaded by

Copyright:

Available Formats

Nihar Meher

 Having 3+ Years of IT experience in Oracle PLSQL development.

Operating systems : Windows XP/7/8/10, UNIX

Project Name: ADBS (Advance Development Banking System)

 Created index to facilitate easy user interface implementation and tuning.

Project Title : ESBS (Enterprise Service for Banking System)

 Monitoring the Log files and log Information.

 Monitoring the Production Server.

 Provide L1 and L2 support to tickets.

Place: Bangalore Nihar Meher

You might also like