Post Job Free
Sign in

Project Sql Server

Location:
Irving, TX
Salary:
130000
Posted:
July 20, 2017

Contact this candidate

Resume:

VASANTH GOVINDARAJAN

510-***-****

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

Senior Web and Front End Developer

SUMMARY

Creative and highly motivated professional Senior.Net Developer seeking to obtain a challenging position, that utilizes my strong technical skills and experience in the field of software architecting, design and development in .Net Technologies.

Over 12 Years of IT experience with exceptional skills in Analysis, Design and Development and Architecting of high scalable Multi-Tiered Web Applications and Windows application using Microsoft Technologies in Banking, E-Shopping domains for Clients such as NEC Corporation of America, Sendori, Rackspace Hosting, eBay, NBC Universal (GE), GE Commercial Finance, Dena Bank and Union Bank of India.

Expertise in Microsoft.Net technologies C#, ASP.NET, ADO.NET, .NET Framework, WPF- XAML, WCF, MVC Patterns

Solid knowledge and experience with Windows Forms, Web Forms, C#.NET, AJAX, JavaScript, UI design and development, consuming and manipulating data using ADO. NET.

Expertise in requirement analysis, design and development of Client/Server and Internet applications

Proficient in designing and implementing databases layers using ADO.NET, and Entity Framework

Used JIRA for issue tracking

Experience in web technologies with C#.Net

Expertise in Design and Development of User Interfaces using ASP.NET and C#

Basic work experience in NUnit, NAnt and Traceability Matrix

Extensive work in Developing Web forms, Web controls, User controls and Custom Controls in ASP.NET, ASP.NET MVC and Client side programming using JavaScript, JQuery, AngularJS, Bookstrap.

Good working experience in SSRS Reports

Strong experience with Angular JS, Bootstrap, Java Script, JQuery, VB Script, XAML, HTML 5

Good work experience in MS SQL Server 2000/2005/2008/2010/2012

Knowledge in developing stored procedures functions and triggers using T-SQL.

Expertise in Object Oriented Programming (OOP) using C#

Experience working in Restful Web APIs

Experience with Source Control like VSS, TFS, GIT Hub

Extensively used multi-tier architecture pattern

Experienced and fully engaged in application life cycles (SDLC), which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications, and providing production support.

Proven ability to analyze problems, root causes, and develop innovative solutions to business challenges.

Strong interpersonal, team skills and ability to interact with people at various levels and lead a team for successful delivery of the project

Possess excellent verbal and written communication skills.

Exceptional ability to quickly master new Technologies and capable of working in-group as well as independently with a sense of responsibility and ownership

TECHNICAL SKILLS

Technologies

C#,ASP.NET, V# .NET 1.1/2.0/3.5/4.0/4.5,ADO.NET, Windows Applications, Web Application, Web Services, AJAX, CSS, XML and HTML, Infragistics Controls

Special Technologies

Object Oriented Programming, WPF- XAML, WCF, MVC Patterns, Entity Framework

Database

SQL Server 2000/2005/2008/2010/2012, T-SQL, SSRS

Database Connectivity

ADO.Net, ODBC, Entity Framework, Linq to SQL,

Scripting Languages

Java Script, NSIS, Angular.js, Bootstrap.js, JQuery, VB Script, XAML, HTML 5

Development Tools

MS Visual Studio 2003/2005/2008/2010/2012

Source Code Control

VSS, TFS, GIT Hub

Web Servers

Internet Information Services (IIS)

Operating System

Windows NT/2000/XP/Vista

Defect Reporting Tools

Internal Defect Tracking tool

Education

Master’s in Business Administration – Systems (Madras University, Tamilnadu, India)

Bachelor in Engineering – Information Technology (Periyar University, Tamilnadu, India)

Certifications

Microsoft Certified Professional Developer in Designing and Developing Web Applications Using Microsoft .NET Framework 4

Microsoft Certified Professional for ASP.Net with C#

Remarkable Honors

Emerged Second in Smart Minds Event for .Net conducted among all iGATE offices across India

Got ‘Best Performance Award’ for the Academic Performance during the year 2000 and 2004

Got Appreciation Certificate for the project ‘Accel Frontline Global Care’

PROFESSIONAL EXPERIENCE

