.net developer

Mehul Barot

Summary

**.* years of experience in analysis, design and development of client/server, web based and n-tier application.

experienced in WCF and MVC 3.0/4.0

Expert in developing web applications, web services (SOAP and REST), windows applications (WinForms) and windows services in Microsoft Visual Studio .Net IDE using C#.Net 2.0, C#.Net 3.5, C#.Net 4.0, ASP.NET, AJAX, ADO.NET, VB.NET and SQL Server 20XX and Oracle.

Good knowledge of Economic Capital Market Risk, Financial & Investment domain.

Extensive experience in PL/SQL Developer, Toad and WinSQL.

Expert in creating POC and RnD work.

Experienced in creating GUI for windows based application.

Expertized in version control system like Star Team, Visual Source Safe, Sub-Version.

Elaborate experience in Crystal Reports, Data Dynamics Active Reporting tools.

Strong working experience in BMC remedy, Quality Center 10.0, BuildForge.

Created custom deployment packages for Application using Visual studio.Net Setup Project.

Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.

Extensive experience in SQL Server Database design, Database maintenance, developing dynamic T-SQL queries, stored procedures, Functions, Views and triggers using MS SQL Server 2000/2005/2008.

Good working knowledge with designer tools such as Microsoft Visio.

Very good working experience in creating project plans using Microsoft Project Plan.

Good working knowledge in designing Use Case, Class, Sequence, Deployment, Activity diagrams using UML.

Expert in debugging an application using the debugging tools provided by the Visual Studio.Net IDE.

Functional domain experience involves Market Risk, Credit Portfolio management, Banking, Wealth reporting, Media and Accounts.

Additional experience also involves product-engineering services that include communication with computer drivers, barcode readers and external devices.

Extensively involved in System Development Life Cycle (SDLC) and Agile methodologies.

Excellent soft skills, team-building skills. Have played Team Lead/Coordinator roles for various projects and handled team as big as 6-7.

Experience in creation of Business Requirement Documents as well as Quality related documents (Function specification, High Level and Low Level design, and Unit Test Case documents).

Excellent analytical skills in understanding clients organizational structure

Fast Learner, effective communication and presentation skills, ability to quickly adapt to the technical environment coupled with very positive user interaction & team spirit.

Education Qualifications:

Bachelor of Engineering (CSE) – Mumbai University, India

TECHNICAL EXPERIENCE:

Technologies:

ASP.Net, C#.Net, WCF, VB.Net, AJAX, JavaScript, Web Services, Windows Services

DESIGN

MS Visio (Class Diagrams, Sequence Diagrams)

RDBMS and Tools:

SQL Server 2000/2005/2008, Oracle, DB2, SQLite, MS Access, PL/SQL Developer, Toad, WinSQL

CONFIGURATION MGMT:

Visual Source Safe, Sub-version, Star Team, Jazz

Reporting Tool:

Crystal Reports, Data Dynamics Active Reports

OPERATING SYSTEM:

Windows

Other:

BMC Remedy, Buildforge, Quality center 10, nUnit Test

FUNCTIONAL EXPERIENCE:

Bodily Injury/Property claims, Economic Capital Market Risk, Credit Portfolio management, Banking (Core), Media (TV, Radio, Press), Accounts, Product engineering services.

Professional Experience:

Client: IPSOS - Parsippany, NJ March 2016 – Present

Project: IHG Survey

Role: Sr. Software Engineer

InterContinental Hotels Group(IHG) conduct various surveys to guest as well as the General managers for their hotel experience. Survey gets the rating from various question sets including open end text and video inputs to study the improvement areas for making better business.

The entire project was dynamic and JSON source based. In case of any new business requirements; making updates in the database table and with very minor code updates was all needed to go live in short time. Also, survey was meant to run on any device including desktop, tablet and mobile

Responsibilities:

Managing multiple applications at a time like IHG Survey, Portal, Mobile Survey

Meeting with business and client service members to get good knowledge of the requirements and providing required suggestions for better implementation

Provided estimation.

