Sql Server Data

Name: Anusha Y

Phone No: 469-***-****

Email ID: ************@*****.***

SUMMARY

Over 6+ years of extensive experience in all phases of Software Development Life Cycle process (SDLC) involving Analysis, Design, Development, Testing and Implementation, Client/Server and web applications using Visual Studio .NET Framework.

Web Application Development experience with technologies using HTML 4.0/5, CSS2, CSS3, DOM, JAVASCRIPT, JQUERY, AJAX, JSON, and XML.

Experience developing Single Page Web Applications using Angular JS, Node JS and Backbone JS.

Extensive front end and backend development experience working with .Net Framework 3.0/3.5/4.0, Visual Studio.NET 2010/2013/2015.

Diverse experience in programming with .NET Framework using technology ASP.NET, ASP.NET MVC, ADO.NET, VB 6.0, C# with Web Services, IIS, JavaScript, HTML, CSS, XML, XSL.

Working experience in MVC Web API, MVC 3/4 and Object Oriented Analysis & Design.

Proficient in Object oriented analysis and design practices, object modeling, use cases, activity diagrams and class diagrams using UML.

Hands on experience in UI technologies with Node JS, Angular JS and Bootstrap. Experience in unit testing JavaScript code with Jasmine and Karma.

Experience in using third party tools like Telerik and kendo Controls.

Hands on experience using build tools such as gulp.js, grunt.js, bower, NPM.

Experienced using tools like JIRA and Confluence.

Experience in Implementing SOA architecture with Web services and Creating, Consuming and Publishing XML Web Services (SOAP, WSDL) and Windows Services using .NET.

Involved in working with Iterative Agile Programming Methodologies, Waterfall methodologies, Scrum and Test-driven development (TDD).

Excellent knowledge in JIRA and Quality Case(QC) tools.

Proficiency in working with all databases like Oracle, MySQL and MongoDB.

Well versed in querying the databases like SQL Server and experience in Dapper ORM for mapping object oriented domain model to a traditional relational database.

Well versed in developing database programs like Stored Procedures, User Defined Functions, Triggers, Packages and implementation scripts (Batch Scripts) on PL/SQL & T-SQL using Oracle and Microsoft SQL Server.

Specialization in the area of Unit & System Level Integration Testing.

Proficient in using Object Oriented Programming (OOPS) for building n-tier architecture systems with hands on development expertise in front-end UI layer, application layer including middleware and core business frameworks and back-end database layer integration.

Experience in using Azure App Service as a cloud platform to build and deploy test and prototype systems.

Extensive work experience on Windows and UNIX.

Excellent knowledge and good understanding of Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) in .Net Framework 4.5/4.0 and Language Integrated Query (LINQ) in .Net Framework 4.5.

Extensive work experience on REDMINE by identifying new tickets for the high priority tasks and retesting the tickets which are completed and in QA.

Experience using Firebug and Developer Tools when debugging and troubleshooting existing code.

Experience using Microsoft Visual Source Safe (VSS) Source code control system, Team Foundation Server (TFS) for version Control.

Extensively involved in fixing production, staging bugs and production support.

Excellent communication and interpersonal skills, quick learner, self-motivated, ability to work individually as well as in a team environment with good team spirit.

TECHNICAL SKILLS

Programming Languages

C#, VB.NET, Java, C, T-SQL, PL/SQL

.Net Technologies

ASP.NET 2.0/3.0/3.5/4.0, ADO.NET, Web services, WCF, MVC 3/4, LINQ, .NET Framework 3.0/3.5/4.0/4.5, Entity Framework, IIS

Web Technologies

HTML/HTML5, CSS/CSS3, Bootstrap.

Scripting Languages

Angular JS, JavaScript, JQuery, AJAX, JSON

Application Design/IDE

TFS, SVN, Microsoft Visual Studio 2013/2012/2010/2008, Business Intelligence Development Studio, Visual Source Safe

Operating Systems

Windows Vista/XP, Windows Server 2008/2003, Windows NT 2000 Professional

