Sql Server,ASP.Net,C#,webservices and wcf

[pic][pic][pic][pic] [pic][pic]

Kumar .P

E-mail: **.****@*****.***

Cell: 770-***-****

Summary

Over 12 Years of experience in Information Technologies with a focus

on Client / Server applications and Web applications, specially on

.NET Technologies like BizTalk Server,ASP.NET, C#.NET, VB.NET,

ADO.NET, Web Services, Windows Services, Windows Communication

Foundation (WCF),XML, Visual Basic 6.0, ASP, VB Script, Java

Script, SQL, PL/SQL, T-SQL, HTML and XHTML. Skills include

requirement specification, application analysis & design and

programming for various business application domains such as Fraud and

Phishing, Insurance Rating Engines, Finance, Banking, Content

Management System and Bio-metric. Having Business Visa (B1).

Experience

. Having Business Visa (B1) Visa with onsite experience.

. Working as a Project Lead/Tech Lead for Cybersoft Technologies,

Hyderabad from April 2010 to till date.

. Worked as a Team Lead for Tech Ortus, Hyderabad from August 2008 to

March 2010.

. Worked as a Senior Software Engineer for Select Sys India, Hyderabad

from November 2004 to July 2008.

. Worked as a Software Engineer for Bolster Solutions Pvt., Ltd., and

Bangalore from March 2002 to October, 2004.

. Specialized in Microsoft Technologies (C#.NET, ASP.NET, Web Services,

Windows Services, Visual Basic 6.0 and ASP).

. Familiar with .NET Framework (CLR, CTS, CLS), VB.NET, C#.NET, ASP.NET,

ASP, Visual Basic 6.0, ActiveX EXE and ActiveX DLL.

. Good working knowledge on SQL Server and Oracle.

. Good working knowledge on Windows Communication Foundation (WCF).

. Experienced with complete application development life-cycle including

requirements gathering, analysis and design, coding, testing and

deployment

. Good knowledge on Sql Server Reporting Services (SSRS)

. Good knowledge on MVC Framework.

. Quick learner with strong analytical and problem solving aptitude.

. Working experience using Agile methodologies.

. Motivated team player with ability to work independently.

Technical Expertise

Operating Systems : Windows Family

Programming Languages : Fox Pro,Visual Basic 6.0, ASP, ASP.NET, C#.NET, VB.NET, ADO.NET, VB

Script, JavaScript, XML, HTML,

XHTML, SQL, T - SQL, AJAX.

Database : FoxPro, Sql Server and Oracle.

Application Server : IIS 5.1 and IIS 6.0.

Middleware : COM

Versioning Tool : SSWI (Source Safe Web Interface), SVN (Sub

Version)

Business Process Management : BizTalk Server 2006

Tools : NUnit, NAnt, Cruise Control and FXCop.

BI : SSRS, SSIS.

Project Profile

Project #1 : PrimeroEdge

Title : PrimeroEdge POS (Front Office)

Client : Product

Technical Stack : ASP.NET 4.0, C#.NET 4.0, SQL Server 2008,Telerik

Controls, WCF, Windows Services, JQuery.

Team Size : 5

Description

This is system provides capabilities to manage student accounts, view and

modify transactions, reconcile sessions, generate reports, make deposits,

and much more.

Key Features

. On demand tracking and review of in-progress sessions and

transactions.

. Manage student account balances and transactions.

. Generate summary or detailed reports for daily, weekly, or monthly

date ranges.

. Perform end of day tasks of transaction, account, and session

adjustments.

. Reconcile and generate deposit slips for bank deposits

Responsibilities

1. Involved to write Database objects (tables and stored procedures)

to insert, update and delete information in sql Server 2000.

2. Implemented the JavaScript for client Side validations.

3. Implemented the AJAX Control by using Ajax Extensions for Business

Rules.

4. Involved to design and development the and ASP.NET pages.

5. Having onsite Houston experience.

Project #2

Title : PrimeroEdge Bio metric

Client : Product

Technical Stack : ASP.NET 3.5, C#.NET 3.5, Windows Forms (Win Forms),

Telerik controls, SQL server 2005, SSRS, WCF,

JavaScript and Ajax Extensions and SSRS, NITGEN

and ZK Devices.

Team Size : 4

Description

The System provides complete time and attendance management functionality

