Sql Server Web Services

Mobile: 918-***-**** Venu Kancharla

Email: *******@*******.***

Synopsis: Masters in Software Development and Information Technology; Professional around 8 + years of IT experience in Analysis, Design, Development, Implementation and Testing of Web and Window based applications. Complete life cycle (SDLC) experience of a product involved in System Analysis, Architecture, Technical design, development, testing, deployment & support medium to large scale business applications using Agile Scrum and iterative development methodologies.

Expertise in…

Web based application development/Maintenance using ASP.NET 4.0, 3.5, 3.0 & 2.0,C#, VB.NET, ADO.NET, MVC, JQuery, AJAX,VB, Java Script, ASP,VB,XML, HTML, SQL Server, SSIS,SSRS and Oracle.

Having good knowledge on ITIL process. Extensively worked with Incident process, Change Management and Release management.

Having rich domain Knowledge in Oil Gas and Energy industry and as well as hospitality

Having Rich Knowledge in designing Hotel reservation portals.

Experience in Multi-tier Architecture development and Telerik Tools.

. NET: Expertise in VS.NET 2012/ 2008/2005/2000 and Extensive Experience in development of cutting - edge Enterprise Application in ASP.NET, Windows Forms, and Windows Services since 2003

Experience UML, Web Services, SOA, XML, XSD, XSLT, XPATH and Design Patterns like Singleton pattern and MVC etc.

Expertise in developing applications with Legacy ASP/VB

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

Expertise in converting Applications From Legacy ASP/ASP.Net 1.1 to .Net 4.0

Having Good knowledge with Integrating .net code with NAESB EDI

Converted Legacy Main Frame scheduled jobs to .net windows service jobs.

Worked with SFTP, Connecting SFTP server using .net

Expertise in integrating payment gateway like PayPal

Expertise in Database design, development in Oracle (11g/10g) and SQL Server 2010, 2008/2005 which includes writing complex store procedures/packages, triggers, views, jobs.

Embraced Agile Scrum methodology into daily practice. Produced top quality and easy maintainable codes.

Experience UML, Web Services, WCF Services, SOA, XML, XSD, XSLT, XPATH and Design Patterns like Singleton pattern and MVC etc.

Having Good Knowledge in Service now and BMC remedy ticketing tool management

Expert in designing the solutions and preparing the design documents using UML and Visio

Strong analytical, problem solving skills, self-starter with a track record of accomplishments

Having 3 yrs. of experience As a Team Lead for developing web applications

Communication, coordination, interpersonal & leadership skills with business-centered mind-set to positively contribute to overall organizational performance

Worked on Transformation of Legacy Application to Service based Applications

Development and Unit Testing: Developing the product as per customer’s requirement. Performing Unit test on the developed code

Performing Code review and Analyzing the root cause of the issues and fixing in Issue Management

Having experience in developing applications for Ecommerce applications domains

Expertise in end to end Product Development.

Expertise in Test-driven development (TDD) methodology using N-UNIT Testing.

Software Development Skills

Languages

C# 2.0/3.0/3.5/4.0, VB.NET, VB, C and C++

Web Technologies

Visual Studio 2005,2008,2010,2012, WCF, ASP.NET, ASP,MVC, JQuery, JavaScript, HTML, DHTML, CSS, XML, AJAX,Web Services, SOAP and ADO.NET

Web Servers

IIS6.0, IIS 7.0/,Apache

Databases

MS SQL Server 2005/ 2008, 2010 PLSQL, Oracle 11g/10g/9i and MS Access 2000

Operating Systems

Windows 9x/XP/NT/2000/2003/Windos7 & Windows8 Servers/Unix/Linux

Version Controls

Visual Source Safe, Visual team foundation server and SVN

Reporting Tools

Crystal Reports, Active Reports

External Vendor Tools Support

OMNIRIM, Honeywell Prowatch, Honeywell Rapid Eye, Enterprise Survey Tool, Cardiolog, Easy Lobby.

Education:

Master in Computer Applications (M.C.A) 2007 From Osmania University, India

Bachelor of Science (B.sc) 2004 From Osmania University, India

