Sql Server Web Services

SUMMARY

Around * years of experience in Application Analysis, Technical Design, Development, Implementation, Performance tuning, and Configuration management in all stages of Full Software Development Life Cycle (SDLC) of Web/Windows based Applications.

Adept at building Internet, Intranet and Client Server applications using ASP.NET, C#.NET, ADO.NET, VB.NET, HTML, XML, LINQ, JavaScript, JQuery and Angular JS.

Experience in implementing Ajax interactions for partial post back and rapid web development.

Good experience in Microsoft .Net Technologies, WCF Services, Web API and Web services.

Experience in developing Windows Services to handle the business process for various modules.

Extensive experience in creating rich content Web Forms, Win Forms, Web User Controls, Server Controls.

Good knowledge of Version Control Systems like Visual Source Safe (VSS) and Team Foundation Server (TFS).

Exposure to RDBMS databases like MS SQL Server, DB2 and Oracle.

Experienced in database programming using ADO.NET objects such as SQL / OLEDB connection, Command, Data Reader, Dataset and Data Adapter.

Good knowledge of database objects and its architecture to configure databases as per the needs of the business process and the applications.

Extensive experience in developing, debugging multi-tier applications using XML, Serialization, Multithreading and Agile programming methodologies.

Experience in developing XML applications using DTD, Schema, DOM, XSLT and X Path.

Experience in building ASP.NET web pages using advanced technologies like Model View Controller (MVC) framework.

Used LINQ extensively to write data access layer to SQL Server.

Experience in database development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures, Cursors and Triggers in SQL Server 2008/2012, Oracle.

Proficient in development of secured, scalable web applications by using appropriate validation of user input and proper data access methods.

An enthusiastic and goal-oriented team player possessing excellent communication and interpersonal skills with high level of adaptability.

Always keen to learn new technologies to enhance my technical skills.

TECHNICAL SKILLS

Languages: C#, VB.Net, T-SQL, Visual Basic, C++

Databases: MS SQL Server 2008/2010/2012, Oracle, DB2

Web Technologies: Web Services, WCF, ASP.NET, WEB API, MVC, SOAP, XML, XSL, XSLT

Development Tools: Visual Studo.NET 2008/2012/2015, AJAX

Scripting Languages: JavaScript, VBScript, HTML, JQuery, JSon, Angular JS

Operating Systems: Windows XP/2000/98, UNIX and LINUX

Reporting & ETL: SSIS, SSRS

Version Control: Visual Source Safe (VSS), Team Foundation Server (TFS)

EDUCATION

Bachelor of Technology in Information Technology, JNT University, India (2005 – 2009).

PROFESSIONAL EXPERIENCE

Intense Technologies

Application Developer

Hyderabad, AP, India

Bharti Airtel/IBM Mar 13 – Jul 16

Document Management System (iDOC)

As part of the Telecom industry Airtel has to follow stringent regulatory norms for through customer documents (address proof, identity proof, etc.) verification as instances of using mobile connections for criminal activities is on the rise. Airtel also needed a faster customer documents verification process so as to decrease the risk of providing services to customers whose credentials have not been verified. An integrated work flow-based system for intelligently managing the entire Service Activation process was provided where scanning of the Customer Application Forms and Customer Identity Documents routing of the document to Audit teams for Audit and Verification, Data Entry for capturing Customer Information details, Updating of Customer Information into a centralized application was done. AirTel India have different workflows for Postpaid, Prepaid, COCP and M2M.

Responsibilities:

Development of the application according to the client needs based on the Business Requirement and Functional Requirement documents.

Involved in configuration and implementation of workflows for Postpaid, Prepaid, COCP and M2M modules.

Developed presentation layer using ASP.NET, Ajax controls and CSS, business layer using C#.Net, and data access layer using Web Services.

Developed Windows Services to handle the business process for various modules.

Involved in designing the applications with C#.Net, ASP.NET, and Visual Studio .NET 2010/2012.

Created CSS for styles on web page, and referenced them in ASP.NET pages.

Created complex Stored Procedures, Views, Triggers, and Functions for fast retrieval of data through SQL Server.

Developed many T-SQL scripts to configure modules using SQL Server 2008/2012.

Developed and consumed WCF services. Created XML Data Schema, Created Data contract, Service Contract and operation contract, defined endpoints, created proxy classes.

Utilized validation controls for server-side validation and JavaScript, JQuery for client-side validation.

Implemented Ajax interactions for partial post back and rapid web development.

