Sql Server Web Services

Vamshi Avadhanula ******.**********@*****.***

240-***-**** LinkedIn :*************@*****.***

Professional Summary:

•Over ten years of professional experience as an application developer and web programmer.

•Over ten years of experience in .NET Framework, Corrillian Framework, Visual Studio.NET using C#. Net, Java, VB.NET, ASP.NET, Microsoft SharePoint, VSTO using MS Office, WinForms, Oracle Database Server and MS SQL Server.

•Extensive experience in WebAPI.

•Extensive experience in .NET Framework 3.5/4.0/4.5.1 and Visual Studio 2008/2010/2013/2015.

•Extensive experience in Microsoft SharePoint Services for creating and maintaining organizational web sites.

•Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirement.

•Developed web applications using ASP.NET MVC pattern.

•Implemented projects with Agile, Waterfall Model and Test Driven Software Development Life Cycles.

• Experience in development of Financial, Wealth Management, Banking, and Medical Imaging areas.

•Experience in hosting and consuming web services, WCF and SOA services.

•Developed services using ASP.NET Web API.

•Securing data privacy and authenticate using secured socket layer [SSL].

•Extensive experience with Web based, Client-Server and N-tier Architectures.

•Developed applications using Model View Controller, Factory, Singleton and Iterator patterns.

•Expertise with Object Oriented Design and Modeling based on UML using Microsoft Visio.

•Experience on .NET Platform Technologies in Web Forms using ASP.NET, ADO.NET, C#, VB.NET, Web Services, WCF, WPF, XAML, XML and SOAP.

•Experience in developing applications by using .NET Framework features such as generics, delegates, serialization, interfaces and collections.

•Expertise in debugging in Visual Studio, reviewing Logs and Event Viewer to track down defects in the applications. Performed Smoke testing, Performance Testing, Unit Testing of the applications.

•Extensive experience in IIS for setting up websites, creating virtual directories, creating/modifying shared locations, manipulating access restrictions for users through IIS.

•Extensive experience in XML, XSD, XSL, XSLT, CSS and DOM.

•Extensive experience in multi-threading and parallel programming.

•Expertise in database design and database programming (Stored procedures, Triggers, Packages) using Oracle Database Server 10g and SQL Server 2005/2008/2014.

•Self-motivated with ability to work in a team environment.

•Good communication and Inter-personal skills.

Education & Certifications:

• Masters in Computer Science, Alabama Agricultural & Mechanical University, Alabama, USA. (July 2007)

• Bachelor of Technology (Computer Science and Engineering), JNTU, India (June 2002)

Technical Summary:

Operating Systems

Windows 2003/2000/NT/98/XP/Vista/7, Unix

.Net Technologies

WinForms, Web Services, C#, VB.NET, ADO.NET, ASP.NET, WCF, WPF, LINQ

Internet & Middleware Technologies

.NET Web Services, .NET Remoting, SharePoint, ASP.NET, ActiveX, Microsoft Application Blocks, Flash, VB Script, HTML, DHTML, XML, XSLT, XSD, CSS, JSON, AJAX, JavaScript, WSDL.

Databases

MS SQL Server 2000/2005/2008,Oracle 10g Database Server, MS-Access 2000/2003

Modeling

UML

Tools

Visual Studio 2005/2008/2010, Crystal Reports 8/8.5, Microsoft Visio 2003, Team Foundation Server (VSTS 2008), Toad for Oracle, SQL Developer, MS Office, Microsoft SharePoint, CodeSmith, HttpAnalyzer, Beyond Compare, Nant, Nunit, FxCop, Log 4 NET, Cruise Control, SSRS, WSDL.exe

Web Servers

IIS 6.0, IIS 7.0.

Source Control

Team Foundation Server, Tortoise SVN, Dynamsoft,

Architectural Patterns

MVP (CABUI), SCSF, MVC

Languages

C#, VB.NET, C++, Java, ASP

Employment History:

Morgan Stanley, NYC August 2017 - Till Date

Principal Consultant

