.Net Project Software Sql Server Data Developer

Gaurav Arora • .NET Professional with ** years of industry experience in robust

**********@*****.*** architecture, code reusability, high performance of applications and complete

425-***-**** execution of SDLC (Software Development Life Cycle).

Visa Status: H1B • Core competence area is application development using Java Script &

Microsoft Technologies.

Experience in implementing client/server, database and Internet based

•

systems using VS .NET 2010.

Experience designing and developing Winforms and Webforms.

•

Extensive experience in ASP.NET, VB.NET, ADO.NET, C#, Web Services,

•

WCF, SOAP, Visual Basic 6.0, JavaScript, Crystal reports 7.x/8.x,HTML,

DHTML, CSS, XML, MS SQL Server 2008, SSIS, T-SQL and SQL.

In-depth understanding of all the web related technologies and web based

•

architectures, .Net framework, design patterns, OOAD, component

technologies and distributed architectures.

Excellent communication and interpersonal skills.

•

Enthusiastic, hardworking, quick learner and always eager to take up new

•

assignments.

Expertise in designing in case tools like Rational Rose/XDE & Visio

•

Education

Bachelors of Science (Computer Science), 1998

Lucknow University, India

DOEACC ‘A’ & O level, 1999

DOEACC, New Delhi

Technical Skills:

Proficient Skills: C#, Asp.net, Asp.net MVC, Silverlight, SQL Server, WCF, Rational XDE, .net framework 4.0,

Soap Web Services, OOAD, AJAX, LINQ

Intermediate Skills: Windows Azure, AWS, Biztalk Server, MSMQ, Sitecore, CMS, Infragistics UI Controls for

Windows & Web Forms

Professional Experience

Company Worked For: Sogeti USA LLC

7th August 2008 – Till Date

Duration:

Worked As: Senior Consultant, Project / Tech Lead

Client: Efinancial

Worked on end to end cloud solution (using Azure) for Efinancial’s new web application as Dev Lead. We used the

latest Azure technologies like Azure Media Services, ACS, Caching etc. and also managed a team of 5 web developers.

Responsibilities:

Designing arhitecture of the application around Windows Azure

•

Architecting different layers (DAL, Business layer, Service Layer, Presentation Layer) of the application

•

Leading a team of five web developers

•

Developing Media solutions using Azure Media Services

•

Sending Daily / Weekly status reports to client

•

Defining scope of every sprint and assigning tasks to developers accordingly

•

Creating REST services to manage scaling of the application

•

Done Facebook integration with the Web application

•

Environment:

C#, Visual Studio 2010, Asp.net MVC 3.0, Sql Azure, AJAX, Windows Azure, Azure Media Services, Team

Foundation Server

Client: Microsoft – BICI

Working in latest technologies like Azure. developing solutions around Azure and WCF Services for integration of

Bing Services like Bing Rewards, Bing News Letter. Also, managing workflow tool developed in ASP.net MVC,

silverlight and WCF services for BICI Team.

Responsibilities:

Client interaction, understanding requirements and communicate the requirements to the Off shore team in

•

India

Developing Services around Azure to integrate communication between different business groups inside and

•

outside of Microsoft

Developing web pages using ASP.net webforms, ASP.net MVC and Silverlight

•

Integrating our workflow with different marketing systems in Microsoft

Developing and exposing WCF Services

•

Creating windows services for smooth integrations

•

Improving process by automation to save time of end user

•

Creating SSIS package to full the data from different Data Sources including AZURE SQL Server instance

•

Client: Starbucks

Worked as Onsite Technical / Team Lead and managed OffShore team working from India. Our Team was responsible

for maintaining and enhancing starbucks.com by adding new features using c# and ASP.net MVC.

Responsible for 24X7 support of starbucks.com for any kind of production issues.

Responsibilities:

Onsite Lead - Managed OffShore Team of 10+ team members

•

Understanding requirements and communicating it to off shore team

•

Developing application using Silverlight, WCF and Asp.net MVC

•

Creating Tools using Silverlight

•

Responsible for 24X7 support of starbucks.com for any kind of production issues.

•

Managing and interacting with different teams involved in maintaining Starbucks ecommerce platform

•

Closely worked with Customer Service department for any technical issue from end user

•

Writing code for short notice promotion launches using WCF services and asp.net

•

Environment:

Asp.net MVC, AJAX, SQL Server 2008, Microsoft CMS, sitecore, Silverlight

Client: CLR Team, Microsoft

Responsibilities:

Supporting the CLR Internal Checkin System (Snap). This Checkin System is developed using scripting

•

languages like Java Script, Perl, windows script and C#. My responsibility includes development for the

new feature requests, estimation, planning, creating reports and also maintenance of the product for any

existing issues.

I was driving /coordinating Forward integrations (Integrations from Main Branch to Clr Branch) and Reverse

•

Integration (Integrations from clr to Main Branch) as well as Silverlight Integrations. It also includes

