Sql Server Data

Palash Chaterjee

**** ******** ****** ****

Toronto, Ontario, M1T3S8, Canada,

Phone 1-647-***-****

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

OBJECTIVE

A challenging position as a Dot Net Developer

Nationality: Canadian

CAREER HIGHLIGHTS

More than 6 years of experience mostly in web-based, intranet and Console application development

Expertise in all the phases of Software Development Life Cycle (SDLC) including Requirement gathering, Technical Analysis, Design, Implementation, Integration, Testing, Deployment and maintenance

Expertise in .Net framework with proficiency in creating applications using ASP.Net Web Forms, C#, ADO.Net, XML, AJAX Control Toolkit with Triggers, Cascading Style Sheets (CSS), JavaScript, WCF, IIS6.0, JSON for data transferring.

Experience in working with IIS, created and configured the applications for domain authentication.

Strong experience in developing Stored Procedures, Functions, and Triggers, Cursor for the implementation of data integrity using T-SQL, SQL Server.

Academic knowledge of MVC 4 with Razor View

Good knowledge of Visual Basic 6.0

Expert knowledge of Crystal Report (also Sub-Report) with PDF generation and SSRS

Solid understanding of design pattern (Factory)

Very strong OOP design abilities, SOA architectures

Solid experience in architecting of enterprise level and 3-layered systems (GUI, Business & Data Access)

Microsoft Certified Professional(MCP)

Worked extensively with Iterative Agile Methodologies (SCRUM), Waterfall

Good communication, interpersonal and presentation skills and excellent work ethics, self-motivated and quick learner, willing to learn, adapt new technologies.

Key technical proficiencies include… [Y – Years’ of hands-on experience]

ASP.NET Web Forms 4.0,3.5 and 2.0

6 Y

Visual Studio (2003/05/08/10/12)

6 Y

C#, ADO.Net

6 Y

XML

2+ Y

LINQ 3.5 with VS 2008

5 M

Crystal Report 8 & 10

4 + y

SQL SERVER 2000/05/08

6.5 Y

JavaScript

5 Y

Web Service

3Y

jQuery 1.3.2.min plug-in

6 months

Source Control (VSS 2005,SVN & TFS)

5 y

WCF

1 Y

IIS ( Creating virtual directory, making folder permission of the working folder etc)

5y

Visual Baisic 6.0

5Y

TECHNICAL EXPERTISE

Languages: C#, VB.Net, SQL/T-SQL, XML, JavaScript, HTML/DHTML, VB6,

Technologies and APIs: ASP.NET 4.0/3.5/2.0/1.1, MVC 4, AJAX, SOAP, JSON, WCF, WEB SERVICE

DBMS: SQL Server 2008/2005/2000 (Complex T-SQL using Stored Procedures, User Defined Function, Trigger, Cursor, User Defined Table, Table Variable)

Platforms: Server 2008/2003/ Win XP, IIS7/IIS6

Tools: Visual Studio 2012/2010/2008/2005/2003, SQL Server Reporting Services, TFS, Visual Source Safe, GIT

Reporting Tools: Crystal Report 10 and Sub Report, SSRS in ASP.Net web application.

CMS Tools: Telerik Rad Editor and FCK Editor Controls.

PROFESSIONAL EXPERIENCE

January 2015- present

Software Developer in Flextrack

At present I am working on a Web application. The domain belonging to a VMS (Vendor Management System) which is managed by a MSP (Manage Service Provider). The application mainly covers the whole recruitment process which includes Timesheet of the contractor.

Working Asp.Net, C#

Debugging the application if any bugs comprises in production.

Working on enhancing modules.

Working heavily on the database with TSQL and Data fixing in the database.

July 2014- December 2015

Contractor for RBC in Capital Markets and Financial Technology, Toronto

I was involved in a Web Portal and Console application. The project had two parts, one was file loading form CSV, Excel files, reading a WCF service into a database. After loading into a database, business rules are applied and finally generate the posting or output files as data feed for other software services. In the Web portal, business users view those output files. Also they configure data through pages /screens. There were Management Information Reports which exists in the portal. All these reports were implemented through SQL Server Reporting Tool and integrated in Asp.Net application which were converted into PDF or Excel file format.

