Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Pleasanton, CA
Posted:
March 12, 2015

Contact this candidate

Resume:

Robin Thomas

Senior ASP.Net / C# / SQL Developer

Mobile: 510-***-****

Email: acojcx@r.postjobfree.com

[pic]

SUMMARY

. 10+ years of experience in software development with responsibilities in

code development, build & implementation and troubleshooting of client-

server applications using ASP.NET, WCF, MVC3, MVC4, C# .Net, HTML,

Webservices, ADO.NET, JavaScript, JQuery, IIS, SQL Server 2008, SQL

Azure.

. Extensive experience in high traffic Web based applications, System

Analysis, Design, Development and Implementation of various Client/Server

and Internet/Intranet applications.

. Knowledge in latest web technologies including Angular JS and Node.JS

. Developed webpages for real-time transaction monitoring using AngularJS

and jQuery

. Proficiency in end-to-end development of software products from

requirement analysis to system study, designing, documentation and

implementation.

. Experience in design and development of cutting-edge Enterprise

Applications using ASP.Net, C#, VB.Net, WCF, Web Services, SQL Server,

Oracle, SSRS, Crystal Reports, SSIS, Classic ASP, VB 6.0, Java script,

XML, XSLT, XSD, CSS2, CSS3, HTML/HTML5, DHTML, ADO. Net.

. Significant experience in SDLC with technical expertise in Microsoft .Net

Technologies

. Worked with .NET Server Controls, Web User Controls, Data Grid Web

Controls, and Forms Validation Controls using ASP.NET

. Development of Web role and Worker role applications using MVC 4 and C#

. Hosting of application in full IIS and Hosted Web Service Core

. Managing Virtual Machines in computing core and Database cores

. Using Azure diagnostics to collect diagnostic data from worker role and

web role

. Using Azure storage explorer to manage Azure BLOB storage

. Experience in Azure BLOB storage and Azure Table storage using OData

protocol and LINQ queries with WCF Data Service .NET Libraries

. Experience in developing N-Tier applications and applications using SOA.

. Experience in iTextSharp and PDFSharp for merging PDF documents and for

splitting multipage PDF to single page PDF

. Used muPDF for splitting the PDF file and for converting to jpg

. Worked with PDFLibNet to convert to different formats and to fetch single

page from a multi page PDF

. Used Tesseract to read OCR from .jpg and .bmp and single page .tiff

images.

. Exposed to different design patters like Singleton, Factory etc

. Experience in developing Stored Procedures, triggers, views, Indexes

using SQL Server 2008 and SQL Azure.

. Experience in SQL Full Text Search for quick search of text from large

data.

. Experience in database maintenance and administration in SQL Azure.

. Experience in data sync jobs and performance tuning in SQL Azure.

. Managing database import and export using Azure DAC services.

. Involved in maintenance and administration of SQL Azure Database.

. Experience with SQL Azure Dynamic Management Views

. Designed, developed and implemented Back Office Solution for Banking

Institutions

. Image recognition based application for clearing division of banks and

mortgage institutions

. Used Fujitsu ADF duplex scanners to scan the documents in single/duplex

modes with the help of Pegasus and Kodak imaging controls.

. Worked with Abbyy fine reader and Lead controls to read OCR, ICR, OMR and

Barcode information.

. Worked with MICR (E-13B font), OCR-A, OCR-B and ICR/IWR to recognize hand

written characters and words, and Code 39 for Barcode reading.

. Involved in designing machine-readable OCR data forms using HP Cardiff

TeleForm Software.

. Worked with Customer Application Forms (CAF), Account Opening Form (AOF)

and Know Your Customer Forms (KYC) to process customer information

. Involved in migration of data that involves translation of data from one

format to another format

. Highly skilled at interfacing with the customer and resolving their

issues with a quick turnaround time

. Excellent analytical, problem-solving and documentation skills and

involved in the entire SDLC life cycle design and implementation.

. Possess good work ethics and high level of integrity, good communication

and interpersonal skills, presentation skills and troubleshooting skills.

TECHNICAL SKILLS

Programming C#.Net 4.5, VB.NET 4.5, ADO.Net,

VB 6.0, PL/SQL

