Developer Manager Project Service Sql Server .Net

RAMANATHA REDDY AMBATI

EXPERIENCE SUMMARY

o Over 6 years of focused IT Industry experience with strong skills in

complete Software Development Life Cycle (SDLC) process includes

Requirement Gathering and Analysis, Development, Unit and Integration

Testing, Deployment and Maintenance

o 5.8 years experience in ASP.NET, C#.NET, VB.NET, ADO.NET, XML Web

services, AJAX, Windows Services, Win forms, XSLT, XPATH, XMLHttp,

JavaScript, Web Parts and CSS Technologies

o 1 year experience in VB 6.0 and ASP 3.0

o Extensive experience in database design and development which includes

hands on skills in developing Stored Procedures, Functions, Views,

Triggers, Jobs, SSRS, SSIS and Database Synchronization with the

database technologies like Oracle 8i/10g/11g and SQL Server 2005/2000

o Extensive experience on coding with XMLHttp object, JavaScript and

XSLT

o Extensive experience in coding with Object Oriented Programming (OOP)

Concepts

o Experience in middle ware technologies like IBM Web sphere MQ 5.5 and

good knowledge on Microsoft BizTalk server 2004 (creation of Maps)

o Good experience in configuring and managing IIS 6.0

o Good knowledge on C# 3.5, ASP.NET 3.5

o Proficient in U.S Healthcare, Insurance and Banking domains

o Extensive experience on N-tier Architecture and Three-tier

Architecture

o Experience in preparation of documents like Detailed Design Document,

Defect Log, Issue Log, Unit / Integration Test Plan, Status Report

o Experience in project management tasks like Preparation of Estimates

for the Project, Project Plan, PCR documentation etc

o Well experienced in version control management (Source safe control)

using Microsoft Visual Studio Team Foundation Server (VSTFS),

Microsoft Visual SourceSafe (VSS), Sub Version and IBM RPM (Rational

Portfolio Manager - for project documents)

o Excellent in technical issue solving and code debugging skills.

o Flexible in work environment and adapt the working style required by

the team

o Played a key role in team that was involved in studying change

requests and involved in client interactions

o Excellent communication, leadership and interpersonal skills with

great team player abilities

o Extensive experience in IBM Processes and Methodologies

o Been appreciated by IBM Mangers and Horizon Blue Cross Blue Shield of

NJ Client for good work

o Acted as single point of contact for Clients in projects

o Worked on more than one projects simultaneously and met the dead lines

o Worked collaboratively with the end-users for identifying requirements

and fixing issues that arrived in JP Morgan Chase

TECHNICAL SKILLS

Programming C#.NET 3.5/2.0/1.1, C++, VB.NET 2.0/1.1, VB

Languages 6.0/5.0, PL/SQL, T-SQL, SQL XML, AJAX, XMLHttp,

JavaScript, XML, XSLT, XPATH, HTML, DHTML

Web Technologies ASP.NET 3.5/2.0/1.1, XSD, SOAP 1.1/1.2, Web

service behavior (Microsoft HTC component used),

IIS 6.0/5.0, ASP 3.0, jQuery 1.2

Databases ORACLE 11g/10g, SQL Server 2005/2K, SQL Server

Reporting Services, SQL Server Integration

Services, MS-ACCESS

Data Access TOAD, ADO.NET and ADO

Technology

Operating Systems Windows XP/9X/2000/2003 Professional and MS-DOS

Middleware XML Web services, IBM Web Sphere MQ 5.5 with

Technologies DOTNET and Microsoft BizTalk Server 2004

Other technologies COM, COM++, Visual Studio 2008/2005/2003, IBM

and tools Rational Portfolio Manager, SubVersion, Visual

Studio Team Foundation System (source control),

Microsoft Visio 2003, MS Sharepoint Portal,

Microsoft Offixe XP

JP Morgan Chase, Columbus, OH Employer: Populas Group Inc, MI

- 48083 (Tek System)

Investor Reporting Integration System - Senior Developer

Sep 2008 - Till Date

Description: Non-Prime Investor Reporting is developing and maintaining

