Post Job Free

Resume

Sign in

Sql Server Management

Location:
Mississauga, ON, Canada
Posted:
April 11, 2015

Contact this candidate

Resume:

Zeeshan Mujtaba

aco4zx@r.postjobfree.com, 647-***-****

Objective: With diverse technical expertise, astute business understanding and

application development background look forward to join a dynamic and

progressive organization offering ample opportunities for diversified

exposure, enhancement of professional skills and career growth.

Career Profile Result-oriented, customer-focused, and quick learner with more than 6

years' of experience working on various National and International

commercial projects. Extensive technical knowledge of financial

Projects for Banks and Stock Trading Modules. Experienced developer

with particular expertise in VB.Net, C#, Visual Basic, SQL, PL/SQL,

ASP.NET,ASP, Web Services, WinSock, JavaScript, VBScript, HTML, CSS,

IIS, COM/COM+/DCOM, MTS, Oracle, MS SQL Server, SQL Express, Microsoft

Access with database analysis and design. Experience of analyzing and

developing software projects in challenging, fast-paced consulting

environments. Demonstrated ability to acquire technical knowledge and

skills rapidly. Innovative problem solver, able to see the business

and technical sides of a problem. Strong written and verbal

communications. Skills in developing requirement specifications, user

documentation and architectural system research. Interested in a

challenging technical track career in an application development

environment.

Technical

Skills

Databases: Oracle, MS SQL Server, SQL Express, Microsoft Access,SQL, Stored

Procedure, MDX

Web Visual Studio, .Net Frame work, ASP.NET,ASP, Web Services, MVC, C#,

Technologies: JavaScript, JQuery, VBScript, HTML, CSS, IIS, Visual Basic, VB.Net,

C#,SSRS,SSAS, Crystal Report

COM/COM+/DCOM, MTS, WCF,MVC

Middleware :

Tools: AJAX Control Toolkit, Visual studio 6 and .NET 2005/2008, Visual

InterDev, Dream weaver, Front Page, Crystal Report, Platinum Erwin

ERX, MS Project. Telerik

Operating Windows 95, Windows NT 4.0, Windows 2000-2008, Windows XP

Systems:

Web Server for Wan Environment. IBM Server Configuration and

Installation, Configuration of Raid 5 Controller. Active Directory,

Network: DLINK 860 Firewall Configurations and Implementation, Building

Frameworks ADO, .Net Framework, Windows SDK, .Net Compact Framework

Case Tools Rational Rose, ER Win, Visio, UML

Other Microsoft Excel, Power Point, Word

Educations 4 Year bachelor degree in computer science Canadian standard.

Preparing SQL Server 2012 Certification

Work Experience Career History:

: 10+ years of diverse experience in System Analysis, System Design,

Product Development and software implementation.

Experienced in Financial Applications and custom application

development for Banks, Stock Exchange and Money Transfer Companies.

Ability to communicate with individual in all levels of business and

Management team.

Experience to work as a team player highly organized and able to

handle multiple tasks simultaneously.

Successfully developed & deployed "Money Transfer System" in Canada,

United Kingdom, United Arab Emirates, Qatar, Pakistan, Bangladesh,

Nepal and Sri Lanka. Also giving ongoing support for the following

product.

2014JAN Organization : SSCI (MORGUARD CANADA)

-Present Job title: Sr. Database Developer / Business Analyst

Morgard is currently using a link on SharePoint portal to give user

access to the cornerstone. The current Single Sign On (SSO)

functionality does not support Deep Linking of URL's. Deep Linking

gives the user the same direct access to an external site AND directs

them to the final destination page found "deeper" in the site per the

level of detail in the link provided.

Develop a Single Sign on (SSO) application and convert SharePoint

module into .Net, to allow deep linking of URL's to ensure user land

at the expected page without having to click various site pages to

"find" the page that was noted in the email they received from

HRAssist.

System sent a set of notifications to the relevant stakeholders.

Performed budgeting non budgeting process flow

Execute LDAP connectivity

System sends an Email confirmation each and every step.

Developed System related / Customize management reports using Crystal

Report (Drill down report, ad hoc reports, formula based report,

graphical report analysis reports)

Responsibilities as Database Developer

Worked as prime contact with business stakeholders to analyze, design

and recommend business application solutions and support them in

designing the complete application flow

Led user sessions and follow SDLC life cycle to effectively identify,

and define business Requirement and system requirements with the

involvement of business SME's

Utilized third party tool Telerik control to developed an Application

in C#, Asp.net.

Worked with Production support team to provide ongoing Technical

support.

Create design artifacts like use case, user scenarios and coding

updates documentation

Worked with team members to resolve client issue and/or escalate them

to appropriate departments within the organization.

Implement of Web Application Security, Involved in Database

Installation, configuration, upgrade, and migration. Be a part of DBA

team and involved in Creating Database Backup, recovery plan, Managing

Database Storage and Capacity planning. Also do Database Performance

monitoring and tuning.

2009JULY- Design and Develop Database Schema

DEC 2013 Developed Stored Procedures, Triggers, Views, SQL and MDX in MS SQL

SERVER

Develop Application in C#, Asp.net using third party component like

Telerik control.

Provide Technical support to production team.

Design customize reporting module in SSRS.

Supervise Technical documentation

Design and Develop Database Schema Wrote Stored Procedures, Triggers,

Views in SQL.

Database Installation, configuration, upgrade, and migration

Creating Database Backup and recovery plan.

Creating/ Managing Database Security plan.

Managing Database Storage and Capacity planning.

Database Performance monitoring and tuning.

Database troubleshooting.

Data Extraction, Transformation, and Loading (ETL).

