NILESH D. BHANDARWAR

Contact No: +1-206-***-****; Email: actiyy@r.postjobfree.com

PROFILE

Currently working with Tata Consultancy Services Ltd.

** ***** * ****** ********** in diverse facets in all stages of SDLC (Software Development Life Cycle) involving .NET development, encompassing analysis, design, development, and execution of business applications also includes 1 Year 8 Months of experience in teaching Software Engineering Subjects.

Playing client facing role in USA from Last 3 years 6 Months for leading Investment client.

In-depth knowledge of various platforms, software systems, and servers.

Extensive programming experience using C#.NET, ASP.NET, ASP.net MVC, WCF, HTML, JQuery, AngularJS, JavaScript, Ajax, SSIS, SSRS, CSS, DB Programming(SQL Server/Oracle), Performance Tuning on SQL Queries, IIS5.0,IIS6.0 and IIS7.0.

Hands on experience with SQL Server 2000, 2005, 2008 and 2012.

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

Excellent communication skills with strong background working directly with co-workers and clientele to identify business objectives and establish requirements.

Sound knowledge of 3-tier and N-tier layered architecture.

Experience designing and/or developing solutions for a Service Oriented Architecture (SOA).

Expert knowledge of versioning tools like TFS (Team Foundation Server), VSS (Visual Source Safe), SVN

Equipped with the knowledge of various software's, organizing technical demonstrations, with sound understanding and skill of creating new software's & systems, designing, analysis, testing, database development and coding for modules while structuring customized solutions to meet customer's specific needs

A team player with strong communication, analytical, organizational and relationship management skills. Successful track record in accomplishing assigned projects within agreed cost & timelines

In depth Understanding of Object Oriented Designing Concepts, SOLID Principles and Design Patterns

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

Quick learner and adapt quickly to any new situation/changes and work pro-actively towards meeting deadlines is my forte

Microsoft Certified in ASP.net 3.5 Web Application development.

TECHNICAL SKILLS

Languages

C#.Net, VB.net, JavaScript, Jquery, SQL

Technology

Microsoft.Net 1.1,2.0,3.5,4.5, ADO.Net, LINQ, Entity Framework, Nhibernate

Web Technologies

ASP.Net, ASP.net MVC, HTML, Jquery, JavaScript, ASP.net Ajax, Ajax, Toolkit,ASP.net Web Services, CSS,WCF,XML, AngularJS, Web API

Web Servers

Internet Information Server (IIS) 5.0/6.0

Databases

Oracle 9i/10g, SQL Server 2000,2005,2008,2012

Operating Systems

Win98/2k/XP/Windows 7

Source Safe

Microsoft Visual Source Safe 6.0,SVN

Tools

P/L Sql Developer 7.1,Teamiste,

Components

Methodologies

Build Tools

Far point Spread 2.0,4.0, Dundas chart control 5.5, iTextSharp, EditLive Editor

Agile, OOPS, OODA, SOA

Power shell scripts, Teamcity Build Server, Octopus

PROFESSIONAL EXPERIENCE

TATA CONSULTANCY SERVICES LTD Nov'09-Till Date

(CMM5 Certified Company)

4104 148th Ave NE

Building G

Redmond, WA,USA-98052

Client: Russell Investments

Location: Seattle.

Assistant Consultant

Technology Used: .NET Technologies likes C#.NET, VB.net, ASP.NET, ASP.Net MVC, WCF, SSRS, SSIS, Jquery, Jquery Ajax, AngularJS, ASP.net Ajax, DB Programming (SQL/Oracle), SQL Server

Spearheading efforts across Interacting with client on the technical aspects of the project

Responsible for Impact Analysis, Business Logic Analysis and Implementation

Accountable for User Interface Design and Development of software

Involved in requirement analysis, database design, coding, testing, implementation and maintenance of several web based applications

Gained exposure in end-to-end development of software products from requirement analysis to system study, designing, coding, testing and debugging

