.Net Developer Sql Server Customer Service Project

Ravi Kumar

Mobile: 402-***-**** E-Mail:

*******.***@*****.***

Professional Summary

Over 8+ Years of experience as a Software Engineer on Microsoft platform through all phases

of the product life cycle using Microsoft Technologies: C#.Net, ASP.Net, ADO.Net, SQL

Server, Share Point, WCF, WWF, WPF and BizTalk Server.

Thorough understanding of Software Development Lifecycle (SDLC) models, including

requirements specifications, design specifications, development, implementation, and support

Good knowledge and understanding of WCF (Windows Communication Foundation), Web

Services, WWF, WPF, XAML, AJAX, LINQ, SQL Server 2005, Biz Talk

Working knowledge of C#, VB and ASP.NET 1.1/2.0/3.0/3.5 using Visual Studio

2008/2005.

Knowledge on Share Point 2007 and developing components as web parts in Share Point

2007.

Strong experience on MVC with Razor view model

Developing User Controls and Custom Controls.

Hands on experience in Payment File Processing using CSV, XML, DTA, ACH, EDI etc

Creation and maintenance of Data Base using TFS Source Control and also creating the Data

Transformation Services and Jobs using SSIS and Informatica Power Center 9x.

Expertise in Service Oriented Architecture (SOA), SOAP over HTTP.

Experience in developing Multi-tier Enterprise Applications using Microsoft Application

blocks and mapping the relational models to object models using Object Data Sources and

Typed Data Sets

Possess sophisticated skills in Web programming using HTML, DHTML, JavaScript,

XML, XSLT, and CSS.

Strong experience in using Master Pages, CSS and Themes in ASP.NET 3.0

Strong experience with UML, Class Diagrams and Use Cases

Applied knowledge in design patterns like singleton, Factory and Abstract factory

Good understanding of RDBMS concepts, Normalization, SQL Server 2005/2008/2012,

Comfortable with using T-SQL, stored procedures, SSIS, Reporting Services (SSRS) 2005,

Crystal Reports7.0

Exceptional ability to adapt to latest technologies, perseverant, innovative and organized

Ability to multi-task, highly result oriented, and possess strong soft skills to be effective in a

team.

Self-motivated and able to work independently and collaborates productively as team

member.

Technical Skills

MS Technologies : ASP.NET (1.1/2.0/3.0/3.5), C#.NET, VB.Net, VB, BizTalk Server,

Share point, Silver light

Web Development : HTML, DHTML, CSS, AJAX, JavaScript, XML, XSL, XSLT,

Schema

Middleware : WPF, WCF, XML, MVC, Web Services, SOA, WSDL

Databases/Access Technologies: SQL Server 2000/2005, ADO.NET, MS Access, SSIS

Tools : Crystal Reports, SSRS 2005, Application Blocks, SQL Reports

Web Browsers : Internet Explorer, Netscape

Web Server : IIS 6.0 and above

Operating System : Windows NT 2008/2000/98/95, DOS

Code Version Tools : SOS, TFS,Anthill and Sub version

Professional Experience

Client: Global Pay (Travelex), Omaha, NE Dec 2009 – Till

Date

Role: Sr. Net Developer

Project: Remittance Engine

Description:

This project deals mainly with supporting the Remittances for Global Pay. Global gives the location to

the files uploaded by customers through a web service. RE will pick up the file, converts into XML,

and applies XSLT and XSD to validate, and process the files. Global pay wants the remittances for

particular payments through web services; RE will send the remittances as a response.

Responsibilities:

Developed .NET Components and enhancing.

Communication for the requirements, changes & issues via Email

Web services creation and hosted in IIS as well as in windows.

Worked on the database interaction through WCF

Integration of services with Legacy systems

Implemented Bulk Insert, Bulk update, Transactions, Stored procedures when updating data.

Involved in creating design documents.

Developed stored procedures and other back end objects.

Implemented globalisation (Resource files) to complete Remittance Engine.

Tracking the source code version with TFS

Synchronize the remittance data of Service with legacy system payments

Integrated third party tools like Hurricane and FAX for delivering the Remittance

Environment: Visual Studio 2008 with .NET framework 3.5, C#, WCF, SQL Server 2008

