Post Job Free

Resume

Sign in

Sql Server Service

Location:
Nashville, TN
Posted:
February 28, 2016

Contact this candidate

Resume:

CHANDRA CHAGALETI

615-***-**** actp9i@r.postjobfree.com

Profile

Having around 10 years of IT experience which Microsoft technologies and Client/Server applications in background, healthcare and auto insurance industries.

Experienced in doing production support along with new development in a balanced approach.

Excellent communication and inter-personal skills.

Excellent working knowledge on MVC 3.0/4.0/5.0.

Strong working knowledge of Entity Frame Work, LINQ.

8 years working experience on C#, SQL Server.

Experience in creating Windows Services, MSMQ.

Design and development of web services using ASMX, WCF, REST Services, WEB API technologies.

Designed and developed SOA web applications using all ASP.NET frameworks.

Highly experienced in SQL Server Database interaction for web applications.

Worked extensively with Jqgrid/MVCJQGRID.

Worked extensively with scripting languages like JQuery, JavaScript

Used JENKINS for Continuous Integration.

Experience with TDD environment.

Working knowledge of TFS, Visual Source Safe, Subversion.

Lead small team of mid-level developers and able to deliver product in time.

Education

Bachelor of Technology in Electronics and communications, India.

Masters in Computer Science, University of Memphis, Memphis, TN.

Skills

C#, VB.NET, Java Script, JQuery, LINQ, Entity Framework,ASP.NET MVC, WEB API, WCF, RESTFUL API, AJAX, JQGRID, JENKINS, MSBUILD, NUNIT, TDD, SQL Server, SVN, TFS, Bootstrap, HTML Helpers

Professional Experience

Lead Developer/Senior Software Engineer - HIRERIGHT INC, NASHVILLE, TN JAN ‘12 to CURRENT

HireRight is leading provider in background checks and employment verification reports in United States. Along with background HireRight also does MVR reports and number of other verifications. HireRight also does background tests in ASIA, EUROPE.

Projects

ECOC (Electronic Chain of custody)

This is an automated process for completing drug testing from start to finish electronically. Involves integration with various third party vendors like LabCorp, Quest. Developed the application using ASP.NET WebAPI technology. Also developed another MVC 4.0 web application to track the status of order.

Account Setup Wizard

This Wizard lets clients to register on the HireRight system which will enable them to submit employment verification orders or drug tests. It provides a detailed wizard experience in setting up their account. This project was done using ASP.NET MVC 4.0 frame work with SQL server for database interactions.

SHERBERT

This is an internal tool that serves multiple purposes such as order tracking, report updates, billing status, emailing customers, search collection sites and so on. Users can also add/edit/delete collection sites, add new test types and so on. They can report results of drug tests, resubmit an order for lab, send notifications to customers. This is a web application developed in ASP.NET 4.0 frame work. Used Jqgrid extensively across all pages. Also used MAPQUEST to display driving distance to applicant’s address from collection site.WCF service is used for MAPQUEST and LABCORP service integration. SQL Server is used for data storage and retrieval.

Tasks Performed:

Gathering requirements by sitting with business users.

Involved in all phases (design, development, deployment) of the SDLC.

Worked in aggressive AGILE-SCRUM environment.

Mentored and worked along with small team of developers to achieve short sprint goals.

Used TDD approach and worked on automated unit testing along working with QA team.

Worked JQGRID/MVCJQGRID across all projects and used AJAX callas to load data.

Used JQUERY extensively across all projects.

Worked with design patterns.

Created lot of WCF, RESTFUL services for third party integration.

Worked on all MVC frameworks extensively and used BOOTSTRAP.

Created Custom Validations in MVC applications.

Used Responsive Design techniques in MVC applications.

Excellent knowledge of MVC framework and all features available in MVC framework.

Created RESTFUL service using WEB API frame and worked with TOKEN authentication.

Worked extensively on SQL SERVER Database design as per requirements.

Used LINQ extensively across data access layer.

Worked extensively on SQL SERVER in writing stored procedures, triggers etc.

Experienced in fine tuning SQL server procedures for faster performance.

Subversion is used as source control for Automated deployments using JENKINS.

Used multithreading when it’s needed in some applications. Done using TASK.

Used JENKINS tool to automate tests.

Worked on large projects involving health care and background verification data.

Worked on integration with lot of third party vendors like MapQuest, LabCorp, and Quest.

Worked on supporting legacy applications and solving production issues.

Technologies:

C#.Net, MVC4.0,WebAPI,WCF,JQGRID,JavaScript,SQLServer2008,SVN,ASP.NET, JENKINS, BOOTSTRAP.

Senior Programmer Analyst/Software Developer-DIRECT GENERAL CORP Nashville, TN DEC ‘05 to JAN ‘12

Direct General is a major insurance company that offers Auto insurance product across 20 states in USA. Along with Auto Insurance offers additional products such as Life insurance, Roadside assistance and so on. Customers will be able to buy insurance either online or in stores.

Projects

DirectGeneral.com

This is a web application which offers customer’s services such as buy a policy, pay bill, view coverages and so on. Developed using MVP pattern and in ASP.NET 3.5. SQL server is used as backend database and AS400 system is used as permanent storage for policy data. Consists of two modules one for online customers and another for stores. Involves integration with third party software for tasks such as MVR report, credit card management, document storage.

DAP (Day End Automated Processor)

This is a windows service that runs at scheduled time that converts all the policy information from all channels into a flat file and transmits it for processing on AS400 system. Used FILEHELPER objects to create the file and created a batch service which schedules the time for each channel.SQL server is used for retrieval of data and AS400 programs are used for transmitting data.

POLICY MANAGEMENT:

Once the policy sold this application is used by internal users to modify /access policy information. Used to create monthly billing, modify any errors on policy, send notifications to customers etc. This is a web application developed in ASP.NET 2.0 and later refactored into ASP.NET 3.5 frame work. Both AS400 and SQL server were used for data retrieval.

Tasks Performed:

Worked on converting legacy platforms to ASP.NET web applications.

Balanced workload effectively between new development and production support.

Involved in all phases (design, development, deployment) of the project.

Created Web services using WCF for tasks such as address validation, credit card processing etc.

Used Crystal reports, ITextSharp methods for generating reports.

Interacted with AS400 RPG Series to get MVR report, rates for policy.

Created Unit testing modules using Visual studio test projects.

Expert in creating various SQL server objects like Database, Table, Indexes, indexed Views, Stored Procedures, Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

Created lot of windows service which will pick up specified number of sales offices transactions.

Used FILEHELPERS to create the text file with required lay out.

Implemented Email service to notify the erroneous transactions and successful completion of automated processing of policies.

Interacted with various third parties such as MVR, Credit Card Authorization, Document Management etc. using ASMX, WCF services.

Created a web application for internal users to reprint/recreate policy documents.

Technologies:

C#.net, VB.NET, VB6, SQL Server 2008, TFS, ASMX, WCF, ASP.NET, AS400.



Contact this candidate