PREVIOUS WORK ASSIGNMENT Jul'06-Oct-09

Harrier Information Systems Pvt. LTD

First Floor, Shanti Plaza, Harihar

Nagar, Besa, Nagpur, Maharashtra,

India 440034.

(ISO 9001:2000 and Microsoft Partner)

Sr. Software Engineer

KAMALA NEHRU MAHAVIDYALAYA Nov'04-Jun'06

(Computer Science and MCA Department)

Sakkardara Square, Nagpur,

Maharashtra, India – 440024

Ad-Hoc Lecturer

EDUCATIONAL DEVELOPMENT

Bachelor of Engineering in Computer Technology 2004

Kavi KulGuru Institute of Technology and Science, Ramtek, Nagpur, Maharashtra, India –441106

HSSC in Science (12th) 2000

New English High School, Shrivastava Road, In Front of Chitnis Park Ground, Mahal, Nagpur,

Maharashtra, India – 440002

SSC(10th) 1998

Nav Bharat Vidyalaya, Kotwal Chowk, Siraspeth, Mangalwari, Mahal, Nagpur, Maharashtra India- 440032

Certifications:

Acquired Brain bench Certification in C#.NET, ASP.NET, .Net Framework and RDBMS Concepts.

Microsoft Certification in ASP.net 3.5 Web Application development. Certified as MongoDB for .net Developer by MongoDB University.

Language Proficiency: English, Hindi, Marathi

Passport Details: G2536571

Present Address: 1015 146th PL NE D02, Bellevue, Washington, USA

Reference: Available On Request

Note: Please refer project annexure for project details

PROJECT ANNEXURE

Title

TAM (Target Allocation Maintenance)

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

Oct-2015 to till date

Team Size

Platform

3 Members

Ms .Net framework 4.5, ASP.net MVC 4.0, C#, Angular JS, Entity Framework, SQL Server2012, WCF Service.

Brief Project Profile

Responsibilities

This application provides USI the ability to more effectively manage and maintain client data as they are received from the custodian (existing State Street Feed) also it provides a facility for US Institutional Client Service associates to manage and maintain US Institutional Client and Fund of Fund Reporting Targets. The US Institutional Target Allocation Maintenance Tool is a web application with an interface that will allow for manual correction of data transmission errors for US Inst Client accounts market values and transactions, which are stored in the ClientSite database and made available on ClientLINK for US Institutional clients. The web application will also provide the facility for management and maintenance the US Institutional client’s Reports Targets, which are also displayed on ClientLINK. The Target Allocation Maintenance Tool communicates with the RAICIR database by using the newly built RAICIR WCF Service API. This system is built to Replace the existing ClientSite Maintenance tool which is old and very un-user friendly to use with a new tool that is easier to use and can connect to the new RAICIR database instead of ClientSite.

●Performed Requirement Gathering and Analysis of applications.

●Single handedly interacting with clients and delivering the solutions.

●Key Developer and also Guide to junior programmers in team for entire project development.

●Involved in writing Store Procedures, Functions and Triggers.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time.

●Involved in application status call and discussion of application with

Client.

●Preparation of coding standard document, best practices and Lessons

Learned.

●Involved in Creating WCF Service to connect RAICIR DB.

●Involved in Performance optimization of Application at Code(Front End and Business Logic) as well as SQL level(Backend)

Title

APM (Application Portfolio Management)

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

Oct-2014 to Sep-2015

Team Size

Platform

5 Members

Ms .Net framework 4.5, ASP.net MVC 4.0, C#, JQuery, SQL Server2012, Entity Framework, SSRS, SSIS

Brief Project Profile

Responsibilities

