Summary of skills

Hands on:

More than * years of experience in data base develop and data Analysing with MSSQL include; T-SQL, SP, query, triggers, functions and batches scripting and SSIS packages, SSRS Reports

More than 4 years of experience in maintaining Win Apps on .Net in C#, test and debug

Knowledge of .Net Frame work 4, 2 and 1.1

More than 5 years experience in creating reports in Crystal report

2 year of experience in VB.Net and ASP.Net

Working knowledge of SVN version and source code controller

Theoretical:

Knowledge of and experience in DDL and DML

In depth knowledge of OLAP invironment and Datamart, Datawarehouse and SSAS

Knowlege of Datawarhouse/ DataMart design

Knowledge of system Analyzing and design

Good understanding of Report Design elements; facts, metrics, measures, ...

Good understanding of project life cycle (SDLC; OOD, Waterfal, Iteration,Agile and LeanAgile)

Ability to work under pressure

Education

Programmer Analyst/Internet Solution Developer Diploma, CDI College (Toronto)

Software Engineering Bsc. Sharif University (Tehran)

Certification

Microsoft Certified Technology Specialist (MCP) .Net Frame Work 2

Computer Skills

Databases: SQL Server T-sql, Query profiler, Query Analyzer, Indexing, Sql script

Language:

Object Oriented:

.Net; C#, VB.Net

Others; Visual Basic for Application (VBA), SQL.

Applications: Visual Studio 2005,2008, SQL Server 2000,2008R2, Crystal Report, Microsoft Office Suite(complete), Microsoft Project Manager, VISIO

Operating System: Windows 9X, 2000 and 2003, 2008 server, A+, Network+

Key Accomplishment

Data analyzing, validating, cleansing data to get the best result on database conversion and data consolidation from legacy to newer system

Creating DTS and SSIS packages to extract, verify and pump up data from database and load it in to excel file in specific format (data type and length) to use in scrub and executive reports

Writing complex store procedures and functions to scrub and transform data for reports from different SQL Server data base (using T-sql and Crystal report)

Analysing, Designing and Developing Database applications in Access (using VBA);

