Post Job Free

Resume

Sign in

Stack Developer Sql Server

Location:
Denton, TX
Posted:
December 20, 2023

Contact this candidate

Resume:

Sr.Net Full Stack Developer

Name: Nikhil

Email: ad1313@r.postjobfree.com

Contact: 940-***-****

Current Location: Dallas, Texas

LinkedIn: https://www.linkedin.com/in/nikhil-kumar-453bb2290/

Professional Summary:

•Over 8+ Years of IT experience with Involvement in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of Web Based, Client-Server and N-tier Architectures.

•developing Win Forms, Web Services, Web Pages using ASP.Net, ADO.NET, Visual Studio (2015, 2013, 2010, 2008, 2005), IIS 5.0/6.0/7.0/8.0, N Service Bus, VBScript, JavaScript, Angular Angular10/8/7/6/5/4/2.0, Type Script 2.0/2.1/4 & Web API 2.0, Bootstrap 3.0, HTML and SSRS Reports. SQL Server 2012/2008/2005.

•Proven ability to lead, manage project resources, interact with clients, coordinate, and work in achieving high levels of productivity and efficiency in complex, dynamic and challenging environments.

•Good experience working with financial and investment Security and with Insurance clients. Experience in developing and deploying Web Forms, Win Forms, and Web service applications extensively.

•Creating React.js / Flux / Redux front - end UI, and Node.js applications.

•Experience in automation and manual testing of websites and web-based clients using Selenium, Junit, TestNG and Selenium WebDriver.

•Extensive design experience with web technologies like HTML5, DHTML, AJAX, CSS, Bootstrap, JavaScript, TypeScript 2.0, jQuery, VBScript, Angular JS 2.0/1.5, Knockout JS, React JS, Required JS and Knockout JS.

•Expertise in Angular 5/4/2/JS controllers, directives, components, factory and service resources, routings and events.

•Extensive experience in working with C#, ASP.NET, Angular JS, MVC, SQL Server, WPF, CSS, HTML etc.

•Involved in use of Angular 2.0 technologies to include, Node.js, LESS and additional technologies to ensure current migration from Angular JS 1.6 to Angular 2.0.

•Extensive experience in Building web applications using Kendo UI widgets, jQuery, Angular 4.0/2.0/JS.

•Good Experience with Unified Modeling Language (UML) standards and documentation and experience in preparing Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams using design tools such as Microsoft Visio.

•Possess excellent abilities in developing database programs like Store Procedures, Joins, Triggers, Views, Cursors, Packages and implementation scripts on ANSI-SQL, PL/SQL and T-SQL using MY SQL, ORACLE, and SQL SERVER.

•Experience working with XML, XSLT, XQUERY, and XPATH and worked with libraries.

•Expert in Object Oriented analysis and design (OOAD), Service Oriented Architecture (SOA) and Model-View-Controller Architectures (MVC).

•Developed Bootstrap responsive web application pages using Angular.JS services, controllers and directives for front end UI and consumed RESTful web service API.

Technical Skills:

Development Tool (IDE)

Visual Studio 2017/2015/2013/2010/2008

Programming Languages

.NET Core, ASP.NET 4.5/4.0/3.5/3.0/2.0, ASP.NET Web Forms, Web-Service, Win Forms, WPF, Microsoft .NET Entity Framework 6.0/5.0/4.0/3.0/2.0, ADO.NET, ASP.NET MVC 5.0/4.0/3.0, WPF, Web API.

JS Framework

Angular 6/7/8/9/10/11, React

Web Technologies

ASP.NET, HTML/DHTML, CSS, XML, JSON, JavaScript, jQuery, ASP.Net Ajax 3.0/2.0

Databases

MS SQL Server 2014/2012/2008/2005, MS Access 2010/2007 and oracle 19g/11g/10g, RDBMS, NO SQL

Middleware

