.Net Sql Server Management Experience Analyst

Summary:

> More than * years of experience as a Software Developer and Business

Analyst

> Development experience using .Net Framework 3.5/3.0/2.0 and Visual Basic

6.0/5.0

> Analyzed, Developed, Configured, Tested and Deployed a variety of

Applications.

> Hands-on experiences in UML design and analysis and experience on using

tools like Enterprise Architect, MS Visio and MS Office suite.

> Experience in all phases of software development lifecycle (SDLC)

management and implementation.

> Have extensively applied Object Oriented Analysis and Design and Object

Oriented Programming (OOP) Concepts, in Software Application Design and

Development. Expertise in designing & writing stable, robust Web

Applications.

> Experience in working with legacy systems in Classic ASP, VB 6.0,

migrating them to .Net framework and new module integration.

> Prior experience communicating with clients and end users with strong

business skills. Good team player with excellent communication skills.

Educational Qualification:

> Master of Computer Application from Bharathiar University, 2003

> Bachelor of Science (Computer Science) from Kerala University, 2000

Technical Skills:

Languages: VB.Net, VB6.0, C#, JavaScript, VBScript, PL/SQL, T-SQL

(DDL,DML), HTML/DHTML, XML, jQuery, UML, C,C++, Java

Technologies: ASP.NET(3.5/3.0/2.0/1.1), Web2.0, ADO.Net, AJAX,

WebServices, SOAP,SOA, .Net Remoting, ActiveX,

MTS/COM+

Databases: SQL Server 2005/2000, Oracle 10g

GUI Tools: Infragistics NetAdvantage 2008/2006/2005, Telerik

RAD Toolkit

Development Tools: Visual Studio 2008/2005, MS Visio, Enterprise

Architect, MS Dynamics, SQL Server Management Studio,

Visual Studio 6.0, Toad VI, NHibernate,

Reporting Tools: Crystal Reports XI/2008/10.0, MS Reporting Services

Other Utils: Visual Source Safe, Jhoomla CMS, Team Foundation Server,

Subversion, MS Build, NUnit 2.2/2.0, MS SandCastle,

MS Office

Professional Experience:

Karmaloop Inc., Boston

Mar 2009 - Jan 2010

Role: Programmer Analyst

. As a Business Analyst cum Programmer I was involved in the

requirements gathering phase, planning of the migration process,

analyzing user needs, initial and technical scoping, database design

and code architecture.

. Created use cases, user guides, programmer documentation, application

administration, and process flow diagrams.

. Performed reverse engineering on an existing Accounting system

integrated with MS Dynamics, performed code reviews, code commenting

and generated all relevant functional and non-technical documents.

. Developed UML design documents including Class and Sequence diagrams.

. Developed T-SQL stored procedures in SQL Server 2005 to develop and/or

enhance solutions to extend and enhance Great Plains Accounting and

CRM module.

. Involved in the migration of a legacy web apps in Classic ASP to .Net

framework.

. Proposed, designed and build a secured system for Customer

Verification Process.

. Participated in code reviews and process mapping for documenting the

functional logic.

. Communicated with the internal and external users to gather core

requirements for designing a stable system.

. Interfaced with the third party vendors for negotiating the deal, as

well as, with the CSD team for requirement gathering till product

launch.

. Used Visual Source Safe for version control and code management.

Environment: VB.Net, ASP.Net, ASP, Ms Visio, EA, Visual Studio 2008, .NET

Framework 3.5, MS Dynamics(Great Plains), VBScript, VSS, ADO.Net, SQL

Server 2005

Outsource Partner's International, New York

Jan 2006 - Feb 2009

Role: Programmer Analyst

. Worked in internal in-house and external client applications.

Developed web and windows applications for clients like Cargill Inc,

MN and Deutsche Bank, CT.

. Analyzed user needs and user requirements, identified risks (risk

management) and process changes (change management); Use cases and

functional design. Performed Code Reviews and Bug reporting and

resolving.

. Applications were developed in an Agile environment using SCRUM.

Initiated the daily SCRUM meeting and monthly Sprint review meetings

with the client.

. Created UML based documents for various applications including Use

Case, Activity, Sequence and Class diagrams.

. Generated Reports for Trading Analyst using MS Excel and Adobe Acrobat

(PDF).

. Prepared product compliance documents. Prepared Q/A test compliance

plans. Created use cases, user guides, programmer documentation,

application administration, and process flow diagrams.

. Developed and monitored job schedulers in Oracle 10g for sending

periodic Email alert to the Trading Desk at Cargill Inc.

. Successfully developed secure and stable web and desktop applications

using C# and VB.Net (.Net framework 3.5/3.0/2.0).

. Created and modified SQL Server Stored Procedures for data centric

modules establishing connection with Great Plains.

Environment: Enterprise Architect 5.0, MS Visio, VB.Net, VB6.0, C#,Visual

Studio 2005, .NET Framework 3.5/3.0/2.0, Crystal Reports, MS

Dynamics(Great Plains, CRM), VBScript, VSS, ADO.Net, Oracle 10g, SQL

Server 2005

Indian Institute of Technology for Management, India

Feb 2003 - Dec 2005

Role: Programmer-Trainee

. Worked on-site for requirement gathering phase and final

implementation and training phase.

. Wrote T-SQL queries and developed stored procedures to access and

manipulate the data in SQL Server database.

. Involved in database design by creating the tables, constraints and

rules for storing and accessing the data.

. Wrote XSLT transformations using XSL, XSD and XPath to create and

transform data in XML files.

. Build reusable class libraries in VB.Net and common user controls to

be utilized as plug-in to various applications.

. Worked on migration of a legacy application in Visual Basic 6.0 to the

.Net Framework using VB.Net classes and migrated the database from MS

Access to SQL Server 2005 database.

. Responsible for design and development of Utilization Matrix utility

to monitor the usage of the software's within the organization.

. Deployment of the system and publishing of the site to the production

servers.

Environment: VB.Net, ASP.Net, Visual Studio 2003, .NET Framework 1.1, VB

6.0/5.0, CSS, JavaScript, HTML, SQL Server 2000

Contact this candidate