Project # 1 : Load Model FI VAR PL Script

The purpose of the PL script is to load the top holdings from account table to the MODEL_FI_VAR table.

•Design methods to calculate market notion and million notion.

•Design methods to delete records from brs_gaa_output and model_fi_var tables.

•Design methods to insert records into brs_gaa_output table and model_fi_var tables.

•Extensively worked on PL\SQL.

Environment: Unix, SQL, Sybase,Visual Studio 2010, UML, Microsoft Visio, Windows 2008 Server, and Web Services.

Project # 2 : Proxy Asset Report

The purpose of the Proxy Asset Report is to generate the month end excel report values based on account table.

•Design the query to load data into proxy asset tables.

•Design the excel template to load the data specific format of excel tables.

•Design the command file to run the program to load the data into excel report using the query file and excel template.

Environment: C#, DynamSoft, IIS7, Sybase Enterprise Server, Visual Studio 2010, UML, Microsoft Visio, Windows 2008 Server, and Web Services.

Project # 3: CTNIG2 Application

CTNIG2 is a web-based application used financial analyst to evaluate and study financial data of portfolio holdings and securities. There is an Admin, Uploader and Survey mode in this application. This application is implemented using Asp.net MVC, WebAPI, C#, Javascript and ASP.Net Ajax.

•Review and analyze the business criteria in CTNIG2 application.

•Followed the Water Fall model of Software Development Life Cycle.

•Used ADO.NET and LINQ to integrate the data from SQL Server database to the User Interface.

•Worked on Polyp module, Control Panel and Survey modules.

•Developed services using WebAPI.

•Control Panel module has Survey Status, Survey Mode, Manage Users sections.

•Extensively used jQuery on client side.

•Developed User Interface and middle-tier modules using ASP.NET, C#, SQL Server, MS Office.

•Developed web services using .NET Framework, C#.

•Communicated with Product Managers while developing modules and in resolving production issues related to CTNIG2 application.

•Extensively worked on Oracle database server 11g for creating/altering tables, writing stored procedures & functions, and setting up triggers.

•Interacted with QA team, Product Management team and Business Users for reviewing business criteria and resolving production related issues.

•Performed N-Unit testing after pieces of functionality are developed.

•Extensively worked on PL/SQL..

•Extensively worked on angular JS.

Environment: ASP.NET MVC, C#, Microsoft SharePoint, Java Script, jQuery, AJAX,, DynamSoft, IIS7, MS SQL Server Management Studio 2014, Visual Studio 2010, UML, Microsoft Visio, Windows 2008 Server, and Web Services.

OLYMPUS CORPORATION OF AMERICA INC PA March 2011 – August 2017

Sr. Programmer Analyst

Project # 1 # NBI Study Application

NBI Study application is used by doctors and fellows to upload image sets and review NBI and White light images.

This application is used to conduct survey by surveyors which is useful for research purpose. This is a web application developed using ASP.NET MVC, WebAPI, C# and SQL Server 2014 as the database.

•Review and analyze the business criteria in NBI study application.

•Followed the Water Fall model of Software Development Life Cycle.

•Developed and consumed Web API services.

•Used ADO.NET and LINQ to integrate the data from SQL Server database to the User Interface.

•Worked on Patient module, Control Panel and Survey modules.

•Control Panel module has Survey Status, Survey Mode, Manage Users and Manage Image Sets sections.

•Developed asynchronous functionality using jQuery.

•Developed User Interface and middle-tier modules using ASP.NET, C#, SQL Server, MS Office.

•Developed web services using .NET Framework, C#.

•Worked with Product Managers while developing modules and in resolving production issues related to CTNIG2 application.

•Extensively worked on SQL Server 2008/2014 database for creating/altering tables, writing stored procedures & functions, and setting up triggers.

•Interacted with QA team, Product Management team and Business Users for reviewing business criteria and resolving production related issues.

•Performed N-Unit testing after pieces of functionality are developed.

•Extensively worked on PL\SQL.

•Extensively worked on angular JS.

