Venkata Rao All

Venkata Rao Swarna 732-881-9317 

[email protected] 

SUMMARY:

• • • • • • • • • • • • • • • • • •

Around 9 years of progressive technical and functional experience specializing in analysis, design and development of Internet, Intranet, Client Server and Object Oriented applications built on Microsoft related Technologies. Participated in every stage of SDLC. Developed n-tier web applications in .NET environment using VB.NET, C#.NET, WCF, ASP.NET 2.0, ADO.NET, Web services, Windows forms, Web forms, VS.NET 2003/2005, IIS 5/6, SQL server 2000, Crystal Reports 7/9, HTML, CSS, Java Script, XML, XSD, XSLT, XPATH. Expertise in creating Web Forms, Win Forms, User Controls, Custom controls, .Net Framework, Namespaces, Delegates, Reflection. Solid Understanding of WCF, Web Services, SOAP, XML, WSDL. Worked on Crystal reports 7.0/9.0 versions and reporting services for generating reports. Worked on different stages of Project life cycle, Architecture Layers and Design patterns. Having Good understanding of SOA Architecture. Used Enterprise libraries for data access, Cryptography and Exception handling. Strong knowledge in Database Programming using RDBMS databases like SQL Server 2005, SQL Server 2000, Oracle 9i. Expertise in writing DTS, PL/SQL Queries, Stored Procedures, Triggers and Cursors. Used Version Controlling tools such as Visual Source Safe 6.0 (VSS) Used the Code Security governance tools like DevInspect. Good knowledge of WCF, WPF and WF. Working knowledge of SSRS, SSIS. Worked on design patterns like MVC, MVP, Singleton, Factory, etc.. Strong experience in drawing Use Case Diagrams, Sequence Diagrams, Class Diagrams, Object Modeling and Data Modeling using MS Visio. Experience performing Unit and Integration Testing in the Development, System Integration Testing (SIT), User Acceptance Testing (UAT) including Bug Reporting and Fixing. Used XML mapping tools like Altova Mapforce. Excellent logical, analytical, communication and inter- personnel skills with exceptional ability to learn new concepts / fast learner with complex systems and a good team player, problem solver and ability to perform at high level to meet deadlines, adaptable to ever changing priorities.

EDUCATION: Masters Degree in Computer Science (MSc) Certifications:

• •

Brainbench Certified Professional in VB.Net, ASP.Net, ADO.Net, .NET Framework 1.1 and MS SQL Server 2000 DBA DNIIT - from NIIT

TECHNICAL SKILLS: .Net Technologies VB.NET, Operating Systems Developments Tools & Technologies 6.0, Testing Tools Web/Application Servers Web Development

Microsoft .NET Framework 1.1/2.0/3.5, C#, ASP.NET, ADO.NET, Web Services, WCF, WPF, WF, SOAP, XML, AJAX. MS Windows 2000/2003 Server, MS Windows XP, MS Windows NT 4.0, MS Windows 95/98, Unix, Linux. Visual Studio.NET 2003/2005/2008, Visual Interdev 6.0, Visual Studio Visual Source Safe, Microsoft Visio. NUNIT 2.2, AXO Soft OnTime2007 IIS 5.0/6.0, MTS, OPENTI ASP.NET, ASP, XML, XSL, XSLT, XPath, VBScript, JavaScript, CSS, HTML/ DHTML

RDBMS Languages Reporting Tools Source control tools Other Tools

MS SQL Server 2005/2000/7.0, MS Access 2000, Oracle 9i, Sybase, SSRS, SSIS C#, VB.NET, VB 6.0, HTML, XML, TSQL Crystal Reports.Net/7.0/9.0, Reporting Services 2005 MS Visual Source Safe, Source Anywhere, TFS. FxCop, WSE 3.0, ANTS Profiler, SPI Dynamics DevInspect, NHibernate, CSLA framework, Infragistics controls, LINQ, JQuery