Worked with User Controls, Validation Controls and AJAX Control Toolkit. For example, Ajax Data Picker, Light Box and Pop-Up Extender, Update panel and Ajax Trigger in Asp.Net Web Forms.

Used Style sheets and Master Pages for achieving uniformity throughout the application

Used LINQ for data manipulation.

Factory design pattern has been applied.

DDL commands are written for building tables, Setting Indexes and applied constraints and DML scripts are written using Stored Procedure, Views, User Defined Functions.

Wrote Class files in C# for various modules. Used ADO.Net (Data Set, Data Reader, Data View etc) in database access component. Used Array List and Generics.

Managed Exception Handling through custom Log file in ASP.Net Web Forms

Managed Load balancing of session state management through Out-Proc.

Met tight deadlines and delivered the project and support QA bugs.

Helped Business Analyst to prepare mockup template of the web portal and technical document.

Tools and technologies used: Framework 3.5 with Visual studio 2008, ASP.Net 3.5, C#, T-SQL, SCM,OOP principles, SQL Server Service

Jan 2012- May 2014

Contractor for AGCO (Alcohol and Gaming Commission of Ontario),

Toronto

I was involved in support and implementation of the web application project. Worked on the project independently.

Implemented various kind of Asp.Net web forms where user inputs data and after that generating it into a PDF file using Crystal Report and Sub Report which is embedded in Asp.Net web application for preparing legal documents. The project contained various permission level settings. C# has been used to develop all kinds of business logic functionality.

Worked with User Controls, Validation Controls, various kinds of server controls for example Grid View, Data List, Repeater etc . Also used various kind of Ajax controls for example Ajax Data Picker, Pop-Up Extender, Update panel and Ajax Trigger in Asp.Net Web Forms.

Used Style sheets and Master Pages for achieving uniformity throughout the application.

Helped application architect with the time estimation and implement various modules.

Three layer architecture has been followed.

DDL commands are written for building tables, Setting Indexes and applied constraints and DML scripts are written using stored procedure, Views, User Defined Functions.

Wrote Class files in C# for various modules. Used ADO.Net (Data Set, Data Reader, Data View etc) in database access component. Extensively used Array List, Generics List Class display data in the grids

Managed Exception Handling through custom Event-Log in ASP.Net Web Forms

Managed Load balancing of session state management through Out-Proc.

Performed unit testing and coordinates various test cases with Quality Assurance Specialist.

Prepared project technical document.

Tools and technologies used: Framework 4.0 with Visual studio 2010, ASP.Net, C#, T-SQL, TFS,OOP principles, Crystal Report

Dec 2010 – Oct 2011

Software Developer, Channel Assist, Vaughan Ontario

Channel Assist was a software consulting company involved in PRM (Partner Relation Management) customized systems.

Projects executed under Channel Assist:

GP8 Sports Water Toronto http://www.gp8.ca/

Involved in Software Development Life Cycle for example Requirement gathering, Capturing requirement, preparing technical documentation,, Data Inputs and Outputs, ER Model, Sequence diagram, Assumptions, Constraints and developed full E-Commerce web application.

Designed the Database, Integrated mockup interface or HTML templates to fit into Asp.Net web forms, Replace HTML controls to server controls, wrote business logic, debugging and unit testing. Also promoted to staging and live server and provided support on that system.

Created WCF Services responsible for communicating and to feed data to other client application

Integrated Payment Gateway by PayPal in the E-Commerce Shopping Cart application for managing online payment using Credit and Debit card.

Implemented Content Management System through Telerik Rad Editor Control and various management information

through Telerik Chart Control.

Wrote DDL and DML scripts, Stored Procedure, Views, Table Variable, Temporary Table, User Define Function, Trigger and Cursor and validation logic in MS SQL SERVER 2008 database

Roger’s Communication Toronto, Canada http://www.rogersalliancelink.com/

