Sridhar Ravva
Contact Information :*************@*******.***
Cell No. : 901-***-****
Career Summary
Solutions-Oriented .Net Developer with over 8 years of experience in Systems Analysis, Design, Development, Testing and Maintenance of various projects including Web and Client/Server Application development using Microsoft .NET Framework 1.0/1.1/2.0/3.5, C#.NET, VB.NET, ASP.NET, Visual Basic 6.0. Proven experience in Complete Software Development Life Cycle models like WaterFall, RAD etc from conception to implementation. Driven by a passion for designing scalable systems and continued challenge of adapting to emerging technologies. Ability to function well within a team environment complemented by excellent writing and communication skills.
• Expertise in analysis, Object Oriented Design, UML, Business Process Flows, development, deployment, testing, implementation of Web applications and Windows Forms applications using C#.NET, VB.NET and Visual Basic 6.0.
• Extensive Experience in leading the architecture and development of cutting - edge multi-tier large scale Distributed Systems and Enterprise Applications in Windows Forms, C#.NET, ASP.NET, WCF and Windows Services.
• Extensively worked on .NET Framework 1.0/1.1/2.0/3.5 in various source safe controls like Visual Source Safe.NET 2003/2005 and Team Foundation Server.
• Extensively worked on C#.NET, ASP.NET, VB.NET, WCF, ADO.NET, Ajax, SQL Server 2000/2005, Oracle 8.0/9i, XML, UML and SOAP.
• Expertise in developing Client/Server Applications and Web Applications on n-Tier Architecture for multiple users.
• Extensive experience on backend programming on SQL Server 2000/2005, Oracle 9i/8 database.
• Experience in developing Functional Specification documents, Tests Plan, Test data, Use Cases, UML, State, Sequence and Class diagrams.
• Expertise in deploying and testing web applications on IIS and SharePoint Server 2003/2007.
• Designed and integrated various custom reports in several projects using Crystal Reports, SQL Server 2000/2005 Reporting Services and also using Visual Studio.NET 2003/2005 Reporting Services.
• Extensive experience on various distributed and enterprise applications using BizTalk Server 2004/2006.
• Good understanding of various domains/industries such as Hotels, Health Care, Claims/Medicare/Medicaid, CRM, ERP, E-Commerce, Insurance, Banking, Sales and Inventory, Billing, Warehouse Management, Stock Exchange and Financial.
• Excellent interpersonal ability and a very good team leader with good communication Skills. Out-standing problem solving, ability to work under pressure, decision making skills and fast learning and grasping capability of new emerging technology.
Educational Qualification
Bachelor of Engineering, majors in Computer Science.
Microsoft Certified
Microsoft Certified Solution Developer (MCSD.NET)
Microsoft Certified Application Developer (MCAD.NET)
Microsoft Certified Professional (MCP.NET)
Skill Set
Languages .NET Framework 1.0/1.1/2.0/3.5, C#.NET, VB.NET, ASP.NET,
ADO.NET, WCF, VSS.NET 2003/2005, BizTalk Server
2004/2006, SharePoint Server 2003/2007, Team Foundation
Server 2005/2008, Ajax, HTML, Front Page, XML, UML, Java
Script, VB Script, Microsoft Visio, TOAD, Visual Basic 6.0,
ASP, C, C++, Basic, FORTRAN, Pascal, COBOL, UNIX (As a
part of Engineering Curriculum).
Reporting Tools Crystal Reports 8.5/9.0/10, SQL Server 2000/2005 Reporting
Services, Visual Studio.NET 2003/2005 Reporting Services.
IDE Visual Studio.NET 2002/2003/2005/2008, Visual Studio 6.0.
Platforms/OS Windows 9x, Windows XP Service Pack 2, Windows 2000,
Windows 2003 Server, DOS, UNIX.
DBMS/RDBMS SQL Server 2000/2005, Oracle 8.0/9i, DB2,
Informix, Ms - Access 2000.
Assembly Language 8085, 8086/8088 families, 80386 DX.
Others MS-Office 2000/XP, Lotus 1-2-3.
Work Experience
Company : International Consulting Partners (ICP)
Client : Hilton Hotels Corporation, Memphis, TN
Project : Property Management System (PMS)
Title : Sr.NET Developer (Nov 2006 – Present)
OnQ PMS (OnQ Property Management System) have modules designed to insure the smooth operation of the hotel property in the areas of hotel management, reservations, hospitality, guest accounts, house accounts, groups, accounts receivable, history and reporting. Hilton properties utilize the OnQ System for daily property management.
Job Responsibilities:
• Involved in Requirements Gathering, Object Oriented Analysis and Design and development of the application.
• Developed flexible, more user interactive and user-friendly GUI’s and Dynamic Web Pages, reusable classes, functions, etc using ASP.NET 3.5 in C#.NET 3.5.
• Created Component Design, prototyped the necessary Business and Data layer Components in C#.NET 3.5.
• Implemented new functionalities in the User Interface and Application logic using C#, ASP.NET and JavaScript.
• Designed and Developed various reusable user controls and custom controls for the project using C#.NET 3.5 in .NET Framework 3.5.
• All User Interface layers web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.Net User Controls, Web Server Controls, ADO.Net using MS SQL Server 2005.
• Business objects were programmed in VB.NET in .NET Framework 3.5.
• Worked directly with the Business Analysts and Team Leads of the system to identify the Business and Functional requirements, business processes, rules and application user requirements.
• Responsible for Developing and Integrating applications using BizTalk Server 2006.
• Developed web applications using Web parts and deployed it on SharePoint Server 2007 in multiple environments (development, testing and production).
• Migrated SharePoint sites from test server to production.
• Developed solution to automate the property reservation creation/publication process using SharePoint 2007 and C#.NET 3.5.
• Customized SharePoint 2007 site for PMS including custom lists, web parts, themes and site templates.
• Created and Maintained various T-SQL Queries, Complex and heavy Stored procedures, triggers, functions, views, indexes, cursors on MS SQL Server 2005 to handle all kinds of transactions in the database. Strong in building nested queries, testing and debugging SQL related problems.
• Extensively used XML and dataset for accessing data from SQL Server 2005 database.
• Developed Web Services for authentication and authorization based on OnQ system.
• Designed, Tested and Integrated various custom reports into the system based on the business requirements using Crystal Reports 10 and SQL Server 2005 Reporting Services.
• Used JavaScript for client-side validations.
• Used Mercury Quality Center in order to work on the defects and production support issues of application and web based modules.
• Used UML for data modeling, VISIO for design and architecture and flow diagrams.
• Designed the several technical documents.
• Performed unit testing, Integration testing, extensive debugging and database design.
Environment: .Net Framework 3.5, C#.NET 3.5, ASP.NET 3.5, ADO.NET 3.5, WCF, BizTalk Server 2006, Sharepoint Server 2007, Team Foundation Server 2008, Ajax, CSS, JavaScript, SQL Server 2005, T-SQL, Crystal Reports 10, SQL Server 2005 Reporting Services, XML, XML Web Services, SOAP, XSL, XSLT, Pentium PC, Windows XP.
Company : Gantec Corporation, IL
Client : Humana Inc., Louisville, KY
Project : Fast App, DBAdmin Tool, Feeds
Title : Sr.NET Developer (July 05 – Oct 06)
Humana provides various individual, medicare, group and medsupp plans like PDP, GPDP, HMO, PPO, FFS, GFFS that offers guidance to help you choose, finance and use your benefits with confidence and success. Humana medical plans, pharmacy plans, and spending accounts are designed to fit every need. Humana offers traditional insurance plus innovative plans like Health Insurance, Dental Insurance, Term Life Insurance that give consumers greater choice and control. With all Humana plans, you have access to personalized guidance to help you choose and use your plan – so you can make the best decisions for your budget and your healthcare needs.
Job Responsibilities:
• Participated in the System Analysis, Design and deployment, Testing and migration to the Production server and maintenance of the Production software applications.
• Designed and developed various .NET Business Objects, .NET Data Access Layer, Data Transfer Objects DTOs and .NET Web Services for various modules of the projects based on the business requirements using ASP.NET 2.0 and C#.NET 2.0 in the Humana UIP Framework.
• Developed various modules such as Plans Listing, Plans Mapping, Plan Details, Plan State County Mapping, Fast App Filter, Fast App Search, Rate Calculator, Member Benefits, Monthly Premium Calculation etc using C#.NET 2.0, ASP.NET 2.0 and AJAX in the Humana UIP Framework.
• Extensively used ADO.NET for Database Operations.
• Created middleware components using VB.NET and C# for accessing Oracle 9i data.
• Used UML for data modeling, VISIO for design and architecture and flow diagrams.
• Responsible for Developing and Integrating applications using BizTalk Server 2006.
• Developed web applications using Web parts and deployed it on SharePoint Server 2003.
• Customized SharePoint 2003 site for FastApp including custom lists, web parts, themes and site templates.
• Created documentation and trained administrators and tech support personnel in SharePoint.
• Used Data Access Block in the various modules of all the projects.
• Designed and Implemented various reusable components, web user controls and web custom controls using C#.NET 2.0 in .NET Framework 2.0.
• Developed Master Pages for all the Projects using C#.NET 2.0 and ASP.NET 2.0.
• Used several AJAX controls in the various modules of the projects.
• Used JavaScript for client-side validations.
• Used XML, XSL and XSLT for representing data to and from the database and also to dynamically bind the data from the database to various controls on the web pages.
• Used Exception handling application block for checking errors/exceptions across the web site using C#.NET 2.0.
• Created, Tested and Integrated various custom reports based on the business requirements using Crystal Reports 10.
• Implemented and Maintained several T-SQL Queries, Complex Stored Procedures, Triggers, Indexes, Views, Cursors and User Defined Functions using SQL Server 2005 and Oracle 9i to handle all kinds of transactions.
• Extensively developed various DTS Packages for Feeds in order to perform validation against data of various tables based on business rules, import/export data from various Tables, insert/update data in the various tables using SQL Server 2000.
• Developed sitemap for the entire web site using ASP.NET 2.0.
• Responsible for production support and testing of application and web based modules.
• Documented and Maintained the relational database design of the Systems using ER Models.
• Documented the complete functionality of the projects like FastApp and DBAdmin Tool in order to provide the full knowledge about the projects to the end user using HTML workshop.
• Involved in extensive debugging and unit testing of the application.
Environment: .Net Framework 2.0, C#.NET 2.0, ASP.NET 2.0, ADO.NET 2.0, BizTalk Server 2006, Sharepoint Server 2003, Team Foundation Server 2005, Ajax, CSS, JavaScript, SQL Server 2005, Oracle 9i, T-SQL, PL/SQL, SQL Server 2000 DTS Packages, Crystal Reports 10, XML, XML Web Services, SOAP, XSL, XSLT, Pentium PC, Windows XP.
Company : Gantec Corporation, IL
Client : Medco Health, NJ
Project : Medco Health Integration Site
Title : Sr.NET Developer (Aug 04 – June 05)
The Medco health and the family-meds integration site allow the customer to order the Rx medicines over the net. This site is redesigned to separate the business logic and the UI functionality. Business logic is implemented in the form of web services. XML plays the role of data carrier between the web services and the UI. The UI calls the web services, which in turn calls the mainframe to get the requested data.
Job Responsibilities:
• Analyzed the specification documents to come up with the design and Object Oriented classes in UML for the modules of the System.
• Deliver requirements documents like System Features, Use Cases, Business Rules, design specification, data modeling, and UML diagrams.
• Developed various modules such as Contact Management, Product Management, Shopping Cart, Order Basket, Order History, Customer Support, Testimonials using C#.NET and ASP.NET.
• Build XML from the data set returned from the stored procedures.
• Business objects were programmed in C#. NET.
• Designed and developed various Web Services based on the business requirements provided for implementing the shopping cart, order processing, Address modules, Payment gateway using C#.NET and ASP.NET.
• Responsible for Developing and Integrating applications using BizTalk Server 2004.
• Implementing custom components using BizTalk Server 2004.
• Developed web applications using Web parts and deployed it on SharePoint Server 2003.
• Created documentation and trained administrators and tech support personnel in SharePoint 2003.
• Developed reusable components using C#.NET in .NET Framework 2.0.
• Used ADO.NET for Database Operations.
• Involved in performance tuning by checking the memory leaks, % Processor Time used and also by using PerfMon, Caching, Multithreading.
• Developed Windows Services for Automatic Mailing System.
• Implemented and Maintained several T-SQL Queries, Stored Procedures, Views, Functions, Indexes, Cursors and Triggers using SQL Server 2005 to handle all kinds of transactions in the database.
• Extensively used DTS Packages in order to import/export various Tables Data using SQL Server 2005.
• Architected the relational database design using ER Models.
• Developed few Dashboards using ASP.NET in order to track the current events/status of various activities that are occurring in the web site and also to provide flexibility in navigating to different sections/modules of the web site.
• Involved in the production support and testing of application and web based modules.
• Integrated and Tested custom reports into the system using Crystal Reports 10.
• Developed sitemap for the entire web site using ASP.NET.
• Involved in the production support and testing of application and web based modules.
• Used JavaScript for client-side validations.
• Documented the various help files using HTML workshop in order to troubleshoot the end user.
• Performed extensive debugging and unit testing of the System.
Environment: .Net Framework 2.0, C#.NET 2.0, ASP.NET 2.0, ADO.NET 2.0, BizTalk Server 2004, SharePoint Server 2003, VSS.NET 2005, Ajax, CSS, JavaScript, SQL Server 2005, T-SQL, SQL Server DTS Packages, Oracle 9i, XML, XML Web Services, SOAP, XSL, Crystal Reports 10, Pentium PC, Windows XP.
Company : Gantec Corporation, IL
Client : Commercial Bank, TN
Project : E-Banking & Debit Card Application
Title : .NET Developer (Nov 03 – July 04)
This assignment involved extending the existing Internet Banking product of BCB and FCIB to support the Debit Cards. The challenge lay in plugging in the new business requirements, which arose as a result of the Banks decision to launch Debit Cards Development, into the e-Banking Application running at the Bank.
Job Responsibilities:
• Involved in the Requirements Gathering, Object Oriented Analysis and Design (UML), Coding, Testing and Implementation of E-Banking and Debit Card System using C#.NET.
• Wrote use cases, sequence diagrams and component diagrams using UML.
• Developed and Maintained various Web Forms and Web Services using C#.NET and ASP.NET.
• Extensively worked with C#.NET and VB.NET for creating classes of this application and Integrated with ASP.NET pages.
• Designed and implemented the solution to integrate front-end and back-end loan processes using BizTalk Server 2004.
• Created SharePoint 2003 site for aggregating information collected in InfoPath forms into a report in Microsoft Word.
• Wrote programs for loading data to XML Files and programs for transforming XML data.
• Used Microsoft Application Center Test Tool 2003 for the performance measurement of the Web Application, for that modified the generated code and made it multithreaded.
• Involved in the performance tuning of the entire web site.
• Wrote business components to access Database using ADO.NET.
• Created and Utilized XML Web Services using C#.NET.
• Developed business objects in C#. NET.
• Implemented and Maintained various T-SQL Queries, Stored Procedures, Views, Indexes, Functions and Triggers to perform automated rules, updating to related tables in SQL Server 2005 along with creating tables, indexes and relations.
• Created various DTS packages in order to import/export data from different sources in SQL Server 2005.
• Developed and Tested various custom reports based on the business and functional requirements using Crystal Reports 9.0.
• Involved in development of front end validations using JavaScript.
• Developed sitemap for the entire web site using ASP.NET.
• Performed unit testing and database design.
Environment: .Net Framework 2.0, VB.NET 2.0, C#.NET 2.0, ASP.NET 2.0, ADO.NET, BizTalk Server 2004, SharePoint Server 2003, VSS.NET 2005, JavaScript, XML, SOAP, XSL, HTML, IIS 4.0, SQL Server 2005, T-SQL, DTS packages, Crystal Reports 10.0, Windows 2000.
Company : Nable Solutions Pvt. Ltd.
Client : SunTrust Bank, Inc., NY
Project : Integrated Account Services System (IACSIS)
Title : .NET Developer (Dec 02 – Sept 03)
The client is one of the nations largest financial institutions offering a diverse product range including banking, credit cards, insurance and wealth management for both individual and corporate clients. IACSIS is a web application meant to be installed on workstations in credit card customer service call centers. It consists of four core modules Disputes, Retention, Adjustments and Credit Insurance, providing an integrated and extensible platform to manage credit card accounts. The Disputes module allows a customer service representative (CSR) to report, document and process credit card dispute cases. Retention allows the CSR to make upgrade or counter-offers to account holders in an attempt to retain their business. Adjustments allows the CSR to forward requests for valid account fee adjustments, that are later either accepted or denied by account specialists. Credit Insurance allows the CSR to make offers and enroll account holders in the Banks optional credit insurance scheme. All four modules function by establishing work cases which are later reviewed and processed.
Job Responsibilities:
• Involved with review and analysis of requirements.
• Involved with database modeling and development of the object model.
• Worked with the team to design and develop the UI of the entire web site in ASP.NET.
• Wrote several web user controls and web custom controls using C#.NET.
• Coded the UI, Business and Data Layers in C#.NET.
• Wrote and consumed XML web services using C#.NET.
• Implemented data access using ADO.NET.
• Involved with database development. Created database tables.
• Created and Maintained T-SQL Queries, Stored Procedures, Views, Functions, Triggers and Cursors using SQL Server 2000 for retrieval and manipulation of data.
• Extensively used DTS Packages in order to import/export various Tables, Data, Stored Procedures, Views, Triggers and Functions using SQL Server 2000.
• Developed several custom reports using Crystal Reports 9.0 based on the various business requirements.
• Performed extensive debugging and unit testing of the System.
Environment: VB.NET, ASP.NET, ADO.NET, VSS.NET 2003, SQL Server 2000, T-SQL, DTS Packages, JavaScript, Crystal Reports 9.0, XML, XML Web Services, XSL, Windows 2000, IIS 5.0.
Company : Nable Solutions Pvt. Ltd.
Project : Sales Management System
Title : .NET Developer (April 02 –Nov 02)
This system is about capturing the user information and their sales opportunities. This includes two sub-systems, one for maintaining the customer data and the other to manage their sales opportunities. The various modules included are the Opportunity module, Interaction module, Sales Planner, KPI, Quotation, and Sync etc. The application is divided into Online and Offline versions. The Offline version will be running in the Sales Users laptop and the online version will be running on the central server. The Sync module takes care of the synchronization of the data.
Job Responsibilities:
• Developed Opportunity, Effort Monitoring, Offline Module, and Quotation modules using C#.NET.
• Involved in Modeling- Created Use Case, Class diagrams and Sequence diagrams using UML.
• Involved in Database design using ER Diagrams.
• Developed scripts for database creation.
• Developed various web forms using C#.NET and ASP.NET.
• Developed various web user controls and web custom controls using C#.NET in order to reduce the duplication of code.
• Integrated several custom reports into the system using Crystal Reports 9.0 based on the business requirements.
• Implemented Caching and Multithreading for improving performance.
• Implemented Role-based security to allow access to the various modules of the application.
• Created and Maintained various T-SQL Queries, Stored Procedures, Views, Indexes, Cursors, Functions and Triggers to perform automated rules, updating to related tables in SQL Server 2000 along with creating tables, indexes and relations.
• Used XML for representing data to and from the database.
• Used Exception handling application block for checking errors/exceptions across the web site using C#.NET.
• Used JavaScript for client-side validations.
• Developed the sitemap for the entire web site using C#.NET and ASP.NET.
• Involved in debugging, defect fixing and testing of the web application.
Environment: .Net Framework 1.1, ASP.NET 1.1, ADO.NET 1.1, C#.NET 1.1, BizTalk Server, VSS.NET 2003, XML, SOAP, SQL Server 2000, T-SQL, DTS Packages, JavaScript, Crystal Reports 9.0, TOAD, UML, Windows, XP Professional.
Company : Nable Solutions Pvt. Ltd.
Project : Extreme and Trapeze Networks
Title : .NET Developer (Nov 01 – April 02)
Extreme and Trapeze Networks has been developed in ASP.NET using C#.NET and VB.NET. The backend are SQL Server 2000 and Oracle. It is purely a web-shopping site. They both have been developed for enhancing the sales and business needs of Extreme and Trapeze Networks through their distributors and channel partners.
These are E-Commerce Sites that sells almost 8,000 manufacturer’s tools and equipments. These applications were developed for them maintains these items and allows users to purchase them over the Internet and keeps records of the items purchased for historical data.
Job Responsibilities:
• Responsibilities include study and analysis of Software Requirement Specification, design, coding, testing, maintenance and documentation.
• Used UML to design Class Diagrams, Sequence Diagrams, Data Flow Diagrams of the project.
• Developed various modules such as Contact Management, Product Management, Item Management, Download Management, Sales Management, Online Training/Onsite Training, Event Scheduling, Purchase Products, Order Basket, Order History in ASP.NET using C#.NET.
• Created and Maintained several T-SQL Queries, Stored Procedures, Views, Indexes, Cursors, Functions and Triggers using SQL Server 2000 and Oracle 8.0 in order to handle all kinds of transactions of distributors and channel partners.
• Extensively implemented DTS Packages in order to import/export various Tables, Data, Stored Procedures, Views, Triggers and Functions using SQL Server 2000.
• Developed Unit Test Plans.
• Wrote and consumed XML web services using VB.NET and C#.NET in order to calculate the purchase details related to payment option selected by the user.
• Also Wrote XML Web Services in order to display the current events such as sales, purchase, most sold out products and wish list containing products using C#.NET.
• Developed various reports based on the customer requirements using Crystal Reports 9.0.
• Developed sitemap for the entire web site using C#.NET.
• Documented the database relational design using ER Models.
• Involved in debugging and unit testing of the System.
Environment: .Net Framework 1.1, C#.NET, VB.NET, ASP.NET, ADO.NET, VSS.NET 2003, CSS, JavaScript, SQL Server 2000, T-SQL, DTS Packages, Oracle 8.0, XML, XML Web Services, SOAP, XSL, Crystal Reports 9, Pentium PC, Windows XP.
Company : Star Computer Systems
Client : HR Mantra
Project : HRM Web
Title : Software Developer in .NET (Sep 00 – Oct 01)
Project Description:
HRM Web has been developed using C#.NET and ASP.NET. The backend databases are SQL Server 2000, Oracle 8.0 and MS Access 2000. It is purely a web based ERP Project. HRM Web handles HR and Payroll related modules. Access to modules and sub options within the project are secured by a password system. HRM Web is a solution that has been developed for all types of companies. It can be upgraded and customized as per the requirements. The Project contains over 300 forms to handle all kinds of transactions.
Job Responsibilities:
• Responsibilities include analyzing, coding, testing and documentation.
• Involved in the development of various modules such as HRD, (human resource development), HRA, (human resource administration), Training Needs Analysis (TNA), Manpower Skills Inventory (MSI) of HRMWeb using ASP.NET and C#.NET.
• Also Involved in the development of modules such as payroll, leave, attendance, salary, perks, Bonus calculation of HRMWeb using ASP.NET and C#.NET.
• Developed various Web based reports of various modules such as HR, Payroll and Accounts based on the customer requirements using Crystal Reports 8.5.
• Developed and maintained majority of web forms in ASP.NET using C#.NET.
• Maintenance of the various masters of HR, Payroll and Accounts modules.
• Created and Maintained various T-SQL Queries, Stored Procedures, User Defined Functions, Views, Index and Triggers using SQL Server 2000 and Oracle 8.0 in order to handle all kinds of transactions.
• Also Implemented various T-SQL Queries, Stored Procedures, User Defined Functions using Oracle 8.0 and MS-Access 2000.
• Developed database design and test plans.
• Wrote and Utilized XML web services using C#.NET.
• Involved in debugging and unit testing of the System.
Environment: C#.NET, ASP.NET, ADO.NET, VSS.NET, SQL Server 2000, T-SQL, Oracle 8.0, MS Access 2000, JavaScript, Crystal Reports 8.5, Pentium PC, Windows 2000/XP.