Sql Server Quality Assurance

Ashish Sharma Mobile: +91-888*******

Email:************.***@*****.***

Career Objective:

To pursue a challenging career which utilizes my knowledge and skills in Developing field to the maximum extent in an organization that can exploit my present skills and provide a platform for career growth and learning.

Experience Summary:

Over 9 years of well experience in the field of IT specializing in the internet development, Object Oriented Programming, Relational Database, Graphical User Interfaces and client/ server architecture with Microsoft .Net Platform 3.5, 4.0 and 4.5 using ASP.Net, VB.Net, C#.Net, HTML, XML, Java Script, SSIS ETL Packages, Web Servers like Microsoft IIS, Databases like SQL Server, DB2, MySQL and Oracle Spatial database.

Experience on working with Geo-Spatial Tool Stack ranging from spatial databases to various visualization APIs. Had knowledge on various processes like Geo-Coding with MapXtreme & MapInfo Toolset Data Preparation & Data Modeling for GIS Applications etc.

Exposure to all phases of Software Development Life Cycle including requirement study & analysis, technical & functional specifications, module development, integration & implementation, testing, monitoring critical paths and taking appropriate decisions.

Having excellent skills with involvement in full life-cycle development using agile methodologies.

Having strong analytical skills with proficiency in debugging and problem solving.

Generated ETL packages using SQL Server Integration Services (SSIS).

Always adherence to architectural standards, coding standards, technical approach and best practices with good knowledge in CMMI level process.

Experience working in an Agile/SCRUM environment.

Knowledge of Configuration Management tools TFS, SVN and VSS (Visual Source Safe).

Experience in the Insurance, Finance and Telecom Application Domain.

Exceptional analytical, problem solving and excellent communication skills and client interaction skill vital for both development and production environment.

Education:

M.C.A from IEC College of Engineering & Technology, Noida which’s affiliated to U.P.Technical University in 2006.

B.C.A from College of Information & Management which’s affiliated to M.C.R.P. University in 2003.

Skills:

Technology

ASP.NET, VB.Net, ADO.NET, AJAX, XML, HTML, JavaScript, JQuery, LINQ, Crystal Report, Web services, WCF and SSIS ETL Packages

Languages

VB.Net, C#.Net, SQL, C#, C++

Data Base

MS SQL Server 2005 - 2008, SSIS, DB2, MySQL and Oracle

Operating System

Windows XP/ Windows 7

Tools

Microsoft Visual Studio, MapXtreme, MapInfo and Geo Spatial Server

Web Servers

Microsoft Internet Information Server

Domains

Insurance, Telecom and Banking

Version Control

TFS 4.5, SVN and Visual Source Safe (6.0)

Professional Experience:

Working with Computer Science Corporation (CSC) India Pvt. Ltd, Hyderabad as Professional Application Delivery since Nov 2013 onwards.

Worked with ValueLabs, Hyderabad as System Analyst since July 2012 to Nov 2013.

Worked with Ebix Software Asia SEZ Pvt. Ltd, Noida as Sr. Software Engineer since April 2010 to June 2012.

Worked with IL&FS Ecosmart Ltd, Noida as Software Developer since April 2007 to April 2010.

Project # AT&T Client Survey System

Environment: Microsoft Visual Studio 2012 and Window 7

Programming: Asp.Net, C#, Ado.Net, Ajax, JavaScript, WCF and SSIS ETL Packages

Database: SQL Server 2008

Team Size: 3

Client: AT&T Inc.

Domain: User Experience Management

Description: The Client Surveys System is a tool which enables groups within the ITO organization to measure how their performance meets the expectations of their clients. The mission of CSS it to identify areas where processes can be improved. CSS is database- driven with a web interface for presenting survey questions to clients and survey results to responsible ITO managers. There are three primary components to CSS – a database backend which processes the surveys and emails the survey solicitations to the requested clients, a web interface for the clients to complete the surveys, and a web interface for survey administrators to view reports on the survey results.

Responsibilities:

Following the Agile methodology process to ensure quality assurance throughout the development lifecycle.

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Ensure code written meets the predefined organizational standards and successfully delivered on time.

Client Interaction to gather relative information.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Project # EPP Ultra (Underwriting Technology Services)

Environment: Microsoft Visual Studio 2012 and Window 7

Programming: Asp.Net, C#, Ado.Net, Ajax, JavaScript and WCF

Database: SQL Server 2008

Team Size: 5

Client: Zurich North America U.S

Domain: Insurance

Description: EPP Ultra platform includes Ultra/Ultraflex and Zplus application to support underwriting process in various business units in Zurich including Specialties, Commercial Markets and Global Corporate. The system is a fully functional policy-writing system that supports quoting, rating, binding, issuance, policy printing (via EDD) and feeds to interfacing systems. It supports New Business, Endorsements including out of sequence, cancelation and reinstatement transactions as well as some automated renewal processing depending on the policy type.

Responsibilities:

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Follow appropriate process and controls to ensure quality assurance throughout the development lifecycle.

Ensure code written meets the predefined organizational standards and successfully delivered on time.

Project # ASTRO - Malaysian Satellite Television and Radio Operator

Environment: Microsoft Visual Studio 2010 and Window 7

Programming: ASP.Net, C#, Ado.Net, Ajax, JavaScript, Entity Framework and Web Services

Database: SQL Server 2008

Team Size: 4

Client: ASTRO

Domain: Multimedia