Environment: ASP.NET MVC, C#, Microsoft SharePoint, Oracle Database server 11g, Toad for Oracle, jQuery, Java Script, AJAX,, DynamSoft, IIS7, MS SQL Server Management Studio 2014, Visual Studio 2010, UML, Microsoft Visio, Windows 2008 Server, and Web Services.

Project 2 # Compliance Report & Investigation Tracker (CRIT)

Compliance Report & Investigation Tracker is web based application developed using ASP.NET web forms. This application is used by Compliance Department to create reports and carry out investigations of any compliance violations by the employees. This application has Reports & Investigations section and Investigation workflow.

Investigation workflow has Qualification, Disposition, Remediation and Summary/Comments sections. A Report would be converted to an Investigation if there is any compliance violation. If there is no compliance violation, the report will be closed. This application is developed using C# and SQL Server 2014 as backend.

•Review and analyze the business criteria in CRIT application.

•Followed the Water Fall model of Software Development Life Cycle.

•Used ADO.NET and LINQ to integrate the data from SQL Server database to the User Interface.

•Worked on Report an Investigation modules.

•Investigation module has Qualification, Disposition, Remediation and Summary-Comments sections.

•Developed User Interface and middle-tier modules using ASP.NET, C#, SQL Server, MS Office.

•Developed web services using .NET Framework, C#.

•Extensively used ASP.NET AJAX for implementing upload, comment and auto complete functionalities.

•Worked with Investigation Managers while developing modules and in resolving production issues related to CRIT application.

•Extensively worked on Oracle database server 11g for creating/altering tables, writing stored procedures & functions, and setting up triggers.

•Interacted with QA team, Product Management team and Business Users for reviewing business criteria and resolving production related issues.

•Performed N-Unit testing after pieces of functionality are developed.

•Extensively worked on PL\SQL.

•Extensively worked on angular JS.

Environment: ASP.NET, C#, Microsoft SharePoint, Java Script, Oracle Database Server 11g, AJAX,ASP.NET AJAX, DynamSoft, IIS7, MS SQL Server Management Studio 2014, Visual Studio 2010, UML, Microsoft Visio, Windows 2008 Server, and Web Services.

Project # 3: Olympus America/Ozone Project:

Olympus America is a web-based e-Commerce application that has Cameras & Audio module, Medical and Surgical module, Life Science & Imaging Systems module and Industrial Solutions module. This application deals with sales, marketing, and support and product registration of various products developed by Olympus. This application is developed using ASP.NET, C#, VB.NET, ASP, VBScript and AJAX.

Ozone is a web-based application with Corporate, Resources and Olympus Store modules developed using ASP.NET, C#, VB.NET, Java, UNIX, SharePoint, MS Office, ASP and VBScript. Ozone application primarily used for Corporate and Resource Management. Olympus Store products are exclusively sold to Olympus Employees at discounted prices.

Responsibilities:

•Review and analyze the business criteria in IBS Tracker application.

•Followed the Water Fall model of Software Development Life Cycle.

•Integrated data from the SQL Server database with the User Interface using .NET Web Services (SOA Architecture) such as SalesRepLookup, EmployeeInfoService and ProductDetailsService.

•Worked on Product Registration, Endosite Consulting module, Service Solutions module, Physical Education Module

•Worked on WCF services to integrate product/employee data from the remote host in Product Registration, Resource Management section.

•Developed User Interface and middle-tier modules using ASP.NET, C#, VB.NET, Java, Unix, SQL Server, Oracle 10g Database Server, MS Office.

•Extensively used jQuery for asynchronous functionalities.

•Developed web services using .NET Framework, C# and VB.NET.

•Communicated with Business Analysts and Product Managers while developing modules and in resolving production issues related to Olympus America and Ozone applications.

•Extensively worked on Oracle database server 11g for creating/altering tables, writing stored procedures & functions, and setting up triggers.

•Interacted with QA team, Product Management team and Business Users for reviewing business criteria and resolving production related issues.

•Developed applications using Model-View-Controller pattern.

