Case Studies

Professional Services

Industry: Federal Government
Services: Jaggy's DBA team implemented database cluster in support of - a central government-wide collection system for federal agencies and recipients of federal awards under Section 1512 of the American Recovery and Reinvestment Act of 2009 (Recovery Act).

Industry: Federal Government
Project: Environmental Protection Agency (EPA)
Services: Jaggy's DBA team provided Oracle Database 11g Real Application Clusters (RAC) implementation with Automatic Storage Management (ASM).

Industry: Federal Government
Project: U.S. Department of Navy, Naval Facilities Engineering Command (NAVFAC)
Services: Oracle Application Server/Fusion Middleware Portal architecture and implementation
The Business Need: Customer operated many Public and Private sites, each managed by a separate team of Webmasters and developers, with different look and feel and color schemas. As part of NAVFAC's transformation initiative, these disparate sites needed to be consolidated.
The Solution: Jaggy's solution was to implement an Enterprise Information Portal based on Oracle Application Server platform. Designed layout of the site, built initial portal templates, style guides, and navigation taxonomies. Migrated all public and private sites to NAVFAC Portal.

Industry: Federal Government
Project: U.S. Department of Health and Human Services
Services: Provided high-availability Microsoft SQL Server implementation for a primary and a disaster recovery (warm failover) site in support of Health Insurance Oversight System (HIOS).

Industry: Federal Government
Project: U.S. General Services Administration (GSA)
Services: Provided system architecture, design, and development services in support of Real Estate Activity Locator (REAL) system for GSA's Public Building Office. REAL system is comprised of various components such as Activity Based Costing, Customer Contacts Database, Disposal, Report, Time Tracking, System Administration and Appraisals.

Consulting Services

Industry: Retail
Services: Jaggy' consulting practice provided Oracle Service Oriented Architecture (SOA) consulting services to address application consolidation requirements.

Industry: Manufacturing & Mining
Services: Jaggy' consulting practice provided Oracle Applications 11i (E-Business Suite) Latin American localization for modules - Financial, Manufacturing, Distribution, HRMS.

Industry: Manufacturing
Services: Jaggy' consulting practice provided Oracle E-Business Suite Human Resources (HRMS) - – implemented the following HRMS Modules in addition to the HR Core (Advanced Benefits, Self-Service – Employee Portal, Time and Labor, HR Intelligence, Learning Management, and Performance Management). Enabled HR integration with third-party vendor ADP Payroll back feed via Oracle Data Pump Data Mapper. Assisted with HRMS Advanced Benefits configuration (COBRA Life, beneficiaries, eligibility plans (Blue Cross) and profiles, enrollment requirements, rates and balances, and de-enrollment). Configured advanced benefits communications, letters, reporting groups and reports.

Industry: Transportation
Services: Jaggy' consulting practice provided Oracle E-Business services to modify Apps 11i standard Aging bucket reports to include collection information (customer contact info, invoice date, credits and adjustments. Designed, tested, implemented and supported programs for item master entry, inventory provision and reserves, automated COGS corrections and automated average cost updates by cost type.

Technology Services

Industry: Manufacturing
Services: Oracle Agile PLM implementation
The Business Need: Our client, world's leading manufacturer of narrow and mid-web printing and converting equipment needed a comprehensive end-to-end product lifecycle management (PLM) solution.
The Solution: Jaggy' technology services team implemented Oracle Agile PLM to evolve fragmented engineering and design processes into information-driven product value chains with global 360-degree visibility into product information, and real-time collaboration across the entire product network.

Industry: Education
Services: Oracle Business Intelligence Enterprise Edition (OBIEE) implementation
The Business Need: Our client, a school district needed to provide enterprise reporting capabilities using data from multiple information sources including Student Information System, ERP, State and Federal agencies.
The Solution: Jaggy' implemented Oracle Business Intelligence Enterprise Edition (OBIEE) Plus - developed metadata repository, business model layer, physical data model and Web Catalog objects per reporting requirements. Built interactive dashboards with drill-down capabilities using Oracle BI Answers. Installed and configured Oracle Hyperion Enterprise Performance Management.

Industry: Energy (Fortune 500)
Services: TIBCO Middleware Integration and EMC Symmetrix storage implementation
The Business Need: Our client, a Fortune 500 company required implementation of TIBCO middleware as an integration effort among heterogeneous platforms and applications.
The Solution: Jaggy architected and implemented TIBCO middleware (BusinessWorks, HAWLK, and TIBCO Designer). Migrated production Oracle databases to EMC Symmetrix storage system.

Managed Services

Industry: Retail
Services: Managed Oracle Applications (E-Business Suite) Services
The Business Need: Our client engages in the retail and sale of building materials to builders, contractors, architects, designers, and homeowners. The company offers bricks, natural/manufactured stone, pavers, outdoor grills and living products, and accessories, as well as masonry, stucco, and landscape products. It offers products through its retail showrooms in Southern California. In-house skills were limited with no dedicated DBA team.
The Solution: Managed services and comprehensive support of the retailer's Oracle Applications (E-Business Suite) instances. Maintain availability, security, and performance of clustered Oracle Apps 11i Production, Development, and UAT environments.

Industry: Education
Services: Managed services for a school district to include Oracle Database Administration, Oracle Fusion Middleware and Oracle Business Intelligence Operations and Maintenance (O&M)

Industry: Consumer Products
Services: Managed services for an Engineering and Consumer Products company to include multiple Oracle E-Business Suite instances. Maintain availability, apply product patches and security updates, cloning, custom XML Publisher reports.

Industry: Manufacturing
Services: Solaris OS administration managed services for an golf equipment manufacturing company to include availability, maintenance, file systems, directory services, and backups.