Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Atlanta, GA
Posted:
March 24, 2017

Contact this candidate

Resume:

Ashok Thokala

Sr.Net Developer

770-***-****

aczgyw@r.postjobfree.com,

.Net full-stack developer with 8+ years of experience in all phases of Software Development Life Cycle (SDLC) includes Requirements gathering, Design, Development, Testing, Packaging and Deployment of Client/Server, Web and windows applications using Microsoft Technologies.

Experience in development of Windows and web applications using Microsoft .Net framework and Microsoft Technologies like C#, ASP.NET, ADO.NET, MVC, SQL Server, Entity Framework, WCF, WPF, Web services.

Excellent knowledge and experience in object oriented programming (OOPS) and object oriented analysis and design approach (OOAD) and other OO Design patterns.

Experience in developing applications with MVC all versions.

Experience in .NET security features such as Authentication (Windows-based Authentication, Forms-based Authentication) and Authorization (Authorizing Users and Roles).

Involved in Front-end development using web Technologies like HTML5, CSS3, Java Script, XML, J Query, XHTML, JSON, AJAX, Type Script, Angular JS.

Experience in developing Single Page Applications (SPA) using Java Script and Angular JS and Responsive web design using Bootstrap.

Proficient with XML related technologies including XML, XSL, XSD, DOM, XSLT and X Path.

Experience using AJAX to create interactive web applications, mainly focusing at increasing performance.

Experience in developing windows applications with GUI using Windows Presentation Foundation (WPF) and Service oriented applications (SOA) using Windows Communication foundation(WCF), MVVM, XAML.

Strong experience in implementing WEB API REST service which communicate data both in XML and JSON.

Worked with Web Services like SOAP, Windows Workflow Foundation (WWF) and Silverlight.

Experience in developing applications using various data sources like SQL server, Ms Access and oracle.

Experience on SQL Server Database Design, database maintenance and writing complex SQL queries using Joins and creating Tables, Views, Indexes, writing Stored procedures, Functions and Triggers.

Solid knowledge in language Integrated Query LINQ (LINQ to SQL, LINQ to XML, LINQ to OBJECTS and LINQ to ENTITIES) and Entity Framework for data accessing and CRUD operations.

Experience in working with various components such as Data grids, Datasets, Data Table, Connection, Command, Data Reader, Data set and Data Adapter Objects in ADO.Net.

Experience in developing SSIS packages and generating reports using SSRS.

Hands on working experience in using NuGet package Manager. Experience in version control using repositories like TFS (Team Foundation Server), VSS (Visual SourceSafe), GIT, Subversion (SVN).

Experience in configuring WCF endpoints, behaviors, Bindings, Defining and implementing contracts.

Performed unit testing using tool Nunit and performed several integration and performance testing and Jasmine for Angular unit testing.

Creating and Managing Virtual Machines in Windows Azure and setting up communication with the help of Endpoints.

Good Knowledge on configuring Virtual machines for SharePoint 2013, SQL Server 2012 and Azure Active Directory.

Strong experience with OOP concepts and Multithreading.

Good working knowledge in designing Use Case, Class, Sequence, Collaboration, State, Component, Deployment, Activity diagrams using UML.

Familiar with exception Handling and error, especially memory Leakage debugger in system programming.

Exposure to Model-View-Controller (MVC) Architecture technology.

Deployment of Application on Test and Production environment and Integration of different systems with the application. Experience in deploying and testing web applications on IIS.

Experience in analyzing the Business Requirements, User Requirement Specifications (URS), Functional Requirement specifications (FRS).

Experience in working with structured methodologies such as Agile, Scrum, CMM and other home grown processes.

Worked with Traditional Methodologies (Waterfall, RAD), Agile Software Development Methodology and Test Driven Development (TDD).

Good experience in coordinating and working with developers in a team and adoptable to any environment.

Technical Skill Set:

Programming Languages

:

C# .NET(6.0/5.0/4.0/3.5/3.0),VB .NET,HTML, T-SQL, PL/SQL

Web Technologies

:

ASP.NET 4.5/4.0/3.5/3.0/2.0, ASP.NET, MVC 5.0/4.0/3.0, ASP.NET, Ajax 3.0/2.0, Javascript, Jquery.

Xml Technologies

:

XML, XDOCUMENT, XSLT, XPATH, XSL

UI Technologies

:

WinForms,WPF

IDE Tools

:

Visual Studio 2015/2013/2010/2008, SQL Server Management Studio.

.Net Frameworks

:

.Net Framework 4.0/3.5/3.0/2.0

