Post Job Free

Resume

Sign in

Sql Server Management

Location:
Smyrna, GA
Posted:
October 28, 2016

Contact this candidate

Resume:

VENKATA SARATH BABU GUTTI

acw981@r.postjobfree.com

470-***-****

Technical Skills Summary

Having 16+ years of extensive experience in system architecture & design, development in areas of service oriented, multi tier, client server and web based systems. Developed software components for various types of applications and involved in all phases of software development life cycle.

.

Providing end to end to Architecture by following good frameworks and design.

Efficiently analyze problems and develop solutions to meet customer needs; involve writing code samples for the customer, which involves recommending design for end solution

Having good experience in giving the design solutions to the project to improve the performance of the project.

Worked in top tier multinational IT companies in various technology and leadership positions.

Recognized as solution leader in the organization to implement innovative solutions, industry standard best practices and improve technology, business processes for customers

Successfully architected and deployed multiple business critical applications with high satisfaction rating.

Extensive experience in .NET Framework, SQL Server, C#, WCF and Asp.net, MVC applications.

Hands-on technical skills and proven expertise in preparing technical proposals, proof of concepts and successfully secured multiple projects. Worked as Presales Architect in Microsoft web technologies at practice level.

Involved in Architectural discussions to come up with good architecture of the project.

Extensive knowledge in creating UML diagrams like Use case, Class Diagrams and Sequence Diagrams etc.

Experience in creating presentations for the technical solutions and architecture of the application and giving presentations to the customer.

Having extensive experience in UML Design by applying the design patterns.

Having good knowledge in OOAD concepts and UML and applying the design concepts to the solutions.

Ability to maintain the team and having leadership skills to communicate with the client to resolve the technical issues.

Having experience in developing cloud based applications (Windows Azure) and deployment in cloud.

Having experience in creating the VM’s and Virtual networks in Cloud environment (Windows Azure) and deployed the application.

Having experience in deploying the application using WebApps, Cloud Services and used Caching services of azure.

Software Expertise

Languages

Web Technologies

Scripting

OS

RDBMS

Messaging

GUI

Methodologies

Tools

C#, ASP.NET, HTML, VB.Net, XML, XSLT, AJAX, WPF, Silverlight

.NET Framework 1.1/ 2.0/3.0/3.5/4.0,4.5,4.5.1, Visual Studio .NET 2012/2013,ASP, Web Services, Windows forms, User Controls, Windows Services, IIS, ASP.NET, WCF, Web API, Windows Azure, MVC

VB Script, Java Script, JQuery, Ajax, ANGULAR JS

Windows 2012 R2/2008 R2/2008/2003/2000/NT/98/95, MS-Dos

MS SQL Server 2016/2014/2012/2008 R2/2008/2005

COM, COM+, DCOM, MSMQ

Visual Basic

UML, COM/DCOM using Microsoft Visual Basic 6.0

Team Foundation Server, Git, SVN, Rational Rose, Microsoft Visio 2000, Erwin 3.5.2, Enter Prise Architect, Entity Profiler, App Dynamics, Release Management

Education

Bachelor’s Degree in Computer Science & Engineering.

Projects

Client : AARP ( American Association for Retired Persons)- Atlanta, GA

Software : C#, MVC 5.0, WEB API, Angular Js, SQL Server 2012, JQuery, Entity Framework 6.0, TFS, Release Management

Duration : Sep 2015– Till Date

Role : Architect

AARP, Inc., formerly the American Association of Retired Persons, is a United States-based Non-Governmental Organization and interest group, founded in 1958 by Ethel Percy Andrus, PhD, a retired educator from California, and based in Washington, D.C. AARP operates as a non-profit advocate for its members and as one of the most powerful lobbying groups in the United States. AARP has two affiliated organizations: AARP Services Inc. which is managed wholly for profit, and the AARP Foundation, a charity that operates on a non-profit basis.