multiple applications for the Home Lending and Mortgage Services

departments. This includes managing data related to Sub-Prime mortgages,

and its internal processes like, loan approvals, adjustments and scheduling

liquidation. Currently a vast portion of these processes are carried out

manually and my team is in the process of automating and integrating the

applications under a loosely coupled system. This website will provide

online web based reports for the investors. In existing system, crystal

reports are used instead. This web site has been developed with customized

Ajax object i.e., XML Http. Using this object only the required data will

be transferred for subsequent requests. It uses a three layered

architecture.

Projects:

Final Remittance: The Remittance page of the IRIS(Investor Reporting

Integration Systems) website allows the end user to enter remittance

corrections on a loan level basis for specific investors, which are then

updated in the servicing system(MSP) at the cutoff period for each

investor. Users can search loans and download loans into an excel sheet.

Users can perform calculations for 9 modems such as Chase, Aurora, Prime,

Aegis, DB, etc, in a single web page with dynamic content.

Investor Web Reports: Converting manual reports to web reports using

Microsoft RDLC reports and report viewer.

Monthly Tracking Log: Monthly Tracking Log indicates transmissions sent to

the investors, as well as confirmation of receipt from the investor.

Loan Level Differences: Adjusting the values of loans for each investor by

a reporter and Manager verifies the loans adjusted.

Responsibilities:

. Automated existing manual process

. Converted all existing crystal reports (manual) to web based reports

using RDLC

. Reduced server side process by server performance and less calls to the

server with a limited required data which resulted in quick webpage

response to the end user.

. Customized AJAX Framework using XMLHTTP object to suit the project

requirement

. Created High level and Technical specifications for web pages

. Search made easy where numerous(sometimes more than 30,000) loans exist

by implementing dynamic search

. Played key role in the design discussion related to the project

. Enhanced existing web pages to reduce the time consumed for a page to

load

. Created stored procures, functions, views, jobs, triggers using TOAD

database IDE tool

. Created a three layered architecture(data access, business access and

user interface) for enhancing the existing applications

. To design and code web pages

. Created Web Parts in Home Page for customization of reports and added

notification for the end users.

. Base and Child Mater Pages Creation(Nested Master Pages) and applied to

all the pages in the website

. Developed and maintained the C# components and Java Script components

which are used for all modules in the project

. Extensively used Validation Controls for client side validations and

implemented Server Side Validation.

. To report project status to Project Manager on a regular basis

. Research on previous versions of the application and update the

functionality to current version application.

. Implemented the use of Cascading Style Sheets(CSS) to improve the look

and feel of the User Interface

. Implemented C# generics

Environment: ASP.NET 2.0, C# 2.0, XSLT Programming, XMLHttp, XPATH, Ajax,

jQuery, JavaScript, Microsoft Reporting (RDLC), Oracle 11g(Database),

TOAD Oracle Editor, Visual Studio 2008 & 2005, IIS 6.0, CSS

Humana Healthcare, Louisville, KY Employer: ObjectWin Technology

Inc, Houston, TX 77057

ESS (Enrollment Self Service) - Senior Developer

Mar 2008 - Aug 2008

Description: Humana is one of the Fortune 100 companies and a leading

insurance provider. This is the first web enrollment application in

insurance industry where user will have direct access to the Medical,

Dental, Life, Vision and Spending Accounts products online. The project is

intended to build a web application which would be used for Individual and

Group enrollment of Humana's Medicare Insurance Plans. This application

uses the Microsoft User Interface Process (UIP) application block as the

implementation of the Model View Controller (MVC) pattern in order to

separate the flow of the application from UI-specific code. In order to

separate application logic from presentation layer logic, an MVC pattern

implementation was required for the architecture.

Responsibilities:

. Designing and coding of web pages based on HTML files provided by

business team

. Coding in XSLT which will transform Serialized DTO (Data Transform

Objects) to html content

Creation of XSLT control which serves all the pages in ESS web

application wherever XSLT is used.

. Created base and child master pages(Nested Master Pages) and applied it

