Srinivasa Rao Gavini

Mobile (P):***-347-***-**** E -mail: adt100@r.postjobfree.com

More than 20 years of IT experience with 7 years in leadership role and 13+ years in developing Web based applications, Web Services and Client/Server apps using Microsoft Technologies, it includes 9 Years in .Net technologies and 6 years in ETL (Extract Transform Loading) and Business Intelligence (BI) with SQL Server 2008 and 2012.

Experience in Angular and java with spring tool suite to create APIs and to use the APIs in angular.

Working in agile methodology with various scrum teams, with experience in Atlassian tools like Bitbucket, Confluence, Bamboo, Jira, Source Tree.

Experience in .Net Framework 1.1,2.0,3.5 &4.0 ASP.NET,.Net MVC,C#, VB.NET, Microsoft Visual Studio .NET 2003/2005/2008/2010,ADO.NET, Web Services, WCF,REST,WPF, Classic ASP, Visual Basic, SQL Server 2000/2005/2008,IIS, XML, XSLT,XPATH,HTML, DHTML, VBScript, JavaScript, JQUERY, COM/DCOM, SSIS,SSRS, Microsoft Visual SourceSafe, Team Suite and Subversion.

Experience in designing Web Apps, Services, Windows based apps, Console, SSIS and SSRS applications by following industry best practices and design patterns.

Experience in creating SOAP based and REST based Web services using WCF (Windows Communication Foundation).

Experience in developing web applications using .net MVC 2.0 and 3.0 Framework.

Experience in developing web applications using classic ASP, VB Script and COM components.

Experience in Configuring and managing web apps in IIS 5.1/6.0/7.0

Experience in different version source controls, VSS, Sub Version (SVN) and Bit Bucket

Experience in developing reports using SQL Server Reporting Services 2008 and 2005 (SSRS)

Experience in developing Asynchronous (AJAX) based web application using ASP.NET AJAX and JQUERY.

knowledge on Hadoop using HIVE

Database:

Experience in SQL Server 2012, 2008, 2005 and SQL Server 2000.

Worked extensively on TSQL, LINQ to SQL,Entity framework and PL/SQL.

Experience in designing and developing large scale, fully normalized, and relational databases for a variety of applications. Experience in working with SQL Server 2008 Service Broker.

Experience in setup SQL Server DB Replication between Data centers.

Experience in writing Queries, Stored procedures, Views, Triggers, Cursors, User defined functions and user Types using Transact-SQL (T-SQL).

Experience in developing Data Transformation Service (DTS) and SQL Server Integrations Services (SSIS) packages for ETL operations.

Experience in Oracle 9i/10g/11i and knowledge in Teradata, No Sql tools, Big Data

Design & Documentation:

Experience in designing different types of applications like web based, windows, batch apps, Reports, SSIS packages and Service Oriented apps using best design patterns and OOP methodologies.

Have experience in different Software development lifecycle methodologies including Agile Scrum methodology.

Strong experience in System Analysis includes Requirement gathering from Client, Preparing URS (User Requirement specification) Documents, SRS (System Requirement Specification) Documents and SDD (System Database Design).

Excellent Organizational, leadership, troubleshooting and interpersonal Skills. Ability to work in-groups as well as independently.

Have excellent presentation and communication skills with strong background working directly with clientele to identify business objectives and establish requirements.

Experience in source code version controlling, build and deployment process.

Experience in operation and maintenance process for web and client/server applications.

Certifications:

Certified Scrum Master

Microsoft Certified Professional with the following exam:

•o Exam Code - 070-305. Code Description - Developing and implementing Web Applications with Microsoft VB .NET and Microsoft Visual Studio .NET

White Belt in Six Sigma CMMi Processes from IBM

PROFESSIONAL EXPERIENCE

Engineer Lead/ SQL/ETL @Anthem Inc., 08/17 – till now

Member Portal (www.Anthem.com)

This portal is both web and mobile based application which provide access to the members who have Anthem Coverage.

Responsibilities

Creation of benefits, claims, bill pay, spending accounts and chat APIs needed for the UI support using spring tool suite using Java.

Developing API code using the Swaggers received from SOA team and creating Virtual APIs as well for the development purpose testing.

Creating and updating the UI pages as needed for benefits, claims, bill pay, chat, spending account modules.

Debug the applications to fix the defects using splunk and postman for debugging tools.

Coordination with devops team for the Continuous Integration deployments and active coordination with other scrum teams, SOA team and testing team as needed.

Support the application as per the business needs.

Environment: Visual studio Code, Angular, Node, Mongo DB Atlassian Suite ( Confluence, Bitbucket, Bamboo), splunk, postman, Jira.