REST API, WCF, Web Services and ADO.NET 4.0/3.5/3.0/2.0,

Configuration & Version Control Tools

Visual Source Safe -VSS, Team Foundation Server-TFS, GIT, Bitbucket, JIRA

Reporting /ETL Tool

SQL Server Reporting Services (SSRS 2008/2005), Crystal Reports, RDLC. Informatica ETL.

PROFESSIONAL EXPERIENCE:

Client: BCBS - Chicago, IL Oct 2021 to till Date

Sr.Net Full Stack Developer

Responsibilities:

•Credit Suisse Group AG is a global investment bank and financial services firm.

•Extensively involved in developing components for Business Logic and Data tier using C#, ASP.NET MVC, and ADO.NET.

•Involved in Requirement Analysis, gathering, Low Level Design, Coding, and Integration.

•Worked on multiple projects as part of the IT backbone team, Projects were mainly based on Angular 7, Angular.JS, C# .NET MVC based full stack applications.

•15 members based on AGILE Methodology Sprints.

•Enhancements to the Angular.JS based front end portal application to provide loan and refinancing options to the customer and partners. Worked on the enhancements, fixes, and front-end validations to support the existing PHP based backend validation for the partner portal.

•Part of the development team of the Angular 7 based pricing calculator portal to get the pricing quotes for the customer/partner.

•Enhancements/fixes for the C# .NET MVC based full stack applications for the cheque request application and its integration with workday.

•UI layer Implementation for dashboard, quick editing, approval workflow, alerts, DAL layer integration. Defect and Task management on TFS. Testing and defect resolution.

•Used Microsoft Teams & AWS Code Commit for the purpose of Version Control and Source Code maintenance needs.

•Facilitating daily scrum meetings, enforcing timeboxes and responding to the impediments, tracking baseline, sprint planning and sprint retrospective

•Used Microservice architecture, based services interacting through a combination of REST and leveraging AWS to build, test and deploy Identity Microservices

•Experience in designing and developing Microservices for the business components using .NET framework.

•Involved in complete application stack in Amazon Web Services (AWS) like EC2, S3 Bucket

•Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS)

•Working with the Business Analyst team to understand the business needs and analysis. Support pushes to the test and production environments.

•Support, Enhancements on the other backbone applications mainly in C#.NET MVC based applications supporting Quicken Loans Accounting, HR, Facilities business needs based on Agile methodology.

•Responsible for designing and developing the Application using ASP.Net MVC 5, Razor Syntaxes, Razor view engine.

•Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using jQuery and getting the Data back as JSON and parsing it onto the UI.

•Installed and configured SharePoint Portal Server (SPS) with Windows Server IIS and SQL Server with Information Systems Management.

•Migrated SQL data to the SharePoint lists and synchronized them for the daily updates.

• Created Stored Procedures, Functions, Views, and Triggers in MS-SQL database using T-SQL for regulate and maintain complex data.

Environment: C#, .NET, MVC 5, Angular 7, Angular JS, ASP.NET, jQuery, JavaScript, HTML, Bootstrap 3, EntityFramework.6.1.3, MS SQL Server 2014, MS Visual Studio 2015, GIT repo, MS TFS, Windows OS, Selenium Automation, Jasmine Unit tests, Docker container.

Client: Walmart - Bentonville, AR Dec 2018 to Sept 2021 .Net Developer

Responsibilities:

•Worked on enhancements of the Disaster Recovery application. Developed in MVC, C#, ADO.NET, Entity Framework supported by SQL Server, Oracle, and DB as a backend.

•Worked with WEB APIs to make calls to the web services using URLs, which would perform GET, PUT, POST and DELETE operations on the server.

•Involved in creating a Web API with Entity Framework and Used Postman to test Web API functionality.

•Involved in the analysis of the requirements as per the functional document/use cases.

•Designed and developed the presentation (UI) module in the project using ASP.NET MVC and C#.

