Sql Server Customer Service .Net Web Services

Uttam

Email id: *******@************.***

Ph: 214-***-****

SUMMARY

• Over 8 years of experience in IT industry with . NET Framework using VB.NET, ASP.NET, C #, Win

Forms, ADO.NET, Web Services, WCF, LINQ and other Microsoft Technologies.

• Experience in various phases of Software Development Life Cycle (SDLC) such as Analysis, Design,

Development, Testing, Deployment and Maintenance of web and windows applications.

• I have been involved in project life cycle viz. Requirement gathering and analysis, Project Estimation,

Planning, Project Scheduling, Project Tracking and Team Management.

• Hands-on experience in UI Design using Win Forms, Web Forms, and programming ASP.NET,

C#.NET, VB.NET,ADO.NET, JavaScript, LINQ, AJAX, JQuery by using .Net Framework

2.0/3.0/3.5/4.0.

• Expertise in using Language Integrated Query (LINQ) providers for data manipulation.

• Experience in design and development of scalable and reusable enterprise systems and various web

applications using ASP.NET, VB.NET, ADO.NET, WCF and SQL Programming, SSIS and Database

Designing.

• Experience in developing ‘Distributed Components’ using Web Services and WCF.

• Strong knowledge in Relational Database Management Systems and experience in writing SQL scripts,

Stored Procedures, User Defined Functions and Triggers for SQL Server 2000/2005/2008.

• Experience with AJAX Library/AJAX Toolkit and creating high responsive User Interface.

• Experience with web building technologies like HTML, JavaScript, JQuery, CSS, and XML.

• Expertise in VB programming, testing, and working on compatibility modules.

• Extensive database designing and programming skills using SQL Server 2000/2005/2008, XML data

source, RDBMS and MS Access.

• Experience in source control systems like Microsoft Team Foundation Server (TFS 2010), Visual

Source Safe For handling file version and storage and .Net Framework 3.0/2.0/1.1 for development of

software class libraries middleware Business Logic Layer (BLL), Data Access Layer (DAL) and User

Interface (UI) components.

• Worked as IIS Administrator for configuring application pools, deploying Web Sites and Applications,

Modules and Handlers, State Management, Authentications, installing certificates, diagnosing errors in

event Viewer and log files, configuring Application Host config and other IIS role Services

• Developed Web Services (.asmx/WCF) based on SOAP.

• Experience in writing SSIS Packages in SQL Server

• Experience in complex SSIS Package design, SSIS Scheduling, workflow design, Framework design.

• Experience with Microsoft TEAM Foundation Server for Code Repository, Deployment and Version

control.

• Experience in developing/consuming WCF (Windows Communication Foundation) services.

• Strong and effective problem-solving, analytical and interpersonal skills, besides being a valuable team

player. Good knowledge of Loan Origination system.

TECHNICAL SKILLS:

Languages: VB.NET, C# .NET

.Net Framework (1.1, 2.0, 3.5, 4.0) VS 2003/2005/2008/2010, ASP.Net,

Web Technologies: ADO.Net, JavaScript, WCF, HTML, XML, JQuery, IIS, Web Services, Win

Forms, Web Forms

Databases: MS-SQL Server 2000/2005/2008, T-SQL, LINQ, MS Access

Internet Technologies: JavaScript, JQuery, HTML, CSS, and XML, VSS, JIRA, FxCop

IDE: Visual Studio.Net

Version Control: MS Visual Source Safe 6.0, Team Foundation Server (TFS).

Networking Protocols: SOAP, HTTP and TCP/IP

Design Tools: Visual Studio.Net, Microsoft Visio, VSS, MS Office 2007/2010

Operating Systems: Windows 98/2000/XP/7/2003 Server

Domain: LOAN Organisation

EDUCATION:

• Bachelors of Technology from Shivaji University, Kolhapur, India.

PROJECTS SUMMARY

One West Bank, Pasadena, CA June 2013 – till date

Senior .Net Developer

Project: Export32 Application

Description: Export32 application is part of loan origination system. Main purpose of this application is to

fund the loans and move loan origination data into servicing side. This application has three major parts

Treasury, SBO and CPI to pass the loan data for funding and servicing side.

Responsibilities:

• Requirement Analysis, Designing Techno functional document

• Developed Business layer to perform the business logic and pass data to data access layer.