PROFESSIONAL EXPERIENCE: Department of Public Safety, Columbus, OH

Apr 2008 – till date

Project: BASS (Business Application Services System) Senior Consultant. Description: BASS is a web application developed in dot net 2.0. Bass is a one stop solution for Bureau of Motor Vehicles in OHIO. Bass allows the agencies to logon using their AD account. Bass has five major components in it namely 1) Driver licenses (DL) 2) vehicle Registrations (VR) 3) security maintenance 4) Other services and Reports. Bass supports multiple DL/VR transactions. BASS also allows users processing of the state ID cards. System complies with the state and federal laws. BASS interfaces with multiple in department and outside the department state and federal systems. System allows DL transactions like new, renewal, duplicate, add endorsements, add or change restrictions etc... Responsibilities: • Study and analysis of business requirements and conducting the status update meetings • Assigning work to the team members and co-coordinating with the team. • Updating the Managers with project status. • Involved in preparing requirement specifications, design specification and reviewing the test case documents. • Involved in the Database Design and developed/updated tables, triggers, views and stored procedures in SQL Server 2005. • Responsible to understand the existing web architecture • key member of the team in migrating the application from dot net framework1.1 to 2.0 • Developed Load Test scripts to stress test the BASS web application using Visual studio testing edition. • Configured the Load Test Environment with 1 controller and 4 agents for stress test of the BASS. • Got appreciation from Director of Department of Public Safety for the work done during the migration of the BASS from dot net framework 1.1 to 2.0 • Designed and developed a solution to use the client resources using the web page with out using Activex controls. Leading to more secure accessing of the client resources. • Developed application to generate multipage TIFF images using GDI+ classes. • Developed application which uses the SQL server 2005 Service Broker and sql dependency class using the Query notification services. • Developed serviced components using OPENTI to communicate with Unisys Mainframe from dot net application. • Having good knowledge of developing and troubleshooting OPENTI components. • Designed and Developed OPENTI Server component with dot net client component which can be called from a mainframe application. • Developed Windows Services for centralized printing using the print servers to client printers. • Played key role in the designing, developing and testing of the DX Module, which is a major enhancement to the system. • Developed the deployment strategy to deploy the new driver license printers with out affecting the day-today working of the deputy registrars. • Key member of the team when BMV rolled out state wide new driver license Card Printers, cameras and signature pads. • Used Infragistics controls. • Developed PDF417 2D Barcode solution for the new Driver license cards to comply with AAMVA standards. • Designed and Developed SQL server job that create SSRS reports and mails them to the users.

• • • • •

Designed multiple SSRS reports Developed a simple Vehicle Registration form for the agencies to quick completion of the transaction. Automated the processing of homebound users applications. Optimized stored procedures leading to better performance of the application. Developed a tool to generate the sql script for the changes made to development database compared to the production database. • Performed DB Stress test on stored procedures using the Quest Benchmark Factory for Databases. • Testing the application (Unit, Integration Testing) and fixing the bugs. • Deployed the application into QA environment Environment: .NET Framework 2.0, WCF Services, VB.NET, AJAX, JQuery, Java Script, Visual Studio .NET 2005, SQL Server 2005, IIS 6.0, SSRS, Windows 2003 server, Win XP thin Clients, OPENTI, Barcode.net, GDI+

TELETRACK, NORCROSS, GA

FEB 2006 – JAN 2008

