Project Engineer Sql Server .Net Developer Business

Summary

. About * years of experience in using .NET (3.5, 2.0, 1.1) framework,

developing Windows Forms and Web forms using C#, VB.NET and ASP.NET.

. Good Experience in Salesforce.com apex and visual force development

along with Force.com IDE and dataloader

. Good experience in Salesforce.com API calls and integration with .NET

systems

. Good Experience in working as Salesforce .com (CRM) developer and

admin functionalities

. Experience in implementing Salesforce.com SSO using delegated

authentication

. Expertise in Windows, Web and Distributed N-tier applications.

. Developed and implemented Web services, XML/XSLT and SOAP as a part of

SOA Architecture.

. Played a major role in optimizing SQL server performance in the real

time systems.

. Experience in SSIS (SQL Server Integration Service) and SSRS (SQL

Server Reporting Service).

. Well versed with scripting technologies HTML, VB Script, Java Script,

DHTML, CSS

. Experience in Designing & Development using Microsoft Technologies,

Manufacturing domain, Implementation of software solutions in n-tier

distributed environment and in N-Tier Architecture.

. Experience in System Analysis & converting the Business Requirements

into Technical Specifications.

. Good understanding of UML diagrams like Activity, Sequence, Component,

Deployment Diagrams at various SDLC.

. Experience in using ADO.NET objects such as SQL / OLEDB connection

object, Command Object, Data Adapter, Datasets, DataTable and

DataReader.

. Experience in RDBMS like SQL 2000 / 2005, DTS, SP, UDFs, Cursors,

Views, Queries and Triggers.

. Expertise in VB-6, XML, XSLT, XSD, VSS

. Good experience in Web-Development technologies like SOAP, UDDI, WSDL,

IIS 6.0/5.0/4.0 and ASP/ASP.NET/2.0/1.1.

. Good Experience in implementing on search engine like Ultraseek and

autonomy IDOL

. Good Experience in various SSO integrations for the client with

software from companies like JIVE, Sales Force

. Accomplished in development & implementation of development/support

methodologies involving best practices to support multi-vendor, multi-

client, multi-geographic location scenario within shared services

model.

. Experience in working on agile methodologies within the SDLC

EDUCATION:

. Bachelor of Technology in Computer Science Engg., National Institute

of Technology, Rourkela, India (Formerly REC Rourkela) (Top ranker in

state engineering entrance).

CERTIFICATION:

. Force.com Certified Developer (Dev 401)

. BrainBench Certification in C#

. 70-315 Developing Web Applications in .NET using C#

. Internal supply chain and high tech industry domain certifications

TECHNICAL SKILLS

Languages : C#, VB.Net, V.B 6.0, Java 2.0.

Mark Up languages : HTML, DHTML, XML, XSL, XSLT

Script Languages : ASP.Net, ASP, AJAX, JavaScript, VB Script

and JSP.

RDBS : SQL Server 2005/2000.

Design : UML with Visio, Rational Rose, Rational XDE

Development Tools : Visual Studio 2008/2005/2003, Visual Studio 6.0,

.NET Framework 1.1/2.0/3.5.

Products : Autonomy IDOL, Vignette Dialog,

Ultraseek, Salesforce.com, Active directory/ADAM

Tools : Rational Rose, Visual Source safe, MS Visio, MS

Office, Rational XDE

Developer Plus for .NET, Vignette Dialog, Enterprise

Architect (EA),

Eclipse, log4net for logging, Google analytics, Sales force

dataloader

Servers : IIS 6.0/5.1/5.0, ASP.NET Development Server.

EXPERIENCE:

Analog Devices Inc, MA

Dec 2009 -

July 2010

Partner portal setup with SSO and maintenance in Salesforce.com

Role : Senior Software Engineer

Technologies : .NET Framework 2.0, ASP.NET, C#, IIS 6.0 & 7.0, SQL Server

2005, VS 2005, Web service, VSS, Visual Studio 2008,HTML, XML, CSS, Svc

Oriented Architecture, Salesforce.com, Visual force, apex, Force.com IDE,

AD/ADAM

Description

This involved creation of new profile and roles for setting up partner

website. As part of this project the user creation was integrated with

analog.com registration website. This was achieved through salesforce.com

api calls (ASP.NET) for creating users and contacts and mapping it to the

parent account in Salesforce.com. Analog.com had its own old portal for

maintaining partner information. As part of this project all the partner

data from old system was transferred into the new system.

This project also involved creation of a single sign on webservice for

Salesforce.com which will be exposed to outside using IBM datapower setup.

The middle layer for webservice was designed to be flexible to be consumed

by other applications. The authentication and authorization mechanism was

handled through GAC dlls which used to interact with AD/ADAM for security.

Responsibilities

. Played the role of Senior Software Engineer and actively involved in

development of project and on-site team interaction.

. Created UML diagrams like class diagrams using Enterprise Architect.

. Contributed in the architecture and design of the application and

developed the UI, Web Forms, User

. Developed web services using C# to implement the business layer.

. Implemented business layer with web services using C#.

. Wrote stored procedures, Views and functions for the developed

functionalities in SQL Server 2005

. Attend daily meeting with client and discuss all changes and issues.

. Involved in Unit Testing and Load Testing.

. Contributed in designing architecture for Single sign on with

Salesforce.com

Analog Devices Inc, MA

Jan2009-

Dec 2009

Salesforce administrator and maintenance

Role : Salesforce admin and developer

Technologies : Salesforce.com, Visual force, apex, Force.com IDE,

Eclipse, Dataloader, Salesforce Integrations

Description

This role was for maintaining and supporting the salesforce

implementation at Analog Devices representing the IT systems. This involved

creation of users, profiles, workflows, formulas and many other intricacies

of salesforce implementation at Analog Devices. This also involved working

with Dataloader for mass upload of data.

Responsibilities

. Played the role of salesforce administrator.

. Managing sales force features like users, profiles, workflow rules

etc

. Handling data manipulation through dataloader

. Handling different data integration points with salesforce and making

sure there are no issues in data transfer between salesforce and other

automated systems

. Attend weekly meeting with client and discuss all changes and issues.

. This was a continuing on going activity along with other projects

around the same time.

Analog Devices Inc, MA

June 2009 - Dec 2009

Distributor Inventory Integration

Role : Senior Software Engineer

Technologies : ASP.NET 2.0, C#, ADO.NET, Web service (asmx), ASP.NET

AJAX, JavaScript, IIS, SQL Server 2005, VSS, HTML, XML, PL/SQL, SQL Server

Reports 2005, Enterprise Design, Svc Oriented Architecture.

Description

The distributor inventory integration project was developed to

facilitate the display of distributor inventory for top distributors in

analog.com website.

The project also provided data for ADI inventory to be

displayed along side the distributor inventory. Since the distributors were

from varied geographies it was decided to use a common vendor which will

interact with different distributors across the world to get the data for

us. The data was exposed by webservices which was consumed by our

application to get the feed daily. This was a major revenue impacting

project as it also gave links to the shopping cart for distributors and to

internal shopping cart application for buying.

Responsibilities

. As Senior Analyst actively involved in development of project and on-

site team interaction.

. Created UML diagrams like class diagrams using Enterprise architect.

. Developed the architecture,design the UI, Web Forms, Custom

controls using (OOps) concepts in the applications.

. Developed web services using C# to implement the business layer.

. Implemented business layer with web services using C# and ADO.NET.

. Implemented client-side validation using JavaScript.

. Developed SP, Triggers, Views and functions in SQL Server 2005 and

performance tuning for the same.

. Did Integration Testing, Performance Testing and Load Testing.

Autonomy IDOL Search engine implementation

Feb2009 - May 2009

Role : Senior .Net Developer

Technologies : ASP.Net, Web services (asmx), C# .Net, Web Forms, SQL

2005, XML, XSLT, Java Script, HTML,CSS, Autonomy IDOL product, Autonomy

IDOL services

Description

This project involved revamping enterprise search for the client. The

old search engine involved was Ultraseek. After a thorough vendor

evaluation between google and IDOL, it was decided to use Autonomy IDOL as

the platform for search engine for the enterprise. This project involved

configuring IDOL server for indexing the contents for the website along

with writing the front end code to consume the search result to be

displayed on the website.

Responsibilities

. Used UML for documentation, structure, and Design. Developed the

Technical Design Documentation using Visio Tool 2003

. Designed and developed standards for application development include

C# and ASP.NET.

. Designed and developed the web forms using ASP.NET/C#.

. Involved in implementing business layer with Web service (asmx) using

C# and ADO.NET.

. Developed the classes using C#, which incorporate three-tier

architecture and database connectivity.

. Used ADO.NET objects like Dataset, DataReader, and DataTable.

. Developed the Base class architecture for all systems in the group so

that they all share the common platform for transactions

. Involved in Impact Analysis for the existing search engine to make

sure all features are getting ported over

. Created Use Cases as part of detailed requirements gathering.