Caliber Home Loans - Home Loan Post-Closing Quality Control and Audit/Post Funding

Irving, Texas Jan 17 to Till Date

Team Leader & Developer

PROJECT DESCRIPTION:

As a part of this project we will enhance the existing web application to accommodate features that would list and reconcile various loan processing and underwriting stages of a home loan. This requires development of a few HTML pages using Angular JS, WebAPI, ASP.net backend server codes, Database changes, and required Webservices. Additionally, we would develop unit test cases and deployment scripts to automate some testing and deployment. This is particularly important to ensure compliance of any applicable laws and policies of the company.

.

Responsibilities:

I am working as a Team Lead in this project. So, my responsibilities include Requirements analysis, High Level technical design, Database scheme design, Identifying the high-level tasks, Implementing the design using ASP.Net, Angular JS, SQL Server and other technologies such as integrating Swagger tools in application for testing WebAPIs, and WCF Services

Mentoring offshore software developers who are part of this project.

Worked on Command Query Responsibility Segregation(CQRS) and their main software architectural pattern and messaging services platforms like Rabbit MQ and Windows MSMQ used for internal integration of different module

Involved in creating full FrontEnd pages in Angular JS using promises

Used MVC and Web APIs to interact with Angualar page and also used swagger tool to test the Api methods

Used Code First Approach – Entity Framework

Environment: C#.NET 4.0/ 4.5, WCF (SOAP/REST), Web API, XML, JavaScript/ JQuery, Visual Studio 2015, Oracle SQL Developer, SQL Server 2012,Angular JS, Swagger

Bechtel Corporation

Phoenix, AZ July 16 to Dec 16

Team Leader & Developer

PROJECT DESCRIPTION:

The project is under Bechtel Business Services which deals with Operations Reports in which the following works are done such as Gathering Trial Balances (TBs) into the Corporate General Ledger (CGL), Financial adjustments to properly reflect Earned Revenue, Incentives and Gross Margin, Financial adjustments for reclassification of account balances (Balance Sheet and Revenue and Cost) not accurately reflected in TBs submitted, Unconsolidated Joint Association Equity Pickups and Quarterly Reporting and Management reporting of Reserves and Cost of Working Capital and also Receiving invoices, auditing invoices and contracts, creating cost allocations, and making payments to vendors for awarded and overhead projects, working collaboratively with project personnel and other finance departments to support reporting needs, providing exceptional customer service to our internal and external customers alike.

Responsibilities:

Senior Lead Developer in creating WEB API projects and consuming the WEBAPI for updating the requested user information in ARMS Database and Oracle Database based on User Buns

Creating SSRS Reports for the project adding encryption techniques for security purpose.

Creating WCF SOAP/REST services to get User Buns related information

Did automation tool for exchanging data between two Systems (BEAMS and ARMS) consuming Web API

Created Web API projects for getting the expense limits and approvers based on provided UserBuns

Used security mechanism accessing the WEB API like Identity based Authentication, Role based Authentication

Created MVC applications using security based features like Authorize and AllowAnonymous and used references of ASP.NET Identity and Owin Security.

Used Encryption techniques in URLs for accessing SSRS reports

Environment: C#.NET 4.0/ 4.5, WCF (SOAP/REST), Web API, XML, JavaScript/ JQuery, Visual Studio 2015, Oracle SQL Developer, SQL Server 2012

County of Sacramento – DHA, Aug 15 to July 16

Sacramento, CA

Team Leader & Developer

PROJECT DESCRIPTION:

DHA's programs are specifically designed to help low-income families and individuals find workable solutions to daily-living problems as they make the transition from welfare to the workplace. This program includes California Work Opportunity and Responsibility to Kids, Job Programs and General Assistance. The current project is developed for generating Service Management and Reporting Tool. Service Management and Reporting Tool (SMART) were developed to provide support in managing the varied application processing and case maintenance tasks that are distributed to the caseworkers. This tool provides these basic functions like to enable clerical and supervisory staff to easily and concurrently distribute incoming tasks to individual Eligibility Specialists, enable staff to search for a task that has been assigned, enable staff to mark assigned tasks as completed, enable supervisors and management to view statistics on how many tasks have been assigned or completed in a given time frame, report task activity against defined goals (performance reporting), store the data in a format that will allow concurrent access and also avail itself to various reports and meet the needs for data archival and retrieval goals

