Location - Chennai
Involved in tuning SQL queries by using quest control tools and manual by EXPLAIN PLAN.
Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
Involved in developing UNIX shell scripts for Loading Database Tables.
Loading data from flat files into database tables using SQL
Preparing documentation for requirements, design, install and Unit testing and System Integration.
Created Materialized Views and partitioning tables for performance reasons.
Preparing documentation for requirements, design, install and Unit testing.
Monitoring day-to-day Process for different Data Loads and resolving Issues.
Resolving the issues on priority basis.
Responsible in Implementation, Maintenance and Development.
Responsible in writing RULE logic for the Leave Management.
Responsible in Designing the screens with the RVW (Ramco virtual Works 2.0) and scripting in SQL server 2008.
Implementation of Production screens and Reports. Involved in Requirement gathering, providing solution, designing and complex report development.
Expertise in Designing screens and developing (coding) part.
Have worked in Model Explorer, SQL Profiler R2, Model Reconstruction Migration Tool, Confiq generator Developer Console and Reports.
Designing the customer required screen using Ramco Virtual Works Tool.
Configure the SQL Job scheduler to fetch the daily based employee changes records.
We are analysing the performance structure to maintain the employee record for each appraisal period.