Developer Software Data .Net Project Sql Design

ANKIT SACHDEVA

**** *****

Ave. #**, San Diego CA 92115

Phone : 214-***-**** / 408-***-**** E-mail : *****.********.**@*****.***

OBJECTIVE

To obtain a potential Full-time Software Developer/ETL Developer position

and make an effective use of my education to work as a responsible and

competent team-oriented player.

EDUCATION

MS - Computer Science, The University of Texas at Dallas, Texas,

USA. GPA: 3.45/4 (June 2010)

B.Tech - Computer Science, Maharishi Dayanand University, India.

GPA: 3.5/4 (May 2007)

SKILLS

Programming: VB .NET, C#.NET with WPF, WCF, AJAX, T-

SQL, HTML, XML, CSS, JavaScript,PHP

Databases: MS SQL Server 2000/2005/2008/oracle9i

Service Tools: DTS (Data transformation services), SSIS

Database Tools: SQL Profiler, SQL Query Analyzer

Data Modeling: ERwin

Database Development skills: Transact SQL (T-SQL), SSAS, SSRS, SSIS,MySQL,

MS SQL 2005, Oracle

IDE : Eclipse, Microsoft Visual Studio 2008

QA Tools : Borland Silk Test, Xuds

Software Engineering : Requirement Analysis & Gathering, Software

Architecture, Quality Assurance

Operating Systems : Windows 9X/XP, Vista, DOS, Linux, UNIX

WORK EXPERIENCE

Jagatjit Industries Ltd New Delhi, India (EDW)

ETL Developer

June 2007- dec 2008

EDW is a collection of data across Company's multiple source systems of

record. It consists of layers designed to capture, integrate, summarize,

and analyze data across the company. It is having several applications like

Land, Distillery, Sales & Revenue etc. And it is a centralized source for

the summation and aggregation of data.

. Analyzed business requirements and built logical data models that

described all the data and relationships between the data.

. Translated business requirements into dimensional data model to

support data mart.

. Defined various facts and dimensions for the data and created several

conformed dimensions to ensure the data in these dimensions meet the

requirements of the sharing departments.

. Responsible for the design of mapping and cleansing to deliver the

data to the data warehouse from the data sources by profiling and

massaging data in the source databases and files as well as creating a

staging database to ensure that accuracy of data pushed to the

relational warehouse.

. Created several cubes specific to special analysis conducted by BI

application used by upper management.

. Created several complex SSIS packages using different transformations

like fuzzy lookup, fuzzy grouping, conditional splits and

multicasting.

. Developed all the required stored procedures, user defined functions,

triggers and views using T-SQL.

. Developed complex parameterized and drill down reports using SQL

Server Reporting Services 2005/2008 from Analysis Services Cube and

rendered and publish the report to Report Manager and Microsoft

SharePoint.

. Created various reports using SSRS like Linked, Drill-through, Sub

reports Click through, reports and sub-reports.

. Optimized the embedded application T-SQL code as well as the stored

procedure used to feed reports for better latency performance.

. Developed and formatted reports, and integrated the reports to

distribute/subscribe them to the internal and external customer.

. Defined user roles for accessing different reports on Reporting

server.

. Optimized the performance of queries with modifications in T-SQL

queries, removed unnecessary columns, eliminated redundant and

inconsistent data, normalized tables, established joins and created

indexes whenever necessary.

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Windows XP, Microsoft

Visual Source Safe, Erwin, VB.net, ASP.net

ACADEMIC PROJECTS

. Object Oriented Analysis and Design

. Designed Online Pizza Ordering System ( Use Case Diagrams, Domain

Diagram, Sequence Diagrams, Activity Diagrams, Class Diagram, State

Diagrams)

. Used GRASP Patterns to refine the system.

Keywords -UML, DESIGN PATTERNS

. Software Testing and Verification

. Designed Successfully Automated Black box testing of yahoo

messenger using silk test as the testing tool

(designing test cases and, running the test cases using the

designed test suite. Added custom verifications using the 4Test

scripting to validate certain features of the messenger and

documenting the test cases according to IEEE standards).

. White box testing of a UNIX utility called "PTX". Used XSUDS

testing tool in determining the coverage of the application based

on the designed test cases. The aim of the project is to maximize

the coverage with minimal test cases. Used inbuilt utilities like

Xatac and XRegression.

Keywords -Silk Test, UNIX, XSUDS, Xatac, XRegression.

. Advanced Requirements Engineering

. Developed an "Online Meeting Scheduler System" as a part of Advanced

Requirements Engineering Course in spring 2009. Responsible for

collecting the requirements from the stake holders, forming the

requirements specification document, creating the software

design, coding the application.

. Used C#.net web technologies for front end coding and

SqlServer as back end.

Keywords -C#, ASP.net 3.5 framework, ADO.net Sql

Server 2005.

. Database Design

. Developed a Web Based Instructor's course feedback system in Fall

2009 responsible for collecting feedback for a particular course the

instructor teaches that semester using ASP.net 3.5 framework with

code behind language as C# and back end database as MS Sql Server

2005.

Keywords -C#, ASP.net 3.5 framework, ADO.net Sql

Server 2005.

. Software Architecture & Design

. Developed a KWIC (Key Word in Context) search engine using various

architectural styles and software patterns.

Keywords -Java, Design Patterns.

. Advanced Software Engineering Project

. Developed an application called WIGOS (Web Information Gathering

and Organization System) for conference Information

Collection given by UT Southwestern Medical Center Dallas TX and

sponsored by Dr Yu Quin. The Project aims to build a user friendly

web site where a user can search in all the relevant information

about all conferences going to be held in USA through the help of

already present search engine API and simple web Crawler.

Keywords -Java, Design Patterns, WebCrawler.

. Software Project Planning & Management

. Prepared the Work Breakdown Structure, Time & cost /effort

Estimation of a large commercial banking Software including Risk

Analysis and Critical Path Analysis using Microsoft Project.

. Advanced Computer Networks

. Designed a Mobile Ad Hoc Network Header to support Real Time

transfer of data(audio and video), Active drop of the packets,

Bursty Traffic and Broadcast of packets, Congestion Control and

Reliability.

. Modified the C++ code of TCP in Network Simulator-2 to include the

above mentioned features.

. Simulated it on NAM (Network Animator) using Tcl Scripts and

calculated the Throughput using AWK Scripts.

Keywords-tcl/tk, C++, Mobile Ad Hoc Network,

TCP/IP.

. Final Year Project as a part of the Bachelor of Engineering

Curriculum.

. Developed an Online Tour and Travel Website" using ASP.Net with C#.

The Website provides an online support for users to organize

tours for themselves rather than going physically to tour and

travel agencies for organize a tour. The site also has additional

features such as tourist venues and hotel information for a

particular city.

Keywords -C#, ASP.net 2.0 framework, ADO.net Sql

Server 2000.

AVAILABILITY

07/12/ 2010

VISA STATUS: F1 ON OPT

RELOCATION: OPEN TO RELOCATION AT MY OWN EXPENSE

Contact this candidate