Managing SLA's.

Provide support to fixes production problem.

Organization: HabibExpress Ltd. (Canada)

Job title: System Analyst / Application Developer

HabibExpress Money Transfer: HabibExpress is online instant cash Money

Transfer system, System Facilitate expatiators to send remittances

instantly different part of the world. HabibExpress is complete Client

Server Application.

Responsibilities System Architect / Application Developer

Architected and developed a fully integrated windows/web based Money

Transfer application.

Involved in the design of security module that gives access to users

based on roles and groups.

Extensively used third party controls to display information in both

Web and Windows based applications.

Created Java Script functions to validate the inputs at the client

side in web based applications.

Developed and executed TSQL procedures, triggers and views to

integrate them with windows and web based software applications.

Developed extensive RDBMS table design for many different subsystems

and enhancements, ensuring that relationships and keys are established

with all the tables in SQL Server 2000 and 2005 and 2008 database.

Responsible for developing complex SQL queries and stored procedures

Also implement SQL Injection, Authentication and Section Management,

Cross-site scripting, Insecure Direct Object References, Security

configuration, Restrict URL access, Invalidated Redirects and

2004 MARCH - Forwards, Sensitive Data Exposure.

JUNE 2009 Developed Front end in ASP.Net, and C #, and BackOffice Modules in

VB.net, Serviced middleware (Com+) components, the web service using

C#, Business Logic Layer in VB.Net

Developed Billing, Settlement, Risk Management, Compliance and

Reporting Module In VB.Net

Generated periodic reports based on the statistical analysis of the

data from various time frame and division using SQL Server Reporting

Services (SSRS)

Develop reports using complex formulas and to query the database to

generate different types of ad-hoc reports using SSRS.

Developed various operational Drill-through and Drill-down reports

using SSRS, also developed different kind of reports such a Sub

Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate a report from two different Data

Sets. Involved with Query Optimization to increase the performance of

the Report.

Experienced in data extraction, Transformation and Loading (ETL) using

various tools including SQL Server Intelligent Services (SSIS), DTS

Packages, and Bulk Insert (BCP).

Excellent in ETL data flow using SSIS workflows to extract data from

SQL Server and Flat File sources, legacy systems and load into various

Business Entities.

Astute knowledge in integrating, migrating, converting and cleansing

data using SQL Server Integration Services (SSIS).

Automated various jobs and data pulls by Designing/creating various

SSIS Packages.

Worked in ETL and data integration in developing ETL mappings and

scripts using SSIS

Knowledge of data migration from SQL Server 2000to SQL Server 2005.

Developed System related / Customize management reports using Crystal

Report (Drill down report, ad hoc reports, formula based report,

graphical report analysis reports)

Organization: Habib Qatar International (Doha Qatar).

Job title: Technical Consultant / Sr. Developer

Application Developed

Money Exchange and Management System.

Online Payroll System.

Fixed Asset Management System.

Responsibilities as DataBase / Application Developer

Extensive end user interaction for gathering requirements, design and

UI approvals and User acceptance testing Performed extensive analysis

of system and business requirements, and business rules.

Developed Serviced middleware (Com+) components using VB.net.

Designed and developed 3 tiers.

Design Database, Stored Procedures, Triggers, SQL in MS SQL SERVER.

Customer relationship management with our in-house and offshore team

Creating Queries for Extracting Data from DB's. (SQL 2000/2005).

Developed reports using Crystal Report.

Developed Front hand and BackOffice Modules in VB.Net, ASP.Net C#.

Technical Documentation.

Helping team in development and deployment.

Implement Data security algorithm

Developed System related / Customize management reports using Crystal

Report (Drill down report, ad hoc reports, formula based report,

graphical report analysis reports)

2000 JAN- Organization: Applications Pvt Ltd.

FEB 2004 Job title: Software Engineer / Jr. Analyst

Virtual Trade Automated System (Online Trading System)

VTAMS is web base Trading Application which is first online trading

system in Pakistan. Virtual Trade Automated Management System or

simply VTAMS is a powerful electronic Client Stock Trading System,

which allows live trading Environment with Karachi stock exchange.

Coordinate with the project Manager in the development and design of

the software, Writing requirement specs

Creating applications using VB and enhancing projects for ASP

applications

Designing data modeling for VB applications of new projects and

reviewing high and low level designs

Studying business requirement, entering code, implementing functions,

and testing applications

Creating and maintaining user and technical documents

Drafting reports with the help of the Crystal Reports tools and

creating project presentations

Performing extensive data analysis and correction

Software architecture and design document.

Virtual Online Business (VOB) B2B.

The Site has the ability to register suppliers and buyers online

saving them time and hassle of manual registration taking their

company and financial information etc.

Display and management of all their sale and purchase of products,

maintaining shopping cart, product pricing, their Delivery Information

and their inventory position web based stock in and stock out and auto

site maintenance process

Performed business requirements analysis and data modeling

Designed object relation diagrams, process flow diagram and objects

modeling

Worked with the team of coding and handled coding of batch process

operation

Created the triggers, functions and stored procedures

Implemented changes in coding and designs using knowledge of VB

Conducted release testing, bug verification and software testing

Worked and enhanced the flow of internal applications

Implementations

Field of Interest:

Achievements

Canada.

United Kingdom.

Qatar.

UAE.

Pakistan.

Srilanka.

Bangladesh.

Technical Consultancy

Project and Customer Management

Analysis and Database Design

Development.

Distributed Applications Design and Development.

Business System Analysis and Design Financial Applications

HabibExpress Money Transfer

Money Exchange Management System

Online Trading System (VTAMS)

GPS Tracking Solutions.



Contact this candidate