Sql Server Engineer

Sakibul Islam Khan

** **** **** ****, ********, Ontario, L6X-4V3

Cell-phone: 514-***-****; Email: ************.****@****.******.**

[pic]

Profile McGill Computer Science graduate with 5+ years of work

experience in an IMS Health company with C#.NET, VBA and SQL

expertise using MS SQL Server; creating offline Dashboards /

automated Reports in Excel/PowerPoint.

Work Experience

Aug 2008 - Nov Senior Software Engineer, M&H Informatics (BD) Ltd. [an

2013 IMS Health company]

(5+ years) Tasks performed:

Analyzed the data that is required for the offline

Dashboard/automated Report in Excel/PowerPoint;

Analyzed the KPI that has to be calculated like Growth,

Market Share, Growth of Market Share, Evolution Index,

Compound Annual Growth Rate (CAGR), etc.; all based on

weekly, monthly, rolling quarter, calendar quarter and

yearly time periods;

Wrote complex SQL queries based on the market definition

of the project, involving

Stored Procedures (SP), Functions, calculations, pivots,

cursors;

Wrote code in C#.NET or VBA macro that would fetch data

from SQL Server database using the Stored Procedures (SP)

with specific parameters and then place the data in the

chosen location within the Dashboard/Report;

For Excel Dashboards, VBA code was also written inside the

Excel file to handle events like Button click,

ComboBox/Drop-Down change, ListBox change, CheckBox

change. These events would fire the VBA code to change the

Charts/Tables of the Excel Dashboard;

Upon completion of the project, the production steps would

be repeated every cycle (weekly/monthly/quarterly/yearly),

to generate new offline Dashboard/automated Reports in

Excel/PowerPoint with refreshed data.

Accomplishment:

Started developing a VBA Excel/PowerPoint framework that

would contain the commonly used VBA code of different

projects.

Technology used:

C#.NET, VBA macro, Excel, PowerPoint, SQL Server, Excel

built-in functions.

Apr 2005 - May Assistant Officer, HSBC - The Hongkong & Shanghai Banking

2008 Corporation Ltd

(3+ years) Tasks performed:

HSBCnet (Corporate Internet Banking) web administrator at

Bangladesh;

Perform maintenance/changes in a back-end software that

changes the HSBCnet website for the clients in the

midnight batch run;

Created data converting/processing software in C#.NET for

the Bank & MIS

Perform Quality Centre Testing on HSBC's new softwares

(UAT & PVT)

[i.e. User Acceptance Test & Production Verification Test]

Accomplishment:

Learnt about the internet banking facility in details from

HSBC's Corporate Internet Banking service [

http://www.hsbcnet.com ];

Technology used:

C#.NET for the data converting/processing software;

Computer Skills

Programming Languages

Procedural/Object Oriented: VB, C / C++, C#.NET, Java

Shell and Internet Perl-CGI, HTML, JavaScript & CSS

Scripting:

Database Management: SQL (in SQL Server, Oracle, DB2, MySQL, MS

Access), JDBC

Object Oriented Software UML

Design Rep.

Networks / Operating TCP-IP / UNIX (Solaris, FreeBSD), DOS, Mac OS,

Systems Windows

Database Management System Entity-relationship model, relational databases

Software Applications

Web-related / Graphics: Dreamweaver, Flash, Photoshop, Fireworks

Word Processing/Publishing: Microsoft Office, WordPerfect / Adobe PageMaker

Databases: MS SQL Server, Oracle, DB2, MySQL, MS Access

Hardware skills Knowledge of PCs, installation of components &

peripherals

Education

Master of Business Administration (M.B.A.), Major: 2009

Management

University of Dhaka, Dhaka, Bangladesh

Bachelor of Science (B.Sc. - 4 years), Major: Computer 2003

Science

McGill University, Montreal, Canada

REFERENCES ARE AVAILABLE UPON REQUEST

Contact this candidate