Sql Server Project

Ashutosh Tripathi E-mail: *****************.*********@*******.***

BCA,MCA, AD3D+ Contact No. +91-971*******

SYNOPSIS

4+ years of experience in Software Designing/ Development/ Programming and Implementation using ASP.Net, C#, Web Services, SQL Server 2008, Winforms, WPF, WCF and SSRS 2008, SSIS for building robust, scalable and secure applications. My current work areas are Requirement Analysis, Application/Database Development, Documentation, Maintenance and Client Coordination. I’m an active participant in official Microsoft ASP.Net.

Experience in Software Design, Development and maintenance of database various commercial applications with experience of SDLC.

Proficiency in Microsoft SQL Server 2005/2008, Microsoft Visual Studio.Net, Microsoft SQL Server Reporting Services 2008/2005.

Good knowledge in System / Database Design, Development, Programming, Testing and Implementation.

Excellent Analytical, technical and communication Skills.

Prosix Softron Pvt Ltd, as a Programmer System Executive 07 July 2010 to 17 Feb 2011

NIIT Ltd, as a Programmer Systems Developer 21 March 2011 to 13 July 2012.

Amdocs, as a Senior Programmer Subject Matter Expert from 30 July To 1st Feb 2013

Current Company is UnitedHealth Information Technologies and I am working as a Senior Programmer Software Engineer from 13 Feb Till Now

Job Duties and responsibilities of Senior Programmer

researching, consulting, analyzing and evaluating system program needs

identifying technology limitations and deficiencies in existing systems and associated processes, procedures and methods

testing, debugging, diagnosing and correcting errors and faults in an applications programming language within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification

writing and maintaining program code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards

writing, updating and maintaining technical program, end user documentation and operational procedures

providing advice, guidance and expertise in developing proposals and strategies for software design activities such as financial evaluation and costing for recommending software purchases and upgrades

SOFTWARE EXPOSURE

Experience in C#.Net, ASP.Net, ADO.Net and Web Services, WCF, MVC, Window Service, JQuery, JavaScript, Entity Framework.

Experience in Microsoft SQL Server 2005, 2008.

Experience in Microsoft SQL Server Reporting Services, SSIS.

Experience in Web Technologies like XML, HTML, IIS, CSS and AJAX.

Experience in WPF and Winforms

Experience in Implementing LINQ To XML in Application.

Experience in Unit Testing

Experience in Test Cases.

Experience in Profiler

Experience in Design Pattern

Experience in Use Case

PROFESSIONAL QUALIFICATIONS / CERTIFICATIONS

QUALIFICATION

MCA from Punjab Technical University.

BCA from Integral University.

AD3D+ Animation Diploma from MAAC

Role and Responsibilities

Designing 3 tire application architecture including Presentation, Business and Data Access Layer and MVC.

Performance Optimization of the Application. Production support.

Database Design. Proficient in implementing business logic using the T-SQL Stored Procedures/Functions/Triggers/Jobs.

Designing of Functional Document, Use Case Diagrams and Low Level definition Document.

Developing web forms, web services and data access layer using ASP.NET with C#.

Designing and development of Reports as per the client requirements.

Web part development and Site creation with Microsoft Share Point Services.

Perform unit testing of application, review of test cases.

Responsible for Module handling, code review and VSS maintenance, SVN.

PROJECT DETAILS

Project: TNOC

Technology: ASP.NET 3.5, MVC 3.0, C#, VB.Net, Web services, SQL Server 2008, JavaScript, JQuery, AJAX, SQL Server Reporting Services 2008, HTML, JSON, Windows Service, WCF

Client UnitedHealth Care (USA)

Team Size 4

Duration 13 Feb 2013 Till Present

Contribution:

(Lead Developer) Involved in all phases of analysis, Database Design, Screen development, Report Development and Documentation.

Description:

TNOC has two parts OLTP and OLAP. TNOC act as a Dataware house which is later used to show reports in SSRS and C#. It is used to show productivity and quality of claims processors. TNOC also helps in decision making through reports. Second part of the application is completely in .Net which is used by Users for Transaction purpose.

Project: BVA(Bill View and Adjustments)

Technology: ASP.NET 2.0,4.0, C#, VB.Net, Web services, SQL Server 2008, JavaScript, AJAX, SQL Server Reporting Services 2008, Framework 4.0, 2.0

Client AT & T (USA)

Team Size 5

Duration 30 July 2012 1 Feb 2013

Contribution:

Involved in all phases of analysis, Database Design, Screen development, Report Development and Documentation.

Description:

This is the application used by AT&T Customer Care Representative to view and adjust the bill as per the customer requirement.

Project: ACIT,CCT,DNO

Technology: ASP.NET 2.0,4.0, C#, VB.Net, Web services, SQL Server 2008, JavaScript, AJAX, SQL Server Reporting Services 2008, Framework 4.0, 2.0

Client AT & T (USA)

Team Size 1

Duration 30 July 2012 1 Feb 2013

Contribution:

Involved in all phases of analysis, Database Design, Screen development, Report Development and Documentation.

Description:

These three application are used by AT&T telecom company for their Project Management, Coupon issues to the customer and for Did not order.

Project: Delivery 9.0- Cloudscape(Social Networking)

Technology: ASP.NET 4.0, C# 4.0, Web services, SQL Server 2008, JavaScript, AJAX, SQL Server Reporting Services 2008, Framework 4.0, Design Pattern, 3-Tier, LINQ to XML

Client NIIT Ltd

Team Size 1

Duration Oct 2011 30 July 2012

Contribution:

Involved in all phases of analysis, Database Design, Screen development, Report Development and Documentation.

Description:

Cloudscape is the Social Networking site for NIIT Students where NIIT Students and Staff have the option to create Blogs, Groups, Discussion, Chat, Calendar etc. Cloudscape is being monitored on the different level

For example Admin, Staff/Centre Head and Student. This Web Application is also CRM enabled.

Project: Delivery 9.0- Cloud Lab

Technology: ASP.NET, C#, Web services, SQL Server 2008, JavaScript, AJAX, SQL Server Reporting Services 2008, Framework 4.0

Client NIIT Ltd

Team Size 2

Duration Aug 2011 30 July 2012

Contribution:

Involved in all phases of analysis, Database Design, Screen development, Report Development and Documentation.

Description:

Cloud Lab is basically Web Application providing a platform to all NIIT digital students to attend the Machine Room (Lab) online. It is based on the cloud concept

Project: Delivery 9.0- Cloud Lecture

Technology: ASP.NET, C#, SQL Server 2008, SSRS 2008,Framework 4.0, JavaScript, AJAX, Web Services, Window Services

Client NIIT Ltd

Team Size: 2

Duration Aug 2011 30 July 2012

Contribution:

Involved in all phases of system analysis, Database Design, Coding, Documentation and Maintenance.

Description:

CLecture is a web application where faculty can create Online Presentations or Seminars for student to provide them Lectures online.

It has 5 Modules, Creating cLecture, Booking cLecture, Cancellation and Accessing cLecture.

Project: Cloud Courseware System- E-Book Reader 2.0

Technology: WPF, C#, SQL Server 2008, SSRS 2008, JavaScript, AJAX, XML, Asp.Net

Client NIIT Ltd

Team Size: 3

Duration March 2011 to 30 July 2012

Contribution:

Involved in all phases of system analysis, Database Design, Coding, Documentation and Maintenance.

Description:

E-book Reader 2.0 is the application which as several modules like you can creates notes, shares your notes with your friends, Faculty can share Notes or Lecture important topics with students. You can create annotations and highlights. You can login into any NIIT student site using CCS.

Project: Complaint Register

Technology: ASP.NET, C#, Web services, SQL Server 2008, XML, JavaScript, AJAX, Microsoft word document library, Framework 3.0, API

Client U.P Government

Team Size: 3

Duration Nov 2010 to March 2011

Contribution:

Involved in all phases of system analysis, Database Design, Coding, Documentation and Maintenance

Description:

This project is developed for the RDSO employees to automate the whole process of registering their residential & official complaints. These complaints are managed by foreman. Foreman allots these complaints to staff and updates the status of complaints as it is attended, or partially attended. Senior authorities can set priorities to some specific complaints. The priority of complaints can be seen by their color combination set according to level of authority. Once the complaint is attended, an email or sms is generated and received by the user who has registered the complaint. These complaints are monitored through various time based reports.

Project: Pharmaceutical Product

Technology: WinForm, C#, Web services, Window Service, SQL Server 2008, SSRS 2008, Asp.Net

Client U.P Government

Team Size: 2

Duration Sep 2010 to Nov 2010

Contribution:

Involved in all phases of system analysis, Database Design, Coding, Documentation and Maintenance.

Description:

This product was used to keep track of medicines, customers and Bills with high flexibility based on client requirements. Each Module in this Product is individual product in itself.

Project: Advertising and Circulation Management

Technology: WinForm, C#, Web services, Window Service, SQL Server 2005, SSRS 2005, AJAX, Asp.Net, Crystal Reports

Client AAJ Newspaper

Team Size: 3

Duration July 2010 to Feb 2011

Contribution:

Involved in all phases of system analysis, Database Design, Coding, Documentation and Maintenance.

Description:

They manage their distribution of paper in different cities and keep the track of suppliers. It also includes small section of accounts where they manage supplier security amount and how much has been paid to their supplier and how much is Due. Each Advertisement has a valid period and involves money for that advertisement. This application keeps track of all advertisement and prompt automatically if any advertisement period needs to renewed or halt. If client didn’t pay the full amount then it will show you till when client advertisement is valid so they can take appropriate action.

ACADEMIC RECORDS

Education : 12th from King George Inter College, July 2004.

: 10th from King George Inter College, July 2002.

PERSONAL DETAILS

Name : Ashutosh Tripathi

Father’s name : S.B Tripathi

Gender : Male

Address : L 67 Malviya Nagar, New Delhi

Date of Birth : 14th October 1986

Marital Status : Single

Nationality : Indian

Strengths : Good Analytical Skills, Sincere & Hardworking and Good Team Player.

Contact this candidate