Management Manager Sql Server .Net Development

Gokul Ramachandran

Monterey,

California,

USA.

Email: abnvpe@r.postjobfree.com

Cell: 312-***-****

Summary:

Microsoft Commerce Server Consultant with 7+ years of hands on experience with Microsoft

•

technologies.

Has been playing an Architect’s role during the initial phase of the last project.

•

Microsoft Certified Technology Specialist in Web Development.

•

Preferred programming language: C#, be sharp

•

Participated in all phases of System development life cycle (SDLC) like System Analysis,

•

requirements gathering, specification/documenting, designing, coding, testing, debugging,

application evaluation and implementation of complex systems

Extensive experience in designing and developing solutions using .NET Framework, Visual

•

Studio .NET, C#, ASP.NET, VB.NET, ADO.NET, ASP, VB 6.0, MS-SQL Server 2000, T-SQL,

DTS Packages, UML, Rational Rose, XML, XSLT, Web Services, SOAP, WSDL, COM, Java

Script, VB Script and IIS

Strong in Microsoft Commerce Server, Catalog management, Order Management, Discount

•

Management, Pipeline, pup files, exporting/importing catalogs, multi-lingual sites.

Strong in .Net, C#, ASP.Net, VB.NET Visual Studio.Net, SourceSafe, FxCop, User interface

•

design, project management.

Designed and developed Web Services in .NET.

•

Strong in Microsoft Content Management Server, Templates, Channels, postings.

•

Designed and developed multi-tiered client-server application and windows services using

•

Microsoft technologies such as .NET and COM+.

Expertise at designing and development of Intranet and Internet Web applications using

•

Microsoft technologies such as .NET, ASP.NET, ADO.NET, ADO,ASP, COM+.

Strong knowledge and hands on experience on ASP.NET, ASP, ADO, ADO.NET, XML, XSL,

•

VBScript, HTML and DHTML

Involved in design and development of databases using MS SQL Server, and Oracle.

•

Wrote stored procedures and PL SQL.

•

Mastered the skills with Enterprise Manager, SQL Profiler and SQL Query Analyser.

•

Hands on experience on middle-ware application servers and web servers such as IIS.

•

Handled responsibility of deployment of applications and setting up development

•

environments using tools such as MS Visual Studio .NET, MS VSS.

Education:

B.Tech in Information Technology from Cochin University of Science and Technology

TECHNICAL SKILLS:

Programming Languages: C#, VB.Net

Databases: Oracle 9i, Microsoft SQL Server 2000, Microsoft SQL Server 2005

Servers: Microsoft Commerce Server 2007, MCS 2002, Microsoft Content

Management Server

GUI: VB, HTML, CSS

Operating Systems: Windows NT & 95 98 and XP, Server 2000/2003

Web Technologies: VBScript, Jscript, XML, XSLT, ASP, ASP.NET 1.0, ASP.NET 1.1,

ASP.NET 2.0, Cascading Style Sheets (CSS)

Technologies: Client/Server Architecture, .NET Framework, UML

Data Access: ADO, ADO.NET

Visual Tools: MSTS, Visual Studio 2008, Microsoft Visual Studio 6.0, Microsoft

Visual Studio .Net 2002, Microsoft Visual Microsoft Studio .Net 2003,

Microsoft Visual Studio .Net 2005

Design Tools: Rational Rose 2003, Microsoft Visio 2003, Erwin Data Modeler

Reporting Tools: Microsoft SQL Server Reporting Services 2005

Web servers: Microsoft IIS 5.0, Microsoft IIS 6.0

Testing Tools: FxCop

Version tools: Team Foundation Server, Microsoft Visual Source Safe 6.0, Clearcase

CERTIFICATIONS:

Microsoft:

MCTS

MCP

MS Commerce Server 2002

Brainbench:

.NET Framework

ASP.NET Fundamentals

OO Concepts

Domain:

LOMA 280

VISA Status:

H1-B

PROJECTS SUMMARY:

FootLocker Inc, Los Angeles, USA Jan 2008 – till date

Foot Locker is the world's leading branded retailer in athletic footwear, apparel and accessories.

This project involved development and maintenance of their e-commerce websites which

unleashes the powerful features of the Microsoft Commerce Server 2007 and gives multi-lingual

