Post Job Free

Resume

Sign in

Sql Server Project

Location:
Hialeah, FL
Salary:
110000
Posted:
October 21, 2015

Contact this candidate

Resume:

Rajeev Kumar

Summary of Experience

Over ** years of experience in complete Software Development Life Cycle (SDLC) with Analysis,

Design, Development, Testing, Implementation and Maintenance of various web and windows

applications.

Expertise in designing and developing complex user interfaces (GUI) using HTML5, CSS3, Bootstrap

CSS, JavaScript, AngularJS, KnockoutJS, backbone.js, Require.js, JQUERY, Asp.Net MVC 4/3 and

Asp.net web forms.

Good exposure in Client Server Architecture, N-Tier Architecture, estimation and Service Oriented

Architecture (SOA).

Conversant with architecture design using MVC, MVP, Singleton, Factory, Abstract Factory, Facade

and observer and dependency injection

Hands on experience in Agile and scrum methodology.

Hands on experience in C#, VB. Net, Asp.net, Asp.net MVC 4.0/3.0, VB,, Win Forms

Strong coding skills in developing WCF Services AND Web API for Web application.

Hands On experience in Team Foundation Server (TFS), JIRA and NUNIT.

Used SSRS for SQL Reporting. Exposure of SSIS for creating packages.

Expert knowledge in oracle 11g, MSSQL 2000/2005,2008 R2, 2012 data Modeling, Logical & Physical

data base design, Data Migration, Performance Tuning, Query optimization.

Good experience in onsite/offshore delivery model

Capable of leading and working with a team to achieve desired results

Experience in designing and developing solutions based on client’s business requirements

Comprehensive Knowledge in Health Care, Insurance, Mortgage, Finance and Logistic.

Worked well in both Team and Individual Environment.

Education:

Master of Computer application

Technical Skills:

TECHNOLOGY

TOOL

.NET Technologies

.NET Framework 4.5/4.0/3.5/3.0/2.0/1.1, C#, VB.Net, ASP.Net, Asp.Net MVC 3.0/4.0, Win Forms and ADO.NET

Web Services

WCF, ASP.NET Web API, Web Services, Window Services

Programming Languages

C#, VB.NET, Visual Basic 6.0 and C

Tools

TFS, VSS, SVN, Perforce, Source Vault, SQL Developer, TOAD, Telerik, Infragistics, Serena tracking tool, JIRA, CSS3, Click Once, Unity container, FXCOP

ORM

Entity framework 4/5, LINQ, Lambda expression, LINQ to SQL, NHibernate

Scripting Languages/Mark up

JavaScript, JQUERY, Angular.js, Backbone.js, Require.js, XSLT, Bootstrap, CSS3, SCSS, SASS, HTML/HTML5, DHTML, XML, ATLAS, Ajax control toolkit

Web Servers

Internet Information Server 6.0/7.0

Databases

MS SQL Server 2012/2008/2005/2000, Oracle 11g, SQLITE, T-SQL, MS-Access, DTS Packages, SSRS, Crystal Reports and exposure of SSIS

Testing Framework

.Net Unit test Project, NUNIT, NMOCK, Rhino Mock, PEX and MOLE

Professional Experience

Client: Health Port Technologies, Alpharetta, GA September 2013 – Present

Project: AudaPro

Role: Senior .NET Developer

AudaPro is Health port’s comprehensive audit/appeal management tool. AudaPro provides the process and technology to streamline audit requests/appeals management and tracking. RACs, MACs, CERTs and ZPICs review contractors and providers are using this application. It mitigates the stress related to managing the many audits that negatively affect health care provider’s revenue.

AudaPro gives users the ability to automate, manage and track the entire audit process. Facilities gain transiency into dollars in risk of audit take-backs and protect revenue. When integrated with Healthport release information, it'll speed audit related requests delivery and eliminate technical denials.

Responsibilities:

Responsible for requirement analysis, design and development of the application.

Responsible for the estimation of the new requirements and develop overall implementation plan.

Provides new ideas/suggestion to stakeholders and direct clients along with business analyst in Lehman term.

Provides expertise to identify and translate system requirements into software design documentation

Lead development of formalized solution methodologies.

Responsible for maintaining repository for deliverables, methodologies, and business development documents

Fully responsible for the delivery of the sprint stories on time with quality.

Developed a web application in Angular.js for the account manager to review and approved the medical records. This application will reduce 60% cost and manual effort for the organization.

