Post Job Free

Resume

Sign in

C# Sql Server

Location:
Parker, CO
Posted:
September 25, 2023

Contact this candidate

Resume:

(****-*******-****

EXPERIENCE SUMMARY:

Around 13+ years of IT experience 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 Architecture in domains like Telecommunication, Healthcare, Insurance, and banking domain.

Relevant 5yrs experience UI/Web application using JavaScript based web development framework using Angular, Angular JS, ReactJS AJAX, JavaScript, jQuery, typescript, Html 5, CSS 3, JSON, and Bootstrap.

Experienced in automation the manual test case in Ranorex and spec flow framework using C# and Dotnet technology.

Strong sense of ownership, ability to work independently, and have strong communication skills.

Hands-on experience in ASP.NET, C#, VB.NET, Web Services, WCF, WPF, IIS, JQUERY, JavaScript, CSS, AJAX, Crystal Reports, SQL Server Reporting (SSRS), SQL Server Integration services (SSIS) and microservices and Azure PAAS, Azure AD.

Used new cutting edge .Net technology with MVC based development, jQuery UI including various NuGet Packages and jQuery Plugins.

Extensive working experience in designing using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, Abstraction and Design patterns like MVVM, Abstract factory, Singleton, MVC.

Experience in using Language-Integrated Query (LINQ) query and retrieve data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL).

Experience in using ASP.NET AJAX framework for quickly creating efficient and interactive Web applications that work across all popular browsers.

Experienced in Service Oriented Architecture (SOA) using Windows communication foundation.

Worked extensively with ADO.NET objects such as Data Adapter, Data Set, and Data Reader to interact with databases like SQL Server 2014/ 2012/2008/2005/2000.

Experience in database related work primarily creating complex Stored Procedure, Views, Triggers, Functions, using SQL.

Experience in writing SSIS Packages/SSRS in SQL Server.

Good knowledge on components like Data Access, Exception Handling, Caching

TECHNICAL SKILLS:

Languages:Asp.NetCore,MVC,Asp.net4.0/3.5/,C#,Java,Angular,React

Database Systems: MS SQL SERVER 2014/2008/2005/2000, PL/SQL

Tools/Utilities/Others: JIRA, GIT Hub, Jenkins, Splunk, SVN, XML tools, ServiceNow, SSRS, MS Visio, ILdasm, Gacutil, Sn.exe, ReSharper

Middleware: WebAPI, Microservice, WCF, Entity Framework, Web Services

Server: Windows Server 2008/2003/NT, Microsoft IIS(7.0/6.0/5.0/4.0)

Frameworks: .Net 4.6/3.5/3.0/2.0/1. *

RELEVANT EXPERIENCE IN CURRENT ORGANIZATION:

Client Name

Remote (MUFG Bank, Denver, CO)

Project Name

OPICS Application

Project Duration

Dec 2022 – Till Date; Team size 10-15

Role/Title

.Net, Angular (Fullstack) Developer

Project Description

There are two types of source systems CLP servers (calypso appln) OPX Servers (OPICS appln). Calypso and OPICS trading platform files transform into GMART data flow into GMART for integration process to CLP MQ for reporting OPX directly writes to the GMART server.

Responsibilities

Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

As a Full-stack Developer involving design and develop UI screen using Angular, Html and Bootstrap.

Creating JSON APIs through Web API for REST service to interact with the backend databases.

Created Class Libraries and used extensively throughout project.

Developed the application using C#.NET to incorporate business logic & implemented back-end connectivity using entity framework core.

Performed code reviews to improve quality of the product.

Involved in Deployment and Troubleshooting issues in the application.

Migrated and tested each test case using Ranorex automation. requirements for automated application code management.

Leveraged Autosys for setting up automated data transfer processes and Connect Direct Servers for encrypted connection transfers, enhancing security and efficiency.

Set up a Continuous Integration (CI) pipeline using Jenkins to automate code pushes to Bitbucket, fulfilling business.