. Created HTML prototype for the User Interface and also to design

similar ASP.NET web forms.

. Did Code Review for the team as per the CMMI Level 5 & ISO Standards.

. Implemented the MVC pattern.

. Involved in System Analysis & converting the Business Requirements

into Technical Specifications.

. Involved in the development such as creating a Web Form and Web

service using ASP.Net 2.0

. Involved in Database, Table and Index design.

. Developed Stored Procedures, Functions etc... using SQL Server

. Worked extensively on IDOL product setup and configuration

.

JIVE SSO Integration Analog Devices Inc

Nov 2008 - Feb 2009

Role : Senior .Net Developer

Technologies : C# .net, SQL 2005, web services, Service oriented

architecture, REST webservices, Active Directory/ADAM integration for

security,

Description

The project included developing a custom SSO solution for deploying

JIVE forums into website. JIVE was a hosted model (SaaS) and the project

required to build a custom SSO solution that can integrate the registration

system for existing website. It involved developing a digest authentication

based web service which can be integrated with JIVE hosted pages.

Responsibilities

. Designed and developed the web forms using ASP.NET/C#.

. Involved in web designing using Dreamwaver and Flash.

. Involved in implementing business layer with web services using C# and

ADO.NET.

. Developed the classes using C#, which incorporate client - server

architecture and database connectivity.

. Used ADO.NET objects like Dataset, DataReader, and DataTable.

. Did Code Review for the team as per the CMMI Level 5 & ISO Standards.

. Involved in Database, Table and Index design

. Developed Stored Procedures, Functions etc... using SQL Server

. Performance Tuning of the SP.

. Created digest authentication based webservice

. Worked with JIVE team for integration of the webservice with their

product for signlesign on

. Creating global assembly dlls for security to interact with Active

directory and ADAM

Product Change Notification and Alerts Analog Devices Inc

Mar 2008 - Nov 2008

Role : Senior Programmer Analyst

Technologies : NET Framework 2.0, ASP.NET, C#, IIS 6.0 & 7.0, SQL

Server 2005, VS 2005, Web service, VSS,HTML, XML, CSS, Java, Vignette

Dialog, Interwoven Data Deploy

The project included developing a business process for publishing the

product change notifications to the website. As part of this project a

generic webservice was build which could publish documents to Interwoven

datastore for displaying on the website. This project also involved working

with vignette dialog to simulate a process for submitting alerts for

product changes for the customers that are registered for the same on the

website. This was a huge project for the client as it started the work in

the area from the scratch which included setting up the business flows and

designing the architecture of the system

Roles and Responsibilities:

. Played the role of Senior Programmer Analyst and actively involved in

development of project and on-site team interaction.

. Working with business to finalize the requirements and coming up with

requirements document for signoff

. Working with business in setting up the flow of the application

. Created UML diagrams like class diagrams using Enterprise Architect.

. Contributed in the architecture and design of the application and

developed the UI, Web Forms, User

. Developed web services using C# to implement the business layer.

. Implemented business layer with web services using C#.

. Wrote stored procedures, Views and functions for the developed

functionalities in SQL Server 2005

. Attend weekly meeting with client and discuss all changes and issues.

. Involved in Unit Testing and Load Testing.

. Interact with the client on a regular basis to discuss the performance

of the team, doing the knowledge sharing, areas of improvement,

training and plan for achieving the goals.

Registration and Enewsletters Integration Analog Devices Inc, MA

May 2007 -Mar 2008

Role : Senior Programmer Analyst

Technologies : NET Framework 2.0, ASP.NET, C#, SQL Server 2005, VS

2005, Web service, VSS,HTML, XML, CSS, Java, AD/ADAM, Cheetahmail APIs,

Maestro

Description

The project included developing a site wide integration for authentication

in the analog website. The application was developed in ASP.NET 2.0 having

C# as the coding language. The project involved highly complex architecture

involving interaction with Active directory for security and providing a

web service to be used by other applications for providing site wide

integration. This project also had an integration for all the newsletters

which was previously managed by other vendors and was built in house as

part of this project. This project also involved the enewsletters data

sending to an outside vendor which manages the enewsletters for the client.

Responsibility

. Played the role of Senior Programmer Analyst and actively involved in

development of project and on-site team interaction.

. Working with business to finalize the requirements and coming up with

requirements document for signoff

. Working with business in setting up the flow of the application

. Created UML diagrams like class diagrams using Enterprise Architect.

. Contributed in the architecture and design of the application and

developed the UI, Web Forms, User

. Wrote stored procedures, Views and functions for the developed

