Sql Server Oracle

Nikhil Khanolkar

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

*** ******* ******, **** **, Winchester MA 01890

Tel : 857-

***-****

PROFILE

. Over 2 years of experience in analysis, design, development, testing,

debugging and implementation of software

specifications and software implementation schedule

. Experience in writing complex SQL Queries, inner and outer joins

for Reports

. Experience in Tuning SQL Statements and Procedures for enhancing the

load performance in various schemas across databases

. Expertise in SQL query writing, creating views, table indexing, data

migration, backup and recovery through dumps, and also in Oracle

installation and database creation

. Hands-on experience with Java,J2EE,PL/SQL, Oracle Reports in Unix and

Windows environment

. Proficient in database design & implementation methodology on

Oracle, SQL Server and Sybase databases

. Proficient in Oracle E-Business Suite(Oracle 11i), Oracle Quoting,

Oracle iStore and Advanced Pricing modules

. Superior communication, organizational, and interpersonal skills.

TECHNICAL SKILLS

Languages: C, Java, JDBC, XML, Shell Scripting, PL/SQL, T-SQL, JSP,

JavaScript, HTML, Servlets

. Operating Systems/Platforms: Windows (9x/NT/2000/XP),Unix

. Tools: TOAD, ERwin Data Modeler, Oracle 11i (CRM),Oracle R12, Oracle

Reports 6i, MS Project 2000,MS Visio, Eclipse, SQL Server Business

Intelligence Studio, Business Objects

. Databases : Oracle 10g, MS SQL Server 2005, MS Access 2003,

Sybase v12.5, MySQL 5.0

. Version Management Software : AllFusion Harvest Change Manager,

Source Code Control System(SCCS)

. Web and Application Servers : Apache Tomcat 6.0, Oracle

Application Server 9i

WORK EXPERIENCE

EMC Corporation, Westborough, MA

October 08 - November 09

Application Developer, Sales Development

. Developed and unit tested Oracle 11i application programs (Quoting and

iStore) as specified in functional design documents and assisted in

progressing the solution from design though the software development

life cycle to implementation

. Customized and extended the functionality of the Oracle Quoting, Oracle

Advanced Pricing and Oracle iStore modules as a part of the Oracle

development team using PL/SQL, Java and JSP technologies.

. Closely involved in the entire lifecycle of the Freight Recovery

project from business requirements to user acceptance testing

(UAT).This project was a major initiative of EMC which enabled users to

calculate and incorporate freight on the quotes being submitted to

customers. Technologies used : PL/SQL, Java, JSP, JavaScript, Oracle

Reports 6i, SoftArtisans Office Writer API, Oracle Quoting and iStore

API

. Customized Advanced Pricing module by creating price lists, modifiers

and qualifiers as per requirement

. Created reports using Oracle Reports 6i, PL/SQL packages and

SoftArtisans Office Writer 3.6.1 tool as a part of enhancements to

Oracle Quoting and Oracle iStore modules

. Coordinated with offshore development team to meet tight deadlines and

frequently participated in knowledge transfer sessions

. Coordinated and assisted business analysts to formulate test plans

State Street Corporation Ltd, Westwood, MA

January 08 - June 08

Co-op, Data Management Services

. Performed database tasks for development and production projects. Tasks

included logical design(data modeling, database documentation) and

physical design(database configuration)

. Gathered requirements, created functional design, modeled and

implemented database on Oracle 10g and Sybase 12.5 for Server map and

developed reports using PL/SQL according to requirement.

. Created various reports using PL /SQL stored procedures according to

requirements

. Designed and developed an application and database to switch between

Oracle 10g RAC nodes sharing a single database depending on the

availability and load. Technologies used :Shell Scripting, PL/SQL,

ERwin Data Modeler

. Automated tasks for DMS team using shell scripting, PL/SQL and Java

technologies

. Assisted in internal audits by developing programs to ensure database

security and assess the effectiveness and efficiency of automated

controls

. Formulated test plans and coordinated user acceptance testing

Nikhil Khanolkar

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

171 Swanton Street, Unit 39, Winchester MA 01890

Tel : 857-

453-0710

Northeastern University, Boston, MA

Graduate Teaching Assistant

January 07 - December 07

. Resolved SQL Server and other software, accounts and hardware related

issues across college of engineering

. Led a team of lab assistants to maintain labs and assist students in

the use of software applications

. Designed and developed database tables and objects in Oracle and SQL

Server according to requirements

KSB Pumps Ltd, Pune, India

Project Engineer

December 04- June

06

. Developed key deliverables as part of the negotiating team at

discussions with client to convert proposals into

orders

. Analyzed technical specifications and customized the power train

constituents to suit client's requirements and

prepared proposals

. Managed multiple projects simultaneously and coordinated with

engineering and production department till delivery

. Reported to the audit committee and management on the policies and

activities of the department

ACADEMIC PROJECTS

Northeastern University

E-Commerce Website, Web Development

May 08 - August 08

. Developed e-commerce website adhering to the MVC architecture using

J2EE and MySQL database to enable users to purchase items using

shopping carts

ETL Development, Data Warehouse & Business Intelligence

September 07- December 07

. Designed, developed and populated different data marts and further OLAP

cubes from Real Warehouse using SQL Server Business Intelligence Studio

according to given requirements.

Infobyte Project, Planning and Managing IS Development

May 07 - August 07

. Performed a detailed level gap analysis of the firm including the

Information systems portfolio coverage, stage assessment, work

breakdown structure, strategic grid, risk analysis and the data

architecture

. Drafted and presented a project plan for implementation of the

selected package

Service Oriented Architecture, System Architecture and Technology

Management January 07 - April 07

. Presented a seminar on Service Oriented Architecture as a part of

course work which included the underlying principles of Web Services,

SOA and its relation to Business process management

IEEE Project, Database Design & Management

September 06 - December 06

. Designed and implemented database for IEEE conference calendar both on

Microsoft Access and SQL Server 2005 to schedule conferences, symposia

without conflicting with each other and their competitors and to

display reports according to their requirement

EDUCATION

Northeastern University, Boston, MA

Master of Science, Information Systems, Dean's scholar, GPA: 3.6/4.0

August 2008

University of Pune, Pune, India

Bachelor of Mechanical Engineering, First Class

June 2004

Contact this candidate