Career History

#1 Williams Internal and External Web applications: (June 2013 to Till Date) Client: Williams–Tulsa, OK

Williams Partners L.P., is an energy infrastructure company focused on connecting North America's significant hydrocarbon resource plays to growing markets for natural gas, natural gas liquids (NGLs) and olefins. William’s operations span from the deep water Gulf of Mexico to the Canadian oil sands. As a part of Williams I was responsible for developing internal websites and Legal websites using .Net technologies

Responsibilities Handling:

Validate Business requirements and initiated process

Actively involved in developing/Maintaining web applications using ASP.NET, C#, ADO.NET and Visual Studio.Net 2010.

Defined and Designed data base in Oracle 11g

Created Tables and Stored Procedures, Sequences and Functions in Oracle 11g to communicate with application

Created Data access layer as a Commute layer between application and database

Used MVC Razor view for dynamic rendering

Implemented UI validations using Java Script, Ajax calls and Models

Authentication validated against Active Directory users

Used CSS to implement various styles for Grid View and all other controls

Designed some of the UI screens for this module using HTML, JavaScript

Used JQuery calendar, Alert and Model windows for Workflow creation.

Created classes for the Caching and Helper class for security mechanism

Developed various partial views to display data in web forms.

Implemented Session time out

Used Enterprise library 5.0 for exception handling

Take ownership of technical solution from the design and architecture through development

Performed unit testing and bug fixing

Used 3-tier architecture to implement all .Net applications.

Used TFS as a Code Repository and followed source code handling practices like Check-In daily basis

Used ADO.NET classes extensively. Also used datasets for binding data to UI controls

Used Resource files to implement multilingual feature

Involved in Code Review to improve application performance.

Deployed application in IIS 7.0 in different environments like QA and Production

Environment: ASP.NET 4.0 with C#.NET, JQuery, Razor view, Enterprise Library 5.0, Ajax, CSS, Web Forms, GUI, JavaScript, XML, Visual Studio 2012, IIS 7.0 and Oracle 11 g.

#2 Treasury Bank Reports: Duration: (Dec 2012 to May 2013) Client:-Williams-Tulsa, Ok

The application used by Finance people to view bank balance information -up to 10 business days. This application gets the bank reports through a batch job maintained by user and loads data into respective bank folders which have current and Archive folders.

Responsibilities Handling:

Validate Business requirements and initiate processes

Defined and Designed data base in Oracle 11g

Created Tables and Stored Procedures, Sequences and Functions in Oracle 11g to communicate with application

Used ODP .Net as a provider for Oracle

Used Entity Framework 5 for database communication

Created package to handle multiple transactions in oracle

Implemented UI validations using Java Script, Ajax calls and Models

Authentication validated against Active Directory users

Used CSS to implement various styles for Grid View and all other controls

Designed UI screens for this module using HTML, JavaScript

Used open source JavaScript calendar for displaying employee vacation dates.

Created classes for the data mapping from the data base tables

Implemented Data Access class to communicate with database

Developed various user controls to display data in web forms like Calendar Control.

Implemented Session time out

Used Enterprise library 5.0 for exception handling

Defined and Implemented user controls

Take ownership of technical solution from the design and architecture through development

Performed unit testing and bug fixing

Used 3-tier architecture to implement Treasury Bank application.

Used VSS open source as a Code Repository and followed source code handling practices like Check-In daily basis

Used ADO.NET classes extensively. Also used datasets for binding data to UI controls

Used Resource files to implement multilingual feature

Involved in Code Review to improve application performance.

Deployed application in IIS 7.0 in different environments like QA and Production

Environment: NET Framework 3.0/3.5, C#, ASP.NET 3.0/3.5, WPF, WCF, AJAX, LINQ, Visual Studio 2008, SQL Server 2005, IIS 6.0, XML, XAML, Microsoft Expression Blend..

#3 BP Mainframe Exit Duration (Oct 2011 to Nov2012

