Email: accpkw@r.postjobfree.com

Phone:- +91-812*******

ASHUTOSH KUMAR SAURAV

CAREER OBJECTIVE

I want to prepare myself for the competitive world and make a place for myself by acquiring relevant

knowledge and developing required skill sets. My positive attitude yearning to learn more and the ability

for iconsistent hard work always hold me in good stead in all my endeavors.

CAREER CONSPECTUS

• Undergone Efficient Training on Data Warehousing Concepts & Data stage 8.x ETL Tool

along with ORACLE SQL/PLSQL.

• User management issues involving control user access to resource and information by allocating proper

privileges.

• Space management issues involving resizing table spaces, data files and rollback segments.

• Writing Stored Procedures, Triggers, Exceptions, etc.

• Writing SQLqueries and PLSQL

EXPERIENCE SUMMARY

I have done advance DWH & PL/SQL Training & Project at Orator Education Pvt. Ltd.

• Comfortable with writing SQL queries and basic Unix Commands

• Comfortable with writing Stored Procedures, Triggers, Functions, packages

• Good knowledge in Oracle Database Architecture concept.

• Successful installations of Oracle software for Production databases on LINUX and Windows

platforms.

• Database connection Issue (no listener/unable to resolve service name etc.)

• Grant Privilege

• Having good knowledge in DWH.

Knowledge in the Data Warehouse concepts like Dimensions, Facts, Star Schema and

•

• Snow Flake Schema.

• Implementing Techniques like Slowly Changing Dimension (Type1, Type2).

• Having knowledge in UNIX basic command.

Comfortable with Data Extraction, Transformation and Loading using Data Warehousing ETL

Tool like Data Stage

Knowledge in Using Debugger wizard to find the bottlenecks in the mapping

•

Usage of import /export wizard to transform data from various ODBC/OLEDB data sources.

•

TECHNICAL SKILLS

Operating System : UNIX, Windows 2003/2008/ Windows 7, Vista/XP

•

Languages : SQL, PL/SQL

•

Development Tools : Data stage 8.x

•

Databases : Oracle

•

Case tools : X – Manager, Putty, TOAD

•

Data Modeling Tools : Erwin

•

EDUCATION SUMMARY

MCA (67.60%) : SRM University (Chennai) 2012.

BCA (Hons.) (64.00%) : SPM College Bihar Sharif (Nalanda) 2009.

OFESSIONAL SUMMARY

ACADEMIC PROJECTS:

Project : A Distributed Algorithm for the Replica Placement Problem

Platform : Windows XP, windows 7

Environment : Java (front End), My Sql (backend)

Project Summary:

Replication of important data objects contribute significantly to the reduction of the network bandwidth

usage and the overall access time to data. Our focus is to improve the efficiency of object replication

within a given distributed replication group. Given the request rates for the objects and the server

capacities, find the replica allocation that minimizes the access time over all servers and objects.

PROJECT SUMMARY

Project Banking Strategic Management system(BSMS)

Client AFFIN bank

Description:

AFFIN Bank has been a leading bank in Malaysia for over 30 years. Since it’s a major bank in Malaysia it

has to be linked with many kinds of business enhancements and competitive edge using information

systems technology to make decisions. They are dedicated to customer service and do intelligent

analysis of their business, which have put them at the front of finance throughout Malaysia. They are

having numerous branches all over Malaysia and like every fast growing branch, this bank is searching

for new avenues, wants to increase the customer base, and attract more investment. By using

information technology this bank wants to have an edge over their competitors.

Responsibility:

Development of the entire program

•

Physical and Logical designing of system using Erwin

•

Running scripts on Linux Server

•

Loading data from flat files into database using sqlloader

•

Writing Oracle stored procedures, functions, triggers and packages.

•

Developing Queries for Reports.

•

Preparing Programmer level test cases.

•

Conducting unit testing.

•

PERSONAL INFORMATION

Sex : Male

•

Marital Status : Single

•

Nationality : Indian

•

Linguistic ability : English, Hindi

•

Current Location : Bangalore.

•

DECLARATION:

I hereby declare that the information furnished above is true to the best of my knowledge.

Place: Bangalore

Ashutosh Kumar Saurav

Contact this candidate