Mehul Barot - Lead Developer - Architect

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 7

Mehul Barot

Kendall Park, NJ 08824


Contact# (848) 600-5090
E-mail: mehbarot82@mail2one.com
SUMMARY:
 19+ years of experience in analysis, design, architect and development of client/server, web based
and n-tier application.
 Dedicated and skilled .NET Developer with extensive hands-on experience in Angular, NodeJs, Type script, SQL
Server, and Azure Cloud Architecture.
 Proven track record of delivering high-quality software solutions in various industries.
 Adept at collaborating with cross-functional teams to achieve project goals and objectives efficiently.
 Strong problem-solving skills and a passion for staying updated with emerging technologies.
 Expert in developing C# REST API along with swagger documentation.
 Fully integrated SSO authentication in multiple enterprise applications
 Good knowledge of Economic Capital Market Risk, Financial & Investment domain.
 Expert in Debugging, creating POC and RnD work.
 Extensive experience in SQL Server Database design, Database maintenance, developing dynamic T-
SQL queries, stored procedures, Functions, Views and triggers using multiple databases like MS sql
and Oracle.
 Functional domain experience involves Market Risk, Credit Portfolio management, Banking, Wealth
reporting, Media and Accounts.
 Extensively involved in System architecture, Development Life Cycle and Agile methodologies.

EDUCATION QUALIFICATIONS:
Bachelor of Engineering (CSE) – Mumbai University, India in 2004

TECHNICAL EXPERIENCE:
Technologies: Angular 15, .Net, NodeJS, Type script, Entity Framework, MVC, LINQ,
ASP.Net, C#.Net, VB.Net, Microservices, HTML, CSS, AJAX, JavaScript, JSON,
jQuery, Web Services, WCF, Windows Services
Clouds Azure, AWS
DESIGN MS Visio (Class Diagrams, Sequence Diagrams)
RDBMS and Tools: Azure SQL Server, MS SQL Server, Oracle, DB2, SQLite, MS Access
CONFIGURATION MGMT: VSTS, Git, Visual Source Safe, Sub-version, Star Team
OPERATING SYSTEM: Windows, Mac

Professional Experience:
Project under employment of AIT Global Inc, New Jersey, USA.

Client: Madison Square Garden – NYC, USA Aug 2019 – Till Date
Project: StarAwards
Role: Sr. Developer

Brief description of the project:


Star Awards Scorecard is MSG’s internal application to handle private events, view completed employee
Checklists and quarterly knowledge check assessment. Users can filter by Venue, Date Range, Employee,
Department, and/or Position to proceed for checklist or complete their knowledge assessment based on job
performed at the time of event(s). This system will give many kind of information to business like, list of events
and the checklist associated with it, a summary view of an individual’s scores broken down by category (Guest
Experience, Knowledge Check, Ops/Financial, Overall Score, Completed Checklists) and has the ability to drill

Mehul Barot Page 1 of 7


down to individual score breakdown, compliance report, ranking reports for the performance of employee
during quarterly knowledge assessment.

Responsibilities:
 Led the development of large-scale web applications using ASP.NET Core and Angular, resulting in
improved user experience and increased customer satisfaction
 Designed and implemented robust and scalable backend solutions using C# and .NET technologies,
ensuring high performance and reliability
 Analyze functional & business requirements and enhance the applications to comply with new
regulations and requests.
 Meeting with business and system analyst to understand the requirements and provided required
suggestions for better implementation
 Utilized Azure Cloud services such as Azure App Services, Azure Functions, and Azure SQL Database
to deploy and manage applications in a cloud-native environment
 Integrated MS Azure AD authentication to the application
 Multiple angular version migration completed successfully. From Angular 6 to Angular 9 and later on
Angular 15
 Initiated, document, design and architecture of Azure to AWS migration, that involves design and
implementation of nodeJS APIs, dockerized the application.
 Explored and implemented multiple Kendo UI and MUI components.
 Converted standard application into responsive designs to support most of the devices
 Database first approach used for database handling in Entity Framework
 Extensive work on database objects like tables, views, stored procedure, functions and user types
 Worked on Agile process and Azure dev ops, performing build and deployment
 Implemented continuous integration and continuous deployment (CI/CD) pipelines using Azure