for school districts. The main features:

. Finger Samples Registration

. Clock-In/Out Process

. Online Employee Timesheets submission and approval process

. Configuration based screens.

. Add/Activate Employees.

. New employee tracking.

. Clock-In/Out Policies.

. Creating Pay Periods Dynamically

. Shift based Timesheets.

. Employees Hours Scheduling

. Configuring submitters and Approvers

. Online Manager Timesheets submission and approval process

. Import Employees

. Export Timesheets to Payroll

. Attendance, Early Clock-In/Out, Late Clock-Out and Tardy reports

Responsibilities

. Design :

1. Involving designing the classes that can be read the finger

sample for different devices like NITGEN, and ZK Devices by

implementing patterns.

2. Designing the Reports by using SSRS.

3. Writing WCF Services to communicating from windows application

to web application.

4. Implementing the rounding rules for employees.

5. Having onsite Houston experience.

Project #3

Title : Parent Online

Client : online Web

Reference URL : https://www.parentonline.net

Technical Stack : ASP.NET, C#, Web Services, SQL Server 2008.

Team Size : 2 (Off Shore)

Description

This is product provides the online payment system to enable Food Service

Departments an option to offer parents an alternative for making meal

payments. Parent Online communicates with the Primero POS automatically to

exchange student payment information, current account balance, account

usage history and joint sibling accounts. Parent Online is a secure, online

payment system that allows parents to make payments for cafeteria meals

using either a credit or check card. Parent Online updates the Primero POS

throughout the day. Parents can remotely access accounts anytime from any

Internet-enabled PC.

The district administrator can view all Parent Online payment activity by

school, by parent account, number of payments made, amount received as well

as view and print reports or deposit summaries.

Responsibilities

. Involved to design the Total system.

. Implemented web services for payment gateways.

. Involved to write Database objects (tables and stored procedures).

. Attending the scrum stand ups meetings daily.

Project #4

Title : Commercial Auto

Client : Franks & Assoc. Insurance Agency, USA.

Technical Stack : ASP.NET 3.5, C#.NET 3.5, SQL server 2005, XML,

Enterprise Library 4.1, Web Services,

JavaScript and Ajax Extensions and SSRS.

Team Size : 5

Description

This is System provides insurance quotes for all commercial line carriers

(Companies). It maintains the personal information, Drivers information,

Vehicle Information, violation information and finally will give the quotes

for different carriers and also it provides to bind the quote by producer

(agent) and also provides the quote page before binding.

Responsibilities

. Went to US (Atlanta) for understanding the domain knowledge.

. Fixing and assigning the issues to team members that are raised in

JIRA

. Backup and restoring the database from production to QA and DEV

Environments.

Project #5 : Authentication NET (Product)

Title : AuthNet

Client : the 41st Parameters, USA

Technical Stack : ASP.NET 2.0, C#.NET 2.0, Windows Services, SQL

Server 2005, NUnit, NAnt, FXCop, Cruise

Control, XML, Web Services, JavaScript and

Enterprise

Library.

Team Size : 10

Description

The AuthNet system will supplement clients' existing authentication systems

by

. Providing active and passive device identification capabilities

. Associating these with customer accounts

. Maintaining device-account associations

. Storing and utilizing account authentication history and results

With this functionality, returning customers can be recognized, novel

devices can be challenged, and fraudsters' devices can be identified and

locked out of customer accounts.

On each login attempt, the system will determine the degree of match

between stored device information previously associated with an account (if

any), and the device currently attempting to log into that account. The

system will then provide a recommendation to the client's authentication

system to allow, challenge, or reject the login attempt.

Responsibilities

. Analysis : Analyzing the Market Competitors like iovation, RSA,

VeriSign, corrilian and Passmark etc.,

. Design :

1. Design the reference implementation of AuthNet Prototype Pages

using ASP.NET aspx.

2. Coded web services for reference implementation of AuthNet

Prototype.

3. Performed Peer-to-Peer code review and suggested modifications

(if required).

4. Version controlling using SVN (Tortoise SVN, and SubVersion).

5. Involved to write Stored procedures in Sql server 2005.

. Unit Testing :

1. Involving writing Unit Test cases using NUnit.

. Others:

2. Configuring the NAnt and Cruise Control Configuration Files.

3. Attending the scrum stand ups meetings daily.

