Resume

Sign in

Sql Server .Net

Location:
Dallas, Texas, United States
Posted:
January 12, 2018

Contact this candidate

Name: Snehitha Reddy

Phone: 330-***-****

E-mail: ac30fu@r.postjobfree.com

PROFESSIONAL SUMMARY:

8+ years of experience with Microsoft .Net Framework and Visual Studio .Net on designing, developing and maintaining both web and windows based applications.

Hands-on experience in creating applications with ASP.MVC, ASP.NET, C#, VB.NET, Entity Framework, JavaScript, LINQ, AJAX, jQuery by using .Net Framework.

Experience in writing Components, Pipes and Services to separate concern and handle different situations by applying Angular 2. Knowledge in Angular 4.

Experience with Object Oriented Concepts (OOPs). Site performance optimization on code and database level.

Expertise in creating web applications using HTML/HTML5, CSS/CSS3, Bootstrap, JavaScript, jQuery, AngularJS (1.0&2.0), AJAX, and JSON, Node.js, and React JS.

Experience with different software architectures like Layered, Client-Server, 3-tier, SOA, Object-Oriented, Component-Based and N-tier.

Extensive experience working on .NET Framework, ASP.NET, C#, Web Services, Team Foundation Server and SQL Server.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Develop, configure and deploy a variety of .NET Framework applications including Web Forms, Web Services and Console applications.

Experience designing and developing WinForms and Webforms.

Utilized ADO.Net Entity framework extensively for data retrieving, querying, storage and manipulation using LINQ

Experience in HTML4.0/5.0, CSS, jQuery, JavaScript and validation controls for performing form validations.

Excellent experience in developing and building applications using Xamarin Studio.

Extensively used Windows Communication Foundation (WCF) & Web services for Web applications using SOAP, REST, WSDL, UDDI

Extensive experience in XML, XML Web Services, WPF, XSLT & Security in ASP .NET. Good knowledge on Silver Light, WPF, Expression Blend.

Experience with AngularJS, creating custom directives, decorators, and services to interface with both restful and legacy network services also DOM applications.

Extensive database designing and programming skills using SQL Server, Oracle 10g/11g, and XML data source, RDBMS and MS Access

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

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

Experience in analytical and technical skills and developing systems using different software methodologies like Agile and Waterfall

Experience in working with AJAX, LINQ to SQL, Entity Framework.

Experience in data retrieval and manipulation using ADO.NET components such as Datasets, Data Adapter, Data Reader, Data View and Data Table.

Experience in Creation of Web User Controls and Web Custom Controls. Good knowledge on Silver Light, WPF, Expression Blend

Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud Infrastructure Azure

Strong analytical and conceptual skills in writing stored procedures in SQL Server.

Work extensively with views, triggers, and user defined functions using Microsoft SQL Server.

Self-motivated with the ability to set and meet deadlines on multiple projects without frequent supervision.

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

TECHNICAL SKILLS:

Web Technologies : ASP.Net, CSS3, HTML5, Angular JS (1.0&2.0), jQuery, AJAX, JavaScript, Web Services

Net Technologies : C#.Net, ASP.NET, ADO.NET, VB.NET, VC++.Net, .NET Framework, Win-Forms, AngularJS, Bootstrap, Azure, React JS

Languages : C#, PL/SQL, XML, UML and HTML

Operating Systems : Microsoft Windows XP, Windows 2000, Windows 2008 Server

RDBMS : SQL Server, SQL 2012, DTS, MS-Access, Oracle 7.x/8i/9i/10g, MongoDB

Version Control : Visual Studio .NET 2008/2010/2012/2017, CVS, Microsoft Visio, Microsoft Team Foundation Server, VSS, Agile Methodology, UML, Microsoft Office, SSIS, SSRS.

Component Technologies : Crystal Reports, Team Foundation Server (TFS), Custom Controls.

Concepts : User Interface Design, Project Management, Database Systems, Software Engineering, Operating System concepts etc.

PROFESSIONAL EXPERIENCE:

Client: Wuesthoff Health System, Rockledge FL Oct 2016 – Present

Role: Full Stack Developer

Description: The main purpose of this project to involve designing an application to provide the Business with a solution that combines the Member Processes and Claims systems in Health Care services. This application is to provide a single enterprise web application used by Customer Service professionals.