to all web pages

. Developed and maintained the C# components which are used for all modules

in the project

. Created web user controls and custom controls

. Created DTO (Data Transport Objects) and DAO (Data Access Objects) which

are included in N-tier Architecture

. Created Models based on jQuery Library

. Created Web Medical tools like My Estimates Expenses with Rx Calculator,

Closest to my plan and News and Announcements etc

. Created Communication Preferences web page which contains dynamically

generated controls based up on XML data which is retrieved from external

web service

. Created and implemented Validation Controls for client and server side

validation of data

. Resolved defects in Integration testing by implementing Humana

methodology

. To research on previous versions of the application and update it to the

current version

. Used Microsoft's User Interface Process Application Blocks (UIP 2.0),

Navigation Graphs etc. for navigation management, state persistence, back

button support and usability enhancements

. Used Cascading Style Sheets(CSS) to improve the look and feel of the User

Interface

. Used ODP.NET for database connectivity on Oracle Database

. Implemented C# generics

Environment: ASP.NET 2.0, C# 2.0, XSLT Programming, XPATH, Microsoft

Application Blocks, jQuery, JavaScript, Microsoft Team Foundation (source

control) and VSS (source controls), Oracle 10g(Database), MS SharePoint

portal (For Project Documentation), UIP Framework, MVC Architecture,

PL/SQL,N Tier Architecture

Horizon BCBSNJ (Blue Cross Blue Shield New Jersey)

Employer : WDC/IBM / India

Blue Squared (Blue2 Application) - Message Oriented Middleware- Module Lead

/ Senior Developer

June 2007 - Feb 2008

Description: MOM is an in-house developed message service engine; it is

built upon a Service Oriented Architecture (SOA) with various pre-built

interfaces to most of Horizon BCBSNJ's major applications and backend

systems. The main function performed by MOM is data exchange and data

integration across multiple applications. When MOM receives an incoming

Request Message from a Client application, it transforms data in the Client

Request Message format into format expected by Mainframe ImagePlus and

drops the message to Queue using MQInterface. The purpose of MOM Blue

Squared Service is to pick up the attachments (AT1, AT2 and AT3) posted on

portal/Blue2 queue with the use of agent listener in MOM architecture. As

the attachment is picked up from the portal/Blue2 queue, it is then decoded

and put on ImagePlus Queue. Then ImagePlus processes the attachment

further. The Blue2 Project involves a Client application, a Mainframe

application and MOM (Message Services, WebSphere MQ). For AT4 transaction,

MOM will create two documents i.e. one document entry should be the

envelope information and other document entry should be the image. These

two documents will be placed in secured folder

Responsibilities:

. Gathering of requirement, analysis and design, estimate, coding and

testing

. Developed the Windows Service which will poll the Blue2 AT1, AT2, AT3

message transactions in IBM Websphere MQ

. Developed the web application for Blue2 AT4 message transactions.

. Deployment of application in Development/UAT/Production servers and

develop deployment document

. Single point of contact for client

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging, deploying and transitioning the system

to SQA team for release

. Supported this application by fixing complex UAT/Post Production issues

. Developed and maintained the stored procedures which are used by the C#

components for logging purposes

. Involved in code and test plan reviewing of modules

. Developed and maintained the C# components which are used for all modules

in the project

. Met project deadlines and delivery dates committed to client by promptly

working on PCR's (project change requests)

. Lead and guided three team members on the project and reported their

performance to project manager on a regular basis

Environment: Windows Service, C# 2.0, SOAP, XML, XSLT, XPATH, IBM Web

Sphere MQ & MS SQL Server 2005.

BX Mainframe Bypass- Unable to Respond - Senior Developer

June 2007 - Sep 2007

Description: To avoid the drop in index, a process through the BizTalk

application that would automatically send back an 'Unable to Respond'

message to BX. (Blue Exchange). This project request is requiring

enhancements to the process previously built. There are three major

components being requested in this release:

. Process automatically determines mainframe inaccessibility and triggers

the responses

. 278 transaction is included in the response mappings

