.Net Sql Server Developer Application C# Management
Resume:
Darshak Sheth
Email ID-: ************@*****.***
Cell No-: 201-***-****
Summary:
. Over 6 years of extensive experience in Web Development, Application
Development using C++, C# .NET, VB .NET, ASP. NET, ADO. NET, XML, Web
Services and Visual Studio .NET 2003 and 2005/2008/2010, Crystal
Reports XI, Crystal Reports XI R2.
. More than 5 years of experience in developing solutions with Microsoft
.NET (MS Framework 1.1 and 2.0) using Visual Studio .NET 2003 &
2005/2008/2010, ASP .NET, C# .NET, and VB.NET with SQL Server 2000,
SQL Server 2005 and Access as the databases. 1 year of experience in
developing large-scale, performance critical client/server
applications using Microsoft Technologies like VB, MTS and Crystal
Reports 8.5/9.
. Experienced in Silverlight, Expression Blend and Spring.NET
. Strong knowledge in the areas of HTML/DHTML/XML/XSD/DOM/XSLT/XPath
authoring/designing, Schema generation.
. Experienced in using tools like Data Transformation Services (DTS) and
SSIS with MS SQL Server 2000/2005.
. Experienced in database connectivity programming using ADO.NET, ODBC,
and OLE DB.
. Experienced with Microsoft Application Building blocks for Dot Net
projects (Data Access, Exception Handling). Knowledge in User
Interface Process, Caching and Security Application Blocks,
Globalization, Threading.
. Extensively used DHTML, AJAX Library, RAD Controls for better UI
experience and responsiveness.
. Expert in database design and database programming using SQL Server
2000/2005 and Oracle 10g (Stored Procedures, Cursors, Triggers).
. Strong in Object Oriented Programming, principals and Design patterns
(Adapter, Singleton and Factory).
. Knowledgeable in all phases of Software Development Life Cycle -
Designing, Developing, Coding, Debugging, Testing, Implementation and
Maintenance.
. Specialized in the design, development and testing of component-based
and distributed systems in a Windows environment, including .NET Web
Services, Remoting.
1. Experience in defining queries, generating drill-down report in
Crystal Reports.
. Knowledge in new features of .NET 3.5/4.0, WCF, Enterprise Library,
NHibernate.
. Skills to select lead and integrate working teams to develop system,
having the "hands on" characteristic to ensure the quality of the
final product.
Education:
BS in Information Technology
Certification:
MCTS (70-536): .NET Framework 2.0 - Web Applications
(MCP ID: 6136495)
Technical Skills:
Visual Studio 2010/2008/2005, Visual Studio .NET 2003, .NET Framework
1.1/2.0/3.0/3.5/4.0, C# .NET, VB .NET, ASP .NET, ADO .NET, MS SQL Server
2000/2005/2008, SSRS 2005, SQL, T-SQL, Profiler, SQL Agent, Oracle 9i/10g,
PL/SQL, SQL Developer, Silverlight 3/4, Documentum 5.3/6.5/6.6, Enterprise
Library 3.1/4.0/4.1, Spring.NET 1.3.0, Service Oriented Architecture (SOA),
Web Services, WCF, WPF, LINQ, ClickOnce, Java Script, VB Script, JSON, XML,
XSL/XSLT, XSD, DOM, UML, HTML, DHTML, CSS, DOS, LINUX, Windows NT/
98/ME/XP/2000/2003/2008, IIS 6.0/7.0, Visual Basic 6.0, Java, ASP,
NHibernate 1.0/2.0, TCP/IP Protocol, Socket Programming, Win Forms, Web
Forms, Visual Source Safe, Subversion, Microsoft Project, Microsoft Visio,
AJAX Library, AJAX Toolkit, ActionScript 3.0, Microsoft FrontPage
2000/XP/2003, MS Excel, MS Word, MS Access, Expression Blend 3/4,
Dreamweaver, Photoshop, Crystal Reports 8.5/9/11/11.5, log4net, Telerik
RadControls, Dundas Charts.
Experience:
Sanofi-Aventis, Bridgewater, NJ / Aequor Technologies
Jan 2010 - Current
Programmer Analyst
Application involves Content Authoring, Packaging and Distributing.
Content can be created with Online and Offline capability. Application has
extensive search functionality to find contents.
Responsibilities:
. Developed and implemented Web application using Silverlight, C# .NET
with Documentum as a backend repository to allow access to the
application over an intranet for authenticated users.
. Involved in writing and reviewing Functional Specification and
finalizing it.
. Developed Database Model Diagram using MS Visio 2003.
. Involved in n-tier architecture design and implementation.
. Extensively Used DQL to fetch and handle user data.
. Based on a modular design where users, granted specific access to
them, can only access certain areas based on their role.
. Extensively used Silverlight Library, Silverlight Toolkit and
Silverlight RadControls for better UI design and responsiveness.
. Involved in Data Migration from Old Repository to New Repository.
. Created User Controls and Input Validations using MVVM pattern.
. Developed WCF Services using .NET Technology and utilized WSDL, SOAP
for transferring data in XML format.
. Responsible for maintaining CSS, Themes and Resources.
. Implemented Export utility and Reports in Excel using SyncFusion.
. Generated e-mails from templates using XML and XSLT/XPath.
. Involved in fixing bugs by debugging the application. Participated in
solving technical issues in the project.
. Involved in Functionality testing, Unit Testing, Integration Testing
and System Testing of the Application.
. Involved in Application packaging and uploading on Development server
and Testing Server.
. Used Subversion, AnkhSVN and TortoiseSVN for version control and as
code repository.
Environment:
C# .NET, ASP .NET, .NET Framework 3.5/4.0, Silverlight 3/4, Expression
Blend 3/4, Sharepoint Server 2007, Documentum 6.5/6.6 (DFC/DFS), Samson,
Repoint, Telerik RadControls for Silverlight, Spring.NET 1.3.0, Enterprise
Library 4.0/4.1, Web Services, SOAP, WSDL, WCF, LINQ, Oracle 10g, SQL
Developer, XML, XSL/XSLT/XPath, Windows Server 2008, Visual Studio 2010, MS
Office 2003, MS Visio 2003, MS Project 2003, IIS 7.0, Subversion, DHTML,
Java Script, DOM, JSON, Photoshop, AJAX Library, AJAX Toolkit, log4net
Sanofi-Aventis, Bridgewater, NJ / Aequor Technologies
Jul 2008 - Dec 2009
Programmer Analyst
Application is related to Clinical Trial Management. It is integration of
ASP .NET and Classic ASP Pages. Modules are related to Study, Country,
Site, Patient, Flow Chart, Investigator, Location, etc. Group Rights and
User rights for each page. There are administrative functions at different
levels of hierarchy & various reports catering to each level. Uploaded
application on development server and testing server.
Responsibilities:
. Developed and implemented Web application using ASP .NET, C# .NET with
Oracle 10g as a backend to allow access to the application over an
intranet for verified users.
. Involved in writing and reviewing Functional Specification and
finalizing it.
. Developed Database Model Diagram using MS Visio 2003.
. Designed the workflow process using UML.
. Involved in n-tier architecture design and implementation.
. Extensively Used Data Access Application Block and ADO .NET objects
such as DataReader, DataAdapter and DataSet to fetch and handle user
data.
. Based on a modular design where users, granted specific access to
them, can only access certain areas based on their role.
. Implemented Session Wrapper for Both ASP and ASP .NET.
. Extensively used AJAX Library and AJAX Toolkit for better UI design
and responsiveness.
. Implemented stored procedures and triggers for Audit Trails.
. Involved in Data Migration from Old Database (SQL Server 2005) to New
Database (Oracle 10g).
. Developed general developer utility Exes in VB .NET using WinForms and
Multithreading.
. Created User Controls with Events and Delegates.
. Developed WCF Services using .NET Technology and utilized WSDL, SOAP
for transferring data in XML format.
. Used Features of .Net Framework 3.5 (Collection Initializes, Partial
Methods and Generics).
. Validated User Input using ASP .NET Validation Controls, AJAX Extender
Controls and JavaScript.
. Responsible for maintaining Master Page, CSS and Themes.
. Implemented Reports in Excel using SyncFusion and Primary Interop
Assemblies in .NET.
. Created Crystal Reports using Crystal .NET from initial stage.
. Generated e-mails from templates using XML and XSLT/XPath.
. Involved in fixing bugs by debugging the application. Found solution
for many technical issues in the project.
. Involved in Functionality testing, Unit Testing, Integration Testing
and System Testing of the Application.
. Used ClickOnce for Deployment of Windows Application.
. Involved in Application packaging and uploaded application on
Development server and Testing Server.
. Documented and Created the Help system.
. Used Visual Source Safe for version control and as code repository.
Environment:
C# .NET, VB .NET, ASP .NET, .NET Framework 3.5, ASP, Enterprise Library
4.0/4.1, Web Services, SOAP, WSDL, WCF, LINQ, Oracle 10g, SQL Server 2005,
SQL Developer, XML, XSL/XSLT/XPath, Windows Server 2003, Visual Studio
2008, MS Office 2003, MS Visio 2003, IIS 6, Visual Source Safe, DHTML, Java
Script, DOM, JSON, Photoshop, Crystal Viewer, AJAX Library, AJAX Toolkit,
log4net, Documentum 5.3 SP6, Samson
Seven Dials Media Inc, Chicago, IL / Softweb Solutions
Apr 2008 - Jun 2008
Sr. .Net Developer
Product is related to Digital Asset Management, Media Asset Management,
Advertising.
Modules related to Lead, Bid, Job, Work Orders, Purchase Orders, Invoices,
Shipping Information, Company, People. There are Group Rights and User
rights Module. Developed menu based on Logged in User's Rights. There are
administrative functions at different levels of hierarchy & various reports
catering to each level. Daily uploaded application and database scripts on
hosting server.
Responsibilities:
. Developed and implemented Web application using ASP .NET, C# with SQL
Server 2005 DB backend, Java Script, to allow access for verified
users to applications over an intranet using Terminal Services.
. Implemented automated list generation and emailing to specified mail
recipient(s), using C# .NET and SQL Server 2005.
. Successfully implemented Agile Software Development Method (Scrum) in
Company.
. Designed the workflow process using UML.
. Done resource allocation using MS Project and involved in Project
Management.
. Involved in a 3-tier architecture design.
. Used ADO .NET objects such as DataReader, DataAdapter and DataSet to
fetch and handle user data.
. Based on a modular design where users granted specific access to them,
can only access each module based on their role.
. Extensively used AJAX Library and RAD Controls (Telerik) for better UI
design.
. Implemented menus for Users based on user-role assigned by an
administrator.
. Configured report server in development and production stage.
. Created SQL server Reports using SSRS 2005 from initial stage.
. Implemented T-SQL stored procedures and triggers.
. Implemented form authentication and validation for users of the system
using Stored Procedures and SQL Server encryption methods.
. Developed general utility Exes in VB .NET using WinForms and
Multithreading.
. Responsible for transferring Excel data in SQL server 2005 using SSIS.
. Developed XML Web Services using .NET Technology and utilized WSDL,
SOAP for transferring data in XML format.
. Used WCF (.Net Framework 3.0) to fetch data from Oracle 9i using
PL/SQL.
. Used Features of .Net Framework 3.0 (Collection Initializes, Partial
Methods, and Generics).
. Implemented company notice board using IIS 6, ASP .NET Forms
Authentication and SQL Server 2005 DB backend.
. Used XSLT Transformation to show Invoices and work orders.
. Involved in Functionality testing of the system.
. Involved in application packaging and uploaded application on hosting
server.
. Used Visual Source Safe for version control and as code repository.
Environment:
C# .NET, VB .NET, ASP .NET, .NET Framework 2.0, .NET Framework 3.0, Web
Services, SOAP, WSDL, WCF, SQL Server 2005, Oracle 9i, SSRS 2005, XML,
XSLT, Windows Server 2003, Visual Studio 2005, MS Office 2003, IIS 6, VSS,
Java Script, Photoshop, AJAX Library, RAD Controls
Speedway Distributors, Belleville, KS / Softweb Solutions Dec
2007 - Mar 2008
Sr. .Net Developer
Client sells their products online through website. Users can see various
products like apparels, caps, key chains, license plate, frames, bags,
pens, create their own View Cart and purchase online. Application contains
admin portal. Admin can manage whole site. Admin can enter other system
users to maintain items. System users can enter new main category, sub
category and items as well as size and price for each item. System users
also can enter new warehouses with their minimum order limit. Minimum order
can be on unit/product, product//warehouse, amount/warehouse, and
unit/warehouse.
Responsibilities:
. Gathered requirements from Clients and documented.
. Attended business meeting and gathered the new business requirements.
. Involved in proper documentation and presentation of technical details
and the jobs planned/performed.
. Responsible for the Database design, for Client Server, intranet and
Internet applications using ASP .NET, C# .NET, Java script & HTML.
. Designed & implemented the Views, stored procedures and triggers.
. Developed Data Access module, Business logic Module and User Interface
in C# .NET.
. Used XML Web Services to transfer data in XML Format and to store
information
. Involved in coding of admin modules to meet the generated functional
requirements using WinForms and Multithreading in VB .NET.
. Generated Shopping Cart using HTML, XML and XSLT at server side.
. Extensively used XSLT Transformation in .NET
. Created Summary Reports and List Reports using Sub-Reports and
Standard Reports in Crystal Reports XI.
2. Used different types of scope for variables, like Shared, Global, and
Local etc, in creating formula.
. Used Crystal Query for ad hoc Reports and Users design Custom Queries.
. Accessed the Database using ADO .NET and SQL Server Database.
. Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.
. Monitored Performance during Beta - Testing phase of the application.
. Used Query Analyzer to optimize SQL Queries.
Environment:
ASP .NET, C# .NET, VB .NET, ADO .NET, .NET Framework 2.0, Visual Studio
2005, MS SQL Server 2005, Crystal Reports XI, Web Services, SOAP, HTML,
XML, XSLT, JavaScript
Fujifilm Graphics System, Chicago, IL / Softweb Solutions
Oct 2007 - Nov 2007
.NET Developer
Fuji film is processing their printed documents and inserting those
parameters in Database. Based on those parameters they want various reports
to measure the quality of printing materials and Printers. There are
various reports like Branch Summary Report, Device Report, Device
Variability Report, Color Detail Report, Patch Report, and Productivity
Report. Charts were developed using Dundas Charts and shown in ABCpdf.
Responsibilities:
. Designed the workflow process using UML.
. Designed and developed the Intranet application in C# .NET 2.0 using
Web Forms.
. Developed business and databases components using C# .NET 2.0.
. Designed Front-end screens and reports in ASP .NET.
. Created Code modules in C#. NET.
. Developed Charts using Dundas.
. Partly involved in designing the architecture for the present system.
. Employed forms authentication techniques to check the authenticity of
users.
. Designed and Developed data access using ADO .NET components like Data
Adapter and Data Set.
. Used Indexes and Stored Procedures for performance enhancement.
. Involved extensive Testing and prepared test cases.
. Used XML for buffering frequently retrieved information.
. Used VSS for version control and as code repository.
. Prepared Help & Documentation for Admin users.
Environment:
ASP .NET, C# .NET, .Net Framework 2.0, Web Services, SOAP, XML, JavaScript,
IIS, Visual Studio 2005, Windows 2003, VSS, Dundas Charts, ABCpdf.
EGovernance, India / VSTL
Jul 2005 - Sep 2007
Programmer / Analyst
The purposes of the project was to extend the capabilities of the current
application, which was developed using FoxPro, and develop new modules to
manage the Government body's information using .NET technologies. It has
various modules like Property Tax, Water Tax, Estate, Birth-Death
Department, PGR, Solid Waste Management, Shop Establishment modules. Users
have parameterized tax calculations, customized tax patterns, yearly
assessment register, birth-death certificates, shop license, license
renewal. Old database from FoxPro is uploaded to SQL server 2000. Provided
24*7 support to client. Application has 450+ ASPX Forms and 350+ Reports.
Separate VB Exe for menu rights, group rights and user rights (only for
admin side).
Responsibilities:
. Converted the code from VB pages to VB .NET/ASP.NET.
. Involved in requirement gathering, analysis, design, development,
change management, deployment and user training, client support.
. Taken part in the reverse engineering of the existing application and
also developed new modules in new application.
. Used JavaScript for Client-side validations.
. Designed and developed database search functionality.
. Extensive usage of Crystal Reports XI.
3. Created numbers of complex formula in sub report using different type
of variables likes shared variable and retrieved them from master
report.
4. Performed coding to integrate Crystal Reports viewer control to aspx
pages.
5. Generated multiple reports like yearly Assessment register,
yearly/monthly Reports, Collection Register/Summery, Revenue
Register/Summery, Target Collection.
. Performed testing and documentation of the site.
. Developed the project using iterative approach.
. Developed a data layer using ADO .NET.
. Developed prototypes and managed changes based on feedback.
. Designed and implemented core architectural components.
. Gathered and documented requirements specifications using UML use-case
methodology.
. Created DTS packages for data transfer and modifications.
. Involved in extensive Testing.
. Prepared test plans and did unit testing of the programs.
. Moved deliverables to Test for Quality Assurance and assisted
installation and configuration.
. Used Globalization in this application. It can work in any language.
. Used XML to buffer frequently retrieved information.
. Provided Onsite training and support to client.
. Used VSS for version control and as code repository.
. Prepared Help & Documentation for Admin/General users.
Environment:
ASP .NET, VB .NET, ADO .NET, .NET Framework 1.1, Visual Studio .NET 2003,
SQL Server 2000, IIS 6, VB6, HTML, CSS, XML, XSLT, JavaScript, Crystal
Reports 9/XI, Visual Source Safe
Civic, India / VSTL
Jul 2004 - Jun 2005
Programmer
Application is developed for Nagar Palikas to make them Computerized.
Includes multiple modules like Property Tax, Water Tax, Birth-Death
Department, PGR modules. Application users can have parameterized tax
calculations, customized tax patterns, birth-death certificates, new water
connection, water connection renew/cancellation, public grievances entry.
Generated reports using Crystal Reports 9. Various reports are available
for department officers to do analysis and management.
Responsibilities:
. Involved in VB Coding.
. Gathered and documented requirement specifications using UML use-case
methodology.
. Involved in requirement gathering, analysis, design, development,
change management.
. Designed and developed database search functionality.
. Developed the project using iterative approach.
. Developed a data layer using ADO.
. Developed prototypes and managed changes based on feedback.
. Extensive usage of Crystal Reports 9 and developed lots of charts.
. Developed Bar and Pie Charts and changed groups runtime.
. Developed Reports using OLE-DB and Plain Text Files (Field Definitions
Only)
. Created In-place and On-Demand Sub-reports for heavy reports.
6. Customized reports by adding new features such as report alerts,
running total, sub-reports and drill-down fields.
. Designed and implemented core architectural components.
. Prepared test plans and did unit testing of the programs.
. Used MTS for maintaining transactions.
. Used VSS for version control and as code repository.
. Prepared Help & Documentation for Admin users.
Environment:
VB 6, SQL Server 2000, ADO, Crystal Reports 8.5/9, COM+, MTS, Visual Source
Safe
Contact this candidate