DevOps, resulting in faster and more reliable software delivery
 Conducted code reviews and provided constructive feedback to team members to ensure code
quality and adherence to coding standards.
 Collaborated with cross-functional teams including product management, design, and quality
assurance to deliver features on time and within budget
Environment: Windows 10, Angular 6/9/15, TypeScript, ASP.Net Core, C# .Net, Kendo UI, Azure SQL Server,
Azure Could, Entity Framework, LINQ, Bootstrap CSS, Azure DevOps, GitHub

Client: GS1US – NJ, USA Oct 2018 – Aug 2019


Project: DataHub
Role: Sr. Developer

Brief description of the project:


GS1 US Data Hub combines three powerful online tools. Now you can easily identify, create, manage, use, and
verify data through one convenient, data-sharable platform. Powered by GS1 Standards, the integrated tools
within GS1 US Data Hub help improve your key business processes by:
 Creating and managing product identification data like U.P.C.s and barcodes
 Using accurate location data to drive accurate shipments
 Identifying companies and products associated with data and barcodes
 Creating, using, and sharing quality data

Responsibilities:
 Managing multiple applications and clients.

Mehul Barot Page 1 of 7


 Meeting with business and system analyst to get good knowledge of the requirements and providing
required suggestions for better implementation
 Working on SCALED Agile process (SAFe)
 Multiple applications are using various technologies like Angular 7, Kendo UI Grid, Swagger, MS Azure
cloud, VSTS etc.
 Extensive TypeScript Programming.
 Implemented SandGrid for email communication.
 Utilized CosmosDB for storing large product information.
 Extensively using REST APIs for UI/Server-side communication.
 Database first approach used for database handling in Entity Framework
 Managed production support deployment and issue handling
Environment: Windows 10, Angular 1.x, Angular 7, Web API 2, C#. Net, SQL Server 2014, Cosmos DB,
SandGrid, Azure Could, Entity Framework 6.0, JavaScript, LINQ, XML, Bootstrap css, VSTS

Client: J Knipper – NJ, USA May 2017 – Oct 2018


Project: Samplicity
Role: Sr. Developer/Lead

Brief description of the project:


J Knipper is one of the largest in Pharmaceutical IT service provider. They develop various online systems
required for Reps and Doctors. Samplicity is the platform for Reps; which helps them placing various
drugs/non drugs item online and in secure way. It is online e-commerce for medical related people. For now
Reps use it and in future it would support doctors to order drugs for their patients. J Knipper offers their
services to Pharma giants like Novo Nordisk, Allergen, Orexigen, Amarin etc.

Responsibilities:
 Managing multiple applications and clients.
 Meeting with business and client service members to get good knowledge of the requirements and
providing required suggestions for better implementation
 Application is using Angular 4.0 with other latest technologies including NodeJS, MS Azure cloud,
Swagger UI, ABP authorization, Hangfire etc.
 Intense use of bootstrap to support application in multi dimensional devices like windows, tablets,
mobile phones.
 Code first approach used for database handling using Entity Framework
 Used Mulesoft for service migration and scheduling.
 ABP authorization used for login security.
 Have used pipes and re-usable components for handling common controls.
 Managed production support deployment and issue handling
 Following Agile Scrum methodology
 Using Sharepoint 2013 for managing the requirement and design documents
Environment: Windows 10, Angular 4, Web API 2, C#. Net, SQL Server 2017, Entity Framework 6.0, JavaScript,
LINQ, XML, Bootstrap css, GitHub, Hangfire, Mulesoft

Client: IPSOS – NJ, USA March 2016 – May 2017


Project: IHG Survey
Role: Sr .Net Developer

Brief description of the project:

Mehul Barot Page 1 of 7


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 brief 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
 Used .Net framework 4.5, Angular 2, MVC 5.0, ASP.Net, C#, VB.Net, ADO.Net for creating different
