Post Job Free

Resume

Sign in

Sql Server Professional Experience

Location:
Gaithersburg, MD
Posted:
December 29, 2016

Contact this candidate

Resume:

Sanjit Rout

acx113@r.postjobfree.com

+1-309-***-****

Professional Summary:

Over 12+ Years of experience in architecture, analyzing, design, development, research, implementation and deployment of several Client/Server, distributed GUI, enterprise level Web based applications.

Experienced with Onsite/Offshore approach, Interaction with the onsite team members and client.

Led and focused the teams on business objectives and tracked progress to ensure project milestones were completed on time, and with the desired results.

Mitigated risk factors through careful analysis of Project deliverables. Anticipated and managed change effectively in rapidly evolving business environments.

Exposure in project analysis, development and testing of applications

Excellent problem solving skills with a strong technical background and good interpersonal skills.

Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

Highly motivated team player with zeal to learn new technologies and always believing in giving the best efforts in challenging environments.

Extensively worked on n-tier architecture applications using .Net frameworks, ASP.Net, C#/, ADO.Net, MVC, JQuery, KnockoutJS and AngularJS, HTML, CSS, IIS, Visual Studio 2015/2013/2008/2005/2003, SQL Server

Implement agile scrum methodology in application development using Visual Studio Kanban Board.

Configuration of the applications, applying the standards in deployments. Disaster recovery management.

Experience in developing and consuming Web Services using Service Oriented Architecture (SOA).

Experience using Bootstrap, HTML, CSS, JavaScript to enhance the performance, look and feature of the website.

Extensively worked with back end, middle tier and GUI designing in both Web applications

Experience in writing stored procedures, triggers, and views in Microsoft SQL Server database

Experience in Version controlling tools GITHub Extension, VSS, SVN etc.

Languages

C#, VB.NET, VB, SQL

.Net Technologies

ASP.NET, MVC, ASP.NET Core,ADO.NET, WCF, Web Services

Tools

VS 2015/2013/2010/2008/2005/2003, GITHub Extension, VSS, Tortoise SVN, NAnt, NUnit

Frameworks

.Net 4.5/3.0/2.0/1.1

RDBMS

MS SQL Server 2008/2005/2000/7.0, MS Access

Scripting Languages

JQuery, KnockoutJS, AngularJS, Java Script

Architecture

n-tier Client/Server, Internet/Intranet

UI design tool

Bootstrap, CSS, Kendo UI

Agile Scrum Tool

Visual Studio Kanban Board

UML

MS Visio, www.draw.io

Markup Languages

XML, XSL, XSLT, XPath, XML Schema

Architecture

MVC, MVVM, SOA, OOD, Design Patterns, Enterprise Architecture, Distributed Systems, TDD

Product Tools

Quality Center 10, JIRA, Confluence

Application Servers

IIS

Professional Experience ; HCL America Inc., USA June 2015 - Current

AARP, USA:

Project : LCE (Legal Council for Elder)

Skill/Tools : VS 2013,.Net, C#, ASP.Net, MVC, JQuery, Bootstrap, CSS, Entity Framework, TFS

Description:

AARP is a non-profit organization with a mission to enhance the quality of life for all as they age. LCE handles cases for residents who are age 60 and older. It also handle Social Security and Supplemental Security Income disability cases for residents age 55 and older. LCE handles most types of civil (not criminal) legal matters.

Responsibilities:

Designed and developed rich and enhanced web pages using ASP.NET, MVC, C#, Entity Framework, JSON, CSS 3, Bootstrap 3.0 and JQuery 1.0.

Modified Business Logic Layer & Data Access Layers to implement the MVC4 architecture and Entity Framework.

Used TFS to manage the branches.

Involved in preparing prototype and walk through during sprint review meeting

Followed Agile Scrum throughout SDLC and actively involved in entire scrum process using the Kanban tool. The work items (Epics, Features, PBIs, Bugs, & Tasks) are managed using this tool to track PBI at EPIC/Feature level.

Responsible for deployment of the Application in production and resolving any post-deployment issues.

Involved in code review and pull request approval.

Ensuring Quality and Process Compliance.

RLI Corporation, USA:

Project : R3Agency

Skill/Tools : VS 2015,.Net, C#, ASP.Net Core, JQuery, Bootstrap, CSS, Entity Framework, Web API, GIT with TFS

Description:

