Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Hyderabad, Telangana, India
Posted:
May 04, 2016

Contact this candidate

Resume:

SAI

acum3q@r.postjobfree.com

732-***-****

SUMMARY:

Senior .Net Developer with 8+ years of experience in developing .NET, Web Based Applications, Windows and Console Applications using C#, .NET Framework (4.5, 4.0, 3.5, 3.0, 2.0), ADO.NET, MVC, XML, HTML, DHTML, CSS, JavaScript, Bootstrap, Angular JS and AJAX.

Extensive experience in .NET applications based on Object Oriented Programming (OOPS), Internet Technologies, Web based, Client/Server, n-tier and Service Oriented Architecture (SOA)

Exceptional working knowledge in all phases of SDLC (Software Development Life Cycle), participated in Analysis, Design, Implementation, Testing and Deployment of multiple project implementations.

Experience in developing User Interface using Web Forms, Win Forms, AJAX Toolkit, CSS, HTML and JQuery.

Experience in creating and consuming WCF (Windows Communication Foundation) on Multiple Hosts.

Developed Web Forms and Win Form applications using .NET Framework (4.5, 4.0, 3.5, 3.0, 2.0) and Visual Studio 2005/2008/2010/2013

Designed, Created, Implemented and Consumed .Net based Web services and hosted using IIS to provide data to other enterprise business units.

Experience with Agile SCRUM methodology, used for new product development.

Worked on reading and generating XML files and related technologies like XSL, XSLT, XAML and X-Path, also used DOM/SAX parsers to work with XML documents.

Experience with AJAX tool manager and JQuery for the Asynchronous data transfer between the client and the server for creative and interactive web applications, mainly focused on performance improvement.

State Management related controls in .NET such as Grid View, Details View, Repeaters and also other ASP.NET Server Controls.

Hands on experience with SQL Server Reporting Services (SSRS), SQL Server Integrating System (SSIS) using SQL

Working experience using Angular JS, Node JS.

Proficient knowledge and experience of LINQ, Entity Framework.

Worked around with jQuery and JSON for the retrieval of data.

Used versioning tools using Microsoft Team Foundation Server (TFS), Clear Case and Visual Source Safe (VSS) for version controlling of the Application.

Excellent skills in creating Tables and Views, also writing Stored Procedures, T-SQL Queries, Functions and Triggers.

Performed Unit Testing (using N-Unit), Integration Testing, Performance Testing and System Testing.

Excellent Analytical and Programming abilities in using technology to create elegant, flexible and maintainable solutions for complex problems.

Reproducing production issues in UAT / DEV/ SIT environments to analyze and solve the problem.

Used JIRA, HP Application life cycle management to track defects and Surfs.

SKILLS:

Programming Languages

C, C++, C#, VB.NET and Java

Scripting Languages

Java Script, AJAX, JQuery

.Net Technologies

ASP.NET, MVC, Web API, ADO.NET,ASP, LINQ, WCF, Entity Framework, XML, XAML, HTML,XSL, XST, XML DOM

Databases

SQL Server 2012/2008 (R2) /2005 and Oracle 10g, MS-Access 2000

Development Tools

Visual Studio 2005/08/10/13, TFS, GIT SVN, VSS, Eclipse.

Other tools

MS Visio, MS office 2010, JIRA, Git, HP Manager

Work Experience

Client: FPL, Miami, FL

Duration: May 2015 to Present

Role: Senior .Net Developer

Description: Treasury Post Payment system is initiated by Financial Management Service for post-payment processing, handling massive amounts of data to store, analyze, convert, and process seven years of Payments and Payee data where different agencies access the post payments, individual and business data records of customers. Also involved in enhancements for existing web applications using Angular JS, Bootstrap and JQuery on front end and build rest based services using Web API, MVC, IOC and Entity Framework for middle tier.

Responsibilities:

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

Experience in working with two-week sprints in an Agile/Scrum environment.

Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity Framework Code First in MVC.

