VAMSHIKRISHNA JANAGAMA

732-***-****

acec4z@r.postjobfree.com

Summary:

. 8+ years of experience in IT industry involving requirement Analysis,

Design, Development, Implementation, Integration, Documentation,

Testing of various Windows based, Web based Internet applications

under different environments.

. Strong experience in Design, Analysis, Implementation and maintenance

of Business applications using N-tier architecture with Microsoft .NET

Framework 4.0/3.5/2.0, C#.NET, VB.NET, ASP.NET, CSS, Web Forms, Win

Forms, ADO.NET, IIS, WebServices, WCF, WPF, Java Script, AJAX Control,

SQLServer 2008/2005, Sybase database.

. Responsibility includes gathering Business requirements, Data

modeling, Development, Client Interaction and Compiling Specifications

from client, Modification and Testing.

. Experienced in Web applications development using Masterpages, HTML,

AJAX, JavaScript, CSS, XSL/T, XSD, Xpath and XML.

. Good working experience in SSIS, SSRS,Crystal Reports, Antenna House

and SQL Server Reporting Services.

. Good working experience in MVC, SOA, and N-Tier based architectures.

. Good understanding knowledge in .NET Framework 4.5, SQL Server 2010.

. Proficient in maintaining source version using VisualSourceSafe(VSS),

TeamFoundationServer(TFS).

. Well versed with Agile/Scrum, Sprint sessions and Pair Programming.

. Efficient in several capacities in modulating system requirements to

technical specifications, including software version control.

. Involved in Client functional demo presentations, Application

knowledge transfer, Onsite coordination, communicate project

specifications effectively with project team.

. Extensive experience in performance tuning, identifying bottlenecks

and resolving to improve performance at Database level.

. Working experience in troubleshooting production issues and providing

post production support.

. Experienced & good understanding knowledge in DMV(Dept. of Motor

Vehicles), Media & Finance, Medical & Health Care, Mortgage &

Insurance domains.

. Has proven record of delivering high quality products, effective and

well-documented code, ability to meet deadlines, sense of ownership

and accountability. Excellent communication, analytical and

interpersonal skills. Have ability to perform as part of a team as

well as an individual contributor.

Technical Skills:

Microsoft .Net Languages: C#.NET, VB.NET, WCF, WPF, WebServices, .NET

Framework.

Web Technologies: ASP.NET 4.0/3.5/2.0, HTML,XML,XSD,

XSL/T,Xpath,JavaScript,AJAX,IIS,CSS.

Data Access Technologies: ADO.NET, Entity Framework, Linq to SQL.

Web Protocols: HTTP, SMTP, FTP, SOAP.

Development Tools: Visual Studio 2010/2008/2005.

Reporting Tools: Crystal Reports, SQL Server Reporting

Services, Antenna House.

Architecture: MVC3 & MVC4, SOA, N-Tier Architecture.

Methodology: Agile & Scrum.

Database: Microsoft SQLServer 2008/2005,T-SQL & Stored Procedures,

Sybase Database.

Operating Systems: Windows 07 /XP.

Source Control Systems: Team Foundation Server, Visual Source Safe.

Domain Knowledge: DMV (Dept. Of Motor Vehicles), Media & Finance,

Medical & Health Care, Insurance.

Professional Experience:

Clients: 1.State of Kansas

Jan 11 - till date

2.State of Connecticut

Project: DRIVER RECORD AND INSURANCE VERIFICATION SYSTEM ( 3M MVSS )

Role: Programmer Analyst

Driver Record and Insurance Verification System (DRIVS) Solution is a

software application developed by 3M and intended for use by State and

County driver services offices to manage customer driving records and

related information.

DRIVS runs in the 3M MVS Enterprise Software Suite Console. DRIVS

interfaces with 3M Accounting Transaction Money Manager (ATMM) and 3M Motor

Vehicle Registration Solution (MOVRS), which also run in the 3M MVS

Enterprise Software Suite Console. ATMM provides the cash drawer and

financial components. MOVRS provides the vehicle management features.

DRIVS shares a customer database with MOVRS. DRIVS customers may have a

driver's license, a non-operator ID, an employee ID, or no credentials.

DRIVS user login is assigned to a user role that determines which features

can a user access in DRIVS.

Responsibilities:

. Worked closely with Business Analyst during the JAD sessions and

gathered the Analytics requirements, User requirements and Document

Technical requirement specifications according to standards.

. Involved in analyzing the application Database schemas and Design new