Description: Astro is the brand name of the Malaysian direct broadcast satellite (DBS) Pay Television service. It transmits digital satellite television and radio to households in Malaysia & Brunei. The name Astro is an acronym for All-Asian Satellite Television and Radio Operator. We support services in the areas of broadcasting and Digital Media. Astro is owned and operated by Astro Television Network System a wholly owned subsidiary of Astro Malaysia. It has operations at All Asia Broadcast Centre located in kualalumpur Malaysia.

Responsibilities:

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Follow appropriate process and controls to ensure quality assurance throughout the development lifecycle.

Ensure code written meets the predefined organizational standards and successfully delivered on time.

Project # GFK NOP - UK (Customer Experience Management Program)

Environment: Microsoft Visual Studio 2010 and Window 7

Programming: ASP.Net, C#, Ado.Net, Ajax, JavaScript and Web Services

Database: SQL Server 2008

Team Size: 5

Client: GFK Group Ltd. (United Kingdom)

Domain: Sales & Marketing

Description: GfK NOP Limited, a market research company, provides market and consumer information. Customer Experience Management Programmed Website is an online multilingual, progress tracking system which allows the clients / dealers to maintain their car deals and client satisfaction information online like stand alone application. It allows clients / dealers to access car sales and client feedback information etc; it allows generating charted reports like Answer Distribution Question Answer Distribution Hierarchy, and Answer Distribution Time, Action Summary, Question Trending, KPI Market, KPI Question, Improvement Calculator etc. Customer Experience Management Programmed (CEMP) Website contains three integrated systems 1) Admin site developed for GFK Admins which caters Administration purpose 2) Jaguar system which caters for jaguar users and 3) Land rover system which caters for land rover users. Once users successfully logins to Jaguar and Land rover systems CEMP website provides widgets / igoogle gadgets like provision through which end user can drag desired widgets to work area (workspace).

Responsibilities:

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Follow appropriate process and controls to ensure quality assurance throughout the development lifecycle.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Ensure code written meets the predefined organizational standards and successfully delivered on time.

Project # Telecom Resource Planning Tool – Product TRPT

Environment: Microsoft Visual Studio 2005 and Window XP

Programming: VB. Net, C#.Net, Ado.Net, MapInfo & MapXtreme

Database: SQL Server 2005

Team Size: 3

Client: Airtel, TataDocomo and Uninor

Domain: Telecommunication

Description: This project is an implementation of GIS for Wireless Telecom Planning Support and it supports standard GIS viewing. The application also uses standard models to predict coverage and microwave link status. Route Information Report that is used to find the distance between layers and what types of highways are coming within Circle Boundaries. The main works which can be done by this program are:

Finding site at a given latitude and longitude

Finding location of a particular site based on Site Id, Site address or Town

Exporting result and snaps of the site to reports (in MS Excel File) information for a site (info tool)

Calculating distance between two sites (Ruler tool)

Loading GIS layers on Map such as National-Highway layer, Boundary Layer, Clutter and DTM Layer

Uploading Planned layer

Generating Coverage and azimuth directions for planned sites as well.

Responsibilities:

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Follow appropriate process and controls to ensure quality assurance throughout the development lifecycle.

Ensure code written meets the predefined organizational standards and successfully delivered on time.

Project # Common Service Centers – Product CSC

Environment: Microsoft Visual Studio 2008 and Window XP

Programming: ASP.Net, C#, Ado.Net, Ajax, JavaScript and Web Services

Database: SQL Server 2008

Team Size: 5

Client: Indian Govt.

Domain: Telecommunication

Description: Common Services Centers (CSCs) enabled front end service delivery points at the village level for delivery of Government, Financial, Social and Private Sector services in the areas of agriculture, health, education, entertainment, FMCG products, banking, insurance, pension, utility payments, etc. CSCs are multiple-services-single-point model for providing facilities for multiple transactions at a single geographical location. The main purpose of these centers is to provide a physical facility for delivery of e-Services of the Government of India to the rural and remote locations where availability of computers and Internet is currently negligible or mostly absent. The introduction of governance on a massive scale is part of the Common Minimum Programmed (CMP). The main works which can be done by this program are:

Access to information : all remote/ rural citizens

Access to quality education / skill upgradation

Access to cost efficient & quality health services

Responsibilities:

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Follow appropriate process and controls to ensure quality assurance throughout the development lifecycle.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Ensure code written meets the predefined organizational standards and successfully delivered on time.

Project # Society Loan System – PNB Bank

Environment: Microsoft Visual Studio 2005 and Window XP

Programming: VB. Net, C#.Net, Ado.Net and Crystal Report 9.0

Database: SQL Server 2005

Team Size: 3

Client: Punjab National Bank

Domain: Banking

Description: This project is useful for the HR department for maintaining the complete information of the total loan distribution and recovery for any society.

Bank offers loan assistance to Societies are Personal Loan, home loan etc.

Loan for Purchase of Land and Completion of project

Loan for Installation of Electric Sub Station (ESS) and development

Loan for exterior development of Group Housing Complex

I

Responsibilities:

Design and develop Web Applications / Reports and delivering the functionality detailed in the technical specifications.

Involved in code review and Writing/Modifying Stored Procedures, functions etc. in SQL Server.

Ensure code written meets the predefined organizational standards and successfully delivered on time

Personal Profile:

Name: Ashish Sharma

Data of Birth: 17th Feb 1983

Nationality: Indian

Languages: Hindi & English

Marital Status: Married

Address: Venkat Sai Enclave, Madhapur, Hyderabad (A.P) - 500081

Date:

Place: Hyderabad (Ashish Sharma)

Contact this candidate