Sql Server Customer Service

**** *** **** *** [pic]

San Jose, CA *****

Cell: 408-***-****

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

Phone: 408-***-****

RAJAN NUMBOOTHIRI

Professional Summary:

. Full stack developer with Over 16 years of experience in analysis, design

and development.

. Worked with Object Oriented methodologies, Client/Server and Web-based

platform using .NET, C#, SQL server and UI technologies.

. Experience in object relational mapping frameworks like MS Entity

Framework.

. Experience in .NET Framework, Visual Studio, ASP.net, C#, Linq, Web

Services, Ajax, Web Forms, MVC, Web Api.

. Front-end development experience in JavaScript, JQuery and JSON, AJAX.

. Developed standard compliant UI using HTML, XHTML, and CSS.

. Experience in application merge and version control system like Visual

Source Safe, Team foundation server (TFS)

. Experience in working and handling IIS server like create website,

application pool and URL Rewrite rules.

. Extensively worked with Multi-tier architecture and web-based

applications with relational database like SQL Server.

. Experience in Database design and working with SQL-Queries.

. Experience in creating/modifying table, stored procedures, functions and

views.

. Experience in third party integration tools like Google Analytics, Buy

Safe, Link Share, Power Review and SLI search engine

. Experience in Ecommerce development like Commerce Server and nopCommerce

. Experience in Data migration by using SSIS package.

. Experience in development of window based application and services.

. Experience in CMS (Content management system) Umbraco

Technical Skills:

Databases MS SQL Server 2012/2008/ 2005, 2000, Sybase, Oracle 10, Informix

7 and Access.

Languages .Net (1.1, 2.0, 3.5, 4.0, 4.5) C#, MVC 4, Entity Framework, Web

/ Tools Api, VB.Net, ADO.Net, Web Services, Window Services, WWF, WCF,

LINQ, Ajax, XML Visual Studio .Net 2005/2008/2012, Visual Source

Safe, TFS, IIS 7, VB 6.0, ASP, COM components, Business Objects,

VBSCRIPT, JSCRIPT, XSLT, HTML, DHTML, MTS, OLEDB, ODBC, OOP,

JAVA 1.2, Applet, JDBC, DDE, OLE, Java script, CGI, PERL 5.0,

Shell script, Cold Fusion Mx, Power Builder 6.5, Excel, MS-Word,

VBA, DTS, DB Artisan 5.02, Cast Work Bench 3.7, R&R Report

writer 6.5, C, DB-Library, Windows SDK, MS-LAN Manager, TCP/IP,

WinSock, Win query 1.1, MS-Cobol, RPC, ISQL, BCP, Transact-SQL,

SQL anywhere, ER-Win, PL/SQL, Win runner.

OS Windows 7, Windows server 2003/2012, NT 4.0, Windows 2000 XP,

HP3000/9000, HP-UX 9.04, Sun OS 5.6, MS-DOS.

Hardware PC, Sun, HP, SGI.

Education / Certifications:

. Post Graduate Diploma in Computer Science and Database Design - Annamalai

University, India

. Graduate in Commerce and Finance - State board of Technical Education,

Madras, India.

. MCSD.NET

- Develop Web Applications using MS Visual C#. NET.

- Develop Windows Forms Applications using Visual C#. NET.

- Develop XML Web Services and Server Components with MS Visual C#.

- Design and Implement Databases with MS SQL Server 2000 Enterprise

Edition.

Employment Status: US Citizen

Professional Experience:

Apr 2009 - Sept 2014 DHC USA Inc. San Francisco, CA

http://www.Dhccare.com

Project: Ecommerce solution for online shopping.

Environment: .ASP.Net 3.5/4.5, C#, MVC 4.0, Entity Framework 5.0, Web Api,

VS 2010/2012, ADO .net, Commerce Server 2007, nopCommerce3.40, Umbraco

(CMS), IIS 7, AJAX, JSON, JQuery, XML, JavaScript, HTML5, DHTML, CSS,

COM, DLL, Window services, Web services, ReSharper.

Windows server 2003/20012, Windows 7 and SQL Server 2005/2008/2012. QAS

online address verification

Responsibility: Senior Software Engineer

Involved in web design and development by using Asp.Net, MVC, and C #,

JavaScript, Html and CSS.

Developed Models, Views (Razor) and Controllers for the application.

Developed very user friendly interface for online shopping and implemented

shopping cart business functionality include special discount, sample page,

review interface.

Using Commerce Server/nopCommerce to create and maintain category and

product information.

Developed new plug-in based on nopcommerce API services for the special

discount and online payment. Implemented Address verification system on the

checkout page to verify their shipping and billing address and provide

address suggestion for the customer to pick correct one.

Developed window based service application to export data to the third

