Sql Server .Net

Sravan K acuynp@r.postjobfree.com

Sr. Net Developer Phone -575-***-****

Summary:

•Around 7 years of professional experience in the scopes of software architecture, development, object-oriented programming, system analysis and design among others for internet, intranet, distributed and standalone systems, Client/Server N-tier Architecture based on Microsoft .NET technologies and SQL Server in various business domains like finance, retail and health care.

•Technical expertise in Microsoft Technologies like .Net Framework 4.5/4.0/3.5/3.0, C#, ADO .NET, IIS, Win Forms, Web Services, ADO, Web API, WCF, XML, Microsoft SQL Server and MS Team Foundation Server, Microsoft Visual Studio.

•Excellent experience in working with different object oriented programming techniques like inheritance, polymorphism, and encapsulation.

•Extensive working experience with different methodologies like Agile (Scrum), Test-driven development (TDD) and Waterfall methodologies.

•Working experience on RESTful Programming using HTTP verbs for CRUD operations with ASP.NET, Microsoft architecture patterns like MVC 5.0, Service Oriented Architecture (SOA), Web forms.

•Expertise in developing Multi-Tier Application Development.

•Well-versed in creating and consuming services on WCF framework using SOAP, XML.

•Experience working with Web Services.

•Hands-on experience working on Team Foundation Server (TFS), Change Control Management, Visual Source safe

•Worked extensively on MVC and web forms software design patterns.

•Experience with the Object Relational Mapping (ORM) using LINQ and thorough Knowledge of LINQ to Objects, Entity Framework.

•Experience with Data Accessing including using Data Adapter, Data Reader and Data Set in ADO. NET and LINQ (Language Integrated Query) providers for data manipulation.

•Used NopCommerce as CMS.

•Experience in .NET security features such as Authentication (Windows-based Authentication, Forms- based Authentication) and Authorization (Authorizing Users and Roles)

•Experience in database design and development of different scripts, stored procedures, triggers, functions and views using SQL Server, Oracle and MS Access.

•Great Team Player with excellent communication, analytical, verbal and writing skills along with strong management, organizational and mentoring skills.

Technical skills

.Net Technologies

C#, .Net Framework 4.5/4.0/3.5/3.0, ASP.NET, ADO.Net, WCF, LINQ, Web Services, Web Forms, Win Forms, AJAX.

Web Technologies

HTML5, HTML, CSS3, CSS, XML, JavaScript, Bootstrap, JQuery, DHTML, XSD, XSL/XSLT, JavaScript, JSON

Database

SQL Server 2008/2008 R2 /2012

Software & Tools

Microsoft Visual Studio 2008/2010/2012/2013, SQL Server Management Studio, SQL Profiler, Developer Tool, Firebug, MS word, MS Excel and MS PowerPoint

Reporting & Integration Tools

Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), Crystal Reports

Operating Systems

Windows, Linux

Version Control

TFS, SVN, VSS, TortoiseSVN, GIT

Application Server

IIS 6.0 /7.0/7.5/8.0

Professional Experience:

Bank of New York Mellon, Brooklyn, NY Oct '14 – Present

Senior .Net Developer

The software was used to manage the loans administered to the bank's client. Using this web application the bank officers and administers were able to instantly access the details of a loan such as the name, account number, loan amount, interest rate, outstanding balance, payment history etc. of each client.

Responsibilities:

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

•Writing Software Requirement Specifications & Test cases, Object Oriented Analysis and Design using UML with Microsoft Visio 2007 and Rational Software Modeler.

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

•Development was done using Agile methodology with daily scrums, and continuous integration using the SDLC process to deliver higher-quality software far more rapidly.

•Created & Consumed WCF Services and also used different bindings to make it available to different types of clients.

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

•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.

•Implemented the project using ASP.NET, C# and back-end database as SQL Server 2012.

•Worked on applications software development efforts from deployment through the maintenance support process.

•Written Stored Procedures in SQL Server 2008

•Used EDMX as conceptual Model and LINQ to Entities to bind the data to Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation.

•Designed Graphical User Interface (GUI) using Master Pages, HTML, JavaScript and CSS classes Used jQuery and AJAX to make the User Interface more responsive.

•Responsible for designing and developing the database objects like Tables, Views, and Complex T-SQL Store Procedures involving Joins and using Temporary Tables, UDF (User Defined Functions).

•Implemented CRUD functionality with Entity framework (ORM) in ASP.NET, MVC 5.0 and implemented sorting, filtering and paging with Entity framework in MVC 5.0.

•Developed RESTful service using WCF framework and used Angular.js for getting data.

