Developer Sql Server Java Project .Net Development

*Name : Sarada Ayyagari

Email: **********@*****.**.**

SUMMARY:

Ø More than eight years of software Industry experience at performing Requirement analysis,

design, development, testing, implementation and maintenance of business applications in

client/server technology

Ø Experience in test planning, test execution, reviewing and documentation

Ø Experience in various roles: as Senior Consultant, Onsite Coordinator, Developer, Designer

and Tester

Ø Extensive experience on Microsoft Visual Studio.Net technologies, VB.Net, C #, Visual

Basic 6.0, COM, VBA, ASP.Net, AJAX, ADO.Net, ASP, VB Script, XML, XPATH, XSLT, XSD,

WML, WML Script, HTML, CSS, IIS, JAVA, JAVA Servlets, Java Script

Ø Experience in MS SQL Server, Oracle, MS Access, Crystal Reports and RDBMS database

concepts, Stored Procedures and Triggers.

Ø Experience in complete Software Development Life cycle(SDLC), object oriented programming

(OOPS), Development and Testing methodologies in OOAD & UML

Ø Excellent analytical, problem solving, interpersonal and communication skills, enthusiasm for

learning, good team player

Ø Work experience in big MNCs : Wipro Technologies ( leading software services company (SEI

CMM level 5 ), StateStreet, ABB, Sony Ericsson . Work experience at onsite customer

locations.

Ø Experience in various Industries like Financial (Banking &Securities ), Manufacturing,

Utilities, Corporate, Electronics, Automotive, Embedded Systems

Ø Microsoft Certified Application Developer(MCAD)

TECHNICAL SKILLS:

Technology Tools

Databases MS Access, MS SQL Server 20005/2000/7, Oracle

7.x, Oracle 8i. Lodestar, ObjectStore, Mysql

Development/Productivity/ Reporting MS Office, Visual Basic, Visual Studio.NET, Business

Tools Objects, Crystal Reports

E-Com Frameworks/Web Technologies ASP, ASP.NET(1.1, 2.0),CSS, IIS, Apache

webserver, Java Servlets, JavaScript

Functional Areas Customer Relationship Management, Finance,

Knowledge Management, Process Automation

Network/Telecom/RT/Systems Software WAP

Programming Languages C#, VB.NET, Java, HTML,WML, XML

Software Engineering .NET Framework, CVS, MS Visio, MS Visual

Methodologies/Tools/Technologies SourceSafe, Rational Rose

TECH INF SERVICES SKILLS Citrix Secure Gateway

PROFESSIONAL EXPERIENCE:

ParTech Inc, Lake Orion, MI April 08 to till date

Role: Developer

ParTech’s vehicle Diagnostics system for ISUZU Motors.

Responsibilities:

Involved in analysis, design and development of Vehicle Communication and diagnostics software

for various OEMs.

I

Environment :Viisual Studio 2008, VB .Net, XML, SQL SERVER 2005, VB 6, MS Access, SQL Server 2005,

Mysql, Windows XP, Communication protocols, Interface systems.

Company (Confidential) TROY, MI March 08

Role: Developer

An automotive parts supplier company required a system for it’s clients to electronically login and view the

invoices and statements online.

Responsibilities:

Involved in making additional features like Future Invoices, yearly staements, etc to the exisitng

website.

Involved in developing strongly typed datasets in C#.

Developed complex SQL queries, Stored Procedures .

Involved in unit testing.

Started the demo build phase of the initial project setup.

Environment :Viisual Studio 2005, C# .Net, XML, ADO.NET, Oracle 9i, SQL Server 2005, Windows XP

Statestreet, Boston (USA) & Munich (Germany) Oct 06 to Sept 07

Role: Onsite Coordinator& Developer

Local Language Translation Tool

Statestreet Securities Bank required a System to provide translation of Corporate Action Notifications into

local language(German) for the local customers.

Responsibilities:

Involved in the complete life cycle of the project.

Involved in gathering requirements, interacting with the Business Application users.

Designed Specification documents according to client standards that are used by other team

members for development of the project and coding.

Designed functional UML diagrams using MS Visio.

Designed UI,Windows forms with VB code

Designed Class library which will interact with database

Designed various methods which are implemented at different stages of the project

Designed classes that interact with RightFax components.

Extensively used Object Oriented development methodology using VB.

Designed database tables, complex SQL queries, Stored Procedures .

Involved in unit testing and UAT and Review of the project.

Started the build phase of the initial project setup on Citrix Server.

Involved in successfully implementing the system and troubleshooting.

Trained end users on Application usage.

Environment :Visual Basic.Net, XML, ADO.NET, SQL Server 2005, Component One, Right Fax,MS Visio,

Citrix Secure Gateway, Windows XP

Statestreet, Munich (Germany) June 05 to Sept 0 6

Role: Consultant

Reports Development for StateStreet Client Information Services Group

Cash Activity Reports are developed for the Client Information Services Group of State Street Corporate. The

reports read data from the database files which are created using data from MCH main frame database and

display the business logic calculation.

Responsibilities:

Involved in analysis of Business Logic, Data and Requirement Specification

Involved in developing complex business logic calculations, queries for data retrieval from the

database files.

Designed and developed reports according to the requirements.

Designed Test cases and Testing and review of reports at Client's location.

Environment : Crystal Reports,MS Access, DB2, Windows 2000.

Statestreet, Munich (Germany) Jan 05 to June 0 5

Role: Consultant

StateStreet Database migration and enhancement of existing applications

The Project involved in making enhancements to the several existing applications and Database migration

from SQL Server 7 to SQL Server 2000 that required to test Sataestreet Financial applications that run

based on the back end.

Responsibilities:

Worked with a Team for Analyze, design and implementation of Applications

Prepared and reviewed the design documents

Designed web pages in ASP.NET with VB and C# code-behind

Worked with different ASP.NET controls

Worked on modules that deal with the asset management and the configuration management.

Developed JavaScript functions to handle from Client-Side validations

Created tables, Indexes, Views and Triggers

Improved the Application performance using stored procedures

Developed Unit test cases,. Involved in Testing and UAT along with Business Application Users.

Environment :Visual Basic.NET, VB 6.0, C #, ASP.NET, ADO.NET, MS SQL Server 7, 2000 . Windows

2000.

AVACON, Helmstedt (Germany) Jan0 4 to Jan 0 5

Role: Consultant

Energy Management System

Avacon, which supplies Utilities like Electricity, Gas and water, required a system for efficient utility Billing

and accurate Planning processes. The system contains two different modules, Pricing and Forecasting. The

pricing module optimizes consumers to Avacon billing process, and the forecasting delivers revenue & cost

planning based on historical records, current pricing policies and market demands.

Responsibilities

Involved in the complete development of the Forecasting module.

Involved in gathering requirements, interacting with the Business Application users.

Involved in System Specification documents for design and development

Designed functional UML diagrams using MS Visio.

Designed UI,Windows forms with VB and VBA Excel code

Designed Class library which will interact with database

Extensively used Object Oriented development methodology using VB.

Designed database tables, complex SQL queries.

Involved in unit testing and UAT and Review of the project.

Environment: Visual Basic.Net, XML, VBA Excel, Lodestar, Windows XP, MS Visio

ABB, Ladenberg (Germany) Jan0 3 to Oct 0 3

Role: Consultant

Real-Time Manufacturing Execution System

Discrete manufacturing process execution and enhancement using IT systems that link real-time production

data with ERP (SAP) systems. This system was based on ABB's Industrial IT platform with hardware

(sensors) to measure & monitor real-time manufacturing process & product quality.

The software solution is based on .NET and implemented on ABB Industrial IT architecture. It included web-

browser (thin client) based user interface for production status, assistance to assembly workers on the line,

and product quality reporting. The solution also interfaces to SAP to manage resource at real-time for order-

to-delivery manufacturing.

Responsibilities:

Designed Class library which will interact with ABB Industrial IT Database

Designed web pages in ASP.NET

Designed and implemented Win Services, which update the workshop data periodically.

Worked with various controls like List View, Data Grid View, List Box and Tab Controls to display the

product related information.

Performed Shop floor transactions

Designed libraries in C# code

Involved in unit testing of the project.

Environment: C# .Net, ASP.Net, Microsoft Office, interface to ABB Industrial IT platform, Windows 2000.

ABB, Ladenberg (Germany) Sept 02 to Dec 02

Role: Consultant

Patent Monitoring Tool

Patent Monitoring Tool is a competitive intelligence system that monitors patent activities in a specific

product or technology area. ABB uses it to analyze competitors patents and their technology activities. In this

project, we have developed a web-based access to setup patent monitoring, download of patents and

analysis for competitive benchmarking. The functionality of the tool includes a monthly dynamic download of

public patent documents based on a predefined search profile consisting of keywords and IPC classes.

Responsibilities:

Involved in development of Classes in Java and Java servelts.

Designed web pages using HTML, Java script and and modified UI.

Crated Indexes, views Triggers in ORACLE database

Extended search engines s functionality with additional search options like multiple keywords.

Involved in Test case preparation and Testing the tool.

Provided documentation.

Environment: JAVA, Java servlets, Java Script, HTML, Oracle 8i, TOAD, Apache webserver, Windows 2000

ABB, Ladenberg (Germany) May 02 to Dec0 2

Role: Developer

Industrial IT For ABB OEM Customers

ABB is supplier for various OEM customers, who design, sell and maintain their own products to end

customers. The OEMs require from ABB not only the products but also product information and service

support. This project is an implementation of electronic delivery of product information using ABB Industrial

IT platform, design tools for collaborative engineering, and XML based web-interaction for service support for

one OEM.

The four modules in this project are 1. Equipment Register (Installed Base Inventory): This is a database for

registering all components delivered to the OEM. 2. Transfer of Product Information: Web-based transfer of

all product information. 3. Fault Notification & Service Handling: XML based reporting of breakdowns and

service support. 4. Co- engineering: Integrated ABB design tools for product selection, configuration and

ordering by the OEM

Responsibilities:

Involved in complete development of all the four modules of the project

Designed and developed VB COM Components

Designed webpages in ASP.

Created tables and performed SQL queries

Designed project document specifications

Involved in Testing and implementation and in build set up on the server

Environment: Visual Basic 6.0, ASP, XML, IIS, MS Access 2000, Windows 2000

Wipro, Chennai (India) June 01 to April 02

Role: Project Engineer

TAMTAM User GUI Tool

Alcatel modular test approach for mixed signal communications needed interface & test methods for IC chips and

circuitry.

Responsibilities:

Involved in project design documentation

Designed functional flow diagrams using Rational Rose

Developed class library in JAVA and JNI

Designed User Interface screens using JAVA SWING

Involved on Unit testing and Integration Testing.

Involved in implementing the tool on Solaris server

Environment: JAVA, Java Swing, JNI, C++, Object Store, Solaris, Rational Rose, WINDOWS 2000

SonyEricsson, Munich (Germany) & Chennai (India) June 00 to June 01

Role: System Engineer

WAP Testing on SONY Ericsson Mobile phones

Identifying and Developing test cases for testing the software developed for Sony Mobile phones. Doing

stability tests on the SONY mobiles by activating supplementary services during a telephonic conversation.

Error logging and generating problem reports for software crashes that occur due to instability in the mobile

software. Also, involved in testing Email functionalities and the Inter Operability Testing of the mobile phone.

Responsibilities:

Involved in evaluation of robustness and reliability using WAP and WML scripts.

Done Testing for different kinds of test suites like Performance, Tag testing, Automated testing, IOT

and Scenario testing on different models of SONY mobile phones.

Involved in coding using WML and WML Script.

Designed new test cases as per the requirement both at onsite Customer location and at offshore

Environment: WAP, WML, WML Script,, Microsoft Office, WINDOWS NT

Wipro, Hyderabad (India) Jan 0 to May 0

Role: Programmer

Job Scheduler monitoring GUI

Fujitsu help-desk needed a system to schedule and track jobs they were receiving.

Responsibilities:

Involved in system documentation

Developed User Interface using JAVA SWING

Designed Test cases and Involved in Unit and Integration Testing

Environment: Java SWING, Java, Windows NT

Wipro, Hyderabad (India) May 9 to Jan 0

Role: Programmer

Integrated Library Automation System (ILAS)

Wipro corporate office in Hyderabad, India, required organization and management of documents in their

library.

Responsibilities:

Involved in Development of different application modules like Admin, Circulation etc.

Developed UI Screens using JAVA Swing

Involved in coding Java, JDBC

Involved in Database design, creating Tables, wrote SQL queries.

Involved in testing and implementation of the application.

Developed spec documents

Environment: Windows 3.1/95/98, Kawa IDE 3.13 for Java, JDBC, Oracle 7.x

Education:

Ø MCA (Master of Computer Applications) from Berhampur University, India.

Ø B.Sc (Bachelor of Science) from Andhra University, India.

Contact this candidate