Banner Image

Skills

  • Ssis
  • ASP.NET
  • C#
  • Data Migration
  • Data Processing
  • Data Warehouse
  • Database Development
  • Microsoft SQL Server
  • Performance Tuning
  • Reports
  • SQL
  • SQL Server Management Studio (SSMS)
  • SSRS
  • Stored Procedures

Services

  • 7 years of experience in SQL SERVER / MS

    $12/hr Starting at $25 Ongoing

    Dedicated Resource

    I can offer best services in the following fields improved performance and availability. • Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables. • Experience...

    ASP.NETC#Data MigrationData ProcessingData Warehouse

About

7 years of experience in SQL SERVER / MSBI (SSIS & SSRS), Sql programming, Asp.Net & C#.

I can offer best services in the following fields
1. Writing complex SQL Query/Functions.
2. SQL Query/Stored Proc/Database instance tuning.
3. Proposing indices/partitions or any other DB structure for better query performance.
4. Data migration among different databases.
5. High volume/high performance data processing with stored procedures.
6. SSIS Package Design & Deployment.
7. SSRS Reports Design & Deployment.
8. Performance Tuning in SSIS packages.
9. Database administration and support in MS SQL Server environments
10. Asp.Net & C#.
SQL SERVER:
• Proficiency in Sql Server 2005/2008/2012 & MSBI (SSIS & SSRS).
• Experience in Database Development in SQL Server and ORACLE.
• Having good knowledge on writing complex queries, stored procedures, functions, view & triggers in Sql Server.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for

improved performance and availability.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
• Experience in Performance Tuning in Sql Server Queries.