APM is a web based Tool that integrates information pertaining to an application and other related artifacts that makes querying information about an application easier. This will eventually replace the Sales Force APM that currently manages the Application Portfolio. It integrates following key elements about an application. Upstream and Downstream Dependencies. Business Profile, Approvers, Owners, more. Servers (Links to SCCM),Databases (Links to DBA Config process), File Shares, Stakeholders (Business & Technology users), AD groups, Services (MFT Feeds, Informatica workflows), Incidents & Enhancement requests (Links to Jira and OPAS).It provides reporting capabilities using SSRS reports. It also contains Daily SSIS Load from Application & Database Inventory Database to APM Database to have added/updated information about infrastructures. This tool also had reporting capability where user can generate Reports in Excel and PDF format using different parameters.

●Performed Requirement Gathering and Analysis of applications.

●Single handedly interacting with clients and delivering the solutions.

●Key Developer and also Guide to junior programmers in team for entire project development.

●Involved in writing Store Procedures, Functions and Triggers.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time.

●Involved in application status call and discussion of application with

Client.

●Preparation of coding standard document, best practices and Lessons

Learned.

●Written SSIS Package to load data in APM database from multiple sources which also includes complex business logics.

●Involved in Performance optimization of Application at Code(Front End and Business Logic) as well as SQL level(Backend)

●Involved in writing SSRS reports.

Title

RAICIR (Russell's America's Institutional Client Information System)

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

Apr-2013 to till Dec-2014

Team Size

Platform

7 Members

Ms .Net framework 4.5, ASP.net MVC 4.0, C#, JQuery, SQL Server2012, Entity Framework, SSRS, SSIS, WCF Service.

Brief Project

Profile

Responsibilities

The Russell Americas Institutional Client Information Repository - is a data warehouse that allows the Americas Institutional business to pull together critical business information in order to facilitate financial, management and client reporting. RAICIR allows the business to report on holdings and transactions for all clients historically, facilitating trend analysis and other long-term reporting. It also serves as a data aggregator for a variety of systems' information, and pushes that information to several other AI business-critical systems. This Project is building using Agile Methodology. In this project main aim is convert old ClientSite Data Warehouse to new RAICIR Data Warehouse and also to modify existing applications. The current platform is very old. It is unable to satisfy current needs of AI that have evolved to a great extent since the time the platform was first set up. As part of their initiative to consolidate its data needs, AI is migrating over their CRM platform from SalesLogix to MS CRM (MS Dynamics). As part of this migration, the ClientSite database is also being replaced by a new database called RAICIR Part of this project is also involved a GUI application and windows service known as CRM Extracts which provides user to generate feeds for Depending Consumers on need basis with dynamic mapping. Besides that windows service is scheduled to produce feeds for corresponding applications with static xml mappings.

●Performed Requirement Gathering and Analysis of applications.

●Single handedly interacting with clients and delivering the solutions.

●Key Senior Developer (for Front End as well as Backend) in team for entire project development.

●Involved in writing Store Procedures, Functions and Triggers and creation of views.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time using Jira Card as this project follows Agile Methodology.

●Involved in application status call and discussion of application with

Client.

●Preparation of coding standard document, best practices and Lessons

Learned.

●Written SSIS Package to load data in RAICIR database from multiple sources which also includes complex business logics and also to output data to multiple output sources.

●Implemented solution so that all other dependent Applications on This DB will be less impacted even after a complete re-design of Database.

●Involved in Performance optimization of Application at Code(Front End and Business Logic) as well as SQL level(Backend) .

Title

AI & PCS Development

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

Aug-2011 to Dec-2012

Team Size

Platform

2 Members

Ms .Net framework 3.5, ASP.net3.5, ASP.net MVC 3.5/4.0, C#, JQuery, SQL Server2012, Entity Framework, SSRS, SSIS,WCF

Brief Project Profile

Responsibilities

AI & PCS development is consisting of development & enhancements of new as well as existing applications for AI & PCS Business Group. This includes development of secured SSO of RussellLink-eStore and RussellLink-RLPT applications. Enhancement of Fund Center for ClientLINK is also implemented. It also involved Development/Enhancement of the new features like showing YouTube video and Ooyala Videos also development of Video Carousel Control etc. using client's preferred technologies & tools. This mainly included short-term to Long-term complex enhancements as well as new developments in RussellLINK and ClientLink which are very high business critical and complex applications. We have also created AI-DOL services which is scheduled nightly to Fetch Documents from Document Repository Panagon to WebDocs database. Besides that we have developed numerous ClientLink email notifications through Membership Tool which used to notify subscribed external client upon arrival of corresponding new Fund documents\Information in Webdocs

