.Net Sql Server Service Management Project Engineer

Biswajit Bora

Summary

> B. Tech with * years of industrial experience in ASP.Net, WinForms, C#,

VB.NET, Web Services, Windows Service, Crystal Reports, Oracle & MS SQL

Server.

> Experience in various N-Tier business applications' Design, Development,

Testing, Documentation and Implementation.

> Experienced in developing application with Object Oriented Design,

Service Oriented Architecture (SOA), and MVC (MVC Framework) Architecture

using Factory and Singleton patterns.

> Experience of working in domains of content management web site,

enterprise-wide project management on web.

> Experienced in using Microsoft Membership API for security.

> Experienced in working Multilingual Application using .NET Culture Info.

> Worked extensively on .NET Framework (3.5, 2.0 & 1.1), ASP.NET, AJAX.NET,

WWF, WCF, Silverlight, ADO.NET Data Service, Windows App, Windows

Service, Web Services, SOAP, LINQ to SQL, C#, XML, XSD, XSLT, XPath, Java

Script, jQuery, CSS, MS SQL Server, ORACLE 10g, TOAD, DevParnter, FxCop,

Nunit, SSIS Package (ETL-Tool), Crystal Reports, IBM-MQ, Microsoft

Application Blocks.

> Worked in Visual Studio 2008 using AJAX framework.

> Experience in SQL, SSIS Package, T-SQL for writing complex Stored

Procedures, Triggers, Functions, worked on Table and Index creation

scripts, knowledge of DB Backup Restore Plan.

> Main areas of expertise also includes analysis and designing application

architecture using Use Cases, Class Model diagrams, work flow for

business functionalities (Sequence Diagram) and other software

engineering concepts and models using Visio and Enterprise Architect.

> Good hands on development tools like MS Visual Studio, Visio, SQL Server,

VSS, Enterprise Architect, TFS, Lotus Notes, MS Office and many.

> Ability to handle project, learn quickly and Deliver under pressure.

> Actively involved in Client interaction for design and requirement

gathering.

> Involved in writing Unit Test Plan, Functional Test Plan and End to End

Test Plan.

> Domain expertise in Finance, Telecommunication and Logistics.

Education

B. Tech: National Institute of Technology Rourkela (INDIA)

Skills

Technologies VS.NET 2008, 2005 & 2003, MSSQL-Server 2008, 2005 & 2000,

ASP.NET, Windows Workflow, WCF, Silverlight, ADO.NET

Data Service, Generics, SSIS Package (ETL-Tool), IBM

MQ, Windows Application, Windows Service, Web

Services, ADO.NET, SQL-DMO, XML, DOM, Crystal

Reports, AJAX.NET, CSS, Expression Blend 2, Nunit,

MQC.

Programming Languages C#, VB, CSS, JavaScript, jQuery, HTML, XML, DHTML,

C++, SQL

Reporting Tools Crystals Reports 9 & 10, DevPartner, FxCop, NUnit.

Design Tool Visio Enterprise Edition, Enterprise Architect

Design/ Architecture Skills UML, Design Patterns (Creational (e.g.

Factory, Singleton)), OOAD

Controls Component One Studio .NET Controls, ChartFx

Operating system Windows 2000, XP Professional, 2003

Configuration Management TFS, VSS, Harvest and CVS.

Experience

Sep 2009 - till date. Wells Fargo Advisors, US