The BP Mainframe, also known as the Amoco mainframe is an End-of-Service Life technology platform which supports critical US FVC applications, interfaces and data. It is no longer feasible to support transaction processing especially for core scheduling, master data, terminal inventory processes US-R&M has initiated a project to assess the mainframe based applications (OPDS2, SCDB, TAS-C and Fuel Settlement) and recommend the migration methodology to be applied to move these application processes out of mainframe. It also includes the migration of the application, testing and fixing the interfaces with 10 satellite applications and archival of the mainframe data

Roles and responsibilities:

Defined process for approval mechanism.

Developed Windows services and Task Schedulers in .net code

Implemented well-structured 3-Tier Asp.Net web application using Data access, Business logic and Presentation layers to track all the Windows services and Jobs which are converted from Main frame.

Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables

Designed and developed GUI with web forms using ASP.NET Controls, AJAX, JQuery and JavaScript.

Made use of Microsoft AJAX extensions such as script manager and update panel to make an asynchronous call to retrieve data and update client-side HTML fields for rich user experience.

Assisted in physical and logical database design.

Designed SQL database schema, stored procedures, user defined functions, views and triggers.

Uploaded the reusable components which will be used by other team members.

Implemented user reentry using user session and application page objects to implement deferred session state which was built to store and retrieve session information of user.

Developed Custom user, server and validation controls using C#.

Used .Net server controls, web user controls, data grid control, form validation control, custom control.

Used rich custom web controls to provide for better user experience.

Used grid view control, details view Control, form view Control, Repeater and data list control to display and enable data manipulation at the interface level.

Efficiently used object oriented programming to achieve the functionality for the application.

Prepared the unit test specifications and test cases.

Created prototypes for client engagements.

Used VSS for Code Repository and followed source code handling practices like Check-In and Check-Out on daily basis

Involved in Code Review to improve application performance.

Prepared weekly status reports /monthly status reports code review.

Resolved performance issues, fine-tuned queries, indexes and stored procedures.

Designed, coded, tested applications identified system deficiencies and recommended solutions.

Environment :-.NET Framework 2.0, C#, ASP.NET 2.0, Visual Studio 2008, SQL Server 2005, IIS 6.0, XML, .Net Windows Services

#4 BP Shipping Duration (Aug 2011 to Oct2011) Client: BP, Houston, Texas

This BP- TAS-LID is a web based tool used by the users to register for a user id and password for Terminal Automation System. There are two level of approvals required before a user id gets registered on TAS. The user and supervisor (provided by the user while registering for id) will be asked to provide approvals. Then DSST Team will then approve access to the users for the Terminal Automation System (TAS). If the DSST team rejects a request then even the supervisor will not be able to see it under his/ her pending approvals. The user also has an option in this website to see where his request currently stands. Users can also change their profile once registered successfully.

Roles and responsibilities:

Defined the requirements and initiated processes

Prepared technical designs, Data Model and service specs

Analyzed the requirements with Business Analyst and end-users.

Worked as a Team Lead with 4 members of team.

Responsible for the Solution maintenance, Standard and Quality.

Developed modules of the application in ASP.NET and involved in writing C#.NET classes.

Made use of Microsoft AJAX extensions such as script manager and update panel to make an asynchronous call to retrieve data and update client-side HTML fields for rich user experience.

Created Windows services using C#.net

Worked with SFTP, Connecting SFTP server using .net

Implemented Web pages as part of GUI Development and validation Checking.

Extensively worked on ADO.NET using Data Adapter, Data Readers and Data Sets.

C# ADO.Net is used to access data from data access layer and Sql transactions.

Used Java Script for client side validations and server side validations.

Involved in writing database scripts, PL/SQL queries, Stored Procedures, triggers and testing them.

Used CSS to implement various styles.

Web.Config file is used to have own setting for the application by writing database connection string and user authentication.

Involved in Unit testing of the application according to the Use Cases written.

Used Enterprise Library to implement standard database functionality.

Environment :-.NET Framework 2.0, C#, ASP.NET 2.0, Visual Studio 2008, SQL Server 2005, IIS 6.0, XML, .Net Windows Services, JavaScript

#5 Altair Electronics (Nov 2010 to July 2011) Clients: Altair Electronics. Hyd, India