Responsible for developing the reusable Components on UI (Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.

Developed REST services using Web API’s.

A defined request-response message system, typically expressed in JSON or XML, which is exposed via the web, most commonly by means of an HTTP-based web server by a server-side ASP.NET Web API.

Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC.

Used ASP.NET MVC 4.0 framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Used JSON to transmit data between Server and Web Application, an alternative to XML Serialization

Developed REST APIs that allow sophisticated, effective and low cost application integration and multi-tier web applications with the use of Web Services using ASP.Net Web API.

Responsible for developing the reusable Components on UI (Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.

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

Performed DOM manipulations, create Templates, Directives, Factories, Controllers, and established tow way Data binding using Angular JS.

Developed very responsive, elegant views for web pages using the Bootstrap CSS Frameworks.

Created drill down, drill through, sub and linked reports using MS SSRS as well as managed the subscription of the reports.

Converted Data Transformation Services application to SQL Server Integrated Services (SSIS) has assigned.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2012 for inserting/Updating/Deleting the data into the relational tables.

Creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012 and Created ad-hoc reports Using Report Builder.

Created different types of reports such as drill down, drill through, parameterize and dashboard reports and schedule them according to business requirement using SSRS.

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

Worked Extensively with Query Optimization Techniques to Fetch Data with better Performance Tuning.

Implemented Unit testing using NUNIT.

Responsible for maintaining versions of source code using Team Foundation Server 2010.

Involved in writing technical specifications design document, deployment documents and operations guide for operation support.

Master data management (MDM) to discover and define non-transactional lists of data, and compiling maintainable master lists.

Experience in Master Data Services(MDS) features include hierarchies, granular security, transactions, data versioning, and business rules.

Environment: C#, .NET 4.0, ASP.NET MVC 5, JavaScript, JQuery, AngularJS, Web API, Razor, ADO.NET Entity Framework, LINQ, JSON, Log4Net, Unity, Auto Mapper, SQL Server 2012, T-SQL, MS Test, UML, Team Foundation Server 2013, IIS 7.5, and Windows Server 2012 R2.

Client: GEICO, Fredericksburg, VA

Duration: March 2014 to April 2015

Role: Senior .Net Developer

Description: This client offers a broad array of housing, maintenance support services, which include a licensed skilled facility, assisted living and home care, vehicle services. The task is to convert their current Independent MS Access application, which consists of database, Entry/display screens and reports to web-based application with web pages developed in .NET framework and SQL Server as backend database.

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.

Implemented Web Services to integrate the client systems using WCF.

Experience with Reporting Tools SQL Server Reporting Services (SSRS), creating ETL packages using SQL Server 2005 Integration Services (SSIS)

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Designed the UI using the ASP.NET, HTML5, Knockout JS, Bootstrap, JQuery, CSS3, Web Forms and the AJAX controls.

Extensively used JQuery UI controls and also to validate HTML DOM.

Used JQuery client-side scripting for autocomplete, tabs, validations, date picking, sorting and other functions.

Created WCF SOAP/REST Services and also used different bindings to make it available to different types of clients.

Worked on SOAP and RESTFUL Services using WEB API, which return JSON data.

Developed WCF REST web services using Entity Framework as the data access layer to Oracle Database.

Used Compiled Queries, Multiple Contexts, Explicit Loading, and Save Changes to context after all database operations to improve the performance in Entity Framework.

Created the link servers to pull the data from different data sources and used them in the stored procedure which will be executing on the scheduled basis through SQL agent.

Written Queries using T-SQL Statements, Views, Stored Procedures, Triggers, Cursors and User Defined Functions in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Worked Extensively with Query Optimization Techniques to Fetch Data with better Performance Tuning.

Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

Responsible for maintaining versions of source code using Team Foundation Server 2010.

Worked in an Agile Programming Methodologies, Scrum and Test-Driven Development (TDD) environment to deliver higher-quality software far more rapidly and designed the complete solution using N-tier Architecture model and MVC design pattern.

Involved in writing technical specifications design document, deployment documents and operations guide for operation support.

Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

Environment: C#, ASP.NET 4.5/4.0, ASP.NET MVC 4.0/3.0, Java Script, JQuery, TFS 2010, WCF SOAP/REST, JSON, IIS 7.0, AJAX, Entity Framework 6.0, LINQ, XML, Microsoft Enterprise Library, SQL Server Integration Services, Git, NUNIT, SQL Server 2008 R2, Windows 7.

Client: Hilton, Memphis, TN

Duration: January 2013 to February 2014

Role: .Net Developer

Description: The major module of the Intranet web application is Customer Satisfaction Survey Report, Contribute application and Service catalogue application which is based on the feedback given by the customers of the organization. Based on the information, reports were generated for the management to view the consolidated information on various aspects of the organization. The application also maintained complete employee details and in a way implemented HR Management for the company. Analyzing and transforming legacy applications into new technologies.

Responsibilities:

Worked on creating UI using CSS, JQuery and Master Pages with C# as code behind file.

Used .NET AJAX controls to dynamically render the content on web pages developed using C#.

Designed and implemented Silverlight 2.0 user controls.

Designed and implemented different layers (UI Layer, Business Access Layer and Data Access Layer) and also using MVC architecture.

Extensively implemented Grid View for displaying data, and editable Grid View for data manipulation in the presentation layer using Server Controls.

Created Several User Controls.

Designed Objected Oriented classes' structure in Data Access Layer and Business Access Layer.

Used LINQ with objects for data retrieving and data querying.

Implemented Data Access Layer using ADO.NET.

Created several Stored Procedures for this project.

JavaScript and ASP.NET Validation Controls for client side validation.

Worked on Data Transformation Services (DTS) to move data from Access to SQL.

Worked on ASP.NET State Management Techniques like View State, Sessions, Caching (Output Caching)

Created Window Communication Services (WCF) to access data from SQL Server.

Implemented WCF Contracts such as Service Contract, Operation Contract and Data Contract.

Implemented Authentication and Authorization using Web.Config file. Configured for users Authorization and role-based security.

Used XML for Data Storage and XSLT to transform the SQL queries returned as XML nodes.

Involved in Designing and Development of Software using agile development practice.

Performance testing and Code testing using NUnit.

Developed some dynamic reporting solutions SQL Server Reporting Services (SSRS)

Environment: ASP.NET 3.5, C#, Web Forms, ADO.NET, AJAX controls, XML, CSS, JavaScript, Visual Studio 2008, SQL Server 2005, Silverlight, WCF, SSRS, MVC.

Client: Union Planters Bank, Memphis, TN

Duration: December 2009 to December 2012

Role: .Net Developer

Description: CE Redesign website allows users to check their credit report, alerts and their eligibility to get credit. It also allows the customers to report their data disputes and Notice of Correction. It will let the user know on what score factors their current credit score is being evaluated.

Responsibilities:

Gathered User Requirements and Involved completely throughout the SDLC.

Application was designed based on N-Tier Architecture.

Designed and developed various Web Forms for various modules using ASP.NET, C#.NET, CSS, and Front Page etc.

Developed Business and Data tier using C#.NET and ADO.NET.

Worked on Role Base Security at the presentation layer involving Authentication and Authorization modules proved by ASP.NET.

Developed User controls using ASP.NET and C# for reusability.

Worked extensively on AJAX controls.

Used Object oriented features such as inheritance, encapsulation and polymorphism in the implementation.

Written PL/SQL Queries and developed stored procedures and user-defined functions to support data retrieval.

Found several areas for improvement, made recommendations, and made changes to improve security across all components and systems.

Used Web Services for accessing data from the web server.

Executed Stored Procedures using SQL server 2005.

Performed Unit and Integration Testing.

Environment: Windows XP, Web Services, Visual Studio 2008, ASP.NET, C#, IIS6.0, HTML, XML, ADO.NET, Java Script, T-SQL, SQL Server 2005.

Client: Matrix Solutions, Hyderabad, India

Duration: July 2008 to Nov 2009

Role: Software Engineer

Description: Product Sell System was designed and developed to meet the requirements of Customer Registrations, Product listings, Billing, E-ordering and reporting. It is a User-Friendly web based applications providing variety of facilities to the customers.

Responsibilities:

Extensively used object oriented concepts for C# code reusability.

Developed the business components class libraries in C#.

Created database objects using SQL Server including complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Involved in UI Designing, Development and Testing of Web Forms using ASP.NET, C#, XML ADO.ET and .NET Framework.

Implemented interfaces in C# which encapsulate business logic and call them from web forms.

Implemented Exception Handling, Logging and Validation of incoming requests.

Environment: .NET Framework 2.0, ASP.NET, C#, Win Forms, ADO.NET, XML, Web services, HTML, SQL Server2000, Crystal Reports, IIS 6.0, Windows 2000, VSS, NUnit, Visual Studio 2005.

Education

Bachelor of Technology ( JNTU University)



Contact this candidate