Sql Server Asp.Net

Rohan

Asp.Net Lead

*** **** ******, *******, *****,

UnitedStates,

email id: ************@*****.***

Phone: 314-***-****

Professional Summary:

Rohan has around 10+ years of IT experience in designing, developing, and customizing web-based applications using .Net framework. He has worked in the capacity of Technical Lead and Sr. developer on various projects.

He has extensive experience in developing CRM suit of products such as SFA, CRM, Campaign Management and SOA based UI application using various emerging Microsoft technologies, latest java scripts libraries and developing Single Page Application using MVVM, AngularJS, reactJS, Web API Core, Entity Framework Core, Dependency injection, ADO.NET, WCF, Web Services, Windows Services, JavaScript, jQuery, HTML, CSS, AJAX, MSMQ, SSIS, SSRS, MS SQL server,

He has worked on services and APIs related to MS Exchange Server (EWS API).

He has extensively worked in Healthcare and BFS vertical with some of the premier clients such as Aetna Inc., Emblem Health, Wells Fargo, etc.

Excellent knowledge on development and enhancement projects, good experience in client interaction with regards to gathering business requirements and producing an effective information system solution.

He has played various roles including developer, team lead and involved in various innovations related activities.

Responsible for designing web pages using the concepts such as Master Pages, Membership and Role Management, Themes, Skins, HTML, XML, CSS, Java Script, and User Controls.

Extensively used Windows Communication Foundation (WCF) & Web services for Web applications using SOAP, WSDL.

Excellent experience in writing Data Access Layer classes using Entity Framework and ADO.Net.

Experience in report generation tools like Crystal Reports and SSRS (SQL Server Reporting services); also, worked on SQL Server Integration System (SSIS) using SQL Server 2008 R2.

Valued experience in using AJAX controls and AJAX Toolkit to enhance user experience.

Proficiently developed Single Page Application using MVVM pattern for Fortune 500 client.

Experience with business analysis and requirements in both traditional Waterfall and Agile methodologies.

Well versed with Unit Testing and System Testing.

Excellent team player and execute tasks under less supervision.

Self-motivated, excellent analytical, communication, interpersonal and presentation skills.

Technical Skills:

Web Development:

ASP.Net, C#, jQuery, JSON, AJAX, AJAX Tool Kit, VB.Net, .NET Core

MVC 5/4, MVVM, HTML5, CSS3, Bootstrap, JavaScript, Entity Framework 6/5, Angular, TypeScript

Project Management:

Kanban, Jira

Database Tools:

Microsoft SQL Server, SSIS and PL/SQL

Development Tools:

Microsoft Visual Studio 2019/2017/2015/2013/2010, Microsoft SQL Server 2012/2008 R2

Web Server:

Internet Information Services – IIS 7.0/6.0

Version/Source Control:

Cloud:

Microsoft Team Foundation Server (TFS), TFS GIT, Tortoise (SVN), Visual Source Safe (VSS), CI/CD.

Azure

Professional Experience:

Client: NFP Health, MA

April’22–Till Date

Project: FPP Role: Dot Net Technology Lead

NFP Health and Vonage, in conjunction with the third-party vendor PCI pal, has configured and integrated their system to allow call in users to:

• Validate their identity

• Be provided with their current balance and due date of payment

• Make a one-time credit card payment.

Responsibilities:

As a Tech Lead, Coordinated with offshore team for timely delivery of requirements.

Developed and managed the project plans for portfolio of CPP related projects.

Involved in providing technical guidance and architectural leadership to the team of developers both onsite and offshore.

Creation of database objects like stored procedures and views using MS SQL Server.

Responsible for migrating legacy applications to cloud based environment using MS Azure using CI/CD pipeline.

Responsible for the unit testing and participate in the Security Peer Reviews.