All of the Medi-CalFresh Service Center staff will use SMART. The rules and processes for using SMART will vary for each of the major user groups

Responsibilities:

Leading a team of around 6 members

Involving in code migration activities and used of MVC architecture from scratch.

Involving in creating stored procedures, functions, views for moving the data from old database to new database based on new architecture.

Using third party Infragistics controls in the project and create page designing, styles and themes based on MVC architecture.

Used Angular JS, JQuery and Bootstraps in the project design

Making use of WCF service oriented architecture design for the new project.

Using SSIS and SSRS tools for managing different aspects of enterprise business intelligence and information processing such as data integration, reporting and analysis

Involved in framing different utility layers along with MVC as core layer

Using Entity Framework for Database connectivity to interact with MVC Model

Using Team Foundation Server for managing the codes, releases and for issue fixing and enhancements

Environment: C#.NET 4.0/ 4.5, WCF(SOAP/REST), Web API, Angular.js, Bootstrap Less, JavaScript/ JQuery, Visual Studio 2008/2010/2012, Entity Framework 6, SQL Server 2008/ 2010/ 2012

NEC Corporation of America Feb 15 to Aug 15

Rancho Cordova, CA

Team Leader & Developer

PROJECT DESCRIPTION:

NEC Corporation of America is a leading Biometric Pioneer, which provides lot of solutions for identifying an individual’s information based on their biometric matches such as Fingerprint, Face Recognition, FastID, IntegraID and MobileID. So an archive system will be available to store all the information securely and retrieve information fast in order to help the law enforcement agencies for conducting criminal case investigation, identifying an individual’s information and keep tracking on the records. So the information of an individual will be stored in database will the help of Nist files which contains details like demographics data, fingerprint images, mugshot images of a person, palm prints for easy accessible.

So as part of module development, the law enforcement agencies will be requesting the individual’s information by provide few details of Nist data. The architecture is designed in such a way to traverse and communicate via interfaces through which request and response takes place. So I use of the information such as Nist Data, Business Headers, Demographics Data and Job Data and create or update the Nist files and few more necessary data through the transactions deriving from another module and send it back as response through FTP server or store the data into an accessible server.

Responsibilities:

Played as team leader and took responsibility for handling a module in the project.

Used to create lot of plugins for different agencies such as Texas DPS, DOJ, LVMPD, SBRV and PPD as per their request

Worked with WCF services and REST Client by providing JobID, SystemID and required action for different plugins

Involved in creating execution flow as an xml for requests, responses and actions for each plugins to execute as per defined in the flow.

Involved in creating FTP server and data upload and download functionalities

Used to create actions and plugin definitions in App.config to make the scheduled requests and responses asynchronously without affecting each other’s job

Involved in creating Field mappings of the nist files as XML data to map the fields corresponding to the types defined in nist files

Create nist files or updating nist files and uploading to FTP Server as per requests by storing the file names in transactions as tracking ids to match with responses.

Created actions for checking the files availability in the FTP Server or accessible server and getting the responses back by mapping the tracking ids with the acknowledgments received from law agencies through other modules.

Designed User Interface using Angular JS

Developed WCF service components in C#, .NET 4.0/4.5, Windows Service

Send the response notifications as success or failure based on the acknowledgments data

Environment: C#.NET 4.0/ 4.5, WCF (SOAP), Angular.js, JavaScript/ JQuery, Visual Studio 2008/2010/2012, Entity Framework, SQL Server 2008/ 2010/ 2012

Employer: Cognizant Technology Solutions Jul 10 – Feb 15

Sendori, Mar 14 – Feb 15

Fremont, CA

Technical Lead Developer

PROJECT DESCRIPTION:

Sendori operates a custom public Domain Name Server (DNS) infrastructure. The app is deployed across seven geo-located facilities in the United States, and distributes traffic to multiple data centers providing some of the fastest un-cached name resolution speeds available

Sendori EULA - "The Sendori application updates your DNS settings to prevent you from navigating to undesired or dangerous websites. Redirects you from Non-Existent Domains (where no domain exists) and from “typo squatting “domains (domains that take advantage of a typographical error to lead you away from your intended website destination) to the web pages where you aimed to navigate, to category relevant web pages where Sendori may have a partnership, or to a search results page giving you additional navigation or search choices”