Project: Checking Data and PositiveData Technical Lead Description: The Checking Data system is designed to provide feedback to the merchant regarding the validity of the checking data given to them and the existence of multiple accounts for the same consumer or the existence of multiple consumers utilizing the same checking account. System validates the consumer’s checking account information that includes Routing Transit Number (RTN) and account number The Positive Data system will provide outstanding loan balance and positive data on loans that reside in its database. The potential exists to provide information on both current loans and on previous loans. Responsibilities: • Study and analysis of business requirements and conducting the status update meetings • Assigning work to the team members and co-ordinating with the team. • Updating the Managers with project status. • Involved in preparing requirement specifications, design specification and reviewing the test case documents. • Involved in the Database Design and developed/updated tables, triggers, views and stored procedures in SQL Server 2000. • Responsible to understand the existing ServiceBroker architecture and train the team. • Making changes to the existing ServiceBroker application. • Involved in Porting of Epicware ‘C’ Language code into VB.Net to use in CheckingData WebService. • Involved in the coding of PositiveData WebService. • Good knowledge of WCF, WPF and WF. • Created new XSLT maps using Altova Mapforce and made changes to the existing maps. • Conducting the Code review and responsible to make sure the code developed is FxCop and DevInspect complaint. • Designed and developed the CheckingData Scanner tool. • Made changes to the existing Client facing XML Interface WebService to accommodate the request for CheckingData application. • Testing the application (Unit, Integration Testing) and fixing the bugs. • Deployed the application into QA environment Environment: .NET Framework 2.0, .NET WebServices, C#, Visual Studio .NET 2005, SQL Server 2000, IIS 6.0, MS Enterprise library 2.0, Win XP Clients. # Project: Teletrack Online Portal Tech Lead Description: The aim of this project is to rewrite existing Teletrack Online which lacks some security features like strong user name and password as well as design capabilities like branding and skinning. Also there is a need for an online portal to host the various Teletrack services like Inquiry Service, State Service, Identity Verification Service, etc., so eventually this new Teletrack Online Portal will be hosting all of the other services and new services as offered by Teletrack. One of the main design considerations for Teletrack Online is security, customizable content and a flexible layout management mechanism based on a combination of the company, online users, online user roles, merchants and

industry. Responsibilities: • Interacting with the business owners for collecting the business requirements and participating in the status update meetings. • Lead the team from front-end in designing and coding the application • Documented the requirement specifications, design specification and reviewing the test case documents. • Involved in designing the pluggable modules concept and Designed and developed the pluggable modules (CreditInquiry and Experian File Lookup). • Involved in the Database Design using Visio and made changes to the existing Membership Database and developed the required stored procedures. • Developed the UserAuthentication and UserAdministration Security WebServices in VB.Net using the Custom Membership Provider inherited from SQL Membership and Role Providers. • Designed and developed the TeletrackOnlinePortal Framework. • Designed and developed Master and content pages UI using ASP.Net pages for Experian File Lookup module • Developed the code to interact with CreditInquiry WebService through WSE Router. • Made changes to the CreditBureau WebService for the Experian File Lookup module. • Used CSLA framework for the business objects. • Conducting the Code Review of the application and making sure the application is FxCop and DevInspect compliant. • Documented and developed the unit test cases for the modules developed. • Documented the Operations manual and Development Implementation Guide. • Maintenance and enhancement for the application and customizing the look and feel as per the client’s requests. • Testing the application (Unit, Integration Testing). Environment: .NET framework 2.0, ASP.Net, C#, CSS, Java Script, Visual Studio .Net 2005, SQL Server 2000, CSLA framework.

COGNIZANT TECHNOLOGY SOLUTIONS, INDIA

JUN 2004 - JAN 2006

Project: UHGHYDKR Portal Tech Lead Description: The main aim of KR Portals is to efficiently and effectively create, locate, capture, and share the project specific knowledge and expertise. This project involves organizing and presenting the project specific knowledge, which makes the newbie’s life easy in understanding the functional and technical aspects of the project with out getting the formal KT. The KR Portal architecture consists of business layer, data access layer and presentation layer. All layers were developed in VB.Net. Microsoft application blocks were used for development of data access layer and exception handling. Responsibilities: • Study and analysis of business requirements and conducting the status update meetings • Assigning work to the team members and coordinating with the team. • Requirement Analysis and Design (Prepared Use Case diagrams, sequence diagrams and class diagrams for online quiz module). • Designing the Database and developing the Stored Procedures and other database objects. • Worked closely with Business Analysts in presenting the content on the site. • Used Internet Explorer WebControl Library for TreeControl. • Coding of KR Portal Framework and online Quiz modules. • Coding of Web Based Training (WBT) Module. • Implemented Coveo Enterprise Search to provide search capability. • Conducting the CodeReview and making sure the application is FxCop compliant. • Preparing and documenting the Unit Test Cases and Testing.

