We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

2.00/5 (Submit Your Rating)
Hire Now

skills

  • OS: Windows, Unix mostly HP
  • Databases: Oracle 8i,9i, 10G,Sybase, DML
  • Languages: PL/SQL,SQL,SQLPLUS, SQLLOADER DML,
  • C, Korn Shell, Perl
  • Development Tools: Toad,PL/SQL Developer, Erwin, Powerbuilder

Most recent experience - all jobs listed are contracts

Confidential

  • Primary project was maintaining the Millenium system for tracking and summarizing donations to Boston College
  • modified materialized views, performed performance
  • enhancements and made other modifications to stored
  • procedures, packages, and Oracle PL/SQL anonymous blocks
  • created new stored procedure.
  • created prototype full summaries recalculation that
  • cut time from over 20 hours to 4 1/2 by converting
  • nested pl/sql loops into sql group by's not in production
  • but tested results were 99 compatible with previous procedure
  • Second project was for BC's new 'Light the World' donation campaign
  • campaign 10 : the need was to take selected campaign 9 gifts
  • rows and modify them to campaign 10.
  • devised new campaign numbering and wrote a process
  • of pl/sql scripts and sqlplus scripts to move selected campaign
  • 9 gifts -> campaign 10A, all 10 gifts -> 10B. Modified existing
  • campaign summaries to merge all the 10A and 10B gifts into
  • campaign 10 summaries.
  • determined a need to display chains of related
  • gifts in order to 'fix' those containing mixed campaign
  • 10A and/or 10B/and/or 9

Confidential

  • wrote fast tree-traversal algorithm to find all chains
  • of related rows in the gifts table - there were 1.5M -
  • the Oracle connect by clause was too slow
  • wrote analysis programs, based on user criteria,
  • to find all 'bad' chains
  • wrote program to fix all 'bad' chains by analyzing the
  • rows in the 'bad' chain tables and updating the gifts

table

Confidential

  • Primary product CCR tracked medical services provided by or
  • through UMass Med School to Mass State Prison system.
  • Project was to extend the CCR application to the Federal Prison
  • facility at the old Fort Devens site by migrating existing DEVENS
  • data in a staging area schema to a schema identical to production CCR schema.
  • wrote script to create schema for DEVENS identical to production
  • CCR schema - used TOAD to generate 'CREATE' commands
  • for each required table from the production schema.
  • Ran script to create the schema.
  • migrated data from staging-area Oracle DEVENS schema to
  • schema created in previous step, using PL/SQL
  • anonymous blocks and SQLPLUS scripts with SQL commands
  • used a business analyst's detailed document which described
  • how to map the staging area tables into the production-structured
  • schema tables, and at times specified the actual data to use
  • created temporary reference tables to 'clean' staging-area data
  • based on errors detected in primary process

Confidential

  • Project for two contractors was to handle programming and support for primary
  • programming and support personnel who were learning new system.
  • Created and modified report programs in DML Data Merge Language
  • for Medical Manager
  • Handled part of support for Medical Manager

Confidential

  • Project was to complete the modification of the MIllenium system to
  • add special handling for spouses of primary donors.
  • completed this modification using PL/SQL stored procedures,
  • triggers, and PL/SQL packages
  • created a user-requested materialized view 'flattening' the
  • display of data related to children of all parent donors

Confidential

  • Project was to develop process to load Federal BINCS Business Identification
  • Number Cross-Reference System parts data into database for comparison/
  • modification of Raytheon's internal vendor information
  • extracted and cleaned data from the Federal file using Perl
  • and used sqlloader to load it into new schema
  • wrote process to compare Federal and Raytheon parts data
  • using a pl/sql unnamed block outputting their differences
  • created Pl/sql unnamed block to display all table/index extents
  • in Raytheon production schema

Confidential

  • Used PL/SQL packages, stored procedures, SQLLDR, associative
  • arrays, cursor loops, ref cursors
  • Used Toad and PL/SQL developer.
  • Modified/created korn-shell scripts that ran batch jobs as needed.
  • Interfaced with DBA's to request/modify database changes, and wrote data fix-up programs for them to run against production data, as needed by enhancements to the batch jobs.
  • Interfaced with users to refine/modify/enhance work requests, analyze results.
  • Used Source Safe Microsoft for version control, Test Director Mercury Software for project control.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship