| | PROJECT | INDUSTRY | SCOPE |
 | Investment Trade Reporting Dashboard | Financial | Manhattan-based global investment trading firm OLAP reporting system
development involving 64-bit clustered, heavy load, near real-time capabilities.
Cubes designed for maximum performance, customized cube dimension attribute
level security through .NET stored procedures, multiple partitions with
incremental processing. Tasks include data mart design, Analysis Services
OLAP cube development, MDX, aggregations, perspectives, SSIS ETL, synchronization
and Proclarity reports and automated trade messaging programming. |
 | Teradata / Microsoft Retail Data Warehouse Reporting | Retail | Teradata / Microsoft multi-terabyte retail reporting system JAD sessions,
business requirements, roadmap, data warehouse design, OLTP and OLAP data
modeling using ERwin, estimation, ETL and reporting solution architecture
leveraging Teradata’s R6.1 database, Master Data Management MDM, Meta
Data Services MDS, load utilities (TPump, MultiLoad, FastLoad) and Query
Scheduler with Microsoft Analysis Services, Reporting Services and Integration
Services 2005. |
 | Retail Low Rack Pricing Analysis Reporting | Retail | Developed SQL Server 2005 code to accumulate and analyze multiple
vendor retail product pricing data for multiple client locations by multiple
vendors, brands and product categories for Pricing Analysts. |
 | Site Analysis and Geocoding | Retail | Site analysis data collection, analysis using correlation and regression
models with SPSS, mapping and geocoding with MapPoint. Additional code
included a web based zip code radius search referencing stored zip code
latitude and longitude. |
 | Item-Based Collaborative Filtering | Retail | Development of the data structure, data mining stored procedures
and code to implement an internal Harvard business analyst's Item-Based
Collaborative Filtering functionality, a function similar to Amazon.com
item recommender. The algorithms involved millions of statistical computations
on an Oracle server evaluating catalog product purchase combinations.
The end result of the project was a reference table and code to implement
recommended items based on the current item selections for the retail
ecommerce web site. |
 | Process Engineering Data Analytics | Supply Chain | Business process analysis, re-engineering AS-IS and TO-BE, value
stream engineering, data analysis, functional and technical requirements,
cost-benefit evaluation and business case for automating manual inspection
processes in a mobile device warehouse facility. |
 | Healthcare Dashboard and Reports | Healthcare | SharePoint MOSS dashboard with Dundas, PerformancePoint and Proclarity
data visualization controls. Project included associated detail reports
against both SQL Server 2005 OLTP and OLAP code data sources. |
 | Progress Energy | Energy | Progress Energy demand forecasting application statement of work
and functional specification leveraging ASP.NET 2.0, Crystal Reports and
Oracle 10g technologies. |
 | Business Process Analysis and Optimization | Consumer Goods | Collected, analyzed and recommended optimized business processes
for a mobile device company. |
 | Navy Region Knowledgebase Web Application | Defense | Design and development of a web based knowledge base and help desk
application for the Navy Northeast Region (Groton, New Brunswick, Newport,
Mitchel, Earle) using IIS 4.0, ASP, MS SQL Server, Javascript, Active-X,
Crystal Reports and T-SQL. Sole developer responsible for designing system
architecture, programming modules, documentation and testing. |
 | Business Process Data Analysis | Manufacturing | Collected, analyzed and reported upon used vehicle inspection process
variations and cost implications by vehicle manufacturer. |
 | Business Intelligence Roadmap and Prototype | Financial | Performed a business intelligence assessment and developed a migration
roadmap with prototype for an international research organization using
SharePoint MOSS and SQL Server Reporting Services 2005. |
 | USI Insurance | Insurance | Regional intranet web based marketing reporting applications to it
using Cold Fusion, Javascript and SQL. |
 | USI Insurance | Insurance | Developed CSR Pro, a web based productivity reporting application
using Cold Fusion, Javascript and SQL. Modules included dynamic web forms,
reports and a control panel. |
 | USI Insurance | Insurance | Created a web based business unit status and risk reporting application
for the CEO. The CEO Reporting Application was developed using Cold Fusion,
Javascript and SQL. |
 | Logistics Applications Dashboard and Reports | Supply Chain | Development of a distributed logistics and dashboard reporting
