Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Plano, TX
Posted:
January 20, 2015

Contact this candidate

Resume:

Denzil D’sa

PROFILE SUMMARY

• Over * years’ experience in Analysis, Design, Development, Coding and Testing of Web and

Windows applications

• Expertise in understanding user requirements and translating business requirements into technical

solutions with excellent problem solving and troubleshooting capabilities.

• Experience in Software Development Lifecycle (SDLC), Agile, Test Driven Development (TDD)

methodology

• Participated in all stages of Software Development Lifecycle, gathering requirements, analysis,

design, development, testing and implementation

• Good knowledge and understanding of object oriented programming (OOP) principles.

Experience in developing Windows application, Web application and Web Services.

Experience of programming in C#, VB.NET, ASP.NET, MVC.NET, ADO.NET and .NET Framework

4.0

Experienced in Microsoft Visual Studio 2008/2010

• Extensive experience in the design and development of N tier Client Server application

architecture.

• Experienced in utilizing the new integrated features of ASP.NET versions like Windows

Communication Foundation (WCF), Windows Presentation Foundation (WPF) and Silverlight for desktop

applications.

• Experience with Microsoft CRM content management system.

• Experienced in using Source Control Systems like, Visual Source Safe (VSS) and Team Foundation

Server (TFS) Task Management to manage application life cycle.

• Extensive experience in working with transactional database systems such as Oracle, SQL Server

and DB2.

• Experience in developing and maintaining SQL Server objects and writing Stored Procedures,

Triggers, Views and Functions.

• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),

SQL Server Analysis Services (SSAS) and Crystal Reports for report generation, integration into . NET

applications.

• Experienced in the use of Enterprise patterns and practices for database connections.

• Experienced in team environments, N Tier systems, Distributed architecture and Service oriented

architecture (SOA) for system development and integration.

Exposure to developing with Java Script Object Notation (JSON) and data exchange pattern.

Experienced in writing test plans and Unit/Integration test scripts.

Good communication skills and interpersonal skills.

Self motivated and quick learner of new concepts and technologies.

TECHNICAL SKILLS:

C#.NET 3.5/4.0, VB.NET, Visual Basic 6.0, Python,

Programming Languages

Ruby, PHP, C, C++, Swift

ASP.NET 4.0/3.5/3.0/2.0/1.1, Silverlight, Ajax,

Web Development

Javascript, VB Script, HTML, CSS, ASP

XML, XSLT, SOAP, WSDL, XQuery, XAML

XML Technologies

1

UI Technologies Winforms, WPF, Telerik, Infragistics

Visual Studio 2008/2010/2013, Eclipse

IDE Tools

Databases MS SQL SERVER 2008/2005, MySQL, DB2, Oracle

10g/9i/8i, MSAcces

Operating System Windows 95 / 98 / NT / 2000/ XP, UNIX, LINUX

Sql Server Reporting Services (SSRS), Crystal

Reporting Tools

Reports 10/8.5/8

Windows Server 2003/NT, Microsoft IIS

Servers

(7.0/6.0/5.0/4.0)

WCF, ADO.NET, WebServices, AutoMapper

Middleware

Testing framework NUnit, CSUnit

Sitefinity, DotNetNuke, Joomla

Content Management

EDUCATION:

• Bachelors of Science

PROFESSIONAL EXPERIENCE:

Heartland Payment Systems (Plano, TX) May 2014 – Current

Sr .Net Developer

Description: Heartland is the fifth largest payment processor in the United States, delivering credit, debit,

prepaid card processing, mobile commerce, e commerce, marketing solutions, security technology, payroll

solutions, and related business solutions and services to more than 300,000 businesses and educational

institutions nationwide.

Responsibilities:

• Develop code written in C# and C projects for the POS Simulator application

• Design the workflow and presentation of the application in Visual Studio 2013

• Enhance the features and functionality of existing Winforms application

• Convert application from Winforms to ClickOnce and XBAP solutions to download and access the