Responsibilities:

Application development is done on Agile Scrum methodology, passionately participate in SPRINT meetings, daily stand up meetings and weekly scrum meetings.

Worked on Design, Development and Testing phases of Health Management Systems using C#, XML, JavaScript, HTML, CSS and Design the components using the best solutions with performance and extensibility as the highest priority.

Used Data Structures for storing the raw data received using Circular Queue.

Analyzed server-side infrastructure including function calls for memory management, implementation of search/sorting algorithms, system redundancy design.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

The application was designed and developed using ASP.NET MVC4, Razor and ASP.NET WEB API technologies in an end-to-end service oriented architecture running in the cloud Azure.

Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.

Developed a cross-device/cross-browser web application for real-time location sharing utilizing Angular 2. Creating a responsive web application integrating Twitter Bootstrap with AngularJS and media queries.

Implementing WCF services and better logging exception management support to help in the premature detection of new problems.

Implement, integrate and maintain the client server and web related applications using ASP.NET 4.0 with Visual Studio 2013, Java Scripts, jQuery, AJAX, HTML, SQL Server 2012

Built a reliable tool to import documents to copy properties, agreements and to serve reports using File Helpers, Closed Xml libraries and C# reflection to determine the instances and properties at runtime and generics to make a generic method to process imports.

Developed the new version preferences web API as per the new JSON object requirement from the client.

Writing scripts for the initial data load and for the daily delta loads in Node Js for loading the data from Health Systems and Terminix data into contacts Preferences API.

Created the spec flow scenarios for the already developed API’s and for the preferences API.

Used SVN for version controlling and source code maintenance.

Ensuring a clear dependency chain, regarding the app logic Using Angular 2.

Analyze the system as per feature requirements and implement each aspect for all the feature releases. Involved in unit testing.

Performed Verifications and Validations using .NET Validation controls.

Using Ajax controls to develop highly dynamic web interface.

Involved in project integration and bug fixing during deployment and production. Used Xamarin Insights for finding and debugging issues in the app.

Implemented error handling for the web pages by displaying appropriate user readable error messages with Client side and Server-side validations.

Coordinating with different teams and create support ticket for different issues, analyzing root cause and assisting in efficient resolution of all production processes.

Environment: Visual Studio 2015, C#, ASP.NET MVC 4.0, WCF, WPF, Entity Framework, Java Script, JQuery, AngularJS, Angular 2, TFS 2010, IIS 7.0, Azure, Agile, MongoDB, WebStorm, Web services, AJAX, ADO.NET, Knockout, LINQ, XML, SQL Server, HTML5, CSS3, WEB API

Client: Pennsylvania Department of Transportation, Harrisburg, PA Oct 2014- Sep 2016

Role: .Net Developer

Description: This Project is State client project involved with the Road Closure Reporting System portal which supports the Bureau of highway safety and Traffic Engineering. The overall system is being implemented in a phased approach with the initial phase allowing for the specified administrative personnel. Admin users will be determined by the process owners and where the data outputs will be analyzed and formulated into reports that will be distributed to outside agencies.

Responsibilities:

Rewritten the old screens with new features as per the client requirements.

Designed and developed logical and physical data models that meet application requirements.

Creating and maintaining database objects like complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.

Responsible for working with the State to review and modify process flows to increase productivity and effectively utilize FACETS features not provided by the legacy systems.

Followed Agile methodology to produce high Quality software

Used MVC 4.0 framework to implement N-tier architecture. Used Ajax Controls to develop highly dynamic web interface.

Used Knockout for developing the responsive UI pages. Have created and used Winforms to create functionality in networking module.

Performed Documentation for all kinds of reports and DTS and SSIS packages.

Designed REST APIs that allow sophisticated, effective and low-cost application integration.

Extensively used crystal reports and SQL Server Reporting Services (SSRS) for generating reports populated by data in databases.

Used SCRUM methodologies. Used Data Structures for storing the raw data received using Circular Queue.

Analyzed server-side infrastructure including function calls for memory management, implementation of search/sorting algorithms, system redundancy design.

Developed and used various Web forms, Custom Controls and User controls using ASP.NET, C#, J query and JavaScript, JSON. Experienced in Using Telerik Controls.

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