Used Jira for bug tracking. Git is used as version control tool and Jenkins is used for continuous integration of builds.

Languages / Tools

VS 2019, SQL Server 2014, Asp.net Core, C#, Agile, TFS, WebAPI, jQuery, JavaScript, Jira, HTML, CSS, Bootstrap, Angular4, Entity Framework core.

Organization Name

Cognizant Technology Solutions

Client Name

Remote (Comcast, CTS, Intellisoft Tech P Ltd, Denver CO)

Project Name

Commercial Agent Frontend (CAFE), Denver CO

Project Duration

Jan 2019 – Nov 2021; Team size 25

Role/Title

Sr. Net Developer

Project Description

CAFÉ is agent portal, helping in troubleshooting the customer issues in real time. Customer care agents will be using the cafe application in a 360 view to server customers regarding connectivity, service, and product related information.

Responsibilities

Developed user interface of application in an agile environment.

Worked effectively within collaborative team to identify and resolve issues.

Involved in sprint retrospective meetings and analyze functional and business requirements.

Strong understanding of client-side scripting and café-device, café-core libraries using HTML, CSS, JSX, and ReactJS used web pack and Babel and created components using Redux.

Changed GIT repository and merged the changes in new repository.

Monitor NOSQL Database Backup on AWS cloud

Maintain knowledge of emerging technologies like .Net core, Entity framework core.

Responsible for writing Unit Tests for the code developed.

Evolved the tech stack to include .NET Core, C#, Web API Microservice for the back end and using React JS.

Worked on Rest/Web API to create the services and tested on Postman used $http service calls for implement CRUD operation and bind the data in the table.

Developed user interfaces and web applications through use of JavaScript and other browser-based technologies.

Co-ordinate with client and business analysts’ team for understanding of requirements.

Coordinated with offshore development teams.

Developed localization APIs which stores the translated data in Azure and SQL tables deploy services on Azure Cloud.

Languages / Tools

ReactJS, JavaScript, Redux, NodeJS, NPM, ALM, Jira, Confluence, SQL, NoSQL, C#, GitHub, MVC, Rally, HTML5, CSS, Bootstrap, .Net Core, Micro Service, Postman, Web API, WCF, MVC, Entity Framework Core and Python 3.6.

PRIOR EXPERIENCE:

Organization Name

Cognizant Technology Solutions

Client Name

Onsite (CVS, CTS, Intellisoft Tech P Ltd, Englewood CO)

Project Name

Novologix

Project Duration

Sep 2017 – Dec 2018; Team size: 12

Role/Title

Net, Angular (Full stack) Developer

Project Description

NLX has the capability to grant medical directors (internal or external) access but if they are reviewing cases for multiple payers, they must switch between NXL applications. As a result of this effort MD users should be able to access all the PA cases across multiple payers that are assigned to them on one shared NLX application

Responsibilities

Application development was carried out following Agile-Scrum methodology, involved in sprint planning, daily standup calls, and sprint review meetings.

●Extensively worked on C#, ASP.NET, WCF, SQL Server 2014.

●Used WCF for multiple services to interact with the application for the clients.

●Designed and developed WCF services, including JSON data formats and attributes.

●Used Postman tool for Rest API testing.

●Worked on Single sign-on (SSO) for user authentication service that permits a user to use one set of login credentials (e.g., name and password) to access multiple applications.

●Worked on NetSqlAzMan to manage the access that roles have to certain tasks.

●Worked on Data Annotations for model validations.

●Designed unit testing module with NUnit to test the application performance.

●Involved in designing and developing in all layers like Database layer, Business layer Service layer and user interface.

●Configured Azure Cloud Service for end point deployment.

●Responsible for writing the Stored Procedures, Functions, Triggers, Views, CTE and extensively worked on T-SQL queries and transactions.

Languages / Tools