Client wants to develop a web based application for managing the retired people medical insurances that are above 50. The system consists of various plans offered for the retired persons. It consists of different policies for managing the insurances of the application, where end user can select the appropriate policy. Also, there is contact module which takes care of people personal information.

Responsibilities

Providing the end to end architecture for the application using different frame works.

Prepared the complete architecture for entire application by following the different architecture strategies and applying best design practices which will fulfill to work in both s desktop and mobile.

Applied different frameworks like MVC, Unity to implement the dependency injection and modular approach.

Leading the technical team and providing them technical direction, design guidance and some development help.

Interacting with Client and understanding the new requirements and proposed design and solution to the team.

Complete responsible for handling the non-functional requirements like security, performance and response times.

Extensively used TFS for source code management and continuous integration.

Involved in peer code reviews and writing unit test cases.

Involved in creating stored procedures, functions and modifying existing database schema.

Responsible for creating Angular Js functions and cascading style sheets as needed.

Involved in the performance tuning of the application and identification of bottle necks.

Responsible for creating the common business functions at business layer at service module.

Implemented common caching mechanism for the application for frequently accessed data.

Responsible for doing the POC on concurrency for the application.

Created load balanced environment using Application Routing Request in IIS for performance testing.

Created virtual network and assigned multiple servers in windows azure for performance testing.

Created Restful services using Web WPI to decouple the application code and business logic for re-usability by following SOA restful principles.

Client : ISUZU

Software : C#, Silverlight 5.0, MVC 5.0, WCF Services, Kendo UI, Angular Js, SQL Server 2012, JQuery, Prism Framework, Entity Framework 6.0, App Dynamics, Entity Profiler, TFS,SSRS, Release Management

Duration : Sep 2013– Sep 2015

Role : Architect

ISUZU is a Japanese commercial and manufacturing company headquartered in Tokyo. Its principal activity is the production, marketing and sale of Isuzu commercial vehicles and diesel engines. The project aims to track the performance of dealers very closely. Some scenarios where dealers carry multiple brands, this task becomes all the more challenging and important.

The project helps to build effective Dealer Management System that enables the following:

Track primary and at times secondary sales

Track product performance with dealer, in comparison to dealer's overall business

Keep track of stock levels with dealers

Effective Supply Chain Management ensuring that the dealer's always have sufficient stock

Compare dealer performances pro-actively, and reward top dealers

Enhance dealer satisfaction levels by providing them a convenient self service portal

Enhancing dealer operational efficiency by providing them systems to streamline and automate their business processes. These include financial accounting, sales, purchase, Inventory, MIS and statutory compliance.

Architect

Providing the end to end architecture for the application using different frame works.

Prepared the complete architecture for entire application by following the different architecture strategies and applying best design practices which will fulfill to work in both s desktop and mobile.

Applied different frameworks like MVVM, Unity, Prism and Structure Map to implement the dependency injection and modular approach.

Leading the technical team and providing them technical direction, design guidance and some development help.

Interacting with Client and understanding the new requirements and proposed design and solution to the team.

Complete responsible for handling the non-functional requirements like security, performance and response times.

Having multiple rounds of discussions with the onsite infrastructure team and client to come with deployment process with release management.

Followed response UI for mobile which is created by using MVC 5.0 which renders in the mobile accordingly.

Extensively used TFS for source code management and continuous integration.

Involved in peer code reviews and writing unit test cases.

Involved in the performance tuning of the application and identification of bottle necks.

Responsible for creating the common business functions at business layer at service module.

Implemented common caching mechanism for the application for frequently accessed data.

Responsible for doing the POC on concurrency for the application.

Created load balanced environment using Application Routing Request in IIS for performance testing.

Created virtual network and assigned multiple servers in windows azure for performance testing.

Created SOA services using WCF to decouple the application code and business logic for re-usability by following SOA principles.

NIIT Technologies

Duration : Jan 2012– Aug 2013

Working in the COC (Center of Competence) which is responsible for the handing the RFP’s.

Involved in creating the proposal solution documents to RFP’s.

