RESUME

Name: Bikrant Kumar Sahoo

Email Id: acs4th@r.postjobfree.com

Contact No: +91-720*******

Work Experience – 2 years 9 months

OBJECTIVE

Dynamic and highly energetic Programming Analyst with 2 years and 9 months of experience in SQL/PLSQL Programming.seeking for a challenging position to utilise my experience in designing, implementing and integrating software application and so further enhance problem solving skills to achieve career growth.

EXPERIENCE SUMMARY

Above 2 years of experience with ORACLE working as Oracle Developer and programmer, developing back-end modules such as packages, functions, procedures, triggers, views, Materialized views for Multitier business applications for OLAP systems. In SQL/PLSQL.

Knowledge of Oracle performance-related features such as indexes, partitioning and index organised tables.

Comprehensive experience in Cursors, Cursor variables, Pl/sql table and Exception handling mechanism.

Knowledge on Merge statement, Synonym, Sequences and Index.

Multitasked, able to meet deadlines, team player, and responsible, quick learner, result-oriented.

Ability to learn quickly and to correctly apply new tools and technology.

Having experience in UNIX.

Handled PL/SQL tables effectively for Bulk Insert & Retrieve.

Employment history:

Working in Wipro technologies pvt. limited, Bangalore as a Software Engineer since April 2013.

PROFESSIONAL QUALIFICATION

Completed B.tech from silicon institute of technology, bhubaneswar, Odisha under Bput in the year of 2013.

Completed intermediate from Dharmasala Mahavidyalaya in the year of 2008.

Completed Matriculation from Madhuban High School in the year of 2006.

TECHNICAL KNOWLEDGE

ORACLE DATABASE

DEVELOPMENT : Oracle Database 11g, SQL, PL/SQL

LANGUAGES : SQL, PL/SQL

TOOLS : SQL DEVELOPER. TOAD, PUTSYS, AUTOSYS

OPERATING SYSTEMS : Windows XP, UNIX.

PROFESSIONAL PROFILE

Project Details

Project 1:

Project Name

Humana web IT

Client Name

Humana Insurance

Role

PL/SQL Developer

Duration

june 2013 to October 2014

Team size

17

Operating System

Windows XP, Unix

Description:-

It is an insurance project that keeps track of the customers and coverage details. The Humana project deals with insurance coverage of customers and their dependants of Humana. The details about the coverage, demographic details, benefit details, expiry and renewal details. As a large insurance company it deals with the customers who insured in Humana more than 100 years.

Role and Responsibilities:-

Analysis of the specifications provided by client.

Understanding the requirements of the system. Used TOAD, PL/SQL developer tools for faster application design and developments.

Writing Packages, Stored Procedures and Functions.

Involved in creation of table indexes, views, materialized views, Sequences and constraints.

Preparing Technical Documents and wrote complex sql queries using joins and sql queries.

Project 2:

Project name

Limit Tracking

Client name

Danske Bank,denmark

Role

PL/SQL Developer

Duration

November 2014 to Till Date

Operating system

Windows Xp, Unix

Team size

18

Description:-

Before DANSI, the system allows multiple partial Redemptions from Auto Sweep Deposit accounts. Now the system is changed in such a way that it should allow only one time Sweep one time partial early withdrawal during the Time Deposit & Auto Sweep time deposit. When a second time sweep/withdrawal happens, the whole Time Deposit will be closed and transferred to saving account

Role and Responsibilities:-

Have Written SQL queries as per requirement.

Involved in coding as part of PL/SQL.

Involved in Development, Enhancement.

Analysis of the specification provided by the client.

Understanding the requirement of the system.

Involved in creation of Tables, Indexes, Views, Sequences and Constraints.

Used advanced Pl/SQL techniques like cursors for data retrieval.

Used SQL Navigator for designing SQL statements.

Handled PL/SQL tables effectively for Bulk Insert & Retrieve.

Created Triggers to maintain the history of vendors & customers

Developing distributed database design (using Oracle) for a distributed client server based system using.

Prepared weekly status reports. Prepared Quality related documents.

Personal Profile

Date of Birth : 08th February,1991

Gender : Male

Nationality : Indian

Marital Status : Unmarried

Languages Known : English, Hindi and Oriya.

Current Address : # 27,ground floor, opp to pragathi nagar

Manjunath Layout, chikkathogur road

Electronic City Post,

Bangalore – 560100

Declaration:

I hereby declare all the information given above are correct to the best of my knowledge and I hold responsible myself for any irregularities if found.

Date

Place Signature

Contact this candidate