support.

Reference: http://www.foot-locker.co.uk/

Work Location: Off-Site

Role:

Lead developer for building the e-commerce website.

•

Architect during the initial phase of the project.

•

Requirement analysis, preparation of use case documents, preparing class diagrams and

•

sequence diagrams, detailed design of the module, coding and unit testing and preparation of

independent testing documents for the product catalog.

Designing and developing the payment gateways for credit card payments.

•

Using Commerce Server 2007 Starter Site to build a solid online store complete with product

•

details, shopping cart, checkout processes, and marketing support.

Since the Starter Site itself is having 2-tier architecture; we had to skin out all the Business

•

Logic to create a separate BL. Thus providing more re-usability, extensibility and security for

the solution.

Identified, designed and created definitions like property definitions, category and Product

•

definitions.

Created base / virtual catalogs for the different countries in Europe.

•

Extended the pipeline components to satisfy the specific business requirements.

•

Used Enterprise Library for the remarkable Exception handling and Logging

•

Used the different tools provided by MCS 2007 viz. Catalog Manager, Marketing Manager,

•

Catalog, Inventory Schema Manager, Customer and Order Manager.

Did BIBIT integration for payment fulfillment.

•

Did integration with UPS for shipment and returns.

•

Designed web pages using ASP.NET

•

Allstate Insurance, Chicago, USA Feb 2007 – Dec 2007

The Allstate Corporation is the USA’s largest publicly held personal lines insurer and is a Fortune

100 company with $156 billion in assets.

This project involved the development and supporting of many the C#.NET, VB.NET, applications

for Imaging and Workflow processes.

• Got appreciations from very top level management for suggesting and implementing a

revolutionary idea which helps the support personnel to start / stop / restart any service

or server from a pager or a cell phone.

Work Location: Onsite

Role:

Obtained recognition award for the second time from my company for noteworthy contributions

•

towards the project.

Got special recognition for the innovation that I had done. This innovation amused a lot many of

•

our clients including the Relationship Manager for Application Development, Testing and

Operations.

Leading and mentoring the team of 4.

•

Onsite coordinator for the team of 4

•

Identified various manual production support tasks that can be automated.

•

Designing the automations of production support tasks.

•

Used FileNet as an image repository

•

Used Captiva’s InputAccel as the software to capture images that come in as fax, mails etc.

•

Used the supervisor of IA for manipulating with batches, processes, modules, etc.

•

Drawing the best possible solution for the requirements and getting it done by the offshore

•

team.

Production support for the Imaging and workflow applications

•

PerkinElmer, Boston, USA Nov 2005 – Jan 2007

Punchout eCommerce implementation of PerkinElmer

Creating a punchout application (B2B) for PerkinElmer so that their clients can access our e-commerce

site through spend-management softwares like Ariba Buyer, EBP, M-market etc.

Also, obtaining the “Ariba Ready” certification by making the application compliant to the Ariba’s

suggested standards.

Work Location: Onsite

Role:

Implementation and Integration of Microsoft Commerce Server 2007 for B2B.

•

Interacting with the clients directly to understand their actual requirements.

•

Leading and mentoring the team of 4.

•

Drawing the best possible solution for the requirements and getting it done by the offshore

•

team.

Guiding the team on any technical challenges. (Got appreciations from the client for tackling

•

many technical issues. Especially for the revolutionary solution (MCS) provided for the

requirement which was about to be dropped due to the technical challenge involved in it.)

Designed web pages using ASP.NET

•

Did C# programming for application development

•

Did C# programming for encrypting and decrypting the data

•

Did C# programming to get the data from files which are in FTP Server in Hexadecimal

•

format

Designed modules to talk with Webmethods of our clients partners.

•

Developed modules that can communicate using XMLs.

•

Developed C# Class file to convert Hexadecimal to ASCII and ASCII to Hexadecimal

•

String

Applied ADO.NET for database access

•

Created Stored Procedures, Triggers and Views in SQL Server 2000

•

Used Data Grid, Data List and Repeater controls for displaying, Editing and Updating

•

data to database

Developed Microsoft Commerce Server 2007 Applications for Catalog Management,

•

Payment Method and Order Processing