•Extensively worked on ASP, VBScript, JavaScript and AJAX for developing various web forms and asynchronous business functionalities.

•Performed N-Unit testing after pieces of functionality are developed.

•Extensively worked on PL\SQL..

•Extensively worked on angular JS.

Environment: ASP.NET, C#, VB.NET, ASP, Java, Microsoft SharePoint, Oracle Database Server 11g, Toad for Oracle, UNIX, MS Office, VB Script, Java Script, AJAX, WCF, VSS, IIS6, MS SQL Server Management Studio 2008, Visual Studio 2010, Oracle Database Server, ORM, UML, Microsoft Visio, Windows 2003 Server, Unix and Web Services.

Standard & Poor’s NY

Sr Developer

Project # 1 : Arrow Global Project: October 2010 –March 2011

Arrow Global is WinForms based application to capture, store, analyze, forecast and report on Financial, Operating,

Segmented and Econometric data. Arrow Global also helps to standardize the data, ratios, output reports, criteria and process for determining ratings and monitoring credit worthiness. The application uses Smart Client Software Factory Pattern (SCSF) and SOA architecture with UI developed in C#. Java web services are used to integrate data from database with the User Interface.

Responsibilities:

•Reviewing the business criteria in Version One application (which is used for Sprint Planning & Tracking).

•Working on user stories, tasks and epics using Agile Scrum methodology of SDLC.

•Integrated data from the Oracle database with the User Interface using Java Web Services (SOA Architecture) such as EntifyInfoService, PortfolioService and LinxMetaDataService.

•Worked on Historical Template, Forecasting Template, Publishing Package and Period Manager Functionality in Arrow Global application.

•Integrated Office tools with the .NET application using VSTO.

•Integrated data from datasets to excel sheet using VSTO.

•Worked on language parser - ANTLR to add new syntax to support new database variables.

•Created design document, requirement analysis and development in C# to integrate new database with minimum changes.

•Integrated new WCF services to Arrow Global which gives conversion between Mnemonics and Data Elements.

•Developed web services using Java.

•Developed and maintained SharePoint website portal. The website portal is used for maintaining knowledge base within the organization.

•Communicated with Financial Analysts to resolve production issues related to Historical Template, Committee Package and Publishing Package in Arrow Global application.

•Investigated and resolved production issues related to Java Web Services and missing data points (such as entity id, vendor data, period end date etc.,) in Oracle Database.

•Interacted with various teams including Product Management team for clarifying business criteria and resolving production issues.

•Extensively worked on Oracle database using Toad of Oracle.

•Worked on complex queries in Oracle database to retrieve information related to entities (such as Financial Institutions, Insurance Companies, BICRA entities).

•Designed and developed Input Template and Committee Package for BICRA (Banking Industry Credit Risk Assessment) entities.

•Designed and developed Arrow Basic, a web-based application.

•Developed applications using Model-View-Controller pattern and Model-View-Presenter pattern.

•Performed N-Unit testing after pieces of functionality are developed.

•Using Microsoft Enterprise Library for Exception, Cache, Smart Client implementation, etc.

Environment: ASP.NET, C#, WinForms, Java Script, WCF, VSS, IIS6, MS SQL Server Management Studio 2005, Oracle 10g Database Server, Toad for Oracle, Oracle SQL Developer, ORM, Tortoise CVS, UML, flash, Microsoft Visio, Microsoft Office, Microsoft SharePoint, UNIX, Windows 2000 Server, Unix and Web Services.

Thomson Reuters July 2009 – September 2010

Sr. Developer

Project # 1: ThomsonOne Project July 2009 – September 2010

Project # I: ThomsonOne Wealth Management Application: This application consists of modules such as Contact Profiler, Portfolio Manager, Performance Reporting, Allocation Tool and Financial Planner which are used by the Financial Advisors.

Responsibilities:

•Reviewing User Requirement Specification documents, Wireframes and Copy Documents

•Extensively worked on Agile Scrum methodology for faster development, during the Software Development Life Cycle.

