Post Job Free

Resume

Sign in

Software Development Sql Server

Location:
Plainfield, NJ
Posted:
December 20, 2023

Contact this candidate

Resume:

PROFESSIONAL SUMMARY:

Accomplished and talented IT professional with over 11 years of experience in complete Software Development Life Cycle (SDLC) which includes analysis, design, development, deployment, testing, debugging, implementation & maintenance of large and complex enterprise applications in Web-based, Client/Server and Distributed n-tier architecture on multi-platform.

Extensive experience in .NET Framework 4.5/4.0/3.5/3.0/2.0, Web based application development using Microsoft.NET technologies including C#, VB.NET, ASP.NET (4.5,4.0/3.5/3.0), MVC 5.0,4.0,3.0, AJAX, J Query, JavaScript, JQ Grid, ADO .NET, Entity Framework 5.0/4.0, LINQ, WCF, Web Services, SOAP, TFS 2010/2008, SQL Server 2012/2008.

Working knowledge in Internet languages like HTML, CSS, XML, JavaScript and AJAX.

Strong in Object Oriented Analysis (OOA), Designing (OOD), and Programming (OOP).

Experience in implementing Service Oriented Architecture (SOA) and Model View Controller (MVC 5.0/4.0/3.0) Architecture.

Good experience in AGILE delivery process of software using SCRUM.

Hands on experience with Web Services (REST, SOAP, WSDL, UDDI) and developing XML web services.

Involved in Software development life cycle (SDLC) of application from design phase to implementation phase, testing, Deployment and maintenance phase.

Rich Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections and Exception Handling.

Experience in handling exceptions using try, catch blocks and Microsoft Exceptional Handling Application blocks.

Experience in working with source control and versioning tools like VSS, SVN and TFS.

Dedicated to keeping up with new technologies and applying them to solve business needs.

Strong skills in developing reporting services like SQL Server Reporting Services (SSRS) and Crystal Reports.

Expertise in developing test cases for Unit Testing, Integration Testing and System Testing.

Excellent analytical, problem solving, trouble-shooting capabilities, communication and interpersonal skills with good work ethics.

Ability to learn new concepts, interact with individuals at all levels of the organization and contributing to project success in multi-tasking, fast paced environment.

Education:

B. Tech in Electronics and Communication Engineering, May 2008, JNTU in India.

TECHNICAL SKILLS:

Operating Systems : Windows NT/2000/2003/XP/2008, Windows Vista, Windows 7

.Net : .Net Framework 5.0/4.5/3.5/3.0/2.0, Win Forms, ADO.Net, MVC, .Net Class Libraries, Telerik controls, .Net Remoting, Web Services, WCF, WEBAPI, WPF.

Languages : C#, VB.NET, C++, C.

Web Technologies : ASP.NET, AJAX, WCF, XML/HTTP, HTML, CSS, Bootstrap.

Scripting languages : JavaScript, Jquery, VB Script

Data Access : Entity Framework, ADO.Net, ODBC and OLEDB

Database Technologies: MS-SQL Server 2005/08/12, My SQL, MS-Access, Oracle

Source Control : MS Visual Source Safe /Team Foundation Server/SVN /GITHUB.

Development Tools : Visual Studio .NET 2003/2005/2008/2010

Reporting Tools : SQL Server Reporting Services (SSRS), Crystal Reports

MS-Office : Outlook, Word, Excel and Power point

PROFESSIONAL EXPERIENCE:

Cognizant (Hartford-Travelers) Oct 2021 – Mar2023

Project: Insurance

Position: Sr.NET Developer -Technical Lead

Travelers Insurance offers a wide range of business insurance options, designed to identify and reduce those risks. Beyond managing claim costs, we help companies prepare for risk and recover faster after an unexpected event. Managing the total cost of risk creates a competitive advantage, helping you protect and grow your business.

Responsibilities:

Following Kanban methodology with the whole team to discuss about the progress of the application development, specks to be taken care and specks that already completed.

Involved in performance tuning of the application by creating various database Indexes and optimizing database queries.

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.

Perform all facets of design, application development and testing within .NET architecture based on programming guidelines.

Store procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.

Performed unit testing on every new version before sending it for User Acceptance Test (UAT).

Involved in application release and responsible for defect free migration in different environments.

Involved in Test Driven Development (TDD) of the Project

Involved in Unit testing, Smoke testing, Integration Testing and Bug fixing.

