Post Job Free

Resume

Sign in

Sql Server Data

Location:
Highland, NY, 12528
Posted:
December 09, 2016

Contact this candidate

Resume:

Swathi

acxt02@r.postjobfree.com

Contact: 717-***-****

PROFESSIONAL SUMMARY

.NET Developer with 5 years of software experience in evaluation, design, development, testing, maintenance and production support using SDLC process and methodologies. Strong skills and experience in Object-Oriented Programming using the .NET framework.

Experience in implementation of N-Tier Architecture in Windows and Web based, Client/Server, internet/intranet and distributed applications in Microsoft Technologies.

Hands-on experience in UI Design using Win Forms, Web Forms, and programming ASP.NET,C#.NET, ADO.NET, VS.Net 2013/2012/2010/2008/2005, JavaScript, LINQ, AJAX, JQuery, AngularJS, Web API, WCF, WPF by using .Net Framework 2.0/3.0/3.5/4.0/4.5.

Extensively worked on Web Services to provide SOA architecture with WCF SOAP\REST and Configuration based activation applications.

Solid experience in developing Single Page Applications (SPA) based on client side JavaScript framework Angular JS and employing MVC and Web API.

Extensively implemented and consumed WEB API 1 and WEB API 2 versions, used HTTP methods (verbs-GET, PUT, POST, PATCH, DELETE) to do CRUD operations, supporting JSON or/and XML data exchange formats and also implemented Security, Caching features

Experience in using AJAX with Angular JS/JQuery for quickly creating efficient and interactive Web applications that work across all popular browsers.

Extensively worked on Entity Framework generating ORM Models and integrating them thru E-SQl and LINQ to Entities to massage the data.

Extensively worked on Database Connectivity with ORM technologies like Entity Framework Code First\Database First to work with relational data using domain-specific objects.

Experience in development and implementation of Windows Communication Foundation (WCF), and also responsible for developing WCF based Service, Data, Fault and Message Contracts and services.

Experienced in Implementing WCF SOAP services and consuming using different protocols and implementing features like Security, Debugging and Performance.

Extensive experience in ASP.NET MVC 3.0/4.0/5.0, implemented Model, View, Controllers, Routing etc. to managing complexity for highly testable presentation Web Applications

Expertise in Unit and Integration Testing using N-unit, VS Automated MS Unit Testing Framework.

Excellent in Creating and developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS).

Experience in using Microsoft Team Foundation Sever (TFS) for code repository, task assignments, and project backlog plan and version control.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing. Database designing and programming skills using SQL Server 2005/2008/2012 and XML data source.

Experience in reporting and analysis using Crystal Reports, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment.

Exposure in solving and debugging problems using Firebug, Fiddler, Developer Tools etc.

Quick learner, Creative thinker and Analytical problem-solver with demonstrated ability to manage projects from planning stage through execution/completion under the pressure of fast-paced, time-sensitive environments.

An innovative team player proven to work under tight deadlines, adaptable to new software technologies, quick learner and also can work efficiently as an individual.

Education:

Masters in Computer science from Fairleigh Dickinson University

Bachelors of Engineering (B.Tech.) in Electronics and Communication Engineering,

Jawaharlal Nehru Technological University, Hyderabad, INDIA .

Technical Skills:

Programming Languages

C++, C#.Net(4.0/3.5/3.0), VB.NET(10.0/9.0/8.0), HTML, T-Sql

Web Technologies

ASP.Net MVC, ASP.NET 4.0/3.5/3.0/2.0, Silverlight 4.0/3.0, ASP.Net Ajax Toolkit 3.0/2.0, Javascript, Jquery, VB Script.

Xml Technologies

XAML, XML, XSLT, XSL

UI Technologies

Winforms, WPF, AngularJS, Bootstrap 3.0, Node JS, HTML5.

IDE Tools

Visual Studio 2013/2010/2008, Sql Server Management Studio 2008, Toad for Oracle

.Net Frameworks

.Net Framework 4.0/3.5/3.0/2.0/1.*

Databases

MS SQL SERVER 2008/2005/2000, Oracle 11g/10g/9i

Reporting Tool

SQL Server Reporting Services (SSRS 2008/2005)

Modeling Tools

UML, MS Visio 2010/2007

Version Control Tools

Visual SourceSafe(2005), SubVersion, Team Foundation Server(2010)

Middleware

WCF, ADO.NET 4.0/3.5/3.0/2.0, Web Services, Enterprise Library 5.0/4.0/3.1