R3 Agency (R3A) is used by agencies for bond entry, execution, and management. R3A is a modernization and UX improvement effort aimed to extend the reach of current R2 platform. R3A will be the first web-based RLink platform to deprecate Object Server in favor of EF to combat performance and supportability considerations. It is also be the first web-based platform using ASP.NET Core at RLI.

Responsibilities:

Designed and developed rich and enhanced web pages using ASP.NET Core 1.0, MVC, C#, WEB API 5.0, Entity Framework 6.0, JSON, HTML 5, CSS 3, Bootstarp 3.0 and JQuery 1.0.

Achieved identity management using Gigya.Social.SDK

Implemented HTML Helper MVC Web Grid with JQuery, Win Forms for boosting the pagination performance, and loaded the graphical data with JSON. Also supporting custom searching along with sorting the data with partial views.

Created Business Logic Layer & Data Access Layers to implement the MVC4 architecture and Entity Framework.

Implemented the dependency injection

Used Visual Studio GITHub Extension for source control and the Sourcetree tool used to manage the branches.

Used Gigya API for identity management

Implemented Redis cache for application performance improvement.

Newrelic tool is used as APM tool for monitoring the application performance across location

Involved in preparing prototype and walk through during sprint review meeting

Followed Agile Scrum throughout SDLC and actively involved in entire scrum process using the Kanban tool. The work items (Epics, Features, PBIs, Bugs, & Tasks) are managed using this tool to track PBI at EPIC/Feature level.

Responsible for deployment of the Application in production and resolving any post-deployment issues.

Involved in code review and pull request approval.

Ensuring Quality and Process Compliance.

Project : https://www.mybondapp.com

Skill/Tools : VS 2015,.Net, C#, ASP.Net, MVC, JQuery, Bootstrap, Kendo UI,CSS, GIT with TFS, Kanban tool

Description:

MyBondapp.com is a direction towards a direct channel that leverages the agency partnership. The agency is still responsible for sales & marketing and is responsible for adding a link to the MBA channel from their website or ads. The agency also collects the commission without having to handle the data-entry process. MBA is the first RLink system to support cross-browser support for bond purchases as well as leverage a federated cloud platform. MBA is also the first RLI system to use Azure Search for indexing Obligee data into NOSQL.

Responsibilities:

Involved in the design, development using ASP.NET, MVC, JQuery, Kendo UI, KnockoutJS

Developed ASP.NET Web forms, unit tested business layer and data access layer using C#,

Understanding the business requirement from client.

Managed web services policies and security

Reviewed technical designs and code produced by others

Presented technical solutions to business teams

Involved in fixing issues, stabilizing and improving performance of components and system

Provided support during the UAT cycles of the system

Used Visual Studio GITHub Extension for source control and the Sourcetree tool used to manage repository.

Used Gigya API for identity management

Implemented Redis cache for application performance improvement.

Newrelic tool is used as APM tool for monitoring the application performance across location

Involved in preparing prototype and walk through during sprint review meeting

Provided support and mentored on-shore and off-shore team members

Practiced Agile methodologies – scrum, sprints & continuous integration

Planning, Estimation and resource allocation

Working as an individual contributor and mentor to the team

Customization and Implementation

Professional Experience ; HCL Technologies, India Nov 2014 – Jun 2015

RLI Corporation, USA:

Project : RLink2

Skill/Tools : Visual Studio 2013, MVC, JQuery. Kendo UI, SQL Server 2008

Description:

RLink2 is used by both agencies and internal RLI employees for bond entry, execution, and management. Surety Operational Team is in charge of setting up Bond Types, Data Dictionaries, Bond Forms, Rating Rules, and all other associated criteria to capture relevant risk factors for bond decisions. RLink2 only supports IE due to the design of its UX - such things as controls, disabling browser navigation bar for history, and other relevant factors forced us to reimagine the R2 subsystems.

Responsibilities:

Mitigated risk factors through careful analysis of Project deliverables. Anticipated and managed change effectively in rapidly evolving business environments.

Interaction with the onsite team members and client.

Critical Bug fixing and Enhancements as per Client Requests.

Providing the support for various critical applications.

Allocating tasks to Team members and ensuring deliverables to be delivered on time.

Ensuring Quality and Process Compliance.

Deployments to Prod/Test and UAT environments

Professional Experience ; HCL Technologies, India Mar 2013 – Nov 2014

Deutsche Bank, USA:

Project : Fails and Pending

Skill/Tools : VS 2010, C# .Net, ASP .Net, SQL Server 2010, MVC, NUnit, UML

Description:

Fails and Pending application which acts as a data mart, stores information on failed and pending cash equity trades of Deautsche Bank. It’s an industrial standard for keeping track in financial information form as failed and pending trades of Deutsche Bank.

Responsibilities:

Take Own the agile release plan and calendar for multiple applications

Planning timescales and the resources needed

Defining software, hardware and network requirements

Developing agreed solutions and implementing new systems

Designing, testing, installing and monitoring new systems

Preparing documentation and presenting progress reports to customers

Analyzing IT requirements within companies and giving independent and objective advice on the use of IT

Presenting solutions in written or oral reports

Host the release control board(RCB), retrospective and daily stand-up meetings

Manage project applications, change and bug fix releases

Quality control the code and content releases between DV,QA,UAT and PROD environments

Responsible for release roadmap, risks and RAG(RED,AMBER,GREEN) status

Support of SEV1 bug fixes and environment issues reported

Communicate and coordination with stake holders and teams for issue resolution

Manage the teams with their agreed deliverables on time

Professional Experience ; HCL Technologies, UK Jul 2012-Mar 2013

UKAR, UK:

Project : Applications Migration project in Citrix Environment

Skill/Tools : C# .Net, VB .Net, VS 2010, SQL Server 2008, VSS, MS Office Project 2007 in Citrix Environment, QC

Description:

UKAR is a privately Held company. UK Asset Resolution Limited, together with its subsidiaries, provides mortgage services to existing mortgage borrowers primarily in West Yorkshire and the North-East. It holds residential mortgages, unsecured loans, and government loans, as well as non-deposit wholesale and secured funding instruments 5th largest mortgage lender in the UK.

Responsibilities:

Project planning using MS office Project 2007 and upload the MPP into PMSmart (Quality tool).

Involved in project estimation using the FP estimation.

Design (LLD and HLD) of individual application as per defined software process

Involved in PRD preparation

Involved in application implementation plan

Coding and Unit Testing

Contribution to peer reviews, conduct code reviews

Assigning the task to team member.

Involved in publish and unpublished of Citrix package

Professional Experience ; HCL Technologies, India Oct 2010 - Mar 2013

CITI Bank, UK

Project : Securities Market Interface

Skill/Tools : VS 2010, C# .Net, VB.Net, WPF, WCF, ASP .Net, SQL Server 2008, NUnit, UML, Enterprise Architect

Description:

SMI provides an almost uniform interface to the European markets for SECORE, Citibank’s core custody processing system. It receives instructions from SECORE which it passes to the market via the applicable interface. Depending upon the market status information may be passed back to SMI allowing the tracking of the instruction. SMI will map these statuses to those used by SECORE and will notify SECORE when it’s version of the status changes. SMI is a Citibank “In-House” developed Windows Client Server based system. SMI is targeted as the market interface system for the Securities market in Citibank Custody operations. It is tightly coupled with SECORE.

Responsibilities :

Involved in the design, development, unit testing and integration of components for SMI application.

Design and project development as per defined software process

Understanding the business requirement from client.

Managed web services policies and security

Reviewed technical designs and code produced by others

Presented technical solutions to business teams

Involved in fixing issues, stabilizing and improving performance of components and system

Provided support during the UAT cycles of the system

Provided support and mentored on-shore and off-shore team members

Practiced Agile methodologies – scrum, sprints & continuous integration

Planning, Estimation and resource allocation

Working as an individual contributor and mentor to the team

Customization and Implementation

Professional Experience ; MphasiS, India Apr 2006 – Apr 2010

Amgen Inc., USA:

Project : Contract Generation System (CGS)

Skill/Tools : VS 2008, C# .Net, ASP .Net, SQL Server 2005, NHibernate, NUnit, JQuery

Description:

The project is developed for a Pharmaceutical company to improve the client’s business. The CGS system is being implemented for the Law department which requires an improved method of creating standardized contract documents. The system will enable authorized users outside of the Law department, such as Clinical Trial Study Managers, to enter the details of the contractual subject matter, the outside parties, the location where the work is to be performed and other parameters that will determine the contents of the final document.

Responsibilities:

Involved in design, development, unit testing and integration of CGS Application

Design and project development as per defined software process

Contribution to process improvements