scheduling, estimating time frame and resources allocation to achieve the integrations in time.

Coordinating within different teams of Microsoft for any issues due to integration and resolving the issues by

•

assigning developers.

Environment: Java Script, Perl, C#, ADO.NET, ASP.NET, Microsoft SQL Server 2008, Microsoft Visual

Studio.NET 2008, HTML, Java Script, Windows XP Professional, .NET framework 3.5 / 4.0, Windows Script,

vb script, Team Foundation Server, Silverlight 2.0, ASP.NET MVC 2.0

Company Worked For : Capgemini, Mumbai - India

: 30th Oct 2006 To 5th August 2008

Duration

Worked As : Senior Consultant, Team Lead

Client : GrowTech

Project#1: GrowWatch

This is Web Based system that enables horticulturist to gather information about the environmental state (for example

temperature, CO2 levels or light intensity) in a greenhouse and processes the gathered information graphically. The

application exposes its interfaces using .Net Remoting. External interfaces are based on SOAP.

Responsibilities:

Created Use Cases and UI Specifications using Rational XDE.

•

Drawn class diagrams and sequence diagrams using Rational XDE.

•

Client side data is validated using Java Script.

•

Web pages are developed using C# and ASP.NET.

•

User controls are developed using C# and ASP.NET.

•

Reviewed code written by team members.

•

Managed a team of 3 members.

•

Created tables, views, stored procedures, user defined functions, and Data

•

Analysis Services using Microsoft SQL Server 2005.

•

Accessed data in Microsoft SQL Server 2005 using ADO.NET.

•

Optimized data access by writing complex SQL statements.

•

Created installer using Microsoft Visual Studio.NET 2005.

•

Storing and accessing data using OLAP Cubes.

•

Environment: C#, ADO.NET, ASP.NET, Microsoft SQL Server 2005, Microsoft Visual Studio.NET 2005,

Microsoft Project, HTML, Java Script, Windows XP Professional, .NET framework 2.0., Chart FX for .Net,

Infragistics Web Controls for .Net, Biztalk Server 2006, AJAX, SQL Server Analysis Services, MS Project

Project#2: Plantform

This is windows based application for maintaining cultivation schedule of plants, planning for production of plants and

their sales etc. In this application Plugin based architecture is implemented and Object Based approach is used for data

handling by help of Remoting Architecture and webservices.

Responsibilities:

GUI Design using C# 2.0

•

Managed team of 6 Developers

•

Designing Use Cases on user requirements

•

Reviewed code written by team members.

•

Coding

•

Testing

•

Developed Remoting Layer and DAL for the applications

•

Database design using SQL Server 2005

•

Created Orchestrations in Biztalk Server 2006 and exposed them as Webservices

•

Created webservices

•

Created Collections & entities

•

Environment: C#.net 2.0, SQL Server 2005, .NET framework 2.0,Visual Studio.NET 2005, LLBLGen, MyGen,

Chart Fx, Infragistics Windows UI Controls, Biztalk Server 2006,

Company Worked For :Tata Technologies Ltd, India

: 2nd May 2005 To 27th Oct 2006

Duration

Worked As : Solution Developer, Team Lead

Client#Tata Steel

Project#CCCS (Computerised Combustion Control System)

Coke making is a highly energy consuming and expensive process for steel makers. Therefore efficient management of

the process is a serious concern to all coke plant managers. Advanced automation of oven machines, scheduling and

heating control has helped coke makers to improve their operational performance

Responsibilities:

Lead the team in coding and testing phase.

•

Done Requirement Analysis along with members of TATA Steel.

•

Designed the system in Rational XDE following complete Object Oriented Methodology using UML.

•

Did database design of the application in coordination with TATA Steel members.

•

Created test cases based on use case diagram.

•

Used MS Project tool for tracking the progress in the project.

•

Environment: Microsoft ASP.NET, C#.NET, ADO.NET, Visual Source Safe, Oracle 10g, Windows 2000 Server,

Crystal Reports, Java Script, IIS Server, MS Project, DOORS 8.1.

Client# Bharat Shell

Project#LSIP (LOBP System Integration Program)

Project involved development of a web based system to map the various business processes of Bharat Shell Limited,

LOBP plant to the application. System is based on a three - tier architecture. System features include dynamic menu

generation, role based access to the system, document based approval process at user defined level etc. System takes

care of production planning based on forecasting, processing of indents & invoices, inventory management, controlling

production of finished goods, dispatch/sales of the finished foods. System also provides an online costing module for

product costing.

Responsibilities:

Played a key role in various phases of SDLC for the application.

•

Did database design of the application.

•

Did design, development and unit testing of activities related to warehouse using C# and ASP.NET that

•

includes warehouse management, tracking the issues and return of the product, tracking the product batch

wise.

Did development of some part of GRN.

•

Perform key role in defining and implementing interface between new LSIP system and existing L4A