•Developed various class libraries using C#.

•Worked on Continuous Integration CI/Continuous Delivery (CD) pipeline for Azure Cloud Services.

•Used Team Foundation Server (TFS) for source code management.

•Worked with Oracle PL/SQL Queries using joins, Indexes and in creating Tables, Views, Indexes, writing Stored Procedures, Functions and Triggers using Oracle 11g, Maintaining Database, and Query Optimization.

•Involved in all stages of SDLC including designing, coding, testing, and implementing the application following Scrum (Agile) methodology.

•Developed .NET Core, MVC Web API based on departmental requirements and specifications.

•Used various bootstrap components like accordion, date picker, alert, buttons, modal and react- bootstrap components.

•Converted .Net application to Microsoft Azure Cloud Service Project as part of cloud deployment.

•Hand-on Experience on High Availability Methodologies for Azure Cloud and SQL 2014 AOAG

•Migrated the existing SharePoint sites to .Net MVC with Azure cloud environment.

•Created a RESTful Web API service using .NET core Web API to generate data for the EMS which was then consumed in the front-end by AngularJS.

•Developed stored procedures, triggers, cursors using Oracle for authorization and card details database.

•Utilized Kubernetes for the runtime environment of the CI/CD system to build, test deploy.

•Implemented REST APIs with azure service fabric stateless Microservices using ASP.NET Core.

•Transformed conceptual designs into interactive user interfaces using HTML5 CSS3 and Bootstrap.

•Designed SSIS package which extracts data from excel, validate the data, and load it into the staging table. Data will be loaded into the main table once the business validations/rules are successfully passed.

•Worked on implementation of business components that will update and save the database in a transaction.

•Implemented Network traffic rules and Access Control Lists (ACL) for Virtual Network in Microsoft Azure Cloud Service Platform

•Used TFS for code management and version control.

•Involved in creating a console app which will generate the report to cross verify error logs of different jobs in the project and scheduled using Control M.

Environment: .NET Core, MVC, WEB API, jQuery, JavaScript, React.JS

Client: State of New York, NY Aug 2017 to Nov 2018

Sr .Net Full Stack Developer

Responsibilities:

•Primary Responsibility to Study the requirements of the clients and the specific needs of the business projects since I am leading a department of six programmers estimated all design work and assigned to department.

•Actively involved in coding and designing using ASP.NET Master Pages, Themes, Skins, MVC, ADO.NET, Web API, JavaScript, XML, JIRA, CSS & Visual Studio.Net 2012/2013/2015, Entity framework.

•Used CI/CD tools like deploy, Stash and Docker, Jenkins, Agile Methodology (Scrum, Jira)

•Using C# to create custom objects to handle functions difficult to implement with PowerShell.

•Developed RESTFUL/WCF Web services, APIs, and other back-end components to support new business requirements.

•Implemented SQLite database with Xamarin forms to save necessary information into device local database.

•Worked on cloud computing using Windows Azure and SQL Server Azure.

•Experience in healthcare integration experience with HL7 and HIPAA.

•Utilized LINQ and ADO.NET, LINQ to SQL, LINQ to XML was used to connect to SQL database, Data Context, and XML data source and wrote SQL scripts, functions, and stored procedures to extract data from the server.

•Resolved Database related trouble tickets assigned to the DBA group.

•Experience in Azure Services such as Web Roles and Worker Roles. Developing and deploying. NET based Web Applications and Websites into the Azure Services. Monitoring Website Resources using APIs, RESTful, SOAP and PowerShell.

•ASP. NET validation controls such as Regular Expression Validator and Custom Validator was used to validate the information provided by the user.

•Refresh databases from Production to test, dev etc.

•Developed User interface module HTML5, JavaScript, ReactJS, JSP and jQuery.

•Created test databases from the production environment as per development team requirement for testing purposes.

