We provide IT Staff Augmentation Services!

Sr Principal Analyst, Database Resume

2.00/5 (Submit Your Rating)

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

We'd love your feedback!