Databases

SQL Server 2012/2010/2008 R2, Oracle 9i/10g, My SQL

Tools

SQL Server SSRS, SSIS, AJAX Control Toolkit, Telerik, NUnit

Web Servers

Apache, IIS 7.5 and IIS 6.0

EDUCATION

Bachelors of engineering in computer science, JNT University, India with GPA 3.6/4.0

PROFESSIONAL EXPERIENCE

Responsibilities:

Responsible for designing and developing the responsive web based user interfaces for Borrowers, Co-Borrowers and loan officers.

Used LESS for styling angular blocks, panels, toaster, alert messages, bread crumbs, labels, tables, navigations, drop downs and forms.

Implemented Kendo UI controls and Kendo Angular controls for menus, navigation, dropdown lists, radio buttons, numeric and currency text boxes.

Used Angular JS for implementing client side service calls with promises and injected the required services into the controllers for reusing the code.

Implemented toaster at client side for displaying the errors, warnings and information depending on the requirement on the views.

Used UI-router for configuring routing by injecting state parameters for an application for laying out the various states the application can be in.

Used Angular Validations and Validation messages to show the errors when submitting the form.

Responsible for making Asp.net Web API calls using restful services with HTTP verbs which includes GET, POST, PUT, DELETE.

Specified a Default route for Web API in configuration.

Used C# language in implementing the web API calls to calling repository methods using the Object Oriented Programming(OOP) functionalities.

Implemented model classes using C# for defining view model properties with getters and setters where view is communicating to the model and used mappers for converting view model to domain model from the business logic.

Implemented the Repository pattern to achieve the code's maintainability and readability by separating business logic from data and to apply a domain model to simplify complex business logic.

Retrieved data from SQL Server by calling various business service methods through repository.

Involved in making database queries, tables, stored procedures and functions in SQL Server 2008.

Used Team Foundation Server(TFS) to share code, get latest version, build apps, track work and to collaborate with team members from visual studio.

Involved in meetings everyday with team members and a manager to discuss the check lists, priority of tasks, deadlines and requirements for the project.

Worked with business analysts and QA team in understanding the new features to be added to the project and resolving the high priority tasks on REDMINE and retesting the tickets which are completed and in QA.

Environment: Microsoft SQL Server 2008, Visual studio professional 2015, C#, Angular JS, Bootstrap, ASP.NET, User Interfaces, HTML, JavaScript, Kendo UI, CSS, TFS, REDMINE.

Responsibilities:

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.

Involved in implementing the Application in the in-build MVC Architecture with Angular JS.

Applied RWD Techniques using Bootstrap and media Queries. Used LESS for creating CSS frameworks store things like colors, font stacks, or any CSS value.

Handled Twitter Bootstrap framework i.e., the concept of Grids, making use of advance components like Navs, Navbars, Pagination, Alerts, Progress bars etc.

Developed Single page application using HTML5, CSS3, AngularJS. Implemented Two way Data-binding in Angular JS which makes the application to handle the automatic synchronization of data between the model and view components.

Implemented various types of services which is a reusable singleton object and used to organize and share code across the application and can also be injected into controllers, filters, directives.

Leveraged angular resources for all data access, encapsulating URLs and standardizing data access interfaces.

Consumed directives like ng-if, ng-switch and ng-repeat to add / remove HTML elements from the DOM based on scope expression.

Used filters to format data before displaying it to the user when using UI-select2 in angular.

Implemented Angular built-in dependency injection mechanism to divide AngularJS application into multiple different types of components which AngularJS can inject into each other.

Used URL routing handled by UI state router, allowing us to divide the application into logical modules (templates and controllers), each of which would be instantiated when its route was invoked by $Route Provider in Angular JS to route the data from one service to another server.

Worked on ngMock module providing mocking for tests in the application and to inject and mock Angular services within unit tests.

Called the restful Web API web service calls for POST, PUT, DELETE and GET methods.

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. Unit tested the application using Jasmine.