VS 2015, SqlServer 2014, C# 4.5, Agile, TFS, WCF, Ajax, ADO .Net, JQuery, JavaScript, MVC, Jira Confluence, HTML5, CSS, Bootstrap, Postman, Angular2, Entity Framework.

Organization Name

Intellisoft Technolgies P Ltd

Client Name

Onsite (CMBHS, State of TX, Intellisoft Tech P Ltd)

Project Name

CMBHS

Project Duration

Sep 2016 – Aug 2017; Team size: 5

Role/Title

DotNet Full Stack Developer

Project Description

CMBHS is a web-based clinical record keeping system for state-contracted community mental health and substance abuse service providers. In addition to an electronic health record, CMBHS also serves as a clinical tool, which includes diagnostic, and treatment plan capabilities.

Responsibilities

Used Telerik controls like Grid Control and Date Picker, Tab strip to provide good feel and experience.

Implemented State Management using View State, Sessions, and Cookies.

Used code analysis tools - ReSharper to improve performance of the

Performed code reviews to improve quality of the product.

Setting up the Development environment branches in Source Control using SVN.

Languages / Tools

VS 2010/2008, PL/SQL, C# 4.5, Agile, Oracle 11g, TFS, WCF, Ajax, ADO .Net, JQuery, JavaScript, ORM, Javascript, MVC, Rally, Telerik, HTML5,CSS,Bootstrap.

Organization Name

Techmagix Inc P Ltd

Client Name

Onsite (Medical Marijuana, State of MD, Techmagix P Ltd)

Project Name

Medical License System

Project Duration

March 2015 – Aug 2016; Team size: 9

Role/Title

DotNet Full Stack Developer

Project Description

Medical Marijuna commission mainly used for license approval and user management and also allows registration of qualified patients and designated caregivers, issuance of registry identification cards, registration of medical marijuana dispensaries, verification system for the identification of medical marijuana cards.

Responsibilities

●Actively participated and Involved in System Designing by interacting with App Arch Team.

●Involved in the development of the Medical License Transaction Flow portal using MVC 5, C# 4.5, AngularJS, JQuery, TDD, and SQL Server 2014.

●Implemented different UI feature like multiple View, partial views.

●Responsible for building the UI for the Medical License Transaction Flow using Kendo UI, MVC and Bootstrap.

●Building the data access layer using Entity Framework ORM model.

●Involved in the Design & Architecture of the Server-Side layer using Domain Driven Design involving patterns like Repository Pattern, Unit of Work, Modular Pattern and Inversion of Control.

●Used Web API (API Controllers) for HTTP and REST based GET, POST, PUT, DELETE and returning JSON format.

●Used Agile Scrum to keep progress track of project.

●Involve in Test Driven Development (TDD) and wrote Integration and Unit Tests.

●Optimizing, debugging and creating stored procedures in SQL 2014

●Building Single Page Applications (SPAs) with AngularJS.

●JavaScript Unit Testing with TDD, Jasmine and Karma.

●Participate in requirements sessions, provide help around Architecture,

Languages / Tools

VS 2015, C#, MVC5, TDD, SQL 2016, TFS, Entity Framework, Web API, REST, AngularJS, Bootstrap 4 Flexbox, Testing Framework.

Organization Name

Tata Consultancy P Ltd

Client Name

Cardinal Health, OH

Project Name

Goliath Sales System

Project Duration

Oct 2010 – Feb 2015; Team size: 5

Role/Title

Sr. Software Developer Consultant

Project Description

Cardinal Health is a medical supplies distributor which includes pharmaceuticals drugs, surgical products, and gloves gowns etc, the project Sales Application is used to manage sales order process for Cardinal health's ParMed, Ashco and ISS divisions. Goliath currently consists of several sub-systems (Sales, EOM, and Admin etc.) and manual interventions when necessary to process custom sales order.

Responsibilities

Creating, implementing, and supporting business-critical modules for Customer facing pages, Payments using ASP.NET 4.0, C#, WCF, Generics, XML, SQL Server 2008.