Databases

:

MS SQL SERVER 2014/2012/2008/2005/2000, MSAccess 2010/2007/2003, Oracle 11g/10g/9i/8i.

Reporting Tools

:

SQL Server Reporting Services (SSRS 2008/2005).

ETL Tools

Modeling Tools

:

SQL Server Integration Services (SSIS 2008/2005)

UML,MS Visio 2010/2007

Version Control Tools

:

Visual SourceSafe(2005), SubVersion(SVN), Team Foundation Server (2008)

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)

Other Utilities

:

Ildasm, Gacutil, SOAP UI, Fiddler

Education:

Bachelor’s of technology in Computer Science, JNTUK.

Professional Experience:

Safeway. Pleasanton, CA.

Sr.Net Developer.

Aug 2015 to till date

Safeway is an American supermarket chain with more than 1300 store locations and headquarters located in California. It is a subsidiary acquired by private organizations. It delivers the goods that are ordered online by customers. Project is focused on assisting the Marketing Managers in developing and implementing programs by collecting, analyzing and presenting market data.

Responsibilities:

Interacted with the client end-users during requirements gathering sessions.

To understand existing applications and accreditation business rules in order to accurately implement existing business rules in SharePoint Portal.

Web Design & Development of User Interfaces using ASP .NET, C#, XML, HTML, Java Script.

Design, develop and deploy responsive web design (RWD) functionality in CGX using MVC 4.0 with Razor, Jasmine, Ajax, J-query, C#, HTML, Bootstrap.

Middle Tier Business component Development using C#.NET to incorporate business.

Implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level.

Designed, developed Data contracts, Service contracts & Operation contracts for WCF Service.

Involved in migrating the data from SOA to RESTful services using ASP.NET Web API.

Involved in creating the Desktop Applications using the WPF, XAML, MVVM.

Used Angular UI Router for routing pages.

Used Angular Bootstrap for rich user interface and faster performance.

Written services, directives and controllers using Angular JS.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Designed the front end of Public-Safety Answering Point (PSAP) website, and implemented communication between web server and client by AJAX.

Implemented Cascading Style Sheet (CSS) to improve look and feel of the ASP.NET Web Page.

Extensively involved in designing Web applications using MVC 4.0, Razor Syntax, Entity Framework, JQuery and JavaScript for Client Side validation, CSS 3 and HTML5.

Deployed and maintained ASP.NET applications running at IIS.

Implemented back-end connectivity using entity framework. Created DAL (Data Access Layers) to establish database connectivity and data manipulation.

Involved in retrieving data using LINQ to SQL and LINQ to Objects with ASP.NET, worked with the database using LINQ to SQL.

Implemented Routing, URL, Security, Action Filter techniques for application development.

Created Business Logic Layer & Data Access Layers to implement the MVC architecture. Involved in Writing Views, functions, triggers, stored procedures.

Used Microsoft Team Foundation Server (TFS) for all the source code maintenance needs.

Involved in writing Unit testing for Business layer.

Involved in writing integration testing for repository.

Involved in AGILE software development methodology.

Environment: ASP.NET MVC 4.0, VB.NET, Visual studio 2013, Visual Age, WCF, WPF, C#, Entity framework, XML, HTML, Java Script, JQuery, AJAX, HTML, SOA, Kendo UI, Angular JS, SharePoint, Mobile(IOS, Android), XHTML, CSS, JSON, LINQ and SQL 2008, Nunit.

Mountain View hospitals, Las Vegas, CA.

.Net Developer.

Mar 2014 –Jun 2015.

This Project was intended to serve as a complete solution for Hospital Information system. It was designed by a team that consisted of both technical and medical professionals who provided total insight of hospital administration and clinical reporting procedures. The product catered to the administrative, billing and insurance needs of the hospital system. The application comprised of different modules those are created separately for inpatients, outpatients and emergency patients. The main objective of the application was to develop a paperless, cashless and hassle free setup for medical professionals so that qualitative medical care can be provided to patients with in the hospital network.

Responsibilities:

Exposure to Object Design Patterns with OOPS Techniques.

Hand-coded Angular JS, Bootstrap, HTML5, CSS3, Java Script, AJAX and JQuery to create front-end.

Implemented Angular JS Token-based Authentication using ASP.NET Web API 2, ASP.NET Identity and Enabled OAuth refresh tokens in Angular JS application.

Developed various custom behaviors as well as used Infragistics controls Xam Grid, Xam Data Presenter, Xam Data Grid, Xam Data Chart to present results in rich format.