Developer / SQL/SSIS/ETL @Anthem Inc. 10/14 – 08/17

Utilization and Quality Management (UM & QM)

The Automatic authorization load process for AGP (GBD) vendors and state clients dealing with Medicare and Medicaid systems.

Responsibilities

Automatic load processes for GBD vendors and clients using SSIS/SQL

Assist with the development of a redesign project for UMI, Authorization loads and Reports.

Performing production/ break fix support for ETL processes and reporting involving UMI.

Design and develop new ETL loads for Quality Management (QM) application MPOP.

Design and support .Net web based programming for MPOP application.

Design and develop new SSRS reports needed for both UM and QM applications

Environment: Visual studio 2010, ASP.NET, C#.NET,IIS 7.0, SQL Server 2012,TSQL, SSIS, Tidal, JIRA, SVN.

ETL Lead Developer @Wells Fargo & Co., in San Antonio, TX 08/13 – 10/14

Collateral Management System

This system helps to generate a process in ABS to Collateral status code (CSC) and /or participation indicator updates requested from the Public REIT group.

Responsibilites:

Worked in creation of SSIS package to load the data into the package

Updated the SQL Stored procedures to meet the requirements.

Environment: Visual studio 2010,MVC 3.0,ASP.NET, C#.NET,VB.Net, AJAX, IIS 7.0, WCF SOAP and REST services,XML, JQUERY, SQL Server 2008 R2,PLSQL/TSQL, SSIS, Team Foundation Server (TFS), Autosys, NDM Connect Direct, Pac2000, Win CVS.

Technical Systems Architect @ Verizon, in IRVING, TX

IPACDReportingSuite 05/11 – 07/13

All historical web reports are developed in ASP.Net MVC framework which internally communicates with WCF Services.

Responsibilities:

Involved in design and development of Real Time reports, Historical reports, Mobile reports and IPACD apps (SMS, ECH). It includes Web applications, WCF Services, REST services Console app and SSIS Packages.

Implemented Publisher – Subscriber, Singleton, Façade, Repository and IOC Dependency Injection design patterns.

Involved in developing web pages in HTML5 and JQUERY for IPAD.

Involved in design and development of WCF services with different endpoints like netTcpBinding (to support callback) and wsHttpBinding.

Involved in design and development of REST based JSONP WCF services in Framework 3,5 and 4.0, (supports cross domain calls).

Involved in setup of SQL Server Service Broker 2008 queues (created queues, message types, contracts& services, wrote stored procedure to insert messages to queue).

Implemented trace, debug and Logging mechanism using Microsoft Enterprise Logging Application block (Microsoft Enterprise Library 5.0), also developed custom trace listeners to store data in custom format.

Implemented, notifying of ‘data available’/ ’Agent status change’ information between components through user defined delegates and events.

Developed ECH, SMS batch console application using Multi threading and Thread Pool. Maintained synchronization of data between threads by using ReaderWriterLock Ex: methods AcquireReaderLock, AcquireWriterLock..

Developed Listener application using Sockets and TCPListener.

Involved in developing Historical reports using .Net MVC 3.0 Framework.

Implemented Repository, IOC using Microsoft Unity Application block, and Dependency Injection design pattern in Historical reports which are developed in .Net MVC 3.0.

Client side validations are implemented by using JQUERY.

Involved in desig and development of Views, Controls and Model in MVC with C#.

Developed data access component using Entity Framework to interact with SQL Server 2008.

Actively involved in design of database and creation of stored procedures, Queries, Views and table using TSQL in SQL Server 2008.

Involved in design and development of Workflows in Window Workflow Foundation (WF).

Involved in monitoring of SQL queries performance using SQL Profiler.

Involved in load and performance testing of Web applications using Visual Studio 2008 Test.

Involved in providing requirements for Load balancer rules (Global lb and Local lb) and coordinated the deployment of code to multiple production servers from different data centers.

Created Test driven development with Visual studio 2008 Team System and Visual Studio Team Test.

Used the XML Stylesheet Transformations (XSLT) and XML Schema (XSD) for transforming and validating input XML files.

Developed packages using SQL Server Integrations Services (SSIS) for transforming data from CMS servers to App server databases.

Involved in administration of IIS and SQL Server on need basis.

Involved in QA, Stage and Production deployments (Production environment is built on Webfarm (Global & local Load balancer)).

Extensively used the AVAYA Application Enabled Services (AES), System Management Service (SMS) and knowledge on Device Media Call Control (DMCC).