4. Having onsite Scottsdale experience.

Project #6 : PatchDB for FraudNet (Product)

Title : Patchdb

Client : the 41st Parameters, USA

Technical Stack : SQL Server 2005,Oracle 10G, T-Sql Scripts, PL/SQL,

Scripts, XML.

Team Size : 2

Description

The client 41st Parameter is having lot of products one of good products

are PhishingNet and Fraud Net Products. Previously Patchdb is working on

Java (Executable JAR files). While modifying tables and queries depending

on client requirement need to add corresponding code in JAR files and build

the product again.

The main purpose of this Patchdb is we create a lot of T-SQL script files

for creating tables and inserting the data in lookup tables using XML files

and calling all script files in to a main script. By using: R command in

SQL Server 2005. And finally we create a batch file and call the main T-SQL

script file using SQLCMD command in Sql Server 2005. When we run this batch

file it's automatically creates database, tables and view and also insert

the data in lookup tables.

Responsibilities

. Analysis : Analyzing the Existing Application.

. Coding :

1. Creating the script files and calling all script files in main

script file.

2. Written code to call main script file from batch file.

3. Attending the scrum stand ups meetings daily.

. Others:

Project #7 : Rating Engine for Home Condo Renters and Dwelling Fire

Insurance Comparative Rater

Title : Single Entry Multiple Carrier Interface (SEMCI) for Home Condo

Renters and Dwelling Fire Insurance.

Client : Superior Access Insurance Solutions (SAIS), USA.

Reference URL : www.sais.com

Technical Stack : ASP.NET 2.0, C#.NET 2.0, BizTalk Server 2006,

JavaScript, Ajax, HTML,CSS,XML, Web Services,

User Controls and Enterprise Library, Sql

Server 2000 and SSWI (Source Safe Web

Interface) and NUnit, RDLC repots.

Team Size : 6

Description

Superior Access Insurance Solutions (SAIS) is one of the biggest MGA

(Managing General Agency) in USA. This MGA is having a lot of Insurance

Carriers (Companies) in different lines like Commercial Lines, Personal

Lines. This system is coming from Personal Lines.

Home Condo Renters and Dwelling Fire Insurance is one of the biggest

insurance in Personal Lines. This system provides insurance for HOME and

Dwelling Fire. This SEMCI provides information about Applicant, Co-

applicant, Mortgage, Underwriting, Company Questions, Coverage, Additional

Property, Loss Information and Prior Carrier Information. By filling all

the above information we are displaying premiums of different carriers