Altair Power saver (AEPL-PS) will prove beneficial to companies and organizations with high energy needs. This product resolves problems of voltage fluctuations, by eliminating the harmonics, Surges and distortion and also through dimming technology, thereby eliminating wastage and heat losses in the device. AEPL power savers have the Advanced Integrated technology to provide quality and optimum power to various loads to save power. Once quality power is supplied to electrical gadgets, they work to optimum efficiency with enhanced life span. In the absence of such an arrangement, the excess power would be wasted and/or generate heat. The AEPL offering the more Advanced Technology with Remote Monitoring the Stabilizer through GPRS Technology to log the data and Continuously observing the Stabilizer functionality and Performance from the web

Responsibilities Handled:

Main contact for the Business Users for development of new requirements proposed as a part of the application development

Analyzed, designed and developed this web application.

Developed several reusable components using C#.NET and used some validation controls.

Prepared test cases for applications and performed Unit testing for applications.

Followed 3-Tier Architecture development.

Used Resource files to implement multilingual feature

Involved in writing database scripts like SQL queries, Stored Procedures and functions.

Used ADO.NET classes extensively. Also used datasets for binding data to UI controls.

Responsible for Coding and Bug fixing.

Implemented Java Script for Client Side Validations.

Environment: NET Framework 2.0, C#, HTML, CSS, JQuery, DHTML, Visual Studio 2008, Web Services,, MS Visual SourceSafe, XML, XHTML, XSLT, MS VISIO(UML),, SQL Server Integration Services 2008, SQL Server Reporting Services 2008.

#6 All Hotel Deals (Nov 2008 to Sep 2010) Clients: AllhotelDeals. Hyd, India