Environment: Visual studio 2010,MVC 3.0,ASP.NET, C#.NET, AJAX, IIS 7.0, WCF SOAP and REST services, Adobe Flex Builder 3,WebORB for .Net (v 3.6.0.3), XML, XSLT, HTML, JQUERY, SQL Server 2008,LINQ 2 SQL, SSIS (SQL Server Integration Services), SSO, SQL Server Service Broker 2008, and Visual Studio Team Test.

Project Manger/Technical Lead Architect @ Wells Fargo Bank, in San Antonio, TX

1Portfolio Asset Management Technical Refresh 09/10 – 05/2011

The 1POA Technical Refresh PTP project refreshes the existing 1POA application server infrastructure by replacing the existing servers to very high performance servers by increasing hardware and corresponding software. This includes upgrading latest software i.e. upgrading the OS from Windows 2003 to Windows 2008, IIS6.0 to IIS7.0, SQL 2005 to SQL 2008, Autosys 4.x to Autosys R11, NDM 4.4 to NDM 4.5 and migrating from CIBNA active directory domain to AD-ENT active directory domain. All the SQL Server SSIS packages upgraded to SQL 2008, tested and deployed from Dev to UAT, UAT to Prod and from Prod to DR (BCP) environments.

Responsibilities:

Analyzed the project to design the hardware and software of the project.

Involved in the budget proposals and approvals of the infrastructure.

Manage a team of systems & network administrators.

Used the project management tool like Microsoft Project to create and manage the project plans.

Measures and tracks performance. Leads teams to enhance performance and achieve targets. Identifies opportunities to improve efficiency and effectiveness.

Deliver on project/program objectivities, manage budget, and oversee procurement process.

Collaborate with peers on the coordination of work and resource allocation, forecast and track time to assess capacity.

Provide recurring project/program status and make recommendations.

Assess resource capacity and lead resource allocation discussions based on prioritization.

Complete project documentation in accordance with standards and policies.

Communicate regular written and verbal updates to project team leadership, customer and sponsor.

Proactively manage risks and issues for project/program.

Very strong relationship and interpersonal skills

Proactive problem skills

Risk and issue management experience

Deployment manager and build engineer for the applications in production.

Migrated, tested and deployed all the applications in new DEV, UAT, Prod and DR environments.

Possess Home Equity Financial domain knowledge.

Environment: Windows 2008 R2, VisualStudio.Net 2010, ASP.Net, VB.Net, C#, Web forms, Oracle11i, SQL Server 2008 R2, SSIS, DTS

Sr. Application Lead Architect @ Wachovia Bank, in San Antonio, TX

Investor Reporting (ETL, IR and Pledging) 01/10 - 08/10

The SHAW (Wells Fargo Loan System) national conversion release 2.10 will modify SHAW to support Home Equity assets moving from ACLS (Advanced Consumer Loan System) and FDR (Wachovia loan System) into the SHAW servicing system. The Fannie Mae and Investor Reporting project will modify the data sources for Legacy Wachovia structure transactions, REITS (Real Estate Investment Trusts), Fannie Mae and pledging systems (IRAMS, STACM DB, ULTRA and FNMA). The investor reporting processes will utilize data from a newly developed load, extraction, and translation (LET) components. The LET will process SHAW, ACAPS and YOM data. The data sources for IRAMS (Investor Reporting Rapid Amortization Reconciliation), STACM (Structured Transactions and Collateral Management) DB, ULTRA and FNMA (Federal National Mortgage Association) will be changed to interface with the LET. Upon completion of this project, all listed applications will be available to process with SHAW, ACAPS and YOM data. The Business groups will continue receiving and/or producing reports from the same ‘existing' processes. Treasury Technology will create the all current reports identified in this project using data from the SHAW servicing system and new ones when required.

Responsibilities:

Closely interacted with the client to analyze business requirement and involved in ongoing discussions with Business.

Responsible for architecture, design and development of SOA and C# .Net applications and systems.

Understanding requirements, interfacing with existing functionality and translating the requirement into application and system architecture.

Lead the team responsible for architecture and design of major components of the complete architecture.

Implementing ideas and presenting them to colleagues and management.

Creating prototypes, testing of design attributes and coordinating with other team members in accomplishing the overall objectives.

Design, Architect and develop an n-tier architecture web based Ultra auto boards on Microsoft's MVC pattern using VB.Net

Design a C# console application to validate the Excel Sheet that is given for processing.

Designed the Server Infrastructure for Department so as to meet the new business requirement.

Created the ETL Packages using the SQL Server 2005 SSIS Packages and created the reports using SQL Server SSRS 2005.

Designed and created the SQL Server Database that is required for the Project