Web Development ASP.Net, HTML/HTML5, JavaScript, CSS2/CSS3,

DHTML, Classic ASP, Angular JS, Node.JS

Databases SQL Azure, SQL Server 2000/2005/2008 R2,

Oracle 10g, MySQL, MS-Access, SQL Azure

Version Control MS Visual Source Safe(VSS), Team Foundation

Server (TFS), Polytron PVCS, Tortoise SVN

UML Use Case diagram, DataFlow diagram,

Sequence diagram

Internet Technologies AJAX, XML, XSLT, XSD, Web Service

Key Skills .Net Development, Design Patterns,

Distributed Applications, Use Case

Documents, UML Activity diagrams for

modeling business scenarios and application

flows

Testing Skills Unit Testing, Integration Testing,

Automation Testing using TFS, WCF Load

testing with SoapUI, WCF testing with WCF

TestClient /WebService Studio/SoapUI.

Domain Knowledge Health Care, Retail, Mortgage, Logistics

Design Patterns MVC, Abstract Factory, Singleton

Bug Tracking Tool HP Quality Center, MS TFS

Reporting Crystal Report, SQL Server Reporting

Services 2008 (SSRS)

Knowledge AGILE Methodology, SCRUM, Networking

essentials, UML and Rational Unified

Process

Third party tools Nunit, Bugzilla, MS Visio, SoapUI, WCF Test

Client, Borland Together

Imaging Technologies iTextSharp, PDFSharp, muPDF, PDFLibNet,

Tesseract, Adobe PDF Viewer, Abbyy fine

reader, Lead Tools controls, HP Cardiff

TeleForm

EDUCATION

. Master in Information Technology (MIT), 2004

. Bachelor of Computer Applications (BCA), 1999

EXPERIENCE

State Compensation Insurance Fund (SCIF), Pleasanton, CA Oct

2013 to Till date

Sr. Software Developer

DMS With Workflow

DMS is a generic document management software with workflow management

included in it. The software is able to capture any common types of

documents (PDF, MS Word, MS Excel, MS Powerpoint, TIFF, JPG, GIF, PNG, BMP

etc) and archive these documents. The document will go through a series of

stages which is configured in the workflow definition module, and OCR will

be applied on the document to read the text in it. SQL Full Text Search is

used to search for a document based on the contents of the document. It

also allows to annotate the documents to highlight important areas in the

document.

Responsibilities:

. Developing Web application using ASP.Net, C#, WCF, JavaScript, JQuery,

HTML5 and CSS3.

. Developed webpages for real-time transaction monitoring using AngularJS

and jQuery.

. Developed desktop application for daily/weekly reports generation.

. Configuring and Developing in Windows Communication Foundation (WCF).

. Used Fujitsu ADF duplex scanners to scan the documents in single/duplex

modes with the help of Pegasus and Kodak imaging controls.

. Used PDFLibNet and Adobe PDF Viewer to split the documents into pages and

to show it on the screen quickly.

. Worked with Abbyy fine reader and Lead controls to read OCR, ICR, OMR and

Barcode information.

. Used iTextSharp and PDFSharp for merging pdf documents and for splitting

multipage pdf to single page pdf

. Used muPDF for splitting the pdf file and for converting to jpg

. Used PDFLibNet to convert to different formats and to fetch single page

from a multi-page pdf

. Used Tesseract to read OCR from .jpg and .bmp and single page .tiff.

. Worked with MICR (E-13B font), OCR-A, OCR-B and ICR/IWR to recognize hand

written characters and words, and Code 39 for Barcode reading.

. Involved in designing machine-readable OCR data forms using HP Cardiff

TeleForm Software.

. Leveraged HTML5, CSS3 in web page development.

. Thoroughly followed the Agile Methodology in the entire project.

. Developing complex Stored procedures, User Defined Function and Triggers

in SQL Server 2008.

. Actively involved in data modeling and contributed in the designing and

creation of SQL 2008 databases.

. Extensively involved in writing unit test cases and executing unit tests

using Nunit.

. Responsible for deploying the existing applications in DEV, SIT, UAT and

PRODFIX environments.

