Sr Principal Analyst, Database Resume
SUMMARY:
- Utilize experience and skills as an Information Systems Engineer assisting in supporting business operations and development who is familiar with various government agencies and spatially aware data.
- Expertise is in the Project Management/Development, MS Office, MS Project, Enterprise Architect, and Oracle Developer Senior Web/Database/BI Publisher Development arenas.
TECHNICAL SKILLS:
Desktop Publishing/Project Management Tools: Excel, MS Word, MS Access, MS Project, MS PowerPoint
Databases: Oracle Databases - versions 11g r2, 10g, 9.0.2.4, 9.0.2.0, 8.x, 7.x, 6.x, 5.1. MySQL, Access.
Application Servers: Oracle Weblogic 9, Oracle Weblogic 10, Oracle AS - ver. iAS 10222, iAS 9.0.x, 10g; IBM WebSphere - ver 5.0, 5.1; Sun; Tomcat
Operating Systems: Windows (XP, 7, 8, 10, NT, 2000, ME, 98, 95); UNIX (Linux - RedHat, SuSE; SunOS)
Languages: Java, JSP, Struts, Ant, C Shell, Bourne Shell, Korn Shell, JavaScript, HTML, PL/SQL, SQL, C, Ada, XML, XSL, CSS, XSLT, XSS, XPath
Development Tools: Oracle BI Publisher 11g, Oracle Spatial; Oracle Forms - v 10g, 9i, 6i, 5.x, 4.x, 3.0, 2.3; Oracle Reports - 10g, 9i, 6i, 2.5, ReportWriter; JDeveloper; Eclipse; WebSphere Application Studio; Oracle Discoverer 10g, 4.x
Quality Assurance: JUnit, JMeter, Confidential, Confidential, SVN, Dimensions, CMM
General: Data Modeling - Online Transaction Processing (OLTP), Data Warehouse (DW), Decision Support System (DSS); Online Analytical Processing (OLAP); Documentation, Project Management
PROFESSIONAL EXPERIENCE:
Sr Principal Analyst, Database
Confidential
Responsibilities:
- Designs, develops, codes, tests, and debugs complex new software products, or makes significant enhancements to existing software.
- Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.
- Resolves complex hardware/software compatibility and interface design considerations.
- Support new development work from design through implementation with regards to Oracle - this includes emergency work as well as planned.
- Perform Maintenance activities on the Oracle portion of our system, i.e.:
- Help support testing and development team issues with each development release - this includes performing advance queries for PL/SQL, JDBC, BI Publisher, Cognos
- Assist or implement advanced XSL/XSLT for BI Publisher Templates ensuring proper XPATH usage.
- Follow CMS guidelines for all database elevations and modeling
- Maintain database models using Erwin and enforce CMS standards when applying changes
- Create logical/physical data models using Erwin
- Work closely with the CMS DA Group and the CMS Central DBA Group
- Maintain all Database design documents
- Design, develop, code, and debug reports using Oracle BI Publisher
- Mentor and assist junior and new technical staff members
- Perform technical interviews for Oracle PL/SQL and BI Publisher
Database Engineer
Confidential
Responsibilities:
- Constructed UML model using Rational Software Architect
- Data Modeling using ErWin
- SOA Web Services XML Schema Design for Confidential
- Architected data model designs, using hierarchical as well as relational models for the Confidential Charting organization.
- Developed use cases for integration into IBM Rational Manual Tester
- Populated test data for integration testing
- Performed validation queries to validate test cases
- Gathered requirements through client meetings in order to design tables from scratch
Tools: used: Oracle 10g PL/SQL, Oracle OC4J 10g, Hibernate, Hibernate Spatial, Spring, Struts, Swing, TOAD, Solaris, Sybase 12.5, Confidential, Oracle Spatial, IBM Rational Software Architect, IBM
Chief Solutions Architect
Confidential
Responsibilities:
- Designed hierarchical structures for an Oracle Forms Based Confidential product for use by the U.S. Navy. Included use of partitions and materialized views. Subsystem was the OLAP portion of a DSS system.
- Scripted several PL/SQL utilities for the management of Oracle partitions, materialized views and hierarchical queries.
- Performed integration testing of PIV readers for barcode scanners
- Created event driven processing queues using Oracle Advanced Queueing
- Assist Accounting departments with backend processes and reports using QuickBooks, Excel, Access, PowerPoint, Word, MS Publisher
Tools: used: Oracle Streams, Oracle Advanced Queueing, Oracle Forms, Java Swing, Visio, Microsoft Project, TOAD, Windows, Confidential, Microsoft Office
Practice Manager
Confidential
Responsibilities:
- Developed a migration plan to convert from Microsoft SQLServer to Oracle to maintain spatially aware data
Tools: used: Oracle 10g, Microsoft SQLServer 2005, Autodesk
Consultant
Confidential, Reston, VA
Responsibilities:
- Tools used: Oracle Forms, Oracle ADF, Oracle Reports, Oracle Application Server, Oracle Warehouse Builder, Oracle Confidential, Red Hat Linux, Solaris, SubVersion, Confidential
- Maintain a healthy working relationship with clients by utilizing interpersonal skills.
- Gained a broad knowledge of government agencies.
- Controlled versions of software with Confidential.
- Implemented budget and finance systems.
- Provided knowledge transfer and technical advice on emerging technologies for universities, information data bank companies and government agencies.
- Developed numerous PL/SQL routines to implement OLTP and Batch processing using PL/SQL and DBMS JOB
Confidential
Responsibilities:
- Developed data warehouse summary table strategy for improved reporting performance for the Confidential PostalOne Application.
- Utilized JUnit to create test cases for J2EE applications.
- Managed deployment of Enterprise Applications by utilizing Ant.
- Developed the ability to manipulate and present financial data through the use of Java Server Pages and tag libraries.
- Coordinated training on the use of Oracle Reports and Oracle AS 10g for development staff at the Confidential .
- Development of Java Server Pages using Oracle Reports and Confidential UIX tag libraries for the Confidential PostalOne Application.
- Designed JSP templates using Struts for the Confidential
- Created Web Module archive, (war and ear), files utilizing Ant, JDeveloper and IBM WebSphere Application Studio Developer.
- Tested applications using JUnit and JMeter for the Confidential .
Confidential
Responsibilities:
- Designed reference and security data table structures for a metadata driven claims processing web application for the Confidential - Claims, Processing and Eligibility (CP&E) System. Utilized IC9, DX and CPT codes. Processed HL7 formatted records.
- Created a security system that allowed for lightweight database users to access the same connection pool with fine grain access to database rows.
- Provided instruction on use of Oracle Software Control Management and the UCM model for configuration management at the Confidential .
- Designed JSP templates using Struts for the Confidential
- Implemented administration maintenance modules for the Confidential CP&E System using Confidential UIX, HTML and JavaScript technologies.
Confidential
Responsibilities:
- Created data mart in a decision support system to allow for dynamic update of record format layouts for data processing at the Confidential (DOC) Confidential - Technology Management Office (TMO) Sample Control Input File (SCIF) unit. Programming specifications were originally maintained in a WordPerfect document.
- Developed configuration management policies for large teams of developers to work simultaneously utilizing the UCM model.
- Blueprinted security model for an ISO 11179 implementation of data elements.
- Provided instruction on use of Oracle Software Control Management and the UCM model for configuration management at the Census.
- Created HTML, JSP and JavaScript pages to implement an ISO 11179 Data Element Registry corporate repository. Integrated modules with Oracle Portal.
- Created JSP parameter screens and search screens utilizing Oracle JDeveloper
- Integrated emerging technologies in order to enhance an existing Oracle Forms 9i application
- Implemented a survey and questionnaire application utilizing Oracle Forms 6i WebForms for the DOC CENSUS Economic Metadata Repository.
- Implemented portals for the DOC CENSUS’s Corporate Metadata Repository (CMR) and Technology Management Office Sample Control Input File (TMO SCIF) Maintenance systems using Oracle Portal 3.0.9.
- Created Oracle Portlets using the Oracle Portal 3.0.9 Portal Development Toolkit (PDK).
- Designed Oracle Portal partner application security utilizing PL/SQL.
Systems Engineer
Confidential, Fairfax, VA
Responsibilities:
- Principal duties include analysis, design and coding, and documentation of software.
- Other duties include design and development of hardware solutions of application needs.
- Also assisted in the development of the Software Development Plan and the Capability Matrix Model for projects
- Supervised the design and development of security applications for a large distributed network using Unix utilities and Oracle's PL/SQL and Discoverer.
- Disseminated policy information for projects’ Software Development Plan and Capability Maturity Model (CMM) at Confidential Corporation (CSC) formerly Dyn Corp Information and Engineering Technology (Dyn Corp I&ET).
Tools: used: Sequent, Pyramid, MP-RAS, SCO-Unix, Oracle Forms, Oracle ReportWriter, SCCS
Systems Analyst
Confidential, Annadale, VA
Responsibilities:
- Responsibilities included debugging and testing and new Ada code for various subtasks of the Defense Telecommunications Service (DTS) System
- Other duties included the implementation of new and modified SQL*Forms, DCL command files, Ada and Pro*Ada code, development of deliverable documentation, and training new team members on system operations
- Training team members, requirements analysis, systems design
- Tools used: VAX, Oracle Forms, Oracle 6.0
Junior Engineer
Confidential
Responsibilities:
- Perform statistical analysis of operations to determine if plant could perform a graceful shutdown.
- Reported status every morning.
- Performed a feasibility study of the likely hood that a core meltdown could occur in the remaining nuclear plants.
- Received a scholarship from Confidential as a result of this work.
- Assisted in coordinating a reduction in force plan, due to mandates made by the regional Public Service Commission.
Tools: used: VAX, MathCad, 20/20 Spreadsheet, Fortran, RBase