Sql Server Quality Assurance

Nadeem Bashir

** **** *****, ****, ** (L*T -*B*)

*******@******.***

(905-239-

**** (Home)

905-***-**** (Cell)

HIGHLIGHTS

. 16+ years of experience in Systems Analysis, Application Software

design, Development, Coding, Maintenance and Support.

. Team Lead with end-to-end grasp of the entire software development

life cycle (SDLC) including Analysis, Design, development, Coding,

Testing and Maintenance of software applications.

. Hands-on experience in database designing, programming, reporting and

complex queries, data modeling and stored procedures using Oracle

10/11g, Oracle Designer and MS SQL Server 2005/2008.

. Current experience in .NET 3.5, ASP.NET, VB.NET,VB6, C#, SQL, PL/SQL,

CSS, HTML, XML, Crystal Reports, SQL Server BI Reports, Visual Studio

2010 and Visual Source Safe.

. Proven experience in legacy systems i.e.; COBOL, Cognos Powerhouse,

QTP, QUIZ, Qdesign, OpenVms and DCL.

. Self-motivated and independent team player who utilized interpersonal

and communication skills to work in harmony with others with minimum

supervision and contributes to group relationships and effectiveness.

. Well-demonstrated problem solving and analytical thinking skills with

great attention to details in recognizing and resolving issues by

delivering innovative, cost effective and time saving solutions.

. Familiar with SLA and Project Management concepts.

PROFESSIONAL EXPERIENCE

The Regional Municipality of Durham, Whitby, Ontario Jun 1997 - Mar

2013

Systems Analyst

Role and Responsibilities:

. Responsible for development, testing, maintenance and support of software

applications utilizing a various technologies including VB.NET, Visual

Basic, C#, ASP.NET, Visual Studio, .NET Framework 3.5, Oracle, PL/SQL

and SQL server.

. Designed, developed, implemented and supported DineSafe web-based

application in VB.NET utilized ASP.NET 3.5.

. Designed, developed, implemented and supported SIMS (Simple Issue

Management System) web based-application in C#.

. Worked with BA's to translate business requirements into systems

requirements.

. Provided application support, troubleshoot, application testing, system

integration testing and post-implementation review of new/changed

applications.

. Created custom site pages, lists views and master pages.

. Created mock-ups of the new user interfaces.

. Conducted systems analysis of organizational needs and goals for the

development and implementation of application systems.

. Developed various reports such as drill down reports, parameterized

reports, sub reports, link reports and matrix reports using Crystal

Reports.

. Integrated Lagan CRM with symphony CMS via web services (SOAP) so that

requests for services made through the website could be logged as cases

in Lagan CRM.

. Configured/Customized Lagan CRM application. Developed e-forms using XML.

. Developed and tested project deliverables assigned as per design

specifications.

. Completed analysis and detailed system design and specifications for

enhancement requests and interface.

. Gathered, review and analysis user requirements, data and process

modelling, systems design, implementation and test planning for systems

and recommend optimum solutions.

. Designed data models and databases using UML and Oracle Designer.

. Developed functional specifications and user interfaces for new

functionality and obtain user sign off.

. Defined business requirements and develop user acceptance testing

strategies, test plans, test cases and execution in support of small to

medium projects.

. Utilized ADO.NET technology extensively for data retrieving, querying,

storage and manipulation

. Created Complex queries and Stored Procedures in Oracle.

. Developed complex reports using SQL server BI reporting tools.

. Developed/Configured ETL jobs for report server using SSIS.

. Developed Crystal reports within the .NET applications.

. Supported of applications in a managed and controlled environment (ITIL).

. Support, maintenance and enhancement of various legacy applications using

COBOL and Cognos Powerhouse in VMS environment.

Environment:

ASP.NET, VB.NET, VB6, C#, SQL Server2005/2008, Oracle10g, SQL, PL/SQL,

HTML, XML, Crystal Reports, SQL server BI Reports, Visual Studio 2010, MS

Visual Sources Safe, Web Services, IIS, CSS, JavaScript, SharePoint 2007,

Web Development, MS Silverlight, COBOL, Cognos Powerhouse, QUIZ, QTP,

Qdesign, DCL,VAX, OpenVMS.

University Scholarship Trust Foundation Jan 1996 - Nov 1996

Senior Programmer

Role and Responsibilities:

. Analyzed, designed, developed and maintain application software for the

RESP.

. Designed, coded, developed and implemented application using COBOL in

VAX/VMS environment.

. Modified existing programs to suit new features for clients.

. Designed and developed procedures for the hardware and software updates.

. Investigated causes of system failures and implemented corrective

actions.

. Followed established methods of testing and acceptance changes made to

the systems.

. Updated systems/users documentations.

. Provided technical support to users.

Environment:

VAX/VMS, DCL, COBOL, Datatrieve, FMS, DECRdb.

Canadian Scholarship Trust Foundation Jun 1992 - Jan 1996

Programmer Analyst

Role and Responsibilities:

. Analyzed, designed and maintain application software for the RESP and

Agent databases.

. Designed, Developed coded and maintain the complex RESP applications

using COBOL in VAX/VMS environment.

. Debug and tested the programs to make sure new changes meet the

requirements of clients.

. Developed and updated GUI interface using VAX/FMS.

. Developed datatrieve procedures to get data from DBMS database.

. Setup command procedures using DCL.

. Created/updated system documentations.

. Provided technical support to users.

Environment:

VAX/VMS, COBOL, DCL, FMS, Datatrieve, DECRdb.

EDUCATION

Diploma in Computer Programming 2001

University of Information Technology, Durham College, Ontario

TECHNICAL COURSES

Advanced Programming in C# with Microsoft Visual Studio 2010 May 2012

Web Development with Microsoft Visual Studio 2010 April 2012

Complete .NET 2.0 Application Development and Best Practices June 2010

Visual Studio 2008 - ASP.NET 3.5 May 2010

Microsoft SharePoint 2007 April 2010

Microsoft SQL Server 2005 for Developer/Admin Dec 2008

C# Programming with Microsoft .NET Feb 2008

Advanced Project Management April 2008

ITIL Foundation Management Nov 2006

Oracle 10g Administration May 2006

Developing Microsoft ASP.NET Web Application using Visual Studio.NET

2003

Effective Communication Skills for IT Professionals 2003

Visual Basic.NET 2003

Hands-on Project Management Skills for Success 2002

Software Testing and Inspection Methods 2002

Identify and Confirming User Requirements 2001

Visual Basic Web Development 2001

Visual Basic 6.0 1999

ORACLE DEVELOPMENT 1999

- Oracle SQL

- PL/SQL programming

- Oracle Application Development and Tuning

Object-Oriented Analysis and Design using UML 1999

Certificate in Structured Testing and Software Quality Assurance 1994

Computer Programmer/Analyst Certificate Program 1992

Seneca College, Toronto

Contact this candidate