Home   |   Sitemap |   About us |   Resources |   Testimonials
 
 
Employer's Register   |   Employer's Priority Membership   |   Freelancer's Register   |   Freelancer's Priority Membership
Home | Profile View
 
Profile Id: 76894    20-May-2010
 
 
Title:   MSSQL Performance Tuner
Name:   KRITHIGA (Technical Analyst Isoft)
Location:   Mandeveli - chennai -
VIEW COMPLETE CONTACT DETAILS
 
 
Agents  
  • Job consultant
  • Sourcing Agent
 
 

Dear Patron ,

I prefer type of work - Part-Time Basis. Expecting remuneration in terms of Hourly Basis of appx. Rs.Negotiable Select.

My Skill - Specialist in tuning stored procedures ,complicated queries.

My prefered location for assignment - Anywhere, Agra, Chennai

Jobs handled -

Overall 6.7 years of experience working with databases like SQL Server 7.0/2000/2005/2008

Performance Tuning in SQL SERVER 2005,2008

Experienced as a Techno functional in Materials Management System .

Experienced in working with tools like Ramco Virtual works and EApplication (ERP).

Thorough working knowledge and Active Participation in AVIATION projects and Healthcare domain.

Experience in the areas of Programming, Testing, Implementation and Customer Support.

.


Technical Analyst,Isoft R&D Ltd, Chennai. (Healthcare)

Team : Centre of Excellence

Product: Lorenzo Clinicals 3.5

Period December 2008 to till date.

Team Size 20

Role Performance Analyst

Description

Lorenzo Clinicals provides comprehensive facilities to manage all the clinical aspects of

Hospital and nonhospital care,It is a clinical information tool that can automate care processes,support clinical decisionmaking and improve the quality of care.

.Accomplishments:

Review the Technical Design and identify the potential performance bottlenecks at an earlier stage and suggest alternate solution.

Review the data model and SQL stored procedure during development stage and suggest on performance enhancement.

Learn new features of SQL Server 2008 and incorporate them into the product for better performance.

Ensure that Lorenzo Clinicals 3.0 product can handle 500 concurrent users with a sample database scaled to 300 GB. This involves Query optimization, Server settings tweaking, File striping across disks.

Procedures taking over 30 seconds to complete have been brought down to 2 3 seconds scale; by employing various tuning methodologies.

Monitor SQL server related counters during Load Runner Run and optimize server performance.

Prepare Best Practices guidelines based on the experiences gained in Performance Engineering and publish in portal for the benefit of developers.

Prepare Proof of Concept for new features and recommend the areas in the product where it can be deployed.



System Analyst, Ramco Systems Ltd, Chennai.

Project: Ramco Aviation Solution Support

Client Pinnacle Airlines,USA

Period August 2007 to till date.

Team Size 6

Designation Team Leader

Description

Ramco Aviation Solution is a Complete ERP Business Package for Aviation Business. Pinnacle Airlines. is using our solution for Material management for their procurement and inventory activities. Pinnacle is an air ambulance service provider with 95 aircrafts. Ramco Aviation solution tracks the goods receipt, material request and stock management activities for their aircrafts.

Accomplishments:

Provided Functional Training in Material Management for entry Level engineers.

Helped the team members in achieving the SLA to achieve.

Provided Technical support during Training/User Acceptance Testing.

Involved in tuning the code for better optimization with QA Load Runner tool.

Code Writing in SQL SERVER 2005 and Test Case preparation for Product validation Group.

Resource planning, allocation of work for the next 6 months in business process wise.

Target fixing for the team members.

Analyst Programmer, Ramco Systems Ltd, Chennai.

Project: Quick Technical Log

Client Safe Air, New Zealand

Period September 2006 to July 2007

Team Size 100

Designation Team Member

Description

Quick Technical Log is a log for recording the Technical Log with Discrepancy ,Component Replacement ,Work Information and Material Request .The Material Request helps in recording the part required for the service of aircraft ,and on generate material request ,an issue of material in fresh status is created.Shortclose MR is also available. The entire UI is designed in tree view of Ramco2.0 model.

Accomplishments:

Interacting with Functionality people to understand the requirements

Preparing Logical Design Diagram and Detailed Design Diagram.

Involved in the development of Traffic violation, Hire and Rental Agreement, Service Level Agreement, Trip sheet, Asset Allocation, Asset Invoice Components

Unit Testing, Functional testing and Bug Fixing

Presenting to Higher Management of the new release of the product.

Environment:

Windows NT, SQL Server 2000, Ramco Virtual Works, Visual Basic 6.0

Systems Executive TVS

Project: Cross Selling

Period July 9 2003 to August 18 th 2006

Team Size 10

Designation Team Member

Description :

Cross selling is giving up loans for the top customers who have successfully completed their previous loans. These are privileged customers who are grouped as AAA, a +, A.

Accomplishments:

Interacting with Functionality people to understand the requirements.

Preparing Logical Design Diagram and Detailed Design Diagram

Involved in the development of Front end.

Designing reports as per the requirements criteria

Code Writing in SQL SERVER 7.0,Visual Basic 6.0

Unit Testing, Functional Testing and Bug Fixing.

Environment:

Visual Basic 6.0, SQL Server 7.0

Project: Materials Management System

Description

Involved in Scenario testing for various Purchase and Inventory Sytems.Writing Test Cases for Product Validation Group.

Accomplishments:

Interacting with Functionality people to understand the requirements

Preparing Logical Design Diagram and Detailed Design Diagram.

Developed Screens in various Inventory needs.

Unit Testing, Functional testing and Bug Fixing

Helped in Data Migration to SAP Materials Management.

Environment:

Windows NT, SQL Server 2000, Visual Basic 6.0

Project: Material Management System

Organization Chennai Petroleum Corporation, Chennai

Period December 2002 to February 2003

Team Size 2

Designation Project Trainee

Description:

The Enterprise Resource Planning (ERP) based Material Based Management System helps to

keep track of Inventory System. It consists of Four Modules

Planning

Purchase

Stores

Accomplishments:

Interacting with User to understand the requirements

Responsible for Developing Reports using Ramco Report Writer

Creating New Screen Requirements using EDK Feature.

Code Writing in SQL SERVER 2000.

Unit Testing, Functional Testing and Bug Fixing.

Environment:

Windows NT, SQL Server 2000, Ramco Report Writer 3.0, Rlaunch


.