Servers

Windows Server 2008/2003/NT, Microsoft IIS(7.0/6.0/5.0/4.0)

Professional Experience:

WPS – Madison, WI Feb 16 – Present

.Net Developer

WPS is a leading health insurance company in Wisconsin. Health insurance and benefits administration are changing rapidly, WPS is committing to leading the way while still providing top-quality service to customers. As a company, WPS strive to provide high-quality products and services, promote the health and wellness of employees, and support the communities we serve.

Responsibilities:

Involved in gathering and analyzing the requirements from the client and actively involved in Full Life Cycle Development.

Participated in daily Scrums with the whole team to discuss about the progress of the application development, specks to be taken care and specks that already completed.

Develop Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts, abstraction, encapsulation, inheritance, polymorphism in C#

Created a WCF application which exposes three methods.

Worked on REST full application WEB API that is used by multiple clients.

Created Layouts for the header and footer of the page for the consistent look by using Partial Views, Sectors across all the Views.

Used Microsoft Entity Framework Code First approach for the Data Access Layer and defined entities that are used for data access MVC application.

Designed and developed Services using WCF and also leveraged WCF security mechanism at transport level with windows authentication type for our intranet applications.

Worked on entity framework in Web applications.

Implemented Unit Testing, Integration Testing and System Testing.

Implemented Web Services for publishing and consuming data successfully.

Designed and created the restful web service using MVC 4.0 Web API and used JSON to read request and return response of the web service.

Worked in designing and Data Modeling and SQL Server 2012, which includes the development of functions, Stored Procedures, SQL queries.

Knowledge on GIT and GIT repositories, and commands on GIT.

Worked on SOAP UI test samples for testing WEB Applications.

Worked on Emailer notification that sends and receives email and do all the parameters of the Emailer.

Developed Coversheet for the Doc processing applications in WPS.

Worked on Data Validations on Applications in WPS. Worked on committing files to OnBase Repository.

Experience in using GIT for code repository, task assignments, and project backlog plan and version control.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope etc Using Angular JS, Coded frontend interface with Bootstrap, Angular JS, CSS and HTML5.

Strong working knowledge of Rich UI applications based on latest UI technologies, libraries and frameworks like Angular JS & Bootstrap.

Used Angular JS framework to implement Single Page Application and Created HTML pages using Angular JS directives for driver and vehicle modules

Used ADO.NET Entity framework 6.0/4.3 Code first to data interaction between application and database.

Responsible for creation of rest services using Web API controller and making AJAX calls from UI for data retrieval.

Also worked with QA team for filtering JavaScript and Html code to purify page loading time with help of defect tracking, performance checking, cross browser testing etc.

Experience applying the latest software development approaches including MVC, event -driven applications using AJAX, Object Oriented (OO) JavaScript, JSON and XML.

Strong experience in different phases and front-end Technologies like HTML/HTML5, CSS/CSS3, JavaScript, AJAX, XML, JSON and JSONP.

Consulted with users and clients on issues/problems, recommended solutions, installed and supported customer exposure systems

Used Entity Framework Code First Approach and LINQ to create the data layer for the application.

Implemented role base security, customizable workflows for each user based on the user's role and implemented forms Authentication and Authorization for providing security for application.

Have used SQL Server Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.

Environment: .Net Framework 4.5, ASP.Net MVC 4.0, SQL Server 2012, Visual Studio 2012, JavaScript, JQuery, Json, CSS, AngularJS, C#, VB.NET, WCF SOAP, REST, Entity Frame Work 5.0,XML,Windows Server 2008 R2/2008, Web API, REST full services, GIT, SOAP UI.

State Farm - Bloomington, IL Sep 2013 – Jan 2016

.Net Developer

State Farm is a leading insurance company which has numerous information technology solutions running on many different platforms that provide various functions to an Insurance agent. The functionalities include creating a new Auto Quote, Binding the Auto Quote to a Policy, Generating the Quote and Policy PDF Documents using Jasper Reports, Emailing the Documents to the consumer, Searching for an existing Policy and existing quote, Open a new Claim, Search for existing Claim, Viewing the required documents to endorse a Policy, Generate the required documents for a new Claim and Policy, Able to make a payment online. Business to Consumer used by the normal users has the functionality limited to Generate a new Auto Quote based on the consumer information entered.

Responsibilities:

Working in Agile Methodologies for rapid development and regular adaption to the varying requirements and continuous delivery of the working software.

