Post Job Free
Sign in

Sql Server .Net

Location:
Los Angeles, CA
Posted:
May 10, 2017

Contact this candidate

Resume:

RAJINI LOMADA

818-***-****

********@*****.*********:********@*****.***

SUMMARY

* ***** * ****** ** IT experience in all phases of software development life cycle (SDLC) - Project Analysis, Requirements, Design, Development, Testing, and Deployment and Documentation.

Extensive experience in .Net Framework 4.6/4.5/4.0/3.5/3.0 Web and Windows based applications development using Microsoft.Net technologies including ASP.Net, C#, ADO.Net, Entity Framework, WCF, REST, WPF, XML, VB, AJAX, AngularJS, JavaScript, jQuery and ASP.

Experience in implementing the MVC 3.0/4.0/5.0 (using the Razor engine), design pattern to standardize the application architecture.

Solid command in Object Oriented concepts (OOPS) using C#.

Hands on experience in web technologies like AngularJS, HTML5, CSS3, JavaScript, jQuery.

Development experience with JavaScript and C# for implementing client side/server side code in ASP.Net applications.

Hands on experience using Source Code Control Systems like Microsoft Team Foundation Server.

Creation of multiple projects in Visual Studio for developing the Web Application which includes the Service layer, Business layer, Data layer and UI layer.

Expert on developing SQL Stored Procedures, Triggers, Functions and Views for Backend process using SQL Server.

Hands on experience on LINQ to SQL to perform operations on database.

Experience performing Unit and Integration Testing in the Development, System Integration Testing(SIT), User Acceptance Testing (UAT) including Bug Reporting and Fixing.

Excellent Logical, Analytical, Communication and inter-personal skills with exceptional ability to learn new concepts/ fast learner with complex systems and a good team player, quick problem solver and ability to perform at high level to meet deadlines.

TECHNICAL SKILLS

Programming Languages

C#, VB, C, Java(Basics)

.Net Technologies

C#.NET, VB.NET, ADO.NET, ASP.NET 3.0/3.5/4.0/4.5, .NET Framework 3.0/3.5/4.0/4.5/4.6, Web Services, WCF, WF, WPF, MVC Design Patterns, MVVM

Web Technologies

XML, HTML, DHTML, XHTML, SOAP, AngularJS, CSS, JavaScript, jQuery, AJAX

UI Technologies

WinForms, WPF, ASP.NET, WebForms

IDE Tools

Visual Studio 2017/2015/2012/2010/2008/2005, SQL Server Management Studio

Databases

MS SQL SERVER 2016/2014/2012/2008/2005

Servers

Windows Server 7,2008, Microsoft IIS(7.5/7.0/6.0/5.0)

Middleware

WCF,ADO.Net 4.0/3.5/3.0/2.0, Web Services

Version Control Tools

Team Foundation Server 2015/2012

S/W Methodologies

Scrum, Agile

EDUCATION

Bachelor of Engineering –Computer Science – St.Peter’s Engineering College, Anna University, INDIA.

PROJECT EXPERIENCE

Client: Ama Waterways, CA Jul 2016 – Till Date

Role: .NET Developer

This project is to add more features and customize the existing features of the company’s website(www.amawaterways.com) using .NET technologies. It also enhances the performance and scalability of the huge applications in the website. It gives all the details about the services the company provides. It shows detailed itineraries included, various packages for river cruising and also allow the passengers to make reservations.

Responsibilities

Study and analysis of requirement and existing system documents.

Extensively worked on developing web applications using ASP.NET, AJAX with C#.

Used ADO.NET to interact with SQL Server Database.

Used LINQ to SQL to perform operations on database.

Made use of AngularJS, JavaScript, jQuery, HTML5, CSS3 for client side coding and page layout of the application.

Strictly followed coding standards like naming conventions, OOPS concept, comments, readability, efficient coding while developing Classes, Methods, Variables and database stored procedures.

Provided technical support to team members and conducting knowledge sessions on project requirements, design and coding standards to the team.

Involved in building ASP.NET pages from already existing HTML pages.

Used .NET Validation Controls for Client side validation.

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

Heavily used .NET Web Controls, Validation Controls and User Controls.

Extensively used Dynamic SQL commands and SQL stored procedures to interact with the Database.