Designed and built reliable, highly scalable, agile and flexible systems using an expressive query language using MongoDB.

Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication and schema design.

Stored the data in the form of JSON structure based documents, stored in a collection using MongoDB.

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

Developed Front-End interaction Web Pages using MVC-4, Server Controls and Validation Controls, Layout.

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

Converted .Net application to Microsoft Azure Cloud Service Project as part of cloud deployment.

Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings based on this.

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

Involved in configuring builds using Jenkins with TFS, MSBuild plugins, configured and used Jenkins to deploy the applications onto Dev, QA, UAT environments.

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.

Participated in various Client meetings with the team and the Project manager to discuss improvement/amendments.

Documented project knowledge and access related information on confluence.

Environment: Microsoft SQL Server 2012, MongoDB, Windows Azure, Visual studio 2012, C#, Angular JS, Bootstrap, ASP.NET, MVC 4.0, User Interfaces, HTML, JavaScript, CSS, AJAX, Entity Framework, SSRS, SSIS.

Responsibilities:

Followed Test-Driven Development with Agile methodology and involved in all the business meetings and status update meetings as a part of SCRUM.

Coded Angular JS controllers and directives for application functionality, used filters while coding in Angular JS.

Implemented Angular Service calls using Angular Factory. Implemented as a single-page, Angular JS client.

Designed, developed and implemented Single Page Application (SPA) in AngularJS by consuming JSON.

Web applications developed for backend system using AngularJS with cutting edge HTML5 and CSS3 techniques

Created and deployed new features in order to sustain and amend existing applications.

Developed cross-browser/platform HTML, CSS3, and JavaScript to match design specs for complex page layouts while adhering to code standards

Used Bootstrap to build responsive UI Design.

Used Twitter Bootstrap for HTML and CSS-based design templates for typography, forms, buttons, navigation and other interface components

Created Navs and Navbar components using various classes and Breadcrumbs to indicate the current page's location within a navigational hierarchy in Bootstrap.

Developed JQuery code using XML Http Request Adapter to send an AJAX request to the server side code and implemented a call-back function for handling results.

Developed external page using JQuery (from the same domain) inside a container when a tab is clicked on via Ajax call and also to support auto mode.

Used AJAX Calls $.get, $.post, $.ajax to make request to the backend and fetch the data in JSON format.

Enhanced Web Application using .NET, Object Oriented Principles (OOP), and n-Tier Architecture.

Used separate Presentation, Business Logic and Data Access Layer in project development.

Used Razor Views to enable fast coding workflow and quickly integrate server code into HTML markup with minimum of keystrokes.

To help prevent potential system issues, developed .NET Windows Service application to monitor folders for creation/deletion/renaming of files.

Used LINQ to write lambda expressions, and LINQ to XML to get data from parsed objects.

Used ADO.NET for Data Retrieval, Querying, Data Storage and Data Manipulation and Enhanced the Data Layer to apply the Functionality to Database Servers.

Enhanced Database schema, Data Tables, Stored Procedures, Functions, Triggers, Indexes, Cursors and Views to manipulate the data using T-SQL, DDL statements.

Manipulated data using CRUD operations of MongoDB and Oracle database management system and handled database access and data transmission based on RESTful web service.

Worked on creating various types of indexes on different collections to get good performance in Mongo database.

Familiar with MongoDB write concern to avoid loss of data during system failures.

Configured multiple jobs on Jenkins for different projects with different plugins for SCM, Unit testing, code analysis, release, deployments.

Experience in effective communication of conceptual ideas and translated the business requirements into interactive web applications.

Implemented Object Data Sources using Typed Data Sets.

Generated SSRS Reports using Typed Datasets and Stored Procedures as data sources.

Environment: ASP.Net 4.0, C#, ADO.Net, Windows Azure, MongoDB, SQL Server 2012, JavaScript, XML, CSS, DHTML, Web Services, IIS 7.5, JQuery, AJAX.

Responsibilities:

Involved in business meetings with clients to understand their requirements and giving inputs to the team in every Scrum Meeting.

