PROFESSIONAL SUMMARY:

• 7 years of IT experience at various industries in software development as a .NET Developer on client/server applications and web based applications using C , ASP.NET, ADO.NET,SQL Server 2000/2005/2008R2, Sql Server Reporting Services, Crystal Reports.
• Microsoft Certified Professional
• Developed use cases using UML
• Object Oriented Analysis and designing.
• Developed Web Forms and Win Forms applications with .NET Framework 2.0/3.5/4.0and ASP.NET 2.0/3.5/4.0
• Developed web and windows applications using C and VB.NET.
• Experience in Visual Studio 2003/2005/2008 and SQL Server Management Studio
• In depth knowledge of T-SQL DDL AND DML .
• Expert in indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Automated testing for new software applications.
• Expert in database backup /restore activities and extracting and transforming data using DTS Import Export Data and Bulk Copy Program.
• Planning and Implementing MS SQL Server Security and Database permissions.
• Sql Server Database Management, Maintenance and troubleshooting.
• Experience in Business Intelligence Integration SSIS, SSAS, SSRS , ETL, Business Data Analysis, Design, Crystal Reports, Logical and Physical database Modeling and Implementation on major RDBMS SQL Server 2000/2005/2008R2 .
• Worked extensively with Stored Procedures, Triggers and Indexes.
• Solid knowledge of OOD, Design Patterns and Transactions Handling
• Experience in developing applications in Agile SDLC.
• Experience in trouble shooting and support
• Excellent analytical, communication, problem solving skills

TECHNICAL SKILLS:

• Development Languages : C , VB.NET, T-SQL
• Scripting Languages : JavaScript
• Markup Languages : HTML,CSS, XML.
• Development Tools : Visual Studio 2005/2008/2010, Microsoft SharePoint Portal.
• Database Systems : MS SQL Server 2000/2005/2008R2, Oracle Pl/SQL
• Developing Software : UML
• Other Tools : ASP.NET3.5/2.0, MS SQL, ADO.NET, .NET Framework 3.5/4.0, Entity Framework 4.1.
• Microsoft Products : MS Word, Excel, Power Point, InfoPath2010
• Reports : SQL Server Report Service, Crystal Report.
• Operating Systems : Window Server 2003, Windows 7/XP

EXPERIENCE:

Confidential

.Net/Sql Developer

• Mbook is the POS solution system that helps wholesalers and retailers to manage their purchase orders and sales.
• Heavily involved in gathering user requirement, analysis, designing, coding, testing and implementation.
• Involved in database management,implementation, designing, modeling, maintenance and troubleshooting.
• Involved in Dimensional Data Modeling and adopted snowflake schema for Business Intelligence activities.
• Involved in data extraction, transformation and loading from various data sources by using SSIS.
• Used SSAS for Data analysis, data dimensions, data warehousing and cubes.
• Involved in web based application with the interaction of Crystal Report XI and SSRS Sql Server reporting services tools.
• Coordination with the vendor for setting up new Purchase Order EDI Processing.
• Practicing Business Intelligence techniques for data analysis.
• Using Sql Server Reporting System for creating report from Data Warehouse/OLAP cubes and scheduling reports in emails and created Adhoc crystal reports for users to pass parameter and get desired data.
• Bug fixing for new and existing web applications.
• Automated UI testing with visual studio 2010.
• Used .Net Framework 3.5/4.0, SQL Server 2008 with Visual Studio 2008/2010 and vb.net/c .
• Involved in writing classes for business rules and logics and testing in vb.net and C .
• Wrote complex stored procedures, functions, Union and views.
• Export Purchase Order to EDI Files, Excel File and PDF File.
• Used .Net Framework 4.0, SQL Server 2008 with Visual Studio 2010 and TFS.
• Involved in Adhoc Marketing Reporting System on Crystal Reports comprising over hundred reports. Used SharePoint 2010 with InfoPath for supervisor daily report submission.

Confidential

.Net Developer

• AMI Alberta Mineral Information was enterprise level project that manages activities of Royalty agreements, Oil wells contracts, Oil Sand and Minerals
• Involved in Object Oriented Analysis, designing ,coding and Testing of the Software Development Life Cycle.
• Actively involved in gathering User Requirement and System Specification.
• Implementation of business strategies on the bases of Object Oriented design and Analysis.
• Involved in Dadabase logical and physicalmodeling. Extracting data from different data sources , transforming and loading in data warehouse.Analyze data flow and Develop Crystal Reports 11 by using Visual Studio 2010 and Sql Server 2008.
• Developed Adhoc Reports in SSRS with BIDS and Report conversion between Crystal and SSRS.
• Assist in development of Alberta Mineral Information application as a multi-tier application using VB.NET AND C and Sql Server 2008.
• Taking advantage of the improved efficiency and ease of use in Visual Studio 2010, with its built-in support for ASP.NET, improved JavaScript support, and a new Web page designer interface.
• Developed Stored procedures, Triggers, Functions, Views and Cursors to interact with the database and Sql Reports and Crystal Reports.
• Documented developed components and modules. Enhancements to the existing system to add additional functionality to meet users' requirements.
• Manage the requirements and specifications throughout the project lifecycle and actively Participate in testing and implementation support activities
• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering of User Requirement and System Specification.
• Automated testing by using Test Drive Tool.
• Created new database logical and physical design to fit new business requirement, and implemented new design into SQL Server 2008
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization
• Prepare test plans and test cases and assists in test execution and defect resolution
• Support end users during the initial implementation of the system including reviewing and working with both end users and developers to resolve problems.
• Defect tracking and raise issues with Visual Intercept.

Environment: C , ASP, ADO.NET, SQL Server 2008, Visual Studio 2008/2010, VSS, UML, Infragistics, Agile Scrum, Visual intercept, Crystal Report 11, SSRS, Agile Scrum, Windows 7.

Confidential

Report Writer

• United BioSource Corporation is a global pharmaceutical services organization that helps
• Emerging and established life science companies gather and analyze evidence to develop and commercialize their medical products.
• Actively involved in gathering User Requirement,analysis, designing, coding, testing and implementation.
• Involved in web based application for Adhoc Marketing Tool using Crystal Report IX.
• Using Sql Server Reporting System for scheduling reports emailed in Excel and PDF and created interface to pass parameter and get desired data.
• Writing complex stored procedures, functions and views in Sql Server 2008R2.
• Tweaking existing web applications.
• Used .Net Framework 3.5/4.0, SQL Server 2008 with Visual Studio 2005 and vb.net/C .
• Design and development of the web applications using ASP.net, VB.net/C
• Developed the user interface in ASP.NET using VB.net
• Involved in creating ETL Packages with SQL Server 2005 for extraction, transformation and deployment various type of data using SSIS
• Involved in implementing Referential Integrity and Cascade deletion in database by creating primary key constraints, foreign key constraints and triggers etc.
• Used ADO.NET for data querying, storage and manipulation. Designed and Implemented Data Access Layer DAL to communicate with SQL Server 2005.
• Created complex stored procedures and functions to support efficient data used in SSRS and Crystal Report
• Participated in different testing and debugging of the system Reports.
• Developed Stored procedures, Triggers, Functions, and Views to interact with the database.

Environment: C , ASP.NET 2.0, ADO.NET, SQL Server 2005, Visual Studio 2005, VSS, UML, SSIS, SSRS.