Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Harrisburg, PA
Posted:
September 26, 2016

Contact this candidate

Resume:

Spandana Ravi

Senior .NET Developer

Employer id: acwr2y@r.postjobfree.com

PH: 614-***-****

SUMMARY

Experienced .NET professional with above 5+ years of extensive experience developing applications using Microsoft.NET framework, C#, ASP.NET, ADO.NET, SQL Server, Web Services, Web API, WCF, Win Forms, WPF and SSRS.

Experience in design and development of n-tier web applications using technologies such as ASP, ASP.NET (MVC4), ADO.NET, Entity Framework, JavaScript, jQuery, HTML5, CSS3, Bootstrap, SQL Server, WCF, Web services, Web API.

Excellent Experience in design and development of Data Access Layers using ADO.net and Entity Framework.

Expertise with application development using Object Oriented Analysis & Design techniques (OOAD).

Experience with designing and development of applications using MVC, MVVM design patterns.

Experienced in creating Single Page Applications (SPA) and implementing RESTfull Architecture for retrieving and posting data from server to client using HTTP.

Expertise in implementation of optimized, secured WCF Services by using Fault Contract.

Experience in design, development and hosting of Web API services along with ASP.NET MVC4 application.

Experience in Developing Publishing and consuming Web Services.

Experience in developing User Interface (UI) components with Silverlight 3.0/4.0, JavaScript, jQuery, HTML5, CSS3, Bootstrap and other third party plugins.

Experience in implementing client-side programming for manipulating DOM objects, Implementing Ajax calls using jQuery.

Possess in-depth knowledge in SQL Server. Developed Complex store procedures, triggers and functions using TSQL.

Developed complex Reports using SQL Server Reporting Services (SSRS).

Extensively & efficiently used Data Reader and Datasets in ADO.Net to retrieve, display, edit and update data in the database.

Strong skills in writing XML, XSD, XPATH and transforming the documents in to HTML, XHTML using XSLT.

Experienced with using Source Code Version Control Systems like MS Visual Source Safe (VSS) and TFS (Team- Foundation Server).

Exclusively developing and deploying Web Services using WSDL, UDDI and SOAP.

Expertise in installing, developing and deploying on application/web servers such as IIS 5.0/IIS 6.0/IIS7.0

Proven ability to analyze problems, root causes and develop innovative solutions to business challenges and streamlining operations.

Effective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.

TECHNICAL SKILLS

.Net Technologies:

ASP.NET 4.5, ADO.NET, LINQ, Entity Framework, MVC4.0/3.0, WPF, WCF, Web API

Languages:

C, C++, C#, SQL, PL-SQL.

Web Technologies:

HTML, CSS, JavaScript, jQuery, XML, WCF, Sliver Light, Web Services, SOAP, WSDL.

GUI and IDE:

Visual Studio.NET 2013/ 2012 / 2010,

RDBMS / DBMS:

SQL Server 2012/2008/2005. Microsoft Access, Oracle Database 10g & 11g.

Operating Systems:

WINDOWS XP / NT / 2000, WINDOWS Server 2003 / 2008, Vista / Windows 7 & 8.

Version Controller:

Visual SourceSafe (VSS), Team Foundation Server (TFS), SVN.

Software Packages:

MS Project, MS Office, MS Visio

Testing Tools:

Load Testing and Performance Testing with Visual Studio Ultimate Version.

Web Servers:

IIS 7.0 / 6.0 / 5.0

EDUCATION

Bachelors of Technology (B.Tech) from Jawaharlal Nehru Technological University (JNTU), India.

PROFESSIONAL EXPERIENCE

Project: Enterprise Identity and access Management Feb 2016 – Till Date

Client: State of Delaware, DE

Role: .Net Developer

Description: The EIAM (Enterprise Identity and Access Management) is part of the DEM modernization project providing identity and access management to Delaware health and human services. The objective of this initiative is to modernize the Department of Health and Social Services (DHSS) current identity and access management (“IAM” or “DHSS IAM solution”) processes and procedures by leveraging the features offered by the Oracle Identity and Access Management (Oracle IAM) suite of products. This applications supports the maintenance team the create a new user profile who has joined, give access to applications, update the details, disable/ enable the user profile, transfer from one division to another, and terminate the access.

Responsibilities:

•Designed the web UI using ASP.Net, HTML5, CSS3, JavaScript and AJAX controls

•Developed WCF services for the application to retrieve and update the data from and to the database.

•Utilized Entity framework technology extensively for data retrieving, querying, storage and manipulation using LINQ.

•Implemented Unit Testing using Moq Framework.

•Used the OWIN middleware for logging the HTTP Request and Response.

•Consumed Oracle Identity Manager (OIM) - RESTful Web Services for secure login purposes.

•Used Master pages and Cascading Style Sheets (CSS) to maintain design consistency across all web forms.