. 270 and 276 responses are enhanced to avoid compliancy errors

Responsibilities:

. Single point of contact for client

. Creation of Maps using BizTalk Mapper tool with the help of various

Factoids

. Developed and maintained the stored procedures which are used by the C#

components for logging purposes

. Involved in code and test plan reviewing of modules

. Developed and maintained the C# components which are used for all modules

in the project

. Created windows service which ping the Mainframe to check availability

. Lead and guided two team members on the project and updated project

manager about the project progress.

Environment: C# 2.0, XML, Windows Service, BizTalk Server 2004 & MS SQL

Server 2005.

Informatics Dashboard for IA and IP - Senior Developer / Module Lead

Apr 2007 - June 2007

Description: : This project is a web based tracking system for the

different slices received by the Impact Analysis (IA) and Impact Pro (IP)

System from different Enterprise Data Warehouse (EDW) on a monthly basis.

Informatics IA Dashboard and IP Dashboard are two web applications for each

IA and IP will track all slice status which loaded based up on month. Slice

status as Staging-Completed, Staging-In Progress, Pre Staging Completed,

Pre Staging In progress, Ready To Pull, Not Ready To Pull and Error Slices.

These web application uses informatics web service which will give the

status of data. These web applications use web service behavior.

Responsibilities:

. Gathering of requirement, analysis and design, estimate, coding and

testing

. Single point of contact for the client

. Worked as a key member of the team involved in studying change requests

and involved in client interactions

. Member of the team responsible for packaging, deploying and handing over

the system to SQA team for release

. Supported this application and fixing complex UAT/Post Production issues

Environment: VS 2003,ASP.NET 2.0, Web service behavior (Microsoft HTC

component used), C#, XML Web Services, JavaScript, IIS,SQL server 2000,

SQL server 2005, SQL XML, PL SQL, Windows XP

MPD Dashboard - Senior Developer / Module Leader

Jan 2007 - Mar 2007

Description: MPD is a data warehouse. It feeds data to applications such as

UCSW, MOM, Member Portal and Provider Portal. MPD Dashboard is a web

application will track all files status which loaded based up on date. File

status as completed, staging in progress, loading in progress, error, files

which are not received. This web application uses web service behavior.

Responsibilities:

. Gathering of Requirement, Analysis and Design, Estimate, Coding and

Testing

. Point of contact with client on daily basis about project related queries

. Worked as a key member of the team involved in studying change requests

and involved in client interactions

. Member of the team responsible for packaging, deploying and handing over

the system to SQA team for release

. Supported this application and fixing complex UAT/Post Production issues

Environment: VS 2003, ASP.NET 1.1, Web service behavior (Microsoft HTC

component used), C#, XML Web Services, JavaScript, IIS, SQL server 2000,

SQL XML, PL SQL, Windows XP

Brand Uncoupling - Developer and Tester

Sep 2006 - Dec 2006

Description: MOM Member Branding Function determines the brand of every

enrolled Product of a Member, then based on all Product Brands of the

Member further determines the Brand for the Member.

Responsibilities:

. Gathering of requirement, analysis and design, coding and Testing

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging, deploying and transitioning the system

to SQA team for release

Environment: VS 2003, C#, XML Web Services, SQL server 2000, Windows XP

XML Web services with MOM Architecture - Developer and Tester

June 2006 - Sep 2006

Description: MOM (Message Oriented Middleware) framework/environment will

provide business services to its Clients by retrieving data from the source

systems.

The preferred transport sub-systems for these business services will be MQ

and Web Services. MOM will receive request messages from its clients and

respond to them via response messages. The preferred format for the request

and response messages will be XML. Special consideration will be made to

those clients that may not be able to send and receive messages in XML

format.

Responsibilities:

. Worked on Claim Payment and Member Enrollment web service message under

MOM framework

. Gathering of requirement, analysis and design, coding and Testing

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging, deploying and transitioning the system

to SQA team for release

Environment: C# 2.0, XML Web Services, SQL server 2000, Windows XP

CPA Alert Monitor - Senior Developer

