Asp.Net Sql Server

Sonam Mankar

Full Stack Developer

Email: *****.******@*****.***, Ph.: +1-502-***-****

PROFESSIONAL SUMMARY:

A .Net with 9+ years of diverse experience in all phases of SDLC involving Analysis, Design, Development, Deployment, Testing and Implementation of Client/Server applications using Microsoft ASP.NET/Core, EF/Core, MS SQL.

Good experience in Software Product Development, Process Automation, Build and Deployment Automation, Release Management, Packaging Quality Control, Source Code repository & Environment management.

Strong expertise on Azure DevOps concepts like Continuous Integration (CI), Continuous delivery (CD)

Experience in working on source control tools like GitHub (GIT).

Configured and Monitored CI CD pipelines using VSTS, and GIT.

Proficient in Deployment automation using PowerShell

Experience in working with different build automation tools like NUGET to achieve End-to-End Automation.

Development experience on.Net MVC, WebAPI, VueJs, Angular Js Basic, jQuery, Json, WCF, Entity Framework, ASP.NET, Bootstrap, VB.NET, REST API Service, C#.Net, Microsoft SQL, PL/SQL, SSRS.

Experience of working on MS Sql Server, Oracle packages, SQL stored procedures, SSIS Packages and creating various kinds of SSRS and Crystal Reports.

Experience in building CICD pipeline using Azure Dev Ops, GIT migration and Nuget repository creations.

Experience in VSTS,TFS,Gated Check - ins, Build Definitions, Release management,PowerShell, Power BI.

Experience working on Agile and SCRUM methodology and working

Experience on Web based project using Angular,JavaScript, HTML and CSS.

Developed REST/WCF Web services, ASP.NET WEB APIs and involved in pre-testing using POSTMAN and Fiddler.

Implemented Web API Routing, Filters, Parameter Binding, Dependency Injection, and hosting concepts.

Created a web API with ASP.NET Core.

Good experience in Microservice architecture and Splunk logging

Strong knowledge on C# includes OOPS concepts and Design Patterns

Strong knowledge of design and development of database using SQL Server.

Worked on SQL Server Database Security, Performance Tuning and Database Migration

Having strong knowledge SQL Server database design, maintenance, T-SQL queries, functions, stored procedures, cursors, indexes, views and triggers etc.

Strong knowledge of software best practices like Test Driven Development (TDD) and continuous integration and worked on nUnit Test Projects.

Experience in Branching, Merging, and Tagging and maintaining the version across the environments using SCM tools like GIT (GitHub, GitLab)

Have experience working on Web and Windows application development.

Exposed to all aspects of software development life cycle (SDLC) such as Analysis, Planning, Developing, Testing, and Implementing, Post-production analysis of the projects. TECHNICAL SKILLS:

Cloud Technologies Azure DevOps, CI/CD Pipeline

Technologies .Net, >net CORE

Web Technologies ASP.Net, HTML 5, MVC, Bootstrap, VueJs Programming Languages C#, VB.NET, HTML, CSS, SCSS

Scripting Languages TypeScript, jQuery, JavaScript, AngularJs Basic Databases SQL Server, Oracle, DB2

Version Control GIT, TFS, GitHub, SVN

Database Tools SQL Server Management Studio.

Editors VS 2019/2022, VS Code

.Net Frameworks .Net Framework 2.7-4.8. .Net Core 2.1 – 3.1 Methodologies Agile, Waterfall

WORK EXPERIENCE:

Atos Syntel, Louisville KY (Humana Client) Aug’19 - Present Role: Associate Cosultant

FNDB – Financial Dashboard is part of Premium Billing System, PBS is built specifically to handle the online billing payment to Humana. Since, FNDB is directly related to the Revenue of Humana so FNDB considered the most crucial application. User can maintain payment information, set recurring payment see monthly invoice information, make onetime payment, manage user specific billing preferences. Responsibilities:

• Work on the UI framework development using the technologies like VueJs, HTML, SCSS, Bootstrap

• Created and Consumed the SOAP service, WEB API. And APIC

• Analysing user requirements and defining functional specifications using Agile methodologies and visual studio. Designing web-based applications using .Net Core, .NET MVC

• Work on various VueJs material components like dropdown, checkbox, multiselect options, etc

• Work with the testing team to execute the test validations

• Work on different project where the js script is used to give the post calls from the UI to the backend for the statistics purpose.

• Work on the git as a versioning system tool to integrate code with other developers

• Worked upon integrating rest APIs

• Followed Agile methodology with daily scrum meetings and providing user story updates worked with Azure DevOps.