Tested and fixed bugs after developing each page of the website.

Used Agile(Scrum) methodology for the software development.

Environment: Visual Studio.NET 2017/2015, SQL Server 2016/2014, C#, ASP.NET 4.5, AJAX, IIS 7.5, ADO.NET, SQL, AngularJS, HTML5, CSS3, JQuery and Agile Methodology.

Client: MUFG Union Bank, CA Jan 2016 – Jul 2016

Role: .NET Developer

Project: TAHOE

TAHOE is an internal application which is used to filter the bank or prospective customers based on various criteria and perform campaigning to those customers through various communication channels. Customers are filtered based on the criteria provided by the requirements team and those customers would be notified of the offers or promotions provided by the bank.

Responsibilities

Study and analysis of requirement and existing system documents.

Extensively worked on developing web applications using ASP.NET, AJAX with C#.

Used Entity Framework6.1 to interact with SQL Server Database.

Used LINQ to SQL to perform operations on database.

Made use of JavaScript, jQuery, HTML5, CSS3 for client side coding and page layout of the application.

Prepared Design documents, Class diagrams and Sequence diagrams using Visio.

Strictly followed coding standards like naming conventions while developing Classes, Methods, Variables and database stored procedures.

Provided technical support to team members and conducting knowledge sessions on project requirements, design and coding standards to the team.

Involved in building ASP.NET pages from already existing HTML pages.

Used .NET Validation Controls for Client side validation.

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

Heavily used .NET Web Controls, Validation Controls and User Controls.

Extensively used Dynamic SQL commands and SQL stored procedures to interact with the Database.

Tested the application thoroughly every time a code change is made and fixed bugs if any.

Environment: Visual Studio.NET 2012/2015, MVC 5, SQL Server 2014, C#, Entity Framework 6.1, ASP.NET 4.5, IIS 7.5, ADO.NET, SQL,WCF Service, HTML5, CSS3, JQuery and Agile Methodology.

Client: Bank of America, CA Dec 2013 – Dec 2015

Role: .NET Developer

Project: Permit

PERMIT (Program for Elimination of Risk and Maintenance of IT). PERMIT is an internal tool used by various higher level bank personals. PERMIT is used for assessment of various initiatives by lead architects. It has rule engine which defines the assessment rules for project assessment. Lead assessors for the project will take up the assessment and based on the assessment it will decide if the project is granted with Permit to Build or permit to operate. Lead architecture and report any kind issues using the issue module.

It has following modules

a) Initiatives b) Architectures c) Assessment d) Scoping blue print (SBP) e) Technology planning (TPT) Initiative module provides all the strategic initiative details such as initiative created date, initiative status etc. Application also has dashboard and reports for all the different modules.

Responsibilities

Study and analysis of requirement and existing system documents

Developed Data Access Components to access the SQL database.

Developed the User Controls and Custom Controls in C# to reuse the user interface in Web Forms and also raise the events by Delegates.

Implemented web applications using ASP.Net MVC5.0 architectural pattern.

Extensively used Data Integration in combining data from different sources which helps in users providing with the unified view of data.

Prepared Design documents, Class diagrams and Sequence diagrams using Visio.

Developed backend stored procedures and one time Data scripts for one time load of static data using SQL server 2012.

Strictly followed coding standards like naming conventions while developing Classes, Methods, Variables and database stored procedures.

Provided technical support to team members and conducting knowledge sessions on project requirements, design and coding standards to the team.

Developed UI components using ASP.NET and C#.

Made use of JavaScript, HTML5, CSS3 functions for browser Check, content and page layout of the application.

Involved in building ASP.NET pages from already existing HTML pages.

Used ADO.NET Entity Framework to interact with SQL Server Database.

Used .NET Validation Controls for Client side validation.

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

Heavily used .NET Web Controls, Validation Controls and User Controls.

Extensively used Dynamic SQL commands and SQL stored procedures to interact with the Database.

Environment: Visual Studio.NET 2013, MVC 5, Web API, SQL Server 2012, C#, Entity Framework 6.0, ASP.NET 4.5,IIS 6,ADO.NET, SQL,WCF Service, HTML5, CSS3, JQuery and Agile Methodology.