schema models to support the user's reporting needs and requirements.

. Responsible for creating the Entity-Relationship diagrams, Class

diagrams, Sequence diagrams and Flow diagrams using Visio 2010 & 2013

and documenting the project architecture,General Specification Design

(GSD).

. Interacted with KDOR ( Kansas Department of Revenue Modernization)

team and actively involved in providing knowledge transfer of

developed functional use case requirements/application, UAT functional

demos & testing, debug & fixing UAT certification bugs.

. Participating in project scrum meetings to deliver higher-quality

software far more rapidly and involved in preparing analysis reports

and project development reports.

. Involved in documenting Release notes, Functional requirements

specification documents, Configurations & installation documents etc.

. Developed a core layer to retrieve all the lookup values needed using

Linq to SQL and cached all the lookup values at client level.

. Developed and worked collaboratively with team which was using Agile

methodology, where I interacted with the Business group as well as my

Implementation Project Manager for different phases of the project.

. DRIVS application is developed in Windows Forms and Web Forms using

VS2008, VS2010 and C#.NET, SQL server 2008, Archon Framework, Dev

Express Controls, and Linq to SQL for retrieving lookups. Linq to

Objects have been used to retrieve the lookup values information at

the client level.

. Involved in development of Classes and interfaces using C#.NET that

incorporates both N-tier architecture and database connectivity.

Developed presentation layer in ASP.NET to use across the

application.Worked with ASP.NET features like State Management,

Caching and Application Security.Used ASP.NET Session Objects to take

care of the user sessions in this application. Involved in design and

development of the Web Forms (UI) using HTML, XML, CSS, JavaScript,

JQuery, SOAP, WCF, WPF, C#.NET, Server controls and Data Controls.

. Involved in designing database tables, developed complex T-SQL stored

procedures, functions for data storage, retrieving customer

information for various applications in DRIVS.

. Implementation of client side validations using JavaScript and Data

Annotations in MVC3 & MVC.4.Used Microsoft Entity Framework for the

Data Access Layer for the ASP.NET application. Used LINQ to query

entities, relational databases, XML documents and ADO.NET datasets.

. Implemented Batch projects which run on daily nightly process.to

evaluate Convictions, Sanctions, Restrictions, comply compliance

consequences on the customer Driving record.

. Implemented Printer Batch project which run on daily nightly process

which prints all the correspondences related to the customers.

. Worked on mapping of data between inbound and batch tables and saving

processed records to the outbound tables.

. Worked with client on testing Issued credentials like DLs, IDs,

Permits, and Concealed Carry Handgun Licenses.

. DRIVS contains information regarding all the sanctions and convictions

associated to a customer and have ways to get rid of sanctions when

complied through Compliance module.

. DRIVS system interfaces with external systems to retrieve information

regarding customers and apply sanctions on the customers driving

record based on the convictions. It also interfaces with systems like

Morphotrust to print various credentials, provides information

regarding the customer status like licensed, eligible for license,

suspension, revocation etc.

. Worked on reporting functionalities using Antenna House Formatter,

SSRS and implemented code to generate customer related correspondences

on a daily basis.

. Worked on improving application performance, fixing bugs and coding

issues.

. Involved in thoroughly unit testing, functional demos of all

deliverables as per the business requirements.

Environment: Visual Studio .Net 2008, 2010, C#.NET, ASP.NET, HTML, ADO.NET,

Web Service, XML, XSLT, XSD, XAML, WCF, WPF, SQL Server 2008, IIS 7.0,

Windows 2007, Dev Express Controls, SSRS, SSIS, AJAX, T-SQL, LINQ to

SQL,LINQ to Objects, MVC3 & MVC4,JavaScript, Jquery, Entity Framework.

Client: SEI Investments, PA

Mar 09 - Dec 10

Project: CONTRIBUTION LINK

Role: .Net Developer

Contribution Link, a revolutionary web-based lobbying and campaign data

management system that provides new tools for lobbyists, candidates,

political committees, professional fundraisers and other stakeholders

needing the ability to track, credit and manage political contributions.

The innovation of Contribution Link comes by "linking" or integrating state

level campaign finance information with lobbyist registration data,

presenting it electronically, based on individual user specifications, into

one central system. The system then adds robust research and reporting

features, contact and event management utilities, and substantial data

search, sort and manipulation tools.

Responsibilities:

. Designed, developed and incorporated many rich, user friendly,

responsive features in the application using .Net framework, AJAX

Library, CSS and JavaScript and UI (User interfaces) and UX for

