Developed and Implemented an enterprise demand management application (PowerBI, Excel Automation, Access)

Developed a data warehouse solution for the Demand Management needs of Bauer performance sports. The multinational (Sweden, US, and Canada) solution includes:

· ETL services, Source to target mapping, data transformation (SSIS)

· An operational data-store (SQL-Server)

· Regional metric (answer) databases (MS-Access)

· Data analysis and decision support functionality

To achieve adequate control and to provide traceability throughout the lifecycle a structured tool-assisted approach was developed.Traceability is a quality initiative that ensures every requirement and functional or technical specification is adequately represented by a discreet test case and that each test, if, when executed, produces a defect. The defect is then traceable back to the test case as well as the original functional or technical specification or requirement. In order to achieve traceability it is important to control data input for requirements, specifications, test cases and defects and to enforce a numbering scheme to ‘relate’ these items to one another. It is through this numbered relationship that we can begin to explore for gaps in our testing coverage making sure that all requirements, and specifications are adequately tested.

Developer, Maxess (BODS) - Workstation based Investment support application (Market Monitor, Montage, Quote, News)

PL1 Developer, Stratus Fault Tolerent Database and ETL development

for my daughter, Danielle

Automated Yield Curve management (SSRM)

a DBMS for IBM and compatible mainframes.

Day1 and Day2 Allocations and Comparisons to Resource Timecard Billings

VB.Net application using Visual Studio

Scrum Tool for managing the daily conversation about Sprint tasks and stories

Sprint Planning & Management tool

Business Objectives, High level timeline, Backlog Construction and Planning Tool

to enable the creation of Project cost plans, enabling what-if capabilities for resource options

Tool to manage Issues, Risks, Change Requests, Defects, Lessons Learned, and Questions

A tool to manage the end-to-end requirements, specifications, use cases, test cases, defects and rework providing bi-directional traceability

Excel-Based (VBA) - Multi-Project Visualization Tool

Remote Shared Database Reference Table Editing Tool

SAP and Business reference data sources loaded into SQL-Server Operational Data Store (ODS). ETL process to organize the data into Reporting data sets. Distribution of reporting database. Excel-based supply & demand planning tool.

for technology research papers to support keyword search, indexing, and tracking

a Stratus / PC /Mainframe menu-driven trading system

Workstation based Investment support application (Market Monitor, Montage, Quote, News)

the student loan decisioning system known as Capstone, the replacement of the corporate web front end (Web-based student loan application), and the establishment of the electronic signature functionality for online web-based loan applications.

an automated software testing tool). Implemented governance methods for driving visibility and transparency of enterprise-wide activities for executive review and issue mitigation.

for the Demand Management needs of Bauer performance sports. The multinational (Sweden, US, and Canada) solution includes: ETL services, Source to target mapping, data transformation (SSIS) An operational data-store (SQL-Server) Regional metric (answer) databases (MS-Access) Data analysis and decision support functionality

Delivered the first iteration of the Enterprise UCA tool which focused on Call Center metrics. Data comparisons for insourced vs. outsourced staffing models, fixed asset calculations, facility costs, as well as what if and trend analysis.

Managed and delivered the installation of the Arcsight FISMA Solution Pack. Worked to establish the firms current state of compliance against NIST guidelines. Worked to develop the firms POAM – Plan of actions and milestones. Developed a process to identify and manage incidents before they significantly impacted compliance. (Data sourced from network, application and monitoring tools)

Prospect Marketing Database to provide a view of all prospects in the U.S. The completed goal houses information on prospects, scored for marketability and targeted for marketing campaigns. (Acxiom customer data management services and feeds, Teradata database repository, SAS based scoring models)

Big Data project to bring in unstructured data from Survey sources, Customer Advocacy sources and other high volume systems. (Hadoop/Hive, Files, Teradata database sources, HTML survey response files)

for Higher Education client

at Health Insurance Exchange

for major Investment Management Company.