INSIGHT - Integrated Network Status

Indicator (and) Growth Highlighting Tool

March 2007 - present
Client AT&T Communications, St Louis MO
Description Insight is a capacity planning and management dashboard tool to manage IP router capacity. Using this tool the planners will be able to track router/router card logical resource capacity at a high level, identify usable capacity subject to the engineering constraints that are implemented in INSTAR as well as those proposed by Network Engineering Team, and, have the ability to adjust the logical resource engineering constraints. INSIGHT acquires IP router/router card inventory, IP router/router card logical resources, IP router uplink utilization and IP router VRF data then establish look-up tables for router engineering rules and models the data. Algorithms are performed to adjust engineering constraints and create IP router logical capacity and IP router VRF management Reports.
Responsibilities and Accomplishments
Investigated OLAP technology and designed multidimensional database structures such as dimensions and cubes. I utilized the Java OLAP API from Oracle to successfully retrieve measures for given criteria from cubes. I wrote a simple framework that utilized Oracle's OLAP API to quickly and efficiently query data from cubes and retain it in a multidimensional bean. I also introduced the JSR 220 standard, Java Persistence API (JPA) to the group to fulfill RDBMS requirements.

Technologies, Libraries, Development tools and Platforms

• Oracle Olap 10g
• Hibernate 3.X using JPA
• Struts 1.2
• JSP
• JBoss, SunOS, Oracle 10g

Switch Demand and Capacity

January 2006 - March 2007
Client SBC Communications, St Louis MO
Description The Switch Demand Capacity(SDC) management consolidation effort will replace existing legacy systems in three regions (ACIMS (MW), LSDF/APB (SW), ISIS/LSDNC (W), and Genesis), with a common Single Suite application that will allow Network Design Engineers to track and plan Central Office switches, capacity and utilization. SDC provides a view of the current end office capacity and the forecasted demand of the wire center. Provides switch capacity monitoring tools for switch capacitators. Includes timing and sizing of switching capacity. This information is used to formulate end office relief plans, track relief plans and analyze the utilization of an existing office.
Responsibilities and Accomplishments Solutions Architect Lead that introduced Springframework to be utilized within the team for the first time. Utilized Spring's IoC capabilities by integrating Hibernate, JSP, Spring MVC, AspectJ, DWR, Quartz, and other various libraries. Setup an architectural design and completed proof of concept solution to be mirrored throughout the application by other developers as a model. Fulfilled business requirements of interfacing with older systems limiting to older architectural approaches by using setting up Java quartz timers to extract, process data, and dynamically ftp data using output streams. Utilized newer architectural approaches whenever possible. Developed a Service Oriented Architecture model utilizing web services to interface with an external application to instantaneously transfer information giving live results. Researched and utilized both Axis and XFire to complete these tasks. Implemented software using cutting edge technology such as DWR's comet (reverse Ajax) or server push techniques to broadcast quickly changing information to business clients.

Technologies, Libraries, Development tools and Platforms

• Springframework 1.2
• Hibernate 3.0
• JSP and Tiles
• AOP using AspectJ
• Java cron scheduler using Quartz
• Webservices using Axis and XFire
• Ajax using DWR
• Apache Tomcat, Linux (dev), SunOS (test and prod), Oracle 9i

Single Point Login (SPL)

January 2005 - March 2006
Client SBC Communications, St Louis MO
Description Single Point Login application is written to address a company wide initiative to meet SBC security standards. The standards included things such as password strength checking, password expiration, secure login, encrypted storage, and validation of users.
Responsibilities and Accomplishments Application architecture lead that thoroughly investigated solutions to create a single point login service for web based applications. Applications such as NWCF, SDC, MTFS, VRF, PESOS, Nortel SSOP, Siemens SSOP, Lucent SSOP and others were modified to utilize a SPL interfacing with both Java and Coldfusion technology. Formulated a design that permitted an SSL encrypted connections, changing of passwords, resetting of passwords, validating passwords, accessing SBC user information from the SBC Phone Database, and created an application list that shows the available applications users have access to within the organization. Evaluated, tested, and adopted open source framework solution Central Authentication Service (CAS) to perform core login services. Modified Spring Web Flow definitions within the CAS framework to allow for required functionality beyond the simplistic login procedure.

Technologies, Libraries, Development tools and Platforms

• Springframework 1.2
• Spring Web Flow 1.0
• Central Authentication Service CAS 3.0
• Hibernate 3.0
• JSP and Tiles
• SOA architecture with Axis and XFire
• SSL
• Apache Tomcat, SunOS (test and prod), Oracle 9i

Network Wire Center Forecasting

June 2004 - January 2005
Client SBC Communications, St Louis MO
Description Network Wire Center Forecasting (NWCF) is an application that allows for Network Capacity Managers to view and distribute wire center forecasts that drive the decisions for timing and sizing switch equipment jobs. NWCF is an interface between an internal wire line tool(SWIFTS) and capacity management applications (ACIMS (MW), LSDF/APB (SW), ISIS/LSDNC (W)). NWCF tracks wire center forecasts to a single switch and processes billing actuals with SWITCH actuals to provide accurate information.
Responsibilities
Utilized the Struts application framework along with Apache Velocity and Apache OJB to formulate an MVC architectural approach. Investigated and pursued other architectural design options to benefit the development process such as an Aspect Oriented approach. Determined that AspectJ would be beneficial to perform logging, error handling, authentication, and authorization. I compared and contrasted several view component options such as JSP, Apache Velocity, Freemarker and others, presented differences, informed developers, and made a conclusive decision. Worked with clients to complete implementation as specified in the business requirements.

Technologies, Libraries, Development tools and Platforms

• Apache Struts 1.2
• Apache Object Relational Bridge (OJB) 1.0
• Apache Velocity 1.4
• AspectJ 1.2
• Sitemesh 2.3
• Oracle 9i, Eclipse 3.0, Apache Tomcat 5.0, SunOS 5.8