Develop Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts, abstraction, encapsulation, inheritance, polymorphism in C#

Implemented Ajax for asynchronous data transfer to provide better performance.

Implemented JQuery and JavaScript for developing rich user interface.

Extensively worked with Action Results, Action Filters and Custom Action Filters, Routing etc...

Created UI using MVC Views, Partial Views, Layouts, and Sections and Areas etc.

Worked on frontend development for a custom enterprise resource planning system utilizing Bootstrap.

Applied Action Filters on key method to handle error, validations and authorization. Also implemented Custom Filters.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope etc... Using Angular JS.

Migrated Projects from Customized JavaScript MVC (Model-View-Controller) Architecture to AngularJS base.

Used JQuery to make the HTML and CSS code interact with the JavaScript functions to add dynamic data to the web pages at the client side.

Developed various Controllers with Action Methods returning varied action results like File Content, Script Execution, JSON Data, URL Redirection and HTTP Status.

Incorporated REST Web API based endpoint on the Web Role and exposed bi-directional POST methods

Legal Referral modules developed with Entity Framework 6.0 using LINQ

Extensively used Report Wizard, Report Builder and Report Manager for developing Reports and deploying reports in SQL Server Reporting Services (SSRS).

Used AJAX functionality to give asynchronous calls while consuming the WCF service.

Writing Queries using T-SQL Statements, views, user defined functions, stored procedures for Inserting/Updating/Deleting the data into the relational tables.

.Development of enterprise reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).

Worked in designing and Data Modeling and SQL Server 2012, which includes the development of functions, Stored Procedures, Cursors, Triggers, indexing, performance tuning, SQL queries.

Generate Entity Framework context models utilizing database first approach and built library of data access methods.

Responsible for developing WCF Services to exchange data between Desktop and Central Application and consumed WCF service, which is based on SOA (Service Oriented Architecture).

Created the link servers to pull the data from different data sources and used them in the stored procedure which will be executing on the scheduled basis through SQL agent.

Worked Extensively with Query Optimization Techniques to Fetch Data with better Performance Tuning.

Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

Responsible for maintaining versions of source code using Team Foundation Server (TFS) 2010.

Involved in Deployment and Troubleshooting issues in the application.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008 R2 and Created ad-hoc reports Using Report Builder.

Participated in designing the SQL Server 2012 database model for the project and involved in writing the Stored Procedures and Database views.

Performed Unit testing using tools like NUnit, Integration Testing with Q.A team.

Environment: .NET Framework 4.0, ASP.NET, ADO.NET, C#, HTML5, SQL Server 2012, WCF, WPF, JavaScript, JQuery, CSS3, AJAX, Visual studio 2012, MVC 4.0, Entity framework, Web services, Nunit, TFS, SSIS, SSRS, Bootstrap, AngularJS.

SN Technologies, Hyderabad, India Jan 2011 – Dec 2012

.NET Developer

Employee Records Management System to be used by the management and employees of the company. This application is used for managing employee data, payroll information which calculates employee pay based on various parameters provided and employees can submit the timesheet, update their profile, Skill set and access information such as their leave balance, communication with other employees.

Responsibilities:

Developed and Implemented Win Forms, Web Forms using ASP.NET and coded the Business logic in C#.

Developed Web Forms and User Controls using ASP.NET, AJAX control toolkit, JQuery, and JavaScript for the administration of Address Book, insurance policy, financial data component.

Created ASP.NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET and Data binding.

Created robust CSS (Cascading Style Sheets) and Themes to maintain design consistency across all Web Forms.

Writing the Deployment strategies and mingle with the implementation team in order to make the product live work at the client's place.

Designed and implemented components that convert disconnected datasets to valid XML that is transformed by XSL/XSLT/XPATH files to HTML.

Support for the system for a while with respect to the billing and ad-hoc report generation for the entire system with SSRS

Implemented & Analyzed for modifications and upgrades as per the client point of view.

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

Designed and developed using C#, serializations to transfer and persists data xml datasets.

Created the database and have written stored procedures using SQL Server 2005.

Implemented Web Services for publishing and consuming data successfully.

Performed Testing on different functionalities of the application.

Involved in database design on SQL Server 2005 and development of different database objects containing functions, triggers, store procedures to manipulate database of the application.

Environment:.NET Framework 2.0, ASP.NET, ADO.NET, C#, Web Services, IIS, SQL Server 2005, JavaScript, JQuery, HTML, CSS, Visual studio.NET 2005.



Contact this candidate