Database Developer_DBA

RAHUL R. NEULKAR Add: **** Maple Avenue, Apt # *, Evanston IL-60201

Ph: 1-312-***-****

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

OBJECTIVE:

Looking for a career as a Database Developer/Administrator and a position to hone my qualities

PROFESSIONAL EXPERTISE:

• Expertise as Oracle Database Administrator

• Expertise as Oracle PL/SQL Developer

• Expertise in Ascential DataStage for Extraction Transformation and Loading and following a job through its complete life cycle

• Developing SQL queries for Back-End testing of data

• Installing and Configuring OpenNMS on Solaris 10

• Expertise in handling DDL as well as DML queries

• Experienced in UNIX/LINUX Shell Scripting, C, C++, JAVA and Visual Basic

• Solid understanding of database, data warehousing, business intelligence concepts, 3NF, Dimensional Models and Data Integration techniques

• Experienced in Dimensional Data modeling (Star/Snowflake Schema), creating Fact and Dimension tables, Physical & logical data modeling

• Highly efficient and provide keen attention to minute details

• Worked on projects requiring user requirement analysis, high-level design, development, testing, implementation, database architecture and application architecture

• Have played an active part in building a strong team/work environment, and have ability to adapt to new technologies and situations with ease

EDUCATION:

Master of Science in Information Technology and Management

Illinois Institute of Technology, Chicago, IL

GPA: 3.0/4.0

May 2009

Bachelor of Engineering in Electronics Communication & Telecommunication

Nagpur University, Nagpur, India First Division

May 2006

SKILL SET

Operating Systems UNIX, Sun Solaris 10, Fedora 6/8, Red Hat 10, Ubuntu, Mandarin, Suse, Windows 98/2000/NT/XP/Vista

Languages C, C++, JAVA, SQL, PL/SQL, Shell Scripts, HTML

RDBMS Oracle 10g/9i, MS Access 97/2000/2007

Data Modeling & Design Tool Microsoft Visio, IBM Rational Rose

ETL Tools IBM Ascential DataStage

Other Tools Toad, SQL*Loader, Lotus Notes, Developer 2000, OpenNMS,

Putty, FTP

WORK EXPERIENCE:

Client: New York Life Insurance Company New York, NY

Duration: August 2008-March 2009

Role: Datastage Developer

Responsibilities:

• Involved in upgrading Datastage jobs from 7.5.2 to Datastage 8.1

• Primarily responsible for designing, developing ETL utilizing Datastage jobs and PL/SQL to process Life Insurance data extracted from Oracle, and Spread sheets

• Designed prototypes utilizing Parallel jobs to demonstrate performance advantage over Server jobs, and outlined plan to convert existing inefficient Server jobs to Parallel jobs when migrating to Datastage 8.1

• Proposed solutions to optimize performance of existing Server jobs such that processing large volume of data can be accomplished in timely manner. Optimizations included utilizing Inter-Process Stage, Link Partitioner and Link Collector stages, Hashed file tweaking, and Oracle query tuning

• Involved in debugging and testing Datastage jobs to ensure proper functionality

• Utilized SyncSort to sort and aggregate large flat files prior to Datastage job processing to enhance performance

• Designed and implemented UNIX Korn Shell scripts to invoke Datastage processes, file management. Also, PL/SQL script to manipulate data on Oracle

• SQL * Loader was used for bulk loading from external files into oracle 10g database

• Documented Datastage jobs process flow, start-up and recovery instructions

• Worked cooperatively with the team members to identify and resolve various issues relating to Datastage and other database related issues.

Environment: Datastage 8.0.1 Enterprise Edition, Oracle 10g/9i, Sun Solaris, SQL*Loader, PL/SQL, TOAD, UNIX Korn Shell Script, Window XP

Designing, Building & Normalization of Relational Database for Sales Order System for Indoworth India Limited, Nagpur, India

Duration: 05/21/2006-11/20/2006

Responsibilities:

• Gathering and analyzing requirements for creating Sales Order System

• Building oracle objects using Inheritance hierarchy

• Creating roles and users according to the requirements

• Writing of Stored Procedures and Triggers

• Creating public synonyms for the procedures and triggers and giving permissions on them to the users

• Creating Functions and populated tables with test data for testing

• Determining efficiency of sql queries using plan table

• Showing importance of primary-foreign keys and tuning sql results to give the best results

Environment: Oracle 10g, SQL * PLUS, Windows 2003 Server Edition

Developing Inventory/Billing Management System for Sagar Restaurant, Nagpur, India

Duration: 09/1/2005-04/30/2006

Responsibilites:

• Working with Sr. Database Manager and the client in acquiring requirements about the deliverables

• Using Developer 2000 (D2K) for developing the front end of system

• Populating the table using DML queries

• Creating test cases

• Working on table requirement and populating the tables for the project

Environment: Oracle 9i, Windows 2000 Server Edition, Developer 2000

PROJECTS:

Database Modeler & Development , Motorola (Naperville)

Duration: 01/26/2008-05/11/2008

Responsibilities:

• Working in close aspect with Motorola for requirement specification

• Creating Data Model for their transactional database using Toad Data Modeler

• Managing user/ database security issues

• Creating roles, profiles, views, synonyms

• Developing triggers to save the history of the data being altered or deleted

• Creating test plans, procedures for testing the database

• Setting up constraints (Table/Column) and managing loading operations on them

• Creating indexes, partitioning schemes for the tables

• Creating batch job creations using crontab

• Scheduling of procedures

Environment: Oracle 10g, SQL * PLUS, Ubuntu 8.04, Toad Data Modeler

Developing Enterprise Data Warehouse for Action Motors

Responsibilities:

• Determining Facts and Dimensions for the EDW

• Modeling EDW based on Star Schema Model

• Creating Primary/Surrogate keys on the dimension tables

• Developing ETL scripts for loading dimension tables and fact tables from transactional tables

• Testing the data in dimension tables for data integrity

• Providing results for queries regarding sales for Action Motors region by region

• The grain was fixed as time for the project and it was judged daily

• Following the project through it’s complete life cycle

Environment: Oracle 10g, SQL * PLUS, TOAD, Er Studio, Windows Vista

Child Care Centre System

Responsibilities:

• Team lead for the project

• Responsible for distributing work amongst project members and interacting with the professor for requirements and specifications for the project

• Designing the tables required for the transactional system

• Actively participating in creating the front end using Visual Basic

• Following the waterfall approach for Work time schedule

Environment: Visual Basic, Windows XP, Microsoft access 2000.

EXTRA CURRICULAR ACTIVITIES:

• Webmaster for Indian Student Association, IIT

• Active participation in drives related to AIDS Awareness, HEPATITIS B vaccination and general awareness on the ill- effects of Dowry Practices and Female Infanticide in India

• Worked for Child Health Care and Immunization

Contact this candidate