•Used C# language in developing the business logic, where in extensively implemented the Object Oriented Programming (OOP) Functionalities and Win forms.

•Developed Reports using SQL Reporting Services and implemented Optimized SQL Stored Procedures

•Used Team foundation Server (TFS) for version control and Shelve pending changes of the source code along with the maintenance of the builds and the relevant documents of the same.

•Created ETL packages using SSIS to move data from various heterogeneous data sources to centralized database.

Environment: Microsoft SQL Server 2012, Visual Studio 2012, C#, ASP.NET4.5, MVC 5.0, HTML5, JavaScript, CSS3, WCF, AJAX, AngularJS, Entity Framework, IIS 7.5, SSIS

Ameriprise Financials Minneapolis, MN Sept '13 – Aug '14

Senior .Net Developer

Ameriprise is one of the leading diversified financial services companies in the U.S. Ameriprise Financial engages in business through its subsidiaries who provide a wide range of financial planning, products and services designed to be utilized as solutions for its clients' cash and liquidity, asset accumulation, income, protection, and estate and wealth transfer needs.

Responsibilities:

•Worked on Agile Methodology (Scrum Framework) to meet timelines with quality deliverables.

•Involved in developing applications in C# and .Net Framework 4.5/4.0 to meet the business requirements using Visual Studio.NET 2012/2010.

•Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET.

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

•Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode.

•Developed and Used User Controls using C# and ASP.NET.

•Created new SSIS packages for populating data into MS SQL database.

•Accessing the data from Data Access Layer for the User Interface using Web Services.

•Created Indexes, Views and Stored Procedures for quick and efficient retrieval of data using SQL server 2008.

•Used Team Foundation Server (TFS) to maintain the version control history during development.

•Assisted in quality assurance measures such as code reviews, test case creation and unit testing for different modules.

•Designed and developed user interfaces using Winforms and C#.

•Used T-SQL to write queries in SQL Server database. Created Stored Procedures in SQL Server. Worked with a team to define requirements and provide technical advice and troubleshooting. Update technical documentation.

Environment: C#, MVC 4.0, .NET Framework 4.5/4.0, HTML, CSS, Ajax, JavaScript, ADO.NET, Web Services, SQL server 2008, Windows XP, IIS, Visual Studio 2010, TFS and SSIS.

Social Interests Solutions, CA Jan '13 – Aug '13

.Net Developer

Health-e-Arizona is an on-line application for Arizona residents. Public can apply for AHCCCS Health

Insurance coverage, Kids Care and Kids Care II, Nutrition Assistance, and Temporary Assistance for Needy Families (TANF) cash assistance. Health-e-Arizona can be used even if residents have applied before or are currently receiving benefits. The status of the application can be checked by the public once registered in Health-e-Arizona. This is a standalone product which is designed in a way it can be customized for different states without major changes or new development. It is designed with custom MVC pattern wherein the business layer is developed using WCF. Business objects and Data Access Layer are all auto generated with our own tool which will reduce the development effort considerably.

Responsibilities:

•Involved in System Analysis, requirement gathering, specification/documenting, designing, coding, testing, debugging, application evaluation and implementation.

•Involved in development and maintenance of windows application that automates the Process of creating loans for various ancillary applications that get data from different Clients.

•Worked in Agile environment.

•Used Custom Validation and User Validations.

•Created Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and JavaScript was written for Client side validations.

•Extensively used CSS for page layout and display of graphics.

•Worked on SQL stored procedures.

•Responsible for resolving any defects found during testing in an efficient and timely manner.

•Designed and Developed UI Screens to be user friendly using JQuery, JavaScript, and AJAX.

•Experience in handling deployment requests in various environments in Dev, Dev stage, QA, and UAT.

•Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.

•Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

•Bug Tracking, Change request, maintains of user roles (change management), and manages checkin check outs through TFS.

•Available on Production Support 24/7.

•Used Master Pages to provide a unified look and feel to the application.

•Used AJAX to create better, faster and more user-friendly web applications.

•Developed various web services using WCF which can be consumed by web application and other systems.

Environment: Visual Studio 2008/2010, TFS, .Net Framework 3.5/4.0, C#, SQL Server 2008/2010, JavaScript, JQuery, LINQ, WCF, AJAX.

Sears Holding Corporation Hoffman Estates, IL Oct '11 – Dec '12

.NET Developer

Sears Holdings Corporation is a leading integrated retailer focused on seamlessly connecting the digital and physical shopping experiences to serve our members - wherever, whenever and however they want to shop. Responsibilities:

•My responsibilities include performing analysis into the different stages of the system development life cycle in order to support development and testing efforts, identify positive and negative trends, and formulate recommendations for process improvements and developments standards.

•Created rich User Interface on the web using HTML, JQuery, CSS, and JavaScript.

•Extensively used JQuery and JavaScript for client side validations.

•Extensively used Twitter Bootstrap Framework for developing rich UI

•Used Visual Source Safe for the purpose of Version Control and Source Code maintenance needs.

•Designed WCF the front end using XAML Browser for Rich UI.

•Used JQuery and JavaScript to reduce the turnaround time of retrieving data from the database.

•Wrote Store Procedures, and SQL User Defined functions for fetching Transaction details, Survey Details, Customer details and Product Configuration data.

•Designed and developed WCF Web Services and configured our WCF Services with appropriate endpoints for consuming them in the web application.

•Used LINQ to SQL to query database and made use of Lambda expression.

•Used nopCommerce for content management system.

•Worked an all the layers such as Presentation layer, BLL and DAL as a Full Stack developer.

•Used SQL Server Management Studio extensively for querying the database for additions and modifications.

•Implemented source control and version control using Sitecore Content Management System.

•Implemented page level error handling using Custom Error pages and Error logs.

•Involved in the Design of the Application using ASP.Net, WCF, Entity Framework, LINQ to SQL

•Used SSIS (SQL Server Integration Services) for migrating data from different sources like MS Excel, CSV, Flat File, sources, Oracle database to SQL Server database.

•Involved in Unit Testing, Integration Testing and successful integration of modules and multiple layers in the system.

•Actively involved in Bug Fixing during the build and deployment process and debugging

•Responsible to provide system support once the code is migrated to Test, QA or Production environments.

Environment: ASP.NET, C#, MVC 4.0, Object Oriented Methodologies, Visual Studio 2010/2008, ADO.Net, SQL Server 2010/2008, SSIS, .NET Framework 4.0, HTML, JQuery, JavaScript, CSS, Bootstrap, Sitecore CMS 7.1, Visual Source Safe, NopCommerce, LINQ, WCF, Entity Framework.

Annex IT Solutions Aug '10 – Sept '11

.Net Developer

Annex IT Solutions is an offshore software development company catering clients across the globe. They mainly focus in developing custom, scalable & secure web applications leveraging outsourcing and offshore value advantage.

Responsibilities:

•Responsible for the Design, Development and Delivery of all the modules.

•Designed and developed web pages using HTML and CSS, maintained the code behind using ASP.NET with C#.NET and maintained the client side functionality using JavaScript and JQuery.

•Used JavaScript, AJAX and JQuery for dynamic page updates and client side validations.

•Extensively worked on ADO.NET for developing core data layers for the distributed applications.

•Extensively worked with Model Classes and ADO.NET for data access implementation.

•Designing and creating the database using normalization techniques in SQL server 2000.

•Writing stored procedures, functions and triggers in SQL server 2000 and 2005.

•Successfully migrated data from Microsoft SQL Server 2000 to Microsoft SQL Server 2005.

•Responsible for working with local and international teams to deploy applications to QA and production environments.

•Testing, Debugging, and Tracing the application for errors, Documentation and maintenance of program.

•Used Visual SourceSafe for version Control.

Environment: ASP.NET 3.5, Visual Studio 2008, Win forms, SQL Server 2000, SQL Server 2005, HTML, XML, CSS, JavaScript, C#, Crystal Reports, IIS5.0.

Talluri Technologies July '08 – Aug '10

.Net Developer

Talluri Technologies offers the services to the health care sector. They assist them in processing of the claims, patient billing and complex compliance issues

Responsibilities:

•Understand requirements specification document and develop the prototype for feasibility study.

•Studied and analyzed the functional and technical specifications.

•Created Visual Studio.NET web forms and Class libraries containing code for business and data access logic using C# .NET.

•Coding and debugging using ASP.NET and C#.

•Used ADO.NET objects such as Data Adapter, Data Reader and Data Set for consistent data access.

•Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

•Developed the web pages using Visual Studio, HTML, and CSS for styling the Web pages.

•Created crystal reports for the back office users.

•Written stored procedures and functions used by data access layer.

•Enhanced the business layer by providing many interfaces and functions which are required.

•Performed Unit Testing and documented the results.

Environment: .Net Framework 3.0, ASP.NET 2.0, C#.Net, JavaScript, ADO.NET, HTML, Crystal Reports, SQL Server 2005.

Education:

Bachelors of Technology in Information Technology, Department of Information Technology, Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh, India.

Contact this candidate