(https://www.wellsfargo.com//)

Project: BMAP

Tech Lead

BMAP is a web-based application available through the WFA Smart Station and

Wisdom portals that is utilized by various WFA business channels for the

purpose of capturing and maintaining critical branch and sales hierarchy

information and related attributes for each WFA sales channel. This branch

and sales hierarchy data is stored in the Operational Data Store (ODS) and

Brokerage Data Warehouse (BDW) common data repositories and available for

usage by 100+ WFA downstream applications and services. The purpose of the

Wells Fargo BMAP Scalability and Integration project is to implement

application updates to allow the application to scale to handle the

addition of new WFA channels (WBS, HDVest & DFS) and increased data related

to the Wells Fargo Merger. The scalability work will result in decreased

risk to other channels, reduced testing and development times, and lower

project costs when changes are required for one or more channels.

Responsibilities:

> Analysis and refinement of functional requirements by closely interacting

with user.

> Actively involved in design and development of the Host application.

> Designed and developed the channel application for WBS (Wealth Brokerage

Services) and guided the offshore team for the development of the rest of

the channel applications based on this.

> Prepared Use Cases for various functionality for channels PCG, DFS, WBS,

LA, HDVast, FINET, FCCS along with the Host application based on the

available Business and Functional requirement documents.

> Responsible for code review and code quality assurance for the offshore

team. Used Dev Partner to enforce coding and design standards defined by

the architecture team.

> Prepared the Class, Use Case and Sequence diagrams for all the channels

along with the host application using MS Visio.

> Used Windows Communication Foundation to communicate with the AEE

Entitlement Service to retrieve user Entitlements.

> Implemented Custom Action for the Web Installer to copy config files from

one virtual directory to another.

> Implemeted OutProc session management using SQL Server 2008.

> Used multiple HTML Frames to host the channel specific application inside

the Host Application.

> Extensively used Web Service, T SQL Queries for request and response

processing.

> Used Oracle Client/TOAD for communicating with ORACLE 10g database.

> Have written complex queries using SQL and PL/SQL.

> Managed Issue Tracker (bug tracking tool) and Change Management in Share

Point.

> Created and executed unit test for all the channels using NUnit.

> Supporting System Testing, End to End Testing, and Load and Performance

Testing.

> Used CVS and Harvest for Source Configuration Mangement.

> Worked in a dynamic, multi-tasking and pressurized environment and

delivered work items successfully.

Environment: Visual Studio 2008, C#.NET, ASP.NET, AJAX.NET, Web Installer,

JaveScript, Windows Communication Foundation, LINQ to Object, SOAP, Windows

Service, ORACLE 10g, TOAD, SQL Server 2008, DevPartner, NUnit, Crystal

Reports, Agile Process, Harvest, CVS and MS Visio.

Dec 2007 - Aug 2009. Sprint, US

(http://www.Sprint.com/)

Project: CAPT

Lead .Net Developer

Cable Automation Provisioning Tool, CAPT is a provisioning tool which takes

order from cable partner and processes it. CAPT uses Web application, Web

Services, Windows services and SSIS packages to process an order. CAPT

receives order through web based interfaces and drop order to CAPT for

provisioning. Orders are passed through various provisioning group for

validation before completion. Validations are done via SSIS packages or

windows services.

Responsibilities:

> Led a team of 5 offshore developers.

> Analysis and refinement of functional requirements by closely interacting

with user.

> Preparing detail design document and other related artifacts (e.g. ADD

for CSR, DLI, DSR, LSR, NPO process).

> Made a series of sequence diagrams for NPO using Visio.

> Allocate work to both onsite the offshore team member and guide them

through out the development towards the smoother end to end testing.

> Development of application related to products CSR, DLI, DSR, LSR and NPO

with backend integration with MS SQL Server/Web Service along with unit

testing using agile process and best practices.

> Implemented ADO.NET Data Service using ADO.NET EDM (Entity Data Model)

for data accessing in Silverlight application. Also worked on Isolated

Storage for storing data while switching between pages.

> Used Expression Blend 2 for GUI design specially for designing Storyboard

and Key Frames.

> Use of various ASP.Net Server Controls, HTML Controls, CSS, JavaScript

Validations, Navigation Controls, Master Pages etc.

> Extensively used Windows Service, Web Service, SQL Stored Procedure,

Functions and IBM Message Queue (MQ) for request and response processing.

> Used SQL Server Management Studio and Profiler for Store Procedure

performance enhancement. Involved in optimization of Relational Database

model using Normalization steps like creating foreign key and table

indexing.

> Used Windows Workflow for validations at various order processing stages

in PreDB validation module.

> Used SSIS package (ETL-Tool) to covert SPID DB2 data to Sprint lkSPID

table format.

> Use ADO.NET and MS Enterprise Library for communicating with SQL Server

2008 database.

> Experienced on creating Crystal Reports, sub-reports, grouping,

formatting, formulas, graphs etc.

> Managed Issue Tracker (bug tracking tool) in Share Point.

> Preparing Functional Test Plan.

> Supporting System Testing, End to End Testing, Cable Partner Testing and

Load and Performance Testing.

> Supporting product deployment to real time environment.

> Use of Microsoft TFS for managing source code.

> Proficient with Lotus Notes and MS Office.

> Worked in a dynamic, multi-tasking and pressurized environment and

delivered work items successfully.

Environment: Visual Studio 2008, C#.NET, VB.NET, ASP.NET, AJAX.NET, JQuery,

Silverlight, Expression Blend 2, ADO.NET Data Service, Windows Workflow

Foundation, Windows Communication Foundation, LINQ to SQL, SSIS Package,

Relational Database, IBM MQ, Web Service, SOAP, Windows Service, SQL Server

2008, Crystal Reports, Agile Process, TFS (Team Foundation Server).

Jan 2007-Dec 2007 Merrill Lynch, US

(http://www.MerrillLynch.com)

Project: RIS AUCN Dashboard (Retirement Income Service)

Senior .Net Developer

RIS AUCN Dashboard is meant to provide a web based interface for Merrill

Lynch investors to keep track of their investment and income in ML. This is

basically meant for the retired individuals, who invested on Merrill Lynch.

It will also facilitate auto continuation for a particular policy without

the hassle of manual rework.

Responsibilities:

> Analysis and refinement of system requirements document by closely

interacting with onsite team.

> Played the role of coordinator with the onsite team and accordingly

knowledge transfer and work distribution within the offshore team.

> Preparing detail design document and other related artifacts (e.g. UI

Spec, Workflow) using Visio.

> Development of application.

> Extensively used AJAX.NET to make the web interface much faster and

callbacks for asynchronous communication.

> Use of various ASP.Net Server Controls, HTML Controls, Validations,

Navigation Controls, Master Pages etc

> Used Service Oriented Architecture (SOA) for data retrieval.

> Used ChartFx object to display graphical representation of number of

order that is currently at particular stage.

> Used Crystal Report for generating report of cash inflow and outflow

based on user input.

> Extensively used SQL and T-SQL for writing stored procedures, triggers,

creating tables and indexes, creating backups and restoring DB.

> Use ADO.NET for communicating with SQL DB.

> Have written complex queries using SQL and PL/SQL.

> Managed Issue Tracker (bug tracking tool) in Share Point.

> Preparing Functional Test Plan.

> Incorporated Nunit test cases.

> Offshore support during UAT phase for related work products.

> Proficient and well versed with other processes involved in management

reporting and other CMM-I level 5 processes.

Environment: Visual Studio 2005, VB.NET, ASP.NET, Web Service, Visio 2003

SDK, Oracle 9i, AJAX.NET, XML, XSLT, XSD, XPath, Chartfx, SQL Server 2005,

Crystal Reports, Java Script, CSS, JSON, Nunit, VSS (Visual Source Safe).

Mar 2006 - Dec 2006 Fritz Institute, US

(http://www.fritzinstitute.org)

Project: Helios (Supply Chain Management & Logistics)

Software Engineer

Helios is meant to provide a web based Logistics Software for Organizations

that perform logistics of Items. It is a tracking system that will help

Humanitarian Organizations to manage the goods for tracking purposes. This

system will be used to track goods starting from Creation of Project/Appeal

to the first receipt of goods. It is a more comprehensive system that

supports additional areas such as extended Delivery Points and also certain

capabilities such as offline tracking and periodic synchronization of data.

Responsibilities:

> Analysis and refinement of system requirements document by closely

interacting with onsite team.

> Development of horizontal prototype.

> Preparing detail design document and other related artifacts (e.g. UI

Spec, Workflow).

> Development of application, related to module Warehouse.

> Allocating work for various team members and guided them throughout the

process.

> Extensively used Java Script for the GUI.

> Extensively used Crystal Report for generating warehouse specific report

generation.

> Used Satellite Assemblies, Resource Manage and Resource file to maintain

GUI pages with respect to user Culture.

> Used Microsoft Data Access Block for the DAL layer of the three tier

architectural application.

> Used SQL Server Import and Export features for data conversions.

> Preparing Functional Test Plan.

> Offshore support during UAT phase for related work products.

> Proficient and well versed with other processes involved in management

reporting and other CMM-I level 5 processes.

> Extensive interaction with the whole team for knowledge transfer and

effective communication of work items.

Environment: Visual Studio 2003, C#.NET, VB.NET, ASP.NET, SQL Server 2000,

Crystal Reports, Visio 2003 SDK, SQL Server 2000, VSS (Visual Source Safe).

Sep 2005 - Feb 2006 Message Pad Limited

(http://www.message-pad.com)

Project: Message Pad, the Message Pad Limited

Software Engineer

The project is about maintaining client's information and providing various

kinds of supports. The client's data is stored in a SQL Servers. ASP.NET is

used to facilitate the user interface part using VB. Windows service is

used for import, export of data, creation of table and its relations using

SQL-DMO.

Responsibilities:

> Understanding the business flow of allocated modules by having

discussions with client.

> Finalizing the design flow of iDataTableRelation (one of the module) and

creating the Use Case Diagram, Class Diagram and Sequence Diagram for the

same module using Enterprise Architect.

> Designing the UI part for Table Relationship module.

> Development of horizontal prototype.

> Used Custom Data Grid and Typed Dataset.

> Preparing LLD (e.g. UI Spec, Workflow), Unit Test Plan and Functional

Test Plan.

> Development of application, related to module iData Table Relationship.

> Used XML Libraries and object from XMTextReader to XMLDocument to

exchange business data between organizations using XML.

> Offshore support during UAT phase for related work products.

> Proficient and well versed with other processes involved in management

reporting and other CMM-I level 5 processes.

Environment: Visual Studio 2003, ASP.Net, C#.NET, XML, DOM-Document,

Windows Services, SQL-DMO, Java Script, SQL Server 2000, VSS (Visual Source

Safe).

Sep 2004 - Aug 2005 Valassis Inc, US

(http://www.valassis.com)

Project: Newspaper Information Service (NIS), Valassis

System Engineer

The project is about maintaining the newspaper information and rates for

various kinds of ad products to support and accelerate the media operations

of Valassis. The media data is stored in a VAX system mainframe using

Oracle RDB database. The front end uses Win forms and the application is

developed using VB.NET. Web services are used to accommodate common

operations to read data from Mainframe. The application has been

architected using multiple logical tiers segregating presentation logic,

workflow logic, business logic and data access logic into separate tiers.

Responsibilities:

> Analysis and refinement of system requirements document by closely

interacting with onsite team.

> Development of horizontal prototype.

> Preparing detail design document and other related artifacts (e.g. UI

Spec, Workflow).

> Used Custom Data Grid and Typed Dataset.

> Used COM components with the help of runtime callable wrapper (RCW).

> Made a series of sequence diagrams for product Insert (function level

Sequence Diagram) using Visio.

> Responsible for troubleshooting in NIS in the form of designing

strategies especially for Component One .Net controls and Typed Dataset.

> Development of application related to products Insert, ROP and Sample

(all layers) with unit testing.

> Offshore support during UAT phase for related work products.

> Proficient and well versed with other processes involved in management

reporting and other CMM-I level 5 processes.

Environment: Visual Studio 2003, VB.Net, .NET Framework 1.1, Win forms,

XML, Web Services, Component One Studio .NET Controls, SQL Server 2000,

ADO.NET, VSS (Visual Source Safe).

Nov 2003 - May 2004 Client:

Reliance Infocom Ltd, India

Project: RI-Billing

Trainee

The objective of the application is to viewing customer billing details,

payment details and keeps a track of customer billing history. The software

enables to generate several types of reports like Customer Interaction,

Credit and Address Verification.

Responsibilities:

> Implemented composite user controls for various requirements.

> Understanding the flow of allocated modules by having discussions with

client.

> Responsible for the coding/development of new systems.

> Develop Store Procedures and Functions in SQL Server 2000.

> Used DTS wizards for Data Transferring, Tables Updating, and Data

Backups.

> Development of application related to product Purchasing (all layers)

with unit testing.

> Proficient and well versed with other processes involved in management

reporting and other CMM-I level 5 processes.

Environment: Visual Studio 2003, .NET Framework 1.1, VB.Net, XML, SQL

Server 2000, T-SQL, HTML, ASP.NET, Java Script, IIS 5.0.

Contact this candidate