Sql Server Project

Kartik Chandra Biswas

System Developer (.net)

********@*******.***, ********@*****.***, ********@*****.***

LinkedIn: https://bd.linkedin.com/in/onsaurav

Phone: 347-***-****, +880**********, skype:onsaurav

Summary:

•Over 9 years of IT Experience in Software Design and Software Development of Microsoft .net Technology on various development, test and production environments with various business domains like ERP, Financial, Insurance, Microcredit and Manufacturing.

•Over 8 years coding experience in C# and Visual Basic.net

•Working in Visual Studio 2015, 2013, 2012, 2010, 2008, 2005 and Visual Basic 6.0.

•Team leading experience, leading development through SDLC including SCRUM or iterative waterfall

•Web Application Development (ASP.Net 3.5, 4.0, 4.5 With C#.Net, MVC, Razor, T4 Template & Scaffolding)

• Good knowledge and experience in Angular.js, Node.js, knockout, jQuery, AJAX, HTML5, Theme, Skin, CSS3.

•Experience in Windows Service and Web Service, Web API and Windows Service.

•Databases Designing (Microsoft SQL Server 20012/2008/2005, SQL Server Compact, Access, MySQL)

•Data Access Providers(Entity Framework Code First/Model First, Microsoft Enterprise Library Data Access, ADO.NET Entity Data Model, LINQ To SQL, ODP.NET, ODBC, OLEDB)

•Have experience building N-Tier applications.

•Have experience in the use of Design Patterns and SOA.

•Good experience in Crystal Report, RDLC and Microsoft SQL Server Reporting Service

•Windows application development (WPF, C#.Net, VB.Net, VB 6.0)

•Third Party Controls like Telerik, DevEx Windows Controls

•Integration of Social Networking Sites (Facebook, Twitter, LinkedIn, Google+)

•Google developers API (Google MAP, Searching, Analytic etc.)

•Source Control like Microsoft Team Foundation Server, Tortoise SVN, GIT, Visual Studio Source Safe 6.0

•Experience of working in the complete Software development life cycle involving development, documentation, testing, implementation and maintenance.

•Implementation of third party payment solution like PayPal, Payoneer etc.

•Good in Design the solution architecture from scratch, Class diagram and error handling.

•Hands-on experience and exposure to different phases of Software Development Life Cycle (SDLC), Agile and Scrum Methodologies.

•2 years’ Experience of SharePoint, development (site, web parts, timer job, workflow) and maintenance.

•Develop few web applications with AngularJS, NodeJS, KnockourJS and BackboneJS.

•Good Working Experience in MongoDB, Use MongoDB to manage Content Type Database.

•Develop Real time project with NHibernet.

•Excellent experience in onsite-offshore model interacting with clients and Onsite managers.

•Sound knowledge of Multithreading and Caching.

•Extensively worked on writing Stored Procedures, Triggers, Functions, Views and Database Design.

•Experience in software unit testing and efficient at fact-finding, root cause analysis and bug-fixing.

•Created and maintained SSIS packages to Import/Export data from flat files, XML, Excel and Oracle.

•5 Years working Experience of WPF and XAML technology. Good experience in User control and Data binding in WPF.

•Strong knowledge in Windows Phone Apps development for Windows phone 7.5, 8.0, 8.1 and 10.

•Windows Apps (Universal Apps) Development for Windows 8.0, 8.1 and 10.

•Good working experience in LINQ handle big data and store procedures using project by LINQ.

•Very Good experience in Entity Framework 4, 6.

•Real time project developed by WPF with MVVM design Pattern.

•Working experience in PRISM pattern implemented in working project.

•Good working experience in IIS to manage and publish Web sites and services.

•Experienced in Agile development and very familiar with scram.

•Error handling with log4net, and windows Event viewer, Good knowledge about Garbage collector and .net exceptions.

•Source controlling experience in Visual Studio TFS 2010, 2012.

•Manage Source by GIT and SVN.

•Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.

•Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2012/2008/2005/2000.

• Highly proficient in Tuning SQL queries and improving the query performance.

• Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.

•Created various Complex Formula Reports to query the database for business Intelligence.

•Experience in deploying created reports in various sources like Web browser, XML and PDF.

•Working experience with Web application security.

Educational Qualifications:

Masters in Computer Science, Jahangirnagar University

Bachelor of Engineering in Computer Science Engineering, State University of Bangladesh

Technical Expertise:

Languages

C#, VB.net

Web Application Development Technologies

ASP.NET, ASP.NET MVC 3,4,5,6, SharePoint, JQuery, AngularJS, NodeJS, Backbone.JS, Ajax, Web Service, WCF, Web API, Silverlight, JavaScript, HTML5, CSS3

Web application platform

SharePoint 2007, 2010, and 2013

Desktop Application Development Technologies

Windows Forms, WPF

Mobile Application

Windows Phone 7.5, 8.0, 8.1, 10.0, Android

Windows Apps

Windows 8.0. 8.1, 10 (Universal Apps)

Design & Architecture

Design patterns, SOLID, Agile Methodology, OOP

IDE

Visual Studio 2008, 2010, 2012, 2013, 2015

CMS

InsiteCreation (ASP.NET), DotNetNuke.

Databases

MongoDB, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, SQL Server 2012, SQLite, MySQL, MS Access

Others Technology

ADO.net, LINQ, Entity Relationship Framework. NHibernet, MVVM, PRISM, MEF

Analysis/Reporting Tools

Crystal Report 8.5 to 11, RDLC (Visual Studio) SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

Error Logging

Event Logging, Log4net

Source Control

GIT, SVN, TFS (VS 2010, VS 2013), Visual Source Safe 6.0

Professional Experience:

SoftwarePeople AdPeople

Senior System Developer

Address: Plot-76/A (3rd Floor), Road-11, Block-M, Banani, Dhaka-1213, Bangladesh

Phone: +88-02-881-****, +88-02-881-**** Web: www.softwarepeople.biz

Duration: Sep-2014 to Continuing

Responsibilities:

Working with SharePoint 2010, Manage and Development SharePoint Application ( Timer Job, Workflow, Web part, and Enhanced Site with Asp.net, C#)

Working with Active directory to manage Huge User Profile.

Working with Centrify Profile to manage Users of Active directory in Linux and Mac.

Implement Design Patterns in Project Backend Architecture.

Working in Agile mythology.

Involved in complete Life Cycle including Analysis, Design, Development and Testing.

Developed modules of the application in ASP.NET and involved in writing C# classes.

Used Web services to communicate with the business layer objects.

Created and worked with dependency, attached and complex properties and plugged them into different WCF services.

Involved in Programming XAML applications.

Coding the presentation layer using WPF and silver light and service layer using Windows Communication foundation technology.

Creating custom site pages, lists, views and master pages and adding ASP, Silverlight controls.

Developed WCF services to enable effective communication between SOA.

Accessing SQL Server 2008 from a Asp.net application using WCF.

Implementing LINQ queries on different data sources in WPF applications.

Worked with Ajax enabled WCF services using C# and ASP.Net.

Access ASP.Net WCF services from Silverlight applications and implement AJAX script to handle Silverlight events and manipulate Silverlight controls.

Used WPF in creating different animated scenes using the combination of transforms, animation controls (storyboard, double animation) and color effects.

Implemented WPF in creating custom controls, 3D graphics.

Working with MongoDB and NHibrneth.

R&D about new modifications and technology and implement in the project

Team meeting and Explain new or implemented technology

Motivating other team meets

The Databiz Software Limited

Senior System Developer & Team Lead (Asst. Manager)

Address: House No. 163 (4th Floor), Road No. 3, New DOHS, Mohakhali, Dhaka-1215

Phone: +880-2-8714185-6, Fax: 880-*-*******

E-mail: ****@***************.*** Web: www.databizsoftware.com

Duration: December 2011 to August 2014

Responsibilities:

Coding design and development desktop and web application with C#, WPF, ASP.net, MVC, Web service etc

Client Side UI design and development with AngularJS, NodeJS with MVC

Component-based development of products related to document processing, indexing and archiving

Technical architecture and UI Design

Finding, interviewing IT specialists, managing team co-operations

System administration, based on virtual servers: W2k3 Domain Controller, SharePoint, Project Server 2007, Team Foundation Server 2005, StarTeam

Training, contacting to end-users, approving business requirements, participating in exhibitions

Searching, implementing 3rd party components, managing relationships with partners

Implementing intranet web portal based on Sharepoint Portal 2007

Project management, requirement management, task management, follow-up activities

Designing user interface

Fixing bugs

Code review

Managing team of developers

The Databiz Software Limited

System Developer

Address: House No. 163 (4th Floor), Road No. 3, New DOHS, Mohakhali, Dhaka-1215

Phone: +880-2-8714185-6, Fax: 880-*-*******

E-mail: ****@***************.*** Web: www.databizsoftware.com

Duration: January 2008 to December 2011

Responsibilities:

Design Modules From Scratch, for user Interface, User controls and Database also.

Coding in C# and VB.net

Desktop Application Design UI with Win Form and WPF

Develop Web Application With ASP.net MVC 3.0 & 4.0

Develop Web Application by ASP.net

Database Design and Create database, Diagram, Store procedure, Functions.

Created the Custom User Grid View Control which includes the Sorting and Paging.

Used Dataset, Data View and Data Adapter to manipulate and display data.

Involved in relational database diagram design and Tables design in SQL Server.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL Server.

Involved in Unit testing and Bug fixing.

Involve in creating the read only API’s application for other applications.

Ingenuity around creation of reusable objects and engines

Facilitated problem solving and collaboration

Help keep the other application developers to use this RBAC model in their application.

Introduce and Implement New Technology.

The Databiz Software Limited

Intern .net Developer

Address: House No. 163 (4th Floor), Road No. 3, New DOHS, Mohakhali, Dhaka-1215

Phone: +880-2-8714185-6, Fax: 880-*-*******

E-mail: ****@***************.*** Web: www.databizsoftware.com

Duration: June 2007 to December 2007

Responsibilities:

Coding in C#, VB.net And Visual Basic 6.0

Manage Data with MySQL and SQL server 2002

Working in Crystal Report

Fixing bugs

Develop new features

Project Experience:

Name of the project: Brand Share

Team Member: 20 (including me)

Supervisor: 3

Project Description: A total advertisement and company branding system. DELL is one of the users of this system. (www.delshare.com)

Technology used:

SharePoint#, ASP.net, WCF, AngularJS, CrystalReport, Active Directory, SqlServer 2008

My Role: Team leader & Lead Developer

Name of the project: My Note

Team Member: 2 (including me)

Supervisor: 1

Project Description: A basic daily note management system for windows phone.

Technology used:

C#, XMAL, SQLite

My Role: Team leader Technical Analyst and Lead Developer

Name of the project: Hotel Trip

Team Member: 7 (including me)

Supervisor: 1

Project Description: Total CMS base online Hotel Management System. Developed by MVC(Razor) and Entity Relationship Framework.

Technology used:

C#, MVC (Razor), JQuery, Entity Relationship Framework, HTML, CSS, JavaScript, Ajax, SQL Server 2012

My Role: Team leader Technical Analyst and Developer

Name of the project: Business Roots

Team Member: 7 (including me)

Supervisor: 2

Project Description: This application is a type of business automation (ERP) with a larger scope. It does as usual an inventory, Stock, Import, Accounts, HR, Replacement system do but with a better performance and extra features.

My role: Team leader and Developer

Technology used:

C#, ASP.NET, JavaScript, HTML, CSS, Ajax etc

SQL Server 2008

Crystal Report

Name of the project: SMS Base Order Processing System and Dealership Maintenance

Team member: 1 (Just me)

Supervisor: 1

Project Description: This is a type of business intelligence software which is very dynamic and will be very handful to the clients.

My role: Software architect, Developer

Technology used:

C#, Windows Forms, WPF

SQL Server 2008

Name of the project: Ration Management System for Bangladesh Police

Team Member: 1 (Just me)

Supervisor: 1

Project Description: This application developed for Bangladesh police for Ration management.

My role: Software architect, Developer

Technology used:

C#, WCF, JavaScript, HTML, CSS, Ajax

SQL Server 2005, LINQ, Crystal Report

Name of the project: Order Management System for Buying House

Team Member: 3 (including me)

Supervisor: 1

Project Description: This application is developed for buying house for Order processing, monitoring, inspection and order shipment. It developed for both web and desktop.

My role: Software architect, Developer and supervisor

Technology used:

C#, ASP.NET, WCF, JavaScript, HTML, CSS, Ajax

Windows Forms

SQL Server 2008, LINQ

Crystal Report

Name of the project: ERP Solution

Team Member: 7 (including me)

Supervisor: 1

Project Description: This application is ERP system which is divided into few modules like inventory, stock, accounts, replacement etc.

My role: Developer

Technology used:

VB.net, Windows Forms

SQL Server 2005

Crystal Report

Name of the project: PMS (Personnel Management System)

Team Member: 4 (including me)

Supervisor: 1

Project Description: This application is Personnel Management System which is divided into few modules like Attendants, Leave, Loan, Overtime, Production, Provident Fund, Shift etc.

My role: Software architect, Developer

Technology used:

C#, Windows Forms

SQL Server 2005

Crystal Report

Name of the project: Service

Team Member: 3 (including me)

Supervisor: 1

Project Description: This application is a SERVIC maintenance system for hardware house.

My role: Software architect, Developer

Technology used:

VB.net, Windows Forms

SQL Server 5

Crystal Report

Name of the project: Retail

Team Member: 3 (including me)

Supervisor: 1

Project Description: This application is a POS system with stock.

My role: Software architect, Developer

Technology used:

C#, WPF

SQL Server 2008, LINQ

Crystal Report

Name of the project: Call Center

Team Member: 2 (including me)

Supervisor: 1

Project Description: This application is Call center Management System with auto alerting

My role: Software architect, Developer

Technology used:

C#, WPF

SQL Server 2008, LINQ

Crystal Report

Name of the project: E-mail base alerting system

Team Member: 2 (including me)

Supervisor: 1

Project Description: This application is a module of ERP by which the management gets the mails with different type of business analysis and reports.

My role: Developer

Technology used:

C#, WCF

SQL Server 2000

Crystal Report

Name of the project: University Management System

Team Member: 3 (including me)

Supervisor: 1

Project Description: This application is a complete university Management System.

My role: Developer

Technology used:

Visual Basic 6.0

SQL Server 2000

Crystal Report 8.5

Senior .NET System Developer, Mail: ********@*******.***, Skype: onsaurav, Phone: 347-***-****, +880**********, LinkedIn: https://bd.linkedin.com/in/onsaurav

Contact this candidate