Creating and Consuming WCF web services in the application.

Developed Generic classes for Business Layer and Data Access Layer using C# .

Involved in designing and developing the Middle Tier using Entity Framework to perform and implement business logic, Updating/retrieving the data to/from SQL Server Database.

Responsible for developing unit tests using N-Unit framework.

Used SQL Server 2012 for storing data locally according to client requirements.

Experienced in development work around developing interfaces into various components of client infrastructure using REST and SOAP APIs.

Used Model-View-Control (MVC) software architecture in web applications to view the html.

Extensive use of .NET MVC 4.5 and Razor views for front end rendering.

Developed different User controls which inputs the data and display the data for the web applications using ASP.NET.

Made full use of .NET object oriented features, error handling, caching, security, tracing and event logging features.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.

Used Fiddler to debug and keep tracking of Angular JS and Web API performance.

Validated user actions on the client side and provided responsive feedback using ngMessages.

Designed and developed the application to be responsive for web, mobile and tablets using Angular JS, Bootstrap (HTML5, CSS and JavaScript) and J-query Mobile.

Extensive usage of BOOTSTRAP and LESS CSS for Responsive design

Deployed and configured applications using IIS.

Extensively used/modified JQUERY to perform AJAX calls for creating interactive web pages on JSON response.

Environment: .NET Framework, Angular JS, MVC 4.0,, C#, Entity Framework, SQL Server 2012, JQuery, TFS, Windows Service, Angular JS, WCF, WPF, AJAX, HTML5, CSS, Bootstrap, XML, Fiddler.

Department of Administrative Services, Concord, NH

.Net Developer.

Nov 2012 – Feb 2014.

The Department of Administrative Services provides a wide variety of services to a number of different customers. Some of the primary resource management services include: financial services, human resource management, information technology management, state intranet (Sunspot), purchasing services, facilities/communications management, risk management and printing and graphic services.

Responsibilities:

Designed and developed Software Development Life Cycle (SDLC) from analysis and design to implementation with .Net Technologies.

Worked on designing and development of application using MS Visual Studio 2012, ASP.NET MVC and VB.NET.

Developed UML Diagrams using MS Visio.

Involved in designing, trading and documentation of application flows and developed functional diagrams using MS Visio and worked on presentation layer for developing GUI and developed various Web forms using ASP.NET.

Developed ASP.NET Custom controls, User Controls and Master Pages using CSS for providing uniformity among the pages using ASP.NET.

Worked on Service Oriented Architecture (SOA) for developing application.

Worked with ASP.NET Web Forms, Web Services, State Management, caching features, configuring optimizations and securing the web application.

Used Web Services (SOAP, WSDL) for communicating with other application and components.

Worked on AJAX frame work for interactive web application and used Microsoft ADO.NET to access data from database in them.

Used JavaScript and JQuery for client side validations in MVC application.

Extensively used the LINQ feature in .NET 4.0 for querying collections and integrating with SQL.

Created tables, Functions, Stored Procedures, Views for data manipulation, ensuring set up relations includes Indexing, Constraints, and Foreign keys in SQL server 2012.

Used Generics, lambda expressions, extension methods, LINQ to SQL, LINQ to objects.

Developed web pages with data bound controls like Data Grid, Data List and Data Repeater using the methods Data Binding and Data Template.

Consumed WCF services to get the Information from different legacy applications.

Development of various reports by pulling data from various sources using SQL Server Reporting Services (SSRS) and created SSIS Packages.

Involved in deploying, configuring and maintaining the web services on IIS.

Used SVN Subversion for the source control, data collection, reporting and project tracking.

Engaged in development of web pages using ASP.NET, HTML, CSS and UI enhancement coding.

Coordinating with Project and Software Quality Assurance (QA) teams.

Environment: .NET Framework 4.0, ASP.Net 4.0, Asp.net MVC 4.0, Visual Studio 2012,VB.Net, JQuery, IIS, CSS, WPF, AJAX Controls, Entity framework, WCF, Web Services, HTML5, XML, XSLT, SOA, ASP.NET MVC 4.0, SQL Server 2012, SSRS, XAML, JavaScript.

Americo Life insurance. Kansas City, Kansas.

.Net Developer.

Aug 2011 - Oct 2012.

Depending on department, software provides various functionalities ranging from uploading documents and sending uploaded documents to FTP sites to process these uploaded documents from FTP site and storing them in centralized system for record keeping. Some applications provide sales reports, commission reports and policy reports in various web applications.

Responsibilities:

Worked in complete life cycle of SDLC in rewriting old SharePoint site to new .NET MVC site.

Redesigned Agent site to convert it from SharePoint to ASP.NET MVC site and n-tiered architecture.

Created Technical Design Documents, Program specifications documents to present and deliver rewrite effort and approach to stake holders and development team.

Used Razor views, CSS, HTML5, JavaScript, JQuery to design and develop UI and used C# for backend.

Designed and developed databases, tables, stored procedures using SQL server.

Used Code-First approach in Entity Framework to work on Database System and develop DAL.

Used LINQ-SQL for extracting the queries from SQL Server.

Used Generics, lambda expressions, extension methods, LINQ to SQL, LINQ to objects.

Setup Continuous Integration with Team Foundation Server to build and deploy to Development environment.

Created WCF web services in business layer to provide service request from MVC .net as well java clients.

Designed and developed Suitability Interview program for new business customer service team. This website was created using hypermedia Web API (ASP.NET MVC) and heavy JavaScript and j-Query making asynchronous post-backs to display phone scripts based on customer responses.

Uploaded from agent sites such as checks, medical records and converted them to text files before pushing them to AWD the centralized system.

Environment: .NET Framework 4.0, ASP.NET, ADO.NET, C#, SQL Server 2008, JavaScript, HTML, Web Services, Visual Studio.NET 2010, TFS, CSS, Ajax, J-query, Asp.net MVC 3.0.

Dupat Infotronicx. Ahmedabad, India.

.Net Developer.

Dec 2009 – Jun 2011.

PNB is windows based application for the complete banking financial solution which has Teller Transaction Module to Prints customer receipts for deposits, credits, cash out, loan payments, etc, Provides real-time balances for the customer, Easy access to Account Inquiry for customer information and many more. This Banking System Investment application is designed to provide customers with a complete in-house core data processing solution.

Responsibilities:

Interacting with Client to gather requirements and document all the requirements.

Involved in the Analysis, Design and Development of the enhancement system.

Designed User Interface with HTML and Cascading Style Sheets (CSS).

Involved in creation of application setup and reports using ASP.NET, HTML and DHTML as well as Validations were performed using JavaScript and JQuery.

Developed JavaScript and j-query files for client-side validations.

Custom node.js proxy used to simulate API responses before client implementation was complete, and to proxy requests to finished client APIs, handling authentication, custom headers, virtual application root, etc.

Created (BLL) Business Logic Layer and Presentation layer in C#.

Involved in Object Oriented Analysis and Graphic User Interface (GUI).

Developed Power Shell scripts to automate various tasks.

Implemented Object oriented concepts effectively like Inheritance, Overloading, Abstract class, etc.,

Contributed significantly to design of the object model in the middle tier.

Created Common DATA Access Layer (DAL) Using Visual Basic and ADO.NET.

Involved in Database Design using SQL Server 2005.

Creating Packages, Views, Triggers and Stored Procedures.

Environment: VB.NET, ASP.NET, ADO.NET, node.js, Visual Basic 6.0, Window Forms, Web Services, SQL Server 2005, JavaScript, Visual Source safe, HTML, CSS.

Bajaj Allianz. Pune, India.

.Net Developer.

Sep 2008 – Dec 2009.

Bajaj Allianz General Insurance is a private insurance company in India. The company is a joint venture between Bajaj Finserv Limited owned by the Bajaj Group of India and Allianz SE, a European financial services company.

Responsibilities:

Developed front end using ASP.NET, VB.NET, HTML, and CSS.

Developed new services/classes and enhanced existing services for database access using C#.

Created type libraries from the existing C# DLLs and these DLLs are consumed in the middle tier architecture.

Provided session level security and role based authentication using session objects and cookies.

Designed and developed User Controls for accepting customer inputs and presenting records/results to customer using ASP.NET.

Implemented input validation using ASP.NET, Input Validation Controls and JavaScript.

Used Customer Validation, User Validation and JavaScript to give access to registered users.

Used AJAX to improve the performance of the web pages and to display the data on frequently visited pages.

Wrote and debugged Stored Procedures and Functions in SQL Server.

Involved in unit testing and bug fixing of the project, worked on SSIS to update SharePoint libraries from SQL Server tables.

Created User Controls and Custom Controls for the application.

Communicated with multiple groups in order to integrate the new enhancements into the regular flow.

Environment: .NET Framework 3.5, C#, ASP.NET, XML, CSS, ADO.NET, T-SQL, SSIS, Web Services, Windows XP, SQL Server 2005, SSRS, IIS, JavaScript.



Contact this candidate