|Investment Trade Data Warehouse and Reporting||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.
|Business Intelligence and Analytics||Healthcare||Healthcare (SaaS) company's global Microsoft business intelligence, analytics, data warehouse and reporting systems in a 24x7 environment. Technologies included
SQL Server 2008 R2, Reporting Services, Report Builder and PowerPivot. Developed healthcare patient population reports, analytical reports and operational reports across a variety of data sources. Planned, tested and upgraded the business intelligence platform from SQL Server 2005 to SQL Server 2008 R2.
|SQL 2008 R2, SharePoint 2010 and PowerPivot Technical Adoption
Program (TAP)||Construction||Reporting project was featured in the Microsoft 2010 Launch Event and
published in a SQL Server 2008 R2 Case Study on Microsoft.com. Technologies included
SharePoint 2010, PerformancePoint, Reporting Services, Report Builder and PowerPivot.
|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
|Various Data Mining Projects||Science||Classification data mining projects according to CRISP DM Methodology using Weka.
Algorithms tested included but was not limited to Neural Networks, Decision Trees, Naive Bayes and Clustering with a variety
of parameters. These pojects required data mining data preparation tasks and selection of predictive variables.
|Business Intelligence Strategy and Roadmap||Insurance||Review of an insurance company’s business intelligence and reporting
business processes, information usage vision, goals, solution planning,
technical implementation and pilot project using SharePoint 2007, PeformancePoint,
Reporting Services and SQL Server 2008.
|Financial Data Warehouse and Reporting||Healthcare||Development of a financial data warehouse, dashboard and reporting
project using SharePoint 2007, PeformancePoint, Integration Services,
Reporting Services and SQL Server 2008.
|HR Data Warehouse and Reporting||Technology||Development of an HR data warehouse, dashboards and reporting project
using SharePoint 2007, PeformancePoint, Analysis Services, Integration
Services, Reporting Services and SQL Server 2008. Integration of disparate
HR applications across all 14 business units. Solution planning, design,
technical implementation, HR Data Mart, ETL and reporting.
|Public Bonds Performance Financial Reporting System||Government||Development of a Public Bonds financial reporting system using SharePoint
2007, Reporting Services and SQL Server 2005. This project involved complex
reporting of multiple bond programs funds allocation, budgeting, adjustments
and spending at various program levels.
|Financial Data Warehouse, Dashboards and Reporting||Professional Services||Development of a data warehouse, financial performance management
dashboards and reports from a Deltek Vision data source using SharePoint
2007, PeformancePoint, Integration Services, Reporting Services and SQL
|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.
|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.
|Financial Institution Global Reporting Analysis and Design||Financial||Financial institution global reporting solution analysis and design. Design
required timely data transfer across global data centers located in Europe,
Malaysia, North America and Australia. Reviewed centralized, decentralized, web service,
OLAP, and Amazon EC2 cloud options with a sharded data model.
|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,
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.
|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.
|USI Insurance||Insurance||Regional intranet web based marketing reporting applications to it
|USI Insurance||Insurance||Developed CSR Pro, a web based productivity reporting application
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,
|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
|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
|Web Based Retail Rack Analysis ||Retail||Development of a web based retail data analysis application utilizing
store rack planning and reporting with interfaces to the point-of-sale
|CSI Intranet and Web Based Project Management||Retail||The first CSI project entailed intranet development using Cold Fusion,
system, file manager, warehouse supply order application, online project
management, help desk, public and private calendars, security control
panel and department specific features.
|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.
|DFAS Navy Airforce Interface||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,
|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
|Housing Utilizaton Reporting System||Defense||Development of an IUA Compliant Housing Utilization Reporting System
using MS Access and VBA.
|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.
|WellCare||Insurance||WellCare LSA Statement of work, functional specification and prototype
for an ASP.NET 2.0 and SQL Server 2005 application.
|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.