Used JavaScript for Client-side validations and server-side validations, utilized Ajax Control Toolkit library for fast, Interactive and better UI.

Applied Master Pages, Themes and CSS for a consistent look and feel for Page design. Consumed Web Service (SOAP) Components for authenticating the user credentials.

Responsible for design and development of user interface and core middle tier business components

Grid view and Custom paging were used to display huge amount of data, used the Entity Framework 4.0 for the use of LINQ-based Data Access.

Responsible for integration design and Production support of application on a regular basis.

Created new and modified existing business rules using a custom built business rules engine. Interpreted business requirements and applied those to the rules engine

Developing modules using Microsoft Visual Studio, VSS as source Control, C#, ASP.NET

Implemented Data Access with Packages and Stored Procedures, implemented ADO.Net Entity Framework.

Used Entity Framework for working with Relational data and LINQ for updating the data.

Implemented JQUERY auto complete feature for rich user experience, implemented AJAX for partial page updates for better user experience.

Created and consumed ASP.Net Web services/WCF.

Manage the back-end connection to Microsoft SQL as the data source using ADO.Net and write SQL queries, stored procedures and triggers to manage data.

Create clustered and non-clustered index to aid faster retrieval of data.

Involved in documentation that describes installation and operating procedures

Conducted design and code review to ensure compliance with Standards.

Worked on .NET security features such as Form-Based Authentication and Role-Based Authorization.

TDD was extensively used for both development of new functionality and refactoring the legacy code.

Participated in post-implementation reviews of both application development content and process to maximize and share learning.

Environment: C#. Net, ADO.Net Entity Framework, ASP.Net, classic asp, Net SQL Server 2008, T-SQL, .Net Web Services, Visual Studio.Net 2010, XML, JavaScript, HTML, CSS, IIS, Visual Source Safe(VSS),subversion (SVN) Windows 2008, AJAX

megaCube Technologies Hyderabad, India

Responsibilities:

Involved in requirement gathering, planning, coding, integrating, testing and deployment.

Responsibilities:

Implemented MVC framework to reduce the complexity and to get full control over the behavior of the application.

Involved in designing the web forms using ASP.NET controls, HTML, CSS, and JavaScript. Used validation controls to perform client side and server side validations.

Involved in developing the requirement with C#, ASP.NET in .Net Technologies, unit testing, system testing and release management.

Responsible for the graphic design and implementation of company web site including navigation, writing HTML and JavaScript and optimization of web graphics.

Developed page layout, copy, navigation, animation, icons and buttons. Presented concepts and designs to Clients and Management for review.

Responsible for web hosting and the installation of e-mail and forms. Developed access database and web interface suitable for client needs.

Used OOPS (object oriented programming) concepts in developing classes.

Used ADO.NET Controls like Connection, Command, Dataset and Data reader.

Created Web Service using C# having generic methods for accessing the database for common kind of functionality used by all the clients.

Used Microsoft Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC 4 application.

Worked closely with Business Teams and Technical Design Architects to understand the flow and client enhancements to the existing applications along with the QA Team.

Used C#.NET as language to develop code behind Business Logic. Built code for UI (code behind) and DAL using C# and ADO.NET.

Built database Queries and Stored Procedures in SQL Server 2010.

Developed web pages/user controls as per requirement documents use-cases, wireframes, etc. while interacting with Business Analyst for their implementation.

Modified web services using C# to interact with the other applications and exposed them using SOAP and HTTP.

Performed Unit testing on required components of application.

Performed migration activity created deliverables and migration document for database and application.

Performed code reviews for Efficient Coding (i.e. adhering to coding standards, procedures, Techniques and performance tuning).

Tracked and fixed defects. Developed and executed required Unit Test cases.

Configured and managed code using TFS (Team Foundation Server).

Environment: ASP.NET, C#, VisualStudio.NET 2010, IIS, SQL Server 2010, ADO.NET, UML, HP Quality Center (Defect Tracking Tool), TFS (Configuration Tool)

Contact this candidate