Designed and maintained a Business Objects business intelligence suite to support billing, insurance claims, and collections for the medical industry. Features included: - Over 250 basic reports (OLTP, OLAP, Dashboards, Scorecards) - Over 150 custom reports - Multiple Ad Hoc reporting universes - Multi-tiered data security - Mobile device supportInstalled and configured all new customer BI implementations, as well as weekly deployments and updates. Added… Show more Designed and maintained a Business Objects business intelligence suite to support billing, insurance claims, and collections for the medical industry. Features included: - Over 250 basic reports (OLTP, OLAP, Dashboards, Scorecards) - Over 150 custom reports - Multiple Ad Hoc reporting universes - Multi-tiered data security - Mobile device supportInstalled and configured all new customer BI implementations, as well as weekly deployments and updates. Added automation tools and quality control practices to both procedures.Assisted in site-wide upgrade from BOXI-3 to BOXI-4. This included: - Migration of active Desktop Intelligence reports (Deski) to Web Intelligence (Webi) - Archiving inactive reports as PDFs - Remapping users and groups to match the new hierarchical security model - Reformatting dashboards and scorecards to take advantage of 4.0 display features - Maintaining parallel updates on both servers until all customers signed off on the 4.0 implementation Researched and implemented Business Objects Translation Manager across all reports and universes, allowing the display of industry-specific terminology to each customer.Designed sample data and materials for user conferences and customer demos.Trained and mentored new employees. Managed multiple BI improvement projects. Show less

Helped design and maintain a series of enterprise-level business intelligence products based on the Business Objects Enterprise suite: BI Portal, DecisionCenter, Financial Planning and Analysis (FPA), Executive Scorecard (XS).Designed an ITIL-compliant Data Warehouse schema containing over 50 entities in 7 modules.Wrote and maintained Extract, Transform, and Load (ETL) workflows in BO Data Services Designer and HP Connect-It. Helped design and implement a tool for… Show more Helped design and maintain a series of enterprise-level business intelligence products based on the Business Objects Enterprise suite: BI Portal, DecisionCenter, Financial Planning and Analysis (FPA), Executive Scorecard (XS).Designed an ITIL-compliant Data Warehouse schema containing over 50 entities in 7 modules.Wrote and maintained Extract, Transform, and Load (ETL) workflows in BO Data Services Designer and HP Connect-It. Helped design and implement a tool for automated creation of ETL workflows via XML templates.Performed data evidence on how to consolidate information from multiple previously-unaligned HP products: Service Manager, Asset Manager, Project and Portfolio Manager, Business Service Management, uCMDB, Server Automation.Assisted in the development of the Universal Data Model (UDM), a UML model that will provide standards for program classes and database entities across the entire HP enterprise software suite.Created a multi-tiered presentation layer, including database views and stored procedures, Business Objects universes, WebIntelligence reports, and Xcelsius dashboards.Designed a generic data source input using Microsoft Excel for demo purposes. This was recently integrated into the released product as a universal input for unsupported source systems.Performed and supported demos for several high-profile customers.Helped design and implement automated testing, using SQL scripts to check ETL integrity. Show less

Performed unit testing on Peregrine’s client-server application (ServiceCenter) for two major releases.

Created, edited, and upgraded Crystal Reports for the Nevada Department of Energy project.Designed and optimized SQL Server stored procedures for report queries.

Sole programmer responsible for creating Peregrine’s reporting tools using third-party APIs. These include ReportCenter (a Delphi application utilizing Crystal Reports Professional for traditional client-server reports) and the Insight product line (utilizing Cognos Impromptu and PowerPlay software for OLAP and web-based reporting). These programs functioned in multiple languages and were integrated with a majority of Peregrine’s product lines. Designed and maintained all sample… Show more Sole programmer responsible for creating Peregrine’s reporting tools using third-party APIs. These include ReportCenter (a Delphi application utilizing Crystal Reports Professional for traditional client-server reports) and the Insight product line (utilizing Cognos Impromptu and PowerPlay software for OLAP and web-based reporting). These programs functioned in multiple languages and were integrated with a majority of Peregrine’s product lines. Designed and maintained all sample reports shipped with each product (50 to 100 per implementation). Assisted customers in creating custom reports. Maintained the Access Code Generator for Peregrine’s primary product: ServiceCenter. Implemented a hardware-based security scheme which prevented illegal distribution of product activation codes.Designed a training curriculum in creating and optimizing custom reports for internal personnel and partners.Authored articles based on knowledge gathered from various sources (email lists, documentation addendums, Lotus Notes, open customer incidents). Edited knowledge articles submitted by developers across multiple product lines.Assisted in designing the web interface for submitting knowledge articles (Get.Answers!).Designed utilities for use by the Knowledge Team, including an organizational chart editor and several tools designed for importing data from alternate formats into Knowlix. Show less

Developed processes for converting and refining knowledge from external sources (ServiceWare, customer data) into MGI’s Knowledge Cube format.Designed an installation program, reporting module, and administrative tools for MGI’s Knowledge Kiosk project.Spearheaded and managed an internship-for-course-credit partnership with Chubb Institute in Molloy’s QA department.