• •

Co-ordinating with the Operations Team in Deploying the apllication on to Production Servers Developed Reports for Quiz Module

Environment: .NET Framework 1.1, ASP.NET 1.1, VB.Net, Visual Studio .NET 2003, SQL Server 2000, IE WebControl Library, MS Enterprise library 1.0, Crystal Reports.Net. Project: Ovations Project CARE (Conversion) Senior Developer Description: This project involves migration of the existing Visual Basic based CareOne application into the .Net based CARE application. Both CareOne and CARE applications help to provide proactive health care management for elderly Americans. The Assessment Loader and GHS Interfaces architecture consists of business layer, data access layer and file management layer. All layers were developed in C#. Microsoft application blocks were used for development of data access layer and exception handling. Responsibilities: • Understanding the business requirements of CareOne. • Understanding the existing the CareOne application • Helping the Team members. • Requirement Analysis and Design (Prepared Use Case diagrams, sequence diagrams and class diagrams for GHS inbound and GHS outbound modules). • Involved in the uploading of existing Assessment Data from Excel files into SQL server and MS Access Databases. • coding of Assessment Loader utility • Developing the GHS inbound and GHS outbound modules. • Understood the usage of domain layer framework in CARE application. • Developed the stored procedures and views. • Used Data Access and Exception Handling Application blocks of MS Enterprise Library. • Making the application FxCop compliant. • Preparing Unit Test Cases to test the functionality of the tool under various scenarios Environment: .NET Framework 1.1, ASP.NET 1.1, C#.Net, Visual Studio .NET 2003, SQL Server 2000, MS Enterprise library 1.0

IBM GLOBAL SERVICES, INDIA

JUN 2003 - MAY 2004

Project: ADMS (Application Development Management System) Senior Developer Description: ADMS is an integrated tool for project tracking, status reporting and collaboration. The Scope of delivery & requirements vary from client to client and project to project. ADMS has the flexibility to accommodate these variations. ADMS uses n-tier architecture. ADMS has provision for managing different issues that may arise during a project lifecycle. A user can review defects, report for testing problems, and can raise issues and risks, on the basis of which reports are prepared. The status reports are prepared on Issue, Risk, Review defects, Staffing plan and Team Timesheet. Clients can visualize the status of the project from these reports. Collaboration with clients is another aspect of this system. Responsibilities: • Member of the performance tuning team. • Participated in development of Role based security implementation. • Designed and developed stored procedures using Microsoft SQL Server 2000. • Developed reports using Crystl Reports.Net for TimeSheet, Bug Report etc.. Environment: .NET Framework 1.1, ASP.NET 1.1, C#.Net, Visual Studio .NET 2003, SQL Server 2000, MS Enterprise library 1.0, Crystal Reports.Net

CYBERNETICS INTERNATIONAL, INDIA

MAR 2000 - MAY 2003