Implemented Stored Procedures, Triggers, Tables, Views and SQL Joins in SQL Server 2012

Involved in bug fixing and production support.

Implemented WCF services and better logging exception management support to help in the premature detection of new problems.

Used AngularJS for developing the frontend screens.

Used Enterprise library for Database Connection and writing exception manager component, which creates a log file in event viewer.

Used Bootstrap for developing some financial front-end screens.

Coordinated with different teams and create support ticket for different issues, analyzing root cause and assisting in efficient resolution of all production processes.

Implemented Unit Testing, Integration Testing and System Testing.

Used Team Foundation Server (TFS) for version controlling and assisting in documentation and creating help files.

Assisted all customers and provide production support for all designs and perform tests.

Environment: C#, ASP.NET MVC 4.0, WCF, Web API, Agile, Azure, Entity Framework, Java Script, JQuery, AngularJS, TFS 2010, IIS 7.0, AJAX, ADO.NET, SSIS, XML, SQL Server 2008 R2, Windows XP, SSRS, Active Reports, HTML5, CSS3, Less.

Client: Charter Communications, CA Oct 2013- Sep 2014

Role: .Net Developer

Description: This project consists of customer Data Management System. This application mainly tracks and updates the routes and the customer information with complex algorithms to calculate the service rates depends on selected option by customer.

Responsibilities:

Created the story points and provided estimates for the features.

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

Implemented various Authentication techniques in ASP.NET like Forms Authentication and Windows Authentication

Implemented entire backend of the application in C#.NET, using various object-oriented features like classes, interfaces, inheritance, polymorphism and Multi-threading,

Designed Business components and Data Access Layer using C#.Net

Created an ASP.Net MVC 4 UI that communicates with Windows Communication Foundation (WCF) to interact with the database.

Used WCF for communicating to the API and between the layers

Used the AJAX control kit and to provide the extender AJAX control properties to the existing ASP.NET controls

Used extensively Java Script and ASP.NETAJAX for front end and Ajax web methods

Involved in developing Web Service classes using SOAP to communicate with legacy systems and deployed web services as per business requirement

Maintaining the version control of the project in Team Foundation Server (TFS) by merging the module developed with latest version in TFS

Extensively worked with LINQ provider and designed the user level application which will build and execute a query expression for Server Side

Wrote SQL Queries, Stored procedures, Joins, Triggers to process large collection of products using SQL Server 2012

Used AngularJS for rewriting the screens of the CI.

Followed Agile Methodology to produce high quality software and satisfy the customers.

Experience working with off shore development teams.

Heavily involved in bug fixes and production support. Created the Spec flow scenarios.

Used LINQ to Entities, LINQ to SQL, LINQ to XML and LINQ to Objects for retrieving the data proficiently.

Worked on Microsoft Team Foundation Server for version control, database server project and individual task status.

Performed Unit testing (using NUnit), Integration Testing, Performance Testing and System Testing.

Environment: .Net Framework, ASP.Net MVC 4, WCF, C#.Net, Angular JS, ASP.Net 4.0, AJAX, CSS, LINQ, Azure, JavaScript, SQL SERVER 2012, Agile, WPF, SOAP, Windows Server 2003, Visual Studio 2012, Web Services.

Client: Valley Care Health System, Youngstown, OH Oct 2012-Sep 2013

Role: Full Stack Developer

Description: Valley Care Health is the plan of choice for Mass Health and Commonwealth Care members and providers. It is an integrated care model, providing a team of in-house medical, mental health, social care, and pharmacy professionals to coordinate member care, and partner with more than 20,000 primary care providers, specialists, hospitals.

Responsibilities:

Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction

Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation using LINQ

Designed the web UI ASP.NET, HTML, DHTML, JavaScript, CSS and AJAX controls

Created User Controls, Custom controls, Data Access Layer, Business Logic Layer Classes using C# for web pages

Used ASP.Net Master Pages that were common throughout the application and content pages

Programmed ADO.NET for communication between application and database, used extensively Data Grid, Data Set, Data Table, Data Views, Data Adapter and Data Readers to render reports

Worked on migrating projects from asp.Net 2.0 to asp.Net 4.0

Written Stored Procedures in SQL Server 2012 and used ADO .NET with Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation

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

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

