Arun Pairhar

Delhi, Delhi, India

Yearly Stats: $0 Earned |

The guru of


Arun Pairhar

I can offer best services in the following fields

1. Services/JQuery/Entity Framework.
2. ODATA and REST Services.
3. Proposing indices/partitions or any other DB structure for better query performance
4. Used taleric Control.
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.

ASP.Net/MVC/WCF Services:
• I have delivered multiple project in and C#.
• I have around 2 year Experince in MVC, used JQuery and Entity Framework Extensively.
• Good hand on experience to in WCF with different kind of binding.
• Good hand on experience to optimize and implement security in WCF.
• REST with ODATA services.

• Proficiency in Sql Server 2000 / 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 inSql 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.

• Strategic Planning for preparation/development of SSIS Packages.
• Experience in Data Transformation Services (DTS) for Data migration/Integration projects.
• Experience in SSIS for developing ETL processes for large-scale data warehouses.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Extensively worked with SSIS tool suite

Work Terms

Work on both hourly and fixed price assignments.