Provided estimates, daily & weekly status report to the client on progress of the tasks.

Coordinating with off-shore Team

Environment: .Net Framework 4.5, C# 4.5/4.0, MVC 5.0, JQuery, JSON, HTML, XML, Agile, WCF, Azure devops, Kanban methodology, REST, WEBAPI, WCF, SQL Server 2012, T-SQL.

Auto Injury Solutions (AIS), Iselin, NJ Oct 2016 – Sep 2021

Project: Med Flow Application

Position: Sr.NET Developer

AIS has been providing New Jersey insurance carriers with the solutions needed to stay in compliance with the Automobile Insurance. In New Jersey auto insurance market allows to help control insurer costs and increase claim efficiency.

MedFlow Technology is the backbone of all our New Jersey services. Not only does it allow full visibility into the entire life of the claim, but its entirely electronic internal workflow provides easy access and organization of all claim data and medical documentation Real-time web access lets adjusters view all case progress and claims documents as needed.

Responsibilities:

Involved in Requirements gathering, Conceptual Design, Analysis, and Detail design, Development and System Testing.

Developed ASP.NET modules using MVC 5.0 (Model-View- Controller).

Responsible for designing User Interface screens using Master Pages, jQuery, HTML, CSS, Java Script, and AJAX Tools and Telerik Kendo UI.

Implemented Cascading Style Sheet (CSS) to improve look and feel of the ASP.NET web page.

Used WCF REST and SOAP for interoperability with other platforms, technologies and for building the custom solutions.

Following Kanban methodology with the whole team to discuss about the progress of the application development, specks to be taken care and specks that already completed.

Converted the existing Associate Database system to meet the new requirements and utilized the various class libraries.

Implementation of client-side validations using jQuery and ASP.NET MVC5.0 Validation implemented at Controller level.

Created DAL (Data Access Layers) using Entity Framework to establish database connectivity and data manipulation.

Involved in performance tuning of the application by creating various database Indexes and optimizing database queries.

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.

Perform all facets of design, application development and testing within .NET architecture based on programming guidelines.

Store procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.

Performed unit testing on every new version before sending it for User Acceptance Test (UAT).

Involved in application release and responsible for defect free migration in different environments.

Involved in Test Driven Development (TDD) of the Project

Involved in Unit testing, Smoke testing, Integration Testing and Bug fixing.

Provided estimates, daily & weekly status report to the client on progress of the tasks.

Environment: .Net Framework 4.5, C# 4.5/4.0, MVC 5.0, JQuery, JSON, HTML, XML, Agile, WCF, Azure devops, Kanban methodology, REST, WEBAPI, WCF, SQL Server 2012, T-SQL.

Accenture-Hyderabad (Client- Microsoft, Redmond, WA) Apr 2013 – Nov 2013

Project: DPlanner

Position: Sr .NET Developer

An online service provided to Client using SKU architecture. DPlanner system is developed to create “Customer Friendly” single point-of-entry for all capacity related requests and scenarios and integrate the planning module into Forecast/Demand/Order.

Responsibilities:

Involved in the Analysis, Requirements gathering and Development of the project.

Developed the CSR portal Web Pages from ground up using ASP.NET, C#, .NET, JavaScript, CSS and server controls.

Participated in full Software Development Life Cycle, to analyze, implement and test the project.

Developed secure login interfaces with ASP.NET Server controls. Security features were provided using Cookies and Session ID so that unauthorized access could be denied.

Implemented Partial views (user controls), Master Pages, Strongly Typed Views and Complex Views.

Implemented AJAX to load contents individually in different partial views to minimize loading time.

Created WCF, REST Services and also used different bindings to make it available to different level of users

Experience in development and implementation of Windows Communication Foundation (WCF), and also Responsible for developing WCF based Service, Data, Fault and Message Contracts

Used JSON (JavaScript Object Notation) format to serializing and transferring data.

Implemented data facade layers and LINQ to extract necessary data.

Created WCF SOAP services and implemented robust instrumentation common modules for diagnostics

LINQ was extensively used in view extension to parse out unnecessary information and to make call to SQL database.

Implemented custom XML to desired output using LINQ to XML.

Performed complex parameterized SQL queries to multiple tables in SQL server 2008 and implemented Joins in Stored Procedures to get the desired data by joining multiple tables in Domain layer.

Environment: .Net Framework 4.5, C# 4.5/4.0, MVC 4.0, ASP.Net, JQuery 2.0, JSON, RESTful web API’s,

