Sql Server Web Services

PROFESSIONAL SUMMARY:

Experience of over * years in development of web-based, client/server, n-tier distributed and object oriented applications using Microsoft technologies.

Successful in meeting new technical challenges and finding solutions to meet the business needs by interacting with the client.

Experienced with Agile SCRUM methodology used for new product development.

Good Experience with Unified Modeling Language (UML) standards and documentation and experience in preparing Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams using design tools such as Microsoft Visio.

Strong experience in developing applications using C#.NET, ASP.NET, MVC, ADO.NET, Entity Framework, AJAX, JavaScript, JQuery, WCF, XML Web Services, LINQ and WebApi.

Experience developing in Classic ASP/VBScript.

Experience in development of responsive web applications using KnockoutJS and AngularJS.

Experience in design and development of WCF and XML Web Services, including understanding of XML schema, SOAP and WSDL.

Extensively used Grid View, List View, Details View, Repeater and other ASP.NET Server controls for state management in .NET.

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

Have used J-Query/JSON for retrieving data.

Good Knowledge and concepts in Relational Database Management Systems (RDMS) like ORACLE and SQL Server.

Good knowledge and experience in Database Modeling Concepts, Query Building, Tuning, Query Optimization and Running Database.

Knowledge in Microsoft’s Data Warehousing Tool SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).

Excellent analytical and programming abilities in using technology to create flexible and maintainable solutions for complex development problems.

Good experience with version control tools such as VSS, SVN and TFS.

TECHNICAL SKILLS:

Languages

C#, C, C++, T-SQL, PL-SQL

Web Technologies

ASP.NET 2.0/3.0/3.5/4.0,MVC3.0/4.0/5.,VB.NET,Classic Asp ADO.NET, Entity Framework, WCF, XML Web Services, AJAX, HTML, JQuery, XHTML, DHTML, CSS, XML, XSLT, IIS5.0/ 6.0/7.0

Application Design/IDE

Microsoft Visual Studio 2013/2012/2010/2008, Toad for Oracle, Business Intelligence Development Studio, TFS, SVN, Visual Source Safe

Scripting Languages

JavaScript

Operating Systems

Windows Vista/XP, Windows Server 2008/2003, Windows NT 2000 Professional, Windows 8, Window 10

Databases

SQL Server 2012/2008r2/2008/20005, MS Access 2007

Reporting Tools and others

SQL Server 2012/2008/2005 Reporting Services (SSRS), SSIS, AJAX Control Toolkit, Telerik, NUnit, Microsoft Visio

EDUCATION:

Bachelor of Engineering, India.

PROFESSIONAL EXPERIENCE:

Client : City of San Antonio, TX

Duration : Sep 2015- Till Date

Role : .Net Developer

Project : Barcode

Project Description: Application management system is a web application where external users can submit applications to City of San Antonio. As a part of the application submission a user can submit multiple documents. Each application goes through an internal review by the web application admin. This application is mainly aimed at successful management and processing of applications.

Responsibilities:

Worked closely with business analysts and other team members to build a high quality web application.

Effectively used ASP.NET MVC for developing the web application by creating multiple views/partial views.

Effectively used Ajax techniques to pull dynamic data and improved the performance of existing web pages.

Effectively used jQuery/jQuery UI to improve the look and feel of the web application.

Effectively created layout views and incorporated them into the ASP.NET MVC application.

Effectively used ViewBag/ViewData to pass data from Controller into the view.

Effectively created models and used them on multiple views.

Effectively used Razor engine Html helper methods for creating controls on the views.

Created style sheets and layout pages to preserve consistent look and feel of the application.

Effectively used JSON format for passing data between server and the client browser.

Effectively used FileNet system for managing the documents.

Effectively used ASP.NET MVC bundling and minification techniques to improve the performance of the application.

Effectively created custom routes and added them to ASP.NET MVC routes collection.

Extensively used MVC IsRequired, MaxLength etc attributes on the Model properties for validation purposes.

Extensively used jQuery/JavaScript for creating user rich UI’s and used Razor engine for creating multiple views.

Effectively used C#.NET for coding the business logic and to develop N-tier services.

Effectively used constructor dependency injection using C#/VB.NET

Effectively coded in C#.NET using .NET 4.0/3.5 techniques like lazy loading, reflection etc.

Effectively used C#.NET to deal with exception handling using try/catch/finally statements.

