Resume 14

Objective:

Looking for a position to be part of multi-tier client-server application development.

Career Summary:

Microsoft Certified Professional with experience in client server-software development, qualified by over 7 years of software design, implementation, and testing experience in Automobile, Utility, Consulting, Staffing, Pharmaceutical, Financial, Merchandising, Real estate, PC manufacturing, and Technical institute industries.

Certification:

Exam 70-176: Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 Dec. 99

Expertise:

• Internet:
  Java Server Pages, Active Server Pages 3.0, Internet Information Server IIS 5.0, Sun J2EE, J2ME, Sun Forte for Java 2.0, Apache Tomcat Web server, and XML

• Databases:
  MS SQL server 6.0/6.5/7.0, MS Access 2.0/95/97, Watcom SQL

• Languages:
  MS Visual Basic 6/5/4/3, MS VB Script, Java Script, Java, C, C++, HTML

• Operating Systems:
  MS Windows NT 3.5,4.0, MS Windows 2000/95/3.11, DOS

• Miscellaneous:
  Rational Rose 4.0/98, Crystal Reports, RDO, DAO, ADO, MTS, and UML

Professional Experience:

Environment : Win NT,2K/VB6/VB.net/ADO/ADO.net/SQL Server 7/SQL Server 2K/ASP/ASP.net/XML

Project : Phoenix Online Intranet Application

• Programmed enhancements and bug fixes in OOP framework consisting of VB ActiveX Controls front end, business and data layer Objects and ASP pages. This application helps Royalty department enter and manage commissions for distributors. Programmed Stored Procedures for data layer objects.
• Designed XML driven odbc connection switching program using VB6 DLLs. This DLL was driven by SQL Server Job automatically. I Programmed DLL object to invoke an error message via Java Script from intranet application to send it to help desk. I used the registry object to extract settings to send along the error message.
• Programmed VB6 DLL Object to automatically update certain flags in main frame system via MSMQ on nightly basis driven by SQL Server Job. This DLL would invoke stored procedure, populate ADO recordset, create a text message, send it to Queue using MSMQ objects, and created a text file for confirmation purposes. It also logged error messages in event log.
• Helped junior programmer to write an intranet ASP application to monitor crystal report statement processes. Based on combo box selection, stored procedures were called and results were rendered on the output page. Performed code review for other developers.
• Trained junior programmers on ASP.net, ADO.net, and VB.net
• Programmed asp.net application using vb.net and ado.net to get distributor information within an OOP framework. Used server controls such as list controls and grid controls. Also programmed config XML file to set constant values such as odbc connection.
• Programmed Web Forms to host user controls and use dataset/datareader objects to perform operations.

Environment : Win NT/VB6/ADO/SQL Server 7

• Designed and implemented security objects that would work with existing framework and provide allow access to screens based on permissions.
• Programmed security utility for operations department to assign security on the screen to take effect upon the front and back office applications.

Project : Back Office Application

Environment : Win NT/VB6/ADO/SQL Server 7/ASP 3.0

• Programmed Job Order Screens to add functionality of permanent job order to work with different tabs and the COM objects.
• Added functionality to the object-oriented framework to work with the Job Order screens.
• Designed stored procedures to process data related to permanent job order.
• Implemented options in order to enter invoices on the miscellaneous invoices screen.
• Programmed User Services such as Cookies, Session Objects, File Processing, and Mail

Project : Front Office Application

Environment : Win NT/VB6/ADO/SQL Server 7

• Programmed middle tier objects to process Garnishments in the payroll based on the clients business rules.
• Interviewed users and managers to extract business rules and documented them in the form of use cases.
• Worked with front end developer to ensure that screens extracted and performed correct calculations to garnish paychecks. Programmed test scenarios in Excel spread sheets.
• Designed stored procedures to extract and process data for the payroll object interface. Reports Crystal 7.0, SQL Server 7
• Configured reports and programmed several stored procedures to extract data for reports like Vendor Usage Summary, Miscellaneous Invoices, Temporary and Permanent invoices etc.
• Implemented reports in detail, summary and various grouping levels within the reports.

Project : Surveillance

Environment : Win NT/VB5,6/SQL Server/Crystal Reports/ASP 2.0

• Designed views and stored procedures against SQL Server 6.5 to drive crystal reports.
• Programmed and supported surveillance VB5 application which keeps track of Loan and Property information.
• Programmed VB6 application to process remotely stored files and run stored procedures.
• Guided team of junior programmers to design Help Desk application.
• Programmed pages using ASP 2.0 and ADO 2.0 to get listing of properties on the web.

Project : Daily Lock box File

Environment : Win NT/VB5/SQL Server/Crystal Reports/Rational Rose

• Designed stored procedures to get data from SQL server for Brand ID application.
• Modeled sequence diagrams in Rational Rose for back end billing system.
• Designed use case and sequence diagrams to model daily lock box file import procedure.
• Gathered user requirements and produced design documents.
• Programmed middle tier objects to tie to both Access and SQL server databases.
• Designed thin client user interface screens to work with business tier objects to interact with data from the back end database.

Project : Payroll Application