#Project: SETU Senior Developer Description: Setu is an application developed to create transparent governance between the government and the common man. This application mainly deals with the receiving and processing the various kinds applications from the people, Applications for like Birth Certificate, Affidavits etc. The application is multilingual, which is based on the Unicode. The best feature of the application is its ability to provide user designable and creatable reports, to create these reports the end user need not to have any programming skills. Responsibilities: • Responsible for understanding user requirements, designing and developing the application. • Involved in interacting with the client & verifying the requirements. • Developed the WinForms UI for Application acceptance module. • Implemented the fingerprinting using VeriFinger SDK. • Developed the business logic layers using VB.Net • Developed code to capture the applicant’s image into the application and reports. • Impleemted the localization language support using the Aksharmala 3rd party software. • Developing User Interface in VB.NET and ASP.Net pages. • Created the setup packages • Impleted the licensing using the XHEO licensing. • Installed new SQL Server 2000 Desktop and Enterprise Editions and maintained at various client locations. • Coding, designing and developing reports. Environment: MS SQL Server 2000, .NET Framework 1.1, Visual Studio 2003, VB.net, Win Forms, ASP.net, Crystal Reports.Net, XHEO Licencing, VeriFinger SDK.

Project: Accounts Management System Developer Description: This application can be used for any kind of accounting needs. This package is very professional, user friendly and multi-user capable. This makes the recording of day-to-day transactions of the accountant very easy. Using this package one can maintain any kind of accounts transactions. This package also includes the accounting statements like Trail Balance, Income & Expenditure statement and Balance sheet. Responsibilities: • Involved in analyzing the various existing applications. • Involved in analysis, design, coding and deployment of the application. • Developed the ledger, journal, cashbook, bank book, profitloss statement etc.. • Involved in Design and development of Database. • Developed the Tables, storedprocedures and views. • Developed the reports for journal, ledger, cash book, bank book, profitloss statement, trail balance and balance sheet etc,,,, • Developed the unit test cases. Environment: VB 6.0, SQL Server 7.0 & Seagate Crystal Reports 7.0. Project: Examination Management System Developer Description: The system is designed to take care of the complete day-to-day activities of the Examination Department starting from sale of the application to the generation of the marks memo. After entering the marks for all subjects the system automatically generates the result for the students. The user can take different kinds of reports like the student list for the exam, decode generation, roll code, transcripts and marks memos. Responsibilities: • Responsible to do the requirement gathering from client, coding and deployment at client’s location • Involved in Designing the database, Developing, Installing and configuring the MS SQL Server 7.0. • Involved in writing the stored procedures and triggers. • Developed a utility to backup the database and copy the backup file to another server on the

network automatically. Involved in designing and developing the complex reports like marks memo etc.., Environment: VB 6.0, SQL Server 7.0 & Seagate Crystal Reports 7.0.

•

Project: Hospital Management System Developer Description: This project deals with the complete functionality of the hospital. It has comprehensive detail form, which contains information about the patient details, doctor details and tests to be conducted along with the payment details. The project also has an efficient report generation system, which helps the patient know his test values as compared to normal values. The system has modules like Patient, Hospital, Lab and Payroll. Responsibilities: • Involved in design, coding and deployment of the application. • Involved in Developing the database objects like tables, storedprocedures, views. • Involved in Installing and configuring the MS SQL Server 7.0. • Involved in developing the Reports. Environment: VB 6.0, SQL Server 7.0 & Seagate Crystal Reports 7.0.

Project: Institutional Management System Developer Description: This project deals with the whole functionality of any Educational Institute (s). It involves with all kinds of departments in the institution. It has different modules to take of different activities that happen in any typical educational institute. The system takes care of the student’s admission, performance, attendance etc. System is provided with a comprehensive search facility which allows the users to query the system for any kind of data that is maintained based on the user’s privilege. The system is provided with a powerful report generation module. The IMS is having the following modules Admission, Student Fees, Accounts, Payroll, Library, Hostel, Examination and Attendance. Responsibilities: • Responsible for creating the front-end entry screens, coding, deployment and testing • Involved in Installing and configuring replication the MS SQL Server 7.0. • Taking Backups, Recovery, Replication and Designing DTS packages. • Involved in writing the stored procedures and triggers. • Designing and developing reports. Environment: VB 6.0, SQL Server 7.0 & Seagate Crystal Reports 7.0.