{"id":31,"date":"2019-02-25T03:44:08","date_gmt":"2019-02-25T03:44:08","guid":{"rendered":"http:\/\/www.phredd.net\/?page_id=31"},"modified":"2019-03-18T14:50:38","modified_gmt":"2019-03-18T20:50:38","slug":"work-experience","status":"publish","type":"page","link":"http:\/\/www.phredd.net\/index.php\/work-experience\/","title":{"rendered":"Work Experience &#8211; Athene USA"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>7700 Mills Civic Parkway<br>West Des Moines, IA 50266<\/strong> <br><strong>Phone: (515) 243-3367\ufeff<\/strong> <\/h2>\n\n\n\n<p><strong>Lead Application Developer \/ Asset Owner<\/strong><\/p>\n\n\n\n<p><strong>February 2008 to present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/strong><br><\/p>\n\n\n\n<ul><li>Learned Oracle Policy Admin System &#8211; In-house support<ul><li>Built on-call procedures around the cycle process (monitoring and trouble-shooting)<\/li><li>Deep dive into process to create trouble-shooting recovery procedures.<\/li><li>Further research into performance enhancement \u2013 memory management, CPU monitoring.&nbsp;&nbsp; Find bottlenecks in the process.<\/li><li>Provide recommendation on hardware requirements as system load increased. <\/li><li>3<sup>rd<\/sup> tier contact for all overnight batch processes.<\/li><li>Developed several Windows batch routines for moving data for cycle.<\/li><li>Wrote Java based reporting on business and system errors for the users.<\/li><\/ul><\/li><li>ETL Process \u2013Java<ul><li>First in-house developer to learn contractor\u2019s (ObjectEdge) Java implementation of ETL (ETL-Lite).&nbsp;&nbsp; Uses hibernate and Spring.<\/li><li>Wrote complex stored procedures (Oracle SQL) for data retrieval.<\/li><li>Finished work on extract to pull scanned images for printing from the document management system.<\/li><li>Finished work on batch rate loads from an external system.<\/li><li>Trained other developers on this application.<\/li><\/ul><\/li><li>ETL Process \u2013 Informatica<ul><li>Converted several Java ETL applications to Informatica.<\/li><li>Mentored junior developers on ETL design.<\/li><li>Completed performance improvements or made recommendations where needed.<\/li><li>Wrote a proof of concept web service in Informatica.<\/li><li>Wrote bash shell script to update properties file (current date for extracts).&nbsp; Now used by other teams.<\/li><\/ul><\/li><\/ul>\n\n\n\n<ul><li>Web-based Java Support systems<ul><li>Wrote a web-based rate loading system for the policy admin system<ul><li>Java Server Faces, Hibernate, Spring based.<\/li><li>Hand written JavaScript and some jQuery.&nbsp;&nbsp; Some scripts modified from online libraries.&nbsp; AJAX methods used to update screens.<\/li><li>Two-step approval process written into the application for production loads.<\/li><li>Designed from user input.<\/li><\/ul><\/li><li>Created a cycle monitoring tool for policy admin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <ul><li>Tracks progress of the batch cycle<\/li><li>Web-based Java Server Faces, Hibernate, Spring<\/li><li>Prime Faces used as the UI framework<\/li><li>Screens auto-update using AJAX.<\/li><\/ul><\/li><li>Took over maintenance of a policy transfer management tool.<ul><li>Java Server Faces, Hibernate, Spring based.<\/li><li>Integration the policy admin and workflow system through SOAP web services<\/li><li>Updated process to include UI entry checks and new business processes.<\/li><li>Improved stability of the system.<\/li><\/ul><\/li><\/ul><\/li><li>Technical lead on moving the policy admin system and supporting apps to a new data center.<\/li><li>Technical lead on converting batch processes from an old mainframe job scheduler to a web-based job scheduler.&nbsp; First team to accomplish this.<\/li><li>Mentoring for other team members <ul><li>Go to person for anything SQL query related<\/li><li>Understanding where the policy admin system fits in the enterprise and how it works with other systems (web service calls, batch extracts, etc.)<\/li><li>Sent to India to train off-shore developers on cycle and the ETL portion of the policy admin system.<\/li><li>Partner with non-technical management on process improvement.<\/li><\/ul><\/li><li>Currently code a new, updated rate management system.<\/li><li>Providing technical insights for a major system conversion.<\/li><\/ul>\n\n\n\n<ul><li><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>7700 Mills Civic ParkwayWest Des Moines, IA 50266 Phone: (515) 243-3367\ufeff Lead Application Developer \/ Asset Owner February 2008 to present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Learned Oracle Policy Admin System &#8211; In-house support Built on-call procedures around the cycle process (monitoring and trouble-shooting) Deep dive into process to create trouble-shooting recovery procedures. Further research into performance enhancement \u2013 memory [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-full-width.php","meta":{"ngg_post_thumbnail":0,"_mc_calendar":[],"footnotes":""},"_links":{"self":[{"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/pages\/31"}],"collection":[{"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":10,"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/pages\/31\/revisions"}],"predecessor-version":[{"id":124,"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/pages\/31\/revisions\/124"}],"wp:attachment":[{"href":"http:\/\/www.phredd.net\/index.php\/wp-json\/wp\/v2\/media?parent=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}