•Designed Use Case Diagrams, Class Diagrams and Activity diagrams using Microsoft Visio.

•Developed ThomsonOne application using Model-View-Controller pattern by separating concerns.

•Developed Performance Reporting, Allocation Tool, Contact Profiler and Portfolio Manager using C# and ASP.NET.

•Developed, configured and consumed ProfileInformationService, HouseHoldAccountService, NetworthReportService WCF services for retrieving/updating data from the remote server.

•Transformed XML using XSLT for generating Client Review and Networth Reports in PDF format.

•Developed and consumed Web Services using XML/SOAP for retrieving user/financial advisor information from remote institution.

•Retrieved/updated data related to positions, securities, account of the end financial users.

•Communicated with the mid-level and end business users to resolve production issues related to the ThomsonOne wealth management application.

•Used Javascript and AJAX for implementing client side functionalities based on events.

Project # II: Model-Rebalance-Trading Application: This application is used for creating and customizing models based on the proven models and rebalancing of accounts with securities such as Cash Equivalents, Large Cap Values Stock, Non-classified, Proposing Orders and Trading can be performed with the help of this application.

Responsibilities:

•Reviewed the requirements documents for developing to perform real-time trading.

•Developed Model, Rebalance, Proposed Orders and Basket screen using C# and ASP.NET.

•Developed and configured and consumed PerformTradeService WCF Service to perform online trading.

•Developed and consumed UserProfileService Web Service using XML/SOAP to retrieve user information which is subsequently used for actual trading.

•Designed and developed web forms using master pages, CSS and XSL.

•Worked on Data Contract, Service Contract and Message Contract while developing WCF Services.

•Performed Exception Handling while implementing Service and Client in WCF.

•Performed integration with the BETA system by using web services, created the proxies from the set of WSDLs by using WSDL.exe tool for submit trading, updating status and trade.

Project # III: Proposal Generator: This tool is useful for generating proposals on the fly for the users which best suit their portfolio. This mission critical tool is used by the Financial Advisors to set up/create Proposal Information, Proposal Parameters, Profile Information, Portfolio Construction, Questionnaire, Investment Program.

Responsibilities:

•Developed business layer components for generating user reports, performing calculations based on securities and retrieving broker/user details by using WCF service.

•Developed middle tier components by efficiently making use of caching when there is repetition of data retrieved from the database is involved.

•Used Caching Application Block and Logging Application Block for implementing caching and logging techniques in the middle tier.

•Created tables and stored procedures and wrote queries to retrieve/modify user/financial advisor information

•Developed Profile Information, Portfolio Construction, Investment Proposal and Report Generation modules using C# and ASP.NET.

•Displayed Product Catalog information using WPF application.

Project # 2: Natixis Data Migration: Performed data migration of Firm Object and Rep Contact objects using Producer-Consumer Pattern. Employed multi-threading for reading/updating values from the SQL Server and the CSV file to the target database. Consumed web services from Oracle CRM On Demand to update the data to the target database. Generated proxy classes by using WSDL.EXE tool and established session with Oracle CRM On Demand to perform data migration.

Responsibilities:

•Implemented DataAccessManager to retrieve data from different migration sources such as SQL Server 2008 and CSV files using C#.

•Developed Object Generator to generate type compatible objects based on the views from the SQL Server database using C#.

•Retrieved and updated values from the data sources and updated to the target database using Producer-Consumer pattern.

•Retrieved and updated data in the order millions of records by dividing them into chunks.

•Implemented logging using Logging Application Block.

•Implemented the FieldMapper functionality to map the source fields to the target web service attributes.

Environment: ASP.NET, C#, VB.NET, Java, Java Script, WCF, WPF, VSS, IIS6, MS SQL Server Management Studio 2005, Oracle 10g Database Server, Toad for Oracle, Oracle SQL Developer, Microsoft SharePoint, MS Office, UNIX, Cruise Control, Veracode, ORM, OO, Visual Studio Team Foundation 2008, UML, flash, Microsoft Visio, Windows 2000 Server, Unix and Web Services.