Entity Framework 5.0, LINQ, HTML, XML, Agile, Windows Service, Web Service, Bootstrap v3.0.2, GitHub, TFS, SQL Server 2012, T-SQL, Windows Server 2008.

JNET-Hyderabad (Client-IROL LLC, Chicago, IL) July 2010 – Mar 2013 Project: Inspection Reports online (IROL)

Position: .Net Developer

InspectionReportsOnline.net (IROL) is a Web-Based Inspection Report Management System for Authorities Having Jurisdiction (AHJ), Service Providers (SP), and Commercial Property Owners/Occupants (PO). IROL assists in streamlining the inspection process to increase productivity, communication, and compliance. IROL’s Mission is to continuously improve our customer’s ability to receive and manage data and information, in turn, improving efficiency and organization via technology.

Responsibilities:

Responsible to create new web services using ASP.Net with C#.

Support/modify the exiting web services as per user requirements.

Managing the SQL server databases.

Provide Support to other teams to fetch the data from the centralized database using ASP.net XML Web Services.

Participated in gathering and documenting User Requirements.

Involved in design, development and testing of application.

Involved in design and developing Web Forms using server controls, user controls.

Performed Unit testing according to the test cases for the modules.

Designed different components using C# with extensive use of Object-Oriented Programming Techniques like inheritance, interfaces etc.

Used built-in validation controls and custom validation control for front end validations.

Resolved defects and implemented enhancements based on the project team requirements.

Involved in writing complex SQL statements and stored procedures using SQL Server 2005.

Environment: Visual Studio 2008, ASP.Net 3.0, ADO.NET, XML, HTML, JavaScript, IIS 6.0, NUNIT, TDD, Visual Source Safe, SSRS, SOAP, WCF, WPF, .NET Framework 3.0, SOA, Web services, SQL Server 2005, T-SQL, DHTML, Windows Server 2003.

Dennis Codd-Hyderabad (Client-Sikorsky, CT) Aug 2008 – Jun 2010

Project: Plan Tour

Position: .Net Developer

This web-based tour request/approval system allows Sikorsky employees to file an electronic request form to bring their guests for plant visits at Sikorsky Aircraft facility. Approvers from different groups would be able to see and approves/reject the requests online through the work flow process. The basic purpose of this application is to web-enable the current process by providing the features such as request creation that requires. A user can create a Request to bring the Visitors to Sikorsky facility by raising the Request upon approval from the corresponding Approver Groups.

Responsibilities:

Responsible in developing the program modules assigned and research and development of critical requirement assigned to me.

Involved in full life-cycle of the project from requirements gathering to transition using Agile Methodology.

Involved in Understanding Existing Applications and Reviewing Requirements, Use Cases with Business Team and Implementing and Prioritizing the Tasks per Business Requirements using the Agile Methodology

Developed core business algorithm to create inland trips based on the availability, rail schedule info and available rates.

Involved in designing the layout of User interface using Visio and Class diagrams using UML.

Programmed ADO.NET for communication between application and database, used extensively Data Grid, Data Set, Data Table, Data Views, Data Adapter and Data Readers to render reports.

Implemented and extensively used the Object-Oriented programming concepts in C# and ASP. Net 3.0.

Developed the Classes, Objects, Dataset Classes, and Methods depending upon the business requirements.

Used ASP.NET User Controls to create wizard steps for submitting and modifying events and evaluation forms. Involved in creating the logic for the several different modules.

Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as parameter to the stored procedures.

Implemented Serialization and Deserialization of objects.

Developed Custom Controls which provides flexibility, reusability better deign time experience.

Developed User Interface (UI) using WPF for the better look and feel of the desktop-based application.

Developed partial post back validations to manipulate data on web pages using AJAX.

Developed various stored procedures for the data retrieval from the database and generating different types of reports using SQL reporting services (SSRS).

Used Visual Source Safe for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Created automated Unit test plans using Visual Studio 2008 and performed Unit testing modules according to the requirements and development standards with N-Unit testing.

Implemented TDD throughout the Project and used Agile Methodology

Environment: ASP.NET, VB.NET, ADO.NET, XML, Web services, HTML, JavaScript, IIS 6.0, Windows 2000, HTML, DHTML, UML, CSS, UML, Ajax Toolkit, VSS, Oracle 10g, Visual Studio 2003, COM+, Win Forms, XML, XSL, HTML, SQL Server 2003.



Contact this candidate