party like Google, Power Review and Link share.

Involved to create new website by using IIS7, secure the website by

implementing SSL and create rules for URL rewrite for each country.

Developed complex Database structure, stored procedures, cursor and

functions in SQL server.

Used Entity Framework ORM to access the records from database.

Developed complete SDLC and the flow of shopping cart and checkout page

September 2007 - Mar'2009 Thru Inc. San Jose, CA

Project: Content Delivery and Managed File Transfer Application. - File IRM

protection, security and notifications.

Environment: ASP .Net 2.0/3.5, C#, ADO .net, VS 2005/2008, XML, XSLT, ASP,

VBScript, Ajax, Java Script, IIS, HTML, DHTML, COM, DLL, Window services,

Web services, windows 2003, CSS, OCX control and SQL Server 2005.

Responsibility: Senior Software Engineer

Involved in development of all application layers including database

objects, data access business-logic and web presentation. Developed this

software as SaaS to the client (Software as a Service).

Developed Thru web services APIs to support messaging and publishing for

desktop and SharePoint clients.

Developed detailed email management functions to support system

registration, notification subscription, retention policies, drop box

upload and content publishing.

Designed and developed role based access control where depending on user

role the application filters the functionality and the level of information

the user sees. Project included integration with publishing, IRM,

Retention and message archival.

Implemented secured sign on method to access web applications including

secured and encrypted user information and distribution message. Created

enterprise level access control database to manage users, roles and

configuration settings through web application. Used unique session tokens

and .NET encryption to maintain the security for crossing between

application pages. Administrator can manage the user logins and profiles

using this application for that site.

Implemented reporting tools to generate the distribution level reports for

their accounting purpose.

June '2004 - September 2007 Fiserv ImageSoft Technologies Redwood shores,

CA

Project: Exchange Guard and Fraud Guard.

Environment: ASP .Net, Using VB and C# .net, ADO .net, XML, XSLT, ASP,

VBScript, Java Script, IIS, HTML, DHTML, COM, DLL, Window services, windows

2003, CSS, VB6.0, OCX control and Oracle 10 database.

Responsibility: Senior Software Engineer.

The Fraud Guard solution platform is designed to provide the financial

institution the functionality necessary to perform fraud detection for

multiple operational scenarios. Exchange Guard is the alternative to

presenting physical paper checks by transmitting electronic images of

checks during the settlement process.

I have developed user interface screen that will be used for monitor the

process and setup the forms related to the accounts using ASP and VB

.Net. Written lot of class library for windows services, which is used by

other services within the system. Using oracle I have developed all

packages for insert, update, delete and select the data. Used third party

OCX and COM components for digital interrogations verification purpose

within the .Net framework, Java script used for client side validation.

Jan '2003 - May 2004 CardEx.com, Irvine, CA

Project: Shopping cart.

Environment: ASP.Net, Using VB and C# .net, ADO .net, XML, XSLT, ASP,

VBScript, Java Script, IIS, HTML, DHTML, windows 2003, CSS, VB6.0, SQL

server 7/2000 database.

Responsibility: Programmer Analyst, design and development.

The main functionality of this application customer can purchase the gift

card through on-line. Customer can activate their gift card on-line once

they received. Gift card can be used as like other normal credit card.

Developed com components for interact with cyber source for credit card

payments. Customer can cancel their order through on-line also if they

want. Customer can choose predefined card message or they can write their

own custom message when the place an order, It will be printed on the gift

card. I have developed portal shopping cart for individual customers like

master card, star wood hotel and COX communications. Portal customers they

have separate login and their own shopping card designs. They can place an

order for their employees like award gift card or promotion gift card. I

have developed in house tools to maintain all the customer service

functionality using .Net and SQL Server 2000.

Sep '2001 - Nov '2002. Dolby Laboratories Inc, San Francisco, CA.

Project: License Accounting System

Environment: VB 6, VB.NET, Visual Studio 6, VS.NET, MTS, ADO.NET, ASP .NET,

Visual Source Safe, Crystal Report 6/8, VBA, SQL server 2000 database.

Responsibility: Programmer Analyst and system design and development.

This application developed based on three-tier concept. All the business

methodology is running under middle tier component. This application will

track of the each licensee royalty payment to the company. The Licensee

pays the royalty to the company for using the Dolby sound technology and

their trademark. Every month each licensee will send the product

information like how many products their sold and how many products are

patent and non-patent. Based on that information this application will find

out how much royalty each licensee has to pay based on their sold product

statement. The licensee will pay the royalty amount quarterly base. Each

licensee has their own agreement with the company based on that the

licensee will pay for patent and non-patent product different rate of

amount for the different product, To calculate the royalty it involves