Enhancement of existing Microsoft pipeline objects using Microsoft Commerce server 2007.

•

Created PUP files for the deployment of e-commerce sites in different environments like

•

integration, testing and production

Exporting base/ virtual catalogs so that it can be send to the translators.

•

Importing the translated catalogs so as to create a multi lingual e-commerce website.

•

Developed MCMS templates.

•

Did coding in C# for the MCMS (Microsoft Content Management Server) templates.

•

Created postings from the MCMS templates.

•

Created SDO files for importing the Templates and Channels to the integration environment

•

and then to the production environment.

Implemented Data Binding methods in Server Controls

•

Involved in Unit test, Integration test, System test

•

Involved in Configuration, Debug and Deployment

•

Evaluated performance of application

•

Prepared Technical Reports and Documentation

•

Environment: Microsoft Commerce Server 2002, Microsoft Content Management Server,

SQL Server 2000, C#, .NET, SAP GUI.

PerkinElmer, Boston, USA Apr 2005 – Oct 2005

Dealer eCommerce implementation of PerkinElmer

This project involved the development of a new application for PerkinElmer that will leverage our client’s

business with their dealers across the globe. With our in depth knowledge of the architecture of our

client’s e-commerce site, we were very instrumental in creating a new application for their electronic

business with their clients.

Work Location: Offshore

Role:

Obtained recognition award from my company for my noteworthy contributions towards the

•

project.

Designed web pages using ASP.NET

•

Developed C# programming for application development

•

Leading a team of 3.

•

Solving technical challenges that we came across during the complete life cycle.

•

Implementation and Integration of Microsoft Commerce Server 2002

•

Developed M icrosoft Commerce Server 2 002 Applications for

•

C atalog Management, Payment Method and O rder Processing.

Created P UP f iles for the d eployment of e-commerce sites in

•

different environments like integration, testing and production

Exporting b ase/ virtual catalogs so that it can be send to the

•

translators.

Importing the translated catalogs so as to create a m ulti lingual e -

•

commerce website .

Developed MCMS templates.

•

Did coding in C # for the M CMS templates .

•

Created p osting from the M CMS templates .

•

Enhancement of existing Microsoft pipeline objects using Microsoft Commerce server 2002.

•

Developed MCMS templates.

•

Did coding in C # for the M CMS (Microsoft Content Management

•

S erver) templates .

Created p ostings from the M CMS templates .

•

Created SDO files for importing the Templates and Channels to the integration environment

•

and then to the production environment.

Implemented Data Binding methods in Server Controls

•

Involved in Unit test, Integration test, System test

•

Involved in Configuration, Debug and Deployment

•

Evaluated performance of application

•

Prepared Technical Reports and Documentation

•

Deploying and giving warranty for the application.

•

Environment: Microsoft Commerce Server 2002, Microsoft Content Management Server,

SQL Server 2000, C#, .NET

AON Corporation, Toronto, Canada Dec 2004 – Mar 2005

Coach Application for XPress

Aon Corporation is the world's premier insurance brokerage, consulting services and consumer

insurance underwriting organization. Aon creates value for clients by offering knowledgeable, flexible

and innovative solutions, from mitigating risk to improving human resources.

This project was to evaluate a framework for implementing a Coach feature in XPress, the insurance

application currently used by AON. A floating toolbar concept using .NET framework was to be

developed for integrating with XPress.

The toolbar is capable of controlling the screen navigation, pass data across various flows, state

management, thread management for a given flow, exception handling, and storing and retrieving from

XPress database.

Work Location: Offshore

Role:

Evaluation, estimation and development of Coach for 1 business flow which is to be used as a

•

Proof of Concept (POC)

Implementing and using .NET Remoting

•

Creating DLLs and then TLBs for communication between the new DotNet application and

•

the old VB 6.0 application.

Developed C# programming for application development.

•

Involved in Unit test, Integration test, System test

•

Involved in Configuration, Debug and Deployment

•

Environment: Windows 2000 Advanced Server, VB6.0, XPress 2.3.2.0, .NET Development Studio,

C#, IBM PC clone.

Perkin Elmer, Boston, USA Aug 2004 - Nov 2004

E-Commerce Website

PerkinElmer, Inc. is a global technology leader providing scientific instruments, consumables and

