Expert In Query Performance Tuning

Published Date: 02 Nov 2017

Vignesh Badri

Experience Summary

Vignesh Badri has been in the Information Technology Industry for around 7 years and 4 Months. He has been involved in design, development and leading projects in ERP, Data warehousing and Business Intelligence.

Experience in leading project teams with multiple technologies.

Involved in RFP’s, project planning and resource task allocation activities.

Experience in handling projects with Agile.

Involved in all phases of a project during his tenure that includes Requirements Gathering, Design, Development, Implementation and Acceptance Testing for end-to-end IT solution offerings.

Experience in software development using SQL Server 2008 R2, MSBI [SSAS/SSRS/SSIS] and COGNOS.

Expert in Query Performance tuning.

Versatile in working with SQL Server Management Studio, Profiler, SQL server Analysis Services (SSAS), SQL server Integration Services (SSIS) & SQL Server Reporting Services(SSRS).

Exposure to T-SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.

Expert in creating complex Stored Procedures, User Defined Functions and effective Triggers to facilitate efficient data manipulation and data integrity.

Extensively worked on developing reports using SSRS.

Experience in designing logical and physical data models using ERWIN.

Hands on experience in generating Drill down and Drill through reports with Drop down menu option in SSRS

Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS).

Microsoft Certification for SQL Server 2008 Database Development with 940/1000 score

Education and Certifications

Title of the Degree with Branch

College/University

Year of Passing

PG Diploma in Management (PGDIM)

IGNOU University, Delhi.

2009.

Diploma in Management (DIM)

IGNOU University, Delhi.

2006.

Bachelor of Engineering (ECE)

PSNA CET/Anna University

2005.

Technical Skills

Operating Systems

Windows Vista, Windows 7, Windows 2003, Windows XP Professional

Databases

SQL Server 2000, SQL Server 2005, SQL Server 2008, COGNOS

Languages

Visual Basic 6.0

ETL tools

SQL Server Integration Services 2005

Reporting Tools

SQL Server Reporting Services 2005

Contact Details

Mobile No. +91-8939945465 Vnet : 464759

Relevant Project Experience

PROJECT DETAILS 1

PROJECT NAME

ONE TOUCH

Industry

IME

Client

LeXISNEXIS

Duration

DEC 2010 TO MAY 2012

Role

SENIOR SOFTWARE ENGINEER

Project Specific Skills

SQL SERVER REPORTING SERVICES 2005/2008R2 (SSRS), SQL SERVER 2005 (CI & CS collations) and COGNOS BI Reports

Location

COGNIZANT, CHENNAI

DESCRIPTION OF THE PROJECT

Redwood Analytics is designed specifically for law Firms and offers comprehensive, sophisticated software, with full analytic and reporting capabilities. The Redwood BI core is an extensive Data Warehouse providing best-practice content derived from time and billing, general ledger, payroll, and other Firm applications. Analysis may be performed on specific key performance indicators within a multi-dimensional cube environment.

Analyzed and developed SSRS reports for the Product Client Analysis. Redwood Analytics client analysis reporting solution provide business intelligent (BI) reports to legal industry. Legal firm needs customized reports to help business development opportunities and focus on pain areas. BI Reporting solution needs to analyze historic data and trends.

Roles and Responsibilities

Leading project team of size 3 members with multiple technologies.

Proactively developed reports with the capabilities of SSRS.

C2.0 is used for project management.

Requirement Analysis, Design Development of Reports for Client analysis.

Implemented Reporting Solution using SQL Server Reporting Service (SSRS).

Reports designed with historical performance data comparison, Cross-Sell analysis and Trend analysis.

Reports helps to analyze measures like Fees collected, Fees billed, Amount worked, Total hours etc.

Automatic deployment script for SSRS reports.

Implemented a single instance reporting solution to support the multiple application versions (LNCA 5.2 and LNCA 5.3).

Relevant Project Experience

PROJECT DETAILS 2

PROJECT NAME

ONE TOUCH

Industry

Aviation

Client

Ramco Systems limited

Duration

Jun 2006 to Dec 2010

Role

System Analyst

Project Specific Skills

SQL SERVER 2005/2008, Ramco Virtual Works (RVW)

Location

Ramco SYSTEMS, CHENNAI

DESCRIPTION OF THE PROJECT

RVW (Ramco Virtual Works) is a tool to design an Enterprise Web based Applications. The scope of the product is to provide Aviation Solution with all functionalities related to maintenances, Logistics.

Development of new features in procurement and inventory, based on the requirements. Creation of web pages with Ramco virtual works (RVW) and back end coding with SQL Server which involves creation of various objects, monitoring performance and tuning.

Roles and Responsibilities

Aviation Product development

Team size 7 (Senior Developer Role).

Resource planning, guiding, review is done for 3 member team.

Techno-functional for Logistics domain

Conversion of Requirement in to design with design impact analysis.

Involved in Requirement analysis, Design, Construction, Performance tuning, Testing, Defect Fixing, Reviews and Customer support.

Test cases preparation is done.

Unit testing and Integration testing were done.

Performance tuning and functional changes based on performance.

Configuration management activities- Configuration Management In charge.

Agile methodology and pair programming concepts were adopted.

Involved in Performance tuning at MTC lab, Bangalore.

Relevant Project Experience

PROJECT DETAILS 3

PROJECT NAME

ONE TOUCH

Industry

Aviation

Client

Ramco Systems limited

Duration

Nov 2005 to Jun 2006

Role

Analyst Programmer

Project Specific Skills

SQL SERVER 2000/2005, Ramco Virtual Works (RVW)

Location

Ramco SYSTEMS, CHENNAI

DESCRIPTION OF THE PROJECT

Porting and Migration from Oracle 9i to SQL 2000 done for entire application. Development and Enhancements done for Base Rel-5. Worked in Logistics and Maintenance components. Existing Defects were resolved.

Roles and Responsibilities

Team size 5 (Developer Role).

Involved in Requirement impact Analysis, Design, Construction and Defect Fixing.

Test cases preparation is done.

Unit testing and Integration testing were done.

Personal Details:

Associate ID:

263629

Associate Name:

Vignesh Badri

Designation:

Associate - Projects

Vertical:

Communications

Years of Exp:

7 Years and 4 Months

Skill Set:

SQL Server Integration Services (SSIS), SQL Server Reporting Server (SSRS), MS SQL Server 2005/2008, COGNOS