Solving technical problem for team members

Provide quality assurance of delivery by doing code reviews and unit testing.

Working on the agile and scrum methodology

Environment: C#,.Net4.0, VS2012, ASP.Net, JQUERY, Angular.js, Telerik RAD controls, Ajax, WebApi, JSON, XML,JIRA, AGILE and scrum, TFS, Window service, Bootstrap, JavaScript and oracle 11g

Client: Cbeyond, Atlanta, GA February 2013 – August 2013

Project: Partner Access

Role: Senior .NET Developer

Cbeyond (NASDAQ: CBEY) is a managed services provider that delivers integrated packages of voice, mobile and broadband services to small businesses. Use Cbeyond Partner Access to pull sales collateral, marketing materials, reports, and updated product information at any time. Cbeyond Partner Access gives you all the tools you need to successfully sell Cbeyond and take your own business to the next level.

Responsibilities:

Understand the old application, requirements and convince client for a new application with latest technologies with performance and accessibility to a wide range of devices like mobile, tab, laptop etc...

Responsible to identify best-fit architectural; develop design of application; provide regular support/guidance to project teams on complex coding, issue resolution and execution

Providing the technical design document to team to reduce rework and increase productivity.

Implemented a powerful exception handing module to quickly solve the production issues.

Heavily involved in the integration with a third party SIEBEL services to fetch data for reports.

Created an expressive document repository so that new team members can easily understand the application.

Responsible for the deliverables with quality by doing the code reviews and unit testing.

Creating the use case diagram using Visio.

Successfully implement agile and scrum methodology in the project.

Environment: Asp.net MVC 4.0, C#, Java Scripts, JQUERY, Ajax, CSS3, HTML5, WebApi, JSON, XML, entity framework 5.0, LINQ, Lambda expression, JIRA, Agile methodology, TFS, SIEBEL Services, SQL server 2008

Client: Asurion, Atlanta, GA September 2012 – January 2013

Project: iWeb

Role: Senior .NET Developer

Asurion is providing insurance for the cell phone users. Mobile Protection provides cell phone users with rapid replacement coverage, device location and data management tools, and ongoing live tech support to care for your privacy, productivity, socializing and even entertainment. This system provides quick information about the device to the customer care execute so that he can provide the assistance to the customers. System is implemented for multiple clients like AT&T, Verizon, and Sprint etc. System will provide the standard solution for the entire client and replace the multiple code bases for different clients.

Responsibilities:

Prepared a single code base UI generation solution for the client who was maintaining multiple code bases for different clients of the application.

Responsible for the requirements analysis, design and development of the application.

Responsible for the estimation of the new requirements and develop overall implementation plan.

It was a complex project to provide a single code base for all client so present lots of proof of concept to provide to the client.

Worked on different client side frameworks like knockout.JS, backbone.JS and angular.JS and asp.NetMvc4.

Build and maintain repository for deliverables, methodologies, and business development documents

Provide quality assurance for services within the solution area.

Used bootstrap to provide a responsive UI which targets wide range of devices.

Used Agile with Scrum methodology

Environment: Asp.Net MVC 4.0, C#, Razor view, Angular.js, backbone.js, Knockout.js, require.js, handlebars.js, TFS, JQUERY, JavaScript, Bootstrap, SQL Server 2008, SQLITE

Client: DSIR (Dept of Scientific and industrial research) January 2012 – June 2012

Project: HR Portal

Role: Technical Lead

This is an automated web application which facilitates the DSIR employees to register with their profiles. Administrator can update the service book of the all employees. Employees can apply different types of reimbursements and claims by using Employee Self Service module. On the other hand, administrators can perform approval activities assigned to them. The system provides facilities of Requirements, Activity Configuration, PMS, Retirement and many more HR processes. The system also includes generation of various kinds of reports required for building electronic workplaces.

Responsibilities:

Responsible for the designing of ESS(Employee self service module)

Responsible for designing and development of the new modules, worked on all layers.

Implemented a custom WORKFLOW to make the business process easy and maintainable.

Solving the technical problems of team members.

Actively involved in new R&D work as and when required

Responsible for the quality code by doing Code Reviews and Unit Testing.

Prepared Technical document for stories, Use Cases and Test Cases

Environment: Asp.net MVC 4.0, Razor, C#, JQUERY, entity framework 4, Dependency Injection, CSS3, HTML5, custom WORKFLOW (WWF), TFS, LINQ, Lambda expression, SQL Server 2008

