Sql Server Project Management
Resume:
Aitzaz Ashraf
*****************@*****.***
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