Post Job Free

Resume

Sign in

Customer Service Sql Server

Location:
Chennai, TN, India
Posted:
October 07, 2015

Contact this candidate

Resume:

DEVARAJAN GURUSAMY

SUMMARY

Over *.** years of IT experience in all phases of Software Development including Analysis, Design, Study, Programming, Unit Testing and Implementation.

Including 4 years of experience of Production Support in Healthcare Industry.

Experienced in Product Support, Customer Service and resolving the customer issues

Experienced in developing web applications with Microsoft .NET framework developing Web / Client – Server applications using C#, ASP.NET, WCF, Web Services, JavaScript and ADO.NET.

Experienced in SiteMinder Web-Agents. Integrated with a standard Web server, SiteMinder Agents enable SiteMinder to manage access to Web applications and content according to predefined security policies.

Good experience in writing back end business logic using Stored Procedures, Functions, and Triggers using T-SQL for SQL Server.

Proven abilities in establishing effective task priorities, work independently and as integral part of a team.

Flexible enough to adapt new technologies.

Ability to learn quickly in work environment, excellent communication skills, productive interpersonal skills, problem solving skills.

TECHNICAL SKILLS

Technologies

C#.Net, VB.Net, ASP.Net, Web Services, WCF, LINQ, XML, AJAX, Java Script, HTML, CSS, CA Siteminder R12

Markup Languages

XML, XSL, HTML, CSS

RDBMS

MS SQL Server 2005/2008

Platforms

Windows 98/XP/7, Windows Server 2003,2008

Third Party Controls

Infragistics Web Client, Adx Studio XRM, MS Dynamic CRM

Source Safe Tools

VSS,Visual SVN,Tortoise Git, StarTeam, Stash STAR

IT Service Management Tool

ServiceNow, HP QMS, Jira

EDUCATION

Master of Science (Computer Science), SNR Sons College, Bharathiar University, Coimbatore (2007)

Bachelor of Science (Computer Science), Sree Amman Arts & Science College, Bharathiar University, Coimbatore (2005).

PROFESSIONAL EXPERIENCE

December 2014 – Present, AstraZeneca Pharma, Chennai.

Role: Solutions Support Engineer

Previous Work Experience:

November 2011 – December 2014, Hexaware Technologies, Chennai.

Role: System Analyst (Production Support)

August 2009 – November 2011, CG-VAK Software & Exports Ltd, Coimbatore

Role: Software Engineer (Development)

September 2007 – August 2009, GFS Softtech Private Ltd, Coimbatore

Role: Software Engineer (Development)

PROFESSIONAL ACHIEVEMENTS

During October 2012, I had got opportunity to travel to the Client corporate office at Collegeville, United States for migration of Maintenance Renewal Process which I had transitioned successfully.

During December 2012 to August 2013, I had travelled to Mexico to set up a new support team for supporting the Global customers from nearshore.

I have been successful in training the new team members on the process.

Have gained confidence in interacting with internal and external customers through my past experience.

Have improved my Business communication skills.

Have gained exposure to Team handling and customer query handling skills.

Have received good feedback from internal and external customers’ for my quality work.

PROJECT EXPERIENCE

Project Name : US Production Support

Role : Senior Team Member

Environment : .NET, C#, SQL Server, IIS

Duration : December 2011 to December 2014

Description: Customer Portal is a centralized launch point for IMS Applications, Product Support, Customer Service, News and information. It provides single sign on for all hosted application on customer portal with around 600 plus products. There are approximately 25000 unique users across all regions and clients. Customer portal consist of four major applications like Application Launch Pad, Product Support, Customer Service and Marketing/Client communication hub. IMS Portal identifies users by their email address. These users can be register through self-registration section or Service teams located in US and UK. The portal utilizes single sign-on technology so that a user enters credentials (UserId and password) one time and has access to all appropriate hosted applications without additional logins.

In ICP, Access to products is assigned by the service team through our CRM tool, Onyx. Quick Links offer immediate access to up to 10 favorites and recently accessed or assigned products. Product Support information is available for all products hosted on the IMS Customer Portal. Information such as product updates, user instructions, FAQs, etc. can be found in this area. Users can set favorite support items and have them displayed in Quick Links on the home page of the portal. Ask IMS allows users to submit online queries and receive feedback online. User collaboration is available to share information among colleagues. Help guides and contact info prevalent throughout the site

Regional teams offer 24x7 supports for all hosted applications.

Role and Responsibilities:

Being SPOC between on shore and off shore team.

Involved in client interaction

Involved in documentation preparation

Monitoring the overnight Production jobs