Involved in designing and development of SOA services using Web Services/ WCF using C#.NET.

Used Entity framework code first for creating data base.

Creating Entity framework migration to tackle with model changes.

Effectively used LINQ to pull data from the database.

Wrote stored procedures, stored functions using SQL Server 2008 database.

Created tables, views, triggers using SQL Server 2008 database.

Created sequences using SQL Server 2008 database.

Deployed and maintained ASP.NET applications running at IIS 7.0.

Participated in Scrum activities and effectively communicated with team members.

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

Implemented test cases for Unit testing in Business, Presenter, and Data Access Layers using N-Unit.

Environment: VisualStudio2012, C#.NET, ASP.NET MVC, jQuery, JavaScript, Entity Framework, CSS, WCF, XML Web Services,IIS 7.0, AJAX, WSDL,SOAP,Agile, LINQ, .NET Framework 4.0/3.5, XML, NUNIT,SQL Server 2008, UML, TFS.

Client : Sony, Los Angeles, CA

Duration : Jul 2014 – Aug 2015

Role : .Net Developer

Project : Smart Band

Project Description: The project dealing with Shared success involved felicitations comprised of determining and calculating health condition of customers using this.. The different awards provided were summarized under reports which were presented monthly and yearly based on different criteria’s.

Responsibilities:

Involved in gathering the requirements from client and in the analysis, design & development of the project.

Provided estimates, daily & weekly status report to the client on progress of the tasks.

Develop Code using SCRUM/Agile project development methodology and participate in Sprints

Implemented data access and business logic to meet client requirement.

Operational knowledge of classic ASP programming and JAVA script programming

Followed MVC architecture and used MVC 4.0 for the application development.

Developed all the UI pages using HTML, XSL/XSLT, XHTML, DOM, CSS, JSON, JavaScript, jQuery, Ajax, Bootstrap.

Used jQuery core library functions for the logical implementation part at client side for all the applications.

Implemented and Consumed Web Services using WCF.

Created POCO data classes, which are mapped to entities that are defined in a data model.

Created DAL (Data Access Layers) to establish database connectivity and data manipulation.

Used Auto Mappper in various instances to maintain clean and non redundant code.

Used Resharper to maintain coding standards.

Used Team Foundation Server for source control.

Implemented FileNet, ActivePDF, for document repository.

Involved in enhancing already existed applications which were written in both VB.NET and C# as well.

Worked on using GIT and Tortoise GIT as version control system. Also used Visual Source Safe before moving to GIT.

Created SSIS Packages using Visual studio to move data from files to tables.

Created SSRS Reports using SQL SERVER 2008 R2 to display results for front end users based on business requirements.

Modified inherited code and SQL scripts for better results.

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

Used WCF TEST CLIENT Tool to test WCF connections to ensure smooth communication with database.

Involved in performance tuning of stored procedures for dealing with timeout issues.

Created efficient stored procedures based on business requirements and also for application related validations.

Worked on Unit test cases and performed unit testing.

Worked closely with Quality Analysts to fix bugs during Quality Assurance and User Acceptance Testing.

Environment: Visual Studio 2013, MVC 4.0/5, WCF,C#,VB.NET,Asp.net, Classic Asp,AJAX, JQuery, ADO.NET,Entity frame work, WCF, HTML 5, CSS 3, JavaScript, IIS 7.0, MS Visio, SQL Server 2012, Management Studio, Web Services,SSIS, SSRS,TFS, MS Excel.

Client : Humana, Louisville, KY

Duration : Jun 2013 - Jun 2014

Role : .Net Developer

Project : Summary of Benefit Coverage (SBC)

Project Description: Summary of Benefit Coverage (SBC) is a web application that allows the user and Brokers to create SBC which include various Medical Events, Coverage Examples. These were generated using data feed process and exported via Service.

Responsibilities:

Involved in gathering the requirements from client and in the analysis, design & development of the project.

Involved in the design and development of reports in MSSQL Server Reporting Services (SSRS).

Followed agile methodologies (scrum, extreme programming) and test driven development.

Followed MVC architecture and used MVC 4.0 for the application development.

Used Telerik AJAX controls (RadGrid, RadGrid, RadCharts, RadUpload, Collapsible Panels, RadWindow etc.) for better user interface and enhanced functionality.

Used Cascading Style Sheets (CSS 3) with HTML 5 to attain uniformity of all web pages.