Adding classes to library and UI to Report and Audit System” (using .Net C#)

Analysying, Designing and Implementing an assessment application to test the base knowledge of the job seekers

Professional Experience

Position: System Architect

Company: Tech Mahindra,(Work at Scotia Bank)Toronto Jun 2014 to Current

Analyse any existed MSBI (SSIS, SSRS), SQL Database base System

Offer new BI methodology

All remediation activities from test application (Integration test, Sanity test, smoke test, …), to data cleaning, object delivery, data lineage tracking, track changing, effective and technical documentation,

Enhance/Correct current BI projects, Database objects(SPs, UDFs) or Reports performance

Compare functionality of BI’s component in Legacy (sql 2005) and new (2012) system and correct any incompatibility or enhancement (as part of remediation activities)

Maintain, test, debauge existed SSIS Packages

Rewrite whole or part of packages, rdls, sql script if necessary to be more responsive with new environment.

Maintain, rewrite sql agents(jobs)

Documents issues, resultion, lineage on every developement as SSRS, SSIS, SQL Script, Scurirty, ...

Manipulated, Enhanced and Created Macro driven applications in Excel VBA

Technology: MS Sql Server 2005,/2012,SSRS 2005/2012,SSIS 2005/2012 VS 2005/2012,

VS DataTools 2012

Position: System Analyst / Developer

Company: Baybridge Senior Housing, Toronto Jun 2013 to February 2014

Enhanced, created new methodology in order to Automate most tasks Via Yardi (ERP Software)

Enhanced, test and adopt script in to existed report (sql Server)

Analysed business rules and create new reports

Created scheduled, temporal, data driven reports

Corrected users wrong input from backend

Monitored performance of the reports, manipulate and enhance the script to get the best performance

Designed front end tables in Crystal Report to render the reports

Helped with overall IT related tasks to users

Technology: MS Sql 2008, Crystal Report 9, VBA, Yardi

Position: Developer, SSRS Report writer (MIS) (Contract)

Company: Burkitt Computer, Barrie Jun 2012 to October 2012

Developed new data and business tier components and used existing core components to develop n-tier web based applications using C# and ADO.net

Coded solution to render reports in to different format using SSRS Web Service (SOAP)

Created Forms using Infragistics components into .Net as interface from (GUI) and create solutions to pass to back end

Coded Presentation objects to show reports on Win app, (Report Viewer) using Web service

Coded SQL scripts and stored procedures using MS SQL Server 2000 and T-SQL

Designed and created 18 SSRS reports using SQL Server 2008R2 and SSRS

Coded, manipulate store procedures

Coded scheduled solution on SSRS reports, Data Driven method

Monitored the performance of SSRS SQL reports and propose and implement corrective action where necessary to improve performance

Worked with version Control (SVN)

Technology: C#, Visual Studio 2008, 2010, BI 2008, MgStudio 2012, SQL Server 2008R2, SSRS, Infragistics Components

Position: Senior Database Developer, Data Analyst and Report writer (MIS) (Contract)

Company: MetCapLiving, Toronto March 2011 to January 2012

Performed report desgin and wrote Sql script to use in Yardi

Performed Extract, Transform, Load data to use in specific file format (Using DTS and SSIS)

Monitored the performance of existing Yardi Reports

Created SSRS reports

Found and implement corrective action where necessary to improve performance on SQL Script that supports Yardi Reports as datasource for the report

Performed Data Cleansing on Consolidation and migration between old Yardi system (Enterprise) and new Yardi (Voyager) (SSIS,EXCELL Macros)

Validated data accuracy and comparing databases (SQL Script, SSIS)

Provided related programming support for other IT issues and projects as and where needed.

Technology: SQL Server 2000 (T-sql), DTS, SQL Server 2008R2, Management Studio; SSIS, Yardi Enterprise, Yardi Voyager (Financial Management System)

**Note: I've been out of country since Late March 2010 to Mid September 2010

Position: Senior Database Developer (Contract)

Company: Regional Municipality of Durham, Whitby May 2008 to December 2009

Wrote SProc for the existed Database in SQL Server to communicate with Databases in Access using Query Analyser

Wrote SProc, UDF for the existed Database in SQL Server to conduct data to Report System

Developed New Databases Based on Access, VBA, improve and correct existed Databases

Added some functionality to the existed Database

Technology: Ms Access, SQL Server 2000 (T-sql), DTS, VBA

Position: Application Developer (Contract)

Company: Paramount Inc, Aurora Aug 2007 to May 2008

Implemented classes and Data link layer includes

oAdded a report C# class to maintain a general level of the report design (Report Factory)

oCreated UI Forms to retrieve parameters passes to store procedures (C#, .Net 2)

oWorked on DataAccess layer to add Disconnected as well as connected ADO objects (Datasets, Datareaders, etc)

oImplemented and Coding C# Class for employee dll to add functionality of keeping track of the employees and calculation of their payment to the application

oImplemented employee – service class and process to the application.

Technology: SQL Server 2000 (T-sql), VS 2005, C#, Crystal Report

Position: Database Developer (Contract)

Company: Canada Air System, Mississauga April 2006 to Jan 2007

Wrote Store procedures to update/insert or create objects for small to mid scale transactions

Wrote complex store procedures to extract data used in Reports

Created new custom forms and user control

Technology: SQL Server 2000 (T-sql), Enterprise Manager, VS 2005, C#, Vb Script, Crystal Report, VISIO, MS Project

Position: Database/ Application Developer (Full time) Tehran May 2002 To February 2005

Company: IOID (manpower Provider Corporation for International Oil companies such as Shell, Eni, Total, etc)

Supported and maintained the existed applications and Databases

Wrote Store procedures to use in reports on the report server from different databases

Added some functionality to existed applications (.net 1.1)

Assisted in develop quality prototypes and full application solutions (vb6)

Assisted in interpret and translate business requirements into application solution designs and preparing ERD and DFD

Assisted in developing Design Class Diagram

Designed, Develop an assessment application

Recreated the web page from legacy ASP to ASP.Net (http://www.iranofogh.com/cvm/))

Technology: SQL Server 2000 (T-sql), Enterprise Manager, C#, VBA, VB.Net, ASP.Net, HTML, Java script, Vb Script, VISIO, Ms Project

Position: Database Developer / Programmer (Full time) Tehran

Company: Research Centre at Regional Municipality of Tehran October 1992 – March 2002

Position: Database Developer February 2001-March2002

Wrote complex store procedures and UFDs to Extract and Transform data for later use in different applications and software

Developed database objects (Tables, SPs, functions) to re_coding information from GIS systems.

Wrote Store Procedures, User Defined Functions to use in daily to day commotion transaction

Wrote complex Store procedures to extract data used in reports

Wrote Sql script to report used in Crystal report

Helped with Data base relocations and extraction using System Store procedures and procedures

Position: Ms Access Application Developer July 1999 – February 2001

Implemented Construction Access applications for using in Earth quake research project (Access 97, VBA)

Implemented Housing Access applications for using in Environment projects (Access 97, VBA)

Implemented types Surveys Access applications for Environment projects (Access 97, VBA)

Implemented budged and expenses Access application to in house use (Access 97, VBA)

Implemented salary and payment Access application for the administration department (Access 97, VBA)

Created Macros for existed Excel spread sheets to automate some functionality and calculation and in order to create charts and filtered the data (Excel and VBA)

Position: Computer Specialist March 1994 – July 1999

Set up, helped with trouble shoot of windows 95,98, NT operating system

Installed, Uninstalled, help with troubles shoot softwares on the users computer and network

Performed Help desk and Trouble shoot with users Issues

Position:Data Entry October 1989 – March 1994

Entered data from different resourses (Manually) to the system (DB2, Data ease, FoxPro)

Technology: SQL Server 7, 2000, Crystal report, Access 1997, Access 2003, Data Ease, Vb6, VBA, Ms Excel

Contact this candidate