application.

. Working in Agile Environment to deliver higher-quality software far

more rapidly. Followed Scrum methodology by welcoming and adapting

changing requirements. Was active member of the scrum meetings and

sprint sessions.

. Implemented MVC Design patterned UI architecture.

. Involved in design of ASP.NET Web forms, developed business logic

layer, designing database tables and involved in writing and

optimizing complex Queries, stored procedures, functions and triggers

for data storage using SQL Server.

. Implemented LINQ concept in the web pages to query, filter and project

data in classes from tables as per the need.

. Worked on User access privileges functionality.

. Implemented login history and alerting the user if logged with same

user id (avoid same login) functionalities.

. Implemented webservices to get the contribution upload history data

for the particular user.

. Implemented WCF to get campaign finance data which is used by

lobbyists, candidates, committees and various modules of application.

. Worked on implementing file (pdf, .tsv, .txt, Video, Audio, Picture)

uploading functionalities.

. Worked on functionalities exporting data in PDF, Excel, Word formats.

. Worked on generating Crystal Reports -- Contributor,

Candidates,Lobbyists,Committee reports which includes contribution,

event funding history information etc.

. Implemented data paging concept to display millions of records at

time, and worked on avoiding unnecessary database hits to improve the,

performance of the application.

. Created/Coordinated application builds and release cycles of business

with dev and QA team.

. Worked on documenting release notes, functional specification document

with screenshots, and installation documents etc.

. Written test cases using Unit test and conducted unit testing using

NUnit tool.

. Performed unit testing on every new version before sending it for UAT.

. Worked on fixing the production environment issues reported by UAT.

. Used TFS for the source & document version control.

Environment: ASP.NET 3.5, C#.NET, ADO.NET, JavaScript, SQL Server 2008,

IIS, AJAX, CSS, XML,XSD, HTML, LINQ, Webservices, WCF, MVC, Crystal

Reports, Visual Studio 2008, Team Foundation Server, Windows XP.

Client: NESS, NJ

Project#1: OPUS HEALTH WEBSITE

Apr 08 - Feb 09

Role: .Net Developer

The Opus Health Website is a Web based Application. This website introduces

Opus Health to the end users and basically consists of three main sections

based on the type of users:

. Pharmaceutical Manufacturers

. Pharmacies

. Patients

Responsibilities:

. Involved in requirement analysis and design of ASP.NET Web Forms,

developed business Logic Layer and Data access layer using VB.NET.

. Performed validation of data through the Graphical User Interface

using JavaScript

. Worked on Add Pharmacies Enrollment functionality.

. Worked on Registration for Certification Testing functionality.

. Worked on Pharmacy web portal registration functionality.

. Implemented SOA Based data architecture utilizing SOAP.

. Worked on Pharmacy Locator functionality used by Patient for searching

nearest Pharmacies locations within the zip code entered. Used SOA

methodology to consume Web-Services for retrieving the nearest

pharmacies.

. Used SOA Dynamic Messaging Patterns to communicate with different plan

sponsors like Dendrite, Touchtone using Soap and Http protocols.

. Deployed services using SOA to consume Opus business requirements.

. Constructed complex SQL queries and stored procedures to retrieve and

manipulate data.

. Worked on functionalities exporting the data to Excel sheets,

automatic email prompting.

. Performed Source Code Maintenance using Microsoft Visual Source Safe.

. Performed coding/programming tasks to specification and in accordance

with Development standards and involved in unit testing along with QA

team, resolved the bugs as per unit test cases.

. Worked on fixing GUI design issues, functional bugs identified by OPUS

Cegedim Dendrite QA team.

. Worked on fixing the issues/defects found during UAT and are resolved

as per the mutual consensus and to the satisfaction of the end users.

. Worked on documenting release notes, functional specification

document, and installation documents.

Environment: ASP.NET 2.0, VB.NET, ADO.NET, CSS, JavaScript, SQL Server

2005,Sybase Database, AJAX, HTML, XML, Web Services, SOA, Visual Studio

2005, VSS 6.0.

Project#2: OPUS PORTAL

Jan 07 - Mar 08

Role: .Net Developer

There are five different Opus Web Applications, which cater to different

business requirements.

1. ProgSpex

2. WebTrax

3. Dashboard

4. Claims Support System (OpusHealthEligibilityApp)

5. Admin Console

These applications are configured separately through their own web.

Configuration and have their own virtual directories on the web server,

though they all use the same database repository.

Maintaining all the five applications is difficult since they use the same