application with Internet Explorer 11

• Create Setup files to install and run the application on Windows 7 machines

• Create and utilize INI file for the Winforms application

• Fix bugs and issues in the code reported by the QA team

• Work with delegates and multi threading in the POS Simulator application

• Work in an Agile team with Daily stand ups, Sprints, Reviews, and Grooming sessions

• Submit regular code hand offs to QA team for testing the application

• Write User Documentation for the application features and functionalilty

• Used Tortoise SVN as repository for source code

Environment: Visual Studio 2013, Tortoise SVN, Rally, MS Word, C#, C, XAML, XML, XSLT, Winforms, Unit

testing, Delegates, Classes, APIs

Commonwealth of Pennsylvania (Harrisburg, PA) Jun 2012 – Mar 2014

Denzil D’sa

Sr .Net Developer

Description: The Workers' Compensation Automation and Integration System is a Web based information

system that will allow electronic communication among the three workers' compensation program areas of the

Department of Labor & and the public. WCAIS will enable electronic communication and permit online filing,

online document management and around the clock access to information.

Responsibilities:

• Responsible for the design, development and implementation of Web and Windows based application

programs.

• Provided comprehensive maintenance support for Web and Windows applications and WCF services.

• Implement server side code written in WCF services for the business logic

• Worked on N tier server side and client side code for applications with multiple tiers for UI, Business,

Database

• Worked on applications that utilized multi threading for UI and backend Processing

• Created objects to ensure proper handling of exceptions and errors thrown by the applications

• Distinguish between VB.Net deprecated code and new code and replace with new code

• Create UDT’s, SPROCS, Functions to handle data that was stored in the database

• Creating test data utilizing SQL scripts for application testing and integration.

• Conducted user acceptance and general testing of applications.

• Actively monitoring system performance and batches on a daily basis, diagnosing and resolving

faults.

• Developed VB.NET and C# code for several modules and services hosted on Web portals.

• Created stored procedures for applications that retrieved and stored data to the database.

• Collaborate with different teams working on individual application modules

• Maintain a list of defects and sift through code to work on fixes and check in the code for Functional

and QA testing

• Meet with team for project overview and code reviews

• Check in code and stored procedures for dev., integration and production environments through daily

and weekly builds

Environment: Visual Studio 2010, SQL Server 2008, TFS 2010, N Tier, TopTeam, MS Excel, T SQL, VB.NET,

C#, ASP.NET 4.0, Web Services, XML, XSLT, HTML, CSS, Javascript, jQuery, Interfaces, AutoMapper,

Custom Web Controls, Generic Controls

One Call Now (Willoughby Hills, OH) Nov 2011 – May 2012

Sr .Net Developer

Description: One Call Now™ is the ideal communications solution for over 35,000 clients across North

America. Businesses, schools, churches, synagogues, camps, youth sports teams and clubs as well as

emergency crews, military units, and communities use our high speed reliable service to get their message to

everyone, everywhere, every time.

Responsibilities:

Developing JSON and XML WCF services to provide functionality to mobile applications

3

Developing and maintaining SQL Server objects including stored procedures and functions,

indexes, triggers

Extensive use of Enterprise patterns and practices for database connections

Design functionality for the mobile applications to communicate with WCF services

Design user and group management features for the mobile application and web services

Work in an agile team with extensive use of TFS 2010 Source Control and Task management to

manage the application life cycle

Utilize TFS bug reporting to handle bugs and issues that come up during sprints

Implement WCF instancing, request/response logging to create different modules of the code

Write documentation for code procedures and web service descriptions to assist with better

understanding of design structure

Regularly meet with QA team to review test cases and discuss errors and problems found during

testing. Recommend solutions and create estimates to implement those solutions

• Develop test harness for testing the WCF web service methods

Provide training for new team members

Environment: Visual Studio 2010, SQL Server 2010, TFS 2010, T SQL, C#, ASP.Net 4.0, HTML, CSS,