Environment : Win. NT/VB5/VBA/MS Access/SQL Server 6.5/Rational Rose

• Programmed Business objects in VB5 so that they could be divided into User Interface, Business, and Persistent Objects. Designed objects so that they could be deployed in DCOM environment using MTS.
• Programmed payroll summary module in VB5 to access data from SQL server using ADO and output data in the form of reports using Crystal reports.
• Updated incorrect data at the SQL server back-end database using SQL.
• Created utility in MS Access to generate SQL scripts to modify data at the back end SQL Server.
• Reviewed use cases and sequence diagrams for new RAS application.

Project : Delta Application

Environment : Win. NT / VB 5/ SQL Server 6.5

• Assisted in the design and development of object oriented classes for Sales and Accounting system to sell technical courses to the Fortune 500 companies.
• Used object-oriented methodology to design classes to create course packages including line items for each package. These classes would also take care of calculating costs and discounts.
• Designed user interface, classes, and modules to enroll students in the courses. This code would also show history of enrollment including cancelled enrollments.
• Programmed objects to fill screens with corresponding events for the courses.
• Modified database structure in SQL server to properly interact with the front-end screens using special predefined database objects.

Project : RoboRebate Application

Environment : Win. 95 / VBA/MS Excel/ MS Access/SQL Server 6.5

• Built reports in Excel 97 for drugs provided by PacifiCare to its customers. Designed SQL program to get data from SQL server.
• Programmed in visual basic for excel to design the reports. Used built in Excel object model to manipulate the cells and rows of the sheets to create the report.
• Designed Front end screens in MS Access and wrote visual basic for access code to manage data between SQL server and front end. These front-end screens were designed to handle data about different drugs and their rebate criteria with respect to the manufacturers and rebate group families.

Project : Core System Project

Environment : Win. NT 4 / VB 5 / SQL Server 6.5 / Rational Rose 4.0

• Generated classes for Visual Basic 5.0 from object models implemented in Rational Rose 4.0.
• Implemented Round Trip Engineering to synchronize the Visual Basic 5.0 code with the object models.
• Designed code generator program to build In Process Active Servers . This code generator , driven by the generated classes, added customized methods, properties, and error handling in the final active server.
• Built COM objects using the output of code generator and maintained binary compatibility with respect to different revisions of the objects.
• Programmed Test Harness program to refer different COM objects into the project and test all the methods and properties so that the objects could read from and save data to the database.

Project : Store Trak 2

Environment : Win. 95 / VB 3.0 / SQL Server 6.5 /Crystal Reports

• Maintained and added modules to the reporting application to print status reports of the merchandising.
• Upgraded the application from VB3.0 to VB4.0 utilizing object-oriented methodology.
• Designed Queries in Access and SQL Server environment.
• Performed SQL Server administrative tasks such as monitoring performance, data migration between remote servers and data structure for front-end programmers.
• Programmed stored procedures to run reports straight from the SQL Server.

Project : VISTA System

Environment : Win. 95 / VB 4.0 / Access 2.0/ SQL Server 6.5

• Designed and implemented modules to download all the offices per selected regions.
• Programmed screens and queries to access data from SQL Server.
• Used DAO functions to create tables for data manipulation.

Project : Member Information System

Environment : Win. 3.11 / VB 3.0 / SQL Server 4.2

• Built and tested modules to perform auto fax feature from the application. Also used in house program library functions to code features.

Project : National Advertising Fund

Environment : Win. 3.11 / Access 2.0 / SQL Server 4.2

• Integrated and designed reports to deliver information about advertising fund collected from several offices.
• Supported and maintained reports for the operation center and trained new users.
• Programmed Queries to prepare underline tables for fast and accurate data retrieval.

Project : Century Incentive Bonus

Environment : Win. 3.11 / Access 2.0 / SQL Server 4.2

• Constructed the reporting application to make important decisions regarding bonuses from affiliate offices.
• Designed Forms, Queries, Reports, and Stored Procedures for the reporting application.

Project : Hard Disk Master

Environment : Win. 3.11/ Turbo C/C++

• Built GUI using C and Visual Basic 3.0 to populate Hard disk with commercial applications.
• This program prepared hard disk for one shot installation of Microsoft applications on the new computer hard drive.
• Tested Microsoft applications on the new systems.
• Designed functions to modify system initialization files appropriately.

Project : WinTax

Environment : Win. 3.11/ Borland C, C++/Watcom SQL server

• Designed functions in C language to retrieve data from remote site and populate user screens.
• Used ODBC calls to interact with the back end database.
• Programmed screen controls using low level Windows API calls.
• Designed algorithms for fast data retrieval.

• Taught C Programming, Windows, and DOS.
• Instructed courses like circuit analysis and design.

• Proposed, installed, and supported PC system solutions for clients business needs.

Education:

Preparing for MCSD April 2001 expected date

• Client server application development using Visual Basic 5.0
• Programming in Visual Basic 3.0
• Implementing a Database of MS SQL server for Windows NT

Illinois Institute of Technology, Chicago, IL. May 1989
Bachelor of Science in Electrical Engineering