Client: Hitachi, Dallas, TX July 2009 – Dec

2009

Role: Sr. Net Developer

Project: Recruitment Module

Description:

A Recruitment Module developed to cater to the needs of Project Managers and Leads to recruit

resources for their projects. The resources could be from either within the organization or new hires

based on the availability in open market and skill set.

Responsibilities:

Team coordination, discussion regarding the changes/task

Integrated the Payment module DAL, BAL using LINK

Consumed the SOAP Web Service for integrating accounting package.

Implemented reports using SSRS (SQL Server Reporting Service)

Developed .NET Components and enhanced the Portal front end.

Implemented globalization (Resource files) to complete portal.

Designed some screens using Silver light.

Created Databases using TFS Source Control.

Maintain the normalization rules across the database.

Worked on the database interaction through WCF Services using LINQ.

Environment: Visual Studio 2008 with .NET framework 3.5, Silver light, WCF, LINQ, SQL Server,

SSIS

Client: Ruesch International, DC September 2007- June

2009

Role: Sr. Net Developer

Project: Ruesch Payee Management

This project envisaged the development of two important software modules in e-Payment solutions,

Program Administration and Enrolments. Key goals are to automate and simplify the entire

enrollment process and manage campaign programs in a most efficient manner. Though it will inherit

some of features of PPM, e-Pay designed to be far more superior to PPM in the following areas

Better Organization and display of data and highly user friendly interface and

navigation.

Centralized access – one point entry for many functional areas.

Manage enrolments from home page.

Summary of enrolments in home page.

Access Campaign information from home page.

All kinds of readily available statistical information about payees.

Various reports during enrolment – no reporting facility available in PPM.

Easy access to drill down details.

More meaningful and intuitive display of information in grids.

Enrolment approval in just one step. Assignment of PayeeID and ProfileIds are in one

step.

Huge process change during enrolment.

Almost all-manual processes will be removed during campaign pre-launch and post

launch time.

Role:

Analyse client requirements and provide project estimations.

Used SQL Stored procedure for customer pagination, functions, done performance tuning by

optimizing SQL quires

Performing Unit Testing and System Testing.

Developed stored procedures and other back end objects.

Implemented Bulk Insert, Bulk update, Transactions, Stored procedures when updating data.

Developed .NET Components and enhancing the Portal front end.

Implemented globalisation (Resource files) to complete portal.

Configured Sql ports in BizTalk sever to process the payments and remittances

Generate Bank files using XSLTs with automation of BizTalk sever and deliver to Bank

Integrated third party tools like ROBO FTP for connectivity with Banks for delivering the

Bank files

Integrated third party tools to validate the payers and payees information before processing

the payments

Integrated third parts tools live VAN to deliver the remittance securely

Use MS CRM 3.0 to build customer relationship management applications

Configured legacy systems to access thru MS CRM

Worked for Customizing Entities in CRM, Adding attributes, Designing List view and Detail

View, Linking the views in Menus using Microsoft Dynamic CRM

Designed customized pages to know the payment details and registered payees under

customer level.

Designed customized pages to setup a customer with customized settings

Synchronize the CRM data with legacy systems

Environment: ASP.NET, VB.NET, CSS, SQL SERVER, Web services, SQL Reports, ADO.Net,

Ajax, BizTalk Server, Java Script

Client: ICFAI, Hyderabad, India February 2007-

September 2007

Role: .Net Developer

Project: PRM

Description:

This project involved the undertaking of a PRM (Prospect Resource Management) an end to end

Marketing tool. It is used for managing intensive marketing activities to businesses in need of

productivity software. The system tracks all sales and marketing activities to ensure that up-to-date

information is readily available for all prospects.

Features implemented:

Provides authenticated, and role wise authorization to resources. Enter and maintain prospect records

with full details including names and addresses, web address, number of employees, market sector,

number of locations, etc. together with a history of sales and marketing activities relating to that

prospect. Easy call plan making and adjustment with flexible User Interface. Track follow-up

activities requiring action. Generate reports in chart and grid format on all marketing activities for a

particular prospect including details of correspondence sent and received and call reports. Reporting

tool is incorporated with the system which eases new report generation and customizing existing one .

Responsibilities:

Analyse client requirements and provide project estimations.

Involved in creating design documents.