Javascript, jQuery, XML, SOAP, JSON, WCF, WPF, .Net Web Services, Web Controls, CSUnit, NUnit,

NHibernate

Clayton Services (Shelton, CT) Aug 2009 – Jul 2011

Sr .Net Developer

Description: Clayton is the market leader in Due Diligence, Independent Pricing, Risk management,

Surveillance and Loss Mitigation in Mortgage industry. As a member of Clayton Fixed Income Services team,

I work on company’s two core products called Credit Risk Management (CRM) and File Upload. CRM

provides a very comprehensive web based solution for servicers and analysts to access deal and loan level

information. File Upload Application is a custom built ETL solution for CRM that brings in more than 3000 files

containing millions of data points every month from a multitude of sources including banks, mortgage

servicers and investment firms.

Responsibilities:

• Create Classes and Objects using C#, LINQ, Entity Framework, MVC.Net

• Create User Interface web pages using ASP.Net, HTML, CSS and Infragistics web controls.

• Used jQuery and Javascript to create client side functions

• Create WPF application using XAML and C# to enable rich features.

• Created server side code to consume WCF services to identify file types.

• Create and modify SQL Server database schema where needed. Designed and implemented Tables,

Field Attributes and defined Constraints, primary foreign keys, and referential integrity.

• Developed Silverlight UI code for various desktop and web applications

• Create LINQ queries to leverage the flexibility and powers of Entity Framework and LINQ

• Create and maintain SQL Server objects including Stored Procedures and User Defined Functions.

• Utilized SSIS and SSRS to create different tools for data extraction and migration

• Regularly meet with QA and UAT teams to review test cases and discuss errors and problems found

during testing. Recommend solutions and create Level of Effort estimates to implement those

solutions.

• Work with Agile development techniques using a task based workflow system

Denzil D’sa

• Developed various test classes and scripts using CSUnit and NHibernate following Test Driven

Development lifecycle.

• Work with different branches of code for different environments and maintain code integrity using

Team Foundation Server 2010 as Project repository.

Environment: C#, ASP.Net 4.0, ASP.Net, HTML, CSS, XAML, VisualStudio 2010, Entity Framework 4.0, MVC

3.0/2.0, MVVM, Silverlight, AJAX, LINQ, SQL Server 2008, Javascript, jQuery, WPF, WCF, Web Controls,

TDD, NUnit, CSUnit, NHibernate, Tortoise SVN, Infragistics Controls, SSIS, SSRS

DataMotion, Inc. (Morristown, NJ) Sep 2007 – Jun 2009

.Net Developer

Description: DataMotion is a leading provider of secure email through its various software offerings. It

provides hosted and in house web portal based encrypted email, Send Secure button plug in for

Outlook/Lotus Notes users, POP3 based email retrieval, PDF push based email retrieval, DataMotion Policy

Manager to filter and channel secure emails, Sales Force integration for leads and more.

Responsibilities:

• Worked on a tight schedule to compile bug free setup wizards for major/minor release versions to be

tested thoroughly and be released to production

• Upgraded VB.Net code from Framework 1.1 to Framework 3.0 for the Large File Transfer Client to

ensure compatibility with Windows Vista/7

• Designed and develop server side code for desktop/web applications.

• Maintain code that was written in a multi threaded environment.

• Created a mobile site for the SaaS application using .Net Web Service API to enable access to the

portal via mobile phones

• Designed and implemented eCommerce applications which was tied into the central billing system

Authorize.Net

• Conducted pair programming sessions to for various front end and back end sections of the code

• Troubleshoot and tested code that was written in COM/COM+ modules

• Developed C# code to print SAAS generated reports to PDF and Excel

• Worked on LDAP application to enable the Policy Manager integration with Active Directory services.

• Developed and updated code for Office Outlook plugin using Office Interop Assemblies

• Designed and updated Winforms application to WPF application and incorporated user authentication

via Login service.

• Designed and developed a Sitefinity CMS content management system using ASP.NET for the

