Data Sql Server

ZAKIR HOSSAIN

** ***** ***, *******, **, Canada

Tel: 1-416-***-**** (cell)

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

Summary: Business oriented Reporting Analyst with sound knowledge of data manipulation,

extraction, and forecasting analysis. Actively seeking a challenging Analyst

Position to enhance my analytical skills to help the business into meaningful insight.

Microsoft SQL server database certified

Completed Big Data training from IBM Big Data University.com

More than 2 years of experience as Reporting Analyst

More than 5 years of experience in MS Excel, Access, SQL Server, VBA

Strong knowledge in statistical analysis using SAS, R

Enhanced knowledge & hands on lab experience on Data Mining Tool e.g. Weka

Hands-on experience on Hadoop Technology (HDFS, MapReduce, Hive, Hbase,

Pig)

Outstanding experience on Excel macro, V-lookup, Pivot table, functions

Advance knowledge in standard, ad-hoc, statistical, forecasting reporting

Strong capability creating MS Access tables, forms, SQL queries& reports

Extensive experience on data extraction, data manipulation& data analysis

Experience on Win XP, Windows 7, MS-Word, Excel, Powerpoint

Strong analytical & problem solving skills

Able to work independently or as a part of a team

WORK EXPERIENCE

Business Reporting Analyst Dec ‘2013 – Present

Sun life Financial, Waterloo, Ontario

Gathered large data set of CRM activities from SMO and financial data from finance deptt

Prepared activities & financial report for CSF – TP Wealth (WSD/ISR/RSA)

Prepared Edward Jones 2014 combined report for smart office activities & Sun life Global

Sales

Modified CRM activities in SmartOffice

Applied filter to extract data to produce meaningful data set for particular activities

Cleansing data to maintain data integrity & data quality

Developed Dashboard & modified dashboard as required

Manipulated data, generate complex formula, as well as created macro using VBA

Produced supporting analytical spreadsheet report to support final report

Prepared process to support business, posted on share point

Prepared monthly Zone Rotation, FC report using VBA

Prepared weekly report (Tilapia, Due Diligence, Redemption etc.)

Reporting Analyst July ‘2011 – Oct’ 2013

Celestica, Toronto, Ontario

Gathered data set from various sources

Checked data integrity & data quality

Manipulated and cleansing data

Assisted in performing compiling data, mining and analysis on given data

Performed statistics analysis for forecasting

Generated macro command to automate the tasks

Extracted data from large date set using SQL command

Performed data analysis on sales, financial,& inventory data using Pivot table

Generated weekly/monthly report

Developed summarized report using MS Excel pivot table

Created short command functions using macros

CreatedMS Access table, forms, SQL queried and report

Data Control Clerk Aug 08-Dec ‘2010

Toronto Transit Commission (TTC)

Data entry, verify accuracy of data& updating data.

Extracted data from large date set using V-lookup functions

Generated summarized report using Excel Pivot table

Data Analysis,update database& generate database report

Created MS Access database table, forms& reports

Generated MS Access SQL queries from large data set to retrieve particular data

Data enter into excel spreadsheets & make a consolidated database

Database Developer 2001-2006

Ha-Meem Group, Dhaka, Bangladesh

• Designed database, analysis, develop using VB & SQL Server

• Developed software as company requirement (i.e Sales & Inventory, Export & import system)

• Designed and create data report using MS Access &crystal reporting

• Maintained RDBMS

• Designed queries, relational database system

• Performed schedule backup and recovery of database

Computer Programmer 1998-2001

Opex Group, Dhaka, Bangladesh

• Designed & eveloped Client/Server application software using VB, Access & SQL server

• Provided all logistic support and modification with existing software

• Distributed developed software within the group where necessary

• Performed administrative work with ON LINE Banking System e.g. Hexagon, Optim, ANZ Link

• Maintained central database server so that user can share the resources

• Controlled server operation i.e. SQL Server 7.0 and Windows NT 4.0

Assistant Programmer 1996-1998

Nouvelle National Ltd, Dhaka, Bangladesh

• Analyzed spread sheets using Microsoft Excel & Lotus

• Designed and developed data entry screen using Foxpro and BASIC

• Designed report using report writer

• Maintained database system

• Assisted Senor Programmer

Education & Training:

Studying in Management of Enterprise Data Analytics (BigData), University of Toronto 2014

Completed Big Data Training program, IBM Big Data University.com 2013

- Hadoop Fundamentals

- Introduction MapReduce Program

- Data Analysis using R

- Data Warehousing using Hive

- Introduction to Pig

Advance Diploma in Computer Science, Bangladesh 1995

Masters in Management, Bangladesh

1994

Contact this candidate