Data Sql Server
Resume:
Meghana D
Full Stack .Net Developer
***************@*****.***
Professional Summary:
Over 8 years of strong professional .Net Development experience in Web and Application development, including Requirements gathering, Analysis, Design, Development and Testing.
Strong experience in ASP.Net MVC, Web API, WCF, Entity Framework, IIS, HTML, CSS, JavaScript, jQuery, Angular JS, Bootstrap.
Involved in various Phases of Software Development Life Cycle (SDLC) i.e. Analysis, Design, Development, Implementation, Testing and User Training of Enterprise Web-Applications, Stand alone and Distributed applications.
Strong experience in Object Oriented Programming (OOP) and methodologies.
Good experience in developing enterprise-level Web Applications using n-Tier Architecture.
Strong understanding of SOLID design principles and exposure to Design Patterns like Singleton, Factory, Builder, Fascade, Strategy, Template etc.
Developed complex data driven Silverlight 4 applications with the WCF RIA Services.
Developed and hosted WCF Services on Multiple Hosts.
Experience in developing User Interface (UI), Business Logic and Data Access components to meet user requirements.
Experience in writing unit tests using MS-Test, NUnit and QUnit.
Experience in developing and deploying Web Forms, Win Forms, and Web service applications extensively.
Extensive Experience in writing Stored Procedures and User Defined Functions in SQL Server 2005/2008/2012.
Extensively worked with ADO.NET to connect SQL Server and Oracle using Connection, Command, Data Adapter, Data Set, Data View, Data Row, Data Grid, Data Column, Data Reader, Constraint and other Database Objects.
Excellent Experience in writing Data Access Layers using ADO.net Entity Frame Work and LINQ to SQL.
Experience with XML, SOAP, WSDL, Web Services, Validation Controls, Authentications like windows authentication, forms authentication.
Experience in working in Software Configuration Management using Tortoise SVN, Microsoft Visual Source Safe (VSS) and Visual Studio Team Foundation Server (TFS).
Experience in implementing client-side JavaScript, JQuery, JDBC, HTML, DHTML, and CSS.
Strong experience in developing Stored Procedures, Functions, and Triggers for the implementation of data integrity using SQL Server.
Knowledge on developing Reports using SQL Server Reporting Services (SSRS).
Expertise in installing, developing and deploying on application/web servers such as IIS 5.0/IIS 6.0/IIS7.0
Strong Analytical and Communication Skills with experience in interfacing effectively with various local and cross-geographic teams to develop requirements, functional specifications, design documents and solve problems.
Technical Skills
Programming Languages
C#, Visual Basic, Angular JS, jQuery, JavaScript, HTML, CSS
Web Technologies
ASP.NET, MVC, Web API, WCF, HTML, CSS, jQuery, JavaScript, Angular JS, VBScript, XML, BootStrap, SOAP 1.1, WSDL
.NET Technologies
.NET Framework (1.1/2.0, 3.5, 4.0), ADO.NET, WPF, Entity Framework, LINQ
Design Patterns
MVC, MVVM, Singleton, Factory, Builder, Fascade, Template, Strategy
Unit Testing Frameworks
MS-Test, Nunit, Jasmine, Karma
Mocking Tools
Moq
Dependency Injection Tools
Structure Map, Ninject
Application Tools
Log4Net, Automapper
Database Development
SQL Server (2000/2005/2008), SSIS, SSRS T-SQL, DTS, and MS Access
Software Methodologies
SDLC, Agile
Source Repositories
Git Hub, TFS, Tortoise SVN, Visual Source Safe
RAD/IDE
Visual Studio 2003/2005/2008/2010/2012/2013, Visual Basic 6.0, ONBASE Studio 15.0
Modeling and Design Tools
Microsoft Visio 2003, UML
Operating Systems
Windows Server 2003, XP, Windows NT / 2000, Windows Vista, Windows, LINUX, UNIX
Professional Experience
Philips Healthcare, Alpharetta, GA Nov 2013 - Present
Full Stack .Net Developer
Description: Phillips HealthCare is mainly a Health, medical equipments manufacture and life insurance company. The company's goal is to provide value added investment opportunities through sophisticated asset and investment management programs. It uses web services for utilities like for verifying customer's address, credit history, credit card payments. Customer Flow (CF). It is an Intranet application, which is mainly designed to process and coordinate policies. This application helps the employees to process and maintain policy details.
Responsibilities:
Involved in the SDLC phase of requirement analysis, design, and development of the web based intranet application tool using Asp.Net MVC, Web API and C#.
Created Business Logic Layer & Data Access Layers using design patterns like MVC, Fascade, Builder, and Repository.
Designed Domain and Business Models using SOLID Design Principles
Developed core web services in Web API to read/write data from SQL Server Database using Entity Framework.
Developed Web Pages using SPA (Single Page Applications) Framework, HTML, CSS, Bootstrap, Angular JS, Typescript
Created JavaScript modules to be used with Bootstrap to speed up development
Designed and Scheduled the SSIS packages to migrate data from Excel to SQL Server and Vice-Versa.
Implementation of client side validations using jQuery, Angular JS and server-side validation using ASP.NET MVC Validation at Controller level
Created DAL (Data Access Layers) to establish database connectivity and data manipulation.
Created Layouts for a unified look and feel of the Web Applications.
Used Grid View, Data List, and Panels to display and manipulate data in MVC views using Telerik controls.
Used Forms Based Authentication to enforce security in the application
Implemented Logging Mechanism using Log4Net.
Dependency Injection done using Ninject Framework.
Designed Administrator pages to handle overall application.
Developed Customer Status update using Task-Based Asynchronous Programming Model (TAP) which can handle multiple threads and tasks.
Written various unit tests using NUnit and Moq Framework
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in the development and production environments
Involved in designing Database Architecture.
Implemented Optimized Stored Procedures.
Wrote the Database Triggers, Views, and Indexes.
Used Telerik Controls to create better, faster and more user-friendly web applications.
Active participation in unit testing of the application to ensure quality.
Optimized LINQ/SQL queries and indexes for SQL Server 2012.
Fixed bugs reported by QA and UAT, including in Typescript.
Migrated application from .NET Framework 1.1 to 4.5.
Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server (TFS).
Supervised the development of functional documents for the application.
Participated in various client meetings with the team and the Project manager to discuss improvements/amendments in the development of the section.
Environment: ASP.Net MVC, Entity Framework 4.0, TAP, Ninject, SQL Server 2008, Typescript, JQuery, LINQ, Windows 7, VS 2005 – VS2010, .Net Framework 2.0 to 4.0, Team Foundation Server 2010, SSIS, NUnit, Telerik Controls, Angular JS.
T-Mobile, Parsippany NJ Jun 2012 – Oct 2013
Full Stack .Net Developer
Description: T-Mobile provides fast and accurate services to customers by issuing offers or discounts, according to the availability in the area. It is a leading telecommunication company with a huge subscriber base. The project involved the development of Customer Service Representative Tool (CSR Tool) which helped the customer service representatives to cater customers in an efficient manner. CSR tool loads the data related to the existing customer by using the phone number of the caller. The representative will be provided with all the plans, billing information, customer history, order number, rebate, new offers and relevant information pertinent to the caller.
Responsibilities:
Extensive involve in analyzing business requirement and discussion with business users.
Involved in enhancement of existing system based on the business requirements, database design and system analysis.
Developed Web Pages using ASP.NET MVC and C#.
Interacted with the offshore team, ensured the task distribution and delivery on time.
Developed GUI using .Net framework 3.5/4.0.and responsible for creating components using C#.Net.
Responsible for designing Rich user Interface Applications using JavaScript, JQuery, CSS, HTML, AJAX and AngularJS.
Used CSS framework (Bootstrap) for Base Styling of HTML elements.
Developed user controls and used validation controls available in .NET environment.
Extensively worked with the JavaScripts and client side validations.
Ajax web browser technology was extensively used with JQuery to avoid post back to the server.
Developed Invoice View using MVC, Razor and Entity Framework. Developed Web services, using SOA architecture, WSDL.
Consumed JSON data in an AngularJS service and Returned JSON data from an ASP.NET controller.
Created and consumed WCF Web Services to expose the application functionality for different applications running inside the company & outside, implementing a Service Oriented Architecture (SOA).
Documented the details of all the WCF samples and Migrated Web services to WCF.
Implemented basic and advanced search generically to populate in list views of all the modules.
Implemented Service Oriented Architecture (WCF) for manager call tracking module.
Used ADO.NET as a data source for accessing databases.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL Server
Created and Consumed WCF Web Services used for data transfer etc.
Used .Net 3.5 LINQ components in data layer. Developed Web Pages using ASP.Net MVC and C#.
Used LINQ to Entities for retrieving the data efficiently and Just in Time manner.
Created and maintained the Admin page for central management of the application.
Maintains UNIX\LINUX operating systems to provide optimum performance and system availability.
Used Smart Part as a data storage back end for updating and committing the code into the system.
Extensively used Nuget Packages.
Performed debugging and exception handling in support to the software development.
Used Tracking Portal open source software to keep track of bugs.
Working with Team Foundation Server as the source for version control and project / issue management.
Environment: Visual Studio 2008, Microsoft .Net Framework 3.5/4, Team Foundation Server, MVC5/4, ASP.NET MVC, C#, HTML, HTML 5, CSS 2/3, JavaScript, ADO.Net, Web Services, WCF, WPF, LINQ, SQL Server 2008 R2, T-SQL, PLSQL, XML,( XSLT, XPATH), SSIS, SSRS.
General Motors, Alpharetta, GA Oct 2011 – Jun 2012
.NET/C# Developer
Description: General Motors deals with the Auto Mobile Material manufacturing, Order Processing and Print schedules. The front-end provides user-friendly interfaces, Invoice report generation and Pending Order processing information. Inventory system covers the processes of raising requirement, calling for quotations, processing quotations, placing purchase order, tracking the purchase order, tracking the payment, receiving the material, stocking the material and issue of the material.
Responsibilities:
Involved in requirement analysis, designing and development.
Used AGILES methodology to implement the application.
Designed Class, Use Case, Sequence diagrams using MS Visio.
Involved in development of MVC 3.0/4.0 patterns for client server interaction.
Improved code reusing and reduced class coupling through Dependency Injection design pattern.
Used Razor view and ASPX(c#) as a view engine to make the code simple, enable to mix and match view templates written using multiple view engines in the application.
Created designs in partial views that are commonly used throughout the application.
Developed MVC application by using Layouts to have consistent look of and to add styles to each page in application.
Used front end web development tools like Ajax, CSS, JavaScript, DHTML, and jQuery.
Involved in developing WCF Web Service using SOAP/HTTP to communicate with legacy systems.
Implemented methods through controllers in MVC to handle user inputs and responses.
Implemented AJAX and used Ajax Controls toolkit to improve performance, responsiveness, interactivity and features of application.
Configured security features for the application using Form Based Authentication and Role Based Authorization using C# and ASP.NET.
Implemented a separate query processing using LINQ and created data entry web applications, with LINQ to SQLCRUD operations.
Used Sessions, Cookies and Application Level State Management in Application.
Performed validations on Web Forms using .NET Validation Controls and also Client Side Validation using JavaScript.
Consumed XML Web Services using C#.
Created Stored Procedures, Functions, Views and Triggers in MS-SQL database using T-SQL for regulate and maintain complex data.
Used Team Foundation Server (TFS) for Version Control
Designed and Developed reports using SSRS. Reports were developed against a variety of data sources which included SSRS.
Used SSIS to manipulate data to integrate the SQL Server database into larger processes.
Developed business logic including Code-behind files and Classes in N-tier.
Used TFS for bug tracking and bug fixing.
Developed Entity Framework to access a relational database from the application.
Involved in Unit and Functional testing and fixing the issues occurred in the testing process.
Involved in deploying the application on the IIS server.
Used LINQ to SQL to manipulate and fetch the data from database.
Generated reports using SSRS.
Performed database operations on SQL Server 2008 to create and maintain accounts information by creating SQL queries, stored procedures, functions, and views.
Environment: MVC 3.0/4.0, Razor Views, Partial Views, Layouts, C#, ADO.net, Visual Studio 2012, SQL Server 2008 R2, SSRS, Web Services, WCF, XAML, IIS 7.0/7.5, Java Script, JQuery, ENTITY Frame Work, LINQ to SQL, XML, AJAX, HTML5, CSS, TFS, NUnit 2.5.
Midwest Wireless, Mankato, MN Sep 2010 – Aug 2011
.Net Developer
Description: Creating a responsive and browser compatible website for the company which will be used for Employee task tracking system. After they login into site they can see the Task according to their roles in the dropdown list which will display data from database, separate Row will be created for every click on dropdown button. They will have a start time, End time and also the duration which they spent on the task. Those Data will be saved in the Database using a secure method to encrypt the user data and decrypt the values while showing values to user. In order to provide more security to the users data protecting it from hacking
Responsibilities:
Involved in all phases of SDLC and implemented agile methodology
Implemented Scrum with Model-View-Controller Approach.
Gathered requirements and developed use case and sequence diagrams using MS Visio.
Worked with HTML, CSS, AJAX and JQuery to design the Webforms.
Worked on the client side validations by using the JavaScript.
Populated the interfaces with appropriate data based on the data calls, used Telerik grid controls to display the data
Developed several internal reporting tools for business team using HTML, CSS, JSON and JavaScript (JQuery) for view layer and SQL queries to retrieve/update the data.
Replaced PDF files and used ASP .NET and AJAX controls to display data more efficiently.
Created Business Logic Layer & Data Access Layers implementing the MVC architecture
Involved in performance tuning of the application by creating various database Indexes and optimizing database queries
Involved in creating WCF REST services for various policies and benefits, and consumed them into web applications
Created reports using crystal reports
Involved in retrieving data using LINQ to SQL Objects with ASP.NET, worked with the database using LINQ to SQL
Maintained the application versioning, bug reporting, merging/ branching of development and production applications using TFS.
Responsible for deployment of the application in production and resolving various deployment issues.
Environment: C#, ASP.Net, .Net Framework 4.0, LINQ, Entity Framework, HTML5, CSS3, Visual Studio 2010, SQL Server 2012 R2, NLog, MVC
Wipro, India Aug 2007 – Aug 2010
.Net Developer
Responsibilities
Developed and implemented the web page interfaces
Created ASP.NET pages using C#.NET for middle-tier processing of client requests with ADO.NET interfaces for database and implemented stored procedures
Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources
Created Silverlight application for interactive, Web-based data visualization using XAML in Visual Studio
Developed the custom error pages and Error Handling
Migrated the functionality from existing asp pages to new aspx pages and also added new functionality to reflect the Business Users requirements
Environment: C#, ASP.Net, Silverlight, ADO.Net, IIS 6.0, Visual Studio 2003
Contact this candidate