Involved in Analysis, Coding, and testing of the application

Developed custom controls and User controls

Implemented AJAX Style coding

Data base creation and maintenance, applied normalization across the data base

Involved in creating tables, functions, writing queries, and Stored Procedures

Environment: ASP.Net 2.0, C#, Java Script, CSS, IIS, SQL Server

Client: ICFAI, Hyderabad, India August 2006 –

February 2007

Role: .Net Developer

Project: iHR

Description:

IHR for HARTEX has been developed to serve the business needs of the company. This application

takes care of all the Human Resource Management activities of the company. Various components and

user controls are used in the application. AJAX. (Asynchronous JavaScript and XML http posting) has

been used in the application for richer User interface. This application can be divided into eight

modules. They are Administration, Employees, Payroll Master, Loan Process, Payroll Pre-process,

Selection Process, Human Resources and Tax Deduction.

Responsibilities:

Analyse client requirements and provide project estimations.

Involved in creating design documents.

Involved in Analysis and Coding

Writing Stored Procedures and functions

Developing User Controls and Custom Controls.

Database creation.

Maintain the normalization across the database.

Implemented AJAX Style Coding

Environment: ASP.NET, VB.NET, CSS, SQL SERVER

Title: Media Management and Online Ordering January 2006 – July

2006

Role: .Net Developer

Description:

Online Ordering Media Management is a service and set of productivity tools designed for advertising

agencies, brand advertisers and movie studios for the purpose of television and radio spot distribution,

management and proof of delivery. Online Ordering Media Management provides an Online ordering

of digital spots by the different users under different agencies. These orders are sent to the CSR

(Customer Service Representative) for approval. CSR is the final approver for each order. This project

addresses the following main Modules:

1. Admin Module, 2.Media Library, 3.Online Ordering, 4.Proof of Delivery (POD), 5.Tracking. I am

involved in Admin Module, which consists of creating Agencies, CSR Management, Spot

Management and Folder Management. The Users within the respective agencies pass their Spot

Orders through these Agencies. After the CSR had approved the order, the spots transferred to

different destinations by using the web services.

Responsibilities:

Discussion with web team and the client for the requirement changes/issues of business logic

Designed the project modules including data base design, UI design, Data Access Layer and

Business Layer.

Implemented the encryption libraries like AES, DES and MD5 security.

Implemented the windows services for data synchronization with legacy systems

Using Web Services

Environment: ASP.Net, C#, Java Script, CSS, IIS, SQL Server

Client: ICFAI University May 2005 – December 2005

Role: .Net Developer

Title: Call Management System (CMS)

Description:

The Project involves the management of Inbound and Outbound Call-Center activities. The project

facilitates the Candidate and the Management in providing Customer Care, Support and Interaction

activities.

Responsibilities:

Actively involved in Requirements gathering and End User Interaction.

Developed Interface through extensive use of VB .Net and Report Management System.

Involved in creating design documents.

Involved in generating Requisitions and Billing reports

Coding and Implementation

Writing Stored Procedures

Environment: VB.Net, Crystal Reports 9.0 ASP. Net, C#, Java Script, IIS, SQL Server, DOS

Client: ICFAI, Hyderabad, India May 2004 – April 2005

Position: Application Developer

Project: Process Automation of ICFAI

Description:

ICFAI provides many distance-learning programs like CFA, CTM, CPA, CIB, CRIM etc and

has an active student base of approximately 50,000 students. The numbers of enrolments are

increasing rapidly thereby increasing the volume of student records handled. The present

system, developed entirely in FoxPro is unable to handle the huge volume of work and

provide timely services to the students. This led to the need of a system having advanced

functionality, centralized database, web-enabled services and reduction in cost, time and

paper work. The various phase of project include System Automation, Web based Interface

development and Data migration from FoxPro to New system.

Responsibilities:

Analyse client requirements and provide project estimations.

Involved in creating design documents.

Involved in Development

Developed Views for Reports

Writing Stored Procedures

Database creation

Maintain the normalization across the database.

Environment: ASP.Net 2.0, C#, Java Script, CSS, IIS, SQL Server2000

Education

M. Sc (IS) from Andhra University, India in 2004.

BCA from Andhra University, India in 2002

Contact this candidate