•T-SQL/Stored Procedures on Oracle 9i and 2000/2005/2008 MS SQL Databases; MS SSIS and Reporting Service and legacy Crystal reports and .Net based crystal report.

•Worked on Visual Studio 2015/ .Net CORE 1.0 Framework to implement Business Logic.

Environment: Visual Studio 2012/2013/2015 IDE, C#, ASP.NET, TFS, ADO.NET, Web API, XML, IIS, HTML5, CSS3, JavaScript, Razor, WCF, WPF, Sitecore, Azure, SQL Server 2012, SSMS/SSIS/SSRS 2017/2012/2008, .NET Framework 3.5/4.5, SQL, ADO.NET, Web Services, Angular JS, SSO, MVC 5, DevOps.

Client: Cisco, San Jose, CA May 2016 to Jul 2017

Full Stack Developer

Responsibilities:

• Developed Windows pages using WPF, Custom user Controls, User controls in C#.

• Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls, both Custom validation and JavaScript was written for Client-side validations and used the new validation controls in VS.

• Developed XML Web Services and WCF services common for various applications using .NET Framework.

•Used Microsoft Teams & AWS Code Commit for the purpose of Version Control and Source Code maintenance needs.

•Used Microservice architecture, based services interacting through a combination of REST and leveraging AWS to build, test and deploy Identity Microservices

•Involved in complete application stack in Amazon Web Services (AWS) like EC2, S3 Bucket

•Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS)

• Create and develop new features for the Auto loop/Service Book/ASR3 products Developed cross browser compatible, customer facing online application based on n -Tier architecture.

• Hands on experience in Visual Studio.NET IDE to design the forms, develop and debug the application.

• Involved in building a rich web experience using JavaScript.

• Used Ajax tool kit, Multi views, regular expressions, regular expression validates, user search controls

• Extensively used ADO.NET, XML in Order to get the high-level performance for the web controls.

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL-SQL in Development and Production environment for SQL.

• Worked on Web API for interacting the Angular App to the business logic layer of MVC.

• Worked on creating the database and developed multiple T-SQL Procedures, Functions and SQL Queries that can handle the business rules. Utilized Data Access Components, Web Services and Business Layers.

• Implemented Forms-based Authentication in ASP.NET to authenticate the users.

• Extensively worked with Datasets to reduce hits to database server.

• Developed test cases and performed unit testing.

• Have done unit testing and integration testing after completion of module coding

• Developed SQL queries, T-SQL procedures, Functions, triggers to handle the business rules data integrity and for various data transactions.

• Performed extensive Unit testing using N Unit, developed Test Plans, Test Cases.

• Team Foundation Server (TFS) was used to maintain the version and source control.

Environment: C#.NET, ASP.NET, ADO.NET, visual basic, WPF, ASP.NET, CSS, SQL Server 2008R2 and 2012, XML, Packages, Visual Studio 2013, TFS, JavaScript, SSRS, SSIS.

Client: Infosys, Hyd May 2013 to Dec 2014

Software Engineer

Responsibilities:

•Used agile methodology for the project which involved daily scrums meeting, defects discussion and Sprint Planning

•Working on the code changes existing .Net Web Application

•Writing new engine classes, business model in C# also maintaining existing classes for connectivity with SQL Server databases

•Involved in design and development of UI components, which includes layered POVs using frameworks AngularJS, JavaScript, and jQuery in conjunction with HTML5, CSS3, and Bootstrap

•Worked with jQuery and typescript for the development of the UI.

•Developed various AJAX and JSON calls for the communication between the server and the UI.

•Designed and developed database tables using oracle 11g database.

•Configured TFS automated build server and set up TFS automatic builds for the project.

•Performed Unit testing and regression testing for the project.

Environments: C#, ASP .NET, SQL, JavaScript, jQuery, Angular JS, HTML, CSS, Bootstrap, Oracle, TFS and JIRA

Education

•Bachelors in computer science – 2013



Contact this candidate