.Net Developer Sql Server Business Oracle Development

SRAVAN MATTEVADA

******.***@*****.*** 806-***-****

SUMMARY:

• 6 plus years of industry experience in design, development and deployment, implementation

and testing of various multi-tier web applications using Microsoft Tools and Technologies like

ASP.NET, C#.NET, VB.NET, SQL2000/2005.

• Extensive experience in working with .NET Framework 2.0/3.0 and developing web

applications.

• Strong knowledge about the Object Oriented Programming (OOP) concept and languages like

C#, VB.NET, JavaScript, C++.

• Good knowledge in Data Base development and expertise in writing stored procedures, triggers,

and views in SQL Server 2000/2005 and Oracle.

• Extensively worked with RDBMS using ADO.NET, ODBC, and OLEDB.

• Experience in database designing & developing databases using Oracle 8i, SQL Server,

DB2, Sybase.

• Expertise in working with XML, Web Services and AJAX.

• Extensive Knowledge in Design and Development of User Interfaces using HTML, DHTML,

CSS, XML, XSLT.

• Hands on Experience with Design Patterns.

• Good working knowledge on WPF and Silverlight.

• Excellent Technology Absorption Capability ranging from Web and Client/Server applications.

Well versed with Back end, Middle tier, front end and GUI Development.

• Working knowledge of IIS, Windows NT / 2000/ XP.

• Experienced in Unit, System and User Acceptance testing.

• Excellent communication and interpersonal skills.

• Proven ability to Define, Measure, Analyze, Control processes involved in project

development

TECHNICAL SKILLS:

Web Technologies ASP.NET 2.0/1.1, ADO.NET,AJAX, XAML

Languages C#, VB.NET, C++, C, java

Web Development JavaScript, VBScript, HTML, XML, CSS, XSL-XSLT, Silverlight.

Databases SQL Server 2005/2000, Oracle 9i/8i, DB2, Sybase

Architectures Client/Server, MVC architecture.

Development Tools Visual Studio/2003/2005, FrontPage.

Tools and Technologies Design Patterns, IIS (5.0/6.0), CVS, SVN, Rational Rose.

SQL Reporting Services (SSRS), Crystal Reports.

Reporting Tools

PROFESSIONAL EXPERIENCE:

Archer Daniels Midland & Co, Decatur, IL Aug’08 –July’09

Role: .NET Developer

Archer Daniels Midland & Co is a manufacturing company which transforms crops into food

ingredients and agriculturally derived fuels. My role was to work with a team on ongoing

internet and intranet projects such as RailBiling, Freight Tender Loading, Make Your Mark etc

in ASP.NET using and C# and VB.NET. Oracle 9i, IBM DB2, and Sybase were used as backend

databases. Team Foundation Server was used to enable team development integration and

version control.

Responsibilities:

• Gather and analyze requirements from business analysts.

• Followed UML based methods using Rational Rose to develop use cases and activity diagrams.

• Develop web pages, stored procedures and functions.

• Designed high end graphic applications using Silverlight.

• Used JQuery to dynamically load user controls.

• Make additions and modifications to existing web pages and business logic.

• Identify and correct errors and problems in the currently running applications.

• Collaborate with teammates to work on potential problems in projects and possible solutions.

• Provide technical support to other team members in developing applications.

• Provide production support to the applications (ASP, ASP.Net 1.1-2.0-3.0) on ADM intranet.

• Wrote Stored Procedures in IBM DB2 and retrieved data from multiple databases (SYBASE, MS

SQL) to process and display.

• Improved the performance of existing applications by fine tuning the stored procedures and

queries.

Environment: Visual Studio .NET, C#, VB.NET, Web Forms, Silverlight, JavaScript, Oracle 9i, IBM

DB2, Sybase, SQL Server Reporting Services (SSRS), Rational Rose.

Ashley Polymers Inc, Brooklyn, NY Oct’07 – July’08

Role: .NET Developer

Ashley Polymers Inc is a manufacturing facility for resins. The key responsibilities involved were

developing key components for the Unified Case Management Tool. There were several tools to be

developed as per the requirements of the client. Some of the tools developed were a Time Management

Tool which would help the supervisors to keep track of all the workers and their efforts, Development of

a Search Tool that allow the users to search through and know about all the on-going projects in the

company and the personnel involved in it. Also developed was a reporting tool to keep track of changes

using the SQL Server for audit purpose.

Responsibilities:

• Interacted with business analysts for gathering and analyzing requirements from users of various

departments.

• Designed and developed the Web Pages using ASP.NET, C# and Visual Studio .NET 2005.

• Prepared business process models and used Visio to create use case diagrams.

• Implemented a custom calendar control for use in the Time management tool.

• Extensive use of Cascading Style Sheets to maintain the uniformity across application and

minimum cost style change in future.

• Contribution in developing XML documents for data transmission and used SOAP protocol to

transfer message.

• Validation controls were used in every screen to take care of design phase error recognition.

• Worked with SharePoint Server to keep track of multiplying documents and their locations in a

central site.

• Used stored procedures, Triggers and views for data manipulation.

• Used SQL Reporting Services tool for report generation.

Environment: ASP.NET, C#, VB.NET, AJAX, ADO.NET, Visual Studio.NET, HTML, JavaScript,

VBScript, Web Services, SQL Server Reporting Services (SSRS), SharePoint Server 3.0, Oracle 8i,

IIS, NET Framework 2.0.

Sheffield Financial, Clemmons, NC Dec ’06 – Sep ’07

Role: .NET Developer

Sheffield Financial LLC offers the simplest, quickest, and easiest retail finance program. Sheffield

