ÿþ<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>AnalyzeSoft - Achieving EXTRAORDINARY results through Analysis and Technology - San Diego, CA</title> <meta name="keywords" content="web services, application integration, data integration, business intelligence, risk management, integration architecture, roi, business case, analysis, workflow analysis, reengineering" /> <meta name="description" content="Analyze Software is a technology services company with a talented, enthusiastic group of people. Our primary goal is to guide our clients to leverage information technology in solving complex business and technical challenges across the business continuum." /> <link href="css/as_win.css" rel="stylesheet" type="text/css" /> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> <script language="JavaScript"> <!-- Hide this script from old browsers -- var imagenumber = 3 ; var randomnumber = Math.random() ; var rand1 = Math.round( (imagenumber-1) * randomnumber) + 1 ; images = new Array images[1] = "img/mainimg_h_1.jpg" images[2] = "img/mainimg_h_2.jpg" images[3] = "img/mainimg_h_3.jpg" var image = images[rand1] // -- End Hiding Here --> </script> </head> <body onload="MM_preloadImages('img/btn_why_f2.gif','img/btn_work_f2.gif','img/btn_bs_h_f2.gif','img/btn_products_h_f2.gif','img/btn_clients_h_f2.gif','img/btn_careers_h_f2.gif','img/btn_contact_h_f2.gif')"> <center> <table width="760" border="0" cellpadding="0" cellspacing="5"> <tr> <td width="180"><a href="default.htm"><img src="img/logo_home.gif" width="180" height="64" border=0/></a></td> <td width="520" nowrap="nowrap" valign="bottom"><a href="vision.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('vision','','img/btn_vision_f2.gif',1)"><img src="img/btn_vision.gif" alt="Our Vision" name="vision" width="170" height="62" border="0" id="vision" /></a><a href="whyus.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('why','','img/btn_why_f2.gif',1)"><img src="img/btn_why.gif" alt="Why Us" name="why" width="170" height="62" hspace="5" border="0" id="why" /></a><a href="bs_tech.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('work','','img/btn_work_f2.gif',1)"><img src="img/btn_work.gif" alt="Our Work" name="work" width="170" height="62" border="0" id="work" /></a></td> <td width="45" valign="bottom"><img src="img/rt_red.gif" width="45" height="7" /></td> </tr> <tr> <td bgcolor="#CCCCCC" class="leftnav_2" width="180" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td><table width="180" border="0" cellpadding="0" cellspacing="0"> <tr> <td valign="top"><img src="img/orange_light.gif" width="180" height="7" /><br /> <img src="img/tag_h.jpg" width="180" vspace="4"/> <a href="aboutus.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('aboutus','','img/btn_about_h_f2.gif',1)"><img src="img/btn_about_h.gif" alt="About Us" name="aboutus" width="180" vspace="2" border="0" id="aboutus" /><br/></a> <a href="bs.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('bs','','img/btn_bs_h_f2.gif',1)"><img src="img/btn_bs_h.gif" alt="Business Services" name="bs" width="180" vspace="3" border="0" id="bs" /></a> <a href="ds.htm"><img src="img/btn_ds_h_f3.gif" alt="Data Solutions" name="ds" width="180" vspace="3" border="0" id="ds" /></a> <a href="products.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('products','','img/btn_products_h_f2.gif',1)"><img src="img/btn_products_h.gif" alt="Products" name="products" width="180" vspace="3" border="0" id="products" /><br/></a> <a href="clients.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('clients','','img/btn_clients_h_f2.gif',1)"><img src="img/btn_clients_h.gif" alt="Our Clients" name="clients" width="180" vspace="3" border="0" id="clients" /><br /> <a href="careers.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('careers','','img/btn_careers_h_f2.gif',1)"><img src="img/btn_careers_h.gif" alt="Careers" name="careers" width="180" vspace="3" border="0" id="careers" /><br /> <a href="contact.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('contact','','img/btn_contact_h_f2.gif',1)"><img src="img/btn_contact_h.gif" alt="Contact Us" name="contact" width="180" vspace="3" border="0" id="contact" /></a></td> </tr> <tr> <td class="leftnav_h"></td> </tr> </table></td> </tr> </table><img src="img/Cert_part.gif" /></td> <td valign="top" align=left><img src="img/mainimg_technology.jpg" /> <table width="100%" border="0" cellspacing="2" cellpadding="0"> <tr> <td valign="top"><strong><br /> Data Solution Services</strong> <table class="dstbl"> <tr class="dstbl"> <td class="dshdrs">Databases</td> <td class="dshdrs">Business Intelligence </td> </tr> <tr> <td class="dstext"> <ul> <li>Advanced Database Administration</li> <li class="outside">Clustering and Highly Redundant Solutions</li> <li>Database Design and Modeling</li> <li>Optimization of Data Structures for VLDB</li> <li>Replication and Log Shipping</li> <li>Capacity Planning and Sizing</li> <li>Designing Optimized Queries on VLDB</li> </ul> </td> <td class="dstext"> <ul> <li>Designing and Deploying Data Gathering (ETL) Processes</li> <li>Defining FACTs and Dimensions</li> <li>Creating Business/Technical Metadata</li> <li>Defining and Tracking KPI s for BPM</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dshdrs">Network and Security </td> <td class="dshdrs">Disaster Recovery </td> </tr> <tr> <td class="dstext"> <ul> <li>Designing Networks (LAN/WAN)</li> <li>Configuring Firewalls and ACL s</li> <li>Designing VPN Solutions</li> <li>Designing Mail Server Solutions</li> <li>Implementing Anti-Virus Strategies</li> <li>Implementing Load Balancer Solutions</li> </ul> </td> <td class="dstext"> <ul> <li>Creating Disaster Recovery and Business Continuity Topologies</li> <li>Defining RTO s and RPO s SLA s</li> <li>Creating Backup and Recovery Solutions at Application and Database Layers</li> <li>Designing Test patterns for DR </li> </ul> </td> </tr> <tr class="dstbl"> <td class="dshdrs">Risk Mitigation </td> <td class="dshdrs">&nbsp;</td> </tr> <tr> <td class="dstext"> <ul> <li>Business Impact Assessment</li> <li>Data Classification</li> <li>Security Policies and Operational Procedures</li> <li>Security Assessment</li> <li>Compliance Assessment and Mitigation (SOX Compliance, GLBA Vendor Management, etc)</li> </ul> </td> <td>&nbsp;</td> </tr> </table> <br /> <strong>Data Solutions Expertise</strong> <table class="dstbl"> <tr class="dstbl"> <td class="dshdrs">Databases</td> <td class="dshdrs">Business Intelligence </td> </tr> <tr> <td class="dstext"> <ul> <li>Microsoft SQL Server</li> <li>Oracle</li> <li>Informix</li> </ul> </td> <td class="dstext"> <ul> <li>MicroStrategy</li> <li>Business Objects</li> <li>Microsoft OLAP</li> <li>SQL Server Reporting Services</li> <li>SQL Server Analysis Services</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dshdrs">ETL</td> <td class="dshdrs">Networking / OS </td> </tr> <tr> <td class="dstext"> <ul> <li>Data Integrator</li> <li>Ascential</li> <li>Microsoft DTS</li> <li>CA Advantage Data Transformer</li> <li>SQL Server Integration Services</li> </ul> </td> <td class="dstext"> <ul> <li>Firewalls(Cisco, ISA) </li> <li>F5 Load balancers</li> <li>Microsoft Exchange</li> <li>Microsoft Clustering</li> <li>Windows 2003</li> <li>Solaris/Unix</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dshdrs">Disaster Recovery </td> <td class="dshdrs">&nbsp;</td> </tr> <tr> <td class="dstext"> <ul> <li>F5 3DNS</li> <li>EMC SRDF</li> <li>DoubleTake</li> <li>Microsoft SQL Replication</li> <li>Microsoft Log Shipping</li> </ul> </td> <td>&nbsp;</td> </tr> </table> <br /> <strong>Data Solutions Case Studies </strong> <table class="dstbl"> <tr class="dstbl"> <td class="dslogos"><img src="img/logo_fis.jpg" width="130" height="58" /></td> <td class="dstext"><strong>Role:</strong> <ul> <li>AnalyzeSoft Data Solutions was engaged in designing a database from the ground up for FIME (Fidelity Integrated Metrics Engine) which brings data together from diverse business functions (Flood, Appraisal, Title, Credit) providing a central repository of transactional data</li> <li>AnalyzeSoft Data Solutions designed a database model comprised of complex hierarchies to allow segregation of different business Units data as well as global views of aggregated data</li> <li>AnalyzeSoft Data Solutions implemented ETL processes to bring data together from different business units for aggregation and loading into Enterprise Data Warehouse, this was implemented using Computer Associates ADT ETL tool along with Microsoft DTS</li> <li>Ascential Quality Stage was prototyped for creating hierarchies and cleansing the data before being ported over to Enterprise Data Repository</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dslogos"><img src="img/logo_fa.jpg" width="130" height="58" /></td> <td class="dstext"> <strong>Role:</strong> <ul> <li>Implemented, tuned and maintained more than 30 OLTP 24X7 SQL Server database servers containing more than 300 databases which served First American's e-commerce services</li> <li>Assessed and optimized database performance including optimization of stored procedures, indexes, table structures  with performance improvements over 300% in some cases</li> <li>Designed and implemented database disaster recovery procedures for business continuity</li> <li>Built strategic business intelligence / data warehousing solution using Microstrategy</li> <li>Involved in establishing security for First American s Internet facing e-commerce initiatives, including maintaining TruSecure certification</li> <li>Established performance counters and metrics for real-time monitoring, strategic forecasting and capacity planning</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dslogos"><img src="img/logo_jpm.jpg" width="130" height="25" /></td> <td class="dstext"> <strong>Role:</strong> <ul> <li>AnalyzeSoft Data Solutions maintains databases at JP MORGAN Chase (formerly Advanta) for their business critical applications (DRI, WINCOINS, and IMAGING etc.)</li> <li>AnalyzeSoft Data Solutions optimized databases and consolidated five SQL Servers into two highly available 24X7 SQL Servers</li> <li>AnalyzeSoft Data Solutions was also involved in the re-architecture of the network from Novell to Windows 2000 Active Directory</li> <li>Implemented disaster recovery of critical databases at an offsite SunGard facility</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dslogos"><img src="img/logo_centex.jpg" width="130" height="37" /></td> <td class="dstext"> <strong>Role:</strong> <ul> <li>AnalyzeSoft Data Solutions was engaged as an IT partner to accomplish multiple high visibility projects</li> <li>Seamlessly converted SQL 7.0 to SQL 2000 with minimal downtime in a highly complicated transactional replicated environment</li> <li>Defined RTO s and RPO s for CHEC s critical applications for disaster recovery</li> <li>Implemented near real-time disaster recovery at an offsite SBC facility using DataMirror, MIMIX for AS400, Doubletake for databases and F5 s BIGIP and 3DNS for traffic shaping</li> <li>AnalyzeSoft Data Solutions was responsible for moving CHEC s data centers to a new facility with minimal downtime for their key systems (AS400, networking equipment, database and application servers)</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dslogos"><img src="img/logo_goalf.jpg" width="130" height="87" /></td> <td class="dstext"> <strong>Role:</strong> <ul> <li>AnalyzeSoft Data Solutions was retained by Goal Financial, one of the leading Student Loan Consolidation Companies, to design and implement next generation data warehousing and business intelligence solution</li> <li>Streamlined receiving servicing files from three different servicers</li> <li>Designed and created an end-to-end ETL process using Microsoft DTS</li> <li>Designed FACT s and DIMENSIONS and created MS OLAP cubes</li> <li>Designed the framework for delivering reports using Microsoft Sharepoint Portal Server, Microsoft Excel and SQL Reporting Services</li> </ul> </td> </tr> <tr class="dstbl"> <td class="dslogos"><img src="img/logo_prof.jpg" width="130" height="25" /></td> <td class="dstext"> <strong>Role:</strong> <ul> <li>AnalyzeSoft Data Solutions was retained by one of the nation s fastest growing perishable goods e-commerce vendors for designing their 24X7 database cluster server which handles more than 15K orders per hour at peak</li> <li>Involved in optimizing and tuning their 30 GB OLTP database for their e-commerce and B2B web site</li> <li>Designed the cluster architecture for Proflowers highly available SQL Server using Microsoft Clustering in an ACTIVE/ACTIVE setup along with IBM FAST storage</li> <li>Implemented log shipping as a solution for read-only databases for back-end processing for shipment and fulfillment services, thereby reducing database contention</li> </ul> </td> </tr> </table> </td> </tr> </table></td> <td>&nbsp;</td> </tr> <tr align="center" valign="middle"> <td height="7" bgcolor="#FFCC99"><img src="img/shim.gif" width="180" height="7" /></td> <td height="7" bgcolor="#FFCC99"><img src="img/shim.gif" width="180" height="7" /></td> <td height="7"><img src="img/rt_red.gif" width="45" height="7" /></td> </tr> <tr align="center" valign="middle"> <td height="20" colspan="3">&copy;2008 AnalyzeSoft. All rights reserved. </td> </tr> </table> </center> </body> <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript"> _uacct = "UA-1450068-1"; urchinTracker(); </script> </html>