An accomplished database designer and administrator with demonstrated success in designing and implementing database solutions that improve the business functionality. Posses diversified background with enterprise systems solutions.

• Expertise as an Oracle Database Administrator and a PL/SQL Developer
• Expertise in Ascential DataStage for Extraction Transformation and Loading and following a job through its complete life cycle
• Worked on projects requiring user requirement analysis, high-level design, development, testing, implementation, database architecture and application architecture
• Experienced in Dimensional Data modeling (Star/Snowflake Schema), creating Fact and Dimension tables, Physical & logical data modeling
• Installing and Configuring OpenNMS on Solaris 10
• Experienced in UNIX/LINUX Shell Scripting, C, C++, JAVA and Visual Basic
• Polished leadership skills, with the ability to motivate teams to increase productivity
• Extensive experience in developing SQL queries (DDL as well as DML) for Back-End testing of data

PROFILE SUMMARY

• Datastage Developer, New York Life Insurance Company New York, NY, 08/01/2008-03/31/2009
• Project Intern, Motorola, Naperville, IL, 01/26/2008-05/11/2008
• Project Intern, Action Motors, Chicago, IL, 07/15/2007-12/13/2007
• Database Designer and Administrator, Indoworth India Ltd, Nagpur, India, 05/21/2006-11/20/2006

EDUCATION:

Master of Science in Information Technology and Management
Bachelor of Engineering in Electronics Communication & Telecommunication

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:

Company: Confidential,New York, NY
Duration: 08/01/ 2008-03/31/2009
Position: Datastage Developer

Responsibilities:

• Involved in upgrading Datastage jobs from Datastage 7.5.2 to Datastage 8.1.
• Responsible for designing and developing ETL (utilizing Datastage and PL/SQL) for processing life insurance data extracted from Oracle and Spread sheets
• Designed prototypes using parallel jobs to demonstrate performance advantage over server jobs and outlined the plan for conversion when migrating to Datastage 8.1
• Proposed solutions to optimize the performance of existing server jobs by utilizing Inter-Process Stage, Link Partitioner and Link Collector stages, Hashed file tweaking and Oracle query tuning
• Performed debugging and testing for Datastage jobs to ensure proper functionality
• Utilized SyncSort to sort and aggregate large flat files prior to Datastage job processing
• Designed and implemented UNIX Korn Shell scripts to invoke Datastage processes, file management procedures. Also , PL/SQL script to manipulate data on Oracle
• Used SQL * Loader for bulk loading from external files into oracle 10g database
• Documented Datastage jobs process flow, start-up and recovery instructions

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

Company: Confidential,Naperville, IL
Duration: 01/26/2008-05/11/2008
Position: Database Designer and Administrator

Responsibilities:

• Worked with the management team for requirement specifications
• Designed a Data Model for their transactional database using Toad Data Modeler
• Created roles, profiles, views, synonyms and addresses managing user/ database security issues
• Developed triggers to save the history of the data being altered or deleted
• Creating test plans, procedures for testing the database
• Set up constraints (Table/Column) and managed loading operations on them
• Creating indexes, partitioning schemes for the tables
• Creating batch job using Crontab

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

Company: Confidential, Chicago,IL
Duration: 07/15/2007-12/13/2007
Position: Data Warehouse Developer

Responsibilities:

• Determined Facts and Dimensions for the EDW and modeled it on Star Schema Model
• Created Primary/Surrogate keys on the dimension tables and tested them for data integrity
• Developed ETL scripts for loading dimension tables and fact tables from transactional tables
• Generated results for queries regarding sales for Action Motors region by region

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

Company: Confidential, Nagpur, India
Duration: 05/21/2006-11/20/2006
Position: Database Designer and Administrator

Responsibilities:

• Procured and analyzed the requirements for creating Sales Order System
• Built oracle objects using Inheritance hierarchy
• Created roles, users, Stored Procedures and Triggers
• Created public synonyms for the procedures and triggers giving permissions to users
• Creating Functions and populated tables with test data for testing
• Determined the efficiency of sql queries using plan table

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

Company: Confidential,Nagpur, India
Duration: 09/1/2005-04/30/2006
Position: Database Designer and Administrator

Responsibilites:

• Worked in closed proximity with the Sr. Database Manager and the end users in acquiring requirements for a billing managemnet system
• Used Developer 2000 (D2K) for developing the front end of system
• Used DML queries to populate the data in the tables and created and executed test cases

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

PROJECTS:

Acaedimic Project : Confidential,
Duration: 01/26/2008-05/11/2008
Position: Team lead

Responsibilities:

• Responsible for distributing work amongst team members and identifying milestones and deliverables.
• Designed the database schema required for the system
• Designed 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