• Developed Data Access layer (DAL) for communicating SQL Server.

• Developed web pages to create messages, to set up messages rules and to set up content using

ASP.NET, AJAX, C#, JavaScript.

• Worked on ASP.Net to develop web pages in our applications. Used VB.NET as a code behind for

all the web pages. Used AJAX, JQuery to call WCF services from JavaScript.

• Used Win forms controls and Custom User Controls to provide standard interactive User Interface

• Worked on Complex Stored Procedures, Functions, and Triggers in SQL Server.

• ADO.NET was used to implement the data access layer to communicate with databases.

• Created and updated complex stored procedures. Created SSIS packages to pass the data to different

vendor applications. Development, Peer Code Review and Unit Testing

• Designed and developed Services using WCF and also leveraged WCF security mechanism at transport

level with windows authentication type for our intranet applications

• Involved in implementing LINQ to SQL code to support the site Search functionality.

• Developed UI using custom controls, user controls, layouts and styles which inputs the data and

display the data for the web applications using ASP.NET.

• Used Web Services (SOAP) for communicating with other application and components.

• Wrote client side validations using JavaScript.

• Developed GUI of ASP .NET web forms using HTML, CSS and JQuery.

• Supporting User Acceptance Testing and Vendor Management

• Designed and developed WCF Web Services and configured our WCF Services with appropriate

endpoints for consuming them in the web application.

• Quick Analysis and troubleshooting of all servicing applications to keep business moving.

• Worked on large and complex databases in SQL Server 2008.

• The backend, database connectivity modules were designed using ADO.Net with SQL Server as

the database.

• Effectively used Microsoft Team Foundation Server(TFS) for Application Configuration Control

• Giving value adds to customer through innovative idea and fixing regular support tickets.

• Creating weekly and monthly production support tickets reports and discussion with Client folks and

within team to improve of SLA, recurring tickets and fixing of regular issue.

Environment: Visual Studio.NET 2008, SQL Server 2000, SSIS, VSS, ADO.Net, ASP.Net, C#, AJAX,

JavaScript, JQuery, HTML, CSS, XML, WCF, LINQ, TFS, SOAP, Web Services.

One West Bank, Pasadena, CA Jan 2013 – May

2013

Project: Prepaid Cards Batch File Processor

Description: Prepaid Cards Batch File Processor allows authorized users to close prepaid cards and

add/remove servicing fees. This application is semi-automated tool for uploading bulk transaction data to

the FIS for prepaid card transactions like close the cards, card closure/overdraft, promotion etc.

Responsibilities:

• Requirement Analysis, Designing Techno functional document

• Developed GUI in ASP.Net 4.0, VB.NET. Worked on Server and User Controls.

• Designed tables. Created queries and Stored Procedures. Worked on ADO.Net (Sql Connection,

Command, Data Table etc.) for operations using query and Stored Procedures.

• Created SSIS Packages to pass the prepaid card transactions for processing.

• Developed classes in Business Layer and in Data Access Layer in C#.NET.

• Used Win forms controls and Custom User Controls to provide standard interactive User

InterfaceUsed ADO.Net extensively with .Net SQL Data Provider thereby accessing the SQL

Server 2008 databases.

• Extensively used the LINQ feature in .NET for querying collections and integrating with SQL.

• Designed and developed Services using WCF and also leveraged WCF security mechanism at transport

level with windows authentication type for our intranet applications

• Written complex Joins for SQL queries while creating views, stored procedure, function and

Triggers.

• Developed the independent WCF (Windows Communication Foundation) services and defined Service

Contracts for specific functionality in search module

Modified web services to interact with the other applications and exposed them using SOAP and

HTTP.

• Designed and developed Web Forms using ASP.NET Controls, CSS and HTML to facilitate the

registered users.

• Utilized ASP.Net Validation controls and JavaScript to perform client side validation.

• Involved in discussion of modules, and technical meetings.

• Involved In designing and building SQL Server Integration Services (SSIS) packages

• Experienced in Software Configuration Management, setting up company Version policies utilizing

Team Foundation Server (TFS).

• Development of key modules using VB.Net in Visual Studio 2010.

• Created and deployed Web Services using ASP.NET, SOAP and XML for Pulling Customer

Service Records. Tracking defects raised by testing team to closure.

Environment: VB.Net, ASP.Net, VS 2010, SQL Server 2008, SSIS, JavaScript, HTTP, HTML, XML, CSS,