(Companies) like (Encompass, Hartford, Safeco and etc By selecting one

of the carriers and then displayed Quote page before binding.

In this System we are using Ajax for generating premiums. We are

generating Request XML as per Accord standards and sending that XML as web

service request for different carriers through asynchronous process.

The web service(s) returns response as XML format. Based on that XML

response we are display premiums in premium summary Page similarly we are

doing Company Questions, Prior Carrier Information, Credit History Score

and validating the Zip Codes and County Information. We are Implementing

Business Rules (BR's) based on States and policy types using AJAX. And

finally we are displaying all the information in Quote page. In this Quote

Page we are using User Controls for displaying all Applicant, Co-Applicant,

Mortgage, Underwriting Questions, Coverage, Additional Property and Loss

information for selected carrier (Company) and implementing lot of Business

Rules by using JavaScript and AJAX.

We serialize every class and pass the serialize data through stored

procedure and deserialize that serialize data to corresponding classes.

Responsibilities

. Design : Involved in designing ASP.Net pages

. Coding :

1. Coded Web services to Generate Premiums of different Carriers

(Company).

2. Involved to write Database objects (tables and stored procedures)

to insert, update and delete information in sql Server 2000.

3. Implemented the JavaScript for client Side validations.

4. Implemented the AJAX Control by using Ajax Extensions for Business

Rules.

5. Implemented the Business Rules as per "Acord" standards in BizTalk

Server 2006.

. Unit Testing :

Involved writing Unit Test cases using NUnit.

Project #8 : Rating Engine for Workers Compensation Comparative Rater

Title : Single Entry Multiple Carrier Interface (SEMCI) for Workers

Compensation.

Client : Superior Access Insurance Solutions (SAIS), USA

Reference URL : www.sais.com

Technical Stack : ASP.NET, C#.NET, Sql Server 2000, Java Script, AJAX

using AjaxPro.dll, Web Services, XML, HTML,

CSS, User Controls, Enterprise Library and

SSWI (Source Safe Web Interface).

Team Size : 5

Description

Superior Access Insurance Solutions (SAIS) is one of the biggest MGA

(Managing General Agency) in USA. This MGA is having a lot of Insurance

Carriers (Companies) in different lines like Commercial Lines, Personal

Lines. This system is coming from Commercial Lines.

Workers Compensation is the biggest Commercial Line Insurance. This system

provides handle injured worker claims in a timely and compensate manner.

This rating Engine includes information about the Applicant, Class Code,

Additional Locations, Additional Insured, Class Code Specific Questions,

Underwriting Questions and finally Premium summary for different carriers

(ACE, AIG, Zenith and Safeco) after selecting one of the carriers then we

displaying Quote Page. This Quote page contains all the information before

binding. For quote page we used User Controls to display all filled

information in before pages and also displays the information how the

premium is coming.

In this system we used Ajax and java script for Business Rules and

validations. And used web services for Generate Premiums for different

carriers. CSS and user controls for Quote Page.

For displaying Safeco Premium we are creating Dyna (Dynamic) Quote for

that Safeco site. For this we are used C# win forms.

Responsibilities

. Design : Involved to design Asp.net pages

. Coding :

1. Coded web services to generate premiums for different carriers

(Companies).

2. Coded in JavaScript for client-side validation.

3. Implemented Ajax by using Ajaxpro for Business Rules.

4. Creating Database objects (tables and stored procedures) to insert,

update and delete information in sql Server 2000.

Project #9 : Dyna Quotes (Dynamic Quotes)

Title : Safeco Commercial Auto Dyna Quote,

Safeco Personal Auto Dyna Quote,

Encompass Personal Auto Dyna Quote,

Client : Superior Access Insurance Solutions (SAIS),

USA

Technical Stack : C# windows Application, ASP, ASP.Net, Sql Server,

Web Services and SSWI (Source Safe Web

Interface).

Team Size : 5

Description

Dyna Quote (Dynamic Quotes) is a new technology that has capability of

automatic sign in and dynamically taking proper information and generates a

premium and scrapping that premium from proper site and displaying that

premium in premium summary page and Quote Page.

In this system we used Microsoft Web Browser (axWebBrowser) control,

Regular Expressions. Getting the all values from database (Sql Server)

using web services and fills that information dynamically page by page for

given site.

Responsibilities :

1. Design : Designed ASP and ASP.NET pages for missing questions.

. Coding :

1. Implemented web services to get the values from data base (Sql

Server).

2. Implemented the classes to get the values from web services and fills

that information in pages dynamically.

Project #10

Title : Mortgage Point of Finance (MPOF)

Client : D & B (Douglas & Benjamin), UK

Technical Stack : ASP.NET, C#.NET, Sql Server, Java Script.

Team Size : 6

Description

This system is designed as to have short term, middle term and long term

finance groups and conducting auctions from multiple business channels of D

& B (Branches). Mortgage Point Of Finance (MPOF) deals with recompilation

process of Mortgage business, which involves tracking and maintenance of

application and Bid amounts, Subscription amount, prized and non-prized

details, producer (Agent) Details, finance Refunds and maintains sister

concern Organizations Preparing BRS (Banking Reconciliation Statements).

Responsibilities

. Designed asp.net pages and generic templates to retrieve and update

information on modules like Generation of finance groups, Bid, prized

and non-prized and etc.,

. Coding, testing and implementation of programs using C#.

. Involved to write database objects (stored procedures) using sql

server.

Education

B.A., in Mathematics from S.V.University, Tirupathi.

Master of Computer Applications (M.C.A.,) from Madhya Pradesh Bhoj

University, Bhopal.

Certifications

Microsoft Certified Professional (MCP)

Microsoft Certified Application Developer (MCAD)

Microsoft Certified Solution Developer (MCSD)

Microsoft Certified Professional Developer (MCPD)

Microsoft Certified Technology Specialist (MCTS)

Agile/Scrum Certified Professional(CSM).

Technical Qualifications

Typewriting Higher in English and Telugu from State Board of Technical

Education and Training, Hyderabad.

Contact this candidate