Responsibilities:

Leaded a team of 6 members and responsible for the life cycle of the entire project

Migrated the project .Net Framework 2.0 to .Net framework 4.0 and have also added some enhancements to the existing application and involved in designing the project.

Worked with users in gathering and analyzing the requirements

Developed WCF Services for creating and consuming business components in ASP.NET

Designing WCF with Service oriented architecture to support Distributed computing where services consumed by end-user.

Implemented JQuery, and Bootstrap in the frontend.

Designed application framework and interaction with database and UI using .NET 4.0 and Angular JS(MVC)

Worked on WCF REST Service to return the JSON/ XML results for the Javascript Call

Hosted 2 types of WCF Services in separate server and called both in project (WCF Service) and JavaScript call (WCF REST service).

Make use of CRUD (PUT, GET, POST, and DELETE) operations in WCF with messaging format.

Designed and developed class library for Domain Entities using Entity Framework

Used threading concept to occur the notification event of desktop application in system tray

Make use of timer threading concept to check the installed services whether it is in start/stop mode and if stopped, it will be forced to make it start.

Developed new application to calculate the Gross Margin using various technologies like WPF on various factors like design, commissions, costs, etc

Implemented the WCF Service and hosted in IIS on server machine and make use of it for existing user interactive.

Used NSIS scripting languages for creating install/uninstall functionalities of Windows installer and also for upgrading the existing app to a new app

Extensively used JavaScript for advertisements

Worked with VSS to manage the code

Worked on Registry entries for creating new registries upon installation the app in user machines

Created technical documentation and help files for end users

Responsible for application support and bugs fixing that were raised during testing

Responsible for the knowledge transfer to coworkers

Worked on Hudson build which is automated build

Environment: C#.NET 4.0, WCF Services, JavaScript/JQuery, Visual Studio 2008/2010/2012, Entity Framework, SQL Server 2008/2010/2012

Rackspace, San Antonio, TX Nov13 – Feb 14

Technical Lead Developer/Team Lead

Project: RAX-SI OpsSupport

Project Description:

RAX Service Innovation (SI) portal is the user interface of all the applications that are involved in monitoring and automation of the processes in rackspace. It is an internal portal and used by Rackers. This helps in setting up monitoring process for the devices. The monitoring sources will generate events mapping the devices and will be sent to the automated system The automated system based on the process rules defined in ARIC will execute the required action. Historically, while this monitoring process was performed manually, with significant increase in the customer base and volumes of device, the monitoring process has been automated to drive cost, timesavings, and accuracy.

Environment: C#.NET 4.0, Windows Applications/Web Applications, JavaScript/JQuery, Visual Studio 2008/2010/2012, SQL Server2008/2010/2012, Git Hub

Responsibilities:

Coordinated with team members and interact with client on business requirements/enhancements.

Lead developer responsible for the mentoring of two (2) other team members.

User to prepare Weekly and Monthly Report about the profit analysis

Took the responsibility of preparing Daily Metric report and involve in analyzing the daily events.

Monitor the events on regular activities and run/rerun to pass through the ARIC rules.

Make use of BMC Tool to check for the event error and rectify it according in which functionality of code the error occurs.

Involved in deployment activities

Periodically monitor all kinds of regular events, long running events, suppressed events.

And if any events goes beyond the limits and more priority will be taken to bypass the event

Attend the automated voice calls from customer regarding the events flow arised and opt it.

eBay, San Jose, CA Jul 10 – Sep 13

Team Leader, Production Support Engineer

Project: eBay UED Tools

eBay User Experience Design(UED) Tools is a one stop repository for all the tools used within UED, UER and extended UED teams. The UED Tools team supports maintenance and enhancements of in-house tools. There are around 10 tools such as UEDBase, Homeroom, Status Engine, Playbook, UER Recruiting, UER Calendar, GRIP, Visits, BCX and COE Tool. This tools are used for maintaining all the internal activities of UED teams such as for scheduling online classroom trainings programs to learn about all things in UED and also for learning new technologies/tools/processes and for uploading and view project/non-project related documents, general group or department information and for achieving project assets such as mockups, specs, wireframes, prototypes, and other documents