SOAP, Web Services, Win Forms, Web Forms, IIS, C#, WCF, TFS, AJAX, LINQ.

Capital One Bank, Dallas, TX Jan 2012 – Dec

2012

Project: Mortgage Lending Application Availability and Support

Description: Brain is a multi-threaded automated “Brain” is a centralized mortgage services engine, which

provides automated underwriting and pricing related services. It has XML based service-oriented

architecture. The Brain has been developed in-house by Indy Mac and it incorporates Indy Mac’s custom

pricing and underwriting algorithms. BRASS (Business Rules Automated Service System) is a rules

engine developed in-house, primarily for the purpose of supporting business rules for underwriting

guidelines and pricing for the Mortgage Bank.

Responsibilities:

• Analysis of the bugs / design issues, identifying the resolution and design of the permanent fix and

identify testing requirements of the same.

• Involved in UI Designing, Development and Testing of Web Forms using ASP.NET, C#.NET,

XML ADO.NET and .NET Framework.

• Implemented interfaces in C#.NET which encapsulate business logic and call them from web forms.

Developed Web Services for the System using .Net (SOAP/XML).

• Deployment of web services for online transactions using C#.NET and exposed them through

SOAP and HTTP.

• Used Serialization in C#.NET coding to serialize and de-serialize XML to objects and vice versa.

• Developed user interface web components using ASP.NET with C#.NET

• Developed T-SQL Stored Procedures for Generating Reports.

• Used Java Script validations with ASP.Net controls

• Designed and developed Services using WCF and also leveraged WCF security mechanism at transport

level with windows authentication type for our intranet applications.

• Used JQuery to build accordion style content, drag and drop functionality, calendar, popup and

modal windows.

• Used ADO.Net for retrieving data from backend database SQL server.

• Used AJAX to trade data with a web server, without reloading the page.

Developed classes for connecting to the SQL server Database.

Including in complex SSIS Package design, SSIS Scheduling.

Created views and stored procedures and optimizing them as required by front-end developers for

easier implementation on web pages.

Involved in Unit testing and regression testing of the entire application.

• Developed the independent WCF (Windows Communication Foundation) services and defined Service

Contracts for specific functionality in search module.

• Created and deployed Web Services using ASP.NET, SOAP and XML for Pulling Customer Service

Records.

Environment: VB.Net, ASP.Net, VS 2010, SQL Server 2008, SSIS, JavaScript, C#, JQuery, HTML, CSS,

XML, Web Services, SOAP, Web Forms, Win Forms, WCF, IIS, TFS, AJAX.

City National Bank, Los Angeles, CA Oct 2009 – Dec 2011

.Net Developer

Project: Online Services Channel

Description: The Online Services Channel Portal is intended to be the single location that aggregates the

entire spectrum of online services including account summaries and relationship team information for

City National’s clients. The project involves building of the front/back end infrastructure for delivery of

City National’s online services to be on par with the high touch and superior service model employed

throughout the rest of the organization.

Responsibilities:

• Involved in Design, Documentation, Coding in .NET Application using VB.NET.

• Involved in designing, trading and documentation of application flows and developed functional

diagrams using Visio, worked on presentation layer for developing GUI and developed various Web

forms using ASP.Net.

• Developed Data Access layer (DAL) for communicating SQL Server.

• Responsible for the creation of the applications by using VB.NET and enhancement of the projects

for .net application.

• Developed the application in ASP.NET and involved in writing VB.NET classes.

• ADO.NET was used to implement the data access layer to communicate with databases

• Used JavaScript for client side data validations and Validation controls to validate the input

Data using Validation Controls.

• Create and unit test intricate client side interactions with JQuery and JavaScript.

• Developed service contract, operation contract & data contract classes to support

communication between each layer.

• Designed and developed Services using WCF and also leveraged WCF security mechanism at transport

level with windows authentication type for our intranet applications

• Involved in IIS configurations as administrator. Involved in deploying, configuring multiple

applications into single websites in individual pools. Involved in troubleshooting issues. Created

documentations for team.

• Developed the independent WCF (Windows Communication Foundation) services and defined Service

Contracts for specific functionality in search module

• Involved in implementing LINQ to SQL code to support the site Search functionality.

• Developed UI using custom controls, user controls, layouts and styles which inputs the data