Providing end to end solutions to the project teams. Also providing the estimations to the proposal documents.

Co-coordinating with various project teams in the organization and providing technical solutions and guidance to the technical team.

Involved in the providing the estimations to the proposals using different techniques like WBS and LOC.

Preparing presentations to the technical solutions and presenting to the customer.

Done POC’s for multiple projects by providing technical solutions which will be recommending to the technical teams in the organization.

Unigy Client –Fairfield – CT

Client : IPC Systems Inc

Software : C#, VisualStudio.NET2008, Adobe Flex 4.0, Java, WCF Services, Web Services

WPF, MySQL

Duration : Sep 2009 – Dec 2011

Role : Architect

IPC information system is a leading provider of mission-critical communication solution to financial service firms worldwide. IPC offers customers a suite of products and enhanced service that includes advanced voiced over protocol(VOIP) technology and integrated network, management service to more than 40 countries.

The objective of this product to develop a PC desktop based application for a variety of voice and non-voice based services alternatively known as Unigy Client. Unigy Client requires the user to have access to direct lines, intercom, ClickToDial and general call features. Application is supporting 3 modes which are Enterprise, Trader Light and Augmentation. The audio associated with the calls will be handled via PC microphone and speakers. It maintains outlook contacts and user can make a call from outlook directly.

Architect and Technical Lead.

Involved in the discussions with Architectural group and come with the plug in based architecture.

Responsible for establishing the communication mechanism between different plug in’s of plug in based architecture.

Leading the technical team and providing them technical direction, design guidance and some development help.

Participated in creating technical specification documents on onsite.

Interacting with Client and understanding the new requirements and proposed design and solution to the team.

Participated in design and developing of inter process components.

Created SOA services using WCF to decouple the application code and business logic for re-usability by following SOA principles

.

ISM & TXOCA – Reston – VA (US)

Client : Unisys Corporation

Platform : Microsoft.NET, IIS 5.0

Software : VisualStudio.NET2005, ASP.NET, AJAX, XML, WCF Services, SQL Server2005

Biz talk Server 2006, MSMQ, XSLT, Web Services

Duration : Dec 2007– Sep 2009

Role : Tech Lead

Information Sharing Management Framework is a web based information repository system for justice agencies. It comprises with security administration module and web search module. The ISM .NET framework centers on Microsoft BizTalk Server as the integration broker enabling real-time information exchange between the agency solutions. The solution will complement BizTalk with Microsoft Message Queue (MSMQ) to ensure reliable message delivery. This whole system was build and implemented using .NET Framework, BizTalk server 2006, MSMQ and SQL Server 2005.

Developed Texas Client Office of Courts Administration (TXOCA) using ISM as the background framework

Technical and Design Lead.

Oversee Development of core business logic and Integration of functions in the systems.

Responsible in the design and development of Information Sharing Management Framework using .Net, BizTalk Server 2006,Ajax and MSMQ.

Participated in creating the class diagrams, sequence diagrams and component diagrams using RSA.

Participated in creating Design documents using Rational Software Architect (RSA).

Developed orchestrations for asynchronous communication between collaborating applications when client system is disconnected and also used WCF adapters.

Involved in creating Windows service for legacy agency systems for exchange of data between the agency database, Query portal and MSMQ queue management.

Created MSI, Executable Batch files for deployment process to set up ISM .NET Framework in various environments using Virtual PC.

Involved in creating the authentication and authorization mechanism using active directory and RSA.

Involved in creating the solutions for interacting with the different legacy systems to for exchange of data between query portal and agency systems.

URL: https://www.ar.courts.state.tx.us

UMO- UK (Unisys Mortgage Origination)

Client : Unisys Corporation

Platform : Microsoft.NET, IIS 5.0

Software : ASP.NET, C#, Web services, SQL server 2005

Duration : Jan 2007– Nov 2007

Role : Tech Lead