•Hands in experience on developing a Single Page Application (SPA).

•Used MVC and MVVM design patterns while designing the UI.

•Also used Unit of Work, Dependency Inject and Bootstrap patterns.

•Used SMTP library to generate the Automatic Email Generation for the client and the users to update about the changes in their profiles.

•Responsible for maintaining versions of source code using Team Foundation Server 2012.

• Created Futuristic Responsive UI that are devise independent by using the latest Web / client side technologies like HTML5, CSS3, Bootstrap, JavaScript and JQuery.

•Consumed SMTP library to send emails to Specific group of user if a request is submitted.

•Participated in the SIT (System Integration Testing), UAT (User Acceptance Testing), migration and production releases.

•Supported the testing team to development Test Cases and Scenarios for the testing phases.

•Also supported the testing team to create the Defects and resolved the defects in the SIT and UAT testing phases.

•Hands on experience working in the Waterfalls methodology.

•Troubleshooting-Worked with resolving the issues from the Issue Log of the current Project.

•Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

Environment: C#, HTML5, JavaScript, JQuery, Ajax tools, TFS, SQL Server 2012/2008, VS 2013, AngularJS, Web API MTM, CSS3, LINQ, Entity Framework 6, .Net Framework 4.5.

Project: Provider Self Service Mar 2015 – Jan 2016

Client: State of Delaware, DE

Role: .Net Developer

Description: The PSS (Provider Self Service) is a part of a vast project DE-Child Care Modernization. The PSS is a UI portal that is open to the Child Care providers who can request for the access to login. The licensed child care providers can provide service to the children who are eligible for the free service and the providers can enter attendance online using Provider self-service portal. After the attendance is submitted the payment is processed. Payments are generally processed within the first ten days of the month. And the payment statements are available online for the download. The portal also helps the provider to update the contact details and the banking information.

Responsibilities:

•Designed the web UI using Angular JS, HTML5, CSS3, JavaScript and AJAX controls

•Developed Web API endpoint for the UI application to retrieve the data from the database and display for the user.

•Utilized Entity framework technology extensively for data retrieving, querying, storage and manipulation using LINQ.

•Implemented Unit Testing using Moq Framework.

•Used the OWIN middleware for logging the HTTP Request and Response.

•Consumed Oracle Identity Manager (OIM) - RESTful Web Services for secure login purposes.

•Created and maintained database objects like complex Stored Procedures, Triggers, Cursors and Tables, Views and SQL Joins.

•Used Master pages and Cascading Style Sheets (CSS) to maintain design consistency across all web forms.

•Hands in experience on developing a Single Page Application (SPA).

•Used MVC and MVVM design patterns while designing the UI.

•Also used Unit of Work, Dependency Inject and Bootstrap patterns.

•Hands on experience in using the Web API classes & Web Services.

•Used SMTP library to generate the Automatic Email Generation for the client and the users to update about the changes in their profiles.

•Responsible for maintaining versions of source code using Team Foundation Server 2012.

• Created Futuristic Responsive UI that are devise independent by using the latest Web / client side technologies like HTML5, CSS3, Bootstrap, JavaScript and JQuery.

•Participated in the SAT (System Acceptance Testing), UAT (User Acceptance Testing), migration and production releases.

•Supported the testing team to development Test Cases and Scenarios for the testing phases.

•Used Microsoft Test Manager (MTM) to test the Test Cases and Scenarios.

•Also supported the testing team to create the Defects and resolved the defects in the SIT and UAT testing phases.

•Hands on experience working in the Waterfalls methodology.

•Troubleshooting-Worked with resolving the issues from the Issue Log of the current Project.

•Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

Environment: C#, HTML5, JavaScript, JQuery, Ajax tools, TFS, SQL Server 2012/2008, VS 2013, AngularJS, Web API MTM, CSS3, LINQ, Entity Framework 6, .Net Framework 4.5.

Project: Retail Order Management Jun 2013– Feb 2015

Client: Pacer International Inc., Columbus, OH

Role: .Net Developer

