Sql Server Manager .Net Developer Project Sales
Resume:
SUMMARY:
. Over * years of IT experience with a focus on web applications and
client-server applications.
. Extensive experience in requirement analysis, design, data modeling,
preparing functional and technical specifications
. Skilled in developing distributed applications using .NET
architecture, XML Web Services, XML, SOAP
. Vast experience in GUI Development using VB.Net, ASP.Net, C#, VB,
XML,XSL, XSLT, WCF, WPF, jQuery, CSS, HTML, XHTML, DHTML,
JavaScript.
. Extensive experience in writing Functions/Stored Procedures using T-
SQL/PL-SQL and writing packages in PL-SQL
. Experience in using SQL DTS services to export & Import data in MS
SQL Server.
. Good experience in implementing authentication using LDAP
. Experience in Code Reviews, preparing use cases, applying QA
methodologies.
. Possesses good communication, presentation, time management, and
logical and analytical skills.
TECHNICAL SKILLS:
Programming Languages: C#, C, VB, VB.NET, COBOL, Core JAVA
Web Development Technologies: ASP.NET 3.5 and 2.0, ASP.NET MVC,
ADO.NET, Entity Framework, LINQ to SQL, AJAX,
JavaScript, jQuery, HTML, XHTML, CSS, WCF,
VBScript, Telerik RadControls
Development Tools: Visual Studio.NET 2008/05/03,
Dreamweaver MX, Photoshop.
RDBMS: MS-SQL Server 2000, 2005, Oracle 8i
XML Related Technologies: XML, XSL, XSLT, SOAP, WSDL
Design Tools: UML, MS Visio
Reporting Tools: SQL Server 2005 Reporting Service, Crystal Reports 8.0
Application Servers: Win 2003, IIS 6.
Version Control: Visual Source Safe, Subversion
PROJECTS SUMMARY:
Medicis Pharmaceutical Corporation, Budd Lake, NJ
Jan 2010 - Till date
Software Consultant
Project title: Path Finder
An Internet based web application which is mainly aimed for account
managers and sales persons of Pharmaceutical Companies which allow its
users to get contact information of key decision makers, covered lives,
drug position and market share data of insurance companies
. Web Form design and coding using Master Pages, Server controls, User
controls, RadGrids, Dundas Charts, CSS, JavaScript, html.
. Thoroughly utilized different Dundas features like plotting areas,
series, 2D/3D, legends, titles, smart labels, toolbar, zoom and scroll
. Added interactive features in Charts like animation, print, drilldown,
data export to excel.
. Used RadGrids to display drilldown data in a well defined manner with
sorting, paging, Export to Excel features.
. Wrote T-SQL queries in creating views and stored procedures in SQL
Server. Used joins, unions to get data from different tables and
databases.
. Developed page and group level security for each page in the
application
. Wrote JavaScript for progressive UI enhancements using jQuery library
. Used EntityFramework with WCF Services to create a customized
conceptual model for data and mapped it to requirements
. Used LINQ to write queries and have the query work in a database vendor
agnostic manner
. Involved in Setting up Development/Test/Production environment
. Identifying issues/bugs reported by the customers
Environment: C#, ASP.Net, VS2008, SQL Server 2005, JavaScript, jQuery,
HTML, WCF, ADO.NET Entity Framework, LINQ, Telerik RadControls, Dundas
Charts,CSS
Ampac Insurance Co, Woodbridge, IL
Jan 08 - Oct 09
Software Consultant
Project title: Life Insurance
An Internet based web application which provides term Life Insurance quotes
to its agents and to online users by working with sponsoring Financial
Institutions in the direct marketing, sales and service of individual life
insurance products to help protect their customers. Converts the entire
application into a PDF document with e-sign
. Managed, developed, implemented and maintained web application
. Developed class diagrams, flow diagrams and flow charts using UML
. Developed page and group level security for each page in the
application with ASP.NET with C#, XML, JavaScript. SQL Server 2000 used
for database, IIS used as web server.
. Interaction with clients for requirement gathering, prototype
demonstrations, etc
. Maintained Content Management System (CMS) for uploading latest rates
and products
. Develop a web-based Customer Relationship Management System (CRM) that
holds customer records and is use to record CRM sheet with details
listed on every CRM number created.
. Hosted websites on Microsoft SharePoint which access many workspaces
and documents
. Developed the User controls for the displaying the questionnaire forms
. Developed complex stored procedures and business logic with T-SQL
. Developed the web services to convert each user application into a pre-
filled PDF form.
. Developed and implemented policies and procedures for an organization's
intranet applications unit. Involved in Setting up
Development/Test/Production environment.
. Identifying issues/bugs reported by the customers.
. Implemented reports for check printing, statistical analysis and
balances using Crystal Reports
Environment: C#, ASP.Net, VS2005, SQL Server 2000, Microsoft SharePoint,
JavaScript, HTML, WCF, SOA, XML, XSL, CSS, Photoshop, Crystal Reports
American Enterprise, Woodbridge, IL
Software Consultant
Project Title: Underwriter Desktop
An Internet based web application intended to provide online services to
its Insurance Underwriters to analyze information that is available in
insurance applications.
. Responsible for implement business logic and developing WCF Service
Libraries that exchange data between Desktop and Central Application
. Involved in total Conceptualization of the web application and database
developments
. Responsible for creating Data Access Layer Classes using ADO.Net
. Developed the web forms using HTML server controls, Web controls, and
validation controls using ASP.Net
. Design & developed web forms that uses AJAX calls.
. Involved in Setting up Development/Test/Production environment
. Generalized stored procedures and triggers for multiple table data
handling in SQL Server 2005
. Used source control Subversion for effective source control of the
entire project
. Performed the unit testing of the various modules.
. Identifying issues/bugs reported by the customers.
Environment: C#, ASP.Net 3.5, SQL Server 2005, VS2008, Photoshop, Flash,
Microsoft SharePoint, JQuery, JavaScript, HTML, WCF, CSS, WPF, XML, XSL,
XSLT, JQuery
Software Developer
Parker Porter Instruments, Hatfield, PA
Sep 07 - Dec07
Project Title: User Authentication
An Intranet based web application intended to provide online services for
their wide employees on Accounting, Sales, Purchase, Shipping and customer
services. Each employee is given restricted access to the website depending
upon their usage of the services
. Responsible for developing the web forms, using HTML server controls,
Web controls, and validation controls using ASP.Net
. Involved in analysis, design and development of 3-tier web application
with ASP.Net handling user services and business services and Oracle 8i
database as data repository
. Order and invoice management, CRM functionality, Warehouse tickets and
shipping features, Catalog management, and a highly complex pricing
model.
. Developed business logic classes using object oriented technologies and
C#. NET
. Authentication of Staff using LDAP via Novell Id and password and Role
based authorization
. Involved in defining the configuration settings using XML in Web.Config
file.
. Coded request - response event handlers in Global.asax file that react
to global application event
. Involved in coding data services and xml processing classes using
C#.NET, VB.Net and ADO.NET.
. Created Stored Procedure, Triggers and PL-SQL for database access.
. Analyzed tables and stored procedures; created indexes on tables for
performance tuning
Environment: C#, ASP.Net, Oracle 8i, VBscript, VB.Net, SQL+, ASP, HTML,
Dreamweaver
Illinois Environmental Protection Agency, Springfield, IL
Jan 06 - Aug 07
Web Developer
Project Title: Loan Application (Financial Assistance System)
Loan Application is a module of Illinois Financial Assistance System. This
Loan Application system is designed to keep track of the information
regarding the loan applications received by IEPA. This system allows IEPA
to better monitor the loan applications, which are being processed for
approval, and also keeps track of application status while in approval
process.
. Responsible to design and develop web application having 5-layers of
(Presentation/UI/Business Logic/Data Access and Data Storage) logical
model in it, using asp.net 2.0
. Developed a Class Library (generated a dll file) that makes the code to
be reused in different applications like windows, web and web services
. Authentication is implemented through Light Weight Directory Access
Protocol (LDAP)
. Implemented role based security
. Developed master pages in order to maintain consistent look through out
the system
. Database design, analysis and development in SQL Server 2005
. Designed, Created and maintained tables, views
. Wrote stored procedures and SQL Queries
. Used "SQL Server Import and Export Wizard" to import data from SQL
Server 2000 to SQL Server 2005 which use Data Transformation Services
(DTS)
. Used Visual Source Safe 6.0 for effective source control of the entire
project
. Involved in integration and testing of all modules
Environment: C#, .Net 2.0, ASP.Net 2.0, SQL Server 2005, VSS 6.0.
Photoshop, Flash
Project Title: Data Logger
This application is designed mainly to facilitate IEPA Staff working at
field to enter data into a Windows CE Device.
. Developed a smart device application which deploys on a Windows CE
(PDA) device.
. Created PDA applications using the ASP.Net Mobile Internet Toolkit.
. Created Web services to extract data from database and read/write it to
an XML file.
. Implemented the application in C at host, C# at PDA
. Involved in defining the configuration settings using XML.
. XML was used to insert and retrieve the data from MS Access database.
. Developed Test cases for the components coded.
Environment: C, C#. Net, Web Services, Windows CE Device and MS Access
Zarca Interactive Inc.,Mumbai, India
Jan 04-Dec 04
Developer (.NET and ASP)
Project Title: Survey Solutions
The solutions include five products: Survey Manager, Distribution Manager,
Report Manager, Export Manager and User Manager. Here users can create the
surveys in almost 15 languages of their choice. Currently the report module
is handling approx. 5 million responses fetched from huge response tables
containing more than 50 millions of data rows. The report module is tuned
in such a manner that it takes less than 30 seconds to fetch and display
data after lengthy and complex logical calculations.
. Migrating the site from ASP to ASP.NET 1.1.
. Unit testing using custom test scripts.
. Effective database normalization done.
. Usage of T-SQL transaction.
. Creating User Defined Functions for common database logic.
. Used VSS for source control.
Environment: ASP.NET 1.1, VB.NET, ASP, SQL SERVER, Visual Source Safe
EDUCATION:
MS in Computer science (Northern Illinois University)
Bachelor of Technology, Computer Science (B.Tech)
******.*@*****.***
Contact this candidate