Sql Server .Net
Resume:
Robin Thomas
Senior ASP.Net / C# / SQL Developer
Mobile: 510-***-****
Email: ************@*****.***
[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