Resume

Sign in

Sql Server Ms

Location:
Mississauga, Ontario, Canada
Salary:
55000
Posted:
October 02, 2016

Contact this candidate

Resume:

PROFESSIONAL CAPABILITIES

* ***** ** ********** ** Database Administrator, Data Analyst and Reports Developer.

Qualified, experienced and trained information technology professional. Four years of full life-cycle development experience with specialization in Web / Desktop application development on Microsoft .Net Development Platform.

Exposure to entire software development life cycle and experience with process based development and industry standards for development, GUIs, change management, document control, issues log and version control.

Sound experience in installation, configuration and maintenance of Database Servers.

5 Years experience in development of database systems, analytic reports (SSRS), SSIS,SSAS,BI,Dashboard.

Experience in MS SQL Server upgrades MS SQL Server 2005 to MS SQL server 2008 to MS SQL Server 2012/2014

Designed and developed Oracle database objects (schemas, table spaces, tables, indexes, views, materialized views etc.).

Experience in query optimization & performance tuning, execution plan, stored procedures.

Development, enhancement and support of Crystal Reports Solution for the Business.

Create dynamic reports in business intelligence suite for cost analysis using the data Banking Project.

Experience covers design, development, testing to successful implementation within budget, scope, timescales and process limitations.

Possess excellent verbal and written communication skills in French & English languages.

TECHNICAL CAPABILITIES

Database: Oracle 11g, SQL Server 2000/2005/2008/2012/2014, MY-SQL,SSIS

Languages: C#, SQL, PLSQL (Oracle), T-SQL

Reporting Tools: Crystal Report 10/11/12, SSRS,BI.

Development Tools: Microsoft visual studion.Net 2005/2008/2010

Operating System Windows Server 2003, Windows Server 2008 R2,Unix, Linux

PROFESSIONAL EXPERIENCE

CDI Computer Dealers Inc. March 2015 – To Date

Report Developer

Performance and Tuning of SQL Server using Index tuning, profiler

SQL Server upgrade and migration from version to SQL Server 2008 and SQL Server 2012/2014

Create BI Reports with the help of SSRS.

Development of Installer package for Microsoft SQL Server Analysis Services and required components

Support all Database problem with development team and QA Team.

Maintain all the Environments of Databases just like (Development, QA and Live).

Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore)

Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes

Responsible for internal Reports.

Write user specific scripts as per application requirements

Installed, maintained, configured Operating Systems and Databases

Tuned SQL queries using indexes and table partitioning and correct database

Provided daily status report on technical issues to senior management

Analyzed Data, Table structure and Relationships after that Create Authentic Reports

Created Reports using Crystal Report 10 & 11

Created Report in Excel with the help of VB Code.

Maintained database recovery and backup schedule

Support for Collection software and Trouble shooting for user problems

Technical Environment: MS SQL SERVER 2008/2012/2014, SQL, Crystal Reports 10, XI,MS Access,SSIS,SSRS.

Sauvageau & Associates. Jan 2015 – March 2015

Database Administrator/Report Developer

Performance and Tuning of SQL Server using Index tuning, profiler

SQL Server upgrade and migration from version 2005 to SQL Server 2008 and SQL Server 2012

Development of Installer package for Microsoft SQL Server Analysis Services and required components

Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore)

Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes

Responsible for internal Reports.

Write user specific scripts as per application requirements

Installed, maintained, configured Operating Systems and Databases

Tuned SQL queries using indexes and table partitioning and correct database

Provided daily status report on technical issues to senior management

Analyzed Data, Table structure and Relationships after that Create Authentic Reports

Created Reports using Crystal Report 10 & 11

Maintained database recovery and backup schedule

Support for Collection software and Trouble shooting for user problems

Technical Environment: MS SQL SERVER 2005/2008, SQL, Crystal Reports 10, XI,MYSQL.

Ottawa Systems Inc. March 2014 – May 2014

Database Administrator/Report Developer

Created the required table spaces, users, and roles for the application

Scripted for automating maintenance tasks and to ease administration

Wrote user specific scripts as per application requirements

Installed, maintained, configured Operating Systems and Databases