Environment: SQL server, SSIS, .Net Core (ASP.net, C#), JavaScript, JQuery, Angular, CI/CD pipeline.

Client: Emblem Health, New York, NY (

Oct’17–July’21

Project: CPP (Commercial Product Portfolio) Role: Dot Net Technology Lead

The Commercial Product Portfolio project is about producing and sending the communication material (such as Welcome kits, ID cards, Bill pay reminder letters, etc.) to plan members every year.

Responsibilities:

Managed the team of around 7 developers involved in developing the application using .Net Core (ASP.Net, C#) and Microsoft SQL Server.

As a Project Manager, Coordinated with offshore team for timely delivery of requirements.

Developed and managed the project plans for portfolio of CPP related projects.

Involved in providing technical guidance and architectural leadership to the team of developers both onsite and offshore.

Utilized latest concepts such as dependency injection for creating classes.

Creation of database objects like stored procedures and views using MS SQL Server.

Responsible for migrating legacy applications to cloud based environment using MS Azure using CI/CD pipeline.

Responsible for the unit testing and participate in the Security Peer Reviews.

Environment: SQL server, SSIS, .Net Core (ASP.net, C#), JavaScript, JQuery, reactJS, HTML5, Dependency Injection, Document Science (Xpression tool), Azure, CI/CD pipeline.

Client: Wells Fargo Advisors, St Louise, MO

Jun’15–Aug’17

Project: CCO Desktop Role: Sr Dot Net Developer

CCO Dashboard is a Strategic Desktop Design application. The purpose of this project is to create a Contact Center interface that is optimized for the Contact center agent and allows for efficient and effective handling of calls. The single user interface was customizable and adaptable according to a user-centered design. The Strategic Desktop Design vision is to provide an integrated tool that allows for knowledge transfer and intuitive interactions between Wells Fargo customer and Customer

Service.

Responsibilities:

Led the project team of 6 developers and 3 QA analysts from client location.

Designed and developed the user interface using ASP.Net MVC.

Familiarity with development in JavaScript utilizing frameworks such as Angularjs.

Involved in developing requirements with C# 4.0, ASP.NET, WCF and Web services in .Net 4.5 Technologies and unit testing, system testing and release management.

Worked extensively on EWS managed API of MS Exchange server to synchronize items in mail server. Mainly worked on item synchronization and folder synchronization to sync mailbox content including calendar events between client and server.

Responsible for building an internal, responsive angular single page application.

Extensively worked with Angular, MVC framework to organize our web application.

Involved in building RESTful Web API for the application which returned data from third party in secured way.

Experience on installing and configuring SSL certificates in web servers.

Created custom sequential workflows with Windows Services applications.

Used Entity Framework for data retrieving querying, storage, and manipulation interface screens developed using MVC.

Involved in cloud migration using Azure for this project.

Used Web Services (SOAP, WSDL) for communicating with other application and components.

Exposed the Web Services to the other client applications by sharing the WSDL's.

Effectively used TFS for build management and tracking bugs and Change Requests.

Involved in Code reviews and preparing unit test documents.

Working closely with the team on new development, defect fixing and major enhancements.

Environment: MVC, C#, Web API, Angularjs, Entity Framework 6, Web Services, SQL Server 2012, TFS.

Wells Fargo Advisors, St Louise MO

Project: 1MFB Role: Sr Dot Net Developer

Jan’15 - Jul’15

The Mutual Fund Breakpoint Calculator (the Calculator) allows you to determine if your clients’ domestic Mutual Fund purchases qualify for breakpoint discounts. When used appropriately, the Calculator will provide you with the information you need to enter orders into Smart Station’s Mutual Fund Order Entry so that breakpoint discounts are correctly applied.

Responsibilities:

As a senior developer, involved in gathering the requirements, conducted sessions, mentoring, and involved in the development.

Worked with existing SharePoint code, created Web parts with Visual Studio 2010 and solved bugs.

Worked with presentation, business and data access layer using VS .Net 2010.

Involved in creating technical spec document and help documents.

Created the Wireframes for presenting the prototype of this project

The wireframe design involved creating outline of structure and layout of page for key modules of 1MFB application using HTML5 and CSS.

It also involved understanding technical requirements from business stakeholders and translating it into wireframe design. Requirement analysis and Query resolution.

Apart from Visual design, also handled initial development and requirement gathering for this project.

Environment: ASP.Net, C#, HTML5, JavaScript

Client: Wells Fargo Advisors, Pune

Oct’13–Aug’15

Project: Advisory Extraction Role: Sr Dot Net Developer

Advisory extraction is a Web based application which is launched from Wisdom/Smart Station. Different brokers/advisors of the organization can log on to the application. The main purpose of this application was to store all the details about the existing as well as prospective customer accounts for the Brokerage vertical of Wells Fargo.

Responsibilities:

Designed and Developed user-interface of the project using ASP.NET, MVVM, jQuery, AJAX, reactJS, CSS3 and HTML5.

Followed Agile Scrum methodology and participated in designing and development of tasks using agile development practices.

Participated in requirement gathering and analysis

Created detailed technical design document for the application.

Provide technical guidance and assistance to development teams.

Implemented Web API controllers with all the HTTP request verbs.

Used jQuery AJAX calls to call the HTTP methods from the Web API controllers.

Created knockout.js widget subsystem within a .NET dash dashboard using typescript and inheritance. Widgets needed to react to page controls changing to refresh data and browser resizing to change styling for responsiveness

Used Bootstrap and AngularJS for developing modules in front end.

Handling Change requests based on the enhancements also involved in Bug Fixes.

Working with jQuery and Knockout.js

Involved in writing application-level code to interact with APIs, Web Services using AJAX, JSON and XML.

Involved in creating reports using SQL Server Reporting Services (SSRS).

Generated several drills down and drill through reports using SSRS.

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS).

Written Complex SQL queries and stored procedures using T-SQL, to get the data for showing in reports and enhanced the performance of existing reports.

Effectively used TFS for build management and tracking bugs and Change Requests.

Involved in preparing User Guide Document and Code reviews.

Environment: MVVM, C#, Web API, SQL Server 2008 R2, SSRS, AngularJS, Web Services, Entity Framework 6, TFS.

UBS Wealth Management, Pune

Jan’12 - Apr’13

Project: ACH (Automated Clearing House) Role: Dot Net Developer

ACH, Automated Clearing House, is a processing and delivery system that provides for the distribution and settlement of electronic debits and credits among financial institutions.

Responsibilities:

Attending the daily standup calls and sprint meetings.

Worked in agile and iterative development methodologies.

Designed and developed web forms with ASP.Net, JavaScript.

Working closely with the team on new development, defect fixing and major enhancements.

Created technical spec document and help docs.

Created reverse engineering documents, also developed Reports by using SSRS.

Improved performance of projects by optimizing SQL queries, implementing caching, and using minification & bundling.

Worked with Entity Framework Database – first approach.

Environment: ASP.net 3.5, C#, Crystal Reports, Microsoft SQL Server.

Educational Qualification:

Bachelor of Engineering in Computers, Pillai's College of Engineering, Navi Mumbai

June 2004 — January 2009

Master’s in Business Analytics, Hult International Business School, Boston-MA

Sept 2021 — Aug 2022

Contact this candidate