Involved in the Analyzing the issues/enhancements.

Involved in preparing the functional point estimation.

Coding and Unit Testing

Contribution to peer reviews, conduct code reviews

Assigning the task to team member using JIRA tool

Coordination with onsite team and client

Involved in preparing Technical design document, Functional design document.

Charles Schwab, USA:

Project : Retirement Planning Services [Schwabplan.com ]

Skill/Tools : ASP.NET, C#, XML, XSLT, SQL Server-2005., .NET Framework 2.0, 3.0, Visual Studio 2005,

Description:

RPS is an acronym for Retirement Planning Services. Schwab offers the following services - corporate services, Schwab institutional (SI.com), retail. RPS is corporate services arm of Schwab. The other corporate service technologies offered are: Plan administration services and stock plan services.

RPS has various applications that help employees (participant) of a firm to save for their retirement. They offer 401k plans too. These applications also offer advice to a participant in investing.

There are 3 main applications of RPS -> PSL (Participant Service Link), SchwabPlan.com and SRI. PSL and Schwab plan are web based applications. SRI is client server application written in Delphi. PSL and SRI are internal to Schwab. Schwab plan can be view on the internet using http://www.schwabplan.com

Responsibilities:

Take part in the preparation of Technical specification documents for the implementation of a given Business Requirement.

Allocating tasks to Team members and ensuring deliverables to be delivered on time.

Estimation for the new projects.

Ensuring Quality and Process Compliance.

Fixing Defects that are logged in the Vantive- Bug Tracking Tool.

Preparation of various process documents like DAR (Decision, Analysis and Resolution), HLD (High Level Design), LLD (Low Level Design) and UTC (Unit Test Cases) etc.

Migration of legacy ASP pages to the new .NET based Architecture.

Developing required Database objects like Stored Procedures, Views, User Defined Functions (UDFs) etc in SQL Server 2005.

Project maintenance.

Development/Enhancement of Web Pages using Visual Studio, C# and other Microsoft Technologies.

Professional Experience ; Crackerjack Software Pvt Ltd, India Oct 2005 – Apr 2006

Irish Tax Institute, Ireland:

Project : http://www.taxireland.ie/ portal development.

Skill/Tools : ASP.NET, C#, SQL Server 2000

Description:

The Irish Tax Institute is the leading representative and educational body for Ireland’s AITI Chartered Tax Advisers (CTA) and is the only professional body exclusively dedicated to tax. Our members provide tax expertise to thousands of businesses, multinationals and individuals in Ireland and internationally. In addition many hold senior roles within professional service firms, global companies, Government, Revenue and state bodies.

Responsibilities:

Making enhancements .NET Framework.

Development of required Business Objects.

Development of User Controls using .NET Standard Controls.

Developing Database objects (stored procedures etc) that are referenced by the Business Objects.

Professional Experience ; Shams Healthcare Software Pvt. Ltd., India Nov 2004 – Sep 2005

TSG, USA:

Project : Hospital Engagement Portal

Skill/Tools : ASP.NET, C#, SQL Server 2000

Description:

Reduce your workload, lower your costs, and leave your patients smiling with TSG’s Patient Portal. The portal brings together information and services in a new patient-friendly way using web architecture that is scalable and flexible to the needs of every organization. The Patient Portal transforms patients into active consumers by allowing them to seek real-time information, participate in their healthcare progress, and stay connected with the organization.

Responsibilities:

Creating and customizing modules in DotNetNuke

Integration with other applications & Unit testing

Professional Experience ; Bhilwara Infotech Limited, India Sep 2003 – Oct 2004

Intech Inc., USA

Project : PPV Transition Tool (Payroll Preview Transition Tool)

Skill/Tools : VB .Net, ASP.NET, Visual Data flex 5.0, SQL Server 2000.

Description:

This tool is an automated process for moving a current IPM customer at the PSID (Payment Schedule Identity) level to Payroll Preview. This tool will implement an automated solution in a structured way.

Responsibilities:

As a senior developer involved in the web application design, development & unit testing.

Code refactoring & fixes to the code written by others and application enhancements

EDUCATION DETAILS

M. Sc. in Computer Science

PERSONAL DETAILS

Visa Status: H1 B Visa Valid Until Dec 2017.

LinkedIn reference: https://in.linkedin.com/in/sanjit-rout-128a6926

Reference will be provided upon request.



Contact this candidate