Sql Project

RAHUL SOLIPURAM

Address: **** ****** ***** *** # * Phone: 937-***-****.

Fairborn, OH 45324. Email:

**************@*****.***

SUMMARY:

. 1 year of total work experience in Analysis, Design and Development of

Databases.

. Experience in working with Databases like Oracle 11g/10g/9i, SQL

server 2008/2005 and MS access.

. Experience in coding SQL, PL/SQL and developing database objects,

triggers, stored procedures, functions, packages and knowledge of

tools like SQL developer and SQL *LOADER.

. Strong interpersonal, analytical and communication skills and ability

to work independently or in a team.

CERTIFICATIONS:

. Oracle Database 11g Administrator Certified Associate (OCA).

November 2010

EDUCATION:

. Master of Science in Computer Science

December 2010

University Of Northern Virginia, Virginia

GPA 3.4/4.0

. Bachelor of Technology in Engineering

June 2008

Sri Indu College of Engineering & Technology, Hyderabad (India)

GPA 3.5/4.0

WORK EXPERIENCE:

. Oracle Database Programmer July

2010 - September 2010

Alticor Inc., Hyderabad, India.

Alticor is the parent company of Amway Corp., Amway Global, Access Business

Group LLC, and Alticor Corporate Enterprises. It is the IT sector of Amway

business. The main purpose of this project is to build Global Data

Warehouse called Global Data warehouse for the Amway Business which enables

the Managers to develop or build reports that helps them to take business

decisions. The project I worked on was a part of the Global Data warehouse.

Responsibilities:

. Create DDL scripts as per the Alticore naming standards -

column, table, index, etc.

. Generated Scripts for creation of new database objects like

views, sequences, triggers, stored procedures and functions in

Oracle.

. Wrote SQL queries using sub queries and join conditions.

. Assisted in performing Backups.

. Assisted in performing documentation as per the company format.

Environment: Oracle 11g/10g, Sun Solaris 5.10, SQL, PL/SQL, SQL

Developer 2.1, Unix Scripting

. Graduate Research Assistant April

2009 - June 2009

Wright State University.

Responsibilities:

. My job is to update Course Studio / WebPages for course

materials and to assist in research work. I worked on WebCT,

Dreamweaver & MS Office tools to attain the purpose.

Environment: Web CT, Windows 7, Dreamweaver, MS Office.

. Oracle Database Programmer / Analyst

January 2008 - July 2008

HP Global Solutions, Hyderabad, India.

Information Management System (IMS) is a web based application that

included purchase and inventory, human resource and information system

modules of enterprise resource planning.

Responsibilities:

. Business analysis and requirements gathering.

. Database design and development.

. Designed and developed SQL stored procedures.

. Wrote procedures, functions and DB triggers.

. Wrote SQL queries and implemented DML commands on the database

objects.

. Assisted in performing documentation as per the company format.

Environment: Oracle 9i, SQL, SQL *Loader, Sun Solaris 5.8.

LAB PROJECTS:

. Credit card Data mart:

Spring 2009

The objective of this project is to build a data mart for the Sales

and Marketing Depatment of a Financial Institution. The Data Mart

includes, Credit Card related information, we can use this Data mart

to generate various reports like Highest Number of Credit Cards sold

in a month, year, and two years. Also, how much each customer is

paying interest weekly, monthly and yearly.

. Design and Implementation of University database management system:

Winter 2009

The main aim of this project is to design a University Database

Management System. The Database consists information of students,

courses registered and marks earned in each course. I had to

implement SQL and Relational Algebra queries on it to achieve the

desired result.

PRESENTATIONS:

. Web Crawler

Winter 2009

Wright State University, Ohio (U.S.A.).

RELATED COURSEWORK:

. Introduction to Database Management Systems

Winter 2009

. Database Management Systems

Spring 2009

. Computer Architecture

Spring 2009

. Current Development of CS I : Java

Fall 2009

. Digital Electronics

Winter 2010

. Artificial Intelligence

Spring 2010

TECHNICAL SKILLS:

. Operating Systems: Windows 98/XP/Vista/ 7, Ubuntu,

Sun Solaris.

. Programming Languages: SQL, PL/SQL, Transact SQL, Java.

. Databases: Oracle 11g, Microsoft SQL

Server, MySQL, MS Access.

. Software Packages: Adobe Photoshop, Web CT, MS Office

. Web Technologies: HTML, Dreamweaver

EXTRACURRICULAR ACTIVITIES:

. Coordinated Technical Events in my college technical fest "Samskriti".

March 2008

I was the member of Organizing Team of the Technical Fest. My job was

to conduct a robotic event called "SUMO WRESTLING" which was one of

the events of the technical fest. In this event many students from

about 16 colleges participated so I had to design the event and

appoint supervisors for the event.

. Organized a "Blood Donation Campaign".

November 2007

As an organizing team member, we organized a blood donation campaign

with the help of Lions Club of India.

Contact this candidate