Financial finances most major name brand equipment, and offers an innovative variety of promotional

choices. Sheffield is headquartered in North Carolina and has an extensive independent dealer base

throughout the U.S. Dealer suite helps dealers to register and enter their selling products. Borrowers can

enter credit applications and equipments to which they want to take the finance.

Responsibilities:

• Interacted with user to analyze and gathered the business requirements.

• Designed the application in three-tier architecture. Data access and business rules were

developed as class libraries.

• Created a template which allows user to select products.

• Used ADO.NET objects to open the connection to read the databases.

• Used DataSets to work with multiple databases in memory and offline.

• User Controls are used to handle reusability of UI components.

• Enhanced the scripts using inheritance and multiple Interfaces.

• Used SharePoint to collaborate, facilitate a meeting, and organize the team's content and ideas.

• Involved in testing the performance of the API’s using XML simulator.

Environment: VB.NET, ASP.NET 2.0, Visual Studio.NET 2005, SQL Server 2005, SharePoint Server,

ADO.NET.

UniCare Health Insurance, Chicago, IL May ’05 – Nov ’06

Role: .NET Developer

Unicare is using an intranet site to request for a report, which is accessed by all departments. An

Automated Renewal Process (ARP) was developed for maintaining the request of annual consultation

report. ASP – SQL Server interface was developed to receive the user inputs for a request of report, and

an interface to authorize the same. Also the request of report is created in editable mode to facilitate

saving as draft and submitting it at a later time. Request Form and Status Forms were created for the

Employers whose renewals are processed through ARP can renew their current plan or choose any

available plan, included in the package.

Responsibilities:

• Developed Web Forms, custom controls for header and footer, standardize menus.

• Provide technical leadership and expertise over the design and development of system.

• Implemented the Middle tier and Business logic using VB.NET and ADO.NET, Java script.

• Encryption and decryption of passwords for security.

• Involved in Design, Coding and Testing the Transaction and Reports Module.

• Responsible for developing Business and Data components in VB.NET.

• Wrote Stored-procedures and queries using SQL and T-SQL to retrieve the data that satisfy the

business needs.

• Worked extensively on Win forms for designing the UI.

• Coding of Work Orders, Enhancements and Defects.

• Used various data control and display elements like DataGrids, DataSets, DataViews and Data

Adaptors to extract data from the backend.

• Interacting with client and answering most of the technical queries and implementing the valid

observations given by the client for this application.

• Giving work status reports to the audit team periodically.

Environment: VB.NET, ADO.NET, .NET Framework 1.1, VB.NET, Visual Studio .NET, SQL Server

2000, IIS, HTML, XML.

LPL Financial, San Diego, CA Jul ’04 – Apr ‘05

Role: .NET Developer

Designed and developed Vision point Payroll project. The objectives of Payroll are maintaining the

complete information of the employee. In this project highly flexible options let you pay both hourly and

salaried employees weekly, fortnightly or monthly across multiple departments. You can use Vision Point

Payroll to produce cheques, payslips, and statutory payment and Bank transfers, to any bank in the

automated clearing-house system.

Responsibilities:

• Interacted with business analysts for gathering and analyzing requirements.

• Involved in Win Forms Design and Coding in Visual Studio.

• Design, Development of WIN Forms using VB.NET.

• Used ADO.NET to connect to the Oracle database.

• Extensively used Dataset and Data Reader to transfer Data between the Client and Server.

• Created Tables, Indexes, Stored Procedures, Triggers, and Views in Oracle.

• Involved in taking Backups, Restoring, Import/Export data using Oracle.

• Involved in developing reports using Crystal Reports.

• Developed help files and user manuals.

Environment: C#, ADO.NET, Visual Studio.NET 2003, .NET Framework1.1, Oracle 8i, Windows XP.

Milestone Consultants, Austin, Texas May ’03 – Jun ’04

Role: Software Developer.

RMB (RunMyBiz) is a dynamic on-demand integrated business application, designed specifically to

meet client business needs. With the robust capabilities of this easy-to-use hosted application, you can cut

your expenses and business risks and enhance your productivity and operational accuracy. Run your

entire business efficiently with this simple, reliable and cohesive system at one end.

Responsibilities:

• Developed WinForms for addition, deletion and modification of employees’ information which

also included facility of handling security rights of employees on the RMB portal.

• Designed and developed WinForms for handling timesheets and expense reports with a facility

for approving managers to view and approve reports accordingly.

• Developed invoices module which included scope for online payment.

• Developed Administration module which have facility of overall management of the portal.

• Created Database objects like Tables, stored procedures, views in Sql Server 2000.

• Developed WebForms for user interaction and input validation was performed by using client-

side validators provided by ASP.NET.

Environment: Visual Studio .NET, VB.NET, XML, VSS, WebForms, Windows XP, JavaScript, HTML,

VB Script, SQL Server 2000.

Standard Mutual Insurance Company, Springfield, IL Jan’03 – May’03

Role: Application Developer

Standard Mutual is a multiple line company writing insurance exclusively through professional

independent agents, in the states of Illinois and Indiana. My role was to provide production support for

the company’s website and develop additional pages. New application forms had to be developed and

processed according to the company policies.

Responsibilities:

• Gathering and analyzing requirements from business analysts.

• Develop pages and make additions and modifications to WebPages.

• Providing production support to the currently running website.

Environment: Visual Studio .NET, VB.NET, Web Forms, AJAX, JavaScript, HTML, SQL Server 2000,

Asppdf, Windows XP.

EDUCATION:

Bachelors in Computer Science, Jawaharlal Nehru Technological University, Hyderabad, India

Contact this candidate