corporate website, with heavy integration with Salesforce.com

• Used SalesForce.com for creating Customer Support, Leads, Campaign associations with the

corporate website. Setting automation rules to send replies to customers.

• Creating and customizing different server side forms to be accessed by internal users.

• Updated and maintained the Sitefinity CMS servers

• Developed detailed User Acceptance and Regression test scripts using Watin (C#) for corporate

SAAS application

• Worked closely with QA team to write automated scripts for functional, system and regression testing.

5

• Developed various test classes and scripts using CSUnit and NUnit.

• Maintained a test data workbench for testing various features based on client specific configurations.

Environment: Windows, C#, VB.Net, ADO.Net, MVC 2.0/1.0, WCF, WPF, MVVM, Silverlight, AJAX, VSS,

TFS, Web Services, Office Interop Assemblies, Javascript, jQuery, CSUnit, NUnit, HTML, XML, CSS, XAML,

T SQL, Ruby, Visual Studio 2003/2008, SQL Server 2005/2008, SSRS, MS Access, Visual SourceSafe

CertifiedMail.com, Inc. (Morristown, NJ) Jul 2006 – Jun 2007

.Net Developer

Description: CertifiedMail is a leading provider of secure email through its various software offerings. It

provides hosted and in house web portal based encrypted email, Send Certified button plug in for

Outlook/Lotus Notes users, Pop3 based email retrieval, PDF push based email retrieval, CertifiedMail Policy

Manager to filter and channel secure emails, Sales Force integration for leads and more.

Responsibilities:

• Migrated existing applications from VB6 to VB.Net Framework 1.1

• Wrote and optimized stored procedures, triggers, indexes for faster SQL processing

• Wrote SQL Server Stored Procedures to back up and recover the CertifiedMail Server during routine

maintenance updates.

• Developed code for Office Outlook plugin using Office Interop Assemblies and COM/COM+ objects

• Installed and upgraded CertifiedMail Server systems for various clients

• Worked closely with clients to gather requirements for the CertifiedMail Server and provide

administrative and back end support to update their production servers

• Worked on Microsoft CRM content management system

• Created documentation for clients including manuals and help files

• Configured multiple Virtual Machines on the staging servers to create different test environments

• Conducted pair programming sessions for various front end and back end sections of the code for

the corporate website.

Environment: Windows, C#, VB.Net, ADO.Net, WCF, WPF, Silverlight, AJAX, VSS, TFS, Web Services,

COM/COM+, Office Interop Assemblies, Javascript, jQuery, CSUnit, NUnit, HTML, XML, CSS, T SQL, Ruby,

Visual Studio 2003/2005, SQL Server 2000/2005, SSRS, MS Access, Visual SourceSafe

Verizon Communications Inc., (MD) Oct 2005 – May 2006

.Net Developer

Targeted Advertising system is a solution for pushing suitable advertisements to the mobile users in their

slack time. The advertisements are filtered on the basis of user’s context (SMS, calendar and reminder

entries) processed by context server and the advertisements (Text, SMS and media) are pushed to the mobile

users.

The activities included in this system are:

o Capturing context information from the compact device like SMS, calendar and reminder entries.

o Sending the captured information to the context server for running algorithm based on ontology.

o Finding suitable advertisement

Denzil D’sa

Sending these advertisements to the connected mobile users in slack time.

o

Responsibilities:

• Create Classes and Objects using C#.Net for n tier applications

• Create pages using ASP.Net, HTML, CSS and web controls for the User Interface

• Developed User Login mechanism using role based authentication

• Create and modify SQL Server databases where needed

• Create Stored Procedures and User Defined Functions

• Worked with Agile development techniques using a task based workflow system

• Worked with different branches of code for different environments and maintain code integrity using

Tortoise SVN as project repository.

Environment: C#, ASP.NET 2.0/1.1, HTML, CSS, .NET Compact Framework, JavaScript, SQL Server 2005,

Tortoise SVN

7



Contact this candidate