●Performed Requirement Gathering and Analysis of applications.

●Single handedly interacting with clients and delivering the solutions.

●Key and single Developer in team for entire project development.

●Involved in writing Store Procedures, Functions and Triggers.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time.

●Involved in application status call and discussion of application with

Client.

●Preparation of coding standard document, best practices and Lessons

Learned.

●Modified existing architecture with Web Backbone in order to shift all

●Business logic (new as well as old) into this framework.

●Involved in Creating/updating/fixing SSIS packages as per requirement.

●Involved in Creating/updating/fixing SSRS Reports as per requirement.

Title

RADAR Grid Renovation 3.0

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

May-2011 to Jul-2011

Team Size

Platform

5 Members

Ms .Net framework 3.5, ASP.net, VB.net, SQL Server2000,Code Smith

Brief Project Profile

Responsibilities

RADAR (Russell Analysis, Data and Ranks) is an intranet web-based application for internal management of Money Manager and Investment product research. As per requirement new set of GRID Categories and values within those categories to supplement the existing set of GRID categories (Asset Class, Geo Emphasis, Style and Substyle) needs to implement. In Renovating the GRID Categories and values the primary benefit is to include place for all capitalization, style and product descriptions. This will make searched meaningful again.

●Performed Requirement Gathering and Analysis of applications.

●Involved in the client calls for requirement reviews.

●Involved in the development of demo as per the major requirement.

●Mainly involved in Development process.

●Single Handedly interacting with clients and delivering the solutions.

●Key Developer in team for various modules such as Draft finalization,

Draft saving, Content Creation, Undo Finalization of content, sounding

Board.

●Involved in writing Store Procedures, Functions and Triggers.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time.

●Involved in application status call and discussion of application with

●Client

●Preparation of coding standard document, best practices and Lessons Learned.

Title

MORT (Manager Oversight Reporting Tool)

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

Jan-2011 to Apr-2011

Team Size

Plateform

1Members

Ms .Net framework 3.5, ASP.net, C#, JQuery, Castle Windsor Monorail for MVC, SQL Server2005,Code Smith

Brief Project Profile

Responsibilities

MORT (Manager Oversight Reporting Tool) is an intranet web-based application used by IMO users to enter Manager Reviews and to generate various complex reports using these reviews. Previously User uses Risk Residual rating Type while entering Reviews. Now As per new requirement Oversight Review rating is need to be used for new Reviews and also all old reviews required to be replaced by Oversight Review Rating. Also All reports need to show new Oversight Review ratings as well as old reports.

●Performed Requirement Gathering and Analysis of applications.

●Single handedly interacting with clients and delivering the solutions.

●Key and single Developer in team for entire project development.

●Involved in writing Store Procedures, Functions and Triggers.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time.

●Involved in application status call and discussion of application with

Client.

●Preparation of coding standard document, best practices and Lessons

Learned.

●Modified existing architecture with Web Backbone in order to shift all

●Business logic (new as well as old) into this framework.

●Involved in designing and writing SSRS.

Title

RADAR (Research and Data Analysis and Ranks)

Client

Russell Investments, Seattle, USA

Organization

Tata Consultancy Services

Duration

Mar-2010 to Dec-2010

Team Size

Plateform

12Members

Ms .Net framework 3.5, ASP.net, VB.net, SQL Server2000,Code Smith

Brief Project Profile

Responsibilities

RADAR (Russell Analysis, Data and Ranks) is an intra-net web-based application for internal management of Money Manager and Investment product research. Mainly involved in development and complete re-engineering of existing offline share-point-MS Word authoring to online web authoring of contents. This application has been used across different Geographies.