functionalities in SQL Server 2005

. Attend weekly meeting with client and discuss all changes and issues.

. Involved in Unit Testing and Load Testing.

. Interact with the client on a regular basis to discuss the performance

of the team, doing the knowledge sharing, areas of improvement,

training and plan for achieving the goals.

. Led an offshore team for a few modules integration with the project

. Constantly working with Cheetah mail vendor for integration

Customer Based Forecasting System, Analog Devices Inc, MA

July 2006 -Apr 2007

Role : Senior Programmer Analyst

Technologies : NET Framework 2.0, ASP.NET, C#, SQL Server 2005, VS

2005, Web service, VSS,HTML, XML, CSS, VB Script, DTS, Maestro, BCP

Description

This project was started as the need for the customer to forecast the

production for the subsequent quarters. This was an important aspect for

the client as it was not there earlier for forecasting based on their

customers. This provided an interface where in the product line

coordinators and sales persons can log in and provide a forecast which will

be fed on to the system for deciding the amount to be produced. This was a

major project for the client as it was interfacing with main system for

forecast being used in Analog devices.

Responsibility

. Played the role of Senior Programmer Analyst and actively involved in

development of project and on-site team interaction.

. Working with business to finalize the requirements and coming up with

requirements document for signoff

. Working with business in setting up the flow of the application

. Created UML diagrams like class diagrams using Enterprise Architect.

. Went through supply chain and manufacturing domain certifications for

this project

. Contributed in the architecture and design of the application and

developed the UI, Web Forms, User

. Wrote stored procedures, Views and functions for the developed

functionalities in SQL Server 2005

. Attend weekly meeting with client and discuss all changes and issues.

. Involved in Unit Testing and Load Testing.

. Interact with the client on a regular basis to discuss the performance

of the team, doing the knowledge sharing, areas of improvement,

training and plan for achieving the goals.

. Led an offshore team for a few modules integration with the project

DSP Knowledge Base, Analog Devices Inc, MA

Dec 2005 -June 2006

Role : Senior Software Engineer

Technologies : NET Framework 1.1, ASP.NET, VB, SQL Server 2000,

VSS,HTML, XML, CSS, VB Script, DTS, Maestro, BCP, Ultraseek Search Engine

Description

This project added a module to the website named Embedded Processing and

DSP. We were given the task to build the system which will perform the task

of uploading the documents to be shown in the website, then performing the

document life cycle i.e. uploading, reviewing and publishing live. After

that document is indexed by the ultraseek search engine which is

implemented in the module and the document is displayed when searched in

interface provided depending on the access level of

the document. We designed the system to implement the content upload life

cycle and implemented the search engine to index and retrieve documents

based on search words. The main challenge for the project was learning the

implementation of the search engine in .NET and the various settings for

the ultraseek search engine to index all the documents available and

providing the customer language specific pages (localization) for the

worldwide implementation in different languages.

Responsibility

. Played the role of Senior Software Engineer at offshore and actively

involved in development of project

. Created UML diagrams like class diagrams using Rational Rose.

. Contributed in the architecture and design of the application and

developed the UI, Web Forms, User

. Wrote stored procedures, Views and functions for the developed

functionalities in SQL Server 2000

. Involved in Unit Testing and Load Testing.

. Created high level and detailed design documents for client sign off

. Having regular calls with onshore tech lead for closing the gap for

requirements

. Learning Ultraseek search engine in quite a short span of time for

development for the project

Job Tracking System, Pitney bowes Jan 2005

-Dec 2005

Role : Senior Software Engineer

Technologies : NET Framework 1.1, ASP.NET, C#, SQL Server 2000,

VSS,HTML, XML, CSS, VB Script, DTS, Maestro, BCP

Description

This project was for developing a Job tracking system for the client. It

involved creation of role based job tracking system for client. It also had

reports which were written in crystal reports along with .NET. The

application had several featuers and pages based on the role of the

employees. They can start their job tracking in the system and thus can

mark their hours very efficiently. Several reports were developed which

managers can keep track of the hours of their subbordintates.

Responsibility

. Played the role of Senior Software Engineer at offshore and actively

involved in development of project

. Created UML diagrams like class diagrams using Rational Rose.

. Contributed in the architecture and design of the application and

developed the UI, Web Forms, User

. Wrote stored procedures, Views and functions for the developed

functionalities in SQL Server 2000

. Involved in Unit Testing and Load Testing.

. Created high level and detailed design documents for client sign off

. Having regular calls with onshore tech lead for closing the gap for

requirements

Contact this candidate