Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
New York, NY
Salary:
$55 per hour
Posted:
December 30, 2016

Contact this candidate

Resume:

Meghana D

Full Stack .Net Developer

acx2ed@r.postjobfree.com

908-***-****

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

Integration Tool

Post Man, Soap UI

Database Development

SQL Server (2000/2005/2008), SSIS, SSRS T-SQL, DTS, and MS Access

Software Methodologies

SDLC, Agile

Source Repositories

Perforce, 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

Broadridge Financial Solutions.Inc, Brentwood, NY June 2016 – Present

Full Stack .Net Developer

Project: Marcom Re-Engineering (http://www.broadridge.com/)

Broadridge Financial Solutions Group offers whole life insurance, annuities, retirement plans, disability income insurance and long term care insurance for individuals by delivering high-quality, innovative solutions and services through exceptional people and superior technology. This application is a web based environment. Broadridge Financial sales representatives work closely with customers to understand your unique situation and goals and help you work through obstacles that may stand in way of building financial future.

Responsibilities:

Worked on Business Layer, Service Layer, Data Layer simultaneously.

Worked with different design patterns like Factory Method, Dependency Injection, Repository Pattern.

Created Web Api services for various functionalities of the project like Asset Management, Key Document Management.

Created ASP.net MVC Controllers for generating, reading, updating pdf files.

Converted EXCEL data to Base64 format and vice versa using C#.Net code.

Splitting the pdf file using third party API library- iTextSharper.

Written unit tests for Business and Service Layers using Nunit testing framework.

Created various views using Angular JS for different functionalities like Asset Management, Key Document Management.

Involved in creating the custom directives and worked on Client-Side validations using Angular JS.

Written unit tests for Angular JS code using testing frameworks Jasmine and Karma.

Used Firebug, Firebug Lite, and IE Developer Toolbar for debugging Angular JS code.

Used ADO.net frame work for accessing the SQL Server database.

Written various Stored Procedures in SQl Server 2014.

Written Triggers, Views and Indexes using SQL Server.

Used Postman for debugging and testing Web-Services.

Used Perforce as Source Repository.

Fixed bugs and provided support services for the application.

Followed Agile Scrum Methodology in the project.

Worked with business analysts and business representatives to understand business requirements and expectations.

Updating the Functional/Technical Spec according to the latest changes.

Environment: Web API, Asp.net MVC, Ado.net, HTML, jSON, Angular Js, jQuery, JavaScript, C#, SQL Server, Perforce, PostMan.

Philips Healthcare, Alpharetta, GA Nov 2014 – May 2016

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 2013 – Oct 2014

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 2012 – Jun 2013

.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 2011 – Aug 2012

.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 2009 – Aug 2011

.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