●Performed Analysis of applications.

●Key Developer in team for various modules such as Draft finalization,

Draft saving, Content Creation, Undo Finalization of content, sounding

Board, Analyst TDR, Ranks and Commentary

●Involved in application status call and discussion of application with

Client

●Involved in writing Store Procedures, Functions and Triggers.

●Involved in deployment and Maintenance of Application

Title

Branch Number Expansion (BNE)

Client

Morgan Stanley, New York, USA

Organization

Tata Consultancy Services

Duration

Nov-2009 to Feb-2010

Team Size

60 Members

Platform

C#. NET 3.5, ASP.net 3.5, SQL Server 2008, IIS 6.0

Brief Project Profile

After the joint venture of Morgan Stanley & Smith Barney the branch number required to be changed from 3 digits to 5 digits. This resulted in the changes of almost 300 applications. BNE is the project that handles the changes to this application to accept 5 digits branch number. Project involved high & low-level analysis of existing applications, modification of the application and finally integrate all the application to work smooth as before.

Responsibilities

●Performed Analysis of applications.

●Identified Number of areas affected and Made changes into it as per

New requirement.

●Key Developer in team for various modules.

●Involved in application status call and discussion of application with

●Client.

●Involved in writing Store Procedures, Functions and Triggers.

●Involved in deployment and Maintenance of Application.

●Preparation of coding standard document, best practices and Lessons

Learned.

Title

Derivium Front Office System

Client

Derivium Capital & Securities Pvt. Ltd, Mumbai

Organization

Harrier Information Systems Pvt. Ltd

Duration

Jun-2009 to Oct-2009

Team Size

2 Members

Platform

C#. NET 3.5, ASP.net 3.5, SQL Server 2008, Visual Studio 2008, IIS 6.0, Itext Sharp

Brief Project Profile

Derivium's Front Office System is meant for Derivium's internal use to automate the front office activities once the deal is finalized. This is a web based application. The purpose of the system is to increase transparency & speed of processing the customer orders. The system generates the deal ticket for SLR and non SLR deals and the deal slip for the primary market. The system also provides the facility of viewing the report of the deals on a particular day.

Responsibilities

●Mainly involved in Development process.

●Involved in the client calls for requirement reviews.

●Involved in the development of demo as per the major requirement.

●Involved in the development of Excel Import utility.

●Provide and discuss estimation of the modules from time to time.

●Track and verify each deliverable from time to time to time.

●Involved in application status call and discussion of application with

Client

●Preparation of coding standard document, best practices and lessons

Learned.

●Involved in creation of user controls.

Title

CRISIL's Xpert Analysis (Performance Attribution Tool)

Client

Principal India Mutual Fund. (Joint Venture of Punjab National Bank and Vijaya

Bank), ASK

Organization

CRISIL Ltd

Duration

Mar-2007 to Jun-2009

Team Size

3 Members

Platform

C#. NET 2.0, ASP.net 2.0, Oracle 9i/10g, Far point Spread, Dundas Chart control, Visual Studio 2005

Brief Project Profile

CRISIL's Xpert Analysis, attribution analysis tool which helps the investment manager to identify the factors that have contributed to the returns earned by the fund, by performance comparison done against a benchmark portfolio. The tool analyses the portfolio returns against a suitable benchmark and enables to attribute returns to various investment policies and controls internal to the fund. And also provides a Risk adjusted return measurement and insight risk ratio to monitor the risk continuously. It drill down the attribution from sector to security level there by enabling the fund manager to deliver as insight on exactly which security is drawing down on the return an which adds on to the total portfolio return. This tool also contains various Graphical and General reports for equity and debt attribution. It also contains feature like Import price and portfolio for multiple date at one shot and import multiple portfolio at one shot through single excel file

Responsibilities

●Involved in the Calls with the Requirement gatherer and understood the

Requirements.

●Initiated the overall design of the Development Solution.

●Involved and assisted in the estimation of the project modules,

