Developer Sql Server

Ishan Shah

*****.******************@*****.*** 551-***-**** www.linkedin.com/in/ishan2 Dallas, Texas

EDUCATION

S, Management Information Systems, GPA 3.5

T Dallas, Concentration - Data Mining Expected 05/13, Electronics & Communication Engineering,

GPA 3.8

ujarat University 07/10

SKILL SET

RDBMS - TOAD for Oracle, SQL*Plus, SQL Developer, SQL Server, MySQL, Access (OLE + Macros)

Languages - SQL, PL/SQL, T-SQL, Java, XML, HTML, CSS

Data Analysis & Reporting Tools - SAS, SSPS, R, Crystal Reports, Excel, Google Analytics, Ad Words, Webmaster(SEO)

OS - UNIX, Windows

ETL & Data Modeling Tools - SSIS, SAP NetWeaver, Visio, Visual Paradigm

WORK EXPERIENCE

Quest Diagnostics, Addison, TX 05/12 - Present

SQL Developer Analyst-Intern

• Build SQL scripts for data conversion from legacy system to newly implemented enterprise system

• Write PL/SQL procedure to automate data loading from database logs

• Develop SQL queries to analyze function response time, network latency and user experience

• Automate customized weekly reporting using Excel’s pivot table feature through ODBC

• Perform Load testing using JMeter and unit testing for Oracle 10g to 11g migration on UNIX server

• Create SSIS packages to automate the database environment sync up

Richardson, TX

UT Dallas - eLearning Dept., 01/12

- 03/12

Teaching Assistant (TA)

• Worked with several faculty members to record and edit their lectures for online teaching

Ahmadabad, India

Gujarat University, 09/10 - 12/10

Visiting Faculty

• Conducted 17 lectures and 12 lab sessions for the assigned course work for 120 ECE students

Indian Space Research Organization, Ahmadabad, India

Research Intern - Moon Mission of India 01/10 - 05/10

• Designed an Ultra Wide Band antenna in the desired frequency range after over 700 draft designs

• Antenna designed to capture and transmit data from moon for analysis

RELEVANT PROJECTS

Statistical Analysis and Data Modeling Fall 12

• Applied logistic and regression analysis to develop an airline price prediction feature for Kayak.com

• Developed use cases, class diagram and a database design to analyze and improve existing functionality

Database Developer, UT Dallas 05/12 - 07/12

• Gathered and analyzed requirements to develop a normalized database using MYSQL

Search Engine Marketing (SEM), Google Online Marketing Challenge 04/12

- 05/12

• Participated in a global online marketing competition and developed 4 advertisements using Google AdWords

• Achieved, Average Ad Position = 2.1, Click Through Rate of 1.80% at an average cost of just $0.50 per click

Database Development for a Hospital Fall 11

• Developed a Star Schema database in BCNF and implemented using SQL Server and Access

Data Mining Project Fall 11

• Analyzed five years data of 550 players to pick the best 14 within the allocated budget using XL Miner

AWARDS

• Won 60% tuition fees waiver from UT Dallas for leadership in community services

• Rewarded free Windows phone from Microsoft for developing 2 apps(More than 4,350 downloads)

CERTIFICATIONS

• Oracle Certified SQL Associate Expected 3/13

• SAS Business Intelligence and Data Mining Expected 5/13

Contact this candidate