Troubleshot Data Base, application and handled user problems

Tuned SQL queries using indexes and table partitioning and correct database

Provided daily status report on technical issues to senior management

Analyzed Data, Table structure and Relationships after that Create Authentic Reports

Created Reports using Crystal Report 10 & 11

Maintained database recovery and backup schedule

Migrated Databases from SQL Server 2005 to SQL Server 2008

Technical Environment: MS SQL SERVER 2005/2008, SQL, Crystal Reports 10, XI.

Sidat Hyder Morshed Associated Pvt Ltd. October 2009 – January 2014

Senior Database Administrator/Report Developer

Creating the required table spaces, users, and roles for the application.

Scripting for automating maintenance tasks and to ease administration.

To write user specific scripts as per application requirements.

Using development and analytical skill to create reports (SQL,SSAS, SSRS, SSIS,BI, stored procedures).

Installation, maintenance, configuration of Operating Systems and Databases as well.

All trouble shooting related to DB & Application & handling the user problem.

Managing the All DBA related daily basis activities.

Tune SQL queries using indexes and table partitioning and correct database.

Responsible for regular deployments, maintenance and support and troubleshooting activities.

Provided daily status report on technical issues to senior management.

Query Optimization for the report for faster result.

Analyze Data, Table structure and Relationships after that Create Authentic Reports.

Creating Reports using Crystal Report 10 & 11

To maintain database recovery and backup schedule.

Monitoring database tuning and performance.

Migrating Databases from SQL Server 2005 to SQL Server 2012.

Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.

Documentation, Leading projects, management, Training, Troubleshooting and support

[Tech. Environment: SQL Server 2012, SQL Server 2008/ R2/2005, SSMS, SSIS, Windows 2008, .NET,BI]

Technical Environment: MSSQL SERVER 2000/2005/2008,SQL,Crystal Report 10,11,12,SSIS,SSRS,SSAS,BI,VS.Net 2005/2008//2010.

Projects:

Procter & Gamble Sales & Distribution System

The objective of this project is Sales & Distributed System enable to maintain the Products Distribution Outlet Wise and to check the Performance of the product sales.

Banking Project Treasury Model

The objective of this project was the Treasury Model, it works in 2 categories: Money Market and Forex.

Money Market: The money market consists of financial institutions and dealers of money or credits who wish to either borrow or lend. Participants are borrowing and lending for short periods of time.

Forex: The primary purpose of the foreign exchange is to assist international trades and investments by allowing business to convert one currency to another currency.

Workflow System

The objective of this project is a solution that allows relationships between various activities to be defined. This will serve three purposes:

For automated activities the WS will serve as a parameter driven method to initiate processes in a sequence and within a time frame.

For non-automated activities the WS will serve as a tool to track the timely performance of activities against pre-defined standards.

ARY Communications (Pvt.) Ltd. July 2006 – September 2009

Worked as Database Administrator-Crystal Report Developer.

To write user specific scripts as per application requirements.

Using development and analytical skill to create reports (SQL, SSRS, SSIS, stored procedures).

Installation, Maintenance, configuration of Operating System and Databases as well.

All trouble shooting related to DB & Application & handling the user problem.

Managing the All DBA related daily basis activities.

Responsible for regular deployments, maintenance and support and troubleshooting activities.

Provided daily status report on technical issues to senior management.

Query Optimization for the report for faster result.

Creating Reports using Crystal Report 10 & 11

To maintain database recovery and backup schedule.

Monitoring database tuning and performance.

Migrating Databases from SQL Server 2005 to SQL Server 2008.

Technical Environment: MS SQL SERVER 2000/2005/2008, SQL, Oracle 11g,Crystal Report 10,11,12,SSRS,SSIS.

Projects:

ARY Sahulat Card Management System

The objective of this project was to keep complete detail of shopping, legitimacy and value back information, therefore, the Sahulat System was developed. This system used to load the transaction details which are received from ORIX Leasing Company.

EDUCATION

Bachelor of Computer Science (BS(CS)) January 2002 – December 2005

Shah Abdul Latif University (ORASOFT)



Contact this candidate