Hillsborough choice is a pupil placement, tracking, and school capacity management system for the 8th largest school district in the US with over 200,000 students. Hillsborough choice consists of two applications, Enterprise System and Student Application Management System (SAMS). SAMS allowed parents to login to a secure environment, retrieve student information, look up transportation options, school choices, make appropriate choice selections, and respond to choice offers. Applications receive from SAMS are processed and stored along with student demographic information retrieved from CA/Datacom on Mainframe Z/OS v1.4 into SQL Server database. Administrators and choice staff use the Enterprise System to manage student applications and assist SAMS users. The web applications are designed using MVC Design pattern and developed in IBM Rational Applications Developer 6.0 using JSP, Servlets, Java Beans, JDBC, JNDI deployed on IBM WebSphere 6.0. The students were later placed used a points based random lottery Client/Server GUI system built using Visual Studio.NET 2003.
Responsibilities:
- Worked on all phases of software development life cycle including Requirement Analysis and Specification, Design, Development, Integration and System Testing, and Implementation.
- Involved in the design and implementation of database in MS SQL Server 2000.
- Involved in creation Several DTS packages, stored procedures and creation and scheduling jobs.
- Involved in design and development of the web application in Java using JSF, JSP, Servlets, and JavaBeans.
- Involved in creation of windows GUI Components in Visual Basic .NET.
- Analyzed, Designed and Developed components for business logic.
- Involved in design and implementation of database interaction using JDBC and JNDI for Data Sources: CA/Datacom, and DB2.
- Involved in unit testing and deploying onto production using IBM WebSphere 6.0 on Linux server.
- Involved creation of address dictionary from the district GIS map and storing the spatial data in MS SQL Server 2000 for easy retrieval of information such as with school boundaries, Regions, Zones.
Environment: JSF, JSP, Servlets, Java Beans, JDBC, JNDI, AJAX, JavaScript, VB.NET, PL/SQL, XML, CA/Datacom, DB2, Windows 2003, Suse Linux Enterprise Server 9.0, AIX 5.2, IBM WebSphere 6.0, IBM Rational Application Developer 6.0/7.0, Visual Studio.NET 2003, MapInfo Professional 8.0.
Project: School Locator and District School Transportation
School Locator and District School Transportation modules are web based tools of an application built to help parents of school district children locate their attendance area school based on residential address and identify transportation options for various schools with their attendance area boundary.
Responsibilities:
- Involved in design and development of web interface using ASP.
- Involved in designed and Development of components for business logic.
- Involved in design and implementation of database in MS SQL Server 2000.
- Involved in design and implementation of database interaction using ODBC.
- Involved in unit testing and deploying onto application server.
Environment: ASP, Microsoft IIS, MS SQL Server 2000.
Project: GeoElections WebTools©
GeoElections WebTools© provides the elections office for counties in US (widely used in Florida) with the power to offer their voters the ability to access elections data through interactive maps on the World Wide Web. The application allowed the web user to search their address and locate it on map along with their voting precinct information. Interactive map layers included: Precincts, School Board Districts, County Commission Districts, City Council Districts, Fire Districts, Water Districts, Special Taxing Districts, State House or Assembly Districts, State Senate Districts, Federal Congressional Districts.
Responsibilities:
- Involved in system analysis and design process.
- Involved in design and implementation of database using MySQL 4.1.
- Involved in development of web interface in HTML/DHTML, JavaScript and PHP.
- Involved in installing and configuring Apache web server.
- Involved in deploying the application on the web server.
- Involved in developing a tool that uses batch processing to build web files and deploy the application on the web server.
- Involved in developing a tool that allows users to configure application specific parameters.
Environment: HTML/DHTML, JavaScript, PHP, MySQL 4.1, Apache 2.0.53, Adobe SVG, Windows 2003, DreamWeaver MX.
Project: GeoChoiceSQL®
GeoChoice® is a solution designed for Magnet or Traditional programs, implemented as a controlled, zoned or open plan, offering centralized control with access for information inquiry and application submittal across the web. The system was developed using MapInfo Professional and SQL Server GeoChoice in order to accomplish the ease-of-use offered by Geographic Information Systems (GIS) to existing school management systems leveraging both the office and World Wide Web. It is a Multi-user application with three levels of access and progressive functionality.
Responsibilities:
- Involved in system analysis and design process.
- Involved in designing and implementing a relational database in MS SQL Server 2000.
- Involved in development of the web interface using asp that requires users login and make school choice selections.
- Involved in development of the windows GUI Interface of the application to interact with SQL Server using ADO.NET.
- Involved in developing tools to import and export data, create stored procedures, and triggers.
- Involved in unit testing and integration.
- Involved in creating an installable package using InstallShield.
Environment: ASP, VB.NET, ADO.NET, MS SQL Server 2000, IIS.
Project: GeoCensusIQ©
GeoCensusIQ© is a tool that provides the user with an easy-to-use means to link demographic data from the US Bureau of the Census with various levels of geography also derived from the US Bureau of the Census. The application is a windows GUI interface that retrieves data from SQL Server, creates portable MS Access databases and generates maps with demographic data geocoded on the map.
Responsibilities:
- Involved in design and development of the windows GUI Interface in VB.net.
- Interact with SQL Server to process and retrieve demographic US census data based on the user criteria by creating DTS package and export data to MS Access database using the GUI Interface.
Environment: VB.Net, MapInfo professional 7.5, MS Access, SQL Server 2000, Windows server 2003
Project: Company’s corporate Website design, web server and email server setup
- Solely Responsible in creating corporate website using HTML/DTHML, JavaScript and PHP.
- Responsible for all the day-to-day operations of the websites including site content, search engine, database maintenance, site tracking and statistics, etc
- Solely Responsible in setting up and maintaining email server using Microsoft Exchange Server 2003.
- Solely Responsible in setting up Name Server, Active Directory and creating the Forward Lookup Zone and Resource Records.
Environment: HTML/DHTML, JavaScript, PHP, Microsoft IIS, Windows Server 2003, Microsoft Exchange Server 2003, Dreamweaver