Analyzed and collected the FNMA Delinquency Report requirements and designed the database for report in SQL Server using YOM (You Owe ME) Oracle Database and created a SSIS package to generate the report out of SQL Server.

Acted as Deployment manager for deploying the applications releases in all three environments.

Design and create the Auto Sys JIL scripts for scheduling the Jobs in the Production environment

Design and create the Batch Files for the SSIS Packages to work in different Environments.

Design the NDM Scripts to NDM the files from Windows to UNIX Mainframe systems.

Designed and created the Stored Procedures and Views for the applications

Environment: VisualStudio.Net 2008, ASP.Net, VB.Net, C#, Web forms, Oracle10g, SSIS, SSRS, Sql Server 2005, CA Autosys, Connect: Direct OS/400 NDM, Mainframe, Teradata

Senior Application Architect @ Prudential, Roseland, NJ 05/09 - 12/09

GIDW FMLA Reporting

FMLA (Family Medical Leave Act) of GIDW (Group Insurance Data Warehouse) is to provide the business with the ability to generate a set of reports relating to FMLA, on demand. This is used to automate the creation of the Word Document with the user selected graphs, products, time periods and the automatic creation of analytical text. The automated analytical text will compliment the data related to the client and the data represented in whole or in part in the reports and graphs. At present, such reports have to be created manually. These reports will source their data from the Group Insurance Data Warehouse and will be generated using the Pru Analyzer report package.

Responsibilities:

Design, Architect and develop an n-tier architecture based on Microsoft's Web Client Software Factory Framework that uses a composite website approach with Microsoft's Enterprise Library Data access, Logging and Exception Handling Application Blocks.

Create Stored Procedures, tables, functions, Cursors and views in DB2 and Oracle Databases.

Create a page parts, part helper, Data Helper to embed the parts in the word document as a report using Microsoft office 2007 Open XML with C#.Net

Environment: VisualStudio.Net 2008, ASP.Net, ADO.Net, C#, Ajax, Web forms, Oracle9i, DB2, Microsoft Office 2007 Open XML, PVCS, Team Tracker.

Senior Software Architect @ Janney Montgomery Scott, Philadelphia, PA 06/08 - 05/09

Ebix AnnuityNet

Ebix AnnuityNet is to develop and build an interface between Ebix AnnuityNet, Janney, BetaSystems and RegEd. Since there is an increase in Janney's annuity business, the Annuity and Compliance departments are currently unable to efficiently track annuity activity, monitor annuity trades and conduct compliance reviews for proper forms and client suitability. The current annuity order entry process is cumbersome, a drawn out and paper intensive process for the FCs and client. The new annuity order system will automate compliance reviews for proper forms and suitability, increase the number of "in good order" transactions, track activity, monitor trades, enhance FC productivity, and improve the client experience by implementing an new annuity order entry system

Responsibilities:

Lead the team responsible for architecture and design of major components of the complete architecture.

Lead the development of a technical strategy in concert with the Director of IT.

Used the TCP/IP Sockets and network stream to connect with the third party Thompson Inc mainframe systems.

Design, Architect and develop the n-tier architecture for JMSAnnuityNet intranet website.·

Environment: VisualStudio.Net 2008,Web Services, ASP.Net, ADO.Net, C#, VB.Net,IIS6.0, Web forms, MS SQL Server 2005, SSIS, SSRS, LINQ,DTS Services, XML,XSD, Windows Server 2003, MS Visual Source Safe2003, Telerik Controls.

Systems Architect @ James River Insurance Group, Richmond, VA 09/07 - 06/08

Primary Property

Primary Property is a web worksheet that is developed to all-encompass, dynamic, and user-friendly enough to encourage underwriters to enter all location information. The web worksheet automatically generates a policy in Prophet and performs initial data entry functions for both the direct and ceded coverages as well as policy common information.

Responsibilities:

Design and develop n-tier architecture (Presentation, Business Process, Business Control, Data Access)

Design and develop code using Microsoft Enterprise Libraries, including Security, logging and Data Access Application Blocks.

Environment: VisualStudio.Net, ASP.Net, ADO.Net, C#, Web forms, Windows Forms, MS SQL Server 2000, Oracle 10i, XML, Windows Server 2003, Source Gear Vault, PDFML.

Jr. Systems Architect @ SunTrust Banks, Atlanta 07/06 - 08/07

Human Resources Information System

SunTrust Banks contracted this project to IBM for maintenance, support and for development the HR System. Human Resources Information System (HRIS) provides an automated solution to provide online paychecks by using online time punching systems across SunTrust. The client needs to support, maintenance, design and develop a system to load time entries to middleware system for paychecks to employees from Human Resources Information systems. The Application involves understanding of the Banking hiring process and generation of Paychecks.