other factors like licensee based on which country and whether technology

has been patent on those countries or not, depending on that the licensee

will pay the royalty to the company. This application will do all the

validation and calculate the royalty and generate the account receivable

for the each licensee.

Mar '2000 - Aug '2001. Prepass.com, San Jose, CA

Project: PrePass system (NGS)

Environment: VB, ASP, Cold Fusion, IIS, Java Script, ODBC, Crystal Report,

Windows-2000, NT, SQL server 7/2000 and Informix 7.0

Responsibility: front-end and Back-end design and development.

The PrePass system consists of weigh station sites, site servers, the

central PrePass site, the central database server, and any number of

PrePass clients. The Weigh station sites and site servers are responsible

for gathering data about bypass activity at the site.

The data from each of the sites will be stored in local database and also

transferred to the central site in a flat file format.

The remote site data will be gathered by the central Pre Pass system. It

will poll each site at regular intervals and download the remote data file.

This file will then be processed and loaded into the central database

server. The PrePass clients will use the data stored in the central

database server to process applications, generate invoices, and other

command and control functionality. PrePass is a client-server system

consisting of unlimited number of PrePass App clients and SQL Server

database.

Feb '97 - Feb '2000. Dresdner RCM Global Investors, San Francisco,

CA

Project: Straight through processing (STP)

Environment: SQL Server 7, VB 5/6, Business objects, Power Builder 6.5, HP

9000 Unix 9.04, Sun OS 5.6, Windows NT 4.0, Novel net ware, Rapid SQL 5.1,

Cast workbench 3.7, HTML, Java 1.2, J-connect, Applet, CGI, Shell and PERL,

ER-Win, Sybase.

Responsibility: Programmer analyst, design and development. Team lead

The STP application was developed to expedite the transaction advice to

various parties. The method used are electronic notification via the

Depository Trust Company (DTC) to Brokers, electronic notification via

ISITC/BRAID to custodian banks and manual via fax or post to custodian

banks, clients and consultants.

The application is composed of three modules, namely Affirmation,

ISITC/BRAID and Bank Letters.

Project: Import and export data from various Systems

Involved in the following application development.

. ID Master (Maintenance of Client, Accounting information)

. Headcount (Maintenance of global employee information)

. Bcomm (Maintenance of broker's commission details)

. SPS (Saratoga productivity system)

. Straw head (Analysis report for Buy and sell the security)

. AUM (Maintenance of Assets under management system)

Jan '97 - Feb '97. Silicon graphics, Mountain view, CA

Project: Sybase DBA

Environment: Scyborg, Sybase System 10, UNIX, Perl.

Responsible for administrate the database. Involved in importing data from

Scyborg to Sybase System 10 using PERL Script, Stored Procedures and

triggers.

Sep '95 - Dec '96 Grubb & Ellis, San Francisco, CA

Project: Revenue System

Environment: HP9000 HP-UX 9.04, PC 486sx, MS-TCP/IP, Sybase 4.9 Server,

Visual Basic 4.0/3.0 Professional (ODBC client & server architecture), MS

Windows

For Workgroups, Rapid SQL 1.51, Win-query 1.1, DB Artisan 2.5, R&R Report

Write. NT 4.0, MS-SQL Server 6.5.

My role in this project was as DBA and Programmer Analyst. As an Analyst

it included writing stored procedures, triggers, view, and rules using

Sybase 4.9. Also wrote SQL script to create tables and indexes. Involved

in system design, data normalization, tuning queries and stored procedures

for best performance. Developed front-end screens and programming using

Visual Basic (ODBC), which captures user defined error messages from

triggers or stored procedures and displays it on the user's screen. Using

OLE for report DLLS. Create the database devices and the log devices.

Create the tables, triggers, indexes and stored procedures. Performance

tuning, diagnosing system problems. Bulk copy and backup and recovery.

May '95 - Jul '95 Microsoft Consulting Services San

Francisco, CA

Project: Energy Information Service Trial

Environment: Visual Basic, Windows NT 32-bit DLL, MS-SQL Server, Winsock,

Banyan Wines, Windows NT 3.5, C, DB-Library, ODBC

Responsibility: Application Analyst/Programmer

This application was developed for Pacific Gas and Electricity (PG&E)

Company. Was involved in the database design and development of programs

for Blue Bill Import, Each Appliance Meter Reading and Energy Meter Reading

using Windows NT 32-bit DLL, C, SQL Server and DB Library. Using Visual

Basic front-end screens were developed for the customer to enter and review

the account and TOU information. Stored procedures and triggers were used

for data insert and retrieval through ODBC. Wrote DLL for getting

information from UNIX data files using Win socket. Windows Socket DLL and

C were used to develop the DLL.

* *

Contact this candidate