and display the data for the web applications using ASP.NET.

• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features,

configuring optimizations and securing the web application.

• Use AJAX controls to minimize server round trip and enhance customer experience.

• Created and deployed Web Services using ASP.NET, SOAP and XML for Pulling Customer

Service Records

• Involved in Writing, Modifying Stored Procedures in SQL Server database Using SQL.

• Prepared test cases for all the modules and performed unit and integration testing.

• Involved in hosting and deployment of the application.

Environment: VB.Net, ASP.Net, VS 2010, WCF, SQL Server 2008, JavaScript, LINQ, ADO.Net, Web

Services, SOAP, IIS, HTML, CSS, XML, AJAX, Web Forms, Win Forms, TFS, WCF, IIS, SSIS, JQuery.

Persistent System Limited, Pune, India

1 Role: Software Engineer

2 Project #1: Travel Management System April

2007 – Sep 2009

Description: The Travel Management system is designed to organize the travel request and approval process. It

maintains records of travel schedules of employees, displays travel request form, and the information is

summarized for managers for approval. It is a central site for posting travel guidelines and policies, finding links

to helpful travel sites, and initiating discussions about travel details. This system provides automatic workflow

and improves travel request efficiency and saves time too.

Responsibilities:

• Responsible for the Design, Development and Delivery of all the modules

• Designed BL and DAL using C#, ADO.NET and SQL Server.

• Involved in the Enhancements and Support for various applications.

• Developed GUI of ASP.NET Web Forms using HTML, CSS and Javascript.

• Developed Stored Procedures, Triggers, and Views in SQL Server 2005 for accessing the database

• Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent

as Parameter to the stored procedures

• AJAX, ASP.NET AJAX Library is used for rich interaction and partial page rendering.

• Developed partial post back validations to manipulate data on web pages using AJAX

• Involved in development and usage of user controls in various web pages.

• Extensively used Validation Controls and Custom validation controls to validate Web forms.

• Created procedures, functions, triggers using T-SQL

• Used AJAX to trade data with a Web Server without reloading the page

• Developed WIN FORMS and controls to associate arbitrary data.

• Involved in the code changes and development of new web-forms and connectivity to database

to get and store data from and to database.

• Involved in writing typical complex SQL queries and stored procedures using T-SQL.

• Created event driven Web Forms using ASP.NET and implemented Form Validations

• Worked on large and complex databases in SQL Server 2005.

• The backend, database connectivity modules were designed using ADO.Net with SQL Server as

the database.

Environment: C#, ASP.Net, VS 2005, SQL Server 2005, AJAX, JavaScript, ADO.Net, HTML, XML, CSS, T-

SQL, Web Forms, JQuery.

Project #2: Online Tracking System Feb 2006 to Mar 2007

Description: Main aim of this project is online tracking of customer visits made by employee. This project also

maintains customers, distributors, branches and product information and contains task management system. In

task management system manager can assign task to the employees or employees can create task by themselves.

Task assignment can be tracked using auto generated mail system.

Responsibilities:

• Responsible for the Design, Development and Delivery of all the modules

• Developed GUI in ASP.Net, C#. Worked on Server and User Controls.

• Coding and debugging using ASP.NET and C#

• Developed user interface web components using ASP.NET with C#.NET

• Developed Web Forms using ASP.NET Server Controls and validated client side using JavaScript

• Used ADO.NET objects such as Data Adapter, Data Reader and Data Set for consistent data access

• Written database Routines, Stored Procedures and fixing up standard specifications

• Convert Web Sites Projects into Web Application projects; rewrite code of Classic ASP.Net into

ASP.NET, C# based on business requirements. Created documentations for users and developers.

• Developed WIN FORMS and controls to associate arbitrary data.

• Involved in development of web-based with n-tier architecture.

• Used AJAX to trade data with a Web Server without reloading the page

• Updated connection strings and database related C# and VB.Net code in all applications according

new database schemas, recoded properties and functions, recreated classes and namespaces.

• Created event driven Web Forms using ASP.NET and implemented Form Validations

• Involved in complete software development life cycle modules through its deployment process.

• Actively participated in developing front end UI in ASP.NET.

Environment: ASP.Net, C#, VB.NET, SQL Server 2000, Web Forms, Win Forms, ADO.Net, AJAX, HTML,

CSS, JavaScript, JQuery.

Contact this candidate