SQL, PL/SQL, sql tuning, transformation technique, transitivity, view

Manoranjan Sethy

PLSQL Developer

Mobile No: +918*********

Email: **********.*****@*******.***

Objective:

To pursue a challenging career where I will be able to learn continuously and grow consistently and add value to the organization through my capabilities and learning.

Professional Summary:

+3.3 years of hands-on experience in designing, developing and testing in Oracle SQL and PL/SQL technologies.

Proficient in both Oracle 9i and 10g.

Excellent work experiences of SQL query formation and execution.

Excellent programming skills of PL/SQL sub-programs.

Hands on experience in PL/SQL record types and tables.

Excellent analytical and technical skills with clear understanding and designing goals of ER modeling for OLTP applications.

Expertise in optimizing an application for the aspects like coding standards, implementing naming conventions, Improving SQL performance.

Hands on experience of query transformation technique, transitivity, view merging, predicate pushing, sub-query un-nesting, query re-writing with materialized view.

Ability to work well in both a team environment and individual environment.

Good work ethics with excellent communication and interpersonal skills, self-motivated, quick learner and team player.

Experience:

Presently working as software engineer for Technosoft Global Services Pvt. Ltd from May 2012 to August 2015.

Previously worked with Nacre Software Services as a Trainee Engineer from October 2011 to March 2012.

Education and Credentials:

Bachelor in Computer Applications (B.C.A) from Utkal University, Bhubaneswar.

Application and System Knowledge:

Technical skills : SQL, PL/SQL basic Linux and shell scripting.

Operating System : Windows 2000 pro, 98/XP, Vista and Windows 7.

Database : Oracle 9i, 10g.

DB Tools : Toad, PL/SQL developer, SQL*PLUS, SQL* loader.

Clients & projects:

Project 1:

Duration: November 2013 – August 2015

Title: Merchant Services & Terminal for Hitachi Payment Services, Japan

Description:

Merchant services popularly known as Credit card processing is the handling of e-payment transactions for merchants. It involves activities obtaining sales information from the merchant, receiving authorization for the transactions, collecting funds from bank which issued the credit card and sending payment to the merchant.

Roles and Responsibilities:

Cursor enabled data fetching from the database.

Active use of SQL, PL/SQL and SQL* Plus programs.

Proper Exception handling implementation.

Worked on general procedures, functions and packages with various PL/SQL validations.

Responsible for solving and fixing the problems occurred while testing and providing permanent solutions.

Knowledge Transition sessions to train the new people joining the team.

Project 2:

Duration: Jun 2012 – Oct 2013

Title: Incident Process management for Cash Management Solutions Inc, UK

Description:

Incident management is an ongoing service concerned with minimizing the downtime of incident affecting the availability of ATM. Every incident is recorded in the tool used for incident management, the records will also enable the associates and the cross functional unit to maintain a clear overview of the process followed for every incident until closure. The process captures information about incident and resolves them as per policies and the data science mentioned in the procedure.

Roles and Responsibilities:

Responsible for validating business requirements.

Involved all aspects of coding level and database level Application Development.

Extensively worked on Procedures and packages to retrieve data using cursors and exception.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

(Manoranjan Sethy)

Contact this candidate