Sql Server Project
Resume:
Ravi Kumar
E-mail :
********.*****@*****.***
:
********.******@*****.***
profile:
. More than 10 years of software development experience specializing in
Mobile, Web and Client/Server technologies. Prior work experience
includes Onsite Client handling Exposure and working with ISO 9001 CMM
Level 5 Companies.
. MBA (SYSTEMS) with specialization in E-Commerce from AIMA Delhi well
versed with latest technologies of IT. Also hold a one and a half-year
diploma in E- commerce from NIIT.
. Strong N-tier application development experience using VS.NET 2008, MS
Silverlite 2, C#, VB.NET, COM+, Visual Basic, ASP, PHP and SQL Server.
. Experience in using .NET technologies (C#, VB.net, ASP.net and Web
services)
. Proficient in Back-end database programming (Stored Procedures, triggers)
using SQL Server and MySQL.
. Strong in Object Oriented methodologies, Application architecture and
design. Experience in all phases of the software development project life
cycle.
. Proficient in web technologies like AJAX, XML, XSLT, HTML/DHTML,
JavaScript and VBScript.
. Proficient in creating Silverlight business apps, with .Net RIA Services
for data access.
. Possess strong communication and interpersonal skills.
work experience - 10+ years.
ORGANISATION: From TO
Mentis consulting pvt ltd mARCH 2005 tILL dATE
RSystems inc pvt Ltd August 2003 Feb 2005
(An ISO 9001 cmm level 5 company)
GE Money Jan 2003 August 2003
Microsoft India May 2001 Dec 2002
Justfares Inc pvt ltd (usa) Feb 2000 April 2001
hCL TeCHNOLOGIES PVT LTD(hONG KONG) Jan 1999 Feb 2000
Projects with Mentis Consulting Inc
1. Stonefly Shoes
Project URL: www.stoneflyshoes.co.uk,
www.stoneflyscarpe.com
CLIENT: Visuality U.K
TECHNOLOGIES: Asp.net(3.5) With C#.net,Linq, Sql server
2005,Java Script,Ajax,XML, CSS,HTML
POSITION: Developer
TEAM SIZE: 3
Description:
"Stonefly Shoes" is an e-commerce Web based Multilanguage application
which is related to selling of footwear. It consiste almost all the
functionality of ecommerce application like
SaleItem,Preorder,DelayDelivery,CrossSell, Upsell,clearence item.
This web application is contain two Window service one for Affilate
and other for Stack Update The automated stock feed window service is
used to manage and keep track of stock within the system from the info
based on remote location.For Payment two payment gateway use it Paypal
and RBS 3Dsecure and offline payment functtionality. It is managed by
"Smartcms". It is also integrated to I2I for its marketing of new
products or special offers.
My Responsibilities:
. Design Business logics of the Project using ASP. Net with C# and
for back end SQL for manipulation and storing of data.
. Worked on coding with ASP. Net using C# and manipulate the data
through SQL Server 2005 Database for showing dynamic content on
the pages with several user controls
. Configuring and maintaining website.
2. SmartCMS
Project URL: SiteUrl/cmslogin.net/index.asp
CLIENT: Visuality U.K
TECHNOLOGIES: Asp.net(3.5) With C#.net,Linq,Sql
server 2005,Java script,Talrik
Control
Ajax,XML, CSS,HTML
POSITION: Developer
TEAM SIZE: 3
Description:
SMARTCMS enables user to manage, update and maintain a website's
content or e-commerce catalogue regardless of language requirements,
administrator's physical location or the time of day. Utilizing and
implementing a SMART-content management system ( CMS ) site saves user
and their team unnecessary programming and site-alteration, while, at
the same time, giving user direct, tactical control of the site's
content and e-commerce catalogue. Content can be text, pictures and
graphics as well as navigational elements and extra sections. SmartCMS
helps user to run their marketing or e-commerce website with ease.
My Responsibilities:
. Upgradation of SmartCMS from classic asp to .net(3.5) version
and enhance the existing Functionality.
. Worked on coding with ASP. Net using C# and manipulate the data
through SQL Server 2005 Database for showing dynamic content on
the pages with several user controls
. Configuring and maintaining website.
3. I2I
Project URL: www.i2i.uk.com
CLIENT: Visuality U.K
TECHNOLOGIES: Asp.net, LINQ, C#, JavaScript,AJAX
Control Toolkit, Jmail component.
POSITION: Developer
TEAM SIZE: 2
Description:
I2I reduces the cost, time and complexity of implementing an eMail
marketing campaign. I2I is the simple, effective e-mail marketing
solution. It breaks the traditional boundaries of eMarketing - no IT
specialists required simple, template-based campaign set-ups. I2I
helps to target customers in a one-to-one environment catching
customer's data at an early stage. Deliver specific e-mail messages to
the targeted customers by developing relationships that increase
direct communication.
Disseminate information by e-mail to give more information to
customers.
My Responsibilities:
. Up gradation of I2I from classic asp to .net (3.5) version and
enhance the existing Functionality.
. Worked on coding with ASP. Net using C# and manipulate the data
through SQL Server 2005 Database for showing dynamic content on
the pages with several user controls
. Configuring and maintaining website.
4. Safetywearworld
Project URL: www.safetywearworld.co.uk
CLIENT: Visuality U.K
TECHNOLOGIES: Asp.net(3.5) With C#.net,Linq,Sql
server 2005,Java script,
Ajax,XML, CSS,HTML
POSITION: Developer
TEAM SIZE: 3
Description:
"Safety Wear World" is an e-commerce based application which is
related to selling of footwear and safety gears. This web application
is configured with automated Google feed to update products on Google
and managed by "Smartcms". Safetywearworld is also integrated to I2I
email marketing system in order to send emails to existing and new
customers for any new product release or offers.
My Responsibilities:
. Design Business logics of the Project using ASP. Net with C# and
for back end SQL for manipulation and storing of data.
. Worked on coding with ASP. Net using C# and manipulate the data
through SQL Server 2005 Database for showing dynamic content on
the pages with several user controls
. Configuring and maintaining website.
5. Lisol Voyager http://lisol.co.uk/: Currently working on Lisol Voyager
which is a Silverlite based architecture which will be deployed as an
Intranet based sub site, a desktop application and a smartphone mobile
application. Voyager will be used by transform the educational services
in the Government schools in UK. It allows storing and electronically
transfers of academic and pastoral information on all pupils and
seamless connectivity between students and teachers, using these
teachers can keep track of pupils' work and monitor progress at the
touch of a button.
6. Justfares US http://www.justfares.com/
7. Pointmarketing US http://pointmarketing.net/
8. Steria UK http://www1.steria.co.uk/
Projects Done (Reverse Chronological Order):
InstallShield AMS (Application Management System) : Installshield is a
Big Software group of US mainly involved into packaging of
applications . With the evolution of 32 bit operating systems,
application developed and packaged for earlier versions needs to be
repackaged .So there were hundreds of repackaging requests with the
companies like Installshield . Managing so many clients and so many
jobs was not an easy task. AMS provides efficient communication
between a service provider and customer companies. Installshield AMS
is a web based application that manages the application lifecycle,
incorporating standards (data) and methodologies (process)
Team Size: 25 members
Development Tools: C#, ASP.NET, VB.NET, ADO.NET, SQL 2000
Contribution: Working as a Project Lead,involved into all phases of
designing and coding of the AMS application .Supervising a team of
software Engineers.
UNMANNED TERMINAL MANAGEMENT SYSTEM for CSX World Terminals PVT LTD
(HONGKONG): CSX World terminals is a leading shipping and cargo
company in Hong Kong. They have large no of containers coming in and
out or their shipping yard. The TMS (Terminal Management System)
involves automation of the complete procedure from truck coming in the
gate till the gate out operation. The application includes interaction
with the OCR which reads the container id printed on the container
prints the work order slip and further yard processing activities
without human intervention.
Team Size: 18 members
Development Tools: C#, ASP.NET, VB.NET, ADO.NET, SQL 2000
Contribution: Working as a Team Lead, handling the team of 9 software
engineers and looking after the complete designing process and
interaction with the client and coding process of the TMS
application
Ski-West Inc .Pvt Ltd: This Project is a Properties Site for our
Client Ski-West. In this project there is a concept of hiring
properties in CANADA and USA. Companies as well as customers can book
properties online.
Team Size: 18 members
Development Tools: C#, ASP.NET, SQL Server 2000 & MS Visio.
Contribution: Re-Designed the Database Earlier there was around 90
tables and some tables with around 100 fields in some of them. I
identified the broken relationships, inconsistent tables, and ill
logical fields. Re-established the required and the most appropriate
Relationships, Stored Procedures and Triggers. Some of the tasks are -
Analysis of the specifications provided by the clients, Design and
Development, Coding using HTML pages, ASP.NET, Database management and
its connectivity, Testing - unit testing & integration testing.
Airline reservation system (Fare Finder). The project is implementing
this product as a client-server application and as a web-based
application. The Client/Server Application, Website and the tools are
developed using latest Microsoft Technologies. My responsibilities
include design and development of the system architecture, Developing
Middle Tier Objects, Tools/Modules for the applications and leading a
team of software Engineers.
Team Size: 4
Development Tools: Visual Basic 6.0 /.net, C#, ASP/ASP.NET, COM,
XML/XSLT, SQL Server 2000, HTML/JavaScript, Visual SourceSafe.
Contribution: Lead Developer - Involved in the Functional
Specifications, Architectural design
and Development. Component Application Development (COM). Designed the
database for Airline fares (netfare), Developed Stored Procedures.
Involved in developing modules/tools using Visual Basic, C#,
ASP/ASP.net, XML,XSLT. Developed .NET components using C#.
Developed Web services for retrieving fares and other details from
netfare database and CRS.
1) Online chat server: The project involved implementing the chat server
as a web based application currently being used for reservation of air
tickets by www.justfares.com .
Team Size: 4
Development Tools: C#, ASP.NET, COM, SQL Server 2000, HTML/Javascript,
DHTML.
Contribution: Lead Developer. Involved in the System Design and
Development.
Developed ASPX pages, Designed the database for storing messages,
Developed Stored Procedures, triggers etc.
2) Integrated Auditors and Certification Management System: The project
involved the computerization of the whole system of International
Certification Ltd (A New Zealand Based company which is into
certifying export companies), includes auditors and company management
system, automated report generation, automated quotation generation
etc.
Team Size: 4
Development Tools: VB.NET, SQL Server 2000, Crystal Report
Contribution: Programmer in a team of four. Analysis, Design and
Development of the application. Responsibilities included Database
Design, Query Optimization using Stored Procedures, Triggers,
Performance Tuning and Database Optimization, GUI Programming and data
Validation, Component Application Development (COM/MTS) .
3) Gmhlogistix Shipping Cost Analysis System: Gmhlogistix is a leading
cargo company. Shipping Cost Analysis system was designed to provide
the maritime personnel with a tool that would allow them to perform
cost analysis for new vessels as well as maintain records for shipping
transactions.
Team Size: 4
Development Tools: VB.NET, SQL Server 2000
Contribution: Worked as a Programmer, Design and Development of the
Application. GUI programming and Back-end Data Validation.
4) Course Registration & Student Tracking System: Developed a Course
Registration and Student tracking software for Amity Business School
(a MBA training institute). This software is designed to meet the
needs of various centers. Microsoft Sql Server and VB were used for
this project.
Development Tools: VB.NET, SQL Server 2000
Contribution: Programmer in a team of four .
5) Sales and Marketing System for Bajaj Capital Pvt. Ltd: Bajaj Capital
uses this application for performing their daily tasks. This system is
mainly a contact management system with various custom screens and
reports, which are helping their employees to perform their tasks more
effectively.
Development Tools: VB, SQL Server 2000
Contribution: Programmer in a team of four. Handled GUI programming.
6) www.Urail.com: Worked as a team leader in developing a European Rail
pass booking website www.urail.com. Through this site the customer can
purchase European railway passes online. Implemented the whole system
of shopping cart as well as the credit card transaction processing.
Team Size: 4
Development Tools: ASP, COM/COM+, SQL Server 2000, HTML/Javascript.
Contribution: Lead Developer - Involved in the Functional
Specifications, Prototyping, System Design and Development. Involved
in the Order Processing Module Developed using ASP/COM.
OTHER ACHIEVEMENTS:
1. Written books in ASP and SQL SERVER 7.0 for NICE(National Institute of
Computer Education) currently being used as part of their study
material in more then 150 branches all over India.
COMPUTER KNOWLEDGE:
o MCA FROM A.I.M.A (DELHI)
o ADVANCED DIPLOMA in computer programming Course from NIIT.
o DIPLOMA IN E-COMMERCE FROM NIIT
LANGUAGES & INTERNET TECHNOLOGIES: ASP.NET, VB.NET, VC++, VB, COM, DCOM,
ASP, XML, WML, SUN JAVA, C++, JAVASCRIPT, VBSCRIPT, HTML, DHTML
PACKAGES: DREAMWEAVER 3.0, FRONTPAGE, MSOFFICE
OPERATING SYSTEMS: DOS, UNIX, Windows 9X, Windows NT
RDBMS: MS SQL SERVER 7.0/ 2000, SYBASE, ACCESS.
COM TECHNOLOGY: ActiveX Controls, ActiveX DLL and EXE
PERSONAL DETAILS:
Date of Birth : 06th March 1976
(DELHI) (Ravi Kumar)
Contact this candidate