Used .Net framework 4.5, MVC, ASP.Net, C#, ADO.Net for creating different modules and GUI for application.

Added many customized controls in MVC.

Extensively used JSON Sources to make application dynamic

Added external control for getting video inputs from guest

Used JQuery, JavaScript, CSS, Bootstrap CSS, XML, etc.

Extensively used SQL triggers, stored procedures, functions and views.

Have used dynamic queries multiple times to make application dynamic.

Implemented SAML (Single sign on) for portal application

Environment: Windows 7, MVC, ASP.Net 4.5 / C#. Net, SQL Server 2012, JavaScript, JQuery, JSON, XML, Sub version

Client: Chubb and Sons – Warren, NJ Oct 2014 – Feb 2016

Project: Predictive Modelling - Claims

Role: Tech Lead (Sr. Developer)

The Chubb Claim department's Predictive Modeling project is looking to leverage the successes and lessons learned in Predictive Modeling for Work Comp and Property claims to the Bodily Injury line of business.

Responsibilities:

Provided estimation using Experience Based - Analogies & experts and Size-based estimation models.

Implemented Agile Scrum methodology. Used software development life cycle (SDLC) for implementing application. Designed and developed Web applications for Claim System using Object-Oriented Principles and n-tier architecture.

Working on multiple applications like property claims, bodily injury claims, data extraction etc. in Chubb.

Used .Net framework 4.5/4.0, ASP.Net, C#, ADO.Net for creating different modules and GUI for application.

Created and consumed Web service using SOAP and REST.

Worked on existing WCF to modify it as per the business requirements

Used JavaScript to enhance the dynamics and interactive features of Web page by allowing user to perform calculations, validate form inputs, add special effects, customize selections, Confirmation, Used AJAX including JQuery library for client side.

Used ADO.Net data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, Data Table and XML for consistent access to SQL data sources.

Handled CLOB data in the form of Fixed width and XML formatted data storage in database

Created Relational Database using Normalization, Implement Relationships between tables, Data table, Stored Procedure, Views in SQL Server 2012 and in Oracle database. Used WCF Web services for manipulating data operation.

Used Jazz for integration, maintenance and Security of code. Responsible for application Supports and releasing the fixes. Resolved potential issues that arose during the execution of development.

To perform unit test of the code used nUnit testing

Coding for various Modules, Error Handling, Modification and Testing, Bug solving of the change requests.

Review requirements with Business/ IT and application development partners

Understand the technical and functional components of Bodily Injury predictive modeling required to be integrated and implemented on Visual Studio 2012 with DB2 databases into Insurance domain.

Mentoring offshore team and making sure for defect free code deployment.

Environment: Windows 7, ASP.Net 4.0 / C#. Net, SQL Server 2012, Oracle 11g, JavaScript, Web services (SOAP and REST), WCF, Jazz, nUnit testing

Client: MetLife Inc. – Somerset, NJ May 2010 – Sep 2014

Project: Risk Frontier

Role: Developer

Economic Capital is used for measuring and reporting market and operational risks across a financial organization. It is the amount of capital the firm should have to support any risks it takes. Moody’s KMV RiskFrontier is one of the industry standards for Economic Capital models and is used by most financial institutes including MetLife.

RiskFrontier calculates required credit risk economic capital for the entire portfolio, enabling better understanding of enterprise-wide credit risk.

It is also suitable for Basel II Pillar 2 purposes and advanced credit risk management, including risk/return analysis and portfolio management.

RiskFrontier is suitable for portfolios spanning corporate, SME, retail, sovereigns, structured asset investments, and more.

Specifically, RiskFrontier deals with multiple asset types: loans, CDS, CDOs, basket default swaps, equities, and so on.

RiskFrontier is market-driven and uses a bottom-up approach to analysis. It employs a simulation model and provides several ways of viewing portfolio output to improve understanding and identify problem areas.

The complete process can be summarized in the following four high level steps