• Implemented the Automation framework using Visual Studio Team System to implement the functional testing of the .Net applications

• Work on the reusable components, and always finding ways to improve the solution to improve performance

• Host & Install Application, Web service and Web API to the system environment Environment: Visual Studio Ent 2019, Visual Studio Code, HTML5, WebAPIs, .net Core, jQuery, VueJs, JavaScript, Azure Vsts, Git, APIC,Apigee,DB2,WebServices

Atos Syntel, Louisville, KY (Humana Client) Sep 2020 – Nov 2021 Role: Associate Consultant

Broker Alert is a web application that Agent can view their payments through Groups & Individual using broker Alert activities table and encourage them to pay Humana ASAP. Responsibilities:

• Involved in software Development Life cycle like Requirement Analysis, Design, Implementation and Testing.

• Work with backend team closely to integrate the APIs to the front end application

• Analysing user requirements and defining functional specifications using Agile methodologies and visual studio. Designing web-based applications using .Net Core, .NET MVC

• Work Followed Agile methodology with daily scrum meetings and providing user story updates worked with Azure DevOps.

• Created and Consumed the SOAP service.

• Worked on CI/CD pipeline for code deployment and migration.

• Deployed the application into the Azure and extracting the data from the Azure cloud services

• Constantly work on the enhancements of the application and follow the agile methodology

• Work on the git as a versioning system tool to integrate code with other developers Environment: Visual Studio, HTML5, CSS3, Asp.net, C#, jQuery, JavaScript, Git, DB2. Atos Syntel, Louisville, KY (Humana Client) Sep 2017– July 2019 Role: Associate Consultant

Humana PayNow or ExpressPay which does not provide much options and flexibility like FNDB but on this portal user do not have to worry for FNDB complexity and pay their premium amounts directly as onetime payment. User can choose to due payment in one go, pay extra payment or choose to fraction of amount for payment. Payment can be selected to be processed same time as soon as payment done or it can request to schedule it Responsibilities:

• Work on the framework for the client using HTML5, CSS, MVC, asp.net

• Worked on writing and amending the test cases

• Involved in a day-to-day Scrum agile methodologywith all stories tracked in VersionOne and VSTS.

• Work with the testing team to execute the test validations

• Extensively worked in ASP.NET MVC, WEB API for implementing Business logic and Data Layer between UI and MS SQL Server, DB2 etc.

• Constantly work on the enhancements of the application and follow the agile methodology

• Work on the git as a versioning system tool to integrate code with other developers

• Implemented Business Logic Layer and Database Access Layer using Object Oriented (OOPS) concepts and C#.

• Wrote Data Access Layer Methods,SQL Queries, Store Procedures, and SQL User Defined functions for fetching Transaction details, Customer Details, and Product Configuration data.

•

Environment: Visual Studio, HTML5, CSS3, Asp.net,MVC, jQuery, JavaScript, Java, Git. Atos Syntel, Louisville, KY (Humana Client) Sep 2017 – Feb 2019 Role: Dot net Developer

Humana Billing Dashboard is internal reporting tool system for Humana that user can download, view and take printout of Account summary, Payment transaction, communication summary, Premium transaction and email preferences. Also they can view monthly and daily graph in chart format. Responsibilities:

• Generated different types of reports like Tabular, Matrix and Charts. Extensive use of Pie, Column and Line Charts using SSRS.

• Managed and handled queries using DB2 database.

• Involving in the development of code as per the business requirements and deployment of application.

• Involving in daily basis client call & status update.

• Taking care of new requirement and managing all the enhancement and task.

• Deployed and configured SSRS reports in SQL Reporting Services Server.

• Unit testing of the developed code.

• Coordinated with other team to resolve the SSRS server issue for production and lower region.

• Deploying reports on lower region to Production region Environment: Visual Studio, SSRS, C#, ASP.NET, DB2, SOAP Services, MVC, JavaScript, Jquery, CSS Syntel, Pune India (Allstate Insurance Client) Apr 2016 – July 2017 Role: Dot Net Developer

Allstate was looking to serve customers at the first contact point through a multi-channel model, providing products and services that customers need and in ways they are most comfortable in interfacing with. As part of CFR initiative, Supplier is already working with Allstate to enhance AOS application in difference areas, i.e., Auto, Renter’s Cross Sell and Motor Cycle.AOS (Allstate Online Sales) is a unified platform targeting customers accessing the application via desktops and mobile devices. The aim of the responsive web application is to provide customers quotes (Auto, Renters, Motorcycle, ORV & Home) and the ability to purchase them online. Responsibilities:

• Participates in activities such as design, reviews, problem solving, gap analysis, and configuration resolutions.

• Participates in creation of deliverables and quality review as needed.

• Work on copies of project deliverables and supporting documentation (e.g., including meeting notes, data collection Templates, etc.), as requested.

• Work on support to the user for application related issues

• Work on new enhancement for the Online Sales application as per suggestion by client.

• Work on Unit testing and Execution of Pre-UAT while enhancing the application in quarterly releases.

• Coordinate with the other application to handle the Online Sales application releases.

• Understand well the spring boot applications so as to integrate the APIs in the backend with the frontend

• Co-coordinating with testing team to execute test validations in various test phases that includes System Integration Testing, (User Acceptance Testing(UAT) Environment: Visual Studio, C#, ASP.NET, Code Migration, DB2, SOAP Services, MVC, JavaScript, Jquery, CSS Time Legend IT Solution Pvt Ltd., India Mar 2015 – Feb 2016 Role: Developer

FACTS is Financial Account Customer Tracking System. It is the main application of Travels System. This project helps to Create & maintain tours & travels details of Airline, Car, Hotel etc. It contains various modules like: Ticketing Process, Invoicing process, Accounts Receivable (Bill By Bill Receipt), Accounts Payable (Bill By Bill Payment). As per financial year it will maintain all ticketing, passenger details. FACTS create Invoice, Refund, Receipt, Payment reports for each

& every ticket.

Responsibilities:

• Worked as a .NET Developer in team.

• Played a Key role in designing, Development, testing and implementation of various modules of project.

• Design and developed Web forms, classes and database management.

• Involved in interaction with user, gathering requirement, understanding business logic, development, user acceptance testing and unit testing.

• Created and delivering ad hoc and routine reports as requested

• Achieved the customer satisfaction by creating admin management pages

• Created UI using the bootstrap, CSS3, HTML5

Environment: Visual Studio, C#, ASP.NET, SQL SERVER 2008, AJAX, Web Services, Crystal Report, JavaScript Time Legend IT Solution pvt Ltd., India Dec 2014 –Feb 2015 Role: Dot Net Developer

QUADLAB Xchange Integrated System The requirements and scope of this project is creating Web Service methods for Financial Export (Win-Yatra) Accounting System to fetch the required data from XChange system for the respective XChange Customer. Financial Export (Win-Yatra) Accounting system wants the Customer to maintain the database at its own end and they should be able to connect to the respective database server directly to fetch the data and update the fetched data so that it’s not picked the next time. Due to the security reasons, XChange system would not expose its SQL server database to any third-party system and hence would rather provide a webservice which the third party can use to access the data from the XChange customer. Responsibilities:

• Created & Handled more than 500 lines of Stored Procedure.

• Created & Integrated Quadlab Web Services to this Project.

• Involved in interaction with user,gathering requirement, understanding business logic, development, user acceptance testing and unit testing.

• Maintain existing software systems by identifying and correcting software defects

• Helped in improving performance of the application by using reusable components and improved the performance of the application by 80%.

•

Environment: C#, ASP.NET, SQL SERVER 2008, Web Services, JavaScript Time Legend IT Solution pvt Ltd., India

Role: Dot Net Developer Dec 2013 -Feb 2014

ERP Eternal this project basically contains most of ERP modes needed in manufacturing industries at present. Project includes many important modules like Factory cash handling, Moulding production, Non Production items, Assembly construction, VAT and Taxation analysis, Accounting and finance etc. The addition of AJAX controls, Crystal Report strong database design really improves the quality and flow of project. Responsibilities:

• Created Worked as a .NET Developer in team.

• Played a Key role in designing, Development, testing and implementation of project.

• Design and developed Web forms, classes and database management.

• Involved in interaction with user, gathering requirement, understanding business logic, development, user acceptance testing and unit testing.

• Worked on modules like Bill of management, Account and finance.

• Solved and delivered the many critical problems occurred during development. Also was responsible for changes in code to meet the customer requirement during UAT phase.

• Given KT to the team to understand the code and requirements.

• Received appreciation for active participation and handling the responsibility to manage design and development.

• Assisted development team with change management requests Environment: C#, ASP.NET,SQL SERER 2008, AJAX, Web Services, Crystal Reports, JavaScript EDUCATION:

Bachelor of Engineering in Computer Science

Govt. College of Engineering, RTMN University June 2011 CERTIFICATION:

• Azure Fundamentals (AZ-900)

• Certified Scrum Master

• Microsoft .Net

Contact this candidate