database at the back end. Any changes made to the database require testing

of the other 4 applications.

Different source code repositories are maintained for these applications.

Every application has its own login, so multiple logins are required by a

user if he wants to work with more than one at the same time. Any new

common functionality (like change of Password page) has to be implemented

in all the applications.

Responsibilities:

. Involved in design and development across all application tiers: UI,

Business layer, Data access layer.

. Involved in designing database tables and stored procedures for data

storage and business logic. Database development using SQL Server and

Sybase.

. Worked on Master Page concepts like Creation of Menu structure and

Navigation panel using JavaScript, CSS and User Controls.

. Worked on Crystal Reports to print the data of worksheets, exporting

the data to Excel sheets.

. Worked on implementing image File upload (jpg, jpeg, bmp, gif, tif,

png) functionalities to save Contract Image to database.

. Worked on deploying and scheduling Tee chart Reports to generate all

daily, weekly, monthly and quarterly Reports.

. Worked on configuring web. Configuration files.

. Worked on implementing code to scan the contract image to pharmacy

Lists, E-mail Address prompt, print address letter functionalities,

Fax functionality which sends the Faxing details and displaying the

Status outcome, Pages scheduled, Number of retries etc.

. Implemented SOA architecture to generate alerts to Opus customer care

whenever unauthorized calls performed.

. Implemented SOA methodology to send emails to customers via Opus Web

Services.

. Implemented SOA Security Implementation to generate Webtrax call

summary reports.

. Worked on Contract Entry Report and generate file on click of generate

report button.

. Worked on Chain Viewer functionality to display an image by using

LEADTOOLS Web Image Viewer control class.

. Worked on Opus web services and created objects to use opus web

services.

. Worked on Security Group wise module user access privileges.

. Developed and implemented appropriate exception handlers using

OptasExceptionHandler.

. Worked on documenting functional specification document and

installation documents etc.

. Coordinated and did parallel testing and fixed the bugs identified by

QA team and OPUS Cegedim Dendrite QA bug pool.

. Wrote a lot of unit tests and done regression testing the application

on different browsers (IE, Firefox, and Opera) as per unit test cases.

. Documented nearly 60,000 alert messages functional wise from all five

Opus applications into excel as per the client requirement.

Environment: ASP.NET 2.0, VB.NET, ADO.NET, CSS, JavaScript, SQL Server

2005, Sybase Database, AJAX, HTML, XML, XSD, SOA, WebServices, Visual

Studio 2005, Crystal Reports, VSS 6.0.

Experience at i3 Software, India

Project: RMIC Home Owners

Jun 05 - Dec 06

Role: .Net Developer

RMIC is the property and casualty insurance industry. The product line

currently includes policy

processing applications for Homeowners, Personal Automobile and Business

Owners lines.

The capabilities of those applications includes: real time data entry and

issuance of all policy

oriented transactions, automated rating and underwriting, customer direct

billing and complete

generation and printing of all output documents.

Responsibilities:

. Involved in UI design, business class design, and business logic

design.

. Involved in designing database tables and stored procedures for data

storage and business logic. Database development using SQL Server.

. Worked on underwriting module and implemented code to track policy

transactions viz. issue, cancel, renewal, endorsement, etc.

. Worked on rating module in implementing code to rate the policy.

Rating request from application will instantiate rating component

based on client, company, product, program ordered by new business or

renewal effective date.

. Worked on Printing module used for generating reports and printing

policy declaration page, notices, invoices, etc.

. Implemented functionality where printing will be done at the time of

issue of policy. Worked on generating crystal reports for invoices,

notices.

. Implementing the Asynchronous calls to save, update, delete and search

the data.

. Implemented dynamic menu, menu tabs and top header in the project for

Home Owners LOB, which is controlled through table driven permissions

and accessibility.

. Worked on billing module used in policy billing module. Implemented

and used Billing objects that are used for cash transactions.

. Worked on implementing order processing functionality which supports

various order type as credit, MVR, CLUP, CLUE etc. Under ordering

process, system checks for the existing order types and it will create

order based on the order types.

. Worked on Agency Management System - used agency objects (collection

of classes) which will be used in Agency module.

. Worked on documenting, Functional specification document.

. Performed Unit Testing the application as per unit test cases in dev

environment as well as in server.

Environment: ASP.NET 2.0, C#.NET, ADO.NET, CSS, JavaScript, SQL Server

2005, AJAX, HTML, Web Services, VSS.

References will be provided upon request

Contact this candidate