Unisys Mortgage Origination (UMO) is a highly-configurable mortgage sales processing solution, designed to be easily adapted to the specific requirements of the customer’s business processes. The vision for UMO solution is to make it a comprehensive market leading Mortgage Origination solution framework developed in Microsoft.NET technology, providing mortgage lenders with a flexible agile solution delivering sales and completions processing.

UMO delivers a set of standard business process workflows which can be tailored and extended to support the particular business requirements of an organization. It is unlikely that the default solution would be used without some customization after the initial installation.

A series of electronic forms capture customer data, minimizing the need for manual re-entry data throughout the quotation and application stages. These electronic forms can be customized to capture only the data the organization requires. UMO automates the production of case documentation, and provides the facility for users to track cases and add notes to assist with the management of the case.

Responsibilities:

Technical and Design Lead.

Leading the technical team and providing them technical direction, design guidance and some development help.

Developed Business requirements and technical specifications based on user requirements

Oversee Development of core business logic and Integration of functions in the systems.

Conduct internal reviews and ensure quality delivery to Onsite.

Property Evaluations (SD2)

Client : Cendant Mobility (US)

Platform : Microsoft.NET, IIS 5.0

Software : MS-SQL Server 2000, ASP.NET, C#

Duration : Sep 2005 – Nov 2006

Role : Team Lead

Service Delivery is re-engineering the ordering of appraisals, titles, contingency removal and rental and moves these functions from the mainframe to ATLAS. Stream line processes, drive efficiencies, reduce touch points and maximize a paperless environment between customers, consultants, resource centers, and suppliers. Property Evaluation is the service to be provided to customers to evaluate their property. The system will create the appraiser list, appraisals and ordering the appraisals. The appraiser will give the property evaluation amount. The person in charge of review of these appraisals, can be reviewed and send the offer amount to the customer.

The new system being developed (EDGE) is Re-engineering of an existing system, which works on Mainframe. Since only some of the functionalities are being moved to new web based system there is requirement of synchronizing the data between Mainframe, IC & EDGE, which is called as bridging. This is achieved using the Biztalk Server Orchestration & Middleware components developed in C#. The various bridges developed are EDGE To Mainframe, Mainframe to Edge & IC to Edge.

Responsibilities:

Designer and Team Lead

Involved in Designing and implementation of system.

Oversee Development of core business logic and Integration of functions in the systems.

Represent Business requirements as UML Use case, Class, and Sequence Diagrams etc.

Conduct internal reviews and ensure quality delivery to Onsite.

#5 Organizational Data1 (OD1)

Client : Cendant Mobility (US)

Platform : Windows 2000, Microsoft.NET, IIS 5.0

Software : MS-SQL Server 2000, ASP.NET, C#

Duration : Jan 2004 – August 2005

Role : Team Lead

Responsibilities:

Involved in Designing and implementation of system.

Oversee Development of core business logic and Integration of functions in the systems.

Represent Business requirements as UML Use case, Class, and Sequence Diagrams etc.

Constant interaction with architecture and project teams.

Conduct internal reviews and ensure quality delivery to Onsite.

Technical Overview:

Application Development for Web Environment with .NET Technologies.

Cendant Mobility is into the business of relocation management whereby a company, which is entering into a contract with Cendant, assigns Cendant to manage the various activities involved in relocating an employee from one place to another.

Currently Cendant mobility has multiple subsystems. These systems have own database and applications and interact with each other. With EDGE Cendant intends to build enterprise data model and application framework to replace existing system.

The organizational data 1 is one of the subsystems of EDGE, to cater design of Enterprise Data model in order to consolidate organizational data with respect to Supplier, Client, Customer and Employee Profile data. This includes user-friendly web based interface for complete maintenance of Supplier and Employee Teams to suffice requirements for subsystems OER, SD2 and Policy tracks.

Operations Support and Analysis (OSA)

Client : CFMC (US)

Platform : Windows 2000, Microsoft.NET, IIS 5.0

Software : MS-SQL Server 2000, ASP.NET, VB.Net

Team Size : 5