Responsibilities:

Coordinated with Clients on business requirements/enhancements

Update the tasks on daily basis to Clients

Took the responsibility of entire project maintenance/enhancements

Monitor the scheduled jobs for projects created on daily basis

Provided scoping/cost estimation for the new enhancements

Involved in deployment activities

Interact with clients on innovative ideas for better productivity

Environment: C#.NET 2.0/3.5, Windows Application, Web Application, Entity Framework, Visual Studio 2008/2010, SQL Server 2005/2008/2010, VSS

Employer: IGate Global Solutions Limited Jan 08 – Jun 10

NBC Universal, GE Aug 09 – Jun 10

Team/Module Leader

Chennai, India

Project: Profitability

Role: Module Leader

PROJECT DESCRIPTION:

Profitability is a Windows WPF application, which caters to the need of the Cable Entertainment business of NBC in analyzing the overall profitability of network schedules. The application gets input from multiple sources of data (including ratings / pricing / demographics) to present reports of Profitability analysis at multiple levels such as show, genre, and day part.

Responsibilities:

Designed User interface (UI) for WPF forms and implemented application logic using C#.NET

Implemented WPF to create attractive and effective User Interface using XAML Document

Extensively involved in Developing Components for Business Layer and Data Layer, implementation in MVC Architecture

Used Grid Views, Form Views, Details View and Object Data Sources extensively

Used Themes and Skins which made the designing uniform

Used Generics extensively in C# and ASP.NET Menu Controls

Created Centralized Session Business Object in C#, which makes creating, and maintaining sessions monitor able

Environment: C#.NET 2.0/3.5, Windows Application, WPF Application with XAML, Visual Studio 2008, SQL Server 2005/2008, ClearCase

NBC Universal, GE Apr 09 – Jul 09

Chennai, India

Project: Affiliate Sales Toolkit (AST)

Project Description: The Affiliate Sales Toolkit (AST), built on the Microsoft .NET platform, tracks Multiple System Operator (MSO) and individual system data including contracts, rates, subscriber counts, contacts, invoices, related documents, and meetings. Users will be able only access the application from within the NBC Unetwork or via a secure RSA Secure ID connection using the ID and password provided to them. The Cable Distribution group at NBC Universal (NBCU) is responsible for developing and maintaining relationships with the cable and satellite providers who carry the broadcast signals for all the analog and digital networks within the NBC Universal family of companies. As a cable programmer, NBCU distributes programming to the consumer via cable and satellite frequencies owned by the cable and satellite operators

Responsibilities:

Involved in report creation activities

Worked on the functionality to find out the subscribers count and the packages used by them

Development of database driven UI navigation

Development of Data Access and business Layer

Coordinating with the business Analysts on system related queries.

Handling the Quality related activities.

Assistance to team members in domain and technical field

Environment: C.Net 2.0, ASP.NET/VB, Windows Forms, Visual Studio 2005/2008, SQL Server 2005/2008, TFS

GE Commercial Finance

Module Leader Jan 09 – Mar 09

Chennai, India

Project: Kazan

Project Description:

The GE Commercial Finance Australia acquired Horizon application from Red Planet software limited. This existing Horizon application is designed to support only Australia specific requirements. It cannot be used across multiple geographies easily. So, Kazan has been developed to support multiple languages, multiple currencies and date formats. The tightly coupled existing Horizon application is broken in to logical components, which enable the application to fit into the framework. This framework also helps to deploy the horizon application across multiple servers

Responsibilities:

Migration of a Leasing website developed in NET 2.0 into a framework developed in .NET3.5 and was responsible for coding the key modules.

Coding for the implementation of the framework specific requirements such as Multi-language support, out proc support etc

Unit testing, System testing of other modules

Environment: .Net 3.5, ASP.NET/C#, AJAX, Visual Studio 2005, SQL Server 2005, TFS

GE Commercial Finance

Module Leader Jan 08 – Dec 09

Chennai, Tamilnadu

Project: Horizon

