Project Sql Server

PRITHWIRAJ DAS

Contact#: 647-***-****, Email: **************@*****.***

#**** *** ***** ** ****, Apt 805, Toronto, ON, M2J 3B8

LinkedIn: http://www.linkedin.com/pub/prithwiraj das/46/412/929

SYNOPSIS

I am software developer with more than 1 year of experience as a developer. I am currently employed

with Dapasoft Inc as an IT Consultant. At Dapasoft I am currently involved in multiple projects. Two of

them are .Net applications with SQL server 2012 as database. One of the projects is for Bell Canada

which is a Microsoft Dynamics CRM 2013 application. I had graduated from Humber College in April

2013 with a post graduate diploma inInformation Technology Solutions. I had worked as a developer at

AMA Inc, Mississauga, ON in a project named Marketing Engine for Wi Fi Hotspots, this represented

AMA Inc at an event at CBC, Toronto. I was also involved as a Junior Buiness Analyst at Synergy Tech,

Toronto, Canada. I had completed my Bachelors of Technology in Electrical Engineering from Techno

India College of Technology, India in 2012.

SKILLS & EXPERTISE

• Programming languages C#, T SQL, Xml, PHP, JEE and J2EE.

Framework Web Forms, WPF, MVC and WCF using ASP.NET; ADO.Net, Entity Framework.

•

Database Oracle 11g, Microsoft SQL Server 2008, Microsoft SQL Server 2012, My SQL.

•

IDE’S NetBeans 7.4, Eclipse, Visual Studio 2013, Oracle SQL Developer, SQL Server 2012/2008, SQL

•

Server Migration Assistant (SSMA), Team Foundation Server(TFS).

• Scripting Languages JavaScript, Html 5, CSS3.

Source Control Team Foundation Server Visual Studio (2012), Atlassian SourceTree.

•

Tools: JIRA Agile, Balsamiq (Mock up), Pencil Project (Mock up), Visual Paradigm, MS Visio.

•

Used Telerik DevTools like UI for ASP.NET AJAX, used xRM Framework with Javascript and Redgate

•

(Sql compare & Sql Data compare), Adobe Dreamweaver(CS4/CS5)

• Knowledge of creating test plan, test cases and Bug reporting. Experience in manual testing.

PROFESSIONAL EXPERIENCE

A. Dapasoft Inc, Toronto, ON, Canada July 2014 Present

Role: IT Consultant

I. Project: Ontario Federation of Indigenous Friendship Centers (OFIFC)

OFIFC project involves collecting data from numerous friendship centers, organizing and maintaining records of

clients and managing various events of OFIFC. This project also updates the government database with client

progress reports and OFIFC budget details.

Responsibilities:

• Adding new programs to the existing system and managing the other existing programs. Migrating data from

old database.

• Deploying updates and bug fixes of code, database and reports on the client environment. Maintaining

Client as well as QA environment.

• Coordinating with offshore team regarding tasks and bugs.

• Managing source codes and resolving bugs using Team Foundation Serve Visual Studio 2012.

Environment: .net Technology, SQL Server 2012(Management Studio and Reporting server), Redgate SQL

Compare, Windows Server 2012 R2/ 2008 R2.

II. Project: Drug and Alcohol Treatment Information System (DATIS)

DATIS project involves creating an application which will upload specific set of data at specific time intervals

from OFIFC database to DATIS database. This application is a Windows service which will interface with web

service.

Responsibilities:

• Creating Windows service application to interface with web service (DATIS)

• Creating functions and stored procedures on OFIFC database which will return the specific data required.

Environment: .net Technology, SQL Server 2012(Management Studio).

III. Project: Bell Funds (Bell Canada)

This project involves creating an application for Bell Canada to maintain their new products Bell Funds. I am

working on the Microsoft CRM 2013 online which will support the database of the Bell Funds application.

Responsibilities:

• Creating custom entities, fields and forms.

• Creating custom plug ins using IFrames

Environment: .net Technology, Microsoft CRM 2013 online, xRM Framework, Telerik UI.

B. AMA Inc, Mississauga, ON, Canada. November 2013 – April 2014.

Role: Developer: Project: Marketing Engine for Wi Fi Hotspots

This project involves development and deployment of an online Wi Fi portal for business owners which will

implement a business strategy helping them to grow their business. This project represented AMA Inc. and

Humber College at an event at CBC News, Toronto, on 14th of May 2014.

Responsibilities:

• UI designing & developing, Coding, Hardware configuration, Architecture designing & Testing.

• Preparing Business Requirement Document, System Architecture diagrams, Project Charter, Test Case and

Software Development Document. Presentation at CBC event.

Environment: .net Technology, PHP and Linux. Hardware: Enterasys HiPath Wireless C20 Controller, Enterasys

HiPath AP3610 and TRENDnet Router. Software: Windows Server 2008 R2.

C. Synergy Tech, Toronto, Canada August 2013 – May 2014.

I. Role: Junior QA Analyst; Project: OANHSS (http://www.oanhss.org/)

The OANHSS project comprised of testing of a web application of OAHNSS (Ontario Association of Non Profit

Homes and Services for Seniors) which will be used by business users and members of OAHNSS for various

purposes.

Responsibilities:

• Created Test Plane, Test Cases, conducted testing, tracked test results and bugs and accurately monitoring

and recording results in test documentation.

• Performed system, unit, acceptance, regression, load and functional/performance testing on application

using manual testing methods.

II. Role: Jr. Business Analyst; Project: Access Portal (http://www.accessportal.com/)

The Access Portal Project involves development and deployment of an online portal that will stream videos for

users to subscribe. This website will host educational videos for medical professionals.

Responsibilities

Developed Functional Specification Document. Demonstrated requirements by developing mock ups.

Responsibilities also included analysis of business and user needs, documentation of requirements, and

translation into proper solution or system requirement specifications . Conducted testing and documented test

results.

EDUCATION

• Information Technology Solutions, Postgraduate 2014

Humber Institute of Technology and Advanced Leaning, Toronto, ON, Canada

Bachelor of Technology in Electrical Engineering 2012

•

Techno India College Of Technology, Kolkata, WB, India

Diploma in Electrical Engineering 2009

•

Ramakrishna Mission Shilpapitha, Kolkata, WB, India

• Madhyamik/ 10th Standard/O Level (Equivalent) 2006

Bidhannagar Municipal School, Kolkata WB, India

PROFESSIONAL DEVELOPMENT

• Certificate in Business Analysis, Adita Executive Training, Toronto, ON, Canada.

• From NIIT: Diploma in Software Engineering.

• From IBM: Advanced Career Education: RDBMS Concepts and Oracle.

• From IETE: Vocational Training On PLC Concepts

PROJECTS (ACADEMIC)

Project #1 Developing of Solar Power Sales and Service web application in ASP.Net

• Developing an e commerce web application for solar powered products and solar panel, with On grid

and Off grid solar panel calculator. Features: user registration and email.

• Languages used – C# with entity framework 4.1; Server used – IIS.

• Project developed using – Visual Studio 2012 and SQL Server Management Studio 2012.

Roles & Responsibilities

• Project Management; Planning, designing, coding and testing.

Project #2 Developing of Information Technology Job web application in Java

• Jobs can be posted category wise and can be assigned to user who applied for the job.

• User can register to the site, view jobs according to category and apply to postings.

• Languages used Java and Oracle. Server used – Glassfish 3.

• Project developed using NetBeans 7.4, Eclipse, Oracle SQL Developer.

Roles & Responsibilities

• Planning, designing, coding and testing.

Project #3 Developing of Interactive Web application for Non prescription Drug in PHP

• The project is an e commerce web application for non prescription drugs, where user can find

medication according to disease symptoms. Features: PayPal and email.

• Three tier multithreaded application using PHP and MySql. Server used – Tomcat 7.0.

• Project developed using NetBeans 7.4, Xampp 5.3.

Roles & Responsibilities

• Team leader; Planning, designing, coding and testing.

VOLUNTARY WORK

• Trinita Children, Kolkata

I was involved in designing and developing website for Trinita Children, an NGO for the welfare of child

labours in Kolkata). I was also involved in various programs of welfare and education of slum children

including Asha for Education Project (http://www.ashanet.org/).

INTERPERSONAL SKILLS

• Analytical and excellent Trouble solver.

• Interactive and Fast Learner.

Excellent client communication and client handling capabilities.

•

EXTRACURRICULAR ACTIVITIES

• Photography, Travelling, Swimming, Snorkelling, playing Spanish guitar & Bass guitar.

• I was a bassist at a Bengali Rock Band.

LANGUAGES KNOWN

English: Fluent (IELTS 7.0), Bengali: Fluent (Native); Hindi: Fluent.

Contact this candidate