applications using numerous MS SQL Server 2005 databases and Analysis
Services cubes. Multiple data warehouse sources included integration
with IBM AS400 legacy systems. Tasks involved database design, stored
procedure development, ETL packages, OLAP Analysis Services performance
tuning and query optimization and reporting. |
 | Web Based Retail Reporting System | Retail | Development, implementation and maintenance of a new web based
retail analysis and audit reporting system containing over 50 reports
utilizing Microsoft SQL Server Reporting Services, linked Oracle and
MS SQL Server data sources, OLAP and OLTP data warehouses |
 | Geocoding Zip Code Radius Event Locator | Retail | Zip Code Event Locator functionality using ASP, SQL Server and
geocoding functions. Table design, zip code radius/distance function
referencing latitude and longitude, stored procedure coding and Mapquest
integration. |
 | DFAS Navy Airforce Interface Web Application | Defense | This multi-million dollar, heavy-load web application had over
14,000 users, replicated databases and load balanced web IIS servers.
Performed programming, performance tuning, optimization, database administration,
documentation and testing. Technology and processes used include Microsoft
DNA architecture, COM/DCOM, Encryption, ActivePDF, Perl, SQL Server
databases, ASP, Visual Basic, Javascript, MTS, RUP, UML, stored procedures,
triggers and DTS. |
 | Distributor Real-Time Data | Retail | ASP Web application for distributing real-time data web subscription
data downloads using ASP, SQL Server 2000, DTS packages with variables
call from a web form, XML and Flash charting. |
 | EFlorida | Government | Enterprise Florida statement of work, functional specification
and consulting for an enterprise web content management system with
Ektron and Pivotal MarketFirst integration. |
 | WellCare | Insurance | WellCare LSA Statement of work, functional specification and prototype
for an ASP.NET 2.0 and SQL Server 2005 application. |
 | Darden Restaurants | Hospitality | Darden Restaurants statement of work, functional specification,
prototypes and consulting for Red Lobster, Olive Garden, Smokey Bones,
Seasons 52 and Bahama Breeze ecommerce projects utilizing ASP.NET 2.0
and SQL Server 2005 with ValueLink, Bank of America and NBO systems
integration. |
 | Quandia - Department of Housing and Urban Development - Erie | Government | The first Quandia project involved development of a HUD forms processing
application using XML, MS Access, SQL, VBA, Visual Basic client-server
application for electronically processing local HUD application forms
to the national system. Tasks involved mapping, conversion and transferring
numerous proprietary application data fields to the destination formats
for electronic batch processing. |
 | Quandia - Department of Housing and Urban Development - Erie | Government | The second Quandia project was to build a web site and content management
application for the Erie Housing Authority. The site and application was
built using IIS, ASP, Javascript, MS Access, ADO and COM. A user friendly
WYSIWYG HTML editor was implemented enabling non-technical employees to
easily update the site on their own. |
 | CSI Intranet and Web Based Project Management | Retail | The first CSI project entailed intranet development using Cold Fusion,
Javascript, Oracle and SQL Server. Modules included a content management
system, file manager, warehouse supply order application, online project
management, help desk, public and private calendars, security control
panel and department specific features. |
 | Office Products Web Site | Retail | ASP.NET C# development of a office products web site. Tasks included
C# HTTP module URL Rewrite/Friendly URLs for search engine optimization,
XML data stores, Javascript, third party tool integration and Oracle ERP
system product catalog data mapping for product display pages. |
 | Navy MWR Web Site | Defense | Design and development of a 90+ page, Section 508 compliant, military
web site containing various forms and electronic resources using HTML,
Javascript, Flash and CSS. |
 | Naval Undersea Warfare Center Earned Value Management System | Defense | Project management and software development integrating a cost tracking
Oracle 7.32 RDBMS, an Omnis client/server financial application, MS Access
and MS Project schedules. This project involved additions to an existing
Oracle RDBMS, designing a new project database, creating new client/server
modules to automate the data exchange between applications and building
a web interface for distribution of reports using IIS 4.0, ASP, VB, VBA
and T-SQL. Responsibilities included leading requirements definition,
writing use cases, designing system architecture, programming modules
and testing. |
 | Navy File Manager Intranet Web Application | Defense | Design and development of a web based application for managing and
