.Net Sql Server Business Project Data Development
Resume:
Lakshmana Lavu
SUMMARY:
Microsoft Certified Professional, Application Developer and Solution Developer with over 10 years of
information systems experience. Experience includes Analysis, Design, Development, Testing and
Implementation of Client Server and web-based applications. Excellent analytical, interpersonal and
communication skills.
EDUCATION/CERTIFICATIONS:
• Masters from an accredited university in India
• Software Engineering from Complete Business Solutions
• PGDCA from GEENI Computer Education
• MCP, MCAD, MCSD in .NET
• Brain bench Certified Product Specialist in Application development using Visual Basic 6.0 and
Active Server Pages 3.0
TECHNICAL SKILLS:
HARDWARE IBM PC Compatibles
OPERATING SYSTEMS Windows XP/Vista/7/2003/2000/NT/98/95
LANGUAGES C, C++, JAVA, J2EE, ASP.NET, C#.NET, VB.NET, ASP, VB, WCF,
HTML, DHTML, XML, JavaScript, VBScript, Web Logic Portal,, Oracle
Web Center, WSS 3.0, MOSS 2007
SERVERS MTS 2.0, IIS 4.0/5.0/6.0/7.0, PWS
MIDDLEWARE . NET Components, MTS, COM+, COM
CONNECTION APIs ODBC, ADO, ADO.NET, RDO, CDO
IDE’s VB IDE, Visual InterDev, Visual Studio 2005/2008
TOOLS Rational Rose for Object Oriented Design and Analysis, Visual Source
Safe for version control
RDBMS Oracle 8i/ 9i/10, MS SQL Server 7.0/2000/2008, Sybase 12.5
REPORTING TOOL Seagate Crystal Reports 7.0/8.0/8.5, Business Objects XI R2/XI R 3.1
NETWORK RELATED TCP/IP protocol and related services. (FTP, HTTP, HTTPS, SMTP,
SOAP and POP3)
PROFESSIONAL EXPERIENCE:
Ventera Corporation March 2006-Present
Software Engineer/Sr. Systems Analyst
Ginnie Mae:
The Reporting and Feedback System (RFS) application implements new reporting and feedback
functionality delineated in Ginnie Mae’s business process improvement (BPI) ideal process vision. The
feedback capability provides immediate information to issuers regarding the status of reported data. RFS
is a central point of process interaction for issuers, service bureaus, Ginnie Mae users,
Contractors/Agents, and others. The purpose of this project is to streamline Ginnie Mae’s existing
business processes and use of information technology to include modernized IT systems, improve the
overall accuracy, completeness, efficiency, and productivity of Ginnie Mae and its internal and external
stakeholders, all while reducing IT spending and total cost of ownership
Roles and Responsibilities:
• As part of the development team, I participated in the full project life cycle including analysis, design,
development, testing and implementation.
• Integrated all .Net Framework 2.0/3.5 Web applications with BEA Web logic Portal to implement
Single Sign on.
• Developed Reports in Business Objects XI R2/R3.1 and Integrated with ASP.net Web Applications.
• Developed .NET components using C#.NET in the .NET framework.
1
• Developed Web Services & Windows Services using C# in the .NET framework.
• Utilized ADO.NET to retrieve and manipulate data, and, display it in ASP.NET pages.
• Utilized Data Grid, Data List and Repeater Controls to display data in a customized format in the
ASP.NET web pages.
• Utilized ASP.NET Validation controls to do server-side validations and client-side validations based
on the user’s browser.
• Leveraged C#.NET to develop the business logic behind the ASP.NET pages
• Involved extensively in Unit testing and System Integration testing.
• Involved extensively in writing Oracle Stored Procedures and PL/SQL
Environment: ASP.NET, C#.NET, ADO.NET, HTML, DHTML, XML, XML Web
Services(WCF), JavaScript, VBScript, Oracle 10, VSS and Windows 2003 Server, BEA
Web logic Portal 9.2, Aqua logic .Net Application Accelerator 1.1/ Oracle Web Center,
Business Objects XI R2/R3.1,.NET framework 2.0/3.5,TFS.
Sprint:
The Mercury application will provide a means for coordination and communication between the different
departments and groups that support the BAS Relocation project. The system will capture all deal related
information at every step of the process and provide tools to track the status of individual deals and report
overall progress at every stage. The Mercury enhancements to support the BAS Relocation project deals
result in improved communication between the many stakeholders that participate in the deal process.
Roles and Responsibilities:
• As part of the development team, I participated in the full project life cycle including analysis, design,
development, testing and implementation.
• Developed .NET components using C#.NET in the .NET framework.
• Developed Web Services & Windows Services using C# in the .NET framework.
• Utilized ADO.NET to retrieve and manipulate data, and, display it in ASP.NET pages.
• Utilized Data Grid, Data List and Repeater Controls to display data in a customized format in the
ASP.NET web pages.
• Utilized ASP.NET Validation controls to do server-side validations and client-side validations based
on the user’s browser.
• Leveraged C#.NET to develop the business logic behind the ASP.NET pages
• Performance tuned SQL queries in the underlying Oracle 9i database.
• Involved extensively in Unit testing and System testing.
Environment: ASP.NET, C#.NET, .NET Components, ADO.NET, HTML, DHTML, XML,
XML Web Services, JavaScript, Java/J2EE, JSP, VBScript, Oracle 9i, Erwin, VSS and
Windows 2000.
FBR July 2005-February 2006
Sr. Web Developer
Roles and Responsibilities:
• As part of the development team, I participated in the full project life cycle including analysis, design,
development, testing and implementation.
• Served as the technical lead for a module, providing technical and functional guidance to the
development team members.
• Lead the design of .NET assemblies, the front-end web pages in ASP.NET and the data model based
on the business requirements. Developed Use Cases and Class Diagrams using Erwin.
• Developed .NET components using Vb .NET in the .NET framework.
• Invoked SQL Server stored procedures using ADO.NET
• Utilized Datasets, Datatable and Dataview to retrieve and manipulate data, and, display it in
ASP.NET pages.
2
• Utilized DataGrid, DataList and Repeater Controls to display data in a customized format in the
ASP.NET web pages.
• Utilized ASP.NET Validation controls to do server-side validations and client-side validations based
on the user’s browser.
• Leveraged VB.NET to develop the business logic behind the ASP.NET pages
• Performance tuned SQL queries in the underlying SQL Server 2000 database.
• Involved extensively in Unit testing and System testing.
Environment: ASP.NET, Vb.NET, .NET Components, ADO.NET, HTML, DHTML, XML,
XML Web Services, JavaScript, VBScript, SQL Server 2000, Erwin, VSS and Windows
2000.
State of IOWA, Department of Elder Affairs November 2003-June 2005
Team Lead / Sr. Programmer Analyst
Description:
This project helped the State of IOWA, Department of Elderly Affairs to provide services for elderly
citizens. This project created an online version of an application used by Facilitators, Assessors &
Coordinators to record data about services requested by elderly citizens.
Roles and Responsibilities:
• Created common controls for all pages of the application. These controls (composite) provide
automated logic for validating data and displaying invalid data messages. These controls also
populate data from the database. The controls are reusable and customizable.
• Creating a caching framework that minimizes traffic to the database by storing the SmartForms data
in the cache with the sliding expiry duration preconfigured in the web server.
• Created a cryptography module to handle the encryption and decryption of critical data. This module
uses single DES, Triple DES, and SHA1 algorithms.
• Created a Data Access Framework in C#. This framework is used to transfer data to the database
and retrieve data from the database, providing a central access point for all data transfer in the
application. Data access is role-based.
• Created a logging framework that handles exceptions thrown in the application and stores error
information in the database or XML-based file. The framework then sends a notification to the
support team for resolution of the issue.
• Created reports utilizing Adobe’s FDF Toolkit. This toolkit is used to fill in the PDF templates with
data from the database on the fly and streamed to the user. There is no physical existence of the
report with specific user data on the server side.
• Created role-based authentication and group access levels for the accessing the SmartForms and
Reports. Created a set-up utility for administering roles and groups.
• Created an object-oriented UI page for rendering for Public, Agent and Admin page navigation. The
menus and page contents are dynamic, based on the roles of the user.
• Created Tables, Views, Functions, Stored Procedures, Cursors and Triggers under SQL Server
2000.
Environment: ASP.NET, VB.NET, C# ADO.NET, HTML, DHTML, XML, XML Web
Services, VBScript, Verisign, Microsoft Application Block, SQL Server 2000, VSS and
Windows 2000.
American Republic Insurance, IOWA
The American Republic Insurance Company has three Websites ( www.americare.com,
www.americanrepublic.com and www.entrecor.com). The goal of the project was to create common logic
for all three sites so that sites differ only in the GUI (Graphical User Interface) and logic specific to that
website.
Roles and Responsibilities:
• During the design phase I played the lead role in designing .NET assemblies, the front-end web
pages in ASP.NET and the data model based on the business process.
3
• Developed Composite Controls.
• Implemented Verisign’s PayFlow Components.
• PDF Reports Generation.
• Invoked SQL Server stored procedures using data access module (C#).
• Performance tuned the SQL queries executed against the underlying SQL Server 2000 database.
• Involved extensively in Unit testing and System testing.
Environment: ASP.NET, VB.NET, C# ADO.NET, HTML, DHTML, XML, XML Web
Services, VBScript, Verisign, Microsoft Application Block, SQL Server 2000, VSS and
Windows 2000.
STS September 2000-October 2003
Sr. Programmer Analyst
Route Sales Management System
The Route Sales Management System (RSMS) focused on automating daily sales force operations by
utilizing mobile handheld systems to maximize productivity and to increase bottom line margin.
Roles and Responsibilities:
• As part of the development team, I was associated with the full life cycle of the project ( analysis,
design, development, testing and implementation ).
• Played the role of a technical lead for a module and provided technical and functional guidance to
the development team of my module.
• During the design phase I played the lead role in designing .NET assemblies, the front-end web
pages in ASP.NET and the data model based on the business process. I have developed Use Cases
and Class Diagrams using Rational Rose.
• Extensively developed .NET components using C# .NET in the .NET framework.
• Invoked SQL Server stored procedures using ADO.NET.
• Have extensively used Datasets, Datatable and Dataview to retrieve and manipulate data and
display it in an ASP.NET page.
• Have used DataGrid, DataList and Repeater Controls to display data in a customized format in the
ASP.NET web pages.
• Have used ASP.NET Validation controls to do server-side validations and client-side validations
based on the user’s browser.
• Extensively used C#.NET to write the code behind logic for the ASP.NET pages
• Performance tuned the SQL queries executed against the underlying SQL Server 2000 database.
• Involved extensively in Unit testing and System testing.
Environment: ASP.NET, C#.NET, .NET Components, ADO.NET, HTML, DHTML, XML,
XML Web Services, JavaScript, VBScript, SQL Server 2000, Rational Rose, VSS and
Windows 2000.
Stock Watch System
The proposed Stock Watch System will serve as a market monitoring tool as well as an analysis tool for
the Market Surveillance (MS) Department. The system would integrate information from various
databases for efficient and effective monitoring of trading activities, disclosures and preliminary
investigative
Roles and Responsibilities:
• Provided technical guidance to a group of developers on small sub-projects.
• Developed UserControles using VB.NET in the .Net Framework.
• Developed Common Class Modules for the team of members.
• Designed and developed ASP.NET pages
• Developed .Net components with embedded business logic.
4
• Developed PL/SQL stored procedures in Sybase 12.5 to handle data related
business logic. Also developed Insert/Update/Delete triggers on the Sybase tables.
• Generated Excel spreadsheets by developing macros to retrieve data from the
database based on business logic.
• Interacted with the business clients for gathering requirements and developed
specifications for various program modules.
• Created Use cases to visualize the placement of different components in the system architecture.
• Extensively involved in the analysis and design of the application using UML, with the tool Rational
Rose 2000e.
• Identified and documented the Use Cases and created the Use Case Diagrams for the same using Rational Rose.
Environment: ASP.NET, VB.NET, .NET Components, ADO.NET, HTML, DHTML, XML,
XML Web Services, JavaScript, VBScript, SQL Server 2000, Sybase 12.5, Rational
Rose, VSS and Windows 2000.
Help Desk Management System
Help Desk System is an in-house Development System to support and help the company employees to
solve the systems related problems.
Roles and Responsibilities:
• Developed UserControles using VB.NET in the .Net Framework.
• Developed Common Class Modules for the team of members.
• Designed and developed ASP.NET pages
• Developed .Net components with embedded business logic.
• Developed PL/SQL stored procedures in SQL Server2000 to handle data related
business logic. Also developed Insert/Update/Delete triggers on the Sybase tables.
• Generated Excel spreadsheets by developing macros to retrieve data from the
database based on business logic.
• Interacted with the business clients for gathering requirements and developed
specifications for various program modules.
• Created Use cases to visualize the placement of different components in the system architecture.
Environment: ASP.NET, VB.NET, .NET Components, ADO.NET, HTML, DHTML, XML,
XML Web Services, JavaScript, VBScript, SQL Server 2000, Rational Rose, VSS and
Windows XP.
Prompt 2000
Prompt 2000 is used to enable Telecom Malaysia to manage all of its projects effectively through the use
of an integrated Project Management and control System using Primavera Project Planner for Enterprise.
Roles and Responsibilities:
• Extensively coded in VB 6.0 using ActiveX technology.
• Developed stored procedures in Oracle 8i to Manage data efficiency.
• Developed Insert/Update/Delete triggers on the Oracle 8i tables.
• Developed MTS packages so as to manage distributed transactions for the ActiveX components.
• Involved extensively in Unit testing and System testing.
Environment: VB, Primavera Project Planner, COM (ACTIVE X-EXE, ACTIVE X-DLL),
HTML, JavaScript, VBScript, Oracle 8i, VSS and Windows 2000
Web Media Dynamix
Media Dynamix (MDX) is an integrated media Delivery system used to calculate statistics and
generate reports based on specific criteria. MDX uses data from a production system to generate
its reports. MDX is a solution that addresses harmonization of business rules, with specific
5
emphasis on data interoperability with the existing systems and scalability for future
enhancements. The application supports both remote and online users, automated data and report
delivery, and multiple languages.
Roles and Responsibilities:
• Extensively coded in VB 6.0 using ActiveX technology.
• Involved in various aspects of the project modules to the full extent
• Designed and developed ASP pages with JavaScript and VBScript.
• Used XML data islands along with DHTML to provide dynamic content on the web
pages in response to the user actions.
• Developed stored procedures in Oracle 8i to Manage data efficiency.
• Developed Insert/Update/Delete triggers on the Oracle 8i tables.
• Developed MTS packages so as to manage distributed transactions for the ActiveX components.
• Involved extensively in Unit testing and System testing.
Environment: VB, ASP, COM (ACTIVE X-DLL), HTML, JavaScript, VBScript, SQL
Server 2000, VSS and Windows 2000
Berjaya Corporate Internet
Berjaya Group Berhad is involved in multiple business ventures and is one of Malaysia’s major public
listed conglomerates. With over 22000 staff, Berjaya manages diversified through partnerships, joint
ventures and new start-ups. At present with large-scale operations and number of staff, Berjaya requires
an improved way of handling its processes like leave, claims, training requisitions etc. Along with these
feature the intranet information systems (EIS).
Roles and Responsibilities:
• Extensively coded in VB 6.0 using ActiveX Dll technology.
• As part of the development team, I was associated with the full life cycle of the
project.
• Developed and monitored the COM/DCOM Objects.
• Developed ActiveX Controls such as dails and Graphs were used to show the
business trends according to the client’s business rules and to alert the users.
• Developed stored procedures in SQL Server 2000 to Manage data efficiency.
• Developed MTS packages so as to manage distributed transactions for the ActiveX components.
• Involved extensively in Unit testing and System testing.
Environment: VB, ASP, COM (ACTIVE X-DLL), HTML, JavaScript, VBScript, SQL
Server 2000, Visual Interdev, VSS and Windows 2000 IBM Server.
I - Proms
Kosijaya is a universal contractor who takes up projects in setting up offices, laboratories in
universities, colleges and schools. They needed their whole process to be computerized and
setup a paperless office. The project involved in designing screens for the user interface and
designing a database for the data storage and retrieval.
Roles and Responsibilities:
• Extensively coded in VB 6.0 using ActiveX Dll technology.
• As part of the development team, I was associated with the full life cycle of the
project (analysis, design, development, testing and implementation ).
• Developed and monitored the COM/DCOM Objects.
• Developed Data-Environment for database connection.
• Developed Search bar ActiveX control, which is used to search through the
database for a selected field and value.
6
• Developed Query Builder to build SQL queries of selected fields from database
tables with assigned criteria’s.
• Developed stored procedures in SQL Server 2000 to Manage data efficiency.
• Developed MTS packages so as to manage distributed transactions for the ActiveX components.
• Involved extensively in Unit testing and System testing.
Environment: VB, ASP, COM (ACTIVE X-DLL), HTML, JavaScript, VBScript, SQL
Server 2000, Visual Interdev, VSS and Windows 2000 IBM Server.
Samsung Intranet
Samsung needed a strong communication between their customers and wanted that to be
economical. This project was designed for the hardware manufacture and sales department,
which deals with the computer monitors. The solution for their instant communication with their
clients with minimum expense was attained with the development of the extranet email.
Roles and Responsibilities:
• Extensively coded in VB 6.0 using ActiveX Dll technology.
• As part of the development team, I was associated with the full life cycle of the
project (analysis, design, development, testing and implementation ).
• Developed and monitored the COM/DCOM Objects.
• Developed Data-Environment for database connection.
• Developed stored procedures in SQL Server 2000 to Manage data efficiency.
• Developed MTS packages so as to manage distributed transactions for the ActiveX components.
• Involved extensively in Unit testing and System testing.
Environment: VB, ASP, COM (ACTIVE X-DLL), HTML, JavaScript, VBScript, SQL
Server 2000, Visual Interdev, VSS and Windows 2000 IBM Server.
E-Commerce Site for Palmtrans Inc
Palmtrans is a transportation company based in Atlanta, GA. that provides different types of services to
the public including Taxis, Limousines, Trucks, Vans, and Helicopters. The core idea of this website is to
facilitate cab bookings over the web.
Roles and Responsibilities:
• Utilized Visual Basic 6.0 to develop ActiveX Controls for web development
• Coded Active Server Pages (ASP) on Internet Information Server (IIS)
• Created Active Documents to interact with the web browser
• Design and creation of COM components that are used with MTS
• Worked on individualized reservation flow for users which involved payment through cyber cash
gateway
• Created packages in MTS and set the transactional properties of components
• Tested and debugged in-process and out-of-process components
• Developed stored procedures, views, and triggers
Environment:
Visual Basic 6.0, COM/DCOM, ACTIVE X, SQL Server 6.5, Crystal Reports 6.0, ASP, MTS (MS
Transaction Server), IIS, Windows NT 4.0
7
Contact this candidate