Responsibilities:

Developed ASPX pages using ASP.NET web form controls, Custom Controls, HTML server controls in VB.NET, C#.

Responsible to configuring the Web.Config file settings.

Used Advance JavaScript for enhancing the User Interface and for complex validation.

Writing Stored Procedures, Triggers in SQL Server as well as tuning up the database by creating the proper indexes on the tables.

Environment: VB.Net, VisualStudio.Net, ASP, ASP.Net, ADO.Net, C#, Web forms, Nunit, MS SQL Server 2000, Windows Server 2003, VSS, Harvest.

Senior Programmer Analyst @ Williams Energy, Houston, Texas 12/04- 06/06

Common Gas Accounting (CGA)

Williams Energy contracted this project to IBM, which is a US based consulting with offshore development in India. Williams Energy contracted IBM to maintain, support and to develop a Common Gas Accounting system. This System is already developed in VB 6.0 and it is a migration to the .NET technology with added functionality.

Responsibilities:

Writing of the ASP.NET applications, DLLs and Class files in VB.NET for the various modules. Used ADO.NET in database access component.

Responsible for Configuration Management using VSS.

·

Environment: VB.Net, ASP.Net, Visual Studio.Net, ADO.Net, C#, Web Services, UML/Rational Rose 2000, HTML/DHTML/XML, COM, Infragistics for .Net, PL/SQL, SQL Server 2000, VSS, JavaScript, IIS 6.0, Win XP.

Senior Programmer Analyst @ AIPT, US 08/04- 11/04

AIPT-APS2.0

AIPT (Association for International Practical Training) contracted this project to Tata Consulting services, which is an Indian based consulting company.

Responsibilities:

Developed ASP pages using ASP.NET web form controls, Custom Controls, HTML server controls in VB.NET, C#.

Environment: ASP.Net, Visual Studio.Net, VB.Net, C#, HTML/DHTML/XML, VSS, JavaScript, IIS 5.0, Win 2000.

Senior Programmer Analyst, Motorola, US 03/04- 07/04

WEB AR REDESIGN

TCS is a Level CMM5 is a leading provider of information technology products and services. It has a comprehensive set of solutions for the manufacturing, retail, distribution, contracting, banking, finance and insurance sectors.

Responsibilities:

Designed and developed of Middle-tier components to facilitate communication between the SQL 2000 database and VB.Net using C# class libraries.

Developed Stored Procedures and triggers in SQL Server 2000/TSQL.

Environment: VB.Net, ASP.Net, ADO.Net, VisualStudio.Net, C#, win forms, XML/XSL, SQL Server 2000, VSS, Win 2000

Reports Lead/ Sr. Programmer, 20th Century Fox, CA, USA 03/02- 03/04

HOBOKEN (FOXPPV)

Fox PPV is the automation system to pay per view (Serials, Films). This system calculates the total budget spent for completion, Campaigning and for Releasing Films or serials. This system finds out the groups to which the films or Serials were distributed for the show. Thus delivers the automation of the information of the Films and serials.

Responsibilities:

Design the prototype for the reports for the business approval.

Developing reports as per the business requirement.

Environment: VB.Net, ASP.Net, ADO. Net, VisualStudio.Net, C#, Crystal Reports 9.0 XML/XSL, SQL Server 2000, VSS, Win 2000

Reports Lead/ Sr. Programmer, 20th Century Fox, CA, USA 01/02 - 03/04

AESOP (FOXCSR)

Implementing new system to replace the existing MS Access based system. Main scope of the project is to rewrite the functionality and adding some more functionality on a new open architecture using industry standard programming languages. This includes the servicing and supply of films and serials tapes to the distributors and TV Channels all over the world.

Responsibilities:

Design the prototype for the reports for the business approval.

Created the stored procedures used for the reports.

Environment: VB.Net, ASP.Net, ADO. Net, VisualStudio.Net, C#, Crystal Reports 9.0 XML/XSL, SQL Server 2000, VSS, Win 2000

Programmer, Smart Soft Inc, SD, USA 07/00 - 01/01

Advanced Screening Ratios

This project was contracted by SMARTSOFT INC to PBSI Inc. This was a web based financial product, which screens and provides information about the companies, which have passed the criteria specified by the user.

Environment: ASP, VB, ADO, Visual Studio, SQL Server, VSS, and Win NT.

Awards

•· Bravo Award winner for demonstrating high technical skills in the IBM project.

EDUCATION/ADVANCE STUDY:

Masters in Information Technology from Punjabi University, India in 2003

Bachelors in Civil Engineering from Nagarjuna University in 2000

Contact this candidate