•

system.

Testing

•

Performance Tuning

•

Environment: Windows 2000 Server, .Net Framework 1.1, ASP Net, C#, Oracle 9i, Crystal Reports, Java Script

Client#Bausch & Lomb, India.

Project#CSN (Cataract Surgery Network)

System Features Patient Registration System which keeps track of the patient registration, their appointment schedule,

their diagnostics etc. Surgery Module keeps track of the surgeries done, surgery schedules, cancellation of surgeries,

OT updates, material consumed etc. Inventory Module keeps track of instruments/material used; their reorder level etc

Finance module keeps tracks of daily expenses, earnings, fees of the patients.

Desktop system facilitate to download master data from web application and upload data of daily transactions to web

application to distributors in more cost and time effective manner.

Responsibilities:

Developed Patient & Surgery modules using VB 6.0.

•

Developed master forms in ASP and developed utility to download/upload the data between desktop and web

•

application.

Gathered Requirements from their corporate office in Gurgaon.

•

Unit testing

•

Deployment at client side

•

End User Training

•

Environment: Windows 2000/XP, Visual Basic 6.0, ASP, SQL Server 2000, Ms-Access 2000

Company Worked For : eShipping Inc

: 2nd February 2004 To 30th April 2005

Duration

Worked As : Software Engineer

Project#1: e-Stats

This is a statistical Analysis Software alongwith a Search Engine. The software includes conversion of data (in text

format), taken from government body, to database format. Then deriving statistics about which liner Imports/Exports

goods in form of No of Containers and reports on basis of that data. This software gives analysis about No of

containers, Type of containers, Commodities, Leading sectors in the world for Liners/Agents, Leading Liners &

Agents alongwith their respective market share.

Responsibilities:

Developed the software with VB.net having Access as backend.

•

Converted data obtained in text format to access database using VB Application.

•

Interacted with the end user for system requirements.

•

Environment: Windows 2000 Server, .Net Framework 1.1, VB.net, MS Access 2000

Project#2: e-Filing

This system is related to the Custom Department of India. It is intended to fully automate the work of CHA’s,

Importers and Exporters who use to file their documents manually

Bank of New York is nation's one of best financial institution and home for all of your personal financial needs.

Responsibilities:

Developed Shipping Bill Module using C#, ASP.net.

•

Designed database using SQL Server 2000

•

Visited various CHA’s/ Importers/Exporter/Custom Department for requirement Analysis

•

Deployment at client side

•

Environment: C#, ASP.NET, SQL Server 2000, HTML, Visual studio.NET 2003, .NET Framework 1.1

Project#3: EXIM Search Engine

This search engine is designed for the Importers/Exporters so that they can find any entry made through custom

department for import/export of any productThe user can find required entry by just specifying one of the following

criteria: cargo description, RITC, Port of Loading, Port of unloading, Date of shipment, Importer/Exporter Name. All

the entries are made by collecting data from different ports of India. This Search Engine again categorized in 5 parts:

Imports, Exports, Ports, Categories and Statistics

Responsibilities:

Developed User Interface in Visual Basic.

•

Designed Database in Access 2000.

•

Testing

•

Performance Tuning

•

Environment: Visual Basic 6.0, MS Access 2000

Project#4: EXIM Conversion

This software is basically a conversion tool which converts files of different formats to Access Database formats.

Actually to support our search engine it is a necessary tool as we collect different formats of data from custom

department of different ports, then we have to convert it into database compatible with our search engine. To do so as

we are having different formats of data we developed a group of converters in single software EXIM Conversion

Responsibilities:

Developed interface in Visual Basic 6.0.

•

Designed Database in MS Access 2000.

•

Done requirement Analysis.

•

Testing

•

Environment: VB6.0, MS Access

Company Worked For : KKCI, Agra - India

: 1st July 2002 to 23rd Jan 2004

Duration

Worked As : Software Developer

Project: Hospital Management & Patient Information System

This software is used to automate the necessary functioning of the hospital. It take cares maintenance of all the useful

data about patients. This software manages the data of all the doctors and patients & also creates reports in the

specified formats.

Responsibilities:

Developed interface in Visual Basic 6.0.

•

Designed Database in MS Access 2000.

•

Done requirement Analysis.

•

Client Communication

•

Environment: VB6.0, MS Access 2000

Company Worked For : CSET, Agra-India

: 2nd July 2001 to 31st May 2002

Duration

Worked As : Programmer

Project#Office Automation System

This software is made for maintaining day to day activity of an educational institute running courses of various

universities as well as private courses. This software includes modules as Student Information System, Course

management, Fee Accounting, Leave Information System as well as Payroll Generation. This software is also having

modules to maintain the information since a student come for enquiry till he leaves the Institute after completion of the

degree /Course.

.

Responsibilities

Developed interface in Visual Basic 6.0.

•

Designed Database in MS Access 2000.

•

Contact this candidate