Sql Server Sales

BASKER S

+91-967******* *.********@*****.***

Professional Summary

2+ years of experience in technical front in MS-SQL Server 2005/2008/2012, Structured Query Language Excellence in SQL, development & debugging, Crystal Reports XI.

Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.

Managed SQL Server Agent Jobs. Created alerts for successful or unsuccessful completion of scheduled jobs.

Experience writing complex SQL Queries and Procedures.

Managed indexes, statistics and optimized queries by using execution plan for tuning the database.

Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.

Generated Reports using Crystal and Jasper Reports.

Writing, updating and supporting reports using TSQL. Professional Strength

Strong in Microsoft SQL Server 2008 R2/2012/2014

Jasper Reports, Crystal Reports

ERP -EDK, Ramco Virtual Works

Knowledge in HTML.

Professional Experience (T-SQL)

Working as a Programmer in Ramco Systems Ltd, Chennai, from August 2017 to till date.

Worked as a Project Trainee in Ramco Systems Ltd, Chennai from June 2016 to July 2017. Academic Credentials

Bachelor of Technology (Information Technology) – Karpagam College of Engineering College

(Autonomous), Coimbatore in 2016 Secured 77.7%.

S.S.R.M Higher Secondary School – XII in 2012 Secured 87.6%.

S.S.R.M Higher Secondary School – X in 2010 Secured 93.2%. Career Features

Ramco Systems Limited – Chennai, Tamil Nadu August 2017 – Till Date As a Programmer was involved in the following:

Product Name – RODE (Ramco On Demand ERP on Cloud Computing)

Designed and Maintaining the MS SQL Stored Procedures, User defined Functions and Views for RAMCO Partners.

Providing the Development (Jasper reporting tool, EDK and PDK) support for RAMCO Partners thought India.

On-Call Support for Partner’s live defects and Clarification on the same.

Monitoring the Partner developed UI’s Performance.

Business Data output analysis for User Interface development and testing for the same.

Code review and data flow monitoring in partner objects.

More than 10 Partners development Support for their development reports and EDK screens.

Data Analysis and the query sequence for customer Business scenario.

Providing and maintain the User level of access for Partner’s Login in Ramco Product. Project Name – MJB WOODS Inc., Irving, USA

Domain : Sales

Clients : MJB Woods Inc.,

Team Size : 4

Environment : RVW (ERP) & Microsoft SQL Server

Description:

Writing SQL Query for functional based, developing Reports using Crystal Reports and also scheduling the report as per the customer requirement.

Developing the ERP online Screens based on customer requirements using Ramco Virtual Works.

Providing the Support for Live defects and Clarification on the same.

Scheduling and managing jobs on SQL Agent.

Product Name – RODE (Ramco On Demand ERP on Cloud Computing) June 2016 – July 2017 As a Trainee was involved in the following

Designed and Maintaining the MS SQL Stored Procedures and Views.

Developing the ERP Online Reports in different modules like COBI, PO, and CDI etc., using jasper type of reporting tool provided my Ramco.

Experience in Analysis, Design and Implementation of Business Intelligence Solutions with Microsoft SQL server 2008/R2 and 2005 with various business domains ERP implementations.

Experience in Design multiple data reports provided by RDW such as Tabular Report, Sub Report, Report Groupings and Parameterized reports.

UPECA AEROTECH, MALAYSIA

Domain : Shipping

Clients : UPECA AEROTECH

Team Size : 2

Environment : EDK (ERP) & Microsoft SQL Server

Description :

This system used to create the invoice for the purchase items. In this screen the user will maintain the shipping details for the particular purchase order. Based on the customer requirements, I had created the screen for them to maintain the shipping details.

Personal Dossier

Father’s Name : Subramani A

Permanent Address : Bharathi Nagar, Panankattur(PO), Omalur (TK), Salem (DT),

Tamil Nadu, PIN Code: 636455.

Languages Known : English, Tamil

Preferred Location : Flexible

Declaration

I hereby declare that the above written particulars are true to the best of my knowledge and assure you that I will work in the right earnest and fulfill the expectations of my superiors. Place: Chennai

Date:

Yours Truly

Contact this candidate