modules and GUI for application.
 Added many customized controls in MVC 5.0.
 Extensively used JSON Sources to make application dynamic
 Added external control for getting video inputs from guest
 Used JQuery, Javascripts, CSS, Bootstrap css, XML, etc.
 Extensively used SQL triggers, stored procedures, functions and views.
 Have used dynamic queries multiple times to make application dynamic.
 Debugging application and providing production support
 Quick fixes for production related defects/issue. Code clean up and fixes
 Implemented SAML (Single sign on) for portal application
 Migrated application to new server which including managing IIS Server
 Managed to accomplish SSIS package to load large files into database
 Work allocation done using Agile Scrum methodology
Environment: Windows 7, Angular 2, MVC 5.0, ASP.Net 4.5 / C#. Net, VB.Net, SQL Server 2012, JavaScript,
JQuery, LINQ, JSON, XML, Bootstrap css, Sub version, GitHub, IIS 8.5

Project under employment of IGate Technologies Inc, New Jersey, USA.


Client: Chubb and Sons – Warren, NJ Oct 2014 – Feb 2016
Project: Predictive Modelling-Claims
Role: Tech Lead (Sr .Net Developer)

Brief description of the project:


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 separate applications in MVC and Angular 2 for business user
 Created and consumed Web service using SOAP and REST.
 Worked on existing WCF to modify it as per the business requirements
 Worked on WinForm app including multi-threading for text extraction process

Mehul Barot Page 1 of 7


 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.
 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, debugging and production issue resolving.
 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, VB.NET, MVC, Angular 2, SQL Server 2012, Oracle 11g,
JavaScript, Web services (SOAP and REST), WCF, Jazz, nUnit testing, IIS 7.5

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


Project: Risk Frontier (Project 1)
Role: Sr .Net Developer

Brief description of the project:


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 many ways of viewing portfolio output to improve understanding and identify
problem areas.

Responsible for:
 Working as Team Lead/onsite coordinator, that 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
 Used multi-threading to achieve parallel execution for WinForm application in VB.Net.
 Understanding and discussing, Investment and Financial terminologies to implement changes from
business in the application

Mehul Barot Page 1 of 7


 Written stored procedures, Functions, Views, triggers using SQL in SQL SERVER 2008.
 Used SSIS packages to load data
 Written the dynamic t-SQL queries to meet uncertain data insertion/update requirement.
 Written code to upload Generic excel data files to database
 Developed Windows Service to kick of the process to consume file data when the files are available.
 Used CSS, 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 and debugging the application.
 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
 Code verification and making sure the requirements are addressed (Code review of the deliverables
from offshore)
 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.
 Worked as server admin for configuring IIS 7.5 for application and Share point site.
Environment: Windows XP/2008, ASP.Net 3.5 / C#. Net, VB.NET, SQL Server 2008, Ajax, JavaScript, Web
services (SOAP), Star Team, Export to Excel report, MS Visio (UML), Remedy, Buildforge, Quality center 10, IIS
7.5

Project: iTracker (Project 2) Jan 2009 - May 2010


Role: .Net Developer

Brief description of the project:


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 that 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.
 Debugging application
 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.

Mehul Barot Page 1 of 7


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, IIS 6

Other projects
Client: Toshiba Mitsubishi Electric Industrial System (USA/Japan) May 2008 – Jan 2009
Project: New Drive Navigator (NDN)
Role: .Net Developer
Environment: Windows XP/2000, VS.Net 3.5 / C#. Net, XML, Sub Version

Client: Edwards, UK Mar 2007 – May 2008


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

Project under employment of Vision 3K Technologies, Mumbai, India.


Client: Public Nov 2006 – Mar 2007
Project: W2W3Online
Role: Software Consultant
Environment: Windows XP/2000, VS.Net 2 / C#. Net, XML, JavaScript, AJAX, Crystal Reports, HTML, SQL 2005
Server, MS VSS

Project under employment of Thymus Solutions Ltd, Mumbai, India:


Client: Prachar Communications - Mumbai, India May 2005 – Nov 2006
Project: MediaCare
Role: Team Lead
Environment: Windows XP/2000, VS.Net 2 / VB. Net, Crystal Reports, SQL 2005 Server, MS VSS

Mehul Barot Page 1 of 7

You might also like