Data Load: Risk Frontier application consumes data from various sources like IDEAS, CRTS, Legal Entity, MUREX etc. Monthly batch job runs on maestro to consume data in Risk Frontier application database

Data Integration: After month end data gets completed, next step is Data Integration. Here the raw data is massaged and it is prepared to be input source data for Moody’s KMV Risk Frontier application (third party vendor application).

Data Transfer: The data gets imported to Risk Frontier databases through Transfer to Risk Frontier step. When the data is imported to vendor application, with the help of predefined data settings (created by business users) user start the portfolio analysis. Here the imported data gets into consideration for random sampling and multiple simulations, which are deemed to produce a better refined economic capital value. The data gets stored in one of the Moody’s application database

Create Economic Capital (EC): Last step is to create Economic Capital (EC) report. MetLife Risk Frontier application pulls data from the Moody’s Risk Frontier data and presents it into well-formatted EC report. The final output of EC report data is further consumed by IDEAS and Tampa group of MetLife!

Responsible for:

Working as Team Lead/onsite coordinator, which includes requirement analysis, design, development, testing, documentations and production deployment.

Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.Net

Understanding and discussing, Investment and Financial terminologies to implement changes from business in the application

Written stored procedures, Functions, Views, triggers using SQL in SQL SERVER 2008.

Written the dynamic t-SQL queries to meet uncertain data insertion/update requirement.

Written code to upload Generic excel data files to database

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Developed Windows Service to kick of the process to consume file data when the files are available.

Used HTML, JavaScript and AJAX for developing Controls and web forms

Extensively used GridViews with sorting and paging.

Developed User Documents for the users.

Provided Production support.

Co-ordination with MetLife & iGate team

Daily co-ordination with offshore team and Helping offshore team understand the requirements. Also, provided technical guidance on the project

Resolving offshore queries (both technical and functional)

Code verification and making sure the requirements are addressed (Code review of the deliverables from offshore)

Help offshore team understand the review findings

Responsible for handling team of 5 resources including onsite and offshore

Created Function specification, High-level design document and Low level design document and Unit Test Case, deployment and operational document.

Environment: Windows XP/2008, ASP.Net 3.5 / C#. Net, SQL Server 2008, Ajax, JavaScript, Web services (SOAP), Star Team, Export to Excel report, MS Visio (UML), Remedy, Buildforge, Quality center 10

Client: MetLife Inc. – Somerset, NJ June 2009 – May 2010

Project: iTracker

Role: Developer, Onsite coordinator

Investment Tracker (iTracker) is a 24/7 wealth reporting web tool that provides producers with in-depth reporting about clients' brokerage accounts, fund direct, managed accounts, variable annuity, variable life data and portfolio tracking. It has complete workflow for branch manager to create portfolios with clients. It also provides the reports on investments made during a selected duration.

Responsibilities:

Performed role of a Module Leader/Sr. .Net Developer which includes requirement analysis, design, development, testing, documentations and production deployment.

Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#

Created Tables, packages and views in Oracle data base using PL-SQL Developer tool

Used Data Dynamics reports for generating various reports.

Used HTML, JavaScript and AJAX for developing Controls and web forms

Also, worked on web service to retrieve data.

Understanding of the requirement and working with the team to convert the requirements to deliverables. Creating project plans, project tracking sheets, task documentations

Helping and guiding the team to achieve the project dead lines

Communicate with business users to understand their requirements. Investigating and solving the existing production issues.

Performance tuning of the existing modules, which includes code optimization as well as database optimization.

Testing of the deliverables

Deployment of project and production support

Used PL/SQL Developer and Toad tool for database connectivity

Environment: Windows XP/2000, ASP.Net 2 / C#. Net, PLSQL, Ajax, JavaScript, Web services, Oracle 10g, XML, Star Team, VSS, Active Reports, Export to Excel report, MS Visio (UML), PL/SQL, Toad

Client: Toshiba Mitsubishi Electrical Industrial Sys – US & JAPAN Region May 2008 – Jan 2009

Project: New Drive Navigator (NDN)

Role: Developer, Onsite coordinator

