Sales Sql Server

Shyni Narayanappa

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

Cell: 804-***-****

PROFESSIONAL SUMMARY

. 7 years and 6 months of experience in all stages of SDLC (software

development life cycle)

. Experience in Development of Applications based on.NET and MS SQL Server.

. Experience in Development of SSIS Packages.

. Experience on C#.NET, ASP.NET, ADO.NET, .NET Framework 3.5, SQL Server

2008 and SSIS (ETL).

. Extensive experience in Relational Database Design, Query Optimization

and Implementation of database objects like Tables, Stored Procedures,

temp tables, CTE using MS SQL Server

. Have a good communication skill, proactive, well organized and an

efficient team player.

TECHNICAL SKILLS

. Programming Languages : C#, ASP.NET

. Web Technologies : ASP.NET 3.5, HTML, CSS

. Web Server : IIS 6.0/7.0

. Database : SQL Server 2008/2005/2000, SSIS, SSRS

EDUCATION

Bachelor of Engineering in Computer Science (B.E) - Anna University, 2005

PROJECT EXPERIENCE

Cognizant Apr' 14 - Sep 14

CLIENT: CHARMING CHARLIE

ASSOCIATE

SLAM - Store Level Allocation Management

Project Team size : 3 people

PM Methodology : SDLC

Environment : C# .Net, ASP .Net 3.5, IIS 6.0,

SQL Server 2008, SSIS

About Charming Charlie

Charming Charlie is an American retailer, established in 2004. It

sells women's apparel and accessories, including jewelry, sunglasses,

scarves, purses, wallets, clothes, shoes, and other items.

There are 284 Charming Charlie locations within the United States.

Project Description:

Allocators use this tool to select the PO's and then allocate it

across different locations. Output of the Allocation tool will be a XML

file with all the allocation quantity, style and location information

SLAM has the following modules

. PO WorkList

. Grading/Allocation Screen

. Reserve Grading

. Distro WorkList

. Reserve Distribution

. Admin Page

Responsibilities:

. Developed several ASP.NET Pages.

. Developed classes and interfaces for the Data Access layer using

ASP.NET, ADO.Net and SQL 2008 data access library

. Participated in writing Stored Procedures for performing optimization

and other database operations such as complex SQL queries using CTE

and temp tables.

. Developed SSIS Packages to extract data from various sources and load

data to different destinations like Database, flat files.

. Performed Unit Testing and Integrated Testing.

QPID - Quality Product Information Dashboard

Project Team size : 2 people

PM Methodology : SDLC

Environment : C# .Net, ASP .Net 3.5, IIS 6.0,

SQL Server 2008, SSIS

Project Description:

QPID application is to test and track the Quality of the Sample

Products purchased from a vendor and analyze the products for its Sale. It

goes through a number of Validations process over a Series of Workflows to

validate the product obtained from a Vendor. The landing page of the

Application is QAProductTracker.aspx.

The Quality Analysis is been done and there are various levels of

criteria to be passed by the product. The workflow is that, the product

will be moved to the next level test only after it passes the previous

level.

QPID has the following modules

QA Product Tracker

QA Analysis

Sample Tracker

Sample Analysis

Export to Excel

Responsibilities:

. Developed several ASP.NET Pages.

. Developed classes and interfaces for the Data Access layer using

ASP.NET, ADO.Net and SQL 2008 data access library

. Participated in writing Stored Procedures for performing optimization

and other database operations such as complex SQL queries using CTE

and views.

. Developed SSIS Packages to extract data from various sources and load

data to various destinations like Database, flat files.

. Performed Unit Testing and Integrated Testing.

. Involved in Maintenance activities for QPID

INFOSYS TECHNOLOGIES Feb' 08

- Feb' 13

CLIENT: LEXISNEXIS

TECHNOLOGY ANALYST

About LexisNexis

The LexisNexis services streamlines the workflow by providing its

client with the convenient access to authoritative legal, news, public

records, and business information. It services give you immediate access to

the most comprehensive range of information resources in existence. This

includes the entire spectrum of news and legal information - from case law

and codes to premium sources like public records etc.

Sales Source

Project Team size : 6 people

PM Methodology : SDLC

Environment : C# .Net, ASP .Net 3.5, IIS 6.0,

SQL Server 2008, SSIS

Project Description:

Sales Source is a LexisNexis system under which they have a suite of

applications namely the Sales Source Online, Sales Source Offline, NEST

(New and Existing Sales Tracking), etc. This system is used by the Sales

Representatives for processing the Online and Offline orders placed by

their customers.

Sales Source Online- This Online Application provides the subscriber, with

the complete access to a universe of useful content. The extensive online

databases give the subscriber the full access to billions of indexed and

searchable documents. Many documents contain editorial enhancements, Head

notes written by the attorney editors.

Sales Source Offline - The LexisNexis Bookstore offers an opportunity to

purchase a broad range of LexisNexis books, CD-ROM products, forms, and

software- complete with compilations of volumes by known experts,

jurisdictional publications, and more. These Product listings within the

online bookstore have their individual pricing.

The Sales Source Online and Offline have the following modules:

. Capturing the customer Information,

. Different products availability

. Product Pricing and subscription options for online products

. Billing information

. Product Recap

. Submit Order

Responsibilities:

. Developed several ASP.NET Pages.

. Participated in writing Stored Procedures for performing optimization

and other database operations such as complex SQL queries and views.

. Performed Unit Testing and Integrated Testing.

. Involved in Maintenance activities for Sales Source.

. Resolved production support issues efficiently and closed on time on

day-to-day bases

Sivasakthi Software Solutions and Services

Client: Kamar-Silver Ltd

May' 07 - Jan' 08

PROGRAMMER

Inventory Control System

Project Team size : 4 people

PM Methodology : SDLC

Environment : VB.Net, SQL Server 2005, ADO.Net

Client: ZXY Apparel Buying Solutions Ltd

Aug' 05 - May' 07

PROGRAMMER

Vitzas - Visual Info Tracker for the Zonal of Apparel Services

Project Team size : 6 people

PM Methodology : SDLC

Environment : VB.Net, SQL Server 2000, ADO.Net

Declaration:

I hereby declare that the information furnished above is true to the best

of my knowledge.

Place : Fremont, California

Date :

(Shyni Narayanappa)

Contact this candidate