Designed, implemented the Web Services for data processing using XML, WSDL, FTP and SOAP.

Coordinated with the business analysts and discussed issues in interpreting the requirements and effectively managed the finalized requirements.

Conducted and performed Unit Testing by designing test scenarios, test plans and performed inspection of test scripts.

Analyzed and developed various reports for end users as per their business rules.

Actively managed the role of Production Support to fix the application issues on time.

Involved in Code Review with the team members.

Involved in Agile/Scrum development process for Software Development Life Cycle.

Actively participated in all the Team meetings and interacted with the clients for the new enhancements.

Environment: C#.Net, ASP.NET, Ajax, WCF, IIS, Web Services, JavaScript, JQuery, TSQL, SQL Server 2008/2012, Visual Studio.NET 2010/2012, Visual Source Safe.

MTS Jan 12 – Mar 13

An integrated work flow-based system for intelligently managing the entire Service Activation process was provided where scanning of the Customer Application Forms and Customer Identity Documents routing of the document to Audit teams for Data Entry for capturing Customer Information details, Updating of Customer Information into a centralized application was done.

Responsibilities:

Requirements gathering from various application teams, Problem Analysis, Design, Development, Testing and Maintenance of the System.

Developed ASPX pages, user controls and validation controls using ASP.NET.

Used C# in Middle-Tier application to write the business logic, Wrapper Classes.

Developed database components using ADO.NET for data accessing.

Developed the application using ASP.NET pages with Master Pages, CSS, Java Script, Microsoft Ajax toolkit.

Created and used DLLs to implement business logic and to integrate the application.

Used panels to display more than one input screen in a single form, to help user navigate to any screen during data entry.

Involved in designing login dialog and the application’s main screen functions that included: Adding, modifying, updating, canceling deactivating, reactivating, transferring of accounts, and commitment application screens.

Developed UI layer for web application using ASP.NET Web forms and code behind using C#.NET.

Developed various utility classes which are used across the whole project using ASP.NET, C# and ADO.NET.

Used LINQ to write data access layer to SQL Server.

Created tools to deal with complex macro-enabled Excel files facilitating user-friendly presentation of reports and calculating commissions using C#.NET and ASP.NET.

Designed, implemented the Web Services for data processing using XML, WSDL, FTP and SOAP.

Written complex stored procedures and functions to integrate database with application layer.

Involved in Agile/Scrum development process for Software Development Life Cycle.

Environment: C#, ASP.NET, IIS, SQL Server, Web Services, Windows Services, JavaScript, JQuery, Ajax, Visual Studio .NET 2010, LINQ, Visual Source Safe.

Unidoc Oct 10 – Dec 11

UniDoc allows you to create documents, cabinets and folders to store the documents, templates. Search and retrieve information. Administer the application. Create groups, roles and users and assign permissions to them, view and edit the user profile, change password and login group, set preferences for the startup screen. Generate reports, manage subscriptions, access to reports, and build queries from database. Capture, record and monitor the actions of users and groups, send mails.

Responsibilities:

Involved in various phases of the Software Development Life Cycle (SDLC) in Requirement Gathering, Conceptual Design, Analysis, Detail Design, Development, System and User Acceptance Testing.

Designed and developed the user interface web pages using ASP.NET, C#.NET and AJAX.

Developed ASPX pages, user controls and validation controls using ASP.Net.

Implemented the SQL Server database connectivity using ADO.NET technology.

Used Java Script and JQuery for client side validation.

Designed and implemented Data access layer using ADO.NET to connect and retrieve or manipulate data in database system.

Involved in migration of database and its database objects from DB2 to SQL Server as part of business migration.

Developed and optimized database structures, T-SQL, stored procedures, views, triggers and user-defined function (UDF) and creating tables, views, indexes and relations.

Coded Business Objects that provided business logic to the ASP.NET web pages.

Used Asynchronous JavaScript and XML (AJAX) techniques to improve application performance.

Extensively used both Dataset and Data Reader to data retrieval from database and used ASP.Net controls like Grid View, List View to the display the data as per business.

Developed XML Web Services for implementing functionality.

Used Visual Source Safe as Source Control System.

Extensively used Web Services to provide data to the Web application.

Developed Windows Services to handle the business process for various modules.

Interacted with the clients for the addition of new enhancements.

Environment: C#, ASP.NET, Ajax, IIS, SQL Server, DB2, Web Services, Windows Services, Visual Studio.NET 2008, VSS.

Contact this candidate