NDN has ability to communicate with drive and exchange information efficiently. NDN provides ability to user to set various parameters and variable inside the drive to monitor as per the specific application in the process. NDN displays drive data in a trend - displays graphically data signals. NDN also facilitate user to upload and download desired drive parameters during configuration and commissioning drive. Downloaded data helps user for offline evaluation. System provides Wizards; make drive product expertise available to user. It allows monitoring drive functions friendlier. NDN maintains user notes and solution help to solve out diagnostic problems.

Responsibilities:

WinForms application, developed for windows based product

Designed and developed customized installer using MS DOTNET 2008.

Development of new requirements using VS.Net 3.5

Used XML configurable files to remove hardcoded values from application

Created customized drop down list which will filter the content on typing

Prepared technical documents, project plan and test cases

Helped other team members to solve their issues

Environment: Windows XP/2000, VS.Net 3.5 / C#. Net, XML, Sub Version

Client: Edwards, UK March 2007 – Aug 2008

Project: Fabworks DSPU

Role: Developer

Data Simulator and Playback Utility (DSPU) is a component driven simulation tool for semiconductor production equipment; mainly vacuum pumps. Basically, it is WinForms application. The main objective of DSPU tool is to simulate data provided by vacuum pump in various scenarios as using real vacuum pumps would not be feasible every time.

There are two main goals for DSPU:

To replicate the data sent by a real pump as a playback utility to reproduce production scenarios.

Generate data based on rules set by the user to test different scenarios

Responsibilities:

Worked as module leader which is responsible for managing and guiding team

Developed “Proof of concept”, made presentation to business users, obtained approval and implemented application that takes multiple inputs and has multiple output formatted data

The input/output format includes graphical representation, CSV formatted files, SQLite DB use, XML, and third party DLLs.

Created dynamic GUI also played Defect Prevention Representative to test the quality of delivered application.

Extensive use of WinSQL tool for database changes

Environment: Windows XP/2000, VS.Net 2 / C#. Net, XML, SQLite, SQL 2005 Server, VSS, Rational Rose, Win SQL

MAJOR ASSIGNMENTS in Vision 3K Ltd: Nov 2006 – March 2007

Client: General Use, USA

Project: W2W3Online

Role: Developer

Responsibilities:

Served as sole developer from designed architecture including requirement definition, object modeling design, tier structure development and user interface definition.

Evaluated and recommended technologies including dot net version, event model, UI component framework, development environment and testing

Defined coding standard, coordinate with User interface team to create UI prototype

Environment: Windows XP/2000, VS.Net 2 / C#. Net, XML, JavaScript, AJAX, Crystal Reports, HTML, SQL 2005 Server, MS VSS

MAJOR ASSIGNMENTS in Thymus Solutions Ltd.: May 2005 – Nov 2006

Client: Prachar Communications, India

Project: MediaCare

Role: Developer

Responsibilities: I was a team leader of 6 people team. Created designed documents, data base design. I developed user friendly UI with business logic. Also, served as a sole resource to communicate with the clients for requirement gathering and problem solving.

Environment: Windows XP/2000, VS.Net 2 / VB. Net, Crystal Reports, SQL 2005 Server, MS VSS

Project: Retail Lending System

Role: Developer

Responsibilities: Responsible for requirement gathering, UI creation, data base design, implementing the business logic, report generation, creating test cases and testing the applications

Environment: Windows XP/2000, VS.Net 2 / VB. Net, Crystal Reports, SQL 2005 Server, MS VSS

Client: Bandra Pathpedhi, India

Project: BankCare System

Role: Developer

Responsibilities: Created UI, database design, coding, testing, implementation of systems and giving support to clients.

Environment: Windows XP/2000, VS.Net 1.1 / VB. Net, Crystal Reports, SQL 2000 Server, MS VSS

Client: Wonder Weaves Textile System Sep 2004 – Feb 2005

Role: Developer

Responsibilities: Front End designing, testing and maintaining the application.

Environment: Windows XP/2000, VC++

Contact this candidate