Environment: Visual Studio.Net 4.0, ASP.NET (C#, ADO.NET), WCF, SQL SERVER

2008, Tortoise SVN, AJAX, T-SQL, CSS3, XML, HTML5, XSD, WSDL, SOAP, JSON,

JQuery, Java Script.

G4S, Tampa, FL

Jan 2012 to Sep 2013

Sr. Software Developer

CFMS (Cash Flow Management System)

CFMS is a software that manages all services of G4S Securities, which

includes Cash-in-Transit system, ATM Replenishment Services, secure

holdings and high risk transport, and logistics of cash and valuables with

all provincial and federal standards on safety.

Responsibilities:

. Developing Web application using ASP.Net, MVC4, C#, JavaScript, JQuery,

JSON, HTML5 and CSS3.

. Configuring and Development in Windows Communication Foundation (WCF).

. System exposes all the data/content through a Windows Communication

Foundation (WCF).

. Development of Web role and Worker role applications using MVC 4 and C#

. Leveraged HTML5, CSS3 in web page development.

. Experience in Azure BLOB storage and Azure Table storage using OData

protocol and LINQ queries with WCF Data Service .NET Libraries

. Migrating the portal application to MVC4.

. Hosting of application in full IIS and Hosted Web Service Core

. Managing Virtual Machines in computing core and Database cores

. Using Azure diagnostics to collect diagnostic data from worker role and

web role

. Using Azure storage explorer to manage Azure BLOB storage

. Thoroughly followed the Agile Methodology in the entire project.

. Developing complex Stored procedures, User Defined Function and Triggers

in SQL Server Azure.

. Actively involved in data modeling and contributed in the designing and

creation of SQL Azure databases.

. Managing database import and export using Azure DAC services.

. Involved in maintenance and administration of SQL Azure Database.

. Extensively involved in writing unit test cases and executing unit tests

using Nunit.

. Responsible for deploying the existing applications in DEV, SIT, UAT and

PRODFIX environments.

Environment: Visual Studio.Net 4.0, ASP.NET (MVC4, C#, ADO.NET), WCF, SQL

SERVER Azure, TFS, AJAX, T-SQL, CSS, XML, HTML5, XSD, WSDL, SOAP, JSON,

JQuery, Java Script.

Dell Inc, Plano, TX Nov 2009

- Dec 2011

Sr. Software Developer

CDAS (Common Data Access Service)

CDAS is a WCF service used in online and offline sales portals of Dell

computers. It manages quote generation, conversion of quotes to orders,

order processing, online payment process, order tracking and order

delivery. It has the SAP Data Service for address validation during

customer creation, billing and order delivery.

Responsibilities:

. Actively involved in Coding using ASP.Net, C#, VB.Net, ADO.Net, HTML,

DHTML, XML, CSS, AJAX, JavaScript.

. Intensively worked in application using SOA architecture developing Web

Services around existing business functions.

. Leveraged Windows Communication Foundation (WCF) when migrating

application from Dot Net 2.0 to 3.5

. Developed the application using Microsoft .NET Framework 3.5 mainly Web

Forms.

. Leveraged AJAX to improve the application performance and leveraged all

the AJAX tool kit controls.

. Leveraged Generics, Delegates & Events for handling user control events.

. Intensively worked in querying Active Directory using .Net classes and

LDAP queries.

. Wrote complex Stored Procedures, triggers and User Defined functions in

SQL Server 2005 using T-SQL to improve the application performance.

. Authenticating the Users, groups using Active directory and LDAP and

storing those group in the user log table.

. Leveraged SQL Server Reporting Services 2005 (SSRS) to generate complex

reports as this involved extensive multi level drill downs, sorting etc.

. Leveraged all the SSRS tools like Table, Matrix, Chart, Sub report etc.

. Leveraged SSIS to archive the historical data as to improve the

performance of the SQL query.

. Worked very closely with the Business & Testing teams for the

requirement gatherings and integration testing.

. Responsible for deploying the existing applications in DEV, SIT, UAT and

PRODFIX environments.

. Created components using VB.NET for stitching the different types of

documents (.doc, pdf).

. Extensively involved in writing unit test cases and proper unit testing

using Nunit.

Environment: Visual Studio.Net 3.5 (ASP.NET MVC3, C#, ADO.NET), WCF, SQL

SERVER 2008 R2 (SSIS, SSRS), TFS, AJAX, T-SQL, CSS, XML, XSLT, Web Service,

WSDL, SOAP, JSON, JQuery, Java Script.

Volvo Inc, Bangalore, India Nov 2008

- Oct 2009

Sr. Software Developer

LDS-NG (Local Dealer System - Next Generation)

Local Dealer System is a retail software used for managing vehicle sales

and vehicle service of Volvo Inc. It manages the workflow and stages of

sales and service.

Responsibilities:

. Actively involved in the creation of n-tier applications.

. Followed the Agile Development methodology.

. Leveraged SQL Server Reporting Services 2005 (SSRS) to generate complex

reports as which involved extensive multi level drill downs, sorting

etc.

. Used SQL Server Integration Services (SSIS) to transfer files between

Excel, flat files to SQL Server and vice versa.

. Actively involved in data modeling and contributed in the designing and

creation of databases.

. Actively involved in the creation of documents such as Use case

diagrams, HLD's, LLD's.

. Coding using ASP.NET, C#, VB.Net, ADO.NET, CSS, HTML, AJAX and

JavaScript.

. Wrote complex stored procedures in SQL Server 2005 using T-SQL.

. Leveraged XSL Transformations (XSLT) for transforming from XML.

. Responsible for code review to ensure that the coding standards are

followed and suggested best coding practices.

. Extensively involved in writing unit test cases.

. Involved in Integration Testing and followed the Top Down approach.

. Used AJAX extensively across the portal to improve the application

performance.

. Developing the application using Microsoft .NET Framework 2.0 mainly Web

Forms.

. Leveraged SQL Server 2005 as a back-end database, T-SQL to create stored

procedures, database tables and constraints and performing the entire

database related tasks from the Visual Studio 2005 development

environment.

. Leveraged Web Parts, Themes, Masters Pages and User Controls.

. Utilized infragistics grid to design the user interface to get the

performance like windows application.

. Utilized JavaScript to avoid post back in import, export, and copy to

clipboard and print functionality.

. Involved in configuring IIS.

. Utilized Web Services to call the live search and Ajax extender

functionality.

. Responsible for deployment of the project.

. Used Visual source safe (VSS) as the version control tool.

. Utilized Bugzilla as a tool for tracking the bugs

Environment: DotNet 2.0/3.5 (ASP.NET, C#, VB.NET, ADO.NET), SQL SERVER

2005/2008 (SSIS, SSRS), Rational Rose, AJAX, T-SQL, CSS, XML, XSLT, Web

Service, WSDL, SOAP, Java Script, SOA.

Centurion Bank, Bangalore, India Mar 2006 -

Oct 2008

Software Developer

UPCS (Universal Process Control System)

Integrated imaging technology with the existing workflow of the retail

business at Centurian bank. Customer documents are scanned and segregated

and uploaded to the central office. Centralized operations team process

customer documents using OCR and update the required business information

in database. Used Fujitsu ADF duplex scanners to scan the documents in

single/duplex modes with the help of Pegasus and Kodak controls. Worked

with Abbyy fine reader, Lead controls and Text OCR APIs to read OCR, ICR,

OMR and Barcode information from the scanned tiff images with minimum

200dpi. Worked with MICR (E-13B font), OCR-A, OCR-B and ICR/IWR to

recognize hand written characters and words and Code 39 for Barcode

reading. Worked with Customer Application Forms (CAF), Account Opening Form

(AOF) and Know Your Customer Forms (KYC) to process customer information.

Responsibilities:

. Development of the application in Asp.net 2.0 and C# with the back

end as SQL Server 2005.

. Integrated the existing ASP application with the ASP.Net 2.0 to

utilize the existing features of the current application.

. Used Fujitsu ADF duplex scanners to scan the documents in

single/duplex modes with the help of Pegasus and Kodak imaging

controls.

. Worked with Abbyy fine reader and Lead controls to read OCR, ICR,

OMR and Barcode information.

. Worked with MICR (E-13B font), OCR-A, OCR-B and ICR/IWR to

recognize hand written characters and words, and Code 39 for

Barcode reading.

. Involved in designing machine-readable OCR data forms using HP

Cardiff TeleForm Software.

. Worked with Customer Application Forms (CAF), Account Opening Form

(AOF) and Know Your Customer Forms (KYC) to process customer

information

. Leveraged SQL Server Reporting Services 2005 (SSRS) to generate

complex reports.

. Used Team Foundation Server (TFS) as a version control tool.

. Wrote complex stored procedures in SQL Server 2005 using T-SQL.

. Leveraged XSL Transformations (XSLT) for transforming into XML.

. Extensively worked with Web services to integrate with the external

applications.

. Creating virtual directories and configuring IIS.

. Custom created objects were used to transfer data's between the

layers.

. Implemented N tier architecture.

. Implemented Form Authentication to authenticate the users.

. Utilized SQL Server 2005 as a back-end database server, used T-SQL

to create stored procedures, created database tables and

constraints, and performed all the database related tasks.

. Developed the Application using Microsoft .NET Framework 2.0 mainly

Web Forms.

. Created Use Case Diagrams, LLD's, HLD's and unit test cases.

. Used Xml Document object to read, manipulate, validate and write

the xml file.

. Utilized various technologies such as ADO.NET, XML,CSS and utilized

various web controls.

. Extensively used AJAX controls throughout the web application.

. Leveraged .NET 2.0 framework (Web Parts, Themes, Masters Pages)

. Used User controls and Navigation features of ASP.NET 2.0.

. Managed sessions using InProcess session state management.

. Utilized various validation controls, used regular expressions,

performed custom validations and created various validation groups.

. Used Delegates and Events to handle the events in User controls.

. Handled cross browser compatibility issues.

. Used Java script for client side validation to improve the

performance.

. Involved in the Deployment of the project.

. Provide mentoring and coaching to team members.

Environment: DotNet 2.0 (ASP.NET, C#), MS Visual Studio 2005, AJAX, SQL

SERVER 2005, SSRS, SSIS, T-SQL, XML, CSS, XSLT, Web Service, Java Script,

Visual Source safe, MS Visio

Fidelity Inc, Bangalore, India Mar 2005

- Feb 2006

Software Developer

TitlePro - Title Insurance

Software manages title insurance, escrow and closing services, commercial

real estate services, property appraisal and valuation, building and site

assessments and other insurance services.

Responsibilities:

. Designed the multi-tier architecture and used the abstract factory

+ singleton design pattern.

. Implemented Form Authentication to authenticate the users.

. Utilized SQL Server 2000 as a back-end database server, used T-SQL

to create stored procedures, created database tables and

constraints, and performed all the database related tasks from the

Visual Studio Development environment and SQL server management

studio.

. Utilized various validation controls, used regular expressions and

performed custom validations and created various validation groups.

. Contributed in the entire Designing and Coding of the project.

. System was completely configurable using the configuration files.

. Developed stored procedures using SQL Server 2000.

. Created documents using Visio and MS Word.

. Involved in configuring IIS.

. Custom created objects were used to transfer data's between the

layers.

. Involved in unit testing.

. Involved in the Deployment of the project.

Environment: .Net 1.0 (ASP.NET, C#, ADO.NET), LDAP, SQL SERVER 2005, SSRS,

Classic ASP, Visual Basic, CSS, XML, XSLT, TFS, T-SQL, Java Script.

Volvo Inc, Bangalore, India Jan

2004 - Feb 2005

Software Developer

PNC (Part Number Creator)

Part Number Creator is used to create and validate Part Numbers that are

used in B2B order processing. It can validate a Part Number and can extract

the list of items from the given Part Number.

Responsibilities:

. Analysis of System Requirement Specifications

. Extensively worked in VB6 and ASP codes.

. Created COM components.

. Involved in configuring IIS.

. Involved in deploying the COM components in MTS.

. Intensively worked with T-SQL and PL/SQL queries in SQL Server 2000

. Creating Documentations in Visio, MS Word.

Environment: ASP, JavaScript, VB 6, COM, MTS, SQL Server 2000, IIS



Contact this candidate