{"id":26,"date":"2014-01-06T00:39:24","date_gmt":"2014-01-06T00:39:24","guid":{"rendered":"http:\/\/test.holtfarleyconsulting.com\/?page_id=26"},"modified":"2019-04-25T15:05:54","modified_gmt":"2019-04-25T19:05:54","slug":"database-services","status":"publish","type":"page","link":"https:\/\/holtfarleyconsulting.com\/?page_id=26","title":{"rendered":"Database Services"},"content":{"rendered":"<h4>Key Skills<\/h4>\n<ul>\n<li>Database Logical and Physical Design<\/li>\n<li>Database Application Development<\/li>\n<li>Performance Tuning<\/li>\n<li>Database Administration<\/li>\n<li>Data Conversion and Integration<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>Successful Projects<\/h4>\n<h5 style=\"padding-left: 30px;\">Data Integration<\/h5>\n<p style=\"padding-left: 60px;\">Designed and developed various applications to synchronize data between operational systems (Oracle ERP database, SQL Server, EDI, flat file, Salesforce.com) using database gateways, cloud based dated integration tools (e.g., Dell Boomi), etc.<\/p>\n<h5 style=\"padding-left: 30px;\">Insurance Corporate Data Model<\/h5>\n<p style=\"padding-left: 60px;\">Developed corporate data model for Mortgage Insurance client.\u00a0 Model included over 350 business entities, supporting all aspects of policy management.\u00a0 Defined database standards (naming, sizing, etc.).<\/p>\n<h5 style=\"padding-left: 30px;\">Web Applications<\/h5>\n<p style=\"padding-left: 60px;\">Designed and developed a wide variety of database driven web-based applications using server page (PL\/SQL, Java) and servlet technologies.<\/p>\n<h5 style=\"padding-left: 30px;\">Data Conversion<\/h5>\n<p style=\"padding-left: 60px;\">Lead team migrating data from client&#8217;s legacy O\/36 (flat files) and SQL Server systems to new Oracle database.\u00a0 Conversion required complex data mapping, integration, and cleanup that ran more than 50 hours on multiple processors.\u00a0 Production startup went flawlessly, under a very tight time schedule.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Key Skills Database Logical and Physical Design Database Application Development Performance Tuning Database Administration Data Conversion and Integration &nbsp; Successful Projects Data Integration Designed and developed various applications to synchronize data between operational systems (Oracle ERP database, SQL Server, EDI, flat file, Salesforce.com) using database gateways, cloud based dated integration tools (e.g., Dell Boomi), etc.&hellip; <a href=\"https:\/\/holtfarleyconsulting.com\/?page_id=26\">Continue reading&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":20,"menu_order":15,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/26"}],"collection":[{"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=26"}],"version-history":[{"count":6,"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/26\/revisions"}],"predecessor-version":[{"id":108,"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/26\/revisions\/108"}],"up":[{"embeddable":true,"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/20"}],"wp:attachment":[{"href":"https:\/\/holtfarleyconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}