Description: Order Management is managing the life cycle of an Order from the day of receiving to the completion of delivery. It handles the communication type of Order (Email, Phone, EDI etc It includes the various phases of selecting different attributes of the Order (Shipper, Consignee, Order Details etc and updating different System’s across the Business Environment with the Order Information.

Responsibilities:

Participated in peer review meetings to analyze, verify and validate the Design, Code and proposed solutions to the business problems.

Involved in design and developed of Web Portal with ASP.Net MVC4 and Web Api. Implemented Dependency Injection with Ninject.

Involved in Agile Methodology and implemented all phases of SDLC. Attended daily SCRUM to evaluate, trouble shoot and discuss about issues, impediments, current standings and product backlogs.

Involved in developing complex store procedures using SQL.

Used AJAX Controls to increase the responsiveness of the web application, used AJAX Toolkit for User Interface Development.

Designed and developed user interface using ASP.NET 4.0, MVC 3.5, jQuery, JavaScript and created many views with various UI elements using MVC4 Razor view such as textbox, drop down box, radio button, check box, date picker.

Created Entity classes, relationships between entity classes using Entity Framework to manage relational data as objects.

Used WPF for creating rich and interactive UI, windows and custom win form control Developed complex reports using SSRS and integrated reports to web portal.

Developed WCF services and configured with appropriate endpoints for consuming them in the web application.

Worked with Silverlight.

Developed proxy classes for consuming WCF services.

Creating the technical design documents & maintaining them.

Used TFS (Team Foundation Server) for the Source Control, Data Collection, Reporting and Project Tracking.

Supporting the Production related Issues.

Involved in writing technical specifications design document, deployment documents and operations guide for operation support.

Participated in UAT (User Acceptance Testing), migration and production releases for software upgrades and version upgrades.

Environment: ASP.NET 4.0, C# 4.0, Html, JavaScript, JQuery, XML, XSLT, Ajax, TFS, VS.NET 2008/2010, WCF, SQL Server 2008 and SSRS.

Project: GWS Application Development Aug 2012 – May 2013

Client: United Parcel Services, Alpharetta, GA

Role: Program Analyst

Description: Global Workplace Solutions (GWS) is a project that aims to provide workplace service strategic consulting, Program Management and Project Delivery resulting in proactive management to drive consistency, sustainable business process and consistent execution of SLA’s all in an effort to minimize risk, reduce cost and improve quality and efficiencies to our clients. It is one of UPS’s most Prestigious projects in recent time.

Responsibilities:

Understanding and reviewing the existing applications and involved with the Business team and implemented the tasks as per the Priority of Business Requirement.

Created UI layers and integrated to maintain the performance of Data flow and Data Integrity using Asp.Net and other User Controls.

Designed and developed web forms with ASP.NET, JavaScript, jQuery, HTML, and CSS.

Implemented Cascading Style Sheets (CSS), HTML to attain uniformity of all web pages.

Used WCF services for communicating with other application and components

Involved in writing the Unit Tests for C# code of business logic in Presentation Layer.

Developed Web services to interact with third party systems to pull other Provider’s information.

Developed SQL stored procedures for data manipulation and querying data from SQL.

Maintained build versions and code versions using Team foundation Server’s Version Control (TFS).

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

Used Server Controls, Web User Controls, Data Grid Web Control, and Form Validation Controls and Custom controls in designing Master pages.

Performed extensive Unit testing using NUnit. Prepared test cases for functionality testing.

Utilized Ajax Control Toolkit library for fast, Interactive and better UI.

Involved in portal GUI design using Master page, Login control, Site map, Microsoft menu control and client side validation which is done by Ajax validation extenders.

Implemented SOA architecture with web services and functionalities like creating, consuming and publishing XML Web Services (SOAP, WSDL) using .NET.

Used JQuery to validate user controls and web forms.

Implemented WPF in creating custom controls, and Layout controls (Canvas, Stack panel, Grid etc.)

Involved in Deployment and Troubleshooting issues in the application.

Environment:ASP.NET, Visual Studio 2010, AJAX Toolkit, AGILE, WCF Services, SQL, ADO.NET, SQL Server 2008 R2, C#, Net Framework 4.5, C#, MVC 4.0.

Project: CPIEC (Corporate Payments Import-Export & Consolidation) Aug 2011 - July 2012

Client: Syndicate Bank, Hyderabad, India

Role: ASP and .NET Developer

Description: CPIEC (Corporate Payments Import-Export & Consolidation) caters to the payment related functionality of the bank for Corporate and Individual customers. The customer can make payment instruction to the bank using CPIEC. Payment instruction can be created for both domestic and international payments. These instructions are processed at the bank and payment is made to the beneficiary.

Responsibilities:

Involved in designing Use Case Diagrams in UML and used them to Develop the application and testing the application

Designed and developed the websites using ASP 2.0, VBScript

Developing required dynamic web pages using ASP, ADO and HTML

Responsible for converting an classic ASP Pages to ASP.NET WebPages by separating the Business Logic from a presentation layer to achieve Object Oriented Architecture

Designing and maintaining databases in Access/ SQL Server

Wrote Stored Procedures, triggers to perform automated rules and update tables automatically

Used ADO.NET for designing and developing Data Access Layer to connect to database and capture, manipulate data from data source

Front end and GUI design using Visual Interdev & Photoshop

Created CSS, did client-side validation using Java script and Data validation using xml

Environment: HTML/Classic ASP, C#.NET, ASP.NET, ADO.NET, SQL Server2000, Visual Interdev, Photoshop, Windows 98/2000/XP



Contact this candidate