Provided session level security and password authentication using Session objects and Cookies.

Created WCF Services and Client Proxy for communication between Application Server and Web Server.

Used SMTP mail class of .NET for the users to send mail with suggestions, receive any alerts, receive confirmation notifications etc..

Data binding was extensively used to bind various server controls to the data from database. List controls like repeater controls, data list controls and data grid controls was used in displaying rows of data in a customized template format.

Used LINQ to SQL with Dynamic LINQ library.

Worked on ORM Entity Framework and LINQ to SQL.

Responsible for writing SQL Queries, Stored procedures, Views and User- defined Function.

Involved in design and development of middle tier web services which encapsulate the business logic in its methods and wrote data access classes using ADO.NET and VB.NET.

Used Apache Subversion (SVN) as version controlling tool.

Involved in testing the application using N-Unit testing.

Environment: Visual Studio 2012, MVC 4.0, WCF,C#,VB.NET, AJAX, JQuery, ADO.NET Entity, WCF, HTML 5, CSS 3, JavaScript, IIS 7.0, MS Visio, SQL Server 2012, Management Studio, Web Services, SSRS,TFS, MS Excel.

Client : Saint Agnes Medical Center, Fresno, CA

Duration : May 2012 - Jun 2013

Role : .Net Developer

Project : Pharmacy Medication Application

Project Description: Pharmacy Medication Application is an enterprise-wide system which delivers the detailed information of the various products and combination of drugs that are made available to the Pharmacy Department. This application supports only intranet Environments. Using this single system we can ensure data integrity and exact information of each and every product that needs to be displayed. This helps in determining the exact information ranging from the combination of drugs, expiry of the products, various products, etc. thus eliminating the confusion to search for a particular product.

Responsibilities:

Involved in complete life cycle of n tier business application using MVC 3.0 architecture and Agile methodology.

Developed Layout views, partial views and CSS to give a consistent look and feel.

MS Visio was implemented for the UML Diagrams like Use Case Diagrams, Object Diagrams, Class Diagrams and Sequence Diagrams to represent the detailed design phase.

Created persistence layer using ORM ADO.NET entity framework.

Created and consumed reusable AJAX enabled WCF service to expose the persistence layer.

Created Html helpers for reusing in views.

Implemented client side validations using Data Annotations and JavaScript..

Created SSIS jobs for transferring files from server to another server daily and find out failed jobs in each SQL server

Developed Stored Procedures and Views to retrieve the order data, calculate expenses and thereafter displayed as a report in SSRS.

Developed Triggers to automate table level events and capture data for audit purpose.

Performed unit testing of various business modules using NUnit.

Participated with QA team in developing Test Plans and strategies for the release processes during the switch from QA to Production.

Environment: Visual Studio 2010, MVC 3.0, WCF,C#, AJAX, JQuery, ADO.NET Entity, WCF, HTML, CSS, JavaScript, IIS 7.0, MS Visio, SQL Server 2012, Management Studio, Web Services, TFS, MS Excel.

Client : Lender Processing Services, Jacksonville, FL

Duration : Oct 2010 - Apr 2012

Role : .Net Developer

Project : Empower Application

Project Description: Empower Application is an enterprise-wide loan origination system based suite of software components that addresses every aspect of critical step of the loan origination process. This application supports both internet and intranet Environments and supports large financial clients like Union Bank, Bank of America etc. Empower is a lender-hosted model, allowing you to own and manage your own customization and implementation timelines. We receive complete functionality in every Using this single system and can ensure data integrity and security to overcome compliance challenges. This single solution helps eliminate errors and the need for duplicate entry that results from multiple systems. The seamless integration of task-driven, automated services for flood, tax and appraisal create a “virtual loan” process.

Responsibilities:

Created Run-Book for the detailed process flow and covers the functionalities provided by application.

Implemented N-Tier Architecture development which involves Presentation Tier, Business Entities, Web services Tier, and Data Access Tier for LPS’s Empower application using C#,ASP.NET 3.5.

MS Visio was implemented for the UML Diagrams like Use Case Diagrams, Object Diagrams, Class Diagrams and Sequence Diagrams to represent the detailed design phase.

Worked with Business Analysts in analyzing business requirements and created functional and Technical design documents.

Developed Custom User Interfaces for Client Union Bank for processes involved in Loan Origination.

