ETL Database Engineer @ Data warehouse ETL expert supporting enterprise analytic's team for Slacker's expert-programmed stations and streamed music experience. From May 2013 to Present (2 years 8 months) Greater San Diego AreaOracle Database Administrator @ SPAWAR Systems Center Pacific Oracle DBA, integration lead and system analyst on Data Center Consolidation effort
• Support Oracle systems in SPAWAR System Center Pacific Data Center; Perform Oracle upgrades
• Perform integration testing on Oracle based systems (Linux/Windows) that has been migrated into VM environment. Check into Oracle issues; work with customers to resolve concerns
• Perform system engineering and analysis determining the migration path and requirements to transition sites into an Navy Enterprise Data Center or commercial data center as appropriate for the product
• Review analysis and recommendations with system owners in order to refine requirements and get buy-in from stake holders and program office From September 2012 to May 2013 (9 months) Greater San Diego AreaLead Software/Database Engineer @ Lead 3 major product releases with an Agile team.
• Agile project lead [Iteration delivery schedule, estimates]
• Acted as Release Coordinator and Iteration Lead
• Developed User Stories with Product
• Lead EDI 4010 to 5010 Conversion (government mandate)
• Lead Mule ESB PDF Conversion for North Carolina Medicaid
• Lead EDI 4010/5010 835 Processor using Mule ESB and Altova (reduced load time by 75% and eliminates OPS manual workarounds)
keywords: EDI, Mule ESB, Java, Eclipse, Hudson, Hibernate, SVN, JIRA, Wiki, Altova, PL/SQL, SQL, data design, Agile, Scrum From December 2011 to August 2012 (9 months) Database Administrator (Oracle) @ • Performed RAC 10 to 11g upgrade ~ Sun Solaris
• Performed 10 to 11g upgrade Linux on VM
• Managed database builds in support of Agile process
• Collaborated with product and development on new features
• Considered areas impacted by changes [processes, applications, reports, notifications].
• Considered operational impact of designs
• Handled daily operational database issues to support SLAs
• Troubleshot production problems, identified quick fixes, created workarounds, reported issues to CCB/PMB
• Created Oracle data warehouse product and reporting system using LogiXml’s ad-hoc functionality
• Tuned SQL and Oracle performance turning
• Routine operational tasks turned over to Operations/IT
keywords: Oracle 11g, Oracle 10g, Linux, Toad, Data Architect, Data Warehouse, ETL, PL/SQL, Performance Tuning, Builds, SVN, Production Support, LogiXML, Ad-hoc Reporting, Agile, Scrum, JIRA, Wiki, Cron jobs, User Stories, Shell Scripts, Bridgegate From January 2009 to December 2011 (3 years) Database Application Developer PA III @ UCSD (School of Medicine Dean’s Office) La Jolla, CA Sept 2007 – Jan 2009
• Worked with business users and stakeholders to define product
• Defined MySQL Schema for Non-salaried/Voluntary Clinical Faculty Appointments (JSP, Ajax, J2EE Application)
• Implemented tracking, routing and approval system
• Database migration from existing Paradox system to MySQL
Keywords: MySQL, Java, Ajax, JSP, Javascript, Data Migration, Data Design, Application Design, UI Design, Abobe Flex, Linux, Tomcat, Approvals/Workflows From September 2007 to January 2009 (1 year 5 months) Programmer/Analyst IV @ Coeus Team Lead (PA IV)
Lead team of four developers responsible for UCSD’s integrated proposal and grant system tracking $2.8B in proposal efforts and $728M in awards for FY 2005. Coordinated cross departmental analysis of requirements. Optimized 54 PL/SQL procedures in Oracle 9i
• Identified database locks and performance issues
• ETL to data warehouse
• Schema analysis for migration from customized Coues 3.6+ to Coeus 4.0
• Supported of Ledger Transaction Sampling, financial transaction risk assessment workflow, jLink applications, Data Warehouse, Reports
keywords: Java, Swing, PowerBuilder, Oracle 9i, Sybase, ETL, Data Warehouse, Performance, STAR Schema, PL/SQL, SQL, Coeus, COA, Financial, Budget, Javascript, HTML, XML, Web Services
Infrastructure Team (PA III)
Worked with lead Java infrastructure architect on implementing core Java framework utilized by ACT which serves as the centralized computing department for the campus
• Business Object Framework
• Overdraft ~ worked with product and developed overdraft reporting and notification system ~ COA STAR schema
• Single Sign on Project (Shibboleth) ~ worked on SSO front end (Struts) and on integration issues between SSO process and jLink
keywords: Java, jLink, Eclipse, Financial Applications, JavaScript, Web Services, SSO, Shiboleth, XML, COA, MySQL, HTML, Component Libraries, Struts, JSP From July 2000 to February 2007 (6 years 8 months) Senior Java Programmer @ Worked with product, lead engineers, QA and database team to resolve issues and/or gain necessary understanding of problems.
• Bridgegate EDI ACH Acknowledgment
• Gentran MySQL Oracle Sequencing
• Enhanced BPM to be able to call SQL scripts
• Wrote BPM payment match workflow checks and notifications
keywords: BPM, Java, Hibernate, JBoss, Eclipse, Ant, SQL, Oracle 10g, GENTRAN, EDI, Bridgegate From 2007 to 2007 (less than a year) Software Engineer @ • Performed database conversion from NWSS mainframe system to Oracle (CINCPACFLT).
• Created DII COE compliant data store segment
• Designed and developed major NSOF message parsers for Status of Readiness and Training Systems (SORTS) in compliance with JCS and USMTF.
• Developed PL/SQL to handle the change event processing of USMTF messages
• Designed and developed PL/SQL package procedures that mapped new messaging structures onto the legacy database system tables
• Attended CNO to assist USMTF SORTSREPNV data set definition
• Gave customer site training at CINCLANTFLT
keywords: Java, Swing, PL/SQL, CGI, PRO-C, OCI, Oracle, GCCS-M, OSS, DII COE, CMM, System Engineering, C, Motif, USMTF, SORTS NWP, CNO, JCS, SPAWAR, HP-UX, Unix From 1992 to 2000 (8 years) Software Engineer @ From 1995 to 1995 (less than a year)
Bachelor of Science (BS), Applied Mathematics @ Florida Institute of Technology From 1988 to 1992 ~ Nolan Thomas ~ is skilled in: Mule ESB, Red Hat Linux, SSO, SQL, Oracle PL/SQL Development, JavaScript, Java Enterprise Edition, Eclipse, Toad, Erwin, Oracle RAC, MySQL, Hibernate, LogiXML, Data Warehousing