CAREER OBJECTIVE_____________________________________________
Move-up, look down & stay ahead.
Operating System Windows 9X/ NT, Unix
Databases Oracle 9i, Oracle 10g
Languages SQL, PL/ SQL
Tools Oracle Warehouse Builder 10g(OWB), Sql Tools and Business Objects
COMPUTER SKILLS______________________________________________

EDUCATIONAL HIGHLIGHTS___________________________________________________________

Bachelor of Engineering (Computer Science & Engineering) from Maharshi Dayanand University in 2004, with 71% marks.
Passed Senior Secondary Examination from C. B. S. E. with 75. 2% marks
Passed Matriculation from C. B. S. E. with 73. 8% marks

State Bank of India (11 Months)
Currently working as Assistant Manager (Systems) in data ware housing department.
Universe Creation, working in web intelligence and dashboard that refreshes the data on change of date.
Work Experience in TCS (9 Months)
Worked as support person at GE Gurgoan for about 9 months on the SBI data warehouse that includes the following responsibilities:
Checking the completeness of the data files, starting, monitoring the daily load single handedly, and running various UNIX scripts.
Checking the meta data tables and target tables of the operational data store
Writing SQL Queries for checking the Operational data store tables
Refreshing the materialized views as required.
Worked as developing and updating the process flows for the Oracle warehouse builder.
Checking the table spaces regularly
Created views required to fetch the data from the source tables.
Analyzing the metadata and other errors for every load and reporting, communicating to clients.
Work Experience in Sapient (2. 1 Years)
Working as a system developer in Essent Data warehousing project, which essentially involves in energy generation and trading in Netherlands. Understanding the business and preparing the data warehouse to calculate the change in the price of various deals done by the Essent.
Worked as a part of designing team to get the data vault build on the staging area with the tools like OWB 10g and working on the database oracle 10 g. The top layer build on the data vault is the star schema design.
Previously worked for National Health care Scheme (NHS) which Extract Load, Transform the data of the patients from various trusts, and apply transformations on the data store in the flat file structure. Creation of views and Materialized views along with Sql queries was used to filter the data from the dump. Apart from that created the test scripts for scenario testing of the data.

TRAINING AND PROJECTS____________________________________________________________
Developed Exam Control Room Automation as final year project

Client: Apeejay
Details: To develop a user friendly and menu driven software for easy calling of forms and runtime parameter reports of total pass students in all semesters, update semester, subject wise result, list of documents submitted and withdrawal against university roll-no.
Team size: 4
Project Guide: Ms. Savneet Kaur, Dept. Of Computer Science, Apeejay College Of Engineering, Gurgaon.
Worked with Rico Auto Industries Limited as a summer Trainee and developed Enterprise Resource Planning System (Oracle + D2K).

Client: Rico Auto Industries Limited
Details: To understand the Purchase Requisition, Purchase Order, Work Order, Delivery Schedule system and to design an application for storing and retrieving records on/ from the application.
Team Size: 3
Project Guide: Mr. R. K Sharma, Asst. Manager, Rico Industries, Rewari.

Understand techniques in Surface Mount Technology & testing for Motherboard in 3rd Semester.

Client: None
Details: To understand various aspects of hardware training involving testing guide for motherboard and modem at XO Info Tech. Gurgaon.

PERSONAL DETAILS
Date Of Birth : 20-August-1982
Martial Status : Single
Contact Details