Developed controller action methods and views using Razor view engine.

Implemented data access and business logic to meet client requirement.

Implementation of client-side validations using JQuery and ASP.NET MVC Validation implemented at Controller level.

Handled ASP.NET features such as Exception Handling, and Custom Error Messages.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error handlers in C#.Net.

Involved in retrieving data using LINQ to SQL and LINQ to Objects with ASP.NET.

Worked on SSRS reports and included them in the Application.

Responsible for Analysis, Design, developing applications, testing and Maintenance.

Responsible for deployment of the Application in production and resolving any post-deployment issues.

Collaborate with other IT teams, communicating and negotiating needs to achieve project goals.

Languages / Tools

Visual Studio 2013, .Net Framework4.5, C#, ASP.NET 4.5, ASP.Net MVC 5, SQL Server 2012, XML, HTML5, JavaScript, CSS, jQuery, LINQ to SQL, Win Service, TFS, AngularJS, Web Service 2.0, Entity Framework, Windows Server 2008.

Organization Name

HCL, Chennai, India

Client Name

LBG, UK

Project Name

I Site

Project Duration

Feb 2010 – Oct 2010; Team size: 3

Role/Title

Sr. Software Developer

Responsibilities

Perform project tasks with development team, spanning UK and India.

Creating user controls and custom controls using WPF to design and render a rich client user interface screens (XAML) to reuse throughout the application using MVVM framework.

Used Telerik controls like Grid Control and Date Picker, Tab strip to provide good feel and experience.

Implemented State Management using View State, Sessions and Cookies.

Used code analysis tools - ReSharper to improve performance of the code

Created T-SQL stored procedures and packages.

Setting up the Development environment branches in Source Control using Tortoise SVN.

Responsible for code reviews to maintain quality of code.

Implementing Unit & Integration Test Cases in the applications with Test Driven Development (TDD) approach with Agile style of project management

Setting up the Team builds, and Jenkins builds for QA, Stage & Production Environments.

Worked on DTS Package and DTS Import/Export for transferring data from several data sources to SQL Server.

Worked on Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.

Used strongly typed dataset for Data Access and Data manipulation to SQL Data Source and Oracle Database.

Languages / Tools

Visual Studio 2010, ASP.NET 4.0, ASP.Net MVC, WCF, WPF, JQuery, Telerik, XML, HTML, JavaScript, IIS 7.0, C#, LINQ, Nunit, Visual SVN (Subversion), SQL, SOAP, IIS5.0.

Organization Name

Alden Pre Press Pvt Ltd

Client Name

NHS, UK

Project Name

NHS

Project Duration

Apr 2008 – Jan 2010; Team size: 5

Role/Title

Software engineer

Responsibilities

Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

Worked with Charts and Data Binding controls with service components.

Designed Web Service, networking components and LINQ APIs.

Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation using LINQ.

Designed the web UI using ASP.NET, HTML, DHTML, XSL/XSLT, JavaScript, CSS, Web Forms and AJAX controls.

Created User Controls, Custom controls, Data Access Layer, Business Logic Layer classes using C# and .Net 3.5.

Worked with ADO.NET to interact with the SQL Server 2008 (i.e. retrieving, updating and inserting data into the tables) for Alerts.

Used ADO.NET and Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation.

Created automatically running stored procedures for day-end operation using SQL Server agent.

Involved in Deployment and Troubleshooting issues in the application.

Languages / Tools

VS2008, C#, ASP.NET 2.0, WCF, Java Script, TFS, WCF, IIS 7.0, AJAX, ADO.NET, MSMQ, LINQ, XML, XPath, NUNIT, SQL Server 2008 R2, Windows XP, UML, Windows Server 2003, Windows Server 2008 R2/2008.

HIGHER EDUCATION:

Master of Science in Software System as distance education, BITS PILLANI, INDIA,2013

Bachelor of Engineering in Computer Science, Madras University, India,2004

Certified for MCP-070536



Contact this candidate