Asp.Net Sql Developer
Resume:
Khyati Shah
Sayreville, NJ *****
********@*****.***
PROFESSIONAL SUMMARY
● IT professional with around 5+ years of experience in Analysis, Design, Development, Implementation, Testing and Deployment of Web Based, Client Server and N-tier Architectures in Billing, Health and E-commerce domains.
● Used db2 catalog commands for ODBC 64bit administrator configuration for the DB2 database connection.
● Analysis and Research to find the references of the 64bit and also involved in testing those references in the application.
● Created bat file in the task scheduler using DOS commands in the VB.
● Experience in ASP.NET, C#, ASP.NET WEB API, ASP.NET MVC, VB.net, VB6, Node.js, Angular 2+, JavaScript, Jquery, HTML, CSS, SQL Server, Typescript, ADO.NET, Ajax, DOS commands, Jenkins deployment.
● Implementing MVC, Entity Data Model, responsive web pages, developed Master Pages and validations.
● Experience in the development of application using Angular 2+, Node.js, Express.js, validations and HTML, CSS.
● Implemented validations in Angular 2+ Environment and UI elements using angular material.
● Created Observables, JSON, Angular material and created template and reactive forms.
● Created Modules, Components, Services, Pipes, Auth guard, Routing for Navigation.
● Used NPM, Node modules, Rx library for fetching data using observables like Subscribe, Map.
● Experience in working Asp.net MVC by developing Controllers, Data Annotations, Models, Layouts, Views, Partial Views and Action Filters.
● Worked on Entity Framework, LINQ and lambda expressions with SQL server.
● Experience in working with Asp.net Web forms, User controls, Master Pages, Grid View, Ajax controls, repeaters and HTML, JavaScript and Css features.
● Strong understanding of SDLC lifecycle and Object-oriented programming and agile development.
● Implemented Security in Web Applications using Azure and Deployed Web Applications to Azure.
● Experience working with SQL Server 2012/2017 DB using Tables, Queries, Normalization, Store Procedures, Views, Indexes, Triggers, Cursors and Functions.
● Experience working with Custom Directives, Json and source control like Team Foundation Server (TFS), GitHub.
SKILLS
C#, MVC, Asp.net
Angular 2+, Html, Css
Javascript, Jquery, Ajax, Json
Sql server 2012/2017, DB2 11.1
TFS, Github, Jenkins Deployment
WORK HISTORY
ASP.NET C# AND VB DEVELOPER 07/2019 to 08/2021
Express Scripts Franklin Lakes, NJ
I worked as .net developer to develop the application for the Pharmacy Case Domain. It manages all the information about customers case details, medical history, Order creation, RX info of the drugs and Shipping details. Mainly worked on Customer contact facility which is backend process running in windows servers as multiple threads. It allows to record customer information and keeping records of the case details. As a developer I was mainly involved in converting the whole application in the 64bit, adding new reference for the 64bit conversion and also test the application with all configuration changes. Apart from that, I was installed and test the application in all the environments with the stress testing and work with CMDB configuration to assess the servers in the different environments. Using DB2 commands, C# and DB2 as a database, working with CMD commands for file transfer and for editing, adding and updating of records of the customer case details. The application processes multiple transactions of the customers details related to case details, case types and complains, order and protocol creation and shipping details with MQ connection, DB2 and SQL developer. I also worked with installing MQ Client for Messaging services and Db2 Client installation for DB2 Connection with ODBC in the application.
Responsibilities:
● Working with multiple servers of the production to install the CCFMW and NRXMW application.
● Created multiple threads using task scheduler for installing the Executable file of the application.
● Implemented code for Excel download functionalities in the application using free npoi cloudware using C#.
● Implemented DB2 commands to setup the 64bit DB2 Administrator and test the DB2 connection using 64bit ODBC driver configuration.
● Analysis and Research the for the 64bit references and replace it with 32bit references for the CRTS batch jobs.
● Provide the support to production and used Jenkins to build the CRTS and NRXMW application.
● Experience working with DOS commands for the mapping the drive and copy the file.
● Involved installing all the 64bit application to the new 64bit servers in all the environments and test all the events and processes in the logs.
● Experience in Client side and Server-side state management technique like Viewstate, Applicationstate, Cookies and Session.
Implemented nuget packages and Validations using javascript for client-side validations.
● Created stored procedures, Triggers and User defined functions, Joins, Subqueries in SQL server.
● Used ADO.NET Datatable, Data adapter, Dataset, Datareaders in the data layer to access, modify and delete data in SQL server.
● Implemented LINQ and Lambda Expression for data retrieval from the sql server database.
● Developed a rich and lightweight user interaction using Jquery, JavaScript.
● Design of Asp.net Master Pages for consistent look and feel and also implemented Partial views in MVC views.
● Designed, created and managed database model using MS SQL Server 2012.
● Implemented Html helpers, Validation summary, WebAPI and Data Annotations exclusively for model validation.
● Installed and used NuGet for package management and dependency resolution and use agile methodology for product development.
● Worked with Razor Views for displaying C# code in HTML. Implemented Viewbag, Viewdata, Tempdata and Session to transfer data between Views and Controllers.
● Worked with the SQL queries and knowledge of the stored procedures, indexes, triggers, views, creating tables etc.
● Design and implement web-based application using Node API, Angular 2, Angular material, Data models, Routing, Json.
· Developing Applications using Angular 2+ Dependency Injection, Routing Module, Components, Services, Authguard like canActivate and Interceptors. Used Azure App Insights for user activity & exception logging.
● Used Observables and Subjects for sharing data within different Components.
● Experience working with NPM, Node Modules including Events, Https and implement JavaScript validations.
● Implemented Routermodule and Activeroutesmodule for navigation of components and MatCardModule and SlideshowModule in angular material using angular.
● Worked with Angular build-in-directives like ngModel to perform Two-way Data binding and passed the data between the components using Input, Output and EventEmitter.
● Used various ng directives to manipulate DOM object like ngIF, ngFor, ngClass, and ngSwitch.
● Created custom Angular directives for reusable components and developed user interface using Angular and bootstrap.
● Used CORS to allow cross domain access between API and Angular application.
● CRUD operations of the database server tested using the Postman services to ensure the get, put, post functionalities are working fine.
● Experience with working on Jira and Github for source control.
Environment: DB2, Oracle SQL Developer, Asp.net, MVC 5, Entity Framework, LINQ, JavaScript, JQuery, Json, C#, DOS commands, Angular 2+, Node js, Express js, HTML, bootstrap, Css, Angular material, bootstrap.
ASP.NET MVC AND C# DEVELOPER 06/2016 to 07/2017
IHCS Technologies Pvt Ltd Vadodara, Gujarat, India
Ihcs provide healthcare solution to those who deliver care and those who receive care. Ihcs solutions enable smarter care and precision for healthier patients and communities. The application consisted of two main modules like EMR (Electronic Medical Record) and PM (Practice Management) in insync. I was primarily involved in developing and maintaining the billing, payment posting, generating charges, ERA, copay and insurance management. I was responsible for creating claims and charges, adding insurance and generating the bill. As a developer, I was involved in fixing bugs in ERA, patient statement and crystal reports and so developed some future enhancements in the insurance management and payment posting. I was involved to add and modify some parameters, used store procedures, generated new fields and function creation using JavaScript. Also, I have worked with Ajax controls using c#, asp.net for developing pop up screen.
Responsibilities:
● Design and implemented application using C#, ASP.NET, ASP.NET with MVC, AJAX, HTML, CSS, JavaScript, WebApi, XML, SQL Server, LINQ, ADO.NET using Entity Framework Database First approach.
● Used .NET Validation Controls for Server-side validations and JavaScript for client-side validations.
● Implemented User controls, Asp.net server controls, CrystalReportViewer, Sub report, Dataset for binding crystal report with reports.
● Experienced with XmlSerializer for serialization and deserialization of Dataset and for read, write and other operations in XML formatted files.
● Implemented Stringbuilder, AppendLine for add or append a string and appends the string with a newline.
● Change the structure of existing modules by converting them from two tier to three tier architectures.
● Developed and implemented some Future blocks and Pdf functionality using Jira and deploy on TFS.
● Experienced with working on Html helpers, HTTP post and HTTP get methods, Jsonresult.
● Implemented Layout View, Partial View, different rendering methods in MVC views.
● Experience with working on Jira and Team Foundation Server for source control and resolving CRM bugs and TFS bugs.
Environment: Asp.net, C#, Asp.net MVC 5, Entity Framework, LINQ, HTML, Css, Nuget, SQL Server Management Studio, JavaScript, Team Foundation Server, JIRA
ASP.NET C# AND MVC DEVELOPER 09/2015 to 06/2016
Megh Technology Vadodara, Gujarat, India
Description: Megh Technology is well-known company for developing and maintaining different types of software. I was involved in working Maroon migrates which contains Extensive knowledge and education of the top tourist destinations in India. I was involved in creating destinations and packages and also the application has booking module where users can book a trip and get inquiry. The Application allows displaying packages, events and their price. Also, I was responsible to add package, itinerary, description and information. In addition, another application is ecommerce website in which I have worked with deals page, add to cart message. I was also involved in creating layout page, modifying admin functionality and used responsive design for menus using Asp.net MVC, C#, Asp.net.
Responsibilities:
● Implemented application using C#, ASP.NET, ASP.NET with MVC, AJAX, HTML, CSS, JavaScript, SQL Server, ADO.NET, VB.Net using Entity Framework Database First approach.
● Followed the N-tier architecture for the application development with presentation layer, data access layer and business logic layer.
● Design and implementation of Asp.net Repeaters, User controls (ASCX) for code reusability.
● Experience with designing inquiry form and send mail to those users.
● Experience in Client side and Server-side state management technique like Viewstate, Applicationstate, Cookies and Session.
● Created stored procedures, Triggers and User defined functions, Joins, Subqueries in SQL server.
● Used ADO.NET Datatable, Data adapter, Dataset, Datareaders in the data layer to access, modify and delete data in SQL server.
● Design of Asp.net Master Pages with content placeholder to give the consistent look and feel for the website.
● Worked with Razor Views and implemented Viewbag, Tempdata and Session to transfer data between views and controllers.
● Implemented Data Annotations and Validation summary using html helpers for client-side validations.
Environment: Asp.net MVC 5, C#, Asp.net, HTML, Css, SQL Server Management Studio, JavaScript, Ajax, bootstrap, LINQ, Lambda expression
ASP.NET C# DEVELOPER 07/2014 to 09/2015
Interfacepro Webtech Pvt Ltd Vadodara, Gujarat, India
Description: Megh Technology is well-known company for developing and maintaining medical software. I was primarily involved in and maintaining the appointment scheduling, maintaining reports and patient history modules. In addition, I was involved to add and modify some parameters, used store procedures, generated new fields and function creation using JavaScript. Also, I have worked with multiple reports to get the information of the patients and creating appointment reminder functionality.
Responsibilities:
● Implemented application using C#, ASP.NET, ASP.NET, AJAX, HTML, CSS, JavaScript, SQL Server, ADO.NET, using Entity Framework Database First approach.
● Followed the N-tier architecture for the application development with presentation layer, data access layer and business logic layer.
● Used AJAX Updatepanel, Timer and Script manager on the serverside web application using Asp.net along with Grid View control to perform CRUD operation.
● Used ADO.NET Datatable, Data adapter, Dataset, Data readers in the data layer to access, modify and delete data in SQL server.
● Implemented nuget packages and Validations using javascript for client-side validations.
Environment: Asp.net, C#, HTML, Css, SQL Server Management Studio, JavaScript, Ajax
EDUCATION
Associate of Science Bachelors of Information Technology 05/2013
.
Contact this candidate