Project Description: Horizon is an online financial application tool that governs the GE Australia’s Vendor Finance business and leasing platform. Horizon seamlessly interfaces with other existing applications and legacies thereby providing customer with account information, deal tracking and reporting, giving them a full workflow access to the system. It offers various financing options to the customers such as Rental (customers paying for the use of equipment and return it @ the end of term) or Asset Purchase (allowing customers to take ownership of the equipment @ the end of term) or Secured Loan (similar to Asset Purchase) or Financing Lease (effective use of capital for the customers resulting in reduced impact on annual budgets)

Responsibilities:

Group lead and responsible for developing a key module

Design, Analysis and Creation of LLDs for key functionalities

Involved in Integration Testing and System Testing.

As part of UAT Support team, responsible for analysis of UAT issues, bug fixing.

As a Module Lead, split the work to team members upon their functionality development.

Create defects in defect tracking system and assign the tasks on priority basis to team members

Environment: .Net 2.0, ASP.NET/C#, AJAX, Visual Studio 2005, SQL Server 2005, TFS

Employer: Accel Frontline Limited Apr 06 – Jan 08

Dena Bank Mar 07 – Jan 08

Team Leader

Chennai, India

Project: Dena Bank – Bi 360

Project Description:

BI360 contains stand-alone executable at the ALPM branches and Web based solution at CBS branches. In addition, it provides appropriate interface to acquire data from the Dena Bank’s existing software systems like CBS and ALPM as flat files. Additional data, which are the gap data entries required for MIS reporting, are captured by BI360 at the branch level. These data are then aggregated at various levels for reporting. The stand-alone executable at ALPM branches will be a single user application at the branches and would help the branches in adding data to the server at the HO on a day today basis. HO Curriculum Vitae will host its own website for CBS branches

Responsibilities:

Designed both Standalone and Web based application for ALPM and CBS Branches respectively

Involved in Unit & Integration Testing

Responsible for Deployment & Production Moves of the applications

Involved in code review activities for the codes developed by team members

Mentor and assign the tasks to team members and schedule status call on bi-weekly basis.

Environment: .Net 2.0, ASP.NET/C#, Visual Studio 2005, SQL Server 2005, VSS

Union Bank of India Apr 06 – Feb 07

Team Leader

Chennai, India

Project: Union Bank of India

Project description:

The current version of Best-B for UBI will be available in three flavors. A web based reporting solution at RO, FGMO and HO levels, a stand-alone executable at the ALPM branches and Web based solution at CBS branches. Best - B provides appropriate interface to acquire data from the UBI's existing software systems like CBS and ALPM as flat files. Additional data required to perform MIS reporting are captured by BEST-B at the branch level. These data are then aggregated at various levels for reporting. The stand-alone executable at ALPM branches will be a single user application at the branches and would help the branches in adding data to the server at the HO on a day today basis. HO will host its own website for CBS branches. This website would provide an interface to the users by using tool bars / menus to access various reports at various departments.

Responsibilities:

Designed both Standalone and Web based application for ALPM and CBS Branches respectively

Involved in Unit & Integration Testing

Responsible for Deployment & Production Moves of the applications

Involved in code review activities for the codes developed by team members

Mentor and assign the tasks to team members and schedule status call on bi-weekly basis.

Travelled to multiple client locations and implemented the applications and test on live.

Environment: .Net 1.0, ASP.NET/C#/VB.Net, Visual Studio 2005, SQL Server 2005, Sybase Anywhere, VSS

Employer: Accel Transmatic Limited Oct 05 – Mar 06

Accel Frontline Global Care

Team Leader& Developer

Chennai, India

Project: Accel Frontline Global Care

Project Description:

In this project, we make use of Insurance Claim Forms, which will be in scanned tiff file format, and the details of the Forms to be entered in Form Template, which is designed by us for storing the records in database, and thereby make use of the records to claim insurance for a particular person. The data saved will be finally converted into a standard Format and it will be send back to Client. Here we can view the daily, weekly and monthly reports of the data entry users how many records they have keyed.

Responsibilities:

Developed the entire project on single handed as a fresher.

Responsible for deployment activities, unit testing, integration testing.

Involved in deployment activities of the projects in Users machine and test the functionalities.

Periodically visit the user’s location and track for issues if any raised by the users.

Environment: Net 1.0, ASP.NET/C#/VB.Net, Visual Studio 2005, SQL Server 2005, Sybase Anywhere, VSS



Contact this candidate