Extensive use of AJAX control toolkit for enhanced user experience.

Extensive use of Infragistics controls wrapped up in LPS Architecture for enhanced user experience.

Created WCF Services to communicate with Data Access Layer for checking User Creditability.

Use of Entity Framework as a data access layer.

Used Web User Controls for dynamic loading of the web page.

Developed Stored Procedures, functions, views and Triggers using SQL Server 2008.

Designed and developed a Database Schemes in order to work at backend using C#, SQL Server 2008.

Environment: ASP.Net 3.5, Visual Studio 2010, Ajax, Web Services, HTML, CSS, JavaScript, JQuery, C#, IIS 7.0, MS Visio, ADO.Net, SQL Server 2008, Management Studio, WCF, TFS 2010, MS Excel.

Client : Hewlett-Packard, Alpharetta, GA (Offshore)

Duration : Oct 2009 - Sep 2010

Role : .Net Programmer

Project : Smart View – Analysis Tool

Project Description: The intended user of this solution is a CEO, industry analyst, asset manager, etc. This project shows pictorial representation of the company performance across the industry. It also compares the company performance with that of its competitors. It has options to publish the graphical representations to a booklet and as well generate web reports.

Responsibilities:

Actively participated in gathering requirements, design, and implementation in MVC Architecture environment.

MS Visio was used for the UML diagrams like Use Case Diagrams, Object Diagrams, Class Diagrams and Sequence Diagrams to represent the detailed design phase.

Developed Web-forms using ASP.NET 3.5 and generated Graphical Reports by using Visifire Silverlight charting tool.

Used Silverlight, Telerik Rad Controls, ASP.NET AJAX toolkit for presentation layer.

Implemented jQuery, as well as completely custom java script to build a bleeding-edge, AJAX-driven user interface.

Created client side and server side validations using ASP.NET input validation controls and JavaScript.

Used ADO.NET to implement data access layer logic.

Extensive use of ASMX Web Services to interact with Data Access library.

Use of SQL Server Integration Services (SSIS) to import data into SQL Server 2008.

Wrote and Evaluated Stored Procedures/User Defined Functions and Optimizing queries using T-SQL.

Optimization of Queries using Temporary Table, Indexes.

Deployment of Application to Test and Production Server.

Involved in migration of our project from .NET 2.0 to .NET 3.5.

Worked on generation of Forms and Reports for user details like failure logins, user locked out history etc.

Environment: ASP.NET 3.5, Silverlight, Web Forms, ASMX Web Services, ADO.NET, XML, jQuery, WSDL, SOAP, Telerik RadControls, AJAX, MS-SQL Server 2008, Windows Server 2008, IIS 7.0, SSIS, SSRS and T-SQL (Stored Procedures).

Client : Kotak Mahindra Bank, Mumbai (India)

Duration : Sep 2007 - Sep 2009

Role : Application Developer

Project : KISSS (Kotak Integrated Sales Support System)

Project Description: Kotak Mahindra Bank conducts various marketing Campaigns for their products like Fixed Deposits, Term Deposit, and Gold, Life Insurance & Medical policies to their existing and non-existing customers. These campaigns are conducted by their Out bound and in bound Call centers at different branches all over India. KISSS is a Web application developed to support their sales staff in conducting such campaigns.

The main modules were Client Allocation, Agent’s Module, and Import/Export Module & Reports. Users of the system are given rights based on their role in the organization. The detailed information of their existing customers was fetched from a Web Service developed by their Banking Application. Information of prospect customers was imported from excel files.

Responsibilities:

Using XML Control, XSLT & dataset for displaying data.

Used XML Web Services (WSDL, and SOAP).

Parsing multi-node XML document using XPath Navigator from banking application and displaying information.

Designing and Developing the Assemblies to be deployed as DLL.

Involved in designing and developing Web forms using ASP.Net 2.0 and C#.

Developing the middle tier using C#.

Extensive use of abstract classes, interfaces, delegates and attributes.

Developed User controls for reuse in the project.

Used ADO.NET for database connectivity, executing queries & stored procedures.

Wrote Stored Procedures, Triggers, Views and queries optimization.

Troubleshooting and production support.

Environment:ASP.NET 2.0, C#, SQL Server 2005,Visual Studio 2005, ADO.NET, IIS 6.0, DTS, VSS, Win 2003

References furnished upon request

Contact this candidate