Client: Kongsberg, UK June 2011 – December 2011

Project: Port Management Information system

Role: Technical Lead

The primary objective of the system is to provide operators, vessel agents and other stake holders with means to Book, plan, manage and have situational awareness of vessel visits inside Gulf of Khambhat. PMIS interact with third party system (VOC) for the vessel’s visit data. Port operator can plan movement on the port for different services like loading, unloading, cargo etc. System also provides invoicing facility for the vessel that has been taken services from the port. A vessel cannot leave the port until a NO Dues Certificate has not been generated.

Responsibilities:

Responsible for the requirement gathering and client communication.

Handling the core module of the project like visit planning, Finance, contact management.

Responsible for the designing and development of the new modules.

Solving the technical problems of team members.

Handling the database part of application like Stored Procedures, UDF, Indexing and Triggers.

Maintain quality of code by doing Code Reviews and Unit Testing.

Actively involved in new R&D work as and when required.

Prepared Technical document for each story, Use Cases and Test Cases

Prepare Generate various reports using SSRS.

Environment: Asp.Net MVC 3.0, Razor, C#, LINQ to SQL, TFS, JQUERY, NUNIT, JavaScript, CSS3, SQL Server 2008, SQL server reporting services (SSRS)

Client: Mitchell Inc., San Diego, CA July 2009 – May 2011

Project: Decision Point

Role: Technical Lead

Decision Point is a window application designed exclusively for evaluating medical bills in the Property and Casualty insurance industry. Decision Point streamlines the claims review and medical billing process by eliminating time-consuming and error-prone manual reviews. Decision Point validates and analyzes claims based on established and consistent billing practices. In medical bill processing, there are complex coding systems, rules, relational mappings, billing practices, and bill considerations that sometimes vary from state to state. Decision Point verifies that these codes and rules are used appropriately and provides information to help the claim adjuster make informed payment decisions.

Responsibilities:

Solving the technical issues to help out the team members.

Requirement gathering and client communication on daily basis.

Maintain quality of code by doing Code Reviews and Unit Testing.

Prepare Use Cases and Test Cases

Provide inputs in technical architecture.

Prepared Technical document for future development reference

Using the VS 2010 unit testing framework for the development code.

Environment: .Net 3.5/4.0, C# 3.5, Win Farms, Agile methodology, VS 2010, XML, LINQ, WCF, TFS, CVS, NUNIT, PEX and moles, VB.NET, SQL Server 2005

Client: Morgan Stanley, New York, NY March 2008 – June 2009

Project: Asset Maintenance platform

Role: Consultant

The overarching goal of the Asset Maintenance platform is to provide a one stop, extensible solution for the Real Estate organization (management, Asset Manager, and Investment Controllers) for the maintenance of asset data to minimize multiple data entry and expose standardized asset data for reporting by asset managers, investment controllers and management. The investment controllers were maintaining a series of spreadsheets with information about the assets owned by Morgan Stanley Real Estate Funds.

Responsibilities:

Automate the process of collecting asset information from the joint venture partners.

This system provides a reporting facility for all the global performance group management.

Provide functionality for snapshot and Undo snapshot of investment on quarter basis.

Provide feature in the tool which will copy data from one quarter to other quarter.

Responsible for the requirement gathering and client communication.

Preparing technical Specification document for the requirements.

Responsible for the designing and development of the application.

Used FXCOP for code reviews and Unit Testing.

Environment: .Net 2.0, C#, Asp.Net, WCF, nHibernate, JQUERY, AJAX, Java Script, nUnit, PEX and moles, MVP, AJAX, SQL Server 2005, Visual Source Safe, FXCOP, infragistic

Client: Bentech, UK October 2007 – February 2008

Project: eFirstOrigin

Role: Developer

BancTec is a leading provider of payment processing, document and content processing and IT services. E-First Origin is a multi-tier architecture application that provides loan origination system and reporting services for the end users. Users of the ‘eFirstOrigin’ are divided into Business Centers that denotes physical locations of users. Another addition to the system has added the concept of ‘Brand’ to the broker structure, products, documents, users, and workflow.

Responsibilities:

Closely involved in designing and development of the application and Worked on all layers.

Implement themes for different groups. Each group has a different look of the website.

Implement an income and payment verification feature for underwriter.

Implement a configurable system to validate the checklist of evidence.

Written Utilities for reusability.

Was responsible for whole database part of this module.

Exercising Code Reviews and Unit Testing.