Creation of classes and sequence diagram.

●Involved in the development of the Masters, Import Price and Portfolio.

●Involved in the development of Performance attribution for Equity and

Debt, Portfolio Analysis and Portfolio Evaluation

Title

Investments Fact Sheets

Client

ICICI Prudential Ltd

Organization

CRISIL Ltd

Duration

Feb 2009 to May-2009

Team Size

1 Member

Platform

C#. NET 3.5, ASP.net 3.5, Oracle 10g, Far point Spread, Visual Studio 2008,IIS 6.0

Brief Project Profile

This system is used by CRISIL Users to generate fact sheets which contain investment details of ICICI Prudential for Equity, Debt, FOF, FMP, Interval, Smart, Hybrid and Arbitrage Portfolios. ICICI Prudential will send these detailed reports to its clients. Clients of ICICI Pru will get brief idea of where Company has invested their money. Initially ICICI will send data to CRISIL user. Then User will import data into system and System will generate reports for various schemes of portfolios in its respected logical formats with calculations. These Reports are then get saved on server in excel file format and download link has been provide to user to download corresponding files. Far point Spread component has been used for saving reports in excel format

Responsibilitie

●Involved in the understanding the Requirement of functionality of the product and Analysis

●Involved in the development of entire application.

●Involved in deployment of Application.

●Involved in writing store procedures to implement business logic.

●Involved in Back End Development.

Title

Surveillance Database Automation Project (SDAP)

Client

CRISIL Ratings

Organization

CRISIL Ltd

Duration

Oct-2006 to Feb-2007

Team Size

5 Members

Platform

C#. NET 1.1, ASP.net 1.1, XML Web Services, SQL Server 2000, Far point Spread, IIS 5.0, VS 2003

Brief Project Profile

Earlier all the data pertaining to the performance of deals (rated pools) was maintained in excel sheets. For drawing conclusions or performing comparisons between various deals, data was pulled out manually from each of the excel sheets (output sheets) maintained. With the number of deals increasing, managing such data, performing calculations and tracking performance became tedious. We developed a Web-based 3 tier system with client as a desktop application as well as browser application in C#, ASP.net and business logic residing in XML web services deployed on IIS 5.0 with data stored in MS SQL Server 2000 database. The client application used Far point spread control for user interface similar to MS Excel. Various features of this application are Automation of quarterly publication reducing time-required for the same to 1 day from earlier 25 days. Alert the surveillance team for an unfavorable performance displayed by a deal. Runs queries for comparison between deals, Important ratios necessary to track the performance of a deal are automatically generated. Maintain MIS of monthly reports due but not received from the trustee, Alert the surveillance team for an unfavorable performance displayed by a deal

Responsibilities

●Involved in the understanding the functionality of the product and the

Developed code.

●Involved in the deployment of updated version of application to existing

Clients.

●Involved in writing store procedures to implement business logic.

●Involved in the development of the Masters, Static Pool Analysis,

Portfolio Analysis, Query module and Reports.

Title

Practioner Finding Web Application for Restylane

Client

Q-Med Sweden

Organization

Harrier Information Systems Pvt. Ltd

Duration

Jul-2006 to Sep-2006

Team Size

2 Members

Platform

C#. NET 1.1, ASP.net 1.1, SQL Server 2000, Visual studio 2003, IIS 5.0

Brief Project Profile

This application is developed for customers of Q-med in order to find Practioners all over the world for product Restylane. This application is role based i.e administrator can have access to all tasks, such as user creation, modification, user deletion, adding, modifying and deleting information about Practioners. Normal users have only read access to application i.e he can search Practioner depending upon the country and can view its details. User can send its query to Practioner using mail service of this application and also can receive mail

Responsibilities

●Involved in the understanding the functionality of the product and in the

Development of the product.

●Involved in the deployment of updated version of application to existing

Clients.

●Involved in the development of reports for showing Practioner details,

●Login Screen, user activation, change password module, mailing module and Report showing inbox.

Contact this candidate