Duration : Aug 2003 – Jan 2004

Role : Team Member

Responsibilities:

Involved in Designing and implementation of system.

Oversee Development of core business logic and Integration of functions in the systems.

Technical Overview:

Application Development for Web Environment with .NET Technologies.

Robust and scalable 3tier Architecture -Presentation, Business, Data Access Layers.

Custom server controls designed for the presentation layer.

The OSA application is developed for CFMC (Citibank Financial Mortar gage) company. It allows users across multiple locations to view information about organizational structure, analysis and audit information. Access rights are provided to view specific information. Analysist can upload the report for subscriber to view. The user management module allows alteration of users, locations and distribution list, report type and assigning those permissions and roles on the application.

#Group9 Property Verification System

Client : Group9 (US)

Platform : Windows 2000, Microsoft.NET, IIS 5.0

Software : MS-SQL Server 2000, ASP.NET, C#

Team Size : 6

Duration : December 2001– April 2003

Role : Team Member

Responsibilities:

Oversee Development of core business logic and Integration of functions in the systems.

Debugging the Discrepancy Reports.

Technical Overview:

Application Development for Web Environment with .NET Technologies.

Robust and scalable 4-tier Architecture -Presentation, Business, Persistence, Data Access Layers.

Custom server controls designed for the presentation layer.

Using XML and XSLT to generate the Invoice Report.

Interface to the external PLU flood certification system

Implemented via .Net Interop.

Windows Service to generate Invoice.

Robust fine-grained security system.

The Property Verification System will enable Group9 to automate the property verification process to provide efficient services to their customers who are institutional or single customers. The application will provide a web-based interface for Group9 customers to enter verification requests and view their interaction with Group9. The system processes the property verification requests for proneness to various hazardous elements like flood zones etc. It will also enable the Group9 users to track verification requests and ensure their completion.

#Apolo-HealthScan

Software : MS-SQL Server 2000, VB 6.0, ASP

Team Size : 5

Duration : Jan 2000 to Aug 2000

Design and implementation of positive and total computerized life style assessment and prescription

System.

A physician or health practitioner for assessing and advising on cardiac,cancer,AIDS,fitness and exercises,nutrition,stress and dependency may use this product. On the basis of findings a personal, positive and health assessment and prescription will be released and information is maintained for appropriate follow up sessions. The ultimate aim of this project is to evaluate primary health based on questionnaire, generate a prescription with do’s and don’ts, a comparative report with previous scan and graphical report generation.

#CJ-Real Estate Management System

Client : Colliers Jardine

Software : Visual Basic 6.0 with SQL Server as backend, ASP

Team Size : 5

Duration : April 99 to Dec 99

Description:

“CJ-REMS” was developed for the real estate business. The system monitors Ressidential,Commercial and industrial listing information,Client requirement details, Broker listed properties,details of ventures of various organisations,etc.The generation of the reports customer wise, venture wise are also integrated in the above system.

Responsibilities include front–end design, coding and handling backend stored procedures.

# Share Accounting System

Client : Sharada Consultants

Software : V.b.6.0 with MS SQL Server as Back End, ASP

Team Size : 8

Duration : March 98 to March 99

The objective of this software is to design and implement a Share Accounting System to enable any Brokerage House to manage entire operations of stock broking starting from day-to day operations of trade to generate the final accounts. This system is meant for use by any individual share broker of any exchange or a corporate member of any stock exchange or a brokerage house with multiple member ships. This is used for managing entire operations of stock broking starting from day- to- day monitoring of trade positions to generate the final accounts. This system has various security levels and different pre-defined roles and privileges. Depending on the role played by the user in the organization, the user has been privileged with access to different forms, reports and menus. Update, Delete, Insert options have also been granted based on the role by default. There is also flexibility of defining new roles and new users with choice privileges from time to time. The system design is flexible and adaptable to future developments in the business environments.

Responsibilities: Worked as a Team Member, where I am responsible for Screen Design and coding.



Contact this candidate