Environment: ASP.NET, C#.Net 3.5, VSS 6.0, SSRS reporting, Rhino Mock, SQL Server 2005, Visual Studio 2008 and Windows XP

Client: First Magnus Financial Corporation, USA April 2007 – September 2007

Project: Realtor portal

Role: .Net Developer

The goal of this project (Realtor portal) is to create a portal that allows realtors to access details for loans where they are assigned as the listing or selling agent. The realtor information will need to be managed through an administrator section within Loan Tracker (existing application), which allows Loan Officers to create Real Estate Companies and Realtor records. All changes to Realtor personal information through the portal will need to reflect in Loan Tracker as well. Utilizing resources such as training document/videos and submit corporate contact request.

Responsibilities:

Responsible for updating day to day changes in Technical Specification document.

Providing facility for realtors to see t

Making POC for the Event and Group modules.

In writing of Stored Procedures, UDFs & Views

In writing Web Services and implementing security into that.

Environment: .Net 2.0, Asp.Net, Web Services, JavaScript, AJAX, Ajax control toolkit, VB.Net, SQL Server 2005

Client: JP Morgan Bank March 2006 – March 2007

Project: Lead 360, JP Morgan Bank

Role: .Net Developer

Application can effectively manage leads, provide greater incentives for top performing employees and also increases the conversion rate of leads to actual sales. A potential borrower goes to the lending tree website, fills out an online application, and then submits it. FMFC receives this information and generate three offers while at the same time notifies the potential borrower that their information is getting processed, registers the sales lead and offers with Leads360 and send back the offers to Lending Tree. Once Leads360 receives the lead and offers, they will assign a rep to sales lead and then notify FMFC which rep was assigned to the lead

JP Morgan is in the process of extending a line of credit to First Magnus Financial in order to pay off the warehouse line that is used to fund our mortgage loans. FMFC will be charged for full use of this credit line regardless of the amount drawn against it. To utilize the line of credit FMFC require the ability to identify the loans eligible for transfer to JP Morgan for payment. System will provide a projected balance of the credit line at any time, and provide reporting to JP Morgan on request.

Responsibilities:

Responsible for updating day to day changes in Technical Specification document.

Coding, Debugging and preparation of Unit Test Cases.

Handing database activities like stored procedures, UDFs & Views

Implement reports in SSRS

Environment: .Net 1.1, Asp.Net, Web Services, AJAX, VB.Net, XML, SSRS, SQL Server 2000

Client: NSIC New Delhi, INDIA June 2005 – February 2006

Project: Enterprise management system

Role: .Net Developer

Enterprise management system is a distributive web application which will work on 38 branch and Head office. The main motive of developing this application to provide a system which will be able to give synchronized data of different offices and make fast communication between different offices and Head office. Each office will have its own local database and there will be a centralized database system. The system will be responsible to synchronized data at head office on defined scheduled interval. Application has human resources, payroll, and finance and loan management system.

Responsibilities:

Involved in developing business logic of Payroll and Human Resource Module

In Coding, Debugging and preparation of Unit Test Cases.

In writing of Stored Procedures, UDFs & Views

Environment: .Net 1.1, Asp.Net, C#, Web Services, SQL Server 2000

Project: POS (Point of Sale) New Delhi, INDIA November 2003 – May 2005

Project: POS (Point of Sale)

Role: .Net Developer

POS is an enterprise window application, which will work on 10 branches and Head office and have a centralized database system. The Solution includes management of Products, Stock, Sale, Sale return, Purchase, Purchase Return, Supplier, Customer, Craft man, Cashier and billing. There are four types of products like Diamonds, Models (Ring, Necklace), Cluster and solid metals. It makes purchase order and MRN and stock is automatically updated. It efficiently managing purchase, purchase return, issue row material, sale and sale return related transactions branch wise. It makes the purchase order and sales invoice on different branches. It provides the search facility to search a product on different branches. It provides admin and user level security.

Other Projects

Window based Inset ERP, Window based automation of School Management System, Asset management system and products price comparison web site.

Responsibilities:

Involved in developing business logic of Client module.

Communication with customer for the requirement on frequently basis.

In Coding, Debugging and preparation of Unit Test Cases, Stored Procedures, UDFs & View

Environment: .Net 1.1, Asp.Net, C#, VB.NET, Visual Basic 6.0, Window Application, Asp, Web Services, SQL Server 2000, MS-Access



Contact this candidate