AllHotelDeals (http://www.allhoteldeals.net/) a complete online accommodation booking, which offers direct and easy access to a range of hotels. It also enables organizations to endorse timely and informed customer interactions, acquiring vital states on customer needs & trends for launching new schemes, increase customer satisfaction, and build strong and lasting relationships it provides Customers to view and search hotels all over the world with an easy and user friendly interface and can make hotel rooms reservation with a few clicks. It provides Hotelier (Hotel Owner) to register his hotel with AHD and provides separate environment to manage his business. It has features to generate Invoices, Automatic Emails to Vendors and Customers.

Responsibilities Handled:

Involved in Analysis, designing and development of UI & ASP.Net pages (Web Forms) after interacting with users for requirements.

Used .NET AJAX controls to dynamically render the content on web pages using C#.

Involved in development of UI (User Interface) Pages using the HTML, Master Pages & ASP.NET.

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

Designed web pages for AHD project for enrollment process, registration, login, collecting payment information, FAQ’s.

Implemented Payment Gateway for hotel bookings

Implemented Data access layer (DAL) using SQL server 2005 by creating Functions, Triggers and Store Procedures in PL/SQL

Utilized Agoda Web services to Pull the Hotel information data for every Hour

Created Unit test cases for the web pages to test the functionality that has been created for the classes and was able to debug them.

Gathered user requirements by interacting with users and prepared Software Requirements Specification (SRS) and other supporting documents.

Involved in deploying the project and testing it on the test servers.

Environment: NET Framework 2.0, C#, HTML, CSS, JQuery, DHTML, Visual Studio 2008, Web Services,, MS Visual SourceSafe, XML, XHTML, XSLT, MS VISIO(UML),, SQL Server Integration Services 2008, SQL Server Reporting Services 2008.

#7 Splendid Rooms (March 2008 to Oct 2008) Client: Gold Crest. Hyd, India

Splendid Rooms a complete online accommodation booking, which offers direct and easy access to a range of hotels. It also enables organizations to endorse timely and informed customer interactions, acquiring vital states on customer needs & trends for launching new schemes, increase customer satisfaction, and build strong and lasting relationships it provides Customers to view and search hotels all over the world with an easy and user friendly interface and can make hotel rooms reservation with a few clicks. It provides Hotelier (Hotel Owner) to register his hotel with SR and provides separate environment to manage his business. It has features to generate Invoices, Automatic Emails to Vendors and Customers.

Responsibilities Handled:

Involved in Analysis, designing and development of UI & ASP.Net pages (Web Forms) after interacting with users for requirements.

Used .NET AJAX controls to dynamically render the content on web pages using C#.

Involved in development of UI (User Interface) Pages using the HTML, Master Pages & ASP.NET.

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

Designed web pages for AHD project for enrollment process, registration, login, collecting payment information, FAQ’s.

Implemented Payment Gateway for hotel bookings

Implemented Data access layer (DAL) using SQL server 2005 by creating Functions, Triggers and Store Procedures in PL/SQL

Utilized Agoda Web services to Pull the Hotel information data for every Hour

Created Unit test cases for the web pages to test the functionality that has been created for the classes and was able to debug them.

Gathered user requirements by interacting with users and prepared Software Requirements Specification (SRS) and other supporting documents.

Involved in deploying the project and testing it on the test servers.

Environment: NET Framework 2.0, C#, HTML, CSS, JQuery, DHTML, Visual Studio 2008, Web Services,, MS Visual SourceSafe, XML, XHTML, XSLT, MS VISIO(UML),, SQL Server Integration Services 2008, SQL Server Reporting Services 2008.

#8 Info Indya (June 2007 to Feb 2008) Client: Gold Crest. Hyd, India

Info India' is one stop information resource about the incredible Indian services in Australia. This site is built to help numerous Indians residing in various states of Australia. It provide best search results about each services, like Indian Doctors, Restaurants, places of worship, groceries shop, tax agents, Indian

Associations etc. throughout Australia. With that 'Info Indya' also provides various other useful resources that will

Help Indian students to pursue internships and to gain knowledge about variety of discounts they are eligible for. This site also offers 'Buy/Sell' various items, search or advertise the accommodation, Matrimonial services that may help other Indians in different states of Australia. These sites not only offers best search results about services but also facilitate to Indians with various Entertainment elements like, upcoming events, now showing Indian movies, Indian TV guide and Radio details. Above all these this site also gives our Indians about the most recent Indian currency conversion rate, Today and tomorrow weather report of different states in Australia. Our efforts are made to facilitate all Indians, but your feedback or comments are most valuable for betterment of this site that is intended to help every Indian across Australia.

Responsibilities Handled:

Involved in Requirements Collection, Design, Analysis, Development and Customization of the Application Care plus.

Designed and implemented application using .NET Framework 2.0

Involved in development of UI (User Interface) Pages using the HTML, Master Pages & ASP.NET.

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

Developed Front End using ASP.Net Web application & AJAX and Code behind files using C#. Net.

Developed the User controls and Custom controls to support the Front-end of the application.

Developed Functional & Data Access Classes for all Web user Controls.

Implemented input validation using the ASP.NET Input Validation Controls.

Developed Java script code for client side validations.

Extensively used AJAX Control tool kit and AJAX libraries for providing light weight AJAX requests

Created Cascading style sheets (CSS) to attain uniformity through all pages

Used ADO.net extensively for data retrieving, querying, storage, manipulation and for achieving disconnected database connectivity.

Developed stored procedures and triggers in SQL Server 2005.

Developed Web Service for retrieving product data (based on XML, WSDL, and SOAP)

Created Service Oriented Architecture SOA for both Windows forms and Web forms applications for linking business and resources on demand to achieve the desired results for service consumers.

Regular production support of the application. Interact with end users as part of support.

Worked with User controls, Web controls, List controls, Wizard controls, Master Pages, Data controls in ASP.NET for the front-end forms.

Involved in Unit testing and Integration testing.

Generated reports using SSRS

Assisted in quality assurance measures such as code reviews, test case creation and unit testing for different modules

Environment: -ASP.NET 2.0, C#, ADO.NET, HTML, CSS, JavaScript, DHTML, Visual Studio 2005, SQL Server 2005, T-SQL, IIS, Web Services, SOAP, WSDL, XML, AJAX, Silver Light 2.0, MS Visual SourceSafe, .NET Framework 2.0, XML, XHTML, XSLT, MS VISIO(UML).

Contact this candidate