displaying military instructions documents built using ASP, Javascript,
MS SQL Server and COM. |
 | Orbital Payment Gateway | Retail | Ecommerce application programming for inventory and gift card functionality
using Java, XML, web services and the Orbital Payment Gateway API. |
 | Remote Data Replication | Retail | Development of a client/server application using VB, ADO, T-SQL and
DTS to remotely manager SQL Server replication. |
 | Web Based Retail Rack Analysis | Retail | Development of a web based retail data analysis application utilizing
Cold Fusion, Javascript and SQL Server. This application features drag-and-drop
store rack planning and reporting with interfaces to the point-of-sale
system. |
 | USA Rehab | Healthcare | Development of a medical billing integration application written
in MS Access and VBA. The application extracts medical billing data from
a Noble Direct/Betrieve 7.0 database and performs custom functions for
archiving, tracking and reporting patient order status. Responsible for
designing system architecture, programming modules, documentation and
testing. |
 | Patient Web Application | Healthcare | Medical client-server patient database application design using MS
SQL Server 7.0 back-end engine and MS Access front-end. Responsible for
designing system architecture, programming modules, documentation and
testing. |
 | Legacy System Data Conversion | Retail | EBCDIC to ASCII data conversion of binary COBOL ISAM files from a
legacy application utilizing Java, DTS and DOS batch scripts, application
interface programming and report development for a PeopleSoft implementation. |
 | Housing Utilizaton Reporting System | Defense | Development of an IUA Compliant Housing Utilization Reporting System
using MS Access and VBA. |
 | Section 508 Compliance DFAS Web Applications | Defense | Legal requirements research, code reviews, scope of work and work
plan estimates on Public Services web based applications for Section 508
compliance regulations. |
 | Naval Station Newport | Defense | Web development, programming and maintenance for intranet applications
and external department web sites using IIS 4.0, ASP, Javascript, Java
and T-SQL. Support legacy, MS Access and client-server applications. Provide
MS SQL Server, MS Exchange and Windows network administration support
for 600+ user community. |
 | Department of Defense DITSCAP Security Evaluation | Defense | Network, web site and database security penetration, vulnerability
analysis, testing, documentation and recommendations for DITSCAP Security
Evaluation. |
 | DOC - Client-Server Application | Construction | Development of an automated MS Access lead tracking application that
interfaces to MS Outlook using VBA. Additional projects for DOC included
programming the Storrow Drive FLASH presentation in ActionScript. |
 | Deltek CRM Implementation | Construction | Conversion from single user desktop applications to networked client-server
usage of a Deltek CRM database. Included database customizations and report
development using Sybase SQL Anywhere Enterprise, MS Access, VBA and Crystal
Reports. Additional tasks included, web site development, enewsletter
creation and marketing templates. |
 | SIR Media | Media | SQL Server database design and ASP.NET VB.NET web application development
for electronic press release distribution. Features include ecommerce
payment, search by form, saved searches, personal lists and distribution.
Framework utilizes Microsoft Application Building Blocks. |
 | Textron eSurvey | Financial | Development of an electronic marketing survey programming using Excel
and VBA |
 | North Safety | Construction | Development of an electronic distributor sales kit using PowerPoint,
Excel and VBA |
 | Office Products Investor Web Site | Retail | ASP.NET C# development of a global office product corporate investor
web site. Tasks included C# module coding, XML data stores, integration
with IRecruiter and Shareholder.com, Javascript and CSS. |
 | Data Technology Networks | Technology | Design and development of a Remote Data Services (RDS) VB application
that has free text, web query capabilities from client desktop applications. |
 | Outsource on Call | Construction | Design and development of a Pocket PC landscape inventory management
application that enabled contractors to inventory, request and update
rentals in the field using a PocketPC. Changes made in the field would
be replicated and synchronized with the main office databases. Technologies
used include HanDBase, Windows CE and eVB. This project also included
user guides in MS Word and Pocket PC Help. |