Rogers Alliance Link was one of the leading rewards program in the industry and it was implemented for Rogers Communication. Helped in managing Partner Relationship Management by measuring Partner performance, educating partners, rewarding partners and communicating with them.

My role was involved in multilingual (French as well as English) functionalities throughout the web site and also the data exist in the web site as well.

Tools and technologies used: ASP.NET, C#, WCF, JavaScript, jQuery, SOAP, IIS, HTTPS, UML, MS Visual Studio.NET 2008, Framework, SQL Server 2008, TFS

Nov 2008 – Aug 2010

Software Engineer, MSR IT Solutions, United Kingdom

MSR is a multinational software consultancy company.

Projects executed under MSR Private Limited:

Fresh Corporate Calgary, Canada (www.freshcorporate.ca)

Worked on the E-Commerce application. Designed the shopping cart system. Implemented CMS, Image Gallery,

Text Sizer features

Prepared ER and Process flow diagram of the technical documentation.

Performed data components and database design

Integrated HTML templates into .Net web application.

Created classes and applied OOP principles

Wrote DDL and DML scripts

Architected Admin and Client Part

Implemented content management solutions (CMS) in the above application

Wrote Unit test and interacted with QA team to support testing

Waldner Laboratory Wangen, Germany (www.colaborate.biz)

This was a Web Service driven application. The web site consist of two parts one to show the outputs in Adobe Flex with three dimensional images dynamically based on some Mathematical calculation and this processed by consuming Web Service. Again from Adobe Flex end, some finished data were transmitted through the web services which is stored in the database vice versa.

Created core web service component and hosted it.

Consume SAOP web service using .Net via Request and Response mechanism

Wrote DML scripts and stored procedure, user defined function using SQL Server.

Refactored existing classes

Incorporated on enhance functionalities

Performed Unit and Integration test with Q&A team

Tools and technologies used: ASP.NE 2.0, C#, Web Service Visual Studio.NET 2005, Red Gate Tools, MS Visio,Viusal Source Safe

Aug 2007 – Nov 2008

Web Developer, Mass Software Solutions, Kolkata Area, India

Massoft is an offshore based web designing consulting company. They provide solutions on E-Commerce, website maintenance, custom web development.

The key responsibilities were to design and implement web enterprise n-tier applications, architect the solutions, enhance and support existing applications, followed standardize common design patterns for the web application, write unit tests, create technical documentation, be involved in all parts of SDLC. Other than the projects listed below also constantly involved in various architectural discussions for many other projects executed by our department.

Developed various kind of web application mainly E-Commerce, CMS based applications

Developed UI pages (Asp.Net Web Forms) and server controls using AJAX technology

Provided solutions and designed optimization features and reusable modules

Wrote business logic and debugging

Implemented bulk images upload, ‘Text Sizer’, Image Gallery, News Letter

Integrated various payment gateway in different Shopping Cart Application (e.g. PayPal, Moneris)

Created database structures and populated of data

Prepared and coordinate internet website changes.

Supported in the production server in against of tickets and interacted with QA team to support testing

Tools and technologies used: ASP.NET 2.0/1.1, C#, JavaScript, T-SQL, SOAP, AJAX, Atlas framework, UML, MS Visual Studio.NET 2005/2003, MS Visio Enterprise Architect, MS Enterprise Library, SQL Server 2000, IBM DB2 8.1, VSS,

Prior to Aug 2007, I was working Visual Basic 6.0, ADO, ActiveX Control and MTS (Microsoft Transaction Server)

ACADEMDIC EDUCATION

Bachelor Degree in Arts3 years from Calcutta University, India

PROFESIONAL QUALIFICATION

PDCST(Professional Diploma In Computer Software Technology) 2 years Full Time from ET&T Government of India (Under the Ministry of Information Technology)

CERTIFICATES

Microsoft Certified Professional (MCP) on Designing and Implementing Desktop

Applications and Distributed Applications with Microsoft Visual Basic 6 exam (70-176 & 70-175)

‘Programming In C’ Certificate From Brainbench

REFERENCES

Available upon request

Contact this candidate