Doing RCA(Root Cause Analysis) and finding resolution to fix the issue

Leading the team and providing the required knowledge transfer

Involved in Design, Analysis and Implementation

Making sure that tickets get resolved within OLA and SLA

Involved in Maintenance and Enhancement of Web and windows based applications.

Project Name : CRM University Portal

Role : Team Member

Environment : C#. NET, ASP.NET 4.0, WCF, LINQ, Microsoft Dynamics CRM, AdxstudioXRM, Java Script, MS SQL Server 2008, IIS 7.0, Windows 7

Duration : September 2010 to September 2011.

Description: The Client wanted to develop an application for the University, which would allow University Users to across Departments to Manage Service Requests, Prospective Student Management, Content Management, maintain Knowledge Base etc. Administrators/Department Heads can manage the Contents of their Departments. Prospective Students can apply for a Course from this Portal and the application will be routed to various users based on the Work Flow.

Role and Responsibilities:

Responsible for application code development and version control using Visual SourceSafe.

Developed back end stored procedure, function and table design in SQL server.

Integral member of the maintenance team for the website.

Involved in design, coding, testing and Integration.

Project Name : Integral Accounting Enterprise

Role : Team Member

Environment : Asp.Net 3.5, VB.Net, Web services, Visual SourceSafe 6.0, XML, SQL Server 2005, HTML,IIS 5.0, Windows2000, JavaScript.

Duration : January 2010 – September 2011

Description: It is a complete financial accounting system. Importantly it is a multi-tiered design and separates the Interface (Presentation Layer) from the Business Logic and the Database Layer, so the system can be easily adapted to various environments or scaled across multiple systems. Especially Business logic layer has been implemented as a web service. It is a multi-lingual System and a separate translation mechanism has been written. It mainly features the following accounting functionality. General ledger, inventory control, AR/AP, ordering, purchasing, payroll, help desk, shopping cart, reports; Integral accounting ASPX report Engine has been implemented and XSLT used for Excel Reporting.

Role and responsibilities:

Responsible for application code and version control using Visual SourceSafe.

Integral member of the maintenance team for the website.

Customized this software several times in different scenarios based on the end user’s requirement.

Mainly added some functionality other than original system’s functionality like Database Utility, which takes a backup of whole database in XML file and can be restored again.

Was actively involved in design, development, and integration and testing of all the primary modules

Project Name : LIMS (Loan Information System)

Role : Team Member

Environment : C#. NET, ASP.NET 3.5, ADO.NET, Web Services, XML, Java Script, MS SQL Server 2005, HTML, IIS 6.0, Windows XP

Duration : August 2009 – June 2010.

Tools Used : Infragistics Web Client, VSS.

Description: This project is developed for leading IT Company in Florida, USA. The main theme of the application is managing loan information for automobiles. There was already an application running across for managing loans developed by this IT company which was created using VB4. Our team worked on migrating this from Windows application to Web Application using ASP.NET. This is an n-tier application composed of Presentation Layer, Database Layer, Entities Layer, Business Logic and Service Layer. We used Infragistics to replicate the same functionality which was available in windows application. Our task was also to create a web application working like a windows application. We used JQuery where Infragistics cannot go beyond.

Roles and Responsibilities:

Understanding the client requirements by studying functional document.

Responsible for application code and version control using Visual SourceSafe.

Involved in design, coding, testing and Integration.

Project Name : ZoomApply Debtpro

Role : Team Member

Environment : ASP.NET 2.0, ADO.NET with SQL Server 2005 and IIS on Windows XP

Duration : September 2007 – August 2009

Description: This application which solves the need of the Financial Providers Concern such as Debt Management, Debt Settlement and Loan Modifications, etc. It is a multi-user Application with Authorization privileges such as Super Admin, Admin, Processor, Executives, Manager and Sales, with their Hierarchy. Customer Support Executive makes an application for the customer through Telephone or other communication media. Import Lead from an Excel file to the system. Process the Application and Send the Contract and E-Signature the Contract. Admin can manage the Clients and their Payments and its related Reports.

Role and responsibilities:

Involved in coding, unit testing and deployment.

Responsible for application code and version control using Visual SourceSafe.

Mainly involved in developing managed code part, not an unmanaged code part.

Done report generation using Data Reports built in with Visual Studio 2005

PERSONAL PROFILE:

Date of Birth : 07th June 1985

Marital Status: Married

Passport No : J5821070

Visa Validity : US B1 & B2 valid till September 2022

Email-Id : acrzq4@r.postjobfree.com

Mobile : +91-904-***-****



Contact this candidate