Client: Duke Energy, NC May 2012 – Nov 2013

Role: .NET Developer

Project: Energy Supply over Demand

The Energy segment operates and manages power generation facilities; and sells and markets electric power, natural gas, and natural gas liquids. Supply Demand Energy this application does forecasting of the supply demand scenario of electricity to customers in southwest, west central, and northern Ohio. It takes in many input parameters such as weather and cost of electricity all over us and international markets and returns results.

Responsibilities

Analyzing and reviewing the business requirements, design document, use cases and functional requirements document.

Involved in complete SDLC using Agile Methodologies.

Implemented web applications using ASP.Net MVC4.0 architectural pattern.

Designing screens by using Visual Studio .NET 2008 and Creating Style Sheets for formatting the WebPages based on the business requirements and functional requirements document.

Client side validations using JavaScript and implemented styling using CSS.

Extensively used AJAX control toolkit for masking, collapsing and expanding the panels etc.

Involved in the development of business logic in C#. NET and Entity Framework.

Used SQL to make CRUD (Create, Read, Update, and Delete) actions in database.

Created and maintained database, tables, user logins, views, indexes, and constraints to implement business rules and also created Triggers to enforce data and referential integrity.

Developed complex SQL queries using various joins and developed various dynamic SQL.

Interacted with testing team as a part of UAT, SIT.

Used Team Foundation Server (TFS) as Source control and document management.

Environment: Visual Studio.NET 2012, Microsoft .Net Framework 4.0, ASP.NET MVC4.0, C#, HTML, CSS, JavaScript, ADO.Net Entity Framework 4.0, Web Services, SQL Server 2012, TFS.

Client: Dentsu, Japan Mar2011 – Apr 2012

Role: .NET Developer

Project: DMPDVLZ

DMPDVLZ is a project to consolidate a website and integrate multiple reporting systems into a single, end-to-end platform. It makes product based applications for different clients.

Responsibilities

Analysis of the specifications provided by the clients.

Involved in Requirement gathering, Functional and technical specification.

Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.

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

Developed Web forms using ASP.Net server controls and validated input using Java Script.

Involved in developing the Technical and Detailed Designee documents

Designed and Developed User Interface usingASP.NET of allocated modules

Developed the Business Logic Layer(BLL) in C#

Exposed BLL using Web Services to presentation layer

Involved in developing the Data Access Layer using Microsoft Enterprise Application Blocks

Written stored procedures and triggers

Worked on CSS in ASP.NET and with HTML, Java Script

Used extensively User Controls and Custom Controls on the Web Forms

Designed the interfaces needed for exposing the Business Components.

Identified the problems due to bugs in the application.

Fixed bugs that came up during UAT.

Environment: .NET Framework 3.5, Visual Studio .Net 2008, IIS 6.0, C#.NET 3.0, ASP.NET 3.0, ADO.NET, HTML, CSS, AJAX, JavaScript, Web Services, REST, SQL Server 2008, XML.

Client: Glaxo Smith Kline (GSK), UK Jul 2008 – Feb 2011

Role: .NET Developer

Project: DMPDVLZ

DMPDVLZ is a project to consolidate a website and integrate multiple reporting systems into a single, end-to-end platform. It makes product based applications for different clients.

Responsibilities

Involved in interacting with business analysts, other developers and management to develop the application.

Involved in all phases of Project life cycle (SDLC)

Followed Agile Methodology to develop the software

Implemented the business logic using C#.NET.

Used ADO.NET and SQL to communicate with the database using the abstract data layers.

Optimizing, debugging and creating T-SQL stored procedures in SQL 2008 R2

Fixing and optimizing ASP.NET web pages using C# and SQL Server 2005/2008 stored procedures, and associating fixes/new code with tasks in Team Foundation Server.

Performing and participating in code reviews

Writing test plans and assisting with Requirements documents

Along with other Sr. Programmers, making regular recommendations on tools and technologies

Writing unit tests using N-Unit and Visual Studio 2008 and for SQL using SQL-Unit

Worked on Query Optimization to improve the performance of Queries

Environment:.NET2.0/3.5, Asp.NET, C#, WinForms, ADO.NET, Visual Studio.NET 2005/2008, T- SQL, XML,SQL Server 2005, IIS.



Contact this candidate