March 2006 - May 2006

Description:

In order to determine system health and file transfer processing has

occurred and is error-free, there exists a need for a proactive system

monitor of the CPA application. CPA Alert Monitor should be able to

determine thresholds for file receipt of files and the status of file

processing.

Responsibilities:

. Gathering of requirement, analysis and design, coding and Testing

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging, deploying and transitioning the system

to SQA team for release

Environment: VS 2003, C# 1.1, SQL server 2000, Windows Service, ASP.NET

1.1, JavaScript, IIS, Windows XP

PDS Health Inc., FL with VCS, Bangalore

Medical Records (www.mdmonitor.com) - Senior Developer

Sep 2005 - Feb 2006

Description:

MD Facta is an online Medical Portal for managing medical records by

providers. Users are Patient, and Provider. Providing Shopping Carts for

Medical Products

Responsibilities:

. Gathering of requirement, analysis and design, coding and Testing

. Developed the reusable components in C# which can be used to implement

new web services

. Single point of contact for client

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging, deploying and transitioning the system

to SQA team for release

Environment: ASP.NET 1.1, C# 1.1, VB.NET 1.1, JavaScript, IIS, SQL server

2000, PL/SQL, Windows 2000

Discussion Forum (www.mdmonitor.com) - Senior Developer

July 2005 - Sep 2005

Description: This is one of the features of mdmonitor project. Discussion

Forum is online discussion tool with independence of database

o Viewing of Different Forums, Post Thread, Reply Thread, Rating of

Thread

o Reusable Component for Any ASP.NET application

o Three tier architecture - Generic Data Layer, Business Logic

Layer, Presentation Layer

Responsibilities:

. Gathering of requirement, analysis and design, coding and Testing

. Single point of contact for client

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging and deploying system

Environment: ASP.NET 1.1, C# 1.1, JavaScript, IIS, SQL server 2000, MS

Access, Oracle, Windows 2000

Value Provider Inc., Titusville, FL with Visual Consultancy Services,

Bangalore

HME Container (http://www.valueprovidersinc.com) - Senior Developer

Apr 2005 - June 2005

Description:

HME Container is web based shopping cart for Medical Products.

. Drag and Drop of product images in to container

. Drag and Drop of product images into recycle bin (part of screen

region) when customer no need for different products

Responsibilities:

. Gathering of requirement, analysis and design, coding and testing

. Single point of contact for client

. Played a key role by involving in a study about change requests and by

involving in all client interactions

. Been a active part of packaging and deploying system

Environment: ASP 3.0, JavaScript, HTML, DHTML, MS Access, Windows 2000, IIS

Centrex BPO Data Services Pvt. Ltd., Bangalore with Plexian Software

Solutions

Data Manager and Conversion - Trainee Developer / Developer

Jan 2004 - Mar 2005

Responsibilities:

. Coding and Testing

. Single point of contact for client

. Supported this application by fixing complex UAT/Post Production issues

Environment: Windows forms, VB 6.0, VB.NET 1.1, Win32 API, Oracle 8i,

Windows 2000

ACEDEMIC

. Post graduate - Master of Computer Applications (GPA 8.0/10.0)

. Graduate - Bachelor of Science in Computers (GPA 7.6/10.0)

CERTIFICATIONS

. Brain bench certifications in ASP.NET (Master), C# (Proficient) and

XML (Proficient) on 02/29/2008, which are conducted thru Tek System.

. QMS Certification on 08/09/2006

. IBM Rational Portfolio Manager for project team members (PM48)

certification on 07/12/2006

. HIPPA IBM certification on 08/09/2007

. IBM Certificate on SOA and Web Services Security for Developers dated

on 09/23/2006

. WN 1051 IBM Web Sphere MQ Essentials System Administration

Certification on 06/16/2007

. Advanced ASP.NET Topics (117772) Certification on 11/04/2006

. EMT - 110 - Web Services in an On Demand World (LTU5538F) and .NET

Remoting in C# (SS130092) Certifications on 09/23/2006

[pic] [pic] [pic]

Contact this candidate