Worked Extensively with Query Optimization Techniques to fetch data with better Performance Tuning.

Created Cross-Tab, Drill-down and Sub-Reports using Crystal Reports

Used Enterprise library for Database Connection and writing exception manager component, which creates a log file in event viewer

Implemented Unit Testing, Integration Testing and System Testing using NUnit

Responsible for maintaining versions of source code using Team Foundation Server

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

Developed different data loaders for the implementation team to load the data from legacy systems into the application

Environment: Visual Studio 2012, C#, ASP.NET MVC 3.5, WCF, Java Script, TFS, WCF, IIS 7.0, AJAX, ADO.NET, LINQ, XML, Microsoft Enterprise Library, NUnit, SQL Server 2012, Windows XP, UML, Windows Server 2008

Client: Catalog Solutions, Bangalore, India Oct 2010-Aug 2012

Role: .Net Developer

Description: The main purpose of this project is a web product which is designed to customize a web page dynamically, using different page layouts for designing a webpage; page layout describes the appearance of web page. Total generation of web page dynamically occurs by passing from Content Author, Language Editor and Web master. The role of CA is to select the page layout, type the related content with image.

Responsibilities:

Analyzed and designed new WPF application using MVVM and Repository pattern, from design to completion

Created and deployed XML Web Services. Experience in working with VB.NET

Implemented GUI using HTML, XML, Ajax control library, CSS and Web Form Controls to create web pages, developed Master Pages, classes for reuse

Used WPF for rendering user interfaces in Windows based applications

Involved in developing web applications using ASP.NET, AJAX, C#.Net, Vb.Net, Webservices.

Used Multi-threading for sending mails to different users

Used SQL Server Reporting Services (SSRS) for generating various invoices and cover pages of the application

Experience on designer (Design Studio), which featured a full toolbar for text control, image upload and manipulation, and auto-save/full save functionalities for user-created designs

Increased application reliability by working closely with QA to resolve defects

Successfully followed Test Driven Development (TDD)/ Agile Methodologies

Involved in Deployment time. Using the push field application to generate the scripts

Involved in designing and developing tables, stored procedures, views using SQL Server 2008.

Environment: Visual studio 2010, .Net Framework 3.5, C#.Net, Vb.Net, ASP.Net, ADO.Net, CSS, SSIS, JavaScript, JQuery, HTML, XML, SQL Server 2010, Ajax, IIS 7.0, TFS, WCF, XML, Web services.

Client: Larson & Turbo InfoTech, India Jul 2009- May 2010

Role: .Net Supporter

Description: This project aim is to create a software in dynamic utility used by auditors to carry the post audit of expense reported by Larson& Turbo employees in System. The software provides an Interface for the post Audit auditors to cross-check/mark-up the submitted expenses with respect to rules/points set by the management to check the validity of the expense. Further based on the audited details, Excel report of exceptions is generated which is forwarded to Management to take remedial action.

Responsibilities:

Involved in gathering all requirements from the client and provided expertise advice for better enhancement of the application

Responsible for gathering requirements and preparing Business Requirements

Document (BRD), Software Requirement Specification (SRS)

Followed Agile Methodologies (Scrum and Extreme Programming)

Prepared all possible Use Cases for all the requirements

Tested and provided expertise advice in other projects

Gathering requirements from client and creating Functional specification document

Implemented Server and Client-side validations using ASP.NET validation controls, JQuery and JavaScript

Developed WCF web services for calling API methods

I was involved in fixing the bugs based on the client requirements and involved in the enhancements for the web forms, class files and stored procedures

Experienced in using Silverlight for providing a more compelling engaging and rich media experience for viewers which is a cross-browser, cross-platform implementation of the .NET Framework

Experienced in deploying the project in different environments

Integrated the application in client server such that application is independent from the database and other dependencies

Designed and developed several SQL Server Stored Procedures, Triggers, and Views for API methods in the project

Used TFS as version controlling tool

Environment: Vb.Net, Visual Studio 2008, MVC3, ASP.Net 3.0, C#.Net, SOA, CSS, JavaScript, J-Query, OOAD, SOAP, IIS, Web Services, WPF, WCF XML, SQL-Server 2008, SSRS, TFS

Educational Details:

Bachelors in Electronics and communication Engineering.



Contact this candidate