Aitzaz Ashraf

acyxk9@r.postjobfree.com

201-***-****

Professional Summary

More than 5 years of experience in, design, and development of various educational and commercial objects oriented application

Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.

Strong ability in upgrading from MS Server 2008 to MS Server 2014 in various technical areas.

DB Design & implementing SQL Server 2008/2012/2014 Stored Procedures, Triggers, Indexes, Views, Functions

Database Optimization and Performance Tuning using SQL Server 2008/20012 Profiler & Analyzer

SQL Server 20014 Implementation & Maintenance, SSRS, data integration & Transformation using SSIS/DTS

Expert in DevExpress Reports like Chart, Master-Detail Report, Pivot Gird

Expert in creating and implementing DevExpress dashboard reports

Extensive experience with .NET (C#, ASP.NET)

Proficient in development and debugging applications using Visual Studio 2010/2012

Complete SDLC cycle: System Analysis, Design, Development, Testing, Deployment & User Training

Strong skills in HTML, JavaScript, Microsoft ASP.Net

Web based application development using Microsoft ASP.Net Ajax, DevExpress Controls

E-Commerce application development using ASP.Net (3.5, 4.0), AJAX, Payment Gateways

3-tier application development experience

Strong development experience using Agile and Scrum based methodologies

Strong understanding for Team Foundation Server(2010/2012)

Strong understanding of 3rd party controls like DevExpress and Telerik

Technical skills

Languages

C# .net 3.5/4.0, ASP.net

Version Control

SourceSafe, TFS2010/2012

Business Component

ADO, ADO.net, LINQ, Entity framework

Database

SQL server(2008/2012/2014), MS-Access

Other

HTML, XML,CSV

Reports

DevExpress reports,SQL server reporting services(SSRS),Crystal reports, MS Access reports

Third Party Tool

DevExpress, Telerik,

Operating Systems

Windows Vista/ Windows 7

Professional Experience

Tools: Visual Studio 2012, C#4.0, ASP.NET, XML, Web Services, SQL 2012, DevExpress, TFS 2013

CompuDance, Dumont NJ

Project: Compuacademy.net

.Net /SQL Developer January 2014 –Present

Compudance Software is school management software used by dance, music and gymnastics studios worldwide. While working at compudance design and developed compudance database from ground up using SQL server 2014, created tables, store procedures and functions. Created and implemented different portals (Admin, staff, teacher and parent) using asp.net 4.0. Different DevExpress controls where used like ASPxScheduler control to schedule classes and to take student attendance, implemented the notification and subscription logic for student and teacher, also created and implemented user registration process for student to register. Implemented registration validating process SMS code send to the cell phone. Also make used of other DevExpress controls like ASPxGridView, ASPxScheduler, ASPxPivotGrid, ASPxHtmlEditor.

Responsibilities:

Visual Studio 2012 (Asp.net 4.0 and C#) is used in the development of the application

Use different DevExpress controls ASPxGridView, ASPxScheduler, ASPxPivotGrid, ASPxHtmlEditor.

Created Tables and Design relationships between them.

Created different Web pages using asp.net

Design and implemented DevExpress reports

Design and implemented DevExpress Dashboard

Implemented alter notification and email

Object/LINQ was used for database operations

Create Trigger for notification

Wrote store procedure created table as required using SQL server 2012

Setup TFS 2013 for project management

Data was imported in a different file formats like CSV, Excel, Access from Schools.

Designing various packages using various task e.g. Execute Sql Task, Data Source Tasks, Data

Environment: Visual Studio 2012 C# 4.0, ASP.net 4.0, SQL2008/2014, Windows 7, TFS 2013

TANVTECH North Bergen NJ

Project: Compudance (Convert Desktop application to Web)

SQL Server Developer January 2011- January 2014

Tools: Visual Studio 2010, C#3.5, ASP.NET, XML, Web Services, SQL 2008, DevExpress, TFS 2010

TanvTech provide services like web development, e-commerce solutions, outsourcing and project management. They also handle both in-house staffing as well as offshore resource fulfillment and offer onsite or in-house project management. While working at Tanvtech converted compudance application from desktop to ap.net web application using Visual Studio 2010, ASP.net, C# and SQL server was used as database.

Responsibilities

Work with user for requirement and understanding the business requirement.

Implementing different types of Constraints, Identity, Different Unique keys on tables designed in the Development and Testing area.

Data was imported in a different file formats like CSV, Excel, Access from school.

Designing various packages using various task e.g. Execute Sql Task, Data Source Tasks, Data Destination, File System Task, various others tasks for data cleansing.

Extensively using Views for complex joins queries involving multiple tables from different databases.

Performing Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.

Creating Stored Procedures, Triggers, Functions and Cursors for validation process and for loading data from the staging are to the product database in SQL 2005.

Experience working with DTS packages (SQL Server 2000) using different tasks and connection to pull the data from different sources, processing them and pushing them into appropriate destination.

Environment

MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS), Microsoft Windows XP Professional, SQL Developer, SQL Server Integration Services (SSIS), SQL Server 2000.

Education:

Master's of Computer Science

The Institutes of Management sciences Pakistan

Bachelor of Engineering

Federal University of Technology Minna, Nigeria

Contact this candidate