services to the pharmaceutical, biomedical, environmental testing and general industrial markets.

This project involved the development of an e-commerce website which unleashes the powerful

features of the MCS and gives multi-lingual support. The four tracks of development where user

management, order management, product catalog management and CMS management.

The user management track was all about managing user profiles where as the order management

track dealt with the order placing, shipping and inventory details. The CMS management track dealt

with templates, posting, channels etc. and the product catalog track dealt with catalogs, categories and

products.

Work Location: Offshore

Role:

Requirement analysis, preparation of use case documents, preparing class diagrams and

•

sequence diagrams, detailed design of the module, coding and unit testing and preparation of

independent testing documents for the product catalog.

Notifier Service: A windows service that runs in the background whenever windows is

•

running. This service checks the database whether any mail is to be send today (compares with

System Date). If yes, it will generate the type of mail that is to be sent from the htmls provided

and then sends the mails to the recipients (customers of our client.)

Applied ADO.NET for database access

•

Created Stored Procedures, Triggers and Views in SQL Server 2000

•

Used Data Grid, Data List and Repeater controls for displaying, Editing and Updating

•

data to database

Developed M icrosoft Commerce Server 2 002 Applications for

•

C atalog Management, Payment Method and O rder Processing

Created P UP files for the d eployment of e-commerce sites in

•

different environments like integration, testing and production

Exporting b ase/ virtual catalogs so that it can be send to the

•

translators.

Importing the translated catalogs so as to create a m ulti lingual e -

•

commerce website .

Developed MCMS templates.

•

Did coding in C # for the M CMS (Microsoft Content Management

•

S erver) templates .

Created p ostings from the M CMS templates .

•

Created SDO files for importing the Templates and Channels to the integration environment

•

and then to the production environment.

Environment: Windows Server 2003, IIS, SQL Server 2000, Microsoft Commerce Server 2002,

Microsoft Content Management Server, Microsoft Solution for Internet Business, Microsoft Commerce

Server Catalog Manager, Microsoft Commerce Server Business desk,

.NET Development Studio, Microsoft Office Visio 2003, C#, IBM PC clone.

Mercy Health Plans, St. Louis, USA Mar 2004 – July 2004

Data Warehousing Project

This project involved the conversion of their existing system to a QNXT (QCSI’s healthcare

management application) compliant system with out losing their existing data. This project also involves

the development of a data warehouse so as to facilitate the generation of analytical reports. The three

main areas of development were in ETL (Extraction, Translation and Loading), Interfaces and reports.

In the ETL phase, the existing system was studied and with our in depth knowledge of the architecture

of QNXT application and its supporting data model, the required translations were developed.

Interfaces consist of basically 2 types viz. inbound and outbound. The inbound interface can read data

from a text or excel file and depending on certain conditions specified by Mercy, updates the new

database. Outbound interfaces, creates file in various formats, which may be required by Mercy’s

partners or by the Government for various purposes.

The reporting consisted of creating both analytical and transactional reports. Analytical reports are

generated from the data warehouse. Where as the transactional reports are created from the

production data.

Role:

Interfaces: created 4 interfaces and the associated documents. Interfaces consisted of both types.

Reports: Generation of 10 transaction reports.

Environment: Windows 2000, SQL Server 2000, Oracle 10g, Oracle Development Suite, C# (Console

application), IBM PC clone.

QCSI, Phoenix, AZ Oct 2003 – Feb 2004

. NET Application Development

QCSI is the leading healthcare payer solution provider, offering advanced technology and services to

automate the complex process of claims adjudication and settlement. Transforming healthcare payer

information technology since 1994. As part of the project with QCSI we were instrumental in converting

their existing 3-tier VB application to a Web enabled and future proof .NET application.

Work Location: Offshore

Role:

Requirement Analysis, Preparation of Requirement Analysis documents, detailed design of the

•

module, coding and unit testing and preparation of independent testing documents.

Created C#.Net Webservice for the different layers like Business layer, Data layer etc.

•

Designed web pages using ASP.NET

•

Developed C# programming for application development.

•

Environment: Windows 2000, IIS, .NET Development Studio, SQL Server 2000, VB Visual Studio 6.0,

C#, IBM PC clone.

Contact this candidate