NCR eCommerce Solutions SC August, 2007 – June, 2009

Software Developer

Project # 1: Online Banking Project August, 2007 – June, 2009

Colonial Bank Project: The Online Banking application enables the users to Manage Accounts, Transfer Funds, Change Address and Order Checks online.

Sharjah Islamic Bank Project: The Online Baking Project involves the total online banking management application for the Sharjah Islamic Bank customers. They can log on to the web application to view their Account Summary details, make Funds Transfers, Reorder Checks, make Stop Payment and Change Address online etc.

Boeing Employees Credit Union Project: The BECU Baking Project is the online banking management application for the online members. The web application consists of many features such as Account Summary, Transfer Funds, Apply for a Loan, Self Service. The members can also work on the features like Stop Payment, Check Reorder and Change Address online.

•Analyzing the Requirement Specification documents and Copy documents for effective designing and coding.

•Designed Use Case Diagrams, Activity and Class Diagrams using UML for efficient design and coding.

•Worked on n-tier architecture for building efficient applications.

•Worked in various stages of SDLC for developing efficient business application product.

•Developed Entity Relationship Diagrams using Microsoft Visio.

•Developed the request and response objects in XML with the help of XSDs and wsdl files, which were subsequently used in the User Interface and Host Integration modules.

•Created organizational web sites using Microsoft SharePoint Services. Managed/edited regional settings, users/groups, themes of the SharePoint Portal web sites.

•Extensive experience in creating web parts, web site templates and content management using Microsoft SharePoint Services.

•Used the VAM controls for validating and enforcing regular expression conditions.

•Developed modules such as Internal Payments, User Administration, Password Reset, Transfer Funds and Alerts for the User Interface using ASP.NET and C#, VB.NET, Java, Oracle Database Server, MS SQL Server MS Office and UNIX.

•Maintained organizational websites using Microsoft SharePoint.

•Designed and developed WinForms for Customer Relationship Manager Application on the .NET 3.5 Framework. It has features such as Member Profile Information, Alerts, Transfers and User Administration modules.

•Developed Host Integration modules for the features such as for the Password Reset and Internal Payments.

•Designed tables and created stored procedures in SQL Server 2005 and generated DAL which was used in the Host Integration modules.

•Created tabular, matrix and free-form reports using SQL Server Reporting Services.

•Extensively worked on data source during the creation of reports using SQL Server Reporting Services.

•Worked on PL/SQL to create, update or modify database tables and written stored procedures and functions in Oracle 10g Database Server.

•Developed Web Services for retrieving and sending data to the host.

•Worked on Cascading Style Sheets (CSS) for designing layouts for Web pages.

•Created tables and stored procedures for efficient implementation of business rules.

•Implemented the SOA for communicating with Host in the Host Integration Modules.

•Implemented Error Handling and Validation for both the User Interface and Host Integration.

•Worked on Data Contract, Service Contract and Message Contract.

•Performed Exception Handling while implementing Service and Client in WCF.

•Extensively worked on Shapes, Transformations and Brushes in Windows Presentation Foundation (WPF).

•Used the Model-View-Controller pattern to develop User Interface, Business and Control modules.

•Developed objects using Factory Pattern.

•Made extensive use of JavaScript in implementing various functionalities on the client side for the User Interface.

•Developed client side modules for communicating with the server directly using AJAX.

•Developed Host Integration objects using XML and XMLSchema.

•Worked on XSL, XSLT for document presentation and transformation.

•Used the Corrillian Framework for developing efficient and robust applications.

•Developed test cases for both User Interface and Host Integration modules.

•Version Control using Visual Source Safe.

•Developed Unit tests using NUnit.

Environment: ASP.Net, C#.Net, VB.NET, Java, MS Office, Java Script, VSS, ORM, OO, IIS6, MS SQL Server Management Studio 2005, Silverlight, Oracle 10g Database Server, Flash, UNIX, Microsoft SharePoint, Tortoise SVN, UML, Microsoft Visio, Windows 2000 Server, and Web Services.

Contact this candidate