Principal Analyst/Architect, Database Resume

PROFESSIONAL EXPERIENCE

Principal Analyst/Architect, Database

Confidential

Responsibilities:

Support the Global Freight Management (GFM) program at Scott AFB as the Principal Analyst, Database (Principal Oracle Database Developer/Java Developer).
Responsible for designing, planning, implementing and administering databases, including security, access, and documentation.
Worked with UniData application developers to reverse engineer a UniData application server for migratation to Oracle 12c.
Developed a data model of approximately 30+ UniData files into over 150+ entities in Toad Data Model and ER/Win. Currently converting UniBasic code into PL/SQL packages and stored procedures which contains the business logic of the GFM program.
Creating complex PL/SQL to replace DataStage ETL as well to manage data being ingested from external sources, and extracting data from Oracle to flat files on server OS for re - syncing data with UniData application server.
Re-writing a number of reports from cron jobs and UniData into PL/SQL and Oracle Job Scheduler.

Confidential

Principal Analyst

Responsibilities:

Responsible for creating a learning and teaching environment for students in accordance with the educational objectives of Southwestern Illinois College (SWIC). Primarily teaching programming languages (C++, C#, Java, JavaScript, and jQuery) and database courses in the Information Systems department of the Business Division.
Teaching units of instruction to students in higher education programs, adult and continuing education courses, or economic development activities. Plan learning activities and use teaching methods designed for a variety of learning styles to help students achieve course outcomes.
Assist with maintaining a classroom/laboratory/shop environment emphasizing safety, good housekeeping, and equipment security. Use course text, outlines, syllabi, and other curriculum materials in accordance with college and department guidelines.
Participate in communications with the college, department, and team. Meet response deadlines as required. Participate in professional development and in-service activities.

Systems Development Specialist, Principal

Confidential

Responsibilities:

Under general supervision, devises solutions for solving basic customer problems using company or customer furnished computer systems and equipment or commercial off-the-shelf packages.
May work on equipment or software design, engineering evaluation or test, configuration management procedures, statistical analysis and modelling. Works with end users and may assist with training. Responsible for all aspects of the hardware and software systems elements.
Conduct detailed requirements and systems analysis, and define and documents detailed functional and systems specifications. Provide inputs for feasibility assessment, impact analysis and cost-benefit analysis.
Assist in the designing and coding of program logic based on overall systems design. Help develop and document test plans and test cases. Required and desired qualification in Java development, Oracle database, PL/SQL, JavaScript, WebMethods, BPM, WebLogic, BPEL, and SOA.

Web Developer

Confidential

Responsibilities:

Developer on a team within the AMC Tanker Airlift Control Center. Designed, built and maintained web application and database / data warehouse tools for data capture and analysis in support of the AMC Fuel Efficiency Office (or other offices as directed). Information is used by AMC senior leaders to develop and promote fuel-savings initiatives.
Utilizing C#, JavaScript, jQuery, HTML and MS SQL Server 2008.